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 FND_NUMBER

Line 140: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),

136: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
137: 'RECEIVER_ID=P', 'INLAND REVENUE',
138: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
139: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
140: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
141: 'FORM_TYPE=P', '5',
142: 'FORM_TYPE_MEANING=P', 'P45_3',
143: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
144: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),

Line 215: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),

211: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
212: 'RECEIVER_ID=P', 'INLAND REVENUE',
213: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
214: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
215: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
216: 'FORM_TYPE=P', '7',
217: 'FORM_TYPE_MEANING=P', 'P46',
218: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
219: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),

Line 279: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),

275: select 'SENDER_ID=P', hoi.org_information11,
276: 'RECEIVER_ID=P', 'INLAND REVENUE',
277: 'TEST_INDICATOR=P',decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
278: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
279: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
280: 'FORM_TYPE=P', '6',
281: 'FORM_TYPE_MEANING=P', 'P46_PENNOT',
282: 'TAX_DIST_NO=P', substr(hoi.org_information1,1,3),
283: 'TAX_DIST_REF=P', upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),

Line 343: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),

339: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
340: 'RECEIVER_ID=P', 'INLAND REVENUE',
341: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
342: 'URGENT_MARKER=P', ' ', -- as a space is required in this place
343: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
344: 'FORM_TYPE=P', '18',
345: 'FORM_TYPE_MEANING=P', 'WNU',
346: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
347: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),

Line 401: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),

397: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
398: 'RECEIVER_ID=P', 'HMRC', /* changed for P45PT_3*/
399: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
400: 'URGENT_MARKER=P', ' ',
401: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
402: 'FORM_TYPE=P', '5',
403: 'FORM_TYPE_MEANING=P', 'P45PT3', /* changed for P45PT_3*/
404: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
405: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),

Line 492: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),

488: select 'SENDER_ID=P', nvl(UPPER(hoi.org_information11),' '), -- Bug 8329474
489: 'RECEIVER_ID=P', 'HMRC', /* changed for P45PT_3*/
490: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
491: 'URGENT_MARKER=P', ' ',
492: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
493: 'FORM_TYPE=P', '5',
494: 'FORM_TYPE_MEANING=P', 'P45PT_3_VER6', /* changed for P45PT_3*/
495: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
496: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),

Line 586: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),

582: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID'),
583: 'URGENT_MARKER=P', ' ',
584: 'TRANSMISSION_DATE=P', to_char(sysdate,'CCYYMMDD'),
585: 'TRANSMISSION_TIME=P', to_char(sysdate,'HHMMSS'),
586: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
587: 'FORM_TYPE=P', '6',
588: 'FORM_TYPE_MEANING=P', 'P46_5_PENNOT',
589: 'UNIQUE_REF=P', '1234',
590: 'SENDER_SUBAD=P',' ',

Line 674: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),

670: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID'),
671: 'URGENT_MARKER=P', ' ',
672: 'TRANSMISSION_DATE=P', to_char(sysdate,'CCYYMMDD'),
673: 'TRANSMISSION_TIME=P', to_char(sysdate,'HHMMSS'),
674: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
675: 'FORM_TYPE=P', '6',
676: 'FORM_TYPE_MEANING=P', 'P46_VER6_PENNOT',
677: 'UNIQUE_REF=P', '1234',
678: 'SENDER_SUBAD=P',' ',

Line 761: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),

757: select 'SENDER_ID=P', nvl(UPPER(hoi.org_information11),' '),
758: 'RECEIVER_ID=P', 'HMRC',
759: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
760: 'URGENT_MARKER=P', ' ',--decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
761: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
762: 'FORM_TYPE=P', '7',
763: 'FORM_TYPE_MEANING=P', 'P46_5',
764: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
765: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),

Line 832: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),

828: select 'SENDER_ID=P', nvl(UPPER(hoi.org_information11),' '),
829: 'RECEIVER_ID=P', 'HMRC',
830: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
831: 'URGENT_MARKER=P', ' ',--decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
832: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
833: 'FORM_TYPE=P', '7',
834: 'FORM_TYPE_MEANING=P', 'P46_VER6',
835: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
836: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),

Line 904: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),

900: select 'SENDER_ID=P', nvl(UPPER(hoi.org_information11),' '),
901: 'RECEIVER_ID=P', 'HMRC',
902: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
903: 'URGENT_MARKER=P', ' ',
904: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
905: 'FORM_TYPE=P', '23',
906: 'FORM_TYPE_MEANING=P', 'P46EXP_VER6',
907: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
908: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),