APPS.GCS_TRANSLATION_PKG SQL Statements

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

Line: 48

  GCS_CCY_NO_RE_ACCT_UPDATED	EXCEPTION;

Line: 50

  GCS_CCY_NO_RATE_UPDATED	EXCEPTION;

Line: 263

    SELECT	cal_period_name
    FROM	fem_cal_periods_tl
    WHERE	cal_period_id = p_cal_period_id
    AND		language = my_lang;

Line: 270

    SELECT	entity_name
    FROM	fem_entities_tl
    WHERE	entity_id = c_entity_id
    AND		language = my_lang;

Line: 277

    SELECT	rel.hierarchy_id,
		rel.child_entity_id,
		rel.parent_entity_id,
		rel.curr_treatment_id
    FROM	gcs_cons_relationships rel
    WHERE	rel.cons_relationship_id = p_cons_relationship_id;

Line: 286

    SELECT	equity_mode_code,
		inc_stmt_mode_code,
		ending_rate_type,
		average_rate_type,
		financial_elem_id, product_id,
		natural_account_id, channel_id, line_item_id, project_id,
		customer_id, task_id, cta_user_dim1_id, cta_user_dim2_id,
		cta_user_dim3_id, cta_user_dim4_id, cta_user_dim5_id,
		cta_user_dim6_id, cta_user_dim7_id, cta_user_dim8_id,
		cta_user_dim9_id, cta_user_dim10_id
    FROM	gcs_curr_treatments_b ctb
    WHERE	curr_treatment_id = c_curr_treatment_id;

Line: 301

    SELECT	eca.currency_code
    FROM	gcs_entity_cons_attrs eca
    WHERE	eca.entity_id = c_entity_id
    AND		eca.hierarchy_id = c_hierarchy_id;

Line: 308

    SELECT	balance_by_org_flag,
		column_name,
		fem_ledger_id
    FROM	gcs_hierarchies_b
    WHERE	hierarchy_id = c_hierarchy_id;

Line: 316

    SELECT	specific_intercompany_id
    FROM	gcs_categories_b
    WHERE	category_code = 'INTRACOMPANY';

Line: 325

    SELECT	decode(earliest_ever_period_id, p_cal_period_id, 'Y', 'N')
    FROM	gcs_translation_track_h
    WHERE	hierarchy_id = c_hierarchy_id
    AND		entity_id = c_entity_id
    AND		currency_code = c_currency_code
    AND		dataset_code = p_hier_dataset_code;

Line: 335

    SELECT	fcpa_period_end_date.date_assign_value
    FROM	fem_cal_periods_attr fcpa_period_end_date
    WHERE	fcpa_period_end_date.cal_period_id = p_cal_period_id
    AND		fcpa_period_end_date.attribute_id = g_cp_end_date_attr_id
    AND		fcpa_period_end_date.version_id = g_cp_end_date_v_id;

Line: 343

    SELECT	financial_elem_id, product_id, natural_account_id, channel_id,
		line_item_id, project_id, customer_id, task_id, user_dim1_id,
		user_dim2_id, user_dim3_id, user_dim4_id, user_dim5_id,
		user_dim6_id, user_dim7_id, user_dim8_id, user_dim9_id,
		user_dim10_id
    FROM	GCS_DIMENSION_TEMPLATES
    WHERE	hierarchy_id = c_hierarchy_id
    AND		template_code = 'RE';

Line: 354

    SELECT	nvl(minimum_accountable_unit, power(10, -precision))
    FROM	fnd_currencies
    WHERE	currency_code = c_ccy;

Line: 360

    SELECT	source_system_code
    FROM	fem_source_systems_b
    WHERE	source_system_display_code = 'GCS';

Line: 366

    SELECT	user_conversion_type
    FROM	gl_daily_conversion_types
    WHERE	conversion_type = c_rate_type;

