APPS.INV_3PL_LOC_PVT dependencies on MTL_3PL_LOCATOR_OCCUPANCY

Line 22: l_old_record mtl_3pl_locator_occupancy%ROWTYPE;

18: IS
19: l_return_status VARCHAR2(1);
20: l_msg_count NUMBER;
21: l_msg_data VARCHAR2(1000);
22: l_old_record mtl_3pl_locator_occupancy%ROWTYPE;
23: l_Last_Receipt_Date DATE;
24: l_current_onhand NUMBER;
25: l_locator_id NUMBER;
26: l_transaction_date DATE;

Line 47: FROM mtl_3pl_locator_occupancy

43:
44: BEGIN
45: Select *
46: INTO l_old_Record
47: FROM mtl_3pl_locator_occupancy
48: WHERE locator_id = p_inventory_location_id
49: and organization_id = p_organization_id
50: AND client_code = p_client_code;
51:

Line 227: FROM mtl_3pl_locator_occupancy

223: ) RETURN VARCHAR2
224: IS
225:
226: cursor c is select client_code , locator_id , organization_id
227: FROM mtl_3pl_locator_occupancy
228: WHERE client_code = l_client_code
229: AND locator_id = l_locator_id
230: and organization_id = l_organization_id
231: FOR UPDATE nowait;

Line 246: Update mtl_3pl_locator_occupancy

242: inv_trx_util_pub.TRACE('recinfo.locator_id ' || recinfo.locator_id , 'update_current_capacity', 4);
243: inv_trx_util_pub.TRACE('recinfo.client_code ' || recinfo.client_code , 'update_current_capacity', 4);
244: END IF;
245:
246: Update mtl_3pl_locator_occupancy
247: set Last_Receipt_Date = l_Last_Receipt_Date,
248: current_onhand = l_current_onhand ,
249: transaction_date = l_transaction_date ,
250: transaction_action_id = l_transaction_action ,

Line 289: INSERT INTO mtl_3pl_locator_occupancy

285: inv_trx_util_pub.TRACE('l_locator_id ' || l_locator_id,'update_current_capacity', 4);
286: inv_trx_util_pub.TRACE('IN l_client_code ' || l_client_code ,'update_current_capacity', 4);
287: END IF;
288:
289: INSERT INTO mtl_3pl_locator_occupancy
290: ( Last_Receipt_Date,
291: current_onhand ,
292: transaction_date ,
293: transaction_action_id ,