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 2538: v_CursorID := DBMS_SQL.Open_Cursor;

2534: WSH_DEBUG_SV.logmsg(l_module_name,'Dynamic SQL-'||g_Unreleased_SQL||g_cond_SQL||g_orderby_SQL);
2535: END IF;
2536:
2537: -- 70. Parse Cursor
2538: v_CursorID := DBMS_SQL.Open_Cursor;
2539: --
2540: IF l_debug_on THEN
2541: WSH_DEBUG_SV.logmsg(l_module_name, 'PARSE CURSOR' );
2542: END IF;

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

2540: IF l_debug_on THEN
2541: WSH_DEBUG_SV.logmsg(l_module_name, 'PARSE CURSOR' );
2542: END IF;
2543: --
2544: DBMS_SQL.Parse(v_CursorID, g_Unreleased_SQL || g_Cond_SQL|| g_orderby_SQL, DBMS_SQL.v7 );
2545: --
2546: IF l_debug_on THEN
2547: WSH_DEBUG_SV.logmsg(l_module_name, 'COLUMN DEFINITION FOR CURSOR' );
2548: END IF;

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

2548: END IF;
2549: --
2550: --{
2551: IF p_mode = 'SUMMARY' THEN
2552: DBMS_SQL.Define_Column(v_CursorID, 1, v_org_id);
2553: DBMS_SQL.Define_Column(v_CursorID, 2, v_inventory_item_id);
2554: DBMS_SQL.Define_Column(v_CursorID, 3, v_count);
2555: ELSE --{
2556: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);

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

2549: --
2550: --{
2551: IF p_mode = 'SUMMARY' THEN
2552: DBMS_SQL.Define_Column(v_CursorID, 1, v_org_id);
2553: DBMS_SQL.Define_Column(v_CursorID, 2, v_inventory_item_id);
2554: DBMS_SQL.Define_Column(v_CursorID, 3, v_count);
2555: ELSE --{
2556: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2557: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);

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

2550: --{
2551: IF p_mode = 'SUMMARY' THEN
2552: DBMS_SQL.Define_Column(v_CursorID, 1, v_org_id);
2553: DBMS_SQL.Define_Column(v_CursorID, 2, v_inventory_item_id);
2554: DBMS_SQL.Define_Column(v_CursorID, 3, v_count);
2555: ELSE --{
2556: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2557: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2558: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);

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

2552: DBMS_SQL.Define_Column(v_CursorID, 1, v_org_id);
2553: DBMS_SQL.Define_Column(v_CursorID, 2, v_inventory_item_id);
2554: DBMS_SQL.Define_Column(v_CursorID, 3, v_count);
2555: ELSE --{
2556: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2557: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2558: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2559: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2560: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);

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

2553: DBMS_SQL.Define_Column(v_CursorID, 2, v_inventory_item_id);
2554: DBMS_SQL.Define_Column(v_CursorID, 3, v_count);
2555: ELSE --{
2556: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2557: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2558: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2559: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2560: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2561: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);

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

2554: DBMS_SQL.Define_Column(v_CursorID, 3, v_count);
2555: ELSE --{
2556: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2557: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2558: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2559: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2560: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2561: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2562: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);

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

2555: ELSE --{
2556: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2557: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2558: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2559: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2560: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2561: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2562: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2563: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);

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

2556: DBMS_SQL.Define_Column(v_CursorID, 1, v_line_id);
2557: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2558: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2559: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2560: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2561: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2562: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2563: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2564: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);

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

2557: DBMS_SQL.Define_Column(v_CursorID, 2, v_header_id);
2558: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2559: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2560: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2561: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2562: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2563: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2564: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2565: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);

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

2558: DBMS_SQL.Define_Column(v_CursorID, 3, v_org_id);
2559: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2560: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2561: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2562: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2563: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2564: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2565: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2566: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);

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

2559: DBMS_SQL.Define_Column(v_CursorID, 4, v_inventory_item_id);
2560: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2561: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2562: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2563: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2564: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2565: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2566: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2567: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);

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

2560: DBMS_SQL.Define_Column(v_CursorID, 5, v_move_order_line_id);
2561: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2562: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2563: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2564: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2565: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2566: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2567: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2568: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);

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

2561: DBMS_SQL.Define_Column(v_CursorID, 6, v_delivery_detail_id);
2562: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2563: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2564: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2565: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2566: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2567: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2568: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2569: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);

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

2562: DBMS_SQL.Define_Column(v_CursorID, 7, v_ship_model_complete_flag,1);
2563: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2564: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2565: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2566: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2567: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2568: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2569: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2570: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.

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

2563: DBMS_SQL.Define_Column(v_CursorID, 8, v_top_model_line_id);
2564: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2565: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2566: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2567: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2568: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2569: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2570: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2571: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);

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

2564: DBMS_SQL.Define_Column(v_CursorID, 9, v_ship_from_location_id);
2565: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2566: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2567: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2568: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2569: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2570: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2571: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2572: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);

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

2565: DBMS_SQL.Define_Column(v_CursorID, 10, v_ship_method_code,30);
2566: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2567: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2568: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2569: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2570: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2571: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2572: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2573: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);

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

2566: DBMS_SQL.Define_Column(v_CursorID, 11, v_shipment_priority,30);
2567: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2568: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2569: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2570: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2571: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2572: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2573: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2574: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);

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

2567: DBMS_SQL.Define_Column(v_CursorID, 12, v_date_scheduled);
2568: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2569: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2570: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2571: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2572: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2573: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2574: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2575: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);

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

2568: DBMS_SQL.Define_Column(v_CursorID, 13, v_requested_quantity);
2569: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2570: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2571: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2572: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2573: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2574: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2575: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2576: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);

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

2569: DBMS_SQL.Define_Column(v_CursorID, 14, v_requested_quantity_uom,3);
2570: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2571: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2572: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2573: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2574: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2575: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2576: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2577: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);

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

2570: DBMS_SQL.Define_Column(v_CursorID, 15, v_preferred_grade, 150); -- HW OPMCONV.
2571: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2572: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2573: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2574: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2575: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2576: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2577: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2578: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);

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

2571: DBMS_SQL.Define_Column(v_CursorID, 16, v_requested_quantity2);
2572: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2573: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2574: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2575: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2576: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2577: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2578: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2579: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);

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

2572: DBMS_SQL.Define_Column(v_CursorID, 17, v_requested_quantity_uom2, 3);
2573: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2574: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2575: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2576: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2577: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2578: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2579: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2580: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);

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

2573: DBMS_SQL.Define_Column(v_CursorID, 18, v_project_id);
2574: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2575: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2576: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2577: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2578: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2579: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2580: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2581: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);

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

2574: DBMS_SQL.Define_Column(v_CursorID, 19, v_task_id);
2575: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2576: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2577: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2578: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2579: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2580: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2581: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2582: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);

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

2575: DBMS_SQL.Define_Column(v_CursorID, 20, v_from_sub,10);
2576: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2577: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2578: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2579: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2580: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2581: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2582: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2583: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);

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

2576: DBMS_SQL.Define_Column(v_CursorID, 21, v_to_sub,10);
2577: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2578: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2579: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2580: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2581: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2582: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2583: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2584: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);

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

2577: DBMS_SQL.Define_Column(v_CursorID, 22, v_released_status,1);
2578: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2579: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2580: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2581: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2582: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2583: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2584: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2585: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);

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

2578: DBMS_SQL.Define_Column(v_CursorID, 23, v_ship_set_id);
2579: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2580: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2581: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2582: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2583: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2584: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2585: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2586: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);

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

2579: DBMS_SQL.Define_Column(v_CursorID, 24, v_source_code,30);
2580: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2581: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2582: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2583: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2584: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2585: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2586: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2587: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);

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

2580: DBMS_SQL.Define_Column(v_CursorID, 25, v_source_header_number,150);
2581: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2582: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2583: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2584: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2585: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2586: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2587: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);
2588: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);

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

2581: DBMS_SQL.Define_Column(v_CursorID, 26, v_planned_departure_date);
2582: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2583: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2584: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2585: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2586: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2587: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);
2588: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);
2589: -- anxsharm, X-dock, customer_id

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

2582: DBMS_SQL.Define_Column(v_CursorID, 27, v_delivery_id);
2583: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2584: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2585: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2586: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2587: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);
2588: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);
2589: -- anxsharm, X-dock, customer_id
2590: DBMS_SQL.Define_Column(v_CursorID, 34, v_customer_id);

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

2583: DBMS_SQL.Define_Column(v_CursorID, 28, v_unit_number, 30);
2584: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2585: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2586: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2587: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);
2588: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);
2589: -- anxsharm, X-dock, customer_id
2590: DBMS_SQL.Define_Column(v_CursorID, 34, v_customer_id);
2591: -- Standalone project Changes start

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

2584: DBMS_SQL.Define_Column(v_CursorID, 29, v_source_doc_type);
2585: DBMS_SQL.Define_Column(v_CursorID, 30, v_reservable_type,1);
2586: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2587: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);
2588: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);
2589: -- anxsharm, X-dock, customer_id
2590: DBMS_SQL.Define_Column(v_CursorID, 34, v_customer_id);
2591: -- Standalone project Changes start
2592: DBMS_SQL.Define_Column(v_CursorID, 35, v_revision, 3);

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

2586: DBMS_SQL.Define_Column(v_CursorID, 31, v_last_update_date);
2587: DBMS_SQL.Define_Column(v_CursorID, 32, v_demand_source_header_id);
2588: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);
2589: -- anxsharm, X-dock, customer_id
2590: DBMS_SQL.Define_Column(v_CursorID, 34, v_customer_id);
2591: -- Standalone project Changes start
2592: DBMS_SQL.Define_Column(v_CursorID, 35, v_revision, 3);
2593: DBMS_SQL.Define_Column(v_CursorID, 36, v_from_locator);
2594: DBMS_SQL.Define_Column(v_CursorID, 37, v_lot_number, 32);

Line 2592: DBMS_SQL.Define_Column(v_CursorID, 35, v_revision, 3);

2588: DBMS_SQL.Define_Column(v_CursorID, 33, v_invoice_value);
2589: -- anxsharm, X-dock, customer_id
2590: DBMS_SQL.Define_Column(v_CursorID, 34, v_customer_id);
2591: -- Standalone project Changes start
2592: DBMS_SQL.Define_Column(v_CursorID, 35, v_revision, 3);
2593: DBMS_SQL.Define_Column(v_CursorID, 36, v_from_locator);
2594: DBMS_SQL.Define_Column(v_CursorID, 37, v_lot_number, 32);
2595: -- Standalone project Changes end
2596: DBMS_SQL.Define_Column(v_CursorID, 38, v_client_id); -- LSP PROJECT

Line 2593: DBMS_SQL.Define_Column(v_CursorID, 36, v_from_locator);

2589: -- anxsharm, X-dock, customer_id
2590: DBMS_SQL.Define_Column(v_CursorID, 34, v_customer_id);
2591: -- Standalone project Changes start
2592: DBMS_SQL.Define_Column(v_CursorID, 35, v_revision, 3);
2593: DBMS_SQL.Define_Column(v_CursorID, 36, v_from_locator);
2594: DBMS_SQL.Define_Column(v_CursorID, 37, v_lot_number, 32);
2595: -- Standalone project Changes end
2596: DBMS_SQL.Define_Column(v_CursorID, 38, v_client_id); -- LSP PROJECT
2597: --}

