eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_APPROVER_GROUP_API dependencies on HR_API

Line 103: set approval_group_id = hr_api.g_number

99: -- delete from ame_approval_group_members where approval_group_id = l_grp_id_list(idx);
100:
101: if p_delete_group = false or l_grp_id_list(idx) <> p_approval_group_id then
102: update ame_approval_group_members
103: set approval_group_id = hr_api.g_number
104: where approval_group_id = l_grp_id_list(idx);
105:
106: for r2 in c_expanded_nested_grps( l_grp_id_list(idx)) loop
107: l_orig_system := null;

Line 126: where approval_group_id = hr_api.g_number

122: when no_data_found then
123: select orig_system, orig_system_id
124: into l_orig_system, l_orig_system_id
125: from ame_approval_group_members
126: where approval_group_id = hr_api.g_number
127: and parameter_name = 'wf_roles_name'
128: and parameter =r2.param
129: and rownum <2;
130: end;

Line 161: delete from ame_approval_group_members where approval_group_id = hr_api.g_number;

157: ,l_orig_system
158: ,l_orig_system_id
159: );
160: end loop;
161: delete from ame_approval_group_members where approval_group_id = hr_api.g_number;
162: else
163: delete from ame_approval_group_members where approval_group_id = l_grp_id_list(idx);
164: end if;
165: end loop;

Line 181: hr_api.userenv_lang

177: --
178: procedure create_ame_approver_group
179: (p_validate in boolean default false
180: ,p_language_code in varchar2 default
181: hr_api.userenv_lang
182: ,p_name in varchar2
183: ,p_description in varchar2
184: ,p_is_static in varchar2
185: ,p_query_string in varchar2 default null

Line 240: when hr_api.cannot_find_prog_unit then

236: ,p_is_static => p_is_static
237: ,p_query_string => p_query_string
238: );
239: exception
240: when hr_api.cannot_find_prog_unit then
241: hr_api.cannot_find_prog_unit_error
242: (p_module_name => 'create_ame_approver_group'
243: ,p_hook_type => 'BP'
244: );

Line 241: hr_api.cannot_find_prog_unit_error

237: ,p_query_string => p_query_string
238: );
239: exception
240: when hr_api.cannot_find_prog_unit then
241: hr_api.cannot_find_prog_unit_error
242: (p_module_name => 'create_ame_approver_group'
243: ,p_hook_type => 'BP'
244: );
245: end;

Line 315: when hr_api.cannot_find_prog_unit then

311: ,p_start_date => l_start_date
312: ,p_end_date => l_end_date
313: );
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'create_ame_approver_group'
318: ,p_hook_type => 'AP'
319: );

Line 316: hr_api.cannot_find_prog_unit_error

312: ,p_end_date => l_end_date
313: );
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'create_ame_approver_group'
318: ,p_hook_type => 'AP'
319: );
320: end;

Line 325: raise hr_api.validate_enabled;

321: --
322: -- When in validation only mode raise the Validate_Enabled exception
323: --
324: if p_validate then
325: raise hr_api.validate_enabled;
326: end if;
327: --
328: -- Set all IN OUT and OUT parameters with out values
329: --

Line 338: when hr_api.validate_enabled then

334:
335: --
336: hr_utility.set_location(' Leaving:'||l_proc, 70);
337: exception
338: when hr_api.validate_enabled then
339: --
340: -- As the Validate_Enabled exception has been raised
341: -- we must rollback to the savepoint
342: --

Line 381: hr_api.userenv_lang

