DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on INV_TABLE_LOCK_PVT

Line 10041: inv_table_lock_pvt.release_locks(p_header_id => l_return_hdr_id);

10037: COMMIT;
10038: IF(l_return_hdr_id IS NOT NULL AND l_return_hdr_id <> -1) THEN
10039: -- Release user lock on assembly return records per inventory
10040: -- request.
10041: inv_table_lock_pvt.release_locks(p_header_id => l_return_hdr_id);
10042: END IF;
10043: -- Set savepoint again because commit will clear savepoint.
10044: SAVEPOINT s_move_proc;
10045: END IF;

Line 10075: inv_table_lock_pvt.release_locks(p_header_id => l_gib.assy_header_id);

10071: IF(l_gib.assy_header_id IS NOT NULL AND
10072: l_gib.assy_header_id <> -1) THEN
10073: -- Release user lock on assembly completion records per inventory
10074: -- request.
10075: inv_table_lock_pvt.release_locks(p_header_id => l_gib.assy_header_id);
10076: END IF;
10077: -- Set savepoint again because commit will clear savepoint.
10078: SAVEPOINT s_move_proc;
10079: END IF;

Line 10327: inv_table_lock_pvt.release_locks(p_header_id => l_gib.mtl_header_id);

10323: COMMIT;
10324: IF(l_MMTT_record > 0 AND
10325: l_gib.mtl_mode <> WIP_CONSTANTS.NO_PROCESSING) THEN
10326: -- Release user lock on backflush records per inventory request.
10327: inv_table_lock_pvt.release_locks(p_header_id => l_gib.mtl_header_id);
10328: END IF;
10329: -- Set savepoint again because commit will clear savepoint.
10330: SAVEPOINT s_move_proc;
10331: END IF;

Line 10603: -- will be deleted when wip call inv_table_lock_pvt.release_locks.

10599: WHERE group_id = p_group_id;
10600:
10601: -- Fixed bug 4361566. Set global variable to let inventory know that they
10602: -- should not delete lock record from their temp table. These lock records
10603: -- will be deleted when wip call inv_table_lock_pvt.release_locks.
10604: WIP_CONSTANTS.WIP_MOVE_WORKER := 'Y';
10605:
10606: wip_movProc_priv.processIntf
10607: (p_group_id => p_group_id,