APPS.CE_FORECAST_UTILS SQL Statements

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

Line: 58

  cursor cDate is	SELECT  start_date,
				end_date
		   	FROM	ce_fc_aging_buckets_v
			WHERE	developer_column_num > 0
		   	ORDER BY developer_column_num;

Line: 63

  cursor cAcct is	SELECT 	forecast_column_id,
				period_from,
				period_to
			FROM 	ce_fc_aging_buckets_v
			WHERE	developer_column_num > 0
			ORDER BY developer_column_num;

Line: 69

  cursor cCol(phid NUMBER) is	SELECT	forecast_column_id
			FROM	ce_forecast_columns
			WHERE	forecast_header_id = phid
			AND	developer_column_num > 0
			ORDER BY developer_column_num;

Line: 77

    select forecast_header_id,
	period_set_name,
	start_period,
	start_date
    into l_forecast_header_id,
	l_period_set_name,
	l_start_period,
	l_start_date
    from ce_forecasts
    where forecast_id  = X_forecast_id;

Line: 94

  select aging_type
  into l_aging_type
  from ce_forecast_headers
  where forecast_header_id = l_forecast_header_id;

Line: 136

|	Delete_Forecast_Children					|
|									|
|  DESCRIPTION								|
|	This procedure deletes all children of a particular forecast	|
|  from CE_FORECAST_CELLS, CE_FORECAST_TRX_CELLS and 			|
|  CE_FORECAST_OPENING_BAL tables.					|
|									|
|  CALLED BY								|
|	OA Controller Classes						|
|  REQUIRES								|
|	Forecast_Id							|
|  HISTORY								|
|	04-FEB-2003	Created		Sunil Poonen			|
 --------------------------------------------------------------------- */

PROCEDURE Delete_Forecast_Children (X_forecast_id NUMBER) IS
  l_count 	NUMBER;

Line: 154

  select count(1)
  into l_count
  from ce_forecast_cells
  where forecast_id = X_forecast_id;

Line: 160

    delete from ce_forecast_cells where forecast_id = X_forecast_id;

Line: 163

  select count(1)
  into l_count
  from ce_forecast_trx_cells
  where forecast_id = X_forecast_id;

Line: 169

    delete from ce_forecast_trx_cells where forecast_id = X_forecast_id;

Line: 172

  select count(1)
  into l_count
  from ce_forecast_opening_bal
  where forecast_id = X_forecast_id;

Line: 178

    delete from ce_forecast_opening_bal where forecast_id = X_forecast_id;

Line: 181

  select count(1)
  into l_count
  from ce_forecast_errors
  where forecast_id = X_forecast_id;

Line: 187

    delete from ce_forecast_errors where forecast_id = X_forecast_id;

Line: 190

END Delete_Forecast_Children;

Line: 209

  CURSOR C_fc IS SELECT forecast_id
		FROM 	ce_forecasts
		WHERE	forecast_header_id = X_forecast_header_id;

Line: 212

  CURSOR C_frow(p_forecast_id NUMBER) IS SELECT forecast_row_id
		FROM 	ce_forecast_rows
		WHERE 	forecast_header_id = X_forecast_header_id
		AND	forecast_row_id not in
			(select forecast_row_id
			from ce_forecast_cells
			where forecast_header_id = X_forecast_header_id
			and forecast_id = p_forecast_id);

Line: 220

  CURSOR C_frow_trx(p_forecast_id NUMBER) IS SELECT forecast_row_id
		FROM 	ce_forecast_rows
		WHERE 	forecast_header_id = X_forecast_header_id
		AND	forecast_row_id not in
			(select forecast_row_id
			from ce_forecast_trx_cells
			where forecast_header_id = X_forecast_header_id
			and forecast_id = p_forecast_id);

Line: 234

  SELECT forecast_column_id
  INTO l_forecast_column_id
  FROM ce_forecast_columns
  WHERE forecast_header_id = X_forecast_header_id
  AND developer_column_num = 1;

Line: 241

    SELECT count(1)
    INTO l_count
    FROM ce_forecast_cells
    WHERE forecast_id = p_fc.forecast_id;

