eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_WAVE_PLANNING_PVT dependencies on DBMS_SQL

Line 106: -- Column variables for DBMS_SQL package for mapping to values

102: g_return_status VARCHAR2(1);
103: ajith varchar2(4000);
104: -- ajith1 varchar2(4000);
105: -- ajith2 varchar2(4000);
106: -- Column variables for DBMS_SQL package for mapping to values
107: -- selected from cursors
108: v_source_code varchar2(30);
109: v_header_id NUMBER;
110: v_line_id NUMBER;

Line 13406: v_CursorID := DBMS_SQL.Open_Cursor;

13402:
13403: g_orderby_SQL := g_orderby_SQL || ' WDD.SOURCE_LINE_ID, ' ||
13404: ' SHIP_FROM_LOCATION_ID, ' || ' SHIP_METHOD_CODE';
13405: -- Parse cursor
13406: v_CursorID := DBMS_SQL.Open_Cursor;
13407: print_debug('Parse cursor', l_debug);
13408:
13409: print_debug('Printing Dynamic SQL', l_debug);
13410: print_debug('g_unreleased_sql :' || g_unreleased_sql, l_debug);

Line 13416: DBMS_SQL.Parse(v_CursorID,

13412: print_debug('g_where_sql :' || g_where_sql, l_debug);
13413: print_debug('g_cond_sql :' || g_cond_sql, l_debug);
13414: print_debug('g_orderby_sql :' || g_orderby_sql, l_debug);
13415:
13416: DBMS_SQL.Parse(v_CursorID,
13417: '( ' || g_Unreleased_SQL || g_Cond_SQL || ' ) ' ||
13418: g_orderby_SQL,
13419: DBMS_SQL.v7);
13420:

Line 13419: DBMS_SQL.v7);

13415:
13416: DBMS_SQL.Parse(v_CursorID,
13417: '( ' || g_Unreleased_SQL || g_Cond_SQL || ' ) ' ||
13418: g_orderby_SQL,
13419: DBMS_SQL.v7);
13420:
13421: print_debug('Column definition for cursor', l_debug);
13422: DBMS_SQL.Define_Column(v_CursorID, 1, v_source_code, 30);
13423: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);

Line 13422: DBMS_SQL.Define_Column(v_CursorID, 1, v_source_code, 30);

13418: g_orderby_SQL,
13419: DBMS_SQL.v7);
13420:
13421: print_debug('Column definition for cursor', l_debug);
13422: DBMS_SQL.Define_Column(v_CursorID, 1, v_source_code, 30);
13423: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
13424: DBMS_SQL.Define_Column(v_CursorID, 3, v_line_id);
13425: DBMS_SQL.Define_Column(v_CursorID, 4, v_header_number, 150);
13426: DBMS_SQL.Define_Column(v_CursorID, 5, v_line_number, 150);

Line 13423: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);

13419: DBMS_SQL.v7);
13420:
13421: print_debug('Column definition for cursor', l_debug);
13422: DBMS_SQL.Define_Column(v_CursorID, 1, v_source_code, 30);
13423: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
13424: DBMS_SQL.Define_Column(v_CursorID, 3, v_line_id);
13425: DBMS_SQL.Define_Column(v_CursorID, 4, v_header_number, 150);
13426: DBMS_SQL.Define_Column(v_CursorID, 5, v_line_number, 150);
13427: DBMS_SQL.Define_Column(v_CursorID, 6, v_header_type_name, 240);

Line 13424: DBMS_SQL.Define_Column(v_CursorID, 3, v_line_id);

13420:
13421: print_debug('Column definition for cursor', l_debug);
13422: DBMS_SQL.Define_Column(v_CursorID, 1, v_source_code, 30);
13423: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
13424: DBMS_SQL.Define_Column(v_CursorID, 3, v_line_id);
13425: DBMS_SQL.Define_Column(v_CursorID, 4, v_header_number, 150);
13426: DBMS_SQL.Define_Column(v_CursorID, 5, v_line_number, 150);
13427: DBMS_SQL.Define_Column(v_CursorID, 6, v_header_type_name, 240);
13428: DBMS_SQL.Define_Column(v_CursorID, 7, v_header_type_id);

Line 13425: DBMS_SQL.Define_Column(v_CursorID, 4, v_header_number, 150);

13421: print_debug('Column definition for cursor', l_debug);
13422: DBMS_SQL.Define_Column(v_CursorID, 1, v_source_code, 30);
13423: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
13424: DBMS_SQL.Define_Column(v_CursorID, 3, v_line_id);
13425: DBMS_SQL.Define_Column(v_CursorID, 4, v_header_number, 150);
13426: DBMS_SQL.Define_Column(v_CursorID, 5, v_line_number, 150);
13427: DBMS_SQL.Define_Column(v_CursorID, 6, v_header_type_name, 240);
13428: DBMS_SQL.Define_Column(v_CursorID, 7, v_header_type_id);
13429: DBMS_SQL.Define_Column(v_CursorID, 8, v_document_type_id);

Line 13426: DBMS_SQL.Define_Column(v_CursorID, 5, v_line_number, 150);

13422: DBMS_SQL.Define_Column(v_CursorID, 1, v_source_code, 30);
13423: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
13424: DBMS_SQL.Define_Column(v_CursorID, 3, v_line_id);
13425: DBMS_SQL.Define_Column(v_CursorID, 4, v_header_number, 150);
13426: DBMS_SQL.Define_Column(v_CursorID, 5, v_line_number, 150);
13427: DBMS_SQL.Define_Column(v_CursorID, 6, v_header_type_name, 240);
13428: DBMS_SQL.Define_Column(v_CursorID, 7, v_header_type_id);
13429: DBMS_SQL.Define_Column(v_CursorID, 8, v_document_type_id);
13430: DBMS_SQL.Define_Column(v_CursorID, 9, v_delivery_detail_id);

Line 13427: DBMS_SQL.Define_Column(v_CursorID, 6, v_header_type_name, 240);

13423: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
13424: DBMS_SQL.Define_Column(v_CursorID, 3, v_line_id);
13425: DBMS_SQL.Define_Column(v_CursorID, 4, v_header_number, 150);
13426: DBMS_SQL.Define_Column(v_CursorID, 5, v_line_number, 150);
13427: DBMS_SQL.Define_Column(v_CursorID, 6, v_header_type_name, 240);
13428: DBMS_SQL.Define_Column(v_CursorID, 7, v_header_type_id);
13429: DBMS_SQL.Define_Column(v_CursorID, 8, v_document_type_id);
13430: DBMS_SQL.Define_Column(v_CursorID, 9, v_delivery_detail_id);
13431: DBMS_SQL.Define_Column(v_CursorID, 10, v_released_status, 1);

Line 13428: DBMS_SQL.Define_Column(v_CursorID, 7, v_header_type_id);

13424: DBMS_SQL.Define_Column(v_CursorID, 3, v_line_id);
13425: DBMS_SQL.Define_Column(v_CursorID, 4, v_header_number, 150);
13426: DBMS_SQL.Define_Column(v_CursorID, 5, v_line_number, 150);
13427: DBMS_SQL.Define_Column(v_CursorID, 6, v_header_type_name, 240);
13428: DBMS_SQL.Define_Column(v_CursorID, 7, v_header_type_id);
13429: DBMS_SQL.Define_Column(v_CursorID, 8, v_document_type_id);
13430: DBMS_SQL.Define_Column(v_CursorID, 9, v_delivery_detail_id);
13431: DBMS_SQL.Define_Column(v_CursorID, 10, v_released_status, 1);
13432: DBMS_SQL.Define_Column(v_CursorID, 11, v_org_id);

Line 13429: DBMS_SQL.Define_Column(v_CursorID, 8, v_document_type_id);

13425: DBMS_SQL.Define_Column(v_CursorID, 4, v_header_number, 150);
13426: DBMS_SQL.Define_Column(v_CursorID, 5, v_line_number, 150);
13427: DBMS_SQL.Define_Column(v_CursorID, 6, v_header_type_name, 240);
13428: DBMS_SQL.Define_Column(v_CursorID, 7, v_header_type_id);
13429: DBMS_SQL.Define_Column(v_CursorID, 8, v_document_type_id);
13430: DBMS_SQL.Define_Column(v_CursorID, 9, v_delivery_detail_id);
13431: DBMS_SQL.Define_Column(v_CursorID, 10, v_released_status, 1);
13432: DBMS_SQL.Define_Column(v_CursorID, 11, v_org_id);
13433: DBMS_SQL.Define_Column(v_CursorID, 12, v_inventory_item_id);

Line 13430: DBMS_SQL.Define_Column(v_CursorID, 9, v_delivery_detail_id);

13426: DBMS_SQL.Define_Column(v_CursorID, 5, v_line_number, 150);
13427: DBMS_SQL.Define_Column(v_CursorID, 6, v_header_type_name, 240);
13428: DBMS_SQL.Define_Column(v_CursorID, 7, v_header_type_id);
13429: DBMS_SQL.Define_Column(v_CursorID, 8, v_document_type_id);
13430: DBMS_SQL.Define_Column(v_CursorID, 9, v_delivery_detail_id);
13431: DBMS_SQL.Define_Column(v_CursorID, 10, v_released_status, 1);
13432: DBMS_SQL.Define_Column(v_CursorID, 11, v_org_id);
13433: DBMS_SQL.Define_Column(v_CursorID, 12, v_inventory_item_id);
13434: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);

Line 13431: DBMS_SQL.Define_Column(v_CursorID, 10, v_released_status, 1);

13427: DBMS_SQL.Define_Column(v_CursorID, 6, v_header_type_name, 240);
13428: DBMS_SQL.Define_Column(v_CursorID, 7, v_header_type_id);
13429: DBMS_SQL.Define_Column(v_CursorID, 8, v_document_type_id);
13430: DBMS_SQL.Define_Column(v_CursorID, 9, v_delivery_detail_id);
13431: DBMS_SQL.Define_Column(v_CursorID, 10, v_released_status, 1);
13432: DBMS_SQL.Define_Column(v_CursorID, 11, v_org_id);
13433: DBMS_SQL.Define_Column(v_CursorID, 12, v_inventory_item_id);
13434: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
13435: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom, 3);

