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.WSH_PR_CRITERIA dependencies on DBMS_SQL

Line 2444: v_CursorID := DBMS_SQL.Open_Cursor;

2440: WSH_DEBUG_SV.logmsg(l_module_name,'Dynamic SQL-'||g_Unreleased_SQL||g_cond_SQL||g_orderby_SQL);
2441: END IF;
2442:
2443: -- 70. Parse Cursor
2444: v_CursorID := DBMS_SQL.Open_Cursor;
2445: --
2446: IF l_debug_on THEN
2447: WSH_DEBUG_SV.logmsg(l_module_name, 'PARSE CURSOR' );
2448: END IF;

Line 2450: DBMS_SQL.Parse(v_CursorID, g_Unreleased_SQL || g_Cond_SQL|| g_orderby_SQL, DBMS_SQL.v7 );

2446: IF l_debug_on THEN
2447: WSH_DEBUG_SV.logmsg(l_module_name, 'PARSE CURSOR' );
2448: END IF;
2449: --
2450: DBMS_SQL.Parse(v_CursorID, g_Unreleased_SQL || g_Cond_SQL|| g_orderby_SQL, DBMS_SQL.v7 );
2451: --
2452: IF l_debug_on THEN
2453: WSH_DEBUG_SV.logmsg(l_module_name, 'COLUMN DEFINITION FOR CURSOR' );
2454: END IF;

Line 2458: DBMS_SQL.Define_Column(v_CursorID, 1, v_org_id);

2454: END IF;
2455: --
2456: --{
2457: IF p_mode = 'SUMMARY' THEN
2458: DBMS_SQL.Define_Column(v_CursorID, 1, v_org_id);
2459: DBMS_SQL.Define_Column(v_CursorID, 2, v_inventory_item_id);
2460: DBMS_SQL.Define_Column(v_CursorID, 3, v_count);
2461: ELSE --{
2462: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);

Line 2459: DBMS_SQL.Define_Column(v_CursorID, 2, v_inventory_item_id);

2455: --
2456: --{
2457: IF p_mode = 'SUMMARY' THEN
2458: DBMS_SQL.Define_Column(v_CursorID, 1, v_org_id);
2459: DBMS_SQL.Define_Column(v_CursorID, 2, v_inventory_item_id);
2460: DBMS_SQL.Define_Column(v_CursorID, 3, v_count);
2461: ELSE --{
2462: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2463: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);

Line 2460: DBMS_SQL.Define_Column(v_CursorID, 3, v_count);

2456: --{
2457: IF p_mode = 'SUMMARY' THEN
2458: DBMS_SQL.Define_Column(v_CursorID, 1, v_org_id);
2459: DBMS_SQL.Define_Column(v_CursorID, 2, v_inventory_item_id);
2460: DBMS_SQL.Define_Column(v_CursorID, 3, v_count);
2461: ELSE --{
2462: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2463: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2464: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);

Line 2462: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);

2458: DBMS_SQL.Define_Column(v_CursorID, 1, v_org_id);
2459: DBMS_SQL.Define_Column(v_CursorID, 2, v_inventory_item_id);
2460: DBMS_SQL.Define_Column(v_CursorID, 3, v_count);
2461: ELSE --{
2462: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2463: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2464: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2465: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2466: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);

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

2459: DBMS_SQL.Define_Column(v_CursorID, 2, v_inventory_item_id);
2460: DBMS_SQL.Define_Column(v_CursorID, 3, v_count);
2461: ELSE --{
2462: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2463: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2464: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2465: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2466: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2467: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);

Line 2464: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);

2460: DBMS_SQL.Define_Column(v_CursorID, 3, v_count);
2461: ELSE --{
2462: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2463: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2464: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2465: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2466: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2467: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2468: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);

Line 2465: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);

2461: ELSE --{
2462: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2463: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2464: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2465: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2466: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2467: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2468: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2469: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);

Line 2466: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);

2462: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2463: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2464: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2465: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2466: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2467: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2468: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2469: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2470: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);

Line 2467: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);

2463: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2464: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2465: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2466: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2467: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2468: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2469: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2470: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2471: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);

Line 2468: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);

2464: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2465: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2466: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2467: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2468: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2469: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2470: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2471: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2472: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);

Line 2469: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);

2465: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2466: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2467: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2468: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2469: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2470: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2471: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2472: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2473: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);

Line 2470: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);

2466: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2467: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2468: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2469: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2470: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2471: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2472: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2473: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2474: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);

Line 2471: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);

2467: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2468: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2469: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2470: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2471: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2472: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2473: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2474: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2475: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);

Line 2472: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);

2468: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2469: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2470: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2471: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2472: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2473: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2474: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2475: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2476: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.

Line 2473: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);

2469: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2470: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2471: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2472: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2473: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2474: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2475: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2476: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2477: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);

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

2470: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2471: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2472: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2473: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2474: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2475: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2476: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2477: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2478: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);

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

2471: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2472: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2473: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2474: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2475: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2476: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2477: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2478: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2479: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);

Line 2476: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.

2472: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2473: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2474: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2475: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2476: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2477: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2478: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2479: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2480: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);

Line 2477: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);

2473: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2474: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2475: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2476: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2477: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2478: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2479: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2480: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2481: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);

Line 2478: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);

2474: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2475: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2476: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2477: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2478: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2479: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2480: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2481: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2482: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);

Line 2479: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);

2475: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2476: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2477: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2478: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2479: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2480: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2481: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2482: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2483: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);

Line 2480: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);

2476: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2477: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2478: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2479: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2480: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2481: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2482: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2483: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2484: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);

Line 2481: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);

2477: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2478: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2479: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2480: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2481: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2482: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2483: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2484: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2485: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);

Line 2482: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);

2478: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2479: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2480: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2481: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2482: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2483: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2484: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2485: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2486: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);

Line 2483: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);

2479: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2480: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2481: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2482: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2483: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2484: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2485: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2486: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2487: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);

Line 2484: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);

2480: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2481: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2482: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2483: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2484: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2485: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2486: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2487: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2488: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);

Line 2485: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);

2481: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2482: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2483: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2484: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2485: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2486: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2487: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2488: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2489: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);

Line 2486: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);

2482: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2483: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2484: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2485: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2486: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2487: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2488: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2489: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2490: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);

Line 2487: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);

2483: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2484: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2485: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2486: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2487: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2488: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2489: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2490: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2491: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);

Line 2488: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);

2484: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2485: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2486: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2487: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2488: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2489: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2490: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2491: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2492: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);

Line 2489: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);

2485: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2486: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2487: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2488: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2489: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2490: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2491: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2492: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2493: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);

Line 2490: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);

2486: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2487: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2488: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2489: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2490: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2491: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2492: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2493: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);
2494: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);

Line 2491: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);

2487: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2488: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2489: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2490: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2491: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2492: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2493: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);
2494: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);
2495: -- anxsharm, X-dock, customer_id

Line 2492: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);

2488: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2489: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2490: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2491: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2492: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2493: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);
2494: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);
2495: -- anxsharm, X-dock, customer_id
2496: DBMS_SQL.Define_Column(v_CursorID, 34, v_customer_id);

Line 2493: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);

2489: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2490: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2491: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2492: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2493: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);
2494: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);
2495: -- anxsharm, X-dock, customer_id
2496: DBMS_SQL.Define_Column(v_CursorID, 34, v_customer_id);
2497: --}

Line 2494: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);

2490: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2491: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2492: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2493: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);
2494: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);
2495: -- anxsharm, X-dock, customer_id
2496: DBMS_SQL.Define_Column(v_CursorID, 34, v_customer_id);
2497: --}
2498: END IF;

Line 2496: DBMS_SQL.Define_Column(v_CursorID, 34, v_customer_id);

2492: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2493: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);
2494: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);
2495: -- anxsharm, X-dock, customer_id
2496: DBMS_SQL.Define_Column(v_CursorID, 34, v_customer_id);
2497: --}
2498: END IF;
2499: --}
2500:

Line 2509: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_batch_id',p_batch_id);

2505: END IF;
2506: --
2507: --{
2508: IF (g_del_detail_id = -1) THEN
2509: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_batch_id',p_batch_id);
2510: ELSIF (g_del_detail_id <> 0) THEN
2511: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_del_detail_id',g_del_detail_id);
2512: END IF;
2513: IF (g_order_header_id <> 0) THEN

Line 2511: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_del_detail_id',g_del_detail_id);

2507: --{
2508: IF (g_del_detail_id = -1) THEN
2509: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_batch_id',p_batch_id);
2510: ELSIF (g_del_detail_id <> 0) THEN
2511: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_del_detail_id',g_del_detail_id);
2512: END IF;
2513: IF (g_order_header_id <> 0) THEN
2514: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_header_id',g_order_header_id);
2515: END IF;

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

2510: ELSIF (g_del_detail_id <> 0) THEN
2511: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_del_detail_id',g_del_detail_id);
2512: END IF;
2513: IF (g_order_header_id <> 0) THEN
2514: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_header_id',g_order_header_id);
2515: END IF;
2516: IF (g_order_line_id <> 0) THEN
2517: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_line_id',g_order_line_id);
2518: END IF;

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

2513: IF (g_order_header_id <> 0) THEN
2514: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_header_id',g_order_header_id);
2515: END IF;
2516: IF (g_order_line_id <> 0) THEN
2517: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_line_id',g_order_line_id);
2518: END IF;
2519: IF (g_customer_id <> 0) THEN
2520: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_customer_id',g_customer_id);
2521: END IF;

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

2516: IF (g_order_line_id <> 0) THEN
2517: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_line_id',g_order_line_id);
2518: END IF;
2519: IF (g_customer_id <> 0) THEN
2520: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_customer_id',g_customer_id);
2521: END IF;
2522: IF (g_ship_from_loc_id <> -1) THEN
2523: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_from_loc_id',g_ship_from_loc_id);
2524: END IF;

Line 2523: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_from_loc_id',g_ship_from_loc_id);

2519: IF (g_customer_id <> 0) THEN
2520: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_customer_id',g_customer_id);
2521: END IF;
2522: IF (g_ship_from_loc_id <> -1) THEN
2523: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_from_loc_id',g_ship_from_loc_id);
2524: END IF;
2525: IF (g_ship_to_loc_id <> 0) THEN
2526: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_to_loc_id',g_ship_to_loc_id);
2527: END IF;

Line 2526: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_to_loc_id',g_ship_to_loc_id);

2522: IF (g_ship_from_loc_id <> -1) THEN
2523: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_from_loc_id',g_ship_from_loc_id);
2524: END IF;
2525: IF (g_ship_to_loc_id <> 0) THEN
2526: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_to_loc_id',g_ship_to_loc_id);
2527: END IF;
2528: IF (g_order_type_id <> 0) THEN
2529: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_type_id',g_order_type_id);
2530: END IF;

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

2525: IF (g_ship_to_loc_id <> 0) THEN
2526: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_to_loc_id',g_ship_to_loc_id);
2527: END IF;
2528: IF (g_order_type_id <> 0) THEN
2529: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_type_id',g_order_type_id);
2530: END IF;
2531: IF (g_ship_set_number <> 0) THEN
2532: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_set_id',g_ship_set_number);
2533: END IF;

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

2528: IF (g_order_type_id <> 0) THEN
2529: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_type_id',g_order_type_id);
2530: END IF;
2531: IF (g_ship_set_number <> 0) THEN
2532: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_set_id',g_ship_set_number);
2533: END IF;
2534: IF (g_task_id <> 0) THEN
2535: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_task_id',g_task_id);
2536: END IF;

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

2531: IF (g_ship_set_number <> 0) THEN
2532: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_set_id',g_ship_set_number);
2533: END IF;
2534: IF (g_task_id <> 0) THEN
2535: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_task_id',g_task_id);
2536: END IF;
2537: IF (g_project_id <> 0) THEN
2538: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_project_id',g_project_id);
2539: END IF;

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

2534: IF (g_task_id <> 0) THEN
2535: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_task_id',g_task_id);
2536: END IF;
2537: IF (g_project_id <> 0) THEN
2538: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_project_id',g_project_id);
2539: END IF;
2540: IF (p_organization_id IS NOT NULL) THEN
2541: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_org_id',p_organization_id);
2542: END IF;

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

2537: IF (g_project_id <> 0) THEN
2538: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_project_id',g_project_id);
2539: END IF;
2540: IF (p_organization_id IS NOT NULL) THEN
2541: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_org_id',p_organization_id);
2542: END IF;
2543: IF (g_ship_method_code IS NOT NULL) THEN
2544: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_method_code',g_ship_method_code);
2545: END IF;

Line 2544: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_method_code',g_ship_method_code);

2540: IF (p_organization_id IS NOT NULL) THEN
2541: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_org_id',p_organization_id);
2542: END IF;
2543: IF (g_ship_method_code IS NOT NULL) THEN
2544: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_method_code',g_ship_method_code);
2545: END IF;
2546: IF (g_shipment_priority IS NOT NULL) THEN
2547: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_shipment_priority',g_shipment_priority);
2548: END IF;

Line 2547: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_shipment_priority',g_shipment_priority);

2543: IF (g_ship_method_code IS NOT NULL) THEN
2544: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_method_code',g_ship_method_code);
2545: END IF;
2546: IF (g_shipment_priority IS NOT NULL) THEN
2547: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_shipment_priority',g_shipment_priority);
2548: END IF;
2549: IF (g_from_request_date IS NOT NULL) THEN
2550: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_request_date',TO_CHAR(g_from_request_date,'RRRR/MM/DD HH24:MI:SS'));
2551: END IF;

Line 2550: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_request_date',TO_CHAR(g_from_request_date,'RRRR/MM/DD HH24:MI:SS'));

2546: IF (g_shipment_priority IS NOT NULL) THEN
2547: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_shipment_priority',g_shipment_priority);
2548: END IF;
2549: IF (g_from_request_date IS NOT NULL) THEN
2550: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_request_date',TO_CHAR(g_from_request_date,'RRRR/MM/DD HH24:MI:SS'));
2551: END IF;
2552: IF (g_to_request_date IS NOT NULL) THEN
2553: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_to_request_date',TO_CHAR(g_to_request_date,'RRRR/MM/DD HH24:MI:SS'));
2554: END IF;

Line 2553: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_to_request_date',TO_CHAR(g_to_request_date,'RRRR/MM/DD HH24:MI:SS'));

2549: IF (g_from_request_date IS NOT NULL) THEN
2550: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_request_date',TO_CHAR(g_from_request_date,'RRRR/MM/DD HH24:MI:SS'));
2551: END IF;
2552: IF (g_to_request_date IS NOT NULL) THEN
2553: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_to_request_date',TO_CHAR(g_to_request_date,'RRRR/MM/DD HH24:MI:SS'));
2554: END IF;
2555: IF (g_from_sched_ship_date IS NOT NULL) THEN
2556: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_sched_ship_date',TO_CHAR(g_from_sched_ship_date,'RRRR/MM/DD HH24:MI:SS'));
2557: END IF;

Line 2556: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_sched_ship_date',TO_CHAR(g_from_sched_ship_date,'RRRR/MM/DD HH24:MI:SS'));

2552: IF (g_to_request_date IS NOT NULL) THEN
2553: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_to_request_date',TO_CHAR(g_to_request_date,'RRRR/MM/DD HH24:MI:SS'));
2554: END IF;
2555: IF (g_from_sched_ship_date IS NOT NULL) THEN
2556: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_sched_ship_date',TO_CHAR(g_from_sched_ship_date,'RRRR/MM/DD HH24:MI:SS'));
2557: END IF;
2558: IF (g_to_sched_ship_date IS NOT NULL) THEN
2559: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_to_sched_ship_date',TO_CHAR(g_to_sched_ship_date,'RRRR/MM/DD HH24:MI:SS'));
2560: END IF;

Line 2559: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_to_sched_ship_date',TO_CHAR(g_to_sched_ship_date,'RRRR/MM/DD HH24:MI:SS'));

2555: IF (g_from_sched_ship_date IS NOT NULL) THEN
2556: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_sched_ship_date',TO_CHAR(g_from_sched_ship_date,'RRRR/MM/DD HH24:MI:SS'));
2557: END IF;
2558: IF (g_to_sched_ship_date IS NOT NULL) THEN
2559: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_to_sched_ship_date',TO_CHAR(g_to_sched_ship_date,'RRRR/MM/DD HH24:MI:SS'));
2560: END IF;
2561: --}
2562:
2563: --{

Line 2566: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',p_inv_item_id);

2562:
2563: --{
2564: IF p_mode = 'WORKER' THEN
2565: IF (p_inv_item_id IS NOT NULL) THEN
2566: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',p_inv_item_id);
2567: END IF;
2568: ELSE
2569: IF (g_inventory_item_id <> 0) THEN
2570: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',g_inventory_item_id);

Line 2570: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',g_inventory_item_id);

2566: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',p_inv_item_id);
2567: END IF;
2568: ELSE
2569: IF (g_inventory_item_id <> 0) THEN
2570: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',g_inventory_item_id);
2571: END IF;
2572: END IF;
2573: --}
2574:

Line 2577: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_include_planned_lines',g_include_planned_lines);

2573: --}
2574:
2575: --{
2576: IF (g_include_planned_lines <> 'N') THEN
2577: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_include_planned_lines',g_include_planned_lines);
2578: END IF;
2579: IF (g_trip_id <> 0) THEN
2580: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_trip_id',g_trip_id);
2581: IF (g_trip_stop_id <> 0) THEN

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

2576: IF (g_include_planned_lines <> 'N') THEN
2577: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_include_planned_lines',g_include_planned_lines);
2578: END IF;
2579: IF (g_trip_id <> 0) THEN
2580: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_trip_id',g_trip_id);
2581: IF (g_trip_stop_id <> 0) THEN
2582: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_trip_stop_id', g_trip_stop_id);
2583: END IF;
2584: END IF;

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

2578: END IF;
2579: IF (g_trip_id <> 0) THEN
2580: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_trip_id',g_trip_id);
2581: IF (g_trip_stop_id <> 0) THEN
2582: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_trip_stop_id', g_trip_stop_id);
2583: END IF;
2584: END IF;
2585: IF (g_delivery_id <> 0) THEN
2586: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_delivery_id',g_delivery_id);

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

2582: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_trip_stop_id', g_trip_stop_id);
2583: END IF;
2584: END IF;
2585: IF (g_delivery_id <> 0) THEN
2586: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_delivery_id',g_delivery_id);
2587: END IF;
2588: IF (g_existing_rsvs_only_flag = 'Y') THEN
2589: IF (g_from_subinventory IS NOT NULL) THEN
2590: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_subinventory_code',g_from_subinventory);

Line 2590: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_subinventory_code',g_from_subinventory);

2586: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_delivery_id',g_delivery_id);
2587: END IF;
2588: IF (g_existing_rsvs_only_flag = 'Y') THEN
2589: IF (g_from_subinventory IS NOT NULL) THEN
2590: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_subinventory_code',g_from_subinventory);
2591: END IF;
2592: IF (g_from_locator IS NOT NULL) THEN
2593: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_locator_id',g_from_locator);
2594: END IF;

Line 2593: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_locator_id',g_from_locator);

2589: IF (g_from_subinventory IS NOT NULL) THEN
2590: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_subinventory_code',g_from_subinventory);
2591: END IF;
2592: IF (g_from_locator IS NOT NULL) THEN
2593: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_locator_id',g_from_locator);
2594: END IF;
2595: END IF;
2596: IF (g_categorysetid <> 0) THEN
2597: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categorysetid',g_categorysetid);

Line 2597: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categorysetid',g_categorysetid);

2593: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_locator_id',g_from_locator);
2594: END IF;
2595: END IF;
2596: IF (g_categorysetid <> 0) THEN
2597: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categorysetid',g_categorysetid);
2598: IF (g_categoryid <> 0) THEN
2599: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categoryid',g_categoryid);
2600: END IF;
2601: END IF;

Line 2599: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categoryid',g_categoryid);

2595: END IF;
2596: IF (g_categorysetid <> 0) THEN
2597: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categorysetid',g_categorysetid);
2598: IF (g_categoryid <> 0) THEN
2599: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categoryid',g_categoryid);
2600: END IF;
2601: END IF;
2602: IF (g_regionid <> 0) THEN
2603: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_regionid',g_regionid);

Line 2603: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_regionid',g_regionid);

2599: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categoryid',g_categoryid);
2600: END IF;
2601: END IF;
2602: IF (g_regionid <> 0) THEN
2603: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_regionid',g_regionid);
2604: END IF;
2605: IF (g_zoneid <> 0) THEN
2606: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_zoneid',g_zoneid);
2607: END IF;

Line 2606: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_zoneid',g_zoneid);

2602: IF (g_regionid <> 0) THEN
2603: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_regionid',g_regionid);
2604: END IF;
2605: IF (g_zoneid <> 0) THEN
2606: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_zoneid',g_zoneid);
2607: END IF;
2608: IF (g_RelSubInventory IS NOT NULL) THEN
2609: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_relsubinv',g_relsubinventory);
2610: END IF;

Line 2609: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_relsubinv',g_relsubinventory);

2605: IF (g_zoneid <> 0) THEN
2606: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_zoneid',g_zoneid);
2607: END IF;
2608: IF (g_RelSubInventory IS NOT NULL) THEN
2609: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_relsubinv',g_relsubinventory);
2610: END IF;
2611: --}
2612:
2613: -- 90. Execute the cursor

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

2615: IF l_debug_on THEN
2616: WSH_DEBUG_SV.logmsg(l_module_name, 'EXECUTING CURSOR' );
2617: END IF;
2618: --
2619: v_ignore := DBMS_SQL.Execute(v_CursorID);
2620:
2621:
2622: -- 100. Fetching records for SUMMARY mode and inserting worker records
2623: --{

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

2623: --{
2624: IF p_mode = 'SUMMARY' THEN
2625: l_count := 0;
2626: LOOP
2627: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
2628: DBMS_SQL.Close_Cursor(v_cursorID);
2629: v_cursorID := NULL;
2630: EXIT;
2631: ELSE

Line 2628: DBMS_SQL.Close_Cursor(v_cursorID);

2624: IF p_mode = 'SUMMARY' THEN
2625: l_count := 0;
2626: LOOP
2627: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
2628: DBMS_SQL.Close_Cursor(v_cursorID);
2629: v_cursorID := NULL;
2630: EXIT;
2631: ELSE
2632: DBMS_SQL.Column_Value(v_CursorID, 1, v_org_id);

Line 2632: DBMS_SQL.Column_Value(v_CursorID, 1, v_org_id);

2628: DBMS_SQL.Close_Cursor(v_cursorID);
2629: v_cursorID := NULL;
2630: EXIT;
2631: ELSE
2632: DBMS_SQL.Column_Value(v_CursorID, 1, v_org_id);
2633: DBMS_SQL.Column_Value(v_CursorID, 2, v_inventory_item_id);
2634: DBMS_SQL.Column_Value(v_CursorID, 3, v_count);
2635:
2636: INSERT INTO WSH_PR_WORKERS (

Line 2633: DBMS_SQL.Column_Value(v_CursorID, 2, v_inventory_item_id);

2629: v_cursorID := NULL;
2630: EXIT;
2631: ELSE
2632: DBMS_SQL.Column_Value(v_CursorID, 1, v_org_id);
2633: DBMS_SQL.Column_Value(v_CursorID, 2, v_inventory_item_id);
2634: DBMS_SQL.Column_Value(v_CursorID, 3, v_count);
2635:
2636: INSERT INTO WSH_PR_WORKERS (
2637: batch_id,

Line 2634: DBMS_SQL.Column_Value(v_CursorID, 3, v_count);

2630: EXIT;
2631: ELSE
2632: DBMS_SQL.Column_Value(v_CursorID, 1, v_org_id);
2633: DBMS_SQL.Column_Value(v_CursorID, 2, v_inventory_item_id);
2634: DBMS_SQL.Column_Value(v_CursorID, 3, v_count);
2635:
2636: INSERT INTO WSH_PR_WORKERS (
2637: batch_id,
2638: type,

Line 2684: IF DBMS_SQL.IS_Open(v_cursorID) THEN

2680:
2681: EXCEPTION
2682: --
2683: WHEN OTHERS THEN
2684: IF DBMS_SQL.IS_Open(v_cursorID) THEN
2685: DBMS_SQL.Close_Cursor(v_cursorID);
2686: END IF;
2687: --
2688: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2685: DBMS_SQL.Close_Cursor(v_cursorID);

2681: EXCEPTION
2682: --
2683: WHEN OTHERS THEN
2684: IF DBMS_SQL.IS_Open(v_cursorID) THEN
2685: DBMS_SQL.Close_Cursor(v_cursorID);
2686: END IF;
2687: --
2688: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2689: --

Line 2872: l_dummy := DBMS_SQL.Fetch_Rows(v_cursorID);

2868:
2869: LOOP
2870: --{
2871: IF v_cursorID IS NOT NULL THEN
2872: l_dummy := DBMS_SQL.Fetch_Rows(v_cursorID);
2873: END IF;
2874: IF ( v_cursorID IS NULL ) OR ( l_dummy = 0 ) THEN
2875: -- Either all lines are fetched for a worker record or a New Organization
2876: --{

Line 2894: DBMS_SQL.Close_Cursor(v_CursorID);

2890: IF c_work_cursorID%ISOPEN THEN
2891: CLOSE c_work_cursorID;
2892: END IF;
2893: IF v_CursorID IS NOT NULL THEN
2894: DBMS_SQL.Close_Cursor(v_CursorID);
2895: v_CursorID := NULL;
2896: END IF;
2897: x_done_flag := FND_API.G_TRUE;
2898: EXIT;

Line 2985: IF DBMS_SQL.Is_Open(v_CursorID) THEN

2981: IF l_debug_on THEN
2982: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in updating worker records as processed');
2983: WSH_DEBUG_SV.pop(l_module_name);
2984: END IF;
2985: IF DBMS_SQL.Is_Open(v_CursorID) THEN
2986: DBMS_SQL.Close_Cursor(v_CursorID);
2987: END IF;
2988: IF c_work_cursorID%ISOPEN THEN
2989: CLOSE c_work_cursorID;

Line 2986: DBMS_SQL.Close_Cursor(v_CursorID);

2982: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in updating worker records as processed');
2983: WSH_DEBUG_SV.pop(l_module_name);
2984: END IF;
2985: IF DBMS_SQL.Is_Open(v_CursorID) THEN
2986: DBMS_SQL.Close_Cursor(v_CursorID);
2987: END IF;
2988: IF c_work_cursorID%ISOPEN THEN
2989: CLOSE c_work_cursorID;
2990: END IF;

Line 3023: IF DBMS_SQL.Is_Open(v_CursorID) THEN

3019: IF l_debug_on THEN
3020: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in Init_Cursor');
3021: WSH_DEBUG_SV.pop(l_module_name);
3022: END IF;
3023: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3024: DBMS_SQL.Close_Cursor(v_CursorID);
3025: END IF;
3026: IF c_work_cursorID%ISOPEN THEN
3027: CLOSE c_work_cursorID;

Line 3024: DBMS_SQL.Close_Cursor(v_CursorID);

3020: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in Init_Cursor');
3021: WSH_DEBUG_SV.pop(l_module_name);
3022: END IF;
3023: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3024: DBMS_SQL.Close_Cursor(v_CursorID);
3025: END IF;
3026: IF c_work_cursorID%ISOPEN THEN
3027: CLOSE c_work_cursorID;
3028: END IF;

Line 3038: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',v_pr_inv_item_id);

3034: -- Bind the new Item and execute the cursor again
3035: IF l_debug_on THEN
3036: WSH_DEBUG_SV.logmsg(l_module_name, 'Binding new Item '||v_pr_inv_item_id||' and Executing Cursor' );
3037: END IF;
3038: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',v_pr_inv_item_id);
3039: l_dummy := DBMS_SQL.Execute(v_CursorID);
3040: v_total_rec_fetched := 0;
3041: END IF;
3042: --}

Line 3039: l_dummy := DBMS_SQL.Execute(v_CursorID);

3035: IF l_debug_on THEN
3036: WSH_DEBUG_SV.logmsg(l_module_name, 'Binding new Item '||v_pr_inv_item_id||' and Executing Cursor' );
3037: END IF;
3038: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',v_pr_inv_item_id);
3039: l_dummy := DBMS_SQL.Execute(v_CursorID);
3040: v_total_rec_fetched := 0;
3041: END IF;
3042: --}
3043:

Line 3051: DBMS_SQL.Column_Value(v_CursorID, 1, v_line_id);

3047: IF l_debug_on THEN
3048: WSH_DEBUG_SV.logmsg(l_module_name, 'MAP OUTPUT COLUMNS' );
3049: END IF;
3050:
3051: DBMS_SQL.Column_Value(v_CursorID, 1, v_line_id);
3052: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
3053: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3054: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3055: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);

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

3048: WSH_DEBUG_SV.logmsg(l_module_name, 'MAP OUTPUT COLUMNS' );
3049: END IF;
3050:
3051: DBMS_SQL.Column_Value(v_CursorID, 1, v_line_id);
3052: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
3053: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3054: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3055: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3056: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);

Line 3053: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);

3049: END IF;
3050:
3051: DBMS_SQL.Column_Value(v_CursorID, 1, v_line_id);
3052: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
3053: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3054: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3055: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3056: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3057: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);

Line 3054: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);

3050:
3051: DBMS_SQL.Column_Value(v_CursorID, 1, v_line_id);
3052: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
3053: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3054: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3055: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3056: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3057: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3058: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);

Line 3055: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);

3051: DBMS_SQL.Column_Value(v_CursorID, 1, v_line_id);
3052: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
3053: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3054: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3055: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3056: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3057: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3058: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3059: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);

Line 3056: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);

3052: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
3053: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3054: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3055: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3056: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3057: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3058: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3059: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3060: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);

Line 3057: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);

3053: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3054: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3055: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3056: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3057: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3058: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3059: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3060: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3061: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);

Line 3058: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);

3054: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3055: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3056: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3057: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3058: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3059: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3060: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3061: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3062: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);

Line 3059: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);

3055: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3056: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3057: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3058: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3059: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3060: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3061: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3062: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3063: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);

Line 3060: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);

3056: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3057: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3058: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3059: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3060: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3061: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3062: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3063: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3064: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);

Line 3061: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);

3057: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3058: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3059: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3060: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3061: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3062: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3063: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3064: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3065: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);

Line 3062: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);

3058: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3059: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3060: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3061: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3062: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3063: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3064: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3065: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3066: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);

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

3059: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3060: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3061: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3062: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3063: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3064: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3065: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3066: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3067: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);

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

3060: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3061: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3062: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3063: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3064: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3065: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3066: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3067: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3068: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);

Line 3065: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);

3061: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3062: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3063: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3064: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3065: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3066: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3067: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3068: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3069: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);

Line 3066: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);

3062: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3063: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3064: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3065: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3066: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3067: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3068: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3069: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3070: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);

Line 3067: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);

3063: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3064: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3065: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3066: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3067: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3068: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3069: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3070: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3071: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);

Line 3068: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);

3064: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3065: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3066: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3067: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3068: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3069: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3070: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3071: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3072: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);

Line 3069: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);

3065: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3066: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3067: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3068: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3069: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3070: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3071: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3072: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3073: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);

Line 3070: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);

3066: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3067: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3068: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3069: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3070: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3071: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3072: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3073: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3074: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);

Line 3071: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);

3067: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3068: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3069: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3070: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3071: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3072: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3073: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3074: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3075: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);

Line 3072: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);

3068: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3069: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3070: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3071: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3072: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3073: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3074: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3075: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3076: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);

Line 3073: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);

3069: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3070: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3071: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3072: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3073: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3074: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3075: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3076: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3077: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);

Line 3074: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);

3070: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3071: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3072: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3073: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3074: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3075: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3076: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3077: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3078: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);

Line 3075: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);

3071: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3072: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3073: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3074: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3075: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3076: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3077: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3078: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3079: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);

Line 3076: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);

3072: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3073: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3074: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3075: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3076: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3077: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3078: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3079: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3080: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);

Line 3077: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);

3073: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3074: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3075: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3076: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3077: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3078: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3079: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3080: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3081: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);

Line 3078: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);

3074: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3075: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3076: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3077: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3078: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3079: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3080: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3081: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3082: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);

Line 3079: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);

3075: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3076: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3077: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3078: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3079: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3080: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3081: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3082: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);
3083: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);

Line 3080: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);

3076: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3077: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3078: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3079: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3080: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3081: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3082: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);
3083: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);
3084: -- anxsharm, X-dock, customer_id

Line 3081: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);

3077: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3078: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3079: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3080: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3081: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3082: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);
3083: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);
3084: -- anxsharm, X-dock, customer_id
3085: DBMS_SQL.Column_Value(v_CursorID, 34, v_customer_id);

Line 3082: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);

3078: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3079: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3080: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3081: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3082: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);
3083: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);
3084: -- anxsharm, X-dock, customer_id
3085: DBMS_SQL.Column_Value(v_CursorID, 34, v_customer_id);
3086:

Line 3083: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);

3079: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3080: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3081: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3082: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);
3083: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);
3084: -- anxsharm, X-dock, customer_id
3085: DBMS_SQL.Column_Value(v_CursorID, 34, v_customer_id);
3086:
3087: IF l_debug_on THEN

Line 3085: DBMS_SQL.Column_Value(v_CursorID, 34, v_customer_id);

3081: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3082: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);
3083: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);
3084: -- anxsharm, X-dock, customer_id
3085: DBMS_SQL.Column_Value(v_CursorID, 34, v_customer_id);
3086:
3087: IF l_debug_on THEN
3088: WSH_DEBUG_SV.log(l_module_name, 'CURRENT LINE IS', TO_CHAR(G_REL_CURRENT_LINE));
3089: WSH_DEBUG_SV.log(l_module_name, 'Delivery detail ID', v_delivery_detail_id);

Line 3101: IF DBMS_SQL.Is_Open(v_CursorID) THEN

3097: IF l_debug_on THEN
3098: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN INSERT_RL_ROW');
3099: --WSH_DEBUG_SV.pop(l_module_name);
3100: END IF;
3101: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3102: DBMS_SQL.Close_Cursor(v_CursorID);
3103: END IF;
3104: IF c_work_cursorID%ISOPEN THEN
3105: CLOSE c_work_cursorID;

Line 3102: DBMS_SQL.Close_Cursor(v_CursorID);

3098: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN INSERT_RL_ROW');
3099: --WSH_DEBUG_SV.pop(l_module_name);
3100: END IF;
3101: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3102: DBMS_SQL.Close_Cursor(v_CursorID);
3103: END IF;
3104: IF c_work_cursorID%ISOPEN THEN
3105: CLOSE c_work_cursorID;
3106: END IF;

Line 3275: IF DBMS_SQL.Is_Open(v_CursorID) THEN

3271: IF l_debug_on THEN
3272: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3273: END IF;
3274: --
3275: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3276: DBMS_SQL.Close_Cursor(v_CursorID);
3277: END IF;
3278: IF c_work_cursorID%ISOPEN THEN
3279: CLOSE c_work_cursorID;

Line 3276: DBMS_SQL.Close_Cursor(v_CursorID);

3272: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3273: END IF;
3274: --
3275: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3276: DBMS_SQL.Close_Cursor(v_CursorID);
3277: END IF;
3278: IF c_work_cursorID%ISOPEN THEN
3279: CLOSE c_work_cursorID;
3280: END IF;