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

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

2161: ) IS
2162: l_year_index NUMBER;
2163: BEGIN
2164: x_return_status := FND_API.G_RET_STS_SUCCESS;
2165: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
2166: IF p_input_date >=
2167: PSB_WS_ACCT1.g_budget_years(l_year_index).start_date
2168: AND
2169: p_input_date <=

Line 2167: PSB_WS_ACCT1.g_budget_years(l_year_index).start_date

2163: BEGIN
2164: x_return_status := FND_API.G_RET_STS_SUCCESS;
2165: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
2166: IF p_input_date >=
2167: PSB_WS_ACCT1.g_budget_years(l_year_index).start_date
2168: AND
2169: p_input_date <=
2170: PSB_WS_ACCT1.g_budget_years(l_year_index).end_date
2171: THEN

Line 2170: PSB_WS_ACCT1.g_budget_years(l_year_index).end_date

2166: IF p_input_date >=
2167: PSB_WS_ACCT1.g_budget_years(l_year_index).start_date
2168: AND
2169: p_input_date <=
2170: PSB_WS_ACCT1.g_budget_years(l_year_index).end_date
2171: THEN
2172: p_budget_year_start_date
2173: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
2174: p_budget_year_end_date

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

2169: p_input_date <=
2170: PSB_WS_ACCT1.g_budget_years(l_year_index).end_date
2171: THEN
2172: p_budget_year_start_date
2173: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
2174: p_budget_year_end_date
2175: := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
2176: /* Got the info so come out of the loop */
2177: EXIT;

Line 2175: := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;

2171: THEN
2172: p_budget_year_start_date
2173: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
2174: p_budget_year_end_date
2175: := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
2176: /* Got the info so come out of the loop */
2177: EXIT;
2178: END IF;
2179: END LOOP;

Line 2392: -- get the calendar start date from the cache used in package PSB_WS_ACCT1

2388: SAVEPOINT Upload_Salary_Position;
2389: l_debug_info := ' Upload Salary Distr API starts';
2390:
2391: -- for bug 4507389
2392: -- get the calendar start date from the cache used in package PSB_WS_ACCT1
2393: l_calendar_start_date := PSB_WS_ACCT1.g_budget_years(1).start_date;
2394:
2395:
2396: /* Bug 4060926 End */

Line 2393: l_calendar_start_date := PSB_WS_ACCT1.g_budget_years(1).start_date;

2389: l_debug_info := ' Upload Salary Distr API starts';
2390:
2391: -- for bug 4507389
2392: -- get the calendar start date from the cache used in package PSB_WS_ACCT1
2393: l_calendar_start_date := PSB_WS_ACCT1.g_budget_years(1).start_date;
2394:
2395:
2396: /* Bug 4060926 End */
2397: -- Get the upload budget year start date and end date

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

2396: /* Bug 4060926 End */
2397: -- Get the upload budget year start date and end date
2398:
2399: /*
2400: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
2401: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
2402: = p_from_budget_year_id THEN
2403: l_year_start_date
2404: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;

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

2397: -- Get the upload budget year start date and end date
2398:
2399: /*
2400: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
2401: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
2402: = p_from_budget_year_id THEN
2403: l_year_start_date
2404: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
2405: END IF;

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

2400: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
2401: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
2402: = p_from_budget_year_id THEN
2403: l_year_start_date
2404: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
2405: END IF;
2406:
2407: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
2408: = p_to_budget_year_id THEN

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

2403: l_year_start_date
2404: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
2405: END IF;
2406:
2407: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
2408: = p_to_budget_year_id THEN
2409: l_year_end_date
2410: := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
2411: END IF;

Line 2410: := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;

2406:
2407: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
2408: = p_to_budget_year_id THEN
2409: l_year_end_date
2410: := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
2411: END IF;
2412: END LOOP;
2413: */
2414:

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

3485:
3486: if p_flex_mapping_set_id is not null then
3487: begin
3488:
3489: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
3490:
3491: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
3492: begin
3493:

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

3487: begin
3488:
3489: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
3490:
3491: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
3492: begin
3493:
3494: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
3495: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;

Line 3494: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;

