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.

[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on FND_PROFILE

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

22: p_effective_date date
23: ) is
24: --
25: l_proc varchar2(72):= g_package||'add_contacts_for_person';
26: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
27: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
28: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
29: l_upd_date date := trunc(sysdate);
30: --

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

23: ) is
24: --
25: l_proc varchar2(72):= g_package||'add_contacts_for_person';
26: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
27: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
28: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
29: l_upd_date date := trunc(sysdate);
30: --
31: begin

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

24: --
25: l_proc varchar2(72):= g_package||'add_contacts_for_person';
26: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
27: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
28: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
29: l_upd_date date := trunc(sysdate);
30: --
31: begin
32: --

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

133: l_sp_tbl l_number_t;
134: l_sp_bg_tbl l_number_t;
135: --
136: l_proc varchar2(72) := g_package||'.add_unrelated_contacts';
137: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
138: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
139: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
140: l_upd_date date := trunc(sysdate);
141: t_varchar varchar2(1);

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

134: l_sp_bg_tbl l_number_t;
135: --
136: l_proc varchar2(72) := g_package||'.add_unrelated_contacts';
137: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
138: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
139: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
140: l_upd_date date := trunc(sysdate);
141: t_varchar varchar2(1);
142: -- Fetch the unrelated contacts, excluding the Candidates (iRecruitment

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

135: --
136: l_proc varchar2(72) := g_package||'.add_unrelated_contacts';
137: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
138: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
139: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
140: l_upd_date date := trunc(sysdate);
141: t_varchar varchar2(1);
142: -- Fetch the unrelated contacts, excluding the Candidates (iRecruitment
143: -- registered user's) that are in scope.

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

815: p_business_group_id number
816: ) is
817: --
818: l_proc varchar2(72):= g_package||'build_contact_list';
819: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
820: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
821: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
822: l_upd_date date := trunc(sysdate);
823: --

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

816: ) is
817: --
818: l_proc varchar2(72):= g_package||'build_contact_list';
819: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
820: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
821: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
822: l_upd_date date := trunc(sysdate);
823: --
824: begin

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

817: --
818: l_proc varchar2(72):= g_package||'build_contact_list';
819: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
820: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
821: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
822: l_upd_date date := trunc(sysdate);
823: --
824: begin
825: --

Line 4290: l_program_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');

4286: l_cnt Number;
4287: dml_errors EXCEPTION;
4288: PRAGMA exception_init(dml_errors, -24381);
4289: l_proc varchar2(100):= 'process_person.profile_insert_cache_to_list';
4290: l_program_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
4291: l_request_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
4292: l_prog_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
4293: l_update_date date := trunc(sysdate);
4294:

Line 4291: l_request_id number(15) := fnd_profile.value('CONC_REQUEST_ID');

4287: dml_errors EXCEPTION;
4288: PRAGMA exception_init(dml_errors, -24381);
4289: l_proc varchar2(100):= 'process_person.profile_insert_cache_to_list';
4290: l_program_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
4291: l_request_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
4292: l_prog_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
4293: l_update_date date := trunc(sysdate);
4294:
4295: Begin

Line 4292: l_prog_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');

4288: PRAGMA exception_init(dml_errors, -24381);
4289: l_proc varchar2(100):= 'process_person.profile_insert_cache_to_list';
4290: l_program_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
4291: l_request_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
4292: l_prog_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
4293: l_update_date date := trunc(sysdate);
4294:
4295: Begin
4296: if g_debug then

Line 5018: fnd_profile_option_values