Line: 372

    SELECT	fea.dim_attribute_varchar_member
    FROM	fem_entities_attr fea,
		fem_dim_attributes_b fdab,
		fem_dim_attr_versions_b fdavb
    WHERE	fea.entity_id = c_entity_id
    AND		fea.attribute_id = fdab.attribute_id
    AND		fea.version_id = fdavb.version_id
    AND		fdab.attribute_varchar_label = 'ENTITY_TYPE_CODE'
    AND         fdavb.attribute_id = fdab.attribute_id
    AND         fdavb.default_version_flag = 'Y';

Line: 390

    SELECT	1
    FROM	fem_balances fb,
		gcs_categories_b cb
    WHERE	fb.dataset_code = p_hier_dataset_code
    AND		fb.cal_period_id = c_cal_period_id
    AND		fb.source_system_code = c_source_system_code
    AND		fb.currency_code = c_currency_code
    AND		fb.ledger_id = c_ledger_id
    AND		fb.entity_id = c_entity_id
    AND		fb.created_by_object_id <> cb.associated_object_id
    AND		cb.category_code = 'DATAPREPARATION';

Line: 405

    SELECT  line_item_id
    FROM    gcs_dimension_templates
    WHERE   hierarchy_id = p_hier_id
    AND     template_code = 'RE';

Line: 429

'SELECT rel.hierarchy_id, rel.child_entity_id, ' ||
'rel.parent_entity_id, rel.curr_treatment_id' || g_nl ||
'FROM   gcs_cons_relationships rel' || g_nl ||
'WHERE  rel.cons_relationship_id = ' || p_cons_relationship_id);

Line: 453

'SELECT cal_period_name' || g_nl ||
'FROM   fem_cal_periods_tl' || g_nl ||
'WHERE  cal_period_id = ' || p_cal_period_id || g_nl ||
'AND    language = ''' || my_lang || '''');

Line: 469

'SELECT	balance_by_org_flag, column_name, fem_ledger_id' || g_nl||
'FROM	gcs_hierarchies_b' || g_nl ||
'WHERE	hierarchy_id = ' || x_hierarchy_id);

Line: 484

'SELECT	specific_intercompany_id' || g_nl||
'FROM	gcs_categories_b' || g_nl ||
'WHERE	category_code = ''INTRACOMPANY''');

Line: 499

'SELECT equity_mode_code, inc_stmt_mode_code, ending_rate_type, ' ||
'average_rate_type, financial_elem_id, ' ||
'product_id, natural_account_id, channel_id, line_item_id, project_id, ' ||
'customer_id, task_id, cta_user_dim1_id, cta_user_dim2_id, ' ||
'cta_user_dim3_id, cta_user_dim4_id, cta_user_dim5_id, cta_user_dim6_id, ' ||
'cta_user_dim7_id, cta_user_dim8_id, cta_user_dim9_id, ' ||
'cta_user_dim10_id' || g_nl ||
'FROM   gcs_curr_treatments_b ctb' || g_nl ||
'WHERE  curr_treatment_id = ' || x_curr_treatment_id);

Line: 528

'SELECT user_conversion_type' || g_nl ||
'FROM   gl_daily_conversion_types' || g_nl ||
'WHERE  conversion_type = ''' || per_rate_type || '''');

Line: 541

'SELECT user_conversion_type' || g_nl ||
'FROM   gl_daily_conversion_types' || g_nl ||
'WHERE  conversion_type = ''' || per_avg_rate_type || '''');

Line: 556

'SELECT eca.currency_code' || g_nl ||
'FROM   gcs_entity_cons_attrs eca' || g_nl ||
'WHERE  eca.entity_id = ' || x_child_entity_id || g_nl ||
'AND    eca.hierarchy_id = ' || x_hierarchy_id);

Line: 571

'SELECT eca.currency_code' || g_nl ||
'FROM   gcs_entity_cons_attrs eca' || g_nl ||
'WHERE  eca.entity_id = ' || x_parent_entity_id || g_nl ||
'AND    eca.hierarchy_id = ' || x_hierarchy_id);

Line: 586

'SELECT fcpa_period_end_date.date_assign_value' || g_nl ||
'FROM   fem_cal_periods_attr fcpa_period_end_date' || g_nl ||
'WHERE  fcpa_period_end_date.cal_period_id = ' || p_cal_period_id || g_nl ||
'AND    fcpa_period_end_date.attribute_id = ' || g_cp_end_date_attr_id || g_nl ||
'AND    fcpa_period_end_date.version_id = ' || g_cp_end_date_v_id);

Line: 628

'SELECT financial_elem_id, product_id, ' ||
'natural_account_id, channel_id, line_item_id, project_id, customer_id, ' ||
'task_id, user_dim1_id, user_dim2_id, user_dim3_id, user_dim4_id, ' ||
'user_dim5_id, user_dim6_id, user_dim7_id, user_dim8_id, user_dim9_id, ' ||
'user_dim10_id' || g_nl ||
'FROM   GCS_DIMENSION_TEMPLATES' || g_nl ||
'WHERE  hierarchy_id = ' || x_hierarchy_id || g_nl ||
'AND    template_code = ''RE''');

