APPS.PA_XLA_INTERFACE_PKG dependencies on PA_BUDGET_LINES

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

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

Line 1450: from pa_budget_lines

1446: xla_transaction_entities txn
1447: where evt.entity_id = txn.entity_id
1448: and evt.event_id in
1449: (Select distinct bc_rev_event_id
1450: from pa_budget_lines
1451: where budget_version_id = p_data_set_id1
1452: and bc_rev_event_id is not null
1453: and p_data_set_id1 is not null
1454: UNION ALL

Line 1456: from pa_budget_lines

1452: and bc_rev_event_id is not null
1453: and p_data_set_id1 is not null
1454: UNION ALL
1455: Select distinct bc_event_id
1456: from pa_budget_lines
1457: where budget_version_id = p_data_set_id2
1458: and bc_event_id is not null
1459: and p_data_set_id2 is not null
1460: );

Line 1659: Update pa_budget_lines

1655: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1656: END IF;
1657: -- ----------------------------------------------------------------------------------------- +
1658:
1659: Update pa_budget_lines
1660: set bc_event_id = NULL
1661: where budget_version_id = p_budget_version_id;
1662:
1663: End If;

Line 1673: Update pa_budget_lines

1669: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1670: END IF;
1671: -- ----------------------------------------------------------------------------------------- +
1672:
1673: Update pa_budget_lines
1674: set bc_rev_event_id = NULL
1675: where budget_version_id = p_old_budget_version_id;
1676:
1677: End If;

Line 1914: from pa_budget_lines

1910: -- Note: g_data_set_id is for current version and l_bvid_to_reverse for reversing prev. baselined
1911:
1912: select distinct budget_version_id, start_date
1913: BULK COLLECT INTO t_source_id_int_1,t_event_date
1914: from pa_budget_lines
1915: where budget_version_id in (g_data_set_id,l_bvid_to_reverse);
1916:
1917: If g_debug_mode = 'Y' THEN
1918:

Line 2164: Update pa_budget_lines

2160: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2161: END IF;
2162:
2163: forall i in t_source_id_int_1.FIRST..t_source_id_int_1.LAST
2164: Update pa_budget_lines
2165: set bc_event_id = t_event_id(i)
2166: where budget_version_id = t_source_id_int_1(i)
2167: and start_date = t_event_date(i)
2168: and t_source_id_int_1(i) = g_data_set_id;

Line 2173: Update pa_budget_lines

2169:
2170: If g_bvid_to_reverse is NOT NULL then
2171:
2172: forall i in t_source_id_int_1.FIRST..t_source_id_int_1.LAST
2173: Update pa_budget_lines
2174: set bc_rev_event_id = t_event_id(i)
2175: where budget_version_id = t_source_id_int_1(i)
2176: and start_date = t_event_date(i)
2177: and t_source_id_int_1(i) = g_bvid_to_reverse;