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

Line 116: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),

112:
113: cursor csr_p45_3_header is
114: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
115: 'RECEIVER_ID=P', 'INLAND REVENUE',
116: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
117: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
118: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
119: 'FORM_TYPE=P', '5',
120: 'FORM_TYPE_MEANING=P', 'P45_3',

Line 117: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),

113: cursor csr_p45_3_header is
114: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
115: 'RECEIVER_ID=P', 'INLAND REVENUE',
116: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
117: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
118: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
119: 'FORM_TYPE=P', '5',
120: 'FORM_TYPE_MEANING=P', 'P45_3',
121: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),

Line 128: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

124: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
125: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
126: from pay_payroll_actions pact,
127: hr_organization_information hoi
128: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
129: and pact.business_group_id = hoi.organization_id
130: and hoi.org_information_context = 'Tax Details References'
131: and nvl(hoi.org_information10,'UK') = 'UK'
132: and substr(pact.legislative_parameters, instr(pact.legislative_parameters, 'TAX_REF=') + 8,

Line 175: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

171: pay_assignment_actions paa,
172: pay_action_information addr,
173: pay_action_information peo,
174: pay_action_information p453
175: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
176: and pay.payroll_action_id = paa.payroll_action_id
177: and paa.assignment_action_id = peo.action_context_id
178: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
179: and peo.action_context_type = 'AAP'

Line 191: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),

187: --
188: cursor csr_p46_header is
189: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
190: 'RECEIVER_ID=P', 'INLAND REVENUE',
191: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
192: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
193: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
194: 'FORM_TYPE=P', '7',
195: 'FORM_TYPE_MEANING=P', 'P46',

Line 192: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),

188: cursor csr_p46_header is
189: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
190: 'RECEIVER_ID=P', 'INLAND REVENUE',
191: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
192: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
193: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
194: 'FORM_TYPE=P', '7',
195: 'FORM_TYPE_MEANING=P', 'P46',
196: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),

Line 203: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

199: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
200: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
201: from pay_payroll_actions pact,
202: hr_organization_information hoi
203: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
204: and pact.business_group_id = hoi.organization_id
205: and hoi.org_information_context = 'Tax Details References'
206: and nvl(hoi.org_information10,'UK') = 'UK'
207: and substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TAX_REF=') + 8,

Line 239: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

235: pay_assignment_actions paa,
236: pay_action_information addr,
237: pay_action_information peo,
238: pay_action_information p46
239: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
240: and pay.payroll_action_id = paa.payroll_action_id
241: and paa.assignment_action_id = peo.action_context_id
242: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
243: and peo.action_context_type = 'AAP'

Line 255: 'TEST_INDICATOR=P',decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),

251: --
252: cursor csr_p46_pennot_header is
253: select 'SENDER_ID=P', hoi.org_information11,
254: 'RECEIVER_ID=P', 'INLAND REVENUE',
255: 'TEST_INDICATOR=P',decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
256: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
257: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
258: 'FORM_TYPE=P', '6',
259: 'FORM_TYPE_MEANING=P', 'P46_PENNOT',

Line 256: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),

252: cursor csr_p46_pennot_header is
253: select 'SENDER_ID=P', hoi.org_information11,
254: 'RECEIVER_ID=P', 'INLAND REVENUE',
255: 'TEST_INDICATOR=P',decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
256: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
257: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
258: 'FORM_TYPE=P', '6',
259: 'FORM_TYPE_MEANING=P', 'P46_PENNOT',
260: 'TAX_DIST_NO=P', substr(hoi.org_information1,1,3),

Line 267: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

263: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
264: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
265: from pay_payroll_actions pact,
266: hr_organization_information hoi
267: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
268: and pact.business_group_id = hoi.organization_id
269: and hoi.org_information_context = 'Tax Details References'
270: and nvl(hoi.org_information10,'UK') = 'UK'
271: and substr(pact.legislative_parameters, instr(pact.legislative_parameters,'TAX_REF=') + 8,

Line 301: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

297: pay_assignment_actions paa,
298: pay_action_information addr,
299: pay_action_information peo,
300: pay_action_information p46p
301: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
302: and pay.payroll_action_id = paa.payroll_action_id
303: and paa.assignment_action_id = peo.action_context_id
304: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
305: and peo.action_context_type = 'AAP'

Line 318: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),

314: -- Bug 5398360
315: cursor csr_wnu3_header is
316: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
317: 'RECEIVER_ID=P', 'INLAND REVENUE',
318: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
319: 'URGENT_MARKER=P', ' ', -- as a space is required in this place
320: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
321: 'FORM_TYPE=P', '18',
322: 'FORM_TYPE_MEANING=P', 'WNU',

Line 330: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

326: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
327: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
328: from pay_payroll_actions pact,
329: hr_organization_information hoi
330: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
331: and pact.business_group_id = hoi.organization_id
332: and hoi.org_information_context = 'Tax Details References'
333: and nvl(hoi.org_information10,'UK') = 'UK'
334: and substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TAX_REF=') + 8,

Line 363: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

359: 'OLD_ASSIGNMENT_NUMBER=P',nvl(upper(wnu3.action_information2), ' ') -- for PAY_GB_EDI_WNU_3
360: from pay_assignment_actions paa,
361: pay_action_information peo,
362: pay_action_information wnu3
363: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
364: and paa.assignment_action_id = peo.action_context_id
365: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
366: and peo.action_context_type = 'AAP'
367: and paa.assignment_action_id = wnu3.action_context_id(+)

