DBA Data[Home] [Help]

APPS.WMS_CARTNZN_PUB dependencies on WMS_CARTONIZATION_USER_PUB

Line 8017: l_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;

8013:
8014: TYPE l_cart_tab_type IS TABLE OF mtl_material_transactions_temp.cartonization_id%TYPE INDEX BY BINARY_INTEGER;
8015: TYPE l_trans_temp_tab_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
8016:
8017: l_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;
8018: l_out_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;
8019:
8020: CURSOR Delivery_cur (p_pick_slip_number NUMBER)
8021: IS

Line 8018: l_out_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;

8014: TYPE l_cart_tab_type IS TABLE OF mtl_material_transactions_temp.cartonization_id%TYPE INDEX BY BINARY_INTEGER;
8015: TYPE l_trans_temp_tab_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
8016:
8017: l_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;
8018: l_out_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;
8019:
8020: CURSOR Delivery_cur (p_pick_slip_number NUMBER)
8021: IS
8022: SELECT DISTINCT wda.delivery_id

Line 8148: WMS_CARTONIZATION_USER_PUB.CARTONIZE (

8144: IF (g_trace_on = 1) THEN
8145: log_event('l_mmtt_table.COUNT : ' || l_mmtt_table.COUNT);
8146: END IF;
8147:
8148: WMS_CARTONIZATION_USER_PUB.CARTONIZE (
8149: x_return_status => l_cart_return_status
8150: , x_msg_count => l_msg_count
8151: , x_msg_data => l_msg_data
8152: , x_task_table => l_out_mmtt_table

Line 8164: log_event('WMS_CARTONIZATION_USER_PUB.cartonize() returned failure, exiting cartonize_customer_logic() ');

8160:
8161: IF NVL(l_cart_return_status,'E') = 'E'
8162: OR l_mmtt_table.COUNT <> l_out_mmtt_table.COUNT THEN
8163: IF (g_trace_on = 1) THEN
8164: log_event('WMS_CARTONIZATION_USER_PUB.cartonize() returned failure, exiting cartonize_customer_logic() ');
8165: END IF;
8166: x_return_status := 'E';
8167: RETURN;
8168: END IF;