[Home] [Help]
PACKAGE: APPS.PAY_DIRECT_DEPOSIT_XML
Source
1 PACKAGE PAY_DIRECT_DEPOSIT_XML AUTHID CURRENT_USER as
2 /* $Header: payddxml.pkh 120.3 2006/02/10 12:13 vpandya noship $ */
3
4 /* +======================================================================+
5 | Copyright (c) 2003 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +======================================================================+
9 Package Name : pay_direct_deposit_xml
10 Package File Name : payddxml.pkh
11
12 Description : Used for Direct Deposit Extract
13
14 Change List:
15 ------------
16
17 Name Date Version Bug Text
18 ------------- ----------- ------- ------- ------------------------------
19 sodhingr 20-Jul-2005 115.0 Initial Version
20 vmehta 16-Sep-2005 115.1 Modified the cursor so that the
21 dates are stored in canonical
22 format.
23 sdahiya 20-Dec-2005 115.2 Dynamically fetch IANA charset
24 to identify XML encoding.
25 sdahiya 22-Dec-2005 115.3 Removed XML header information.
26 PYUGEN will generate XML headers.
27 vpandya 10-Feb-2006 115.4 5032348 Changed cursor c_get_details
28 added alias payroll_action_id
29 column as this column has newly
30 been created for
31 pay_pre_payments table also.
32 ========================================================================*/
33
34 CURSOR main_block IS
35 SELECT 'ROOT_XML_TAG=P',
36 '<DIRECT_DEPOSIT>'
37 FROM dual;
38
39
40 CURSOR c_get_header IS
41 select distinct 'PAYROLL_ACTION_ID=C',ppa.payroll_action_id,
42 'TRANSFER_PAYROLL_ACTION_ID=P',ppa.payroll_action_id,
43 'TRANSFER_DD_DATE=P',
44 fnd_date.date_to_canonical(nvl(overriding_dd_date
45 ,ppa.effective_date)),
46 'TRANSFER_BUSINESS_GROUP_ID=P',business_group_id,
47 'TRANSFER_EFFECTIVE_DATE=P',
48 fnd_date.date_to_canonical(ppa.effective_date),
49 'TRANSFER_ORG_PAY_METHOD=P',ppa.org_payment_method_id
50 from pay_payroll_actions ppa
51 where ppa.payroll_action_id =
52 pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
53 --and ppa.payroll_action_id = paa.payroll_action_id
54 --group by tax_unit_id,ppa.payroll_action_id, ppa.effective_date,
55 --ppa.org_payment_method_id;
56
57
58
59 CURSOR c_get_details IS
60 SELECT 'TRANSFER_ACT_ID=P',paa.assignment_action_id,
61 'TRANSFER_ASSIGNMENT_ID=P', assignment_id,
62 'TRANSFER_PERSONAL_PAY_METH=P',ppp.personal_payment_method_id,
63 'TRANSFER_PRE_PAY_ID=P',ppp.pre_payment_id,
64 'TRANSFER_PREPAY_ASG_ACT=P',ppp.assignment_action_id,
65 'DEPOSIT_AMOUNT=P', ppp.value
66 FROM pay_assignment_actions paa
67 ,pay_pre_payments ppp
68 WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value(
69 'PAYROLL_ACTION_ID')
70 and paa.pre_payment_id = ppp.pre_payment_id;
71
72 CURSOR c_get_asg_action IS
73 SELECT 'TRANSFER_ACT_ID=P',
74 pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
75 FROM DUAL;
76
77
78 PROCEDURE get_headers ;
79 PROCEDURE generate_xml;
80 PROCEDURE get_deposit_header;
81 PROCEDURE get_footers;
82 PROCEDURE get_deposit_footer;
83
84 level_cnt NUMBER :=0;
85
86 END pay_direct_deposit_xml;