DBA Data[Home] [Help]

APPS.WMS_CARTNZN_PUB dependencies on INV_RCV_COMMON_APIS

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

100: SUBTYPE WDR_ROW IS WMS_DEVICE_REQUESTS%ROWTYPE;
101:
102: SUBTYPE MMTT_ROW_TYPE IS MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
103:
104: -- Table that needs to be passed inv_rcv_common_apis for splitting
105: -- mtl_transaction_lots_temp and mtl_serial_numbers_temp
106:
107: api_table inv_rcv_common_apis.trans_rec_tb_tp;
108:

Line 107: api_table inv_rcv_common_apis.trans_rec_tb_tp;

103:
104: -- Table that needs to be passed inv_rcv_common_apis for splitting
105: -- mtl_transaction_lots_temp and mtl_serial_numbers_temp
106:
107: api_table inv_rcv_common_apis.trans_rec_tb_tp;
108:
109: -- This value is incremented and inserted into sequence_id of the table
110: -- wms_packaging_hist on every insert
111: --sequence_id NUMBER := 1;

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

3001: END LOOP;
3002:
3003: IF api_table_index > 0 THEN
3004: --Setting the variable to order lots by creation date
3005: inv_rcv_common_apis.g_order_lots_by := inv_rcv_common_apis.g_order_lots_by_creation_date;
3006:
3007: inv_rcv_common_apis.break
3008: (p_original_tid => curr_temp_id,
3009: p_new_transactions_tb => api_table,

Line 3007: inv_rcv_common_apis.break

3003: IF api_table_index > 0 THEN
3004: --Setting the variable to order lots by creation date
3005: inv_rcv_common_apis.g_order_lots_by := inv_rcv_common_apis.g_order_lots_by_creation_date;
3006:
3007: inv_rcv_common_apis.break
3008: (p_original_tid => curr_temp_id,
3009: p_new_transactions_tb => api_table,
3010: p_lot_control_code => v_lot_control_code,
3011: p_serial_control_code => v_serial_control_code);

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

3010: p_lot_control_code => v_lot_control_code,
3011: p_serial_control_code => v_serial_control_code);
3012:
3013: --Setting it back to default
3014: inv_rcv_common_apis.g_order_lots_by := inv_rcv_common_apis.g_order_lots_by_exp_date;
3015: END IF;
3016:
3017: /* Hack for sony */
3018: UPDATE mtl_transaction_lots_temp