APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_WS_ACCT1

Line 1936: l_period_amount PSB_WS_ACCT1.g_prdamt_tbl_type;

1932: p_local_worksheet_id IN NUMBER,
1933: p_global_worksheet_id IN NUMBER
1934: ) IS
1935:
1936: l_period_amount PSB_WS_ACCT1.g_prdamt_tbl_type;
1937: l_period_fte PSB_WS_ACCT1.g_prdamt_tbl_type;
1938:
1939: l_account_line_id NUMBER;
1940: l_position_line_id NUMBER;

Line 1937: l_period_fte PSB_WS_ACCT1.g_prdamt_tbl_type;

1933: p_global_worksheet_id IN NUMBER
1934: ) IS
1935:
1936: l_period_amount PSB_WS_ACCT1.g_prdamt_tbl_type;
1937: l_period_fte PSB_WS_ACCT1.g_prdamt_tbl_type;
1938:
1939: l_account_line_id NUMBER;
1940: l_position_line_id NUMBER;
1941: l_fte_line_id NUMBER;

Line 2067: PSB_WS_ACCT1.Create_Account_Dist

2063: for c_re_sp_rec in c_re_sp (c_wal_rec.service_package_id) loop
2064: l_service_package_id := c_re_sp_rec.service_package_id;
2065: end loop;
2066:
2067: PSB_WS_ACCT1.Create_Account_Dist
2068: (p_api_version => 1.0,
2069: p_return_status => l_return_status,
2070: p_account_line_id => l_account_line_id,
2071: p_worksheet_id => g_global_worksheet_id,

Line 2258: PSB_WS_ACCT1.Create_Account_Dist

2254: for c_re_sp_rec in c_re_sp (c_wal_rec.service_package_id) loop
2255: l_service_package_id := c_re_sp_rec.service_package_id;
2256: end loop;
2257:
2258: PSB_WS_ACCT1.Create_Account_Dist
2259: (p_api_version => 1.0,
2260: p_return_status => l_return_status,
2261: p_account_line_id => l_account_line_id,
2262: p_worksheet_id => g_global_worksheet_id,

Line 2627: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp

2623: select budget_group_id
2624: from PSB_BUDGET_GROUPS
2625: where budget_group_type = 'R'
2626: and budget_group_id = budgetgroup_id
2627: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
2628: and (effective_end_date is null or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)
2629: start with budget_group_id = l_budget_group_id
2630: connect by prior budget_group_id = parent_budget_group_id;
2631:

Line 2628: and (effective_end_date is null or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)

2624: from PSB_BUDGET_GROUPS
2625: where budget_group_type = 'R'
2626: and budget_group_id = budgetgroup_id
2627: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
2628: and (effective_end_date is null or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)
2629: start with budget_group_id = l_budget_group_id
2630: connect by prior budget_group_id = parent_budget_group_id;
2631:
2632:

Line 2661: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then

2657: add_message('PSB', 'PSB_TARGET_WORKSHEET_IS_FROZEN');
2658: raise FND_API.G_EXC_ERROR;
2659: end if;
2660:
2661: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
2662: begin
2663:
2664: PSB_WS_ACCT1.Cache_Budget_Calendar
2665: (p_return_status => l_return_status,

Line 2664: PSB_WS_ACCT1.Cache_Budget_Calendar

2660:
2661: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
2662: begin
2663:
2664: PSB_WS_ACCT1.Cache_Budget_Calendar
2665: (p_return_status => l_return_status,
2666: p_budget_calendar_id => l_budget_calendar_id);
2667:
2668: if l_return_status <> FND_API.G_RET_STS_SUCCESS then