1 PACKAGE pay_arch_missing_asg_pkg AS
2 /* $Header: pymissarch.pkh 120.0.12000000.1 2007/01/17 22:44:30 appldev noship $ */
3 /******************************************************************************
4
5 ******************************************************************
6 * *
7 * Copyright (C) 1996 Oracle Corporation. *
8 * All rights reserved. *
9 * *
10 * This material has been provided pursuant to an agreement *
11 * containing restrictions on its use. The material is also *
12 * protected by copyright law. No part of this material may *
13 * be copied or distributed, transmitted or transcribed, in *
14 * any form or by any means, electronic, mechanical, magnetic, *
15 * manual, or otherwise, or disCLOSEd to third parties without *
16 * the express written permission of Oracle Corporation, *
17 * 500 Oracle Parkway, Redwood City, CA, 94065. *
18 * *
19 ******************************************************************
20
21 --
22 Name : PAY_ARCH_MISSING_ASG_PKG
23 Description : This package contains the logic for Multi-threading of the
24 Year End Archive Missing Assignments Report
25 --
26
27 Change List
28 -----------
29 Date Name Vers Bug No Description
30 ----------- ---------- ------- ------- ------------------------------
31 25-OCT-2005 rdhingra 115.0 4674183 Code transferred from
32 payusyem.pkh.
33
34
35 ******************************************************************************/
36 procedure range_cursor ( pactid in number,
37 sqlstr out nocopy varchar2
38 );
39
40 procedure action_creation ( pactid in number,
41 stperson in number,
42 endperson in number,
43 chunk in number
44 );
45
46 Procedure ARCHIVE_DEINIT(p_payroll_action_id IN NUMBER);
47 Procedure ARCHIVE_CODE (p_assignment_action_id IN NUMBER, p_effective_date in date);
48 Procedure ARCHIVE_INIT(p_payroll_action_id IN NUMBER);
49
50 --
51 -- Global Variables
52 g_effective_date date;
53 g_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
54 g_run_balance_status varchar2(1);
55 g_session_id NUMBER;
56 g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
57
58 TYPE balance_status_rec is RECORD (attribute varchar2(100),
59 attribute_id number(15)
60 );
61 TYPE balance_status_tab is TABLE OF balance_status_rec
62 INDEX BY BINARY_INTEGER;
63
64 ltr_def_bal_status balance_status_tab;
65
66 END pay_arch_missing_asg_pkg;