APPS.XLA_UPGRADE_PUB dependencies on XLA_UPGRADE_DATES

Line 1213: EXECUTE IMMEDIATE 'LOCK TABLE XLA_UPGRADE_DATES IN EXCLUSIVE MODE NOWAIT ';

1209: END IF;
1210:
1211: -- Extra Validation in place to not to allow any two concurrent program's
1212: -- to run simultaneously
1213: EXECUTE IMMEDIATE 'LOCK TABLE XLA_UPGRADE_DATES IN EXCLUSIVE MODE NOWAIT ';
1214: EXECUTE IMMEDIATE 'LOCK TABLE XLA_UPGRADE_REQUESTS IN EXCLUSIVE MODE NOWAIT ';
1215:
1216: SELECT Count(1)
1217: INTO l_hotpatch_running

Line 1541: DELETE FROM xla_upgrade_dates;

1537: ||' are : ' ||To_char(SQL%ROWCOUNT));
1538: END LOOP;
1539: END IF;
1540:
1541: DELETE FROM xla_upgrade_dates;
1542:
1543: -- Inserting details of ledgers , start date and end date for use by product teams
1544: IF p_application_id = 275 THEN
1545: NULL;

Line 1549: INSERT INTO xla_upgrade_dates

1545: NULL;
1546: -- Projects is not participating in this upgrade. So for time being upgraded the code.
1547: /*
1548: FORALL i IN 1..v_array_ledger_id.COUNT
1549: INSERT INTO xla_upgrade_dates
1550: (ledger_id
1551: ,start_date
1552: ,end_date)
1553: SELECT gps.ledger_id

Line 1564: INSERT INTO xla_upgrade_dates

1560: GROUP BY gps.ledger_id ;
1561: */
1562: ELSE
1563: FORALL i IN 1..g_array_ledger_id.COUNT
1564: INSERT INTO xla_upgrade_dates
1565: (ledger_id,
1566: start_date,
1567: end_date)
1568: SELECT gps.ledger_id,

Line 1581: Trace('Gather Statistics on XLA_UPGRADE_DATES',c_level_statement,l_log_module);

1577:
1578: COMMIT;
1579:
1580: IF (c_level_statement >= g_log_level) THEN
1581: Trace('Gather Statistics on XLA_UPGRADE_DATES',c_level_statement,l_log_module);
1582: END IF;
1583: fnd_stats.gather_table_stats('XLA', 'XLA_UPGRADE_DATES');
1584:
1585: -- Call Product Team Upgrade Manager API's for Upgrade

Line 1583: fnd_stats.gather_table_stats('XLA', 'XLA_UPGRADE_DATES');

1579:
1580: IF (c_level_statement >= g_log_level) THEN
1581: Trace('Gather Statistics on XLA_UPGRADE_DATES',c_level_statement,l_log_module);
1582: END IF;
1583: fnd_stats.gather_table_stats('XLA', 'XLA_UPGRADE_DATES');
1584:
1585: -- Call Product Team Upgrade Manager API's for Upgrade
1586: IF (c_level_statement >= g_log_level) THEN
1587: Trace('Calling Product APIs for actual upgrade.',c_level_statement,l_log_module);

Line 2153: -- DELETE FROM xla_upgrade_dates;

2149: -- END IF;
2150:
2151: -- IF l_start_date <> l_end_date THEN
2152:
2153: -- DELETE FROM xla_upgrade_dates;
2154:
2155: -- Inserting details of ledgers , start date and end date
2156: -- for use by product teams
2157: -- INSERT INTO xla_upgrade_dates

Line 2157: -- INSERT INTO xla_upgrade_dates

2153: -- DELETE FROM xla_upgrade_dates;
2154:
2155: -- Inserting details of ledgers , start date and end date
2156: -- for use by product teams
2157: -- INSERT INTO xla_upgrade_dates
2158: -- (ledger_id
2159: -- ,start_date
2160: -- ,end_date)
2161: -- VALUES (l_ledger_id