Line: 647

'SELECT nvl(minimum_accountable_unit, power(10, -precision))' || g_nl ||
'FROM   fnd_currencies' || g_nl ||
'WHERE  currency_code = ''' || x_target_currency || '''');

Line: 661

'SELECT decode(earliest_ever_period_id, ' || p_cal_period_id ||
', ''Y'', ''N'')' || g_nl ||
'FROM   gcs_translation_track_h' || g_nl ||
'WHERE  cons_relationship_id = ' || p_cons_relationship_id || g_nl ||
'AND    dataset_code = ' || p_hier_dataset_code);

Line: 679

'SELECT source_system_code' || g_nl ||
'FROM   fem_source_systems_b' || g_nl ||
'WHERE  source_system_display_code = ''GCS''');

Line: 1283

    SELECT	DISTINCT company_cost_center_org_id org_id
    FROM	gcs_translation_gt;

Line: 1291

    SELECT cb.associated_object_id
    FROM   gcs_categories_b cb
    WHERE  cb.category_code = 'TRANSLATION';

Line: 1329

'SELECT ''Y''' || g_nl ||
'FROM   GCS_TRANSLATION_GT' || g_nl;

Line: 1333

'SELECT nvl(sum(nvl(fb.ytd_debit_balance_e, 0)),0), ' ||
'nvl(sum(nvl(fb.ytd_credit_balance_e, 0)),0)' || g_nl ||
'FROM   FEM_BALANCES fb,' || g_nl ||
'       FEM_LN_ITEMS_ATTR li,' || g_nl ||
'       FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
'WHERE  fb.dataset_code = ' || p_hier_dataset_code || g_nl ||
'AND    fb.created_by_object_id = ' || fb_object_id || g_nl ||
'AND    fb.cal_period_id = ' || p_prev_period_id || g_nl ||
'AND    fb.source_system_code = ' || p_source_system_code || g_nl ||
'AND    fb.currency_code = ''' || p_to_ccy || '''' || g_nl ||
'AND    fb.ledger_id = ' || p_ledger_id || g_nl ||
'AND    fb.entity_id = ' || p_entity_id || g_nl ||
'AND    li.line_item_id = fb.line_item_id' || g_nl ||
'AND    li.attribute_id = ' || g_li_acct_type_attr_id || g_nl ||
'AND    li.version_id = ' || g_li_acct_type_v_id || g_nl ||
'AND    fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
'AND    fxata.attribute_id = ' || g_xat_basic_acct_type_attr_id || g_nl ||
'AND    fxata.version_id = ' || g_xat_basic_acct_type_v_id || g_nl ||
'AND    fxata.dim_attribute_varchar_member IN (''REVENUE'',''EXPENSE'')' || g_nl;

Line: 1361

'INSERT INTO gcs_translation_gt(translate_rule_code, account_type_code, ' ||
'company_cost_center_org_id, intercompany_id, ' ||
'financial_elem_id, product_id, natural_account_id, channel_id, ' ||
'line_item_id, project_id, customer_id, task_id, user_dim1_id, ' ||
'user_dim2_id, user_dim3_id, user_dim4_id, user_dim5_id, user_dim6_id, ' ||
'user_dim7_id, user_dim8_id, user_dim9_id, user_dim10_id, t_amount_dr, ' ||
't_amount_cr, begin_ytd_dr, begin_ytd_cr, xlate_ptd_dr, xlate_ptd_cr, ' ||
'xlate_ytd_dr, xlate_ytd_cr)' || g_nl ||
'SELECT ''' || p_eq_xlate_mode || ''', ''EQUITY'', ';

Line: 1372

'UPDATE GCS_TRANSLATION_GT' || g_nl ||
'SET    begin_ytd_dr = nvl(begin_ytd_dr, 0) + :re_delta_dr,' || g_nl ||
'       begin_ytd_cr = nvl(begin_ytd_cr, 0) + :re_delta_cr' || g_nl;

Line: 1408

	'SELECT DISTINCT ' || p_sec_dim_col ||
        ', COMPANY_COST_CENTER_ORG_ID FROM gcs_translation_gt';

Line: 1464

            raise GCS_CCY_NO_RE_ACCT_UPDATED;

Line: 1472

      dims_cv_text := 'SELECT DISTINCT ' || p_sec_dim_col ||
                      ' FROM gcs_translation_gt';

Line: 1508

            raise GCS_CCY_NO_RE_ACCT_UPDATED;

Line: 1517

'SELECT DISTINCT company_cost_center_org_id org_id FROM gcs_translation_gt');

Line: 1563

            raise GCS_CCY_NO_RE_ACCT_UPDATED;

Line: 1592

          raise GCS_CCY_NO_RE_ACCT_UPDATED;

Line: 1598

'UPDATE GCS_TRANSLATION_GT tg' || g_nl ||
'SET    begin_ytd_dr = 0,' || g_nl ||
'       begin_ytd_cr = 0' || g_nl ||
'WHERE  EXISTS' || g_nl ||
'(SELECT 1' || g_nl ||
' FROM   FEM_LN_ITEMS_ATTR li,' || g_nl ||
'        FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
' WHERE  li.line_item_id = tg.line_item_id' || g_nl ||
' AND    li.attribute_id = ' || g_li_acct_type_attr_id || g_nl ||
' AND    li.version_id = ' || g_li_acct_type_v_id || g_nl ||
' AND    fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
' AND    fxata.attribute_id = ' || g_xat_basic_acct_type_attr_id || g_nl ||
' AND    fxata.version_id = ' || g_xat_basic_acct_type_v_id || g_nl ||
' AND    fxata.dim_attribute_varchar_member IN (''REVENUE'',''EXPENSE''))');

Line: 1615

    UPDATE	GCS_TRANSLATION_GT tg
    SET		begin_ytd_dr = 0,
		begin_ytd_cr = 0
    WHERE	EXISTS
    (SELECT	1
     FROM	FEM_LN_ITEMS_ATTR li,
		FEM_EXT_ACCT_TYPES_ATTR fxata
     WHERE	li.line_item_id = tg.line_item_id
     AND	li.attribute_id = g_li_acct_type_attr_id
     AND	li.version_id = g_li_acct_type_v_id
     AND	fxata.ext_account_type_code = li.dim_attribute_varchar_member
     AND	fxata.attribute_id = g_xat_basic_acct_type_attr_id
     AND	fxata.version_id = g_xat_basic_acct_type_v_id
     AND	fxata.dim_attribute_varchar_member IN ('REVENUE','EXPENSE'));

Line: 1641

    WHEN GCS_CCY_NO_RE_ACCT_UPDATED THEN
      FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_RE_UPDATED_ERR');

Line: 1705

    SELECT	DISTINCT company_cost_center_org_id org_id
    FROM	gcs_entry_lines
    WHERE	entry_id = p_entry_id;

Line: 1736

'SELECT decode(func.ytd_debit - func.ytd_credit,' || g_nl ||
'              0, decode(func.ytd_debit,' || g_nl ||
'                        0, 0,' || g_nl ||
'                        xlat.ytd_debit/func.ytd_debit),' || g_nl ||
'              (xlat.ytd_debit - xlat.ytd_credit)/(func.ytd_debit - func.ytd_credit))' || g_nl ||
'FROM' || g_nl ||
'  (SELECT nvl(sum(nvl(fb.ytd_debit_balance_e, 0)),0) ytd_debit, ' ||
'nvl(sum(nvl(fb.ytd_credit_balance_e, 0)),0) ytd_credit' || g_nl ||
'   FROM   FEM_BALANCES fb,' || g_nl ||
'          FEM_LN_ITEMS_ATTR li,' || g_nl ||
'          FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
'   WHERE  fb.dataset_code = ' || p_hier_dataset_code || g_nl ||
'   AND    fb.cal_period_id = ' || p_cal_period_id || g_nl ||
'   AND    fb.source_system_code = ' || p_source_system_code || g_nl ||
'   AND    fb.currency_code = ''' || p_from_ccy || '''' || g_nl ||
'   AND    fb.ledger_id = ' || p_ledger_id || g_nl ||
'   AND    fb.entity_id = ' || p_entity_id || g_nl ||
'   AND    li.line_item_id = fb.line_item_id' || g_nl ||
'   AND    li.attribute_id = ' || g_li_acct_type_attr_id || g_nl ||
'   AND    li.version_id = ' || g_li_acct_type_v_id || g_nl ||
'   AND    fxata.ext_account_type_code = li.dim_attribute_varchar_member' || g_nl ||
'   AND    fxata.attribute_id = ' || g_xat_basic_acct_type_attr_id || g_nl ||
'   AND    fxata.version_id = ' || g_xat_basic_acct_type_v_id || g_nl ||
'   AND    ((fxata.dim_attribute_varchar_member IN (''REVENUE'',''EXPENSE'')' || g_nl;

Line: 1773

'SELECT rate_type_code' || g_nl ||
'FROM   GCS_HISTORICAL_RATES' || g_nl ||
'WHERE  entity_id = ' || p_entity_id || g_nl ||
'AND    hierarchy_id = ' || p_hierarchy_id || g_nl ||
'AND    cal_period_id = ' || p_next_period_id || g_nl ||
'AND    from_currency = ''' ||p_from_ccy || '''' || g_nl ||
'AND    to_currency = ''' || p_to_ccy || '''' || g_nl;

Line: 1782

'INSERT INTO gcs_historical_rates(standard_re_rate_flag, entity_id, hierarchy_id, ' ||
'cal_period_id, from_currency, to_currency, company_cost_center_org_id, ' ||
'intercompany_id, financial_elem_id, ' ||
'product_id, natural_account_id, channel_id, line_item_id, project_id, ' ||
'customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id, ' ||
'user_dim4_id, user_dim5_id, user_dim6_id, user_dim7_id, user_dim8_id, ' ||
'user_dim9_id, user_dim10_id, translated_rate, translated_amount, ' ||
'rate_type_code, update_flag, account_type_code, stop_rollforward_flag, ' ||
'last_update_date, last_updated_by, last_update_login, creation_date, ' ||
'created_by)' || g_nl ||
'VALUES(''Y'', ' || p_entity_id || ', ' || p_hierarchy_id ||
', ' || p_next_period_id || ', ''' || p_from_ccy || ''', ''' || p_to_ccy ||
''', ';

Line: 1797

'UPDATE GCS_HISTORICAL_RATES' || g_nl ||
'SET translated_rate = :re_rate,' || g_nl ||
'    translated_amount = null,' || g_nl ||
'    rate_type_code = ''C'',' || g_nl ||
'    last_update_date = sysdate,' || g_nl ||
'    last_updated_by = ' || g_fnd_user_id || ',' || g_nl ||
'    last_update_login = ' || g_fnd_login_id || g_nl ||
'WHERE  entity_id = ' || p_entity_id || g_nl ||
'AND    hierarchy_id = ' || p_hierarchy_id || g_nl ||
'AND    from_currency = ''' || p_from_ccy || '''' || g_nl ||
'AND    to_currency = ''' || p_to_ccy || '''' || g_nl ||
'AND    cal_period_id = ' || p_next_period_id || g_nl;

Line: 1821

'  (SELECT nvl(sum(nvl(el.ytd_debit_balance_e, 0)), 0) ytd_debit, ' ||
'nvl(sum(nvl(el.ytd_credit_balance_e, 0)), 0) ytd_credit' || g_nl ||
'   FROM   GCS_ENTRY_LINES el,' || g_nl ||
'          FEM_LN_ITEMS_ATTR lia,' || g_nl ||
'          FEM_EXT_ACCT_TYPES_ATTR xata' || g_nl ||
'   WHERE  el.entry_id = ' || p_entry_id || g_nl ||
'   AND    lia.line_item_id = el.line_item_id' || g_nl ||
'   AND    lia.attribute_id = ' || g_li_acct_type_attr_id || g_nl ||
'   AND    lia.version_id = ' || g_li_acct_type_v_id || g_nl ||
'   AND    xata.ext_account_type_code = lia.dim_attribute_varchar_member' || g_nl ||
'   AND    xata.attribute_id = ' || g_xat_basic_acct_type_attr_id || g_nl ||
'   AND    xata.version_id = ' || g_xat_basic_acct_type_v_id || g_nl ||
'   AND    ((xata.dim_attribute_varchar_member IN (''REVENUE'', ''EXPENSE'')' || g_nl;

Line: 1864

	'SELECT DISTINCT ' || p_sec_dim_col ||
        ', COMPANY_COST_CENTER_ORG_ID FROM gcs_entry_lines where entry_id = ' || p_entry_id;

Line: 1918

              raise GCS_CCY_NO_RATE_UPDATED;

Line: 1927

      dims_cv_text := 'SELECT DISTINCT ' || p_sec_dim_col ||
                      ' FROM gcs_entry_lines WHERE entry_id = ' || p_entry_id;

Line: 1959

              raise GCS_CCY_NO_RATE_UPDATED;

Line: 1969

'SELECT DISTINCT company_cost_center_org_id org_id FROM gcs_entry_lines WHERE entry_id = ' || p_entry_id);

Line: 2015

              raise GCS_CCY_NO_RATE_UPDATED;

Line: 2043

            raise GCS_CCY_NO_RATE_UPDATED;

Line: 2060

    WHEN GCS_CCY_NO_RATE_UPDATED THEN
      FND_MESSAGE.set_name('GCS', 'GCS_CCY_NO_RE_RT_UPDATED_ERR');

Line: 2092

'UPDATE gcs_translation_gt' || g_nl ||
'SET    xlate_ptd_dr = t_amount_dr,' || g_nl ||
'       xlate_ptd_cr = t_amount_cr,' || g_nl ||
'       xlate_ytd_dr = t_amount_dr + begin_ytd_dr,' || g_nl ||
'       xlate_ytd_cr = t_amount_cr + begin_ytd_cr' || g_nl ||
'WHERE  translate_rule_code = ''PTD''');

Line: 2100

    UPDATE	gcs_translation_gt
    SET		xlate_ptd_dr = t_amount_dr,
		xlate_ptd_cr = t_amount_cr,
		xlate_ytd_dr = t_amount_dr + begin_ytd_dr,
		xlate_ytd_cr = t_amount_cr + begin_ytd_cr
    WHERE	translate_rule_code = 'PTD';

Line: 2108

'UPDATE gcs_translation_gt' || g_nl ||
'SET    xlate_ptd_dr = t_amount_dr - begin_ytd_dr,' || g_nl ||
'       xlate_ptd_cr = t_amount_cr - begin_ytd_cr,' || g_nl ||
'       xlate_ytd_dr = t_amount_dr,' || g_nl ||
'       xlate_ytd_cr = t_amount_cr' || g_nl ||
'WHERE	translate_rule_code = ''YTD''');

Line: 2116

    UPDATE	gcs_translation_gt
    SET		xlate_ptd_dr = t_amount_dr - begin_ytd_dr,
		xlate_ptd_cr = t_amount_cr - begin_ytd_cr,
		xlate_ytd_dr = t_amount_dr,
		xlate_ytd_cr = t_amount_cr
    WHERE	translate_rule_code = 'YTD';

Line: 2139

  PROCEDURE Update_Status_Tracking(
	p_hierarchy_id		IN NUMBER,
	p_entity_id		IN NUMBER,
	p_currency_code		IN VARCHAR2,
	p_cal_period_id		IN NUMBER,
	p_hier_dataset_code	IN NUMBER,
	p_cal_period_number	IN NUMBER,
	p_cal_period_year	IN NUMBER,
	p_next_cal_period_id	IN NUMBER) IS
    module	VARCHAR2(30);

