DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on INV_MOVE_ORDER_PUB

Line 153: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

149: , p_sec_qty IN NUMBER := NULL -- Added for OPM convergance
150: , p_sec_uom IN VARCHAR2 := NULL -- Added for OPM convergance
151: , x_line_id OUT nocopy NUMBER -- Added for R12 MOL Consolidation
152: ) IS
153: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
154: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
155: l_msg_count NUMBER;
156: l_msg_data VARCHAR2(2400);
157: l_trohdr_val_rec inv_move_order_pub.trolin_val_tbl_type;

Line 157: l_trohdr_val_rec inv_move_order_pub.trolin_val_tbl_type;

153: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
154: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
155: l_msg_count NUMBER;
156: l_msg_data VARCHAR2(2400);
157: l_trohdr_val_rec inv_move_order_pub.trolin_val_tbl_type;
158: l_commit VARCHAR2(1) := fnd_api.g_false;
159: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
160: l_line_num NUMBER := 0;
161: l_header_id NUMBER := fnd_api.g_miss_num;

Line 159: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;

155: l_msg_count NUMBER;
156: l_msg_data VARCHAR2(2400);
157: l_trohdr_val_rec inv_move_order_pub.trolin_val_tbl_type;
158: l_commit VARCHAR2(1) := fnd_api.g_false;
159: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
160: l_line_num NUMBER := 0;
161: l_header_id NUMBER := fnd_api.g_miss_num;
162: l_order_count NUMBER := 1;
163: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;

Line 163: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;

159: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
160: l_line_num NUMBER := 0;
161: l_header_id NUMBER := fnd_api.g_miss_num;
162: l_order_count NUMBER := 1;
163: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
164: l_commit VARCHAR2(1) := fnd_api.g_false;
165: p_need_by_date DATE := SYSDATE;
166: p_src_subinv VARCHAR2(30);
167: l_org_id NUMBER;

Line 308: inv_move_order_pub.create_move_order_lines(

304:
305: l_trolin_tbl(l_order_count).from_cost_group_id := l_from_cg_id;
306: l_trolin_tbl(l_order_count).to_cost_group_id := l_from_cg_id;
307:
308: inv_move_order_pub.create_move_order_lines(
309: p_api_version_number => 1.0
310: , p_init_msg_list => 'F'
311: , p_commit => fnd_api.g_false
312: , x_return_status => l_return_status

Line 464: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

460: , p_transfer_org_id IN NUMBER DEFAULT NULL
461: , p_sec_qty IN NUMBER := NULL -- Added for OPM Convergance
462: , p_sec_uom IN VARCHAR2 := NULL -- Added for OPM Convergance
463: ) IS
464: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
465: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
466: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
467: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
468: l_msg_count NUMBER;

Line 465: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

461: , p_sec_qty IN NUMBER := NULL -- Added for OPM Convergance
462: , p_sec_uom IN VARCHAR2 := NULL -- Added for OPM Convergance
463: ) IS
464: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
465: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
466: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
467: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
468: l_msg_count NUMBER;
469: l_msg_data VARCHAR2(2000);

Line 466: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;

462: , p_sec_uom IN VARCHAR2 := NULL -- Added for OPM Convergance
463: ) IS
464: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
465: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
466: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
467: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
468: l_msg_count NUMBER;
469: l_msg_data VARCHAR2(2000);
470: msg VARCHAR2(2000);

Line 474: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;

470: msg VARCHAR2(2000);
471: l_header_id NUMBER := fnd_api.g_miss_num;
472: l_line_num NUMBER := 0;
473: l_order_count NUMBER := 1;
474: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
475: l_commit VARCHAR2(1) := fnd_api.g_false;
476: p_need_by_date DATE := SYSDATE;
477: p_src_subinv VARCHAR2(30);
478: l_org_id NUMBER;

Line 671: inv_move_order_pub.process_move_order(

667: IF (l_debug = 1) THEN
668: mydebug('create_mo: Header Not passed. Calling Process_Move_Order');
669: END IF;
670:
671: inv_move_order_pub.process_move_order(
672: p_api_version_number => 1.0
673: , p_init_msg_list => 'F'
674: , p_commit => fnd_api.g_false
675: , x_return_status => l_return_status