APPS.GCS_TRANSLATION_PKG dependencies on GCS_TRANSLATION_STATUSES

Line 2153: FROM gcs_translation_statuses

2149:
2150: -- Check the status of a translation
2151: CURSOR status_check_c(c_cal_period_id NUMBER) IS
2152: SELECT status_code
2153: FROM gcs_translation_statuses
2154: WHERE hierarchy_id = p_hierarchy_id
2155: AND entity_id = p_entity_id
2156: AND currency_code = p_currency_code
2157: AND cal_period_id = c_cal_period_id

Line 2190: INSERT INTO gcs_translation_statuses(

2186: OPEN status_check_c(p_cal_period_id);
2187: FETCH status_check_c INTO status;
2188: IF status_check_c%NOTFOUND THEN
2189: CLOSE status_check_c;
2190: INSERT INTO gcs_translation_statuses(
2191: hierarchy_id, entity_id, currency_code, cal_period_id, dataset_code,
2192: status_code, request_id, creation_date, created_by, last_update_date,
2193: last_updated_by, last_update_login)
2194: VALUES(

Line 2201: UPDATE gcs_translation_statuses

2197: g_fnd_user_id, g_fnd_login_id);
2198: ELSE
2199: CLOSE status_check_c;
2200: IF status <> 'C' THEN
2201: UPDATE gcs_translation_statuses
2202: SET status_code = 'C'
2203: WHERE hierarchy_id = p_hierarchy_id
2204: AND entity_id = p_entity_id
2205: AND currency_code = p_currency_code

Line 2519: -- gcs_translation_statuses tables

2515: p_entry_id => p_new_entry_id);
2516: END IF;
2517:
2518: -- Create or update rows in the gcs_translation_track_h and
2519: -- gcs_translation_statuses tables
2520: update_status_tracking(
2521: p_hierarchy_id => hierarchy_id,
2522: p_entity_id => child_entity_id,
2523: p_currency_code => target_currency,