DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on INV_TABLE_LOCK_PVT

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

10390: COMMIT;
10391: IF(l_return_hdr_id IS NOT NULL AND l_return_hdr_id <> -1) THEN
10392: -- Release user lock on assembly return records per inventory
10393: -- request.
10394: inv_table_lock_pvt.release_locks(p_header_id => l_return_hdr_id);
10395: END IF;
10396: -- Set savepoint again because commit will clear savepoint.
10397: SAVEPOINT s_move_proc;
10398: END IF;

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

10424: IF(l_gib.assy_header_id IS NOT NULL AND
10425: l_gib.assy_header_id <> -1) THEN
10426: -- Release user lock on assembly completion records per inventory
10427: -- request.
10428: inv_table_lock_pvt.release_locks(p_header_id => l_gib.assy_header_id);
10429: END IF;
10430: -- Set savepoint again because commit will clear savepoint.
10431: SAVEPOINT s_move_proc;
10432: END IF;

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

10676: COMMIT;
10677: IF(l_MMTT_record > 0 AND
10678: l_gib.mtl_mode <> WIP_CONSTANTS.NO_PROCESSING) THEN
10679: -- Release user lock on backflush records per inventory request.
10680: inv_table_lock_pvt.release_locks(p_header_id => l_gib.mtl_header_id);
10681: END IF;
10682: -- Set savepoint again because commit will clear savepoint.
10683: SAVEPOINT s_move_proc;
10684: END IF;

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

10956: WHERE group_id = p_group_id;
10957:
10958: -- Fixed bug 4361566. Set global variable to let inventory know that they
10959: -- should not delete lock record from their temp table. These lock records
10960: -- will be deleted when wip call inv_table_lock_pvt.release_locks.
10961: WIP_CONSTANTS.WIP_MOVE_WORKER := 'Y';
10962:
10963: wip_movProc_priv.processIntf
10964: (p_group_id => p_group_id,