APPS.GCS_TEMPLATES_DYNAMIC_PKG dependencies on GCS_ENTRY_HEADERS

Line 83: || 'FROM gcs_entry_headers '

79: fnd_log.STRING (fnd_log.level_statement,
80: g_pkg_name || '.' || l_api_name,
81: 'SELECT ''X'''
82: || g_nl
83: || 'FROM gcs_entry_headers '
84: || g_nl
85: || 'WHERE entry_id = '
86: || p_entry_id
87: || g_nl

Line 96: FROM gcs_entry_headers

92: IF p_data_prep_flag = 'N' THEN
93: BEGIN
94: SELECT 'Y'
95: INTO l_re_required
96: FROM gcs_entry_headers
97: WHERE entry_id = p_entry_id
98: AND start_cal_period_id <> nvl(end_cal_period_id, 0);
99: EXCEPTION
100: WHEN NO_DATA_FOUND THEN

Line 1082: FROM gcs_entry_headers eh,

1078: CURSOR category_c
1079: IS
1080: SELECT cb.category_code,
1081: cb.category_type_code
1082: FROM gcs_entry_headers eh,
1083: gcs_categories_b cb
1084: WHERE eh.entry_id = p_entry_id
1085: AND cb.category_code = eh.category_code;
1086:

Line 1188: || 'FROM gcs_entry_headers '

1184: fnd_log.STRING (fnd_log.level_statement,
1185: g_pkg_name || '.' || l_api_name,
1186: 'SELECT category_code'
1187: || g_nl
1188: || 'FROM gcs_entry_headers '
1189: || g_nl
1190: || 'WHERE entry_id = '
1191: || p_entry_id
1192: );

Line 1262: from gcs_entry_headers

1258: fnd_log.STRING (fnd_log.level_statement,
1259: g_pkg_name || '.' || l_api_name,
1260: ' select start_cal_period_id, currency_code
1261: into l_cal_period_id, l_currency_code
1262: from gcs_entry_headers
1263: where entry_id = ' || p_entry_id
1264: );
1265: END IF;
1266:

Line 1269: from gcs_entry_headers

1265: END IF;
1266:
1267: select start_cal_period_id, currency_code
1268: into l_cal_period_id, l_currency_code
1269: from gcs_entry_headers
1270: where entry_id = p_entry_id;
1271:
1272: IF l_currency_code <> p_threshold_currency_code THEN
1273:

Line 1692: UPDATE gcs_entry_headers

1688: null;
1689: END;
1690:
1691: IF l_threshold_passed_flag = 'Y' THEN
1692: UPDATE gcs_entry_headers
1693: SET suspense_exceeded_flag = 'Y'
1694: WHERE entry_id = p_entry_id;
1695: END IF;
1696: