1 PACKAGE ben_create_ptnl_ler_ss AUTHID CURRENT_USER AS
2 /* $Header: belerwrs.pkh 115.4 2002/12/30 18:53:57 rpillay noship $*/
3
4 gv_wf_review_region_item constant wf_item_attributes.name%type
5 := 'HR_REVIEW_REGION_ITEM';
6
7 --This is a overloaded procedure which will call the actual wrapper
8
9
10 PROCEDURE create_ptnl_ler_for_per
11 (p_validate in varchar2 default 'N'
12 ,p_ptnl_ler_for_per_id out nocopy varchar2
13 ,p_csd_by_ptnl_ler_for_per_id in varchar2 default null
14 ,p_lf_evt_ocrd_dt in out nocopy varchar2
15 ,p_ptnl_ler_for_per_stat_cd in varchar2 default null
16 ,p_ptnl_ler_for_per_src_cd in varchar2 default null
17 ,p_mnl_dt in varchar2 default null
18 ,p_enrt_perd_id in varchar2 default null
19 ,p_ler_id in varchar2 default null
20 ,p_person_id in varchar2 default null
21 ,p_business_group_id in varchar2 default null
22 ,p_dtctd_dt in varchar2 default null
23 ,p_procd_dt in varchar2 default null
24 ,p_unprocd_dt in varchar2 default null
25 ,p_voidd_dt in varchar2 default null
26 ,p_mnlo_dt in varchar2 default null
27 ,p_ntfn_dt in varchar2 default null
28 ,p_request_id in varchar2 default null
29 ,p_program_application_id in varchar2 default null
30 ,p_program_id in varchar2 default null
31 ,p_program_update_date in varchar2 default null
32 ,p_object_version_number out nocopy varchar2
33 ,p_effective_date in varchar2
34 ,p_item_type in varchar2
35 ,p_item_key in varchar2
36 ,p_activity_id in varchar2
37 ,p_login_person_id in varchar2 default null
38 ,P_flow_mode in varchar2
39 ,p_subflow_mode in varchar2
40 ,p_life_event_name in varchar2
41 ,p_transaction_step_id out nocopy varchar2
42 ,p_error_message out nocopy long
43 ,p_hire_dt in varchar2 default null
44 );
45
46
47
48 PROCEDURE create_ptnl_ler_for_per
49 (p_validate in varchar2 default 'N'
50 ,p_ptnl_ler_for_per_id out nocopy number
51 ,p_csd_by_ptnl_ler_for_per_id in number default null
52 ,p_lf_evt_ocrd_dt in date default null
53 ,p_ptnl_ler_for_per_stat_cd in varchar2 default null
54 ,p_ptnl_ler_for_per_src_cd in varchar2 default null
55 ,p_mnl_dt in date default null
56 ,p_enrt_perd_id in number default null
57 ,p_ler_id in number default null
58 ,p_person_id in number default null
59 ,p_business_group_id in number default null
60 ,p_dtctd_dt in date default null
61 ,p_procd_dt in date default null
62 ,p_unprocd_dt in date default null
63 ,p_voidd_dt in date default null
64 ,p_mnlo_dt in date default null
65 ,p_ntfn_dt in date default null
66 ,p_request_id in number default null
67 ,p_program_application_id in number default null
68 ,p_program_id in number default null
69 ,p_program_update_date in date default null
70 ,p_object_version_number out nocopy number
71 ,p_effective_date in date
72 ,p_item_type in varchar2
73 ,p_item_key in varchar2
74 ,p_activity_id in number
75 ,p_login_person_id in number default null
76 ,P_flow_mode in varchar2
77 ,p_subflow_mode in varchar2
78 ,p_life_event_name in varchar2
79 ,p_transaction_step_id out nocopy number
80 ,p_error_message out nocopy long
81 );
82
83
84 -- ---------------------------------------------------------------------------
85 -- ---------------------- < get_address_data_from_tt> -------------------------
86 -- ---------------------------------------------------------------------------
87 -- Purpose: This procedure will get transaction data which are pending for
88 -- approval in workflow for a transaction step id.
89 -- ---------------------------------------------------------------------------
90
91 PROCEDURE get_ptnl_ler_data_from_tt
92 (p_transaction_step_id in number
93 ,p_csd_by_ptnl_ler_for_per_id out nocopy number -- in number default null
94 ,p_lf_evt_ocrd_dt out nocopy date -- in date default null
95 ,p_ptnl_ler_for_per_stat_cd out nocopy varchar2 -- in varchar2 default null
96 ,p_ptnl_ler_for_per_src_cd out nocopy varchar2 -- in varchar2 default null
97 ,p_mnl_dt out nocopy date -- in date default null
98 ,p_enrt_perd_id out nocopy number -- in number default null
99 ,p_ler_id out nocopy number -- in number default null
100 ,p_person_id out nocopy number -- in number default null
101 ,p_business_group_id out nocopy number -- in number default null
102 ,p_dtctd_dt out nocopy date -- in date default null
103 ,p_procd_dt out nocopy date -- in date default null
104 ,p_unprocd_dt out nocopy date -- in date default null
105 ,p_voidd_dt out nocopy date -- in date default null
106 ,p_mnlo_dt out nocopy date -- in date default null
107 ,p_ntfn_dt out nocopy date -- in date default null
108 ,p_request_id out nocopy number -- in number default null
109 ,p_program_application_id out nocopy number -- in number default null
110 ,p_program_id out nocopy number -- in number default null
111 ,p_program_update_date out nocopy date -- in date default null
112 ,p_effective_date out nocopy date
113 ,p_flow_mode in varchar2
114 ,p_subflow_mode in varchar2
115 ,p_life_event_name out nocopy varchar2
116 );
117
118 -- ---------------------------------------------------------------------------
119 -- ---------------------- < get_address_data_from_tt> -------------------------
120 -- ---------------------------------------------------------------------------
121 -- Purpose: This procedure will get transaction data which are saved earlier
122 -- in the current transaction. This is invoked when a user click BACK
123 -- button to go back from the Review page to Update page to correct
124 -- typos or make further changes. Hence, we need to use the item_type
125 -- item_key passed in to retrieve the transaction record.
126 -- This is an overloaded version.
127 -- ---------------------------------------------------------------------------
128 PROCEDURE get_ptnl_ler_data_from_tt
129 (p_item_type in varchar2
130 ,p_item_key in varchar2
131 ,p_activity_id in varchar2
132 ,p_trans_rec_count out nocopy number
133 ,p_csd_by_ptnl_ler_for_per_id out nocopy number -- in number default null
134 ,p_lf_evt_ocrd_dt out nocopy date -- in date default null
135 ,p_ptnl_ler_for_per_stat_cd out nocopy varchar2 -- in varchar2 default null
136 ,p_ptnl_ler_for_per_src_cd out nocopy varchar2 -- in varchar2 default null
137 ,p_mnl_dt out nocopy date -- in date default null
138 ,p_enrt_perd_id out nocopy number -- in number default null
139 ,p_ler_id out nocopy number -- in number default null
140 ,p_person_id out nocopy number -- in number default null
141 ,p_business_group_id out nocopy number -- in number default null
142 ,p_dtctd_dt out nocopy date -- in date default null
143 ,p_procd_dt out nocopy date -- in date default null
144 ,p_unprocd_dt out nocopy date -- in date default null
145 ,p_voidd_dt out nocopy date -- in date default null
146 ,p_mnlo_dt out nocopy date -- in date default null
147 ,p_ntfn_dt out nocopy date -- in date default null
148 ,p_request_id out nocopy number -- in number default null
149 ,p_program_application_id out nocopy number -- in number default null
150 ,p_program_id out nocopy number -- in number default null
151 ,p_program_update_date out nocopy date -- in date default null
152 ,p_effective_date out nocopy date
153 ,p_flow_mode in varchar2
154 ,p_subflow_mode in varchar2
155 ,p_life_event_name out nocopy varchar2
156 );
157
158
159 /*---------------------------------------------------------------------------+
160 | |
161 | Name : process_api |
162 | |
163 | Purpose : This will procedure is invoked whenever approver |
164 | approves the address change. |
165 | |
166 +-----------------------------------------------------------------------------*/
167 PROCEDURE process_api
168 (p_validate IN BOOLEAN DEFAULT FALSE
169 ,p_transaction_step_id IN NUMBER DEFAULT NULL
170 );
171
172 procedure get_step(
173 p_item_type in varchar2
174 ,p_item_key in varchar2
175 ,p_activity_id in varchar2
176 ,p_api_name in varchar2
177 ,p_flow_mode in varchar2
178 ,p_subflow_mode in varchar2
179 ,p_transaction_step_id out nocopy number
180 ,p_object_version_number out nocopy number );
181
182
183
184 END ben_create_ptnl_ler_ss;