APPS.MRP_FORECAST_INTERFACE_PK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 61

        delete_row              BOOLEAN := FALSE;

Line: 66

    SELECT  mrp_forecast_dates_s.nextval
    INTO    var_max_trx_id
    FROM    dual;

Line: 79

        delete_row := FALSE;

Line: 117

            delete_row := TRUE;

Line: 125

              AND delete_row = FALSE
        THEN
            fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

Line: 192

            DELETE  FROM mrp_Forecast_dates
            WHERE   transaction_id = forecast_interface(counter).transaction_id
            and     organization_id =
                    forecast_interface(counter).organization_id
            and     forecast_designator =
                    forecast_interface(counter).forecast_designator;

Line: 231

            SELECT  'x'
            INTO    dummy_var
            FROM    mtl_parameters
            WHERE   organization_id =
                        forecast_interface(counter).organization_id
              AND process_enabled_flag = 'N';  /* 1485309 */

Line: 254

            SELECT  'x'
            INTO    dummy_var
            FROM    mtl_system_items
            WHERE   organization_id =
                        forecast_interface(counter).organization_id
            AND     inventory_item_id =
                        forecast_interface(counter).inventory_item_id;

Line: 278

            SELECT  'x'
            INTO    dummy_var
            FROM    mrp_forecast_designators
            WHERE   forecast_designator =
                        forecast_interface(counter).forecast_designator
            AND     NVL(disable_date, SYSDATE + 2) > TRUNC(SYSDATE)
            AND     forecast_set IS NOT NULL
            AND     organization_id =
                        forecast_interface(counter).organization_id;

Line: 391

              SELECT  'x'
              INTO    dummy_var
              FROM    wip_lines
              WHERE   organization_id =
                                forecast_interface(counter).organization_id
              AND     line_id = forecast_interface(counter).line_id;

Line: 436

             delete_row = FALSE )
        THEN
--            dbms_output.put_line('Inserting row '||
--            forecast_interface(counter).forecast_designator);

Line: 441

/* 1336039 - SVAIDYAN: Insert attribute_category also. */

            INSERT INTO mrp_forecast_dates
            (
                transaction_id,
                last_update_date,
                last_updated_by,
                creation_date,
                created_by,
                last_update_login,
                inventory_item_id,
                organization_id,
                forecast_designator,
                forecast_date,
                rate_end_date,
                bucket_type,
                original_forecast_quantity,
                current_forecast_quantity,
                comments,
                confidence_percentage,
                source_organization_id,
                source_forecast_designator,
                origination_type,
                request_id,
                source_code,
                source_line_id,
                attribute1,
                attribute2,
                attribute3,
                attribute4,
                attribute5,
                attribute6,
                attribute7,
                attribute8,
                attribute9,
                attribute10,
                attribute11,
                attribute12,
                attribute13,
                attribute14,
                attribute15,
                old_transaction_id,
                to_update,
                project_id,
                task_id,
                line_id,
                attribute_category)
            VALUES
            (
                NVL(forecast_interface(counter).transaction_id,
                        mrp_forecast_dates_s.nextval),
                SYSDATE,
                NVL(forecast_interface(counter).last_updated_by, -1),
                SYSDATE,
                NVL(forecast_interface(counter).created_by, -1),
                NVL(forecast_interface(counter).last_update_login, -1),
                forecast_interface(counter).inventory_item_id,
                forecast_interface(counter).organization_id,
                forecast_interface(counter).forecast_designator,
                var_for_date,
                var_for_end_date,
                forecast_interface(counter).bucket_type,
                ROUND(forecast_interface(counter).quantity, 6),
                ROUND(forecast_interface(counter).quantity, 6),
                forecast_interface(counter).comments,
                forecast_interface(counter).confidence_percentage,
                NULL,
                NULL,
                IMPORTED_ITEM_FORECAST,
                forecast_interface(counter).request_id,
                forecast_interface(counter).source_code,
                forecast_interface(counter).source_line_id,
                forecast_interface(counter).attribute1,
                forecast_interface(counter).attribute2,
                forecast_interface(counter).attribute3,
                forecast_interface(counter).attribute4,
                forecast_interface(counter).attribute5,
                forecast_interface(counter).attribute6,
                forecast_interface(counter).attribute7,
                forecast_interface(counter).attribute8,
                forecast_interface(counter).attribute9,
                forecast_interface(counter).attribute10,
                forecast_interface(counter).attribute11,
                forecast_interface(counter).attribute12,
                forecast_interface(counter).attribute13,
                forecast_interface(counter).attribute14,
                forecast_interface(counter).attribute15,
                NULL,
                NULL,
                forecast_interface(counter).project_id,
                forecast_interface(counter).task_id,
                forecast_interface(counter).line_id,
                forecast_interface(counter).attribute_category
        );

Line: 540

             SELECT 1 INTO record_exists
             FROM  mrp_forecast_items
             WHERE organization_id = forecast_interface(counter).organization_id
             AND   inventory_item_id = forecast_interface(counter).inventory_item_id
             AND   forecast_designator = forecast_interface(counter).forecast_designator;

Line: 548

                 INSERT INTO mrp_forecast_items
                 (
                 inventory_item_id,
                 organization_id,
                 forecast_designator,
                 last_update_date,
                 last_updated_by,
                 creation_date,
                 created_by,
                 last_update_login
                 )
                  values(
                   forecast_interface(counter).inventory_item_id,
                   forecast_interface(counter).organization_id,
                   forecast_interface(counter).forecast_designator,
                   SYSDATE,
                   NVL(forecast_interface(counter).created_by, -1),
                   SYSDATE,
                   NVL(forecast_interface(counter).last_updated_by, -1),
                   NVL(forecast_interface(counter).last_update_login, -1));

Line: 606

            	delete  from mrp_forecast_dates
            	where   forecast_designator =
                	tab_forecast_designator(counter).forecast_designator
            	and     organization_id =
                	tab_forecast_designator(counter).organization_id;

Line: 613

		delete  from mrp_forecast_dates
                where   forecast_designator =
                        tab_forecast_designator(counter).forecast_designator
                and     organization_id =
                        tab_forecast_designator(counter).organization_id
            	and 	inventory_item_id =
			tab_forecast_designator(counter).inventory_item_id;

Line: 635

            	delete  from mrp_forecast_items
            	where   forecast_designator =
                	tab_forecast_designator(counter).forecast_designator
            	and     organization_id =
                	tab_forecast_designator(counter).organization_id;

Line: 641

		delete  from mrp_forecast_items
                where   forecast_designator =
                        tab_forecast_designator(counter).forecast_designator
                and     organization_id =
                        tab_forecast_designator(counter).organization_id
	    	and     inventory_item_id =
			tab_forecast_designator(counter).inventory_item_id;

Line: 721

  SELECT calendar_date,
	p_quantity/p_count
  FROM mtl_parameters param,
	bom_calendar_dates cal
  WHERE param.organization_id = p_organization_id
    AND param.calendar_exception_set_id = cal.exception_set_id
    AND param.calendar_code = cal.calendar_code
    AND cal.seq_num IS NOT NULL
    AND cal.calendar_date BETWEEN p_start_date AND p_end_date
    AND cal.calendar_date <> p_end_date;