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.CSL_JTF_RS_GRP_MEM_ACC_PKG dependencies on JTF_RS_GROUP_MEMBERS

Line 5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_JTF_RS_GROUP_MEMBERS_ACC';

1: PACKAGE BODY CSL_JTF_RS_GRP_MEM_ACC_PKG AS
2: /* $Header: csljgacb.pls 120.0 2005/05/24 17:18:20 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_JTF_RS_GROUP_MEMBERS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_GROUP_MEMBERS');
8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_RS_GROUP_MEMBERS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'GROUP_MEMBER_ID';

Line 7: JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_GROUP_MEMBERS');

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_JTF_RS_GROUP_MEMBERS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_GROUP_MEMBERS');
8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_RS_GROUP_MEMBERS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'GROUP_MEMBER_ID';
10: g_debug_level NUMBER;
11:

Line 8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_RS_GROUP_MEMBERS';

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_JTF_RS_GROUP_MEMBERS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_GROUP_MEMBERS');
8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_RS_GROUP_MEMBERS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'GROUP_MEMBER_ID';
10: g_debug_level NUMBER;
11:
12:

Line 23: FROM jtf_rs_group_members

19: /** Get the group Id for a given group member Id ***/
20: CURSOR c_GetGroupId( b_group_member_id NUMBER )
21: IS
22: SELECT group_id, resource_id
23: FROM jtf_rs_group_members
24: WHERE DELETE_FLAG = 'N'
25: AND group_member_id = b_group_member_id;
26:
27: r_GetGroupId c_GetGroupId%ROWTYPE;

Line 33: FROM jtf_rs_group_members

29: /** Get all resource ids that reside in a retrieved group id ***/
30: CURSOR c_GetResourceId( b_group_id NUMBER )
31: IS
32: SELECT resource_id
33: FROM jtf_rs_group_members
34: WHERE group_id = b_group_id
35: AND delete_flag = 'N';
36:
37: r_GetResourceId c_GetResourceId%ROWTYPE;

Line 115: FROM jtf_rs_group_members rgm

111: /*** cursor to retrieve group member details ***/
112: CURSOR c_group_member( b_group_member_id NUMBER ) IS
113: SELECT rgm.resource_id
114: , rxt.user_id
115: FROM jtf_rs_group_members rgm
116: , jtf_rs_resource_extns rxt
117: WHERE rgm.resource_id = rxt.resource_id
118: AND rgm.group_member_id = b_group_member_id;
119: r_group_member c_group_member%ROWTYPE;

Line 190: FROM jtf_rs_group_members rgm

186: /*** cursor to retrieve group member details ***/
187: CURSOR c_group_member( b_group_member_id NUMBER ) IS
188: SELECT rgm.resource_id
189: , rxt.user_id
190: FROM jtf_rs_group_members rgm
191: , jtf_rs_resource_extns rxt
192: WHERE rgm.resource_id = rxt.resource_id
193: AND rgm.group_member_id = b_group_member_id;
194: r_group_member c_group_member%ROWTYPE;

Line 255: (P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,

251: END Delete_ACC_Record;
252:
253: /*** Called after Group member Insert ***/
254: PROCEDURE POST_INSERT_RS_GROUP_MEMBER
255: (P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
256: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
257: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
258: X_RETURN_STATUS OUT NOCOPY VARCHAR2
259: )

Line 256: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

252:
253: /*** Called after Group member Insert ***/
254: PROCEDURE POST_INSERT_RS_GROUP_MEMBER
255: (P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
256: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
257: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
258: X_RETURN_STATUS OUT NOCOPY VARCHAR2
259: )
260: IS

Line 257: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

253: /*** Called after Group member Insert ***/
254: PROCEDURE POST_INSERT_RS_GROUP_MEMBER
255: (P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
256: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
257: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
258: X_RETURN_STATUS OUT NOCOPY VARCHAR2
259: )
260: IS
261: CURSOR c_group_resources ( b_group_id NUMBER ) IS

Line 263: FROM jtf_rs_group_members

259: )
260: IS
261: CURSOR c_group_resources ( b_group_id NUMBER ) IS
262: SELECT group_member_id, resource_id
263: FROM jtf_rs_group_members
264: WHERE group_id = b_group_id
265: AND delete_flag = 'N';
266: r_group_resources c_group_resources%ROWTYPE;
267:

