[Home] [Help]
9: p_action_type_id in number) return number as
10: l_proc varchar2(72) := g_package||'get_action_type_order_number';
11: l_order_number number;
12: begin
13: hr_utility.set_location('Entering:'|| l_proc, 10);
14: select order_number
15: into l_order_number
16: from ame_action_type_config
17: where
21: nvl(end_date - ame_util.oneSecond, sysdate);
22: return(l_order_number);
23: exception
24: when others then
25: hr_utility.set_location(' Leaving:'||l_proc, 60);
26: raise;
27: return(null);
28: end get_action_type_order_number;
29: --
31: l_proc varchar2(72) := g_package||'get_allowed_rule_type';
32: l_rule_type number;
33: l_temp_count number;
34: begin
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: select count(*)
37: into l_temp_count
38: from ame_action_type_usages
39: where
55: return(l_rule_type);
56: end if;
57: exception
58: when others then
59: hr_utility.set_location(' Leaving:'||l_proc, 60);
60: raise;
61: return(null);
62: end get_allowed_rule_type;
63: --
66: l_proc varchar2(72) := g_package||'get_max_order_number';
67: l_order_number number;
68: l_rule_type number;
69: begin
70: hr_utility.set_location('Entering:'|| l_proc, 10);
71: l_rule_type := get_allowed_rule_type(p_action_type_id => p_action_type_id);
72: select max(order_number)
73: into l_order_number
74: from ame_action_type_config,
87: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
88: return(l_order_number);
89: exception
90: when others then
91: hr_utility.set_location(' Leaving:'||l_proc, 50);
92: raise;
93: return(null);
94: end get_max_order_number;
95: --
99: l_proc varchar2(72) := g_package||'order_number_unique';
100: l_rule_type number;
101: l_temp_count number;
102: begin
103: hr_utility.set_location('Entering:'|| l_proc, 10);
104: l_rule_type := get_allowed_rule_type(p_action_type_id => p_action_type_id);
105: select count(*)
106: into l_temp_count
107: from ame_action_type_config,
125: return(true);
126: end if;
127: exception
128: when others then
129: hr_utility.set_location(' Leaving:'||l_proc, 60);
130: raise;
131: return(false);
132: end order_number_unique;
133: --
170: l_aty_start_date date;
171: l_acf_end_date date;
172: l_aty_end_date date;
173: begin
174: hr_utility.set_location('Entering:'|| l_proc, 10);
175: l_effective_date := sysdate;
176: l_rule_type := get_allowed_rule_type(p_action_type_id => p_action_type_id);
177: open c_sel1(p_ame_application_id => p_ame_application_id,
178: p_order_number => p_order_number,
194: ,p_start_date => l_acf_start_date
195: ,p_end_date => l_acf_end_date
196: );
197: end loop;
198: hr_utility.set_location(' Leaving:'||l_proc, 50);
199: exception
200: when others then
201: hr_utility.set_location(' Leaving:'||l_proc, 60);
202: rollback;
197: end loop;
198: hr_utility.set_location(' Leaving:'||l_proc, 50);
199: exception
200: when others then
201: hr_utility.set_location(' Leaving:'||l_proc, 60);
202: rollback;
203: raise;
204: end decrement_action_type_ord_nums;
205: --
244: l_aty_start_date date;
245: l_acf_end_date date;
246: l_aty_end_date date;
247: begin
248: hr_utility.set_location('Entering:'|| l_proc, 10);
249: l_effective_date := sysdate;
250: l_rule_type := get_allowed_rule_type(p_action_type_id => p_action_type_id);
251: open c_sel1(p_ame_application_id => p_ame_application_id,
252: p_action_type_id => p_action_type_id,
269: ,p_start_date => l_acf_start_date
270: ,p_end_date => l_acf_end_date
271: );
272: end loop;
273: hr_utility.set_location(' Leaving:'||l_proc, 50);
274: exception
275: when others then
276: hr_utility.set_location(' Leaving:'||l_proc, 60);
277: rollback;
272: end loop;
273: hr_utility.set_location(' Leaving:'||l_proc, 50);
274: exception
275: when others then
276: hr_utility.set_location(' Leaving:'||l_proc, 60);
277: rollback;
278: raise;
279: end increment_action_type_ord_nums;
280: --
324: l_language_code fnd_languages.language_code%TYPE;
325: l_application_ids ame_util.idList;
326: --
327: begin
328: hr_utility.set_location('Entering:'|| l_proc, 10);
329: -- Validate language code
330: l_language_code := p_language_code;
331: hr_api.validate_language_code(p_language_code => l_language_code);
332: -- Set the effective date to the sysdate
427: p_apu_object_version_number := l_apu_object_version_number;
428: p_apu_start_date := l_apu_start_date;
429: p_apu_end_date := l_apu_end_date;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc, 50);
432: exception
433: when hr_api.validate_enabled then
434: --
435: -- As the Validate_Enabled exception has been raised
448: p_apu_object_version_number := null;
449: p_apu_start_date := null;
450: p_apu_end_date := null;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 60);
453: --
454: when others then
455: --
456: -- A validation or unexpected error has occurred
462: p_apu_object_version_number := null;
463: p_apu_start_date := null;
464: p_apu_end_date := null;
465: --
466: hr_utility.set_location(' Leaving:'||l_proc, 70);
467: ROLLBACK TO create_ame_action_type;
468: raise;
469: --
470: end create_ame_action_type;
489: l_approver_count number;
490: l_rule_type number;
491: --
492: begin
493: hr_utility.set_location('Entering:'|| l_proc, 10);
494: --
495: -- Set the effective date to the sysdate
496: l_effective_date := sysdate;
497: -- Issue a savepoint.
597: p_object_version_number := l_object_version_number;
598: p_start_date := l_start_date;
599: p_end_date := l_end_date;
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 50);
602: exception
603: when hr_api.validate_enabled then
604: --
605: -- As the Validate_Enabled exception has been raised
614: p_object_version_number := null;
615: p_start_date := null;
616: p_end_date := null;
617: --
618: hr_utility.set_location(' Leaving:'||l_proc, 60);
619: --
620: when others then
621: --
622: -- A validation or unexpected error has occurred
624: p_object_version_number := null;
625: p_start_date := null;
626: p_end_date := null;
627: --
628: hr_utility.set_location(' Leaving:'||l_proc, 70);
629: ROLLBACK TO create_ame_action_type_usage;
630: raise;
631: --
632: end create_ame_action_type_usage;
649: l_start_date date;
650: l_end_date date;
651: --
652: begin
653: hr_utility.set_location('Entering:'|| l_proc, 10);
654: --
655: -- Set the effective date to the sysdate
656: l_effective_date := sysdate;
657: -- Issue a savepoint.
697: ,p_hook_type => 'AP'
698: );
699: end;
700: -- When in validation only mode raise the Validate_Enabled exception
701: hr_utility.set_location(l_proc, 9);
702: --
703: if p_validate then
704: raise hr_api.validate_enabled;
705: end if;
707: p_object_version_number := l_object_version_number;
708: p_start_date := l_start_date;
709: p_end_date := l_end_date;
710: --
711: hr_utility.set_location(' Leaving:'||l_proc, 50);
712: exception
713: when hr_api.validate_enabled then
714: --
715: -- As the Validate_Enabled exception has been raised
724: p_object_version_number := null;
725: p_start_date := null;
726: p_end_date := null;
727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 60);
729: --
730: when others then
731: --
732: -- A validation or unexpected error has occurred
734: p_object_version_number := null;
735: p_start_date := null;
736: p_end_date := null;
737: --
738: hr_utility.set_location(' Leaving:'||l_proc, 70);
739: ROLLBACK TO create_ame_appr_type_usage;
740: raise;
741: --
742: end create_ame_appr_type_usage;
762: l_start_date date;
763: l_end_date date;
764: --
765: begin
766: hr_utility.set_location('Entering:'|| l_proc, 10);
767: --
768: -- Set the effective date to the sysdate
769: l_effective_date := sysdate;
770: -- Issue a savepoint.
880: p_object_version_number := l_object_version_number;
881: p_start_date := l_start_date;
882: p_end_date := l_end_date;
883: --
884: hr_utility.set_location(' Leaving:'||l_proc, 50);
885: exception
886: when hr_api.validate_enabled then
887: --
888: -- As the Validate_Enabled exception has been raised
897: p_object_version_number := null;
898: p_start_date := null;
899: p_end_date := null;
900: --
901: hr_utility.set_location(' Leaving:'||l_proc, 60);
902: --
903: when others then
904: --
905: -- A validation or unexpected error has occurred
907: p_object_version_number := null;
908: p_start_date := null;
909: p_end_date := null;
910: --
911: hr_utility.set_location(' Leaving:'||l_proc, 70);
912: ROLLBACK TO create_ame_action_type_config;
913: raise;
914: --
915: end create_ame_action_type_conf;
953: l_attribute_type ame_attributes.attribute_type%TYPE;
954: l_query_string ame_attribute_usages.query_string%TYPE;
955: --
956: begin
957: hr_utility.set_location('Entering:'|| l_proc, 10);
958: --
959: -- Set the effective date to the sysdate
960: l_effective_date := sysdate;
961: -- Issue a savepoint.
1034: p_object_version_number := l_object_version_number;
1035: p_start_date := l_start_date;
1036: p_end_date := l_end_date;
1037: --
1038: hr_utility.set_location(' Leaving:'||l_proc, 50);
1039: exception
1040: when hr_api.validate_enabled then
1041: --
1042: -- As the Validate_Enabled exception has been raised
1051: p_object_version_number := null;
1052: p_start_date := null;
1053: p_end_date := null;
1054: --
1055: hr_utility.set_location(' Leaving:'||l_proc, 60);
1056: --
1057: when others then
1058: --
1059: -- A validation or unexpected error has occurred
1061: p_object_version_number := null;
1062: p_start_date := null;
1063: p_end_date := null;
1064: --
1065: hr_utility.set_location(' Leaving:'||l_proc, 70);
1066: ROLLBACK TO create_ame_req_attribute;
1067: raise;
1068: --
1069: end create_ame_req_attribute;
1113: l_action_type_name ame_action_types.name%TYPE;
1114: l_approver varchar2(100);
1115: --
1116: begin
1117: hr_utility.set_location('Entering:'|| l_proc, 10);
1118: --
1119: -- Validate language code
1120: l_language_code := p_language_code;
1121: hr_api.validate_language_code(p_language_code => l_language_code);
1201: p_object_version_number := l_object_version_number;
1202: p_start_date := l_start_date;
1203: p_end_date := l_end_date;
1204: --
1205: hr_utility.set_location(' Leaving:'||l_proc, 50);
1206: exception
1207: when hr_api.validate_enabled then
1208: --
1209: -- As the Validate_Enabled exception has been raised
1219: p_object_version_number := null;
1220: p_start_date := null;
1221: p_end_date := null;
1222: --
1223: hr_utility.set_location(' Leaving:'||l_proc, 60);
1224: --
1225: when others then
1226: --
1227: -- A validation or unexpected error has occurred
1230: p_object_version_number := null;
1231: p_start_date := null;
1232: p_end_date := null;
1233: --
1234: hr_utility.set_location(' Leaving:'||l_proc, 70);
1235: ROLLBACK TO create_ame_action;
1236: raise;
1237: --
1238: end create_ame_action;
1262: l_end_date date;
1263: l_language_code fnd_languages.language_code%TYPE;
1264: --
1265: begin
1266: hr_utility.set_location('Entering:'|| l_proc, 10);
1267: --
1268: -- Validate language code
1269: l_language_code := p_language_code;
1270: hr_api.validate_language_code(p_language_code => l_language_code);
1334: --
1335: p_object_version_number := l_object_version_number;
1336: p_start_date := l_start_date;
1337: p_end_date := l_end_date;
1338: hr_utility.set_location(' Leaving:'||l_proc, 50);
1339: exception
1340: when hr_api.validate_enabled then
1341: --
1342: -- As the Validate_Enabled exception has been raised
1351: p_object_version_number := null;
1352: p_start_date := null;
1353: p_end_date := null;
1354: --
1355: hr_utility.set_location(' Leaving:'||l_proc, 60);
1356: when others then
1357: --
1358: -- A validation or unexpected error has occurred
1359: --
1361: p_object_version_number := null;
1362: p_start_date := null;
1363: p_end_date := null;
1364: --
1365: hr_utility.set_location(' Leaving:'||l_proc, 70);
1366: ROLLBACK TO update_ame_action_type;
1367: raise;
1368: --
1369: end update_ame_action_type;
1397: l_old_order_number_unique varchar2(3);
1398: l_update_only_at_modified boolean;
1399: --
1400: begin
1401: hr_utility.set_location('Entering:'|| l_proc, 10);
1402: --
1403: -- Set the effective date to the sysdate
1404: l_effective_date := sysdate;
1405: l_object_version_number := p_object_version_number;
1466: --
1467: p_object_version_number := l_object_version_number;
1468: p_start_date := l_start_date;
1469: p_end_date := l_end_date;
1470: hr_utility.set_location(' Leaving:'||l_proc, 50);
1471: exception
1472: when hr_api.validate_enabled then
1473: --
1474: -- As the Validate_Enabled exception has been raised
1483: p_object_version_number := null;
1484: p_start_date := null;
1485: p_end_date := null;
1486: --
1487: hr_utility.set_location(' Leaving:'||l_proc, 60);
1488: --
1489: when others then
1490: --
1491: -- A validation or unexpected error has occurred
1494: p_object_version_number := null;
1495: p_start_date := null;
1496: p_end_date := null;
1497: --
1498: hr_utility.set_location(' Leaving:'||l_proc, 70);
1499: ROLLBACK TO update_ame_action_type_conf;
1500: raise;
1501: --
1502: end update_ame_action_type_conf;
1548: l_action_type_name ame_action_types.name%TYPE;
1549: l_approver varchar2(100);
1550: --
1551: begin
1552: hr_utility.set_location('Entering:'|| l_proc, 10);
1553: --
1554: -- Set the effective date to the sysdate
1555: l_effective_date := sysdate;
1556: l_object_version_number := p_object_version_number;
1638: --
1639: p_object_version_number := l_object_version_number;
1640: p_start_date := l_start_date;
1641: p_end_date := l_end_date;
1642: hr_utility.set_location(' Leaving:'||l_proc, 50);
1643: exception
1644: when hr_api.validate_enabled then
1645: --
1646: -- As the Validate_Enabled exception has been raised
1655: p_object_version_number := null;
1656: p_start_date := null;
1657: p_end_date := null;
1658: --
1659: hr_utility.set_location(' Leaving:'||l_proc, 60);
1660: when others then
1661: --
1662: -- A validation or unexpected error has occurred
1663: --
1665: p_object_version_number := null;
1666: p_start_date := null;
1667: p_end_date := null;
1668: --
1669: hr_utility.set_location(' Leaving:'||l_proc, 70);
1670: ROLLBACK TO update_ame_action;
1671: raise;
1672: --
1673: end update_ame_action;
1771: l_config_count number;
1772: l_rule_usage_count number;
1773: --
1774: begin
1775: hr_utility.set_location('Entering:'|| l_proc, 10);
1776: -- Issue a savepoint.
1777: --
1778: -- Set the effective date to the sysdate
1779: l_effective_date := sysdate;
1909: --
1910: p_object_version_number := l_aty_object_version_number;
1911: p_start_date := l_aty_start_date;
1912: p_end_date := l_aty_end_date;
1913: hr_utility.set_location(' Leaving:'||l_proc, 50);
1914: exception
1915: when hr_api.validate_enabled then
1916: --
1917: -- As the Validate_Enabled exception has been raised
1922: p_object_version_number := null;
1923: p_start_date := null;
1924: p_end_date := null;
1925: --
1926: hr_utility.set_location(' Leaving:'||l_proc, 60);
1927: when others then
1928: --
1929: -- A validation or unexpected error has occurred
1930: p_object_version_number := null;
1930: p_object_version_number := null;
1931: p_start_date := null;
1932: p_end_date := null;
1933: --
1934: hr_utility.set_location(' Leaving:'||l_proc, 70);
1935: ROLLBACK TO delete_ame_action_type;
1936: raise;
1937: --
1938: -- End of fix.
1958: l_start_date date;
1959: l_end_date date;
1960: --
1961: begin
1962: hr_utility.set_location('Entering:'|| l_proc, 10);
1963: --
1964: -- Set the effective date to the sysdate
1965: l_effective_date := sysdate;
1966: l_object_version_number := p_object_version_number;
2011: --
2012: p_object_version_number := l_object_version_number;
2013: p_start_date := l_start_date;
2014: p_end_date := l_end_date;
2015: hr_utility.set_location(' Leaving:'||l_proc, 50);
2016: exception
2017: when hr_api.validate_enabled then
2018: --
2019: p_object_version_number := null;
2019: p_object_version_number := null;
2020: p_start_date := null;
2021: p_end_date := null;
2022: --
2023: hr_utility.set_location(' Leaving:'||l_proc, 60);
2024: -- As the Validate_Enabled exception has been raised
2025: -- we must rollback to the savepoint
2026: --
2027: ROLLBACK TO delete_ame_action_type_usage;
2033: p_object_version_number := null;
2034: p_start_date := null;
2035: p_end_date := null;
2036: --
2037: hr_utility.set_location(' Leaving:'||l_proc, 70);
2038: ROLLBACK TO delete_ame_action_type_usage;
2039: raise;
2040: --
2041: end delete_ame_action_type_usage;
2060: l_end_date date;
2061: l_order_number number;
2062: --
2063: begin
2064: hr_utility.set_location('Entering:'|| l_proc, 10);
2065: --
2066: -- Set the effective date to the sysdate
2067: l_effective_date := sysdate;
2068: l_object_version_number := p_object_version_number;
2115: --
2116: p_object_version_number := l_object_version_number;
2117: p_start_date := l_start_date;
2118: p_end_date := l_end_date;
2119: hr_utility.set_location(' Leaving:'||l_proc, 50);
2120: exception
2121: when hr_api.validate_enabled then
2122: --
2123: p_object_version_number := null;
2123: p_object_version_number := null;
2124: p_start_date := null;
2125: p_end_date := null;
2126: --
2127: hr_utility.set_location(' Leaving:'||l_proc, 60);
2128: -- As the Validate_Enabled exception has been raised
2129: -- we must rollback to the savepoint
2130: --
2131: ROLLBACK TO delete_ame_action_type_conf;
2137: p_object_version_number := null;
2138: p_start_date := null;
2139: p_end_date := null;
2140: --
2141: hr_utility.set_location(' Leaving:'||l_proc, 70);
2142: ROLLBACK TO delete_ame_action_type_conf;
2143: raise;
2144: --
2145: end delete_ame_action_type_conf;
2163: l_start_date date;
2164: l_end_date date;
2165: --
2166: begin
2167: hr_utility.set_location('Entering:'|| l_proc, 10);
2168: --
2169: -- Set the effective date to the sysdate
2170: l_effective_date := sysdate;
2171: l_object_version_number := p_object_version_number;
2186: (p_module_name => 'delete_ame_appr_type_usage'
2187: ,p_hook_type => 'BP'
2188: );
2189: end;
2190: hr_utility.set_location(l_proc, 7);
2191: --
2192: ame_apu_del.del
2193: (p_action_type_id => p_action_type_id,
2194: p_approver_type_id => p_approver_type_id,
2219: --
2220: p_object_version_number := l_object_version_number;
2221: p_start_date := l_start_date;
2222: p_end_date := l_end_date;
2223: hr_utility.set_location(' Leaving:'||l_proc, 50);
2224: exception
2225: when hr_api.validate_enabled then
2226: --
2227: p_object_version_number := null;
2227: p_object_version_number := null;
2228: p_start_date := null;
2229: p_end_date := null;
2230: --
2231: hr_utility.set_location(' Leaving:'||l_proc, 60);
2232: -- As the Validate_Enabled exception has been raised
2233: -- we must rollback to the savepoint
2234: --
2235: ROLLBACK TO delete_ame_appr_type_usage;
2241: p_object_version_number := null;
2242: p_start_date := null;
2243: p_end_date := null;
2244: --
2245: hr_utility.set_location(' Leaving:'||l_proc, 70);
2246: ROLLBACK TO delete_ame_appr_type_usage;
2247: raise;
2248: --
2249: end delete_ame_appr_type_usage;
2268: l_start_date date;
2269: l_end_date date;
2270: --
2271: begin
2272: hr_utility.set_location('Entering:'|| l_proc, 10);
2273: --
2274: -- Set the effective date to the sysdate
2275: l_effective_date := sysdate;
2276: l_object_version_number := p_object_version_number;
2324: --
2325: p_object_version_number := l_object_version_number;
2326: p_start_date := l_start_date;
2327: p_end_date := l_end_date;
2328: hr_utility.set_location(' Leaving:'||l_proc, 50);
2329: exception
2330: when hr_api.validate_enabled then
2331: --
2332: p_object_version_number := null;
2332: p_object_version_number := null;
2333: p_start_date := null;
2334: p_end_date := null;
2335: --
2336: hr_utility.set_location(' Leaving:'||l_proc, 60);
2337: -- As the Validate_Enabled exception has been raised
2338: -- we must rollback to the savepoint
2339: --
2340: ROLLBACK TO delete_ame_req_attribute;
2347: p_object_version_number := null;
2348: p_start_date := null;
2349: p_end_date := null;
2350: --
2351: hr_utility.set_location(' Leaving:'||l_proc, 70);
2352: ROLLBACK TO delete_ame_req_attribute;
2353: raise;
2354: --
2355: end delete_ame_req_attribute;
2374: l_start_date date;
2375: l_end_date date;
2376: --
2377: begin
2378: hr_utility.set_location('Entering:'|| l_proc, 10);
2379: --
2380: -- Set the effective date to the sysdate
2381: l_effective_date := sysdate;
2382: l_object_version_number := p_object_version_number;
2395: (p_module_name => 'delete_ame_action'
2396: ,p_hook_type => 'BP'
2397: );
2398: end;
2399: hr_utility.set_location(l_proc, 7);
2400: -- Process Logic
2401: ame_act_del.del
2402: (p_action_id => p_action_id,
2403: p_action_type_id => p_action_type_id,
2427: --
2428: p_object_version_number := l_object_version_number;
2429: p_start_date := l_start_date;
2430: p_end_date := l_end_date;
2431: hr_utility.set_location(' Leaving:'||l_proc, 50);
2432: exception
2433: when hr_api.validate_enabled then
2434: --
2435: p_object_version_number := null;
2435: p_object_version_number := null;
2436: p_start_date := null;
2437: p_end_date := null;
2438: --
2439: hr_utility.set_location(' Leaving:'||l_proc, 60);
2440: -- As the Validate_Enabled exception has been raised
2441: -- we must rollback to the savepoint
2442: --
2443: ROLLBACK TO delete_ame_action;
2449: p_object_version_number := null;
2450: p_start_date := null;
2451: p_end_date := null;
2452: --
2453: hr_utility.set_location(' Leaving:'||l_proc, 70);
2454: ROLLBACK TO delete_ame_action;
2455: raise;
2456: --
2457: end delete_ame_action;