Home » Applications » Oracle Fusion Apps & E-Business Suite » validating against APPS and set FND_GLOBAL.EMPLOYEE_ID
validating against APPS and set FND_GLOBAL.EMPLOYEE_ID [message #255363] Tue, 31 July 2007 09:26
sandhyaa
Messages: 79
Registered: February 2007
Member
Dear All,
I know we can validate a user against APPS using
select fnd_web_sec.validate_login(<userName>,<password>) from dual ;

After this how do I set the FND_GLOBAL.EMPLOYEE_ID, so that I can execute a query like:

SELECT * FROM vwMyView WHERE PERSON_ID= FND_GLOBAL.EMPLOYEE_ID

To summarize,
1) I need to build a web application using ASP, validate username and password using fnd_web_sec.validate_login

2) If validated SET FND_GLOBAL.EMPLOYEE_ID & execute the query
SELECT * FROM vwMyView WHERE PERSON_ID= FND_GLOBAL.EMPLOYEE_ID

Can this be accomplished?

Please help.

Thanks
Sandi
Previous Topic: AP Distribution Set API
Next Topic: Foreign Currency SOB setup
Goto Forum:
  


Current Time: Sat Dec 03 07:44:14 CST 2016

Total time taken to generate the page: 0.16004 seconds