Line 2594: DBMS_SQL.Define_Column(v_CursorID, 37, v_lot_number, 32);

2590: DBMS_SQL.Define_Column(v_CursorID, 34, v_customer_id);
2591: -- Standalone project Changes start
2592: DBMS_SQL.Define_Column(v_CursorID, 35, v_revision, 3);
2593: DBMS_SQL.Define_Column(v_CursorID, 36, v_from_locator);
2594: DBMS_SQL.Define_Column(v_CursorID, 37, v_lot_number, 32);
2595: -- Standalone project Changes end
2596: DBMS_SQL.Define_Column(v_CursorID, 38, v_client_id); -- LSP PROJECT
2597: --}
2598: END IF;

Line 2596: DBMS_SQL.Define_Column(v_CursorID, 38, v_client_id); -- LSP PROJECT

2592: DBMS_SQL.Define_Column(v_CursorID, 35, v_revision, 3);
2593: DBMS_SQL.Define_Column(v_CursorID, 36, v_from_locator);
2594: DBMS_SQL.Define_Column(v_CursorID, 37, v_lot_number, 32);
2595: -- Standalone project Changes end
2596: DBMS_SQL.Define_Column(v_CursorID, 38, v_client_id); -- LSP PROJECT
2597: --}
2598: END IF;
2599: --}
2600:

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

