APPS.XTR_CASH_FCST SQL Statements

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

Line: 8

	SELECT 	cfh.name, cfh.aging_type,
		cfh.overdue_transactions, cfh.transaction_calendar_id,
		cfh.start_project_id, cfh.end_project_id, cfh.treasury_template
	FROM 	CE_FORECAST_HEADERS cfh
	WHERE 	cfh.forecast_header_id = p_forecast_header_id;

Line: 18

	SELECT	rowid, forecast_row_id, row_number, trx_type, nvl(lead_time,0),
		NVL(forecast_method,'F'), discount_option, DECODE(trx_type, 'PAY', 'PAY', SUBSTR(trx_type, 1,2)),
		include_float_flag, NVL(order_status,'A'),
		order_date_type, code_combination_id, budget_name,
		encumbrance_type_id, chart_of_accounts_id,
		set_of_books_id, NVL(org_id,-99),
		roll_forward_type, roll_forward_period,
		NVL(include_dispute_flag,'N'), sales_stage_id,
		channel_code, NVL(win_probability,0), sales_forecast_status,
		customer_profile_class_id, bank_account_id,
		receipt_method_id, vendor_type, payment_method, pay_group,
		payment_priority, authorization_status, type, budget_type,
		budget_version, include_hold_flag, include_net_cash_flag, budget_version_id,
		payroll_id, org_payment_method_id,
		external_source_type, criteria_category,
		criteria1, criteria2, criteria3, criteria4, criteria5,
		criteria6, criteria7, criteria8, criteria9, criteria10,
		criteria11, criteria12, criteria13, criteria14, criteria15
	FROM 	ce_forecast_rows
	WHERE 	row_number BETWEEN NVL(p_rownum_from, row_number) AND
				   NVL(p_rownum_to, row_number)
	AND 	forecast_header_id = p_forecast_header_id
        AND     trx_type 	   <> 'GLC';

Line: 43

        SELECT  rowid, forecast_row_id, row_number,
		set_of_books_id, code_combination_id, chart_of_accounts_id
	FROM    ce_forecast_rows
        WHERE   row_number BETWEEN NVL(p_rownum_from, row_number) AND
                                   NVL(p_rownum_to, row_number)
        AND 	forecast_header_id = p_forecast_header_id
	AND	trx_type 	   = 'GLC';

Line: 78

  CURSOR C IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;

Line: 79

  CURSOR H IS SELECT CE_FORECAST_HEADERS_S.nextval FROM sys.dual;

Line: 95

      select forecast_header_id
      into   G_rp_forecast_header_id
      from   ce_forecast_headers
      where  treasury_template = 'Y';

Line: 112

  SELECT legal_entity_id
  INTO   G_rp_legal_entity_id
  FROM   xtr_party_info
  WHERE  party_code = p_company_code
  AND    party_type = 'C';

Line: 123

	SELECT DISTINCT(organization_id) organization_id
	FROM HR_OPERATING_UNITS hou
	WHERE hou.set_of_books_id = (SELECT glle.ledger_id FROM gl_ledger_le_v glle
          WHERE  glle.legal_entity_id = G_rp_legal_entity_id
          AND glle.ledger_category_code = 'PRIMARY');   -- bug 4654775

Line: 286

  SELECT min(transaction_date), max(transaction_date)
  INTO	 XTR_CSH_FCST_POP.G_calendar_start, XTR_CSH_FCST_POP.G_calendar_end
  FROM	 gl_transaction_dates
  WHERE	 transaction_calendar_id = G_transaction_calendar_id;

Line: 331

	SELECT 	gsb.period_set_name, org.set_of_books_id, org.set_of_books_name
  	FROM   	ce_forecast_orgs_v org,
		gl_sets_of_books gsb
  	WHERE  	gsb.set_of_books_id 	= org.set_of_books_id
  	  AND	org.app_short_name 	= G_app_short_name
  	  AND  	org.set_of_books_id 	= NVL(G_set_of_books_id,org.set_of_books_id)
  	  AND 	(org.org_id 		= DECODE(G_org_id, -1, org.org_id,-99, org.org_id, G_org_id)
			 or org.org_id IS NULL);

Line: 346

    SELECT	period_set_name, set_of_books_id, name, currency_code
    INTO	calendar, sob_id, sob_name, G_sob_currency_code
    FROM	gl_sets_of_books	gsb
    WHERE	gsb.set_of_books_id 	= G_set_of_books_id;

Line: 359

      CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
					'CE_FC_INVALID_PERIOD', error_msg);

Line: 376

        CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
					'CE_FC_INVALID_PERIOD', error_msg);

Line: 444

        SELECT	row_number
	FROM    ce_forecast_rows
        WHERE   row_number BETWEEN NVL(p_rownum_from, row_number) AND
                                   NVL(p_rownum_to, row_number)
        AND     forecast_header_id = p_forecast_header_id
        AND     trx_type 	   <> 'GLC';

Line: 505

  CURSOR C IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;

Line: 515

      SELECT 	forecast_id
      INTO	fid
      FROM	ce_forecasts
      WHERE	name = G_rp_forecast_runname;

Line: 529

  DELETE FROM ce_forecasts
  WHERE  forecast_header_id = G_rp_forecast_header_id;

Line: 532

  DELETE FROM ce_forecast_errors
  WHERE  forecast_header_id = G_rp_forecast_header_id;

Line: 536

  INSERT INTO ce_forecasts(
	FORECAST_ID,
        FORECAST_HEADER_ID,
	NAME,
	START_DATE,
	FORECAST_CURRENCY,
	CURRENCY_TYPE,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	ERROR_STATUS)
  VALUES(G_forecast_id,
         G_rp_forecast_header_id,
	 G_rp_forecast_runname,
 	 G_rp_forecast_start_date,
 	 G_party_code,
	 'A',
	 nvl(fnd_global.user_id, -1),
	 sysdate,
	 nvl(fnd_global.user_id, -1),
	 sysdate,
	 'S');

Line: 614

      SELECT 	forecast_period_id
      INTO	G_overdue_period_id
      FROM	xtr_forecast_periods
      WHERE	forecast_header_id = G_rp_forecast_header_id	AND
		level_of_summary = 'O';

Line: 657

    DELETE FROM  xtr_external_cashflows
           WHERE company_code = G_party_code;  -- AW Bug 1378198

Line: 665

	   xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.create_forecast-->delete');

Line: 713

    SELECT  error_status
    INTO    l_status
    FROM    ce_forecasts
    WHERE   forecast_id = G_forecast_id;

Line: 781

  SELECT party_code
  FROM   xtr_party_info
  WHERE  party_code = nvl(p_company_code, party_code)
  AND    party_type = 'C';

Line: 788

  SELECT party_code
  FROM   xtr_parties_v
  WHERE  party_code = nvl(p_company_code, party_code)
  AND    party_type = 'C';

Line: 800

	  DELETE FROM ce_forecasts
	  WHERE  forecast_header_id = G_rp_forecast_header_id;

Line: 806

	  DELETE FROM ce_forecast_errors
	  WHERE  forecast_header_id = G_rp_forecast_header_id;

Line: 814

	   xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.forecast-->delete');