3490:
3491: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
3492: begin
3493:
3494: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
3495: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
3496: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
3497:
3498: if (((c_position_distr_rec.effective_start_date < l_year_end_date) and

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

3491: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
3492: begin
3493:
3494: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
3495: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
3496: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
3497:
3498: if (((c_position_distr_rec.effective_start_date < l_year_end_date) and
3499: (c_position_distr_rec.effective_end_date is null)) or

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

3492: begin
3493:
3494: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
3495: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
3496: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
3497:
3498: if (((c_position_distr_rec.effective_start_date < l_year_end_date) and
3499: (c_position_distr_rec.effective_end_date is null)) or
3500: ((c_position_distr_rec.effective_start_date between l_year_start_date and l_year_end_date) or

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

3846:
3847: if p_flex_mapping_set_id is not null then
3848: begin
3849:
3850: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
3851:
3852: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
3853: begin
3854:

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

3848: begin
3849:
3850: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
3851:
3852: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
3853: begin
3854:
3855: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
3856: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;

Line 3855: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;

3851:
3852: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
3853: begin
3854:
3855: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
3856: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
3857: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
3858:
3859: if (((c_position_distr_rec.effective_start_date < l_year_end_date) and

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

3852: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
3853: begin
3854:
3855: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
3856: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
3857: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
3858:
3859: if (((c_position_distr_rec.effective_start_date < l_year_end_date) and
3860: (c_position_distr_rec.effective_end_date is null)) or

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

3853: begin
3854:
3855: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
3856: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
3857: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
3858:
3859: if (((c_position_distr_rec.effective_start_date < l_year_end_date) and
3860: (c_position_distr_rec.effective_end_date is null)) or
3861: ((c_position_distr_rec.effective_start_date between l_year_start_date and l_year_end_date) or

Line 4067: l_period_amount PSB_WS_ACCT1.g_prdamt_tbl_type;

4063: l_period11_amount NUMBER;
4064: l_period12_amount NUMBER;
4065:
4066: l_mapped_ccid NUMBER;
4067: l_period_amount PSB_WS_ACCT1.g_prdamt_tbl_type;
4068:
4069: l_return_status VARCHAR2(1);
4070: l_msg_count NUMBER;
4071: l_msg_data VARCHAR2(2000);

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

4282: l_position_id := c_re_pos_rec.position_id;
4283: l_budget_group_id := c_re_pos_rec.budget_group_id;
4284: end loop;
4285:
4286: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
4287:
4288: l_budget_year_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id;
4289: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
4290: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;

Line 4288: l_budget_year_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id;

4284: end loop;
4285:
4286: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
4287:
4288: l_budget_year_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id;
4289: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
4290: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
4291: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
4292:

Line 4289: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;

4285:
4286: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
4287:
4288: l_budget_year_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id;
4289: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
4290: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
4291: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
4292:
4293: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop

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

4286: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
4287:
4288: l_budget_year_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id;
4289: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
4290: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
4291: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
4292:
4293: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
4294:

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

4287:
4288: l_budget_year_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id;
4289: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
4290: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
4291: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
4292:
4293: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
4294:
4295: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = l_budget_year_id then

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

4289: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
4290: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
4291: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
4292:
4293: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
4294:
4295: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = l_budget_year_id then
4296: begin
4297:

Line 4295: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = l_budget_year_id then

4291: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
4292:
4293: for l_period_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
4294:
4295: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = l_budget_year_id then
4296: begin
4297:
4298: if PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 1 then
4299: l_period1_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

Line 4298: if PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 1 then

4294:
4295: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = l_budget_year_id then
4296: begin
4297:
4298: if PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 1 then
4299: l_period1_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4300: l_period1_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4301: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 2 then
4302: l_period2_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

Line 4299: l_period1_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

4295: if PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id = l_budget_year_id then
4296: begin
4297:
4298: if PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 1 then
4299: l_period1_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4300: l_period1_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4301: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 2 then
4302: l_period2_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4303: l_period2_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

Line 4300: l_period1_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

4296: begin
4297:
4298: if PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 1 then
4299: l_period1_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4300: l_period1_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4301: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 2 then
4302: l_period2_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4303: l_period2_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4304: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 3 then

Line 4301: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 2 then

4297:
4298: if PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 1 then
4299: l_period1_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4300: l_period1_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4301: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 2 then
4302: l_period2_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4303: l_period2_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4304: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 3 then
4305: l_period3_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

Line 4302: l_period2_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

4298: if PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 1 then
4299: l_period1_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4300: l_period1_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4301: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 2 then
4302: l_period2_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4303: l_period2_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4304: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 3 then
4305: l_period3_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4306: l_period3_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

Line 4303: l_period2_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

4299: l_period1_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4300: l_period1_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4301: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 2 then
4302: l_period2_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4303: l_period2_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4304: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 3 then
4305: l_period3_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4306: l_period3_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4307: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 4 then

Line 4304: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 3 then

4300: l_period1_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4301: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 2 then
4302: l_period2_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4303: l_period2_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4304: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 3 then
4305: l_period3_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4306: l_period3_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4307: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 4 then
4308: l_period4_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

Line 4305: l_period3_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

4301: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 2 then
4302: l_period2_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4303: l_period2_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4304: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 3 then
4305: l_period3_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4306: l_period3_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4307: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 4 then
4308: l_period4_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4309: l_period4_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

Line 4306: l_period3_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

4302: l_period2_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4303: l_period2_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4304: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 3 then
4305: l_period3_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4306: l_period3_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4307: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 4 then
4308: l_period4_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4309: l_period4_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4310: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 5 then

Line 4307: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 4 then

4303: l_period2_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4304: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 3 then
4305: l_period3_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4306: l_period3_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4307: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 4 then
4308: l_period4_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4309: l_period4_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4310: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 5 then
4311: l_period5_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

Line 4308: l_period4_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

4304: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 3 then
4305: l_period3_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4306: l_period3_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4307: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 4 then
4308: l_period4_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4309: l_period4_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4310: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 5 then
4311: l_period5_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4312: l_period5_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

Line 4309: l_period4_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

4305: l_period3_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4306: l_period3_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4307: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 4 then
4308: l_period4_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4309: l_period4_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4310: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 5 then
4311: l_period5_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4312: l_period5_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4313: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 6 then

Line 4310: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 5 then

4306: l_period3_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4307: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 4 then
4308: l_period4_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4309: l_period4_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4310: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 5 then
4311: l_period5_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4312: l_period5_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4313: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 6 then
4314: l_period6_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

Line 4311: l_period5_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

4307: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 4 then
4308: l_period4_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4309: l_period4_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4310: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 5 then
4311: l_period5_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4312: l_period5_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4313: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 6 then
4314: l_period6_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4315: l_period6_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

Line 4312: l_period5_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

4308: l_period4_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4309: l_period4_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4310: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 5 then
4311: l_period5_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4312: l_period5_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4313: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 6 then
4314: l_period6_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4315: l_period6_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4316: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 7 then

Line 4313: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 6 then

4309: l_period4_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4310: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 5 then
4311: l_period5_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4312: l_period5_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4313: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 6 then
4314: l_period6_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4315: l_period6_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4316: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 7 then
4317: l_period7_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

Line 4314: l_period6_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

4310: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 5 then
4311: l_period5_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4312: l_period5_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4313: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 6 then
4314: l_period6_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4315: l_period6_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4316: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 7 then
4317: l_period7_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4318: l_period7_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

Line 4315: l_period6_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

4311: l_period5_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4312: l_period5_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4313: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 6 then
4314: l_period6_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4315: l_period6_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4316: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 7 then
4317: l_period7_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4318: l_period7_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4319: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 8 then

Line 4316: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 7 then

4312: l_period5_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4313: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 6 then
4314: l_period6_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4315: l_period6_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4316: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 7 then
4317: l_period7_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4318: l_period7_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4319: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 8 then
4320: l_period8_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

Line 4317: l_period7_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

4313: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 6 then
4314: l_period6_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4315: l_period6_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4316: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 7 then
4317: l_period7_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4318: l_period7_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4319: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 8 then
4320: l_period8_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4321: l_period8_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

Line 4318: l_period7_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

4314: l_period6_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4315: l_period6_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4316: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 7 then
4317: l_period7_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4318: l_period7_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4319: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 8 then
4320: l_period8_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4321: l_period8_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4322: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 9 then

Line 4319: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 8 then

4315: l_period6_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4316: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 7 then
4317: l_period7_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4318: l_period7_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4319: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 8 then
4320: l_period8_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4321: l_period8_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4322: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 9 then
4323: l_period9_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

Line 4320: l_period8_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

4316: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 7 then
4317: l_period7_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4318: l_period7_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4319: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 8 then
4320: l_period8_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4321: l_period8_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4322: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 9 then
4323: l_period9_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4324: l_period9_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

Line 4321: l_period8_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

4317: l_period7_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4318: l_period7_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4319: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 8 then
4320: l_period8_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4321: l_period8_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4322: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 9 then
4323: l_period9_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4324: l_period9_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4325: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 10 then

Line 4322: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 9 then

4318: l_period7_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4319: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 8 then
4320: l_period8_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4321: l_period8_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4322: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 9 then
4323: l_period9_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4324: l_period9_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4325: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 10 then
4326: l_period10_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

Line 4323: l_period9_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

4319: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 8 then
4320: l_period8_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4321: l_period8_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4322: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 9 then
4323: l_period9_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4324: l_period9_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4325: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 10 then
4326: l_period10_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4327: l_period10_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

Line 4324: l_period9_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

4320: l_period8_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4321: l_period8_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4322: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 9 then
4323: l_period9_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4324: l_period9_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4325: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 10 then
4326: l_period10_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4327: l_period10_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4328: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 11 then

Line 4325: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 10 then

4321: l_period8_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4322: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 9 then
4323: l_period9_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4324: l_period9_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4325: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 10 then
4326: l_period10_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4327: l_period10_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4328: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 11 then
4329: l_period11_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

Line 4326: l_period10_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

4322: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 9 then
4323: l_period9_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4324: l_period9_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4325: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 10 then
4326: l_period10_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4327: l_period10_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4328: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 11 then
4329: l_period11_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4330: l_period11_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

Line 4327: l_period10_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

4323: l_period9_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4324: l_period9_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4325: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 10 then
4326: l_period10_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4327: l_period10_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4328: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 11 then
4329: l_period11_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4330: l_period11_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4331: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 12 then

Line 4328: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 11 then

4324: l_period9_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4325: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 10 then
4326: l_period10_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4327: l_period10_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4328: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 11 then
4329: l_period11_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4330: l_period11_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4331: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 12 then
4332: l_period12_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

Line 4329: l_period11_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

4325: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 10 then
4326: l_period10_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4327: l_period10_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4328: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 11 then
4329: l_period11_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4330: l_period11_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4331: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 12 then
4332: l_period12_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4333: l_period12_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

Line 4330: l_period11_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

4326: l_period10_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4327: l_period10_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4328: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 11 then
4329: l_period11_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4330: l_period11_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4331: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 12 then
4332: l_period12_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4333: l_period12_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4334: end if;

Line 4331: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 12 then

4327: l_period10_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4328: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 11 then
4329: l_period11_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4330: l_period11_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4331: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 12 then
4332: l_period12_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4333: l_period12_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4334: end if;
4335:

Line 4332: l_period12_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;

4328: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 11 then
4329: l_period11_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4330: l_period11_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4331: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 12 then
4332: l_period12_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4333: l_period12_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4334: end if;
4335:
4336: end;

Line 4333: l_period12_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;

4329: l_period11_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4330: l_period11_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4331: elsif PSB_WS_ACCT1.g_budget_periods(l_period_index).long_sequence_no = 12 then
4332: l_period12_start_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date;
4333: l_period12_end_date := PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date;
4334: end if;
4335:
4336: end;
4337: end if;

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

5758: l_flex_mapping_set_id := c_WS_Rec.flex_mapping_set_id;
5759: l_position_id_flex_num := c_WS_Rec.position_id_flex_num;
5760: end loop;
5761:
5762: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
5763: begin
5764:
5765: PSB_WS_ACCT1.Cache_Budget_Calendar
5766: (p_return_status => l_return_status,

Line 5765: PSB_WS_ACCT1.Cache_Budget_Calendar

5761:
5762: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
5763: begin
5764:
5765: PSB_WS_ACCT1.Cache_Budget_Calendar
5766: (p_return_status => l_return_status,
5767: p_budget_calendar_id => l_budget_calendar_id);
5768:
5769: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

5781:
5782: -- for bug 4507389
5783: -- get the budget year start date and the budget year end date
5784: -- this is used to upload salary distributions
5785: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
5786: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
5787: = p_from_budget_year_id THEN
5788: g_year_start_date
5789: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;

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

5782: -- for bug 4507389
5783: -- get the budget year start date and the budget year end date
5784: -- this is used to upload salary distributions
5785: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
5786: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
5787: = p_from_budget_year_id THEN
5788: g_year_start_date
5789: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
5790: END IF;

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

5785: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years LOOP
5786: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
5787: = p_from_budget_year_id THEN
5788: g_year_start_date
5789: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
5790: END IF;
5791:
5792: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
5793: = p_to_budget_year_id THEN

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

5788: g_year_start_date
5789: := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
5790: END IF;
5791:
5792: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
5793: = p_to_budget_year_id THEN
5794: g_year_end_date
5795: := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
5796: END IF;

Line 5795: := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;

5791:
5792: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id
5793: = p_to_budget_year_id THEN
5794: g_year_end_date
5795: := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
5796: END IF;
5797: END LOOP;
5798: -- for bug 4507389
5799:

Line 7977: ((p_event_type = 'BP') and ((c_BG_Rec.effective_start_date <= PSB_WS_ACCT1.g_startdate_pp)

7973:
7974: for c_BG_Rec in c_BG loop
7975:
7976: if ((p_event_type = 'BR') or
7977: ((p_event_type = 'BP') and ((c_BG_Rec.effective_start_date <= PSB_WS_ACCT1.g_startdate_pp)
7978: and (c_BG_Rec.effective_end_date is null or c_BG_Rec.effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)))) then
7979: if c_BG_Rec.organization_id is null then
7980: message_token('BUDGET_GROUP', c_BG_Rec.short_name);
7981: add_message('PSB', 'PSB_PQH_NO_ORG_MAPPING');

Line 7978: and (c_BG_Rec.effective_end_date is null or c_BG_Rec.effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)))) then

7974: for c_BG_Rec in c_BG loop
7975:
7976: if ((p_event_type = 'BR') or
7977: ((p_event_type = 'BP') and ((c_BG_Rec.effective_start_date <= PSB_WS_ACCT1.g_startdate_pp)
7978: and (c_BG_Rec.effective_end_date is null or c_BG_Rec.effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)))) then
7979: if c_BG_Rec.organization_id is null then
7980: message_token('BUDGET_GROUP', c_BG_Rec.short_name);
7981: add_message('PSB', 'PSB_PQH_NO_ORG_MAPPING');
7982: l_org_notmapped := TRUE;

Line 8728: if p_gl_flex_code <> nvl(PSB_WS_ACCT1.g_flex_code, FND_API.G_MISS_NUM) then

8724:
8725: end loop;
8726: close c_Dist;
8727:
8728: if p_gl_flex_code <> nvl(PSB_WS_ACCT1.g_flex_code, FND_API.G_MISS_NUM) then
8729: begin
8730:
8731: PSB_WS_ACCT1.Flex_Info
8732: (p_flex_code => p_gl_flex_code,

Line 8731: PSB_WS_ACCT1.Flex_Info

8727:
8728: if p_gl_flex_code <> nvl(PSB_WS_ACCT1.g_flex_code, FND_API.G_MISS_NUM) then
8729: begin
8730:
8731: PSB_WS_ACCT1.Flex_Info
8732: (p_flex_code => p_gl_flex_code,
8733: p_return_status => l_return_status);
8734:
8735: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 8897: for l_init_index in 1..PSB_WS_ACCT1.g_num_segs loop

8893:
8894: -- added for bug # 4502946
8895: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
8896:
8897: for l_init_index in 1..PSB_WS_ACCT1.g_num_segs loop
8898: l_ccid_val(l_init_index) := null;
8899: l_seg_val(l_init_index) := null;
8900: end loop;
8901:

Line 8909: n_segments => PSB_WS_ACCT1.g_num_segs,

8905: (application_short_name => 'SQLGL',
8906: key_flex_code => 'GL#',
8907: structure_number => p_gl_flex_code,
8908: combination_id => PSB_WS_POS1.g_salary_dist(l_saldist_index).ccid,
8909: n_segments => PSB_WS_ACCT1.g_num_segs,
8910: segments => l_ccid_val) then
8911:
8912: /* start bug 3666828 */
8913: l_hr_position_id := p_hr_position_id;

Line 8922: for l_index in 1..PSB_WS_ACCT1.g_num_segs loop

8918: FND_MSG_PUB.Add;
8919: raise FND_API.G_EXC_ERROR;
8920: end if;
8921:
8922: for l_index in 1..PSB_WS_ACCT1.g_num_segs loop
8923:
8924: if ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') and
8925: (l_dist.segment1(l_dist_index) is not null)) then
8926: l_seg_val(l_index) := l_dist.segment1(l_dist_index);

Line 8924: if ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') and

8920: end if;
8921:
8922: for l_index in 1..PSB_WS_ACCT1.g_num_segs loop
8923:
8924: if ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') and
8925: (l_dist.segment1(l_dist_index) is not null)) then
8926: l_seg_val(l_index) := l_dist.segment1(l_dist_index);
8927:
8928: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') and

Line 8928: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') and

8924: if ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') and
8925: (l_dist.segment1(l_dist_index) is not null)) then
8926: l_seg_val(l_index) := l_dist.segment1(l_dist_index);
8927:
8928: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') and
8929: (l_dist.segment2(l_dist_index) is not null)) then
8930: l_seg_val(l_index) := l_dist.segment2(l_dist_index);
8931:
8932: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') and

Line 8932: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') and

8928: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') and
8929: (l_dist.segment2(l_dist_index) is not null)) then
8930: l_seg_val(l_index) := l_dist.segment2(l_dist_index);
8931:
8932: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') and
8933: (l_dist.segment3(l_dist_index) is not null)) then
8934: l_seg_val(l_index) := l_dist.segment3(l_dist_index);
8935:
8936: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') and

Line 8936: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') and

8932: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') and
8933: (l_dist.segment3(l_dist_index) is not null)) then
8934: l_seg_val(l_index) := l_dist.segment3(l_dist_index);
8935:
8936: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') and
8937: (l_dist.segment4(l_dist_index) is not null)) then
8938: l_seg_val(l_index) := l_dist.segment4(l_dist_index);
8939:
8940: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') and

Line 8940: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') and

8936: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') and
8937: (l_dist.segment4(l_dist_index) is not null)) then
8938: l_seg_val(l_index) := l_dist.segment4(l_dist_index);
8939:
8940: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') and
8941: (l_dist.segment5(l_dist_index) is not null)) then
8942: l_seg_val(l_index) := l_dist.segment5(l_dist_index);
8943:
8944: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') and

Line 8944: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') and

8940: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') and
8941: (l_dist.segment5(l_dist_index) is not null)) then
8942: l_seg_val(l_index) := l_dist.segment5(l_dist_index);
8943:
8944: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') and
8945: (l_dist.segment6(l_dist_index) is not null)) then
8946: l_seg_val(l_index) := l_dist.segment6(l_dist_index);
8947:
8948: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') and

Line 8948: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') and

8944: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') and
8945: (l_dist.segment6(l_dist_index) is not null)) then
8946: l_seg_val(l_index) := l_dist.segment6(l_dist_index);
8947:
8948: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') and
8949: (l_dist.segment7(l_dist_index) is not null)) then
8950: l_seg_val(l_index) := l_dist.segment7(l_dist_index);
8951:
8952: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') and

Line 8952: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') and

8948: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') and
8949: (l_dist.segment7(l_dist_index) is not null)) then
8950: l_seg_val(l_index) := l_dist.segment7(l_dist_index);
8951:
8952: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') and
8953: (l_dist.segment8(l_dist_index) is not null)) then
8954: l_seg_val(l_index) := l_dist.segment8(l_dist_index);
8955:
8956: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') and

Line 8956: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') and

8952: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') and
8953: (l_dist.segment8(l_dist_index) is not null)) then
8954: l_seg_val(l_index) := l_dist.segment8(l_dist_index);
8955:
8956: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') and
8957: (l_dist.segment9(l_dist_index) is not null)) then
8958: l_seg_val(l_index) := l_dist.segment9(l_dist_index);
8959:
8960: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') and

Line 8960: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') and

8956: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') and
8957: (l_dist.segment9(l_dist_index) is not null)) then
8958: l_seg_val(l_index) := l_dist.segment9(l_dist_index);
8959:
8960: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') and
8961: (l_dist.segment10(l_dist_index) is not null)) then
8962: l_seg_val(l_index) := l_dist.segment10(l_dist_index);
8963:
8964: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') and

Line 8964: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') and

8960: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') and
8961: (l_dist.segment10(l_dist_index) is not null)) then
8962: l_seg_val(l_index) := l_dist.segment10(l_dist_index);
8963:
8964: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') and
8965: (l_dist.segment11(l_dist_index) is not null)) then
8966: l_seg_val(l_index) := l_dist.segment11(l_dist_index);
8967:
8968: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') and

Line 8968: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') and

8964: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') and
8965: (l_dist.segment11(l_dist_index) is not null)) then
8966: l_seg_val(l_index) := l_dist.segment11(l_dist_index);
8967:
8968: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') and
8969: (l_dist.segment12(l_dist_index) is not null)) then
8970: l_seg_val(l_index) := l_dist.segment12(l_dist_index);
8971:
8972: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') and

Line 8972: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') and

8968: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') and
8969: (l_dist.segment12(l_dist_index) is not null)) then
8970: l_seg_val(l_index) := l_dist.segment12(l_dist_index);
8971:
8972: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') and
8973: (l_dist.segment13(l_dist_index) is not null)) then
8974: l_seg_val(l_index) := l_dist.segment13(l_dist_index);
8975:
8976: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') and

Line 8976: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') and

8972: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') and
8973: (l_dist.segment13(l_dist_index) is not null)) then
8974: l_seg_val(l_index) := l_dist.segment13(l_dist_index);
8975:
8976: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') and
8977: (l_dist.segment14(l_dist_index) is not null)) then
8978: l_seg_val(l_index) := l_dist.segment14(l_dist_index);
8979:
8980: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') and

