APPS.CSM_GROUP_DOWNLOAD_PUB dependencies on CSM_GROUPS

Line 79: --calling the package to insert records into CSM_GROUPS table

75: IF p_operation = 'INSERT'
76:
77: THEN
78:
79: --calling the package to insert records into CSM_GROUPS table
80:
81: csm_group_download_pvt.insert_my_group
82: ( P_USER_ID => l_owner_id,
83: X_RETURN_STATUS => l_return_status,

Line 90: --calling the package to delete records from CSM_GROUPS table

86: ELSIF p_operation = 'DELETE'
87:
88: THEN
89:
90: --calling the package to delete records from CSM_GROUPS table
91:
92: csm_group_download_pvt.delete_my_group
93: ( P_USER_ID => l_owner_id,
94: X_RETURN_STATUS => l_return_status,

Line 121: --calling the package to insert Related groups records into CSM_GROUPS table

117: IF p_operation = 'INSERT'
118:
119: THEN
120:
121: --calling the package to insert Related groups records into CSM_GROUPS table
122:
123: csm_group_download_pvt.insert_group_acc
124: ( P_USER_ID => l_rel_user_id,
125: P_GROUP_ID => p_related_group_id,

Line 135: --calling the package to insert Related groups records into CSM_GROUPS table

131: ELSIF p_operation = 'DELETE'
132:
133: THEN
134:
135: --calling the package to insert Related groups records into CSM_GROUPS table
136:
137: csm_group_download_pvt.delete_group_acc
138: ( P_USER_ID => l_rel_user_id,
139: P_GROUP_ID => p_related_group_id,

Line 294: --calling the package to insert records into CSM_GROUPS table

290: IF p_operation = 'INSERT'
291:
292: THEN
293:
294: --calling the package to insert records into CSM_GROUPS table
295:
296: csm_group_download_pvt.insert_my_group
297: ( P_USER_ID => l_owner_id,
298: X_RETURN_STATUS => l_return_status,

Line 305: --calling the package to delete records from CSM_GROUPS table

301: ELSIF p_operation = 'DELETE'
302:
303: THEN
304:
305: --calling the package to delete records from CSM_GROUPS table
306:
307: csm_group_download_pvt.delete_my_group
308: ( P_USER_ID => l_owner_id,
309: X_RETURN_STATUS => l_return_status,

Line 350: --calling the package to insert Related groups records into CSM_GROUPS table

346: IF p_operation = 'INSERT'
347:
348: THEN
349:
350: --calling the package to insert Related groups records into CSM_GROUPS table
351:
352: csm_group_download_pvt.insert_group_acc
353: ( P_USER_ID => l_rel_user_id,
354: P_GROUP_ID => l_rel_group_id,

Line 364: --calling the package to insert Related groups records into CSM_GROUPS table

360: ELSIF p_operation = 'DELETE'
361:
362: THEN
363:
364: --calling the package to insert Related groups records into CSM_GROUPS table
365:
366: csm_group_download_pvt.delete_group_acc
367: ( P_USER_ID => l_rel_user_id,
368: P_GROUP_ID => l_rel_group_id,

Line 481: FROM csm_groups acc

477:
478: CURSOR csr_get_rel_grp_id (p_owner_id IN NUMBER)
479: IS
480: SELECT acc.group_id
481: FROM csm_groups acc
482: WHERE acc.user_id = p_owner_id
483: AND acc.group_owner_id <> acc.user_id;
484:
485: BEGIN