DBA Data[Home] [Help]

APPS.WMS_CARTNZN_PUB dependencies on WMS_CARTONIZATION_USER_PUB

Line 8106: l_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;

8102:
8103: TYPE l_cart_tab_type IS TABLE OF mtl_material_transactions_temp.cartonization_id%TYPE INDEX BY BINARY_INTEGER;
8104: TYPE l_trans_temp_tab_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
8105:
8106: l_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;
8107: l_out_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;
8108:
8109: CURSOR Delivery_cur (p_pick_slip_number NUMBER)
8110: IS

Line 8107: l_out_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;

8103: TYPE l_cart_tab_type IS TABLE OF mtl_material_transactions_temp.cartonization_id%TYPE INDEX BY BINARY_INTEGER;
8104: TYPE l_trans_temp_tab_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
8105:
8106: l_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;
8107: l_out_mmtt_table WMS_CARTONIZATION_USER_PUB.mmtt_type;
8108:
8109: CURSOR Delivery_cur (p_pick_slip_number NUMBER)
8110: IS
8111: SELECT DISTINCT wda.delivery_id

Line 8243: WMS_CARTONIZATION_USER_PUB.CARTONIZE (

8239: IF (g_trace_on = 1) THEN
8240: log_event('l_mmtt_table.COUNT : ' || l_mmtt_table.COUNT);
8241: END IF;
8242:
8243: WMS_CARTONIZATION_USER_PUB.CARTONIZE (
8244: x_return_status => l_cart_return_status
8245: , x_msg_count => l_msg_count
8246: , x_msg_data => l_msg_data
8247: , x_task_table => l_out_mmtt_table

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

8255:
8256: IF NVL(l_cart_return_status,'E') = 'E'
8257: OR l_mmtt_table.COUNT <> l_out_mmtt_table.COUNT THEN
8258: IF (g_trace_on = 1) THEN
8259: log_event('WMS_CARTONIZATION_USER_PUB.cartonize() returned failure, exiting cartonize_customer_logic() ');
8260: END IF;
8261: x_return_status := 'E';
8262: RETURN;
8263: END IF;