APPS.INV_PICK_RELEASE_PUB dependencies on INV_MOVE_ORDER_PUB

Line 256: procedure sort( p_trolin_tbl IN OUT NOCOPY INV_Move_Order_PUB.TROLIN_TBL_TYPE,

252: -- to the same shipset must be consecutive in the table. Because
253: -- these lines will usually be mostly in order already, we can use the
254: -- InsertionSort algorithm.
255:
256: procedure sort( p_trolin_tbl IN OUT NOCOPY INV_Move_Order_PUB.TROLIN_TBL_TYPE,
257: p_low_index IN NUMBER,
258: p_high_index IN NUMBER) IS
259: l_low_index NUMBER := p_low_index;
260: l_high_index NUMBER := p_high_index;

Line 263: l_trolin_rec INV_MOVE_ORDER_PUB.TROLIN_REC_TYPE;

259: l_low_index NUMBER := p_low_index;
260: l_high_index NUMBER := p_high_index;
261: l_pivot_idx NUMBER;
262: l_prior_index NUMBER;
263: l_trolin_rec INV_MOVE_ORDER_PUB.TROLIN_REC_TYPE;
264: l_pivot_rec INV_MOVE_ORDER_PUB.TROLIN_REC_TYPE;
265: i NUMBER;
266: j NUMBER;
267:

Line 264: l_pivot_rec INV_MOVE_ORDER_PUB.TROLIN_REC_TYPE;

260: l_high_index NUMBER := p_high_index;
261: l_pivot_idx NUMBER;
262: l_prior_index NUMBER;
263: l_trolin_rec INV_MOVE_ORDER_PUB.TROLIN_REC_TYPE;
264: l_pivot_rec INV_MOVE_ORDER_PUB.TROLIN_REC_TYPE;
265: i NUMBER;
266: j NUMBER;
267:
268: BEGIN

Line 301: PROCEDURE test_sort( p_trolin_tbl IN OUT NOCOPY INV_MOVE_ORDER_PUB.Trolin_Tbl_Type) IS

297: i := p_trolin_tbl.NEXT(i);
298: END LOOP;
299: END sort;
300:
301: PROCEDURE test_sort( p_trolin_tbl IN OUT NOCOPY INV_MOVE_ORDER_PUB.Trolin_Tbl_Type) IS
302: BEGIN
303: sort(p_trolin_tbl, p_trolin_tbl.FIRST, p_trolin_tbl.LAST);
304: END test_sort;
305:

Line 673: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE

669: ,p_commit IN VARCHAR2
670: ,x_return_status OUT NOCOPY VARCHAR2
671: ,x_msg_count OUT NOCOPY NUMBER
672: ,x_msg_data OUT NOCOPY VARCHAR2
673: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE
674: ,p_auto_pick_confirm IN NUMBER
675: ,p_grouping_rule_id IN NUMBER
676: ,p_allow_partial_pick IN VARCHAR2
677: ,x_pick_release_status OUT NOCOPY INV_Release_Status_Tbl_Type

Line 723: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE

719: ,p_commit IN VARCHAR2
720: ,x_return_status OUT NOCOPY VARCHAR2
721: ,x_msg_count OUT NOCOPY NUMBER
722: ,x_msg_data OUT NOCOPY VARCHAR2
723: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE
724: ,p_auto_pick_confirm IN NUMBER
725: ,p_grouping_rule_id IN NUMBER
726: ,p_allow_partial_pick IN VARCHAR2
727: ,x_pick_release_status OUT NOCOPY INV_Release_Status_Tbl_Type

Line 745: l_mo_line INV_Move_Order_PUB.TROLIN_REC_TYPE;

741: -- be pick released.
742: l_line_index NUMBER;
743: -- The index of the line in the table
744: -- being processed
745: l_mo_line INV_Move_Order_PUB.TROLIN_REC_TYPE;
746: -- Temporary record to hold information
747: -- on the record being processed.
748: l_organization_id NUMBER;
749: -- The organization ID to use (based

Line 782: l_mo_line_tbl INV_Move_Order_Pub.Trolin_Tbl_Type := p_mo_line_tbl;

778: -- processed.
779: l_detail_rec_count NUMBER := 0;
780: l_reservation_exists NUMBER := 0; --BUG13604664
781:
782: l_mo_line_tbl INV_Move_Order_Pub.Trolin_Tbl_Type := p_mo_line_tbl;
783: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
784: l_smc_backorder_det_tbl WSH_INTERFACE.ChangedAttributeTabType;
785: l_shipset_smc_backorder_rec WSH_INTEGRATION.BackorderRecType;
786: l_action_flag VARCHAR2(1);