Line 8980: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') and

8976: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') and
8977: (l_dist.segment14(l_dist_index) is not null)) then
8978: l_seg_val(l_index) := l_dist.segment14(l_dist_index);
8979:
8980: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') and
8981: (l_dist.segment15(l_dist_index) is not null)) then
8982: l_seg_val(l_index) := l_dist.segment15(l_dist_index);
8983:
8984: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') and

Line 8984: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') and

8980: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') and
8981: (l_dist.segment15(l_dist_index) is not null)) then
8982: l_seg_val(l_index) := l_dist.segment15(l_dist_index);
8983:
8984: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') and
8985: (l_dist.segment16(l_dist_index) is not null)) then
8986: l_seg_val(l_index) := l_dist.segment16(l_dist_index);
8987:
8988: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') and

Line 8988: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') and

8984: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') and
8985: (l_dist.segment16(l_dist_index) is not null)) then
8986: l_seg_val(l_index) := l_dist.segment16(l_dist_index);
8987:
8988: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') and
8989: (l_dist.segment17(l_dist_index) is not null)) then
8990: l_seg_val(l_index) := l_dist.segment17(l_dist_index);
8991:
8992: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') and

Line 8992: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') and

8988: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') and
8989: (l_dist.segment17(l_dist_index) is not null)) then
8990: l_seg_val(l_index) := l_dist.segment17(l_dist_index);
8991:
8992: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') and
8993: (l_dist.segment18(l_dist_index) is not null)) then
8994: l_seg_val(l_index) := l_dist.segment18(l_dist_index);
8995:
8996: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') and

Line 8996: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') and

8992: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') and
8993: (l_dist.segment18(l_dist_index) is not null)) then
8994: l_seg_val(l_index) := l_dist.segment18(l_dist_index);
8995:
8996: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') and
8997: (l_dist.segment19(l_dist_index) is not null)) then
8998: l_seg_val(l_index) := l_dist.segment19(l_dist_index);
8999:
9000: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') and

Line 9000: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') and

8996: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') and
8997: (l_dist.segment19(l_dist_index) is not null)) then
8998: l_seg_val(l_index) := l_dist.segment19(l_dist_index);
8999:
9000: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') and
9001: (l_dist.segment20(l_dist_index) is not null)) then
9002: l_seg_val(l_index) := l_dist.segment20(l_dist_index);
9003:
9004: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') and

Line 9004: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') and

9000: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') and
9001: (l_dist.segment20(l_dist_index) is not null)) then
9002: l_seg_val(l_index) := l_dist.segment20(l_dist_index);
9003:
9004: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') and
9005: (l_dist.segment21(l_dist_index) is not null)) then
9006: l_seg_val(l_index) := l_dist.segment21(l_dist_index);
9007:
9008: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') and

Line 9008: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') and

9004: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') and
9005: (l_dist.segment21(l_dist_index) is not null)) then
9006: l_seg_val(l_index) := l_dist.segment21(l_dist_index);
9007:
9008: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') and
9009: (l_dist.segment22(l_dist_index) is not null)) then
9010: l_seg_val(l_index) := l_dist.segment22(l_dist_index);
9011:
9012: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') and