Line 13432: DBMS_SQL.Define_Column(v_CursorID, 11, v_org_id);

13428: DBMS_SQL.Define_Column(v_CursorID, 7, v_header_type_id);
13429: DBMS_SQL.Define_Column(v_CursorID, 8, v_document_type_id);
13430: DBMS_SQL.Define_Column(v_CursorID, 9, v_delivery_detail_id);
13431: DBMS_SQL.Define_Column(v_CursorID, 10, v_released_status, 1);
13432: DBMS_SQL.Define_Column(v_CursorID, 11, v_org_id);
13433: DBMS_SQL.Define_Column(v_CursorID, 12, v_inventory_item_id);
13434: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
13435: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom, 3);
13436: DBMS_SQL.Define_Column(v_CursorID, 15, v_move_order_line_id);

Line 13433: DBMS_SQL.Define_Column(v_CursorID, 12, v_inventory_item_id);

13429: DBMS_SQL.Define_Column(v_CursorID, 8, v_document_type_id);
13430: DBMS_SQL.Define_Column(v_CursorID, 9, v_delivery_detail_id);
13431: DBMS_SQL.Define_Column(v_CursorID, 10, v_released_status, 1);
13432: DBMS_SQL.Define_Column(v_CursorID, 11, v_org_id);
13433: DBMS_SQL.Define_Column(v_CursorID, 12, v_inventory_item_id);
13434: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
13435: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom, 3);
13436: DBMS_SQL.Define_Column(v_CursorID, 15, v_move_order_line_id);
13437: DBMS_SQL.Define_Column(v_CursorID, 16, v_ship_model_complete_flag, 1);

Line 13434: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);

13430: DBMS_SQL.Define_Column(v_CursorID, 9, v_delivery_detail_id);
13431: DBMS_SQL.Define_Column(v_CursorID, 10, v_released_status, 1);
13432: DBMS_SQL.Define_Column(v_CursorID, 11, v_org_id);
13433: DBMS_SQL.Define_Column(v_CursorID, 12, v_inventory_item_id);
13434: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
13435: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom, 3);
13436: DBMS_SQL.Define_Column(v_CursorID, 15, v_move_order_line_id);
13437: DBMS_SQL.Define_Column(v_CursorID, 16, v_ship_model_complete_flag, 1);
13438: DBMS_SQL.Define_Column(v_CursorID, 17, v_top_model_id);

Line 13435: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom, 3);

13431: DBMS_SQL.Define_Column(v_CursorID, 10, v_released_status, 1);
13432: DBMS_SQL.Define_Column(v_CursorID, 11, v_org_id);
13433: DBMS_SQL.Define_Column(v_CursorID, 12, v_inventory_item_id);
13434: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
13435: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom, 3);
13436: DBMS_SQL.Define_Column(v_CursorID, 15, v_move_order_line_id);
13437: DBMS_SQL.Define_Column(v_CursorID, 16, v_ship_model_complete_flag, 1);
13438: DBMS_SQL.Define_Column(v_CursorID, 17, v_top_model_id);
13439: DBMS_SQL.Define_Column(v_CursorID, 18, v_ship_from_location_id);

Line 13436: DBMS_SQL.Define_Column(v_CursorID, 15, v_move_order_line_id);

13432: DBMS_SQL.Define_Column(v_CursorID, 11, v_org_id);
13433: DBMS_SQL.Define_Column(v_CursorID, 12, v_inventory_item_id);
13434: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
13435: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom, 3);
13436: DBMS_SQL.Define_Column(v_CursorID, 15, v_move_order_line_id);
13437: DBMS_SQL.Define_Column(v_CursorID, 16, v_ship_model_complete_flag, 1);
13438: DBMS_SQL.Define_Column(v_CursorID, 17, v_top_model_id);
13439: DBMS_SQL.Define_Column(v_CursorID, 18, v_ship_from_location_id);
13440: DBMS_SQL.Define_Column(v_CursorID, 19, v_ship_to_location_id);

Line 13437: DBMS_SQL.Define_Column(v_CursorID, 16, v_ship_model_complete_flag, 1);

13433: DBMS_SQL.Define_Column(v_CursorID, 12, v_inventory_item_id);
13434: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
13435: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom, 3);
13436: DBMS_SQL.Define_Column(v_CursorID, 15, v_move_order_line_id);
13437: DBMS_SQL.Define_Column(v_CursorID, 16, v_ship_model_complete_flag, 1);
13438: DBMS_SQL.Define_Column(v_CursorID, 17, v_top_model_id);
13439: DBMS_SQL.Define_Column(v_CursorID, 18, v_ship_from_location_id);
13440: DBMS_SQL.Define_Column(v_CursorID, 19, v_ship_to_location_id);
13441: DBMS_SQL.Define_Column(v_CursorID, 20, v_ship_method_code, 30);

Line 13438: DBMS_SQL.Define_Column(v_CursorID, 17, v_top_model_id);

13434: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
13435: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom, 3);
13436: DBMS_SQL.Define_Column(v_CursorID, 15, v_move_order_line_id);
13437: DBMS_SQL.Define_Column(v_CursorID, 16, v_ship_model_complete_flag, 1);
13438: DBMS_SQL.Define_Column(v_CursorID, 17, v_top_model_id);
13439: DBMS_SQL.Define_Column(v_CursorID, 18, v_ship_from_location_id);
13440: DBMS_SQL.Define_Column(v_CursorID, 19, v_ship_to_location_id);
13441: DBMS_SQL.Define_Column(v_CursorID, 20, v_ship_method_code, 30);
13442: DBMS_SQL.Define_Column(v_CursorID, 21, v_shipment_priority_code, 30);

Line 13439: DBMS_SQL.Define_Column(v_CursorID, 18, v_ship_from_location_id);

13435: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom, 3);
13436: DBMS_SQL.Define_Column(v_CursorID, 15, v_move_order_line_id);
13437: DBMS_SQL.Define_Column(v_CursorID, 16, v_ship_model_complete_flag, 1);
13438: DBMS_SQL.Define_Column(v_CursorID, 17, v_top_model_id);
13439: DBMS_SQL.Define_Column(v_CursorID, 18, v_ship_from_location_id);
13440: DBMS_SQL.Define_Column(v_CursorID, 19, v_ship_to_location_id);
13441: DBMS_SQL.Define_Column(v_CursorID, 20, v_ship_method_code, 30);
13442: DBMS_SQL.Define_Column(v_CursorID, 21, v_shipment_priority_code, 30);
13443: DBMS_SQL.Define_Column(v_CursorID, 22, v_ship_set_id);

Line 13440: DBMS_SQL.Define_Column(v_CursorID, 19, v_ship_to_location_id);

13436: DBMS_SQL.Define_Column(v_CursorID, 15, v_move_order_line_id);
13437: DBMS_SQL.Define_Column(v_CursorID, 16, v_ship_model_complete_flag, 1);
13438: DBMS_SQL.Define_Column(v_CursorID, 17, v_top_model_id);
13439: DBMS_SQL.Define_Column(v_CursorID, 18, v_ship_from_location_id);
13440: DBMS_SQL.Define_Column(v_CursorID, 19, v_ship_to_location_id);
13441: DBMS_SQL.Define_Column(v_CursorID, 20, v_ship_method_code, 30);
13442: DBMS_SQL.Define_Column(v_CursorID, 21, v_shipment_priority_code, 30);
13443: DBMS_SQL.Define_Column(v_CursorID, 22, v_ship_set_id);
13444: DBMS_SQL.Define_Column(v_CursorID, 23, v_date_scheduled);

Line 13441: DBMS_SQL.Define_Column(v_CursorID, 20, v_ship_method_code, 30);

13437: DBMS_SQL.Define_Column(v_CursorID, 16, v_ship_model_complete_flag, 1);
13438: DBMS_SQL.Define_Column(v_CursorID, 17, v_top_model_id);
13439: DBMS_SQL.Define_Column(v_CursorID, 18, v_ship_from_location_id);
13440: DBMS_SQL.Define_Column(v_CursorID, 19, v_ship_to_location_id);
13441: DBMS_SQL.Define_Column(v_CursorID, 20, v_ship_method_code, 30);
13442: DBMS_SQL.Define_Column(v_CursorID, 21, v_shipment_priority_code, 30);
13443: DBMS_SQL.Define_Column(v_CursorID, 22, v_ship_set_id);
13444: DBMS_SQL.Define_Column(v_CursorID, 23, v_date_scheduled);
13445: DBMS_SQL.Define_Column(v_CursorID, 24, v_planned_departure_date);

Line 13442: DBMS_SQL.Define_Column(v_CursorID, 21, v_shipment_priority_code, 30);

13438: DBMS_SQL.Define_Column(v_CursorID, 17, v_top_model_id);
13439: DBMS_SQL.Define_Column(v_CursorID, 18, v_ship_from_location_id);
13440: DBMS_SQL.Define_Column(v_CursorID, 19, v_ship_to_location_id);
13441: DBMS_SQL.Define_Column(v_CursorID, 20, v_ship_method_code, 30);
13442: DBMS_SQL.Define_Column(v_CursorID, 21, v_shipment_priority_code, 30);
13443: DBMS_SQL.Define_Column(v_CursorID, 22, v_ship_set_id);
13444: DBMS_SQL.Define_Column(v_CursorID, 23, v_date_scheduled);
13445: DBMS_SQL.Define_Column(v_CursorID, 24, v_planned_departure_date);
13446: DBMS_SQL.Define_Column(v_CursorID, 25, v_delivery_id);

Line 13443: DBMS_SQL.Define_Column(v_CursorID, 22, v_ship_set_id);

13439: DBMS_SQL.Define_Column(v_CursorID, 18, v_ship_from_location_id);
13440: DBMS_SQL.Define_Column(v_CursorID, 19, v_ship_to_location_id);
13441: DBMS_SQL.Define_Column(v_CursorID, 20, v_ship_method_code, 30);
13442: DBMS_SQL.Define_Column(v_CursorID, 21, v_shipment_priority_code, 30);
13443: DBMS_SQL.Define_Column(v_CursorID, 22, v_ship_set_id);
13444: DBMS_SQL.Define_Column(v_CursorID, 23, v_date_scheduled);
13445: DBMS_SQL.Define_Column(v_CursorID, 24, v_planned_departure_date);
13446: DBMS_SQL.Define_Column(v_CursorID, 25, v_delivery_id);
13447: DBMS_SQL.Define_Column(v_CursorID, 26, v_customer_id);

Line 13444: DBMS_SQL.Define_Column(v_CursorID, 23, v_date_scheduled);

13440: DBMS_SQL.Define_Column(v_CursorID, 19, v_ship_to_location_id);
13441: DBMS_SQL.Define_Column(v_CursorID, 20, v_ship_method_code, 30);
13442: DBMS_SQL.Define_Column(v_CursorID, 21, v_shipment_priority_code, 30);
13443: DBMS_SQL.Define_Column(v_CursorID, 22, v_ship_set_id);
13444: DBMS_SQL.Define_Column(v_CursorID, 23, v_date_scheduled);
13445: DBMS_SQL.Define_Column(v_CursorID, 24, v_planned_departure_date);
13446: DBMS_SQL.Define_Column(v_CursorID, 25, v_delivery_id);
13447: DBMS_SQL.Define_Column(v_CursorID, 26, v_customer_id);
13448: DBMS_SQL.Define_Column(v_CursorID, 27, v_carrier_id);

Line 13445: DBMS_SQL.Define_Column(v_CursorID, 24, v_planned_departure_date);

13441: DBMS_SQL.Define_Column(v_CursorID, 20, v_ship_method_code, 30);
13442: DBMS_SQL.Define_Column(v_CursorID, 21, v_shipment_priority_code, 30);
13443: DBMS_SQL.Define_Column(v_CursorID, 22, v_ship_set_id);
13444: DBMS_SQL.Define_Column(v_CursorID, 23, v_date_scheduled);
13445: DBMS_SQL.Define_Column(v_CursorID, 24, v_planned_departure_date);
13446: DBMS_SQL.Define_Column(v_CursorID, 25, v_delivery_id);
13447: DBMS_SQL.Define_Column(v_CursorID, 26, v_customer_id);
13448: DBMS_SQL.Define_Column(v_CursorID, 27, v_carrier_id);
13449: DBMS_SQL.Define_Column(v_CursorID, 28, v_preferred_grade);

Line 13446: DBMS_SQL.Define_Column(v_CursorID, 25, v_delivery_id);

13442: DBMS_SQL.Define_Column(v_CursorID, 21, v_shipment_priority_code, 30);
13443: DBMS_SQL.Define_Column(v_CursorID, 22, v_ship_set_id);
13444: DBMS_SQL.Define_Column(v_CursorID, 23, v_date_scheduled);
13445: DBMS_SQL.Define_Column(v_CursorID, 24, v_planned_departure_date);
13446: DBMS_SQL.Define_Column(v_CursorID, 25, v_delivery_id);
13447: DBMS_SQL.Define_Column(v_CursorID, 26, v_customer_id);
13448: DBMS_SQL.Define_Column(v_CursorID, 27, v_carrier_id);
13449: DBMS_SQL.Define_Column(v_CursorID, 28, v_preferred_grade);
13450: DBMS_SQL.Define_Column(v_CursorID, 29, v_requested_quantity2);

Line 13447: DBMS_SQL.Define_Column(v_CursorID, 26, v_customer_id);

13443: DBMS_SQL.Define_Column(v_CursorID, 22, v_ship_set_id);
13444: DBMS_SQL.Define_Column(v_CursorID, 23, v_date_scheduled);
13445: DBMS_SQL.Define_Column(v_CursorID, 24, v_planned_departure_date);
13446: DBMS_SQL.Define_Column(v_CursorID, 25, v_delivery_id);
13447: DBMS_SQL.Define_Column(v_CursorID, 26, v_customer_id);
13448: DBMS_SQL.Define_Column(v_CursorID, 27, v_carrier_id);
13449: DBMS_SQL.Define_Column(v_CursorID, 28, v_preferred_grade);
13450: DBMS_SQL.Define_Column(v_CursorID, 29, v_requested_quantity2);
13451: DBMS_SQL.Define_Column(v_CursorID, 30, v_requested_quantity_uom2, 3);

Line 13448: DBMS_SQL.Define_Column(v_CursorID, 27, v_carrier_id);

13444: DBMS_SQL.Define_Column(v_CursorID, 23, v_date_scheduled);
13445: DBMS_SQL.Define_Column(v_CursorID, 24, v_planned_departure_date);
13446: DBMS_SQL.Define_Column(v_CursorID, 25, v_delivery_id);
13447: DBMS_SQL.Define_Column(v_CursorID, 26, v_customer_id);
13448: DBMS_SQL.Define_Column(v_CursorID, 27, v_carrier_id);
13449: DBMS_SQL.Define_Column(v_CursorID, 28, v_preferred_grade);
13450: DBMS_SQL.Define_Column(v_CursorID, 29, v_requested_quantity2);
13451: DBMS_SQL.Define_Column(v_CursorID, 30, v_requested_quantity_uom2, 3);
13452: DBMS_SQL.Define_Column(v_CursorID, 31, v_project_id);

Line 13449: DBMS_SQL.Define_Column(v_CursorID, 28, v_preferred_grade);

13445: DBMS_SQL.Define_Column(v_CursorID, 24, v_planned_departure_date);
13446: DBMS_SQL.Define_Column(v_CursorID, 25, v_delivery_id);
13447: DBMS_SQL.Define_Column(v_CursorID, 26, v_customer_id);
13448: DBMS_SQL.Define_Column(v_CursorID, 27, v_carrier_id);
13449: DBMS_SQL.Define_Column(v_CursorID, 28, v_preferred_grade);
13450: DBMS_SQL.Define_Column(v_CursorID, 29, v_requested_quantity2);
13451: DBMS_SQL.Define_Column(v_CursorID, 30, v_requested_quantity_uom2, 3);
13452: DBMS_SQL.Define_Column(v_CursorID, 31, v_project_id);
13453: DBMS_SQL.Define_Column(v_CursorID, 32, v_task_id);

Line 13450: DBMS_SQL.Define_Column(v_CursorID, 29, v_requested_quantity2);

13446: DBMS_SQL.Define_Column(v_CursorID, 25, v_delivery_id);
13447: DBMS_SQL.Define_Column(v_CursorID, 26, v_customer_id);
13448: DBMS_SQL.Define_Column(v_CursorID, 27, v_carrier_id);
13449: DBMS_SQL.Define_Column(v_CursorID, 28, v_preferred_grade);
13450: DBMS_SQL.Define_Column(v_CursorID, 29, v_requested_quantity2);
13451: DBMS_SQL.Define_Column(v_CursorID, 30, v_requested_quantity_uom2, 3);
13452: DBMS_SQL.Define_Column(v_CursorID, 31, v_project_id);
13453: DBMS_SQL.Define_Column(v_CursorID, 32, v_task_id);
13454: DBMS_SQL.Define_Column(v_CursorID, 33, v_subinventory, 30);

Line 13451: DBMS_SQL.Define_Column(v_CursorID, 30, v_requested_quantity_uom2, 3);

13447: DBMS_SQL.Define_Column(v_CursorID, 26, v_customer_id);
13448: DBMS_SQL.Define_Column(v_CursorID, 27, v_carrier_id);
13449: DBMS_SQL.Define_Column(v_CursorID, 28, v_preferred_grade);
13450: DBMS_SQL.Define_Column(v_CursorID, 29, v_requested_quantity2);
13451: DBMS_SQL.Define_Column(v_CursorID, 30, v_requested_quantity_uom2, 3);
13452: DBMS_SQL.Define_Column(v_CursorID, 31, v_project_id);
13453: DBMS_SQL.Define_Column(v_CursorID, 32, v_task_id);
13454: DBMS_SQL.Define_Column(v_CursorID, 33, v_subinventory, 30);
13455: DBMS_SQL.Define_Column(v_CursorID, 34, v_weight_uom_code, 5);

Line 13452: DBMS_SQL.Define_Column(v_CursorID, 31, v_project_id);

13448: DBMS_SQL.Define_Column(v_CursorID, 27, v_carrier_id);
13449: DBMS_SQL.Define_Column(v_CursorID, 28, v_preferred_grade);
13450: DBMS_SQL.Define_Column(v_CursorID, 29, v_requested_quantity2);
13451: DBMS_SQL.Define_Column(v_CursorID, 30, v_requested_quantity_uom2, 3);
13452: DBMS_SQL.Define_Column(v_CursorID, 31, v_project_id);
13453: DBMS_SQL.Define_Column(v_CursorID, 32, v_task_id);
13454: DBMS_SQL.Define_Column(v_CursorID, 33, v_subinventory, 30);
13455: DBMS_SQL.Define_Column(v_CursorID, 34, v_weight_uom_code, 5);
13456: DBMS_SQL.Define_Column(v_CursorID, 35, v_net_weight);

Line 13453: DBMS_SQL.Define_Column(v_CursorID, 32, v_task_id);

13449: DBMS_SQL.Define_Column(v_CursorID, 28, v_preferred_grade);
13450: DBMS_SQL.Define_Column(v_CursorID, 29, v_requested_quantity2);
13451: DBMS_SQL.Define_Column(v_CursorID, 30, v_requested_quantity_uom2, 3);
13452: DBMS_SQL.Define_Column(v_CursorID, 31, v_project_id);
13453: DBMS_SQL.Define_Column(v_CursorID, 32, v_task_id);
13454: DBMS_SQL.Define_Column(v_CursorID, 33, v_subinventory, 30);
13455: DBMS_SQL.Define_Column(v_CursorID, 34, v_weight_uom_code, 5);
13456: DBMS_SQL.Define_Column(v_CursorID, 35, v_net_weight);
13457: DBMS_SQL.Define_Column(v_CursorID, 36, v_volume_uom_code, 5);

Line 13454: DBMS_SQL.Define_Column(v_CursorID, 33, v_subinventory, 30);

