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_IE_ARCHIVE_DETAIL_PKG dependencies on PAY_MAGTAPE_GENERIC

Line 210: papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')

206: FROM pay_all_payrolls_f papf
207: , hr_organization_information org
208: , hr_soft_coding_keyflex sck
209: WHERE
210: papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')
211: and to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS')
212: between papf.effective_start_date and papf.effective_end_date
213: and org.org_information_context = 'IE_PAYPATH_INFORMATION'
214: and papf.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID

Line 211: and to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS')

207: , hr_organization_information org
208: , hr_soft_coding_keyflex sck
209: WHERE
210: papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')
211: and to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS')
212: between papf.effective_start_date and papf.effective_end_date
213: and org.org_information_context = 'IE_PAYPATH_INFORMATION'
214: and papf.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
215: and org.ORG_INFORMATION_ID = to_number(sck.segment2)

Line 225: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

221: SELECT org.org_information8
222: FROM hr_organization_information org
223: , pay_payroll_actions ppa
224: WHERE
225: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
226: and org.organization_id = ppa.business_group_id
227: and org.org_information_context = 'IE_PAYPATH_INFORMATION'
228: and rownum=1;
229: --Cursor to fetch paypath id for a specified payroll parameter

Line 244: and papf.payroll_id = pay_magtape_generic.get_parameter_value('PAYROLL_ID')

240: , pay_all_payrolls_f papf
241: , pay_payroll_actions ppa
242: WHERE
243: papf.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
244: and papf.payroll_id = pay_magtape_generic.get_parameter_value('PAYROLL_ID')
245: and papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')
246: and ppa.effective_date between papf.effective_start_date and papf.effective_end_date
247: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
248: and papf.payroll_id=ppa.payroll_id);

Line 245: and papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')

241: , pay_payroll_actions ppa
242: WHERE
243: papf.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
244: and papf.payroll_id = pay_magtape_generic.get_parameter_value('PAYROLL_ID')
245: and papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')
246: and ppa.effective_date between papf.effective_start_date and papf.effective_end_date
247: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
248: and papf.payroll_id=ppa.payroll_id);
249: l_paypath_ids csr_payrolls%rowtype;

Line 247: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

243: papf.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
244: and papf.payroll_id = pay_magtape_generic.get_parameter_value('PAYROLL_ID')
245: and papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')
246: and ppa.effective_date between papf.effective_start_date and papf.effective_end_date
247: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
248: and papf.payroll_id=ppa.payroll_id);
249: l_paypath_ids csr_payrolls%rowtype;
250: l_bg_pathid csr_bg_paypath%rowtype;
251: l_payroll_pathid csr_payroll_paypath%rowtype;

Line 257: IF pay_magtape_generic.get_parameter_value('PAYROLL_ID') is null then

253: e_submit_error exception;
254: l_paypathid varchar2(150);
255: BEGIN
256: --Only consolidation set specified as parameter in IE PayPath Process
257: IF pay_magtape_generic.get_parameter_value('PAYROLL_ID') is null then
258: BEGIN
259: IF (g_consolidation_set_id is null) then
260: OPEN csr_payrolls;
261: LOOP

Line 272: g_consolidation_set_id := pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID');

268: raise e_submit_error;
269: end if;
270: g_paypathid := l_paypathid;
271: END LOOP;
272: g_consolidation_set_id := pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID');
273: END IF;
274: --If no Paypath ids are specified at payroll level,Paypath id defined at BG level is picked up.
275: if cnt=0 then
276: IF (g_payroll_action_id is null) then

Line 287: g_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

283: return l_paypathid;
284: END IF;
285: CLOSE CSR_BG_PAYPATH;
286: g_paypathid := l_bg_pathid.org_information8;
287: g_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
288: return g_paypathid;
289: END IF;
290: end if;
291: --If payrolls in the consolidation set all have the same paypath id, then that paypath id is picked up.

Line 316: g_payroll_id := pay_magtape_generic.get_parameter_value('PAYROLL_ID');

312: END IF;
313: --Bug No 3086034 End
314: CLOSE CSR_PAYROLL_PAYPATH;
315: g_paypathid := l_payroll_pathid.org_information8;
316: g_payroll_id := pay_magtape_generic.get_parameter_value('PAYROLL_ID');
317: g_consolidation_set_id := pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID');
318: return g_paypathid ;
319: END IF;
320: END IF;

Line 317: g_consolidation_set_id := pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID');

313: --Bug No 3086034 End
314: CLOSE CSR_PAYROLL_PAYPATH;
315: g_paypathid := l_payroll_pathid.org_information8;
316: g_payroll_id := pay_magtape_generic.get_parameter_value('PAYROLL_ID');
317: g_consolidation_set_id := pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID');
318: return g_paypathid ;
319: END IF;
320: END IF;
321: return g_paypathid;