DBA Data[Home] [Help]

APPS.WMS_ITEM_LOAD dependencies on INV_RCV_INTEGRATION_APIS

Line 463: l_mo_lines_tb inv_rcv_integration_apis.mo_in_tb_tp;

459: l_sec_qty_used NUMBER;
460: l_sec_qty_left NUMBER;
461: -- Move order line table to store the move order line(s)
462: -- used to match against the load entry values
463: l_mo_lines_tb inv_rcv_integration_apis.mo_in_tb_tp;
464: l_tmp_mo_lines_tb inv_rcv_integration_apis.mo_in_tb_tp;
465: l_index NUMBER;
466: -- Cursor to get move order lines with available quantity
467: -- which match the item load entry parameters

Line 464: l_tmp_mo_lines_tb inv_rcv_integration_apis.mo_in_tb_tp;

460: l_sec_qty_left NUMBER;
461: -- Move order line table to store the move order line(s)
462: -- used to match against the load entry values
463: l_mo_lines_tb inv_rcv_integration_apis.mo_in_tb_tp;
464: l_tmp_mo_lines_tb inv_rcv_integration_apis.mo_in_tb_tp;
465: l_index NUMBER;
466: -- Cursor to get move order lines with available quantity
467: -- which match the item load entry parameters
468: CURSOR mo_lines_cursor IS

Line 569: l_mo_split_tb inv_rcv_integration_apis.mo_in_tb_tp;

565: l_drop_sec_quantity NUMBER;
566: l_inspect_sec_quantity NUMBER;
567: l_error_code NUMBER;
568: -- Variables used to call split_mo API
569: l_mo_split_tb inv_rcv_integration_apis.mo_in_tb_tp;
570: -- Variables used to call insert MMTT API
571: l_return NUMBER;
572: l_txn_temp_id NUMBER;
573: l_subinv_code VARCHAR2(10);

Line 1510: inv_rcv_integration_apis.split_mo

1506:
1507: IF (l_debug = 1) THEN
1508: print_debug('Calling split_mo API');
1509: END IF;
1510: inv_rcv_integration_apis.split_mo
1511: (p_orig_mol_id => l_mo_lines_tb(l_index).line_id,
1512: p_mo_splt_tb => l_mo_split_tb,
1513: p_operation_type => 'LOAD',
1514: x_return_status => x_return_status,

Line 2151: l_mo_lines_tb inv_rcv_integration_apis.mo_in_tb_tp;

2147: l_load_sec_quantity NUMBER;
2148: l_drop_sec_quantity NUMBER;
2149: l_inspect_sec_quantity NUMBER;
2150: -- Variable used for calling pack_unpack_split
2151: l_mo_lines_tb inv_rcv_integration_apis.mo_in_tb_tp;
2152: l_index NUMBER;
2153: -- Variable used to store the current receiving txn mode
2154: l_txn_mode_code VARCHAR2(25);
2155: -- Variables used to call the Inventory TM