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_PICKING_ROWS dependencies on DBMS_SQL

Line 69: -- Column variables for DBMS_SQL package for mapping to selected values from cursors

65:
66: -- To keep track of non_ship lines refetch mode
67: ns_lines_refetch_mode BOOLEAN;
68:
69: -- Column variables for DBMS_SQL package for mapping to selected values from cursors
70:
71: -- Unreleased lines -- Backordered lines
72: u_line_id BINARY_INTEGER; b_line_id BINARY_INTEGER;
73: u_header_id BINARY_INTEGER; b_header_id BINARY_INTEGER;

Line 448: u_cursor := DBMS_SQL.Open_Cursor;

444: WSH_UTIL.Write_Log('Starting WSH_PR_PICKING_ROWS.Open_Execute_Cursor');
445: IF p_mode = 'UNRELEASED' THEN
446: -- Open a cursor for unreleased_SQL
447: WSH_UTIL.Write_Log('Processing unreleased cursor');
448: u_cursor := DBMS_SQL.Open_Cursor;
449:
450: -- Parse the cursor
451: WSH_UTIL.Write_Log('Parsing unreleased cursor');
452: DBMS_SQL.Parse(u_cursor, unreleased_SQL, DBMS_SQL.v7);

Line 452: DBMS_SQL.Parse(u_cursor, unreleased_SQL, DBMS_SQL.v7);

448: u_cursor := DBMS_SQL.Open_Cursor;
449:
450: -- Parse the cursor
451: WSH_UTIL.Write_Log('Parsing unreleased cursor');
452: DBMS_SQL.Parse(u_cursor, unreleased_SQL, DBMS_SQL.v7);
453:
454: -- Identify the column numbers with variable
455: WSH_UTIL.Write_Log('Column definition for unreleased cursor');
456: DBMS_SQL.Define_Column(u_cursor, 1, u_line_id);

Line 456: DBMS_SQL.Define_Column(u_cursor, 1, u_line_id);

452: DBMS_SQL.Parse(u_cursor, unreleased_SQL, DBMS_SQL.v7);
453:
454: -- Identify the column numbers with variable
455: WSH_UTIL.Write_Log('Column definition for unreleased cursor');
456: DBMS_SQL.Define_Column(u_cursor, 1, u_line_id);
457: DBMS_SQL.Define_Column(u_cursor, 2, u_header_id);
458: DBMS_SQL.Define_Column(u_cursor, 3, u_org_id);
459: DBMS_SQL.Define_Column(u_cursor, 4, u_ato_flag, 1);
460: DBMS_SQL.Define_Column(u_cursor, 5, u_line_detail_id);

Line 457: DBMS_SQL.Define_Column(u_cursor, 2, u_header_id);

453:
454: -- Identify the column numbers with variable
455: WSH_UTIL.Write_Log('Column definition for unreleased cursor');
456: DBMS_SQL.Define_Column(u_cursor, 1, u_line_id);
457: DBMS_SQL.Define_Column(u_cursor, 2, u_header_id);
458: DBMS_SQL.Define_Column(u_cursor, 3, u_org_id);
459: DBMS_SQL.Define_Column(u_cursor, 4, u_ato_flag, 1);
460: DBMS_SQL.Define_Column(u_cursor, 5, u_line_detail_id);
461: DBMS_SQL.Define_Column(u_cursor, 6, u_ship_model_complete, 1);

Line 458: DBMS_SQL.Define_Column(u_cursor, 3, u_org_id);

454: -- Identify the column numbers with variable
455: WSH_UTIL.Write_Log('Column definition for unreleased cursor');
456: DBMS_SQL.Define_Column(u_cursor, 1, u_line_id);
457: DBMS_SQL.Define_Column(u_cursor, 2, u_header_id);
458: DBMS_SQL.Define_Column(u_cursor, 3, u_org_id);
459: DBMS_SQL.Define_Column(u_cursor, 4, u_ato_flag, 1);
460: DBMS_SQL.Define_Column(u_cursor, 5, u_line_detail_id);
461: DBMS_SQL.Define_Column(u_cursor, 6, u_ship_model_complete, 1);
462: DBMS_SQL.Define_Column(u_cursor, 7, u_ship_set_number);

Line 459: DBMS_SQL.Define_Column(u_cursor, 4, u_ato_flag, 1);

455: WSH_UTIL.Write_Log('Column definition for unreleased cursor');
456: DBMS_SQL.Define_Column(u_cursor, 1, u_line_id);
457: DBMS_SQL.Define_Column(u_cursor, 2, u_header_id);
458: DBMS_SQL.Define_Column(u_cursor, 3, u_org_id);
459: DBMS_SQL.Define_Column(u_cursor, 4, u_ato_flag, 1);
460: DBMS_SQL.Define_Column(u_cursor, 5, u_line_detail_id);
461: DBMS_SQL.Define_Column(u_cursor, 6, u_ship_model_complete, 1);
462: DBMS_SQL.Define_Column(u_cursor, 7, u_ship_set_number);
463: DBMS_SQL.Define_Column(u_cursor, 8, u_parent_line_id);

Line 460: DBMS_SQL.Define_Column(u_cursor, 5, u_line_detail_id);

456: DBMS_SQL.Define_Column(u_cursor, 1, u_line_id);
457: DBMS_SQL.Define_Column(u_cursor, 2, u_header_id);
458: DBMS_SQL.Define_Column(u_cursor, 3, u_org_id);
459: DBMS_SQL.Define_Column(u_cursor, 4, u_ato_flag, 1);
460: DBMS_SQL.Define_Column(u_cursor, 5, u_line_detail_id);
461: DBMS_SQL.Define_Column(u_cursor, 6, u_ship_model_complete, 1);
462: DBMS_SQL.Define_Column(u_cursor, 7, u_ship_set_number);
463: DBMS_SQL.Define_Column(u_cursor, 8, u_parent_line_id);
464: DBMS_SQL.Define_Column(u_cursor, 9, u_ld_warehouse_id);

Line 461: DBMS_SQL.Define_Column(u_cursor, 6, u_ship_model_complete, 1);

457: DBMS_SQL.Define_Column(u_cursor, 2, u_header_id);
458: DBMS_SQL.Define_Column(u_cursor, 3, u_org_id);
459: DBMS_SQL.Define_Column(u_cursor, 4, u_ato_flag, 1);
460: DBMS_SQL.Define_Column(u_cursor, 5, u_line_detail_id);
461: DBMS_SQL.Define_Column(u_cursor, 6, u_ship_model_complete, 1);
462: DBMS_SQL.Define_Column(u_cursor, 7, u_ship_set_number);
463: DBMS_SQL.Define_Column(u_cursor, 8, u_parent_line_id);
464: DBMS_SQL.Define_Column(u_cursor, 9, u_ld_warehouse_id);
465: DBMS_SQL.Define_Column(u_cursor, 10, u_ship_to_site_use_id);

Line 462: DBMS_SQL.Define_Column(u_cursor, 7, u_ship_set_number);

458: DBMS_SQL.Define_Column(u_cursor, 3, u_org_id);
459: DBMS_SQL.Define_Column(u_cursor, 4, u_ato_flag, 1);
460: DBMS_SQL.Define_Column(u_cursor, 5, u_line_detail_id);
461: DBMS_SQL.Define_Column(u_cursor, 6, u_ship_model_complete, 1);
462: DBMS_SQL.Define_Column(u_cursor, 7, u_ship_set_number);
463: DBMS_SQL.Define_Column(u_cursor, 8, u_parent_line_id);
464: DBMS_SQL.Define_Column(u_cursor, 9, u_ld_warehouse_id);
465: DBMS_SQL.Define_Column(u_cursor, 10, u_ship_to_site_use_id);
466: DBMS_SQL.Define_Column(u_cursor, 11, u_ship_to_contact_id);

Line 463: DBMS_SQL.Define_Column(u_cursor, 8, u_parent_line_id);

459: DBMS_SQL.Define_Column(u_cursor, 4, u_ato_flag, 1);
460: DBMS_SQL.Define_Column(u_cursor, 5, u_line_detail_id);
461: DBMS_SQL.Define_Column(u_cursor, 6, u_ship_model_complete, 1);
462: DBMS_SQL.Define_Column(u_cursor, 7, u_ship_set_number);
463: DBMS_SQL.Define_Column(u_cursor, 8, u_parent_line_id);
464: DBMS_SQL.Define_Column(u_cursor, 9, u_ld_warehouse_id);
465: DBMS_SQL.Define_Column(u_cursor, 10, u_ship_to_site_use_id);
466: DBMS_SQL.Define_Column(u_cursor, 11, u_ship_to_contact_id);
467: DBMS_SQL.Define_Column(u_cursor, 12, u_ship_method_code, 30);

Line 464: DBMS_SQL.Define_Column(u_cursor, 9, u_ld_warehouse_id);

460: DBMS_SQL.Define_Column(u_cursor, 5, u_line_detail_id);
461: DBMS_SQL.Define_Column(u_cursor, 6, u_ship_model_complete, 1);
462: DBMS_SQL.Define_Column(u_cursor, 7, u_ship_set_number);
463: DBMS_SQL.Define_Column(u_cursor, 8, u_parent_line_id);
464: DBMS_SQL.Define_Column(u_cursor, 9, u_ld_warehouse_id);
465: DBMS_SQL.Define_Column(u_cursor, 10, u_ship_to_site_use_id);
466: DBMS_SQL.Define_Column(u_cursor, 11, u_ship_to_contact_id);
467: DBMS_SQL.Define_Column(u_cursor, 12, u_ship_method_code, 30);
468: DBMS_SQL.Define_Column(u_cursor, 13, u_shipment_priority, 30);

Line 465: DBMS_SQL.Define_Column(u_cursor, 10, u_ship_to_site_use_id);

461: DBMS_SQL.Define_Column(u_cursor, 6, u_ship_model_complete, 1);
462: DBMS_SQL.Define_Column(u_cursor, 7, u_ship_set_number);
463: DBMS_SQL.Define_Column(u_cursor, 8, u_parent_line_id);
464: DBMS_SQL.Define_Column(u_cursor, 9, u_ld_warehouse_id);
465: DBMS_SQL.Define_Column(u_cursor, 10, u_ship_to_site_use_id);
466: DBMS_SQL.Define_Column(u_cursor, 11, u_ship_to_contact_id);
467: DBMS_SQL.Define_Column(u_cursor, 12, u_ship_method_code, 30);
468: DBMS_SQL.Define_Column(u_cursor, 13, u_shipment_priority, 30);
469: DBMS_SQL.Define_Column(u_cursor, 14, u_departure_id);

Line 466: DBMS_SQL.Define_Column(u_cursor, 11, u_ship_to_contact_id);

462: DBMS_SQL.Define_Column(u_cursor, 7, u_ship_set_number);
463: DBMS_SQL.Define_Column(u_cursor, 8, u_parent_line_id);
464: DBMS_SQL.Define_Column(u_cursor, 9, u_ld_warehouse_id);
465: DBMS_SQL.Define_Column(u_cursor, 10, u_ship_to_site_use_id);
466: DBMS_SQL.Define_Column(u_cursor, 11, u_ship_to_contact_id);
467: DBMS_SQL.Define_Column(u_cursor, 12, u_ship_method_code, 30);
468: DBMS_SQL.Define_Column(u_cursor, 13, u_shipment_priority, 30);
469: DBMS_SQL.Define_Column(u_cursor, 14, u_departure_id);
470: DBMS_SQL.Define_Column(u_cursor, 15, u_delivery_id);

Line 467: DBMS_SQL.Define_Column(u_cursor, 12, u_ship_method_code, 30);

463: DBMS_SQL.Define_Column(u_cursor, 8, u_parent_line_id);
464: DBMS_SQL.Define_Column(u_cursor, 9, u_ld_warehouse_id);
465: DBMS_SQL.Define_Column(u_cursor, 10, u_ship_to_site_use_id);
466: DBMS_SQL.Define_Column(u_cursor, 11, u_ship_to_contact_id);
467: DBMS_SQL.Define_Column(u_cursor, 12, u_ship_method_code, 30);
468: DBMS_SQL.Define_Column(u_cursor, 13, u_shipment_priority, 30);
469: DBMS_SQL.Define_Column(u_cursor, 14, u_departure_id);
470: DBMS_SQL.Define_Column(u_cursor, 15, u_delivery_id);
471: DBMS_SQL.Define_Column(u_cursor, 16, u_item_type_code, 30);

Line 468: DBMS_SQL.Define_Column(u_cursor, 13, u_shipment_priority, 30);

464: DBMS_SQL.Define_Column(u_cursor, 9, u_ld_warehouse_id);
465: DBMS_SQL.Define_Column(u_cursor, 10, u_ship_to_site_use_id);
466: DBMS_SQL.Define_Column(u_cursor, 11, u_ship_to_contact_id);
467: DBMS_SQL.Define_Column(u_cursor, 12, u_ship_method_code, 30);
468: DBMS_SQL.Define_Column(u_cursor, 13, u_shipment_priority, 30);
469: DBMS_SQL.Define_Column(u_cursor, 14, u_departure_id);
470: DBMS_SQL.Define_Column(u_cursor, 15, u_delivery_id);
471: DBMS_SQL.Define_Column(u_cursor, 16, u_item_type_code, 30);
472: DBMS_SQL.Define_Column(u_cursor, 17, u_schedule_date);

Line 469: DBMS_SQL.Define_Column(u_cursor, 14, u_departure_id);

465: DBMS_SQL.Define_Column(u_cursor, 10, u_ship_to_site_use_id);
466: DBMS_SQL.Define_Column(u_cursor, 11, u_ship_to_contact_id);
467: DBMS_SQL.Define_Column(u_cursor, 12, u_ship_method_code, 30);
468: DBMS_SQL.Define_Column(u_cursor, 13, u_shipment_priority, 30);
469: DBMS_SQL.Define_Column(u_cursor, 14, u_departure_id);
470: DBMS_SQL.Define_Column(u_cursor, 15, u_delivery_id);
471: DBMS_SQL.Define_Column(u_cursor, 16, u_item_type_code, 30);
472: DBMS_SQL.Define_Column(u_cursor, 17, u_schedule_date);
473: DBMS_SQL.Define_Column(u_cursor, 18, u_ordered_quantity);

Line 470: DBMS_SQL.Define_Column(u_cursor, 15, u_delivery_id);

466: DBMS_SQL.Define_Column(u_cursor, 11, u_ship_to_contact_id);
467: DBMS_SQL.Define_Column(u_cursor, 12, u_ship_method_code, 30);
468: DBMS_SQL.Define_Column(u_cursor, 13, u_shipment_priority, 30);
469: DBMS_SQL.Define_Column(u_cursor, 14, u_departure_id);
470: DBMS_SQL.Define_Column(u_cursor, 15, u_delivery_id);
471: DBMS_SQL.Define_Column(u_cursor, 16, u_item_type_code, 30);
472: DBMS_SQL.Define_Column(u_cursor, 17, u_schedule_date);
473: DBMS_SQL.Define_Column(u_cursor, 18, u_ordered_quantity);
474: DBMS_SQL.Define_Column(u_cursor, 19, u_cancelled_quantity);

Line 471: DBMS_SQL.Define_Column(u_cursor, 16, u_item_type_code, 30);

467: DBMS_SQL.Define_Column(u_cursor, 12, u_ship_method_code, 30);
468: DBMS_SQL.Define_Column(u_cursor, 13, u_shipment_priority, 30);
469: DBMS_SQL.Define_Column(u_cursor, 14, u_departure_id);
470: DBMS_SQL.Define_Column(u_cursor, 15, u_delivery_id);
471: DBMS_SQL.Define_Column(u_cursor, 16, u_item_type_code, 30);
472: DBMS_SQL.Define_Column(u_cursor, 17, u_schedule_date);
473: DBMS_SQL.Define_Column(u_cursor, 18, u_ordered_quantity);
474: DBMS_SQL.Define_Column(u_cursor, 19, u_cancelled_quantity);
475: DBMS_SQL.Define_Column(u_cursor, 20, u_l_inventory_item_id);

Line 472: DBMS_SQL.Define_Column(u_cursor, 17, u_schedule_date);

468: DBMS_SQL.Define_Column(u_cursor, 13, u_shipment_priority, 30);
469: DBMS_SQL.Define_Column(u_cursor, 14, u_departure_id);
470: DBMS_SQL.Define_Column(u_cursor, 15, u_delivery_id);
471: DBMS_SQL.Define_Column(u_cursor, 16, u_item_type_code, 30);
472: DBMS_SQL.Define_Column(u_cursor, 17, u_schedule_date);
473: DBMS_SQL.Define_Column(u_cursor, 18, u_ordered_quantity);
474: DBMS_SQL.Define_Column(u_cursor, 19, u_cancelled_quantity);
475: DBMS_SQL.Define_Column(u_cursor, 20, u_l_inventory_item_id);
476: DBMS_SQL.Define_Column(u_cursor, 21, u_ld_inventory_item_id);

Line 473: DBMS_SQL.Define_Column(u_cursor, 18, u_ordered_quantity);

469: DBMS_SQL.Define_Column(u_cursor, 14, u_departure_id);
470: DBMS_SQL.Define_Column(u_cursor, 15, u_delivery_id);
471: DBMS_SQL.Define_Column(u_cursor, 16, u_item_type_code, 30);
472: DBMS_SQL.Define_Column(u_cursor, 17, u_schedule_date);
473: DBMS_SQL.Define_Column(u_cursor, 18, u_ordered_quantity);
474: DBMS_SQL.Define_Column(u_cursor, 19, u_cancelled_quantity);
475: DBMS_SQL.Define_Column(u_cursor, 20, u_l_inventory_item_id);
476: DBMS_SQL.Define_Column(u_cursor, 21, u_ld_inventory_item_id);
477: DBMS_SQL.Define_Column(u_cursor, 22, u_customer_item_id);

Line 474: DBMS_SQL.Define_Column(u_cursor, 19, u_cancelled_quantity);

470: DBMS_SQL.Define_Column(u_cursor, 15, u_delivery_id);
471: DBMS_SQL.Define_Column(u_cursor, 16, u_item_type_code, 30);
472: DBMS_SQL.Define_Column(u_cursor, 17, u_schedule_date);
473: DBMS_SQL.Define_Column(u_cursor, 18, u_ordered_quantity);
474: DBMS_SQL.Define_Column(u_cursor, 19, u_cancelled_quantity);
475: DBMS_SQL.Define_Column(u_cursor, 20, u_l_inventory_item_id);
476: DBMS_SQL.Define_Column(u_cursor, 21, u_ld_inventory_item_id);
477: DBMS_SQL.Define_Column(u_cursor, 22, u_customer_item_id);
478: DBMS_SQL.Define_Column(u_cursor, 23, u_dep_plan_required_flag, 1);

Line 475: DBMS_SQL.Define_Column(u_cursor, 20, u_l_inventory_item_id);

471: DBMS_SQL.Define_Column(u_cursor, 16, u_item_type_code, 30);
472: DBMS_SQL.Define_Column(u_cursor, 17, u_schedule_date);
473: DBMS_SQL.Define_Column(u_cursor, 18, u_ordered_quantity);
474: DBMS_SQL.Define_Column(u_cursor, 19, u_cancelled_quantity);
475: DBMS_SQL.Define_Column(u_cursor, 20, u_l_inventory_item_id);
476: DBMS_SQL.Define_Column(u_cursor, 21, u_ld_inventory_item_id);
477: DBMS_SQL.Define_Column(u_cursor, 22, u_customer_item_id);
478: DBMS_SQL.Define_Column(u_cursor, 23, u_dep_plan_required_flag, 1);
479: DBMS_SQL.Define_Column(u_cursor, 24, u_shipment_schedule_line_id);

Line 476: DBMS_SQL.Define_Column(u_cursor, 21, u_ld_inventory_item_id);

472: DBMS_SQL.Define_Column(u_cursor, 17, u_schedule_date);
473: DBMS_SQL.Define_Column(u_cursor, 18, u_ordered_quantity);
474: DBMS_SQL.Define_Column(u_cursor, 19, u_cancelled_quantity);
475: DBMS_SQL.Define_Column(u_cursor, 20, u_l_inventory_item_id);
476: DBMS_SQL.Define_Column(u_cursor, 21, u_ld_inventory_item_id);
477: DBMS_SQL.Define_Column(u_cursor, 22, u_customer_item_id);
478: DBMS_SQL.Define_Column(u_cursor, 23, u_dep_plan_required_flag, 1);
479: DBMS_SQL.Define_Column(u_cursor, 24, u_shipment_schedule_line_id);
480: DBMS_SQL.Define_Column(u_cursor, 25, u_unit_code, 3);

Line 477: DBMS_SQL.Define_Column(u_cursor, 22, u_customer_item_id);

473: DBMS_SQL.Define_Column(u_cursor, 18, u_ordered_quantity);
474: DBMS_SQL.Define_Column(u_cursor, 19, u_cancelled_quantity);
475: DBMS_SQL.Define_Column(u_cursor, 20, u_l_inventory_item_id);
476: DBMS_SQL.Define_Column(u_cursor, 21, u_ld_inventory_item_id);
477: DBMS_SQL.Define_Column(u_cursor, 22, u_customer_item_id);
478: DBMS_SQL.Define_Column(u_cursor, 23, u_dep_plan_required_flag, 1);
479: DBMS_SQL.Define_Column(u_cursor, 24, u_shipment_schedule_line_id);
480: DBMS_SQL.Define_Column(u_cursor, 25, u_unit_code, 3);
481: DBMS_SQL.Define_Column(u_cursor, 26, u_line_type_code, 30);

Line 478: DBMS_SQL.Define_Column(u_cursor, 23, u_dep_plan_required_flag, 1);

474: DBMS_SQL.Define_Column(u_cursor, 19, u_cancelled_quantity);
475: DBMS_SQL.Define_Column(u_cursor, 20, u_l_inventory_item_id);
476: DBMS_SQL.Define_Column(u_cursor, 21, u_ld_inventory_item_id);
477: DBMS_SQL.Define_Column(u_cursor, 22, u_customer_item_id);
478: DBMS_SQL.Define_Column(u_cursor, 23, u_dep_plan_required_flag, 1);
479: DBMS_SQL.Define_Column(u_cursor, 24, u_shipment_schedule_line_id);
480: DBMS_SQL.Define_Column(u_cursor, 25, u_unit_code, 3);
481: DBMS_SQL.Define_Column(u_cursor, 26, u_line_type_code, 30);
482: DBMS_SQL.Define_Column(u_cursor, 27, u_component_code, 1000);

Line 479: DBMS_SQL.Define_Column(u_cursor, 24, u_shipment_schedule_line_id);

475: DBMS_SQL.Define_Column(u_cursor, 20, u_l_inventory_item_id);
476: DBMS_SQL.Define_Column(u_cursor, 21, u_ld_inventory_item_id);
477: DBMS_SQL.Define_Column(u_cursor, 22, u_customer_item_id);
478: DBMS_SQL.Define_Column(u_cursor, 23, u_dep_plan_required_flag, 1);
479: DBMS_SQL.Define_Column(u_cursor, 24, u_shipment_schedule_line_id);
480: DBMS_SQL.Define_Column(u_cursor, 25, u_unit_code, 3);
481: DBMS_SQL.Define_Column(u_cursor, 26, u_line_type_code, 30);
482: DBMS_SQL.Define_Column(u_cursor, 27, u_component_code, 1000);
483: DBMS_SQL.Define_Column(u_cursor, 28, u_standard_comp_freeze_date, 15);

Line 480: DBMS_SQL.Define_Column(u_cursor, 25, u_unit_code, 3);

476: DBMS_SQL.Define_Column(u_cursor, 21, u_ld_inventory_item_id);
477: DBMS_SQL.Define_Column(u_cursor, 22, u_customer_item_id);
478: DBMS_SQL.Define_Column(u_cursor, 23, u_dep_plan_required_flag, 1);
479: DBMS_SQL.Define_Column(u_cursor, 24, u_shipment_schedule_line_id);
480: DBMS_SQL.Define_Column(u_cursor, 25, u_unit_code, 3);
481: DBMS_SQL.Define_Column(u_cursor, 26, u_line_type_code, 30);
482: DBMS_SQL.Define_Column(u_cursor, 27, u_component_code, 1000);
483: DBMS_SQL.Define_Column(u_cursor, 28, u_standard_comp_freeze_date, 15);
484: DBMS_SQL.Define_Column(u_cursor, 29, u_order_number);

Line 481: DBMS_SQL.Define_Column(u_cursor, 26, u_line_type_code, 30);

477: DBMS_SQL.Define_Column(u_cursor, 22, u_customer_item_id);
478: DBMS_SQL.Define_Column(u_cursor, 23, u_dep_plan_required_flag, 1);
479: DBMS_SQL.Define_Column(u_cursor, 24, u_shipment_schedule_line_id);
480: DBMS_SQL.Define_Column(u_cursor, 25, u_unit_code, 3);
481: DBMS_SQL.Define_Column(u_cursor, 26, u_line_type_code, 30);
482: DBMS_SQL.Define_Column(u_cursor, 27, u_component_code, 1000);
483: DBMS_SQL.Define_Column(u_cursor, 28, u_standard_comp_freeze_date, 15);
484: DBMS_SQL.Define_Column(u_cursor, 29, u_order_number);
485: DBMS_SQL.Define_Column(u_cursor, 30, u_order_type_id);

Line 482: DBMS_SQL.Define_Column(u_cursor, 27, u_component_code, 1000);

478: DBMS_SQL.Define_Column(u_cursor, 23, u_dep_plan_required_flag, 1);
479: DBMS_SQL.Define_Column(u_cursor, 24, u_shipment_schedule_line_id);
480: DBMS_SQL.Define_Column(u_cursor, 25, u_unit_code, 3);
481: DBMS_SQL.Define_Column(u_cursor, 26, u_line_type_code, 30);
482: DBMS_SQL.Define_Column(u_cursor, 27, u_component_code, 1000);
483: DBMS_SQL.Define_Column(u_cursor, 28, u_standard_comp_freeze_date, 15);
484: DBMS_SQL.Define_Column(u_cursor, 29, u_order_number);
485: DBMS_SQL.Define_Column(u_cursor, 30, u_order_type_id);
486: DBMS_SQL.Define_Column(u_cursor, 31, u_customer_id);

Line 483: DBMS_SQL.Define_Column(u_cursor, 28, u_standard_comp_freeze_date, 15);

479: DBMS_SQL.Define_Column(u_cursor, 24, u_shipment_schedule_line_id);
480: DBMS_SQL.Define_Column(u_cursor, 25, u_unit_code, 3);
481: DBMS_SQL.Define_Column(u_cursor, 26, u_line_type_code, 30);
482: DBMS_SQL.Define_Column(u_cursor, 27, u_component_code, 1000);
483: DBMS_SQL.Define_Column(u_cursor, 28, u_standard_comp_freeze_date, 15);
484: DBMS_SQL.Define_Column(u_cursor, 29, u_order_number);
485: DBMS_SQL.Define_Column(u_cursor, 30, u_order_type_id);
486: DBMS_SQL.Define_Column(u_cursor, 31, u_customer_id);
487: DBMS_SQL.Define_Column(u_cursor, 32, u_invoice_to_site_use_id);

Line 484: DBMS_SQL.Define_Column(u_cursor, 29, u_order_number);

480: DBMS_SQL.Define_Column(u_cursor, 25, u_unit_code, 3);
481: DBMS_SQL.Define_Column(u_cursor, 26, u_line_type_code, 30);
482: DBMS_SQL.Define_Column(u_cursor, 27, u_component_code, 1000);
483: DBMS_SQL.Define_Column(u_cursor, 28, u_standard_comp_freeze_date, 15);
484: DBMS_SQL.Define_Column(u_cursor, 29, u_order_number);
485: DBMS_SQL.Define_Column(u_cursor, 30, u_order_type_id);
486: DBMS_SQL.Define_Column(u_cursor, 31, u_customer_id);
487: DBMS_SQL.Define_Column(u_cursor, 32, u_invoice_to_site_use_id);
488: DBMS_SQL.Define_Column(u_cursor, 33, u_planned_departure_date_d);

Line 485: DBMS_SQL.Define_Column(u_cursor, 30, u_order_type_id);

481: DBMS_SQL.Define_Column(u_cursor, 26, u_line_type_code, 30);
482: DBMS_SQL.Define_Column(u_cursor, 27, u_component_code, 1000);
483: DBMS_SQL.Define_Column(u_cursor, 28, u_standard_comp_freeze_date, 15);
484: DBMS_SQL.Define_Column(u_cursor, 29, u_order_number);
485: DBMS_SQL.Define_Column(u_cursor, 30, u_order_type_id);
486: DBMS_SQL.Define_Column(u_cursor, 31, u_customer_id);
487: DBMS_SQL.Define_Column(u_cursor, 32, u_invoice_to_site_use_id);
488: DBMS_SQL.Define_Column(u_cursor, 33, u_planned_departure_date_d);
489: DBMS_SQL.Define_Column(u_cursor, 34, u_planned_departure_date_t);

Line 486: DBMS_SQL.Define_Column(u_cursor, 31, u_customer_id);

482: DBMS_SQL.Define_Column(u_cursor, 27, u_component_code, 1000);
483: DBMS_SQL.Define_Column(u_cursor, 28, u_standard_comp_freeze_date, 15);
484: DBMS_SQL.Define_Column(u_cursor, 29, u_order_number);
485: DBMS_SQL.Define_Column(u_cursor, 30, u_order_type_id);
486: DBMS_SQL.Define_Column(u_cursor, 31, u_customer_id);
487: DBMS_SQL.Define_Column(u_cursor, 32, u_invoice_to_site_use_id);
488: DBMS_SQL.Define_Column(u_cursor, 33, u_planned_departure_date_d);
489: DBMS_SQL.Define_Column(u_cursor, 34, u_planned_departure_date_t);
490: DBMS_SQL.Define_Column(u_cursor, 35, u_master_container_id);

Line 487: DBMS_SQL.Define_Column(u_cursor, 32, u_invoice_to_site_use_id);

483: DBMS_SQL.Define_Column(u_cursor, 28, u_standard_comp_freeze_date, 15);
484: DBMS_SQL.Define_Column(u_cursor, 29, u_order_number);
485: DBMS_SQL.Define_Column(u_cursor, 30, u_order_type_id);
486: DBMS_SQL.Define_Column(u_cursor, 31, u_customer_id);
487: DBMS_SQL.Define_Column(u_cursor, 32, u_invoice_to_site_use_id);
488: DBMS_SQL.Define_Column(u_cursor, 33, u_planned_departure_date_d);
489: DBMS_SQL.Define_Column(u_cursor, 34, u_planned_departure_date_t);
490: DBMS_SQL.Define_Column(u_cursor, 35, u_master_container_id);
491: DBMS_SQL.Define_Column(u_cursor, 36, u_detail_container_id);

Line 488: DBMS_SQL.Define_Column(u_cursor, 33, u_planned_departure_date_d);

484: DBMS_SQL.Define_Column(u_cursor, 29, u_order_number);
485: DBMS_SQL.Define_Column(u_cursor, 30, u_order_type_id);
486: DBMS_SQL.Define_Column(u_cursor, 31, u_customer_id);
487: DBMS_SQL.Define_Column(u_cursor, 32, u_invoice_to_site_use_id);
488: DBMS_SQL.Define_Column(u_cursor, 33, u_planned_departure_date_d);
489: DBMS_SQL.Define_Column(u_cursor, 34, u_planned_departure_date_t);
490: DBMS_SQL.Define_Column(u_cursor, 35, u_master_container_id);
491: DBMS_SQL.Define_Column(u_cursor, 36, u_detail_container_id);
492: DBMS_SQL.Define_Column(u_cursor, 37, u_load_seq_number);

Line 489: DBMS_SQL.Define_Column(u_cursor, 34, u_planned_departure_date_t);

485: DBMS_SQL.Define_Column(u_cursor, 30, u_order_type_id);
486: DBMS_SQL.Define_Column(u_cursor, 31, u_customer_id);
487: DBMS_SQL.Define_Column(u_cursor, 32, u_invoice_to_site_use_id);
488: DBMS_SQL.Define_Column(u_cursor, 33, u_planned_departure_date_d);
489: DBMS_SQL.Define_Column(u_cursor, 34, u_planned_departure_date_t);
490: DBMS_SQL.Define_Column(u_cursor, 35, u_master_container_id);
491: DBMS_SQL.Define_Column(u_cursor, 36, u_detail_container_id);
492: DBMS_SQL.Define_Column(u_cursor, 37, u_load_seq_number);
493: DBMS_SQL.Define_Column(u_cursor, 38, u_invoice_value);

Line 490: DBMS_SQL.Define_Column(u_cursor, 35, u_master_container_id);

486: DBMS_SQL.Define_Column(u_cursor, 31, u_customer_id);
487: DBMS_SQL.Define_Column(u_cursor, 32, u_invoice_to_site_use_id);
488: DBMS_SQL.Define_Column(u_cursor, 33, u_planned_departure_date_d);
489: DBMS_SQL.Define_Column(u_cursor, 34, u_planned_departure_date_t);
490: DBMS_SQL.Define_Column(u_cursor, 35, u_master_container_id);
491: DBMS_SQL.Define_Column(u_cursor, 36, u_detail_container_id);
492: DBMS_SQL.Define_Column(u_cursor, 37, u_load_seq_number);
493: DBMS_SQL.Define_Column(u_cursor, 38, u_invoice_value);
494:

Line 491: DBMS_SQL.Define_Column(u_cursor, 36, u_detail_container_id);

487: DBMS_SQL.Define_Column(u_cursor, 32, u_invoice_to_site_use_id);
488: DBMS_SQL.Define_Column(u_cursor, 33, u_planned_departure_date_d);
489: DBMS_SQL.Define_Column(u_cursor, 34, u_planned_departure_date_t);
490: DBMS_SQL.Define_Column(u_cursor, 35, u_master_container_id);
491: DBMS_SQL.Define_Column(u_cursor, 36, u_detail_container_id);
492: DBMS_SQL.Define_Column(u_cursor, 37, u_load_seq_number);
493: DBMS_SQL.Define_Column(u_cursor, 38, u_invoice_value);
494:
495:

Line 492: DBMS_SQL.Define_Column(u_cursor, 37, u_load_seq_number);

488: DBMS_SQL.Define_Column(u_cursor, 33, u_planned_departure_date_d);
489: DBMS_SQL.Define_Column(u_cursor, 34, u_planned_departure_date_t);
490: DBMS_SQL.Define_Column(u_cursor, 35, u_master_container_id);
491: DBMS_SQL.Define_Column(u_cursor, 36, u_detail_container_id);
492: DBMS_SQL.Define_Column(u_cursor, 37, u_load_seq_number);
493: DBMS_SQL.Define_Column(u_cursor, 38, u_invoice_value);
494:
495:
496: -- Bind release criteria values

Line 493: DBMS_SQL.Define_Column(u_cursor, 38, u_invoice_value);

489: DBMS_SQL.Define_Column(u_cursor, 34, u_planned_departure_date_t);
490: DBMS_SQL.Define_Column(u_cursor, 35, u_master_container_id);
491: DBMS_SQL.Define_Column(u_cursor, 36, u_detail_container_id);
492: DBMS_SQL.Define_Column(u_cursor, 37, u_load_seq_number);
493: DBMS_SQL.Define_Column(u_cursor, 38, u_invoice_value);
494:
495:
496: -- Bind release criteria values
497: WSH_UTIL.Write_Log('Binding unreleased cursor');

Line 501: DBMS_SQL.Bind_Variable(u_cursor, ':X_header_id',

497: WSH_UTIL.Write_Log('Binding unreleased cursor');
498:
499: IF (wsh_pr_picking_session.header_id <> 0) THEN
500: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
501: DBMS_SQL.Bind_Variable(u_cursor, ':X_header_id',
502: wsh_pr_picking_session.header_id);
503: END IF;
504: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
505: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_type_id',

Line 505: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_type_id',

501: DBMS_SQL.Bind_Variable(u_cursor, ':X_header_id',
502: wsh_pr_picking_session.header_id);
503: END IF;
504: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
505: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_type_id',
506: wsh_pr_picking_session.order_type_id);
507: IF (wsh_pr_picking_session.customer_id <> 0) THEN
508: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
509: DBMS_SQL.Bind_Variable(u_cursor, ':X_customer_id',

Line 509: DBMS_SQL.Bind_Variable(u_cursor, ':X_customer_id',

505: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_type_id',
506: wsh_pr_picking_session.order_type_id);
507: IF (wsh_pr_picking_session.customer_id <> 0) THEN
508: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
509: DBMS_SQL.Bind_Variable(u_cursor, ':X_customer_id',
510: wsh_pr_picking_session.customer_id);
511: END IF;
512:
513: IF (wsh_pr_picking_session.order_line_id <> 0) THEN

Line 515: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_line_id',

511: END IF;
512:
513: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
514: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));
515: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_line_id',
516: wsh_pr_picking_session.order_line_id);
517: END IF;
518:
519: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));

Line 520: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_set_number',

516: wsh_pr_picking_session.order_line_id);
517: END IF;
518:
519: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
520: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_set_number',
521: wsh_pr_picking_session.ship_set_number);
522: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
523: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_site_use_id',
524: wsh_pr_picking_session.ship_site_use_id);

Line 523: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_site_use_id',

519: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
520: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_set_number',
521: wsh_pr_picking_session.ship_set_number);
522: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
523: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_site_use_id',
524: wsh_pr_picking_session.ship_site_use_id);
525: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
526: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_method_code',
527: wsh_pr_picking_session.ship_method_code);

Line 526: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_method_code',

522: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
523: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_site_use_id',
524: wsh_pr_picking_session.ship_site_use_id);
525: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
526: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_method_code',
527: wsh_pr_picking_session.ship_method_code);
528: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
529: DBMS_SQL.Bind_Variable(u_cursor, ':X_warehouse_id',
530: wsh_pr_picking_session.warehouse_id);

Line 529: DBMS_SQL.Bind_Variable(u_cursor, ':X_warehouse_id',

525: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
526: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_method_code',
527: wsh_pr_picking_session.ship_method_code);
528: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
529: DBMS_SQL.Bind_Variable(u_cursor, ':X_warehouse_id',
530: wsh_pr_picking_session.warehouse_id);
531: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
532: DBMS_SQL.Bind_Variable(u_cursor, ':X_subinventory',
533: wsh_pr_picking_session.subinventory);

Line 532: DBMS_SQL.Bind_Variable(u_cursor, ':X_subinventory',

528: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
529: DBMS_SQL.Bind_Variable(u_cursor, ':X_warehouse_id',
530: wsh_pr_picking_session.warehouse_id);
531: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
532: DBMS_SQL.Bind_Variable(u_cursor, ':X_subinventory',
533: wsh_pr_picking_session.subinventory);
534: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
535: DBMS_SQL.Bind_Variable(u_cursor, ':X_shipment_priority',
536: wsh_pr_picking_session.shipment_priority);

Line 535: DBMS_SQL.Bind_Variable(u_cursor, ':X_shipment_priority',

531: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
532: DBMS_SQL.Bind_Variable(u_cursor, ':X_subinventory',
533: wsh_pr_picking_session.subinventory);
534: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
535: DBMS_SQL.Bind_Variable(u_cursor, ':X_shipment_priority',
536: wsh_pr_picking_session.shipment_priority);
537: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
538: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_request_date',
539: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 538: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_request_date',

534: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
535: DBMS_SQL.Bind_Variable(u_cursor, ':X_shipment_priority',
536: wsh_pr_picking_session.shipment_priority);
537: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
538: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_request_date',
539: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
540: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
541: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_request_date',
542: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 541: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_request_date',

537: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
538: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_request_date',
539: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
540: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
541: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_request_date',
542: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
543: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
544: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_sched_ship_date',
545: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 544: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_sched_ship_date',

540: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
541: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_request_date',
542: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
543: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
544: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_sched_ship_date',
545: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
546: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
547: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_sched_ship_date',
548: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 547: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_sched_ship_date',

543: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
544: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_sched_ship_date',
545: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
546: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
547: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_sched_ship_date',
548: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
549: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
550: DBMS_SQL.Bind_Variable(u_cursor, ':X_existing_rsvs_only_flag',
551: wsh_pr_picking_session.existing_rsvs_only_flag);

Line 550: DBMS_SQL.Bind_Variable(u_cursor, ':X_existing_rsvs_only_flag',

546: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
547: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_sched_ship_date',
548: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
549: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
550: DBMS_SQL.Bind_Variable(u_cursor, ':X_existing_rsvs_only_flag',
551: wsh_pr_picking_session.existing_rsvs_only_flag);
552: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
553: DBMS_SQL.Bind_Variable(u_cursor, ':X_inventory_item_id',
554: wsh_pr_picking_session.inventory_item_id);

Line 553: DBMS_SQL.Bind_Variable(u_cursor, ':X_inventory_item_id',

549: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
550: DBMS_SQL.Bind_Variable(u_cursor, ':X_existing_rsvs_only_flag',
551: wsh_pr_picking_session.existing_rsvs_only_flag);
552: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
553: DBMS_SQL.Bind_Variable(u_cursor, ':X_inventory_item_id',
554: wsh_pr_picking_session.inventory_item_id);
555: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
556: DBMS_SQL.Bind_Variable(u_cursor, ':X_reservations',
557: wsh_pr_picking_session.reservations);

Line 556: DBMS_SQL.Bind_Variable(u_cursor, ':X_reservations',

552: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
553: DBMS_SQL.Bind_Variable(u_cursor, ':X_inventory_item_id',
554: wsh_pr_picking_session.inventory_item_id);
555: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
556: DBMS_SQL.Bind_Variable(u_cursor, ':X_reservations',
557: wsh_pr_picking_session.reservations);
558: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
559: DBMS_SQL.Bind_Variable(u_cursor, ':X_departure_id',
560: wsh_pr_picking_session.departure_id);

Line 559: DBMS_SQL.Bind_Variable(u_cursor, ':X_departure_id',

555: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
556: DBMS_SQL.Bind_Variable(u_cursor, ':X_reservations',
557: wsh_pr_picking_session.reservations);
558: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
559: DBMS_SQL.Bind_Variable(u_cursor, ':X_departure_id',
560: wsh_pr_picking_session.departure_id);
561: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
562: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
563: DBMS_SQL.Bind_Variable(u_cursor, ':X_delivery_id',

Line 563: DBMS_SQL.Bind_Variable(u_cursor, ':X_delivery_id',

559: DBMS_SQL.Bind_Variable(u_cursor, ':X_departure_id',
560: wsh_pr_picking_session.departure_id);
561: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
562: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
563: DBMS_SQL.Bind_Variable(u_cursor, ':X_delivery_id',
564: wsh_pr_picking_session.delivery_id);
565: END IF;
566: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
567: DBMS_SQL.Bind_Variable(u_cursor, ':X_include_planned_lines',

Line 567: DBMS_SQL.Bind_Variable(u_cursor, ':X_include_planned_lines',

563: DBMS_SQL.Bind_Variable(u_cursor, ':X_delivery_id',
564: wsh_pr_picking_session.delivery_id);
565: END IF;
566: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
567: DBMS_SQL.Bind_Variable(u_cursor, ':X_include_planned_lines',
568: wsh_pr_picking_session.include_planned_lines);
569:
570: -- Execute the cursor
571: WSH_UTIL.Write_Log('Executing unreleased cursor');

Line 572: v_ignore := DBMS_SQL.Execute(u_cursor);

568: wsh_pr_picking_session.include_planned_lines);
569:
570: -- Execute the cursor
571: WSH_UTIL.Write_Log('Executing unreleased cursor');
572: v_ignore := DBMS_SQL.Execute(u_cursor);
573:
574: ELSIF p_mode= 'BACKORDERED' THEN
575: -- Open a cursor for backordered_SQL
576: WSH_UTIL.Write_Log('Processing backordered cursor');

Line 577: b_cursor := DBMS_SQL.Open_Cursor;

573:
574: ELSIF p_mode= 'BACKORDERED' THEN
575: -- Open a cursor for backordered_SQL
576: WSH_UTIL.Write_Log('Processing backordered cursor');
577: b_cursor := DBMS_SQL.Open_Cursor;
578:
579: -- Parse the cursor
580: WSH_UTIL.Write_Log('Parsing backordered cursor');
581: DBMS_SQL.Parse(b_cursor, backordered_SQL, DBMS_SQL.v7);

Line 581: DBMS_SQL.Parse(b_cursor, backordered_SQL, DBMS_SQL.v7);

577: b_cursor := DBMS_SQL.Open_Cursor;
578:
579: -- Parse the cursor
580: WSH_UTIL.Write_Log('Parsing backordered cursor');
581: DBMS_SQL.Parse(b_cursor, backordered_SQL, DBMS_SQL.v7);
582:
583: -- Identify the column numbers with variable
584: WSH_UTIL.Write_Log('Column definition for backordered cursor');
585: DBMS_SQL.Define_Column(b_cursor, 1, b_line_id);

Line 585: DBMS_SQL.Define_Column(b_cursor, 1, b_line_id);

581: DBMS_SQL.Parse(b_cursor, backordered_SQL, DBMS_SQL.v7);
582:
583: -- Identify the column numbers with variable
584: WSH_UTIL.Write_Log('Column definition for backordered cursor');
585: DBMS_SQL.Define_Column(b_cursor, 1, b_line_id);
586: DBMS_SQL.Define_Column(b_cursor, 2, b_header_id);
587: DBMS_SQL.Define_Column(b_cursor, 3, b_org_id);
588: DBMS_SQL.Define_Column(b_cursor, 4, b_ato_flag, 1);
589: DBMS_SQL.Define_Column(b_cursor, 5, b_line_detail_id);

Line 586: DBMS_SQL.Define_Column(b_cursor, 2, b_header_id);

582:
583: -- Identify the column numbers with variable
584: WSH_UTIL.Write_Log('Column definition for backordered cursor');
585: DBMS_SQL.Define_Column(b_cursor, 1, b_line_id);
586: DBMS_SQL.Define_Column(b_cursor, 2, b_header_id);
587: DBMS_SQL.Define_Column(b_cursor, 3, b_org_id);
588: DBMS_SQL.Define_Column(b_cursor, 4, b_ato_flag, 1);
589: DBMS_SQL.Define_Column(b_cursor, 5, b_line_detail_id);
590: DBMS_SQL.Define_Column(b_cursor, 6, b_ship_model_complete, 1);

Line 587: DBMS_SQL.Define_Column(b_cursor, 3, b_org_id);

583: -- Identify the column numbers with variable
584: WSH_UTIL.Write_Log('Column definition for backordered cursor');
585: DBMS_SQL.Define_Column(b_cursor, 1, b_line_id);
586: DBMS_SQL.Define_Column(b_cursor, 2, b_header_id);
587: DBMS_SQL.Define_Column(b_cursor, 3, b_org_id);
588: DBMS_SQL.Define_Column(b_cursor, 4, b_ato_flag, 1);
589: DBMS_SQL.Define_Column(b_cursor, 5, b_line_detail_id);
590: DBMS_SQL.Define_Column(b_cursor, 6, b_ship_model_complete, 1);
591: DBMS_SQL.Define_Column(b_cursor, 7, b_ship_set_number);

Line 588: DBMS_SQL.Define_Column(b_cursor, 4, b_ato_flag, 1);

584: WSH_UTIL.Write_Log('Column definition for backordered cursor');
585: DBMS_SQL.Define_Column(b_cursor, 1, b_line_id);
586: DBMS_SQL.Define_Column(b_cursor, 2, b_header_id);
587: DBMS_SQL.Define_Column(b_cursor, 3, b_org_id);
588: DBMS_SQL.Define_Column(b_cursor, 4, b_ato_flag, 1);
589: DBMS_SQL.Define_Column(b_cursor, 5, b_line_detail_id);
590: DBMS_SQL.Define_Column(b_cursor, 6, b_ship_model_complete, 1);
591: DBMS_SQL.Define_Column(b_cursor, 7, b_ship_set_number);
592: DBMS_SQL.Define_Column(b_cursor, 8, b_parent_line_id);

Line 589: DBMS_SQL.Define_Column(b_cursor, 5, b_line_detail_id);

585: DBMS_SQL.Define_Column(b_cursor, 1, b_line_id);
586: DBMS_SQL.Define_Column(b_cursor, 2, b_header_id);
587: DBMS_SQL.Define_Column(b_cursor, 3, b_org_id);
588: DBMS_SQL.Define_Column(b_cursor, 4, b_ato_flag, 1);
589: DBMS_SQL.Define_Column(b_cursor, 5, b_line_detail_id);
590: DBMS_SQL.Define_Column(b_cursor, 6, b_ship_model_complete, 1);
591: DBMS_SQL.Define_Column(b_cursor, 7, b_ship_set_number);
592: DBMS_SQL.Define_Column(b_cursor, 8, b_parent_line_id);
593: DBMS_SQL.Define_Column(b_cursor, 9, b_ld_warehouse_id);

Line 590: DBMS_SQL.Define_Column(b_cursor, 6, b_ship_model_complete, 1);

586: DBMS_SQL.Define_Column(b_cursor, 2, b_header_id);
587: DBMS_SQL.Define_Column(b_cursor, 3, b_org_id);
588: DBMS_SQL.Define_Column(b_cursor, 4, b_ato_flag, 1);
589: DBMS_SQL.Define_Column(b_cursor, 5, b_line_detail_id);
590: DBMS_SQL.Define_Column(b_cursor, 6, b_ship_model_complete, 1);
591: DBMS_SQL.Define_Column(b_cursor, 7, b_ship_set_number);
592: DBMS_SQL.Define_Column(b_cursor, 8, b_parent_line_id);
593: DBMS_SQL.Define_Column(b_cursor, 9, b_ld_warehouse_id);
594: DBMS_SQL.Define_Column(b_cursor, 10, b_ship_to_site_use_id);

Line 591: DBMS_SQL.Define_Column(b_cursor, 7, b_ship_set_number);

587: DBMS_SQL.Define_Column(b_cursor, 3, b_org_id);
588: DBMS_SQL.Define_Column(b_cursor, 4, b_ato_flag, 1);
589: DBMS_SQL.Define_Column(b_cursor, 5, b_line_detail_id);
590: DBMS_SQL.Define_Column(b_cursor, 6, b_ship_model_complete, 1);
591: DBMS_SQL.Define_Column(b_cursor, 7, b_ship_set_number);
592: DBMS_SQL.Define_Column(b_cursor, 8, b_parent_line_id);
593: DBMS_SQL.Define_Column(b_cursor, 9, b_ld_warehouse_id);
594: DBMS_SQL.Define_Column(b_cursor, 10, b_ship_to_site_use_id);
595: DBMS_SQL.Define_Column(b_cursor, 11, b_ship_to_contact_id);

Line 592: DBMS_SQL.Define_Column(b_cursor, 8, b_parent_line_id);

588: DBMS_SQL.Define_Column(b_cursor, 4, b_ato_flag, 1);
589: DBMS_SQL.Define_Column(b_cursor, 5, b_line_detail_id);
590: DBMS_SQL.Define_Column(b_cursor, 6, b_ship_model_complete, 1);
591: DBMS_SQL.Define_Column(b_cursor, 7, b_ship_set_number);
592: DBMS_SQL.Define_Column(b_cursor, 8, b_parent_line_id);
593: DBMS_SQL.Define_Column(b_cursor, 9, b_ld_warehouse_id);
594: DBMS_SQL.Define_Column(b_cursor, 10, b_ship_to_site_use_id);
595: DBMS_SQL.Define_Column(b_cursor, 11, b_ship_to_contact_id);
596: DBMS_SQL.Define_Column(b_cursor, 12, b_ship_method_code, 30);

Line 593: DBMS_SQL.Define_Column(b_cursor, 9, b_ld_warehouse_id);

589: DBMS_SQL.Define_Column(b_cursor, 5, b_line_detail_id);
590: DBMS_SQL.Define_Column(b_cursor, 6, b_ship_model_complete, 1);
591: DBMS_SQL.Define_Column(b_cursor, 7, b_ship_set_number);
592: DBMS_SQL.Define_Column(b_cursor, 8, b_parent_line_id);
593: DBMS_SQL.Define_Column(b_cursor, 9, b_ld_warehouse_id);
594: DBMS_SQL.Define_Column(b_cursor, 10, b_ship_to_site_use_id);
595: DBMS_SQL.Define_Column(b_cursor, 11, b_ship_to_contact_id);
596: DBMS_SQL.Define_Column(b_cursor, 12, b_ship_method_code, 30);
597: DBMS_SQL.Define_Column(b_cursor, 13, b_shipment_priority, 30);

Line 594: DBMS_SQL.Define_Column(b_cursor, 10, b_ship_to_site_use_id);

590: DBMS_SQL.Define_Column(b_cursor, 6, b_ship_model_complete, 1);
591: DBMS_SQL.Define_Column(b_cursor, 7, b_ship_set_number);
592: DBMS_SQL.Define_Column(b_cursor, 8, b_parent_line_id);
593: DBMS_SQL.Define_Column(b_cursor, 9, b_ld_warehouse_id);
594: DBMS_SQL.Define_Column(b_cursor, 10, b_ship_to_site_use_id);
595: DBMS_SQL.Define_Column(b_cursor, 11, b_ship_to_contact_id);
596: DBMS_SQL.Define_Column(b_cursor, 12, b_ship_method_code, 30);
597: DBMS_SQL.Define_Column(b_cursor, 13, b_shipment_priority, 30);
598: DBMS_SQL.Define_Column(b_cursor, 14, b_departure_id);

Line 595: DBMS_SQL.Define_Column(b_cursor, 11, b_ship_to_contact_id);

591: DBMS_SQL.Define_Column(b_cursor, 7, b_ship_set_number);
592: DBMS_SQL.Define_Column(b_cursor, 8, b_parent_line_id);
593: DBMS_SQL.Define_Column(b_cursor, 9, b_ld_warehouse_id);
594: DBMS_SQL.Define_Column(b_cursor, 10, b_ship_to_site_use_id);
595: DBMS_SQL.Define_Column(b_cursor, 11, b_ship_to_contact_id);
596: DBMS_SQL.Define_Column(b_cursor, 12, b_ship_method_code, 30);
597: DBMS_SQL.Define_Column(b_cursor, 13, b_shipment_priority, 30);
598: DBMS_SQL.Define_Column(b_cursor, 14, b_departure_id);
599: DBMS_SQL.Define_Column(b_cursor, 15, b_delivery_id);

Line 596: DBMS_SQL.Define_Column(b_cursor, 12, b_ship_method_code, 30);

592: DBMS_SQL.Define_Column(b_cursor, 8, b_parent_line_id);
593: DBMS_SQL.Define_Column(b_cursor, 9, b_ld_warehouse_id);
594: DBMS_SQL.Define_Column(b_cursor, 10, b_ship_to_site_use_id);
595: DBMS_SQL.Define_Column(b_cursor, 11, b_ship_to_contact_id);
596: DBMS_SQL.Define_Column(b_cursor, 12, b_ship_method_code, 30);
597: DBMS_SQL.Define_Column(b_cursor, 13, b_shipment_priority, 30);
598: DBMS_SQL.Define_Column(b_cursor, 14, b_departure_id);
599: DBMS_SQL.Define_Column(b_cursor, 15, b_delivery_id);
600: DBMS_SQL.Define_Column(b_cursor, 16, b_item_type_code, 30);

Line 597: DBMS_SQL.Define_Column(b_cursor, 13, b_shipment_priority, 30);

593: DBMS_SQL.Define_Column(b_cursor, 9, b_ld_warehouse_id);
594: DBMS_SQL.Define_Column(b_cursor, 10, b_ship_to_site_use_id);
595: DBMS_SQL.Define_Column(b_cursor, 11, b_ship_to_contact_id);
596: DBMS_SQL.Define_Column(b_cursor, 12, b_ship_method_code, 30);
597: DBMS_SQL.Define_Column(b_cursor, 13, b_shipment_priority, 30);
598: DBMS_SQL.Define_Column(b_cursor, 14, b_departure_id);
599: DBMS_SQL.Define_Column(b_cursor, 15, b_delivery_id);
600: DBMS_SQL.Define_Column(b_cursor, 16, b_item_type_code, 30);
601: DBMS_SQL.Define_Column(b_cursor, 17, b_schedule_date);

Line 598: DBMS_SQL.Define_Column(b_cursor, 14, b_departure_id);

594: DBMS_SQL.Define_Column(b_cursor, 10, b_ship_to_site_use_id);
595: DBMS_SQL.Define_Column(b_cursor, 11, b_ship_to_contact_id);
596: DBMS_SQL.Define_Column(b_cursor, 12, b_ship_method_code, 30);
597: DBMS_SQL.Define_Column(b_cursor, 13, b_shipment_priority, 30);
598: DBMS_SQL.Define_Column(b_cursor, 14, b_departure_id);
599: DBMS_SQL.Define_Column(b_cursor, 15, b_delivery_id);
600: DBMS_SQL.Define_Column(b_cursor, 16, b_item_type_code, 30);
601: DBMS_SQL.Define_Column(b_cursor, 17, b_schedule_date);
602: DBMS_SQL.Define_Column(b_cursor, 18, b_ordered_quantity);

Line 599: DBMS_SQL.Define_Column(b_cursor, 15, b_delivery_id);

595: DBMS_SQL.Define_Column(b_cursor, 11, b_ship_to_contact_id);
596: DBMS_SQL.Define_Column(b_cursor, 12, b_ship_method_code, 30);
597: DBMS_SQL.Define_Column(b_cursor, 13, b_shipment_priority, 30);
598: DBMS_SQL.Define_Column(b_cursor, 14, b_departure_id);
599: DBMS_SQL.Define_Column(b_cursor, 15, b_delivery_id);
600: DBMS_SQL.Define_Column(b_cursor, 16, b_item_type_code, 30);
601: DBMS_SQL.Define_Column(b_cursor, 17, b_schedule_date);
602: DBMS_SQL.Define_Column(b_cursor, 18, b_ordered_quantity);
603: DBMS_SQL.Define_Column(b_cursor, 19, b_cancelled_quantity);

Line 600: DBMS_SQL.Define_Column(b_cursor, 16, b_item_type_code, 30);

596: DBMS_SQL.Define_Column(b_cursor, 12, b_ship_method_code, 30);
597: DBMS_SQL.Define_Column(b_cursor, 13, b_shipment_priority, 30);
598: DBMS_SQL.Define_Column(b_cursor, 14, b_departure_id);
599: DBMS_SQL.Define_Column(b_cursor, 15, b_delivery_id);
600: DBMS_SQL.Define_Column(b_cursor, 16, b_item_type_code, 30);
601: DBMS_SQL.Define_Column(b_cursor, 17, b_schedule_date);
602: DBMS_SQL.Define_Column(b_cursor, 18, b_ordered_quantity);
603: DBMS_SQL.Define_Column(b_cursor, 19, b_cancelled_quantity);
604: DBMS_SQL.Define_Column(b_cursor, 20, b_l_inventory_item_id);

Line 601: DBMS_SQL.Define_Column(b_cursor, 17, b_schedule_date);

597: DBMS_SQL.Define_Column(b_cursor, 13, b_shipment_priority, 30);
598: DBMS_SQL.Define_Column(b_cursor, 14, b_departure_id);
599: DBMS_SQL.Define_Column(b_cursor, 15, b_delivery_id);
600: DBMS_SQL.Define_Column(b_cursor, 16, b_item_type_code, 30);
601: DBMS_SQL.Define_Column(b_cursor, 17, b_schedule_date);
602: DBMS_SQL.Define_Column(b_cursor, 18, b_ordered_quantity);
603: DBMS_SQL.Define_Column(b_cursor, 19, b_cancelled_quantity);
604: DBMS_SQL.Define_Column(b_cursor, 20, b_l_inventory_item_id);
605: DBMS_SQL.Define_Column(b_cursor, 21, b_ld_inventory_item_id);

Line 602: DBMS_SQL.Define_Column(b_cursor, 18, b_ordered_quantity);

598: DBMS_SQL.Define_Column(b_cursor, 14, b_departure_id);
599: DBMS_SQL.Define_Column(b_cursor, 15, b_delivery_id);
600: DBMS_SQL.Define_Column(b_cursor, 16, b_item_type_code, 30);
601: DBMS_SQL.Define_Column(b_cursor, 17, b_schedule_date);
602: DBMS_SQL.Define_Column(b_cursor, 18, b_ordered_quantity);
603: DBMS_SQL.Define_Column(b_cursor, 19, b_cancelled_quantity);
604: DBMS_SQL.Define_Column(b_cursor, 20, b_l_inventory_item_id);
605: DBMS_SQL.Define_Column(b_cursor, 21, b_ld_inventory_item_id);
606: DBMS_SQL.Define_Column(b_cursor, 22, b_customer_item_id);

Line 603: DBMS_SQL.Define_Column(b_cursor, 19, b_cancelled_quantity);

599: DBMS_SQL.Define_Column(b_cursor, 15, b_delivery_id);
600: DBMS_SQL.Define_Column(b_cursor, 16, b_item_type_code, 30);
601: DBMS_SQL.Define_Column(b_cursor, 17, b_schedule_date);
602: DBMS_SQL.Define_Column(b_cursor, 18, b_ordered_quantity);
603: DBMS_SQL.Define_Column(b_cursor, 19, b_cancelled_quantity);
604: DBMS_SQL.Define_Column(b_cursor, 20, b_l_inventory_item_id);
605: DBMS_SQL.Define_Column(b_cursor, 21, b_ld_inventory_item_id);
606: DBMS_SQL.Define_Column(b_cursor, 22, b_customer_item_id);
607: DBMS_SQL.Define_Column(b_cursor, 23, b_dep_plan_required_flag, 1);

Line 604: DBMS_SQL.Define_Column(b_cursor, 20, b_l_inventory_item_id);

600: DBMS_SQL.Define_Column(b_cursor, 16, b_item_type_code, 30);
601: DBMS_SQL.Define_Column(b_cursor, 17, b_schedule_date);
602: DBMS_SQL.Define_Column(b_cursor, 18, b_ordered_quantity);
603: DBMS_SQL.Define_Column(b_cursor, 19, b_cancelled_quantity);
604: DBMS_SQL.Define_Column(b_cursor, 20, b_l_inventory_item_id);
605: DBMS_SQL.Define_Column(b_cursor, 21, b_ld_inventory_item_id);
606: DBMS_SQL.Define_Column(b_cursor, 22, b_customer_item_id);
607: DBMS_SQL.Define_Column(b_cursor, 23, b_dep_plan_required_flag, 1);
608: DBMS_SQL.Define_Column(b_cursor, 24, b_shipment_schedule_line_id);

Line 605: DBMS_SQL.Define_Column(b_cursor, 21, b_ld_inventory_item_id);

601: DBMS_SQL.Define_Column(b_cursor, 17, b_schedule_date);
602: DBMS_SQL.Define_Column(b_cursor, 18, b_ordered_quantity);
603: DBMS_SQL.Define_Column(b_cursor, 19, b_cancelled_quantity);
604: DBMS_SQL.Define_Column(b_cursor, 20, b_l_inventory_item_id);
605: DBMS_SQL.Define_Column(b_cursor, 21, b_ld_inventory_item_id);
606: DBMS_SQL.Define_Column(b_cursor, 22, b_customer_item_id);
607: DBMS_SQL.Define_Column(b_cursor, 23, b_dep_plan_required_flag, 1);
608: DBMS_SQL.Define_Column(b_cursor, 24, b_shipment_schedule_line_id);
609: DBMS_SQL.Define_Column(b_cursor, 25, b_unit_code, 3);

Line 606: DBMS_SQL.Define_Column(b_cursor, 22, b_customer_item_id);

602: DBMS_SQL.Define_Column(b_cursor, 18, b_ordered_quantity);
603: DBMS_SQL.Define_Column(b_cursor, 19, b_cancelled_quantity);
604: DBMS_SQL.Define_Column(b_cursor, 20, b_l_inventory_item_id);
605: DBMS_SQL.Define_Column(b_cursor, 21, b_ld_inventory_item_id);
606: DBMS_SQL.Define_Column(b_cursor, 22, b_customer_item_id);
607: DBMS_SQL.Define_Column(b_cursor, 23, b_dep_plan_required_flag, 1);
608: DBMS_SQL.Define_Column(b_cursor, 24, b_shipment_schedule_line_id);
609: DBMS_SQL.Define_Column(b_cursor, 25, b_unit_code, 3);
610: DBMS_SQL.Define_Column(b_cursor, 26, b_line_type_code, 30);

Line 607: DBMS_SQL.Define_Column(b_cursor, 23, b_dep_plan_required_flag, 1);

603: DBMS_SQL.Define_Column(b_cursor, 19, b_cancelled_quantity);
604: DBMS_SQL.Define_Column(b_cursor, 20, b_l_inventory_item_id);
605: DBMS_SQL.Define_Column(b_cursor, 21, b_ld_inventory_item_id);
606: DBMS_SQL.Define_Column(b_cursor, 22, b_customer_item_id);
607: DBMS_SQL.Define_Column(b_cursor, 23, b_dep_plan_required_flag, 1);
608: DBMS_SQL.Define_Column(b_cursor, 24, b_shipment_schedule_line_id);
609: DBMS_SQL.Define_Column(b_cursor, 25, b_unit_code, 3);
610: DBMS_SQL.Define_Column(b_cursor, 26, b_line_type_code, 30);
611: DBMS_SQL.Define_Column(b_cursor, 27, b_component_code, 1000);

Line 608: DBMS_SQL.Define_Column(b_cursor, 24, b_shipment_schedule_line_id);

604: DBMS_SQL.Define_Column(b_cursor, 20, b_l_inventory_item_id);
605: DBMS_SQL.Define_Column(b_cursor, 21, b_ld_inventory_item_id);
606: DBMS_SQL.Define_Column(b_cursor, 22, b_customer_item_id);
607: DBMS_SQL.Define_Column(b_cursor, 23, b_dep_plan_required_flag, 1);
608: DBMS_SQL.Define_Column(b_cursor, 24, b_shipment_schedule_line_id);
609: DBMS_SQL.Define_Column(b_cursor, 25, b_unit_code, 3);
610: DBMS_SQL.Define_Column(b_cursor, 26, b_line_type_code, 30);
611: DBMS_SQL.Define_Column(b_cursor, 27, b_component_code, 1000);
612: DBMS_SQL.Define_Column(b_cursor, 28, b_standard_comp_freeze_date, 15);

Line 609: DBMS_SQL.Define_Column(b_cursor, 25, b_unit_code, 3);

605: DBMS_SQL.Define_Column(b_cursor, 21, b_ld_inventory_item_id);
606: DBMS_SQL.Define_Column(b_cursor, 22, b_customer_item_id);
607: DBMS_SQL.Define_Column(b_cursor, 23, b_dep_plan_required_flag, 1);
608: DBMS_SQL.Define_Column(b_cursor, 24, b_shipment_schedule_line_id);
609: DBMS_SQL.Define_Column(b_cursor, 25, b_unit_code, 3);
610: DBMS_SQL.Define_Column(b_cursor, 26, b_line_type_code, 30);
611: DBMS_SQL.Define_Column(b_cursor, 27, b_component_code, 1000);
612: DBMS_SQL.Define_Column(b_cursor, 28, b_standard_comp_freeze_date, 15);
613: DBMS_SQL.Define_Column(b_cursor, 29, b_order_number);

Line 610: DBMS_SQL.Define_Column(b_cursor, 26, b_line_type_code, 30);

606: DBMS_SQL.Define_Column(b_cursor, 22, b_customer_item_id);
607: DBMS_SQL.Define_Column(b_cursor, 23, b_dep_plan_required_flag, 1);
608: DBMS_SQL.Define_Column(b_cursor, 24, b_shipment_schedule_line_id);
609: DBMS_SQL.Define_Column(b_cursor, 25, b_unit_code, 3);
610: DBMS_SQL.Define_Column(b_cursor, 26, b_line_type_code, 30);
611: DBMS_SQL.Define_Column(b_cursor, 27, b_component_code, 1000);
612: DBMS_SQL.Define_Column(b_cursor, 28, b_standard_comp_freeze_date, 15);
613: DBMS_SQL.Define_Column(b_cursor, 29, b_order_number);
614: DBMS_SQL.Define_Column(b_cursor, 30, b_order_type_id);

Line 611: DBMS_SQL.Define_Column(b_cursor, 27, b_component_code, 1000);

607: DBMS_SQL.Define_Column(b_cursor, 23, b_dep_plan_required_flag, 1);
608: DBMS_SQL.Define_Column(b_cursor, 24, b_shipment_schedule_line_id);
609: DBMS_SQL.Define_Column(b_cursor, 25, b_unit_code, 3);
610: DBMS_SQL.Define_Column(b_cursor, 26, b_line_type_code, 30);
611: DBMS_SQL.Define_Column(b_cursor, 27, b_component_code, 1000);
612: DBMS_SQL.Define_Column(b_cursor, 28, b_standard_comp_freeze_date, 15);
613: DBMS_SQL.Define_Column(b_cursor, 29, b_order_number);
614: DBMS_SQL.Define_Column(b_cursor, 30, b_order_type_id);
615: DBMS_SQL.Define_Column(b_cursor, 31, b_customer_id);

Line 612: DBMS_SQL.Define_Column(b_cursor, 28, b_standard_comp_freeze_date, 15);

608: DBMS_SQL.Define_Column(b_cursor, 24, b_shipment_schedule_line_id);
609: DBMS_SQL.Define_Column(b_cursor, 25, b_unit_code, 3);
610: DBMS_SQL.Define_Column(b_cursor, 26, b_line_type_code, 30);
611: DBMS_SQL.Define_Column(b_cursor, 27, b_component_code, 1000);
612: DBMS_SQL.Define_Column(b_cursor, 28, b_standard_comp_freeze_date, 15);
613: DBMS_SQL.Define_Column(b_cursor, 29, b_order_number);
614: DBMS_SQL.Define_Column(b_cursor, 30, b_order_type_id);
615: DBMS_SQL.Define_Column(b_cursor, 31, b_customer_id);
616: DBMS_SQL.Define_Column(b_cursor, 32, b_invoice_to_site_use_id);

Line 613: DBMS_SQL.Define_Column(b_cursor, 29, b_order_number);

609: DBMS_SQL.Define_Column(b_cursor, 25, b_unit_code, 3);
610: DBMS_SQL.Define_Column(b_cursor, 26, b_line_type_code, 30);
611: DBMS_SQL.Define_Column(b_cursor, 27, b_component_code, 1000);
612: DBMS_SQL.Define_Column(b_cursor, 28, b_standard_comp_freeze_date, 15);
613: DBMS_SQL.Define_Column(b_cursor, 29, b_order_number);
614: DBMS_SQL.Define_Column(b_cursor, 30, b_order_type_id);
615: DBMS_SQL.Define_Column(b_cursor, 31, b_customer_id);
616: DBMS_SQL.Define_Column(b_cursor, 32, b_invoice_to_site_use_id);
617: DBMS_SQL.Define_Column(b_cursor, 33, b_planned_departure_date_d);

Line 614: DBMS_SQL.Define_Column(b_cursor, 30, b_order_type_id);

610: DBMS_SQL.Define_Column(b_cursor, 26, b_line_type_code, 30);
611: DBMS_SQL.Define_Column(b_cursor, 27, b_component_code, 1000);
612: DBMS_SQL.Define_Column(b_cursor, 28, b_standard_comp_freeze_date, 15);
613: DBMS_SQL.Define_Column(b_cursor, 29, b_order_number);
614: DBMS_SQL.Define_Column(b_cursor, 30, b_order_type_id);
615: DBMS_SQL.Define_Column(b_cursor, 31, b_customer_id);
616: DBMS_SQL.Define_Column(b_cursor, 32, b_invoice_to_site_use_id);
617: DBMS_SQL.Define_Column(b_cursor, 33, b_planned_departure_date_d);
618: DBMS_SQL.Define_Column(b_cursor, 34, b_planned_departure_date_t);

Line 615: DBMS_SQL.Define_Column(b_cursor, 31, b_customer_id);

611: DBMS_SQL.Define_Column(b_cursor, 27, b_component_code, 1000);
612: DBMS_SQL.Define_Column(b_cursor, 28, b_standard_comp_freeze_date, 15);
613: DBMS_SQL.Define_Column(b_cursor, 29, b_order_number);
614: DBMS_SQL.Define_Column(b_cursor, 30, b_order_type_id);
615: DBMS_SQL.Define_Column(b_cursor, 31, b_customer_id);
616: DBMS_SQL.Define_Column(b_cursor, 32, b_invoice_to_site_use_id);
617: DBMS_SQL.Define_Column(b_cursor, 33, b_planned_departure_date_d);
618: DBMS_SQL.Define_Column(b_cursor, 34, b_planned_departure_date_t);
619: DBMS_SQL.Define_Column(b_cursor, 35, b_master_container_id);

Line 616: DBMS_SQL.Define_Column(b_cursor, 32, b_invoice_to_site_use_id);

612: DBMS_SQL.Define_Column(b_cursor, 28, b_standard_comp_freeze_date, 15);
613: DBMS_SQL.Define_Column(b_cursor, 29, b_order_number);
614: DBMS_SQL.Define_Column(b_cursor, 30, b_order_type_id);
615: DBMS_SQL.Define_Column(b_cursor, 31, b_customer_id);
616: DBMS_SQL.Define_Column(b_cursor, 32, b_invoice_to_site_use_id);
617: DBMS_SQL.Define_Column(b_cursor, 33, b_planned_departure_date_d);
618: DBMS_SQL.Define_Column(b_cursor, 34, b_planned_departure_date_t);
619: DBMS_SQL.Define_Column(b_cursor, 35, b_master_container_id);
620: DBMS_SQL.Define_Column(b_cursor, 36, b_detail_container_id);

Line 617: DBMS_SQL.Define_Column(b_cursor, 33, b_planned_departure_date_d);

613: DBMS_SQL.Define_Column(b_cursor, 29, b_order_number);
614: DBMS_SQL.Define_Column(b_cursor, 30, b_order_type_id);
615: DBMS_SQL.Define_Column(b_cursor, 31, b_customer_id);
616: DBMS_SQL.Define_Column(b_cursor, 32, b_invoice_to_site_use_id);
617: DBMS_SQL.Define_Column(b_cursor, 33, b_planned_departure_date_d);
618: DBMS_SQL.Define_Column(b_cursor, 34, b_planned_departure_date_t);
619: DBMS_SQL.Define_Column(b_cursor, 35, b_master_container_id);
620: DBMS_SQL.Define_Column(b_cursor, 36, b_detail_container_id);
621: DBMS_SQL.Define_Column(b_cursor, 37, b_load_seq_number);

Line 618: DBMS_SQL.Define_Column(b_cursor, 34, b_planned_departure_date_t);

614: DBMS_SQL.Define_Column(b_cursor, 30, b_order_type_id);
615: DBMS_SQL.Define_Column(b_cursor, 31, b_customer_id);
616: DBMS_SQL.Define_Column(b_cursor, 32, b_invoice_to_site_use_id);
617: DBMS_SQL.Define_Column(b_cursor, 33, b_planned_departure_date_d);
618: DBMS_SQL.Define_Column(b_cursor, 34, b_planned_departure_date_t);
619: DBMS_SQL.Define_Column(b_cursor, 35, b_master_container_id);
620: DBMS_SQL.Define_Column(b_cursor, 36, b_detail_container_id);
621: DBMS_SQL.Define_Column(b_cursor, 37, b_load_seq_number);
622: DBMS_SQL.Define_Column(b_cursor, 38, b_invoice_value);

Line 619: DBMS_SQL.Define_Column(b_cursor, 35, b_master_container_id);

615: DBMS_SQL.Define_Column(b_cursor, 31, b_customer_id);
616: DBMS_SQL.Define_Column(b_cursor, 32, b_invoice_to_site_use_id);
617: DBMS_SQL.Define_Column(b_cursor, 33, b_planned_departure_date_d);
618: DBMS_SQL.Define_Column(b_cursor, 34, b_planned_departure_date_t);
619: DBMS_SQL.Define_Column(b_cursor, 35, b_master_container_id);
620: DBMS_SQL.Define_Column(b_cursor, 36, b_detail_container_id);
621: DBMS_SQL.Define_Column(b_cursor, 37, b_load_seq_number);
622: DBMS_SQL.Define_Column(b_cursor, 38, b_invoice_value);
623:

Line 620: DBMS_SQL.Define_Column(b_cursor, 36, b_detail_container_id);

616: DBMS_SQL.Define_Column(b_cursor, 32, b_invoice_to_site_use_id);
617: DBMS_SQL.Define_Column(b_cursor, 33, b_planned_departure_date_d);
618: DBMS_SQL.Define_Column(b_cursor, 34, b_planned_departure_date_t);
619: DBMS_SQL.Define_Column(b_cursor, 35, b_master_container_id);
620: DBMS_SQL.Define_Column(b_cursor, 36, b_detail_container_id);
621: DBMS_SQL.Define_Column(b_cursor, 37, b_load_seq_number);
622: DBMS_SQL.Define_Column(b_cursor, 38, b_invoice_value);
623:
624: -- Bind release criteria values

Line 621: DBMS_SQL.Define_Column(b_cursor, 37, b_load_seq_number);

617: DBMS_SQL.Define_Column(b_cursor, 33, b_planned_departure_date_d);
618: DBMS_SQL.Define_Column(b_cursor, 34, b_planned_departure_date_t);
619: DBMS_SQL.Define_Column(b_cursor, 35, b_master_container_id);
620: DBMS_SQL.Define_Column(b_cursor, 36, b_detail_container_id);
621: DBMS_SQL.Define_Column(b_cursor, 37, b_load_seq_number);
622: DBMS_SQL.Define_Column(b_cursor, 38, b_invoice_value);
623:
624: -- Bind release criteria values
625: WSH_UTIL.Write_Log('Binding backordered cursor');

Line 622: DBMS_SQL.Define_Column(b_cursor, 38, b_invoice_value);

618: DBMS_SQL.Define_Column(b_cursor, 34, b_planned_departure_date_t);
619: DBMS_SQL.Define_Column(b_cursor, 35, b_master_container_id);
620: DBMS_SQL.Define_Column(b_cursor, 36, b_detail_container_id);
621: DBMS_SQL.Define_Column(b_cursor, 37, b_load_seq_number);
622: DBMS_SQL.Define_Column(b_cursor, 38, b_invoice_value);
623:
624: -- Bind release criteria values
625: WSH_UTIL.Write_Log('Binding backordered cursor');
626:

Line 629: DBMS_SQL.Bind_Variable(b_cursor, ':X_header_id',

625: WSH_UTIL.Write_Log('Binding backordered cursor');
626:
627: IF (wsh_pr_picking_session.header_id <> 0) THEN
628: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
629: DBMS_SQL.Bind_Variable(b_cursor, ':X_header_id',
630: wsh_pr_picking_session.header_id);
631: END IF;
632: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
633: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_type_id',

Line 633: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_type_id',

629: DBMS_SQL.Bind_Variable(b_cursor, ':X_header_id',
630: wsh_pr_picking_session.header_id);
631: END IF;
632: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
633: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_type_id',
634: wsh_pr_picking_session.order_type_id);
635: IF (wsh_pr_picking_session.customer_id <> 0) THEN
636: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
637: DBMS_SQL.Bind_Variable(b_cursor, ':X_customer_id',

Line 637: DBMS_SQL.Bind_Variable(b_cursor, ':X_customer_id',

633: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_type_id',
634: wsh_pr_picking_session.order_type_id);
635: IF (wsh_pr_picking_session.customer_id <> 0) THEN
636: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
637: DBMS_SQL.Bind_Variable(b_cursor, ':X_customer_id',
638: wsh_pr_picking_session.customer_id);
639: END IF;
640:
641: IF (wsh_pr_picking_session.order_line_id <> 0) THEN

Line 643: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_line_id',

639: END IF;
640:
641: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
642: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));
643: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_line_id',
644: wsh_pr_picking_session.order_line_id);
645: END IF;
646:
647: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));

Line 648: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_set_number',

644: wsh_pr_picking_session.order_line_id);
645: END IF;
646:
647: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
648: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_set_number',
649: wsh_pr_picking_session.ship_set_number);
650: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
651: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_site_use_id',
652: wsh_pr_picking_session.ship_site_use_id);

Line 651: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_site_use_id',

647: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
648: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_set_number',
649: wsh_pr_picking_session.ship_set_number);
650: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
651: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_site_use_id',
652: wsh_pr_picking_session.ship_site_use_id);
653: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
654: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_method_code',
655: wsh_pr_picking_session.ship_method_code);

