[Home] [Help]
313: -- Calling Private package: Create_Deliverable
314: -- Hint: Primary key needs to be returned
315:
316: -- customer pre-processing
317: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
318: THEN
319: AMS_Deliverable_CUHK.create_deliverable_pre(
320: l_pvt_Deliv_rec,
321: l_return_status
328: END IF;
329: END IF;
330:
331: -- vertical industry pre-processing
332: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'V')
333: THEN
334: AMS_Deliverable_VUHK.create_deliverable_pre(
335: l_pvt_Deliv_rec,
336: l_return_status
365: -- End of API body.
366: --
367:
368: -- customer pre-processing
369: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'C')
370: THEN
371: AMS_Deliverable_CUHK.create_deliverable_post(
372: l_pvt_Deliv_rec,
373: x_Deliv_id,
383:
384:
385:
386: -- vertical industry pre-processing
387: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'V')
388: THEN
389: AMS_Deliverable_VUHK.create_deliverable_post(
390: l_pvt_Deliv_rec,
391: x_Deliv_id,
636: -- Initialize API return status to SUCCESS
637: x_return_status := FND_API.G_RET_STS_SUCCESS;
638:
639: -- customer pre-processing
640: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
641: THEN
642: AMS_Deliverable_CUHK.update_deliverable_pre(
643: l_pvt_deliv_rec,
644: l_return_status
651: END IF;
652: END IF;
653:
654: -- vertical industry pre-processing
655: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'V')
656: THEN
657: AMS_Deliverable_VUHK.update_deliverable_pre(
658: l_pvt_deliv_rec,
659: l_return_status
694: THEN
695: COMMIT WORK;
696: END IF;
697:
698: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'C')
699: THEN
700: AMS_Deliverable_CUHK.update_deliverable_post(
701: l_pvt_deliv_rec,
702: l_return_status
709: END IF;
710: END IF;
711:
712: -- vertical industry pre-processing
713: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'V')
714: THEN
715: AMS_Deliverable_VUHK.update_deliverable_post(
716: l_pvt_deliv_rec,
717: l_return_status
828: -- Initialize API return status to SUCCESS
829: x_return_status := FND_API.G_RET_STS_SUCCESS;
830:
831: -- customer pre-processing
832: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
833: THEN
834: AMS_Deliverable_CUHK.delete_Deliverable_pre(
835: l_deliv_ID,
836: l_object_version_number,
844: END IF;
845: END IF;
846:
847: -- vertical industry pre-processing
848: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'V')
849: THEN
850: AMS_Deliverable_VUHK.delete_Deliverable_pre(
851: l_deliv_ID,
852: l_object_version_number,
885: -- End of API body
886: --
887:
888: -- customer pre-processing
889: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'C')
890: THEN
891: AMS_Deliverable_CUHK.delete_Deliverable_post(
892: l_deliv_ID,
893: l_object_version_number,
901: END IF;
902: END IF;
903:
904: -- vertical industry pre-processing
905: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'V')
906: THEN
907: AMS_Deliverable_VUHK.delete_Deliverable_post(
908: l_deliv_ID,
909: l_object_version_number,
1010: x_return_status := FND_API.G_RET_STS_SUCCESS;
1011:
1012:
1013: -- customer pre-processing
1014: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
1015: THEN
1016: AMS_Deliverable_CUHK.validate_deliverable_pre(
1017: l_pvt_deliv_rec,
1018: l_return_status
1025: END IF;
1026: END IF;
1027:
1028: -- vertical industry pre-processing
1029: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'V')
1030: THEN
1031: AMS_Deliverable_VUHK.validate_deliverable_pre(
1032: l_pvt_deliv_rec,
1033: l_return_status
1064:
1065:
1066:
1067: -- vertical industry post-processing
1068: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'V')
1069: THEN
1070: AMS_Deliverable_VUHK.validate_deliverable_post(
1071: l_pvt_deliv_rec,
1072: l_return_status
1079: END IF;
1080: END IF;
1081:
1082: -- customer post-processing
1083: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'C')
1084: THEN
1085: AMS_Deliverable_CUHK.validate_deliverable_post(
1086: l_pvt_deliv_rec,
1087: l_return_status
1187: -- Initialize API return status to SUCCESS
1188: x_return_status := FND_API.G_RET_STS_SUCCESS;
1189: --
1190: -- customer pre-processing
1191: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
1192: THEN
1193: AMS_Deliverable_CUHK.lock_deliverable_pre(
1194: l_deliv_ID,
1195: l_object_version_number,
1203: END IF;
1204: END IF;
1205:
1206: -- vertical industry pre-processing
1207: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'V')
1208: THEN
1209: AMS_Deliverable_VUHK.lock_Deliverable_pre(
1210: l_deliv_ID,
1211: l_object_version_number,
1243: --
1244: -- End of API body.
1245: --
1246: -- customer pre-processing
1247: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'C')
1248: THEN
1249: AMS_Deliverable_CUHK.lock_Deliverable_post(
1250: l_deliv_ID,
1251: l_object_version_number,
1259: END IF;
1260: END IF;
1261:
1262: -- vertical industry pre-processing
1263: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'V')
1264: THEN
1265: AMS_Deliverable_VUHK.lock_Deliverable_post(
1266: l_deliv_ID,
1267: l_object_version_number,