5014: AND p_effective_date BETWEEN fusg.start_date
5015: AND NVL(fusg.end_date,p_effective_date)
5016: AND EXISTS(
5017: SELECT level_value FROM
5018: fnd_profile_option_values
5019: WHERE profile_option_id = (SELECT profile_option_id FROM fnd_profile_options_vl
5020: WHERE profile_option_name = 'PER_SECURITY_PROFILE_ID')
5021: AND PROFILE_OPTION_VALUE = p_security_profile_id --SECURITY_PROFILE_ID
5022: AND LEVEL_ID=10003

Line 5019: WHERE profile_option_id = (SELECT profile_option_id FROM fnd_profile_options_vl

5015: AND NVL(fusg.end_date,p_effective_date)
5016: AND EXISTS(
5017: SELECT level_value FROM
5018: fnd_profile_option_values
5019: WHERE profile_option_id = (SELECT profile_option_id FROM fnd_profile_options_vl
5020: WHERE profile_option_name = 'PER_SECURITY_PROFILE_ID')
5021: AND PROFILE_OPTION_VALUE = p_security_profile_id --SECURITY_PROFILE_ID
5022: AND LEVEL_ID=10003
5023: AND level_value=fusg.responsibility_id )

Line 5102: if fnd_profile.value('ENABLE_SECURITY_GROUPS') = 'N' then

5098:
5099:
5100: IF (p_sec_prof_rec.custom_restriction_flag = 'U')
5101: THEN
5102: if fnd_profile.value('ENABLE_SECURITY_GROUPS') = 'N' then
5103: OPEN
5104: csr_get_resp(user_rec.user_id,to_char(p_sec_prof_rec.security_profile_id));
5105: FETCH csr_get_resp INTO l_resp_id,
5106: l_resp_app_id,

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

5564: argument3 => 'HR_PROCESS',
5565: argument4 => l_effective_date,
5566: argument5 => l_effective_date,
5567: argument6 => 'PROCESS',
5568: argument7 => fnd_profile.value('PER_BUSINESS_GROUP_ID'),
5569: argument8 => null,
5570: argument9 => null,
5571: argument10 => l_action_parameter_group_id,
5572: argument11 => 'BUSINESS_GROUP_ID='||l_business_group_id,

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

5733:
5734: --
5735: -- Set variables used for WHO columns
5736: --
5737: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');
5738: p_request_id := fnd_profile.value('CONC_REQUEST_ID');
5739: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
5740: p_update_date := trunc(sysdate);
5741:

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

5734: --
5735: -- Set variables used for WHO columns
5736: --
5737: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');
5738: p_request_id := fnd_profile.value('CONC_REQUEST_ID');
5739: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
5740: p_update_date := trunc(sysdate);
5741:
5742: -- Bug 3813908

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

5735: -- Set variables used for WHO columns
5736: --
5737: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');
5738: p_request_id := fnd_profile.value('CONC_REQUEST_ID');
5739: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
5740: p_update_date := trunc(sysdate);
5741:
5742: -- Bug 3813908
5743: if p_action_parameter_group_id is not null then

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

6408: begin
6409: --
6410: -- Set WHO column globals...
6411: --
6412: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');
6413: p_request_id := fnd_profile.value('CONC_REQUEST_ID');
6414: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
6415: p_update_date := trunc(sysdate);
6416:

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

6409: --
6410: -- Set WHO column globals...
6411: --
6412: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');
6413: p_request_id := fnd_profile.value('CONC_REQUEST_ID');
6414: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
6415: p_update_date := trunc(sysdate);
6416:
6417: end initialization;

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

6410: -- Set WHO column globals...
6411: --
6412: p_program_id := fnd_profile.value('CONC_PROGRAM_ID');
6413: p_request_id := fnd_profile.value('CONC_REQUEST_ID');
6414: p_program_application_id := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
6415: p_update_date := trunc(sysdate);
6416:
6417: end initialization;
6418: --

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

6509: ) is
6510: --
6511: -- Local variables
6512: l_proc varchar2(72):= g_package||'submit_cand_sec_opt';
6513: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
6514: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
6515: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
6516: l_upd_date date := trunc(sysdate);
6517: l_sec_cnt number := 1;

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

6510: --
6511: -- Local variables
6512: l_proc varchar2(72):= g_package||'submit_cand_sec_opt';
6513: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
6514: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
6515: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
6516: l_upd_date date := trunc(sysdate);
6517: l_sec_cnt number := 1;
6518: --

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

6511: -- Local variables
6512: l_proc varchar2(72):= g_package||'submit_cand_sec_opt';
6513: l_prog_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
6514: l_req_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
6515: l_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
6516: l_upd_date date := trunc(sysdate);
6517: l_sec_cnt number := 1;
6518: --
6519: -- Exception variables

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

6543: --
6544: hr_utility.set_location('Entering '||l_proc, 10);
6545: --
6546: -- Checking that whether iRecruitment is installed.
6547: if nvl(fnd_profile.value('IRC_INSTALLED_FLAG'), 'N') = 'N' then
6548: raise e_irec_not_installed;
6549: end if;
6550: --
6551: hr_utility.set_location(l_proc, 20);