Line 9012: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') and

9008: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') and
9009: (l_dist.segment22(l_dist_index) is not null)) then
9010: l_seg_val(l_index) := l_dist.segment22(l_dist_index);
9011:
9012: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') and
9013: (l_dist.segment23(l_dist_index) is not null)) then
9014: l_seg_val(l_index) := l_dist.segment23(l_dist_index);
9015:
9016: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') and

Line 9016: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') and

9012: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') and
9013: (l_dist.segment23(l_dist_index) is not null)) then
9014: l_seg_val(l_index) := l_dist.segment23(l_dist_index);
9015:
9016: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') and
9017: (l_dist.segment24(l_dist_index) is not null)) then
9018: l_seg_val(l_index) := l_dist.segment24(l_dist_index);
9019:
9020: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') and

Line 9020: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') and

9016: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') and
9017: (l_dist.segment24(l_dist_index) is not null)) then
9018: l_seg_val(l_index) := l_dist.segment24(l_dist_index);
9019:
9020: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') and
9021: (l_dist.segment25(l_dist_index) is not null)) then
9022: l_seg_val(l_index) := l_dist.segment25(l_dist_index);
9023:
9024: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') and

Line 9024: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') and

9020: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') and
9021: (l_dist.segment25(l_dist_index) is not null)) then
9022: l_seg_val(l_index) := l_dist.segment25(l_dist_index);
9023:
9024: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') and
9025: (l_dist.segment26(l_dist_index) is not null)) then
9026: l_seg_val(l_index) := l_dist.segment26(l_dist_index);
9027:
9028: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') and