Line: 249

	CE_FORECAST_CELLS_PKG.insert_row(
		X_rowid			=>forecast_rowid,
		X_FORECAST_CELL_ID	=>forecast_cell_id,
		X_FORECAST_ID		=>p_fc.forecast_id,
		X_FORECAST_HEADER_ID	=>X_forecast_header_id,
		X_FORECAST_ROW_ID	=>p_frow.forecast_row_id,
		X_FORECAST_COLUMN_ID	=>l_forecast_column_id,
		X_AMOUNT		=>0,
		X_CREATED_BY		=>nvl(fnd_global.user_id,-1),
		X_CREATION_DATE		=>sysdate,
		X_LAST_UPDATED_BY	=>nvl(fnd_global.user_id,-1),
		X_LAST_UPDATE_DATE	=>sysdate,
		X_LAST_UPDATE_LOGIN	=>nvl(fnd_global.user_id,-1));

Line: 265

    SELECT count(1)
    INTO l_count
    FROM ce_forecast_trx_cells
    WHERE forecast_id = p_fc.forecast_id;

Line: 273

	CE_FORECAST_TRX_CELLS_PKG.insert_row(
		X_rowid			=>forecast_rowid,
		X_FORECAST_CELL_ID	=>forecast_cell_id,
		X_FORECAST_ID		=>p_fc.forecast_id,
		X_FORECAST_HEADER_ID	=>X_forecast_header_id,
		X_FORECAST_ROW_ID	=>p_frow_trx.forecast_row_id,
		X_FORECAST_COLUMN_ID	=>l_forecast_column_id,
		X_AMOUNT		=>0,
		X_TRX_AMOUNT		=>to_number(null),
		X_REFERENCE_ID 		=>null,
		X_CURRENCY_CODE   	=>null,
		X_ORG_ID		=>null,
		X_INCLUDE_FLAG		=>'Y',
		X_TRX_DATE		=>null,
		X_BANK_ACCOUNT_ID	=>null,
		X_CODE_COMBINATION_ID	=>null,
		X_CREATED_BY		=>nvl(fnd_global.user_id,-1),
		X_CREATION_DATE		=>sysdate,
		X_LAST_UPDATED_BY	=>nvl(fnd_global.user_id,-1),
		X_LAST_UPDATE_DATE	=>sysdate,
		X_LAST_UPDATE_LOGIN	=>nvl(fnd_global.user_id,-1));

Line: 302

|	Update_Column_Setup						|
|									|
|  DESCRIPTION								|
|	This procedure updates the column setup from Automatic		|
|	to Manual for the case where columns were manually added	|
|									|
|  CALLED BY								|
|	OA Controller Classes						|
|  REQUIRES								|
|	Forecast Header Id						|
|  HISTORY								|
|	14-MAR-2003	Created		Sunil Poonen			|
 --------------------------------------------------------------------- */

PROCEDURE Update_Column_Setup (X_forecast_header_id NUMBER) IS
  l_column_setup VARCHAR2(1);

Line: 319

  select column_setup
  into l_column_setup
  from ce_forecast_headers
  where forecast_header_id = X_forecast_header_id;

Line: 325

    update ce_forecast_headers
    set column_setup = 'M'
    where forecast_header_id = X_forecast_header_id;

Line: 330

END Update_Column_Setup;

Line: 350

  CURSOR C_frow IS SELECT forecast_row_id,
			forecast_header_id,
			row_number,
			trx_type,
			lead_time,
			forecast_method,
			discount_option,
			order_status,
			order_date_type,
			code_combination_id,
			set_of_books_id,
			org_id,
			chart_of_accounts_id,
			budget_name,
			budget_version_id,
			encumbrance_type_id,
			roll_forward_type,
			roll_forward_period,
			customer_profile_class_id,
			include_dispute_flag,
			sales_stage_id,
			channel_code,
			win_probability,
                        sales_forecast_status,
			receipt_method_id,
			bank_account_id,
			payment_method,
			pay_group,
			payment_priority,
			vendor_type,
			authorization_status,
			type,
			budget_type,
			budget_version,
			include_hold_flag,
                   	include_net_cash_flag,
			xtr_bank_account,
			exclude_indic_exp,
			company_code,
			created_by,
			creation_date,
			last_updated_by,
			last_update_date,
			last_update_login,
			org_payment_method_id,
			attribute_category,
			attribute1,
			attribute2,
			attribute3,
			attribute4,
			attribute5,
			attribute6,
			attribute7,
			attribute8,
			attribute9,
			attribute10,
			attribute11,
			attribute12,
			attribute13,
			attribute14,
			attribute15,
			description,
			payroll_id,
			external_source_type,
			criteria_category,
			criteria1,
			criteria2,
			criteria3,
			criteria4,
			criteria5,
			criteria6,
			criteria7,
			criteria8,
			criteria9,
			criteria10,
			criteria11,
			criteria12,
			criteria13,
			criteria14,
			criteria15,
                        use_average_payment_days,
                        period,
                        order_type_id,
                        use_payment_terms
		  FROM ce_forecast_rows
		  WHERE forecast_header_id = X_forecast_header_id;

Line: 437

  CURSOR C_fcol IS SELECT forecast_column_id,
			forecast_header_id,
			column_number,
			days_from,
			days_to,
			developer_column_num,
			created_by,
			creation_date,
			last_updated_by,
			last_update_date,
			last_update_login,
			attribute_category,
			attribute1,
			attribute2,
			attribute3,
			attribute4,
			attribute5,
			attribute6,
			attribute7,
			attribute8,
			attribute9,
			attribute10,
			attribute11,
			attribute12,
			attribute13,
			attribute14,
			attribute15
		  FROM ce_forecast_columns
		  WHERE forecast_header_id = X_forecast_header_id;

Line: 467

  CURSOR C_fperiod IS SELECT forecast_period_id,
			forecast_header_id,
			level_of_summary,
			period_number,
			length_of_period,
			length_type,
			created_by,
			creation_date,
			last_updated_by,
			last_update_date,
			last_update_login
		  FROM ce_forecast_periods
		  WHERE forecast_header_id = X_forecast_header_id;

Line: 487

  select ce_forecast_headers_s.nextval
  into l_forecast_header_id
  from dual;

Line: 491

  INSERT INTO ce_forecast_headers(
			forecast_header_id,
			name,
			description,
			aging_type,
			overdue_transactions,
			cutoff_period,
			transaction_calendar_id,
                        start_project_id,
                        end_project_id,
                        treasury_template,
			created_by,
			creation_date,
			last_updated_by,
			last_update_date,
			last_update_login,
			attribute_category,
			attribute1,
			attribute2,
			attribute3,
			attribute4,
			attribute5,
			attribute6,
			attribute7,
			attribute8,
			attribute9,
			attribute10,
			attribute11,
			attribute12,
			attribute13,
			attribute14,
			attribute15
		) SELECT l_forecast_header_id,
			X_new_name,
			description,
			aging_type,
			overdue_transactions,
			cutoff_period,
			transaction_calendar_id,
                	start_project_id,
                	end_project_id,
			treasury_template,
			nvl(fnd_global.user_id,-1),
			sysdate,
			nvl(fnd_global.user_id,-1),
			sysdate,
			nvl(fnd_global.user_id,-1),
			attribute_category,
			attribute1,
			attribute2,
			attribute3,
			attribute4,
			attribute5,
			attribute6,
			attribute7,
			attribute8,
			attribute9,
			attribute10,
			attribute11,
			attribute12,
			attribute13,
			attribute14,
			attribute15
		  FROM ce_forecast_headers
		  WHERE forecast_header_id = X_forecast_header_id;

Line: 558

    select nvl(drilldown_flag,'N')
    into l_drilldown_flag
    from ce_forecasts
    where forecast_id = X_forecast_id;

Line: 563

    UPDATE ce_forecasts
    SET forecast_header_id = l_forecast_header_id
    WHERE forecast_id = X_forecast_id;

Line: 568

      UPDATE ce_forecast_trx_cells
      SET forecast_header_id = l_forecast_header_id
      WHERE forecast_id = X_forecast_id;

Line: 572

      UPDATE ce_forecast_cells
      SET forecast_header_id = l_forecast_header_id
      WHERE forecast_id = X_forecast_id;