Line 401: (P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

397: END POST_INSERT_RS_GROUP_MEMBER;
398:
399: /* Called after Group member delete */
400: PROCEDURE PRE_DELETE_RS_GROUP_MEMBER
401: (P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
402: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
403: X_RETURN_STATUS OUT NOCOPY VARCHAR2
404: )
405: IS

Line 402: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

398:
399: /* Called after Group member delete */
400: PROCEDURE PRE_DELETE_RS_GROUP_MEMBER
401: (P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
402: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
403: X_RETURN_STATUS OUT NOCOPY VARCHAR2
404: )
405: IS
406: CURSOR c_group_resources ( b_group_id NUMBER ) IS

Line 408: FROM jtf_rs_group_members

404: )
405: IS
406: CURSOR c_group_resources ( b_group_id NUMBER ) IS
407: SELECT group_member_id, resource_id
408: FROM jtf_rs_group_members
409: WHERE group_id = b_group_id
410: AND delete_flag = 'N';
411: r_group_resources c_group_resources%ROWTYPE;
412:

Line 415: FROM jtf_rs_group_members

411: r_group_resources c_group_resources%ROWTYPE;
412:
413: CURSOR c_group_member ( b_group_id NUMBER, b_resource_id NUMBER ) IS
414: SELECT group_member_id
415: FROM jtf_rs_group_members
416: WHERE group_id = b_group_id
417: AND resource_id = b_resource_id
418: AND delete_flag = 'N';
419: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;

Line 419: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;

415: FROM jtf_rs_group_members
416: WHERE group_id = b_group_id
417: AND resource_id = b_resource_id
418: AND delete_flag = 'N';
419: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
420:
421: l_is_mobile_resource BOOLEAN;
422: BEGIN
423: /*** get debug level ***/

Line 573: FROM jtm_jtf_rs_group_members_acc acc

569:
570: CURSOR c_grp_mem_acc( b_resource_id NUMBER)
571: IS
572: SELECT acc.group_member_id
573: FROM jtm_jtf_rs_group_members_acc acc
574: WHERE acc.resource_id = b_resource_id;
575: r_grp_mem_acc c_grp_mem_acc%ROWTYPE;
576:
577: BEGIN

Line 649: CURSOR c_jtf_rs_group_members (b_resource_id NUMBER) IS

645: ( p_resource_id IN NUMBER
646: , x_return_status OUT NOCOPY VARCHAR2
647: )
648: IS
649: CURSOR c_jtf_rs_group_members (b_resource_id NUMBER) IS
650: SELECT group_member_id
651: FROM JTF_RS_GROUP_MEMBERS
652: WHERE delete_flag = 'N'
653: AND group_id IN (

Line 651: FROM JTF_RS_GROUP_MEMBERS

647: )
648: IS
649: CURSOR c_jtf_rs_group_members (b_resource_id NUMBER) IS
650: SELECT group_member_id
651: FROM JTF_RS_GROUP_MEMBERS
652: WHERE delete_flag = 'N'
653: AND group_id IN (
654: SELECT group_id
655: FROM jtf_rs_group_members

Line 655: FROM jtf_rs_group_members

651: FROM JTF_RS_GROUP_MEMBERS
652: WHERE delete_flag = 'N'
653: AND group_id IN (
654: SELECT group_id
655: FROM jtf_rs_group_members
656: WHERE delete_flag = 'N'
657: AND RESOURCE_ID = b_resource_id);
658: r_jtf_rs_group_members c_jtf_rs_group_members%ROWTYPE;
659: BEGIN

Line 658: r_jtf_rs_group_members c_jtf_rs_group_members%ROWTYPE;

654: SELECT group_id
655: FROM jtf_rs_group_members
656: WHERE delete_flag = 'N'
657: AND RESOURCE_ID = b_resource_id);
658: r_jtf_rs_group_members c_jtf_rs_group_members%ROWTYPE;
659: BEGIN
660: /*** get debug level ***/
661: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
662:

Line 684: FOR r_jtf_rs_group_members IN c_jtf_rs_group_members( p_resource_id )

680: -- x_return_status := FND_API.G_RET_STS_ERROR;
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: ELSE
683: /*** Yes -> insert all replicateable records ***/
684: FOR r_jtf_rs_group_members IN c_jtf_rs_group_members( p_resource_id )
685: LOOP
686: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
687: jtm_message_log_pkg.Log_Msg
688: ( r_jtf_rs_group_members.group_member_id

Line 688: ( r_jtf_rs_group_members.group_member_id

684: FOR r_jtf_rs_group_members IN c_jtf_rs_group_members( p_resource_id )
685: LOOP
686: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
687: jtm_message_log_pkg.Log_Msg
688: ( r_jtf_rs_group_members.group_member_id
689: , g_table_name
690: , 'Calling Insert_ACC_Record'
691: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
692: END IF;

Line 695: ( r_jtf_rs_group_members.group_member_id

691: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
692: END IF;
693:
694: Insert_ACC_Record
695: ( r_jtf_rs_group_members.group_member_id
696: , p_resource_id
697: );
698: END LOOP;
699: x_return_status := FND_API.G_RET_STS_SUCCESS;