DBA Data[Home] [Help]

APPS.GCS_XML_DT_UTILITY_PKG dependencies on GCS_ENTRY_HEADERS

Line 952: FROM gcs_entry_headers geh,

948: l_api_name VARCHAR2 (30) := 'BEFORE_ENTRY_REPORT';
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

Line 962: FROM gcs_entry_headers geh

958:
959: CURSOR year_to_apply_re_cur (pEntryId NUMBER)
960: IS
961: SELECT geh.year_to_apply_re
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;

Line 965: l_year_to_appy_re GCS_ENTRY_HEADERS.YEAR_TO_APPLY_RE%TYPE;

961: SELECT geh.year_to_apply_re
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