13450: DBMS_SQL.Define_Column(v_CursorID, 29, v_requested_quantity2);
13451: DBMS_SQL.Define_Column(v_CursorID, 30, v_requested_quantity_uom2, 3);
13452: DBMS_SQL.Define_Column(v_CursorID, 31, v_project_id);
13453: DBMS_SQL.Define_Column(v_CursorID, 32, v_task_id);
13454: DBMS_SQL.Define_Column(v_CursorID, 33, v_subinventory, 30);
13455: DBMS_SQL.Define_Column(v_CursorID, 34, v_weight_uom_code, 5);
13456: DBMS_SQL.Define_Column(v_CursorID, 35, v_net_weight);
13457: DBMS_SQL.Define_Column(v_CursorID, 36, v_volume_uom_code, 5);
13458: DBMS_SQL.Define_Column(v_CursorID, 37, v_volume);

Line 13455: DBMS_SQL.Define_Column(v_CursorID, 34, v_weight_uom_code, 5);

13451: DBMS_SQL.Define_Column(v_CursorID, 30, v_requested_quantity_uom2, 3);
13452: DBMS_SQL.Define_Column(v_CursorID, 31, v_project_id);
13453: DBMS_SQL.Define_Column(v_CursorID, 32, v_task_id);
13454: DBMS_SQL.Define_Column(v_CursorID, 33, v_subinventory, 30);
13455: DBMS_SQL.Define_Column(v_CursorID, 34, v_weight_uom_code, 5);
13456: DBMS_SQL.Define_Column(v_CursorID, 35, v_net_weight);
13457: DBMS_SQL.Define_Column(v_CursorID, 36, v_volume_uom_code, 5);
13458: DBMS_SQL.Define_Column(v_CursorID, 37, v_volume);
13459: -- Bind release criteria values

Line 13456: DBMS_SQL.Define_Column(v_CursorID, 35, v_net_weight);

13452: DBMS_SQL.Define_Column(v_CursorID, 31, v_project_id);
13453: DBMS_SQL.Define_Column(v_CursorID, 32, v_task_id);
13454: DBMS_SQL.Define_Column(v_CursorID, 33, v_subinventory, 30);
13455: DBMS_SQL.Define_Column(v_CursorID, 34, v_weight_uom_code, 5);
13456: DBMS_SQL.Define_Column(v_CursorID, 35, v_net_weight);
13457: DBMS_SQL.Define_Column(v_CursorID, 36, v_volume_uom_code, 5);
13458: DBMS_SQL.Define_Column(v_CursorID, 37, v_volume);
13459: -- Bind release criteria values
13460:

Line 13457: DBMS_SQL.Define_Column(v_CursorID, 36, v_volume_uom_code, 5);

13453: DBMS_SQL.Define_Column(v_CursorID, 32, v_task_id);
13454: DBMS_SQL.Define_Column(v_CursorID, 33, v_subinventory, 30);
13455: DBMS_SQL.Define_Column(v_CursorID, 34, v_weight_uom_code, 5);
13456: DBMS_SQL.Define_Column(v_CursorID, 35, v_net_weight);
13457: DBMS_SQL.Define_Column(v_CursorID, 36, v_volume_uom_code, 5);
13458: DBMS_SQL.Define_Column(v_CursorID, 37, v_volume);
13459: -- Bind release criteria values
13460:
13461: print_debug('Bind cursor', L_debug);

Line 13458: DBMS_SQL.Define_Column(v_CursorID, 37, v_volume);

13454: DBMS_SQL.Define_Column(v_CursorID, 33, v_subinventory, 30);
13455: DBMS_SQL.Define_Column(v_CursorID, 34, v_weight_uom_code, 5);
13456: DBMS_SQL.Define_Column(v_CursorID, 35, v_net_weight);
13457: DBMS_SQL.Define_Column(v_CursorID, 36, v_volume_uom_code, 5);
13458: DBMS_SQL.Define_Column(v_CursorID, 37, v_volume);
13459: -- Bind release criteria values
13460:
13461: print_debug('Bind cursor', L_debug);
13462:

Line 13464: -- DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_del_detail_id',g_del_line_id);

13460:
13461: print_debug('Bind cursor', L_debug);
13462:
13463: /* IF (g_del_line_id <> 0 AND g_del_lines_list IS NULL) THEN
13464: -- DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_del_detail_id',g_del_line_id);
13465: END IF;*/
13466: IF (g_customer_class_id is not null) THEN
13467: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13468: ':X_CUSTOMER_CLASS_ID',

Line 13467: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13463: /* IF (g_del_line_id <> 0 AND g_del_lines_list IS NULL) THEN
13464: -- DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_del_detail_id',g_del_line_id);
13465: END IF;*/
13466: IF (g_customer_class_id is not null) THEN
13467: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13468: ':X_CUSTOMER_CLASS_ID',
13469: g_customer_class_id);
13470: END IF;
13471:

Line 13473: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_header_id', g_order_header_id);

13469: g_customer_class_id);
13470: END IF;
13471:
13472: IF (g_order_header_id <> 0) THEN
13473: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_header_id', g_order_header_id);
13474: END IF;
13475: /* IF (g_order_line_id <> 0) THEN
13476: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_line_id',g_order_line_id);
13477: END IF;*/

Line 13476: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_line_id',g_order_line_id);

13472: IF (g_order_header_id <> 0) THEN
13473: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_header_id', g_order_header_id);
13474: END IF;
13475: /* IF (g_order_line_id <> 0) THEN
13476: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_line_id',g_order_line_id);
13477: END IF;*/
13478: IF (g_customer_id <> 0) THEN
13479: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_customer_id', g_customer_id);
13480: END IF;

Line 13479: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_customer_id', g_customer_id);

13475: /* IF (g_order_line_id <> 0) THEN
13476: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_line_id',g_order_line_id);
13477: END IF;*/
13478: IF (g_customer_id <> 0) THEN
13479: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_customer_id', g_customer_id);
13480: END IF;
13481: IF (g_item_category_id <> 0) THEN
13482: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13483: ':X_category_id',

Line 13482: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13478: IF (g_customer_id <> 0) THEN
13479: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_customer_id', g_customer_id);
13480: END IF;
13481: IF (g_item_category_id <> 0) THEN
13482: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13483: ':X_category_id',
13484: g_item_category_id);
13485: END IF;
13486: IF (g_ship_from_loc_id <> -1) THEN

Line 13487: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13483: ':X_category_id',
13484: g_item_category_id);
13485: END IF;
13486: IF (g_ship_from_loc_id <> -1) THEN
13487: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13488: ':X_ship_from_loc_id',
13489: g_ship_from_loc_id);
13490: END IF;
13491: IF (g_ship_to_loc_id <> 0) THEN

Line 13492: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13488: ':X_ship_from_loc_id',
13489: g_ship_from_loc_id);
13490: END IF;
13491: IF (g_ship_to_loc_id <> 0) THEN
13492: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13493: ':X_ship_to_loc_id',
13494: g_ship_to_loc_id);
13495: END IF;
13496: -- DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_backorders_flag',g_backorders_flag);

Line 13496: -- DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_backorders_flag',g_backorders_flag);

13492: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13493: ':X_ship_to_loc_id',
13494: g_ship_to_loc_id);
13495: END IF;
13496: -- DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_backorders_flag',g_backorders_flag);
13497: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_order_type_id', g_order_type_id);
13498: -- DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_ship_set_id', g_ship_set_number);
13499: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_task_id', g_task_id);
13500: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_project_id', g_project_id);

Line 13497: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_order_type_id', g_order_type_id);

13493: ':X_ship_to_loc_id',
13494: g_ship_to_loc_id);
13495: END IF;
13496: -- DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_backorders_flag',g_backorders_flag);
13497: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_order_type_id', g_order_type_id);
13498: -- DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_ship_set_id', g_ship_set_number);
13499: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_task_id', g_task_id);
13500: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_project_id', g_project_id);
13501: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_org_id', p_organization_id);

Line 13498: -- DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_ship_set_id', g_ship_set_number);

13494: g_ship_to_loc_id);
13495: END IF;
13496: -- DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_backorders_flag',g_backorders_flag);
13497: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_order_type_id', g_order_type_id);
13498: -- DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_ship_set_id', g_ship_set_number);
13499: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_task_id', g_task_id);
13500: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_project_id', g_project_id);
13501: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_org_id', p_organization_id);
13502: DBMS_SQL.BIND_VARIABLE(v_CursorID,

Line 13499: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_task_id', g_task_id);

13495: END IF;
13496: -- DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_backorders_flag',g_backorders_flag);
13497: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_order_type_id', g_order_type_id);
13498: -- DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_ship_set_id', g_ship_set_number);
13499: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_task_id', g_task_id);
13500: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_project_id', g_project_id);
13501: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_org_id', p_organization_id);
13502: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13503: ':X_ship_method_code',

Line 13500: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_project_id', g_project_id);

13496: -- DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_backorders_flag',g_backorders_flag);
13497: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_order_type_id', g_order_type_id);
13498: -- DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_ship_set_id', g_ship_set_number);
13499: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_task_id', g_task_id);
13500: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_project_id', g_project_id);
13501: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_org_id', p_organization_id);
13502: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13503: ':X_ship_method_code',
13504: g_ship_method_code);

Line 13501: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_org_id', p_organization_id);

13497: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_order_type_id', g_order_type_id);
13498: -- DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_ship_set_id', g_ship_set_number);
13499: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_task_id', g_task_id);
13500: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_project_id', g_project_id);
13501: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_org_id', p_organization_id);
13502: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13503: ':X_ship_method_code',
13504: g_ship_method_code);
13505: DBMS_SQL.BIND_VARIABLE(v_CursorID,

Line 13502: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13498: -- DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_ship_set_id', g_ship_set_number);
13499: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_task_id', g_task_id);
13500: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_project_id', g_project_id);
13501: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_org_id', p_organization_id);
13502: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13503: ':X_ship_method_code',
13504: g_ship_method_code);
13505: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13506: ':X_shipment_priority',

Line 13505: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13501: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_org_id', p_organization_id);
13502: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13503: ':X_ship_method_code',
13504: g_ship_method_code);
13505: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13506: ':X_shipment_priority',
13507: g_shipment_priority);
13508: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13509: ':X_from_request_date',

Line 13508: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13504: g_ship_method_code);
13505: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13506: ':X_shipment_priority',
13507: g_shipment_priority);
13508: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13509: ':X_from_request_date',
13510: g_from_request_date);
13511: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13512: ':X_to_request_date',

Line 13511: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13507: g_shipment_priority);
13508: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13509: ':X_from_request_date',
13510: g_from_request_date);
13511: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13512: ':X_to_request_date',
13513: g_to_request_date);
13514: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13515: ':X_from_sched_ship_date',

