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 261: -- delete from csm_inv_loc_ass_acc

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

Line 329: FROM csm_inv_loc_ass_acc acc,

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