APPS.CSM_INV_LOC_ASS_EVENT_PKG dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 17: g_table_name1 CONSTANT VARCHAR2(30) := 'CSP_INV_LOC_ASSIGNMENTS';

13: -- Enter procedure, function bodies as shown below
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');

Line 55: FROM csp_inv_loc_assignments invLoc,

51: SELECT au.user_id AS user_id,
52: invloc.resource_id AS resource_id,
53: invLoc.organization_id AS organization_id,
54: invLoc.subinventory_code AS subinventory_code
55: FROM csp_inv_loc_assignments invLoc,
56: asg_user au
57: WHERE invloc.csp_inv_loc_assignment_id = p_csp_inv_loc_assg_id
58: AND au.resource_id = invloc.resource_id
59: AND au.USER_ID = au.owner_id;

Line 96: l_subinventory_code csp_inv_loc_assignments.subinventory_code%TYPE;

92: l_sqlerrno VARCHAR2(20);
93: l_sqlerrmsg VARCHAR2(4000);
94: l_error_msg VARCHAR2(4000);
95: l_return_status VARCHAR2(2000);
96: l_subinventory_code csp_inv_loc_assignments.subinventory_code%TYPE;
97: l_organization_id csp_inv_loc_assignments.organization_id%TYPE;
98: l_inv_location_id mtl_item_locations.inventory_location_id%TYPE;
99: l_locator_org_id mtl_item_locations.organization_id%TYPE;
100:

Line 97: l_organization_id csp_inv_loc_assignments.organization_id%TYPE;

93: l_sqlerrmsg VARCHAR2(4000);
94: l_error_msg VARCHAR2(4000);
95: l_return_status VARCHAR2(2000);
96: l_subinventory_code csp_inv_loc_assignments.subinventory_code%TYPE;
97: l_organization_id csp_inv_loc_assignments.organization_id%TYPE;
98: l_inv_location_id mtl_item_locations.inventory_location_id%TYPE;
99: l_locator_org_id mtl_item_locations.organization_id%TYPE;
100:
101: -- get subinventory/organization to insert into csm_mtl_sec_inv

Line 106: FROM csp_inv_loc_assignments

102: CURSOR l_inv_loc_ass_csr(p_inv_loc_ass_id IN NUMBER)
103: IS
104: SELECT subinventory_code,
105: organization_id
106: FROM csp_inv_loc_assignments
107: WHERE csp_inv_loc_assignment_id = p_inv_loc_ass_id;
108:
109: -- get inventory_location_id/organization_id to insert into csm_mtl_item_locations
110: CURSOR l_inv_location_csr(p_subinv_code IN VARCHAR2, p_organization_id IN NUMBER)

Line 194: FROM csp_inv_loc_assignments cila,

190: SELECT cila.organization_id,
191: cila.subinventory_code,
192: cila.resource_id,
193: au.user_id
194: FROM csp_inv_loc_assignments cila,
195: asg_user au
196: WHERE cila.csp_inv_loc_assignment_id = p_csp_inv_loc_assignment_id
197: AND au.resource_id = cila.resource_id
198: AND au.USER_ID = au.owner_id;

Line 235: l_subinventory_code csp_inv_loc_assignments.subinventory_code%TYPE;

231: l_sqlerrno VARCHAR2(20);
232: l_sqlerrmsg VARCHAR2(4000);
233: l_error_msg VARCHAR2(4000);
234: l_return_status VARCHAR2(2000);
235: l_subinventory_code csp_inv_loc_assignments.subinventory_code%TYPE;
236: l_organization_id csp_inv_loc_assignments.organization_id%TYPE;
237: l_inv_location_id mtl_item_locations.inventory_location_id%TYPE;
238: l_locator_org_id mtl_item_locations.organization_id%TYPE;
239:

Line 236: l_organization_id csp_inv_loc_assignments.organization_id%TYPE;

232: l_sqlerrmsg VARCHAR2(4000);
233: l_error_msg VARCHAR2(4000);
234: l_return_status VARCHAR2(2000);
235: l_subinventory_code csp_inv_loc_assignments.subinventory_code%TYPE;
236: l_organization_id csp_inv_loc_assignments.organization_id%TYPE;
237: l_inv_location_id mtl_item_locations.inventory_location_id%TYPE;
238: l_locator_org_id mtl_item_locations.organization_id%TYPE;
239:
240: -- get subinventory/organization to delete from csm_mtl_sec_inv

Line 245: FROM csp_inv_loc_assignments

241: CURSOR l_inv_loc_ass_csr(p_inv_loc_ass_id IN NUMBER)
242: IS
243: SELECT subinventory_code,
244: organization_id
245: FROM csp_inv_loc_assignments
246: WHERE csp_inv_loc_assignment_id = p_inv_loc_ass_id;
247:
248: -- get inventory_location_id/organization_id to delete from csm_mtl_item_locations
249: CURSOR l_inv_location_csr(p_subinv_code IN VARCHAR2, p_organization_id IN NUMBER)

Line 332: csp_inv_loc_assignments cila,

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
336: AND au.USER_ID = acc.USER_ID