APPS.PA_XLA_UPGRADE dependencies on PA_XLA_UPG_CTRL

Line 267: PA_XLA_UPG_CTRL

263: FROM PA_COST_DISTRIBUTION_LINES_ALL cdl,
264: PA_EXPENDITURE_ITEMS_ALL ei,
265: PA_IMPLEMENTATIONS_ALL imp,
266: (select ledger_id,min(min_value) min_value, max(max_value) max_value from
267: PA_XLA_UPG_CTRL
268: where reference = 'GL_PERIOD_STATUSES'
269: AND status = 'P'
270: AND batch_id = p_upg_batch_id
271: group by ledger_id) ctrl,

Line 343: PA_XLA_UPG_CTRL

339: FROM PA_CC_DIST_LINES_ALL cdl,
340: PA_EXPENDITURE_ITEMS_ALL ei,
341: PA_IMPLEMENTATIONS_ALL imp,
342: (select ledger_id,min(min_value) min_value, max(max_value) max_value from
343: PA_XLA_UPG_CTRL
344: where reference = 'GL_PERIOD_STATUSES'
345: AND status = 'P'
346: AND batch_id = p_upg_batch_id
347: group by ledger_id) ctrl,

Line 1575: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE,

1571: -- For each ledger min and max gl dates are stored in the control table so as to avoid joining
1572: -- with gl_period_statuses table in the main upgrade
1573: ---------------------------------------------------------------------------------------------------
1574:
1575: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE,
1576: LEDGER_ID, BATCH_ID, STATUS)
1577: SELECT 'GL_PERIOD_STATUSES', to_char(min(start_date),'J') , to_char(max(end_date),'J') , ledger_id, p_batch_id, 'P'
1578: FROM gl_period_statuses
1579: WHERE application_id = 275

Line 1585: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE,

1581: AND exists (select 1 from pa_implementations_all where set_of_books_id
1582: = ledger_id and SAME_PA_GL_PERIOD = 'N')
1583: GROUP BY ledger_id;
1584:
1585: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE,
1586: LEDGER_ID, BATCH_ID, STATUS)
1587: SELECT 'GL_PERIOD_STATUSES', to_char(min(start_date),'J') , to_char(max(end_date),'J') , ledger_id, p_batch_id, 'P'
1588: FROM gl_period_statuses
1589: WHERE application_id = 8721

Line 1597: from pa_xla_upg_ctrl

1593: GROUP BY ledger_id;
1594:
1595: select min(to_date(min_value,'J') ) , max(to_date(max_value,'J') )
1596: into l_start_date, l_end_date
1597: from pa_xla_upg_ctrl
1598: where batch_id = p_batch_id
1599: and reference = 'GL_PERIOD_STATUSES';
1600:
1601:

Line 1672: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)

1668:
1669: l_jeh_min_id := null;
1670: l_jeh_max_id := null;
1671:
1672: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)
1673: VALUES ('GL_JE_HEADERS', l_jeh_min_id, l_jeh_max_id, '', p_batch_id, 'P');
1674:
1675: ---------------------------------------------------------------------------------------------------
1676: -- Min and max expenditure item ids are stored in the control table to drive the cost and cross

Line 1720: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)

1716: 3 Only Cross Charge is there
1717:
1718: */
1719:
1720: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)
1721: VALUES ('COST_CROSS_FLAG', l_cost_cross, l_cost_cross, '', p_batch_id, 'P');
1722:
1723:
1724: l_min_eiid := 0;

Line 1754: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)

1750: end if;
1751: end if;
1752:
1753:
1754: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)
1755: VALUES ('PA_EXPENDITURE_ITEMS_ALL', l_min_eiid, l_max_eiid, '', p_batch_id, 'P');
1756:
1757:
1758:

Line 1776: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)

1772: END;
1773:
1774: IF l_cnt > 0
1775: THEN
1776: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)
1777: VALUES ('MRC', l_min_eiid, l_max_eiid, '', p_batch_id, 'P');
1778:
1779: x_mrc_enabled := 'Y';
1780: ELSE