1: PACKAGE BODY jtf_rs_team_usages_pvt AS
2: /* $Header: jtfrsvjb.pls 120.0 2005/05/11 08:23:04 appldev ship $ */
3:
4: /*****************************************************************************************
5: This private package body defines the procedures for managing resource team usages,
13:
14:
15: /* Package variables. */
16:
17: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_TEAM_USAGES_PVT';
18:
19:
20: /* Procedure to create the resource team usage
21: based on input values passed by calling routines. */
131:
132: /* Pre Call to the Customer Type User Hook */
133:
134: IF jtf_resource_utl.ok_to_execute(
135: 'JTF_RS_TEAM_USAGES_PVT',
136: 'CREATE_TEAM_USAGE',
137: 'B',
138: 'C')
139: THEN
138: 'C')
139: THEN
140:
141: IF jtf_usr_hks.ok_to_execute(
142: 'JTF_RS_TEAM_USAGES_PVT',
143: 'CREATE_TEAM_USAGE',
144: 'B',
145: 'C')
146: THEN
167: END IF;
168:
169: /* Pre Call to the Vertical Type User Hook */
170: IF jtf_resource_utl.ok_to_execute(
171: 'JTF_RS_TEAM_USAGES_PVT',
172: 'CREATE_TEAM_USAGE',
173: 'B',
174: 'V')
175: THEN
174: 'V')
175: THEN
176:
177: IF jtf_usr_hks.ok_to_execute(
178: 'JTF_RS_TEAM_USAGES_PVT',
179: 'CREATE_TEAM_USAGE',
180: 'B',
181: 'V')
182: THEN
203: END IF;
204:
205: /* Pre Call to the Internal Type User Hook */
206: IF jtf_resource_utl.ok_to_execute(
207: 'JTF_RS_TEAM_USAGES_PVT',
208: 'CREATE_TEAM_USAGE',
209: 'B',
210: 'I')
211: THEN
209: 'B',
210: 'I')
211: THEN
212: IF jtf_usr_hks.ok_to_execute(
213: 'JTF_RS_TEAM_USAGES_PVT',
214: 'CREATE_TEAM_USAGE',
215: 'B',
216: 'I')
217: THEN
386: /* Make the post processing call to the user hooks */
387:
388: /* Post Call to the Customer Type User Hook */
389: IF jtf_resource_utl.ok_to_execute(
390: 'JTF_RS_TEAM_USAGES_PVT',
391: 'CREATE_TEAM_USAGE',
392: 'A',
393: 'C')
394: THEN
393: 'C')
394: THEN
395:
396: IF jtf_usr_hks.ok_to_execute(
397: 'JTF_RS_TEAM_USAGES_PVT',
398: 'CREATE_TEAM_USAGE',
399: 'A',
400: 'C')
401: THEN
423: END IF;
424:
425: /* Post Call to the Vertical Type User Hook */
426: IF jtf_resource_utl.ok_to_execute(
427: 'JTF_RS_TEAM_USAGES_PVT',
428: 'CREATE_TEAM_USAGE',
429: 'A',
430: 'V')
431: THEN
429: 'A',
430: 'V')
431: THEN
432: IF jtf_usr_hks.ok_to_execute(
433: 'JTF_RS_TEAM_USAGES_PVT',
434: 'CREATE_TEAM_USAGE',
435: 'A',
436: 'V')
437: THEN
459: END IF;
460:
461: /* Post Call to the Internal Type User Hook */
462: IF jtf_resource_utl.ok_to_execute(
463: 'JTF_RS_TEAM_USAGES_PVT',
464: 'CREATE_TEAM_USAGE',
465: 'A',
466: 'I')
467: THEN
465: 'A',
466: 'I')
467: THEN
468: IF jtf_usr_hks.ok_to_execute(
469: 'JTF_RS_TEAM_USAGES_PVT',
470: 'CREATE_TEAM_USAGE',
471: 'A',
472: 'I')
473: THEN
495:
496: /* Standard call for Message Generation */
497:
498: IF jtf_resource_utl.ok_to_execute(
499: 'JTF_RS_TEAM_USAGES_PVT',
500: 'CREATE_TEAM_USAGE',
501: 'M',
502: 'M')
503: THEN
501: 'M',
502: 'M')
503: THEN
504: IF jtf_usr_hks.ok_to_execute(
505: 'JTF_RS_TEAM_USAGES_PVT',
506: 'CREATE_TEAM_USAGE',
507: 'M',
508: 'M')
509: THEN
659: /* Make the pre processing call to the user hooks */
660:
661: /* Pre Call to the Customer Type User Hook */
662: IF jtf_resource_utl.ok_to_execute(
663: 'JTF_RS_TEAM_USAGES_PVT',
664: 'DELETE_TEAM_USAGE',
665: 'B',
666: 'C')
667: THEN
665: 'B',
666: 'C')
667: THEN
668: IF jtf_usr_hks.ok_to_execute(
669: 'JTF_RS_TEAM_USAGES_PVT',
670: 'DELETE_TEAM_USAGE',
671: 'B',
672: 'C')
673: THEN
695:
696:
697: /* Pre Call to the Vertical Type User Hook */
698: IF jtf_resource_utl.ok_to_execute(
699: 'JTF_RS_TEAM_USAGES_PVT',
700: 'DELETE_TEAM_USAGE',
701: 'B',
702: 'V')
703: THEN
701: 'B',
702: 'V')
703: THEN
704: IF jtf_usr_hks.ok_to_execute(
705: 'JTF_RS_TEAM_USAGES_PVT',
706: 'DELETE_TEAM_USAGE',
707: 'B',
708: 'V')
709: THEN
731:
732:
733: /* Pre Call to the Internal Type User Hook */
734: IF jtf_resource_utl.ok_to_execute(
735: 'JTF_RS_TEAM_USAGES_PVT',
736: 'DELETE_TEAM_USAGE',
737: 'B',
738: 'I')
739: THEN
737: 'B',
738: 'I')
739: THEN
740: IF jtf_usr_hks.ok_to_execute(
741: 'JTF_RS_TEAM_USAGES_PVT',
742: 'DELETE_TEAM_USAGE',
743: 'B',
744: 'I')
745: THEN
859: /* Make the post processing call to the user hooks */
860:
861: /* Post Call to the Customer Type User Hook */
862: IF jtf_resource_utl.ok_to_execute(
863: 'JTF_RS_TEAM_USAGES_PVT',
864: 'DELETE_TEAM_USAGE',
865: 'A',
866: 'C')
867: THEN
866: 'C')
867: THEN
868:
869: IF jtf_usr_hks.ok_to_execute(
870: 'JTF_RS_TEAM_USAGES_PVT',
871: 'DELETE_TEAM_USAGE',
872: 'A',
873: 'C')
874: THEN
896:
897:
898: /* Post Call to the Vertical Type User Hook */
899: IF jtf_resource_utl.ok_to_execute(
900: 'JTF_RS_TEAM_USAGES_PVT',
901: 'DELETE_TEAM_USAGE',
902: 'A',
903: 'V')
904: THEN
902: 'A',
903: 'V')
904: THEN
905: IF jtf_usr_hks.ok_to_execute(
906: 'JTF_RS_TEAM_USAGES_PVT',
907: 'DELETE_TEAM_USAGE',
908: 'A',
909: 'V')
910: THEN
932:
933:
934: /* Post Call to the Internal Type User Hook */
935: IF jtf_resource_utl.ok_to_execute(
936: 'JTF_RS_TEAM_USAGES_PVT',
937: 'DELETE_TEAM_USAGE',
938: 'A',
939: 'I')
940: THEN
938: 'A',
939: 'I')
940: THEN
941: IF jtf_usr_hks.ok_to_execute(
942: 'JTF_RS_TEAM_USAGES_PVT',
943: 'DELETE_TEAM_USAGE',
944: 'A',
945: 'I')
946: THEN
967:
968: /* Standard call for Message Generation */
969:
970: IF jtf_resource_utl.ok_to_execute(
971: 'JTF_RS_TEAM_USAGES_PVT',
972: 'DELETE_TEAM_USAGE',
973: 'M',
974: 'M')
975: THEN
973: 'M',
974: 'M')
975: THEN
976: IF jtf_usr_hks.ok_to_execute(
977: 'JTF_RS_TEAM_USAGES_PVT',
978: 'DELETE_TEAM_USAGE',
979: 'M',
980: 'M')
981: THEN
1066:
1067: END delete_team_usage;
1068:
1069:
1070: END jtf_rs_team_usages_pvt;