APPS.PAY_WF_PKG dependencies on FND_PROFILE

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);

Line 2064: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');

2060:
2061: begin
2062:
2063: l_proc := gv_package||'.get_notifier';
2064: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
2065:
2066: hr_utility.trace('Profile Value is : '|| lv_contact_source);
2067: hr_utility.trace('Payroll Id is : '|| ln_payroll_id);
2068: hr_utility.trace('GRE Id is : '|| ln_gre_id);