APPS.PQH_RAP_INS dependencies on PQH_RAP_INS

Line 1: Package Body pqh_rap_ins as

1: Package Body pqh_rap_ins as
2: /* $Header: pqraprhi.pkb 120.0 2005/05/29 02:24 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package constant varchar2(33) := ' pqh_rap_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package constant varchar2(33) := ' pqh_rap_ins.'; -- Global package name
9: --
10: -- The following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 27: pqh_rap_ins.g_rank_process_approval_id_i := p_rank_process_approval_id;

23: Begin
24:
25: hr_utility.set_location('Entering:'||l_proc, 10);
26: --
27: pqh_rap_ins.g_rank_process_approval_id_i := p_rank_process_approval_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
30: End set_base_key_value;
31: --

Line 183: pqh_rap_ins.g_rank_process_approval_id_i;

179: Cursor C_Sel2 is
180: Select null
181: from pqh_rank_process_approvals
182: where rank_process_approval_id =
183: pqh_rap_ins.g_rank_process_approval_id_i;
184: --
185: l_proc constant varchar2(72):= g_package||'pre_insert';
186: l_exists varchar2(1);
187: --

Line 192: If (pqh_rap_ins.g_rank_process_approval_id_i is not null) Then

188: Begin
189:
190: hr_utility.set_location('Entering:'||l_proc, 5);
191: --
192: If (pqh_rap_ins.g_rank_process_approval_id_i is not null) Then
193: --
194: -- Verify registered primary key values not already in use
195: --
196: Open C_Sel2;

Line 212: pqh_rap_ins.g_rank_process_approval_id_i;

208: --
209: -- Use registered key values and clear globals
210: --
211: p_rec.rank_process_approval_id :=
212: pqh_rap_ins.g_rank_process_approval_id_i;
213: pqh_rap_ins.g_rank_process_approval_id_i := null;
214: Else
215: --
216: -- No registerd key values, so select the next sequence number

Line 213: pqh_rap_ins.g_rank_process_approval_id_i := null;

209: -- Use registered key values and clear globals
210: --
211: p_rec.rank_process_approval_id :=
212: pqh_rap_ins.g_rank_process_approval_id_i;
213: pqh_rap_ins.g_rank_process_approval_id_i := null;
214: Else
215: --
216: -- No registerd key values, so select the next sequence number
217: --

Line 332: pqh_rap_ins.pre_insert(p_rec);

328: hr_multi_message.end_validation_set;
329: --
330: -- Call the supporting pre-insert operation
331: --
332: pqh_rap_ins.pre_insert(p_rec);
333: --
334: -- Insert the row
335: --
336: pqh_rap_ins.insert_dml(p_rec);

Line 336: pqh_rap_ins.insert_dml(p_rec);

332: pqh_rap_ins.pre_insert(p_rec);
333: --
334: -- Insert the row
335: --
336: pqh_rap_ins.insert_dml(p_rec);
337: --
338: -- Call the supporting post-insert operation
339: --
340: pqh_rap_ins.post_insert

Line 340: pqh_rap_ins.post_insert

336: pqh_rap_ins.insert_dml(p_rec);
337: --
338: -- Call the supporting post-insert operation
339: --
340: pqh_rap_ins.post_insert
341: (p_effective_date
342: ,p_rec
343: );
344: --

Line 391: pqh_rap_ins.ins

387: --
388: -- Having converted the arguments into the pqh_rap_rec
389: -- plsql record structure we call the corresponding record business process.
390: --
391: pqh_rap_ins.ins
392: (p_effective_date
393: ,l_rec
394: );
395: --

Line 405: end pqh_rap_ins;

401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
403: End ins;
404: --
405: end pqh_rap_ins;