377: procedure update_ame_approver_group
378: (p_validate in boolean default false
379: ,p_approval_group_id in number
380: ,p_language_code in varchar2 default
381: hr_api.userenv_lang
382: ,p_description in varchar2 default hr_api.g_varchar2
383: ,p_is_static in varchar2 default hr_api.g_varchar2
384: ,p_query_string in varchar2 default hr_api.g_varchar2
385: ,p_object_version_number in out nocopy number

Line 382: ,p_description in varchar2 default hr_api.g_varchar2

378: (p_validate in boolean default false
379: ,p_approval_group_id in number
380: ,p_language_code in varchar2 default
381: hr_api.userenv_lang
382: ,p_description in varchar2 default hr_api.g_varchar2
383: ,p_is_static in varchar2 default hr_api.g_varchar2
384: ,p_query_string in varchar2 default hr_api.g_varchar2
385: ,p_object_version_number in out nocopy number
386: ,p_start_date out nocopy date

Line 383: ,p_is_static in varchar2 default hr_api.g_varchar2

379: ,p_approval_group_id in number
380: ,p_language_code in varchar2 default
381: hr_api.userenv_lang
382: ,p_description in varchar2 default hr_api.g_varchar2
383: ,p_is_static in varchar2 default hr_api.g_varchar2
384: ,p_query_string in varchar2 default hr_api.g_varchar2
385: ,p_object_version_number in out nocopy number
386: ,p_start_date out nocopy date
387: ,p_end_date out nocopy date

Line 384: ,p_query_string in varchar2 default hr_api.g_varchar2

380: ,p_language_code in varchar2 default
381: hr_api.userenv_lang
382: ,p_description in varchar2 default hr_api.g_varchar2
383: ,p_is_static in varchar2 default hr_api.g_varchar2
384: ,p_query_string in varchar2 default hr_api.g_varchar2
385: ,p_object_version_number in out nocopy number
386: ,p_start_date out nocopy date
387: ,p_end_date out nocopy date
388: ) is

Line 438: when hr_api.cannot_find_prog_unit then

434: ,p_query_string => p_query_string
435: ,p_object_version_number => p_object_version_number
436: );
437: exception
438: when hr_api.cannot_find_prog_unit then
439: hr_api.cannot_find_prog_unit_error
440: (p_module_name => 'update_ame_approver_group'
441: ,p_hook_type => 'BP'
442: );

Line 439: hr_api.cannot_find_prog_unit_error

435: ,p_object_version_number => p_object_version_number
436: );
437: exception
438: when hr_api.cannot_find_prog_unit then
439: hr_api.cannot_find_prog_unit_error
440: (p_module_name => 'update_ame_approver_group'
441: ,p_hook_type => 'BP'
442: );
443: end;

Line 453: ,p_datetrack_mode => hr_api.g_update

449: fetch Csel1 into l_old_is_static;
450: close Csel1;
451: --call row handler update procedure
452: ame_apg_upd.upd(p_effective_date => sysdate
453: ,p_datetrack_mode => hr_api.g_update
454: ,p_approval_group_id => p_approval_group_id
455: ,p_object_version_number => p_object_version_number
456: ,p_description => p_description
457: ,p_is_static => p_is_static

Line 459: ,p_security_group_id => hr_api.g_number

455: ,p_object_version_number => p_object_version_number
456: ,p_description => p_description
457: ,p_is_static => p_is_static
458: ,p_query_string => p_query_string
459: ,p_security_group_id => hr_api.g_number
460: ,p_start_date => l_start_date
461: ,p_end_date => l_end_date
462: );
463: --call tl table update procedure

Line 480: ,p_datetrack_mode => hr_api.g_delete

476: loop
477: l_object_version_number_item := rec.object_version_number;
478: ame_gpi_del.del
479: (p_effective_date => sysdate
480: ,p_datetrack_mode => hr_api.g_delete
481: ,p_approval_group_item_id => rec.approval_group_item_id
482: ,p_object_version_number => l_object_version_number_item
483: ,p_start_date => l_start_date_item
484: ,p_end_date => l_end_date_item

Line 511: when hr_api.cannot_find_prog_unit then

507: ,p_start_date => l_start_date
508: ,p_end_date => l_end_date
509: );
510: exception
511: when hr_api.cannot_find_prog_unit then
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'update_ame_approver_group'
514: ,p_hook_type => 'AP'
515: );

Line 512: hr_api.cannot_find_prog_unit_error

508: ,p_end_date => l_end_date
509: );
510: exception
511: when hr_api.cannot_find_prog_unit then
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'update_ame_approver_group'
514: ,p_hook_type => 'AP'
515: );
516: end;

