DBA Data[Home] [Help]

APPS.PAY_GB_P11D_EDI_CONTROL dependencies on PAY_GB_P11D_MAGTAPE

Line 12: select 'TAX_YEAR=P',pay_gb_p11d_magtape.get_parameters(

8: p_employer_ref in varchar2) return number;
9:
10: -- CURSOR --
11: cursor csr_p11d_header is
12: select 'TAX_YEAR=P',pay_gb_p11d_magtape.get_parameters(
13: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'Rep_Run'),
14: 'TEST_SUBMISSION=P',pay_magtape_generic.get_parameter_value('TEST_SUBMISSION'),
15: 'TRANSMISSION_DATE=P',to_char(sysdate,'YYYYMMDDHHMMSS'),
16: 'PAYROLL_ACTION_ID=P',pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')

Line 26: 'PARTY_NAME=P', pay_gb_p11d_magtape.get_parameters(

22: 'EMPLOYERS_REF_NO=P', NVL(UPPER(action_information6), ' '),
23: 'EMPLOYERS_NAME=P', NVL(UPPER(action_information7), ' '),
24: 'EMPLOYERS_ADDRESS=P', NVL(UPPER(action_information8), ' '),
25: 'MESSAGE_DATE=P', to_char(sysdate,'YYYYMMDD'),
26: 'PARTY_NAME=P', pay_gb_p11d_magtape.get_parameters(
27: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),
28: 'PARTY_NAME',action_information6),
29: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(
30: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',

Line 29: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(

25: 'MESSAGE_DATE=P', to_char(sysdate,'YYYYMMDD'),
26: 'PARTY_NAME=P', pay_gb_p11d_magtape.get_parameters(
27: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),
28: 'PARTY_NAME',action_information6),
29: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(
30: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',
31: action_information6),
32: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(
33: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),

Line 32: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(

28: 'PARTY_NAME',action_information6),
29: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(
30: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',
31: action_information6),
32: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(
33: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),
34: 'SUBMITTER_REF_NO=P', pay_gb_p11d_magtape.get_parameters(
35: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SUBMITTER_REF_NO',
36: action_information6)

Line 34: 'SUBMITTER_REF_NO=P', pay_gb_p11d_magtape.get_parameters(

30: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',
31: action_information6),
32: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(
33: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),
34: 'SUBMITTER_REF_NO=P', pay_gb_p11d_magtape.get_parameters(
35: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SUBMITTER_REF_NO',
36: action_information6)
37: from pay_assignment_actions paa,
38: pay_action_information pai

Line 52: 'PARTY_NAME=P', pay_gb_p11d_magtape.get_parameters(

48: 'EMPLOYERS_REF_NO=P', NVL(UPPER(action_information6), ' '),
49: 'EMPLOYERS_NAME=P', NVL(UPPER(action_information7), ' '),
50: 'EMPLOYERS_ADDRESS=P', NVL(UPPER(action_information8), ' '),
51: 'MESSAGE_DATE=P', to_char(sysdate,'YYYYMMDD'),
52: 'PARTY_NAME=P', pay_gb_p11d_magtape.get_parameters(
53: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),
54: 'PARTY_NAME',action_information6),
55: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(
56: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',

Line 55: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(

51: 'MESSAGE_DATE=P', to_char(sysdate,'YYYYMMDD'),
52: 'PARTY_NAME=P', pay_gb_p11d_magtape.get_parameters(
53: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),
54: 'PARTY_NAME',action_information6),
55: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(
56: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',
57: action_information6),
58: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(
59: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),

Line 58: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(

54: 'PARTY_NAME',action_information6),
55: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(
56: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',
57: action_information6),
58: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(
59: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),
60: 'SUBMITTER_REF_NO=P', pay_gb_p11d_magtape.get_parameters(
61: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SUBMITTER_REF_NO',
62: action_information6);

Line 60: 'SUBMITTER_REF_NO=P', pay_gb_p11d_magtape.get_parameters(

56: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',
57: action_information6),
58: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(
59: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),
60: 'SUBMITTER_REF_NO=P', pay_gb_p11d_magtape.get_parameters(
61: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SUBMITTER_REF_NO',
62: action_information6);
63:
64: