eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PYUCSLIS_PKG dependencies on FND_PROFILE

Line 20: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');

16: p_effective_date date
17: ) is
18: --
19: l_proc varchar2(72):= g_package||'add_contacts_for_person';
20: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
21: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
22: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
23: l_upd_date date := trunc(sysdate);
24: --

Line 21: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');

17: ) is
18: --
19: l_proc varchar2(72):= g_package||'add_contacts_for_person';
20: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
21: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
22: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
23: l_upd_date date := trunc(sysdate);
24: --
25: begin

Line 22: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');

18: --
19: l_proc varchar2(72):= g_package||'add_contacts_for_person';
20: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
21: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
22: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
23: l_upd_date date := trunc(sysdate);
24: --
25: begin
26: --

Line 89: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');

85: l_sp_tbl l_number_t;
86: l_sp_bg_tbl l_number_t;
87: --
88: l_proc varchar2(72) := g_package||'.add_unrelated_contacts';
89: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
90: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
91: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
92: l_upd_date date := trunc(sysdate);
93: t_varchar varchar2(1);

Line 90: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');

86: l_sp_bg_tbl l_number_t;
87: --
88: l_proc varchar2(72) := g_package||'.add_unrelated_contacts';
89: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
90: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
91: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
92: l_upd_date date := trunc(sysdate);
93: t_varchar varchar2(1);
94: -- Fetch the unrelated contacts, excluding the Candidates (iRecruitment

Line 91: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');

87: --
88: l_proc varchar2(72) := g_package||'.add_unrelated_contacts';
89: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
90: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
91: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
92: l_upd_date date := trunc(sysdate);
93: t_varchar varchar2(1);
94: -- Fetch the unrelated contacts, excluding the Candidates (iRecruitment
95: -- registered user's) that are in scope.

Line 755: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');

751: p_business_group_id number
752: ) is
753: --
754: l_proc varchar2(72):= g_package||'build_contact_list';
755: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
756: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
757: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
758: l_upd_date date := trunc(sysdate);
759: --

Line 756: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');

752: ) is
753: --
754: l_proc varchar2(72):= g_package||'build_contact_list';
755: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
756: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
757: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
758: l_upd_date date := trunc(sysdate);
759: --
760: begin

Line 757: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');

753: --
754: l_proc varchar2(72):= g_package||'build_contact_list';
755: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
756: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
757: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
758: l_upd_date date := trunc(sysdate);
759: --
760: begin
761: --

Line 2688: argument7 => fnd_profile.value('PER_BUSINESS_GROUP_ID'),

2684: argument3 => 'HR_PROCESS',
2685: argument4 => l_effective_date,
2686: argument5 => l_effective_date,
2687: argument6 => 'PROCESS',
2688: argument7 => fnd_profile.value('PER_BUSINESS_GROUP_ID'),
2689: argument8 => null,
2690: argument9 => null,
2691: argument10 => l_action_parameter_group_id,
2692: argument11 => 'BUSINESS_GROUP_ID='||l_business_group_id,

Line 2792: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');

2788:
2789: --
2790: -- Set variables used for WHO columns
2791: --
2792: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');
2793: p_request_id := fnd_profile.value('CONC_REQUEST_ID');
2794: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
2795: p_update_date := trunc(sysdate);
2796:

Line 2793: p_request_id := fnd_profile.value('CONC_REQUEST_ID');

2789: --
2790: -- Set variables used for WHO columns
2791: --
2792: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');
2793: p_request_id := fnd_profile.value('CONC_REQUEST_ID');
2794: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
2795: p_update_date := trunc(sysdate);
2796:
2797: generate_list_control

Line 2794: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');

2790: -- Set variables used for WHO columns
2791: --
2792: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');
2793: p_request_id := fnd_profile.value('CONC_REQUEST_ID');
2794: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
2795: p_update_date := trunc(sysdate);
2796:
2797: generate_list_control
2798: (p_effective_date => nvl(fnd_date.canonical_to_date(p_effective_date)

Line 3415: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');

3411: begin
3412: --
3413: -- Set WHO column globals...
3414: --
3415: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');
3416: p_request_id := fnd_profile.value('CONC_REQUEST_ID');
3417: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
3418: p_update_date := trunc(sysdate);
3419:

Line 3416: p_request_id := fnd_profile.value('CONC_REQUEST_ID');

3412: --
3413: -- Set WHO column globals...
3414: --
3415: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');
3416: p_request_id := fnd_profile.value('CONC_REQUEST_ID');
3417: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
3418: p_update_date := trunc(sysdate);
3419:
3420: end initialization;

Line 3417: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');

3413: -- Set WHO column globals...
3414: --
3415: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');
3416: p_request_id := fnd_profile.value('CONC_REQUEST_ID');
3417: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
3418: p_update_date := trunc(sysdate);
3419:
3420: end initialization;
3421: --

Line 3516: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');

3512: ) is
3513: --
3514: -- Local variables
3515: l_proc varchar2(72):= g_package||'submit_cand_sec_opt';
3516: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
3517: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
3518: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
3519: l_upd_date date := trunc(sysdate);
3520: l_sec_cnt number := 1;

Line 3517: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');

3513: --
3514: -- Local variables
3515: l_proc varchar2(72):= g_package||'submit_cand_sec_opt';
3516: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
3517: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
3518: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
3519: l_upd_date date := trunc(sysdate);
3520: l_sec_cnt number := 1;
3521: --

Line 3518: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');

3514: -- Local variables
3515: l_proc varchar2(72):= g_package||'submit_cand_sec_opt';
3516: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
3517: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
3518: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
3519: l_upd_date date := trunc(sysdate);
3520: l_sec_cnt number := 1;
3521: --
3522: -- Exception variables

Line 3550: if nvl(fnd_profile.value('IRC_INSTALLED_FLAG'), 'N') = 'N' then

3546: --
3547: hr_utility.set_location('Entering '||l_proc, 10);
3548: --
3549: -- Checking that whether iRecruitment is installed.
3550: if nvl(fnd_profile.value('IRC_INSTALLED_FLAG'), 'N') = 'N' then
3551: raise e_irec_not_installed;
3552: end if;
3553: --
3554: hr_utility.set_location(l_proc, 20);