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

Line 570: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

566: END;
567: ELSE -- Some parameter is passed
568:
569: -- Open cursor.
570: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
571:
572: -- Building the dynamic query based on parameters passed.
573: -- Moac Changed below cursor to use oe_order_headers_all
574: /*Start MOAC_SQL_CHANGE */

Line 740: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);

736: oe_debug_pub.add('Query : ' || l_stmt, 1 ) ;
737: END IF;
738:
739: -- Parse statement.
740: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);
741:
742: -- Bind variables
743: -- Moac Start
744: IF p_org_id is NOT NULL THEN

Line 745: DBMS_SQL.Bind_Variable(l_cursor_id, ':org_id', p_org_id);

741:
742: -- Bind variables
743: -- Moac Start
744: IF p_org_id is NOT NULL THEN
745: DBMS_SQL.Bind_Variable(l_cursor_id, ':org_id', p_org_id);
746: END IF;
747: -- Moac End
748:
749: IF p_order_number_low IS NOT NULL THEN

Line 750: DBMS_SQL.Bind_Variable(l_cursor_id, ':order_number_low',

746: END IF;
747: -- Moac End
748:
749: IF p_order_number_low IS NOT NULL THEN
750: DBMS_SQL.Bind_Variable(l_cursor_id, ':order_number_low',
751: p_order_number_low);
752: END IF;
753: IF p_order_number_high IS NOT NULL THEN
754: DBMS_SQL.Bind_Variable(l_cursor_id, ':order_number_high',

Line 754: DBMS_SQL.Bind_Variable(l_cursor_id, ':order_number_high',

750: DBMS_SQL.Bind_Variable(l_cursor_id, ':order_number_low',
751: p_order_number_low);
752: END IF;
753: IF p_order_number_high IS NOT NULL THEN
754: DBMS_SQL.Bind_Variable(l_cursor_id, ':order_number_high',
755: p_order_number_high);
756: END IF;
757: IF p_request_date_low IS NOT NULL THEN
758: DBMS_SQL.Bind_Variable(l_cursor_id, ':request_date_low',

Line 758: DBMS_SQL.Bind_Variable(l_cursor_id, ':request_date_low',

754: DBMS_SQL.Bind_Variable(l_cursor_id, ':order_number_high',
755: p_order_number_high);
756: END IF;
757: IF p_request_date_low IS NOT NULL THEN
758: DBMS_SQL.Bind_Variable(l_cursor_id, ':request_date_low',
759: l_request_date_low);
760: END IF;
761: IF p_request_date_high IS NOT NULL THEN
762: DBMS_SQL.Bind_Variable(l_cursor_id, ':request_date_high',

Line 762: DBMS_SQL.Bind_Variable(l_cursor_id, ':request_date_high',

758: DBMS_SQL.Bind_Variable(l_cursor_id, ':request_date_low',
759: l_request_date_low);
760: END IF;
761: IF p_request_date_high IS NOT NULL THEN
762: DBMS_SQL.Bind_Variable(l_cursor_id, ':request_date_high',
763: l_request_date_high);
764: END IF;
765: IF p_customer_po_number IS NOT NULL THEN
766: DBMS_SQL.Bind_Variable(l_cursor_id, ':customer_po_number',

Line 766: DBMS_SQL.Bind_Variable(l_cursor_id, ':customer_po_number',

762: DBMS_SQL.Bind_Variable(l_cursor_id, ':request_date_high',
763: l_request_date_high);
764: END IF;
765: IF p_customer_po_number IS NOT NULL THEN
766: DBMS_SQL.Bind_Variable(l_cursor_id, ':customer_po_number',
767: p_customer_po_number);
768: END IF;
769: IF p_ship_to_location IS NOT NULL THEN
770: DBMS_SQL.Bind_Variable(l_cursor_id, ':ship_to_location',

Line 770: DBMS_SQL.Bind_Variable(l_cursor_id, ':ship_to_location',

766: DBMS_SQL.Bind_Variable(l_cursor_id, ':customer_po_number',
767: p_customer_po_number);
768: END IF;
769: IF p_ship_to_location IS NOT NULL THEN
770: DBMS_SQL.Bind_Variable(l_cursor_id, ':ship_to_location',
771: p_ship_to_location);
772: END IF;
773: IF p_order_type IS NOT NULL THEN
774: DBMS_SQL.Bind_Variable(l_cursor_id, ':order_type', p_order_type);

Line 774: DBMS_SQL.Bind_Variable(l_cursor_id, ':order_type', p_order_type);

770: DBMS_SQL.Bind_Variable(l_cursor_id, ':ship_to_location',
771: p_ship_to_location);
772: END IF;
773: IF p_order_type IS NOT NULL THEN
774: DBMS_SQL.Bind_Variable(l_cursor_id, ':order_type', p_order_type);
775: END IF;
776: IF p_customer IS NOT NULL THEN
777: DBMS_SQL.Bind_Variable(l_cursor_id, ':customer', p_customer);
778: END IF;

Line 777: DBMS_SQL.Bind_Variable(l_cursor_id, ':customer', p_customer);

773: IF p_order_type IS NOT NULL THEN
774: DBMS_SQL.Bind_Variable(l_cursor_id, ':order_type', p_order_type);
775: END IF;
776: IF p_customer IS NOT NULL THEN
777: DBMS_SQL.Bind_Variable(l_cursor_id, ':customer', p_customer);
778: END IF;
779: IF p_item IS NOT NULL THEN
780: DBMS_SQL.Bind_Variable(l_cursor_id, ':item', p_item);
781: END IF;

Line 780: DBMS_SQL.Bind_Variable(l_cursor_id, ':item', p_item);

776: IF p_customer IS NOT NULL THEN
777: DBMS_SQL.Bind_Variable(l_cursor_id, ':customer', p_customer);
778: END IF;
779: IF p_item IS NOT NULL THEN
780: DBMS_SQL.Bind_Variable(l_cursor_id, ':item', p_item);
781: END IF;
782: IF p_ordered_date_low IS NOT NULL THEN
783: DBMS_SQL.Bind_Variable(l_cursor_id, ':ordered_date_low',
784: l_ordered_date_low);

Line 783: DBMS_SQL.Bind_Variable(l_cursor_id, ':ordered_date_low',

779: IF p_item IS NOT NULL THEN
780: DBMS_SQL.Bind_Variable(l_cursor_id, ':item', p_item);
781: END IF;
782: IF p_ordered_date_low IS NOT NULL THEN
783: DBMS_SQL.Bind_Variable(l_cursor_id, ':ordered_date_low',
784: l_ordered_date_low);
785: END IF;
786: IF p_ordered_date_high IS NOT NULL THEN
787: DBMS_SQL.Bind_Variable(l_cursor_id, ':ordered_date_high',

Line 787: DBMS_SQL.Bind_Variable(l_cursor_id, ':ordered_date_high',

783: DBMS_SQL.Bind_Variable(l_cursor_id, ':ordered_date_low',
784: l_ordered_date_low);
785: END IF;
786: IF p_ordered_date_high IS NOT NULL THEN
787: DBMS_SQL.Bind_Variable(l_cursor_id, ':ordered_date_high',
788: l_ordered_date_high);
789: END IF;
790: IF p_warehouse IS NOT NULL THEN
791: DBMS_SQL.Bind_Variable(l_cursor_id, ':warehouse', p_warehouse);

Line 791: DBMS_SQL.Bind_Variable(l_cursor_id, ':warehouse', p_warehouse);

787: DBMS_SQL.Bind_Variable(l_cursor_id, ':ordered_date_high',
788: l_ordered_date_high);
789: END IF;
790: IF p_warehouse IS NOT NULL THEN
791: DBMS_SQL.Bind_Variable(l_cursor_id, ':warehouse', p_warehouse);
792: END IF;
793: IF p_demand_class IS NOT NULL THEN
794: DBMS_SQL.Bind_Variable(l_cursor_id, ':demand_class', p_demand_class);
795: END IF;

Line 794: DBMS_SQL.Bind_Variable(l_cursor_id, ':demand_class', p_demand_class);

790: IF p_warehouse IS NOT NULL THEN
791: DBMS_SQL.Bind_Variable(l_cursor_id, ':warehouse', p_warehouse);
792: END IF;
793: IF p_demand_class IS NOT NULL THEN
794: DBMS_SQL.Bind_Variable(l_cursor_id, ':demand_class', p_demand_class);
795: END IF;
796: IF p_planning_priority IS NOT NULL THEN
797: DBMS_SQL.Bind_Variable(l_cursor_id, ':planning_priority',
798: p_planning_priority);

Line 797: DBMS_SQL.Bind_Variable(l_cursor_id, ':planning_priority',

793: IF p_demand_class IS NOT NULL THEN
794: DBMS_SQL.Bind_Variable(l_cursor_id, ':demand_class', p_demand_class);
795: END IF;
796: IF p_planning_priority IS NOT NULL THEN
797: DBMS_SQL.Bind_Variable(l_cursor_id, ':planning_priority',
798: p_planning_priority);
799: END IF;
800: IF p_shipment_priority IS NOT NULL THEN
801: DBMS_SQL.Bind_Variable(l_cursor_id, ':shipment_priority',

Line 801: DBMS_SQL.Bind_Variable(l_cursor_id, ':shipment_priority',

797: DBMS_SQL.Bind_Variable(l_cursor_id, ':planning_priority',
798: p_planning_priority);
799: END IF;
800: IF p_shipment_priority IS NOT NULL THEN
801: DBMS_SQL.Bind_Variable(l_cursor_id, ':shipment_priority',
802: p_shipment_priority);
803: END IF;
804: IF p_line_type IS NOT NULL THEN
805: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_type', p_line_type);

Line 805: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_type', p_line_type);

801: DBMS_SQL.Bind_Variable(l_cursor_id, ':shipment_priority',
802: p_shipment_priority);
803: END IF;
804: IF p_line_type IS NOT NULL THEN
805: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_type', p_line_type);
806: END IF;
807: IF p_line_request_date_low IS NOT NULL THEN
808: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_request_date_low',
809: l_line_request_date_low);

Line 808: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_request_date_low',

804: IF p_line_type IS NOT NULL THEN
805: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_type', p_line_type);
806: END IF;
807: IF p_line_request_date_low IS NOT NULL THEN
808: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_request_date_low',
809: l_line_request_date_low);
810: END IF;
811: IF p_line_request_date_high IS NOT NULL THEN
812: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_request_date_high',

Line 812: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_request_date_high',

808: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_request_date_low',
809: l_line_request_date_low);
810: END IF;
811: IF p_line_request_date_high IS NOT NULL THEN
812: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_request_date_high',
813: l_line_request_date_high);
814: END IF;
815: IF p_line_ship_to_location IS NOT NULL THEN
816: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_ship_to_location',

Line 816: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_ship_to_location',

812: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_request_date_high',
813: l_line_request_date_high);
814: END IF;
815: IF p_line_ship_to_location IS NOT NULL THEN
816: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_ship_to_location',
817: p_line_ship_to_location);
818: END IF;
819: IF p_sch_ship_date_low IS NOT NULL THEN
820: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_ship_date_low',

Line 820: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_ship_date_low',

816: DBMS_SQL.Bind_Variable(l_cursor_id, ':line_ship_to_location',
817: p_line_ship_to_location);
818: END IF;
819: IF p_sch_ship_date_low IS NOT NULL THEN
820: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_ship_date_low',
821: l_sch_ship_date_low);
822: END IF;
823: IF p_sch_ship_date_high IS NOT NULL THEN
824: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_ship_date_high',

Line 824: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_ship_date_high',

820: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_ship_date_low',
821: l_sch_ship_date_low);
822: END IF;
823: IF p_sch_ship_date_high IS NOT NULL THEN
824: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_ship_date_high',
825: l_sch_ship_date_high);
826: END IF;
827: IF p_sch_arrival_date_low IS NOT NULL THEN
828: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_arrival_date_low',

Line 828: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_arrival_date_low',

824: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_ship_date_high',
825: l_sch_ship_date_high);
826: END IF;
827: IF p_sch_arrival_date_low IS NOT NULL THEN
828: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_arrival_date_low',
829: l_sch_arrival_date_low);
830: END IF;
831: IF p_sch_arrival_date_high IS NOT NULL THEN
832: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_arrival_date_high',

Line 832: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_arrival_date_high',

828: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_arrival_date_low',
829: l_sch_arrival_date_low);
830: END IF;
831: IF p_sch_arrival_date_high IS NOT NULL THEN
832: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_arrival_date_high',
833: l_sch_arrival_date_high);
834: END IF;
835: IF p_booked IS NOT NULL THEN
836: DBMS_SQL.Bind_Variable(l_cursor_id, ':booked', p_booked);

Line 836: DBMS_SQL.Bind_Variable(l_cursor_id, ':booked', p_booked);

832: DBMS_SQL.Bind_Variable(l_cursor_id, ':sch_arrival_date_high',
833: l_sch_arrival_date_high);
834: END IF;
835: IF p_booked IS NOT NULL THEN
836: DBMS_SQL.Bind_Variable(l_cursor_id, ':booked', p_booked);
837: END IF;
838: --12639770
839: IF NVL(p_sch_mode, 'LINE_ELIGIBLE') = 'LINE_ELIGIBLE' THEN
840: DBMS_SQL.Bind_Variable(l_cursor_id, ':prg_start_date', l_prg_start_date);

Line 840: DBMS_SQL.Bind_Variable(l_cursor_id, ':prg_start_date', l_prg_start_date);

836: DBMS_SQL.Bind_Variable(l_cursor_id, ':booked', p_booked);
837: END IF;
838: --12639770
839: IF NVL(p_sch_mode, 'LINE_ELIGIBLE') = 'LINE_ELIGIBLE' THEN
840: DBMS_SQL.Bind_Variable(l_cursor_id, ':prg_start_date', l_prg_start_date);
841: END IF;
842:
843: --Bug 8813015: start
844: --This code is to be un-commented while providing option for

Line 848: DBMS_SQL.Bind_Variable(l_cursor_id, ':picked', p_picked);

844: --This code is to be un-commented while providing option for
845: --picked lines in scheduling concurrent request UI.
846: /*
847: IF p_picked IS NOT NULL THEN
848: DBMS_SQL.Bind_Variable(l_cursor_id, ':picked', p_picked);
849: END IF;
850: */
851: --Bug 8813015: end
852:

Line 854: DBMS_SQL.Define_Column(l_cursor_id, 1, l_header_id);

850: */
851: --Bug 8813015: end
852:
853: -- Map output columns
854: DBMS_SQL.Define_Column(l_cursor_id, 1, l_header_id);
855: DBMS_SQL.Define_Column(l_cursor_id, 2, l_line_id);
856: DBMS_SQL.Define_Column(l_cursor_id, 3, l_org_id); -- Moac
857:
858: IF l_debug_level > 0 THEN

Line 855: DBMS_SQL.Define_Column(l_cursor_id, 2, l_line_id);

851: --Bug 8813015: end
852:
853: -- Map output columns
854: DBMS_SQL.Define_Column(l_cursor_id, 1, l_header_id);
855: DBMS_SQL.Define_Column(l_cursor_id, 2, l_line_id);
856: DBMS_SQL.Define_Column(l_cursor_id, 3, l_org_id); -- Moac
857:
858: IF l_debug_level > 0 THEN
859: oe_debug_pub.add('Before executing query.',1);

Line 856: DBMS_SQL.Define_Column(l_cursor_id, 3, l_org_id); -- Moac

852:
853: -- Map output columns
854: DBMS_SQL.Define_Column(l_cursor_id, 1, l_header_id);
855: DBMS_SQL.Define_Column(l_cursor_id, 2, l_line_id);
856: DBMS_SQL.Define_Column(l_cursor_id, 3, l_org_id); -- Moac
857:
858: IF l_debug_level > 0 THEN
859: oe_debug_pub.add('Before executing query.',1);
860: END IF;

Line 863: l_retval := DBMS_SQL.Execute(l_cursor_id);

859: oe_debug_pub.add('Before executing query.',1);
860: END IF;
861:
862: -- Execute query.
863: l_retval := DBMS_SQL.Execute(l_cursor_id);
864:
865: IF l_debug_level > 0 THEN
866: oe_debug_pub.add('Execution Result : ' || l_retval, 2) ;
867: END IF;

Line 876: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 THEN

872: IF l_debug_level > 0 THEN
873: oe_debug_pub.add('Execution Result : ' || l_retval, 2) ;
874: END IF;
875:
876: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 THEN
877: EXIT;
878: END IF;
879:
880: DBMS_SQL.Column_Value(l_cursor_id, 1, l_header_id);

Line 880: DBMS_SQL.Column_Value(l_cursor_id, 1, l_header_id);

876: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 THEN
877: EXIT;
878: END IF;
879:
880: DBMS_SQL.Column_Value(l_cursor_id, 1, l_header_id);
881: DBMS_SQL.Column_Value(l_cursor_id, 2, l_line_id);
882: DBMS_SQL.Column_Value(l_cursor_id, 3, l_org_id); -- Moac
883:
884:

Line 881: DBMS_SQL.Column_Value(l_cursor_id, 2, l_line_id);

877: EXIT;
878: END IF;
879:
880: DBMS_SQL.Column_Value(l_cursor_id, 1, l_header_id);
881: DBMS_SQL.Column_Value(l_cursor_id, 2, l_line_id);
882: DBMS_SQL.Column_Value(l_cursor_id, 3, l_org_id); -- Moac
883:
884:
885: IF l_debug_level > 0 THEN

Line 882: DBMS_SQL.Column_Value(l_cursor_id, 3, l_org_id); -- Moac

878: END IF;
879:
880: DBMS_SQL.Column_Value(l_cursor_id, 1, l_header_id);
881: DBMS_SQL.Column_Value(l_cursor_id, 2, l_line_id);
882: DBMS_SQL.Column_Value(l_cursor_id, 3, l_org_id); -- Moac
883:
884:
885: IF l_debug_level > 0 THEN
886: oe_debug_pub.add('***** 1. Processing Line Id '||

Line 1611: DBMS_SQL.Close_Cursor(l_cursor_id);

1607: END IF;
1608: END LOOP; -- loop for each row of dynamic query.
1609:
1610: -- close the cursor
1611: DBMS_SQL.Close_Cursor(l_cursor_id);
1612:
1613: END IF; -- if parameters passed are null.
1614:
1615: OE_MSG_PUB.Save_Messages(p_request_id => to_number(l_request_id));

Line 1654: DBMS_SQL.Close_Cursor(l_cursor_id);

1650:
1651: WHEN OTHERS THEN
1652: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error in OE_SCH_CONC_REQUESTS.Request');
1653: fnd_file.put_line(FND_FILE.LOG, substr(sqlerrm, 1, 2000));
1654: DBMS_SQL.Close_Cursor(l_cursor_id);
1655:
1656: END Request;
1657:
1658: END OE_SCH_CONC_REQUESTS;