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_EXCEL2_PVT dependencies on PSB_WS_ACCT1

Line 80: g_fte_profile PSB_WS_ACCT1.g_prdamt_tbl_type;

76:
77: g_poswkh_assignments g_poswkh_tbl_type;
78: g_num_poswkh_assignments NUMBER;
79:
80: g_fte_profile PSB_WS_ACCT1.g_prdamt_tbl_type;
81: g_num_fte NUMBER;
82:
83: -- Storage structures from PSBVWP2B.pls end
84:

Line 547: PSB_WS_ACCT1.Cache_Budget_Calendar

543: raise FND_API.G_EXC_ERROR;
544: END IF;
545: END IF;
546:
547: PSB_WS_ACCT1.Cache_Budget_Calendar
548: (p_return_status => l_return_status,
549: p_budget_calendar_id => g_budget_calendar_id);
550:
551: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 812: l_period_amount PSB_WS_ACCT1.g_prdamt_tbl_type;

808: l_budget_group_id NUMBER;
809: ca_account_line_id NUMBER;
810: l_account_line_id NUMBER;
811:
812: l_period_amount PSB_WS_ACCT1.g_prdamt_tbl_type;
813: l_amount NUMBER;
814:
815: old_acct BOOLEAN;
816: new_acct BOOLEAN;

Line 931: FOR l_index in 1..PSB_WS_ACCT1.G_MAX_NUM_AMOUNTS LOOP

927:
928:
929: l_validation_status := FND_API.G_RET_STS_SUCCESS;
930: -- Initialize the table
931: FOR l_index in 1..PSB_WS_ACCT1.G_MAX_NUM_AMOUNTS LOOP
932: l_period_amount(l_index) := NULL;
933: END LOOP;
934:
935: -- Start the Validation process

Line 1413: l_period_amounts PSB_WS_ACCT1.g_prdamt_tbl_type;

1409: l_year_index BINARY_INTEGER;
1410: l_period_index BINARY_INTEGER;
1411: l_wlbi_index BINARY_INTEGER;
1412:
1413: l_period_amounts PSB_WS_ACCT1.g_prdamt_tbl_type;
1414: l_validation_status VARCHAR2(1) ;
1415: l_currency_flag VARCHAR2(1);
1416:
1417: l_return_status VARCHAR2(1);

Line 1459: FOR l_index in 1..PSB_WS_ACCT1.G_MAX_NUM_AMOUNTS LOOP

1455: BEGIN
1456: l_validation_status := FND_API.G_RET_STS_SUCCESS;
1457:
1458: -- Initialize the table
1459: FOR l_index in 1..PSB_WS_ACCT1.G_MAX_NUM_AMOUNTS LOOP
1460: l_period_amounts(l_index) := NULL;
1461: END LOOP;
1462:
1463: FOR wlbi_rec IN

Line 1761: FOR l_index in 1..PSB_WS_ACCT1.G_MAX_NUM_AMOUNTS LOOP

1757: LOOP
1758: -- Move the values to Update API's Input PL/SQL table
1759: l_period_index := 0;
1760: -- Initialize the table
1761: FOR l_index in 1..PSB_WS_ACCT1.G_MAX_NUM_AMOUNTS LOOP
1762: l_period_amounts(l_index) := NULL;
1763: END LOOP;
1764:
1765: l_period_start_column := g_estimate_years(l_year_index).period_start_column;

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

2301: l_position_end_date := c_Positions_Rec.effective_end_date;
2302: end loop;
2303:
2304: -- this assumes the budget calendar is cached
2305: l_start_date := greatest(PSB_WS_ACCT1.g_startdate_cy, l_position_start_date);
2306: l_end_date := least(PSB_WS_ACCT1.g_end_est_date,
2307: nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date));
2308:
2309: -- Get the postion data in PL/SQL tables for the effective date

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

