1 PACKAGE per_mx_ssaffl_archive AUTHID CURRENT_USER AS
2 /* $Header: pemxafar.pkh 120.0.12000000.1 2007/01/22 00:14:40 appldev ship $ */
3 --
4 /*
5 /*
6 ******************************************************************
7 * *
8 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
9 * Chertsey, England. *
10 * *
11 * All rights reserved. *
12 * *
13 * This material has been provided pursuant to an agreement *
14 * containing restrictions on its use. The material is also *
15 * protected by copyright law. No part of this material may *
16 * be copied or distributed, transmitted or transcribed, in *
17 * any form or by any means, electronic, mechanical, magnetic, *
18 * manual, or otherwise, or disclosed to third parties without *
19 * the express written permission of Oracle Corporation UK Ltd, *
20 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
21 * England. *
22 * *
23 ******************************************************************
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ----------- ---------- ----- ------- -----------------------------------
29 03-MAY-2004 kthirmiy 115.0 Created.
30 16-JUL-2004 kthirmiy 115.1 Added t_int_asg_event_rec and
31 t_int_asg_event_table.
32 Added new function get_start_date
33 to return the archive run start date.
34 02-AUG-2004 kthirmiy 115.2 Removed t_details_table type.
35 02-AUG-2004 kthirmiy 115.3 Added Invalid_rec_flag.
36 05-AUG-2004 kthirmiy 115.4 Removed Invlaid_rec_flag.
37 07-Jan-2005 kthirmiy 115.5 4104743 Added a new function get_default_imp_date
38 to return the default Implementation date
39 from pay_mx_legislation_info_f table.
40 20-Jan-2005 ardsouza 115.6 4129001 Added p_business_group_id parameter to
41 procedure "derive_gre_from_loc_scl".
42
43 */
44 --
45
46 FUNCTION get_default_imp_date
47 RETURN VARCHAR2 ;
48
49 FUNCTION get_start_date( p_legal_emp_id IN VARCHAR2
50 ,p_tran_gre_id IN VARCHAR2
51 ,p_gre_id IN VARCHAR2
52 ) RETURN VARCHAR2 ;
53
54
55 PROCEDURE get_payroll_action_info(p_payroll_action_id IN NUMBER
56 ,p_start_date OUT NOCOPY DATE
57 ,p_end_date OUT NOCOPY DATE
58 ,p_business_group_id OUT NOCOPY NUMBER
59 ,p_tran_gre_id OUT NOCOPY NUMBER
60 ,p_gre_id OUT NOCOPY NUMBER
61 ,p_event_group_id OUT NOCOPY NUMBER
62 );
63
64 PROCEDURE range_cursor(p_payroll_action_id IN NUMBER
65 ,p_sqlstr OUT NOCOPY VARCHAR2);
66
67 PROCEDURE action_creation(p_payroll_action_id IN NUMBER
68 ,p_start_assignment_id IN NUMBER
69 ,p_end_assignment_id IN NUMBER
70 ,p_chunk IN NUMBER);
71
72 PROCEDURE archive_data(p_assignment_action_id IN NUMBER
73 ,p_effective_date IN DATE);
74
75
76 PROCEDURE archinit(p_payroll_action_id IN NUMBER);
77
78 FUNCTION derive_gre_from_loc_scl(
79 p_location_id IN NUMBER
80 ,p_business_group_id IN NUMBER -- Bug 4129001
81 ,p_soft_coding_keyflex_id IN NUMBER
82 ,p_effective_date IN DATE ) RETURN NUMBER ;
83
84
85 TYPE t_int_asg_event_rec IS RECORD
86 (
87 update_type pay_datetracked_events.update_type%TYPE ,
88 effective_date DATE,
89 column_name pay_event_updates.column_name%TYPE ,
90 old_value VARCHAR2(2000),
91 new_value VARCHAR2(2000),
92 column_name1 pay_event_updates.column_name%TYPE ,
93 old_value1 VARCHAR2(2000),
94 new_value1 VARCHAR2(2000)
95 );
96
97 TYPE t_int_asg_event_table IS
98 TABLE OF t_int_asg_event_rec
99 INDEX BY BINARY_INTEGER;
100
101 END per_mx_ssaffl_archive;