APPS.GCS_XML_GEN_PKG dependencies on GCS_CONS_ENG_RUN_DTLS

Line 2074: FROM gcs_cons_eng_run_dtls

2070: SELECT run_detail_id,
2071: entry_id,
2072: stat_entry_id,
2073: request_error_code
2074: FROM gcs_cons_eng_run_dtls
2075: WHERE run_name = p_run_name
2076: AND consolidation_entity_id = p_cons_entity_id
2077: AND child_entity_id = p_child_entity_id
2078: AND category_code = p_category_code;

Line 2085: FROM gcs_cons_eng_run_dtls

2081: SELECT run_detail_id,
2082: entry_id,
2083: stat_entry_id,
2084: request_error_code
2085: FROM gcs_cons_eng_run_dtls
2086: WHERE run_name = p_run_name
2087: AND consolidation_entity_id = p_cons_entity_id
2088: AND child_entity_id IS NOT NULL
2089: AND category_code = p_category_code;

Line 2096: FROM gcs_cons_eng_run_dtls

2092: SELECT run_detail_id,
2093: entry_id,
2094: stat_entry_id,
2095: request_error_code
2096: FROM gcs_cons_eng_run_dtls
2097: WHERE run_name = p_run_name
2098: AND consolidation_entity_id = p_cons_entity_id
2099: AND category_code = p_category_code
2100: AND child_entity_id = p_child_entity_id;

Line 2107: FROM gcs_cons_eng_run_dtls

2103: SELECT run_detail_id,
2104: entry_id,
2105: stat_entry_id,
2106: request_error_code
2107: FROM gcs_cons_eng_run_dtls
2108: WHERE run_name = p_run_name
2109: AND consolidation_entity_id = p_cons_entity_id
2110: AND child_entity_id IS NOT NULL
2111: AND category_code = p_category_code;

Line 2127: FROM gcs_cons_eng_run_dtls

2123: request_error_code
2124: INTO l_entry_id,
2125: l_stat_entry_id,
2126: l_request_error_code
2127: FROM gcs_cons_eng_run_dtls
2128: WHERE run_detail_id = p_run_detail_id;
2129:
2130: EXCEPTION
2131: WHEN OTHERS THEN

Line 2145: FROM gcs_cons_eng_run_dtls

2141: SELECT entry_id,
2142: request_error_code
2143: INTO l_entry_id,
2144: l_request_error_code
2145: FROM gcs_cons_eng_run_dtls
2146: WHERE run_detail_id = p_run_detail_id;
2147: --fnd_file.put_line(fnd_file.log, 'Entry Id'|| l_entry_id);
2148: EXCEPTION
2149: WHEN OTHERS THEN