Line: 580

    select ce_forecast_rows_s.nextval
    into l_forecast_row_id
    from dual;

Line: 584

    INSERT INTO ce_forecast_rows(
			forecast_row_id,
			forecast_header_id,
			row_number,
			trx_type,
			lead_time,
			forecast_method,
			discount_option,
			order_status,
			order_date_type,
			code_combination_id,
			set_of_books_id,
			org_id,
			chart_of_accounts_id,
			budget_name,
			budget_version_id,
			encumbrance_type_id,
			roll_forward_type,
			roll_forward_period,
			customer_profile_class_id,
			include_dispute_flag,
			sales_stage_id,
			channel_code,
			win_probability,
                        sales_forecast_status,
			receipt_method_id,
			bank_account_id,
			payment_method,
			pay_group,
			payment_priority,
			vendor_type,
			authorization_status,
			type,
			budget_type,
			budget_version,
			include_hold_flag,
                	include_net_cash_flag,
			xtr_bank_account,
			exclude_indic_exp,
			company_code,
			created_by,
			creation_date,
			last_updated_by,
			last_update_date,
			last_update_login,
			org_payment_method_id,
			attribute_category,
			attribute1,
			attribute2,
			attribute3,
			attribute4,
			attribute5,
			attribute6,
			attribute7,
			attribute8,
			attribute9,
			attribute10,
			attribute11,
			attribute12,
			attribute13,
			attribute14,
			attribute15,
			description,
			payroll_id,
			external_source_type,
			criteria_category,
			criteria1,
			criteria2,
			criteria3,
			criteria4,
			criteria5,
			criteria6,
			criteria7,
			criteria8,
			criteria9,
			criteria10,
			criteria11,
			criteria12,
			criteria13,
			criteria14,
			criteria15,
                        use_average_payment_days,
                        period,
                        order_type_id,
                        use_payment_terms
		) VALUES (l_forecast_row_id,
			l_forecast_header_id,
			p_frow.row_number,
			p_frow.trx_type,
			p_frow.lead_time,
			p_frow.forecast_method,
			p_frow.discount_option,
			p_frow.order_status,
			p_frow.order_date_type,
			p_frow.code_combination_id,
			p_frow.set_of_books_id,
			p_frow.org_id,
			p_frow.chart_of_accounts_id,
			p_frow.budget_name,
			p_frow.budget_version_id,
			p_frow.encumbrance_type_id,
			p_frow.roll_forward_type,
			p_frow.roll_forward_period,
			p_frow.customer_profile_class_id,
			p_frow.include_dispute_flag,
			p_frow.sales_stage_id,
			p_frow.channel_code,
			p_frow.win_probability,
                        p_frow.sales_forecast_status,
			p_frow.receipt_method_id,
			p_frow.bank_account_id,
			p_frow.payment_method,
			p_frow.pay_group,
			p_frow.payment_priority,
			p_frow.vendor_type,
			p_frow.authorization_status,
			p_frow.type,
			p_frow.budget_type,
			p_frow.budget_version,
			p_frow.include_hold_flag,
                   	p_frow.include_net_cash_flag,
			p_frow.xtr_bank_account,
			p_frow.exclude_indic_exp,
			p_frow.company_code,
			nvl(fnd_global.user_id,-1),
			sysdate,
			nvl(fnd_global.user_id,-1),
			sysdate,
			nvl(fnd_global.user_id,-1),
			p_frow.org_payment_method_id,
			p_frow.attribute_category,
			p_frow.attribute1,
			p_frow.attribute2,
			p_frow.attribute3,
			p_frow.attribute4,
			p_frow.attribute5,
			p_frow.attribute6,
			p_frow.attribute7,
			p_frow.attribute8,
			p_frow.attribute9,
			p_frow.attribute10,
			p_frow.attribute11,
			p_frow.attribute12,
			p_frow.attribute13,
			p_frow.attribute14,
			p_frow.attribute15,
			p_frow.description,
			p_frow.payroll_id,
			p_frow.external_source_type,
			p_frow.criteria_category,
			p_frow.criteria1,
			p_frow.criteria2,
			p_frow.criteria3,
			p_frow.criteria4,
			p_frow.criteria5,
			p_frow.criteria6,
			p_frow.criteria7,
			p_frow.criteria8,
			p_frow.criteria9,
			p_frow.criteria10,
			p_frow.criteria11,
			p_frow.criteria12,
			p_frow.criteria13,
			p_frow.criteria14,
			p_frow.criteria15,
                        p_frow.use_average_payment_days,
                        p_frow.period,
                        p_frow.order_type_id,
                        p_frow.use_payment_terms);

Line: 756

        update ce_forecast_trx_cells
        set forecast_row_id = l_forecast_row_id
        where forecast_row_id = p_frow.forecast_row_id
        and forecast_id = X_forecast_id;

Line: 761

        update ce_forecast_cells
        set forecast_row_id = l_forecast_row_id
        where forecast_row_id = p_frow.forecast_row_id
        and forecast_id = X_forecast_id;

Line: 770

    select ce_forecast_columns_s.nextval
    into l_forecast_column_id
    from dual;

Line: 774

    INSERT INTO ce_forecast_columns(
			forecast_column_id,
			forecast_header_id,
			column_number,
			days_from,
			days_to,
			developer_column_num,
			created_by,
			creation_date,
			last_updated_by,
			last_update_date,
			last_update_login,
			attribute_category,
			attribute1,
			attribute2,
			attribute3,
			attribute4,
			attribute5,
			attribute6,
			attribute7,
			attribute8,
			attribute9,
			attribute10,
			attribute11,
			attribute12,
			attribute13,
			attribute14,
			attribute15
		) VALUES (l_forecast_column_id,
			l_forecast_header_id,
			p_fcol.column_number,
			p_fcol.days_from,
			p_fcol.days_to,
			p_fcol.developer_column_num,
			nvl(fnd_global.user_id,-1),
			sysdate,
			nvl(fnd_global.user_id,-1),
			sysdate,
			nvl(fnd_global.user_id,-1),
			p_fcol.attribute_category,
			p_fcol.attribute1,
			p_fcol.attribute2,
			p_fcol.attribute3,
			p_fcol.attribute4,
			p_fcol.attribute5,
			p_fcol.attribute6,
			p_fcol.attribute7,
			p_fcol.attribute8,
			p_fcol.attribute9,
			p_fcol.attribute10,
			p_fcol.attribute11,
			p_fcol.attribute12,
			p_fcol.attribute13,
			p_fcol.attribute14,
			p_fcol.attribute15);

Line: 832

        update ce_forecast_trx_cells
        set forecast_column_id = l_forecast_column_id
        where forecast_column_id = p_fcol.forecast_column_id
        and forecast_id = X_forecast_id;

Line: 837

        update ce_forecast_cells
        set forecast_column_id = l_forecast_column_id
        where forecast_column_id = p_fcol.forecast_column_id
        and forecast_id = X_forecast_id;

Line: 846

    select ce_forecast_periods_s.nextval
    into l_forecast_period_id
    from dual;

Line: 850

    INSERT INTO ce_forecast_periods(
			forecast_period_id,
			forecast_header_id,
			level_of_summary,
			period_number,
			length_of_period,
			length_type,
			created_by,
			creation_date,
			last_updated_by,
			last_update_date,
			last_update_login
		) VALUES (l_forecast_period_id,
			p_fperiod.forecast_header_id,
			p_fperiod.level_of_summary,
			p_fperiod.period_number,
			p_fperiod.length_of_period,
			p_fperiod.length_type,
			nvl(fnd_global.user_id,-1),
			sysdate,
			nvl(fnd_global.user_id,-1),
			sysdate,
			nvl(fnd_global.user_id,-1)
		);

Line: 896

    SELECT 	forecast_header_id,
		period_number,
	   	level_of_summary,
	   	length_of_period,
           	length_type,
		created_by,
		creation_date,
		last_updated_by,
		last_update_date,
		last_update_login
    FROM   	ce_forecast_periods
    WHERE	forecast_header_id = p_forecast_header_id
    ORDER BY	period_number;