Line 654: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_method_code',

650: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
651: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_site_use_id',
652: wsh_pr_picking_session.ship_site_use_id);
653: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
654: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_method_code',
655: wsh_pr_picking_session.ship_method_code);
656: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
657: DBMS_SQL.Bind_Variable(b_cursor, ':X_warehouse_id',
658: wsh_pr_picking_session.warehouse_id);

Line 657: DBMS_SQL.Bind_Variable(b_cursor, ':X_warehouse_id',

653: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
654: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_method_code',
655: wsh_pr_picking_session.ship_method_code);
656: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
657: DBMS_SQL.Bind_Variable(b_cursor, ':X_warehouse_id',
658: wsh_pr_picking_session.warehouse_id);
659: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
660: DBMS_SQL.Bind_Variable(b_cursor, ':X_subinventory',
661: wsh_pr_picking_session.subinventory);

Line 660: DBMS_SQL.Bind_Variable(b_cursor, ':X_subinventory',

656: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
657: DBMS_SQL.Bind_Variable(b_cursor, ':X_warehouse_id',
658: wsh_pr_picking_session.warehouse_id);
659: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
660: DBMS_SQL.Bind_Variable(b_cursor, ':X_subinventory',
661: wsh_pr_picking_session.subinventory);
662: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
663: DBMS_SQL.Bind_Variable(b_cursor, ':X_shipment_priority',
664: wsh_pr_picking_session.shipment_priority);

Line 663: DBMS_SQL.Bind_Variable(b_cursor, ':X_shipment_priority',

659: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
660: DBMS_SQL.Bind_Variable(b_cursor, ':X_subinventory',
661: wsh_pr_picking_session.subinventory);
662: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
663: DBMS_SQL.Bind_Variable(b_cursor, ':X_shipment_priority',
664: wsh_pr_picking_session.shipment_priority);
665: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
666: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_request_date',
667: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 666: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_request_date',

662: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
663: DBMS_SQL.Bind_Variable(b_cursor, ':X_shipment_priority',
664: wsh_pr_picking_session.shipment_priority);
665: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
666: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_request_date',
667: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
668: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
669: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_request_date',
670: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 669: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_request_date',

665: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
666: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_request_date',
667: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
668: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
669: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_request_date',
670: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
671: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
672: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_sched_ship_date',
673: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 672: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_sched_ship_date',

668: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
669: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_request_date',
670: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
671: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
672: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_sched_ship_date',
673: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
674: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
675: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_sched_ship_date',
676: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 675: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_sched_ship_date',

671: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
672: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_sched_ship_date',
673: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
674: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
675: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_sched_ship_date',
676: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
677: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
678: DBMS_SQL.Bind_Variable(b_cursor, ':X_existing_rsvs_only_flag',
679: wsh_pr_picking_session.existing_rsvs_only_flag);

Line 678: DBMS_SQL.Bind_Variable(b_cursor, ':X_existing_rsvs_only_flag',

674: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
675: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_sched_ship_date',
676: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
677: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
678: DBMS_SQL.Bind_Variable(b_cursor, ':X_existing_rsvs_only_flag',
679: wsh_pr_picking_session.existing_rsvs_only_flag);
680: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
681: DBMS_SQL.Bind_Variable(b_cursor, ':X_inventory_item_id',
682: wsh_pr_picking_session.inventory_item_id);

Line 681: DBMS_SQL.Bind_Variable(b_cursor, ':X_inventory_item_id',

677: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
678: DBMS_SQL.Bind_Variable(b_cursor, ':X_existing_rsvs_only_flag',
679: wsh_pr_picking_session.existing_rsvs_only_flag);
680: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
681: DBMS_SQL.Bind_Variable(b_cursor, ':X_inventory_item_id',
682: wsh_pr_picking_session.inventory_item_id);
683: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
684: DBMS_SQL.Bind_Variable(b_cursor, ':X_reservations',
685: wsh_pr_picking_session.reservations);

Line 684: DBMS_SQL.Bind_Variable(b_cursor, ':X_reservations',

680: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
681: DBMS_SQL.Bind_Variable(b_cursor, ':X_inventory_item_id',
682: wsh_pr_picking_session.inventory_item_id);
683: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
684: DBMS_SQL.Bind_Variable(b_cursor, ':X_reservations',
685: wsh_pr_picking_session.reservations);
686: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
687: DBMS_SQL.Bind_Variable(b_cursor, ':X_departure_id',
688: wsh_pr_picking_session.departure_id);

Line 687: DBMS_SQL.Bind_Variable(b_cursor, ':X_departure_id',

683: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
684: DBMS_SQL.Bind_Variable(b_cursor, ':X_reservations',
685: wsh_pr_picking_session.reservations);
686: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
687: DBMS_SQL.Bind_Variable(b_cursor, ':X_departure_id',
688: wsh_pr_picking_session.departure_id);
689: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
690: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
691: DBMS_SQL.Bind_Variable(b_cursor, ':X_delivery_id',

Line 691: DBMS_SQL.Bind_Variable(b_cursor, ':X_delivery_id',

687: DBMS_SQL.Bind_Variable(b_cursor, ':X_departure_id',
688: wsh_pr_picking_session.departure_id);
689: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
690: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
691: DBMS_SQL.Bind_Variable(b_cursor, ':X_delivery_id',
692: wsh_pr_picking_session.delivery_id);
693: END IF;
694: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
695: DBMS_SQL.Bind_Variable(b_cursor, ':X_include_planned_lines',

Line 695: DBMS_SQL.Bind_Variable(b_cursor, ':X_include_planned_lines',

691: DBMS_SQL.Bind_Variable(b_cursor, ':X_delivery_id',
692: wsh_pr_picking_session.delivery_id);
693: END IF;
694: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
695: DBMS_SQL.Bind_Variable(b_cursor, ':X_include_planned_lines',
696: wsh_pr_picking_session.include_planned_lines);
697:
698: -- Execute the cursor
699: WSH_UTIL.Write_Log('Executing backordered cursor');

Line 700: v_ignore := DBMS_SQL.Execute(b_cursor);

696: wsh_pr_picking_session.include_planned_lines);
697:
698: -- Execute the cursor
699: WSH_UTIL.Write_Log('Executing backordered cursor');
700: v_ignore := DBMS_SQL.Execute(b_cursor);
701:
702: ELSIF p_mode = 'SYNC' THEN
703:
704: -- Open a cursor for sync_SQL

Line 706: s_cursor := DBMS_SQL.Open_Cursor;

702: ELSIF p_mode = 'SYNC' THEN
703:
704: -- Open a cursor for sync_SQL
705: WSH_UTIL.Write_Log('Processing sync cursor');
706: s_cursor := DBMS_SQL.Open_Cursor;
707:
708: -- Parse the cursor
709: WSH_UTIL.Write_Log('Parsing sync cursor');
710: DBMS_SQL.Parse(s_cursor, sync_SQL, DBMS_SQL.v7);

Line 710: DBMS_SQL.Parse(s_cursor, sync_SQL, DBMS_SQL.v7);

706: s_cursor := DBMS_SQL.Open_Cursor;
707:
708: -- Parse the cursor
709: WSH_UTIL.Write_Log('Parsing sync cursor');
710: DBMS_SQL.Parse(s_cursor, sync_SQL, DBMS_SQL.v7);
711:
712: -- Identify the column numbers with variable
713: WSH_UTIL.Write_Log('Column definition for sync cursor');
714: DBMS_SQL.Define_Column(s_cursor, 1, s_line_id);

Line 714: DBMS_SQL.Define_Column(s_cursor, 1, s_line_id);

710: DBMS_SQL.Parse(s_cursor, sync_SQL, DBMS_SQL.v7);
711:
712: -- Identify the column numbers with variable
713: WSH_UTIL.Write_Log('Column definition for sync cursor');
714: DBMS_SQL.Define_Column(s_cursor, 1, s_line_id);
715: DBMS_SQL.Define_Column(s_cursor, 2, s_header_id);
716: DBMS_SQL.Define_Column(s_cursor, 3, s_org_id);
717: DBMS_SQL.Define_Column(s_cursor, 4, s_ato_flag, 1);
718: DBMS_SQL.Define_Column(s_cursor, 5, s_line_detail_id);

Line 715: DBMS_SQL.Define_Column(s_cursor, 2, s_header_id);

711:
712: -- Identify the column numbers with variable
713: WSH_UTIL.Write_Log('Column definition for sync cursor');
714: DBMS_SQL.Define_Column(s_cursor, 1, s_line_id);
715: DBMS_SQL.Define_Column(s_cursor, 2, s_header_id);
716: DBMS_SQL.Define_Column(s_cursor, 3, s_org_id);
717: DBMS_SQL.Define_Column(s_cursor, 4, s_ato_flag, 1);
718: DBMS_SQL.Define_Column(s_cursor, 5, s_line_detail_id);
719: DBMS_SQL.Define_Column(s_cursor, 6, s_ship_model_complete, 1);

Line 716: DBMS_SQL.Define_Column(s_cursor, 3, s_org_id);

712: -- Identify the column numbers with variable
713: WSH_UTIL.Write_Log('Column definition for sync cursor');
714: DBMS_SQL.Define_Column(s_cursor, 1, s_line_id);
715: DBMS_SQL.Define_Column(s_cursor, 2, s_header_id);
716: DBMS_SQL.Define_Column(s_cursor, 3, s_org_id);
717: DBMS_SQL.Define_Column(s_cursor, 4, s_ato_flag, 1);
718: DBMS_SQL.Define_Column(s_cursor, 5, s_line_detail_id);
719: DBMS_SQL.Define_Column(s_cursor, 6, s_ship_model_complete, 1);
720: DBMS_SQL.Define_Column(s_cursor, 7, s_ship_set_number);

Line 717: DBMS_SQL.Define_Column(s_cursor, 4, s_ato_flag, 1);

713: WSH_UTIL.Write_Log('Column definition for sync cursor');
714: DBMS_SQL.Define_Column(s_cursor, 1, s_line_id);
715: DBMS_SQL.Define_Column(s_cursor, 2, s_header_id);
716: DBMS_SQL.Define_Column(s_cursor, 3, s_org_id);
717: DBMS_SQL.Define_Column(s_cursor, 4, s_ato_flag, 1);
718: DBMS_SQL.Define_Column(s_cursor, 5, s_line_detail_id);
719: DBMS_SQL.Define_Column(s_cursor, 6, s_ship_model_complete, 1);
720: DBMS_SQL.Define_Column(s_cursor, 7, s_ship_set_number);
721: DBMS_SQL.Define_Column(s_cursor, 8, s_parent_line_id);

Line 718: DBMS_SQL.Define_Column(s_cursor, 5, s_line_detail_id);

714: DBMS_SQL.Define_Column(s_cursor, 1, s_line_id);
715: DBMS_SQL.Define_Column(s_cursor, 2, s_header_id);
716: DBMS_SQL.Define_Column(s_cursor, 3, s_org_id);
717: DBMS_SQL.Define_Column(s_cursor, 4, s_ato_flag, 1);
718: DBMS_SQL.Define_Column(s_cursor, 5, s_line_detail_id);
719: DBMS_SQL.Define_Column(s_cursor, 6, s_ship_model_complete, 1);
720: DBMS_SQL.Define_Column(s_cursor, 7, s_ship_set_number);
721: DBMS_SQL.Define_Column(s_cursor, 8, s_parent_line_id);
722: DBMS_SQL.Define_Column(s_cursor, 9, s_ld_warehouse_id);

Line 719: DBMS_SQL.Define_Column(s_cursor, 6, s_ship_model_complete, 1);

715: DBMS_SQL.Define_Column(s_cursor, 2, s_header_id);
716: DBMS_SQL.Define_Column(s_cursor, 3, s_org_id);
717: DBMS_SQL.Define_Column(s_cursor, 4, s_ato_flag, 1);
718: DBMS_SQL.Define_Column(s_cursor, 5, s_line_detail_id);
719: DBMS_SQL.Define_Column(s_cursor, 6, s_ship_model_complete, 1);
720: DBMS_SQL.Define_Column(s_cursor, 7, s_ship_set_number);
721: DBMS_SQL.Define_Column(s_cursor, 8, s_parent_line_id);
722: DBMS_SQL.Define_Column(s_cursor, 9, s_ld_warehouse_id);
723: DBMS_SQL.Define_Column(s_cursor, 10, s_ship_to_site_use_id);

Line 720: DBMS_SQL.Define_Column(s_cursor, 7, s_ship_set_number);

716: DBMS_SQL.Define_Column(s_cursor, 3, s_org_id);
717: DBMS_SQL.Define_Column(s_cursor, 4, s_ato_flag, 1);
718: DBMS_SQL.Define_Column(s_cursor, 5, s_line_detail_id);
719: DBMS_SQL.Define_Column(s_cursor, 6, s_ship_model_complete, 1);
720: DBMS_SQL.Define_Column(s_cursor, 7, s_ship_set_number);
721: DBMS_SQL.Define_Column(s_cursor, 8, s_parent_line_id);
722: DBMS_SQL.Define_Column(s_cursor, 9, s_ld_warehouse_id);
723: DBMS_SQL.Define_Column(s_cursor, 10, s_ship_to_site_use_id);
724: DBMS_SQL.Define_Column(s_cursor, 11, s_ship_to_contact_id);

Line 721: DBMS_SQL.Define_Column(s_cursor, 8, s_parent_line_id);

717: DBMS_SQL.Define_Column(s_cursor, 4, s_ato_flag, 1);
718: DBMS_SQL.Define_Column(s_cursor, 5, s_line_detail_id);
719: DBMS_SQL.Define_Column(s_cursor, 6, s_ship_model_complete, 1);
720: DBMS_SQL.Define_Column(s_cursor, 7, s_ship_set_number);
721: DBMS_SQL.Define_Column(s_cursor, 8, s_parent_line_id);
722: DBMS_SQL.Define_Column(s_cursor, 9, s_ld_warehouse_id);
723: DBMS_SQL.Define_Column(s_cursor, 10, s_ship_to_site_use_id);
724: DBMS_SQL.Define_Column(s_cursor, 11, s_ship_to_contact_id);
725: DBMS_SQL.Define_Column(s_cursor, 12, s_ship_method_code, 30);

Line 722: DBMS_SQL.Define_Column(s_cursor, 9, s_ld_warehouse_id);

718: DBMS_SQL.Define_Column(s_cursor, 5, s_line_detail_id);
719: DBMS_SQL.Define_Column(s_cursor, 6, s_ship_model_complete, 1);
720: DBMS_SQL.Define_Column(s_cursor, 7, s_ship_set_number);
721: DBMS_SQL.Define_Column(s_cursor, 8, s_parent_line_id);
722: DBMS_SQL.Define_Column(s_cursor, 9, s_ld_warehouse_id);
723: DBMS_SQL.Define_Column(s_cursor, 10, s_ship_to_site_use_id);
724: DBMS_SQL.Define_Column(s_cursor, 11, s_ship_to_contact_id);
725: DBMS_SQL.Define_Column(s_cursor, 12, s_ship_method_code, 30);
726: DBMS_SQL.Define_Column(s_cursor, 13, s_shipment_priority, 30);

Line 723: DBMS_SQL.Define_Column(s_cursor, 10, s_ship_to_site_use_id);

719: DBMS_SQL.Define_Column(s_cursor, 6, s_ship_model_complete, 1);
720: DBMS_SQL.Define_Column(s_cursor, 7, s_ship_set_number);
721: DBMS_SQL.Define_Column(s_cursor, 8, s_parent_line_id);
722: DBMS_SQL.Define_Column(s_cursor, 9, s_ld_warehouse_id);
723: DBMS_SQL.Define_Column(s_cursor, 10, s_ship_to_site_use_id);
724: DBMS_SQL.Define_Column(s_cursor, 11, s_ship_to_contact_id);
725: DBMS_SQL.Define_Column(s_cursor, 12, s_ship_method_code, 30);
726: DBMS_SQL.Define_Column(s_cursor, 13, s_shipment_priority, 30);
727: DBMS_SQL.Define_Column(s_cursor, 14, s_departure_id);

Line 724: DBMS_SQL.Define_Column(s_cursor, 11, s_ship_to_contact_id);

720: DBMS_SQL.Define_Column(s_cursor, 7, s_ship_set_number);
721: DBMS_SQL.Define_Column(s_cursor, 8, s_parent_line_id);
722: DBMS_SQL.Define_Column(s_cursor, 9, s_ld_warehouse_id);
723: DBMS_SQL.Define_Column(s_cursor, 10, s_ship_to_site_use_id);
724: DBMS_SQL.Define_Column(s_cursor, 11, s_ship_to_contact_id);
725: DBMS_SQL.Define_Column(s_cursor, 12, s_ship_method_code, 30);
726: DBMS_SQL.Define_Column(s_cursor, 13, s_shipment_priority, 30);
727: DBMS_SQL.Define_Column(s_cursor, 14, s_departure_id);
728: DBMS_SQL.Define_Column(s_cursor, 15, s_delivery_id);

Line 725: DBMS_SQL.Define_Column(s_cursor, 12, s_ship_method_code, 30);

721: DBMS_SQL.Define_Column(s_cursor, 8, s_parent_line_id);
722: DBMS_SQL.Define_Column(s_cursor, 9, s_ld_warehouse_id);
723: DBMS_SQL.Define_Column(s_cursor, 10, s_ship_to_site_use_id);
724: DBMS_SQL.Define_Column(s_cursor, 11, s_ship_to_contact_id);
725: DBMS_SQL.Define_Column(s_cursor, 12, s_ship_method_code, 30);
726: DBMS_SQL.Define_Column(s_cursor, 13, s_shipment_priority, 30);
727: DBMS_SQL.Define_Column(s_cursor, 14, s_departure_id);
728: DBMS_SQL.Define_Column(s_cursor, 15, s_delivery_id);
729: DBMS_SQL.Define_Column(s_cursor, 16, s_schedule_date);

Line 726: DBMS_SQL.Define_Column(s_cursor, 13, s_shipment_priority, 30);

722: DBMS_SQL.Define_Column(s_cursor, 9, s_ld_warehouse_id);
723: DBMS_SQL.Define_Column(s_cursor, 10, s_ship_to_site_use_id);
724: DBMS_SQL.Define_Column(s_cursor, 11, s_ship_to_contact_id);
725: DBMS_SQL.Define_Column(s_cursor, 12, s_ship_method_code, 30);
726: DBMS_SQL.Define_Column(s_cursor, 13, s_shipment_priority, 30);
727: DBMS_SQL.Define_Column(s_cursor, 14, s_departure_id);
728: DBMS_SQL.Define_Column(s_cursor, 15, s_delivery_id);
729: DBMS_SQL.Define_Column(s_cursor, 16, s_schedule_date);
730: DBMS_SQL.Define_Column(s_cursor, 17, s_customer_item_id);

Line 727: DBMS_SQL.Define_Column(s_cursor, 14, s_departure_id);

723: DBMS_SQL.Define_Column(s_cursor, 10, s_ship_to_site_use_id);
724: DBMS_SQL.Define_Column(s_cursor, 11, s_ship_to_contact_id);
725: DBMS_SQL.Define_Column(s_cursor, 12, s_ship_method_code, 30);
726: DBMS_SQL.Define_Column(s_cursor, 13, s_shipment_priority, 30);
727: DBMS_SQL.Define_Column(s_cursor, 14, s_departure_id);
728: DBMS_SQL.Define_Column(s_cursor, 15, s_delivery_id);
729: DBMS_SQL.Define_Column(s_cursor, 16, s_schedule_date);
730: DBMS_SQL.Define_Column(s_cursor, 17, s_customer_item_id);
731: DBMS_SQL.Define_Column(s_cursor, 18, s_dep_plan_required_flag, 1);

Line 728: DBMS_SQL.Define_Column(s_cursor, 15, s_delivery_id);

724: DBMS_SQL.Define_Column(s_cursor, 11, s_ship_to_contact_id);
725: DBMS_SQL.Define_Column(s_cursor, 12, s_ship_method_code, 30);
726: DBMS_SQL.Define_Column(s_cursor, 13, s_shipment_priority, 30);
727: DBMS_SQL.Define_Column(s_cursor, 14, s_departure_id);
728: DBMS_SQL.Define_Column(s_cursor, 15, s_delivery_id);
729: DBMS_SQL.Define_Column(s_cursor, 16, s_schedule_date);
730: DBMS_SQL.Define_Column(s_cursor, 17, s_customer_item_id);
731: DBMS_SQL.Define_Column(s_cursor, 18, s_dep_plan_required_flag, 1);
732: DBMS_SQL.Define_Column(s_cursor, 19, s_order_number);

Line 729: DBMS_SQL.Define_Column(s_cursor, 16, s_schedule_date);

725: DBMS_SQL.Define_Column(s_cursor, 12, s_ship_method_code, 30);
726: DBMS_SQL.Define_Column(s_cursor, 13, s_shipment_priority, 30);
727: DBMS_SQL.Define_Column(s_cursor, 14, s_departure_id);
728: DBMS_SQL.Define_Column(s_cursor, 15, s_delivery_id);
729: DBMS_SQL.Define_Column(s_cursor, 16, s_schedule_date);
730: DBMS_SQL.Define_Column(s_cursor, 17, s_customer_item_id);
731: DBMS_SQL.Define_Column(s_cursor, 18, s_dep_plan_required_flag, 1);
732: DBMS_SQL.Define_Column(s_cursor, 19, s_order_number);
733: DBMS_SQL.Define_Column(s_cursor, 20, s_order_type_id);

Line 730: DBMS_SQL.Define_Column(s_cursor, 17, s_customer_item_id);

726: DBMS_SQL.Define_Column(s_cursor, 13, s_shipment_priority, 30);
727: DBMS_SQL.Define_Column(s_cursor, 14, s_departure_id);
728: DBMS_SQL.Define_Column(s_cursor, 15, s_delivery_id);
729: DBMS_SQL.Define_Column(s_cursor, 16, s_schedule_date);
730: DBMS_SQL.Define_Column(s_cursor, 17, s_customer_item_id);
731: DBMS_SQL.Define_Column(s_cursor, 18, s_dep_plan_required_flag, 1);
732: DBMS_SQL.Define_Column(s_cursor, 19, s_order_number);
733: DBMS_SQL.Define_Column(s_cursor, 20, s_order_type_id);
734: DBMS_SQL.Define_Column(s_cursor, 21, s_customer_id);

Line 731: DBMS_SQL.Define_Column(s_cursor, 18, s_dep_plan_required_flag, 1);

727: DBMS_SQL.Define_Column(s_cursor, 14, s_departure_id);
728: DBMS_SQL.Define_Column(s_cursor, 15, s_delivery_id);
729: DBMS_SQL.Define_Column(s_cursor, 16, s_schedule_date);
730: DBMS_SQL.Define_Column(s_cursor, 17, s_customer_item_id);
731: DBMS_SQL.Define_Column(s_cursor, 18, s_dep_plan_required_flag, 1);
732: DBMS_SQL.Define_Column(s_cursor, 19, s_order_number);
733: DBMS_SQL.Define_Column(s_cursor, 20, s_order_type_id);
734: DBMS_SQL.Define_Column(s_cursor, 21, s_customer_id);
735: DBMS_SQL.Define_Column(s_cursor, 22, s_invoice_to_site_use_id);

Line 732: DBMS_SQL.Define_Column(s_cursor, 19, s_order_number);

728: DBMS_SQL.Define_Column(s_cursor, 15, s_delivery_id);
729: DBMS_SQL.Define_Column(s_cursor, 16, s_schedule_date);
730: DBMS_SQL.Define_Column(s_cursor, 17, s_customer_item_id);
731: DBMS_SQL.Define_Column(s_cursor, 18, s_dep_plan_required_flag, 1);
732: DBMS_SQL.Define_Column(s_cursor, 19, s_order_number);
733: DBMS_SQL.Define_Column(s_cursor, 20, s_order_type_id);
734: DBMS_SQL.Define_Column(s_cursor, 21, s_customer_id);
735: DBMS_SQL.Define_Column(s_cursor, 22, s_invoice_to_site_use_id);
736: DBMS_SQL.Define_Column(s_cursor, 23, s_master_container_id);

Line 733: DBMS_SQL.Define_Column(s_cursor, 20, s_order_type_id);

729: DBMS_SQL.Define_Column(s_cursor, 16, s_schedule_date);
730: DBMS_SQL.Define_Column(s_cursor, 17, s_customer_item_id);
731: DBMS_SQL.Define_Column(s_cursor, 18, s_dep_plan_required_flag, 1);
732: DBMS_SQL.Define_Column(s_cursor, 19, s_order_number);
733: DBMS_SQL.Define_Column(s_cursor, 20, s_order_type_id);
734: DBMS_SQL.Define_Column(s_cursor, 21, s_customer_id);
735: DBMS_SQL.Define_Column(s_cursor, 22, s_invoice_to_site_use_id);
736: DBMS_SQL.Define_Column(s_cursor, 23, s_master_container_id);
737: DBMS_SQL.Define_Column(s_cursor, 24, s_detail_container_id);

Line 734: DBMS_SQL.Define_Column(s_cursor, 21, s_customer_id);

730: DBMS_SQL.Define_Column(s_cursor, 17, s_customer_item_id);
731: DBMS_SQL.Define_Column(s_cursor, 18, s_dep_plan_required_flag, 1);
732: DBMS_SQL.Define_Column(s_cursor, 19, s_order_number);
733: DBMS_SQL.Define_Column(s_cursor, 20, s_order_type_id);
734: DBMS_SQL.Define_Column(s_cursor, 21, s_customer_id);
735: DBMS_SQL.Define_Column(s_cursor, 22, s_invoice_to_site_use_id);
736: DBMS_SQL.Define_Column(s_cursor, 23, s_master_container_id);
737: DBMS_SQL.Define_Column(s_cursor, 24, s_detail_container_id);
738: DBMS_SQL.Define_Column(s_cursor, 25, s_load_seq_number);

Line 735: DBMS_SQL.Define_Column(s_cursor, 22, s_invoice_to_site_use_id);

731: DBMS_SQL.Define_Column(s_cursor, 18, s_dep_plan_required_flag, 1);
732: DBMS_SQL.Define_Column(s_cursor, 19, s_order_number);
733: DBMS_SQL.Define_Column(s_cursor, 20, s_order_type_id);
734: DBMS_SQL.Define_Column(s_cursor, 21, s_customer_id);
735: DBMS_SQL.Define_Column(s_cursor, 22, s_invoice_to_site_use_id);
736: DBMS_SQL.Define_Column(s_cursor, 23, s_master_container_id);
737: DBMS_SQL.Define_Column(s_cursor, 24, s_detail_container_id);
738: DBMS_SQL.Define_Column(s_cursor, 25, s_load_seq_number);
739:

Line 736: DBMS_SQL.Define_Column(s_cursor, 23, s_master_container_id);

732: DBMS_SQL.Define_Column(s_cursor, 19, s_order_number);
733: DBMS_SQL.Define_Column(s_cursor, 20, s_order_type_id);
734: DBMS_SQL.Define_Column(s_cursor, 21, s_customer_id);
735: DBMS_SQL.Define_Column(s_cursor, 22, s_invoice_to_site_use_id);
736: DBMS_SQL.Define_Column(s_cursor, 23, s_master_container_id);
737: DBMS_SQL.Define_Column(s_cursor, 24, s_detail_container_id);
738: DBMS_SQL.Define_Column(s_cursor, 25, s_load_seq_number);
739:
740: -- Bind release criteria values

Line 737: DBMS_SQL.Define_Column(s_cursor, 24, s_detail_container_id);

733: DBMS_SQL.Define_Column(s_cursor, 20, s_order_type_id);
734: DBMS_SQL.Define_Column(s_cursor, 21, s_customer_id);
735: DBMS_SQL.Define_Column(s_cursor, 22, s_invoice_to_site_use_id);
736: DBMS_SQL.Define_Column(s_cursor, 23, s_master_container_id);
737: DBMS_SQL.Define_Column(s_cursor, 24, s_detail_container_id);
738: DBMS_SQL.Define_Column(s_cursor, 25, s_load_seq_number);
739:
740: -- Bind release criteria values
741: WSH_UTIL.Write_Log('Binding sync cursor');

Line 738: DBMS_SQL.Define_Column(s_cursor, 25, s_load_seq_number);

734: DBMS_SQL.Define_Column(s_cursor, 21, s_customer_id);
735: DBMS_SQL.Define_Column(s_cursor, 22, s_invoice_to_site_use_id);
736: DBMS_SQL.Define_Column(s_cursor, 23, s_master_container_id);
737: DBMS_SQL.Define_Column(s_cursor, 24, s_detail_container_id);
738: DBMS_SQL.Define_Column(s_cursor, 25, s_load_seq_number);
739:
740: -- Bind release criteria values
741: WSH_UTIL.Write_Log('Binding sync cursor');
742:

Line 744: DBMS_SQL.Bind_Variable(s_cursor, ':X_p_param_1',

740: -- Bind release criteria values
741: WSH_UTIL.Write_Log('Binding sync cursor');
742:
743: WSH_UTIL.Write_Log('X_p_param_1 = ' || to_char(wsh_pr_picking_session.sync_line_id));
744: DBMS_SQL.Bind_Variable(s_cursor, ':X_p_param_1',
745: wsh_pr_picking_session.sync_line_id);
746: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
747: DBMS_SQL.Bind_Variable(s_cursor, ':X_warehouse_id',
748: wsh_pr_picking_session.warehouse_id);

Line 747: DBMS_SQL.Bind_Variable(s_cursor, ':X_warehouse_id',

743: WSH_UTIL.Write_Log('X_p_param_1 = ' || to_char(wsh_pr_picking_session.sync_line_id));
744: DBMS_SQL.Bind_Variable(s_cursor, ':X_p_param_1',
745: wsh_pr_picking_session.sync_line_id);
746: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
747: DBMS_SQL.Bind_Variable(s_cursor, ':X_warehouse_id',
748: wsh_pr_picking_session.warehouse_id);
749: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
750: DBMS_SQL.Bind_Variable(s_cursor, ':X_subinventory',
751: wsh_pr_picking_session.subinventory);

Line 750: DBMS_SQL.Bind_Variable(s_cursor, ':X_subinventory',

746: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
747: DBMS_SQL.Bind_Variable(s_cursor, ':X_warehouse_id',
748: wsh_pr_picking_session.warehouse_id);
749: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
750: DBMS_SQL.Bind_Variable(s_cursor, ':X_subinventory',
751: wsh_pr_picking_session.subinventory);
752: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
753: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_request_date',
754: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 753: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_request_date',

749: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
750: DBMS_SQL.Bind_Variable(s_cursor, ':X_subinventory',
751: wsh_pr_picking_session.subinventory);
752: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
753: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_request_date',
754: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
755: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
756: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_request_date',
757: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 756: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_request_date',

752: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
753: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_request_date',
754: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
755: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
756: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_request_date',
757: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
758: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
759: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_sched_ship_date',
760: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 759: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_sched_ship_date',

755: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
756: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_request_date',
757: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
758: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
759: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_sched_ship_date',
760: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
761: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
762: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_sched_ship_date',
763: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 762: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_sched_ship_date',

758: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
759: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_sched_ship_date',
760: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
761: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
762: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_sched_ship_date',
763: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
764: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
765: DBMS_SQL.Bind_Variable(s_cursor, ':X_existing_rsvs_only_flag',
766: wsh_pr_picking_session.existing_rsvs_only_flag);

Line 765: DBMS_SQL.Bind_Variable(s_cursor, ':X_existing_rsvs_only_flag',

761: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
762: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_sched_ship_date',
763: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
764: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
765: DBMS_SQL.Bind_Variable(s_cursor, ':X_existing_rsvs_only_flag',
766: wsh_pr_picking_session.existing_rsvs_only_flag);
767: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
768: DBMS_SQL.Bind_Variable(s_cursor, ':X_inventory_item_id',
769: wsh_pr_picking_session.inventory_item_id);

Line 768: DBMS_SQL.Bind_Variable(s_cursor, ':X_inventory_item_id',

764: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
765: DBMS_SQL.Bind_Variable(s_cursor, ':X_existing_rsvs_only_flag',
766: wsh_pr_picking_session.existing_rsvs_only_flag);
767: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
768: DBMS_SQL.Bind_Variable(s_cursor, ':X_inventory_item_id',
769: wsh_pr_picking_session.inventory_item_id);
770: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
771: DBMS_SQL.Bind_Variable(s_cursor, ':X_reservations',
772: wsh_pr_picking_session.reservations);

Line 771: DBMS_SQL.Bind_Variable(s_cursor, ':X_reservations',

767: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
768: DBMS_SQL.Bind_Variable(s_cursor, ':X_inventory_item_id',
769: wsh_pr_picking_session.inventory_item_id);
770: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
771: DBMS_SQL.Bind_Variable(s_cursor, ':X_reservations',
772: wsh_pr_picking_session.reservations);
773: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
774: DBMS_SQL.Bind_Variable(s_cursor, ':X_departure_id',
775: wsh_pr_picking_session.departure_id);

Line 774: DBMS_SQL.Bind_Variable(s_cursor, ':X_departure_id',

770: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
771: DBMS_SQL.Bind_Variable(s_cursor, ':X_reservations',
772: wsh_pr_picking_session.reservations);
773: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
774: DBMS_SQL.Bind_Variable(s_cursor, ':X_departure_id',
775: wsh_pr_picking_session.departure_id);
776: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
777: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
778: DBMS_SQL.Bind_Variable(s_cursor, ':X_delivery_id',

Line 778: DBMS_SQL.Bind_Variable(s_cursor, ':X_delivery_id',

774: DBMS_SQL.Bind_Variable(s_cursor, ':X_departure_id',
775: wsh_pr_picking_session.departure_id);
776: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
777: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
778: DBMS_SQL.Bind_Variable(s_cursor, ':X_delivery_id',
779: wsh_pr_picking_session.delivery_id);
780: END IF;
781: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
782: DBMS_SQL.Bind_Variable(s_cursor, ':X_include_planned_lines',

Line 782: DBMS_SQL.Bind_Variable(s_cursor, ':X_include_planned_lines',

778: DBMS_SQL.Bind_Variable(s_cursor, ':X_delivery_id',
779: wsh_pr_picking_session.delivery_id);
780: END IF;
781: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
782: DBMS_SQL.Bind_Variable(s_cursor, ':X_include_planned_lines',
783: wsh_pr_picking_session.include_planned_lines);
784:
785: -- Execute the cursor
786: WSH_UTIL.Write_Log('Executing sync cursor');

Line 787: v_ignore := DBMS_SQL.Execute(s_cursor);

783: wsh_pr_picking_session.include_planned_lines);
784:
785: -- Execute the cursor
786: WSH_UTIL.Write_Log('Executing sync cursor');
787: v_ignore := DBMS_SQL.Execute(s_cursor);
788:
789: ELSIF p_mode = 'NON_SHIPPABLE' THEN
790: -- Open a cursor for non_ship_SQL
791: WSH_UTIL.Write_Log('Processing non-ship cursor');

Line 792: ns_cursor := DBMS_SQL.Open_Cursor;

788:
789: ELSIF p_mode = 'NON_SHIPPABLE' THEN
790: -- Open a cursor for non_ship_SQL
791: WSH_UTIL.Write_Log('Processing non-ship cursor');
792: ns_cursor := DBMS_SQL.Open_Cursor;
793:
794: -- Parse the cursor
795: WSH_UTIL.Write_Log('Parsing non-ship cursor');
796: DBMS_SQL.Parse(ns_cursor, non_ship_SQL, DBMS_SQL.v7);

Line 796: DBMS_SQL.Parse(ns_cursor, non_ship_SQL, DBMS_SQL.v7);

792: ns_cursor := DBMS_SQL.Open_Cursor;
793:
794: -- Parse the cursor
795: WSH_UTIL.Write_Log('Parsing non-ship cursor');
796: DBMS_SQL.Parse(ns_cursor, non_ship_SQL, DBMS_SQL.v7);
797:
798: WSH_UTIL.Write_Log('Column definition for non-ship cursor');
799: DBMS_SQL.Define_Column(ns_cursor, 1, n_line_id);
800: DBMS_SQL.Define_Column(ns_cursor, 2, n_header_id);

Line 799: DBMS_SQL.Define_Column(ns_cursor, 1, n_line_id);

795: WSH_UTIL.Write_Log('Parsing non-ship cursor');
796: DBMS_SQL.Parse(ns_cursor, non_ship_SQL, DBMS_SQL.v7);
797:
798: WSH_UTIL.Write_Log('Column definition for non-ship cursor');
799: DBMS_SQL.Define_Column(ns_cursor, 1, n_line_id);
800: DBMS_SQL.Define_Column(ns_cursor, 2, n_header_id);
801: DBMS_SQL.Define_Column(ns_cursor, 3, n_line_detail_id);
802: DBMS_SQL.Define_Column(ns_cursor, 4, n_org_id);
803:

Line 800: DBMS_SQL.Define_Column(ns_cursor, 2, n_header_id);

796: DBMS_SQL.Parse(ns_cursor, non_ship_SQL, DBMS_SQL.v7);
797:
798: WSH_UTIL.Write_Log('Column definition for non-ship cursor');
799: DBMS_SQL.Define_Column(ns_cursor, 1, n_line_id);
800: DBMS_SQL.Define_Column(ns_cursor, 2, n_header_id);
801: DBMS_SQL.Define_Column(ns_cursor, 3, n_line_detail_id);
802: DBMS_SQL.Define_Column(ns_cursor, 4, n_org_id);
803:
804: -- Bind release criteria values

Line 801: DBMS_SQL.Define_Column(ns_cursor, 3, n_line_detail_id);

797:
798: WSH_UTIL.Write_Log('Column definition for non-ship cursor');
799: DBMS_SQL.Define_Column(ns_cursor, 1, n_line_id);
800: DBMS_SQL.Define_Column(ns_cursor, 2, n_header_id);
801: DBMS_SQL.Define_Column(ns_cursor, 3, n_line_detail_id);
802: DBMS_SQL.Define_Column(ns_cursor, 4, n_org_id);
803:
804: -- Bind release criteria values
805: WSH_UTIL.Write_Log('Binding non-ship cursor');

Line 802: DBMS_SQL.Define_Column(ns_cursor, 4, n_org_id);

798: WSH_UTIL.Write_Log('Column definition for non-ship cursor');
799: DBMS_SQL.Define_Column(ns_cursor, 1, n_line_id);
800: DBMS_SQL.Define_Column(ns_cursor, 2, n_header_id);
801: DBMS_SQL.Define_Column(ns_cursor, 3, n_line_detail_id);
802: DBMS_SQL.Define_Column(ns_cursor, 4, n_org_id);
803:
804: -- Bind release criteria values
805: WSH_UTIL.Write_Log('Binding non-ship cursor');
806:

Line 808: DBMS_SQL.Bind_Variable(ns_cursor, ':X_request_id',

804: -- Bind release criteria values
805: WSH_UTIL.Write_Log('Binding non-ship cursor');
806:
807: WSH_UTIL.Write_Log('X_request_id = ' || to_char(wsh_pr_picking_session.request_id));
808: DBMS_SQL.Bind_Variable(ns_cursor, ':X_request_id',
809: wsh_pr_picking_session.request_id);
810:
811: IF (wsh_pr_picking_session.header_id <> 0) THEN
812: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));

Line 813: DBMS_SQL.Bind_Variable(ns_cursor, ':X_header_id',

809: wsh_pr_picking_session.request_id);
810:
811: IF (wsh_pr_picking_session.header_id <> 0) THEN
812: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
813: DBMS_SQL.Bind_Variable(ns_cursor, ':X_header_id',
814: wsh_pr_picking_session.header_id);
815: END IF;
816: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
817: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_type_id',

Line 817: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_type_id',

813: DBMS_SQL.Bind_Variable(ns_cursor, ':X_header_id',
814: wsh_pr_picking_session.header_id);
815: END IF;
816: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
817: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_type_id',
818: wsh_pr_picking_session.order_type_id);
819: IF (wsh_pr_picking_session.customer_id <> 0) THEN
820: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
821: DBMS_SQL.Bind_Variable(ns_cursor, ':X_customer_id',

Line 821: DBMS_SQL.Bind_Variable(ns_cursor, ':X_customer_id',

817: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_type_id',
818: wsh_pr_picking_session.order_type_id);
819: IF (wsh_pr_picking_session.customer_id <> 0) THEN
820: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
821: DBMS_SQL.Bind_Variable(ns_cursor, ':X_customer_id',
822: wsh_pr_picking_session.customer_id);
823: END IF;
824:
825: IF (wsh_pr_picking_session.order_line_id <> 0) THEN

Line 827: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_line_id',

823: END IF;
824:
825: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
826: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));
827: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_line_id',
828: wsh_pr_picking_session.order_line_id);
829: END IF;
830:
831: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));

Line 832: DBMS_SQL.Bind_Variable(ns_cursor, ':X_ship_set_number',

828: wsh_pr_picking_session.order_line_id);
829: END IF;
830:
831: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
832: DBMS_SQL.Bind_Variable(ns_cursor, ':X_ship_set_number',
833: wsh_pr_picking_session.ship_set_number);
834: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
835: DBMS_SQL.Bind_Variable(ns_cursor, ':X_warehouse_id',
836: wsh_pr_picking_session.warehouse_id);

Line 835: DBMS_SQL.Bind_Variable(ns_cursor, ':X_warehouse_id',

831: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
832: DBMS_SQL.Bind_Variable(ns_cursor, ':X_ship_set_number',
833: wsh_pr_picking_session.ship_set_number);
834: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
835: DBMS_SQL.Bind_Variable(ns_cursor, ':X_warehouse_id',
836: wsh_pr_picking_session.warehouse_id);
837: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
838: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_request_date',
839: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 838: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_request_date',

834: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
835: DBMS_SQL.Bind_Variable(ns_cursor, ':X_warehouse_id',
836: wsh_pr_picking_session.warehouse_id);
837: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
838: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_request_date',
839: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
840: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
841: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_request_date',
842: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 841: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_request_date',

837: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
838: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_request_date',
839: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
840: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
841: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_request_date',
842: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
843: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
844: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_sched_ship_date',
845: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 844: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_sched_ship_date',

840: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
841: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_request_date',
842: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
843: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
844: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_sched_ship_date',
845: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
846: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
847: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_sched_ship_date',
848: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 847: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_sched_ship_date',

843: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
844: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_sched_ship_date',
845: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
846: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
847: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_sched_ship_date',
848: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
849: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
850: DBMS_SQL.Bind_Variable(ns_cursor, ':X_inventory_item_id',
851: wsh_pr_picking_session.inventory_item_id);

Line 850: DBMS_SQL.Bind_Variable(ns_cursor, ':X_inventory_item_id',

846: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
847: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_sched_ship_date',
848: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
849: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
850: DBMS_SQL.Bind_Variable(ns_cursor, ':X_inventory_item_id',
851: wsh_pr_picking_session.inventory_item_id);
852: IF (wsh_pr_picking_session.departure_id <> 0) THEN
853: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
854: DBMS_SQL.Bind_Variable(ns_cursor, ':X_departure_id',

Line 854: DBMS_SQL.Bind_Variable(ns_cursor, ':X_departure_id',

850: DBMS_SQL.Bind_Variable(ns_cursor, ':X_inventory_item_id',
851: wsh_pr_picking_session.inventory_item_id);
852: IF (wsh_pr_picking_session.departure_id <> 0) THEN
853: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
854: DBMS_SQL.Bind_Variable(ns_cursor, ':X_departure_id',
855: wsh_pr_picking_session.departure_id);
856: END IF;
857: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
858: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));

Line 859: DBMS_SQL.Bind_Variable(ns_cursor, ':X_delivery_id',

855: wsh_pr_picking_session.departure_id);
856: END IF;
857: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
858: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
859: DBMS_SQL.Bind_Variable(ns_cursor, ':X_delivery_id',
860: wsh_pr_picking_session.delivery_id);
861: END IF;
862:
863: -- Execute the cursor

Line 865: v_ignore := DBMS_SQL.Execute(ns_cursor);

861: END IF;
862:
863: -- Execute the cursor
864: WSH_UTIL.Write_Log('Executing non-ship cursor');
865: v_ignore := DBMS_SQL.Execute(ns_cursor);
866:
867: ELSE
868: WSH_UTIL.Write_Log('Invalid mode for Open_Execute_Cursor');
869: RETURN FAILURE;

Line 1180: IF DBMS_SQL.Fetch_Rows(u_cursor) > 0 THEN

1176: -- Fetch unreleased lines only
1177: --
1178: line := 1;
1179: IF backorder_mode = 'E' THEN
1180: IF DBMS_SQL.Fetch_Rows(u_cursor) > 0 THEN
1181: Map_Col_Value('u');
1182: Insert_RL_Row('u');
1183: RETURN SUCCESS;
1184: ELSE

Line 1185: DBMS_SQL.Close_Cursor(u_cursor);

1181: Map_Col_Value('u');
1182: Insert_RL_Row('u');
1183: RETURN SUCCESS;
1184: ELSE
1185: DBMS_SQL.Close_Cursor(u_cursor);
1186: RETURN DONE;
1187: END IF;
1188:
1189: --

Line 1195: IF DBMS_SQL.Fetch_Rows(b_cursor) > 0 THEN

1191: --
1192: ELSIF backorder_mode = 'O' THEN
1193:
1194: line := 2;
1195: IF DBMS_SQL.Fetch_Rows(b_cursor) > 0 THEN
1196: Map_Col_Value('b');
1197: Insert_RL_Row('b');
1198: RETURN SUCCESS;
1199: ELSE

Line 1200: DBMS_SQL.Close_Cursor(b_cursor);

1196: Map_Col_Value('b');
1197: Insert_RL_Row('b');
1198: RETURN SUCCESS;
1199: ELSE
1200: DBMS_SQL.Close_Cursor(b_cursor);
1201: RETURN DONE;
1202: END IF;
1203: --
1204: -- Fetch both unreleased and backordered lines, and compare

Line 1212: IF DBMS_SQL.Fetch_Rows(u_cursor) > 0 THEN

1208: -- Fetch row from unreleased lines cursor
1209: line := 3;
1210: IF first_call_gld = 'Y' THEN
1211: line := 4;
1212: IF DBMS_SQL.Fetch_Rows(u_cursor) > 0 THEN
1213: line := 41;
1214: Map_Col_Value('u');
1215: ELSE
1216: WSH_UTIL.Write_Log('Closing cursor u');

Line 1217: DBMS_SQL.Close_Cursor(u_cursor);

1213: line := 41;
1214: Map_Col_Value('u');
1215: ELSE
1216: WSH_UTIL.Write_Log('Closing cursor u');
1217: DBMS_SQL.Close_Cursor(u_cursor);
1218: END IF;
1219:
1220: line := 5;
1221: IF DBMS_SQL.Fetch_Rows(b_cursor) > 0 THEN

Line 1221: IF DBMS_SQL.Fetch_Rows(b_cursor) > 0 THEN

1217: DBMS_SQL.Close_Cursor(u_cursor);
1218: END IF;
1219:
1220: line := 5;
1221: IF DBMS_SQL.Fetch_Rows(b_cursor) > 0 THEN
1222: Map_Col_Value('b');
1223: ELSE
1224: WSH_UTIL.Write_Log('Closing cursor b');
1225: DBMS_SQL.Close_Cursor(b_cursor);

Line 1225: DBMS_SQL.Close_Cursor(b_cursor);

1221: IF DBMS_SQL.Fetch_Rows(b_cursor) > 0 THEN
1222: Map_Col_Value('b');
1223: ELSE
1224: WSH_UTIL.Write_Log('Closing cursor b');
1225: DBMS_SQL.Close_Cursor(b_cursor);
1226: END IF;
1227:
1228: line := 6;
1229: IF NOT DBMS_SQL.Is_Open(u_cursor) AND NOT DBMS_SQL.Is_Open(b_cursor) THEN

Line 1229: IF NOT DBMS_SQL.Is_Open(u_cursor) AND NOT DBMS_SQL.Is_Open(b_cursor) THEN

1225: DBMS_SQL.Close_Cursor(b_cursor);
1226: END IF;
1227:
1228: line := 6;
1229: IF NOT DBMS_SQL.Is_Open(u_cursor) AND NOT DBMS_SQL.Is_Open(b_cursor) THEN
1230: first_call_gld := 'N';
1231: RETURN DONE;
1232: END IF;
1233:

Line 1235: IF NOT DBMS_SQL.Is_Open(u_cursor) THEN

1231: RETURN DONE;
1232: END IF;
1233:
1234: line := 7;
1235: IF NOT DBMS_SQL.Is_Open(u_cursor) THEN
1236: Insert_RL_Row('b');
1237: first_call_gld := 'N';
1238: RETURN SUCCESS;
1239: END IF;

Line 1242: IF NOT DBMS_SQL.Is_Open(b_cursor) THEN

1238: RETURN SUCCESS;
1239: END IF;
1240:
1241: line := 8;
1242: IF NOT DBMS_SQL.Is_Open(b_cursor) THEN
1243: line := 81;
1244: Insert_RL_Row('u');
1245: first_call_gld := 'N';
1246: RETURN SUCCESS;

Line 1252: IF NOT DBMS_SQL.Is_Open(b_cursor) THEN

1248: first_call_gld := 'N';
1249: END IF;
1250:
1251: line := 9;
1252: IF NOT DBMS_SQL.Is_Open(b_cursor) THEN
1253: IF DBMS_SQL.Fetch_Rows(u_cursor) > 0 THEN
1254: Map_Col_Value('u');
1255: Insert_RL_Row('u');
1256: RETURN SUCCESS;

Line 1253: IF DBMS_SQL.Fetch_Rows(u_cursor) > 0 THEN

1249: END IF;
1250:
1251: line := 9;
1252: IF NOT DBMS_SQL.Is_Open(b_cursor) THEN
1253: IF DBMS_SQL.Fetch_Rows(u_cursor) > 0 THEN
1254: Map_Col_Value('u');
1255: Insert_RL_Row('u');
1256: RETURN SUCCESS;
1257: ELSE

Line 1258: DBMS_SQL.Close_Cursor(u_cursor);

1254: Map_Col_Value('u');
1255: Insert_RL_Row('u');
1256: RETURN SUCCESS;
1257: ELSE
1258: DBMS_SQL.Close_Cursor(u_cursor);
1259: RETURN DONE;
1260: END IF;
1261: ELSIF NOT DBMS_SQL.Is_Open(u_cursor) THEN
1262: line := 10;

Line 1261: ELSIF NOT DBMS_SQL.Is_Open(u_cursor) THEN

1257: ELSE
1258: DBMS_SQL.Close_Cursor(u_cursor);
1259: RETURN DONE;
1260: END IF;
1261: ELSIF NOT DBMS_SQL.Is_Open(u_cursor) THEN
1262: line := 10;
1263: IF DBMS_SQL.Fetch_Rows(b_cursor) > 0 THEN
1264: Map_Col_Value('b');
1265: Insert_RL_Row('b');

Line 1263: IF DBMS_SQL.Fetch_Rows(b_cursor) > 0 THEN

1259: RETURN DONE;
1260: END IF;
1261: ELSIF NOT DBMS_SQL.Is_Open(u_cursor) THEN
1262: line := 10;
1263: IF DBMS_SQL.Fetch_Rows(b_cursor) > 0 THEN
1264: Map_Col_Value('b');
1265: Insert_RL_Row('b');
1266: RETURN SUCCESS;
1267: ELSE

Line 1268: DBMS_SQL.Close_Cursor(b_cursor);

1264: Map_Col_Value('b');
1265: Insert_RL_Row('b');
1266: RETURN SUCCESS;
1267: ELSE
1268: DBMS_SQL.Close_Cursor(b_cursor);
1269: RETURN DONE;
1270: END IF;
1271: ELSE
1272: line := 11;

Line 1288: IF DBMS_SQL.Fetch_Rows(u_cursor) > 0 THEN

1284: b_shipment_priority);
1285:
1286: IF next_line = 'u' THEN
1287: Insert_RL_Row('u');
1288: IF DBMS_SQL.Fetch_Rows(u_cursor) > 0 THEN
1289: Map_Col_Value('u');
1290: RETURN SUCCESS;
1291: ELSE
1292: DBMS_SQL.Close_Cursor(u_cursor);

Line 1292: DBMS_SQL.Close_Cursor(u_cursor);

1288: IF DBMS_SQL.Fetch_Rows(u_cursor) > 0 THEN
1289: Map_Col_Value('u');
1290: RETURN SUCCESS;
1291: ELSE
1292: DBMS_SQL.Close_Cursor(u_cursor);
1293: Insert_RL_Row('b');
1294: RETURN SUCCESS;
1295: END IF;
1296: ELSIF next_line = 'b' THEN

Line 1298: IF DBMS_SQL.Fetch_Rows(b_cursor) > 0 THEN

1294: RETURN SUCCESS;
1295: END IF;
1296: ELSIF next_line = 'b' THEN
1297: Insert_RL_Row('b');
1298: IF DBMS_SQL.Fetch_Rows(b_cursor) > 0 THEN
1299: Map_Col_Value('b');
1300: RETURN SUCCESS;
1301: ELSE
1302: DBMS_SQL.Close_Cursor(b_cursor);

Line 1302: DBMS_SQL.Close_Cursor(b_cursor);

1298: IF DBMS_SQL.Fetch_Rows(b_cursor) > 0 THEN
1299: Map_Col_Value('b');
1300: RETURN SUCCESS;
1301: ELSE
1302: DBMS_SQL.Close_Cursor(b_cursor);
1303: Insert_RL_Row('u');
1304: RETURN SUCCESS;
1305: END IF;
1306: END IF;

Line 1309: IF NOT DBMS_SQL.Is_Open(u_cursor) AND NOT DBMS_SQL.Is_Open(b_cursor) THEN

1305: END IF;
1306: END IF;
1307:
1308: line := 12;
1309: IF NOT DBMS_SQL.Is_Open(u_cursor) AND NOT DBMS_SQL.Is_Open(b_cursor) THEN
1310: RETURN DONE;
1311: END IF;
1312:
1313: END IF;

Line 1334: -- row call to DBMS_SQL. Utility to go with DBMS_SQL.

1330: --
1331: -- Purpose
1332: -- This function maps the column value from the cursor
1333: -- to the variable (based on the source) after each fetch
1334: -- row call to DBMS_SQL. Utility to go with DBMS_SQL.
1335: --
1336: -- Arguments
1337: -- p_source - indicates whether to map the value for
1338: -- backordered lines ('b') or unreleased

Line 1352: DBMS_SQL.Column_Value(u_cursor, 1, u_line_id);

1348: cs BINARY_INTEGER;
1349:
1350: BEGIN
1351: IF p_source = 'u' THEN
1352: DBMS_SQL.Column_Value(u_cursor, 1, u_line_id);
1353: DBMS_SQL.Column_Value(u_cursor, 2, u_header_id);
1354: DBMS_SQL.Column_Value(u_cursor, 3, u_org_id);
1355: DBMS_SQL.Column_Value(u_cursor, 4, u_ato_flag);
1356: DBMS_SQL.Column_Value(u_cursor, 5, u_line_detail_id);

Line 1353: DBMS_SQL.Column_Value(u_cursor, 2, u_header_id);

1349:
1350: BEGIN
1351: IF p_source = 'u' THEN
1352: DBMS_SQL.Column_Value(u_cursor, 1, u_line_id);
1353: DBMS_SQL.Column_Value(u_cursor, 2, u_header_id);
1354: DBMS_SQL.Column_Value(u_cursor, 3, u_org_id);
1355: DBMS_SQL.Column_Value(u_cursor, 4, u_ato_flag);
1356: DBMS_SQL.Column_Value(u_cursor, 5, u_line_detail_id);
1357: DBMS_SQL.Column_Value(u_cursor, 6, u_ship_model_complete);

Line 1354: DBMS_SQL.Column_Value(u_cursor, 3, u_org_id);

1350: BEGIN
1351: IF p_source = 'u' THEN
1352: DBMS_SQL.Column_Value(u_cursor, 1, u_line_id);
1353: DBMS_SQL.Column_Value(u_cursor, 2, u_header_id);
1354: DBMS_SQL.Column_Value(u_cursor, 3, u_org_id);
1355: DBMS_SQL.Column_Value(u_cursor, 4, u_ato_flag);
1356: DBMS_SQL.Column_Value(u_cursor, 5, u_line_detail_id);
1357: DBMS_SQL.Column_Value(u_cursor, 6, u_ship_model_complete);
1358: DBMS_SQL.Column_Value(u_cursor, 7, u_ship_set_number);

Line 1355: DBMS_SQL.Column_Value(u_cursor, 4, u_ato_flag);

1351: IF p_source = 'u' THEN
1352: DBMS_SQL.Column_Value(u_cursor, 1, u_line_id);
1353: DBMS_SQL.Column_Value(u_cursor, 2, u_header_id);
1354: DBMS_SQL.Column_Value(u_cursor, 3, u_org_id);
1355: DBMS_SQL.Column_Value(u_cursor, 4, u_ato_flag);
1356: DBMS_SQL.Column_Value(u_cursor, 5, u_line_detail_id);
1357: DBMS_SQL.Column_Value(u_cursor, 6, u_ship_model_complete);
1358: DBMS_SQL.Column_Value(u_cursor, 7, u_ship_set_number);
1359: DBMS_SQL.Column_Value(u_cursor, 8, u_parent_line_id);

Line 1356: DBMS_SQL.Column_Value(u_cursor, 5, u_line_detail_id);

1352: DBMS_SQL.Column_Value(u_cursor, 1, u_line_id);
1353: DBMS_SQL.Column_Value(u_cursor, 2, u_header_id);
1354: DBMS_SQL.Column_Value(u_cursor, 3, u_org_id);
1355: DBMS_SQL.Column_Value(u_cursor, 4, u_ato_flag);
1356: DBMS_SQL.Column_Value(u_cursor, 5, u_line_detail_id);
1357: DBMS_SQL.Column_Value(u_cursor, 6, u_ship_model_complete);
1358: DBMS_SQL.Column_Value(u_cursor, 7, u_ship_set_number);
1359: DBMS_SQL.Column_Value(u_cursor, 8, u_parent_line_id);
1360: DBMS_SQL.Column_Value(u_cursor, 9, u_ld_warehouse_id);

Line 1357: DBMS_SQL.Column_Value(u_cursor, 6, u_ship_model_complete);

1353: DBMS_SQL.Column_Value(u_cursor, 2, u_header_id);
1354: DBMS_SQL.Column_Value(u_cursor, 3, u_org_id);
1355: DBMS_SQL.Column_Value(u_cursor, 4, u_ato_flag);
1356: DBMS_SQL.Column_Value(u_cursor, 5, u_line_detail_id);
1357: DBMS_SQL.Column_Value(u_cursor, 6, u_ship_model_complete);
1358: DBMS_SQL.Column_Value(u_cursor, 7, u_ship_set_number);
1359: DBMS_SQL.Column_Value(u_cursor, 8, u_parent_line_id);
1360: DBMS_SQL.Column_Value(u_cursor, 9, u_ld_warehouse_id);
1361: DBMS_SQL.Column_Value(u_cursor, 10, u_ship_to_site_use_id);

Line 1358: DBMS_SQL.Column_Value(u_cursor, 7, u_ship_set_number);

1354: DBMS_SQL.Column_Value(u_cursor, 3, u_org_id);
1355: DBMS_SQL.Column_Value(u_cursor, 4, u_ato_flag);
1356: DBMS_SQL.Column_Value(u_cursor, 5, u_line_detail_id);
1357: DBMS_SQL.Column_Value(u_cursor, 6, u_ship_model_complete);
1358: DBMS_SQL.Column_Value(u_cursor, 7, u_ship_set_number);
1359: DBMS_SQL.Column_Value(u_cursor, 8, u_parent_line_id);
1360: DBMS_SQL.Column_Value(u_cursor, 9, u_ld_warehouse_id);
1361: DBMS_SQL.Column_Value(u_cursor, 10, u_ship_to_site_use_id);
1362: DBMS_SQL.Column_Value(u_cursor, 11, u_ship_to_contact_id);

Line 1359: DBMS_SQL.Column_Value(u_cursor, 8, u_parent_line_id);

1355: DBMS_SQL.Column_Value(u_cursor, 4, u_ato_flag);
1356: DBMS_SQL.Column_Value(u_cursor, 5, u_line_detail_id);
1357: DBMS_SQL.Column_Value(u_cursor, 6, u_ship_model_complete);
1358: DBMS_SQL.Column_Value(u_cursor, 7, u_ship_set_number);
1359: DBMS_SQL.Column_Value(u_cursor, 8, u_parent_line_id);
1360: DBMS_SQL.Column_Value(u_cursor, 9, u_ld_warehouse_id);
1361: DBMS_SQL.Column_Value(u_cursor, 10, u_ship_to_site_use_id);
1362: DBMS_SQL.Column_Value(u_cursor, 11, u_ship_to_contact_id);
1363: DBMS_SQL.Column_Value(u_cursor, 12, u_ship_method_code);

Line 1360: DBMS_SQL.Column_Value(u_cursor, 9, u_ld_warehouse_id);

1356: DBMS_SQL.Column_Value(u_cursor, 5, u_line_detail_id);
1357: DBMS_SQL.Column_Value(u_cursor, 6, u_ship_model_complete);
1358: DBMS_SQL.Column_Value(u_cursor, 7, u_ship_set_number);
1359: DBMS_SQL.Column_Value(u_cursor, 8, u_parent_line_id);
1360: DBMS_SQL.Column_Value(u_cursor, 9, u_ld_warehouse_id);
1361: DBMS_SQL.Column_Value(u_cursor, 10, u_ship_to_site_use_id);
1362: DBMS_SQL.Column_Value(u_cursor, 11, u_ship_to_contact_id);
1363: DBMS_SQL.Column_Value(u_cursor, 12, u_ship_method_code);
1364: DBMS_SQL.Column_Value(u_cursor, 13, u_shipment_priority);

Line 1361: DBMS_SQL.Column_Value(u_cursor, 10, u_ship_to_site_use_id);

1357: DBMS_SQL.Column_Value(u_cursor, 6, u_ship_model_complete);
1358: DBMS_SQL.Column_Value(u_cursor, 7, u_ship_set_number);
1359: DBMS_SQL.Column_Value(u_cursor, 8, u_parent_line_id);
1360: DBMS_SQL.Column_Value(u_cursor, 9, u_ld_warehouse_id);
1361: DBMS_SQL.Column_Value(u_cursor, 10, u_ship_to_site_use_id);
1362: DBMS_SQL.Column_Value(u_cursor, 11, u_ship_to_contact_id);
1363: DBMS_SQL.Column_Value(u_cursor, 12, u_ship_method_code);
1364: DBMS_SQL.Column_Value(u_cursor, 13, u_shipment_priority);
1365: DBMS_SQL.Column_Value(u_cursor, 14, u_departure_id);

Line 1362: DBMS_SQL.Column_Value(u_cursor, 11, u_ship_to_contact_id);

1358: DBMS_SQL.Column_Value(u_cursor, 7, u_ship_set_number);
1359: DBMS_SQL.Column_Value(u_cursor, 8, u_parent_line_id);
1360: DBMS_SQL.Column_Value(u_cursor, 9, u_ld_warehouse_id);
1361: DBMS_SQL.Column_Value(u_cursor, 10, u_ship_to_site_use_id);
1362: DBMS_SQL.Column_Value(u_cursor, 11, u_ship_to_contact_id);
1363: DBMS_SQL.Column_Value(u_cursor, 12, u_ship_method_code);
1364: DBMS_SQL.Column_Value(u_cursor, 13, u_shipment_priority);
1365: DBMS_SQL.Column_Value(u_cursor, 14, u_departure_id);
1366: DBMS_SQL.Column_Value(u_cursor, 15, u_delivery_id);

Line 1363: DBMS_SQL.Column_Value(u_cursor, 12, u_ship_method_code);

1359: DBMS_SQL.Column_Value(u_cursor, 8, u_parent_line_id);
1360: DBMS_SQL.Column_Value(u_cursor, 9, u_ld_warehouse_id);
1361: DBMS_SQL.Column_Value(u_cursor, 10, u_ship_to_site_use_id);
1362: DBMS_SQL.Column_Value(u_cursor, 11, u_ship_to_contact_id);
1363: DBMS_SQL.Column_Value(u_cursor, 12, u_ship_method_code);
1364: DBMS_SQL.Column_Value(u_cursor, 13, u_shipment_priority);
1365: DBMS_SQL.Column_Value(u_cursor, 14, u_departure_id);
1366: DBMS_SQL.Column_Value(u_cursor, 15, u_delivery_id);
1367: DBMS_SQL.Column_Value(u_cursor, 16, u_item_type_code);

Line 1364: DBMS_SQL.Column_Value(u_cursor, 13, u_shipment_priority);

1360: DBMS_SQL.Column_Value(u_cursor, 9, u_ld_warehouse_id);
1361: DBMS_SQL.Column_Value(u_cursor, 10, u_ship_to_site_use_id);
1362: DBMS_SQL.Column_Value(u_cursor, 11, u_ship_to_contact_id);
1363: DBMS_SQL.Column_Value(u_cursor, 12, u_ship_method_code);
1364: DBMS_SQL.Column_Value(u_cursor, 13, u_shipment_priority);
1365: DBMS_SQL.Column_Value(u_cursor, 14, u_departure_id);
1366: DBMS_SQL.Column_Value(u_cursor, 15, u_delivery_id);
1367: DBMS_SQL.Column_Value(u_cursor, 16, u_item_type_code);
1368: DBMS_SQL.Column_Value(u_cursor, 17, u_schedule_date);

Line 1365: DBMS_SQL.Column_Value(u_cursor, 14, u_departure_id);

1361: DBMS_SQL.Column_Value(u_cursor, 10, u_ship_to_site_use_id);
1362: DBMS_SQL.Column_Value(u_cursor, 11, u_ship_to_contact_id);
1363: DBMS_SQL.Column_Value(u_cursor, 12, u_ship_method_code);
1364: DBMS_SQL.Column_Value(u_cursor, 13, u_shipment_priority);
1365: DBMS_SQL.Column_Value(u_cursor, 14, u_departure_id);
1366: DBMS_SQL.Column_Value(u_cursor, 15, u_delivery_id);
1367: DBMS_SQL.Column_Value(u_cursor, 16, u_item_type_code);
1368: DBMS_SQL.Column_Value(u_cursor, 17, u_schedule_date);
1369: DBMS_SQL.Column_Value(u_cursor, 18, u_ordered_quantity);

Line 1366: DBMS_SQL.Column_Value(u_cursor, 15, u_delivery_id);

1362: DBMS_SQL.Column_Value(u_cursor, 11, u_ship_to_contact_id);
1363: DBMS_SQL.Column_Value(u_cursor, 12, u_ship_method_code);
1364: DBMS_SQL.Column_Value(u_cursor, 13, u_shipment_priority);
1365: DBMS_SQL.Column_Value(u_cursor, 14, u_departure_id);
1366: DBMS_SQL.Column_Value(u_cursor, 15, u_delivery_id);
1367: DBMS_SQL.Column_Value(u_cursor, 16, u_item_type_code);
1368: DBMS_SQL.Column_Value(u_cursor, 17, u_schedule_date);
1369: DBMS_SQL.Column_Value(u_cursor, 18, u_ordered_quantity);
1370: DBMS_SQL.Column_Value(u_cursor, 19, u_cancelled_quantity);

Line 1367: DBMS_SQL.Column_Value(u_cursor, 16, u_item_type_code);

1363: DBMS_SQL.Column_Value(u_cursor, 12, u_ship_method_code);
1364: DBMS_SQL.Column_Value(u_cursor, 13, u_shipment_priority);
1365: DBMS_SQL.Column_Value(u_cursor, 14, u_departure_id);
1366: DBMS_SQL.Column_Value(u_cursor, 15, u_delivery_id);
1367: DBMS_SQL.Column_Value(u_cursor, 16, u_item_type_code);
1368: DBMS_SQL.Column_Value(u_cursor, 17, u_schedule_date);
1369: DBMS_SQL.Column_Value(u_cursor, 18, u_ordered_quantity);
1370: DBMS_SQL.Column_Value(u_cursor, 19, u_cancelled_quantity);
1371: DBMS_SQL.Column_Value(u_cursor, 20, u_l_inventory_item_id);

Line 1368: DBMS_SQL.Column_Value(u_cursor, 17, u_schedule_date);

1364: DBMS_SQL.Column_Value(u_cursor, 13, u_shipment_priority);
1365: DBMS_SQL.Column_Value(u_cursor, 14, u_departure_id);
1366: DBMS_SQL.Column_Value(u_cursor, 15, u_delivery_id);
1367: DBMS_SQL.Column_Value(u_cursor, 16, u_item_type_code);
1368: DBMS_SQL.Column_Value(u_cursor, 17, u_schedule_date);
1369: DBMS_SQL.Column_Value(u_cursor, 18, u_ordered_quantity);
1370: DBMS_SQL.Column_Value(u_cursor, 19, u_cancelled_quantity);
1371: DBMS_SQL.Column_Value(u_cursor, 20, u_l_inventory_item_id);
1372: DBMS_SQL.Column_Value(u_cursor, 21, u_ld_inventory_item_id);

Line 1369: DBMS_SQL.Column_Value(u_cursor, 18, u_ordered_quantity);

1365: DBMS_SQL.Column_Value(u_cursor, 14, u_departure_id);
1366: DBMS_SQL.Column_Value(u_cursor, 15, u_delivery_id);
1367: DBMS_SQL.Column_Value(u_cursor, 16, u_item_type_code);
1368: DBMS_SQL.Column_Value(u_cursor, 17, u_schedule_date);
1369: DBMS_SQL.Column_Value(u_cursor, 18, u_ordered_quantity);
1370: DBMS_SQL.Column_Value(u_cursor, 19, u_cancelled_quantity);
1371: DBMS_SQL.Column_Value(u_cursor, 20, u_l_inventory_item_id);
1372: DBMS_SQL.Column_Value(u_cursor, 21, u_ld_inventory_item_id);
1373: DBMS_SQL.Column_Value(u_cursor, 22, u_customer_item_id);

Line 1370: DBMS_SQL.Column_Value(u_cursor, 19, u_cancelled_quantity);

1366: DBMS_SQL.Column_Value(u_cursor, 15, u_delivery_id);
1367: DBMS_SQL.Column_Value(u_cursor, 16, u_item_type_code);
1368: DBMS_SQL.Column_Value(u_cursor, 17, u_schedule_date);
1369: DBMS_SQL.Column_Value(u_cursor, 18, u_ordered_quantity);
1370: DBMS_SQL.Column_Value(u_cursor, 19, u_cancelled_quantity);
1371: DBMS_SQL.Column_Value(u_cursor, 20, u_l_inventory_item_id);
1372: DBMS_SQL.Column_Value(u_cursor, 21, u_ld_inventory_item_id);
1373: DBMS_SQL.Column_Value(u_cursor, 22, u_customer_item_id);
1374: DBMS_SQL.Column_Value(u_cursor, 23, u_dep_plan_required_flag);

Line 1371: DBMS_SQL.Column_Value(u_cursor, 20, u_l_inventory_item_id);

1367: DBMS_SQL.Column_Value(u_cursor, 16, u_item_type_code);
1368: DBMS_SQL.Column_Value(u_cursor, 17, u_schedule_date);
1369: DBMS_SQL.Column_Value(u_cursor, 18, u_ordered_quantity);
1370: DBMS_SQL.Column_Value(u_cursor, 19, u_cancelled_quantity);
1371: DBMS_SQL.Column_Value(u_cursor, 20, u_l_inventory_item_id);
1372: DBMS_SQL.Column_Value(u_cursor, 21, u_ld_inventory_item_id);
1373: DBMS_SQL.Column_Value(u_cursor, 22, u_customer_item_id);
1374: DBMS_SQL.Column_Value(u_cursor, 23, u_dep_plan_required_flag);
1375: DBMS_SQL.Column_Value(u_cursor, 24, u_shipment_schedule_line_id);

Line 1372: DBMS_SQL.Column_Value(u_cursor, 21, u_ld_inventory_item_id);

1368: DBMS_SQL.Column_Value(u_cursor, 17, u_schedule_date);
1369: DBMS_SQL.Column_Value(u_cursor, 18, u_ordered_quantity);
1370: DBMS_SQL.Column_Value(u_cursor, 19, u_cancelled_quantity);
1371: DBMS_SQL.Column_Value(u_cursor, 20, u_l_inventory_item_id);
1372: DBMS_SQL.Column_Value(u_cursor, 21, u_ld_inventory_item_id);
1373: DBMS_SQL.Column_Value(u_cursor, 22, u_customer_item_id);
1374: DBMS_SQL.Column_Value(u_cursor, 23, u_dep_plan_required_flag);
1375: DBMS_SQL.Column_Value(u_cursor, 24, u_shipment_schedule_line_id);
1376: DBMS_SQL.Column_Value(u_cursor, 25, u_unit_code);

Line 1373: DBMS_SQL.Column_Value(u_cursor, 22, u_customer_item_id);

1369: DBMS_SQL.Column_Value(u_cursor, 18, u_ordered_quantity);
1370: DBMS_SQL.Column_Value(u_cursor, 19, u_cancelled_quantity);
1371: DBMS_SQL.Column_Value(u_cursor, 20, u_l_inventory_item_id);
1372: DBMS_SQL.Column_Value(u_cursor, 21, u_ld_inventory_item_id);
1373: DBMS_SQL.Column_Value(u_cursor, 22, u_customer_item_id);
1374: DBMS_SQL.Column_Value(u_cursor, 23, u_dep_plan_required_flag);
1375: DBMS_SQL.Column_Value(u_cursor, 24, u_shipment_schedule_line_id);
1376: DBMS_SQL.Column_Value(u_cursor, 25, u_unit_code);
1377: DBMS_SQL.Column_Value(u_cursor, 26, u_line_type_code);

Line 1374: DBMS_SQL.Column_Value(u_cursor, 23, u_dep_plan_required_flag);

1370: DBMS_SQL.Column_Value(u_cursor, 19, u_cancelled_quantity);
1371: DBMS_SQL.Column_Value(u_cursor, 20, u_l_inventory_item_id);
1372: DBMS_SQL.Column_Value(u_cursor, 21, u_ld_inventory_item_id);
1373: DBMS_SQL.Column_Value(u_cursor, 22, u_customer_item_id);
1374: DBMS_SQL.Column_Value(u_cursor, 23, u_dep_plan_required_flag);
1375: DBMS_SQL.Column_Value(u_cursor, 24, u_shipment_schedule_line_id);
1376: DBMS_SQL.Column_Value(u_cursor, 25, u_unit_code);
1377: DBMS_SQL.Column_Value(u_cursor, 26, u_line_type_code);
1378: DBMS_SQL.Column_Value(u_cursor, 27, u_component_code);

Line 1375: DBMS_SQL.Column_Value(u_cursor, 24, u_shipment_schedule_line_id);

1371: DBMS_SQL.Column_Value(u_cursor, 20, u_l_inventory_item_id);
1372: DBMS_SQL.Column_Value(u_cursor, 21, u_ld_inventory_item_id);
1373: DBMS_SQL.Column_Value(u_cursor, 22, u_customer_item_id);
1374: DBMS_SQL.Column_Value(u_cursor, 23, u_dep_plan_required_flag);
1375: DBMS_SQL.Column_Value(u_cursor, 24, u_shipment_schedule_line_id);
1376: DBMS_SQL.Column_Value(u_cursor, 25, u_unit_code);
1377: DBMS_SQL.Column_Value(u_cursor, 26, u_line_type_code);
1378: DBMS_SQL.Column_Value(u_cursor, 27, u_component_code);
1379: DBMS_SQL.Column_Value(u_cursor, 28, u_standard_comp_freeze_date);

Line 1376: DBMS_SQL.Column_Value(u_cursor, 25, u_unit_code);

1372: DBMS_SQL.Column_Value(u_cursor, 21, u_ld_inventory_item_id);
1373: DBMS_SQL.Column_Value(u_cursor, 22, u_customer_item_id);
1374: DBMS_SQL.Column_Value(u_cursor, 23, u_dep_plan_required_flag);
1375: DBMS_SQL.Column_Value(u_cursor, 24, u_shipment_schedule_line_id);
1376: DBMS_SQL.Column_Value(u_cursor, 25, u_unit_code);
1377: DBMS_SQL.Column_Value(u_cursor, 26, u_line_type_code);
1378: DBMS_SQL.Column_Value(u_cursor, 27, u_component_code);
1379: DBMS_SQL.Column_Value(u_cursor, 28, u_standard_comp_freeze_date);
1380: DBMS_SQL.Column_Value(u_cursor, 29, u_order_number);

Line 1377: DBMS_SQL.Column_Value(u_cursor, 26, u_line_type_code);

1373: DBMS_SQL.Column_Value(u_cursor, 22, u_customer_item_id);
1374: DBMS_SQL.Column_Value(u_cursor, 23, u_dep_plan_required_flag);
1375: DBMS_SQL.Column_Value(u_cursor, 24, u_shipment_schedule_line_id);
1376: DBMS_SQL.Column_Value(u_cursor, 25, u_unit_code);
1377: DBMS_SQL.Column_Value(u_cursor, 26, u_line_type_code);
1378: DBMS_SQL.Column_Value(u_cursor, 27, u_component_code);
1379: DBMS_SQL.Column_Value(u_cursor, 28, u_standard_comp_freeze_date);
1380: DBMS_SQL.Column_Value(u_cursor, 29, u_order_number);
1381: DBMS_SQL.Column_Value(u_cursor, 30, u_order_type_id);

Line 1378: DBMS_SQL.Column_Value(u_cursor, 27, u_component_code);

1374: DBMS_SQL.Column_Value(u_cursor, 23, u_dep_plan_required_flag);
1375: DBMS_SQL.Column_Value(u_cursor, 24, u_shipment_schedule_line_id);
1376: DBMS_SQL.Column_Value(u_cursor, 25, u_unit_code);
1377: DBMS_SQL.Column_Value(u_cursor, 26, u_line_type_code);
1378: DBMS_SQL.Column_Value(u_cursor, 27, u_component_code);
1379: DBMS_SQL.Column_Value(u_cursor, 28, u_standard_comp_freeze_date);
1380: DBMS_SQL.Column_Value(u_cursor, 29, u_order_number);
1381: DBMS_SQL.Column_Value(u_cursor, 30, u_order_type_id);
1382: DBMS_SQL.Column_Value(u_cursor, 31, u_customer_id);

Line 1379: DBMS_SQL.Column_Value(u_cursor, 28, u_standard_comp_freeze_date);

1375: DBMS_SQL.Column_Value(u_cursor, 24, u_shipment_schedule_line_id);
1376: DBMS_SQL.Column_Value(u_cursor, 25, u_unit_code);
1377: DBMS_SQL.Column_Value(u_cursor, 26, u_line_type_code);
1378: DBMS_SQL.Column_Value(u_cursor, 27, u_component_code);
1379: DBMS_SQL.Column_Value(u_cursor, 28, u_standard_comp_freeze_date);
1380: DBMS_SQL.Column_Value(u_cursor, 29, u_order_number);
1381: DBMS_SQL.Column_Value(u_cursor, 30, u_order_type_id);
1382: DBMS_SQL.Column_Value(u_cursor, 31, u_customer_id);
1383: DBMS_SQL.Column_Value(u_cursor, 32, u_invoice_to_site_use_id);

Line 1380: DBMS_SQL.Column_Value(u_cursor, 29, u_order_number);

1376: DBMS_SQL.Column_Value(u_cursor, 25, u_unit_code);
1377: DBMS_SQL.Column_Value(u_cursor, 26, u_line_type_code);
1378: DBMS_SQL.Column_Value(u_cursor, 27, u_component_code);
1379: DBMS_SQL.Column_Value(u_cursor, 28, u_standard_comp_freeze_date);
1380: DBMS_SQL.Column_Value(u_cursor, 29, u_order_number);
1381: DBMS_SQL.Column_Value(u_cursor, 30, u_order_type_id);
1382: DBMS_SQL.Column_Value(u_cursor, 31, u_customer_id);
1383: DBMS_SQL.Column_Value(u_cursor, 32, u_invoice_to_site_use_id);
1384: DBMS_SQL.Column_Value(u_cursor, 33, u_planned_departure_date_d);

Line 1381: DBMS_SQL.Column_Value(u_cursor, 30, u_order_type_id);

1377: DBMS_SQL.Column_Value(u_cursor, 26, u_line_type_code);
1378: DBMS_SQL.Column_Value(u_cursor, 27, u_component_code);
1379: DBMS_SQL.Column_Value(u_cursor, 28, u_standard_comp_freeze_date);
1380: DBMS_SQL.Column_Value(u_cursor, 29, u_order_number);
1381: DBMS_SQL.Column_Value(u_cursor, 30, u_order_type_id);
1382: DBMS_SQL.Column_Value(u_cursor, 31, u_customer_id);
1383: DBMS_SQL.Column_Value(u_cursor, 32, u_invoice_to_site_use_id);
1384: DBMS_SQL.Column_Value(u_cursor, 33, u_planned_departure_date_d);
1385: DBMS_SQL.Column_Value(u_cursor, 34, u_planned_departure_date_t);

Line 1382: DBMS_SQL.Column_Value(u_cursor, 31, u_customer_id);

1378: DBMS_SQL.Column_Value(u_cursor, 27, u_component_code);
1379: DBMS_SQL.Column_Value(u_cursor, 28, u_standard_comp_freeze_date);
1380: DBMS_SQL.Column_Value(u_cursor, 29, u_order_number);
1381: DBMS_SQL.Column_Value(u_cursor, 30, u_order_type_id);
1382: DBMS_SQL.Column_Value(u_cursor, 31, u_customer_id);
1383: DBMS_SQL.Column_Value(u_cursor, 32, u_invoice_to_site_use_id);
1384: DBMS_SQL.Column_Value(u_cursor, 33, u_planned_departure_date_d);
1385: DBMS_SQL.Column_Value(u_cursor, 34, u_planned_departure_date_t);
1386: DBMS_SQL.Column_Value(u_cursor, 35, u_master_container_id);

Line 1383: DBMS_SQL.Column_Value(u_cursor, 32, u_invoice_to_site_use_id);

1379: DBMS_SQL.Column_Value(u_cursor, 28, u_standard_comp_freeze_date);
1380: DBMS_SQL.Column_Value(u_cursor, 29, u_order_number);
1381: DBMS_SQL.Column_Value(u_cursor, 30, u_order_type_id);
1382: DBMS_SQL.Column_Value(u_cursor, 31, u_customer_id);
1383: DBMS_SQL.Column_Value(u_cursor, 32, u_invoice_to_site_use_id);
1384: DBMS_SQL.Column_Value(u_cursor, 33, u_planned_departure_date_d);
1385: DBMS_SQL.Column_Value(u_cursor, 34, u_planned_departure_date_t);
1386: DBMS_SQL.Column_Value(u_cursor, 35, u_master_container_id);
1387: DBMS_SQL.Column_Value(u_cursor, 36, u_detail_container_id);

Line 1384: DBMS_SQL.Column_Value(u_cursor, 33, u_planned_departure_date_d);

1380: DBMS_SQL.Column_Value(u_cursor, 29, u_order_number);
1381: DBMS_SQL.Column_Value(u_cursor, 30, u_order_type_id);
1382: DBMS_SQL.Column_Value(u_cursor, 31, u_customer_id);
1383: DBMS_SQL.Column_Value(u_cursor, 32, u_invoice_to_site_use_id);
1384: DBMS_SQL.Column_Value(u_cursor, 33, u_planned_departure_date_d);
1385: DBMS_SQL.Column_Value(u_cursor, 34, u_planned_departure_date_t);
1386: DBMS_SQL.Column_Value(u_cursor, 35, u_master_container_id);
1387: DBMS_SQL.Column_Value(u_cursor, 36, u_detail_container_id);
1388: DBMS_SQL.Column_Value(u_cursor, 37, u_load_seq_number);

Line 1385: DBMS_SQL.Column_Value(u_cursor, 34, u_planned_departure_date_t);

1381: DBMS_SQL.Column_Value(u_cursor, 30, u_order_type_id);
1382: DBMS_SQL.Column_Value(u_cursor, 31, u_customer_id);
1383: DBMS_SQL.Column_Value(u_cursor, 32, u_invoice_to_site_use_id);
1384: DBMS_SQL.Column_Value(u_cursor, 33, u_planned_departure_date_d);
1385: DBMS_SQL.Column_Value(u_cursor, 34, u_planned_departure_date_t);
1386: DBMS_SQL.Column_Value(u_cursor, 35, u_master_container_id);
1387: DBMS_SQL.Column_Value(u_cursor, 36, u_detail_container_id);
1388: DBMS_SQL.Column_Value(u_cursor, 37, u_load_seq_number);
1389: DBMS_SQL.Column_Value(u_cursor, 38, u_invoice_value);

Line 1386: DBMS_SQL.Column_Value(u_cursor, 35, u_master_container_id);

1382: DBMS_SQL.Column_Value(u_cursor, 31, u_customer_id);
1383: DBMS_SQL.Column_Value(u_cursor, 32, u_invoice_to_site_use_id);
1384: DBMS_SQL.Column_Value(u_cursor, 33, u_planned_departure_date_d);
1385: DBMS_SQL.Column_Value(u_cursor, 34, u_planned_departure_date_t);
1386: DBMS_SQL.Column_Value(u_cursor, 35, u_master_container_id);
1387: DBMS_SQL.Column_Value(u_cursor, 36, u_detail_container_id);
1388: DBMS_SQL.Column_Value(u_cursor, 37, u_load_seq_number);
1389: DBMS_SQL.Column_Value(u_cursor, 38, u_invoice_value);
1390: ELSIF p_source = 'b' THEN

Line 1387: DBMS_SQL.Column_Value(u_cursor, 36, u_detail_container_id);

1383: DBMS_SQL.Column_Value(u_cursor, 32, u_invoice_to_site_use_id);
1384: DBMS_SQL.Column_Value(u_cursor, 33, u_planned_departure_date_d);
1385: DBMS_SQL.Column_Value(u_cursor, 34, u_planned_departure_date_t);
1386: DBMS_SQL.Column_Value(u_cursor, 35, u_master_container_id);
1387: DBMS_SQL.Column_Value(u_cursor, 36, u_detail_container_id);
1388: DBMS_SQL.Column_Value(u_cursor, 37, u_load_seq_number);
1389: DBMS_SQL.Column_Value(u_cursor, 38, u_invoice_value);
1390: ELSIF p_source = 'b' THEN
1391: DBMS_SQL.Column_Value(b_cursor, 1, b_line_id);

Line 1388: DBMS_SQL.Column_Value(u_cursor, 37, u_load_seq_number);

1384: DBMS_SQL.Column_Value(u_cursor, 33, u_planned_departure_date_d);
1385: DBMS_SQL.Column_Value(u_cursor, 34, u_planned_departure_date_t);
1386: DBMS_SQL.Column_Value(u_cursor, 35, u_master_container_id);
1387: DBMS_SQL.Column_Value(u_cursor, 36, u_detail_container_id);
1388: DBMS_SQL.Column_Value(u_cursor, 37, u_load_seq_number);
1389: DBMS_SQL.Column_Value(u_cursor, 38, u_invoice_value);
1390: ELSIF p_source = 'b' THEN
1391: DBMS_SQL.Column_Value(b_cursor, 1, b_line_id);
1392: DBMS_SQL.Column_Value(b_cursor, 2, b_header_id);

Line 1389: DBMS_SQL.Column_Value(u_cursor, 38, u_invoice_value);

1385: DBMS_SQL.Column_Value(u_cursor, 34, u_planned_departure_date_t);
1386: DBMS_SQL.Column_Value(u_cursor, 35, u_master_container_id);
1387: DBMS_SQL.Column_Value(u_cursor, 36, u_detail_container_id);
1388: DBMS_SQL.Column_Value(u_cursor, 37, u_load_seq_number);
1389: DBMS_SQL.Column_Value(u_cursor, 38, u_invoice_value);
1390: ELSIF p_source = 'b' THEN
1391: DBMS_SQL.Column_Value(b_cursor, 1, b_line_id);
1392: DBMS_SQL.Column_Value(b_cursor, 2, b_header_id);
1393: DBMS_SQL.Column_Value(b_cursor, 3, b_org_id);

Line 1391: DBMS_SQL.Column_Value(b_cursor, 1, b_line_id);

1387: DBMS_SQL.Column_Value(u_cursor, 36, u_detail_container_id);
1388: DBMS_SQL.Column_Value(u_cursor, 37, u_load_seq_number);
1389: DBMS_SQL.Column_Value(u_cursor, 38, u_invoice_value);
1390: ELSIF p_source = 'b' THEN
1391: DBMS_SQL.Column_Value(b_cursor, 1, b_line_id);
1392: DBMS_SQL.Column_Value(b_cursor, 2, b_header_id);
1393: DBMS_SQL.Column_Value(b_cursor, 3, b_org_id);
1394: DBMS_SQL.Column_Value(b_cursor, 4, b_ato_flag);
1395: DBMS_SQL.Column_Value(b_cursor, 5, b_line_detail_id);

Line 1392: DBMS_SQL.Column_Value(b_cursor, 2, b_header_id);

1388: DBMS_SQL.Column_Value(u_cursor, 37, u_load_seq_number);
1389: DBMS_SQL.Column_Value(u_cursor, 38, u_invoice_value);
1390: ELSIF p_source = 'b' THEN
1391: DBMS_SQL.Column_Value(b_cursor, 1, b_line_id);
1392: DBMS_SQL.Column_Value(b_cursor, 2, b_header_id);
1393: DBMS_SQL.Column_Value(b_cursor, 3, b_org_id);
1394: DBMS_SQL.Column_Value(b_cursor, 4, b_ato_flag);
1395: DBMS_SQL.Column_Value(b_cursor, 5, b_line_detail_id);
1396: DBMS_SQL.Column_Value(b_cursor, 6, b_ship_model_complete);

Line 1393: DBMS_SQL.Column_Value(b_cursor, 3, b_org_id);

1389: DBMS_SQL.Column_Value(u_cursor, 38, u_invoice_value);
1390: ELSIF p_source = 'b' THEN
1391: DBMS_SQL.Column_Value(b_cursor, 1, b_line_id);
1392: DBMS_SQL.Column_Value(b_cursor, 2, b_header_id);
1393: DBMS_SQL.Column_Value(b_cursor, 3, b_org_id);
1394: DBMS_SQL.Column_Value(b_cursor, 4, b_ato_flag);
1395: DBMS_SQL.Column_Value(b_cursor, 5, b_line_detail_id);
1396: DBMS_SQL.Column_Value(b_cursor, 6, b_ship_model_complete);
1397: DBMS_SQL.Column_Value(b_cursor, 7, b_ship_set_number);

Line 1394: DBMS_SQL.Column_Value(b_cursor, 4, b_ato_flag);

1390: ELSIF p_source = 'b' THEN
1391: DBMS_SQL.Column_Value(b_cursor, 1, b_line_id);
1392: DBMS_SQL.Column_Value(b_cursor, 2, b_header_id);
1393: DBMS_SQL.Column_Value(b_cursor, 3, b_org_id);
1394: DBMS_SQL.Column_Value(b_cursor, 4, b_ato_flag);
1395: DBMS_SQL.Column_Value(b_cursor, 5, b_line_detail_id);
1396: DBMS_SQL.Column_Value(b_cursor, 6, b_ship_model_complete);
1397: DBMS_SQL.Column_Value(b_cursor, 7, b_ship_set_number);
1398: DBMS_SQL.Column_Value(b_cursor, 8, b_parent_line_id);

Line 1395: DBMS_SQL.Column_Value(b_cursor, 5, b_line_detail_id);

1391: DBMS_SQL.Column_Value(b_cursor, 1, b_line_id);
1392: DBMS_SQL.Column_Value(b_cursor, 2, b_header_id);
1393: DBMS_SQL.Column_Value(b_cursor, 3, b_org_id);
1394: DBMS_SQL.Column_Value(b_cursor, 4, b_ato_flag);
1395: DBMS_SQL.Column_Value(b_cursor, 5, b_line_detail_id);
1396: DBMS_SQL.Column_Value(b_cursor, 6, b_ship_model_complete);
1397: DBMS_SQL.Column_Value(b_cursor, 7, b_ship_set_number);
1398: DBMS_SQL.Column_Value(b_cursor, 8, b_parent_line_id);
1399: DBMS_SQL.Column_Value(b_cursor, 9, b_ld_warehouse_id);

Line 1396: DBMS_SQL.Column_Value(b_cursor, 6, b_ship_model_complete);

1392: DBMS_SQL.Column_Value(b_cursor, 2, b_header_id);
1393: DBMS_SQL.Column_Value(b_cursor, 3, b_org_id);
1394: DBMS_SQL.Column_Value(b_cursor, 4, b_ato_flag);
1395: DBMS_SQL.Column_Value(b_cursor, 5, b_line_detail_id);
1396: DBMS_SQL.Column_Value(b_cursor, 6, b_ship_model_complete);
1397: DBMS_SQL.Column_Value(b_cursor, 7, b_ship_set_number);
1398: DBMS_SQL.Column_Value(b_cursor, 8, b_parent_line_id);
1399: DBMS_SQL.Column_Value(b_cursor, 9, b_ld_warehouse_id);
1400: DBMS_SQL.Column_Value(b_cursor, 10, b_ship_to_site_use_id);

Line 1397: DBMS_SQL.Column_Value(b_cursor, 7, b_ship_set_number);

1393: DBMS_SQL.Column_Value(b_cursor, 3, b_org_id);
1394: DBMS_SQL.Column_Value(b_cursor, 4, b_ato_flag);
1395: DBMS_SQL.Column_Value(b_cursor, 5, b_line_detail_id);
1396: DBMS_SQL.Column_Value(b_cursor, 6, b_ship_model_complete);
1397: DBMS_SQL.Column_Value(b_cursor, 7, b_ship_set_number);
1398: DBMS_SQL.Column_Value(b_cursor, 8, b_parent_line_id);
1399: DBMS_SQL.Column_Value(b_cursor, 9, b_ld_warehouse_id);
1400: DBMS_SQL.Column_Value(b_cursor, 10, b_ship_to_site_use_id);
1401: DBMS_SQL.Column_Value(b_cursor, 11, b_ship_to_contact_id);

Line 1398: DBMS_SQL.Column_Value(b_cursor, 8, b_parent_line_id);

1394: DBMS_SQL.Column_Value(b_cursor, 4, b_ato_flag);
1395: DBMS_SQL.Column_Value(b_cursor, 5, b_line_detail_id);
1396: DBMS_SQL.Column_Value(b_cursor, 6, b_ship_model_complete);
1397: DBMS_SQL.Column_Value(b_cursor, 7, b_ship_set_number);
1398: DBMS_SQL.Column_Value(b_cursor, 8, b_parent_line_id);
1399: DBMS_SQL.Column_Value(b_cursor, 9, b_ld_warehouse_id);
1400: DBMS_SQL.Column_Value(b_cursor, 10, b_ship_to_site_use_id);
1401: DBMS_SQL.Column_Value(b_cursor, 11, b_ship_to_contact_id);
1402: DBMS_SQL.Column_Value(b_cursor, 12, b_ship_method_code);

Line 1399: DBMS_SQL.Column_Value(b_cursor, 9, b_ld_warehouse_id);

1395: DBMS_SQL.Column_Value(b_cursor, 5, b_line_detail_id);
1396: DBMS_SQL.Column_Value(b_cursor, 6, b_ship_model_complete);
1397: DBMS_SQL.Column_Value(b_cursor, 7, b_ship_set_number);
1398: DBMS_SQL.Column_Value(b_cursor, 8, b_parent_line_id);
1399: DBMS_SQL.Column_Value(b_cursor, 9, b_ld_warehouse_id);
1400: DBMS_SQL.Column_Value(b_cursor, 10, b_ship_to_site_use_id);
1401: DBMS_SQL.Column_Value(b_cursor, 11, b_ship_to_contact_id);
1402: DBMS_SQL.Column_Value(b_cursor, 12, b_ship_method_code);
1403: DBMS_SQL.Column_Value(b_cursor, 13, b_shipment_priority);

Line 1400: DBMS_SQL.Column_Value(b_cursor, 10, b_ship_to_site_use_id);

1396: DBMS_SQL.Column_Value(b_cursor, 6, b_ship_model_complete);
1397: DBMS_SQL.Column_Value(b_cursor, 7, b_ship_set_number);
1398: DBMS_SQL.Column_Value(b_cursor, 8, b_parent_line_id);
1399: DBMS_SQL.Column_Value(b_cursor, 9, b_ld_warehouse_id);
1400: DBMS_SQL.Column_Value(b_cursor, 10, b_ship_to_site_use_id);
1401: DBMS_SQL.Column_Value(b_cursor, 11, b_ship_to_contact_id);
1402: DBMS_SQL.Column_Value(b_cursor, 12, b_ship_method_code);
1403: DBMS_SQL.Column_Value(b_cursor, 13, b_shipment_priority);
1404: DBMS_SQL.Column_Value(b_cursor, 14, b_departure_id);

Line 1401: DBMS_SQL.Column_Value(b_cursor, 11, b_ship_to_contact_id);

1397: DBMS_SQL.Column_Value(b_cursor, 7, b_ship_set_number);
1398: DBMS_SQL.Column_Value(b_cursor, 8, b_parent_line_id);
1399: DBMS_SQL.Column_Value(b_cursor, 9, b_ld_warehouse_id);
1400: DBMS_SQL.Column_Value(b_cursor, 10, b_ship_to_site_use_id);
1401: DBMS_SQL.Column_Value(b_cursor, 11, b_ship_to_contact_id);
1402: DBMS_SQL.Column_Value(b_cursor, 12, b_ship_method_code);
1403: DBMS_SQL.Column_Value(b_cursor, 13, b_shipment_priority);
1404: DBMS_SQL.Column_Value(b_cursor, 14, b_departure_id);
1405: DBMS_SQL.Column_Value(b_cursor, 15, b_delivery_id);

Line 1402: DBMS_SQL.Column_Value(b_cursor, 12, b_ship_method_code);

1398: DBMS_SQL.Column_Value(b_cursor, 8, b_parent_line_id);
1399: DBMS_SQL.Column_Value(b_cursor, 9, b_ld_warehouse_id);
1400: DBMS_SQL.Column_Value(b_cursor, 10, b_ship_to_site_use_id);
1401: DBMS_SQL.Column_Value(b_cursor, 11, b_ship_to_contact_id);
1402: DBMS_SQL.Column_Value(b_cursor, 12, b_ship_method_code);
1403: DBMS_SQL.Column_Value(b_cursor, 13, b_shipment_priority);
1404: DBMS_SQL.Column_Value(b_cursor, 14, b_departure_id);
1405: DBMS_SQL.Column_Value(b_cursor, 15, b_delivery_id);
1406: DBMS_SQL.Column_Value(b_cursor, 16, b_item_type_code);

Line 1403: DBMS_SQL.Column_Value(b_cursor, 13, b_shipment_priority);

1399: DBMS_SQL.Column_Value(b_cursor, 9, b_ld_warehouse_id);
1400: DBMS_SQL.Column_Value(b_cursor, 10, b_ship_to_site_use_id);
1401: DBMS_SQL.Column_Value(b_cursor, 11, b_ship_to_contact_id);
1402: DBMS_SQL.Column_Value(b_cursor, 12, b_ship_method_code);
1403: DBMS_SQL.Column_Value(b_cursor, 13, b_shipment_priority);
1404: DBMS_SQL.Column_Value(b_cursor, 14, b_departure_id);
1405: DBMS_SQL.Column_Value(b_cursor, 15, b_delivery_id);
1406: DBMS_SQL.Column_Value(b_cursor, 16, b_item_type_code);
1407: DBMS_SQL.Column_Value(b_cursor, 17, b_schedule_date);

Line 1404: DBMS_SQL.Column_Value(b_cursor, 14, b_departure_id);

1400: DBMS_SQL.Column_Value(b_cursor, 10, b_ship_to_site_use_id);
1401: DBMS_SQL.Column_Value(b_cursor, 11, b_ship_to_contact_id);
1402: DBMS_SQL.Column_Value(b_cursor, 12, b_ship_method_code);
1403: DBMS_SQL.Column_Value(b_cursor, 13, b_shipment_priority);
1404: DBMS_SQL.Column_Value(b_cursor, 14, b_departure_id);
1405: DBMS_SQL.Column_Value(b_cursor, 15, b_delivery_id);
1406: DBMS_SQL.Column_Value(b_cursor, 16, b_item_type_code);
1407: DBMS_SQL.Column_Value(b_cursor, 17, b_schedule_date);
1408: DBMS_SQL.Column_Value(b_cursor, 18, b_ordered_quantity);

Line 1405: DBMS_SQL.Column_Value(b_cursor, 15, b_delivery_id);

1401: DBMS_SQL.Column_Value(b_cursor, 11, b_ship_to_contact_id);
1402: DBMS_SQL.Column_Value(b_cursor, 12, b_ship_method_code);
1403: DBMS_SQL.Column_Value(b_cursor, 13, b_shipment_priority);
1404: DBMS_SQL.Column_Value(b_cursor, 14, b_departure_id);
1405: DBMS_SQL.Column_Value(b_cursor, 15, b_delivery_id);
1406: DBMS_SQL.Column_Value(b_cursor, 16, b_item_type_code);
1407: DBMS_SQL.Column_Value(b_cursor, 17, b_schedule_date);
1408: DBMS_SQL.Column_Value(b_cursor, 18, b_ordered_quantity);
1409: DBMS_SQL.Column_Value(b_cursor, 19, b_cancelled_quantity);

Line 1406: DBMS_SQL.Column_Value(b_cursor, 16, b_item_type_code);

1402: DBMS_SQL.Column_Value(b_cursor, 12, b_ship_method_code);
1403: DBMS_SQL.Column_Value(b_cursor, 13, b_shipment_priority);
1404: DBMS_SQL.Column_Value(b_cursor, 14, b_departure_id);
1405: DBMS_SQL.Column_Value(b_cursor, 15, b_delivery_id);
1406: DBMS_SQL.Column_Value(b_cursor, 16, b_item_type_code);
1407: DBMS_SQL.Column_Value(b_cursor, 17, b_schedule_date);
1408: DBMS_SQL.Column_Value(b_cursor, 18, b_ordered_quantity);
1409: DBMS_SQL.Column_Value(b_cursor, 19, b_cancelled_quantity);
1410: DBMS_SQL.Column_Value(b_cursor, 20, b_l_inventory_item_id);

Line 1407: DBMS_SQL.Column_Value(b_cursor, 17, b_schedule_date);

1403: DBMS_SQL.Column_Value(b_cursor, 13, b_shipment_priority);
1404: DBMS_SQL.Column_Value(b_cursor, 14, b_departure_id);
1405: DBMS_SQL.Column_Value(b_cursor, 15, b_delivery_id);
1406: DBMS_SQL.Column_Value(b_cursor, 16, b_item_type_code);
1407: DBMS_SQL.Column_Value(b_cursor, 17, b_schedule_date);
1408: DBMS_SQL.Column_Value(b_cursor, 18, b_ordered_quantity);
1409: DBMS_SQL.Column_Value(b_cursor, 19, b_cancelled_quantity);
1410: DBMS_SQL.Column_Value(b_cursor, 20, b_l_inventory_item_id);
1411: DBMS_SQL.Column_Value(b_cursor, 21, b_ld_inventory_item_id);

Line 1408: DBMS_SQL.Column_Value(b_cursor, 18, b_ordered_quantity);

1404: DBMS_SQL.Column_Value(b_cursor, 14, b_departure_id);
1405: DBMS_SQL.Column_Value(b_cursor, 15, b_delivery_id);
1406: DBMS_SQL.Column_Value(b_cursor, 16, b_item_type_code);
1407: DBMS_SQL.Column_Value(b_cursor, 17, b_schedule_date);
1408: DBMS_SQL.Column_Value(b_cursor, 18, b_ordered_quantity);
1409: DBMS_SQL.Column_Value(b_cursor, 19, b_cancelled_quantity);
1410: DBMS_SQL.Column_Value(b_cursor, 20, b_l_inventory_item_id);
1411: DBMS_SQL.Column_Value(b_cursor, 21, b_ld_inventory_item_id);
1412: DBMS_SQL.Column_Value(b_cursor, 22, b_customer_item_id);

Line 1409: DBMS_SQL.Column_Value(b_cursor, 19, b_cancelled_quantity);

1405: DBMS_SQL.Column_Value(b_cursor, 15, b_delivery_id);
1406: DBMS_SQL.Column_Value(b_cursor, 16, b_item_type_code);
1407: DBMS_SQL.Column_Value(b_cursor, 17, b_schedule_date);
1408: DBMS_SQL.Column_Value(b_cursor, 18, b_ordered_quantity);
1409: DBMS_SQL.Column_Value(b_cursor, 19, b_cancelled_quantity);
1410: DBMS_SQL.Column_Value(b_cursor, 20, b_l_inventory_item_id);
1411: DBMS_SQL.Column_Value(b_cursor, 21, b_ld_inventory_item_id);
1412: DBMS_SQL.Column_Value(b_cursor, 22, b_customer_item_id);
1413: DBMS_SQL.Column_Value(b_cursor, 23, b_dep_plan_required_flag);

Line 1410: DBMS_SQL.Column_Value(b_cursor, 20, b_l_inventory_item_id);

1406: DBMS_SQL.Column_Value(b_cursor, 16, b_item_type_code);
1407: DBMS_SQL.Column_Value(b_cursor, 17, b_schedule_date);
1408: DBMS_SQL.Column_Value(b_cursor, 18, b_ordered_quantity);
1409: DBMS_SQL.Column_Value(b_cursor, 19, b_cancelled_quantity);
1410: DBMS_SQL.Column_Value(b_cursor, 20, b_l_inventory_item_id);
1411: DBMS_SQL.Column_Value(b_cursor, 21, b_ld_inventory_item_id);
1412: DBMS_SQL.Column_Value(b_cursor, 22, b_customer_item_id);
1413: DBMS_SQL.Column_Value(b_cursor, 23, b_dep_plan_required_flag);
1414: DBMS_SQL.Column_Value(b_cursor, 24, b_shipment_schedule_line_id);

Line 1411: DBMS_SQL.Column_Value(b_cursor, 21, b_ld_inventory_item_id);

1407: DBMS_SQL.Column_Value(b_cursor, 17, b_schedule_date);
1408: DBMS_SQL.Column_Value(b_cursor, 18, b_ordered_quantity);
1409: DBMS_SQL.Column_Value(b_cursor, 19, b_cancelled_quantity);
1410: DBMS_SQL.Column_Value(b_cursor, 20, b_l_inventory_item_id);
1411: DBMS_SQL.Column_Value(b_cursor, 21, b_ld_inventory_item_id);
1412: DBMS_SQL.Column_Value(b_cursor, 22, b_customer_item_id);
1413: DBMS_SQL.Column_Value(b_cursor, 23, b_dep_plan_required_flag);
1414: DBMS_SQL.Column_Value(b_cursor, 24, b_shipment_schedule_line_id);
1415: DBMS_SQL.Column_Value(b_cursor, 25, b_unit_code);

Line 1412: DBMS_SQL.Column_Value(b_cursor, 22, b_customer_item_id);

1408: DBMS_SQL.Column_Value(b_cursor, 18, b_ordered_quantity);
1409: DBMS_SQL.Column_Value(b_cursor, 19, b_cancelled_quantity);
1410: DBMS_SQL.Column_Value(b_cursor, 20, b_l_inventory_item_id);
1411: DBMS_SQL.Column_Value(b_cursor, 21, b_ld_inventory_item_id);
1412: DBMS_SQL.Column_Value(b_cursor, 22, b_customer_item_id);
1413: DBMS_SQL.Column_Value(b_cursor, 23, b_dep_plan_required_flag);
1414: DBMS_SQL.Column_Value(b_cursor, 24, b_shipment_schedule_line_id);
1415: DBMS_SQL.Column_Value(b_cursor, 25, b_unit_code);
1416: DBMS_SQL.Column_Value(b_cursor, 26, b_line_type_code);

Line 1413: DBMS_SQL.Column_Value(b_cursor, 23, b_dep_plan_required_flag);

1409: DBMS_SQL.Column_Value(b_cursor, 19, b_cancelled_quantity);
1410: DBMS_SQL.Column_Value(b_cursor, 20, b_l_inventory_item_id);
1411: DBMS_SQL.Column_Value(b_cursor, 21, b_ld_inventory_item_id);
1412: DBMS_SQL.Column_Value(b_cursor, 22, b_customer_item_id);
1413: DBMS_SQL.Column_Value(b_cursor, 23, b_dep_plan_required_flag);
1414: DBMS_SQL.Column_Value(b_cursor, 24, b_shipment_schedule_line_id);
1415: DBMS_SQL.Column_Value(b_cursor, 25, b_unit_code);
1416: DBMS_SQL.Column_Value(b_cursor, 26, b_line_type_code);
1417: DBMS_SQL.Column_Value(b_cursor, 27, b_component_code);

Line 1414: DBMS_SQL.Column_Value(b_cursor, 24, b_shipment_schedule_line_id);

1410: DBMS_SQL.Column_Value(b_cursor, 20, b_l_inventory_item_id);
1411: DBMS_SQL.Column_Value(b_cursor, 21, b_ld_inventory_item_id);
1412: DBMS_SQL.Column_Value(b_cursor, 22, b_customer_item_id);
1413: DBMS_SQL.Column_Value(b_cursor, 23, b_dep_plan_required_flag);
1414: DBMS_SQL.Column_Value(b_cursor, 24, b_shipment_schedule_line_id);
1415: DBMS_SQL.Column_Value(b_cursor, 25, b_unit_code);
1416: DBMS_SQL.Column_Value(b_cursor, 26, b_line_type_code);
1417: DBMS_SQL.Column_Value(b_cursor, 27, b_component_code);
1418: DBMS_SQL.Column_Value(b_cursor, 28, b_standard_comp_freeze_date);

Line 1415: DBMS_SQL.Column_Value(b_cursor, 25, b_unit_code);

1411: DBMS_SQL.Column_Value(b_cursor, 21, b_ld_inventory_item_id);
1412: DBMS_SQL.Column_Value(b_cursor, 22, b_customer_item_id);
1413: DBMS_SQL.Column_Value(b_cursor, 23, b_dep_plan_required_flag);
1414: DBMS_SQL.Column_Value(b_cursor, 24, b_shipment_schedule_line_id);
1415: DBMS_SQL.Column_Value(b_cursor, 25, b_unit_code);
1416: DBMS_SQL.Column_Value(b_cursor, 26, b_line_type_code);
1417: DBMS_SQL.Column_Value(b_cursor, 27, b_component_code);
1418: DBMS_SQL.Column_Value(b_cursor, 28, b_standard_comp_freeze_date);
1419: DBMS_SQL.Column_Value(b_cursor, 29, b_order_number);

Line 1416: DBMS_SQL.Column_Value(b_cursor, 26, b_line_type_code);

1412: DBMS_SQL.Column_Value(b_cursor, 22, b_customer_item_id);
1413: DBMS_SQL.Column_Value(b_cursor, 23, b_dep_plan_required_flag);
1414: DBMS_SQL.Column_Value(b_cursor, 24, b_shipment_schedule_line_id);
1415: DBMS_SQL.Column_Value(b_cursor, 25, b_unit_code);
1416: DBMS_SQL.Column_Value(b_cursor, 26, b_line_type_code);
1417: DBMS_SQL.Column_Value(b_cursor, 27, b_component_code);
1418: DBMS_SQL.Column_Value(b_cursor, 28, b_standard_comp_freeze_date);
1419: DBMS_SQL.Column_Value(b_cursor, 29, b_order_number);
1420: DBMS_SQL.Column_Value(b_cursor, 30, b_order_type_id);

Line 1417: DBMS_SQL.Column_Value(b_cursor, 27, b_component_code);

1413: DBMS_SQL.Column_Value(b_cursor, 23, b_dep_plan_required_flag);
1414: DBMS_SQL.Column_Value(b_cursor, 24, b_shipment_schedule_line_id);
1415: DBMS_SQL.Column_Value(b_cursor, 25, b_unit_code);
1416: DBMS_SQL.Column_Value(b_cursor, 26, b_line_type_code);
1417: DBMS_SQL.Column_Value(b_cursor, 27, b_component_code);
1418: DBMS_SQL.Column_Value(b_cursor, 28, b_standard_comp_freeze_date);
1419: DBMS_SQL.Column_Value(b_cursor, 29, b_order_number);
1420: DBMS_SQL.Column_Value(b_cursor, 30, b_order_type_id);
1421: DBMS_SQL.Column_Value(b_cursor, 31, b_customer_id);

Line 1418: DBMS_SQL.Column_Value(b_cursor, 28, b_standard_comp_freeze_date);

1414: DBMS_SQL.Column_Value(b_cursor, 24, b_shipment_schedule_line_id);
1415: DBMS_SQL.Column_Value(b_cursor, 25, b_unit_code);
1416: DBMS_SQL.Column_Value(b_cursor, 26, b_line_type_code);
1417: DBMS_SQL.Column_Value(b_cursor, 27, b_component_code);
1418: DBMS_SQL.Column_Value(b_cursor, 28, b_standard_comp_freeze_date);
1419: DBMS_SQL.Column_Value(b_cursor, 29, b_order_number);
1420: DBMS_SQL.Column_Value(b_cursor, 30, b_order_type_id);
1421: DBMS_SQL.Column_Value(b_cursor, 31, b_customer_id);
1422: DBMS_SQL.Column_Value(b_cursor, 32, b_invoice_to_site_use_id);

Line 1419: DBMS_SQL.Column_Value(b_cursor, 29, b_order_number);

1415: DBMS_SQL.Column_Value(b_cursor, 25, b_unit_code);
1416: DBMS_SQL.Column_Value(b_cursor, 26, b_line_type_code);
1417: DBMS_SQL.Column_Value(b_cursor, 27, b_component_code);
1418: DBMS_SQL.Column_Value(b_cursor, 28, b_standard_comp_freeze_date);
1419: DBMS_SQL.Column_Value(b_cursor, 29, b_order_number);
1420: DBMS_SQL.Column_Value(b_cursor, 30, b_order_type_id);
1421: DBMS_SQL.Column_Value(b_cursor, 31, b_customer_id);
1422: DBMS_SQL.Column_Value(b_cursor, 32, b_invoice_to_site_use_id);
1423: DBMS_SQL.Column_Value(b_cursor, 33, b_planned_departure_date_d);

Line 1420: DBMS_SQL.Column_Value(b_cursor, 30, b_order_type_id);

1416: DBMS_SQL.Column_Value(b_cursor, 26, b_line_type_code);
1417: DBMS_SQL.Column_Value(b_cursor, 27, b_component_code);
1418: DBMS_SQL.Column_Value(b_cursor, 28, b_standard_comp_freeze_date);
1419: DBMS_SQL.Column_Value(b_cursor, 29, b_order_number);
1420: DBMS_SQL.Column_Value(b_cursor, 30, b_order_type_id);
1421: DBMS_SQL.Column_Value(b_cursor, 31, b_customer_id);
1422: DBMS_SQL.Column_Value(b_cursor, 32, b_invoice_to_site_use_id);
1423: DBMS_SQL.Column_Value(b_cursor, 33, b_planned_departure_date_d);
1424: DBMS_SQL.Column_Value(b_cursor, 34, b_planned_departure_date_t);

Line 1421: DBMS_SQL.Column_Value(b_cursor, 31, b_customer_id);

1417: DBMS_SQL.Column_Value(b_cursor, 27, b_component_code);
1418: DBMS_SQL.Column_Value(b_cursor, 28, b_standard_comp_freeze_date);
1419: DBMS_SQL.Column_Value(b_cursor, 29, b_order_number);
1420: DBMS_SQL.Column_Value(b_cursor, 30, b_order_type_id);
1421: DBMS_SQL.Column_Value(b_cursor, 31, b_customer_id);
1422: DBMS_SQL.Column_Value(b_cursor, 32, b_invoice_to_site_use_id);
1423: DBMS_SQL.Column_Value(b_cursor, 33, b_planned_departure_date_d);
1424: DBMS_SQL.Column_Value(b_cursor, 34, b_planned_departure_date_t);
1425: DBMS_SQL.Column_Value(b_cursor, 35, b_master_container_id);

Line 1422: DBMS_SQL.Column_Value(b_cursor, 32, b_invoice_to_site_use_id);

1418: DBMS_SQL.Column_Value(b_cursor, 28, b_standard_comp_freeze_date);
1419: DBMS_SQL.Column_Value(b_cursor, 29, b_order_number);
1420: DBMS_SQL.Column_Value(b_cursor, 30, b_order_type_id);
1421: DBMS_SQL.Column_Value(b_cursor, 31, b_customer_id);
1422: DBMS_SQL.Column_Value(b_cursor, 32, b_invoice_to_site_use_id);
1423: DBMS_SQL.Column_Value(b_cursor, 33, b_planned_departure_date_d);
1424: DBMS_SQL.Column_Value(b_cursor, 34, b_planned_departure_date_t);
1425: DBMS_SQL.Column_Value(b_cursor, 35, b_master_container_id);
1426: DBMS_SQL.Column_Value(b_cursor, 36, b_detail_container_id);

Line 1423: DBMS_SQL.Column_Value(b_cursor, 33, b_planned_departure_date_d);

1419: DBMS_SQL.Column_Value(b_cursor, 29, b_order_number);
1420: DBMS_SQL.Column_Value(b_cursor, 30, b_order_type_id);
1421: DBMS_SQL.Column_Value(b_cursor, 31, b_customer_id);
1422: DBMS_SQL.Column_Value(b_cursor, 32, b_invoice_to_site_use_id);
1423: DBMS_SQL.Column_Value(b_cursor, 33, b_planned_departure_date_d);
1424: DBMS_SQL.Column_Value(b_cursor, 34, b_planned_departure_date_t);
1425: DBMS_SQL.Column_Value(b_cursor, 35, b_master_container_id);
1426: DBMS_SQL.Column_Value(b_cursor, 36, b_detail_container_id);
1427: DBMS_SQL.Column_Value(b_cursor, 37, b_load_seq_number);

Line 1424: DBMS_SQL.Column_Value(b_cursor, 34, b_planned_departure_date_t);

1420: DBMS_SQL.Column_Value(b_cursor, 30, b_order_type_id);
1421: DBMS_SQL.Column_Value(b_cursor, 31, b_customer_id);
1422: DBMS_SQL.Column_Value(b_cursor, 32, b_invoice_to_site_use_id);
1423: DBMS_SQL.Column_Value(b_cursor, 33, b_planned_departure_date_d);
1424: DBMS_SQL.Column_Value(b_cursor, 34, b_planned_departure_date_t);
1425: DBMS_SQL.Column_Value(b_cursor, 35, b_master_container_id);
1426: DBMS_SQL.Column_Value(b_cursor, 36, b_detail_container_id);
1427: DBMS_SQL.Column_Value(b_cursor, 37, b_load_seq_number);
1428: DBMS_SQL.Column_Value(b_cursor, 38, b_invoice_value);

Line 1425: DBMS_SQL.Column_Value(b_cursor, 35, b_master_container_id);

1421: DBMS_SQL.Column_Value(b_cursor, 31, b_customer_id);
1422: DBMS_SQL.Column_Value(b_cursor, 32, b_invoice_to_site_use_id);
1423: DBMS_SQL.Column_Value(b_cursor, 33, b_planned_departure_date_d);
1424: DBMS_SQL.Column_Value(b_cursor, 34, b_planned_departure_date_t);
1425: DBMS_SQL.Column_Value(b_cursor, 35, b_master_container_id);
1426: DBMS_SQL.Column_Value(b_cursor, 36, b_detail_container_id);
1427: DBMS_SQL.Column_Value(b_cursor, 37, b_load_seq_number);
1428: DBMS_SQL.Column_Value(b_cursor, 38, b_invoice_value);
1429: ELSIF p_source = 's' THEN

Line 1426: DBMS_SQL.Column_Value(b_cursor, 36, b_detail_container_id);

1422: DBMS_SQL.Column_Value(b_cursor, 32, b_invoice_to_site_use_id);
1423: DBMS_SQL.Column_Value(b_cursor, 33, b_planned_departure_date_d);
1424: DBMS_SQL.Column_Value(b_cursor, 34, b_planned_departure_date_t);
1425: DBMS_SQL.Column_Value(b_cursor, 35, b_master_container_id);
1426: DBMS_SQL.Column_Value(b_cursor, 36, b_detail_container_id);
1427: DBMS_SQL.Column_Value(b_cursor, 37, b_load_seq_number);
1428: DBMS_SQL.Column_Value(b_cursor, 38, b_invoice_value);
1429: ELSIF p_source = 's' THEN
1430: DBMS_SQL.Column_Value(s_cursor, 1, s_line_id);

Line 1427: DBMS_SQL.Column_Value(b_cursor, 37, b_load_seq_number);

1423: DBMS_SQL.Column_Value(b_cursor, 33, b_planned_departure_date_d);
1424: DBMS_SQL.Column_Value(b_cursor, 34, b_planned_departure_date_t);
1425: DBMS_SQL.Column_Value(b_cursor, 35, b_master_container_id);
1426: DBMS_SQL.Column_Value(b_cursor, 36, b_detail_container_id);
1427: DBMS_SQL.Column_Value(b_cursor, 37, b_load_seq_number);
1428: DBMS_SQL.Column_Value(b_cursor, 38, b_invoice_value);
1429: ELSIF p_source = 's' THEN
1430: DBMS_SQL.Column_Value(s_cursor, 1, s_line_id);
1431: DBMS_SQL.Column_Value(s_cursor, 2, s_header_id);

Line 1428: DBMS_SQL.Column_Value(b_cursor, 38, b_invoice_value);

1424: DBMS_SQL.Column_Value(b_cursor, 34, b_planned_departure_date_t);
1425: DBMS_SQL.Column_Value(b_cursor, 35, b_master_container_id);
1426: DBMS_SQL.Column_Value(b_cursor, 36, b_detail_container_id);
1427: DBMS_SQL.Column_Value(b_cursor, 37, b_load_seq_number);
1428: DBMS_SQL.Column_Value(b_cursor, 38, b_invoice_value);
1429: ELSIF p_source = 's' THEN
1430: DBMS_SQL.Column_Value(s_cursor, 1, s_line_id);
1431: DBMS_SQL.Column_Value(s_cursor, 2, s_header_id);
1432: DBMS_SQL.Column_Value(s_cursor, 3, s_org_id);

Line 1430: DBMS_SQL.Column_Value(s_cursor, 1, s_line_id);

1426: DBMS_SQL.Column_Value(b_cursor, 36, b_detail_container_id);
1427: DBMS_SQL.Column_Value(b_cursor, 37, b_load_seq_number);
1428: DBMS_SQL.Column_Value(b_cursor, 38, b_invoice_value);
1429: ELSIF p_source = 's' THEN
1430: DBMS_SQL.Column_Value(s_cursor, 1, s_line_id);
1431: DBMS_SQL.Column_Value(s_cursor, 2, s_header_id);
1432: DBMS_SQL.Column_Value(s_cursor, 3, s_org_id);
1433: DBMS_SQL.Column_Value(s_cursor, 4, s_ato_flag);
1434: DBMS_SQL.Column_Value(s_cursor, 5, s_line_detail_id);

Line 1431: DBMS_SQL.Column_Value(s_cursor, 2, s_header_id);

1427: DBMS_SQL.Column_Value(b_cursor, 37, b_load_seq_number);
1428: DBMS_SQL.Column_Value(b_cursor, 38, b_invoice_value);
1429: ELSIF p_source = 's' THEN
1430: DBMS_SQL.Column_Value(s_cursor, 1, s_line_id);
1431: DBMS_SQL.Column_Value(s_cursor, 2, s_header_id);
1432: DBMS_SQL.Column_Value(s_cursor, 3, s_org_id);
1433: DBMS_SQL.Column_Value(s_cursor, 4, s_ato_flag);
1434: DBMS_SQL.Column_Value(s_cursor, 5, s_line_detail_id);
1435: DBMS_SQL.Column_Value(s_cursor, 6, s_ship_model_complete);

Line 1432: DBMS_SQL.Column_Value(s_cursor, 3, s_org_id);

1428: DBMS_SQL.Column_Value(b_cursor, 38, b_invoice_value);
1429: ELSIF p_source = 's' THEN
1430: DBMS_SQL.Column_Value(s_cursor, 1, s_line_id);
1431: DBMS_SQL.Column_Value(s_cursor, 2, s_header_id);
1432: DBMS_SQL.Column_Value(s_cursor, 3, s_org_id);
1433: DBMS_SQL.Column_Value(s_cursor, 4, s_ato_flag);
1434: DBMS_SQL.Column_Value(s_cursor, 5, s_line_detail_id);
1435: DBMS_SQL.Column_Value(s_cursor, 6, s_ship_model_complete);
1436: DBMS_SQL.Column_Value(s_cursor, 7, s_ship_set_number);

Line 1433: DBMS_SQL.Column_Value(s_cursor, 4, s_ato_flag);

1429: ELSIF p_source = 's' THEN
1430: DBMS_SQL.Column_Value(s_cursor, 1, s_line_id);
1431: DBMS_SQL.Column_Value(s_cursor, 2, s_header_id);
1432: DBMS_SQL.Column_Value(s_cursor, 3, s_org_id);
1433: DBMS_SQL.Column_Value(s_cursor, 4, s_ato_flag);
1434: DBMS_SQL.Column_Value(s_cursor, 5, s_line_detail_id);
1435: DBMS_SQL.Column_Value(s_cursor, 6, s_ship_model_complete);
1436: DBMS_SQL.Column_Value(s_cursor, 7, s_ship_set_number);
1437: DBMS_SQL.Column_Value(s_cursor, 8, s_parent_line_id);

Line 1434: DBMS_SQL.Column_Value(s_cursor, 5, s_line_detail_id);

1430: DBMS_SQL.Column_Value(s_cursor, 1, s_line_id);
1431: DBMS_SQL.Column_Value(s_cursor, 2, s_header_id);
1432: DBMS_SQL.Column_Value(s_cursor, 3, s_org_id);
1433: DBMS_SQL.Column_Value(s_cursor, 4, s_ato_flag);
1434: DBMS_SQL.Column_Value(s_cursor, 5, s_line_detail_id);
1435: DBMS_SQL.Column_Value(s_cursor, 6, s_ship_model_complete);
1436: DBMS_SQL.Column_Value(s_cursor, 7, s_ship_set_number);
1437: DBMS_SQL.Column_Value(s_cursor, 8, s_parent_line_id);
1438: DBMS_SQL.Column_Value(s_cursor, 9, s_ld_warehouse_id);

Line 1435: DBMS_SQL.Column_Value(s_cursor, 6, s_ship_model_complete);

1431: DBMS_SQL.Column_Value(s_cursor, 2, s_header_id);
1432: DBMS_SQL.Column_Value(s_cursor, 3, s_org_id);
1433: DBMS_SQL.Column_Value(s_cursor, 4, s_ato_flag);
1434: DBMS_SQL.Column_Value(s_cursor, 5, s_line_detail_id);
1435: DBMS_SQL.Column_Value(s_cursor, 6, s_ship_model_complete);
1436: DBMS_SQL.Column_Value(s_cursor, 7, s_ship_set_number);
1437: DBMS_SQL.Column_Value(s_cursor, 8, s_parent_line_id);
1438: DBMS_SQL.Column_Value(s_cursor, 9, s_ld_warehouse_id);
1439: DBMS_SQL.Column_Value(s_cursor, 10, s_ship_to_site_use_id);

Line 1436: DBMS_SQL.Column_Value(s_cursor, 7, s_ship_set_number);

1432: DBMS_SQL.Column_Value(s_cursor, 3, s_org_id);
1433: DBMS_SQL.Column_Value(s_cursor, 4, s_ato_flag);
1434: DBMS_SQL.Column_Value(s_cursor, 5, s_line_detail_id);
1435: DBMS_SQL.Column_Value(s_cursor, 6, s_ship_model_complete);
1436: DBMS_SQL.Column_Value(s_cursor, 7, s_ship_set_number);
1437: DBMS_SQL.Column_Value(s_cursor, 8, s_parent_line_id);
1438: DBMS_SQL.Column_Value(s_cursor, 9, s_ld_warehouse_id);
1439: DBMS_SQL.Column_Value(s_cursor, 10, s_ship_to_site_use_id);
1440: DBMS_SQL.Column_Value(s_cursor, 11, s_ship_to_contact_id);

Line 1437: DBMS_SQL.Column_Value(s_cursor, 8, s_parent_line_id);

1433: DBMS_SQL.Column_Value(s_cursor, 4, s_ato_flag);
1434: DBMS_SQL.Column_Value(s_cursor, 5, s_line_detail_id);
1435: DBMS_SQL.Column_Value(s_cursor, 6, s_ship_model_complete);
1436: DBMS_SQL.Column_Value(s_cursor, 7, s_ship_set_number);
1437: DBMS_SQL.Column_Value(s_cursor, 8, s_parent_line_id);
1438: DBMS_SQL.Column_Value(s_cursor, 9, s_ld_warehouse_id);
1439: DBMS_SQL.Column_Value(s_cursor, 10, s_ship_to_site_use_id);
1440: DBMS_SQL.Column_Value(s_cursor, 11, s_ship_to_contact_id);
1441: DBMS_SQL.Column_Value(s_cursor, 12, s_ship_method_code);

Line 1438: DBMS_SQL.Column_Value(s_cursor, 9, s_ld_warehouse_id);

1434: DBMS_SQL.Column_Value(s_cursor, 5, s_line_detail_id);
1435: DBMS_SQL.Column_Value(s_cursor, 6, s_ship_model_complete);
1436: DBMS_SQL.Column_Value(s_cursor, 7, s_ship_set_number);
1437: DBMS_SQL.Column_Value(s_cursor, 8, s_parent_line_id);
1438: DBMS_SQL.Column_Value(s_cursor, 9, s_ld_warehouse_id);
1439: DBMS_SQL.Column_Value(s_cursor, 10, s_ship_to_site_use_id);
1440: DBMS_SQL.Column_Value(s_cursor, 11, s_ship_to_contact_id);
1441: DBMS_SQL.Column_Value(s_cursor, 12, s_ship_method_code);
1442: DBMS_SQL.Column_Value(s_cursor, 13, s_shipment_priority);

Line 1439: DBMS_SQL.Column_Value(s_cursor, 10, s_ship_to_site_use_id);

1435: DBMS_SQL.Column_Value(s_cursor, 6, s_ship_model_complete);
1436: DBMS_SQL.Column_Value(s_cursor, 7, s_ship_set_number);
1437: DBMS_SQL.Column_Value(s_cursor, 8, s_parent_line_id);
1438: DBMS_SQL.Column_Value(s_cursor, 9, s_ld_warehouse_id);
1439: DBMS_SQL.Column_Value(s_cursor, 10, s_ship_to_site_use_id);
1440: DBMS_SQL.Column_Value(s_cursor, 11, s_ship_to_contact_id);
1441: DBMS_SQL.Column_Value(s_cursor, 12, s_ship_method_code);
1442: DBMS_SQL.Column_Value(s_cursor, 13, s_shipment_priority);
1443: DBMS_SQL.Column_Value(s_cursor, 14, s_departure_id);

Line 1440: DBMS_SQL.Column_Value(s_cursor, 11, s_ship_to_contact_id);

1436: DBMS_SQL.Column_Value(s_cursor, 7, s_ship_set_number);
1437: DBMS_SQL.Column_Value(s_cursor, 8, s_parent_line_id);
1438: DBMS_SQL.Column_Value(s_cursor, 9, s_ld_warehouse_id);
1439: DBMS_SQL.Column_Value(s_cursor, 10, s_ship_to_site_use_id);
1440: DBMS_SQL.Column_Value(s_cursor, 11, s_ship_to_contact_id);
1441: DBMS_SQL.Column_Value(s_cursor, 12, s_ship_method_code);
1442: DBMS_SQL.Column_Value(s_cursor, 13, s_shipment_priority);
1443: DBMS_SQL.Column_Value(s_cursor, 14, s_departure_id);
1444: DBMS_SQL.Column_Value(s_cursor, 15, s_delivery_id);

Line 1441: DBMS_SQL.Column_Value(s_cursor, 12, s_ship_method_code);

1437: DBMS_SQL.Column_Value(s_cursor, 8, s_parent_line_id);
1438: DBMS_SQL.Column_Value(s_cursor, 9, s_ld_warehouse_id);
1439: DBMS_SQL.Column_Value(s_cursor, 10, s_ship_to_site_use_id);
1440: DBMS_SQL.Column_Value(s_cursor, 11, s_ship_to_contact_id);
1441: DBMS_SQL.Column_Value(s_cursor, 12, s_ship_method_code);
1442: DBMS_SQL.Column_Value(s_cursor, 13, s_shipment_priority);
1443: DBMS_SQL.Column_Value(s_cursor, 14, s_departure_id);
1444: DBMS_SQL.Column_Value(s_cursor, 15, s_delivery_id);
1445: DBMS_SQL.Column_Value(s_cursor, 16, s_schedule_date);

Line 1442: DBMS_SQL.Column_Value(s_cursor, 13, s_shipment_priority);

1438: DBMS_SQL.Column_Value(s_cursor, 9, s_ld_warehouse_id);
1439: DBMS_SQL.Column_Value(s_cursor, 10, s_ship_to_site_use_id);
1440: DBMS_SQL.Column_Value(s_cursor, 11, s_ship_to_contact_id);
1441: DBMS_SQL.Column_Value(s_cursor, 12, s_ship_method_code);
1442: DBMS_SQL.Column_Value(s_cursor, 13, s_shipment_priority);
1443: DBMS_SQL.Column_Value(s_cursor, 14, s_departure_id);
1444: DBMS_SQL.Column_Value(s_cursor, 15, s_delivery_id);
1445: DBMS_SQL.Column_Value(s_cursor, 16, s_schedule_date);
1446: DBMS_SQL.Column_Value(s_cursor, 17, s_customer_item_id);

Line 1443: DBMS_SQL.Column_Value(s_cursor, 14, s_departure_id);

1439: DBMS_SQL.Column_Value(s_cursor, 10, s_ship_to_site_use_id);
1440: DBMS_SQL.Column_Value(s_cursor, 11, s_ship_to_contact_id);
1441: DBMS_SQL.Column_Value(s_cursor, 12, s_ship_method_code);
1442: DBMS_SQL.Column_Value(s_cursor, 13, s_shipment_priority);
1443: DBMS_SQL.Column_Value(s_cursor, 14, s_departure_id);
1444: DBMS_SQL.Column_Value(s_cursor, 15, s_delivery_id);
1445: DBMS_SQL.Column_Value(s_cursor, 16, s_schedule_date);
1446: DBMS_SQL.Column_Value(s_cursor, 17, s_customer_item_id);
1447: DBMS_SQL.Column_Value(s_cursor, 18, s_dep_plan_required_flag);

Line 1444: DBMS_SQL.Column_Value(s_cursor, 15, s_delivery_id);

1440: DBMS_SQL.Column_Value(s_cursor, 11, s_ship_to_contact_id);
1441: DBMS_SQL.Column_Value(s_cursor, 12, s_ship_method_code);
1442: DBMS_SQL.Column_Value(s_cursor, 13, s_shipment_priority);
1443: DBMS_SQL.Column_Value(s_cursor, 14, s_departure_id);
1444: DBMS_SQL.Column_Value(s_cursor, 15, s_delivery_id);
1445: DBMS_SQL.Column_Value(s_cursor, 16, s_schedule_date);
1446: DBMS_SQL.Column_Value(s_cursor, 17, s_customer_item_id);
1447: DBMS_SQL.Column_Value(s_cursor, 18, s_dep_plan_required_flag);
1448: DBMS_SQL.Column_Value(s_cursor, 19, s_order_number);

Line 1445: DBMS_SQL.Column_Value(s_cursor, 16, s_schedule_date);

1441: DBMS_SQL.Column_Value(s_cursor, 12, s_ship_method_code);
1442: DBMS_SQL.Column_Value(s_cursor, 13, s_shipment_priority);
1443: DBMS_SQL.Column_Value(s_cursor, 14, s_departure_id);
1444: DBMS_SQL.Column_Value(s_cursor, 15, s_delivery_id);
1445: DBMS_SQL.Column_Value(s_cursor, 16, s_schedule_date);
1446: DBMS_SQL.Column_Value(s_cursor, 17, s_customer_item_id);
1447: DBMS_SQL.Column_Value(s_cursor, 18, s_dep_plan_required_flag);
1448: DBMS_SQL.Column_Value(s_cursor, 19, s_order_number);
1449: DBMS_SQL.Column_Value(s_cursor, 20, s_order_type_id);

Line 1446: DBMS_SQL.Column_Value(s_cursor, 17, s_customer_item_id);

1442: DBMS_SQL.Column_Value(s_cursor, 13, s_shipment_priority);
1443: DBMS_SQL.Column_Value(s_cursor, 14, s_departure_id);
1444: DBMS_SQL.Column_Value(s_cursor, 15, s_delivery_id);
1445: DBMS_SQL.Column_Value(s_cursor, 16, s_schedule_date);
1446: DBMS_SQL.Column_Value(s_cursor, 17, s_customer_item_id);
1447: DBMS_SQL.Column_Value(s_cursor, 18, s_dep_plan_required_flag);
1448: DBMS_SQL.Column_Value(s_cursor, 19, s_order_number);
1449: DBMS_SQL.Column_Value(s_cursor, 20, s_order_type_id);
1450: DBMS_SQL.Column_Value(s_cursor, 21, s_customer_id);

Line 1447: DBMS_SQL.Column_Value(s_cursor, 18, s_dep_plan_required_flag);

1443: DBMS_SQL.Column_Value(s_cursor, 14, s_departure_id);
1444: DBMS_SQL.Column_Value(s_cursor, 15, s_delivery_id);
1445: DBMS_SQL.Column_Value(s_cursor, 16, s_schedule_date);
1446: DBMS_SQL.Column_Value(s_cursor, 17, s_customer_item_id);
1447: DBMS_SQL.Column_Value(s_cursor, 18, s_dep_plan_required_flag);
1448: DBMS_SQL.Column_Value(s_cursor, 19, s_order_number);
1449: DBMS_SQL.Column_Value(s_cursor, 20, s_order_type_id);
1450: DBMS_SQL.Column_Value(s_cursor, 21, s_customer_id);
1451: DBMS_SQL.Column_Value(s_cursor, 22, s_invoice_to_site_use_id);

Line 1448: DBMS_SQL.Column_Value(s_cursor, 19, s_order_number);

1444: DBMS_SQL.Column_Value(s_cursor, 15, s_delivery_id);
1445: DBMS_SQL.Column_Value(s_cursor, 16, s_schedule_date);
1446: DBMS_SQL.Column_Value(s_cursor, 17, s_customer_item_id);
1447: DBMS_SQL.Column_Value(s_cursor, 18, s_dep_plan_required_flag);
1448: DBMS_SQL.Column_Value(s_cursor, 19, s_order_number);
1449: DBMS_SQL.Column_Value(s_cursor, 20, s_order_type_id);
1450: DBMS_SQL.Column_Value(s_cursor, 21, s_customer_id);
1451: DBMS_SQL.Column_Value(s_cursor, 22, s_invoice_to_site_use_id);
1452: DBMS_SQL.Column_Value(s_cursor, 23, s_master_container_id);

Line 1449: DBMS_SQL.Column_Value(s_cursor, 20, s_order_type_id);

1445: DBMS_SQL.Column_Value(s_cursor, 16, s_schedule_date);
1446: DBMS_SQL.Column_Value(s_cursor, 17, s_customer_item_id);
1447: DBMS_SQL.Column_Value(s_cursor, 18, s_dep_plan_required_flag);
1448: DBMS_SQL.Column_Value(s_cursor, 19, s_order_number);
1449: DBMS_SQL.Column_Value(s_cursor, 20, s_order_type_id);
1450: DBMS_SQL.Column_Value(s_cursor, 21, s_customer_id);
1451: DBMS_SQL.Column_Value(s_cursor, 22, s_invoice_to_site_use_id);
1452: DBMS_SQL.Column_Value(s_cursor, 23, s_master_container_id);
1453: DBMS_SQL.Column_Value(s_cursor, 24, s_detail_container_id);

Line 1450: DBMS_SQL.Column_Value(s_cursor, 21, s_customer_id);

1446: DBMS_SQL.Column_Value(s_cursor, 17, s_customer_item_id);
1447: DBMS_SQL.Column_Value(s_cursor, 18, s_dep_plan_required_flag);
1448: DBMS_SQL.Column_Value(s_cursor, 19, s_order_number);
1449: DBMS_SQL.Column_Value(s_cursor, 20, s_order_type_id);
1450: DBMS_SQL.Column_Value(s_cursor, 21, s_customer_id);
1451: DBMS_SQL.Column_Value(s_cursor, 22, s_invoice_to_site_use_id);
1452: DBMS_SQL.Column_Value(s_cursor, 23, s_master_container_id);
1453: DBMS_SQL.Column_Value(s_cursor, 24, s_detail_container_id);
1454: DBMS_SQL.Column_Value(s_cursor, 25, s_load_seq_number);

Line 1451: DBMS_SQL.Column_Value(s_cursor, 22, s_invoice_to_site_use_id);

1447: DBMS_SQL.Column_Value(s_cursor, 18, s_dep_plan_required_flag);
1448: DBMS_SQL.Column_Value(s_cursor, 19, s_order_number);
1449: DBMS_SQL.Column_Value(s_cursor, 20, s_order_type_id);
1450: DBMS_SQL.Column_Value(s_cursor, 21, s_customer_id);
1451: DBMS_SQL.Column_Value(s_cursor, 22, s_invoice_to_site_use_id);
1452: DBMS_SQL.Column_Value(s_cursor, 23, s_master_container_id);
1453: DBMS_SQL.Column_Value(s_cursor, 24, s_detail_container_id);
1454: DBMS_SQL.Column_Value(s_cursor, 25, s_load_seq_number);
1455: ELSIF p_source = 'n' THEN

Line 1452: DBMS_SQL.Column_Value(s_cursor, 23, s_master_container_id);

1448: DBMS_SQL.Column_Value(s_cursor, 19, s_order_number);
1449: DBMS_SQL.Column_Value(s_cursor, 20, s_order_type_id);
1450: DBMS_SQL.Column_Value(s_cursor, 21, s_customer_id);
1451: DBMS_SQL.Column_Value(s_cursor, 22, s_invoice_to_site_use_id);
1452: DBMS_SQL.Column_Value(s_cursor, 23, s_master_container_id);
1453: DBMS_SQL.Column_Value(s_cursor, 24, s_detail_container_id);
1454: DBMS_SQL.Column_Value(s_cursor, 25, s_load_seq_number);
1455: ELSIF p_source = 'n' THEN
1456: DBMS_SQL.Column_Value(ns_cursor, 1, n_line_id);

Line 1453: DBMS_SQL.Column_Value(s_cursor, 24, s_detail_container_id);

1449: DBMS_SQL.Column_Value(s_cursor, 20, s_order_type_id);
1450: DBMS_SQL.Column_Value(s_cursor, 21, s_customer_id);
1451: DBMS_SQL.Column_Value(s_cursor, 22, s_invoice_to_site_use_id);
1452: DBMS_SQL.Column_Value(s_cursor, 23, s_master_container_id);
1453: DBMS_SQL.Column_Value(s_cursor, 24, s_detail_container_id);
1454: DBMS_SQL.Column_Value(s_cursor, 25, s_load_seq_number);
1455: ELSIF p_source = 'n' THEN
1456: DBMS_SQL.Column_Value(ns_cursor, 1, n_line_id);
1457: DBMS_SQL.Column_Value(ns_cursor, 2, n_header_id);

Line 1454: DBMS_SQL.Column_Value(s_cursor, 25, s_load_seq_number);

1450: DBMS_SQL.Column_Value(s_cursor, 21, s_customer_id);
1451: DBMS_SQL.Column_Value(s_cursor, 22, s_invoice_to_site_use_id);
1452: DBMS_SQL.Column_Value(s_cursor, 23, s_master_container_id);
1453: DBMS_SQL.Column_Value(s_cursor, 24, s_detail_container_id);
1454: DBMS_SQL.Column_Value(s_cursor, 25, s_load_seq_number);
1455: ELSIF p_source = 'n' THEN
1456: DBMS_SQL.Column_Value(ns_cursor, 1, n_line_id);
1457: DBMS_SQL.Column_Value(ns_cursor, 2, n_header_id);
1458: DBMS_SQL.Column_Value(ns_cursor, 3, n_line_detail_id);

Line 1456: DBMS_SQL.Column_Value(ns_cursor, 1, n_line_id);

1452: DBMS_SQL.Column_Value(s_cursor, 23, s_master_container_id);
1453: DBMS_SQL.Column_Value(s_cursor, 24, s_detail_container_id);
1454: DBMS_SQL.Column_Value(s_cursor, 25, s_load_seq_number);
1455: ELSIF p_source = 'n' THEN
1456: DBMS_SQL.Column_Value(ns_cursor, 1, n_line_id);
1457: DBMS_SQL.Column_Value(ns_cursor, 2, n_header_id);
1458: DBMS_SQL.Column_Value(ns_cursor, 3, n_line_detail_id);
1459: DBMS_SQL.Column_Value(ns_cursor, 4, n_org_id);
1460: END IF;

Line 1457: DBMS_SQL.Column_Value(ns_cursor, 2, n_header_id);

1453: DBMS_SQL.Column_Value(s_cursor, 24, s_detail_container_id);
1454: DBMS_SQL.Column_Value(s_cursor, 25, s_load_seq_number);
1455: ELSIF p_source = 'n' THEN
1456: DBMS_SQL.Column_Value(ns_cursor, 1, n_line_id);
1457: DBMS_SQL.Column_Value(ns_cursor, 2, n_header_id);
1458: DBMS_SQL.Column_Value(ns_cursor, 3, n_line_detail_id);
1459: DBMS_SQL.Column_Value(ns_cursor, 4, n_org_id);
1460: END IF;
1461:

Line 1458: DBMS_SQL.Column_Value(ns_cursor, 3, n_line_detail_id);

1454: DBMS_SQL.Column_Value(s_cursor, 25, s_load_seq_number);
1455: ELSIF p_source = 'n' THEN
1456: DBMS_SQL.Column_Value(ns_cursor, 1, n_line_id);
1457: DBMS_SQL.Column_Value(ns_cursor, 2, n_header_id);
1458: DBMS_SQL.Column_Value(ns_cursor, 3, n_line_detail_id);
1459: DBMS_SQL.Column_Value(ns_cursor, 4, n_org_id);
1460: END IF;
1461:
1462: RETURN;

Line 1459: DBMS_SQL.Column_Value(ns_cursor, 4, n_org_id);

1455: ELSIF p_source = 'n' THEN
1456: DBMS_SQL.Column_Value(ns_cursor, 1, n_line_id);
1457: DBMS_SQL.Column_Value(ns_cursor, 2, n_header_id);
1458: DBMS_SQL.Column_Value(ns_cursor, 3, n_line_detail_id);
1459: DBMS_SQL.Column_Value(ns_cursor, 4, n_org_id);
1460: END IF;
1461:
1462: RETURN;
1463:

Line 1748: sreq_cursor := DBMS_SQL.Open_Cursor;

1744: WSH_UTIL.Write_Log('Error in Construct SQL');
1745: RETURN FAILURE;
1746: END IF;
1747: sreq_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('SET_REQUEST_SQL');
1748: sreq_cursor := DBMS_SQL.Open_Cursor;
1749: DBMS_SQL.Parse(sreq_cursor, sreq_SQL, DBMS_SQL.v7);
1750:
1751: WSH_UTIL.Write_Log('Binding Set Request ID cursor');
1752:

Line 1749: DBMS_SQL.Parse(sreq_cursor, sreq_SQL, DBMS_SQL.v7);

1745: RETURN FAILURE;
1746: END IF;
1747: sreq_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('SET_REQUEST_SQL');
1748: sreq_cursor := DBMS_SQL.Open_Cursor;
1749: DBMS_SQL.Parse(sreq_cursor, sreq_SQL, DBMS_SQL.v7);
1750:
1751: WSH_UTIL.Write_Log('Binding Set Request ID cursor');
1752:
1753: WSH_UTIL.Write_Log('X_request_id = ' || to_char(wsh_pr_picking_session.request_id));

Line 1754: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_request_id',

1750:
1751: WSH_UTIL.Write_Log('Binding Set Request ID cursor');
1752:
1753: WSH_UTIL.Write_Log('X_request_id = ' || to_char(wsh_pr_picking_session.request_id));
1754: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_request_id',
1755: wsh_pr_picking_session.request_id);
1756: WSH_UTIL.Write_Log('X_sync_line_id = ' || to_char(p_sync_line_id));
1757: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_sync_line_id',
1758: p_sync_line_id);

Line 1757: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_sync_line_id',

1753: WSH_UTIL.Write_Log('X_request_id = ' || to_char(wsh_pr_picking_session.request_id));
1754: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_request_id',
1755: wsh_pr_picking_session.request_id);
1756: WSH_UTIL.Write_Log('X_sync_line_id = ' || to_char(p_sync_line_id));
1757: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_sync_line_id',
1758: p_sync_line_id);
1759: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
1760: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_request_date',
1761: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 1760: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_request_date',

1756: WSH_UTIL.Write_Log('X_sync_line_id = ' || to_char(p_sync_line_id));
1757: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_sync_line_id',
1758: p_sync_line_id);
1759: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
1760: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_request_date',
1761: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
1762: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1763: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_request_date',
1764: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 1763: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_request_date',

1759: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
1760: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_request_date',
1761: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
1762: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1763: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_request_date',
1764: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1765: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
1766: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_inventory_item_id',
1767: wsh_pr_picking_session.inventory_item_id);

Line 1766: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_inventory_item_id',

1762: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1763: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_request_date',
1764: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1765: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
1766: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_inventory_item_id',
1767: wsh_pr_picking_session.inventory_item_id);
1768: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
1769: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_warehouse_id',
1770: wsh_pr_picking_session.warehouse_id);

Line 1769: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_warehouse_id',

1765: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
1766: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_inventory_item_id',
1767: wsh_pr_picking_session.inventory_item_id);
1768: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
1769: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_warehouse_id',
1770: wsh_pr_picking_session.warehouse_id);
1771: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1772: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_sched_ship_date',
1773: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 1772: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_sched_ship_date',

1768: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
1769: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_warehouse_id',
1770: wsh_pr_picking_session.warehouse_id);
1771: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1772: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_sched_ship_date',
1773: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1774: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1775: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_sched_ship_date',
1776: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 1775: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_sched_ship_date',

1771: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1772: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_sched_ship_date',
1773: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1774: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1775: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_sched_ship_date',
1776: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1777:
1778: v_ignore := DBMS_SQL.Execute(sreq_cursor);
1779: WSH_UTIL.Write_Log('Updated ' || to_char(v_ignore) || ' lines in model');

Line 1778: v_ignore := DBMS_SQL.Execute(sreq_cursor);

1774: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1775: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_sched_ship_date',
1776: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1777:
1778: v_ignore := DBMS_SQL.Execute(sreq_cursor);
1779: WSH_UTIL.Write_Log('Updated ' || to_char(v_ignore) || ' lines in model');
1780: DBMS_SQL.Close_Cursor(sreq_cursor);
1781: RETURN SUCCESS;
1782:

Line 1780: DBMS_SQL.Close_Cursor(sreq_cursor);

1776: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1777:
1778: v_ignore := DBMS_SQL.Execute(sreq_cursor);
1779: WSH_UTIL.Write_Log('Updated ' || to_char(v_ignore) || ' lines in model');
1780: DBMS_SQL.Close_Cursor(sreq_cursor);
1781: RETURN SUCCESS;
1782:
1783: EXCEPTION
1784: WHEN OTHERS THEN

Line 1870: IF DBMS_SQL.Fetch_Rows(s_cursor) > 0 THEN

1866: LOOP
1867: IF current_sync_line < MAX_LINES THEN
1868: -- Inserts the next line detail into sync_table
1869:
1870: IF DBMS_SQL.Fetch_Rows(s_cursor) > 0 THEN
1871: Map_Col_Value('s');
1872: Insert_RL_Row('s');
1873: cs := SUCCESS;
1874: ELSE

Line 1875: DBMS_SQL.Close_Cursor(s_cursor);

1871: Map_Col_Value('s');
1872: Insert_RL_Row('s');
1873: cs := SUCCESS;
1874: ELSE
1875: DBMS_SQL.Close_Cursor(s_cursor);
1876: cs := DONE;
1877: END IF;
1878:
1879: IF cs = DONE THEN

Line 2004: IF DBMS_SQL.Fetch_Rows(ns_cursor) > 0 THEN

2000: LOOP
2001: IF current_line < MAX_LINES THEN
2002: -- Fetch lines from the non-shippable cursor
2003:
2004: IF DBMS_SQL.Fetch_Rows(ns_cursor) > 0 THEN
2005: Map_Col_Value('n');
2006: Insert_RL_Row('n');
2007: cs := SUCCESS;
2008: ELSE

Line 2009: DBMS_SQL.Close_Cursor(ns_cursor);

2005: Map_Col_Value('n');
2006: Insert_RL_Row('n');
2007: cs := SUCCESS;
2008: ELSE
2009: DBMS_SQL.Close_Cursor(ns_cursor);
2010: cs := DONE;
2011: END IF;
2012:
2013: IF cs = FAILURE THEN

Line 2070: IF DBMS_SQL.Is_Open(u_cursor) THEN

2066: PROCEDURE Close_Cursors IS
2067:
2068: BEGIN
2069:
2070: IF DBMS_SQL.Is_Open(u_cursor) THEN
2071: DBMS_SQL.Close_Cursor(u_cursor);
2072: END IF;
2073: IF DBMS_SQL.Is_Open(b_cursor) THEN
2074: DBMS_SQL.Close_Cursor(b_cursor);

Line 2071: DBMS_SQL.Close_Cursor(u_cursor);

2067:
2068: BEGIN
2069:
2070: IF DBMS_SQL.Is_Open(u_cursor) THEN
2071: DBMS_SQL.Close_Cursor(u_cursor);
2072: END IF;
2073: IF DBMS_SQL.Is_Open(b_cursor) THEN
2074: DBMS_SQL.Close_Cursor(b_cursor);
2075: END IF;

Line 2073: IF DBMS_SQL.Is_Open(b_cursor) THEN

2069:
2070: IF DBMS_SQL.Is_Open(u_cursor) THEN
2071: DBMS_SQL.Close_Cursor(u_cursor);
2072: END IF;
2073: IF DBMS_SQL.Is_Open(b_cursor) THEN
2074: DBMS_SQL.Close_Cursor(b_cursor);
2075: END IF;
2076: IF DBMS_SQL.Is_Open(s_cursor) THEN
2077: DBMS_SQL.Close_Cursor(s_cursor);

Line 2074: DBMS_SQL.Close_Cursor(b_cursor);

2070: IF DBMS_SQL.Is_Open(u_cursor) THEN
2071: DBMS_SQL.Close_Cursor(u_cursor);
2072: END IF;
2073: IF DBMS_SQL.Is_Open(b_cursor) THEN
2074: DBMS_SQL.Close_Cursor(b_cursor);
2075: END IF;
2076: IF DBMS_SQL.Is_Open(s_cursor) THEN
2077: DBMS_SQL.Close_Cursor(s_cursor);
2078: END IF;

Line 2076: IF DBMS_SQL.Is_Open(s_cursor) THEN

2072: END IF;
2073: IF DBMS_SQL.Is_Open(b_cursor) THEN
2074: DBMS_SQL.Close_Cursor(b_cursor);
2075: END IF;
2076: IF DBMS_SQL.Is_Open(s_cursor) THEN
2077: DBMS_SQL.Close_Cursor(s_cursor);
2078: END IF;
2079: IF DBMS_SQL.Is_Open(ns_cursor) THEN
2080: DBMS_SQL.Close_Cursor(ns_cursor);

Line 2077: DBMS_SQL.Close_Cursor(s_cursor);

2073: IF DBMS_SQL.Is_Open(b_cursor) THEN
2074: DBMS_SQL.Close_Cursor(b_cursor);
2075: END IF;
2076: IF DBMS_SQL.Is_Open(s_cursor) THEN
2077: DBMS_SQL.Close_Cursor(s_cursor);
2078: END IF;
2079: IF DBMS_SQL.Is_Open(ns_cursor) THEN
2080: DBMS_SQL.Close_Cursor(ns_cursor);
2081: END IF;

Line 2079: IF DBMS_SQL.Is_Open(ns_cursor) THEN

2075: END IF;
2076: IF DBMS_SQL.Is_Open(s_cursor) THEN
2077: DBMS_SQL.Close_Cursor(s_cursor);
2078: END IF;
2079: IF DBMS_SQL.Is_Open(ns_cursor) THEN
2080: DBMS_SQL.Close_Cursor(ns_cursor);
2081: END IF;
2082: IF DBMS_SQL.Is_Open(sreq_cursor) THEN
2083: DBMS_SQL.Close_Cursor(sreq_cursor);

Line 2080: DBMS_SQL.Close_Cursor(ns_cursor);

2076: IF DBMS_SQL.Is_Open(s_cursor) THEN
2077: DBMS_SQL.Close_Cursor(s_cursor);
2078: END IF;
2079: IF DBMS_SQL.Is_Open(ns_cursor) THEN
2080: DBMS_SQL.Close_Cursor(ns_cursor);
2081: END IF;
2082: IF DBMS_SQL.Is_Open(sreq_cursor) THEN
2083: DBMS_SQL.Close_Cursor(sreq_cursor);
2084: END IF;

Line 2082: IF DBMS_SQL.Is_Open(sreq_cursor) THEN

2078: END IF;
2079: IF DBMS_SQL.Is_Open(ns_cursor) THEN
2080: DBMS_SQL.Close_Cursor(ns_cursor);
2081: END IF;
2082: IF DBMS_SQL.Is_Open(sreq_cursor) THEN
2083: DBMS_SQL.Close_Cursor(sreq_cursor);
2084: END IF;
2085:
2086: END Close_Cursors;

Line 2083: DBMS_SQL.Close_Cursor(sreq_cursor);

2079: IF DBMS_SQL.Is_Open(ns_cursor) THEN
2080: DBMS_SQL.Close_Cursor(ns_cursor);
2081: END IF;
2082: IF DBMS_SQL.Is_Open(sreq_cursor) THEN
2083: DBMS_SQL.Close_Cursor(sreq_cursor);
2084: END IF;
2085:
2086: END Close_Cursors;
2087: