1: PACKAGE BODY jtf_rs_group_usages_pvt AS
2: /* $Header: jtfrsvab.pls 120.0 2005/05/11 08:22:52 appldev ship $ */
3:
4: /*****************************************************************************************
5: This private package body defines the procedures for managing resource group usages,
13:
14:
15: /* Package variables. */
16:
17: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_GROUP_USAGES_PVT';
18:
19:
20: /* Procedure to create the resource group usage
21: based on input values passed by calling routines. */
135:
136: /* Pre Call to the Customer Type User Hook */
137:
138: IF jtf_resource_utl.ok_to_execute(
139: 'JTF_RS_GROUP_USAGES_PVT',
140: 'CREATE_GROUP_USAGE',
141: 'B',
142: 'C')
143: THEN
141: 'B',
142: 'C')
143: THEN
144: IF jtf_usr_hks.ok_to_execute(
145: 'JTF_RS_GROUP_USAGES_PVT',
146: 'CREATE_GROUP_USAGE',
147: 'B',
148: 'C')
149: THEN
172:
173: /* Pre Call to the Vertical Type User Hook */
174:
175: IF jtf_resource_utl.ok_to_execute(
176: 'JTF_RS_GROUP_USAGES_PVT',
177: 'CREATE_GROUP_USAGE',
178: 'B',
179: 'V')
180: THEN
178: 'B',
179: 'V')
180: THEN
181: IF jtf_usr_hks.ok_to_execute(
182: 'JTF_RS_GROUP_USAGES_PVT',
183: 'CREATE_GROUP_USAGE',
184: 'B',
185: 'V')
186: THEN
209:
210: /* Pre Call to the Internal Type User Hook */
211:
212: IF jtf_resource_utl.ok_to_execute(
213: 'JTF_RS_GROUP_USAGES_PVT',
214: 'CREATE_GROUP_USAGE',
215: 'B',
216: 'I')
217: THEN
215: 'B',
216: 'I')
217: THEN
218: IF jtf_usr_hks.ok_to_execute(
219: 'JTF_RS_GROUP_USAGES_PVT',
220: 'CREATE_GROUP_USAGE',
221: 'B',
222: 'I')
223: THEN
393:
394: /* Post Call to the Customer Type User Hook */
395:
396: IF jtf_resource_utl.ok_to_execute(
397: 'JTF_RS_GROUP_USAGES_PVT',
398: 'CREATE_GROUP_USAGE',
399: 'A',
400: 'C')
401: THEN
399: 'A',
400: 'C')
401: THEN
402: IF jtf_usr_hks.ok_to_execute(
403: 'JTF_RS_GROUP_USAGES_PVT',
404: 'CREATE_GROUP_USAGE',
405: 'A',
406: 'C')
407: THEN
431:
432: /* Post Call to the Vertical Type User Hook */
433:
434: IF jtf_resource_utl.ok_to_execute(
435: 'JTF_RS_GROUP_USAGES_PVT',
436: 'CREATE_GROUP_USAGE',
437: 'A',
438: 'V')
439: THEN
437: 'A',
438: 'V')
439: THEN
440: IF jtf_usr_hks.ok_to_execute(
441: 'JTF_RS_GROUP_USAGES_PVT',
442: 'CREATE_GROUP_USAGE',
443: 'A',
444: 'V')
445: THEN
469:
470: /* Post Call to the Internal Type User Hook */
471:
472: IF jtf_resource_utl.ok_to_execute(
473: 'JTF_RS_GROUP_USAGES_PVT',
474: 'CREATE_GROUP_USAGE',
475: 'A',
476: 'I')
477: THEN
475: 'A',
476: 'I')
477: THEN
478: IF jtf_usr_hks.ok_to_execute(
479: 'JTF_RS_GROUP_USAGES_PVT',
480: 'CREATE_GROUP_USAGE',
481: 'A',
482: 'I')
483: THEN
505:
506: /* Standard call for Message Generation */
507:
508: IF jtf_resource_utl.ok_to_execute(
509: 'JTF_RS_GROUP_USAGES_PVT',
510: 'CREATE_GROUP_USAGE',
511: 'M',
512: 'M')
513: THEN
511: 'M',
512: 'M')
513: THEN
514: IF jtf_usr_hks.ok_to_execute(
515: 'JTF_RS_GROUP_USAGES_PVT',
516: 'CREATE_GROUP_USAGE',
517: 'M',
518: 'M')
519: THEN
686:
687: /* Pre Call to the Customer Type User Hook */
688:
689: IF jtf_resource_utl.ok_to_execute(
690: 'JTF_RS_GROUP_USAGES_PVT',
691: 'DELETE_GROUP_USAGE',
692: 'B',
693: 'C')
694: THEN
692: 'B',
693: 'C')
694: THEN
695: IF jtf_usr_hks.ok_to_execute(
696: 'JTF_RS_GROUP_USAGES_PVT',
697: 'DELETE_GROUP_USAGE',
698: 'B',
699: 'C')
700: THEN
723:
724: /* Pre Call to the Vertical Type User Hook */
725:
726: IF jtf_resource_utl.ok_to_execute(
727: 'JTF_RS_GROUP_USAGES_PVT',
728: 'DELETE_GROUP_USAGE',
729: 'B',
730: 'V')
731: THEN
729: 'B',
730: 'V')
731: THEN
732: IF jtf_usr_hks.ok_to_execute(
733: 'JTF_RS_GROUP_USAGES_PVT',
734: 'DELETE_GROUP_USAGE',
735: 'B',
736: 'V')
737: THEN
760:
761: /* Pre Call to the Internal Type User Hook */
762:
763: IF jtf_resource_utl.ok_to_execute(
764: 'JTF_RS_GROUP_USAGES_PVT',
765: 'DELETE_GROUP_USAGE',
766: 'B',
767: 'I')
768: THEN
766: 'B',
767: 'I')
768: THEN
769: IF jtf_usr_hks.ok_to_execute(
770: 'JTF_RS_GROUP_USAGES_PVT',
771: 'DELETE_GROUP_USAGE',
772: 'B',
773: 'I')
774: THEN
909:
910: /* Post Call to the Customer Type User Hook */
911:
912: IF jtf_resource_utl.ok_to_execute(
913: 'JTF_RS_GROUP_USAGES_PVT',
914: 'DELETE_GROUP_USAGE',
915: 'A',
916: 'C')
917: THEN
915: 'A',
916: 'C')
917: THEN
918: IF jtf_usr_hks.ok_to_execute(
919: 'JTF_RS_GROUP_USAGES_PVT',
920: 'DELETE_GROUP_USAGE',
921: 'A',
922: 'C')
923: THEN
946:
947: /* Post Call to the Vertical Type User Hook */
948:
949: IF jtf_resource_utl.ok_to_execute(
950: 'JTF_RS_GROUP_USAGES_PVT',
951: 'DELETE_GROUP_USAGE',
952: 'A',
953: 'V')
954: THEN
952: 'A',
953: 'V')
954: THEN
955: IF jtf_usr_hks.ok_to_execute(
956: 'JTF_RS_GROUP_USAGES_PVT',
957: 'DELETE_GROUP_USAGE',
958: 'A',
959: 'V')
960: THEN
983:
984: /* Post Call to the Internal Type User Hook */
985:
986: IF jtf_resource_utl.ok_to_execute(
987: 'JTF_RS_GROUP_USAGES_PVT',
988: 'DELETE_GROUP_USAGE',
989: 'A',
990: 'I')
991: THEN
989: 'A',
990: 'I')
991: THEN
992: IF jtf_usr_hks.ok_to_execute(
993: 'JTF_RS_GROUP_USAGES_PVT',
994: 'DELETE_GROUP_USAGE',
995: 'A',
996: 'I')
997: THEN
1018:
1019: /* Standard call for Message Generation */
1020:
1021: IF jtf_resource_utl.ok_to_execute(
1022: 'JTF_RS_GROUP_USAGES_PVT',
1023: 'DELETE_GROUP_USAGE',
1024: 'M',
1025: 'M')
1026: THEN
1024: 'M',
1025: 'M')
1026: THEN
1027: IF jtf_usr_hks.ok_to_execute(
1028: 'JTF_RS_GROUP_USAGES_PVT',
1029: 'DELETE_GROUP_USAGE',
1030: 'M',
1031: 'M')
1032: THEN
1129:
1130: END delete_group_usage;
1131:
1132:
1133: END jtf_rs_group_usages_pvt;