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: 178

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

Line: 181

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

Line: 183

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

Line: 191

        SELECT plan_id, name FROM bisbv_business_plans;

Line: 194

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

Line: 197

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

Line: 199

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

Line: 206

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

Line: 210

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

Line: 213

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

Line: 215

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

Line: 224

        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: 231

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

Line: 234

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

Line: 236

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

Line: 239

		htf.formSelectOpen( 'P_TO_FORECAST' );

Line: 242

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

Line: 244

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

Line: 310

    select plan_id, name from bisbv_business_plans;

Line: 313

  SELECT distinct period_type name from gl_periods;

Line: 316

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

Line: 322

  SELECT organization_name name, organization_id from org_organization_definitions
	ORDER BY organization_name;

Line: 398

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

Line: 401

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

Line: 403

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

Line: 406

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

Line: 412

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

Line: 415

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

Line: 417

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

Line: 420

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

Line: 425

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

Line: 427

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

Line: 429

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

Line: 430

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

Line: 432

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

Line: 434

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

Line: 440

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

Line: 443

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

Line: 445

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