DBA Data[Home] [Help]

PACKAGE: APPS.PAY_IN_EOY_ARCHIVE

Source


1 PACKAGE pay_in_eoy_archive AUTHID CURRENT_USER AS
2 /* $Header: pyinpeoy.pkh 120.0.12010000.1 2008/07/27 22:53:55 appldev ship $ */
3    TYPE t_asg_rec IS RECORD
4           (gre_id       NUMBER
5           ,start_date   DATE
6           ,end_date     DATE
7           );
8 
9    TYPE t_asg_tab IS TABLE OF t_asg_rec
10    INDEX BY BINARY_INTEGER;
11 
12    TYPE t_gre_rec IS RECORD
13           (gre_id       NUMBER
14           );
15 
16    TYPE t_gre_tab IS TABLE OF t_asg_rec
17    INDEX BY BINARY_INTEGER;
18 
19    TYPE t_bal_name_rec IS RECORD
20    (
21         balance_name VARCHAR2(240)
22    );
23 
24    TYPE t_bal_name_tab IS TABLE OF t_bal_name_rec
25    INDEX BY BINARY_INTEGER;
26   -------------------------------------------------------------------------
27   -- These are PUBLIC procedures that are required by the Archive process.
28   -- There names are stored in PAY_REPORT_FORMAT_MAPPINGS_F so that
29   -- the archive process knows what code to execute for each step of
30   -- the archive.
31   --------------------------------------------------------------------------
32 
33   --------------------------------------------------------------------------
34   --                                                                      --
35   -- Name           : RANGE_CODE                                          --
36   -- Type           : PROCEDURE                                           --
37   -- Access         : Public                                              --
38   -- Description    : This procedure returns a sql string to select a     --
39   --                  range of assignments eligible for archival.         --
40   --                                                                      --
41   -- Parameters     :                                                     --
42   --             IN : p_payroll_action_id    NUMBER                       --
43   --            OUT : p_sql                  VARCHAR2                     --
44   --                                                                      --
45   --------------------------------------------------------------------------
46   --
47 
48   PROCEDURE range_code
49     (
50       p_payroll_action_id    IN  NUMBER
51      ,p_sql                  OUT NOCOPY VARCHAR2
52     );
53   --
54 
55   --------------------------------------------------------------------------
56   --                                                                      --
57   -- Name           : INITIALIZATION_CODE                                 --
58   -- Type           : PROCEDURE                                           --
59   -- Access         : Public                                              --
60   -- Description    : This procedure is used to set global contexts       --
61   --                  Here It is used to archive the data at payroll      --
62   --                  action level.                                       --
63   --                                                                      --
64   -- Parameters     :                                                     --
65   --             IN : p_payroll_action_id    NUMBER                       --
66   --            OUT : N/A                                                 --
67   --------------------------------------------------------------------------
68   --
69   PROCEDURE initialization_code
70     (
71       p_payroll_action_id    IN  NUMBER
72     );
73   --
74 
75   --------------------------------------------------------------------------
76   --                                                                      --
77   -- Name           : ASSIGNMENT_ACTION_CODE                              --
78   -- Type           : PROCEDURE                                           --
79   -- Access         : Public                                              --
80   -- Description    : This procedure further restricts the assignment_id's--
81   --                  returned by range_code                              --
82   --                                                                      --
83   -- Parameters     :                                                     --
84   --             IN : p_payroll_action_id    NUMBER                       --
85   --                  p_start_person         NUMBER                       --
86   --                  p_end_person           NUMBER                       --
87   --                  p_chunk                NUMBER                       --
88   --            OUT : N/A                                                 --
89   --------------------------------------------------------------------------
90   --
91 
92   PROCEDURE assignment_action_code
93     (
94       p_payroll_action_id    IN  NUMBER
95      ,p_start_person         IN  NUMBER
96      ,p_end_person           IN  NUMBER
97      ,p_chunk                IN  NUMBER
98     );
99   --
100 
101   --------------------------------------------------------------------------
102   --                                                                      --
103   -- Name           : ARCHIVE_CODE                                        --
104   -- Type           : PROCEDURE                                           --
105   -- Access         : Public                                              --
106   -- Description    : This procedure is actually used to archive data . It--
107   --                  internally calls private procedures to archive      --
108   --                  balances,employee details, employer details,        --
109   --                  elements,absences and accruals etc.                 --
110   --                                                                      --
111   -- Parameters     :                                                     --
112   --             IN : p_assignment_action_id    NUMBER                    --
113   --                  p_effective_date          DATE                      --
114   --            OUT : N/A                                                 --
115   --------------------------------------------------------------------------
116   --
117 
118   PROCEDURE archive_code
119     (
120       p_assignment_action_id IN  NUMBER
121      ,p_effective_date       IN  DATE
122     );
123 
124 END pay_in_eoy_archive;