APPS.HR_TRN_UPD dependencies on HR_API

Line 65: -- Update the hr_api_transactions Row

61: --
62: --
63: hr_trn_shd.g_api_dml := true; -- Set the api dml status
64: --
65: -- Update the hr_api_transactions Row
66: --
67: update hr_api_transactions
68: set
69: transaction_id = p_rec.transaction_id,

Line 67: update hr_api_transactions

63: hr_trn_shd.g_api_dml := true; -- Set the api dml status
64: --
65: -- Update the hr_api_transactions Row
66: --
67: update hr_api_transactions
68: set
69: transaction_id = p_rec.transaction_id,
70: creator_person_id = p_rec.creator_person_id,
71: transaction_privilege = p_rec.transaction_privilege,

Line 106: When hr_api.check_integrity_violated Then

102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: --
105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
109: hr_trn_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
109: hr_trn_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
114: hr_trn_shd.constraint_error

Line 111: When hr_api.parent_integrity_violated Then

107: -- A check constraint has been violated
108: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
109: hr_trn_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
114: hr_trn_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
114: hr_trn_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
119: hr_trn_shd.constraint_error

Line 116: When hr_api.unique_integrity_violated Then

112: -- Parent integrity has been violated
113: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
114: hr_trn_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
119: hr_trn_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
119: hr_trn_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
123: Raise;
124: End update_dml;

Line 269: If (p_rec.creator_person_id = hr_api.g_number) then

265: -- p_rec plsql record structure
266: -- to see if a system default is being used. If a system default
267: -- is being used then we must set to the 'current' argument value.
268: --
269: If (p_rec.creator_person_id = hr_api.g_number) then
270: p_rec.creator_person_id :=
271: hr_trn_shd.g_old_rec.creator_person_id;
272: End If;
273: If (p_rec.transaction_privilege = hr_api.g_varchar2) then

Line 273: If (p_rec.transaction_privilege = hr_api.g_varchar2) then

269: If (p_rec.creator_person_id = hr_api.g_number) then
270: p_rec.creator_person_id :=
271: hr_trn_shd.g_old_rec.creator_person_id;
272: End If;
273: If (p_rec.transaction_privilege = hr_api.g_varchar2) then
274: p_rec.transaction_privilege :=
275: hr_trn_shd.g_old_rec.transaction_privilege;
276: End If;
277: --

Line 296: If (p_rec.creator_person_id = hr_api.g_number) then

292: -- p_rec plsql record structure
293: -- to see if a system default is being used. If a system default
294: -- is being used then we must set to the 'current' argument value.
295: --
296: If (p_rec.creator_person_id = hr_api.g_number) then
297: p_rec.creator_person_id :=
298: hr_trn_shd.g_old_rec.creator_person_id;
299: End If;
300: If (p_rec.transaction_privilege = hr_api.g_varchar2) then

Line 300: If (p_rec.transaction_privilege = hr_api.g_varchar2) then

296: If (p_rec.creator_person_id = hr_api.g_number) then
297: p_rec.creator_person_id :=
298: hr_trn_shd.g_old_rec.creator_person_id;
299: End If;
300: If (p_rec.transaction_privilege = hr_api.g_varchar2) then
301: p_rec.transaction_privilege :=
302: hr_trn_shd.g_old_rec.transaction_privilege;
303: End If;
304: If (p_rec.product_code = hr_api.g_varchar2) then

Line 304: If (p_rec.product_code = hr_api.g_varchar2) then

300: If (p_rec.transaction_privilege = hr_api.g_varchar2) then
301: p_rec.transaction_privilege :=
302: hr_trn_shd.g_old_rec.transaction_privilege;
303: End If;
304: If (p_rec.product_code = hr_api.g_varchar2) then
305: p_rec.product_code :=
306: hr_trn_shd.g_old_rec.product_code;
307: End If;
308: If (p_rec.url = hr_api.g_varchar2) then