Line 376: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),

372: /* changes for P45PT_3 start*/
373: cursor csr_p45pt_3_header is
374: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
375: 'RECEIVER_ID=P', 'HMRC', /* changed for P45PT_3*/
376: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
377: 'URGENT_MARKER=P', ' ',
378: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
379: 'FORM_TYPE=P', '5',
380: 'FORM_TYPE_MEANING=P', 'P45PT3', /* changed for P45PT_3*/

Line 386: 'TEST_ID=P', nvl(pay_magtape_generic.get_parameter_value('TEST_ID'),' ') /added for P45PT_3/

382: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),
383: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
384: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
385: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
386: 'TEST_ID=P', nvl(pay_magtape_generic.get_parameter_value('TEST_ID'),' ') /*added for P45PT_3*/
387: from pay_payroll_actions pact,
388: hr_organization_information hoi
389: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
390: and pact.business_group_id = hoi.organization_id

Line 389: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

385: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
386: 'TEST_ID=P', nvl(pay_magtape_generic.get_parameter_value('TEST_ID'),' ') /*added for P45PT_3*/
387: from pay_payroll_actions pact,
388: hr_organization_information hoi
389: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
390: and pact.business_group_id = hoi.organization_id
391: and hoi.org_information_context = 'Tax Details References'
392: and nvl(hoi.org_information10,'UK') = 'UK'
393: and substr(pact.legislative_parameters, instr(pact.legislative_parameters, 'TAX_REF=') + 8,

Line 448: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

444: pay_assignment_actions paa,
445: pay_action_information addr,
446: pay_action_information peo,
447: pay_action_information p453
448: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
449: and pay.payroll_action_id = paa.payroll_action_id
450: and paa.assignment_action_id = peo.action_context_id
451: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
452: and peo.action_context_type = 'AAP'

Line 467: 'TEST_INDICATOR=P',decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),

463: /******* start *******/
464: cursor csr_p46_5_pennot_header is
465: select 'SENDER_ID=P', hoi.org_information11,
466: 'RECEIVER_ID=P', 'HMRC',
467: 'TEST_INDICATOR=P',decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
468: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID'),
469: 'URGENT_MARKER=P', ' ',
470: 'TRANSMISSION_DATE=P', to_char(sysdate,'CCYYMMDD'),
471: 'TRANSMISSION_TIME=P', to_char(sysdate,'HHMMSS'),

Line 468: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID'),

464: cursor csr_p46_5_pennot_header is
465: select 'SENDER_ID=P', hoi.org_information11,
466: 'RECEIVER_ID=P', 'HMRC',
467: 'TEST_INDICATOR=P',decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
468: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID'),
469: 'URGENT_MARKER=P', ' ',
470: 'TRANSMISSION_DATE=P', to_char(sysdate,'CCYYMMDD'),
471: 'TRANSMISSION_TIME=P', to_char(sysdate,'HHMMSS'),
472: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),

Line 485: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

481: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
482: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
483: from pay_payroll_actions pact,
484: hr_organization_information hoi
485: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
486: and pact.business_group_id = hoi.organization_id
487: and hoi.org_information_context = 'Tax Details References'
488: and nvl(hoi.org_information10,'UK') = 'UK'
489: and substr(pact.legislative_parameters, instr(pact.legislative_parameters,'TAX_REF=') + 8,

Line 537: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

533: pay_assignment_actions paa,
534: pay_action_information addr,
535: pay_action_information peo,
536: pay_action_information p46p
537: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
538: and pay.payroll_action_id = paa.payroll_action_id
539: and paa.assignment_action_id = peo.action_context_id
540: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
541: and peo.action_context_type = 'AAP'

Line 553: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),

549: ---
550: cursor csr_p46_5_header is
551: select 'SENDER_ID=P', nvl(UPPER(hoi.org_information11),' '),
552: 'RECEIVER_ID=P', 'HMRC',
553: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
554: 'URGENT_MARKER=P', ' ',--decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
555: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
556: 'FORM_TYPE=P', '7',
557: 'FORM_TYPE_MEANING=P', 'P46_5',

Line 554: 'URGENT_MARKER=P', ' ',--decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),

550: cursor csr_p46_5_header is
551: select 'SENDER_ID=P', nvl(UPPER(hoi.org_information11),' '),
552: 'RECEIVER_ID=P', 'HMRC',
553: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
554: 'URGENT_MARKER=P', ' ',--decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
555: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
556: 'FORM_TYPE=P', '7',
557: 'FORM_TYPE_MEANING=P', 'P46_5',
558: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),

Line 563: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')

559: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),
560: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
561: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
562: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
563: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
564: from pay_payroll_actions pact,
565: hr_organization_information hoi
566: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
567: and pact.business_group_id = hoi.organization_id

Line 566: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

562: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
563: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
564: from pay_payroll_actions pact,
565: hr_organization_information hoi
566: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
567: and pact.business_group_id = hoi.organization_id
568: and hoi.org_information_context = 'Tax Details References'
569: and nvl(hoi.org_information10,'UK') = 'UK'
570: and substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TAX_REF=') + 8,

Line 605: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

601: pay_assignment_actions paa,
602: pay_action_information addr,
603: pay_action_information peo,
604: pay_action_information p46
605: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
606: and pay.payroll_action_id = paa.payroll_action_id
607: and paa.assignment_action_id = peo.action_context_id
608: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
609: and peo.action_context_type = 'AAP'