1 PACKAGE pay_us_deposit_advice_pkg AS
2 /* $Header: payuslivearchive.pkh 120.2.12010000.4 2009/01/21 08:28:03 sudedas ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
7 * Chertsey, England. *
8 * *
9 * All rights reserved. *
10 * *
11 * This material has been provided pursuant to an agreement *
12 * containing restrictions on its use. The material is also *
13 * protected by copyright law. No part of this material may *
14 * be copied or distributed, transmitted or transcribed, in *
15 * any form or by any means, electronic, mechanical, magnetic, *
16 * manual, or otherwise, or disclosed to third parties without *
17 * the express written permission of Oracle Corporation UK Ltd, *
18 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
19 * England. *
20 * *
21 ******************************************************************
22
23 Change List
24 -----------
25 Date Name Vers Bug No Description
26 ----------- ---------- ----- ------- -----------------------------------
27 08-Jun-04 rmonge 115.0 Created.
28 This package is a copy of
29 pyusdar.pkh. Please refer
30 to the old package header
31 for history of changes.
32 5-Jul-04 schauhan 115.1 3512116 Added function check_if_assignment_paid.
33 This is added for eliminating cursor
34 c_actions_zero_pay.
35 24-May-07 sudedas 115.2 5635335 Added procedure archive_deinit
36 to be used by New Deposit Advice (PDF)
37 27-Jun-2007 sudedas 115.3 Added Qualifying Procedure and Function
38 check_if_qualified_for_US. This is for
39 Archive Deposit Advice producing XML
40 using Global Payslip Printing Solution.
41 15-Jan-2009 sudedas 115.4 7583387 Added function DAxml_range_cursor
42 and package level global variables for
43 DA(XML) payroll action level legislative
44 parameters and a global plsql table.
45 21-Jan-2009 sudedas 115.5 7583387 Changed Function DAxml_range_cursor
46 to Procedure.
47 115.6 7583387 Added NOCOPY hint for OUT variable.
48 --
49 */
50 PROCEDURE range_cursor(pactid in number
51 ,sqlstr out NOCOPY varchar2);
52
53 FUNCTION check_if_assignment_paid(p_prepayment_action_id in number,
54 p_deposit_start_date in date,
55 p_deposit_end_date in date,
56 p_consolidation_set_id in number)
57 RETURN VARCHAR2;
58
59
60 PROCEDURE archive_action_creation(pactid in number,
61 stperson in number,
62 endperson in number,
63 chunk in number);
64
65 PROCEDURE sort_action(procname in varchar2,
66 sqlstr in out NOCOPY varchar2,
67 len out NOCOPY number);
68
69 procedure action_creation ( pactid in number,
70 stperson in number,
71 endperson in number,
72 chunk in number
73 );
74 -- Procedure will be used for de-initialization of Deposit Advice (PDF) Process
75 procedure archive_deinit(pactid in number) ;
76
77 PROCEDURE qualifying_proc(p_assignment_id IN NUMBER
78 ,p_qualifier OUT NOCOPY VARCHAR2 ) ;
79 --
80 --
81 FUNCTION check_if_qualified_for_US(p_archive_action_id IN NUMBER
82 ,p_assignment_id IN NUMBER
83 ,p_deposit_start_date IN DATE
84 ,p_deposit_end_date IN DATE
85 ,p_consolidation_set_id IN NUMBER)
86 RETURN VARCHAR2;
87 --
88 --
89 --
90
91 PROCEDURE DAxml_range_cursor(pactid in number
92 ,psqlstr out NOCOPY varchar2);
93 --
94 --
95 g_payroll_act_id NUMBER := -1;
96 g_payroll_id NUMBER := -1;
97 g_consolidation_set_id NUMBER := -1;
98 g_start_dt DATE := TO_DATE('0001/01/01','YYYY/MM/DD');
99 g_end_dt DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
100 g_rep_group pay_report_groups.report_group_name%TYPE := NULL;
101 g_rep_category pay_report_categories.category_name%TYPE := NULL;
102 g_assignment_set_id NUMBER := -1;
103 g_assignment_id NUMBER := -1;
104 g_effective_date DATE := TO_DATE('0001/01/01','YYYY/MM/DD');
105 g_business_group_id NUMBER := -1;
106 g_legislation_code VARCHAR2(10) := 'XX';
107
108 TYPE typ_tmp_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
109 g_tmp_tbl typ_tmp_tbl;
110 --
111 --
112 END pay_us_deposit_advice_pkg;