1: PACKAGE BODY jtf_rs_team_members_pvt AS
2: /* $Header: jtfrsveb.pls 120.0 2005/05/11 08:22:56 appldev ship $ */
3:
4: /*****************************************************************************************
5: This private package body defines the procedures for managing resource team members,
12: ******************************************************************************************/
13:
14: /* Package variables. */
15:
16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_RS_TEAM_MEMBERS_PVT';
17:
18:
19: /* Procedure to create the resource team members
20: based on input values passed by calling routines. */
112:
113: /* Pre Call to the Customer Type User Hook */
114:
115: IF jtf_resource_utl.ok_to_execute(
116: 'JTF_RS_TEAM_MEMBERS_PVT',
117: 'CREATE_RESOURCE_TEAM_MEMBERS',
118: 'B',
119: 'C')
120: THEN
118: 'B',
119: 'C')
120: THEN
121: IF jtf_usr_hks.ok_to_execute(
122: 'JTF_RS_TEAM_MEMBERS_PVT',
123: 'CREATE_RESOURCE_TEAM_MEMBERS',
124: 'B',
125: 'C')
126: THEN
150:
151: /* Pre Call to the Vertical Type User Hook */
152:
153: IF jtf_resource_utl.ok_to_execute(
154: 'JTF_RS_TEAM_MEMBERS_PVT',
155: 'CREATE_RESOURCE_TEAM_MEMBERS',
156: 'B',
157: 'V')
158: THEN
156: 'B',
157: 'V')
158: THEN
159: IF jtf_usr_hks.ok_to_execute(
160: 'JTF_RS_TEAM_MEMBERS_PVT',
161: 'CREATE_RESOURCE_TEAM_MEMBERS',
162: 'B',
163: 'V')
164: THEN
188:
189: /* Pre Call to the Internal Type User Hook */
190:
191: IF jtf_resource_utl.ok_to_execute(
192: 'JTF_RS_TEAM_MEMBERS_PVT',
193: 'CREATE_RESOURCE_TEAM_MEMBERS',
194: 'B',
195: 'I')
196: THEN
194: 'B',
195: 'I')
196: THEN
197: IF jtf_usr_hks.ok_to_execute(
198: 'JTF_RS_TEAM_MEMBERS_PVT',
199: 'CREATE_RESOURCE_TEAM_MEMBERS',
200: 'B',
201: 'I')
202: THEN
361:
362: /* Post Call to the Customer Type User Hook */
363:
364: IF jtf_resource_utl.ok_to_execute(
365: 'JTF_RS_TEAM_MEMBERS_PVT',
366: 'CREATE_RESOURCE_TEAM_MEMBERS',
367: 'A',
368: 'C')
369: THEN
367: 'A',
368: 'C')
369: THEN
370: IF jtf_usr_hks.ok_to_execute(
371: 'JTF_RS_TEAM_MEMBERS_PVT',
372: 'CREATE_RESOURCE_TEAM_MEMBERS',
373: 'A',
374: 'C')
375: THEN
400:
401: /* Post Call to the Vertical Type User Hook */
402:
403: IF jtf_resource_utl.ok_to_execute(
404: 'JTF_RS_TEAM_MEMBERS_PVT',
405: 'CREATE_RESOURCE_TEAM_MEMBERS',
406: 'A',
407: 'V')
408: THEN
406: 'A',
407: 'V')
408: THEN
409: IF jtf_usr_hks.ok_to_execute(
410: 'JTF_RS_TEAM_MEMBERS_PVT',
411: 'CREATE_RESOURCE_TEAM_MEMBERS',
412: 'A',
413: 'V')
414: THEN
439:
440: /* Post Call to the Internal Type User Hook */
441:
442: IF jtf_resource_utl.ok_to_execute(
443: 'JTF_RS_TEAM_MEMBERS_PVT',
444: 'CREATE_RESOURCE_TEAM_MEMBERS',
445: 'A',
446: 'I')
447: THEN
445: 'A',
446: 'I')
447: THEN
448: IF jtf_usr_hks.ok_to_execute(
449: 'JTF_RS_TEAM_MEMBERS_PVT',
450: 'CREATE_RESOURCE_TEAM_MEMBERS',
451: 'A',
452: 'I')
453: THEN
476:
477: /* Standard call for Message Generation */
478:
479: IF jtf_resource_utl.ok_to_execute(
480: 'JTF_RS_TEAM_MEMBERS_PVT',
481: 'CREATE_RESOURCE_TEAM_MEMBERS',
482: 'M',
483: 'M')
484: THEN
482: 'M',
483: 'M')
484: THEN
485: IF jtf_usr_hks.ok_to_execute(
486: 'JTF_RS_TEAM_MEMBERS_PVT',
487: 'CREATE_RESOURCE_TEAM_MEMBERS',
488: 'M',
489: 'M')
490: THEN
733:
734: /* Pre Call to the Customer Type User Hook */
735:
736: IF jtf_resource_utl.ok_to_execute(
737: 'JTF_RS_TEAM_MEMBERS_PVT',
738: 'UPDATE_RESOURCE_TEAM_MEMBERS',
739: 'B',
740: 'C')
741: THEN
739: 'B',
740: 'C')
741: THEN
742: IF jtf_usr_hks.ok_to_execute(
743: 'JTF_RS_TEAM_MEMBERS_PVT',
744: 'UPDATE_RESOURCE_TEAM_MEMBERS',
745: 'B',
746: 'C')
747: THEN
761:
762: /* Pre Call to the Vertical Type User Hook */
763:
764: IF jtf_resource_utl.ok_to_execute(
765: 'JTF_RS_TEAM_MEMBERS_PVT',
766: 'UPDATE_RESOURCE_TEAM_MEMBERS',
767: 'B',
768: 'V')
769: THEN
767: 'B',
768: 'V')
769: THEN
770: IF jtf_usr_hks.ok_to_execute(
771: 'JTF_RS_TEAM_MEMBERS_PVT',
772: 'UPDATE_RESOURCE_TEAM_MEMBERS',
773: 'B',
774: 'V')
775: THEN
789:
790: /* Pre Call to the Internal Type User Hook */
791:
792: IF jtf_resource_utl.ok_to_execute(
793: 'JTF_RS_TEAM_MEMBERS_PVT',
794: 'UPDATE_RESOURCE_TEAM_MEMBERS',
795: 'B',
796: 'I')
797: THEN
795: 'B',
796: 'I')
797: THEN
798: IF jtf_usr_hks.ok_to_execute(
799: 'JTF_RS_TEAM_MEMBERS_PVT',
800: 'UPDATE_RESOURCE_TEAM_MEMBERS',
801: 'B',
802: 'I')
803: THEN
896:
897: /* Post Call to the Customer Type User Hook */
898:
899: IF jtf_resource_utl.ok_to_execute(
900: 'JTF_RS_TEAM_MEMBERS_PVT',
901: 'UPDATE_RESOURCE_TEAM_MEMBERS',
902: 'A',
903: 'C')
904: THEN
902: 'A',
903: 'C')
904: THEN
905: IF jtf_usr_hks.ok_to_execute(
906: 'JTF_RS_TEAM_MEMBERS_PVT',
907: 'UPDATE_RESOURCE_TEAM_MEMBERS',
908: 'A',
909: 'C')
910: THEN
923:
924: /* Post Call to the Vertical Type User Hook */
925:
926: IF jtf_resource_utl.ok_to_execute(
927: 'JTF_RS_TEAM_MEMBERS_PVT',
928: 'UPDATE_RESOURCE_TEAM_MEMBERS',
929: 'A',
930: 'V')
931: THEN
929: 'A',
930: 'V')
931: THEN
932: IF jtf_usr_hks.ok_to_execute(
933: 'JTF_RS_TEAM_MEMBERS_PVT',
934: 'UPDATE_RESOURCE_TEAM_MEMBERS',
935: 'A',
936: 'V')
937: THEN
951:
952: /* Post Call to the Internal Type User Hook */
953:
954: IF jtf_resource_utl.ok_to_execute(
955: 'JTF_RS_TEAM_MEMBERS_PVT',
956: 'UPDATE_RESOURCE_TEAM_MEMBERS',
957: 'A',
958: 'I')
959: THEN
957: 'A',
958: 'I')
959: THEN
960: IF jtf_usr_hks.ok_to_execute(
961: 'JTF_RS_TEAM_MEMBERS_PVT',
962: 'UPDATE_RESOURCE_TEAM_MEMBERS',
963: 'A',
964: 'I')
965: THEN
978:
979: /* Standard call for Message Generation */
980:
981: IF jtf_resource_utl.ok_to_execute(
982: 'JTF_RS_TEAM_MEMBERS_PVT',
983: 'UPDATE_RESOURCE_TEAM_MEMBERS',
984: 'M',
985: 'M')
986: THEN
984: 'M',
985: 'M')
986: THEN
987: IF jtf_usr_hks.ok_to_execute(
988: 'JTF_RS_TEAM_MEMBERS_PVT',
989: 'UPDATE_RESOURCE_TEAM_MEMBERS',
990: 'M',
991: 'M')
992: THEN
1131:
1132: /* Pre Call to the Customer Type User Hook */
1133:
1134: IF jtf_resource_utl.ok_to_execute(
1135: 'JTF_RS_TEAM_MEMBERS_PVT',
1136: 'DELETE_RESOURCE_TEAM_MEMBERS',
1137: 'B',
1138: 'C')
1139: THEN
1137: 'B',
1138: 'C')
1139: THEN
1140: IF jtf_usr_hks.ok_to_execute(
1141: 'JTF_RS_TEAM_MEMBERS_PVT',
1142: 'DELETE_RESOURCE_TEAM_MEMBERS',
1143: 'B',
1144: 'C')
1145: THEN
1169:
1170: /* Pre Call to the Vertical Type User Hook */
1171:
1172: IF jtf_resource_utl.ok_to_execute(
1173: 'JTF_RS_TEAM_MEMBERS_PVT',
1174: 'DELETE_RESOURCE_TEAM_MEMBERS',
1175: 'B',
1176: 'V')
1177: THEN
1175: 'B',
1176: 'V')
1177: THEN
1178: IF jtf_usr_hks.ok_to_execute(
1179: 'JTF_RS_TEAM_MEMBERS_PVT',
1180: 'DELETE_RESOURCE_TEAM_MEMBERS',
1181: 'B',
1182: 'V')
1183: THEN
1207:
1208: /* Pre Call to the Internal Type User Hook */
1209:
1210: IF jtf_resource_utl.ok_to_execute(
1211: 'JTF_RS_TEAM_MEMBERS_PVT',
1212: 'DELETE_RESOURCE_TEAM_MEMBERS',
1213: 'B',
1214: 'I')
1215: THEN
1213: 'B',
1214: 'I')
1215: THEN
1216: IF jtf_usr_hks.ok_to_execute(
1217: 'JTF_RS_TEAM_MEMBERS_PVT',
1218: 'DELETE_RESOURCE_TEAM_MEMBERS',
1219: 'B',
1220: 'I')
1221: THEN
1410:
1411: /* Post Call to the Customer Type User Hook */
1412:
1413: IF jtf_resource_utl.ok_to_execute(
1414: 'JTF_RS_TEAM_MEMBERS_PVT',
1415: 'DELETE_RESOURCE_TEAM_MEMBERS',
1416: 'A',
1417: 'C')
1418: THEN
1416: 'A',
1417: 'C')
1418: THEN
1419: IF jtf_usr_hks.ok_to_execute(
1420: 'JTF_RS_TEAM_MEMBERS_PVT',
1421: 'DELETE_RESOURCE_TEAM_MEMBERS',
1422: 'A',
1423: 'C')
1424: THEN
1448:
1449: /* Post Call to the Vertical Type User Hook */
1450:
1451: IF jtf_resource_utl.ok_to_execute(
1452: 'JTF_RS_TEAM_MEMBERS_PVT',
1453: 'DELETE_RESOURCE_TEAM_MEMBERS',
1454: 'A',
1455: 'V')
1456: THEN
1454: 'A',
1455: 'V')
1456: THEN
1457: IF jtf_usr_hks.ok_to_execute(
1458: 'JTF_RS_TEAM_MEMBERS_PVT',
1459: 'DELETE_RESOURCE_TEAM_MEMBERS',
1460: 'A',
1461: 'V')
1462: THEN
1486:
1487: /* Post Call to the Internal Type User Hook */
1488:
1489: IF jtf_resource_utl.ok_to_execute(
1490: 'JTF_RS_TEAM_MEMBERS_PVT',
1491: 'DELETE_RESOURCE_TEAM_MEMBERS',
1492: 'A',
1493: 'I')
1494: THEN
1492: 'A',
1493: 'I')
1494: THEN
1495: IF jtf_usr_hks.ok_to_execute(
1496: 'JTF_RS_TEAM_MEMBERS_PVT',
1497: 'DELETE_RESOURCE_TEAM_MEMBERS',
1498: 'A',
1499: 'I')
1500: THEN
1524:
1525: /* Standard call for Message Generation */
1526:
1527: IF jtf_resource_utl.ok_to_execute(
1528: 'JTF_RS_TEAM_MEMBERS_PVT',
1529: 'DELETE_RESOURCE_TEAM_MEMBERS',
1530: 'M',
1531: 'M')
1532: THEN
1530: 'M',
1531: 'M')
1532: THEN
1533: IF jtf_usr_hks.ok_to_execute(
1534: 'JTF_RS_TEAM_MEMBERS_PVT',
1535: 'DELETE_RESOURCE_TEAM_MEMBERS',
1536: 'M',
1537: 'M')
1538: THEN
1624: END delete_resource_team_members;
1625:
1626:
1627:
1628: END jtf_rs_team_members_pvt;