APPS.PA_XLA_INTERFACE_PKG dependencies on PA_BUDGET_LINES

Line 391: -- E4. Stamp event_id on source table (pa_budget_lines for

387:
388: END LOOP;
389:
390: -- -------------------------------------------------------------+
391: -- E4. Stamp event_id on source table (pa_budget_lines for
392: -- Budgets, pa_bc_packets for FC)
393: IF g_debug_mode = 'Y' THEN
394: pa_debug.g_err_stage:= 'Create Events: Tieback Processing';
395: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

Line 1440: from pa_budget_lines

1436: xla_transaction_entities txn
1437: where evt.entity_id = txn.entity_id
1438: and evt.event_id in
1439: (Select distinct bc_rev_event_id
1440: from pa_budget_lines
1441: where budget_version_id = p_data_set_id1
1442: and bc_rev_event_id is not null
1443: and p_data_set_id1 is not null
1444: UNION ALL

Line 1446: from pa_budget_lines

1442: and bc_rev_event_id is not null
1443: and p_data_set_id1 is not null
1444: UNION ALL
1445: Select distinct bc_event_id
1446: from pa_budget_lines
1447: where budget_version_id = p_data_set_id2
1448: and bc_event_id is not null
1449: and p_data_set_id2 is not null
1450: );

Line 1649: Update pa_budget_lines

1645: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1646: END IF;
1647: -- ----------------------------------------------------------------------------------------- +
1648:
1649: Update pa_budget_lines
1650: set bc_event_id = NULL
1651: where budget_version_id = p_budget_version_id;
1652:
1653: End If;

Line 1663: Update pa_budget_lines

1659: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1660: END IF;
1661: -- ----------------------------------------------------------------------------------------- +
1662:
1663: Update pa_budget_lines
1664: set bc_rev_event_id = NULL
1665: where budget_version_id = p_old_budget_version_id;
1666:
1667: End If;

Line 1904: from pa_budget_lines

1900: -- Note: g_data_set_id is for current version and l_bvid_to_reverse for reversing prev. baselined
1901:
1902: select distinct budget_version_id, start_date
1903: BULK COLLECT INTO t_source_id_int_1,t_event_date
1904: from pa_budget_lines
1905: where budget_version_id in (g_data_set_id,l_bvid_to_reverse);
1906:
1907: If g_debug_mode = 'Y' THEN
1908:

Line 2154: Update pa_budget_lines

2150: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2151: END IF;
2152:
2153: forall i in t_source_id_int_1.FIRST..t_source_id_int_1.LAST
2154: Update pa_budget_lines
2155: set bc_event_id = t_event_id(i)
2156: where budget_version_id = t_source_id_int_1(i)
2157: and start_date = t_event_date(i)
2158: and t_source_id_int_1(i) = g_data_set_id;

Line 2163: Update pa_budget_lines

2159:
2160: If g_bvid_to_reverse is NOT NULL then
2161:
2162: forall i in t_source_id_int_1.FIRST..t_source_id_int_1.LAST
2163: Update pa_budget_lines
2164: set bc_rev_event_id = t_event_id(i)
2165: where budget_version_id = t_source_id_int_1(i)
2166: and start_date = t_event_date(i)
2167: and t_source_id_int_1(i) = g_bvid_to_reverse;