Line: 2152

    SELECT	status_code
    FROM	gcs_translation_statuses
    WHERE	hierarchy_id = p_hierarchy_id
    AND		entity_id = p_entity_id
    AND		currency_code = p_currency_code
    AND		cal_period_id = c_cal_period_id
    AND		dataset_code = p_hier_dataset_code;

Line: 2164

    SELECT	earliest_ever_period_id,
		earliest_never_period_id
    FROM	gcs_translation_track_h
    WHERE	hierarchy_id = p_hierarchy_id
    AND		entity_id = p_entity_id
    AND		currency_code = p_currency_code
    AND		dataset_code = p_hier_dataset_code;

Line: 2181

    module := 'UPDATE_STATUS_TRACKING';

Line: 2190

      INSERT INTO gcs_translation_statuses(
	hierarchy_id, entity_id, currency_code, cal_period_id, dataset_code,
	status_code, request_id, creation_date, created_by, last_update_date,
	last_updated_by, last_update_login)
      VALUES(
	p_hierarchy_id, p_entity_id, p_currency_code, p_cal_period_id,
	p_hier_dataset_code, 'C', '', sysdate, g_fnd_user_id, sysdate,
	g_fnd_user_id, g_fnd_login_id);

Line: 2201

        UPDATE	gcs_translation_statuses
        SET	status_code = 'C'
        WHERE	hierarchy_id = p_hierarchy_id
        AND	entity_id = p_entity_id
        AND	currency_code = p_currency_code
        AND	cal_period_id = p_cal_period_id
        AND	dataset_code = p_hier_dataset_code;