2302: end loop;
2303:
2304: -- this assumes the budget calendar is cached
2305: l_start_date := greatest(PSB_WS_ACCT1.g_startdate_cy, l_position_start_date);
2306: l_end_date := least(PSB_WS_ACCT1.g_end_est_date,
2307: nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date));
2308:
2309: -- Get the postion data in PL/SQL tables for the effective date
2310: Cache_Position_Data(p_return_status => l_return_status,

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

2303:
2304: -- this assumes the budget calendar is cached
2305: l_start_date := greatest(PSB_WS_ACCT1.g_startdate_cy, l_position_start_date);
2306: l_end_date := least(PSB_WS_ACCT1.g_end_est_date,
2307: nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date));
2308:
2309: -- Get the postion data in PL/SQL tables for the effective date
2310: Cache_Position_Data(p_return_status => l_return_status,
2311: p_position_line_id => p_position_line_id,

Line 3243: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop

3239: end loop;
3240:
3241:
3242: -- Get the last period index
3243: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
3244:
3245: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
3246: l_last_period_index := PSB_WS_ACCT1.g_budget_years(l_year_index).last_period_index;
3247: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;

Line 3245: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then

3241:
3242: -- Get the last period index
3243: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
3244:
3245: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
3246: l_last_period_index := PSB_WS_ACCT1.g_budget_years(l_year_index).last_period_index;
3247: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
3248: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
3249:

Line 3246: l_last_period_index := PSB_WS_ACCT1.g_budget_years(l_year_index).last_period_index;

3242: -- Get the last period index
3243: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
3244:
3245: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
3246: l_last_period_index := PSB_WS_ACCT1.g_budget_years(l_year_index).last_period_index;
3247: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
3248: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
3249:
3250: exit;

Line 3247: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;

3243: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
3244:
3245: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
3246: l_last_period_index := PSB_WS_ACCT1.g_budget_years(l_year_index).last_period_index;
3247: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
3248: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
3249:
3250: exit;
3251: end if;

Line 3248: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;

3244:
3245: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
3246: l_last_period_index := PSB_WS_ACCT1.g_budget_years(l_year_index).last_period_index;
3247: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
3248: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
3249:
3250: exit;
3251: end if;
3252:

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

3303:
3304: -- Loop thru cached calendar to get start and end dates for the budget period
3305: l_year_period_num := 0;
3306:
3307: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
3308:
3309: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = p_budget_year_id then
3310: begin
3311: l_year_period_num := l_year_period_num + 1;

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

3305: l_year_period_num := 0;
3306:
3307: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
3308:
3309: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = p_budget_year_id then
3310: begin
3311: l_year_period_num := l_year_period_num + 1;
3312: IF l_year_period_num = l_period_num THEN
3313:

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

3310: begin
3311: l_year_period_num := l_year_period_num + 1;
3312: IF l_year_period_num = l_period_num THEN
3313:
3314: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;
3315: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
3316: l_budget_period_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
3317: l_budget_period_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
3318: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;

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

3311: l_year_period_num := l_year_period_num + 1;
3312: IF l_year_period_num = l_period_num THEN
3313:
3314: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;
3315: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
3316: l_budget_period_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
3317: l_budget_period_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
3318: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
3319: l_num_calc_periods := PSB_WS_ACCT1.g_budget_periods(l_period_index).num_calc_periods;

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

3312: IF l_year_period_num = l_period_num THEN
3313:
3314: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;
3315: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
3316: l_budget_period_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
3317: l_budget_period_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
3318: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
3319: l_num_calc_periods := PSB_WS_ACCT1.g_budget_periods(l_period_index).num_calc_periods;
3320:

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

3313:
3314: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;
3315: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
3316: l_budget_period_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
3317: l_budget_period_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
3318: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
3319: l_num_calc_periods := PSB_WS_ACCT1.g_budget_periods(l_period_index).num_calc_periods;
3320:
3321: END IF;

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

3314: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;
3315: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
3316: l_budget_period_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
3317: l_budget_period_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
3318: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
3319: l_num_calc_periods := PSB_WS_ACCT1.g_budget_periods(l_period_index).num_calc_periods;
3320:
3321: END IF;
3322: end;

Line 3319: l_num_calc_periods := PSB_WS_ACCT1.g_budget_periods(l_period_index).num_calc_periods;

3315: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
3316: l_budget_period_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
3317: l_budget_period_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
3318: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
3319: l_num_calc_periods := PSB_WS_ACCT1.g_budget_periods(l_period_index).num_calc_periods;
3320:
3321: END IF;
3322: end;
3323: end if;