DBA Data[Home] [Help]

PACKAGE: APPS.PER_MX_SSAFFL_ARCHIVE

Source


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;