eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:

Line 95: l_subinventory_code csp_inv_loc_assignments.subinventory_code%TYPE;

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

Line 96: l_organization_id csp_inv_loc_assignments.organization_id%TYPE;

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

Line 105: FROM csp_inv_loc_assignments

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

Line 193: FROM csp_inv_loc_assignments cila,

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

Line 233: l_subinventory_code csp_inv_loc_assignments.subinventory_code%TYPE;

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

Line 234: l_organization_id csp_inv_loc_assignments.organization_id%TYPE;

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

Line 243: FROM csp_inv_loc_assignments

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

Line 330: csp_inv_loc_assignments cila

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:
334: l_invLocAsgn_rec l_invLocAsgn_csr%ROWTYPE;