DBA Data[Home] [Help]

APPS.WMS_CARTNZN_PUB dependencies on INV_RCV_COMMON_APIS

Line 180: -- Table that needs to be passed inv_rcv_common_apis for splitting

176:
177: t_lpn_alloc_flag_table lpn_alloc_flag_tb;
178:
179:
180: -- Table that needs to be passed inv_rcv_common_apis for splitting
181: -- mtl_transaction_lots_temp and mtl_serial_numbers_temp
182:
183: api_table inv_rcv_common_apis.trans_rec_tb_tp;
184:

Line 183: api_table inv_rcv_common_apis.trans_rec_tb_tp;

179:
180: -- Table that needs to be passed inv_rcv_common_apis for splitting
181: -- mtl_transaction_lots_temp and mtl_serial_numbers_temp
182:
183: api_table inv_rcv_common_apis.trans_rec_tb_tp;
184:
185: -- This value is incremented and inserted into sequence_id of the table
186: -- wms_packaging_hist on every insert
187: --sequence_id NUMBER := 1;

Line 3025: inv_rcv_common_apis.g_order_lots_by := inv_rcv_common_apis.g_order_lots_by_creation_date;

3021: END LOOP;
3022:
3023: IF api_table_index > 0 THEN
3024: --Setting the variable to order lots by creation date
3025: inv_rcv_common_apis.g_order_lots_by := inv_rcv_common_apis.g_order_lots_by_creation_date;
3026:
3027: inv_rcv_common_apis.break
3028: (p_original_tid => curr_temp_id,
3029: p_new_transactions_tb => api_table,

Line 3027: inv_rcv_common_apis.break

3023: IF api_table_index > 0 THEN
3024: --Setting the variable to order lots by creation date
3025: inv_rcv_common_apis.g_order_lots_by := inv_rcv_common_apis.g_order_lots_by_creation_date;
3026:
3027: inv_rcv_common_apis.break
3028: (p_original_tid => curr_temp_id,
3029: p_new_transactions_tb => api_table,
3030: p_lot_control_code => v_lot_control_code,
3031: p_serial_control_code => v_serial_control_code);

Line 3034: inv_rcv_common_apis.g_order_lots_by := inv_rcv_common_apis.g_order_lots_by_exp_date;

3030: p_lot_control_code => v_lot_control_code,
3031: p_serial_control_code => v_serial_control_code);
3032:
3033: --Setting it back to default
3034: inv_rcv_common_apis.g_order_lots_by := inv_rcv_common_apis.g_order_lots_by_exp_date;
3035: END IF;
3036:
3037: /* Hack for sony */
3038: UPDATE mtl_transaction_lots_temp