Line: 932

  DELETE FROM ce_forecast_columns
  WHERE forecast_header_id = p_forecast_header_id
  AND developer_column_num > 0;

Line: 940

	CEP_STANDARD.DEBUG('EXCEPTION:populate_temp_buckets-->delete');

Line: 967

          INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
          VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);

Line: 985

          INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
          VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);

Line: 1003

          INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
          VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);

Line: 1073

  SELECT aging_type
  INTO l_aging_type
  FROM ce_forecast_headers
  WHERE forecast_header_id = p_forecast_header_id;

Line: 1080

    CE_FORECASTS_TABLE_PKG.Insert_Row(
			X_Rowid			=> l_forecast_rowid,
			X_forecast_id		=> l_forecast_id,
			X_forecast_header_id	=> p_forecast_header_id,
			X_name			=> p_forecast_name,
			X_description		=> null,
			X_start_date		=> to_date(p_forecast_start_date,'DD/MM/RRRR'),
			X_period_set_name	=> p_calendar_name,
			X_start_period		=> p_forecast_start_period,
			X_forecast_currency	=> p_forecast_currency,
			X_currency_type		=> p_src_curr_type,
			X_source_currency	=> p_src_currency,
			X_exchange_rate_type	=> p_exchange_type,
			X_exchange_date		=> to_date(p_exchange_date,'DD/MM/RRRR'),
			X_exchange_rate		=> p_exchange_rate,
			X_error_status		=> 'P',
			X_amount_threshold	=> p_amount_threshold,
			X_project_id		=> null,
			X_drilldown_flag	=> 'Y',
			X_bank_balance_type	=> p_bank_balance_type,
			X_float_type		=> p_float_type,
			X_view_by		=> p_view_by,
			X_include_sub_account	=> p_include_sub_account,
			X_factor		=> p_factor,
			X_request_id		=> null,
			X_created_by		=> nvl(fnd_global.user_id, -1),
			X_creation_date		=> sysdate,
			X_last_updated_by	=> nvl(fnd_global.user_id, -1),
			X_last_update_date	=> sysdate,
			X_last_update_login	=> nvl(fnd_global.user_id, -1),
			X_attribute_category	=> null,
			X_attribute1		=> null,
			X_attribute2		=> null,
			X_attribute3		=> null,
			X_attribute4		=> null,
			X_attribute5		=> null,
			X_attribute6		=> null,
			X_attribute7		=> null,
			X_attribute8		=> null,
			X_attribute9		=> null,
			X_attribute10		=> null,
			X_attribute11		=> null,
			X_attribute12		=> null,
			X_attribute13		=> null,
			X_attribute14		=> null,
			X_attribute15		=> null);

Line: 1211

  UPDATE ce_forecasts
  SET request_id = l_request_id
  WHERE forecast_id = l_forecast_id;

Line: 1239

  CURSOR C_fc IS SELECT forecast_id,
			request_id
		FROM ce_forecasts
		WHERE error_status in ('P','R','X')
		AND request_id is not null;

Line: 1255

      UPDATE ce_forecasts
      SET error_status = 'F'
      WHERE forecast_id = p_fc.forecast_id;

Line: 1260

      UPDATE ce_forecasts
      SET error_status = 'R'
      WHERE forecast_id = p_fc.forecast_id
      AND error_status = 'P';

Line: 1318

  select count(1)
  into   l_cnt
  from   xtr_dealer_codes
  where  user_id = fnd_global.user_id;

Line: 1354

  select count(1)
  into   l_cnt
  from   xtr_parties_v
  where  legal_entity_id = X_le_id;

Line: 1369

    select rowid, forecast_column_id, forecast_header_id, column_number
    from   ce_forecast_columns
    where  forecast_header_id = hid
    order by column_number
    for update nowait;

Line: 1388

    l_rowid.delete;

Line: 1389

    l_dev_num.delete;

Line: 1390

    l_cid.delete;

Line: 1391

    l_hid.delete;

Line: 1392

    l_col_num.delete;

Line: 1407

        update ce_forecast_columns
        set    developer_column_num = l_dev_num(i)
        where  forecast_column_id = l_cid(i);