APPS.GCS_XML_DT_UTILITY_PKG dependencies on FEM_CAL_PERIODS_ATTR

Line 72: fem_cal_periods_attr fcpa

68: gcs_entities_attr gea,
69: fem_tab_column_prop ftcp,
70: fem_tab_columns_b ftcb,
71: gcs_data_sub_dtls gdsd,
72: fem_cal_periods_attr fcpa
73: WHERE gdsd.load_id = p_load_id
74: AND gea.entity_id = p_entity_id
75: AND gea.data_type_code = gdsd.balance_type_code
76: AND fcpa.cal_period_id = gdsd.cal_period_id

Line 245: fem_cal_periods_attr fcpa

241: IS
242: SELECT DISTINCT gcr.child_entity_id
243: FROM gcs_cons_relationships gcr,
244: gcs_cons_eng_runs gcer,
245: fem_cal_periods_attr fcpa
246: WHERE gcr.parent_entity_id = p_entity_id
247: AND gcr.dominant_parent_flag = 'Y'
248: AND gcr.hierarchy_id = gcer.hierarchy_id
249: AND gcer.run_name = p_run_name

Line 350: fem_cal_periods_attr fcpa

346: l_entity_id
347: FROM gcs_data_sub_dtls gdsd,
348: gcs_entities_attr gea,
349: fem_ledgers_attr fla_comp,
350: fem_cal_periods_attr fcpa
351: WHERE gdsd.load_id = pXmlFileId
352: AND gea.entity_id = gdsd.entity_id
353: AND gea.data_type_code = gdsd.balance_type_code
354: AND fcpa.cal_period_id = gdsd.cal_period_id

Line 442: fem_cal_periods_attr fcpa

438: fem_tab_columns_b ftcb,
439: gcs_system_options gso,
440: fem_global_vs_combo_defs fch_gvcd,
441: gcs_data_sub_dtls gdsd ,
442: fem_cal_periods_attr fcpa
443: WHERE gso.fch_global_vs_combo_id = fch_gvcd.global_vs_combo_id
444: AND gea.entity_id = gdsd.entity_id
445: AND gea.data_type_code = gdsd.balance_type_code
446: AND fcpa.cal_period_id = gdsd.cal_period_id

Line 616: fem_cal_periods_attr fcpa

612: FROM gcs_data_type_codes_vl gdtcb,
613: gcs_entities_attr gea,
614: fem_ledgers_attr fla,
615: fem_datasets_attr fda,
616: fem_cal_periods_attr fcpa
617: WHERE gea.data_type_code = gdtcb.data_type_code
618: AND fla.ledger_id = gea.ledger_id
619: AND fda.dataset_code = gdtcb.source_dataset_code
620: AND gea.entity_id = pEntityId

Line 645: fem_cal_periods_attr fcpa

641: INTO l_source_datasetcode
642: FROM gcs_entities_attr gea ,
643: fem_object_definition_b fodb,
644: fem_intg_bal_rule_defs fibrd,
645: fem_cal_periods_attr fcpa
646: WHERE fodb.object_id = gea.balances_rule_id
647: AND fibrd.bal_rule_obj_def_id = fodb.object_definition_id
648: AND gea.entity_id = pEntityId
649: AND gea.data_type_code = pDataTypeCode

Line 778: fem_cal_periods_attr fcpa

774: gcs_entities_attr gea,
775: gcs_system_options gso,
776: fem_global_vs_combo_defs fch_gvcd,
777: gcs_data_sub_dtls gdsd,
778: fem_cal_periods_attr fcpa
779: WHERE gso.fch_global_vs_combo_id = fch_gvcd.global_vs_combo_id
780: AND fla.ledger_id = gea.ledger_id
781: AND fla.attribute_id = pLedgerVsComboAttr
782: AND fla.version_id = pLedgerVsComboVersion

Line 812: FROM fem_cal_periods_attr fcpa

808: --Do further filtration on HIERARCHY_OBJ_DEF_ID
809: -- Get the Cal Period End Date
810: SELECT fcpa.date_assign_value
811: INTO l_cal_pd_end_date
812: FROM fem_cal_periods_attr fcpa
813: WHERE fcpa.attribute_id = l_period_end_date_attr
814: AND fcpa.version_id = l_period_end_date_version
815: AND fcpa.cal_period_id = pCalPeriodId ;
816:

Line 953: fem_cal_periods_attr fcpa

949: CURSOR period_cur (pEntryId NUMBER, pAccountingYrAttrId NUMBER, pAccountingYrVerId NUMBER)
950: IS
951: SELECT fcpa.number_assign_value view_period_year
952: FROM gcs_entry_headers geh,
953: fem_cal_periods_attr fcpa
954: WHERE geh.entry_id = pEntryId
955: AND fcpa.cal_period_id = pCalPeriodId
956: AND fcpa.attribute_id = pAccountingYrAttrId
957: AND fcpa.version_id = pAccountingYrVerId;

Line 966: l_view_period FEM_CAL_PERIODS_ATTR.NUMBER_ASSIGN_VALUE%TYPE;

962: FROM gcs_entry_headers geh
963: WHERE geh.entry_id = pEntryId;
964:
965: l_year_to_appy_re GCS_ENTRY_HEADERS.YEAR_TO_APPLY_RE%TYPE;
966: l_view_period FEM_CAL_PERIODS_ATTR.NUMBER_ASSIGN_VALUE%TYPE;
967:
968: BEGIN
969: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');