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 663: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE

659: ,p_commit IN VARCHAR2
660: ,x_return_status OUT NOCOPY VARCHAR2
661: ,x_msg_count OUT NOCOPY NUMBER
662: ,x_msg_data OUT NOCOPY VARCHAR2
663: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE
664: ,p_auto_pick_confirm IN NUMBER
665: ,p_grouping_rule_id IN NUMBER
666: ,p_allow_partial_pick IN VARCHAR2
667: ,x_pick_release_status OUT NOCOPY INV_Release_Status_Tbl_Type

Line 713: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE

709: ,p_commit IN VARCHAR2
710: ,x_return_status OUT NOCOPY VARCHAR2
711: ,x_msg_count OUT NOCOPY NUMBER
712: ,x_msg_data OUT NOCOPY VARCHAR2
713: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE
714: ,p_auto_pick_confirm IN NUMBER
715: ,p_grouping_rule_id IN NUMBER
716: ,p_allow_partial_pick IN VARCHAR2
717: ,x_pick_release_status OUT NOCOPY INV_Release_Status_Tbl_Type

Line 735: l_mo_line INV_Move_Order_PUB.TROLIN_REC_TYPE;

731: -- be pick released.
732: l_line_index NUMBER;
733: -- The index of the line in the table
734: -- being processed
735: l_mo_line INV_Move_Order_PUB.TROLIN_REC_TYPE;
736: -- Temporary record to hold information
737: -- on the record being processed.
738: l_organization_id NUMBER;
739: -- The organization ID to use (based

Line 771: l_mo_line_tbl INV_Move_Order_Pub.Trolin_Tbl_Type := p_mo_line_tbl;

767: -- The number of rows which have been
768: -- processed.
769: l_detail_rec_count NUMBER := 0;
770:
771: l_mo_line_tbl INV_Move_Order_Pub.Trolin_Tbl_Type := p_mo_line_tbl;
772: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
773: l_smc_backorder_det_tbl WSH_INTERFACE.ChangedAttributeTabType;
774: l_shipset_smc_backorder_rec WSH_INTEGRATION.BackorderRecType;
775: l_action_flag VARCHAR2(1);