APPS.PSB_WORKSHEET dependencies on PSB_WS_ACCT1

Line 299: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp

295: select Count(*) count_bg1,
296: Max(last_update_date) lud_bg1
297: from PSB_BUDGET_GROUPS
298: where budget_group_type = 'R'
299: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
300: and (effective_end_date is null or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)
301: start with budget_group_id = p_budget_group_id
302: connect by prior budget_group_id = parent_budget_group_id;
303:

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

296: Max(last_update_date) lud_bg1
297: from PSB_BUDGET_GROUPS
298: where budget_group_type = 'R'
299: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
300: and (effective_end_date is null or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)
301: start with budget_group_id = p_budget_group_id
302: connect by prior budget_group_id = parent_budget_group_id;
303:
304: cursor c_bg2 is

Line 312: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp

308: where budget_group_id in
309: (select budget_group_id
310: from PSB_BUDGET_GROUPS
311: where budget_group_type = 'R'
312: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
313: and (effective_end_date is null or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)
314: start with budget_group_id = p_budget_group_id
315: connect by prior budget_group_id = parent_budget_group_id);
316:

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

309: (select budget_group_id
310: from PSB_BUDGET_GROUPS
311: where budget_group_type = 'R'
312: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
313: and (effective_end_date is null or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)
314: start with budget_group_id = p_budget_group_id
315: connect by prior budget_group_id = parent_budget_group_id);
316:
317: cursor c_de is

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

732: raise FND_API.G_EXC_ERROR;
733: end if;*/
734: /*For Bug No : 2260391 End*/
735:
736: if g_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
737: begin
738:
739: PSB_WS_ACCT1.Cache_Budget_Calendar
740: (p_return_status => l_return_status,

Line 739: PSB_WS_ACCT1.Cache_Budget_Calendar

735:
736: if g_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
737: begin
738:
739: PSB_WS_ACCT1.Cache_Budget_Calendar
740: (p_return_status => l_return_status,
741: p_budget_calendar_id => g_budget_calendar_id);
742:
743: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

1210: delete from PSB_ERROR_MESSAGES
1211: where source_process = 'WORKSHEET_CREATION'
1212: and process_id = p_worksheet_id;
1213:
1214: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
1215: begin
1216:
1217: PSB_WS_ACCT1.Cache_Budget_Calendar
1218: (p_return_status => l_return_status,

Line 1217: PSB_WS_ACCT1.Cache_Budget_Calendar

1213:
1214: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
1215: begin
1216:
1217: PSB_WS_ACCT1.Cache_Budget_Calendar
1218: (p_return_status => l_return_status,
1219: p_budget_calendar_id => l_budget_calendar_id);
1220:
1221: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1228: PSB_WS_ACCT1.Apply_Account_Constraints

1224:
1225: end;
1226: end if;
1227:
1228: PSB_WS_ACCT1.Apply_Account_Constraints
1229: (p_return_status => l_return_status,
1230: p_validation_status => l_validation_status,
1231: p_worksheet_id => p_worksheet_id,
1232: p_flex_mapping_set_id => g_flex_mapping_set_id,

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

1544: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1545: raise FND_API.G_EXC_ERROR;
1546: end if;
1547:
1548: if g_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
1549: begin
1550:
1551: PSB_WS_ACCT1.Cache_Budget_Calendar
1552: (p_return_status => l_return_status,

Line 1551: PSB_WS_ACCT1.Cache_Budget_Calendar

1547:
1548: if g_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
1549: begin
1550:
1551: PSB_WS_ACCT1.Cache_Budget_Calendar
1552: (p_return_status => l_return_status,
1553: p_budget_calendar_id => g_budget_calendar_id);
1554:
1555: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

1778:
1779: if FND_API.to_Boolean(g_budget_by_position) then
1780: begin
1781:
1782: if g_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
1783: begin
1784:
1785: PSB_WS_ACCT1.Cache_Budget_Calendar
1786: (p_return_status => l_return_status,

Line 1785: PSB_WS_ACCT1.Cache_Budget_Calendar

1781:
1782: if g_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
1783: begin
1784:
1785: PSB_WS_ACCT1.Cache_Budget_Calendar
1786: (p_return_status => l_return_status,
1787: p_budget_calendar_id => g_budget_calendar_id);
1788:
1789: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

2018:
2019: if nvl(l_constraint_set_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
2020: begin
2021:
2022: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
2023: begin
2024:
2025: PSB_WS_ACCT1.Cache_Budget_Calendar
2026: (p_return_status => l_return_status,

Line 2025: PSB_WS_ACCT1.Cache_Budget_Calendar

2021:
2022: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
2023: begin
2024:
2025: PSB_WS_ACCT1.Cache_Budget_Calendar
2026: (p_return_status => l_return_status,
2027: p_budget_calendar_id => l_budget_calendar_id);
2028:
2029: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 2062: PSB_WS_ACCT1.Apply_Account_Constraints

2058: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2059: raise FND_API.G_EXC_ERROR;
2060: end if;
2061:
2062: PSB_WS_ACCT1.Apply_Account_Constraints
2063: (p_return_status => l_return_status,
2064: p_validation_status => l_validation_status,
2065: p_worksheet_id => p_worksheet_id,
2066: p_flex_mapping_set_id => g_flex_mapping_set_id,

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

2228:
2229: if nvl(l_constraint_set_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
2230: begin
2231:
2232: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
2233: begin
2234:
2235: PSB_WS_ACCT1.Cache_Budget_Calendar
2236: (p_return_status => l_return_status,

Line 2235: PSB_WS_ACCT1.Cache_Budget_Calendar

2231:
2232: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
2233: begin
2234:
2235: PSB_WS_ACCT1.Cache_Budget_Calendar
2236: (p_return_status => l_return_status,
2237: p_budget_calendar_id => l_budget_calendar_id);
2238:
2239: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

2445:
2446: if nvl(l_constraint_set_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
2447: begin
2448:
2449: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
2450: begin
2451:
2452: PSB_WS_ACCT1.Cache_Budget_Calendar
2453: (p_return_status => l_return_status,

Line 2452: PSB_WS_ACCT1.Cache_Budget_Calendar

2448:
2449: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
2450: begin
2451:
2452: PSB_WS_ACCT1.Cache_Budget_Calendar
2453: (p_return_status => l_return_status,
2454: p_budget_calendar_id => l_budget_calendar_id);
2455:
2456: if l_return_status <> FND_API.G_RET_STS_SUCCESS then