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.

[Home] [Help]

APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_IE_P35

Line 1: PACKAGE PAY_IE_P35_MAGTAPE AUTHID CURRENT_USER AS

1: PACKAGE PAY_IE_P35_MAGTAPE AUTHID CURRENT_USER AS
2: /* $Header: pyiep35m.pkh 120.8.12020000.4 2013/02/04 11:46:54 rsahai ship $ */
3:
4: l_arc_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
5: level_cnt NUMBER;

Line 15: SELECT ('P35_MODE=P'), trim(pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'MODE')),

11:
12: FUNCTION get_end_date RETURN DATE;
13:
14: CURSOR CSR_P35_HEADER_FOOTER IS
15: SELECT ('P35_MODE=P'), trim(pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'MODE')),
16: ('END_DATE=P'), pay_ie_p35.get_parameter(ppa.payroll_action_id,'END_DATE'),
17: ('EFFECTIVE_DATE=P'),to_char(ppa.effective_date,'dd-mm-yyyy'),
18: ('EMPLOYER_NUMBER=P'), pact.action_information1,
19: ('EMPLOYER_NAME=P'), pact.action_information26 ,

Line 16: ('END_DATE=P'), pay_ie_p35.get_parameter(ppa.payroll_action_id,'END_DATE'),

12: FUNCTION get_end_date RETURN DATE;
13:
14: CURSOR CSR_P35_HEADER_FOOTER IS
15: SELECT ('P35_MODE=P'), trim(pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'MODE')),
16: ('END_DATE=P'), pay_ie_p35.get_parameter(ppa.payroll_action_id,'END_DATE'),
17: ('EFFECTIVE_DATE=P'),to_char(ppa.effective_date,'dd-mm-yyyy'),
18: ('EMPLOYER_NUMBER=P'), pact.action_information1,
19: ('EMPLOYER_NAME=P'), pact.action_information26 ,
20: ('TRADE_NAME=P'), pact.action_information9,

Line 27: --('WEEKS_53=P') , decode(trim(pay_ie_p35.get_parameter(ppa.payroll_action_id,'WEEKS')),'Y','1','0'),

23: ('EMPLOYER_ADDRESS3=P'),pact.action_information7 ,
24: ('CONTACT_NAME=P'), pact.action_information27 ,
25: ('CONTACT_NUMBER=P'), pact.action_information28 ,
26: ('FAX_NO=P'), pact.action_information10,
27: --('WEEKS_53=P') , decode(trim(pay_ie_p35.get_parameter(ppa.payroll_action_id,'WEEKS')),'Y','1','0'),
28: ('WEEKS_53=P') , decode(trim(pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'WEEKS')),'Y','1','0'), --8233782
29: ('REQUEST_ID=P'), to_char(ppa.request_id),
30: ('SUBMISSION_TYPE=P'),pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'SUB_TYPE') /*Added for bug fix 3815830*/
31: FROM pay_payroll_actions ppa

Line 28: ('WEEKS_53=P') , decode(trim(pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'WEEKS')),'Y','1','0'), --8233782

24: ('CONTACT_NAME=P'), pact.action_information27 ,
25: ('CONTACT_NUMBER=P'), pact.action_information28 ,
26: ('FAX_NO=P'), pact.action_information10,
27: --('WEEKS_53=P') , decode(trim(pay_ie_p35.get_parameter(ppa.payroll_action_id,'WEEKS')),'Y','1','0'),
28: ('WEEKS_53=P') , decode(trim(pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'WEEKS')),'Y','1','0'), --8233782
29: ('REQUEST_ID=P'), to_char(ppa.request_id),
30: ('SUBMISSION_TYPE=P'),pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'SUB_TYPE') /*Added for bug fix 3815830*/
31: FROM pay_payroll_actions ppa
32: ,pay_action_information pact

Line 30: ('SUBMISSION_TYPE=P'),pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'SUB_TYPE') /Added for bug fix 3815830/

26: ('FAX_NO=P'), pact.action_information10,
27: --('WEEKS_53=P') , decode(trim(pay_ie_p35.get_parameter(ppa.payroll_action_id,'WEEKS')),'Y','1','0'),
28: ('WEEKS_53=P') , decode(trim(pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'WEEKS')),'Y','1','0'), --8233782
29: ('REQUEST_ID=P'), to_char(ppa.request_id),
30: ('SUBMISSION_TYPE=P'),pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'SUB_TYPE') /*Added for bug fix 3815830*/
31: FROM pay_payroll_actions ppa
32: ,pay_action_information pact
33:
34: WHERE pact.action_context_id = ppa.payroll_action_id

Line 48: AND PAA.TAX_UNIT_ID = pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'EMP_NO'));

44: and arc_paa.assignment_action_id= pai.locked_action_id)
45: --16210193
46: AND EXISTS ( SELECT 1 FROM PAY_ASSIGNMENT_ACTIONS PAA
47: WHERE PAA.payroll_action_id = ppa.payroll_action_id
48: AND PAA.TAX_UNIT_ID = pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'EMP_NO'));
49: --16210193
50:
51: /* Modified the cursor for BUG 2987230 */
52: CURSOR CSR_P35_DETAIL IS

Line 179: END pay_ie_p35_magtape;

175:
176: -- for bug 6275544
177: FUNCTION test_XML(P_STRING VARCHAR2) RETURN VARCHAR2;
178:
179: END pay_ie_p35_magtape;