APPS.GCS_AD_TRIALBALANCE_PKG dependencies on GCS_ENTRY_HEADERS

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 238: 'UPDATE gcs_entry_headers'

234: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
235: THEN
236: fnd_log.STRING (fnd_log.level_statement,
237: g_pkg_name || '.' || l_api_name,
238: 'UPDATE gcs_entry_headers'
239: || g_nl
240: || 'SET entry_name = '
241: || p_entry_name
242: || g_nl

Line 255: UPDATE gcs_entry_headers

251: || l_entry_id
252: );
253: END IF;
254:
255: UPDATE gcs_entry_headers
256: SET entry_name = p_entry_name,
257: description = p_description,
258: balance_type_code = p_balance_type_code,
259: last_update_date = sysdate

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 317: 'UPDATE gcs_entry_headers'

313: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
314: THEN
315: fnd_log.STRING (fnd_log.level_statement,
316: g_pkg_name || '.' || l_api_name,
317: 'UPDATE gcs_entry_headers'
318: || g_nl
319: || 'SET disabled_flag = ''Y'''
320: || g_nl
321: || ',entry_name = substr(entry_name, 0, 55) || '' OLD ->'' || '

Line 330: UPDATE gcs_entry_headers

326: || l_entry_id
327: );
328: END IF;
329:
330: UPDATE gcs_entry_headers
331: SET disabled_flag = 'Y',
332: entry_name = substr(entry_name, 0, 55) || ' OLD ->' || l_new_entry_id,
333: last_update_date = sysdate
334: WHERE entry_id = l_entry_id;

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,

Line 1249: 'DELETE FROM gcs_entry_headers WHERE entry_id = '

1245: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1246: THEN
1247: fnd_log.STRING (fnd_log.level_statement,
1248: g_pkg_name || '.' || l_api_name,
1249: 'DELETE FROM gcs_entry_headers WHERE entry_id = '
1250: || l_entry_id
1251: );
1252: END IF;
1253: delete from gcs_entry_headers where entry_id = l_entry_id;

Line 1253: delete from gcs_entry_headers where entry_id = l_entry_id;

1249: 'DELETE FROM gcs_entry_headers WHERE entry_id = '
1250: || l_entry_id
1251: );
1252: END IF;
1253: delete from gcs_entry_headers where entry_id = l_entry_id;
1254: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1255: THEN
1256: fnd_log.STRING (fnd_log.level_statement,
1257: g_pkg_name || '.' || l_api_name,