2606: --
2607: --{
2608: -- bug # 8915460 : Added g_del_detail_id = - 2 condition.
2609: IF (g_del_detail_id = -1 OR g_del_detail_id = -2) THEN
2610: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_batch_id',p_batch_id);
2611: ELSIF (g_del_detail_id <> 0) THEN
2612: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_del_detail_id',g_del_detail_id);
2613: END IF;
2614: IF (g_order_header_id <> 0) THEN

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

2608: -- bug # 8915460 : Added g_del_detail_id = - 2 condition.
2609: IF (g_del_detail_id = -1 OR g_del_detail_id = -2) THEN
2610: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_batch_id',p_batch_id);
2611: ELSIF (g_del_detail_id <> 0) THEN
2612: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_del_detail_id',g_del_detail_id);
2613: END IF;
2614: IF (g_order_header_id <> 0) THEN
2615: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_header_id',g_order_header_id);
2616: END IF;

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

2611: ELSIF (g_del_detail_id <> 0) THEN
2612: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_del_detail_id',g_del_detail_id);
2613: END IF;
2614: IF (g_order_header_id <> 0) THEN
2615: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_header_id',g_order_header_id);
2616: END IF;
2617: IF (g_order_line_id <> 0) THEN
2618: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_line_id',g_order_line_id);
2619: END IF;

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

2614: IF (g_order_header_id <> 0) THEN
2615: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_header_id',g_order_header_id);
2616: END IF;
2617: IF (g_order_line_id <> 0) THEN
2618: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_line_id',g_order_line_id);
2619: END IF;
2620: IF (g_customer_id <> 0) THEN
2621: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_customer_id',g_customer_id);
2622: END IF;

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

2617: IF (g_order_line_id <> 0) THEN
2618: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_line_id',g_order_line_id);
2619: END IF;
2620: IF (g_customer_id <> 0) THEN
2621: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_customer_id',g_customer_id);
2622: END IF;
2623: -- LSP PROJECT
2624: IF (g_CLIENT_id <> 0) THEN
2625: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_client_id',g_client_id);

Line 2625: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_client_id',g_client_id);

2621: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_customer_id',g_customer_id);
2622: END IF;
2623: -- LSP PROJECT
2624: IF (g_CLIENT_id <> 0) THEN
2625: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_client_id',g_client_id);
2626: END IF;
2627: -- LSP PROJECT
2628: IF (g_ship_from_loc_id <> -1) THEN
2629: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_from_loc_id',g_ship_from_loc_id);

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

2625: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_client_id',g_client_id);
2626: END IF;
2627: -- LSP PROJECT
2628: IF (g_ship_from_loc_id <> -1) THEN
2629: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_from_loc_id',g_ship_from_loc_id);
2630: END IF;
2631: IF (g_ship_to_loc_id <> 0) THEN
2632: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_to_loc_id',g_ship_to_loc_id);
2633: END IF;

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

2628: IF (g_ship_from_loc_id <> -1) THEN
2629: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_from_loc_id',g_ship_from_loc_id);
2630: END IF;
2631: IF (g_ship_to_loc_id <> 0) THEN
2632: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_to_loc_id',g_ship_to_loc_id);
2633: END IF;
2634: IF (g_order_type_id <> 0) THEN
2635: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_type_id',g_order_type_id);
2636: END IF;

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

2631: IF (g_ship_to_loc_id <> 0) THEN
2632: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_to_loc_id',g_ship_to_loc_id);
2633: END IF;
2634: IF (g_order_type_id <> 0) THEN
2635: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_type_id',g_order_type_id);
2636: END IF;
2637: IF (g_ship_set_number <> 0) THEN
2638: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_set_id',g_ship_set_number);
2639: END IF;

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

2634: IF (g_order_type_id <> 0) THEN
2635: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_order_type_id',g_order_type_id);
2636: END IF;
2637: IF (g_ship_set_number <> 0) THEN
2638: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_set_id',g_ship_set_number);
2639: END IF;
2640: IF (g_task_id <> 0) THEN
2641: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_task_id',g_task_id);
2642: END IF;

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

2637: IF (g_ship_set_number <> 0) THEN
2638: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_set_id',g_ship_set_number);
2639: END IF;
2640: IF (g_task_id <> 0) THEN
2641: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_task_id',g_task_id);
2642: END IF;
2643: IF (g_project_id <> 0) THEN
2644: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_project_id',g_project_id);
2645: END IF;

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

2640: IF (g_task_id <> 0) THEN
2641: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_task_id',g_task_id);
2642: END IF;
2643: IF (g_project_id <> 0) THEN
2644: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_project_id',g_project_id);
2645: END IF;
2646: IF (p_organization_id IS NOT NULL) THEN
2647: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_org_id',p_organization_id);
2648: END IF;

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

2643: IF (g_project_id <> 0) THEN
2644: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_project_id',g_project_id);
2645: END IF;
2646: IF (p_organization_id IS NOT NULL) THEN
2647: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_org_id',p_organization_id);
2648: END IF;
2649: IF (g_ship_method_code IS NOT NULL) THEN
2650: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_method_code',g_ship_method_code);
2651: END IF;

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

2646: IF (p_organization_id IS NOT NULL) THEN
2647: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_org_id',p_organization_id);
2648: END IF;
2649: IF (g_ship_method_code IS NOT NULL) THEN
2650: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_method_code',g_ship_method_code);
2651: END IF;
2652: IF (g_shipment_priority IS NOT NULL) THEN
2653: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_shipment_priority',g_shipment_priority);
2654: END IF;

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

2649: IF (g_ship_method_code IS NOT NULL) THEN
2650: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_ship_method_code',g_ship_method_code);
2651: END IF;
2652: IF (g_shipment_priority IS NOT NULL) THEN
2653: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_shipment_priority',g_shipment_priority);
2654: END IF;
2655: IF (g_from_request_date IS NOT NULL) THEN
2656: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_request_date',TO_CHAR(g_from_request_date,'RRRR/MM/DD HH24:MI:SS'));
2657: END IF;

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

2652: IF (g_shipment_priority IS NOT NULL) THEN
2653: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_shipment_priority',g_shipment_priority);
2654: END IF;
2655: IF (g_from_request_date IS NOT NULL) THEN
2656: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_request_date',TO_CHAR(g_from_request_date,'RRRR/MM/DD HH24:MI:SS'));
2657: END IF;
2658: IF (g_to_request_date IS NOT NULL) THEN
2659: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_to_request_date',TO_CHAR(g_to_request_date,'RRRR/MM/DD HH24:MI:SS'));
2660: END IF;

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

2655: IF (g_from_request_date IS NOT NULL) THEN
2656: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_request_date',TO_CHAR(g_from_request_date,'RRRR/MM/DD HH24:MI:SS'));
2657: END IF;
2658: IF (g_to_request_date IS NOT NULL) THEN
2659: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_to_request_date',TO_CHAR(g_to_request_date,'RRRR/MM/DD HH24:MI:SS'));
2660: END IF;
2661: IF (g_from_sched_ship_date IS NOT NULL) THEN
2662: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_sched_ship_date',TO_CHAR(g_from_sched_ship_date,'RRRR/MM/DD HH24:MI:SS'));
2663: END IF;

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

2658: IF (g_to_request_date IS NOT NULL) THEN
2659: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_to_request_date',TO_CHAR(g_to_request_date,'RRRR/MM/DD HH24:MI:SS'));
2660: END IF;
2661: IF (g_from_sched_ship_date IS NOT NULL) THEN
2662: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_sched_ship_date',TO_CHAR(g_from_sched_ship_date,'RRRR/MM/DD HH24:MI:SS'));
2663: END IF;
2664: IF (g_to_sched_ship_date IS NOT NULL) THEN
2665: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_to_sched_ship_date',TO_CHAR(g_to_sched_ship_date,'RRRR/MM/DD HH24:MI:SS'));
2666: END IF;

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

2661: IF (g_from_sched_ship_date IS NOT NULL) THEN
2662: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_from_sched_ship_date',TO_CHAR(g_from_sched_ship_date,'RRRR/MM/DD HH24:MI:SS'));
2663: END IF;
2664: IF (g_to_sched_ship_date IS NOT NULL) THEN
2665: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_to_sched_ship_date',TO_CHAR(g_to_sched_ship_date,'RRRR/MM/DD HH24:MI:SS'));
2666: END IF;
2667: --}
2668:
2669: --{

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

2668:
2669: --{
2670: IF p_mode = 'WORKER' THEN
2671: IF (p_inv_item_id IS NOT NULL) THEN
2672: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',p_inv_item_id);
2673: END IF;
2674: ELSE
2675: IF (g_inventory_item_id <> 0) THEN
2676: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',g_inventory_item_id);

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

2672: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',p_inv_item_id);
2673: END IF;
2674: ELSE
2675: IF (g_inventory_item_id <> 0) THEN
2676: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',g_inventory_item_id);
2677: END IF;
2678: END IF;
2679: --}
2680:

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

2679: --}
2680:
2681: --{
2682: IF (g_include_planned_lines <> 'N') THEN
2683: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_include_planned_lines',g_include_planned_lines);
2684: END IF;
2685: IF (g_trip_id <> 0) THEN
2686: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_trip_id',g_trip_id);
2687: IF (g_trip_stop_id <> 0) THEN

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

2682: IF (g_include_planned_lines <> 'N') THEN
2683: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_include_planned_lines',g_include_planned_lines);
2684: END IF;
2685: IF (g_trip_id <> 0) THEN
2686: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_trip_id',g_trip_id);
2687: IF (g_trip_stop_id <> 0) THEN
2688: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_trip_stop_id', g_trip_stop_id);
2689: END IF;
2690: END IF;

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

2684: END IF;
2685: IF (g_trip_id <> 0) THEN
2686: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_trip_id',g_trip_id);
2687: IF (g_trip_stop_id <> 0) THEN
2688: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_trip_stop_id', g_trip_stop_id);
2689: END IF;
2690: END IF;
2691: IF (g_delivery_id <> 0) THEN
2692: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_delivery_id',g_delivery_id);

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

2688: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_trip_stop_id', g_trip_stop_id);
2689: END IF;
2690: END IF;
2691: IF (g_delivery_id <> 0) THEN
2692: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_delivery_id',g_delivery_id);
2693: END IF;
2694: IF (g_existing_rsvs_only_flag = 'Y') THEN
2695: IF (g_from_subinventory IS NOT NULL) THEN
2696: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_subinventory_code',g_from_subinventory);

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

2692: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_delivery_id',g_delivery_id);
2693: END IF;
2694: IF (g_existing_rsvs_only_flag = 'Y') THEN
2695: IF (g_from_subinventory IS NOT NULL) THEN
2696: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_subinventory_code',g_from_subinventory);
2697: END IF;
2698: IF (g_from_locator IS NOT NULL) THEN
2699: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_locator_id',g_from_locator);
2700: END IF;

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

2695: IF (g_from_subinventory IS NOT NULL) THEN
2696: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_subinventory_code',g_from_subinventory);
2697: END IF;
2698: IF (g_from_locator IS NOT NULL) THEN
2699: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_locator_id',g_from_locator);
2700: END IF;
2701: END IF;
2702: IF (g_categorysetid <> 0) THEN
2703: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categorysetid',g_categorysetid);

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

2699: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_locator_id',g_from_locator);
2700: END IF;
2701: END IF;
2702: IF (g_categorysetid <> 0) THEN
2703: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categorysetid',g_categorysetid);
2704: IF (g_categoryid <> 0) THEN
2705: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categoryid',g_categoryid);
2706: END IF;
2707: END IF;

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

2701: END IF;
2702: IF (g_categorysetid <> 0) THEN
2703: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categorysetid',g_categorysetid);
2704: IF (g_categoryid <> 0) THEN
2705: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categoryid',g_categoryid);
2706: END IF;
2707: END IF;
2708: IF (g_regionid <> 0) THEN
2709: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_regionid',g_regionid);

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

2705: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_categoryid',g_categoryid);
2706: END IF;
2707: END IF;
2708: IF (g_regionid <> 0) THEN
2709: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_regionid',g_regionid);
2710: END IF;
2711: IF (g_zoneid <> 0) THEN
2712: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_zoneid',g_zoneid);
2713: END IF;

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

2708: IF (g_regionid <> 0) THEN
2709: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_regionid',g_regionid);
2710: END IF;
2711: IF (g_zoneid <> 0) THEN
2712: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_zoneid',g_zoneid);
2713: END IF;
2714: IF (g_RelSubInventory IS NOT NULL) THEN
2715: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_relsubinv',g_relsubinventory);
2716: END IF;

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

2711: IF (g_zoneid <> 0) THEN
2712: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_zoneid',g_zoneid);
2713: END IF;
2714: IF (g_RelSubInventory IS NOT NULL) THEN
2715: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_relsubinv',g_relsubinventory);
2716: END IF;
2717: --}
2718:
2719: -- 90. Execute the cursor

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

2721: IF l_debug_on THEN
2722: WSH_DEBUG_SV.logmsg(l_module_name, 'EXECUTING CURSOR' );
2723: END IF;
2724: --
2725: v_ignore := DBMS_SQL.Execute(v_CursorID);
2726:
2727:
2728: -- 100. Fetching records for SUMMARY mode and inserting worker records
2729: --{

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

2729: --{
2730: IF p_mode = 'SUMMARY' THEN
2731: l_count := 0;
2732: LOOP
2733: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
2734: DBMS_SQL.Close_Cursor(v_cursorID);
2735: v_cursorID := NULL;
2736: EXIT;
2737: ELSE

Line 2734: DBMS_SQL.Close_Cursor(v_cursorID);

2730: IF p_mode = 'SUMMARY' THEN
2731: l_count := 0;
2732: LOOP
2733: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
2734: DBMS_SQL.Close_Cursor(v_cursorID);
2735: v_cursorID := NULL;
2736: EXIT;
2737: ELSE
2738: DBMS_SQL.Column_Value(v_CursorID, 1, v_org_id);

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

2734: DBMS_SQL.Close_Cursor(v_cursorID);
2735: v_cursorID := NULL;
2736: EXIT;
2737: ELSE
2738: DBMS_SQL.Column_Value(v_CursorID, 1, v_org_id);
2739: DBMS_SQL.Column_Value(v_CursorID, 2, v_inventory_item_id);
2740: DBMS_SQL.Column_Value(v_CursorID, 3, v_count);
2741:
2742: INSERT INTO WSH_PR_WORKERS (

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

2735: v_cursorID := NULL;
2736: EXIT;
2737: ELSE
2738: DBMS_SQL.Column_Value(v_CursorID, 1, v_org_id);
2739: DBMS_SQL.Column_Value(v_CursorID, 2, v_inventory_item_id);
2740: DBMS_SQL.Column_Value(v_CursorID, 3, v_count);
2741:
2742: INSERT INTO WSH_PR_WORKERS (
2743: batch_id,

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

2736: EXIT;
2737: ELSE
2738: DBMS_SQL.Column_Value(v_CursorID, 1, v_org_id);
2739: DBMS_SQL.Column_Value(v_CursorID, 2, v_inventory_item_id);
2740: DBMS_SQL.Column_Value(v_CursorID, 3, v_count);
2741:
2742: INSERT INTO WSH_PR_WORKERS (
2743: batch_id,
2744: type,

Line 2790: IF DBMS_SQL.IS_Open(v_cursorID) THEN

2786:
2787: EXCEPTION
2788: --
2789: WHEN OTHERS THEN
2790: IF DBMS_SQL.IS_Open(v_cursorID) THEN
2791: DBMS_SQL.Close_Cursor(v_cursorID);
2792: END IF;
2793: --
2794: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2791: DBMS_SQL.Close_Cursor(v_cursorID);

2787: EXCEPTION
2788: --
2789: WHEN OTHERS THEN
2790: IF DBMS_SQL.IS_Open(v_cursorID) THEN
2791: DBMS_SQL.Close_Cursor(v_cursorID);
2792: END IF;
2793: --
2794: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2795: --

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

2978:
2979: LOOP
2980: --{
2981: IF v_cursorID IS NOT NULL THEN
2982: l_dummy := DBMS_SQL.Fetch_Rows(v_cursorID);
2983: END IF;
2984: IF ( v_cursorID IS NULL ) OR ( l_dummy = 0 ) THEN
2985: -- Either all lines are fetched for a worker record or a New Organization
2986: --{

Line 3004: DBMS_SQL.Close_Cursor(v_CursorID);

3000: IF c_work_cursorID%ISOPEN THEN
3001: CLOSE c_work_cursorID;
3002: END IF;
3003: IF v_CursorID IS NOT NULL THEN
3004: DBMS_SQL.Close_Cursor(v_CursorID);
3005: v_CursorID := NULL;
3006: END IF;
3007: x_done_flag := FND_API.G_TRUE;
3008: EXIT;

Line 3091: IF DBMS_SQL.Is_Open(v_CursorID) THEN

3087: IF l_debug_on THEN
3088: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in updating worker records as processed');
3089: WSH_DEBUG_SV.pop(l_module_name);
3090: END IF;
3091: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3092: DBMS_SQL.Close_Cursor(v_CursorID);
3093: END IF;
3094: IF c_work_cursorID%ISOPEN THEN
3095: CLOSE c_work_cursorID;

Line 3092: DBMS_SQL.Close_Cursor(v_CursorID);

3088: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in updating worker records as processed');
3089: WSH_DEBUG_SV.pop(l_module_name);
3090: END IF;
3091: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3092: DBMS_SQL.Close_Cursor(v_CursorID);
3093: END IF;
3094: IF c_work_cursorID%ISOPEN THEN
3095: CLOSE c_work_cursorID;
3096: END IF;

Line 3129: IF DBMS_SQL.Is_Open(v_CursorID) THEN

3125: IF l_debug_on THEN
3126: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in Init_Cursor');
3127: WSH_DEBUG_SV.pop(l_module_name);
3128: END IF;
3129: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3130: DBMS_SQL.Close_Cursor(v_CursorID);
3131: END IF;
3132: IF c_work_cursorID%ISOPEN THEN
3133: CLOSE c_work_cursorID;

Line 3130: DBMS_SQL.Close_Cursor(v_CursorID);

3126: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in Init_Cursor');
3127: WSH_DEBUG_SV.pop(l_module_name);
3128: END IF;
3129: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3130: DBMS_SQL.Close_Cursor(v_CursorID);
3131: END IF;
3132: IF c_work_cursorID%ISOPEN THEN
3133: CLOSE c_work_cursorID;
3134: END IF;

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

3140: -- Bind the new Item and execute the cursor again
3141: IF l_debug_on THEN
3142: WSH_DEBUG_SV.logmsg(l_module_name, 'Binding new Item '||v_pr_inv_item_id||' and Executing Cursor' );
3143: END IF;
3144: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',v_pr_inv_item_id);
3145: l_dummy := DBMS_SQL.Execute(v_CursorID);
3146: v_total_rec_fetched := 0;
3147: END IF;
3148: --}

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

3141: IF l_debug_on THEN
3142: WSH_DEBUG_SV.logmsg(l_module_name, 'Binding new Item '||v_pr_inv_item_id||' and Executing Cursor' );
3143: END IF;
3144: DBMS_SQL.BIND_VARIABLE(v_CursorID,':X_inventory_item_id',v_pr_inv_item_id);
3145: l_dummy := DBMS_SQL.Execute(v_CursorID);
3146: v_total_rec_fetched := 0;
3147: END IF;
3148: --}
3149:

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

3153: IF l_debug_on THEN
3154: WSH_DEBUG_SV.logmsg(l_module_name, 'MAP OUTPUT COLUMNS' );
3155: END IF;
3156:
3157: DBMS_SQL.Column_Value(v_CursorID, 1, v_line_id);
3158: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
3159: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3160: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3161: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);

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

3154: WSH_DEBUG_SV.logmsg(l_module_name, 'MAP OUTPUT COLUMNS' );
3155: END IF;
3156:
3157: DBMS_SQL.Column_Value(v_CursorID, 1, v_line_id);
3158: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
3159: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3160: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3161: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3162: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);

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

3155: END IF;
3156:
3157: DBMS_SQL.Column_Value(v_CursorID, 1, v_line_id);
3158: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
3159: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3160: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3161: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3162: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3163: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);

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

3156:
3157: DBMS_SQL.Column_Value(v_CursorID, 1, v_line_id);
3158: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
3159: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3160: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3161: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3162: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3163: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3164: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);

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

3157: DBMS_SQL.Column_Value(v_CursorID, 1, v_line_id);
3158: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
3159: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3160: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3161: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3162: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3163: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3164: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3165: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);

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

3158: DBMS_SQL.Column_Value(v_CursorID, 2, v_header_id);
3159: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3160: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3161: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3162: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3163: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3164: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3165: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3166: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);

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

3159: DBMS_SQL.Column_Value(v_CursorID, 3, v_org_id);
3160: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3161: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3162: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3163: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3164: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3165: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3166: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3167: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);

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

3160: DBMS_SQL.Column_Value(v_CursorID, 4, v_inventory_item_id);
3161: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3162: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3163: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3164: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3165: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3166: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3167: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3168: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);

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

3161: DBMS_SQL.Column_Value(v_CursorID, 5, v_move_order_line_id);
3162: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3163: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3164: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3165: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3166: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3167: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3168: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3169: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);

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

3162: DBMS_SQL.Column_Value(v_CursorID, 6, v_delivery_detail_id);
3163: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3164: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3165: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3166: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3167: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3168: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3169: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3170: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);

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

3163: DBMS_SQL.Column_Value(v_CursorID, 7, v_ship_model_complete_flag);
3164: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3165: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3166: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3167: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3168: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3169: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3170: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3171: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);

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

3164: DBMS_SQL.Column_Value(v_CursorID, 8, v_top_model_line_id);
3165: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3166: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3167: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3168: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3169: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3170: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3171: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3172: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);

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

3165: DBMS_SQL.Column_Value(v_CursorID, 9, v_ship_from_location_id);
3166: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3167: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3168: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3169: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3170: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3171: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3172: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3173: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);

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

3166: DBMS_SQL.Column_Value(v_CursorID, 10, v_ship_method_code);
3167: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3168: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3169: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3170: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3171: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3172: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3173: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3174: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);

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

3167: DBMS_SQL.Column_Value(v_CursorID, 11, v_shipment_priority);
3168: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3169: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3170: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3171: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3172: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3173: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3174: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3175: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);

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

3168: DBMS_SQL.Column_Value(v_CursorID, 12, v_date_scheduled);
3169: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3170: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3171: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3172: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3173: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3174: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3175: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3176: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);

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

3169: DBMS_SQL.Column_Value(v_CursorID, 13, v_requested_quantity);
3170: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3171: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3172: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3173: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3174: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3175: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3176: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3177: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);

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

3170: DBMS_SQL.Column_Value(v_CursorID, 14, v_requested_quantity_uom);
3171: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3172: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3173: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3174: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3175: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3176: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3177: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3178: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);

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

3171: DBMS_SQL.Column_Value(v_CursorID, 15, v_preferred_grade);
3172: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3173: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3174: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3175: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3176: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3177: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3178: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3179: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);

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

3172: DBMS_SQL.Column_Value(v_CursorID, 16, v_requested_quantity2);
3173: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3174: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3175: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3176: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3177: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3178: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3179: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3180: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);

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

3173: DBMS_SQL.Column_Value(v_CursorID, 17, v_requested_quantity_uom2);
3174: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3175: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3176: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3177: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3178: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3179: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3180: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3181: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);

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

3174: DBMS_SQL.Column_Value(v_CursorID, 18, v_project_id);
3175: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3176: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3177: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3178: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3179: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3180: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3181: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3182: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);

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

3175: DBMS_SQL.Column_Value(v_CursorID, 19, v_task_id);
3176: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3177: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3178: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3179: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3180: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3181: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3182: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3183: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);

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

3176: DBMS_SQL.Column_Value(v_CursorID, 20, v_from_sub);
3177: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3178: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3179: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3180: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3181: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3182: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3183: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3184: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);

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

3177: DBMS_SQL.Column_Value(v_CursorID, 21, v_to_sub);
3178: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3179: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3180: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3181: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3182: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3183: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3184: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3185: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);

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

3178: DBMS_SQL.Column_Value(v_CursorID, 22, v_released_status);
3179: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3180: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3181: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3182: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3183: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3184: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3185: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3186: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);

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

3179: DBMS_SQL.Column_Value(v_CursorID, 23, v_ship_set_id);
3180: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3181: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3182: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3183: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3184: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3185: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3186: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3187: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);

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

3180: DBMS_SQL.Column_Value(v_CursorID, 24, v_source_code);
3181: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3182: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3183: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3184: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3185: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3186: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3187: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3188: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);

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

3181: DBMS_SQL.Column_Value(v_CursorID, 25, v_source_header_number);
3182: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3183: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3184: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3185: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3186: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3187: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3188: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);
3189: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);

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

3182: DBMS_SQL.Column_Value(v_CursorID, 26, v_planned_departure_date);
3183: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3184: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3185: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3186: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3187: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3188: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);
3189: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);
3190: -- anxsharm, X-dock, customer_id

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

3183: DBMS_SQL.Column_Value(v_CursorID, 27, v_delivery_id);
3184: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3185: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3186: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3187: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3188: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);
3189: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);
3190: -- anxsharm, X-dock, customer_id
3191: DBMS_SQL.Column_Value(v_CursorID, 34, v_customer_id);

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

3184: DBMS_SQL.Column_Value(v_CursorID, 28, v_unit_number);
3185: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3186: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3187: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3188: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);
3189: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);
3190: -- anxsharm, X-dock, customer_id
3191: DBMS_SQL.Column_Value(v_CursorID, 34, v_customer_id);
3192: -- Standalone project Changes start

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

3185: DBMS_SQL.Column_Value(v_CursorID, 29, v_source_doc_type);
3186: DBMS_SQL.Column_Value(v_CursorID, 30, v_reservable_type);
3187: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3188: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);
3189: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);
3190: -- anxsharm, X-dock, customer_id
3191: DBMS_SQL.Column_Value(v_CursorID, 34, v_customer_id);
3192: -- Standalone project Changes start
3193: DBMS_SQL.Column_Value(v_CursorID, 35, v_revision);

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

