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

Line 67: g_monthly_profile PSB_WS_ACCT1.g_prdamt_tbl_type;

63:
64: g_poswkh_assignments g_poswkh_tbl_type;
65: g_num_poswkh_assignments NUMBER;
66:
67: g_monthly_profile PSB_WS_ACCT1.g_prdamt_tbl_type;
68: g_num_monthly_profile NUMBER := 0;
69:
70: g_quarterly_profile PSB_WS_ACCT1.g_prdamt_tbl_type;
71: g_num_quarterly_profile NUMBER := 0;

Line 70: g_quarterly_profile PSB_WS_ACCT1.g_prdamt_tbl_type;

66:
67: g_monthly_profile PSB_WS_ACCT1.g_prdamt_tbl_type;
68: g_num_monthly_profile NUMBER := 0;
69:
70: g_quarterly_profile PSB_WS_ACCT1.g_prdamt_tbl_type;
71: g_num_quarterly_profile NUMBER := 0;
72:
73: g_semiannual_profile PSB_WS_ACCT1.g_prdamt_tbl_type;
74: g_num_semiannual_profile NUMBER := 0;

Line 73: g_semiannual_profile PSB_WS_ACCT1.g_prdamt_tbl_type;

69:
70: g_quarterly_profile PSB_WS_ACCT1.g_prdamt_tbl_type;
71: g_num_quarterly_profile NUMBER := 0;
72:
73: g_semiannual_profile PSB_WS_ACCT1.g_prdamt_tbl_type;
74: g_num_semiannual_profile NUMBER := 0;
75:
76: TYPE g_posrecalc_rec_type IS RECORD
77: ( element_line_id NUMBER, pay_element_id NUMBER,

Line 279: where (((effective_start_date <= PSB_WS_ACCT1.g_end_est_date)

275: name,
276: effective_start_date,
277: effective_end_date
278: from PSB_POSITIONS
279: where (((effective_start_date <= PSB_WS_ACCT1.g_end_est_date)
280: and (effective_end_date is null))
281: or ((effective_start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
282: or (effective_end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
283: or ((effective_start_date < PSB_WS_ACCT1.g_startdate_cy)

Line 281: or ((effective_start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)

277: effective_end_date
278: from PSB_POSITIONS
279: where (((effective_start_date <= PSB_WS_ACCT1.g_end_est_date)
280: and (effective_end_date is null))
281: or ((effective_start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
282: or (effective_end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
283: or ((effective_start_date < PSB_WS_ACCT1.g_startdate_cy)
284: and (effective_end_date > PSB_WS_ACCT1.g_end_est_date))))
285: and business_group_id = p_business_group_id

Line 282: or (effective_end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)

278: from PSB_POSITIONS
279: where (((effective_start_date <= PSB_WS_ACCT1.g_end_est_date)
280: and (effective_end_date is null))
281: or ((effective_start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
282: or (effective_end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
283: or ((effective_start_date < PSB_WS_ACCT1.g_startdate_cy)
284: and (effective_end_date > PSB_WS_ACCT1.g_end_est_date))))
285: and business_group_id = p_business_group_id
286: and data_extract_id = p_data_extract_id;

Line 283: or ((effective_start_date < PSB_WS_ACCT1.g_startdate_cy)

279: where (((effective_start_date <= PSB_WS_ACCT1.g_end_est_date)
280: and (effective_end_date is null))
281: or ((effective_start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
282: or (effective_end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
283: or ((effective_start_date < PSB_WS_ACCT1.g_startdate_cy)
284: and (effective_end_date > PSB_WS_ACCT1.g_end_est_date))))
285: and business_group_id = p_business_group_id
286: and data_extract_id = p_data_extract_id;
287:

Line 284: and (effective_end_date > PSB_WS_ACCT1.g_end_est_date))))

280: and (effective_end_date is null))
281: or ((effective_start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
282: or (effective_end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
283: or ((effective_start_date < PSB_WS_ACCT1.g_startdate_cy)
284: and (effective_end_date > PSB_WS_ACCT1.g_end_est_date))))
285: and business_group_id = p_business_group_id
286: and data_extract_id = p_data_extract_id;
287:
288: BEGIN

Line 381: p_start_date => PSB_WS_ACCT1.g_startdate_cy,

377: p_flex_code => p_flex_code,
378: p_data_extract_id => p_data_extract_id,
379: p_position_id => c_Positions_Rec.position_id,
380: p_position_name => c_Positions_Rec.name,
381: p_start_date => PSB_WS_ACCT1.g_startdate_cy,
382: p_end_date => PSB_WS_ACCT1.g_end_est_date);
383:
384: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
385: raise FND_API.G_EXC_ERROR;

Line 382: p_end_date => PSB_WS_ACCT1.g_end_est_date);

378: p_data_extract_id => p_data_extract_id,
379: p_position_id => c_Positions_Rec.position_id,
380: p_position_name => c_Positions_Rec.name,
381: p_start_date => PSB_WS_ACCT1.g_startdate_cy,
382: p_end_date => PSB_WS_ACCT1.g_end_est_date);
383:
384: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
385: raise FND_API.G_EXC_ERROR;
386: end if;

Line 434: if l_num_positions > PSB_WS_ACCT1.g_checkpoint_save then

430: end if;
431:
432: l_num_positions := l_num_positions + 1;
433:
434: if l_num_positions > PSB_WS_ACCT1.g_checkpoint_save then
435: commit work;
436: l_num_positions := 0;
437: end if;
438:

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

870: if nvl(p_position_end_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE then
871: l_position_end_date := p_position_end_date;
872: end if;
873:
874: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
875: begin
876:
877: PSB_WS_ACCT1.Cache_Budget_Calendar
878: (p_return_status => l_return_status,

Line 877: PSB_WS_ACCT1.Cache_Budget_Calendar

873:
874: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
875: begin
876:
877: PSB_WS_ACCT1.Cache_Budget_Calendar
878: (p_return_status => l_return_status,
879: p_budget_calendar_id => l_budget_calendar_id);
880:
881: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

884:
885: end;
886: end if;
887:
888: l_start_date := greatest(PSB_WS_ACCT1.g_startdate_cy, l_position_start_date);
889: l_end_date := least(PSB_WS_ACCT1.g_end_est_date, nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date));
890:
891: if FND_API.to_Boolean(p_recalculate_flag) then
892: begin

Line 889: l_end_date := least(PSB_WS_ACCT1.g_end_est_date, nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date));

885: end;
886: end if;
887:
888: l_start_date := greatest(PSB_WS_ACCT1.g_startdate_cy, l_position_start_date);
889: l_end_date := least(PSB_WS_ACCT1.g_end_est_date, nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date));
890:
891: if FND_API.to_Boolean(p_recalculate_flag) then
892: begin
893:

Line 1137: FOR l_year_index IN 1..PSB_WS_ACCT1.g_num_budget_years LOOP

1133:
1134: -- the following IF clause is added as part of bug fix#4379636
1135: IF P_BUDGET_YEAR_ID IS NOT NULL THEN
1136:
1137: FOR l_year_index IN 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1138:
1139: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP')
1140: and PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
1141: begin

Line 1139: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP')

1135: IF P_BUDGET_YEAR_ID IS NOT NULL THEN
1136:
1137: FOR l_year_index IN 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1138:
1139: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP')
1140: and PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
1141: begin
1142:
1143: Calculate_Position_Cost_Year

Line 1140: and PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then

1136:
1137: FOR l_year_index IN 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1138:
1139: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP')
1140: and PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
1141: begin
1142:
1143: Calculate_Position_Cost_Year
1144: (p_return_status => l_return_status,

Line 1151: p_year_start_date => PSB_WS_ACCT1.g_budget_years(l_year_index).start_date,

1147: p_position_line_id => p_position_line_id,
1148: p_position_id => l_position_id,
1149: p_position_name => l_position_name,
1150: p_budget_year_id => p_budget_year_id,
1151: p_year_start_date => PSB_WS_ACCT1.g_budget_years(l_year_index).start_date,
1152: p_year_end_date => PSB_WS_ACCT1.g_budget_years(l_year_index).end_date);
1153:
1154: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1155: raise FND_API.G_EXC_ERROR;

Line 1152: p_year_end_date => PSB_WS_ACCT1.g_budget_years(l_year_index).end_date);

1148: p_position_id => l_position_id,
1149: p_position_name => l_position_name,
1150: p_budget_year_id => p_budget_year_id,
1151: p_year_start_date => PSB_WS_ACCT1.g_budget_years(l_year_index).start_date,
1152: p_year_end_date => PSB_WS_ACCT1.g_budget_years(l_year_index).end_date);
1153:
1154: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1155: raise FND_API.G_EXC_ERROR;
1156: end if;

Line 1165: FOR l_year_index IN 1..PSB_WS_ACCT1.g_num_budget_years LOOP

1161: END LOOP;
1162:
1163: ELSE
1164:
1165: FOR l_year_index IN 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1166:
1167: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
1168: begin
1169:

Line 1167: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then

1163: ELSE
1164:
1165: FOR l_year_index IN 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1166:
1167: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
1168: begin
1169:
1170: Calculate_Position_Cost_Year
1171: (p_return_status => l_return_status,

Line 1177: p_budget_year_id => PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id,

1173: p_business_group_id => l_business_group_id,
1174: p_position_line_id => p_position_line_id,
1175: p_position_id => l_position_id,
1176: p_position_name => l_position_name,
1177: p_budget_year_id => PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id,
1178: p_year_start_date => PSB_WS_ACCT1.g_budget_years(l_year_index).start_date,
1179: p_year_end_date => PSB_WS_ACCT1.g_budget_years(l_year_index).end_date);
1180:
1181: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1178: p_year_start_date => PSB_WS_ACCT1.g_budget_years(l_year_index).start_date,

1174: p_position_line_id => p_position_line_id,
1175: p_position_id => l_position_id,
1176: p_position_name => l_position_name,
1177: p_budget_year_id => PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id,
1178: p_year_start_date => PSB_WS_ACCT1.g_budget_years(l_year_index).start_date,
1179: p_year_end_date => PSB_WS_ACCT1.g_budget_years(l_year_index).end_date);
1180:
1181: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1182: raise FND_API.G_EXC_ERROR;

Line 1179: p_year_end_date => PSB_WS_ACCT1.g_budget_years(l_year_index).end_date);

1175: p_position_id => l_position_id,
1176: p_position_name => l_position_name,
1177: p_budget_year_id => PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id,
1178: p_year_start_date => PSB_WS_ACCT1.g_budget_years(l_year_index).start_date,
1179: p_year_end_date => PSB_WS_ACCT1.g_budget_years(l_year_index).end_date);
1180:
1181: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1182: raise FND_API.G_EXC_ERROR;
1183: end if;

Line 1194: FOR l_year_index IN 1..PSB_WS_ACCT1.g_num_budget_years LOOP

1190:
1191: -- the following IF clause is added as part of bug fix#4379636
1192: IF P_BUDGET_YEAR_ID IS NOT NULL THEN
1193:
1194: FOR l_year_index IN 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1195:
1196: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') AND
1197: PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN
1198: begin

Line 1196: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') AND

1192: IF P_BUDGET_YEAR_ID IS NOT NULL THEN
1193:
1194: FOR l_year_index IN 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1195:
1196: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') AND
1197: PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN
1198: begin
1199:
1200: l_start_date := greatest(PSB_WS_ACCT1.g_budget_years(l_year_index).start_date, l_position_start_date);

Line 1197: PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN

1193:
1194: FOR l_year_index IN 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1195:
1196: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') AND
1197: PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN
1198: begin
1199:
1200: l_start_date := greatest(PSB_WS_ACCT1.g_budget_years(l_year_index).start_date, l_position_start_date);
1201: l_end_date := least(PSB_WS_ACCT1.g_budget_years(l_year_index).end_date, nvl(l_position_end_date,

Line 1200: l_start_date := greatest(PSB_WS_ACCT1.g_budget_years(l_year_index).start_date, l_position_start_date);

1196: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') AND
1197: PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN
1198: begin
1199:
1200: l_start_date := greatest(PSB_WS_ACCT1.g_budget_years(l_year_index).start_date, l_position_start_date);
1201: l_end_date := least(PSB_WS_ACCT1.g_budget_years(l_year_index).end_date, nvl(l_position_end_date,
1202: PSB_WS_ACCT1.g_budget_years(l_year_index).end_date));
1203:
1204: Distribute_Position_Cost

Line 1201: l_end_date := least(PSB_WS_ACCT1.g_budget_years(l_year_index).end_date, nvl(l_position_end_date,

1197: PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN
1198: begin
1199:
1200: l_start_date := greatest(PSB_WS_ACCT1.g_budget_years(l_year_index).start_date, l_position_start_date);
1201: l_end_date := least(PSB_WS_ACCT1.g_budget_years(l_year_index).end_date, nvl(l_position_end_date,
1202: PSB_WS_ACCT1.g_budget_years(l_year_index).end_date));
1203:
1204: Distribute_Position_Cost
1205: (p_return_status => l_return_status,

Line 1202: PSB_WS_ACCT1.g_budget_years(l_year_index).end_date));

1198: begin
1199:
1200: l_start_date := greatest(PSB_WS_ACCT1.g_budget_years(l_year_index).start_date, l_position_start_date);
1201: l_end_date := least(PSB_WS_ACCT1.g_budget_years(l_year_index).end_date, nvl(l_position_end_date,
1202: PSB_WS_ACCT1.g_budget_years(l_year_index).end_date));
1203:
1204: Distribute_Position_Cost
1205: (p_return_status => l_return_status,
1206: p_root_budget_group_id => l_root_budget_group_id,

Line 1228: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP

1224: END LOOP;
1225:
1226: ELSE
1227:
1228: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1229:
1230: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
1231: begin
1232:

Line 1230: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then

1226: ELSE
1227:
1228: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1229:
1230: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
1231: begin
1232:
1233: l_start_date := greatest(PSB_WS_ACCT1.g_budget_years(l_year_index).start_date, l_position_start_date);
1234: l_end_date := least(PSB_WS_ACCT1.g_budget_years(l_year_index).end_date, nvl(l_position_end_date,

Line 1233: l_start_date := greatest(PSB_WS_ACCT1.g_budget_years(l_year_index).start_date, l_position_start_date);

1229:
1230: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
1231: begin
1232:
1233: l_start_date := greatest(PSB_WS_ACCT1.g_budget_years(l_year_index).start_date, l_position_start_date);
1234: l_end_date := least(PSB_WS_ACCT1.g_budget_years(l_year_index).end_date, nvl(l_position_end_date,
1235: PSB_WS_ACCT1.g_budget_years(l_year_index).end_date));
1236:
1237: Distribute_Position_Cost

Line 1234: l_end_date := least(PSB_WS_ACCT1.g_budget_years(l_year_index).end_date, nvl(l_position_end_date,

1230: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
1231: begin
1232:
1233: l_start_date := greatest(PSB_WS_ACCT1.g_budget_years(l_year_index).start_date, l_position_start_date);
1234: l_end_date := least(PSB_WS_ACCT1.g_budget_years(l_year_index).end_date, nvl(l_position_end_date,
1235: PSB_WS_ACCT1.g_budget_years(l_year_index).end_date));
1236:
1237: Distribute_Position_Cost
1238: (p_return_status => l_return_status,

Line 1235: PSB_WS_ACCT1.g_budget_years(l_year_index).end_date));

1231: begin
1232:
1233: l_start_date := greatest(PSB_WS_ACCT1.g_budget_years(l_year_index).start_date, l_position_start_date);
1234: l_end_date := least(PSB_WS_ACCT1.g_budget_years(l_year_index).end_date, nvl(l_position_end_date,
1235: PSB_WS_ACCT1.g_budget_years(l_year_index).end_date));
1236:
1237: Distribute_Position_Cost
1238: (p_return_status => l_return_status,
1239: p_root_budget_group_id => l_root_budget_group_id,

Line 1246: p_budget_year_id => PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id,

1242: p_data_extract_id => l_data_extract_id,
1243: p_business_group_id => l_business_group_id,
1244: p_position_id => l_position_id,
1245: p_position_line_id => p_position_line_id,
1246: p_budget_year_id => PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id,
1247: p_start_date => l_start_date,
1248: p_end_date => l_end_date);
1249:
1250: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1280: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP

1276:
1277: -- the following IF clause is added as part of bug fix#4379636
1278: IF p_budget_year_id IS NOT NULL THEN
1279:
1280: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1281:
1282: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') AND
1283: PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN
1284:

Line 1282: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') AND

1278: IF p_budget_year_id IS NOT NULL THEN
1279:
1280: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1281:
1282: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') AND
1283: PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN
1284:
1285: begin
1286:

Line 1283: PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN

1279:
1280: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1281:
1282: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') AND
1283: PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN
1284:
1285: begin
1286:
1287: l_num_budget_years := least(ceil(months_between(nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date),

Line 1287: l_num_budget_years := least(ceil(months_between(nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date),

1283: PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN
1284:
1285: begin
1286:
1287: l_num_budget_years := least(ceil(months_between(nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date),
1288: nvl(l_position_start_date, PSB_WS_ACCT1.g_startdate_pp)) / 12),
1289: nvl(greatest(nvl(l_ws_num_years, 0), nvl(PSB_WS_POS1.g_budget_group_numyrs, 0)),
1290: PSB_WS_ACCT1.g_max_num_years));
1291:

Line 1288: nvl(l_position_start_date, PSB_WS_ACCT1.g_startdate_pp)) / 12),

1284:
1285: begin
1286:
1287: l_num_budget_years := least(ceil(months_between(nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date),
1288: nvl(l_position_start_date, PSB_WS_ACCT1.g_startdate_pp)) / 12),
1289: nvl(greatest(nvl(l_ws_num_years, 0), nvl(PSB_WS_POS1.g_budget_group_numyrs, 0)),
1290: PSB_WS_ACCT1.g_max_num_years));
1291:
1292: if (l_num_proposed_years < (l_num_budget_years + 1)) then

Line 1290: PSB_WS_ACCT1.g_max_num_years));

1286:
1287: l_num_budget_years := least(ceil(months_between(nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date),
1288: nvl(l_position_start_date, PSB_WS_ACCT1.g_startdate_pp)) / 12),
1289: nvl(greatest(nvl(l_ws_num_years, 0), nvl(PSB_WS_POS1.g_budget_group_numyrs, 0)),
1290: PSB_WS_ACCT1.g_max_num_years));
1291:
1292: if (l_num_proposed_years < (l_num_budget_years + 1)) then
1293: begin
1294: -- bug 3446226 passed l_fte_start_date and l_fte_end_date instead of

Line 1330: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP

1326: end loop;
1327:
1328: ELSE
1329:
1330: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1331:
1332: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') THEN
1333: BEGIN
1334:

Line 1332: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') THEN

1328: ELSE
1329:
1330: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
1331:
1332: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') THEN
1333: BEGIN
1334:
1335: l_num_budget_years := least(ceil(months_between(nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date),
1336: nvl(l_position_start_date, PSB_WS_ACCT1.g_startdate_pp)) / 12),

Line 1335: l_num_budget_years := least(ceil(months_between(nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date),

1331:
1332: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') THEN
1333: BEGIN
1334:
1335: l_num_budget_years := least(ceil(months_between(nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date),
1336: nvl(l_position_start_date, PSB_WS_ACCT1.g_startdate_pp)) / 12),
1337: nvl(greatest(nvl(l_ws_num_years, 0), nvl(PSB_WS_POS1.g_budget_group_numyrs, 0)),
1338: PSB_WS_ACCT1.g_max_num_years));
1339:

Line 1336: nvl(l_position_start_date, PSB_WS_ACCT1.g_startdate_pp)) / 12),

1332: IF PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') THEN
1333: BEGIN
1334:
1335: l_num_budget_years := least(ceil(months_between(nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date),
1336: nvl(l_position_start_date, PSB_WS_ACCT1.g_startdate_pp)) / 12),
1337: nvl(greatest(nvl(l_ws_num_years, 0), nvl(PSB_WS_POS1.g_budget_group_numyrs, 0)),
1338: PSB_WS_ACCT1.g_max_num_years));
1339:
1340: if (l_num_proposed_years < (l_num_budget_years + 1)) then

Line 1338: PSB_WS_ACCT1.g_max_num_years));

1334:
1335: l_num_budget_years := least(ceil(months_between(nvl(l_position_end_date, PSB_WS_ACCT1.g_end_est_date),
1336: nvl(l_position_start_date, PSB_WS_ACCT1.g_startdate_pp)) / 12),
1337: nvl(greatest(nvl(l_ws_num_years, 0), nvl(PSB_WS_POS1.g_budget_group_numyrs, 0)),
1338: PSB_WS_ACCT1.g_max_num_years));
1339:
1340: if (l_num_proposed_years < (l_num_budget_years + 1)) then
1341: begin
1342: -- bug 3446226 passed l_fte_start_date and l_fte_end_date instead of

Line 1359: p_budget_year_id => PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id,

1355: p_service_package_id => l_service_package_id,
1356: p_stage_set_id => l_stage_set_id,
1357: p_start_stage_seq => l_start_stage_seq,
1358: p_current_stage_seq => l_current_stage_seq,
1359: p_budget_year_id => PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id,
1360: p_budget_group_id => PSB_WS_POS1.g_salary_budget_group_id);
1361:
1362: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1363: raise FND_API.G_EXC_ERROR;

Line 1510: l_salary_indexes PSB_WS_ACCT1.g_prdamt_tbl_type;

1506:
1507: l_processing_type VARCHAR2(1);
1508: l_nonrec_calculated VARCHAR2(1);
1509:
1510: l_salary_indexes PSB_WS_ACCT1.g_prdamt_tbl_type;
1511: l_num_salary_indexes NUMBER;
1512:
1513: l_return_status VARCHAR2(1);
1514: l_msg_data VARCHAR2(2000);

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

1525: l_api_name CONSTANT VARCHAR2(30) := 'Calculate_Position_Cost_Year';
1526:
1527: BEGIN
1528:
1529: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
1530:
1531: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
1532: l_last_period_index := PSB_WS_ACCT1.g_budget_years(l_year_index).last_period_index;
1533: exit;

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

1527: BEGIN
1528:
1529: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
1530:
1531: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
1532: l_last_period_index := PSB_WS_ACCT1.g_budget_years(l_year_index).last_period_index;
1533: exit;
1534: end if;
1535:

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

1528:
1529: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
1530:
1531: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
1532: l_last_period_index := PSB_WS_ACCT1.g_budget_years(l_year_index).last_period_index;
1533: exit;
1534: end if;
1535:
1536: end loop;

Line 1538: for l_salary_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

1534: end if;
1535:
1536: end loop;
1537:
1538: for l_salary_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
1539: l_salary_indexes(l_salary_index) := null;
1540: end loop;
1541:
1542: l_num_salary_indexes := 0;

Line 1573: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years

1569: if FND_API.to_Boolean(l_element_assigned) then
1570: begin
1571:
1572: /* Bug 5065066 Start */
1573: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years
1574: LOOP
1575: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
1576: = p_budget_year_id THEN
1577: l_year_start_date

Line 1575: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id

1571:
1572: /* Bug 5065066 Start */
1573: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years
1574: LOOP
1575: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
1576: = p_budget_year_id THEN
1577: l_year_start_date
1578: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
1579: END IF;

Line 1578: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;

1574: LOOP
1575: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
1576: = p_budget_year_id THEN
1577: l_year_start_date
1578: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
1579: END IF;
1580: END LOOP;
1581: /* Bug 5065066 End */
1582:

Line 1588: FOR l_period_index IN 1..PSB_WS_ACCT1.g_num_budget_periods

1584: /* Bug 5065066 Start */
1585: -- l_assign_period_index := 1;
1586: IF l_year_start_date < g_pos_start_date THEN
1587: l_period_ctr := 0;
1588: FOR l_period_index IN 1..PSB_WS_ACCT1.g_num_budget_periods
1589: LOOP
1590: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
1591: p_budget_year_id THEN
1592: l_period_ctr := l_period_ctr +1 ;

Line 1590: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =

1586: IF l_year_start_date < g_pos_start_date THEN
1587: l_period_ctr := 0;
1588: FOR l_period_index IN 1..PSB_WS_ACCT1.g_num_budget_periods
1589: LOOP
1590: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
1591: p_budget_year_id THEN
1592: l_period_ctr := l_period_ctr +1 ;
1593: END IF;
1594:

Line 1595: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =

1591: p_budget_year_id THEN
1592: l_period_ctr := l_period_ctr +1 ;
1593: END IF;
1594:
1595: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
1596: p_budget_year_id AND
1597: g_pos_start_date BETWEEN
1598: PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date AND
1599: PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date THEN

Line 1598: PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date AND

1594:
1595: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
1596: p_budget_year_id AND
1597: g_pos_start_date BETWEEN
1598: PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date AND
1599: PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date THEN
1600:
1601: l_assign_period_index := l_period_ctr;
1602: END IF;

Line 1599: PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date THEN

1595: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
1596: p_budget_year_id AND
1597: g_pos_start_date BETWEEN
1598: PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date AND
1599: PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date THEN
1600:
1601: l_assign_period_index := l_period_ctr;
1602: END IF;
1603: END LOOP;

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

1621:
1622: l_calculate_from_salary := FND_API.G_FALSE;
1623: l_assign_period := FND_API.G_FALSE;
1624:
1625: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
1626:
1627: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = p_budget_year_id then
1628: begin
1629:

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

1623: l_assign_period := FND_API.G_FALSE;
1624:
1625: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
1626:
1627: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = p_budget_year_id then
1628: begin
1629:
1630: l_element_cost := 0;
1631:

Line 1632: l_long_index := PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no;

1628: begin
1629:
1630: l_element_cost := 0;
1631:
1632: l_long_index := PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no;
1633: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;
1634: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
1635:
1636: for l_calcperiod_index in 1..PSB_WS_ACCT1.g_num_calc_periods loop

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

1629:
1630: l_element_cost := 0;
1631:
1632: l_long_index := PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no;
1633: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;
1634: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
1635:
1636: for l_calcperiod_index in 1..PSB_WS_ACCT1.g_num_calc_periods loop
1637:

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

1630: l_element_cost := 0;
1631:
1632: l_long_index := PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no;
1633: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;
1634: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
1635:
1636: for l_calcperiod_index in 1..PSB_WS_ACCT1.g_num_calc_periods loop
1637:
1638: if ((PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).budget_period_id = l_budget_period_id) and

Line 1636: for l_calcperiod_index in 1..PSB_WS_ACCT1.g_num_calc_periods loop

1632: l_long_index := PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no;
1633: l_budget_period_id := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_id;
1634: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
1635:
1636: for l_calcperiod_index in 1..PSB_WS_ACCT1.g_num_calc_periods loop
1637:
1638: if ((PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).budget_period_id = l_budget_period_id) and
1639: ((l_processing_type = 'R') or
1640: ((l_processing_type = 'N') and (not FND_API.to_Boolean(l_nonrec_calculated))))) then

Line 1638: if ((PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).budget_period_id = l_budget_period_id) and

1634: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
1635:
1636: for l_calcperiod_index in 1..PSB_WS_ACCT1.g_num_calc_periods loop
1637:
1638: if ((PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).budget_period_id = l_budget_period_id) and
1639: ((l_processing_type = 'R') or
1640: ((l_processing_type = 'N') and (not FND_API.to_Boolean(l_nonrec_calculated))))) then
1641: begin
1642:

Line 1649: l_calc_period_type := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).calc_period_type;

1645:
1646: -- for bug 2622404
1647: l_nonelm_calc_flag := fnd_api.g_false;
1648:
1649: l_calc_period_type := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).calc_period_type;
1650: l_calc_start_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).start_date;
1651: l_calc_end_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).end_date;
1652:
1653: /*For Bug No : 2811698 Start*/

Line 1650: l_calc_start_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).start_date;

1646: -- for bug 2622404
1647: l_nonelm_calc_flag := fnd_api.g_false;
1648:
1649: l_calc_period_type := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).calc_period_type;
1650: l_calc_start_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).start_date;
1651: l_calc_end_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).end_date;
1652:
1653: /*For Bug No : 2811698 Start*/
1654: --commented the following code as this is moved to other place

Line 1651: l_calc_end_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).end_date;

1647: l_nonelm_calc_flag := fnd_api.g_false;
1648:
1649: l_calc_period_type := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).calc_period_type;
1650: l_calc_start_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).start_date;
1651: l_calc_end_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).end_date;
1652:
1653: /*For Bug No : 2811698 Start*/
1654: --commented the following code as this is moved to other place
1655: /*if l_calc_period_type = 'M' and g_num_monthly_profile > 0 then

Line 3782: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

3778: a.period_num;
3779:
3780: BEGIN
3781:
3782: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
3783: g_monthly_profile(l_init_index) := null;
3784: g_quarterly_profile(l_init_index) := null;
3785: g_semiannual_profile(l_init_index) := null;
3786: end loop;

Line 3797: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

3793:
3794: if c_Monthly_Profile_Rec.entity_id <> nvl(l_entity_id, FND_API.G_MISS_NUM) then
3795: begin
3796:
3797: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
3798: g_monthly_profile(l_init_index) := null;
3799: end loop;
3800:
3801: g_num_monthly_profile := 0;

Line 3820: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

3816:
3817: if c_Quarterly_Profile_Rec.entity_id <> nvl(l_entity_id, FND_API.G_MISS_NUM) then
3818: begin
3819:
3820: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
3821: g_quarterly_profile(l_init_index) := null;
3822: end loop;
3823:
3824: g_num_quarterly_profile := 0;

Line 3843: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

3839:
3840: if c_Semiannual_Profile_Rec.entity_id <> nvl(l_entity_id, FND_API.G_MISS_NUM) then
3841: begin
3842:
3843: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
3844: g_semiannual_profile(l_init_index) := null;
3845: end loop;
3846:
3847: g_num_semiannual_profile := 0;

Line 4497: l_period_fte PSB_WS_ACCT1.g_prdamt_tbl_type;

4493: l_budget_period_type VARCHAR2(1);
4494: l_long_sequence_no NUMBER;
4495:
4496: l_annual_fte NUMBER;
4497: l_period_fte PSB_WS_ACCT1.g_prdamt_tbl_type;
4498: l_num_budget_periods NUMBER;
4499:
4500: l_fte_line_id NUMBER;
4501: l_element_line_id NUMBER;

Line 4509: l_period_amount PSB_WS_ACCT1.g_prdamt_tbl_type;

4505: l_position_exists VARCHAR2(1);
4506:
4507: l_sal_account_line VARCHAR2(1);
4508:
4509: l_period_amount PSB_WS_ACCT1.g_prdamt_tbl_type;
4510:
4511: l_fte_index BINARY_INTEGER;
4512: l_elemcost_index BINARY_INTEGER;
4513: l_element_index BINARY_INTEGER;

Line 4635: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

4631: end loop;
4632:
4633: l_annual_fte := 0;
4634:
4635: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
4636: l_period_fte(l_init_index) := null;
4637: end loop;
4638:
4639: for l_elemcost_index in 1..PSB_WS_POS1.g_num_pc_costs loop

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

4648:
4649: if l_year_calculated then
4650: begin
4651:
4652: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
4653:
4654: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
4655: l_num_budget_periods := PSB_WS_ACCT1.g_budget_years(l_year_index).num_budget_periods;
4656: l_budget_year_name := PSB_WS_ACCT1.g_budget_years(l_year_index).year_name; -- Bug#4571412

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

4650: begin
4651:
4652: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
4653:
4654: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
4655: l_num_budget_periods := PSB_WS_ACCT1.g_budget_years(l_year_index).num_budget_periods;
4656: l_budget_year_name := PSB_WS_ACCT1.g_budget_years(l_year_index).year_name; -- Bug#4571412
4657: end if;
4658:

Line 4655: l_num_budget_periods := PSB_WS_ACCT1.g_budget_years(l_year_index).num_budget_periods;

4651:
4652: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
4653:
4654: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
4655: l_num_budget_periods := PSB_WS_ACCT1.g_budget_years(l_year_index).num_budget_periods;
4656: l_budget_year_name := PSB_WS_ACCT1.g_budget_years(l_year_index).year_name; -- Bug#4571412
4657: end if;
4658:
4659: end loop;

Line 4656: l_budget_year_name := PSB_WS_ACCT1.g_budget_years(l_year_index).year_name; -- Bug#4571412

4652: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
4653:
4654: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
4655: l_num_budget_periods := PSB_WS_ACCT1.g_budget_years(l_year_index).num_budget_periods;
4656: l_budget_year_name := PSB_WS_ACCT1.g_budget_years(l_year_index).year_name; -- Bug#4571412
4657: end if;
4658:
4659: end loop;
4660:

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

4657: end if;
4658:
4659: end loop;
4660:
4661: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
4662:
4663: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = p_budget_year_id then
4664: begin
4665:

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

4659: end loop;
4660:
4661: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
4662:
4663: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = p_budget_year_id then
4664: begin
4665:
4666: l_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4667: l_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

Line 4666: l_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

4662:
4663: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = p_budget_year_id then
4664: begin
4665:
4666: l_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4667: l_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4668: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
4669: l_long_sequence_no := PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no;
4670:

Line 4667: l_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

4663: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = p_budget_year_id then
4664: begin
4665:
4666: l_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4667: l_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4668: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
4669: l_long_sequence_no := PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no;
4670:
4671: l_fte_assigned := FND_API.G_FALSE;

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

4664: begin
4665:
4666: l_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4667: l_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4668: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
4669: l_long_sequence_no := PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no;
4670:
4671: l_fte_assigned := FND_API.G_FALSE;
4672:

Line 4669: l_long_sequence_no := PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no;

4665:
4666: l_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4667: l_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4668: l_budget_period_type := PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_period_type;
4669: l_long_sequence_no := PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no;
4670:
4671: l_fte_assigned := FND_API.G_FALSE;
4672:
4673: /*For Bug No : 2811698 Start*/

Line 4890: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

4886: begin
4887:
4888: l_elemdist_exists := TRUE;
4889:
4890: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
4891: l_period_amount(l_init_index) := null;
4892: end loop;
4893:
4894: l_period_amount(1) := PSB_WS_POS1.g_pd_costs(l_dist_index).period1_amount;

Line 4966: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

4962: -- with the current distribution for the position
4963:
4964: l_wal_index := null;
4965:
4966: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
4967: l_period_amount(l_init_index) := l_period_amount(l_init_index) * l_factor;
4968: end loop;
4969:
4970: l_old_ytd_amount := PSB_WS_POS1.g_pd_costs(l_dist_index).ytd_amount;

Line 4996: PSB_WS_ACCT1.Create_Account_Dist

4992:
4993: g_pd_recalc_costs(l_recalc_dist_index).redist_flag := 'Y';
4994: l_wal_index := l_recalc_dist_index;
4995:
4996: PSB_WS_ACCT1.Create_Account_Dist
4997: (p_api_version => 1.0,
4998: p_return_status => l_return_status,
4999: p_worksheet_id => p_worksheet_id,
5000: p_account_line_id => g_pd_recalc_costs(l_recalc_dist_index).account_line_id,

Line 5024: PSB_WS_ACCT1.Create_Note

5020:
5021: -- Bug#4571412.
5022: -- Added parameters to make the call in sync
5023: -- with its definition.
5024: PSB_WS_ACCT1.Create_Note
5025: ( p_return_status => l_return_status
5026: , p_account_line_id => g_pd_recalc_costs(l_recalc_dist_index).account_line_id
5027: , p_note => l_note
5028: , p_chart_of_accounts_id => PSB_WS_POS3.g_flex_code -- Bug#4675858

Line 5052: PSB_WS_ACCT1.Create_Account_Dist

5048:
5049: if l_wal_index is null then
5050: begin
5051:
5052: PSB_WS_ACCT1.Create_Account_Dist
5053: (p_api_version => 1.0,
5054: p_return_status => l_return_status,
5055: p_account_line_id => l_account_line_id,
5056: p_worksheet_id => p_worksheet_id,

Line 5224: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

5220: end if;
5221:
5222: end loop;
5223:
5224: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
5225: l_period_amount(l_init_index) := NULL;
5226: end loop;
5227:
5228: for l_recalc_dist_index in 1..g_num_pd_recalc_costs loop

Line 5233: PSB_WS_ACCT1.Create_Account_Dist

5229:
5230: if g_pd_recalc_costs(l_recalc_dist_index).redist_flag is null then
5231: begin
5232:
5233: PSB_WS_ACCT1.Create_Account_Dist
5234: (p_api_version => 1.0,
5235: p_return_status => l_return_status,
5236: p_worksheet_id => p_worksheet_id,
5237: p_account_line_id => g_pd_recalc_costs(l_recalc_dist_index).account_line_id,