APPS.PAY_GB_MOVDED_EDI dependencies on FND_NUMBER

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

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),' '),
122: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),

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

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),' '),
197: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),

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

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),
261: 'TAX_DIST_REF=P', upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),

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

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',
323: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
324: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),

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

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*/
381: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
382: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),

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

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),
473: 'FORM_TYPE=P', '6',
474: 'FORM_TYPE_MEANING=P', 'P46_5_PENNOT',
475: 'UNIQUE_REF=P', '1234',
476: 'SENDER_SUBAD=P',' ',

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

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),' '),
559: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),