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_IE_P35_MAGTAPE dependencies on PAY_IE_P35

Line 1: PACKAGE PAY_IE_P35_MAGTAPE AS

1: PACKAGE PAY_IE_P35_MAGTAPE AS
2: /* $Header: pyiep35m.pkh 120.4.12010000.1 2008/07/27 22:50:10 appldev 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: ('REQUEST_ID=P'), to_char(ppa.request_id),
29: ('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*/
30: FROM pay_payroll_actions ppa
31: ,pay_action_information pact

Line 29: ('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/

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: ('REQUEST_ID=P'), to_char(ppa.request_id),
29: ('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*/
30: FROM pay_payroll_actions ppa
31: ,pay_action_information pact
32:
33: WHERE pact.action_context_id = ppa.payroll_action_id

Line 152: END pay_ie_p35_magtape;

148:
149: -- for bug 6275544
150: FUNCTION test_XML(P_STRING VARCHAR2) RETURN VARCHAR2;
151:
152: END pay_ie_p35_magtape;