DBA Data[Home] [Help]

APPS.AME_APT_UPD dependencies on AME_APT_SHD

Line 58: (p_rec in out nocopy ame_apt_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ame_apt_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 77: ame_apt_shd.get_object_version_number

73: -- Because we are updating a row we must get the next object
74: -- version number.
75: --
76: p_rec.object_version_number :=
77: ame_apt_shd.get_object_version_number
78: (p_approver_type_id => p_rec.approver_type_id
79: );
80: --
81: -- Update the ame_approver_types Row

Line 117: ame_apt_shd.constraint_error

113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: ame_apt_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --

Line 122: ame_apt_shd.constraint_error

118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: ame_apt_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: --
126: Raise;

Line 161: (p_rec in out nocopy ame_apt_shd.g_rec_type

157: --
158: -- {End Of Comments}
159: -- ----------------------------------------------------------------------------
160: Procedure update_dml
161: (p_rec in out nocopy ame_apt_shd.g_rec_type
162: ,p_effective_date in date
163: ,p_datetrack_mode in varchar2
164: ,p_validation_start_date in date
165: ,p_validation_end_date in date

Line 228: (p_rec in out nocopy ame_apt_shd.g_rec_type

224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure dt_pre_update
228: (p_rec in out nocopy ame_apt_shd.g_rec_type
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_validation_start_date in date
232: ,p_validation_end_date in date

Line 244: ame_apt_shd.upd_effective_end_date

240: If (p_datetrack_mode <> hr_api.g_correction) then
241: --
242: -- Update the current effective end date
243: --
244: ame_apt_shd.upd_effective_end_date
245: (p_effective_date => p_effective_date
246: ,p_approver_type_id => p_rec.approver_type_id
247: ,p_new_effective_end_date => p_validation_start_date
248: ,p_validation_start_date => p_validation_start_date

Line 313: (p_rec in out nocopy ame_apt_shd.g_rec_type

309: --
310: -- {End Of Comments}
311: -- ----------------------------------------------------------------------------
312: Procedure pre_update
313: (p_rec in out nocopy ame_apt_shd.g_rec_type
314: ,p_effective_date in date
315: ,p_datetrack_mode in varchar2
316: ,p_validation_start_date in date
317: ,p_validation_end_date in date

Line 371: (p_rec in ame_apt_shd.g_rec_type

367: --
368: -- {End Of Comments}
369: -- ----------------------------------------------------------------------------
370: Procedure post_update
371: (p_rec in ame_apt_shd.g_rec_type
372: ,p_effective_date in date
373: ,p_datetrack_mode in varchar2
374: ,p_validation_start_date in date
375: ,p_validation_end_date in date

Line 405: ,p_orig_system_o => ame_apt_shd.g_old_rec.orig_system

401: ,p_query_procedure => p_rec.query_procedure
402: ,p_start_date => p_rec.start_date
403: ,p_end_date => p_rec.end_date
404: ,p_object_version_number => p_rec.object_version_number
405: ,p_orig_system_o => ame_apt_shd.g_old_rec.orig_system
406: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label
407: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
408: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
409: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label

Line 406: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label

402: ,p_start_date => p_rec.start_date
403: ,p_end_date => p_rec.end_date
404: ,p_object_version_number => p_rec.object_version_number
405: ,p_orig_system_o => ame_apt_shd.g_old_rec.orig_system
406: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label
407: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
408: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
409: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
410: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label

Line 407: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label

403: ,p_end_date => p_rec.end_date
404: ,p_object_version_number => p_rec.object_version_number
405: ,p_orig_system_o => ame_apt_shd.g_old_rec.orig_system
406: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label
407: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
408: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
409: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
410: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
411: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query

Line 408: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label

404: ,p_object_version_number => p_rec.object_version_number
405: ,p_orig_system_o => ame_apt_shd.g_old_rec.orig_system
406: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label
407: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
408: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
409: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
410: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
411: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
412: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query

Line 409: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label

405: ,p_orig_system_o => ame_apt_shd.g_old_rec.orig_system
406: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label
407: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
408: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
409: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
410: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
411: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
412: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
413: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query

Line 410: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label

406: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label
407: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
408: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
409: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
410: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
411: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
412: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
413: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
414: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query

Line 411: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query

407: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
408: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
409: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
410: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
411: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
412: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
413: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
414: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
415: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query

Line 412: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query

408: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
409: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
410: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
411: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
412: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
413: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
414: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
415: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
416: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure

Line 413: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query

409: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
410: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
411: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
412: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
413: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
414: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
415: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
416: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
417: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date

Line 414: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query

410: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
411: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
412: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
413: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
414: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
415: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
416: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
417: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date
418: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date

Line 415: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query

411: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
412: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
413: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
414: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
415: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
416: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
417: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date
418: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date
419: ,p_object_version_number_o => ame_apt_shd.g_old_rec.object_version_number

Line 416: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure

412: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
413: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
414: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
415: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
416: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
417: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date
418: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date
419: ,p_object_version_number_o => ame_apt_shd.g_old_rec.object_version_number
420: );

Line 417: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date

413: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
414: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
415: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
416: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
417: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date
418: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date
419: ,p_object_version_number_o => ame_apt_shd.g_old_rec.object_version_number
420: );
421: --

Line 418: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date

414: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
415: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
416: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
417: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date
418: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date
419: ,p_object_version_number_o => ame_apt_shd.g_old_rec.object_version_number
420: );
421: --
422: exception

Line 419: ,p_object_version_number_o => ame_apt_shd.g_old_rec.object_version_number

415: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
416: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
417: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date
418: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date
419: ,p_object_version_number_o => ame_apt_shd.g_old_rec.object_version_number
420: );
421: --
422: exception
423: --

Line 479: (p_rec in out nocopy ame_apt_shd.g_rec_type

475: --
476: -- {End Of Comments}
477: -- ----------------------------------------------------------------------------
478: Procedure convert_defs
479: (p_rec in out nocopy ame_apt_shd.g_rec_type
480: ) is
481: --
482: Begin
483: --

Line 491: ame_apt_shd.g_old_rec.orig_system;

487: -- is being used then we must set to the 'current' argument value.
488: --
489: If (p_rec.orig_system = hr_api.g_varchar2) then
490: p_rec.orig_system :=
491: ame_apt_shd.g_old_rec.orig_system;
492: End If;
493: If (p_rec.query_variable_1_label = hr_api.g_varchar2) then
494: p_rec.query_variable_1_label :=
495: ame_apt_shd.g_old_rec.query_variable_1_label;

Line 495: ame_apt_shd.g_old_rec.query_variable_1_label;

491: ame_apt_shd.g_old_rec.orig_system;
492: End If;
493: If (p_rec.query_variable_1_label = hr_api.g_varchar2) then
494: p_rec.query_variable_1_label :=
495: ame_apt_shd.g_old_rec.query_variable_1_label;
496: End If;
497: If (p_rec.query_variable_2_label = hr_api.g_varchar2) then
498: p_rec.query_variable_2_label :=
499: ame_apt_shd.g_old_rec.query_variable_2_label;

Line 499: ame_apt_shd.g_old_rec.query_variable_2_label;

495: ame_apt_shd.g_old_rec.query_variable_1_label;
496: End If;
497: If (p_rec.query_variable_2_label = hr_api.g_varchar2) then
498: p_rec.query_variable_2_label :=
499: ame_apt_shd.g_old_rec.query_variable_2_label;
500: End If;
501: If (p_rec.query_variable_3_label = hr_api.g_varchar2) then
502: p_rec.query_variable_3_label :=
503: ame_apt_shd.g_old_rec.query_variable_3_label;

Line 503: ame_apt_shd.g_old_rec.query_variable_3_label;

499: ame_apt_shd.g_old_rec.query_variable_2_label;
500: End If;
501: If (p_rec.query_variable_3_label = hr_api.g_varchar2) then
502: p_rec.query_variable_3_label :=
503: ame_apt_shd.g_old_rec.query_variable_3_label;
504: End If;
505: If (p_rec.query_variable_4_label = hr_api.g_varchar2) then
506: p_rec.query_variable_4_label :=
507: ame_apt_shd.g_old_rec.query_variable_4_label;

Line 507: ame_apt_shd.g_old_rec.query_variable_4_label;

503: ame_apt_shd.g_old_rec.query_variable_3_label;
504: End If;
505: If (p_rec.query_variable_4_label = hr_api.g_varchar2) then
506: p_rec.query_variable_4_label :=
507: ame_apt_shd.g_old_rec.query_variable_4_label;
508: End If;
509: If (p_rec.query_variable_5_label = hr_api.g_varchar2) then
510: p_rec.query_variable_5_label :=
511: ame_apt_shd.g_old_rec.query_variable_5_label;

Line 511: ame_apt_shd.g_old_rec.query_variable_5_label;

507: ame_apt_shd.g_old_rec.query_variable_4_label;
508: End If;
509: If (p_rec.query_variable_5_label = hr_api.g_varchar2) then
510: p_rec.query_variable_5_label :=
511: ame_apt_shd.g_old_rec.query_variable_5_label;
512: End If;
513: If (p_rec.variable_1_lov_query = hr_api.g_varchar2) then
514: p_rec.variable_1_lov_query :=
515: ame_apt_shd.g_old_rec.variable_1_lov_query;

Line 515: ame_apt_shd.g_old_rec.variable_1_lov_query;

511: ame_apt_shd.g_old_rec.query_variable_5_label;
512: End If;
513: If (p_rec.variable_1_lov_query = hr_api.g_varchar2) then
514: p_rec.variable_1_lov_query :=
515: ame_apt_shd.g_old_rec.variable_1_lov_query;
516: End If;
517: If (p_rec.variable_2_lov_query = hr_api.g_varchar2) then
518: p_rec.variable_2_lov_query :=
519: ame_apt_shd.g_old_rec.variable_2_lov_query;

Line 519: ame_apt_shd.g_old_rec.variable_2_lov_query;

515: ame_apt_shd.g_old_rec.variable_1_lov_query;
516: End If;
517: If (p_rec.variable_2_lov_query = hr_api.g_varchar2) then
518: p_rec.variable_2_lov_query :=
519: ame_apt_shd.g_old_rec.variable_2_lov_query;
520: End If;
521: If (p_rec.variable_3_lov_query = hr_api.g_varchar2) then
522: p_rec.variable_3_lov_query :=
523: ame_apt_shd.g_old_rec.variable_3_lov_query;

Line 523: ame_apt_shd.g_old_rec.variable_3_lov_query;

519: ame_apt_shd.g_old_rec.variable_2_lov_query;
520: End If;
521: If (p_rec.variable_3_lov_query = hr_api.g_varchar2) then
522: p_rec.variable_3_lov_query :=
523: ame_apt_shd.g_old_rec.variable_3_lov_query;
524: End If;
525: If (p_rec.variable_4_lov_query = hr_api.g_varchar2) then
526: p_rec.variable_4_lov_query :=
527: ame_apt_shd.g_old_rec.variable_4_lov_query;

Line 527: ame_apt_shd.g_old_rec.variable_4_lov_query;

523: ame_apt_shd.g_old_rec.variable_3_lov_query;
524: End If;
525: If (p_rec.variable_4_lov_query = hr_api.g_varchar2) then
526: p_rec.variable_4_lov_query :=
527: ame_apt_shd.g_old_rec.variable_4_lov_query;
528: End If;
529: If (p_rec.variable_5_lov_query = hr_api.g_varchar2) then
530: p_rec.variable_5_lov_query :=
531: ame_apt_shd.g_old_rec.variable_5_lov_query;

Line 531: ame_apt_shd.g_old_rec.variable_5_lov_query;

527: ame_apt_shd.g_old_rec.variable_4_lov_query;
528: End If;
529: If (p_rec.variable_5_lov_query = hr_api.g_varchar2) then
530: p_rec.variable_5_lov_query :=
531: ame_apt_shd.g_old_rec.variable_5_lov_query;
532: End If;
533: If (p_rec.query_procedure = hr_api.g_varchar2) then
534: p_rec.query_procedure :=
535: ame_apt_shd.g_old_rec.query_procedure;

Line 535: ame_apt_shd.g_old_rec.query_procedure;

531: ame_apt_shd.g_old_rec.variable_5_lov_query;
532: End If;
533: If (p_rec.query_procedure = hr_api.g_varchar2) then
534: p_rec.query_procedure :=
535: ame_apt_shd.g_old_rec.query_procedure;
536: End If;
537: --
538: End convert_defs;
539: --

Line 546: ,p_rec in out nocopy ame_apt_shd.g_rec_type

542: -- ----------------------------------------------------------------------------
543: Procedure upd
544: (p_effective_date in date
545: ,p_datetrack_mode in varchar2
546: ,p_rec in out nocopy ame_apt_shd.g_rec_type
547: ) is
548: --
549: l_proc varchar2(72) := g_package||'upd';
550: l_validation_start_date date;

Line 562: ame_apt_shd.lck

558: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
559: --
560: -- We must lock the row which we need to update.
561: --
562: ame_apt_shd.lck
563: (p_effective_date => p_effective_date
564: ,p_datetrack_mode => p_datetrack_mode
565: ,p_approver_type_id => p_rec.approver_type_id
566: ,p_orig_system => p_rec.orig_system

Line 649: l_rec ame_apt_shd.g_rec_type;

645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2
646: ,p_query_procedure in varchar2 default hr_api.g_varchar2
647: ) is
648: --
649: l_rec ame_apt_shd.g_rec_type;
650: l_proc varchar2(72) := g_package||'upd';
651: --
652: Begin
653: hr_utility.set_location('Entering:'||l_proc, 5);

Line 659: ame_apt_shd.convert_args

655: -- Call conversion function to turn arguments into the
656: -- l_rec structure.
657: --
658: l_rec :=
659: ame_apt_shd.convert_args
660: (p_approver_type_id
661: ,p_orig_system
662: ,p_query_variable_1_label
663: ,p_query_variable_2_label