eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GCS_PERIOD_INIT_DYNAMIC_PKG dependencies on GCS_ENTRY_LINES

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 282: GCS_ENTRY_LINES l2,

278: -1*(ytd_credit_balance_e),
279: 0,
280: 0
281: FROM
282: GCS_ENTRY_LINES l2,
283: FEM_LN_ITEMS_ATTR lia,
284: FEM_EXT_ACCT_TYPES_ATTR feata
285: WHERE l2.entry_id = l_entry_list(i)
286: AND lia.attribute_id = g_li_eat_attr_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 347: GCS_ENTRY_LINES l2

343: -1*(ytd_credit_balance_e),
344: 0,
345: 0
346: FROM
347: GCS_ENTRY_LINES l2
348: WHERE l2.entry_id = l_entry_list(i)
349: AND l2.line_type_code IN ('PROFIT_LOSS', 'BALANCE_SHEET');
350:
351: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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 437: GCS_ENTRY_LINES l2,

433: 0,
434: 0
435: FROM
436: --Bugfix 5449718: Remove source, target entry, and category joins.
437: GCS_ENTRY_LINES l2,
438: FEM_LN_ITEMS_ATTR lia,
439: FEM_EXT_ACCT_TYPES_ATTR feata
440: WHERE
441: l2.entry_id = l_entry_list(i)

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 536: GCS_ENTRY_LINES l2,

532: ytd_debit_balance_e,
533: ytd_credit_balance_e
534: FROM
535: --Bugfix 5449718: Remove source, target entry, and category joins. Add join to fem_ext_acct_types_attr
536: GCS_ENTRY_LINES l2,
537: FEM_LN_ITEMS_ATTR lia,
538: FEM_EXT_ACCT_TYPES_ATTR feata
539: WHERE
540: l2.entry_id = l_entry_list(i)

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 602: GCS_ENTRY_LINES l2

598: 0,
599: 0
600: FROM
601: --Bugfix 5449718: Remove source, target entry, and category joins.
602: GCS_ENTRY_LINES l2
603: WHERE
604: l2.entry_id = l_entry_list(i)
605: AND l2.line_type_code IN ('CALCULATED', 'BALANCE_SHEET');
606: -- Bugfix 5449718: Group by is no longer necessary

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 616: INSERT INTO gcs_entry_lines

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,
620: intercompany_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: