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 163: delete from ame_approval_group_members where approval_group_id = hr_api.g_number;

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

Line 183: hr_api.userenv_lang

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

Line 242: when hr_api.cannot_find_prog_unit then

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

Line 243: hr_api.cannot_find_prog_unit_error

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

Line 317: when hr_api.cannot_find_prog_unit then

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

Line 318: hr_api.cannot_find_prog_unit_error

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

Line 327: raise hr_api.validate_enabled;

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

Line 340: when hr_api.validate_enabled then

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

Line 383: hr_api.userenv_lang

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

Line 384: ,p_description in varchar2 default hr_api.g_varchar2

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

Line 385: ,p_is_static in varchar2 default hr_api.g_varchar2

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

Line 386: ,p_query_string in varchar2 default hr_api.g_varchar2

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

Line 440: when hr_api.cannot_find_prog_unit then

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

Line 441: hr_api.cannot_find_prog_unit_error

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

Line 455: ,p_datetrack_mode => hr_api.g_update

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

Line 461: ,p_security_group_id => hr_api.g_number

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

Line 482: ,p_datetrack_mode => hr_api.g_delete

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

Line 513: when hr_api.cannot_find_prog_unit then

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

Line 514: hr_api.cannot_find_prog_unit_error

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

Line 523: raise hr_api.validate_enabled;

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

Line 533: when hr_api.validate_enabled then

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

Line 651: when hr_api.cannot_find_prog_unit then

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

Line 652: hr_api.cannot_find_prog_unit_error

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

Line 703: ,p_datetrack_mode => hr_api.g_delete

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

Line 711: ,p_datetrack_mode => hr_api.g_delete

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

Line 735: when hr_api.cannot_find_prog_unit then

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

Line 736: hr_api.cannot_find_prog_unit_error

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

Line 745: raise hr_api.validate_enabled;

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

Line 755: when hr_api.validate_enabled then

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

Line 835: when hr_api.cannot_find_prog_unit then

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

Line 836: hr_api.cannot_find_prog_unit_error

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

Line 867: when hr_api.cannot_find_prog_unit then

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

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

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

Line 876: raise hr_api.validate_enabled;

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

Line 887: when hr_api.validate_enabled then

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

Line 964: when hr_api.cannot_find_prog_unit then

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

Line 965: hr_api.cannot_find_prog_unit_error

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

Line 974: ,p_datetrack_mode => hr_api.g_delete

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

Line 993: when hr_api.cannot_find_prog_unit then

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

Line 994: hr_api.cannot_find_prog_unit_error

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

Line 1003: raise hr_api.validate_enabled;

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

Line 1013: when hr_api.validate_enabled then

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

Line 1057: ,p_voting_regime in varchar2 default hr_api.g_varchar2

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

Line 1058: ,p_order_number in varchar2 default hr_api.g_number

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

Line 1093: when hr_api.cannot_find_prog_unit then

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

Line 1094: hr_api.cannot_find_prog_unit_error

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

Line 1103: ,p_datetrack_mode => hr_api.g_update

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

Line 1126: when hr_api.cannot_find_prog_unit then

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

Line 1127: hr_api.cannot_find_prog_unit_error

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

Line 1136: raise hr_api.validate_enabled;

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

Line 1146: when hr_api.validate_enabled then

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

Line 1227: when hr_api.cannot_find_prog_unit then

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

Line 1228: hr_api.cannot_find_prog_unit_error

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

Line 1262: when hr_api.cannot_find_prog_unit then

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

Line 1263: hr_api.cannot_find_prog_unit_error

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

Line 1272: raise hr_api.validate_enabled;

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

Line 1283: when hr_api.validate_enabled then

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

Line 1364: when hr_api.cannot_find_prog_unit then

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

Line 1365: hr_api.cannot_find_prog_unit_error

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

Line 1384: ,p_datetrack_mode => hr_api.g_delete

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

Line 1405: when hr_api.cannot_find_prog_unit then

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

Line 1406: hr_api.cannot_find_prog_unit_error

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

Line 1415: raise hr_api.validate_enabled;

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

Line 1425: when hr_api.validate_enabled then

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

Line 1469: ,p_order_number in varchar2 default hr_api.g_number

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

Line 1509: when hr_api.cannot_find_prog_unit then

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

Line 1510: hr_api.cannot_find_prog_unit_error

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

Line 1529: ,p_datetrack_mode => hr_api.g_update

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

Line 1552: when hr_api.cannot_find_prog_unit then

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

Line 1553: hr_api.cannot_find_prog_unit_error

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

Line 1562: raise hr_api.validate_enabled;

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

Line 1572: when hr_api.validate_enabled then

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