2507:
2508: --Variables for addressing the Bug 4333758
2509: l_allocated_txn_status NUMBER := 2 ;
2510:
2511: l_txn_action_int_rcpt NUMBER := INV_GLOBALS.G_ACTION_INTRANSITRECEIPT /* 12 */;
2512: l_txn_action_rcpt NUMBER := INV_GLOBALS.G_ACTION_RECEIPT /* 27 */ ;
2513: l_txn_action_subxfer NUMBER := INV_GLOBALS.G_ACTION_SUBXFR /* 2 */ ;
2514: l_txn_action_orgxfer NUMBER := INV_GLOBALS.G_ACTION_ORGXFR /* 3 */ ;
2515: l_txn_action_stgxfer NUMBER := INV_GLOBALS.G_ACTION_STGXFR /* 28 */ ;
2508: --Variables for addressing the Bug 4333758
2509: l_allocated_txn_status NUMBER := 2 ;
2510:
2511: l_txn_action_int_rcpt NUMBER := INV_GLOBALS.G_ACTION_INTRANSITRECEIPT /* 12 */;
2512: l_txn_action_rcpt NUMBER := INV_GLOBALS.G_ACTION_RECEIPT /* 27 */ ;
2513: l_txn_action_subxfer NUMBER := INV_GLOBALS.G_ACTION_SUBXFR /* 2 */ ;
2514: l_txn_action_orgxfer NUMBER := INV_GLOBALS.G_ACTION_ORGXFR /* 3 */ ;
2515: l_txn_action_stgxfer NUMBER := INV_GLOBALS.G_ACTION_STGXFR /* 28 */ ;
2516: --Variables for addressing the Bug 4333758
2509: l_allocated_txn_status NUMBER := 2 ;
2510:
2511: l_txn_action_int_rcpt NUMBER := INV_GLOBALS.G_ACTION_INTRANSITRECEIPT /* 12 */;
2512: l_txn_action_rcpt NUMBER := INV_GLOBALS.G_ACTION_RECEIPT /* 27 */ ;
2513: l_txn_action_subxfer NUMBER := INV_GLOBALS.G_ACTION_SUBXFR /* 2 */ ;
2514: l_txn_action_orgxfer NUMBER := INV_GLOBALS.G_ACTION_ORGXFR /* 3 */ ;
2515: l_txn_action_stgxfer NUMBER := INV_GLOBALS.G_ACTION_STGXFR /* 28 */ ;
2516: --Variables for addressing the Bug 4333758
2517:
2510:
2511: l_txn_action_int_rcpt NUMBER := INV_GLOBALS.G_ACTION_INTRANSITRECEIPT /* 12 */;
2512: l_txn_action_rcpt NUMBER := INV_GLOBALS.G_ACTION_RECEIPT /* 27 */ ;
2513: l_txn_action_subxfer NUMBER := INV_GLOBALS.G_ACTION_SUBXFR /* 2 */ ;
2514: l_txn_action_orgxfer NUMBER := INV_GLOBALS.G_ACTION_ORGXFR /* 3 */ ;
2515: l_txn_action_stgxfer NUMBER := INV_GLOBALS.G_ACTION_STGXFR /* 28 */ ;
2516: --Variables for addressing the Bug 4333758
2517:
2518: cursor c_all_locators(p_locator_id NUMBER,p_subinventory VARCHAR2) is
2511: l_txn_action_int_rcpt NUMBER := INV_GLOBALS.G_ACTION_INTRANSITRECEIPT /* 12 */;
2512: l_txn_action_rcpt NUMBER := INV_GLOBALS.G_ACTION_RECEIPT /* 27 */ ;
2513: l_txn_action_subxfer NUMBER := INV_GLOBALS.G_ACTION_SUBXFR /* 2 */ ;
2514: l_txn_action_orgxfer NUMBER := INV_GLOBALS.G_ACTION_ORGXFR /* 3 */ ;
2515: l_txn_action_stgxfer NUMBER := INV_GLOBALS.G_ACTION_STGXFR /* 28 */ ;
2516: --Variables for addressing the Bug 4333758
2517:
2518: cursor c_all_locators(p_locator_id NUMBER,p_subinventory VARCHAR2) is
2519: select inventory_location_id,