APPS.MRP_PARAMETER_MRPFSETA SQL Statements

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

Line: 31

        select max(organization_id), count(organization_name)
          into l_org_id, l_count
          from org_organization_definitions
         where organization_name = P_ORG_NAME;

Line: 39

            select 1
              into l_exist
              from org_organization_definitions
             where organization_name = P_ORG_NAME
               and organization_id = P_ORG_ID;

Line: 71

        select distinct period_type
          into l_period_type
	  from gl_periods
	  where period_set_name in (select period_set_name
            from gl_sets_of_books gl,
		org_organization_definitions org
	    where org.set_of_books_id = gl.set_of_books_id
		and org.organization_id = p_org_id)
	 and period_type = P_PERIOD;

Line: 101

        select forecast_designator
 	  into l_from_forecast
	  from mrp_forecast_designators
         where organization_id = p_org_id
         and forecast_set is null
	 and forecast_designator = P_FROM_FORECAST;

Line: 108

        select forecast_designator
 	  into l_to_forecast
	  from mrp_forecast_designators
         where organization_id = p_org_id
         and forecast_set is null
         and forecast_designator >= P_FROM_FORECAST
	 and forecast_designator = P_TO_FORECAST;

Line: 172

        SELECT organization_id org_id, organization_name name
	FROM org_organization_definitions
        ORDER BY organization_name;

Line: 179

    param(i).Value := htf.formSelectOpen( 'P_ORG' );

Line: 182

        param(i).Value := param(i).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.org_id );

Line: 184

    param(i).Value := param(i).Value || htf.formSelectClose;

Line: 194

        SELECT plan_id, name FROM bisbv_business_plans;

Line: 199

    param(i).Value := htf.formSelectOpen( 'P_TARGET' );

Line: 202

                 htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );

Line: 204

    param(i).Value := param(i).Value || htf.formSelectClose;

Line: 212

    CURSOR c_period IS SELECT distinct period_type name, period_type id
	FROM gl_periods;

Line: 217

    param(i).Value := htf.formSelectOpen( 'P_PERIOD' );

Line: 220

                 htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );

Line: 222

    param(i).Value := param(i).Value || htf.formSelectClose;

Line: 232

        SELECT forecast_designator name, forecast_designator id
	    FROM mrp_forecast_designators
	    WHERE forecast_set IS NULL
              AND organization_id = 207
 	    ORDER BY forecast_designator;

Line: 240

    param(i).Value := htf.formSelectOpen( 'P_FROM_FORECAST' );

Line: 243

                 htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );

Line: 245

    param(i).Value := param(i).Value || htf.formSelectClose;

Line: 248

		htf.formSelectOpen( 'P_TO_FORECAST' );

Line: 251

		htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );

Line: 253

    param(i).Value := param(i).Value || htf.formSelectClose;

Line: 321

    select plan_id, name from bisbv_business_plans;

Line: 324

  SELECT distinct period_type name from gl_periods;

Line: 327

  SELECT distinct forecast_designator name from mrp_forecast_designators
   	where forecast_set IS null
	AND organization_id = 207
            ORDER BY forecast_designator;

Line: 333

  SELECT organization_name name, organization_id from org_organization_definitions
	ORDER BY organization_name;

Line: 409

  params(1).Value := htf.formSelectOpen( 'P_ORGANIZATION_ID' );

Line: 412

      params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );

Line: 414

      params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );

Line: 417

  params(1).Value := params(1).Value || htf.formSelectClose;

Line: 423

  params(2).Value := htf.formSelectOpen( 'P_BUSINESS_PLAN' );

Line: 426

      params(2).Value := params(2).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.plan_id );

Line: 428

      params(2).Value := params(2).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );

Line: 431

  params(2).Value := params(2).Value || htf.formSelectClose;

Line: 436

  params(3).Value := htf.formSelectOpen('P_PLAN1');

Line: 438

	params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );

Line: 440

  params(3).Value := params(3).Value || htf.formSelectClose;

Line: 441

  params(3).Value := params(3).Value || ' - ' || htf.formSelectOpen( 'P_PLAN2' );

Line: 443

	params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );

Line: 445

  params(3).Value := params(3).Value || htf.formSelectClose;

Line: 452

  params(4).Value := htf.formSelectOpen( 'P_PERIOD_TYPE' );

Line: 455

		htf.formSelectOption( c1.name, NULL, 'value=' || c1.name);

Line: 457

  params(4).Value := params(4).Value || htf.formSelectClose;