1 package pay_archive_missing_asg_pkg as
2 /* $Header: payusyem.pkh 120.0 2005/10/17 18:18:52 djoshi noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 2005 Oracle Corporation *
7 * *
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 --
24 Name : PAY_ARCHIVE_MISSING_ASG_PKG
25 Description : This package contains the logic for Multi-threading of the
26 Year End Archive Missing Assignments Report
27 --
28
29 Change List
30 -----------
31 Date Name Vers Bug No Description
32 ----------- ---------- ----- ------- -----------------------------------
33 10-AUG-2005 rsethupa 115.0 Created
34 16-SEP-2005 sdhole 115.1 4613898 Added g_payroll_action_id global
35 variable.
36 -------------------------------------------------------------------------------
37 */
38 procedure range_cursor ( pactid in number,
39 sqlstr out nocopy varchar2
40 );
41
42 procedure action_creation ( pactid in number,
43 stperson in number,
44 endperson in number,
45 chunk in number
46 );
47
48 Procedure ARCHIVE_DEINIT(p_payroll_action_id IN NUMBER);
49 Procedure ARCHIVE_CODE (p_assignment_action_id IN NUMBER, p_effective_date in date);
50 Procedure ARCHIVE_INIT(p_payroll_action_id IN NUMBER);
51
52 --
53 -- Global Variables
54 g_effective_date date;
55 g_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
56 g_run_balance_status varchar2(1);
57 g_session_id NUMBER;
58 g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
59
60 TYPE balance_status_rec is RECORD (attribute varchar2(100),
61 attribute_id number(15)
62 );
63 TYPE balance_status_tab is TABLE OF balance_status_rec
64 INDEX BY BINARY_INTEGER;
65
66 ltr_def_bal_status balance_status_tab;
67
68 end pay_archive_missing_asg_pkg;