DBA Data[Home] [Help]

APPS.GCS_AD_TRIALBALANCE_PKG dependencies on GCS_ENTRY_HEADERS_S

Line 165: 'SELECT gcs_entry_headers_s.NEXTVAL'

161: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
162: THEN
163: fnd_log.STRING (fnd_log.level_statement,
164: g_pkg_name || '.' || l_api_name,
165: 'SELECT gcs_entry_headers_s.NEXTVAL'
166: || g_nl
167: || 'INTO l_entry_id'
168: || g_nl
169: || 'FROM dual'

Line 173: SELECT gcs_entry_headers_s.NEXTVAL

169: || 'FROM dual'
170: );
171: END IF;
172:
173: SELECT gcs_entry_headers_s.NEXTVAL
174: INTO l_entry_id
175: FROM DUAL;
176:
177: gcs_entry_pkg.insert_entry_header

Line 301: 'SELECT gcs_entry_headers_s.NEXTVAL'

297: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
298: THEN
299: fnd_log.STRING (fnd_log.level_statement,
300: g_pkg_name || '.' || l_api_name,
301: 'SELECT gcs_entry_headers_s.NEXTVAL'
302: || g_nl
303: || 'INTO l_new_entry_id'
304: || g_nl
305: || 'FROM dual'

Line 309: SELECT gcs_entry_headers_s.NEXTVAL

305: || 'FROM dual'
306: );
307: END IF;
308:
309: SELECT gcs_entry_headers_s.NEXTVAL
310: INTO l_new_entry_id
311: FROM DUAL;
312:
313: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

Line 1211: 'UPDATE gcs_entry_headers set disabled_flag = ''Y'' WHERE entry_id = '

1207: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1208: THEN
1209: fnd_log.STRING (fnd_log.level_statement,
1210: g_pkg_name || '.' || l_api_name,
1211: 'UPDATE gcs_entry_headers set disabled_flag = ''Y'' WHERE entry_id = '
1212: || l_entry_id
1213: );
1214: END IF;
1215: update gcs_entry_headers set disabled_flag = 'Y' where entry_id = l_entry_id;

Line 1215: update gcs_entry_headers set disabled_flag = 'Y' where entry_id = l_entry_id;

1211: 'UPDATE gcs_entry_headers set disabled_flag = ''Y'' WHERE entry_id = '
1212: || l_entry_id
1213: );
1214: END IF;
1215: update gcs_entry_headers set disabled_flag = 'Y' where entry_id = l_entry_id;
1216: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1217: THEN
1218: fnd_log.STRING (fnd_log.level_statement,
1219: g_pkg_name || '.' || l_api_name,