Line 308: If (p_rec.url = hr_api.g_varchar2) then

304: If (p_rec.product_code = hr_api.g_varchar2) then
305: p_rec.product_code :=
306: hr_trn_shd.g_old_rec.product_code;
307: End If;
308: If (p_rec.url = hr_api.g_varchar2) then
309: p_rec.url :=
310: hr_trn_shd.g_old_rec.url;
311: End If;
312: If (p_rec.status = hr_api.g_varchar2) then

Line 312: If (p_rec.status = hr_api.g_varchar2) then

308: If (p_rec.url = hr_api.g_varchar2) then
309: p_rec.url :=
310: hr_trn_shd.g_old_rec.url;
311: End If;
312: If (p_rec.status = hr_api.g_varchar2) then
313: p_rec.status :=
314: hr_trn_shd.g_old_rec.status;
315: End If;
316: If (p_rec.section_display_name = hr_api.g_varchar2) then

Line 316: If (p_rec.section_display_name = hr_api.g_varchar2) then

312: If (p_rec.status = hr_api.g_varchar2) then
313: p_rec.status :=
314: hr_trn_shd.g_old_rec.status;
315: End If;
316: If (p_rec.section_display_name = hr_api.g_varchar2) then
317: p_rec.section_display_name :=
318: hr_trn_shd.g_old_rec.section_display_name;
319: End If;
320: If (p_rec.function_id = hr_api.g_number) then

Line 320: If (p_rec.function_id = hr_api.g_number) then

316: If (p_rec.section_display_name = hr_api.g_varchar2) then
317: p_rec.section_display_name :=
318: hr_trn_shd.g_old_rec.section_display_name;
319: End If;
320: If (p_rec.function_id = hr_api.g_number) then
321: p_rec.function_id :=
322: hr_trn_shd.g_old_rec.function_id;
323: End If;
324: If (p_rec.transaction_ref_table = hr_api.g_varchar2) then

Line 324: If (p_rec.transaction_ref_table = hr_api.g_varchar2) then

320: If (p_rec.function_id = hr_api.g_number) then
321: p_rec.function_id :=
322: hr_trn_shd.g_old_rec.function_id;
323: End If;
324: If (p_rec.transaction_ref_table = hr_api.g_varchar2) then
325: p_rec.transaction_ref_table :=
326: hr_trn_shd.g_old_rec.transaction_ref_table;
327: End If;
328: If (p_rec.transaction_ref_id = hr_api.g_number) then

Line 328: If (p_rec.transaction_ref_id = hr_api.g_number) then

324: If (p_rec.transaction_ref_table = hr_api.g_varchar2) then
325: p_rec.transaction_ref_table :=
326: hr_trn_shd.g_old_rec.transaction_ref_table;
327: End If;
328: If (p_rec.transaction_ref_id = hr_api.g_number) then
329: p_rec.transaction_ref_id :=
330: hr_trn_shd.g_old_rec.transaction_ref_id;
331: End If;
332: If (p_rec.transaction_type = hr_api.g_varchar2) then

Line 332: If (p_rec.transaction_type = hr_api.g_varchar2) then

328: If (p_rec.transaction_ref_id = hr_api.g_number) then
329: p_rec.transaction_ref_id :=
330: hr_trn_shd.g_old_rec.transaction_ref_id;
331: End If;
332: If (p_rec.transaction_type = hr_api.g_varchar2) then
333: p_rec.transaction_type :=
334: hr_trn_shd.g_old_rec.transaction_type;
335: End If;
336: If (p_rec.assignment_id = hr_api.g_number) then

Line 336: If (p_rec.assignment_id = hr_api.g_number) then

332: If (p_rec.transaction_type = hr_api.g_varchar2) then
333: p_rec.transaction_type :=
334: hr_trn_shd.g_old_rec.transaction_type;
335: End If;
336: If (p_rec.assignment_id = hr_api.g_number) then
337: p_rec.assignment_id :=
338: hr_trn_shd.g_old_rec.assignment_id;
339: End If;
340: If (p_rec.api_addtnl_info = hr_api.g_varchar2) then

Line 340: If (p_rec.api_addtnl_info = hr_api.g_varchar2) then

336: If (p_rec.assignment_id = hr_api.g_number) then
337: p_rec.assignment_id :=
338: hr_trn_shd.g_old_rec.assignment_id;
339: End If;
340: If (p_rec.api_addtnl_info = hr_api.g_varchar2) then
341: p_rec.api_addtnl_info :=
342: hr_trn_shd.g_old_rec.api_addtnl_info;
343: End If;
344: If (p_rec.selected_person_id = hr_api.g_number) then

Line 344: If (p_rec.selected_person_id = hr_api.g_number) then

340: If (p_rec.api_addtnl_info = hr_api.g_varchar2) then
341: p_rec.api_addtnl_info :=
342: hr_trn_shd.g_old_rec.api_addtnl_info;
343: End If;
344: If (p_rec.selected_person_id = hr_api.g_number) then
345: p_rec.selected_person_id :=
346: hr_trn_shd.g_old_rec.selected_person_id;
347: End If;
348: If (p_rec.item_type = hr_api.g_varchar2) then

Line 348: If (p_rec.item_type = hr_api.g_varchar2) then

344: If (p_rec.selected_person_id = hr_api.g_number) then
345: p_rec.selected_person_id :=
346: hr_trn_shd.g_old_rec.selected_person_id;
347: End If;
348: If (p_rec.item_type = hr_api.g_varchar2) then
349: p_rec.item_type :=
350: hr_trn_shd.g_old_rec.item_type;
351: End If;
352: If (p_rec.item_key = hr_api.g_varchar2) then

Line 352: If (p_rec.item_key = hr_api.g_varchar2) then

348: If (p_rec.item_type = hr_api.g_varchar2) then
349: p_rec.item_type :=
350: hr_trn_shd.g_old_rec.item_type;
351: End If;
352: If (p_rec.item_key = hr_api.g_varchar2) then
353: p_rec.item_key :=
354: hr_trn_shd.g_old_rec.item_key;
355: End If;
356: If (p_rec.transaction_effective_date = hr_api.g_date) then

Line 356: If (p_rec.transaction_effective_date = hr_api.g_date) then

352: If (p_rec.item_key = hr_api.g_varchar2) then
353: p_rec.item_key :=
354: hr_trn_shd.g_old_rec.item_key;
355: End If;
356: If (p_rec.transaction_effective_date = hr_api.g_date) then
357: p_rec.transaction_effective_date :=
358: hr_trn_shd.g_old_rec.transaction_effective_date;
359: End If;
360: If (p_rec.process_name = hr_api.g_varchar2) then

Line 360: If (p_rec.process_name = hr_api.g_varchar2) then

356: If (p_rec.transaction_effective_date = hr_api.g_date) then
357: p_rec.transaction_effective_date :=
358: hr_trn_shd.g_old_rec.transaction_effective_date;
359: End If;
360: If (p_rec.process_name = hr_api.g_varchar2) then
361: p_rec.process_name :=
362: hr_trn_shd.g_old_rec.process_name;
363: End If;
364: If (p_rec.plan_id = hr_api.g_number) then

Line 364: If (p_rec.plan_id = hr_api.g_number) then

360: If (p_rec.process_name = hr_api.g_varchar2) then
361: p_rec.process_name :=
362: hr_trn_shd.g_old_rec.process_name;
363: End If;
364: If (p_rec.plan_id = hr_api.g_number) then
365: p_rec.plan_id :=
366: hr_trn_shd.g_old_rec.plan_id;
367: End If;
368: If (p_rec.rptg_grp_id = hr_api.g_number) then

Line 368: If (p_rec.rptg_grp_id = hr_api.g_number) then

364: If (p_rec.plan_id = hr_api.g_number) then
365: p_rec.plan_id :=
366: hr_trn_shd.g_old_rec.plan_id;
367: End If;
368: If (p_rec.rptg_grp_id = hr_api.g_number) then
369: p_rec.rptg_grp_id :=
370: hr_trn_shd.g_old_rec.rptg_grp_id;
371: End If;
372: If (p_rec.effective_date_option = hr_api.g_varchar2) then

Line 372: If (p_rec.effective_date_option = hr_api.g_varchar2) then

368: If (p_rec.rptg_grp_id = hr_api.g_number) then
369: p_rec.rptg_grp_id :=
370: hr_trn_shd.g_old_rec.rptg_grp_id;
371: End If;
372: If (p_rec.effective_date_option = hr_api.g_varchar2) then
373: p_rec.effective_date_option :=
374: hr_trn_shd.g_old_rec.effective_date_option;
375: End If;
376: If (p_rec.parent_transaction_id = hr_api.g_number) then

Line 376: If (p_rec.parent_transaction_id = hr_api.g_number) then

372: If (p_rec.effective_date_option = hr_api.g_varchar2) then
373: p_rec.effective_date_option :=
374: hr_trn_shd.g_old_rec.effective_date_option;
375: End If;
376: If (p_rec.parent_transaction_id = hr_api.g_number) then
377: p_rec.parent_transaction_id :=
378: hr_trn_shd.g_old_rec.parent_transaction_id;
379: End If;
380: If (p_rec.relaunch_function = hr_api.g_varchar2) then

Line 380: If (p_rec.relaunch_function = hr_api.g_varchar2) then

376: If (p_rec.parent_transaction_id = hr_api.g_number) then
377: p_rec.parent_transaction_id :=
378: hr_trn_shd.g_old_rec.parent_transaction_id;
379: End If;
380: If (p_rec.relaunch_function = hr_api.g_varchar2) then
381: p_rec.relaunch_function :=
382: hr_trn_shd.g_old_rec.relaunch_function;
383: End If;
384: If (p_rec.transaction_group = hr_api.g_varchar2) then

Line 384: If (p_rec.transaction_group = hr_api.g_varchar2) then

380: If (p_rec.relaunch_function = hr_api.g_varchar2) then
381: p_rec.relaunch_function :=
382: hr_trn_shd.g_old_rec.relaunch_function;
383: End If;
384: If (p_rec.transaction_group = hr_api.g_varchar2) then
385: p_rec.transaction_group :=
386: hr_trn_shd.g_old_rec.transaction_group;
387: End If;
388: If (p_rec.transaction_identifier = hr_api.g_varchar2) then

Line 388: If (p_rec.transaction_identifier = hr_api.g_varchar2) then

384: If (p_rec.transaction_group = hr_api.g_varchar2) then
385: p_rec.transaction_group :=
386: hr_trn_shd.g_old_rec.transaction_group;
387: End If;
388: If (p_rec.transaction_identifier = hr_api.g_varchar2) then
389: p_rec.transaction_identifier :=
390: hr_trn_shd.g_old_rec.transaction_identifier;
391: End If;
392:

Line 403: IF (p_rec.transaction_state = hr_api.g_varchar2 ) THEN

399: -- plan_id, rptg_grp_id, effective_date_option added by sanej
400: --
401: --ns start
402: -- Set the transaction state to wip if it's not a new transaction
403: IF (p_rec.transaction_state = hr_api.g_varchar2 ) THEN
404: p_rec.transaction_state := hr_trn_shd.g_old_rec.transaction_state;
405: END IF;
406: --ns end
407: --

Line 468: Raise HR_Api.Validate_Enabled;

464: --
465: -- If we are validating then raise the Validate_Enabled exception
466: --
467: If p_validate then
468: Raise HR_Api.Validate_Enabled;
469: End If;
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 10);
472: Exception

Line 473: When HR_Api.Validate_Enabled Then

469: End If;
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 10);
472: Exception
473: When HR_Api.Validate_Enabled Then
474: --
475: -- As the Validate_Enabled exception has been raised
476: -- we must rollback to the savepoint
477: --

Line 487: p_creator_person_id in number default hr_api.g_number,

483: -- ----------------------------------------------------------------------------
484: Procedure upd
485: (
486: p_transaction_id in number,
487: p_creator_person_id in number default hr_api.g_number,
488: p_transaction_privilege in varchar2 default hr_api.g_varchar2,
489: p_validate in boolean default false
490: ) is
491: --

Line 488: p_transaction_privilege in varchar2 default hr_api.g_varchar2,

484: Procedure upd
485: (
486: p_transaction_id in number,
487: p_creator_person_id in number default hr_api.g_number,
488: p_transaction_privilege in varchar2 default hr_api.g_varchar2,
489: p_validate in boolean default false
490: ) is
491: --
492: l_rec hr_trn_shd.g_rec_type;

Line 525: p_creator_person_id in number default hr_api.g_number,

521: -- ----------------------------------------------------------------------------
522: Procedure upd
523: (
524: p_transaction_id in number,
525: p_creator_person_id in number default hr_api.g_number,
526: p_transaction_privilege in varchar2 default hr_api.g_varchar2,
527: p_validate in boolean default false,
528: p_product_code in varchar2 default hr_api.g_varchar2,
529: p_url in varchar2 default hr_api.g_varchar2,

Line 526: p_transaction_privilege in varchar2 default hr_api.g_varchar2,

522: Procedure upd
523: (
524: p_transaction_id in number,
525: p_creator_person_id in number default hr_api.g_number,
526: p_transaction_privilege in varchar2 default hr_api.g_varchar2,
527: p_validate in boolean default false,
528: p_product_code in varchar2 default hr_api.g_varchar2,
529: p_url in varchar2 default hr_api.g_varchar2,
530: p_status in varchar2,

Line 528: p_product_code in varchar2 default hr_api.g_varchar2,

524: p_transaction_id in number,
525: p_creator_person_id in number default hr_api.g_number,
526: p_transaction_privilege in varchar2 default hr_api.g_varchar2,
527: p_validate in boolean default false,
528: p_product_code in varchar2 default hr_api.g_varchar2,
529: p_url in varchar2 default hr_api.g_varchar2,
530: p_status in varchar2,
531: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
532: p_section_display_name in varchar2 default hr_api.g_varchar2,

Line 529: p_url in varchar2 default hr_api.g_varchar2,

525: p_creator_person_id in number default hr_api.g_number,
526: p_transaction_privilege in varchar2 default hr_api.g_varchar2,
527: p_validate in boolean default false,
528: p_product_code in varchar2 default hr_api.g_varchar2,
529: p_url in varchar2 default hr_api.g_varchar2,
530: p_status in varchar2,
531: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
532: p_section_display_name in varchar2 default hr_api.g_varchar2,
533: p_function_id in number default hr_api.g_number,

Line 531: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns

527: p_validate in boolean default false,
528: p_product_code in varchar2 default hr_api.g_varchar2,
529: p_url in varchar2 default hr_api.g_varchar2,
530: p_status in varchar2,
531: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
532: p_section_display_name in varchar2 default hr_api.g_varchar2,
533: p_function_id in number default hr_api.g_number,
534: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
535: p_transaction_ref_id in number default hr_api.g_number,

Line 532: p_section_display_name in varchar2 default hr_api.g_varchar2,

528: p_product_code in varchar2 default hr_api.g_varchar2,
529: p_url in varchar2 default hr_api.g_varchar2,
530: p_status in varchar2,
531: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
532: p_section_display_name in varchar2 default hr_api.g_varchar2,
533: p_function_id in number default hr_api.g_number,
534: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
535: p_transaction_ref_id in number default hr_api.g_number,
536: p_transaction_type in varchar2 default hr_api.g_varchar2,

Line 533: p_function_id in number default hr_api.g_number,

529: p_url in varchar2 default hr_api.g_varchar2,
530: p_status in varchar2,
531: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
532: p_section_display_name in varchar2 default hr_api.g_varchar2,
533: p_function_id in number default hr_api.g_number,
534: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
535: p_transaction_ref_id in number default hr_api.g_number,
536: p_transaction_type in varchar2 default hr_api.g_varchar2,
537: p_assignment_id in number default hr_api.g_number,

Line 534: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,

530: p_status in varchar2,
531: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
532: p_section_display_name in varchar2 default hr_api.g_varchar2,
533: p_function_id in number default hr_api.g_number,
534: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
535: p_transaction_ref_id in number default hr_api.g_number,
536: p_transaction_type in varchar2 default hr_api.g_varchar2,
537: p_assignment_id in number default hr_api.g_number,
538: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,

Line 535: p_transaction_ref_id in number default hr_api.g_number,

531: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
532: p_section_display_name in varchar2 default hr_api.g_varchar2,
533: p_function_id in number default hr_api.g_number,
534: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
535: p_transaction_ref_id in number default hr_api.g_number,
536: p_transaction_type in varchar2 default hr_api.g_varchar2,
537: p_assignment_id in number default hr_api.g_number,
538: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
539: p_selected_person_id in number default hr_api.g_number,

Line 536: p_transaction_type in varchar2 default hr_api.g_varchar2,

532: p_section_display_name in varchar2 default hr_api.g_varchar2,
533: p_function_id in number default hr_api.g_number,
534: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
535: p_transaction_ref_id in number default hr_api.g_number,
536: p_transaction_type in varchar2 default hr_api.g_varchar2,
537: p_assignment_id in number default hr_api.g_number,
538: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
539: p_selected_person_id in number default hr_api.g_number,
540: p_item_type in varchar2 default hr_api.g_varchar2,

Line 537: p_assignment_id in number default hr_api.g_number,

533: p_function_id in number default hr_api.g_number,
534: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
535: p_transaction_ref_id in number default hr_api.g_number,
536: p_transaction_type in varchar2 default hr_api.g_varchar2,
537: p_assignment_id in number default hr_api.g_number,
538: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
539: p_selected_person_id in number default hr_api.g_number,
540: p_item_type in varchar2 default hr_api.g_varchar2,
541: p_item_key in varchar2 default hr_api.g_varchar2,

Line 538: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,

534: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
535: p_transaction_ref_id in number default hr_api.g_number,
536: p_transaction_type in varchar2 default hr_api.g_varchar2,
537: p_assignment_id in number default hr_api.g_number,
538: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
539: p_selected_person_id in number default hr_api.g_number,
540: p_item_type in varchar2 default hr_api.g_varchar2,
541: p_item_key in varchar2 default hr_api.g_varchar2,
542: p_transaction_effective_date in date default hr_api.g_date,

Line 539: p_selected_person_id in number default hr_api.g_number,

535: p_transaction_ref_id in number default hr_api.g_number,
536: p_transaction_type in varchar2 default hr_api.g_varchar2,
537: p_assignment_id in number default hr_api.g_number,
538: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
539: p_selected_person_id in number default hr_api.g_number,
540: p_item_type in varchar2 default hr_api.g_varchar2,
541: p_item_key in varchar2 default hr_api.g_varchar2,
542: p_transaction_effective_date in date default hr_api.g_date,
543: p_process_name in varchar2 default hr_api.g_varchar2,

Line 540: p_item_type in varchar2 default hr_api.g_varchar2,

536: p_transaction_type in varchar2 default hr_api.g_varchar2,
537: p_assignment_id in number default hr_api.g_number,
538: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
539: p_selected_person_id in number default hr_api.g_number,
540: p_item_type in varchar2 default hr_api.g_varchar2,
541: p_item_key in varchar2 default hr_api.g_varchar2,
542: p_transaction_effective_date in date default hr_api.g_date,
543: p_process_name in varchar2 default hr_api.g_varchar2,
544: p_plan_id in number default hr_api.g_number,

Line 541: p_item_key in varchar2 default hr_api.g_varchar2,

537: p_assignment_id in number default hr_api.g_number,
538: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
539: p_selected_person_id in number default hr_api.g_number,
540: p_item_type in varchar2 default hr_api.g_varchar2,
541: p_item_key in varchar2 default hr_api.g_varchar2,
542: p_transaction_effective_date in date default hr_api.g_date,
543: p_process_name in varchar2 default hr_api.g_varchar2,
544: p_plan_id in number default hr_api.g_number,
545: p_rptg_grp_id in number default hr_api.g_number,

Line 542: p_transaction_effective_date in date default hr_api.g_date,

538: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
539: p_selected_person_id in number default hr_api.g_number,
540: p_item_type in varchar2 default hr_api.g_varchar2,
541: p_item_key in varchar2 default hr_api.g_varchar2,
542: p_transaction_effective_date in date default hr_api.g_date,
543: p_process_name in varchar2 default hr_api.g_varchar2,
544: p_plan_id in number default hr_api.g_number,
545: p_rptg_grp_id in number default hr_api.g_number,
546: p_effective_date_option in varchar2 default hr_api.g_varchar2,

Line 543: p_process_name in varchar2 default hr_api.g_varchar2,

539: p_selected_person_id in number default hr_api.g_number,
540: p_item_type in varchar2 default hr_api.g_varchar2,
541: p_item_key in varchar2 default hr_api.g_varchar2,
542: p_transaction_effective_date in date default hr_api.g_date,
543: p_process_name in varchar2 default hr_api.g_varchar2,
544: p_plan_id in number default hr_api.g_number,
545: p_rptg_grp_id in number default hr_api.g_number,
546: p_effective_date_option in varchar2 default hr_api.g_varchar2,
547: p_creator_role in varchar2 default hr_api.g_varchar2,

Line 544: p_plan_id in number default hr_api.g_number,

540: p_item_type in varchar2 default hr_api.g_varchar2,
541: p_item_key in varchar2 default hr_api.g_varchar2,
542: p_transaction_effective_date in date default hr_api.g_date,
543: p_process_name in varchar2 default hr_api.g_varchar2,
544: p_plan_id in number default hr_api.g_number,
545: p_rptg_grp_id in number default hr_api.g_number,
546: p_effective_date_option in varchar2 default hr_api.g_varchar2,
547: p_creator_role in varchar2 default hr_api.g_varchar2,
548: p_last_update_role in varchar2 default hr_api.g_varchar2,

Line 545: p_rptg_grp_id in number default hr_api.g_number,

541: p_item_key in varchar2 default hr_api.g_varchar2,
542: p_transaction_effective_date in date default hr_api.g_date,
543: p_process_name in varchar2 default hr_api.g_varchar2,
544: p_plan_id in number default hr_api.g_number,
545: p_rptg_grp_id in number default hr_api.g_number,
546: p_effective_date_option in varchar2 default hr_api.g_varchar2,
547: p_creator_role in varchar2 default hr_api.g_varchar2,
548: p_last_update_role in varchar2 default hr_api.g_varchar2,
549: p_parent_transaction_id in number default hr_api.g_number,

Line 546: p_effective_date_option in varchar2 default hr_api.g_varchar2,

542: p_transaction_effective_date in date default hr_api.g_date,
543: p_process_name in varchar2 default hr_api.g_varchar2,
544: p_plan_id in number default hr_api.g_number,
545: p_rptg_grp_id in number default hr_api.g_number,
546: p_effective_date_option in varchar2 default hr_api.g_varchar2,
547: p_creator_role in varchar2 default hr_api.g_varchar2,
548: p_last_update_role in varchar2 default hr_api.g_varchar2,
549: p_parent_transaction_id in number default hr_api.g_number,
550: p_relaunch_function in varchar2 default hr_api.g_varchar2,

Line 547: p_creator_role in varchar2 default hr_api.g_varchar2,

543: p_process_name in varchar2 default hr_api.g_varchar2,
544: p_plan_id in number default hr_api.g_number,
545: p_rptg_grp_id in number default hr_api.g_number,
546: p_effective_date_option in varchar2 default hr_api.g_varchar2,
547: p_creator_role in varchar2 default hr_api.g_varchar2,
548: p_last_update_role in varchar2 default hr_api.g_varchar2,
549: p_parent_transaction_id in number default hr_api.g_number,
550: p_relaunch_function in varchar2 default hr_api.g_varchar2,
551: p_transaction_group in varchar2 default hr_api.g_varchar2,

Line 548: p_last_update_role in varchar2 default hr_api.g_varchar2,

544: p_plan_id in number default hr_api.g_number,
545: p_rptg_grp_id in number default hr_api.g_number,
546: p_effective_date_option in varchar2 default hr_api.g_varchar2,
547: p_creator_role in varchar2 default hr_api.g_varchar2,
548: p_last_update_role in varchar2 default hr_api.g_varchar2,
549: p_parent_transaction_id in number default hr_api.g_number,
550: p_relaunch_function in varchar2 default hr_api.g_varchar2,
551: p_transaction_group in varchar2 default hr_api.g_varchar2,
552: p_transaction_identifier in varchar2 default hr_api.g_varchar2,

Line 549: p_parent_transaction_id in number default hr_api.g_number,

545: p_rptg_grp_id in number default hr_api.g_number,
546: p_effective_date_option in varchar2 default hr_api.g_varchar2,
547: p_creator_role in varchar2 default hr_api.g_varchar2,
548: p_last_update_role in varchar2 default hr_api.g_varchar2,
549: p_parent_transaction_id in number default hr_api.g_number,
550: p_relaunch_function in varchar2 default hr_api.g_varchar2,
551: p_transaction_group in varchar2 default hr_api.g_varchar2,
552: p_transaction_identifier in varchar2 default hr_api.g_varchar2,
553: p_transaction_document in clob default NULL

Line 550: p_relaunch_function in varchar2 default hr_api.g_varchar2,

546: p_effective_date_option in varchar2 default hr_api.g_varchar2,
547: p_creator_role in varchar2 default hr_api.g_varchar2,
548: p_last_update_role in varchar2 default hr_api.g_varchar2,
549: p_parent_transaction_id in number default hr_api.g_number,
550: p_relaunch_function in varchar2 default hr_api.g_varchar2,
551: p_transaction_group in varchar2 default hr_api.g_varchar2,
552: p_transaction_identifier in varchar2 default hr_api.g_varchar2,
553: p_transaction_document in clob default NULL
554: ) is

Line 551: p_transaction_group in varchar2 default hr_api.g_varchar2,

547: p_creator_role in varchar2 default hr_api.g_varchar2,
548: p_last_update_role in varchar2 default hr_api.g_varchar2,
549: p_parent_transaction_id in number default hr_api.g_number,
550: p_relaunch_function in varchar2 default hr_api.g_varchar2,
551: p_transaction_group in varchar2 default hr_api.g_varchar2,
552: p_transaction_identifier in varchar2 default hr_api.g_varchar2,
553: p_transaction_document in clob default NULL
554: ) is
555: --

Line 552: p_transaction_identifier in varchar2 default hr_api.g_varchar2,

548: p_last_update_role in varchar2 default hr_api.g_varchar2,
549: p_parent_transaction_id in number default hr_api.g_number,
550: p_relaunch_function in varchar2 default hr_api.g_varchar2,
551: p_transaction_group in varchar2 default hr_api.g_varchar2,
552: p_transaction_identifier in varchar2 default hr_api.g_varchar2,
553: p_transaction_document in clob default NULL
554: ) is
555: --
556: -- p_plan_id, p_rptg_grp_id, p_effective_date_option added by sanej