APPS.CSM_GROUP_DOWNLOAD_PVT dependencies on CSM_ACC_PKG

Line 12: g_grp_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

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
16: -- during user-creation.

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 51: CSM_ACC_PKG.Insert_Acc

47: FETCH c_group_ins INTO l_group_id,l_owner_id;
48: CLOSE c_group_ins;
49:
50: IF l_group_id IS NOT NULL AND l_owner_id IS NOT NULL THEN
51: CSM_ACC_PKG.Insert_Acc
52: (P_PUBLICATION_ITEM_NAMES => g_grp_pubi_name
53: ,P_ACC_TABLE_NAME => g_grp_acc_table_name
54: ,P_SEQ_NAME => g_grp_seq_name
55: ,P_PK1_NAME => g_grp_pk1_name

Line 116: CSM_ACC_PKG.Delete_Acc

112: CLOSE c_group_del;
113:
114: IF l_group_id IS NOT NULL THEN
115:
116: CSM_ACC_PKG.Delete_Acc
117: (P_PUBLICATION_ITEM_NAMES => g_grp_pubi_name
118: ,P_ACC_TABLE_NAME => g_grp_acc_table_name
119: ,P_PK1_NAME => g_grp_pk1_name
120: ,P_PK1_NUM_VALUE => l_group_id

Line 178: CSM_ACC_PKG.Insert_Acc

174:
175: CLOSE c_rel_group_ins;
176:
177: IF p_user_id IS NOT NULL AND p_group_id IS NOT NULL THEN
178: CSM_ACC_PKG.Insert_Acc
179: (P_PUBLICATION_ITEM_NAMES => g_grp_pubi_name
180: ,P_ACC_TABLE_NAME => g_grp_acc_table_name
181: ,P_SEQ_NAME => g_grp_seq_name
182: ,P_PK1_NAME => g_grp_pk1_name

Line 243: CSM_ACC_PKG.Delete_Acc

239: 'CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);
240:
241: IF p_user_id IS NOT NULL AND p_group_id IS NOT NULL THEN
242:
243: CSM_ACC_PKG.Delete_Acc
244: (P_PUBLICATION_ITEM_NAMES => g_grp_pubi_name
245: ,P_ACC_TABLE_NAME => g_grp_acc_table_name
246: ,P_PK1_NAME => g_grp_pk1_name
247: ,P_PK1_NUM_VALUE => p_group_id