Line 13514: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13510: g_from_request_date);
13511: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13512: ':X_to_request_date',
13513: g_to_request_date);
13514: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13515: ':X_from_sched_ship_date',
13516: g_from_sched_ship_date);
13517: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13518: ':X_to_sched_ship_date',

Line 13517: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13513: g_to_request_date);
13514: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13515: ':X_from_sched_ship_date',
13516: g_from_sched_ship_date);
13517: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13518: ':X_to_sched_ship_date',
13519: g_to_sched_ship_date);
13520: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13521: ':X_inventory_item_id',

Line 13520: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13516: g_from_sched_ship_date);
13517: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13518: ':X_to_sched_ship_date',
13519: g_to_sched_ship_date);
13520: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13521: ':X_inventory_item_id',
13522: g_inventory_item_id);
13523: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_trip_id', g_trip_id);
13524: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_delivery_id', g_delivery_id);

Line 13523: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_trip_id', g_trip_id);

13519: g_to_sched_ship_date);
13520: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13521: ':X_inventory_item_id',
13522: g_inventory_item_id);
13523: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_trip_id', g_trip_id);
13524: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_delivery_id', g_delivery_id);
13525: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13526: ':X_include_planned_lines',
13527: g_include_planned_lines);

Line 13524: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_delivery_id', g_delivery_id);

13520: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13521: ':X_inventory_item_id',
13522: g_inventory_item_id);
13523: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_trip_id', g_trip_id);
13524: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_delivery_id', g_delivery_id);
13525: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13526: ':X_include_planned_lines',
13527: g_include_planned_lines);
13528: IF (g_trip_id <> 0) THEN

Line 13525: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13521: ':X_inventory_item_id',
13522: g_inventory_item_id);
13523: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_trip_id', g_trip_id);
13524: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_delivery_id', g_delivery_id);
13525: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13526: ':X_include_planned_lines',
13527: g_include_planned_lines);
13528: IF (g_trip_id <> 0) THEN
13529: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_trip_stop_id', g_trip_stop_id);

Line 13529: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_trip_stop_id', g_trip_stop_id);

13525: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13526: ':X_include_planned_lines',
13527: g_include_planned_lines);
13528: IF (g_trip_id <> 0) THEN
13529: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_trip_stop_id', g_trip_stop_id);
13530: end if;
13531:
13532: if (g_from_dock_appoint_date is not null) then
13533: DBMS_SQL.BIND_VARIABLE(v_CursorID,

Line 13533: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13529: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_trip_stop_id', g_trip_stop_id);
13530: end if;
13531:
13532: if (g_from_dock_appoint_date is not null) then
13533: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13534: ':X_to_dock_appoint_date',
13535: g_to_dock_appoint_date);
13536: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13537: ':X_from_dock_appoint_date',

Line 13536: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13532: if (g_from_dock_appoint_date is not null) then
13533: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13534: ':X_to_dock_appoint_date',
13535: g_to_dock_appoint_date);
13536: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13537: ':X_from_dock_appoint_date',
13538: g_from_dock_appoint_date);
13539: END IF;
13540:

Line 13542: DBMS_SQL.BIND_VARIABLE(v_CursorID,

13538: g_from_dock_appoint_date);
13539: END IF;
13540:
13541: if nvl(g_add_lines, 'N') = 'Y' then
13542: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13543: ':X_WAVE_HEADER_ID',
13544: V_WAVE_HEADER_ID);
13545: end if;
13546: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_CARRIER_ID', g_CARRIER_ID);

Line 13546: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_CARRIER_ID', g_CARRIER_ID);

13542: DBMS_SQL.BIND_VARIABLE(v_CursorID,
13543: ':X_WAVE_HEADER_ID',
13544: V_WAVE_HEADER_ID);
13545: end if;
13546: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_CARRIER_ID', g_CARRIER_ID);
13547: -- Execute the cursor
13548: print_debug('Executing cursor', l_debug);
13549:
13550: IF DBMS_SQL.Is_Open(v_cursorID) THEN

Line 13550: IF DBMS_SQL.Is_Open(v_cursorID) THEN

13546: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':X_CARRIER_ID', g_CARRIER_ID);
13547: -- Execute the cursor
13548: print_debug('Executing cursor', l_debug);
13549:
13550: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13551: print_debug('The DBMS SQL is_open before the execute with rows for v_cursorID ' , l_debug);
13552: END IF;
13553: v_ignore := DBMS_SQL.Execute(v_CursorID);
13554: IF DBMS_SQL.Is_Open(v_cursorID) THEN

Line 13551: print_debug('The DBMS SQL is_open before the execute with rows for v_cursorID ' , l_debug);

13547: -- Execute the cursor
13548: print_debug('Executing cursor', l_debug);
13549:
13550: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13551: print_debug('The DBMS SQL is_open before the execute with rows for v_cursorID ' , l_debug);
13552: END IF;
13553: v_ignore := DBMS_SQL.Execute(v_CursorID);
13554: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13555: print_debug('The DBMS SQL is_open after the execute with rows for v_cursorID ' , l_debug);

Line 13553: v_ignore := DBMS_SQL.Execute(v_CursorID);

13549:
13550: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13551: print_debug('The DBMS SQL is_open before the execute with rows for v_cursorID ' , l_debug);
13552: END IF;
13553: v_ignore := DBMS_SQL.Execute(v_CursorID);
13554: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13555: print_debug('The DBMS SQL is_open after the execute with rows for v_cursorID ' , l_debug);
13556: END IF;
13557: x_api_status := fnd_api.g_ret_sts_success;

Line 13554: IF DBMS_SQL.Is_Open(v_cursorID) THEN

13550: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13551: print_debug('The DBMS SQL is_open before the execute with rows for v_cursorID ' , l_debug);
13552: END IF;
13553: v_ignore := DBMS_SQL.Execute(v_CursorID);
13554: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13555: print_debug('The DBMS SQL is_open after the execute with rows for v_cursorID ' , l_debug);
13556: END IF;
13557: x_api_status := fnd_api.g_ret_sts_success;
13558: EXCEPTION

Line 13555: print_debug('The DBMS SQL is_open after the execute with rows for v_cursorID ' , l_debug);

13551: print_debug('The DBMS SQL is_open before the execute with rows for v_cursorID ' , l_debug);
13552: END IF;
13553: v_ignore := DBMS_SQL.Execute(v_CursorID);
13554: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13555: print_debug('The DBMS SQL is_open after the execute with rows for v_cursorID ' , l_debug);
13556: END IF;
13557: x_api_status := fnd_api.g_ret_sts_success;
13558: EXCEPTION
13559: WHEN OTHERS THEN

Line 13630: IF DBMS_SQL.Is_Open(v_cursorID) THEN

13626: print_debug('Fetching Customer specified lines', l_debug);
13627: MAX_LINES := 1000;
13628: print_debug('MAX_LINES is ' || to_char(MAX_LINES), l_debug);
13629: -- Loop and fetch up to MAX_LINES
13630: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13631: print_debug('The DBMS SQL is_open with rows for v_cursorID ' , l_debug);
13632: END IF;
13633: LOOP
13634: IF g_rel_current_line < MAX_LINES THEN

Line 13631: print_debug('The DBMS SQL is_open with rows for v_cursorID ' , l_debug);

13627: MAX_LINES := 1000;
13628: print_debug('MAX_LINES is ' || to_char(MAX_LINES), l_debug);
13629: -- Loop and fetch up to MAX_LINES
13630: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13631: print_debug('The DBMS SQL is_open with rows for v_cursorID ' , l_debug);
13632: END IF;
13633: LOOP
13634: IF g_rel_current_line < MAX_LINES THEN
13635: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN

Line 13635: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN

13631: print_debug('The DBMS SQL is_open with rows for v_cursorID ' , l_debug);
13632: END IF;
13633: LOOP
13634: IF g_rel_current_line < MAX_LINES THEN
13635: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
13636: print_debug('Fetched all lines for organization', l_debug);
13637: x_done_flag := FND_API.G_TRUE;
13638: DBMS_SQL.Close_Cursor(v_cursorID);
13639: -- Reinitialize the first line marker since we have

Line 13638: DBMS_SQL.Close_Cursor(v_cursorID);

13634: IF g_rel_current_line < MAX_LINES THEN
13635: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
13636: print_debug('Fetched all lines for organization', l_debug);
13637: x_done_flag := FND_API.G_TRUE;
13638: DBMS_SQL.Close_Cursor(v_cursorID);
13639: -- Reinitialize the first line marker since we have
13640: -- fetched all rows
13641: first_line.source_header_id := -1;
13642: print_debug('After Fetching all ROWs ', l_debug);

Line 13683: IF DBMS_SQL.Is_Open(v_cursorID) THEN

13679:
13680: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13681: FND_MSG_PUB.Add_Exc_Msg('WSH_PR_CRITERIA', 'Get_Lines');
13682: END IF;
13683: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13684: DBMS_SQL.Close_Cursor(v_cursorID);
13685: END IF;
13686: x_done_flag := FND_API.G_RET_STS_ERROR;
13687: x_api_status := FND_API.G_RET_STS_ERROR;

Line 13684: DBMS_SQL.Close_Cursor(v_cursorID);

13680: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13681: FND_MSG_PUB.Add_Exc_Msg('WSH_PR_CRITERIA', 'Get_Lines');
13682: END IF;
13683: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13684: DBMS_SQL.Close_Cursor(v_cursorID);
13685: END IF;
13686: x_done_flag := FND_API.G_RET_STS_ERROR;
13687: x_api_status := FND_API.G_RET_STS_ERROR;
13688: END Get_Lines;

Line 13694: DBMS_SQL.Column_Value(v_CursorID, 1, v_source_code);

13690: PROCEDURE Insert_RL_Row(x_api_status OUT NOCOPY VARCHAR2) IS
13691: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13692: BEGIN
13693: print_debug('Map output columns', l_debug);
13694: DBMS_SQL.Column_Value(v_CursorID, 1, v_source_code);
13695: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
13696: DBMS_SQL.Column_Value(v_CursorID, 3, v_line_id);
13697: DBMS_SQL.Column_Value(v_CursorID, 4, v_header_number);
13698: DBMS_SQL.Column_Value(v_CursorID, 5, v_line_number);

Line 13695: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);

13691: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13692: BEGIN
13693: print_debug('Map output columns', l_debug);
13694: DBMS_SQL.Column_Value(v_CursorID, 1, v_source_code);
13695: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
13696: DBMS_SQL.Column_Value(v_CursorID, 3, v_line_id);
13697: DBMS_SQL.Column_Value(v_CursorID, 4, v_header_number);
13698: DBMS_SQL.Column_Value(v_CursorID, 5, v_line_number);
13699: DBMS_SQL.Column_Value(v_CursorID, 6, v_header_type_name);

Line 13696: DBMS_SQL.Column_Value(v_CursorID, 3, v_line_id);

13692: BEGIN
13693: print_debug('Map output columns', l_debug);
13694: DBMS_SQL.Column_Value(v_CursorID, 1, v_source_code);
13695: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
13696: DBMS_SQL.Column_Value(v_CursorID, 3, v_line_id);
13697: DBMS_SQL.Column_Value(v_CursorID, 4, v_header_number);
13698: DBMS_SQL.Column_Value(v_CursorID, 5, v_line_number);
13699: DBMS_SQL.Column_Value(v_CursorID, 6, v_header_type_name);
13700: DBMS_SQL.Column_Value(v_CursorID, 7, v_header_type_id);

Line 13697: DBMS_SQL.Column_Value(v_CursorID, 4, v_header_number);

13693: print_debug('Map output columns', l_debug);
13694: DBMS_SQL.Column_Value(v_CursorID, 1, v_source_code);
13695: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
13696: DBMS_SQL.Column_Value(v_CursorID, 3, v_line_id);
13697: DBMS_SQL.Column_Value(v_CursorID, 4, v_header_number);
13698: DBMS_SQL.Column_Value(v_CursorID, 5, v_line_number);
13699: DBMS_SQL.Column_Value(v_CursorID, 6, v_header_type_name);
13700: DBMS_SQL.Column_Value(v_CursorID, 7, v_header_type_id);
13701: DBMS_SQL.Column_Value(v_CursorID, 8, v_document_type_id);

Line 13698: DBMS_SQL.Column_Value(v_CursorID, 5, v_line_number);

13694: DBMS_SQL.Column_Value(v_CursorID, 1, v_source_code);
13695: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
13696: DBMS_SQL.Column_Value(v_CursorID, 3, v_line_id);
13697: DBMS_SQL.Column_Value(v_CursorID, 4, v_header_number);
13698: DBMS_SQL.Column_Value(v_CursorID, 5, v_line_number);
13699: DBMS_SQL.Column_Value(v_CursorID, 6, v_header_type_name);
13700: DBMS_SQL.Column_Value(v_CursorID, 7, v_header_type_id);
13701: DBMS_SQL.Column_Value(v_CursorID, 8, v_document_type_id);
13702: DBMS_SQL.Column_Value(v_CursorID, 9, v_delivery_detail_id);

Line 13699: DBMS_SQL.Column_Value(v_CursorID, 6, v_header_type_name);

13695: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
13696: DBMS_SQL.Column_Value(v_CursorID, 3, v_line_id);
13697: DBMS_SQL.Column_Value(v_CursorID, 4, v_header_number);
13698: DBMS_SQL.Column_Value(v_CursorID, 5, v_line_number);
13699: DBMS_SQL.Column_Value(v_CursorID, 6, v_header_type_name);
13700: DBMS_SQL.Column_Value(v_CursorID, 7, v_header_type_id);
13701: DBMS_SQL.Column_Value(v_CursorID, 8, v_document_type_id);
13702: DBMS_SQL.Column_Value(v_CursorID, 9, v_delivery_detail_id);
13703: DBMS_SQL.Column_Value(v_CursorID, 10, v_released_status);

Line 13700: DBMS_SQL.Column_Value(v_CursorID, 7, v_header_type_id);

13696: DBMS_SQL.Column_Value(v_CursorID, 3, v_line_id);
13697: DBMS_SQL.Column_Value(v_CursorID, 4, v_header_number);
13698: DBMS_SQL.Column_Value(v_CursorID, 5, v_line_number);
13699: DBMS_SQL.Column_Value(v_CursorID, 6, v_header_type_name);
13700: DBMS_SQL.Column_Value(v_CursorID, 7, v_header_type_id);
13701: DBMS_SQL.Column_Value(v_CursorID, 8, v_document_type_id);
13702: DBMS_SQL.Column_Value(v_CursorID, 9, v_delivery_detail_id);
13703: DBMS_SQL.Column_Value(v_CursorID, 10, v_released_status);
13704: DBMS_SQL.Column_Value(v_CursorID, 11, v_org_id);

Line 13701: DBMS_SQL.Column_Value(v_CursorID, 8, v_document_type_id);

13697: DBMS_SQL.Column_Value(v_CursorID, 4, v_header_number);
13698: DBMS_SQL.Column_Value(v_CursorID, 5, v_line_number);
13699: DBMS_SQL.Column_Value(v_CursorID, 6, v_header_type_name);
13700: DBMS_SQL.Column_Value(v_CursorID, 7, v_header_type_id);
13701: DBMS_SQL.Column_Value(v_CursorID, 8, v_document_type_id);
13702: DBMS_SQL.Column_Value(v_CursorID, 9, v_delivery_detail_id);
13703: DBMS_SQL.Column_Value(v_CursorID, 10, v_released_status);
13704: DBMS_SQL.Column_Value(v_CursorID, 11, v_org_id);
13705: DBMS_SQL.Column_Value(v_CursorID, 12, v_inventory_item_id);

Line 13702: DBMS_SQL.Column_Value(v_CursorID, 9, v_delivery_detail_id);

13698: DBMS_SQL.Column_Value(v_CursorID, 5, v_line_number);
13699: DBMS_SQL.Column_Value(v_CursorID, 6, v_header_type_name);
13700: DBMS_SQL.Column_Value(v_CursorID, 7, v_header_type_id);
13701: DBMS_SQL.Column_Value(v_CursorID, 8, v_document_type_id);
13702: DBMS_SQL.Column_Value(v_CursorID, 9, v_delivery_detail_id);
13703: DBMS_SQL.Column_Value(v_CursorID, 10, v_released_status);
13704: DBMS_SQL.Column_Value(v_CursorID, 11, v_org_id);
13705: DBMS_SQL.Column_Value(v_CursorID, 12, v_inventory_item_id);
13706: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);

Line 13703: DBMS_SQL.Column_Value(v_CursorID, 10, v_released_status);

13699: DBMS_SQL.Column_Value(v_CursorID, 6, v_header_type_name);
13700: DBMS_SQL.Column_Value(v_CursorID, 7, v_header_type_id);
13701: DBMS_SQL.Column_Value(v_CursorID, 8, v_document_type_id);
13702: DBMS_SQL.Column_Value(v_CursorID, 9, v_delivery_detail_id);
13703: DBMS_SQL.Column_Value(v_CursorID, 10, v_released_status);
13704: DBMS_SQL.Column_Value(v_CursorID, 11, v_org_id);
13705: DBMS_SQL.Column_Value(v_CursorID, 12, v_inventory_item_id);
13706: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
13707: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);

Line 13704: DBMS_SQL.Column_Value(v_CursorID, 11, v_org_id);

13700: DBMS_SQL.Column_Value(v_CursorID, 7, v_header_type_id);
13701: DBMS_SQL.Column_Value(v_CursorID, 8, v_document_type_id);
13702: DBMS_SQL.Column_Value(v_CursorID, 9, v_delivery_detail_id);
13703: DBMS_SQL.Column_Value(v_CursorID, 10, v_released_status);
13704: DBMS_SQL.Column_Value(v_CursorID, 11, v_org_id);
13705: DBMS_SQL.Column_Value(v_CursorID, 12, v_inventory_item_id);
13706: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
13707: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
13708: DBMS_SQL.Column_Value(v_CursorID, 15, v_move_order_line_id);

Line 13705: DBMS_SQL.Column_Value(v_CursorID, 12, v_inventory_item_id);

13701: DBMS_SQL.Column_Value(v_CursorID, 8, v_document_type_id);
13702: DBMS_SQL.Column_Value(v_CursorID, 9, v_delivery_detail_id);
13703: DBMS_SQL.Column_Value(v_CursorID, 10, v_released_status);
13704: DBMS_SQL.Column_Value(v_CursorID, 11, v_org_id);
13705: DBMS_SQL.Column_Value(v_CursorID, 12, v_inventory_item_id);
13706: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
13707: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
13708: DBMS_SQL.Column_Value(v_CursorID, 15, v_move_order_line_id);
13709: DBMS_SQL.Column_Value(v_CursorID, 16, v_ship_model_complete_flag);

Line 13706: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);

13702: DBMS_SQL.Column_Value(v_CursorID, 9, v_delivery_detail_id);
13703: DBMS_SQL.Column_Value(v_CursorID, 10, v_released_status);
13704: DBMS_SQL.Column_Value(v_CursorID, 11, v_org_id);
13705: DBMS_SQL.Column_Value(v_CursorID, 12, v_inventory_item_id);
13706: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
13707: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
13708: DBMS_SQL.Column_Value(v_CursorID, 15, v_move_order_line_id);
13709: DBMS_SQL.Column_Value(v_CursorID, 16, v_ship_model_complete_flag);
13710: DBMS_SQL.Column_Value(v_CursorID, 17, v_top_model_id);

Line 13707: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);

13703: DBMS_SQL.Column_Value(v_CursorID, 10, v_released_status);
13704: DBMS_SQL.Column_Value(v_CursorID, 11, v_org_id);
13705: DBMS_SQL.Column_Value(v_CursorID, 12, v_inventory_item_id);
13706: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
13707: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
13708: DBMS_SQL.Column_Value(v_CursorID, 15, v_move_order_line_id);
13709: DBMS_SQL.Column_Value(v_CursorID, 16, v_ship_model_complete_flag);
13710: DBMS_SQL.Column_Value(v_CursorID, 17, v_top_model_id);
13711: DBMS_SQL.Column_Value(v_CursorID, 18, v_ship_from_location_id);

Line 13708: DBMS_SQL.Column_Value(v_CursorID, 15, v_move_order_line_id);

13704: DBMS_SQL.Column_Value(v_CursorID, 11, v_org_id);
13705: DBMS_SQL.Column_Value(v_CursorID, 12, v_inventory_item_id);
13706: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
13707: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
13708: DBMS_SQL.Column_Value(v_CursorID, 15, v_move_order_line_id);
13709: DBMS_SQL.Column_Value(v_CursorID, 16, v_ship_model_complete_flag);
13710: DBMS_SQL.Column_Value(v_CursorID, 17, v_top_model_id);
13711: DBMS_SQL.Column_Value(v_CursorID, 18, v_ship_from_location_id);
13712: DBMS_SQL.Column_Value(v_CursorID, 19, v_ship_to_location_id);

Line 13709: DBMS_SQL.Column_Value(v_CursorID, 16, v_ship_model_complete_flag);

13705: DBMS_SQL.Column_Value(v_CursorID, 12, v_inventory_item_id);
13706: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
13707: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
13708: DBMS_SQL.Column_Value(v_CursorID, 15, v_move_order_line_id);
13709: DBMS_SQL.Column_Value(v_CursorID, 16, v_ship_model_complete_flag);
13710: DBMS_SQL.Column_Value(v_CursorID, 17, v_top_model_id);
13711: DBMS_SQL.Column_Value(v_CursorID, 18, v_ship_from_location_id);
13712: DBMS_SQL.Column_Value(v_CursorID, 19, v_ship_to_location_id);
13713: DBMS_SQL.Column_Value(v_CursorID, 20, v_ship_method_code);

Line 13710: DBMS_SQL.Column_Value(v_CursorID, 17, v_top_model_id);

13706: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
13707: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
13708: DBMS_SQL.Column_Value(v_CursorID, 15, v_move_order_line_id);
13709: DBMS_SQL.Column_Value(v_CursorID, 16, v_ship_model_complete_flag);
13710: DBMS_SQL.Column_Value(v_CursorID, 17, v_top_model_id);
13711: DBMS_SQL.Column_Value(v_CursorID, 18, v_ship_from_location_id);
13712: DBMS_SQL.Column_Value(v_CursorID, 19, v_ship_to_location_id);
13713: DBMS_SQL.Column_Value(v_CursorID, 20, v_ship_method_code);
13714: DBMS_SQL.Column_Value(v_CursorID, 21, v_shipment_priority_code);

Line 13711: DBMS_SQL.Column_Value(v_CursorID, 18, v_ship_from_location_id);

13707: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
13708: DBMS_SQL.Column_Value(v_CursorID, 15, v_move_order_line_id);
13709: DBMS_SQL.Column_Value(v_CursorID, 16, v_ship_model_complete_flag);
13710: DBMS_SQL.Column_Value(v_CursorID, 17, v_top_model_id);
13711: DBMS_SQL.Column_Value(v_CursorID, 18, v_ship_from_location_id);
13712: DBMS_SQL.Column_Value(v_CursorID, 19, v_ship_to_location_id);
13713: DBMS_SQL.Column_Value(v_CursorID, 20, v_ship_method_code);
13714: DBMS_SQL.Column_Value(v_CursorID, 21, v_shipment_priority_code);
13715: DBMS_SQL.Column_Value(v_CursorID, 22, v_ship_set_id);

Line 13712: DBMS_SQL.Column_Value(v_CursorID, 19, v_ship_to_location_id);

13708: DBMS_SQL.Column_Value(v_CursorID, 15, v_move_order_line_id);
13709: DBMS_SQL.Column_Value(v_CursorID, 16, v_ship_model_complete_flag);
13710: DBMS_SQL.Column_Value(v_CursorID, 17, v_top_model_id);
13711: DBMS_SQL.Column_Value(v_CursorID, 18, v_ship_from_location_id);
13712: DBMS_SQL.Column_Value(v_CursorID, 19, v_ship_to_location_id);
13713: DBMS_SQL.Column_Value(v_CursorID, 20, v_ship_method_code);
13714: DBMS_SQL.Column_Value(v_CursorID, 21, v_shipment_priority_code);
13715: DBMS_SQL.Column_Value(v_CursorID, 22, v_ship_set_id);
13716: DBMS_SQL.Column_Value(v_CursorID, 23, v_date_scheduled);

Line 13713: DBMS_SQL.Column_Value(v_CursorID, 20, v_ship_method_code);

13709: DBMS_SQL.Column_Value(v_CursorID, 16, v_ship_model_complete_flag);
13710: DBMS_SQL.Column_Value(v_CursorID, 17, v_top_model_id);
13711: DBMS_SQL.Column_Value(v_CursorID, 18, v_ship_from_location_id);
13712: DBMS_SQL.Column_Value(v_CursorID, 19, v_ship_to_location_id);
13713: DBMS_SQL.Column_Value(v_CursorID, 20, v_ship_method_code);
13714: DBMS_SQL.Column_Value(v_CursorID, 21, v_shipment_priority_code);
13715: DBMS_SQL.Column_Value(v_CursorID, 22, v_ship_set_id);
13716: DBMS_SQL.Column_Value(v_CursorID, 23, v_date_scheduled);
13717: DBMS_SQL.Column_Value(v_CursorID, 24, v_planned_departure_date);

Line 13714: DBMS_SQL.Column_Value(v_CursorID, 21, v_shipment_priority_code);

13710: DBMS_SQL.Column_Value(v_CursorID, 17, v_top_model_id);
13711: DBMS_SQL.Column_Value(v_CursorID, 18, v_ship_from_location_id);
13712: DBMS_SQL.Column_Value(v_CursorID, 19, v_ship_to_location_id);
13713: DBMS_SQL.Column_Value(v_CursorID, 20, v_ship_method_code);
13714: DBMS_SQL.Column_Value(v_CursorID, 21, v_shipment_priority_code);
13715: DBMS_SQL.Column_Value(v_CursorID, 22, v_ship_set_id);
13716: DBMS_SQL.Column_Value(v_CursorID, 23, v_date_scheduled);
13717: DBMS_SQL.Column_Value(v_CursorID, 24, v_planned_departure_date);
13718: DBMS_SQL.Column_Value(v_CursorID, 25, v_delivery_id);

Line 13715: DBMS_SQL.Column_Value(v_CursorID, 22, v_ship_set_id);

13711: DBMS_SQL.Column_Value(v_CursorID, 18, v_ship_from_location_id);
13712: DBMS_SQL.Column_Value(v_CursorID, 19, v_ship_to_location_id);
13713: DBMS_SQL.Column_Value(v_CursorID, 20, v_ship_method_code);
13714: DBMS_SQL.Column_Value(v_CursorID, 21, v_shipment_priority_code);
13715: DBMS_SQL.Column_Value(v_CursorID, 22, v_ship_set_id);
13716: DBMS_SQL.Column_Value(v_CursorID, 23, v_date_scheduled);
13717: DBMS_SQL.Column_Value(v_CursorID, 24, v_planned_departure_date);
13718: DBMS_SQL.Column_Value(v_CursorID, 25, v_delivery_id);
13719: DBMS_SQL.Column_Value(v_CursorID, 26, v_customer_id);

Line 13716: DBMS_SQL.Column_Value(v_CursorID, 23, v_date_scheduled);

13712: DBMS_SQL.Column_Value(v_CursorID, 19, v_ship_to_location_id);
13713: DBMS_SQL.Column_Value(v_CursorID, 20, v_ship_method_code);
13714: DBMS_SQL.Column_Value(v_CursorID, 21, v_shipment_priority_code);
13715: DBMS_SQL.Column_Value(v_CursorID, 22, v_ship_set_id);
13716: DBMS_SQL.Column_Value(v_CursorID, 23, v_date_scheduled);
13717: DBMS_SQL.Column_Value(v_CursorID, 24, v_planned_departure_date);
13718: DBMS_SQL.Column_Value(v_CursorID, 25, v_delivery_id);
13719: DBMS_SQL.Column_Value(v_CursorID, 26, v_customer_id);
13720: DBMS_SQL.Column_Value(v_CursorID, 27, v_carrier_id);

Line 13717: DBMS_SQL.Column_Value(v_CursorID, 24, v_planned_departure_date);

13713: DBMS_SQL.Column_Value(v_CursorID, 20, v_ship_method_code);
13714: DBMS_SQL.Column_Value(v_CursorID, 21, v_shipment_priority_code);
13715: DBMS_SQL.Column_Value(v_CursorID, 22, v_ship_set_id);
13716: DBMS_SQL.Column_Value(v_CursorID, 23, v_date_scheduled);
13717: DBMS_SQL.Column_Value(v_CursorID, 24, v_planned_departure_date);
13718: DBMS_SQL.Column_Value(v_CursorID, 25, v_delivery_id);
13719: DBMS_SQL.Column_Value(v_CursorID, 26, v_customer_id);
13720: DBMS_SQL.Column_Value(v_CursorID, 27, v_carrier_id);
13721: DBMS_SQL.Column_Value(v_CursorID, 28, v_preferred_grade);

Line 13718: DBMS_SQL.Column_Value(v_CursorID, 25, v_delivery_id);

13714: DBMS_SQL.Column_Value(v_CursorID, 21, v_shipment_priority_code);
13715: DBMS_SQL.Column_Value(v_CursorID, 22, v_ship_set_id);
13716: DBMS_SQL.Column_Value(v_CursorID, 23, v_date_scheduled);
13717: DBMS_SQL.Column_Value(v_CursorID, 24, v_planned_departure_date);
13718: DBMS_SQL.Column_Value(v_CursorID, 25, v_delivery_id);
13719: DBMS_SQL.Column_Value(v_CursorID, 26, v_customer_id);
13720: DBMS_SQL.Column_Value(v_CursorID, 27, v_carrier_id);
13721: DBMS_SQL.Column_Value(v_CursorID, 28, v_preferred_grade);
13722: DBMS_SQL.Column_Value(v_CursorID, 29, v_requested_quantity2);

Line 13719: DBMS_SQL.Column_Value(v_CursorID, 26, v_customer_id);

