APPS.CSM_INV_LOC_ASS_EVENT_PKG dependencies on CSM_INV_LOC_ASS_ACC

Line 18: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_INV_LOC_ASS_ACC';

14:
15: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_INV_LOC_ASS';
16:
17: g_table_name1 CONSTANT VARCHAR2(30) := 'CSP_INV_LOC_ASSIGNMENTS';
18: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_INV_LOC_ASS_ACC';
19: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_INV_LOC_ASS_ACC_S';
20: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
21: CSM_ACC_PKG.t_publication_item_list('CSM_INV_LOC_ASS');
22: g_pk1_name1 CONSTANT VARCHAR2(30) := 'CSP_INV_LOC_ASSIGNMENT_ID';

Line 19: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_INV_LOC_ASS_ACC_S';

15: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_INV_LOC_ASS';
16:
17: g_table_name1 CONSTANT VARCHAR2(30) := 'CSP_INV_LOC_ASSIGNMENTS';
18: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_INV_LOC_ASS_ACC';
19: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_INV_LOC_ASS_ACC_S';
20: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
21: CSM_ACC_PKG.t_publication_item_list('CSM_INV_LOC_ASS');
22: g_pk1_name1 CONSTANT VARCHAR2(30) := 'CSP_INV_LOC_ASSIGNMENT_ID';
23:

Line 263: -- delete from csm_inv_loc_ass_acc

259:
260: OPEN l_inv_loc_ass_csr(p_csp_inv_loc_assignment_id);
261: FETCH l_inv_loc_ass_csr INTO l_subinventory_code, l_organization_id;
262: IF l_inv_loc_ass_csr%FOUND THEN
263: -- delete from csm_inv_loc_ass_acc
264: CSM_ACC_PKG.Delete_Acc
265: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
266: ,P_ACC_TABLE_NAME => g_acc_table_name1
267: ,P_PK1_NAME => g_pk1_name1

Line 331: FROM csm_inv_loc_ass_acc acc,

327: CURSOR l_invLocAsgn_csr(p_csp_inv_loc_assg_id IN NUMBER)
328: IS
329: SELECT acc.access_id,
330: acc.user_id
331: FROM csm_inv_loc_ass_acc acc,
332: csp_inv_loc_assignments cila,
333: ASG_USER au
334: WHERE acc.csp_inv_loc_assignment_id = p_csp_inv_loc_assg_id
335: AND cila.csp_inv_loc_assignment_id = acc.csp_inv_loc_assignment_id