Line 521: raise hr_api.validate_enabled;

517: --
518: -- When in validation only mode raise the Validate_Enabled exception
519: --
520: if p_validate then
521: raise hr_api.validate_enabled;
522: end if;
523: --
524: -- Set all IN OUT and OUT parameters with out values.
525: --

Line 531: when hr_api.validate_enabled then

527: p_end_date := l_end_date;
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 70);
530: exception
531: when hr_api.validate_enabled then
532: --
533: -- As the Validate_Enabled exception has been raised
534: -- we must rollback to the savepoint
535: --

Line 649: when hr_api.cannot_find_prog_unit then

645: (p_approval_group_id => p_approval_group_id
646: ,p_object_version_number => p_object_version_number
647: );
648: exception
649: when hr_api.cannot_find_prog_unit then
650: hr_api.cannot_find_prog_unit_error
651: (p_module_name => 'delete_ame_approver_group'
652: ,p_hook_type => 'BP'
653: );

Line 650: hr_api.cannot_find_prog_unit_error

646: ,p_object_version_number => p_object_version_number
647: );
648: exception
649: when hr_api.cannot_find_prog_unit then
650: hr_api.cannot_find_prog_unit_error
651: (p_module_name => 'delete_ame_approver_group'
652: ,p_hook_type => 'BP'
653: );
654: end;

Line 701: ,p_datetrack_mode => hr_api.g_delete

697: loop
698: l_object_version_number_conf :=rec.object_version_number;
699: ame_gpi_del.del
700: (p_effective_date => sysdate
701: ,p_datetrack_mode => hr_api.g_delete
702: ,p_approval_group_item_id => rec.approval_group_item_id
703: ,p_object_version_number => l_object_version_number_conf
704: ,p_start_date => l_start_date_conf
705: ,p_end_date => l_end_date_conf

Line 709: ,p_datetrack_mode => hr_api.g_delete

705: ,p_end_date => l_end_date_conf
706: );
707: end loop;
708: ame_apg_del.del(p_effective_date => sysdate
709: ,p_datetrack_mode => hr_api.g_delete
710: ,p_approval_group_id => p_approval_group_id
711: ,p_object_version_number => p_object_version_number
712: ,p_start_date => l_start_date
713: ,p_end_date => l_end_date

Line 733: when hr_api.cannot_find_prog_unit then

729: ,p_start_date => l_start_date
730: ,p_end_date => l_end_date
731: );
732: exception
733: when hr_api.cannot_find_prog_unit then
734: hr_api.cannot_find_prog_unit_error
735: (p_module_name => 'delete_ame_approver_group'
736: ,p_hook_type => 'AP'
737: );

Line 734: hr_api.cannot_find_prog_unit_error

730: ,p_end_date => l_end_date
731: );
732: exception
733: when hr_api.cannot_find_prog_unit then
734: hr_api.cannot_find_prog_unit_error
735: (p_module_name => 'delete_ame_approver_group'
736: ,p_hook_type => 'AP'
737: );
738: end;

Line 743: raise hr_api.validate_enabled;

739: --
740: -- When in validation only mode raise the Validate_Enabled exception
741: --
742: if p_validate then
743: raise hr_api.validate_enabled;
744: end if;
745: --
746: -- Set all IN OUT and OUT parameters with out values.
747: --

Line 753: when hr_api.validate_enabled then

749: p_end_date := l_end_date;
750: --
751: hr_utility.set_location(' Leaving:'||l_proc, 70);
752: exception
753: when hr_api.validate_enabled then
754: --
755: -- As the Validate_Enabled exception has been raised
756: -- we must rollback to the savepoint
757: --

Line 833: when hr_api.cannot_find_prog_unit then

829: ,p_voting_regime => p_voting_regime
830: ,p_order_number => p_order_number
831: );
832: exception
833: when hr_api.cannot_find_prog_unit then
834: hr_api.cannot_find_prog_unit_error
835: (p_module_name => 'create_approver_group_config'
836: ,p_hook_type => 'BP'
837: );

