APPS.GCS_DATASUB_WF_PKG dependencies on GCS_DATA_TYPE_CODES_B

Line 105: gcs_data_type_codes_b gdtcb,

101: FROM gcs_data_sub_dtls gdsd,
102: fem_entities_b feb,
103: fem_ledgers_b flb,
104: gcs_entities_attr gea,
105: gcs_data_type_codes_b gdtcb,
106: fem_datasets_attr fda,
107: fem_cal_periods_attr fcpa
108: WHERE gdsd.load_id = p_load_id
109: AND gdsd.entity_id = feb.entity_id

Line 3336: -- first check whether there exists rows in gcs_data_type_codes_b with given dataset

3332: END IF;
3333:
3334: IF (l_status_code = 'S') THEN
3335:
3336: -- first check whether there exists rows in gcs_data_type_codes_b with given dataset
3337: -- because if it is not then we do not care.
3338:
3339: BEGIN
3340: SELECT data_type_code

Line 3342: FROM gcs_data_type_codes_b

3338:
3339: BEGIN
3340: SELECT data_type_code
3341: INTO l_data_type_code
3342: FROM gcs_data_type_codes_b
3343: WHERE source_dataset_code = l_dataset_code
3344: AND rownum < 2;
3345: EXCEPTION
3346: WHEN NO_DATA_FOUND THEN

Line 3362: FROM gcs_data_type_codes_b

3358:
3359: BEGIN
3360: SELECT source_dataset_code
3361: INTO l_actual_ds_code
3362: FROM gcs_data_type_codes_b
3363: WHERE data_type_code = 'ACTUAL';
3364:
3365: -- Bugfix 5843592, Get the correct entity, depending upon the calendar period
3366:

Line 3413: '<< Source_dataset_code for ACTUAL is NULL in gcs_data_type_codes_b >>');

3409: WHEN NO_DATA_FOUND THEN
3410: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3412: g_api || '.HANDLE_UNDO_EVENT',
3413: '<< Source_dataset_code for ACTUAL is NULL in gcs_data_type_codes_b >>');
3414: END IF;
3415: RETURN 'SUCCESS';
3416: END;
3417: