DBA Data[Home] [Help]

APPS.GCS_PERIOD_INIT_DYNAMIC_PKG dependencies on GCS_ENTRY_LINES_GT

Line 246: --Bugfix 5449718: Need to insert into GCS_ENTRY_LINES_GT to avoid unique constraint errors

242: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.' || fn_name, 'Beginning Collection of Single Year Entries');
244: END IF;
245:
246: --Bugfix 5449718: Need to insert into GCS_ENTRY_LINES_GT to avoid unique constraint errors
247: FORALL i IN l_entry_id_list.FIRST.. l_entry_id_list.LAST
248: INSERT INTO GCS_ENTRY_LINES_GT
249: (entry_id,
250: description,

Line 248: INSERT INTO GCS_ENTRY_LINES_GT

244: END IF;
245:
246: --Bugfix 5449718: Need to insert into GCS_ENTRY_LINES_GT to avoid unique constraint errors
247: FORALL i IN l_entry_id_list.FIRST.. l_entry_id_list.LAST
248: INSERT INTO GCS_ENTRY_LINES_GT
249: (entry_id,
250: description,
251: company_cost_center_org_id,
252: intercompany_id,

Line 299: --Bugfix 5449718: Need to insert into GCS_ENTRY_LINES_GT to avoid unique constraint errors. Handle entries where only balance sheet lines must be applied

295: END IF;
296:
297: END IF;
298:
299: --Bugfix 5449718: Need to insert into GCS_ENTRY_LINES_GT to avoid unique constraint errors. Handle entries where only balance sheet lines must be applied
300: IF (l_recur_entry_id_list.COUNT > 0) THEN
301: --Cannot reference tables of records in BULK statements so initializing individual tables
302:
303: l_entry_list.DELETE;

Line 316: INSERT INTO GCS_ENTRY_LINES_GT l1

312: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.' || fn_name, 'Beginning Collection of Recurring Entries');
313: END IF;
314:
315: FORALL i IN l_recur_entry_id_list.FIRST.. l_recur_entry_id_list.LAST
316: INSERT INTO GCS_ENTRY_LINES_GT l1
317: (entry_id,
318: description,
319: company_cost_center_org_id,
320: intercompany_id,

Line 389: INSERT INTO GCS_ENTRY_LINES_GT l1

385: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.' || fn_name, 'Beginning Collection of Single Year Entries');
386: END IF;
387:
388: FORALL i IN l_entry_id_list.FIRST.. l_entry_id_list.LAST
389: INSERT INTO GCS_ENTRY_LINES_GT l1
390: (entry_id,
391: description,
392: company_cost_center_org_id,
393: intercompany_id,

Line 488: INSERT INTO GCS_ENTRY_LINES_GT l1

484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.' || fn_name, 'Beginning Collection of Single Year Entries');
485: END IF;
486:
487: FORALL i IN l_entry_id_list.FIRST.. l_entry_id_list.LAST
488: INSERT INTO GCS_ENTRY_LINES_GT l1
489: (entry_id,
490: description,
491: company_cost_center_org_id,
492: intercompany_id,

Line 572: INSERT INTO GCS_ENTRY_LINES_GT l1

568: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.' || fn_name, 'Beginning Collection of Recurring Entries');
569: END IF;
570:
571: FORALL i IN l_recur_entry_id_list.FIRST.. l_recur_entry_id_list.LAST
572: INSERT INTO GCS_ENTRY_LINES_GT l1
573: (entry_id,
574: description,
575: company_cost_center_org_id,
576: intercompany_id,

Line 615: --Bugfix 5449718: Move data from gcs_entry_lines_gt into gcs_entry_lines

611:
612: END IF;
613: END IF; --if..then..cross year flag
614:
615: --Bugfix 5449718: Move data from gcs_entry_lines_gt into gcs_entry_lines
616: INSERT INTO gcs_entry_lines
617: (entry_id,
618: line_type_code,
619: company_cost_center_org_id,

Line 652: FROM gcs_entry_lines_gt

648: GCS_PERIOD_INIT_PKG.g_fnd_user_id,
649: sysdate,
650: GCS_PERIOD_INIT_PKG.g_fnd_user_id,
651: GCS_PERIOD_INIT_PKG.g_fnd_login_id
652: FROM gcs_entry_lines_gt
653: GROUP BY entry_id,
654: company_cost_center_org_id,
655: line_item_id,
656: