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.CSM_GROUP_DOWNLOAD_PVT dependencies on CSM_GROUPS

Line 7: g_grp_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS';

3:
4: -- The same table is used as both base and access table.
5:
6:
7: g_grp_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS';
8: g_grp_table_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS';
9: g_grp_seq_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS_S' ;
10: g_grp_pk1_name CONSTANT VARCHAR2(30) := 'GROUP_ID';
11: g_grp_item CONSTANT VARCHAR2(30) := 'CSM_GROUPS';

Line 8: g_grp_table_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS';

4: -- The same table is used as both base and access table.
5:
6:
7: g_grp_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS';
8: g_grp_table_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS';
9: g_grp_seq_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS_S' ;
10: g_grp_pk1_name CONSTANT VARCHAR2(30) := 'GROUP_ID';
11: g_grp_item CONSTANT VARCHAR2(30) := 'CSM_GROUPS';
12: g_grp_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 9: g_grp_seq_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS_S' ;

5:
6:
7: g_grp_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS';
8: g_grp_table_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS';
9: g_grp_seq_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS_S' ;
10: g_grp_pk1_name CONSTANT VARCHAR2(30) := 'GROUP_ID';
11: g_grp_item CONSTANT VARCHAR2(30) := 'CSM_GROUPS';
12: g_grp_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
13: CSM_ACC_PKG.t_publication_item_list('CSM_GROUPS');

Line 11: g_grp_item CONSTANT VARCHAR2(30) := 'CSM_GROUPS';

7: g_grp_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS';
8: g_grp_table_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS';
9: g_grp_seq_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS_S' ;
10: g_grp_pk1_name CONSTANT VARCHAR2(30) := 'GROUP_ID';
11: g_grp_item CONSTANT VARCHAR2(30) := 'CSM_GROUPS';
12: g_grp_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
13: CSM_ACC_PKG.t_publication_item_list('CSM_GROUPS');
14:
15: -- This procedure will insert current group record in csm_groups

Line 13: CSM_ACC_PKG.t_publication_item_list('CSM_GROUPS');

9: g_grp_seq_name CONSTANT VARCHAR2(30) := 'CSM_GROUPS_S' ;
10: g_grp_pk1_name CONSTANT VARCHAR2(30) := 'GROUP_ID';
11: g_grp_item CONSTANT VARCHAR2(30) := 'CSM_GROUPS';
12: g_grp_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
13: CSM_ACC_PKG.t_publication_item_list('CSM_GROUPS');
14:
15: -- This procedure will insert current group record in csm_groups
16: -- during user-creation.
17: PROCEDURE INSERT_MY_GROUP (p_user_id NUMBER

Line 15: -- This procedure will insert current group record in csm_groups

11: g_grp_item CONSTANT VARCHAR2(30) := 'CSM_GROUPS';
12: g_grp_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
13: CSM_ACC_PKG.t_publication_item_list('CSM_GROUPS');
14:
15: -- This procedure will insert current group record in csm_groups
16: -- during user-creation.
17: PROCEDURE INSERT_MY_GROUP (p_user_id NUMBER
18: , x_return_status OUT NOCOPY VARCHAR2
19: , x_error_message OUT NOCOPY VARCHAR2)

Line 31: FROM CSM_GROUPS acc

27: AND usr.ENABLED = 'Y'
28: AND NOT EXISTS
29: (
30: SELECT 1
31: FROM CSM_GROUPS acc
32: WHERE acc.USER_ID = usr.OWNER_ID
33: AND acc.GROUP_TYPE ='C'
34: );
35:

Line 40: l_group_id CSM_GROUPS.GROUP_ID%TYPE := NULL;

36: --variable declarations
37: l_sqlerrno VARCHAR2(20);
38: l_sqlerrmsg VARCHAR2(2000);
39: l_message VARCHAR2(3000);
40: l_group_id CSM_GROUPS.GROUP_ID%TYPE := NULL;
41: l_owner_id CSM_GROUPS.GROUP_OWNER_ID%TYPE := NULL;
42: BEGIN
43:
44: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP Proc ',

Line 41: l_owner_id CSM_GROUPS.GROUP_OWNER_ID%TYPE := NULL;

37: l_sqlerrno VARCHAR2(20);
38: l_sqlerrmsg VARCHAR2(2000);
39: l_message VARCHAR2(3000);
40: l_group_id CSM_GROUPS.GROUP_ID%TYPE := NULL;
41: l_owner_id CSM_GROUPS.GROUP_OWNER_ID%TYPE := NULL;
42: BEGIN
43:
44: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP Proc ',
45: 'CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP',FND_LOG.LEVEL_STATEMENT);

Line 60: UPDATE CSM_GROUPS

56: ,P_PK1_NUM_VALUE => l_group_id
57: ,P_USER_ID => l_owner_id
58: );
59:
60: UPDATE CSM_GROUPS
61: SET GROUP_TYPE ='C',
62: GROUP_OWNER_ID=l_owner_id
63: WHERE GROUP_ID = l_group_id
64: AND USER_ID = l_owner_id;

Line 86: -- CSM_GROUPS table only if there are no Mobile Users from the Group.

82: END INSERT_MY_GROUP;
83:
84:
85: -- The Group which was downloaded for the user has to be deleted from the
86: -- CSM_GROUPS table only if there are no Mobile Users from the Group.
87:
88: PROCEDURE DELETE_MY_GROUP ( p_user_id NUMBER
89: , x_return_status OUT NOCOPY VARCHAR2
90: , x_error_message OUT NOCOPY VARCHAR2)

Line 96: FROM CSM_GROUPS acc

92: --CURSOR declarations
93: CURSOR c_group_del(b_user_id NUMBER)
94: IS
95: SELECT acc.group_id
96: FROM CSM_GROUPS acc
97: WHERE acc.USER_ID = b_user_id
98: AND acc.GROUP_TYPE = 'C';
99:
100: --variable declarations

Line 101: l_group_id CSM_GROUPS.GROUP_ID%TYPE := NULL;

97: WHERE acc.USER_ID = b_user_id
98: AND acc.GROUP_TYPE = 'C';
99:
100: --variable declarations
101: l_group_id CSM_GROUPS.GROUP_ID%TYPE := NULL;
102: l_sqlerrno VARCHAR2(20);
103: l_sqlerrmsg VARCHAR2(2000);
104: l_message VARCHAR2(3000);
105: l_access_id CSM_GROUPS.ACCESS_ID%TYPE;

Line 105: l_access_id CSM_GROUPS.ACCESS_ID%TYPE;

101: l_group_id CSM_GROUPS.GROUP_ID%TYPE := NULL;
102: l_sqlerrno VARCHAR2(20);
103: l_sqlerrmsg VARCHAR2(2000);
104: l_message VARCHAR2(3000);
105: l_access_id CSM_GROUPS.ACCESS_ID%TYPE;
106:
107: BEGIN
108: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP Proc ',
109: 'CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP',FND_LOG.LEVEL_STATEMENT);

Line 187: UPDATE CSM_GROUPS

183: ,P_PK1_NUM_VALUE => p_group_id
184: ,P_USER_ID => p_user_id
185: );
186:
187: UPDATE CSM_GROUPS
188: SET GROUP_TYPE = p_group_type,
189: GROUP_OWNER_ID = p_owner_id
190: WHERE GROUP_ID = p_group_id
191: AND USER_ID = p_user_id;

Line 222: --CSM_GROUPS table only if there are no Mobile Users from the Group.

218: END INSERT_GROUP_ACC;
219:
220:
221: --The Group which was downloaded for the user has to be deleted from the
222: --CSM_GROUPS table only if there are no Mobile Users from the Group.
223:
224: PROCEDURE DELETE_GROUP_ACC ( p_user_id NUMBER
225: , p_group_id NUMBER
226: , x_return_status OUT NOCOPY VARCHAR2

Line 231: l_group_id CSM_GROUPS.GROUP_ID%TYPE;

227: , x_error_message OUT NOCOPY VARCHAR2)
228: IS
229:
230: --variable declarations
231: l_group_id CSM_GROUPS.GROUP_ID%TYPE;
232: l_sqlerrno VARCHAR2(20);
233: l_sqlerrmsg VARCHAR2(2000);
234: l_message VARCHAR2(3000);
235: l_access_id CSM_GROUPS.ACCESS_ID%TYPE;

Line 235: l_access_id CSM_GROUPS.ACCESS_ID%TYPE;

231: l_group_id CSM_GROUPS.GROUP_ID%TYPE;
232: l_sqlerrno VARCHAR2(20);
233: l_sqlerrmsg VARCHAR2(2000);
234: l_message VARCHAR2(3000);
235: l_access_id CSM_GROUPS.ACCESS_ID%TYPE;
236:
237: BEGIN
238: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC Proc ',
239: 'CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);