APPS.XLA_ACCT_SETUP_PKG dependencies on XLA_LAUNCH_OPTIONS

Line 523: -- 2. Inserts into xla_launch_options for ledgers that do not exist there.

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
526: -- earlier.
527: --

Line 580: -- Inserting into xla_launch_options table rows for the application and

576: trace('Number of rows deleted = '||SQL%ROWCOUNT,30);
577:
578:
579: -------------------------------------------------------------------------
580: -- Inserting into xla_launch_options table rows for the application and
581: -- all the eligible ledgers.
582: -------------------------------------------------------------------------
583: trace('Inserting rows in xla_launch_options for the ledgers '||
584: 'that are not already setup',20);

Line 583: trace('Inserting rows in xla_launch_options for the ledgers '||

579: -------------------------------------------------------------------------
580: -- Inserting into xla_launch_options table rows for the application and
581: -- all the eligible ledgers.
582: -------------------------------------------------------------------------
583: trace('Inserting rows in xla_launch_options for the ledgers '||
584: 'that are not already setup',20);
585:
586: INSERT INTO xla_launch_options
587: (application_id

Line 586: INSERT INTO xla_launch_options

582: -------------------------------------------------------------------------
583: trace('Inserting rows in xla_launch_options for the ledgers '||
584: 'that are not already setup',20);
585:
586: INSERT INTO xla_launch_options
587: (application_id
588: ,ledger_id
589: ,accounting_mode_code
590: ,accounting_mode_override_flag

Line 642: FROM xla_launch_options

638: AND gll.ledger_id = xlr.primary_ledger_id
639: AND NVL(xam.transaction_coa_id
640: ,gll.chart_of_accounts_id) = gll.chart_of_accounts_id
641: AND NOT EXISTS (SELECT 1
642: FROM xla_launch_options
643: WHERE ledger_id = xlr.ledger_id
644: AND application_id = xsl.application_id));
645:
646: trace('Number of rows inserted = '||SQL%ROWCOUNT,30);

Line 860: FROM xla_launch_options

856: l_exist VARCHAR2(1);
857:
858: CURSOR c_launch_options IS
859: SELECT 'x'
860: FROM xla_launch_options
861: WHERE application_id = p_application_id
862: AND ledger_id = p_ledger_id;
863:
864: BEGIN

Line 873: INSERT INTO xla_launch_options

869: OPEN c_launch_options;
870: FETCH c_launch_options INTO l_exist ;
871:
872: IF c_launch_options%NOTFOUND THEN
873: INSERT INTO xla_launch_options
874: (application_id
875: ,ledger_id
876: ,accounting_mode_code
877: ,accounting_mode_override_flag

Line 1096: FROM xla_launch_options

1092: l_application_id NUMBER(38);
1093:
1094: CURSOR c_launch_options IS
1095: SELECT 'x'
1096: FROM xla_launch_options
1097: WHERE application_id = p_application_id
1098: AND ledger_id = p_primary_ledger_id;
1099:
1100: BEGIN

Line 1245: -- Ledger is primary, so insert into xla_launch_options

1241: -- Check if ledger is primary or secondary
1242: ----------------------------------------------------------------------------
1243: IF p_primary_ledger_id = p_ledger_id THEN
1244: -------------------------------------------------------------------------
1245: -- Ledger is primary, so insert into xla_launch_options
1246: -------------------------------------------------------------------------
1247: insert_launch_options
1248: (p_ledger_id => p_ledger_id
1249: ,p_application_id => p_application_id);

Line 1276: -- xla_launch_options

1272:
1273: IF p_valuation_method_flag = 'Y' THEN
1274: -------------------------------------------------------------------
1275: -- Consider secondary ledger as primary, insert into
1276: -- xla_launch_options
1277: -------------------------------------------------------------------
1278: insert_launch_options
1279: (p_ledger_id => p_ledger_id
1280: ,p_application_id => p_application_id);

Line 1564: UPDATE xla_launch_options SET

1560: ----------------------------------------------------------------------------
1561: -- Update launch options, if there is already launch options for the
1562: -- ledger and the application
1563: ----------------------------------------------------------------------------
1564: UPDATE xla_launch_options SET
1565: accounting_mode_code = NVL(p_acct_mode_code, accounting_mode_code)
1566: ,accounting_mode_override_flag = NVL(p_acct_mode_override_flag, accounting_mode_override_flag)
1567: ,summary_report_flag = NVL(p_summary_report_flag, summary_report_flag)
1568: ,summary_report_override_flag = NVL(p_summary_report_override_flag, summary_report_override_flag)