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.

APPS.XLA_ACCT_SETUP_PKG dependencies on XLA_JE_CATEGORIES

Line 497: -- Delete from xla_je_categories table.

493: trace('p_event_class_code = '||p_event_class_code , 20);
494: trace('p_application_id = '||p_application_id , 20);
495:
496: ----------------------------------------------------------------------------
497: -- Delete from xla_je_categories table.
498: ----------------------------------------------------------------------------
499: DELETE FROM xla_je_categories
500: WHERE application_id = p_application_id
501: AND event_class_code = p_event_class_code;

Line 499: DELETE FROM xla_je_categories

495:
496: ----------------------------------------------------------------------------
497: -- Delete from xla_je_categories table.
498: ----------------------------------------------------------------------------
499: DELETE FROM xla_je_categories
500: WHERE application_id = p_application_id
501: AND event_class_code = p_event_class_code;
502: trace('Number of rows deleted = '||SQL%ROWCOUNT , 40);
503:

Line 521: -- 1. Deletes from xla_je_categories the event classes that do not

517: -- This API is a registered concurrent program that can be executed for one/all
518: -- applications registered with XLA, to compelete the subledger's accounting
519: -- setup for defined ledgers.
520: -- It performs following tasks for the application(s):
521: -- 1. Deletes from xla_je_categories the event classes that do not
522: -- exist in xla_event_classes.
523: -- 2. Inserts into xla_launch_options for ledgers that do not exist there.
524: -- 3. Inserts into xla_ledger_options for ledgers that do not exist there.
525: -- 4. Inserts into xla_je_categories the event classes that were not setup

Line 525: -- 4. Inserts into xla_je_categories the event classes that were not setup

521: -- 1. Deletes from xla_je_categories the event classes that do not
522: -- exist in xla_event_classes.
523: -- 2. Inserts into xla_launch_options for ledgers that do not exist there.
524: -- 3. Inserts into xla_ledger_options for ledgers that do not exist there.
525: -- 4. Inserts into xla_je_categories the event classes that were not setup
526: -- earlier.
527: --
528: --=============================================================================
529: PROCEDURE perform_application_setup_cp

Line 561: -- Deleting from xla_je_categories all the event classes for the

557: trace('Updating Subledger Accounting Options for application = '||
558: c1.application_name, 20);
559:
560: -------------------------------------------------------------------------
561: -- Deleting from xla_je_categories all the event classes for the
562: -- application that has been deleted from AMB tables.
563: -------------------------------------------------------------------------
564: trace('Deleting orphan rows from xla_je_categories for event classes '||
565: 'that do not exist.....',20);

Line 564: trace('Deleting orphan rows from xla_je_categories for event classes '||

560: -------------------------------------------------------------------------
561: -- Deleting from xla_je_categories all the event classes for the
562: -- application that has been deleted from AMB tables.
563: -------------------------------------------------------------------------
564: trace('Deleting orphan rows from xla_je_categories for event classes '||
565: 'that do not exist.....',20);
566:
567: DELETE
568: FROM xla_je_categories xjc

Line 568: FROM xla_je_categories xjc

564: trace('Deleting orphan rows from xla_je_categories for event classes '||
565: 'that do not exist.....',20);
566:
567: DELETE
568: FROM xla_je_categories xjc
569: WHERE application_id = c1.application_id
570: AND NOT EXISTS
571: (SELECT 1
572: FROM xla_event_classes_b

Line 722: -- Inserting into xla_je_categories table rows for all the eligible

718:
719:
720:
721: -------------------------------------------------------------------------
722: -- Inserting into xla_je_categories table rows for all the eligible
723: -- classes for the application and all the eligible ledgers.
724: -------------------------------------------------------------------------
725: trace('Inserting rows in xla_je_categories for the event classes and ledgers '||
726: 'that are not already setup',20);

Line 725: trace('Inserting rows in xla_je_categories for the event classes and ledgers '||

721: -------------------------------------------------------------------------
722: -- Inserting into xla_je_categories table rows for all the eligible
723: -- classes for the application and all the eligible ledgers.
724: -------------------------------------------------------------------------
725: trace('Inserting rows in xla_je_categories for the event classes and ledgers '||
726: 'that are not already setup',20);
727:
728: INSERT INTO xla_je_categories
729: (application_id

Line 728: INSERT INTO xla_je_categories

724: -------------------------------------------------------------------------
725: trace('Inserting rows in xla_je_categories for the event classes and ledgers '||
726: 'that are not already setup',20);
727:
728: INSERT INTO xla_je_categories
729: (application_id
730: ,ledger_id
731: ,entity_code
732: ,event_class_code

Line 767: FROM xla_je_categories

763: AND NVL(xam.transaction_coa_id
764: ,gll.chart_of_accounts_id) = gll.chart_of_accounts_id
765: AND xec.application_id = xsl.application_id
766: AND NOT EXISTS (SELECT 1
767: FROM xla_je_categories
768: WHERE application_id = xsl.application_id
769: AND ledger_id = xlr.ledger_id
770: AND entity_code = xec.entity_code
771: AND event_class_code = xec.event_class_code));

Line 1035: FROM xla_je_categories xjc

1031: WHERE xeca.application_id = p_application_id
1032: AND xeca.event_class_code = NVL(p_event_class_code,xeca.event_class_code)
1033: AND xeca.event_class_code NOT IN
1034: (SELECT event_class_code
1035: FROM xla_je_categories xjc
1036: WHERE xjc.application_id = p_application_id
1037: AND xjc.ledger_id = p_ledger_id);
1038:
1039: BEGIN

Line 1046: INSERT INTO xla_je_categories

1042: trace('p_application_id = '||p_application_id , 20);
1043: trace('p_event_class_code = '||p_event_class_code , 20);
1044:
1045: FOR c1 IN csr_event_classes LOOP
1046: INSERT INTO xla_je_categories
1047: (application_id
1048: ,ledger_id
1049: ,entity_code
1050: ,event_class_code

Line 1259: -- Insert into xla_je_categories

1255: (p_ledger_id => p_ledger_id
1256: ,p_application_id => p_application_id);
1257:
1258: -------------------------------------------------------------------------
1259: -- Insert into xla_je_categories
1260: -------------------------------------------------------------------------
1261: insert_je_category
1262: (p_ledger_id => p_ledger_id
1263: ,p_application_id => p_application_id

Line 1291: -- Insert into xla_je_categories

1287: (p_ledger_id => p_ledger_id
1288: ,p_application_id => p_application_id);
1289:
1290: ----------------------------------------------------------------------
1291: -- Insert into xla_je_categories
1292: ----------------------------------------------------------------------
1293: insert_je_category
1294: (p_ledger_id => p_ledger_id
1295: ,p_application_id => p_application_id