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.BEN_CREATE_PTNL_LER_SS dependencies on HR_TRANSACTION_SS

Line 61: and to_date(p_effective_date,hr_transaction_ss.g_date_format)

57: select ler.ocrd_dt_det_cd
58: from ben_ler_f ler
59: where ler.business_group_id = to_number(p_business_group_id)
60: and ler.ler_id = to_number(p_ler_id)
61: and to_date(p_effective_date,hr_transaction_ss.g_date_format)
62: between ler.effective_start_date
63: and ler.effective_end_date;
64: BEGIN
65: -- CALL THE ACTUAL PROCEDURE HERE

Line 70: if (to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format) <=

66: /************cobra change********************/
67: --
68: if p_hire_dt is not null then
69:
70: if (to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format) <=
71: to_date(p_hire_dt,hr_transaction_ss.g_date_format)) then
72: p_lf_evt_ocrd_dt := p_hire_dt;
73: end if;
74: end if;

Line 71: to_date(p_hire_dt,hr_transaction_ss.g_date_format)) then

67: --
68: if p_hire_dt is not null then
69:
70: if (to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format) <=
71: to_date(p_hire_dt,hr_transaction_ss.g_date_format)) then
72: p_lf_evt_ocrd_dt := p_hire_dt;
73: end if;
74: end if;
75: open get_ler;

Line 81: ,p_effective_date => to_date(p_effective_date,hr_transaction_ss.g_date_format)

77: if get_ler%found then
78: if l_ocrd_dt_cd is not null then
79: ben_determine_date.main
80: (p_date_cd => l_ocrd_dt_cd
81: ,p_effective_date => to_date(p_effective_date,hr_transaction_ss.g_date_format)
82: ,p_lf_evt_ocrd_dt => to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format)
83: ,p_returned_date => l_lf_evt_ocrd_date
84: );
85: else

Line 82: ,p_lf_evt_ocrd_dt => to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format)

78: if l_ocrd_dt_cd is not null then
79: ben_determine_date.main
80: (p_date_cd => l_ocrd_dt_cd
81: ,p_effective_date => to_date(p_effective_date,hr_transaction_ss.g_date_format)
82: ,p_lf_evt_ocrd_dt => to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format)
83: ,p_returned_date => l_lf_evt_ocrd_date
84: );
85: else
86: l_lf_evt_ocrd_date := to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format);

Line 86: l_lf_evt_ocrd_date := to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format);

82: ,p_lf_evt_ocrd_dt => to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format)
83: ,p_returned_date => l_lf_evt_ocrd_date
84: );
85: else
86: l_lf_evt_ocrd_date := to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format);
87: end if;
88: else
89: l_lf_evt_ocrd_date := to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format);
90: end if;

Line 89: l_lf_evt_ocrd_date := to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format);

85: else
86: l_lf_evt_ocrd_date := to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format);
87: end if;
88: else
89: l_lf_evt_ocrd_date := to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format);
90: end if;
91: /********************************************/
92: --l_lf_evt_ocrd_date := to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format);
93: -- Replace the strings by date and number where required

Line 92: --l_lf_evt_ocrd_date := to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format);

88: else
89: l_lf_evt_ocrd_date := to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format);
90: end if;
91: /********************************************/
92: --l_lf_evt_ocrd_date := to_date(p_lf_evt_ocrd_dt,hr_transaction_ss.g_date_format);
93: -- Replace the strings by date and number where required
94: create_ptnl_ler_for_per
95: (p_validate => p_validate -- in varchar2 default 'N'
96: ,p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id -- out number

Line 101: ,p_mnl_dt => to_date(p_mnl_dt,hr_transaction_ss.g_date_format) -- in date default null

97: ,p_csd_by_ptnl_ler_for_per_id => to_number(p_csd_by_ptnl_ler_for_per_id) -- in number default null
98: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date -- in date default null
99: ,p_ptnl_ler_for_per_stat_cd => p_ptnl_ler_for_per_stat_cd -- in varchar2 default null
100: ,p_ptnl_ler_for_per_src_cd => p_ptnl_ler_for_per_src_cd -- in varchar2 default null
101: ,p_mnl_dt => to_date(p_mnl_dt,hr_transaction_ss.g_date_format) -- in date default null
102: ,p_enrt_perd_id => to_number(p_enrt_perd_id) -- in number default null
103: ,p_ler_id => to_number(p_ler_id) -- in number default null
104: ,p_person_id => to_number(p_person_id) -- in number default null
105: ,p_business_group_id => to_number(p_business_group_id) -- in number

Line 106: ,p_dtctd_dt => to_date(p_dtctd_dt,hr_transaction_ss.g_date_format) -- in date default null

102: ,p_enrt_perd_id => to_number(p_enrt_perd_id) -- in number default null
103: ,p_ler_id => to_number(p_ler_id) -- in number default null
104: ,p_person_id => to_number(p_person_id) -- in number default null
105: ,p_business_group_id => to_number(p_business_group_id) -- in number
106: ,p_dtctd_dt => to_date(p_dtctd_dt,hr_transaction_ss.g_date_format) -- in date default null
107: ,p_procd_dt => to_date(p_procd_dt,hr_transaction_ss.g_date_format) -- in date default null
108: ,p_unprocd_dt => to_date(p_unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null
109: ,p_voidd_dt => to_date(p_voidd_dt,hr_transaction_ss.g_date_format) -- in date default null
110: ,p_mnlo_dt => to_date(p_mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null

Line 107: ,p_procd_dt => to_date(p_procd_dt,hr_transaction_ss.g_date_format) -- in date default null

103: ,p_ler_id => to_number(p_ler_id) -- in number default null
104: ,p_person_id => to_number(p_person_id) -- in number default null
105: ,p_business_group_id => to_number(p_business_group_id) -- in number
106: ,p_dtctd_dt => to_date(p_dtctd_dt,hr_transaction_ss.g_date_format) -- in date default null
107: ,p_procd_dt => to_date(p_procd_dt,hr_transaction_ss.g_date_format) -- in date default null
108: ,p_unprocd_dt => to_date(p_unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null
109: ,p_voidd_dt => to_date(p_voidd_dt,hr_transaction_ss.g_date_format) -- in date default null
110: ,p_mnlo_dt => to_date(p_mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null
111: ,p_ntfn_dt => to_date(p_ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null

Line 108: ,p_unprocd_dt => to_date(p_unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null

104: ,p_person_id => to_number(p_person_id) -- in number default null
105: ,p_business_group_id => to_number(p_business_group_id) -- in number
106: ,p_dtctd_dt => to_date(p_dtctd_dt,hr_transaction_ss.g_date_format) -- in date default null
107: ,p_procd_dt => to_date(p_procd_dt,hr_transaction_ss.g_date_format) -- in date default null
108: ,p_unprocd_dt => to_date(p_unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null
109: ,p_voidd_dt => to_date(p_voidd_dt,hr_transaction_ss.g_date_format) -- in date default null
110: ,p_mnlo_dt => to_date(p_mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null
111: ,p_ntfn_dt => to_date(p_ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null
112: ,p_request_id => to_number(p_request_id) -- in number default null

Line 109: ,p_voidd_dt => to_date(p_voidd_dt,hr_transaction_ss.g_date_format) -- in date default null

105: ,p_business_group_id => to_number(p_business_group_id) -- in number
106: ,p_dtctd_dt => to_date(p_dtctd_dt,hr_transaction_ss.g_date_format) -- in date default null
107: ,p_procd_dt => to_date(p_procd_dt,hr_transaction_ss.g_date_format) -- in date default null
108: ,p_unprocd_dt => to_date(p_unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null
109: ,p_voidd_dt => to_date(p_voidd_dt,hr_transaction_ss.g_date_format) -- in date default null
110: ,p_mnlo_dt => to_date(p_mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null
111: ,p_ntfn_dt => to_date(p_ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null
112: ,p_request_id => to_number(p_request_id) -- in number default null
113: ,p_program_application_id => to_number(p_program_application_id) -- in number default null

Line 110: ,p_mnlo_dt => to_date(p_mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null

106: ,p_dtctd_dt => to_date(p_dtctd_dt,hr_transaction_ss.g_date_format) -- in date default null
107: ,p_procd_dt => to_date(p_procd_dt,hr_transaction_ss.g_date_format) -- in date default null
108: ,p_unprocd_dt => to_date(p_unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null
109: ,p_voidd_dt => to_date(p_voidd_dt,hr_transaction_ss.g_date_format) -- in date default null
110: ,p_mnlo_dt => to_date(p_mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null
111: ,p_ntfn_dt => to_date(p_ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null
112: ,p_request_id => to_number(p_request_id) -- in number default null
113: ,p_program_application_id => to_number(p_program_application_id) -- in number default null
114: ,p_program_id => to_number(p_program_id) -- in number default null

Line 111: ,p_ntfn_dt => to_date(p_ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null

107: ,p_procd_dt => to_date(p_procd_dt,hr_transaction_ss.g_date_format) -- in date default null
108: ,p_unprocd_dt => to_date(p_unprocd_dt,hr_transaction_ss.g_date_format) -- in date default null
109: ,p_voidd_dt => to_date(p_voidd_dt,hr_transaction_ss.g_date_format) -- in date default null
110: ,p_mnlo_dt => to_date(p_mnlo_dt,hr_transaction_ss.g_date_format) -- in date default null
111: ,p_ntfn_dt => to_date(p_ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null
112: ,p_request_id => to_number(p_request_id) -- in number default null
113: ,p_program_application_id => to_number(p_program_application_id) -- in number default null
114: ,p_program_id => to_number(p_program_id) -- in number default null
115: ,p_program_update_date => to_date(p_program_update_date,hr_transaction_ss.g_date_format) -- in date default null

Line 115: ,p_program_update_date => to_date(p_program_update_date,hr_transaction_ss.g_date_format) -- in date default null

111: ,p_ntfn_dt => to_date(p_ntfn_dt,hr_transaction_ss.g_date_format) -- in date default null
112: ,p_request_id => to_number(p_request_id) -- in number default null
113: ,p_program_application_id => to_number(p_program_application_id) -- in number default null
114: ,p_program_id => to_number(p_program_id) -- in number default null
115: ,p_program_update_date => to_date(p_program_update_date,hr_transaction_ss.g_date_format) -- in date default null
116: ,p_object_version_number => l_object_version_number --out number
117: ,p_effective_date => to_date(p_effective_date,hr_transaction_ss.g_date_format) -- in date
118: ,p_item_type => p_item_type -- in varchar2
119: ,p_item_key => p_item_key -- in varchar2

Line 117: ,p_effective_date => to_date(p_effective_date,hr_transaction_ss.g_date_format) -- in date

113: ,p_program_application_id => to_number(p_program_application_id) -- in number default null
114: ,p_program_id => to_number(p_program_id) -- in number default null
115: ,p_program_update_date => to_date(p_program_update_date,hr_transaction_ss.g_date_format) -- in date default null
116: ,p_object_version_number => l_object_version_number --out number
117: ,p_effective_date => to_date(p_effective_date,hr_transaction_ss.g_date_format) -- in date
118: ,p_item_type => p_item_type -- in varchar2
119: ,p_item_key => p_item_key -- in varchar2
120: ,p_activity_id => to_number(p_activity_id) -- in number
121: ,p_login_person_id => to_number(p_login_person_id) -- in number default null

Line 132: p_lf_evt_ocrd_dt := to_char(l_lf_evt_ocrd_date,hr_transaction_ss.g_date_format);

128: -- assign the out parameters
129: p_ptnl_ler_for_per_id := to_char(l_ptnl_ler_for_per_id);
130: p_object_version_number:= to_char(l_object_version_number);
131: p_transaction_step_id := to_char(l_transaction_step_id);
132: p_lf_evt_ocrd_dt := to_char(l_lf_evt_ocrd_date,hr_transaction_ss.g_date_format);
133: --
134: EXCEPTION
135: when others then
136: raise;

Line 178: l_transaction_table hr_transaction_ss.transaction_table;

174: --declare a cursor to check if the person actually exists in the database
175: cursor csr_person is select person_id from per_all_people_f where person_id = p_person_id;
176:
177:
178: l_transaction_table hr_transaction_ss.transaction_table;
179: l_count INTEGER := 0;
180: l_transaction_id hr_api_transaction_steps.transaction_id%type default null;
181: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
182: l_trans_object_version_number hr_api_transaction_steps.object_version_number%type;

Line 284: l_transaction_id := hr_transaction_ss.get_transaction_id

280: --
281: --
282: -- First, check if transaction id exists or not
283: --
284: l_transaction_id := hr_transaction_ss.get_transaction_id
285: (p_item_type => p_item_type
286: ,p_item_key => p_item_key);
287: --
288: IF l_transaction_id is null THEN

Line 292: hr_transaction_ss.start_transaction

288: IF l_transaction_id is null THEN
289:
290: -- Start a Transaction
291:
292: hr_transaction_ss.start_transaction
293: (itemtype => p_item_type
294: ,itemkey => p_item_key
295: ,actid => p_activity_id
296: ,funmode => 'RUN'

Line 302: l_transaction_id := hr_transaction_ss.get_transaction_id

298: ,result => l_result);
299:
300: -- need to take care of l_result
301:
302: l_transaction_id := hr_transaction_ss.get_transaction_id
303: (p_item_type => p_item_type
304: ,p_item_key => p_item_key);
305: ELSE
306: -- since transaction id is present look for the step if it already exists

Line 346: hr_transaction_ss.g_date_format);

342:
343: l_count := l_count + 1;
344: l_transaction_table(l_count).param_name := 'P_LF_EVT_OCRD_DT';
345: l_transaction_table(l_count).param_value := to_char(p_lf_evt_ocrd_dt,
346: hr_transaction_ss.g_date_format);
347: l_transaction_table(l_count).param_data_type := 'DATE';
348:
349:
350: l_count := l_count + 1;

Line 364: hr_transaction_ss.g_date_format);

360:
361: l_count := l_count + 1;
362: l_transaction_table(l_count).param_name := 'P_MNL_DT';
363: l_transaction_table(l_count).param_value := to_char(p_mnl_dt,
364: hr_transaction_ss.g_date_format);
365: l_transaction_table(l_count).param_data_type := 'DATE';
366:
367: l_count := l_count + 1;
368: l_transaction_table(l_count).param_name := 'P_ENRT_PERD_ID';

Line 390: hr_transaction_ss.g_date_format);

386:
387: l_count := l_count + 1;
388: l_transaction_table(l_count).param_name := 'P_DTCTD_DT';
389: l_transaction_table(l_count).param_value := to_char(p_dtctd_dt,
390: hr_transaction_ss.g_date_format);
391: l_transaction_table(l_count).param_data_type := 'DATE';
392:
393: l_count := l_count + 1;
394: l_transaction_table(l_count).param_name := 'P_PROCD_DT';

Line 396: hr_transaction_ss.g_date_format);

392:
393: l_count := l_count + 1;
394: l_transaction_table(l_count).param_name := 'P_PROCD_DT';
395: l_transaction_table(l_count).param_value := to_char(p_procd_dt,
396: hr_transaction_ss.g_date_format);
397: l_transaction_table(l_count).param_data_type := 'DATE';
398:
399: l_count := l_count + 1;
400: l_transaction_table(l_count).param_name := 'P_UNPROCD_DT';

Line 402: hr_transaction_ss.g_date_format);

398:
399: l_count := l_count + 1;
400: l_transaction_table(l_count).param_name := 'P_UNPROCD_DT';
401: l_transaction_table(l_count).param_value := to_char(p_unprocd_dt,
402: hr_transaction_ss.g_date_format);
403: l_transaction_table(l_count).param_data_type := 'DATE';
404:
405: l_count := l_count + 1;
406: l_transaction_table(l_count).param_name := 'P_VOIDD_DT';

Line 408: hr_transaction_ss.g_date_format);

404:
405: l_count := l_count + 1;
406: l_transaction_table(l_count).param_name := 'P_VOIDD_DT';
407: l_transaction_table(l_count).param_value := to_char(p_voidd_dt,
408: hr_transaction_ss.g_date_format);
409: l_transaction_table(l_count).param_data_type := 'DATE';
410:
411: l_count := l_count + 1;
412: l_transaction_table(l_count).param_name := 'P_MNLO_DT';

Line 414: hr_transaction_ss.g_date_format);

410:
411: l_count := l_count + 1;
412: l_transaction_table(l_count).param_name := 'P_MNLO_DT';
413: l_transaction_table(l_count).param_value := to_char(p_mnlo_dt,
414: hr_transaction_ss.g_date_format);
415: l_transaction_table(l_count).param_data_type := 'DATE';
416:
417: l_count := l_count + 1;
418: l_transaction_table(l_count).param_name := 'P_NTFN_DT';

Line 420: hr_transaction_ss.g_date_format);

416:
417: l_count := l_count + 1;
418: l_transaction_table(l_count).param_name := 'P_NTFN_DT';
419: l_transaction_table(l_count).param_value := to_char(p_ntfn_dt,
420: hr_transaction_ss.g_date_format);
421: l_transaction_table(l_count).param_data_type := 'DATE';
422:
423: l_count := l_count + 1;
424: l_transaction_table(l_count).param_name := 'P_REQUEST_ID';

Line 442: hr_transaction_ss.g_date_format);

438:
439: l_count := l_count + 1;
440: l_transaction_table(l_count).param_name := 'P_PROGRAM_UPDATE_DATE';
441: l_transaction_table(l_count).param_value := to_char(p_program_update_date,
442: hr_transaction_ss.g_date_format);
443: l_transaction_table(l_count).param_data_type := 'DATE';
444:
445:
446: l_count := l_count + 1;

Line 449: hr_transaction_ss.g_date_format);

445:
446: l_count := l_count + 1;
447: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
448: l_transaction_table(l_count).param_value := to_char(p_effective_date,
449: hr_transaction_ss.g_date_format);
450: l_transaction_table(l_count).param_data_type := 'DATE';
451:
452: l_count := l_count + 1;
453: l_transaction_table(l_count).param_name := 'P_ITEM_TYPE';

Line 505: hr_transaction_ss.save_transaction_step

501: l_transaction_table(l_count).param_value := l_review_item_name;
502: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
503:
504:
505: hr_transaction_ss.save_transaction_step
506: (p_item_type => p_item_type
507: ,p_item_key => p_item_key
508: ,p_actid => p_activity_id
509: ,p_login_person_id => nvl(p_login_person_id, p_person_id) -- PB Modification