DBA Data[Home] [Help]

APPS.JTF_RS_TEAM_MEMBERS_PVT dependencies on JTF_RS_TEAM_MEMBERS_PVT

Line 1: PACKAGE BODY jtf_rs_team_members_pvt AS

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,

Line 16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_RS_TEAM_MEMBERS_PVT';

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. */

Line 116: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 122: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 154: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 160: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 192: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 198: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 365: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 371: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 404: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 410: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 443: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 449: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 480: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 486: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 737: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 743: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 765: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 771: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 793: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 799: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 900: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 906: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 927: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 933: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 955: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 961: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 982: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 988: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1135: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1141: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1173: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1179: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1211: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1217: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1414: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1420: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1452: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1458: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1490: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1496: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1528: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1534: 'JTF_RS_TEAM_MEMBERS_PVT',

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

Line 1628: END jtf_rs_team_members_pvt;

1624: END delete_resource_team_members;
1625:
1626:
1627:
1628: END jtf_rs_team_members_pvt;