Line: 2217

      INSERT INTO gcs_translation_track_h(
	hierarchy_id, entity_id, currency_code, dataset_code,
	earliest_ever_period_id, earliest_never_period_id, created_by,
	creation_date, last_updated_by, last_update_date, last_update_login)
      VALUES(
	p_hierarchy_id, p_entity_id, p_currency_code, p_hier_dataset_code,
	p_cal_period_id, p_cal_period_id, g_fnd_user_id, sysdate,
	g_fnd_user_id, sysdate, g_fnd_login_id);

Line: 2238

        UPDATE	gcs_translation_track_h
        SET	earliest_ever_period_id = p_cal_period_id
        WHERE	hierarchy_id = p_hierarchy_id
        AND	entity_id = p_entity_id
        AND	currency_code = p_currency_code
        AND	dataset_code = p_hier_dataset_code;

Line: 2249

          UPDATE	gcs_translation_track_h
          SET		earliest_never_period_id = p_next_cal_period_id
          WHERE		hierarchy_id = p_hierarchy_id
          AND		entity_id = p_entity_id
          AND		currency_code = p_currency_code
          AND		dataset_code = p_hier_dataset_code;

Line: 2272

          UPDATE gcs_translation_track_h
          SET earliest_never_period_id = next_period_id
          WHERE hierarchy_id = p_hierarchy_id
          AND   entity_id = p_entity_id
          AND   currency_code = p_currency_code
          AND   dataset_code = p_hier_dataset_code;

Line: 2294

  END Update_Status_Tracking;

Line: 2520

    update_status_tracking(
	p_hierarchy_id		=> hierarchy_id,
	p_entity_id		=> child_entity_id,
	p_currency_code		=> target_currency,
	p_cal_period_id		=> p_cal_period_id,
	p_hier_dataset_code	=> p_hier_dataset_code,
	p_cal_period_number	=> cal_period_info.cal_period_number,
	p_cal_period_year	=> cal_period_info.cal_period_year,
	p_next_cal_period_id	=> cal_period_info.next_cal_period_id);