13715: DBMS_SQL.Column_Value(v_CursorID, 22, v_ship_set_id);
13716: DBMS_SQL.Column_Value(v_CursorID, 23, v_date_scheduled);
13717: DBMS_SQL.Column_Value(v_CursorID, 24, v_planned_departure_date);
13718: DBMS_SQL.Column_Value(v_CursorID, 25, v_delivery_id);
13719: DBMS_SQL.Column_Value(v_CursorID, 26, v_customer_id);
13720: DBMS_SQL.Column_Value(v_CursorID, 27, v_carrier_id);
13721: DBMS_SQL.Column_Value(v_CursorID, 28, v_preferred_grade);
13722: DBMS_SQL.Column_Value(v_CursorID, 29, v_requested_quantity2);
13723: DBMS_SQL.Column_Value(v_CursorID, 30, v_requested_quantity_uom2);

Line 13720: DBMS_SQL.Column_Value(v_CursorID, 27, v_carrier_id);

13716: DBMS_SQL.Column_Value(v_CursorID, 23, v_date_scheduled);
13717: DBMS_SQL.Column_Value(v_CursorID, 24, v_planned_departure_date);
13718: DBMS_SQL.Column_Value(v_CursorID, 25, v_delivery_id);
13719: DBMS_SQL.Column_Value(v_CursorID, 26, v_customer_id);
13720: DBMS_SQL.Column_Value(v_CursorID, 27, v_carrier_id);
13721: DBMS_SQL.Column_Value(v_CursorID, 28, v_preferred_grade);
13722: DBMS_SQL.Column_Value(v_CursorID, 29, v_requested_quantity2);
13723: DBMS_SQL.Column_Value(v_CursorID, 30, v_requested_quantity_uom2);
13724: DBMS_SQL.Column_Value(v_CursorID, 31, v_project_id);

Line 13721: DBMS_SQL.Column_Value(v_CursorID, 28, v_preferred_grade);

13717: DBMS_SQL.Column_Value(v_CursorID, 24, v_planned_departure_date);
13718: DBMS_SQL.Column_Value(v_CursorID, 25, v_delivery_id);
13719: DBMS_SQL.Column_Value(v_CursorID, 26, v_customer_id);
13720: DBMS_SQL.Column_Value(v_CursorID, 27, v_carrier_id);
13721: DBMS_SQL.Column_Value(v_CursorID, 28, v_preferred_grade);
13722: DBMS_SQL.Column_Value(v_CursorID, 29, v_requested_quantity2);
13723: DBMS_SQL.Column_Value(v_CursorID, 30, v_requested_quantity_uom2);
13724: DBMS_SQL.Column_Value(v_CursorID, 31, v_project_id);
13725: DBMS_SQL.Column_Value(v_CursorID, 32, v_task_id);

Line 13722: DBMS_SQL.Column_Value(v_CursorID, 29, v_requested_quantity2);

13718: DBMS_SQL.Column_Value(v_CursorID, 25, v_delivery_id);
13719: DBMS_SQL.Column_Value(v_CursorID, 26, v_customer_id);
13720: DBMS_SQL.Column_Value(v_CursorID, 27, v_carrier_id);
13721: DBMS_SQL.Column_Value(v_CursorID, 28, v_preferred_grade);
13722: DBMS_SQL.Column_Value(v_CursorID, 29, v_requested_quantity2);
13723: DBMS_SQL.Column_Value(v_CursorID, 30, v_requested_quantity_uom2);
13724: DBMS_SQL.Column_Value(v_CursorID, 31, v_project_id);
13725: DBMS_SQL.Column_Value(v_CursorID, 32, v_task_id);
13726: DBMS_SQL.Column_Value(v_CursorID, 33, v_subinventory);

Line 13723: DBMS_SQL.Column_Value(v_CursorID, 30, v_requested_quantity_uom2);

13719: DBMS_SQL.Column_Value(v_CursorID, 26, v_customer_id);
13720: DBMS_SQL.Column_Value(v_CursorID, 27, v_carrier_id);
13721: DBMS_SQL.Column_Value(v_CursorID, 28, v_preferred_grade);
13722: DBMS_SQL.Column_Value(v_CursorID, 29, v_requested_quantity2);
13723: DBMS_SQL.Column_Value(v_CursorID, 30, v_requested_quantity_uom2);
13724: DBMS_SQL.Column_Value(v_CursorID, 31, v_project_id);
13725: DBMS_SQL.Column_Value(v_CursorID, 32, v_task_id);
13726: DBMS_SQL.Column_Value(v_CursorID, 33, v_subinventory);
13727: DBMS_SQL.Column_Value(v_CursorID, 34, v_weight_uom_code);

Line 13724: DBMS_SQL.Column_Value(v_CursorID, 31, v_project_id);

13720: DBMS_SQL.Column_Value(v_CursorID, 27, v_carrier_id);
13721: DBMS_SQL.Column_Value(v_CursorID, 28, v_preferred_grade);
13722: DBMS_SQL.Column_Value(v_CursorID, 29, v_requested_quantity2);
13723: DBMS_SQL.Column_Value(v_CursorID, 30, v_requested_quantity_uom2);
13724: DBMS_SQL.Column_Value(v_CursorID, 31, v_project_id);
13725: DBMS_SQL.Column_Value(v_CursorID, 32, v_task_id);
13726: DBMS_SQL.Column_Value(v_CursorID, 33, v_subinventory);
13727: DBMS_SQL.Column_Value(v_CursorID, 34, v_weight_uom_code);
13728: DBMS_SQL.Column_Value(v_CursorID, 35, v_net_weight);

Line 13725: DBMS_SQL.Column_Value(v_CursorID, 32, v_task_id);

13721: DBMS_SQL.Column_Value(v_CursorID, 28, v_preferred_grade);
13722: DBMS_SQL.Column_Value(v_CursorID, 29, v_requested_quantity2);
13723: DBMS_SQL.Column_Value(v_CursorID, 30, v_requested_quantity_uom2);
13724: DBMS_SQL.Column_Value(v_CursorID, 31, v_project_id);
13725: DBMS_SQL.Column_Value(v_CursorID, 32, v_task_id);
13726: DBMS_SQL.Column_Value(v_CursorID, 33, v_subinventory);
13727: DBMS_SQL.Column_Value(v_CursorID, 34, v_weight_uom_code);
13728: DBMS_SQL.Column_Value(v_CursorID, 35, v_net_weight);
13729: DBMS_SQL.Column_Value(v_CursorID, 36, v_volume_uom_code);

Line 13726: DBMS_SQL.Column_Value(v_CursorID, 33, v_subinventory);

13722: DBMS_SQL.Column_Value(v_CursorID, 29, v_requested_quantity2);
13723: DBMS_SQL.Column_Value(v_CursorID, 30, v_requested_quantity_uom2);
13724: DBMS_SQL.Column_Value(v_CursorID, 31, v_project_id);
13725: DBMS_SQL.Column_Value(v_CursorID, 32, v_task_id);
13726: DBMS_SQL.Column_Value(v_CursorID, 33, v_subinventory);
13727: DBMS_SQL.Column_Value(v_CursorID, 34, v_weight_uom_code);
13728: DBMS_SQL.Column_Value(v_CursorID, 35, v_net_weight);
13729: DBMS_SQL.Column_Value(v_CursorID, 36, v_volume_uom_code);
13730:

Line 13727: DBMS_SQL.Column_Value(v_CursorID, 34, v_weight_uom_code);

13723: DBMS_SQL.Column_Value(v_CursorID, 30, v_requested_quantity_uom2);
13724: DBMS_SQL.Column_Value(v_CursorID, 31, v_project_id);
13725: DBMS_SQL.Column_Value(v_CursorID, 32, v_task_id);
13726: DBMS_SQL.Column_Value(v_CursorID, 33, v_subinventory);
13727: DBMS_SQL.Column_Value(v_CursorID, 34, v_weight_uom_code);
13728: DBMS_SQL.Column_Value(v_CursorID, 35, v_net_weight);
13729: DBMS_SQL.Column_Value(v_CursorID, 36, v_volume_uom_code);
13730:
13731: DBMS_SQL.Column_Value(v_CursorID, 37, v_volume);

Line 13728: DBMS_SQL.Column_Value(v_CursorID, 35, v_net_weight);

13724: DBMS_SQL.Column_Value(v_CursorID, 31, v_project_id);
13725: DBMS_SQL.Column_Value(v_CursorID, 32, v_task_id);
13726: DBMS_SQL.Column_Value(v_CursorID, 33, v_subinventory);
13727: DBMS_SQL.Column_Value(v_CursorID, 34, v_weight_uom_code);
13728: DBMS_SQL.Column_Value(v_CursorID, 35, v_net_weight);
13729: DBMS_SQL.Column_Value(v_CursorID, 36, v_volume_uom_code);
13730:
13731: DBMS_SQL.Column_Value(v_CursorID, 37, v_volume);
13732: print_debug('Insert into table', l_debug);

Line 13729: DBMS_SQL.Column_Value(v_CursorID, 36, v_volume_uom_code);

13725: DBMS_SQL.Column_Value(v_CursorID, 32, v_task_id);
13726: DBMS_SQL.Column_Value(v_CursorID, 33, v_subinventory);
13727: DBMS_SQL.Column_Value(v_CursorID, 34, v_weight_uom_code);
13728: DBMS_SQL.Column_Value(v_CursorID, 35, v_net_weight);
13729: DBMS_SQL.Column_Value(v_CursorID, 36, v_volume_uom_code);
13730:
13731: DBMS_SQL.Column_Value(v_CursorID, 37, v_volume);
13732: print_debug('Insert into table', l_debug);
13733: release_table(g_rel_current_line).source_line_id := v_line_id;

Line 13731: DBMS_SQL.Column_Value(v_CursorID, 37, v_volume);

13727: DBMS_SQL.Column_Value(v_CursorID, 34, v_weight_uom_code);
13728: DBMS_SQL.Column_Value(v_CursorID, 35, v_net_weight);
13729: DBMS_SQL.Column_Value(v_CursorID, 36, v_volume_uom_code);
13730:
13731: DBMS_SQL.Column_Value(v_CursorID, 37, v_volume);
13732: print_debug('Insert into table', l_debug);
13733: release_table(g_rel_current_line).source_line_id := v_line_id;
13734: release_table(g_rel_current_line).source_header_id := v_header_id;
13735: release_table(g_rel_current_line).organization_id := v_org_id;