84: BEGIN
85:
86: /* func_id, userid, resp_id, and func_id will indicate which func we want */
87:
88: user_id := to_number(fnd_profile.value('USER_ID'));
89: resp_id := to_number(fnd_profile.value('RESP_ID'));
90: resp_appl_id := to_number(fnd_profile.value('RESP_APPL_ID'));
91: sec_grp_id := to_number(fnd_profile.value('SECURITY_GROUP_ID'));
92:
85:
86: /* func_id, userid, resp_id, and func_id will indicate which func we want */
87:
88: user_id := to_number(fnd_profile.value('USER_ID'));
89: resp_id := to_number(fnd_profile.value('RESP_ID'));
90: resp_appl_id := to_number(fnd_profile.value('RESP_APPL_ID'));
91: sec_grp_id := to_number(fnd_profile.value('SECURITY_GROUP_ID'));
92:
93:
86: /* func_id, userid, resp_id, and func_id will indicate which func we want */
87:
88: user_id := to_number(fnd_profile.value('USER_ID'));
89: resp_id := to_number(fnd_profile.value('RESP_ID'));
90: resp_appl_id := to_number(fnd_profile.value('RESP_APPL_ID'));
91: sec_grp_id := to_number(fnd_profile.value('SECURITY_GROUP_ID'));
92:
93:
94: -- /* Get profile plsql agent with one trailing slash */
87:
88: user_id := to_number(fnd_profile.value('USER_ID'));
89: resp_id := to_number(fnd_profile.value('RESP_ID'));
90: resp_appl_id := to_number(fnd_profile.value('RESP_APPL_ID'));
91: sec_grp_id := to_number(fnd_profile.value('SECURITY_GROUP_ID'));
92:
93:
94: -- /* Get profile plsql agent with one trailing slash */
95: -- do not need plsql_agent bug#4865201