APPS.PAY_WF_PKG dependencies on FND_PROFILE_SERVER

Line 1024: select fnd_profile_server.value('PER_SECURITY_PROFILE_ID')

1020: END;
1021: -- For debugging .. remove the code
1022: Begin
1023: /*
1024: select fnd_profile_server.value('PER_SECURITY_PROFILE_ID')
1025: into l_profile_per_sec_id
1026: from dual;
1027: */
1028: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))

Line 1028: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))

1024: select fnd_profile_server.value('PER_SECURITY_PROFILE_ID')
1025: into l_profile_per_sec_id
1026: from dual;
1027: */
1028: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
1029: into l_profile_per_sec_id
1030: from dual;
1031: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
1032: into l_profile_per_bg

Line 1031: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')

1027: */
1028: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
1029: into l_profile_per_sec_id
1030: from dual;
1031: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
1032: into l_profile_per_bg
1033: from dual;
1034: /*
1035: select fnd_profile_server.value('SECURITY_GROUP_ID')

Line 1035: select fnd_profile_server.value('SECURITY_GROUP_ID')

1031: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
1032: into l_profile_per_bg
1033: from dual;
1034: /*
1035: select fnd_profile_server.value('SECURITY_GROUP_ID')
1036: into l_profile_sec_grp_id
1037: from dual;
1038: */
1039: select to_number(fnd_profile_server.value('SECURITY_GROUP_ID'))

Line 1039: select to_number(fnd_profile_server.value('SECURITY_GROUP_ID'))

1035: select fnd_profile_server.value('SECURITY_GROUP_ID')
1036: into l_profile_sec_grp_id
1037: from dual;
1038: */
1039: select to_number(fnd_profile_server.value('SECURITY_GROUP_ID'))
1040: into l_profile_sec_grp_id
1041: from dual;
1042:
1043: select fnd_profile_server.value('USERNAME')

Line 1043: select fnd_profile_server.value('USERNAME')

1039: select to_number(fnd_profile_server.value('SECURITY_GROUP_ID'))
1040: into l_profile_sec_grp_id
1041: from dual;
1042:
1043: select fnd_profile_server.value('USERNAME')
1044: into l_profile_user_name
1045: from dual;
1046:
1047: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);