Line 9028: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') and

9024: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') and
9025: (l_dist.segment26(l_dist_index) is not null)) then
9026: l_seg_val(l_index) := l_dist.segment26(l_dist_index);
9027:
9028: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') and
9029: (l_dist.segment27(l_dist_index) is not null)) then
9030: l_seg_val(l_index) := l_dist.segment27(l_dist_index);
9031:
9032: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') and

Line 9032: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') and

9028: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') and
9029: (l_dist.segment27(l_dist_index) is not null)) then
9030: l_seg_val(l_index) := l_dist.segment27(l_dist_index);
9031:
9032: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') and
9033: (l_dist.segment28(l_dist_index) is not null)) then
9034: l_seg_val(l_index) := l_dist.segment28(l_dist_index);
9035:
9036: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') and

Line 9036: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') and

9032: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') and
9033: (l_dist.segment28(l_dist_index) is not null)) then
9034: l_seg_val(l_index) := l_dist.segment28(l_dist_index);
9035:
9036: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') and
9037: (l_dist.segment29(l_dist_index) is not null)) then
9038: l_seg_val(l_index) := l_dist.segment29(l_dist_index);
9039:
9040: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT30') and

Line 9040: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT30') and

9036: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') and
9037: (l_dist.segment29(l_dist_index) is not null)) then
9038: l_seg_val(l_index) := l_dist.segment29(l_dist_index);
9039:
9040: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT30') and
9041: (l_dist.segment30(l_dist_index) is not null)) then
9042: l_seg_val(l_index) := l_dist.segment30(l_dist_index);
9043:
9044: else

Line 9056: n_segments => PSB_WS_ACCT1.g_num_segs,

9052: (application_short_name => 'SQLGL',
9053: key_flex_code => 'GL#',
9054: structure_number => p_gl_flex_code,
9055: validation_date => sysdate,
9056: n_segments => PSB_WS_ACCT1.g_num_segs,
9057: segments => l_seg_val,
9058: combination_id => l_ccid) then
9059:
9060: /* start bug 3666828 */

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

12788:
12789: if ((p_flex_mapping_set_id is not null) and (nvl(p_follow_salary, 'N') = 'N')) then
12790: begin
12791:
12792: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
12793:
12794: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
12795: begin
12796:

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

12790: begin
12791:
12792: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
12793:
12794: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
12795: begin
12796:
12797: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
12798: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;

Line 12797: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;

12793:
12794: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
12795: begin
12796:
12797: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
12798: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
12799: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
12800:
12801: if (((c_elemdist_rec.effective_start_date < l_year_end_date) and

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

12794: if PSB_WS_ACCT1.g_budget_years(l_year_index).year_type in ('CY', 'PP') then
12795: begin
12796:
12797: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
12798: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
12799: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
12800:
12801: if (((c_elemdist_rec.effective_start_date < l_year_end_date) and
12802: (c_elemdist_rec.effective_end_date is null)) or

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

12795: begin
12796:
12797: l_budget_year_type_id := PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_type_id;
12798: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
12799: l_year_end_date := PSB_WS_ACCT1.g_budget_years(l_year_index).end_date;
12800:
12801: if (((c_elemdist_rec.effective_start_date < l_year_end_date) and
12802: (c_elemdist_rec.effective_end_date is null)) or
12803: ((c_elemdist_rec.effective_start_date between l_year_start_date and l_year_end_date) or