Line 834: hr_api.cannot_find_prog_unit_error

830: ,p_order_number => p_order_number
831: );
832: exception
833: when hr_api.cannot_find_prog_unit then
834: hr_api.cannot_find_prog_unit_error
835: (p_module_name => 'create_approver_group_config'
836: ,p_hook_type => 'BP'
837: );
838: end;

Line 865: when hr_api.cannot_find_prog_unit then

861: ,p_start_date => l_start_date
862: ,p_end_date => l_end_date
863: );
864: exception
865: when hr_api.cannot_find_prog_unit then
866: hr_api.cannot_find_prog_unit_error(p_module_name => 'create_approver_group_config'
867: ,p_hook_type => 'AP'
868: );
869: end;

Line 866: hr_api.cannot_find_prog_unit_error(p_module_name => 'create_approver_group_config'

862: ,p_end_date => l_end_date
863: );
864: exception
865: when hr_api.cannot_find_prog_unit then
866: hr_api.cannot_find_prog_unit_error(p_module_name => 'create_approver_group_config'
867: ,p_hook_type => 'AP'
868: );
869: end;
870: --

Line 874: raise hr_api.validate_enabled;

870: --
871: -- When in validation only mode raise the Validate_Enabled exception
872: --
873: if p_validate then
874: raise hr_api.validate_enabled;
875: end if;
876: --
877: -- Set all IN OUT and OUT parameters with out values.
878: --

Line 885: when hr_api.validate_enabled then

881: p_object_version_number := l_object_version_number;
882: --
883: hr_utility.set_location(' Leaving:'||l_proc, 70);
884: exception
885: when hr_api.validate_enabled then
886: --
887: -- As the Validate_Enabled exception has been raised
888: -- we must rollback to the savepoint
889: --

Line 962: when hr_api.cannot_find_prog_unit then

958: ,p_application_id => p_application_id
959: ,p_object_version_number => p_object_version_number
960: );
961: exception
962: when hr_api.cannot_find_prog_unit then
963: hr_api.cannot_find_prog_unit_error
964: (p_module_name => 'delete_approver_group_config'
965: ,p_hook_type => 'BP'
966: );

Line 963: hr_api.cannot_find_prog_unit_error

959: ,p_object_version_number => p_object_version_number
960: );
961: exception
962: when hr_api.cannot_find_prog_unit then
963: hr_api.cannot_find_prog_unit_error
964: (p_module_name => 'delete_approver_group_config'
965: ,p_hook_type => 'BP'
966: );
967: end;

Line 972: ,p_datetrack_mode => hr_api.g_delete

968: --
969: -- Process Logic
970: --
971: ame_gcf_del.del(p_effective_date => sysdate
972: ,p_datetrack_mode => hr_api.g_delete
973: ,p_approval_group_id => p_approval_group_id
974: ,p_application_id => p_application_id
975: ,p_object_version_number => p_object_version_number
976: ,p_start_date => l_start_date

Line 991: when hr_api.cannot_find_prog_unit then

987: ,p_start_date => l_start_date
988: ,p_end_date => l_end_date
989: );
990: exception
991: when hr_api.cannot_find_prog_unit then
992: hr_api.cannot_find_prog_unit_error
993: (p_module_name => 'delete_approver_group_config'
994: ,p_hook_type => 'AP'
995: );

Line 992: hr_api.cannot_find_prog_unit_error

988: ,p_end_date => l_end_date
989: );
990: exception
991: when hr_api.cannot_find_prog_unit then
992: hr_api.cannot_find_prog_unit_error
993: (p_module_name => 'delete_approver_group_config'
994: ,p_hook_type => 'AP'
995: );
996: end;

Line 1001: raise hr_api.validate_enabled;

997: --
998: -- When in validation only mode raise the Validate_Enabled exception
999: --
1000: if p_validate then
1001: raise hr_api.validate_enabled;
1002: end if;
1003: --
1004: -- Set all IN OUT and OUT parameters with out values.
1005: --

Line 1011: when hr_api.validate_enabled then

1007: p_end_date := l_end_date;
1008: --
1009: hr_utility.set_location(' Leaving:'||l_proc, 70);
1010: exception
1011: when hr_api.validate_enabled then
1012: --
1013: -- As the Validate_Enabled exception has been raised
1014: -- we must rollback to the savepoint
1015: --

Line 1055: ,p_voting_regime in varchar2 default hr_api.g_varchar2

1051: (
1052: p_validate in boolean default false
1053: ,p_approval_group_id in number
1054: ,p_application_id in number
1055: ,p_voting_regime in varchar2 default hr_api.g_varchar2
1056: ,p_order_number in varchar2 default hr_api.g_number
1057: ,p_object_version_number in out nocopy number
1058: ,p_start_date out nocopy date
1059: ,p_end_date out nocopy date

Line 1056: ,p_order_number in varchar2 default hr_api.g_number

1052: p_validate in boolean default false
1053: ,p_approval_group_id in number
1054: ,p_application_id in number
1055: ,p_voting_regime in varchar2 default hr_api.g_varchar2
1056: ,p_order_number in varchar2 default hr_api.g_number
1057: ,p_object_version_number in out nocopy number
1058: ,p_start_date out nocopy date
1059: ,p_end_date out nocopy date
1060: ) IS

Line 1091: when hr_api.cannot_find_prog_unit then

1087: ,p_order_number => p_order_number
1088: ,p_object_version_number =>p_object_version_number
1089: );
1090: exception
1091: when hr_api.cannot_find_prog_unit then
1092: hr_api.cannot_find_prog_unit_error
1093: (p_module_name => 'update_approver_group_config'
1094: ,p_hook_type => 'BP'
1095: );

Line 1092: hr_api.cannot_find_prog_unit_error

1088: ,p_object_version_number =>p_object_version_number
1089: );
1090: exception
1091: when hr_api.cannot_find_prog_unit then
1092: hr_api.cannot_find_prog_unit_error
1093: (p_module_name => 'update_approver_group_config'
1094: ,p_hook_type => 'BP'
1095: );
1096: end;

Line 1101: ,p_datetrack_mode => hr_api.g_update

1097: --
1098: -- Process Logic
1099: --
1100: ame_gcf_upd.upd(p_effective_date => sysdate
1101: ,p_datetrack_mode => hr_api.g_update
1102: ,p_approval_group_id => p_approval_group_id
1103: ,p_application_id => p_application_id
1104: ,p_voting_regime => p_voting_regime
1105: ,p_order_number => p_order_number

Line 1124: when hr_api.cannot_find_prog_unit then

1120: ,p_start_date => l_start_date
1121: ,p_end_date => l_end_date
1122: );
1123: exception
1124: when hr_api.cannot_find_prog_unit then
1125: hr_api.cannot_find_prog_unit_error
1126: (p_module_name => 'update_approver_group_config'
1127: ,p_hook_type => 'AP'
1128: );

Line 1125: hr_api.cannot_find_prog_unit_error

1121: ,p_end_date => l_end_date
1122: );
1123: exception
1124: when hr_api.cannot_find_prog_unit then
1125: hr_api.cannot_find_prog_unit_error
1126: (p_module_name => 'update_approver_group_config'
1127: ,p_hook_type => 'AP'
1128: );
1129: end;

Line 1134: raise hr_api.validate_enabled;

1130: --
1131: -- When in validation only mode raise the Validate_Enabled exception
1132: --
1133: if p_validate then
1134: raise hr_api.validate_enabled;
1135: end if;
1136: --
1137: -- Set all IN OUT and OUT parameters with out values.
1138: --

Line 1144: when hr_api.validate_enabled then

1140: p_end_date := l_end_date;
1141: --
1142: hr_utility.set_location(' Leaving:'||l_proc, 70);
1143: exception
1144: when hr_api.validate_enabled then
1145: --
1146: -- As the Validate_Enabled exception has been raised
1147: -- we must rollback to the savepoint
1148: --

