eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_GROUP_USAGES_PVT dependencies on JTF_RS_GROUP_USAGES

Line 1: PACKAGE BODY jtf_rs_group_usages_pvt AS

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,

Line 17: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_GROUP_USAGES_PVT';

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

Line 27: P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,

23: PROCEDURE create_group_usage
24: (P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2,
26: P_COMMIT IN VARCHAR2,
27: P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
28: P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
29: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
30: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
31: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,

Line 28: P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,

24: (P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2,
26: P_COMMIT IN VARCHAR2,
27: P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
28: P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
29: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE,
30: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE,
31: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE,
32: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE,

Line 48: X_GROUP_USAGE_ID OUT NOCOPY JTF_RS_GROUP_USAGES.GROUP_USAGE_ID%TYPE

44: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
48: X_GROUP_USAGE_ID OUT NOCOPY JTF_RS_GROUP_USAGES.GROUP_USAGE_ID%TYPE
49: ) IS
50:
51: l_api_version CONSTANT NUMBER := 1.0;
52: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GROUP_USAGE';

Line 53: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;

49: ) IS
50:
51: l_api_version CONSTANT NUMBER := 1.0;
52: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GROUP_USAGE';
53: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;
54: l_usage jtf_rs_group_usages.usage%TYPE := upper(p_usage);
55:
56: l_rowid ROWID;
57: l_group_usage_id jtf_rs_group_usages.group_usage_id%TYPE;

Line 54: l_usage jtf_rs_group_usages.usage%TYPE := upper(p_usage);

50:
51: l_api_version CONSTANT NUMBER := 1.0;
52: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GROUP_USAGE';
53: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;
54: l_usage jtf_rs_group_usages.usage%TYPE := upper(p_usage);
55:
56: l_rowid ROWID;
57: l_group_usage_id jtf_rs_group_usages.group_usage_id%TYPE;
58: l_check_char VARCHAR2(1);

Line 57: l_group_usage_id jtf_rs_group_usages.group_usage_id%TYPE;

53: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;
54: l_usage jtf_rs_group_usages.usage%TYPE := upper(p_usage);
55:
56: l_rowid ROWID;
57: l_group_usage_id jtf_rs_group_usages.group_usage_id%TYPE;
58: l_check_char VARCHAR2(1);
59: l_check_count NUMBER;
60: l_bind_data_id NUMBER;
61:

Line 72: jtf_rs_group_usages GU2,

68: FROM jtf_rs_groups_vl G1,
69: jtf_rs_groups_vl G2,
70: jtf_rs_group_members GM1,
71: jtf_rs_group_members GM2,
72: jtf_rs_group_usages GU2,
73: jtf_rs_role_relations RR1,
74: jtf_rs_role_relations RR2
75: WHERE G1.group_id = GM1.group_id
76: AND G2.group_id = GM2.group_id

Line 104: CURSOR c_jtf_rs_group_usages( l_rowid IN ROWID ) IS

100: AND G1.group_id = l_group_id
101: AND nvl(G1.exclusive_flag,'N') = 'Y';
102:
103:
104: CURSOR c_jtf_rs_group_usages( l_rowid IN ROWID ) IS
105: SELECT 'Y'
106: FROM jtf_rs_group_usages
107: WHERE ROWID = l_rowid;
108:

Line 106: FROM jtf_rs_group_usages

102:
103:
104: CURSOR c_jtf_rs_group_usages( l_rowid IN ROWID ) IS
105: SELECT 'Y'
106: FROM jtf_rs_group_usages
107: WHERE ROWID = l_rowid;
108:
109:
110: BEGIN

Line 139: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 145: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 176: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 182: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 213: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 219: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 251: FROM jtf_rs_group_usages

247: l_check_count := 0;
248:
249: SELECT count(*)
250: INTO l_check_count
251: FROM jtf_rs_group_usages
252: WHERE group_id = l_group_id
253: AND usage = l_usage;
254:
255: IF l_check_count > 0 THEN

Line 313: SELECT jtf_rs_group_usages_s.nextval

309:
310:
311: /* Get the next value of the Group_usage_id from the sequence. */
312:
313: SELECT jtf_rs_group_usages_s.nextval
314: INTO l_group_usage_id
315: FROM dual;
316:
317:

Line 320: jtf_rs_group_usages_pkg.insert_row(

316:
317:
318: /* Insert the row into the table by calling the table handler. */
319:
320: jtf_rs_group_usages_pkg.insert_row(
321: x_rowid => l_rowid,
322: x_group_usage_id => l_group_usage_id,
323: x_group_id => l_group_id,
324: x_usage => l_usage,

Line 351: OPEN c_jtf_rs_group_usages(l_rowid);

347:
348:
349: -- dbms_output.put_line('Inserted Row');
350:
351: OPEN c_jtf_rs_group_usages(l_rowid);
352:
353: FETCH c_jtf_rs_group_usages INTO l_check_char;
354:
355:

Line 353: FETCH c_jtf_rs_group_usages INTO l_check_char;

349: -- dbms_output.put_line('Inserted Row');
350:
351: OPEN c_jtf_rs_group_usages(l_rowid);
352:
353: FETCH c_jtf_rs_group_usages INTO l_check_char;
354:
355:
356: IF c_jtf_rs_group_usages%NOTFOUND THEN
357:

Line 356: IF c_jtf_rs_group_usages%NOTFOUND THEN

352:
353: FETCH c_jtf_rs_group_usages INTO l_check_char;
354:
355:
356: IF c_jtf_rs_group_usages%NOTFOUND THEN
357:
358: -- dbms_output.put_line('Error in Table Handler');
359:
360: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 365: IF c_jtf_rs_group_usages%ISOPEN THEN

361:
362: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
363: fnd_msg_pub.add;
364:
365: IF c_jtf_rs_group_usages%ISOPEN THEN
366:
367: CLOSE c_jtf_rs_group_usages;
368:
369: END IF;

Line 367: CLOSE c_jtf_rs_group_usages;

363: fnd_msg_pub.add;
364:
365: IF c_jtf_rs_group_usages%ISOPEN THEN
366:
367: CLOSE c_jtf_rs_group_usages;
368:
369: END IF;
370:
371: RAISE fnd_api.g_exc_unexpected_error;

Line 384: IF c_jtf_rs_group_usages%ISOPEN THEN

380:
381:
382: /* Close the cursors */
383:
384: IF c_jtf_rs_group_usages%ISOPEN THEN
385:
386: CLOSE c_jtf_rs_group_usages;
387:
388: END IF;

Line 386: CLOSE c_jtf_rs_group_usages;

382: /* Close the cursors */
383:
384: IF c_jtf_rs_group_usages%ISOPEN THEN
385:
386: CLOSE c_jtf_rs_group_usages;
387:
388: END IF;
389:
390:

Line 397: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 403: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 435: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 441: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 473: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 479: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 509: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 515: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 622: P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,

618: PROCEDURE delete_group_usage
619: (P_API_VERSION IN NUMBER,
620: P_INIT_MSG_LIST IN VARCHAR2,
621: P_COMMIT IN VARCHAR2,
622: P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
623: P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
624: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_USAGES.OBJECT_VERSION_NUMBER%TYPE,
625: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
626: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 623: P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,

619: (P_API_VERSION IN NUMBER,
620: P_INIT_MSG_LIST IN VARCHAR2,
621: P_COMMIT IN VARCHAR2,
622: P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
623: P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
624: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_USAGES.OBJECT_VERSION_NUMBER%TYPE,
625: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
626: X_MSG_COUNT OUT NOCOPY NUMBER,
627: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 624: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_USAGES.OBJECT_VERSION_NUMBER%TYPE,

620: P_INIT_MSG_LIST IN VARCHAR2,
621: P_COMMIT IN VARCHAR2,
622: P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
623: P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
624: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_USAGES.OBJECT_VERSION_NUMBER%TYPE,
625: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
626: X_MSG_COUNT OUT NOCOPY NUMBER,
627: X_MSG_DATA OUT NOCOPY VARCHAR2
628: ) IS

Line 632: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;

628: ) IS
629:
630: l_api_version CONSTANT NUMBER := 1.0;
631: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_GROUP_USAGE';
632: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;
633: l_usage jtf_rs_group_usages.usage%TYPE := upper(p_usage);
634:
635: l_check_char VARCHAR2(1);
636: l_group_usage_id jtf_rs_group_usages.group_usage_id%TYPE;

Line 633: l_usage jtf_rs_group_usages.usage%TYPE := upper(p_usage);

629:
630: l_api_version CONSTANT NUMBER := 1.0;
631: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_GROUP_USAGE';
632: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;
633: l_usage jtf_rs_group_usages.usage%TYPE := upper(p_usage);
634:
635: l_check_char VARCHAR2(1);
636: l_group_usage_id jtf_rs_group_usages.group_usage_id%TYPE;
637: l_bind_data_id NUMBER;

Line 636: l_group_usage_id jtf_rs_group_usages.group_usage_id%TYPE;

632: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;
633: l_usage jtf_rs_group_usages.usage%TYPE := upper(p_usage);
634:
635: l_check_char VARCHAR2(1);
636: l_group_usage_id jtf_rs_group_usages.group_usage_id%TYPE;
637: l_bind_data_id NUMBER;
638:
639:
640: CURSOR c_group_usage_id(

Line 645: FROM jtf_rs_group_usages

641: l_group_id IN NUMBER,
642: l_usage IN VARCHAR2 )
643: IS
644: SELECT group_usage_id
645: FROM jtf_rs_group_usages
646: WHERE group_id = l_group_id
647: AND usage = l_usage;
648:
649: -- Added the below cursor to get the meaning of the usage code passed.

Line 690: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 696: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 727: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 733: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 764: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 770: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 859: jtf_rs_group_usages_pkg.lock_row(

855: is still valid. */
856:
857: BEGIN
858:
859: jtf_rs_group_usages_pkg.lock_row(
860: x_group_usage_id => l_group_usage_id,
861: x_object_version_number => p_object_version_num
862: );
863:

Line 887: jtf_rs_group_usages_pkg.delete_row(

883: BEGIN
884:
885: /* Delete the row into the table by calling the table handler. */
886:
887: jtf_rs_group_usages_pkg.delete_row(
888: x_group_usage_id => l_group_usage_id
889: );
890:
891: EXCEPTION

Line 913: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 919: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 950: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 956: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 987: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 993: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 1022: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 1028: 'JTF_RS_GROUP_USAGES_PVT',

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

Line 1133: END jtf_rs_group_usages_pvt;

1129:
1130: END delete_group_usage;
1131:
1132:
1133: END jtf_rs_group_usages_pvt;