[Home] [Help]
PACKAGE: APPS.PAY_JP_IWHT_ARCH_PKG
Source
1 PACKAGE pay_jp_iwht_arch_pkg AUTHID CURRENT_USER AS
2 -- $Header: pyjpiwar.pkh 120.2.12020000.2 2012/07/05 00:17:03 amnaraya ship $
3 -- *************************************************************************
4 -- * Copyright (c) Oracle Corporation Japan,2009 Product Development.
5 -- * All rights reserved
6 -- *************************************************************************
7 -- *
8 -- * PROGRAM NAME
9 -- * PAYJLWL.pkb
10 -- *
11 -- * DESCRIPTION
12 -- * This script creates the package body of PAY_JP_WL_ARCH_PKG
13 -- *
14 -- * USAGE
15 -- * To install sqlplus <apps_user>/<apps_pwd> @payjpiwhtarchpkg.pkh
16 -- * To Execute sqlplus <apps_user>/<apps_pwd> EXEC payjpiwhtarchpkg.<procedure name>
17 -- *
18 -- * PROGRAM LIST
19 -- * ==========
20 -- * NAME DESCRIPTION
21 -- * ----------------- --------------------------------------------------
22 -- * RANGE_CODE
23 -- * INITIALIZATION_CODE
24 -- * ASSIGNMENT_ACTION_CODE
25 -- * ARCHIVE_CODE
26 -- *
27 -- * DEPENDENCIES
28 -- * None
29 -- *
30 -- * CALLED BY
31 -- * Concurrent Program
32 -- *
33 -- * LAST UPDATE DATE 05-Feb-2010
34 -- * Date the program has been modified for the last time
35 -- *
36 -- * HISTORY
37 -- * =======
38 -- *
39 -- * VERSION DATE AUTHOR(S) DESCRIPTION
40 -- * ------- ----------- ----------------- -----------------------------
41 -- * 120.0.12010000.1 05-Feb-2010 MPOTHALA Creation
42 -- * 120.0.12010000.2 05-Feb-2010 MPOTHALA Added commit
43 -- *************************************************************************
44
45 TYPE parameters IS RECORD (business_group_id NUMBER
46 ,effective_date DATE
47 ,withholding_agent_id NUMBER
48 ,payroll_id NUMBER
49 ,termination_date_from DATE
50 ,termination_date_to DATE
51 ,assignment_set_id NUMBER
52 ,rearchive_flag VARCHAR2(10)
53 );
54 --
55 gr_parameters parameters;
56 --
57 --+=====================================================================+
58 --| |
59 --|Name : range_code |
60 --| |
61 --|Description : This is the range code |
62 --| |
63 --|Parameters : |
64 --| |
65 --| p_payroll_action_id IN NUMBER |
66 --| p_sql OUT VARCHAR2 |
67 --+=====================================================================+
68 PROCEDURE range_code
69 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
70 ,p_sql out NOCOPY varchar2
71 );
72 --+=====================================================================+
73 --| |
74 --|Name : initialization_code |
75 --| |
76 --|Description : This is the initialization_code procedure |
77 --| |
78 --|Parameters : |
79 --| |
80 --| p_payroll_action_id IN NUMBER |
81 --+=====================================================================+
82 PROCEDURE initialization_code
83 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
84 --+=====================================================================+
85 --| |
86 --|Name : assignment_action_code |
87 --| |
88 --|Description : This is the assignment_action_code procedure |
89 --| |
90 --|Parameters : |
91 --| |
92 --| p_payroll_action_id IN NUMBER |
93 --| p_start_person IN NUMBER |
94 --| p_end_oerson IN NUMBER |
95 --| p_chunk IN NUMBER |
96 --+=====================================================================+
97 PROCEDURE assignment_action_code
98 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
99 ,p_start_person in per_all_people_f.person_id%type
100 ,p_end_person in per_all_people_f.person_id%type
101 ,p_chunk in number
102 );
103 --+=====================================================================+
104 --| |
105 --|Name : archive_code |
106 --| |
107 --|Description : This is the archive_code procedure |
108 --| |
109 --|Parameters : |
110 --| |
111 --| p_assignment_action_id IN NUMBER |
112 --| p_payroll_action_id IN NUMBER |
113 --| p_effective_date IN DATE |
114 --+=====================================================================+
115 PROCEDURE archive_code
116 (
117 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
118 ,p_effective_date in pay_payroll_actions.effective_date%type
119 );
120 --+=====================================================================+
121 --| |
122 --|Name : get_with_hold_agent |
123 --| |
124 --|Description : This is the get_with_hold_agent procedure |
125 --| |
126 --|Parameters : |
127 --| |
128 --| p_assignment_id IN NUMBER |
129 --+=====================================================================+
130 FUNCTION get_with_hold_agent(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
131 ,p_effective_date IN DATE)
132 RETURN NUMBER;
133 --
134 --+=====================================================================+
135 --| |
136 --|Name : deinitialize_code |
137 --| |
138 --|Description : This is the deinitialise_code procedure |
139 --| |
140 --|Parameters : |
141 --| |
142 --| p_payroll_action_id IN NUMBER |
143 --+=====================================================================+
144 PROCEDURE deinitialize_code (p_payroll_action_id IN NUMBER);
145 --
146 END pay_jp_iwht_arch_pkg;