Line 1225: when hr_api.cannot_find_prog_unit then

1221: ,p_parameter => p_parameter
1222: ,p_order_number => p_order_number
1223: );
1224: exception
1225: when hr_api.cannot_find_prog_unit then
1226: hr_api.cannot_find_prog_unit_error
1227: (p_module_name => 'create_approver_group_item'
1228: ,p_hook_type => 'BP'
1229: );

Line 1226: hr_api.cannot_find_prog_unit_error

1222: ,p_order_number => p_order_number
1223: );
1224: exception
1225: when hr_api.cannot_find_prog_unit then
1226: hr_api.cannot_find_prog_unit_error
1227: (p_module_name => 'create_approver_group_item'
1228: ,p_hook_type => 'BP'
1229: );
1230: end;

Line 1260: when hr_api.cannot_find_prog_unit then

1256: ,p_start_date => l_start_date
1257: ,p_end_date => l_end_date
1258: );
1259: exception
1260: when hr_api.cannot_find_prog_unit then
1261: hr_api.cannot_find_prog_unit_error
1262: (p_module_name => 'create_approver_group_item'
1263: ,p_hook_type => 'AP'
1264: );

Line 1261: hr_api.cannot_find_prog_unit_error

1257: ,p_end_date => l_end_date
1258: );
1259: exception
1260: when hr_api.cannot_find_prog_unit then
1261: hr_api.cannot_find_prog_unit_error
1262: (p_module_name => 'create_approver_group_item'
1263: ,p_hook_type => 'AP'
1264: );
1265: end;

Line 1270: raise hr_api.validate_enabled;

1266: --
1267: -- When in validation only mode raise the Validate_Enabled exception
1268: --
1269: if p_validate then
1270: raise hr_api.validate_enabled;
1271: end if;
1272: --
1273: -- Set all IN OUT and OUT parameters with out values.
1274: --

Line 1281: when hr_api.validate_enabled then

1277: p_object_version_number := l_object_version_number;
1278: --
1279: hr_utility.set_location(' Leaving:'||l_proc, 70);
1280: exception
1281: when hr_api.validate_enabled then
1282: --
1283: -- As the Validate_Enabled exception has been raised
1284: -- we must rollback to the savepoint
1285: --

Line 1362: when hr_api.cannot_find_prog_unit then

1358: (p_approval_group_item_id => p_approval_group_item_id
1359: ,p_object_version_number => p_object_version_number
1360: );
1361: exception
1362: when hr_api.cannot_find_prog_unit then
1363: hr_api.cannot_find_prog_unit_error
1364: (p_module_name => 'delete_approver_group_item'
1365: ,p_hook_type => 'BP'
1366: );

Line 1363: hr_api.cannot_find_prog_unit_error

1359: ,p_object_version_number => p_object_version_number
1360: );
1361: exception
1362: when hr_api.cannot_find_prog_unit then
1363: hr_api.cannot_find_prog_unit_error
1364: (p_module_name => 'delete_approver_group_item'
1365: ,p_hook_type => 'BP'
1366: );
1367: end;

Line 1382: ,p_datetrack_mode => hr_api.g_delete

1378: else
1379: close Csel1;
1380: end if;
1381: ame_gpi_del.del(p_effective_date => sysdate
1382: ,p_datetrack_mode => hr_api.g_delete
1383: ,p_approval_group_item_id => p_approval_group_item_id
1384: ,p_object_version_number => p_object_version_number
1385: ,p_start_date => l_start_date
1386: ,p_end_date => l_end_date

Line 1403: when hr_api.cannot_find_prog_unit then

1399: ,p_start_date => l_start_date
1400: ,p_end_date => l_end_date
1401: );
1402: exception
1403: when hr_api.cannot_find_prog_unit then
1404: hr_api.cannot_find_prog_unit_error
1405: (p_module_name => 'delete_approver_group_item'
1406: ,p_hook_type => 'AP'
1407: );

Line 1404: hr_api.cannot_find_prog_unit_error

1400: ,p_end_date => l_end_date
1401: );
1402: exception
1403: when hr_api.cannot_find_prog_unit then
1404: hr_api.cannot_find_prog_unit_error
1405: (p_module_name => 'delete_approver_group_item'
1406: ,p_hook_type => 'AP'
1407: );
1408: end;

Line 1413: raise hr_api.validate_enabled;

1409: --
1410: -- When in validation only mode raise the Validate_Enabled exception
1411: --
1412: if p_validate then
1413: raise hr_api.validate_enabled;
1414: end if;
1415: --
1416: -- Set all IN OUT and OUT parameters with out values.
1417: --

Line 1423: when hr_api.validate_enabled then

1419: p_end_date := l_end_date;
1420: --
1421: hr_utility.set_location(' Leaving:'||l_proc, 70);
1422: exception
1423: when hr_api.validate_enabled then
1424: --
1425: -- As the Validate_Enabled exception has been raised
1426: -- we must rollback to the savepoint
1427: --

Line 1467: ,p_order_number in varchar2 default hr_api.g_number

1463: procedure update_approver_group_item
1464: (
1465: p_validate in boolean default false
1466: ,p_approval_group_item_id in number
1467: ,p_order_number in varchar2 default hr_api.g_number
1468: ,p_object_version_number in out nocopy number
1469: ,p_start_date out nocopy date
1470: ,p_end_date out nocopy date
1471: ) IS

Line 1507: when hr_api.cannot_find_prog_unit then

1503: ,p_order_number => p_order_number
1504: ,p_object_version_number =>p_object_version_number
1505: );
1506: exception
1507: when hr_api.cannot_find_prog_unit then
1508: hr_api.cannot_find_prog_unit_error
1509: (p_module_name => 'update_approver_group_item'
1510: ,p_hook_type => 'BP'
1511: );

Line 1508: hr_api.cannot_find_prog_unit_error

1504: ,p_object_version_number =>p_object_version_number
1505: );
1506: exception
1507: when hr_api.cannot_find_prog_unit then
1508: hr_api.cannot_find_prog_unit_error
1509: (p_module_name => 'update_approver_group_item'
1510: ,p_hook_type => 'BP'
1511: );
1512: end;

Line 1527: ,p_datetrack_mode => hr_api.g_update

1523: else
1524: close Csel1;
1525: end if;
1526: ame_gpi_upd.upd(p_effective_date => sysdate
1527: ,p_datetrack_mode => hr_api.g_update
1528: ,p_approval_group_item_id => p_approval_group_item_id
1529: ,p_order_number => p_order_number
1530: ,p_object_version_number => p_object_version_number
1531: ,p_start_date => l_start_date

Line 1550: when hr_api.cannot_find_prog_unit then

1546: ,p_start_date => l_start_date
1547: ,p_end_date => l_end_date
1548: );
1549: exception
1550: when hr_api.cannot_find_prog_unit then
1551: hr_api.cannot_find_prog_unit_error
1552: (p_module_name => 'update_approver_group_item'
1553: ,p_hook_type => 'AP'
1554: );

Line 1551: hr_api.cannot_find_prog_unit_error

1547: ,p_end_date => l_end_date
1548: );
1549: exception
1550: when hr_api.cannot_find_prog_unit then
1551: hr_api.cannot_find_prog_unit_error
1552: (p_module_name => 'update_approver_group_item'
1553: ,p_hook_type => 'AP'
1554: );
1555: end;

Line 1560: raise hr_api.validate_enabled;

1556: --
1557: -- When in validation only mode raise the Validate_Enabled exception
1558: --
1559: if p_validate then
1560: raise hr_api.validate_enabled;
1561: end if;
1562: --
1563: -- Set all IN OUT and OUT parameters with out values.
1564: --

Line 1570: when hr_api.validate_enabled then

1566: p_end_date := l_end_date;
1567: --
1568: hr_utility.set_location(' Leaving:'||l_proc, 70);
1569: exception
1570: when hr_api.validate_enabled then
1571: --
1572: -- As the Validate_Enabled exception has been raised
1573: -- we must rollback to the savepoint
1574: --