eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_EXCEL_PVT dependencies on PSB_WS_ACCT1

Line 1508: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop

1504: l_element_value := NULL;
1505: -- Loop thru cached calendar to get start and end dates for the budget period
1506: l_year_period_num := 0;
1507:
1508: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
1509:
1510: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = p_budget_year_id then
1511: l_year_period_num := l_year_period_num + 1;
1512: IF l_year_period_num = l_period_num THEN

Line 1510: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = p_budget_year_id then

1506: l_year_period_num := 0;
1507:
1508: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
1509:
1510: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = p_budget_year_id then
1511: l_year_period_num := l_year_period_num + 1;
1512: IF l_year_period_num = l_period_num THEN
1513:
1514: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;

Line 1514: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;

1510: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = p_budget_year_id then
1511: l_year_period_num := l_year_period_num + 1;
1512: IF l_year_period_num = l_period_num THEN
1513:
1514: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;
1515: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
1516: l_budget_period_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
1517: l_budget_period_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
1518: exit;

Line 1515: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;

1511: l_year_period_num := l_year_period_num + 1;
1512: IF l_year_period_num = l_period_num THEN
1513:
1514: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;
1515: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
1516: l_budget_period_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
1517: l_budget_period_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
1518: exit;
1519: END IF;

Line 1516: l_budget_period_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

1512: IF l_year_period_num = l_period_num THEN
1513:
1514: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;
1515: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
1516: l_budget_period_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
1517: l_budget_period_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
1518: exit;
1519: END IF;
1520:

Line 1517: l_budget_period_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

1513:
1514: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;
1515: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
1516: l_budget_period_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
1517: l_budget_period_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
1518: exit;
1519: END IF;
1520:
1521: end if;

Line 1694: PSB_WS_ACCT1.Cache_Budget_Calendar

1690: p_cy_end_date => l_cy_end_date,
1691: p_pp_start_date => l_pp_start_date
1692: );
1693:
1694: PSB_WS_ACCT1.Cache_Budget_Calendar
1695: (p_return_status => l_return_status,
1696: p_budget_calendar_id => g_budget_calendar_id);
1697:
1698: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1796: l_start_date := greatest(PSB_WS_ACCT1.g_startdate_cy, l_position_start_date);

1792: l_position_start_date := c_Positions_Rec.effective_start_date;
1793: l_position_end_date := c_Positions_Rec.effective_end_date;
1794: end loop;
1795: -- this assumes the budget calendar is cached
1796: l_start_date := greatest(PSB_WS_ACCT1.g_startdate_cy, l_position_start_date);
1797: l_end_date := least(PSB_WS_ACCT1.g_end_est_date,
1798: nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date));
1799:
1800:

Line 1797: l_end_date := least(PSB_WS_ACCT1.g_end_est_date,

1793: l_position_end_date := c_Positions_Rec.effective_end_date;
1794: end loop;
1795: -- this assumes the budget calendar is cached
1796: l_start_date := greatest(PSB_WS_ACCT1.g_startdate_cy, l_position_start_date);
1797: l_end_date := least(PSB_WS_ACCT1.g_end_est_date,
1798: nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date));
1799:
1800:
1801: -- Get the postion data in PL/SQL tables for the effective date

Line 1798: nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date));

1794: end loop;
1795: -- this assumes the budget calendar is cached
1796: l_start_date := greatest(PSB_WS_ACCT1.g_startdate_cy, l_position_start_date);
1797: l_end_date := least(PSB_WS_ACCT1.g_end_est_date,
1798: nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date));
1799:
1800:
1801: -- Get the postion data in PL/SQL tables for the effective date
1802: Cache_Position_Data(p_return_status => l_return_status,