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
] 
Blog
Search
Help
Members
Register
Login
Home