3187: DBMS_SQL.Column_Value(v_CursorID, 31, v_last_update_date);
3188: DBMS_SQL.Column_Value(v_CursorID, 32, v_demand_source_header_id);
3189: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);
3190: -- anxsharm, X-dock, customer_id
3191: DBMS_SQL.Column_Value(v_CursorID, 34, v_customer_id);
3192: -- Standalone project Changes start
3193: DBMS_SQL.Column_Value(v_CursorID, 35, v_revision);
3194: DBMS_SQL.Column_Value(v_CursorID, 36, v_from_locator);
3195: DBMS_SQL.Column_Value(v_CursorID, 37, v_lot_number);

Line 3193: DBMS_SQL.Column_Value(v_CursorID, 35, v_revision);

3189: DBMS_SQL.Column_Value(v_CursorID, 33, v_invoice_value);
3190: -- anxsharm, X-dock, customer_id
3191: DBMS_SQL.Column_Value(v_CursorID, 34, v_customer_id);
3192: -- Standalone project Changes start
3193: DBMS_SQL.Column_Value(v_CursorID, 35, v_revision);
3194: DBMS_SQL.Column_Value(v_CursorID, 36, v_from_locator);
3195: DBMS_SQL.Column_Value(v_CursorID, 37, v_lot_number);
3196: -- Standalone project Changes end
3197: DBMS_SQL.Column_Value(v_CursorID, 38, v_client_id); -- LSP PROJECT

Line 3194: DBMS_SQL.Column_Value(v_CursorID, 36, v_from_locator);

3190: -- anxsharm, X-dock, customer_id
3191: DBMS_SQL.Column_Value(v_CursorID, 34, v_customer_id);
3192: -- Standalone project Changes start
3193: DBMS_SQL.Column_Value(v_CursorID, 35, v_revision);
3194: DBMS_SQL.Column_Value(v_CursorID, 36, v_from_locator);
3195: DBMS_SQL.Column_Value(v_CursorID, 37, v_lot_number);
3196: -- Standalone project Changes end
3197: DBMS_SQL.Column_Value(v_CursorID, 38, v_client_id); -- LSP PROJECT
3198: IF l_debug_on THEN

Line 3195: DBMS_SQL.Column_Value(v_CursorID, 37, v_lot_number);

3191: DBMS_SQL.Column_Value(v_CursorID, 34, v_customer_id);
3192: -- Standalone project Changes start
3193: DBMS_SQL.Column_Value(v_CursorID, 35, v_revision);
3194: DBMS_SQL.Column_Value(v_CursorID, 36, v_from_locator);
3195: DBMS_SQL.Column_Value(v_CursorID, 37, v_lot_number);
3196: -- Standalone project Changes end
3197: DBMS_SQL.Column_Value(v_CursorID, 38, v_client_id); -- LSP PROJECT
3198: IF l_debug_on THEN
3199: WSH_DEBUG_SV.log(l_module_name, 'CURRENT LINE IS', TO_CHAR(G_REL_CURRENT_LINE));

Line 3197: DBMS_SQL.Column_Value(v_CursorID, 38, v_client_id); -- LSP PROJECT

3193: DBMS_SQL.Column_Value(v_CursorID, 35, v_revision);
3194: DBMS_SQL.Column_Value(v_CursorID, 36, v_from_locator);
3195: DBMS_SQL.Column_Value(v_CursorID, 37, v_lot_number);
3196: -- Standalone project Changes end
3197: DBMS_SQL.Column_Value(v_CursorID, 38, v_client_id); -- LSP PROJECT
3198: IF l_debug_on THEN
3199: WSH_DEBUG_SV.log(l_module_name, 'CURRENT LINE IS', TO_CHAR(G_REL_CURRENT_LINE));
3200: WSH_DEBUG_SV.log(l_module_name, 'Delivery detail ID', v_delivery_detail_id);
3201: END IF;

Line 3212: IF DBMS_SQL.Is_Open(v_CursorID) THEN

3208: IF l_debug_on THEN
3209: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN INSERT_RL_ROW');
3210: --WSH_DEBUG_SV.pop(l_module_name);
3211: END IF;
3212: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3213: DBMS_SQL.Close_Cursor(v_CursorID);
3214: END IF;
3215: IF c_work_cursorID%ISOPEN THEN
3216: CLOSE c_work_cursorID;

Line 3213: DBMS_SQL.Close_Cursor(v_CursorID);

3209: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN INSERT_RL_ROW');
3210: --WSH_DEBUG_SV.pop(l_module_name);
3211: END IF;
3212: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3213: DBMS_SQL.Close_Cursor(v_CursorID);
3214: END IF;
3215: IF c_work_cursorID%ISOPEN THEN
3216: CLOSE c_work_cursorID;
3217: END IF;

Line 3391: IF DBMS_SQL.Is_Open(v_CursorID) THEN

3387: IF l_debug_on THEN
3388: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3389: END IF;
3390: --
3391: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3392: DBMS_SQL.Close_Cursor(v_CursorID);
3393: END IF;
3394: IF c_work_cursorID%ISOPEN THEN
3395: CLOSE c_work_cursorID;

Line 3392: DBMS_SQL.Close_Cursor(v_CursorID);

3388: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3389: END IF;
3390: --
3391: IF DBMS_SQL.Is_Open(v_CursorID) THEN
3392: DBMS_SQL.Close_Cursor(v_CursorID);
3393: END IF;
3394: IF c_work_cursorID%ISOPEN THEN
3395: CLOSE c_work_cursorID;
3396: END IF;