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

Line 112: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,

108: p_start_stage_seq IN NUMBER,
109: p_current_stage_seq IN NUMBER,
110: p_budget_group_id IN NUMBER,
111: /*For Bug No : 2811698 Start*/
112: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,
113: p_total_fte IN NUMBER,
114: p_num_budget_periods IN NUMBER
115: /*For Bug No : 2811698 End*/
116:

Line 535: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp

531: cursor c_Allowed is
532: select 'Valid'
533: from PSB_BUDGET_GROUPS
534: where budget_group_type = 'R'
535: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
536: and (effective_end_date is null
537: or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)
538: and budget_group_id = p_position_budget_group_id
539: start with budget_group_id = l_budget_group_id

Line 537: or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)

533: from PSB_BUDGET_GROUPS
534: where budget_group_type = 'R'
535: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
536: and (effective_end_date is null
537: or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)
538: and budget_group_id = p_position_budget_group_id
539: start with budget_group_id = l_budget_group_id
540: connect by prior budget_group_id = parent_budget_group_id;
541:

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

555: l_budget_calendar_id := c_WS_Rec.budget_calendar_id;
556: l_budget_group_id := c_WS_Rec.budget_group_id;
557: end loop;
558:
559: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
560: begin
561:
562: PSB_WS_ACCT1.Cache_Budget_Calendar
563: (p_return_status => l_return_status,

Line 562: PSB_WS_ACCT1.Cache_Budget_Calendar

558:
559: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
560: begin
561:
562: PSB_WS_ACCT1.Cache_Budget_Calendar
563: (p_return_status => l_return_status,
564: p_budget_calendar_id => l_budget_calendar_id);
565:
566: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 605: -- PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)

601: /* ----------------------------------------------------------------------- */
602:
603: -- Cache all Elements for a Data Extract and Business Group that are valid
604: -- within the projection period for a Worksheet (specified by
605: -- PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
606:
607: PROCEDURE Cache_Elements
608: ( p_return_status OUT NOCOPY VARCHAR2,
609: p_data_extract_id IN NUMBER,

Line 634: where (((start_date <= PSB_WS_ACCT1.g_end_est_date)

630: follow_salary,
631: period_type,
632: process_period_type
633: from PSB_PAY_ELEMENTS
634: where (((start_date <= PSB_WS_ACCT1.g_end_est_date)
635: and (end_date is null))
636: or ((start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
637: or (end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
638: or ((start_date < PSB_WS_ACCT1.g_startdate_cy)

Line 636: or ((start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)

632: process_period_type
633: from PSB_PAY_ELEMENTS
634: where (((start_date <= PSB_WS_ACCT1.g_end_est_date)
635: and (end_date is null))
636: or ((start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
637: or (end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
638: or ((start_date < PSB_WS_ACCT1.g_startdate_cy)
639: and (end_date > PSB_WS_ACCT1.g_end_est_date))))
640: and business_group_id = p_business_group_id

Line 637: or (end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)

633: from PSB_PAY_ELEMENTS
634: where (((start_date <= PSB_WS_ACCT1.g_end_est_date)
635: and (end_date is null))
636: or ((start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
637: or (end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
638: or ((start_date < PSB_WS_ACCT1.g_startdate_cy)
639: and (end_date > PSB_WS_ACCT1.g_end_est_date))))
640: and business_group_id = p_business_group_id
641: and data_extract_id = p_data_extract_id

Line 638: or ((start_date < PSB_WS_ACCT1.g_startdate_cy)

634: where (((start_date <= PSB_WS_ACCT1.g_end_est_date)
635: and (end_date is null))
636: or ((start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
637: or (end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
638: or ((start_date < PSB_WS_ACCT1.g_startdate_cy)
639: and (end_date > PSB_WS_ACCT1.g_end_est_date))))
640: and business_group_id = p_business_group_id
641: and data_extract_id = p_data_extract_id
642: order by salary_flag desc,

Line 639: and (end_date > PSB_WS_ACCT1.g_end_est_date))))

635: and (end_date is null))
636: or ((start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
637: or (end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
638: or ((start_date < PSB_WS_ACCT1.g_startdate_cy)
639: and (end_date > PSB_WS_ACCT1.g_end_est_date))))
640: and business_group_id = p_business_group_id
641: and data_extract_id = p_data_extract_id
642: order by salary_flag desc,
643: pay_element_id;

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

674: if g_budget_calendar_id is not null then
675: l_budget_calendar_id := g_budget_calendar_id;
676: end if;
677:
678: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
679: begin
680:
681: PSB_WS_ACCT1.Cache_Budget_Calendar
682: (p_return_status => l_return_status,

Line 681: PSB_WS_ACCT1.Cache_Budget_Calendar

677:
678: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
679: begin
680:
681: PSB_WS_ACCT1.Cache_Budget_Calendar
682: (p_return_status => l_return_status,
683: p_budget_calendar_id => l_budget_calendar_id);
684:
685: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1121: and b.effective_start_date <= PSB_WS_ACCT1.g_startdate_pp

1117: from PSB_SET_RELATIONS a,
1118: PSB_BUDGET_GROUPS b,
1119: PSB_BUDGET_ACCOUNTS c
1120: where a.budget_group_id = b.budget_group_id
1121: and b.effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
1122: and (b.effective_end_date is null
1123: or b.effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)
1124: and b.budget_group_type = 'R'
1125: and ((b.budget_group_id = p_root_budget_group_id) or

Line 1123: or b.effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)

1119: PSB_BUDGET_ACCOUNTS c
1120: where a.budget_group_id = b.budget_group_id
1121: and b.effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
1122: and (b.effective_end_date is null
1123: or b.effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)
1124: and b.budget_group_type = 'R'
1125: and ((b.budget_group_id = p_root_budget_group_id) or
1126: (b.root_budget_group_id = p_root_budget_group_id))
1127: and a.account_position_set_id = c.account_position_set_id

Line 1242: if p_flex_code <> nvl(PSB_WS_ACCT1.g_flex_code, FND_API.G_MISS_NUM) then

1238: add_message('PSB', 'PSB_NO_SALARY_DISTRIBUTION');
1239: raise FND_API.G_EXC_ERROR;
1240: end if;
1241:
1242: if p_flex_code <> nvl(PSB_WS_ACCT1.g_flex_code, FND_API.G_MISS_NUM) then
1243: begin
1244:
1245: PSB_WS_ACCT1.Flex_Info
1246: (p_flex_code => p_flex_code,

Line 1245: PSB_WS_ACCT1.Flex_Info

1241:
1242: if p_flex_code <> nvl(PSB_WS_ACCT1.g_flex_code, FND_API.G_MISS_NUM) then
1243: begin
1244:
1245: PSB_WS_ACCT1.Flex_Info
1246: (p_flex_code => p_flex_code,
1247: p_return_status => l_return_status);
1248:
1249: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

1355:
1356: end;
1357: end if;
1358:
1359: if g_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
1360: begin
1361:
1362: PSB_WS_ACCT1.Cache_Budget_Calendar
1363: (p_return_status => l_return_status,

Line 1362: PSB_WS_ACCT1.Cache_Budget_Calendar

1358:
1359: if g_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
1360: begin
1361:
1362: PSB_WS_ACCT1.Cache_Budget_Calendar
1363: (p_return_status => l_return_status,
1364: p_budget_calendar_id => g_budget_calendar_id);
1365:
1366: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1413: for c_Distribute_WS_Rec in PSB_WS_ACCT1.c_Distribute_WS (g_global_worksheet_id,

1409: end;
1410: else
1411: begin
1412:
1413: for c_Distribute_WS_Rec in PSB_WS_ACCT1.c_Distribute_WS (g_global_worksheet_id,
1414: p_budget_group_id,
1415: PSB_WS_ACCT1.g_startdate_pp,
1416: PSB_WS_ACCT1.g_enddate_cy) loop
1417:

Line 1415: PSB_WS_ACCT1.g_startdate_pp,

1411: begin
1412:
1413: for c_Distribute_WS_Rec in PSB_WS_ACCT1.c_Distribute_WS (g_global_worksheet_id,
1414: p_budget_group_id,
1415: PSB_WS_ACCT1.g_startdate_pp,
1416: PSB_WS_ACCT1.g_enddate_cy) loop
1417:
1418: Create_Position_Matrix
1419: (p_api_version => 1.0,

Line 1416: PSB_WS_ACCT1.g_enddate_cy) loop

1412:
1413: for c_Distribute_WS_Rec in PSB_WS_ACCT1.c_Distribute_WS (g_global_worksheet_id,
1414: p_budget_group_id,
1415: PSB_WS_ACCT1.g_startdate_pp,
1416: PSB_WS_ACCT1.g_enddate_cy) loop
1417:
1418: Create_Position_Matrix
1419: (p_api_version => 1.0,
1420: p_return_status => l_return_status,

Line 1481: for c_Distribute_WS_Rec in PSB_WS_ACCT1.c_Distribute_WS (g_global_worksheet_id,

1477: end;
1478: else
1479: begin
1480:
1481: for c_Distribute_WS_Rec in PSB_WS_ACCT1.c_Distribute_WS (g_global_worksheet_id,
1482: p_budget_group_id,
1483: PSB_WS_ACCT1.g_startdate_pp,
1484: PSB_WS_ACCT1.g_enddate_cy) loop
1485:

Line 1483: PSB_WS_ACCT1.g_startdate_pp,

1479: begin
1480:
1481: for c_Distribute_WS_Rec in PSB_WS_ACCT1.c_Distribute_WS (g_global_worksheet_id,
1482: p_budget_group_id,
1483: PSB_WS_ACCT1.g_startdate_pp,
1484: PSB_WS_ACCT1.g_enddate_cy) loop
1485:
1486: Create_Position_Matrix
1487: (p_api_version => 1.0,

Line 1484: PSB_WS_ACCT1.g_enddate_cy) loop

1480:
1481: for c_Distribute_WS_Rec in PSB_WS_ACCT1.c_Distribute_WS (g_global_worksheet_id,
1482: p_budget_group_id,
1483: PSB_WS_ACCT1.g_startdate_pp,
1484: PSB_WS_ACCT1.g_enddate_cy) loop
1485:
1486: Create_Position_Matrix
1487: (p_api_version => 1.0,
1488: p_return_status => l_return_status,

Line 1671: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type

1667: p_stage_set_id IN NUMBER,
1668: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
1669: p_current_stage_seq IN NUMBER,
1670: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
1671: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type
1672: ) IS
1673:
1674: l_api_name CONSTANT VARCHAR2(30) := 'Create_FTE_Lines';
1675: l_api_version CONSTANT NUMBER := 1.0;

Line 1692: l_period_fte PSB_WS_ACCT1.g_prdamt_tbl_type;

1688:
1689: l_ftelineid NUMBER;
1690:
1691: l_fte NUMBER;
1692: l_period_fte PSB_WS_ACCT1.g_prdamt_tbl_type;
1693: l_annual_fte NUMBER;
1694: /*For Bug No : 2811698 Start*/
1695: l_total_fte NUMBER := 0;
1696: /*For Bug No : 2811698 End*/

Line 1699: l_spfte PSB_WS_ACCT1.g_prdamt_tbl_type;

1695: l_total_fte NUMBER := 0;
1696: /*For Bug No : 2811698 End*/
1697:
1698: l_spflid NUMBER;
1699: l_spfte PSB_WS_ACCT1.g_prdamt_tbl_type;
1700: l_spannual_fte NUMBER;
1701: l_spfl_exists VARCHAR2(1) := FND_API.G_FALSE;
1702:
1703: l_global_wsid NUMBER;

Line 1732: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

1728: l_loginid := FND_GLOBAL.LOGIN_ID;
1729:
1730: --Total cost would be the sum of all the periods
1731: /*For Bug No : 2811698 Start*/
1732: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
1733: l_total_fte := l_total_fte + nvl(p_period_fte(l_index),0);
1734: end loop;
1735: /*For Bug No : 2811698 End*/
1736:

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

1804: for c_BG_Rec in c_BG (l_budget_group_id) loop
1805: l_business_group_id := c_BG_Rec.business_group_id;
1806: end loop;
1807:
1808: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
1809: begin
1810:
1811: PSB_WS_ACCT1.Cache_Budget_Calendar
1812: (p_return_status => l_return_status,

Line 1811: PSB_WS_ACCT1.Cache_Budget_Calendar

1807:
1808: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
1809: begin
1810:
1811: PSB_WS_ACCT1.Cache_Budget_Calendar
1812: (p_return_status => l_return_status,
1813: p_budget_calendar_id => l_budget_calendar_id);
1814:
1815: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

1818:
1819: end;
1820: end if;
1821:
1822: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
1823:
1824: -- Find number of Budget Periods in the Budget Year : this is used to compute the Annual FTE
1825:
1826: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then

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

1822: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
1823:
1824: -- Find number of Budget Periods in the Budget Year : this is used to compute the Annual FTE
1825:
1826: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
1827: l_num_budget_periods := PSB_WS_ACCT1.g_budget_years(l_year_index).num_budget_periods;
1828: end if;
1829:
1830: end loop;

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

1823:
1824: -- Find number of Budget Periods in the Budget Year : this is used to compute the Annual FTE
1825:
1826: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id then
1827: l_num_budget_periods := PSB_WS_ACCT1.g_budget_years(l_year_index).num_budget_periods;
1828: end if;
1829:
1830: end loop;
1831:

Line 1840: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

1836: -- budget periods in the Budget Year
1837:
1838: l_annual_fte := 0;
1839:
1840: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
1841:
1842: if FND_API.to_Boolean(l_spfl_exists) then
1843: begin
1844:

Line 1971: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

1967: for c_FTESeq_Rec in c_FTESeq loop
1968: l_ftelineid := c_FTESeq_Rec.FTELineID;
1969: end loop;
1970:
1971: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
1972:
1973: l_fte := nvl(p_period_fte(l_index), 0);
1974:
1975: if l_fte = 0 then

Line 2232: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,

2228: p_worksheet_id IN NUMBER,
2229: p_fte_line_id IN NUMBER,
2230: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
2231: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
2232: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,
2233: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
2234: ) IS
2235:
2236: l_api_name CONSTANT VARCHAR2(30) := 'Create_FTE_Lines';

Line 2253: l_period_fte PSB_WS_ACCT1.g_prdamt_tbl_type;

2249: l_stage_set_id NUMBER;
2250: l_start_stage_seq NUMBER;
2251: l_current_stage_seq NUMBER;
2252: l_end_stage_seq NUMBER;
2253: l_period_fte PSB_WS_ACCT1.g_prdamt_tbl_type;
2254: l_annual_fte NUMBER;
2255: l_new_annual_fte NUMBER;
2256:
2257: l_budget_calendar_id NUMBER;

Line 2273: l_spfte PSB_WS_ACCT1.g_prdamt_tbl_type;

2269:
2270: l_fte_line_id NUMBER;
2271:
2272: l_spflid NUMBER;
2273: l_spfte PSB_WS_ACCT1.g_prdamt_tbl_type;
2274: -- Added l_bind_fte as part of fix for bug 3132485
2275: l_bind_fte PSB_WS_ACCT1.g_prdamt_tbl_type;
2276: l_spfl_exists VARCHAR2(1) := FND_API.G_FALSE;
2277:

Line 2275: l_bind_fte PSB_WS_ACCT1.g_prdamt_tbl_type;

2271:
2272: l_spflid NUMBER;
2273: l_spfte PSB_WS_ACCT1.g_prdamt_tbl_type;
2274: -- Added l_bind_fte as part of fix for bug 3132485
2275: l_bind_fte PSB_WS_ACCT1.g_prdamt_tbl_type;
2276: l_spfl_exists VARCHAR2(1) := FND_API.G_FALSE;
2277:
2278: l_recalculate_flag VARCHAR2(1) := FND_API.G_FALSE;
2279:

Line 2344: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

2340: end if;
2341:
2342: --Total cost would be the sum of all the periods
2343: /*For Bug No : 2811698 Start*/
2344: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
2345: l_total_fte := l_total_fte + nvl(p_period_fte(l_index),0);
2346: end loop;
2347: /*For Bug No : 2811698 End*/
2348:

Line 2462: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

2458:
2459: -- Create new Stage if any of the existing Period FTEs are being updated and the Start Stage Seq for
2460: -- the current FTE line is different from the Current Stage Sequence
2461:
2462: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
2463: if nvl(p_period_fte(l_index), FND_API.G_MISS_NUM) <> nvl(l_period_fte(l_index), FND_API.G_MISS_NUM) then
2464: l_new_stage := FND_API.G_TRUE;
2465: l_recalculate_flag := FND_API.G_TRUE;
2466: exit;

Line 2502: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

2498: 'start_stage_seq, ' ||
2499: 'current_stage_seq, ' ||
2500: 'end_stage_seq, ';
2501:
2502: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
2503: sql_wfl := sql_wfl ||
2504: 'period' || l_index || '_fte, ';
2505: end loop;
2506:

Line 2526: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

2522: 'start_stage_seq, ' ||
2523: ':b_previous_stage_seq, ' ||
2524: ':b_previous_stage_seq, ';
2525:
2526: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
2527: sql_wfl := sql_wfl ||
2528: 'period' || l_index || '_fte, ';
2529: end loop;
2530:

Line 2548: -- Replaced PSB_WS_ACCT1.dsql_execute with execute immediate for bug 3132485

2544: ':b_creation_date ' ||
2545: 'from PSB_WS_FTE_LINES ' ||
2546: 'where fte_line_id = :b_fte_line_id';
2547:
2548: -- Replaced PSB_WS_ACCT1.dsql_execute with execute immediate for bug 3132485
2549: -- Bug#5030383
2550:
2551: EXECUTE IMMEDIATE
2552: sql_wfl

Line 2565: num_wfl := PSB_WS_ACCT1.dsql_execute(sql_wfl);

2561: , SYSDATE
2562: , p_fte_line_id ;
2563:
2564: /*
2565: num_wfl := PSB_WS_ACCT1.dsql_execute(sql_wfl);
2566:
2567: if num_wfl < 0 then
2568: raise FND_API.G_EXC_ERROR;
2569: end if;

Line 2581: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

2577: sql_wfl := 'update PSB_WS_FTE_LINES ' ||
2578: 'set service_package_id = decode( :p_service_package_id1 , :gmn1,'||
2579: 'service_package_id, :p_service_package_id2 ), ';
2580:
2581: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
2582:
2583: if FND_API.to_Boolean(l_spfl_exists) then
2584: l_fte := nvl(p_period_fte(l_index), 0) + nvl(l_spfte(l_index), 0);
2585: else

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

2641: for c_BG_Rec in c_BG (l_budget_group_id) loop
2642: l_business_group_id := c_BG_Rec.business_group_id;
2643: end loop;
2644:
2645: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
2646: begin
2647:
2648: PSB_WS_ACCT1.Cache_Budget_Calendar
2649: (p_return_status => l_return_status,

Line 2648: PSB_WS_ACCT1.Cache_Budget_Calendar

2644:
2645: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
2646: begin
2647:
2648: PSB_WS_ACCT1.Cache_Budget_Calendar
2649: (p_return_status => l_return_status,
2650: p_budget_calendar_id => l_budget_calendar_id);
2651:
2652: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

2655:
2656: end;
2657: end if;
2658:
2659: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
2660:
2661: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = l_budget_year_id then
2662: l_num_budget_periods := PSB_WS_ACCT1.g_budget_years(l_year_index).num_budget_periods;
2663: end if;

Line 2661: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = l_budget_year_id then

2657: end if;
2658:
2659: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
2660:
2661: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = l_budget_year_id then
2662: l_num_budget_periods := PSB_WS_ACCT1.g_budget_years(l_year_index).num_budget_periods;
2663: end if;
2664:
2665: end loop;

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

2658:
2659: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years loop
2660:
2661: if PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = l_budget_year_id then
2662: l_num_budget_periods := PSB_WS_ACCT1.g_budget_years(l_year_index).num_budget_periods;
2663: end if;
2664:
2665: end loop;
2666:

Line 2690: num_wfl := PSB_WS_ACCT1.dsql_execute(sql_wfl);

2686: 'where fte_line_id = :b_fte_line_id' ;
2687:
2688: -- Commented this as part of fix for Bug 3132485
2689: /*
2690: num_wfl := PSB_WS_ACCT1.dsql_execute(sql_wfl);
2691:
2692: if num_wfl < 0 then
2693: raise FND_API.G_EXC_ERROR;
2694: end if;

Line 2942: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,

2938: p_start_stage_seq IN NUMBER,
2939: p_current_stage_seq IN NUMBER,
2940: p_budget_group_id IN NUMBER,
2941: /*For Bug No : 2811698 Start*/
2942: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,
2943: p_total_fte IN NUMBER,
2944: p_num_budget_periods IN NUMBER
2945: /*For Bug No : 2811698 End*/
2946: ) IS

Line 2949: l_period_amount PSB_WS_ACCT1.g_prdamt_tbl_type;

2945: /*For Bug No : 2811698 End*/
2946: ) IS
2947:
2948: l_account_line_id NUMBER;
2949: l_period_amount PSB_WS_ACCT1.g_prdamt_tbl_type;
2950:
2951: l_salary_account_line VARCHAR2(1);
2952: l_ytd_amount NUMBER;
2953: l_annual_fte NUMBER;

Line 3150: psb_ws_acct1.cache_budget_calendar

3146: l_budget_calendar_id := c_ws_rec.budget_calendar_id;
3147: l_budget_group_id := c_ws_rec.budget_group_id;
3148: END LOOP;
3149:
3150: psb_ws_acct1.cache_budget_calendar
3151: (
3152: p_return_status => l_return_status ,
3153: p_budget_calendar_id => l_budget_calendar_id
3154: );

Line 3180: p_start_date => PSB_WS_ACCT1.g_startdate_cy,

3176: p_flex_code => l_chart_of_accounts_id,
3177: p_data_extract_id => l_data_extract_id,
3178: p_position_id => l_position_id,
3179: p_position_name => null,
3180: p_start_date => PSB_WS_ACCT1.g_startdate_cy,
3181: p_end_date => PSB_WS_ACCT1.g_end_est_date);
3182:
3183: /* Bug 4379636 End */
3184:

Line 3181: p_end_date => PSB_WS_ACCT1.g_end_est_date);

3177: p_data_extract_id => l_data_extract_id,
3178: p_position_id => l_position_id,
3179: p_position_name => null,
3180: p_start_date => PSB_WS_ACCT1.g_startdate_cy,
3181: p_end_date => PSB_WS_ACCT1.g_end_est_date);
3182:
3183: /* Bug 4379636 End */
3184:
3185: l_rounding_diff := 0;

Line 3192: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

3188: begin
3189:
3190: for c_Element_Dist_Rec in c_Base_Element_Dist loop
3191:
3192: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
3193: l_period_amount(l_index) := null;
3194: end loop;
3195:
3196: /* Bug 4379636 Start */

Line 3243: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

3239: else
3240: l_single_fte_amount := 0;
3241: end if;
3242:
3243: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
3244: if nvl(p_period_fte(l_index),0) = 0 then
3245: l_period_amount(l_index) := NULL;
3246: else
3247: l_period_amount(l_index) := l_single_fte_amount * p_period_fte(l_index);

Line 3267: PSB_WS_ACCT1.Create_Account_Dist

3263: else
3264: l_salary_account_line := FND_API.G_TRUE;
3265: end if;
3266:
3267: PSB_WS_ACCT1.Create_Account_Dist
3268: (p_api_version => 1.0,
3269: p_return_status => l_return_status,
3270: p_account_line_id => l_account_line_id,
3271: p_worksheet_id => p_worksheet_id,

Line 3337: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

3333: begin
3334:
3335: for c_Element_Dist_Rec in c_Element_Dist loop
3336:
3337: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
3338: l_period_amount(l_index) := null;
3339: end loop;
3340:
3341: /* Bug 4379636 Start */

Line 3396: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

3392: else
3393: l_single_fte_amount := 0;
3394: end if;
3395:
3396: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
3397: if nvl(p_period_fte(l_index),0) = 0 then
3398: l_period_amount(l_index) := NULL;
3399: else
3400: l_period_amount(l_index) := l_single_fte_amount * p_period_fte(l_index);

Line 3445: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

3441: else
3442: l_single_fte_amount := 0;
3443: end if;
3444:
3445: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
3446: if nvl(p_period_fte(l_index),0) = 0 then
3447: l_period_amount(l_index) := NULL;
3448: else
3449: l_period_amount(l_index) := l_single_fte_amount * p_period_fte(l_index);

Line 3478: PSB_WS_ACCT1.Create_Account_Dist

3474:
3475: IF NOT l_acct_distributed THEN
3476: /* For Bug No. 2250319 : End */
3477:
3478: PSB_WS_ACCT1.Create_Account_Dist
3479: (p_api_version => 1.0,
3480: p_return_status => l_return_status,
3481: p_worksheet_id => p_worksheet_id,
3482: p_account_line_id => c_Element_Dist_Rec.account_line_id,

Line 4100: l_period_amount PSB_WS_ACCT1.g_prdamt_tbl_type;

4096: l_api_name CONSTANT VARCHAR2(30) := 'Update_Annual_FTE';
4097: l_api_version CONSTANT NUMBER := 1.0;
4098:
4099: l_ytd_amount NUMBER;
4100: l_period_amount PSB_WS_ACCT1.g_prdamt_tbl_type;
4101: l_annual_fte NUMBER;
4102:
4103: l_init_index BINARY_INTEGER;
4104: l_salary_index BINARY_INTEGER;

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

4244: end loop;
4245:
4246: for l_salary_index in 1..g_num_element_dist loop
4247:
4248: for l_init_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
4249: l_period_amount(l_init_index) := null;
4250: end loop;
4251:
4252: l_period_amount(1) := g_element_dist(l_salary_index).period1_amount;

Line 4313: PSB_WS_ACCT1.Create_Account_Dist

4309: l_period_amount(58) := g_element_dist(l_salary_index).period58_amount;
4310: l_period_amount(59) := g_element_dist(l_salary_index).period59_amount;
4311: l_period_amount(60) := g_element_dist(l_salary_index).period60_amount;
4312:
4313: PSB_WS_ACCT1.Create_Account_Dist
4314: (p_api_version => 1.0,
4315: p_return_status => l_return_status,
4316: p_worksheet_id => p_worksheet_id,
4317: p_account_line_id => g_element_dist(l_salary_index).account_line_id,

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

4502:
4503: -- added for bug # 4502946
4504: l_percent := g_salary_dist(l_saldist_index).percent / 100;
4505:
4506: for l_init_index in 1..PSB_WS_ACCT1.g_num_segs loop
4507: l_ccid_val(l_init_index) := null;
4508: l_seg_val(l_init_index) := null;
4509: end loop;
4510:

Line 4516: n_segments => PSB_WS_ACCT1.g_num_segs,

4512: (application_short_name => 'SQLGL',
4513: key_flex_code => 'GL#',
4514: structure_number => p_flex_code,
4515: combination_id => g_salary_dist(l_saldist_index).ccid,
4516: n_segments => PSB_WS_ACCT1.g_num_segs,
4517: segments => l_ccid_val) then
4518:
4519: FND_MSG_PUB.Add;
4520: raise FND_API.G_EXC_ERROR;

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

4519: FND_MSG_PUB.Add;
4520: raise FND_API.G_EXC_ERROR;
4521: end if;
4522:
4523: for l_index in 1..PSB_WS_ACCT1.g_num_segs loop
4524:
4525: if ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') and
4526: (c_Dist_Rec.segment1 is not null)) then
4527: l_seg_val(l_index) := c_Dist_Rec.segment1;

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

4521: end if;
4522:
4523: for l_index in 1..PSB_WS_ACCT1.g_num_segs loop
4524:
4525: if ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') and
4526: (c_Dist_Rec.segment1 is not null)) then
4527: l_seg_val(l_index) := c_Dist_Rec.segment1;
4528:
4529: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') and

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

4525: if ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') and
4526: (c_Dist_Rec.segment1 is not null)) then
4527: l_seg_val(l_index) := c_Dist_Rec.segment1;
4528:
4529: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') and
4530: (c_Dist_Rec.segment2 is not null)) then
4531: l_seg_val(l_index) := c_Dist_Rec.segment2;
4532:
4533: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') and

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

4529: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') and
4530: (c_Dist_Rec.segment2 is not null)) then
4531: l_seg_val(l_index) := c_Dist_Rec.segment2;
4532:
4533: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') and
4534: (c_Dist_Rec.segment3 is not null)) then
4535: l_seg_val(l_index) := c_Dist_Rec.segment3;
4536:
4537: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') and

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

4533: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') and
4534: (c_Dist_Rec.segment3 is not null)) then
4535: l_seg_val(l_index) := c_Dist_Rec.segment3;
4536:
4537: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') and
4538: (c_Dist_Rec.segment4 is not null)) then
4539: l_seg_val(l_index) := c_Dist_Rec.segment4;
4540:
4541: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') and

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

4537: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') and
4538: (c_Dist_Rec.segment4 is not null)) then
4539: l_seg_val(l_index) := c_Dist_Rec.segment4;
4540:
4541: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') and
4542: (c_Dist_Rec.segment5 is not null)) then
4543: l_seg_val(l_index) := c_Dist_Rec.segment5;
4544:
4545: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') and

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

4541: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') and
4542: (c_Dist_Rec.segment5 is not null)) then
4543: l_seg_val(l_index) := c_Dist_Rec.segment5;
4544:
4545: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') and
4546: (c_Dist_Rec.segment6 is not null)) then
4547: l_seg_val(l_index) := c_Dist_Rec.segment6;
4548:
4549: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') and

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

4545: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') and
4546: (c_Dist_Rec.segment6 is not null)) then
4547: l_seg_val(l_index) := c_Dist_Rec.segment6;
4548:
4549: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') and
4550: (c_Dist_Rec.segment7 is not null)) then
4551: l_seg_val(l_index) := c_Dist_Rec.segment7;
4552:
4553: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') and

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

4549: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') and
4550: (c_Dist_Rec.segment7 is not null)) then
4551: l_seg_val(l_index) := c_Dist_Rec.segment7;
4552:
4553: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') and
4554: (c_Dist_Rec.segment8 is not null)) then
4555: l_seg_val(l_index) := c_Dist_Rec.segment8;
4556:
4557: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') and

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

4553: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') and
4554: (c_Dist_Rec.segment8 is not null)) then
4555: l_seg_val(l_index) := c_Dist_Rec.segment8;
4556:
4557: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') and
4558: (c_Dist_Rec.segment9 is not null)) then
4559: l_seg_val(l_index) := c_Dist_Rec.segment9;
4560:
4561: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') and

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

4557: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') and
4558: (c_Dist_Rec.segment9 is not null)) then
4559: l_seg_val(l_index) := c_Dist_Rec.segment9;
4560:
4561: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') and
4562: (c_Dist_Rec.segment10 is not null)) then
4563: l_seg_val(l_index) := c_Dist_Rec.segment10;
4564:
4565: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') and

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

4561: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') and
4562: (c_Dist_Rec.segment10 is not null)) then
4563: l_seg_val(l_index) := c_Dist_Rec.segment10;
4564:
4565: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') and
4566: (c_Dist_Rec.segment11 is not null)) then
4567: l_seg_val(l_index) := c_Dist_Rec.segment11;
4568:
4569: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') and

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

4565: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') and
4566: (c_Dist_Rec.segment11 is not null)) then
4567: l_seg_val(l_index) := c_Dist_Rec.segment11;
4568:
4569: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') and
4570: (c_Dist_Rec.segment12 is not null)) then
4571: l_seg_val(l_index) := c_Dist_Rec.segment12;
4572:
4573: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') and

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

4569: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') and
4570: (c_Dist_Rec.segment12 is not null)) then
4571: l_seg_val(l_index) := c_Dist_Rec.segment12;
4572:
4573: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') and
4574: (c_Dist_Rec.segment13 is not null)) then
4575: l_seg_val(l_index) := c_Dist_Rec.segment13;
4576:
4577: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') and

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

4573: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') and
4574: (c_Dist_Rec.segment13 is not null)) then
4575: l_seg_val(l_index) := c_Dist_Rec.segment13;
4576:
4577: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') and
4578: (c_Dist_Rec.segment14 is not null)) then
4579: l_seg_val(l_index) := c_Dist_Rec.segment14;
4580:
4581: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') and

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

4577: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') and
4578: (c_Dist_Rec.segment14 is not null)) then
4579: l_seg_val(l_index) := c_Dist_Rec.segment14;
4580:
4581: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') and
4582: (c_Dist_Rec.segment15 is not null)) then
4583: l_seg_val(l_index) := c_Dist_Rec.segment15;
4584:
4585: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') and

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

4581: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') and
4582: (c_Dist_Rec.segment15 is not null)) then
4583: l_seg_val(l_index) := c_Dist_Rec.segment15;
4584:
4585: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') and
4586: (c_Dist_Rec.segment16 is not null)) then
4587: l_seg_val(l_index) := c_Dist_Rec.segment16;
4588:
4589: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') and

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

4585: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') and
4586: (c_Dist_Rec.segment16 is not null)) then
4587: l_seg_val(l_index) := c_Dist_Rec.segment16;
4588:
4589: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') and
4590: (c_Dist_Rec.segment17 is not null)) then
4591: l_seg_val(l_index) := c_Dist_Rec.segment17;
4592:
4593: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') and

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

4589: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') and
4590: (c_Dist_Rec.segment17 is not null)) then
4591: l_seg_val(l_index) := c_Dist_Rec.segment17;
4592:
4593: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') and
4594: (c_Dist_Rec.segment18 is not null)) then
4595: l_seg_val(l_index) := c_Dist_Rec.segment18;
4596:
4597: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') and

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

4593: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') and
4594: (c_Dist_Rec.segment18 is not null)) then
4595: l_seg_val(l_index) := c_Dist_Rec.segment18;
4596:
4597: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') and
4598: (c_Dist_Rec.segment19 is not null)) then
4599: l_seg_val(l_index) := c_Dist_Rec.segment19;
4600:
4601: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') and

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

4597: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') and
4598: (c_Dist_Rec.segment19 is not null)) then
4599: l_seg_val(l_index) := c_Dist_Rec.segment19;
4600:
4601: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') and
4602: (c_Dist_Rec.segment20 is not null)) then
4603: l_seg_val(l_index) := c_Dist_Rec.segment20;
4604:
4605: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') and

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

4601: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') and
4602: (c_Dist_Rec.segment20 is not null)) then
4603: l_seg_val(l_index) := c_Dist_Rec.segment20;
4604:
4605: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') and
4606: (c_Dist_Rec.segment21 is not null)) then
4607: l_seg_val(l_index) := c_Dist_Rec.segment21;
4608:
4609: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') and

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

4605: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') and
4606: (c_Dist_Rec.segment21 is not null)) then
4607: l_seg_val(l_index) := c_Dist_Rec.segment21;
4608:
4609: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') and
4610: (c_Dist_Rec.segment22 is not null)) then
4611: l_seg_val(l_index) := c_Dist_Rec.segment22;
4612:
4613: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') and

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

4609: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') and
4610: (c_Dist_Rec.segment22 is not null)) then
4611: l_seg_val(l_index) := c_Dist_Rec.segment22;
4612:
4613: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') and
4614: (c_Dist_Rec.segment23 is not null)) then
4615: l_seg_val(l_index) := c_Dist_Rec.segment23;
4616:
4617: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') and

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

4613: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') and
4614: (c_Dist_Rec.segment23 is not null)) then
4615: l_seg_val(l_index) := c_Dist_Rec.segment23;
4616:
4617: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') and
4618: (c_Dist_Rec.segment24 is not null)) then
4619: l_seg_val(l_index) := c_Dist_Rec.segment24;
4620:
4621: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') and

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

4617: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') and
4618: (c_Dist_Rec.segment24 is not null)) then
4619: l_seg_val(l_index) := c_Dist_Rec.segment24;
4620:
4621: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') and
4622: (c_Dist_Rec.segment25 is not null)) then
4623: l_seg_val(l_index) := c_Dist_Rec.segment25;
4624:
4625: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') and

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

4621: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') and
4622: (c_Dist_Rec.segment25 is not null)) then
4623: l_seg_val(l_index) := c_Dist_Rec.segment25;
4624:
4625: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') and
4626: (c_Dist_Rec.segment26 is not null)) then
4627: l_seg_val(l_index) := c_Dist_Rec.segment26;
4628:
4629: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') and

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

4625: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') and
4626: (c_Dist_Rec.segment26 is not null)) then
4627: l_seg_val(l_index) := c_Dist_Rec.segment26;
4628:
4629: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') and
4630: (c_Dist_Rec.segment27 is not null)) then
4631: l_seg_val(l_index) := c_Dist_Rec.segment27;
4632:
4633: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') and

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

4629: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') and
4630: (c_Dist_Rec.segment27 is not null)) then
4631: l_seg_val(l_index) := c_Dist_Rec.segment27;
4632:
4633: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') and
4634: (c_Dist_Rec.segment28 is not null)) then
4635: l_seg_val(l_index) := c_Dist_Rec.segment28;
4636:
4637: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') and

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

4633: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') and
4634: (c_Dist_Rec.segment28 is not null)) then
4635: l_seg_val(l_index) := c_Dist_Rec.segment28;
4636:
4637: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') and
4638: (c_Dist_Rec.segment29 is not null)) then
4639: l_seg_val(l_index) := c_Dist_Rec.segment29;
4640:
4641: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT30') and

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

4637: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') and
4638: (c_Dist_Rec.segment29 is not null)) then
4639: l_seg_val(l_index) := c_Dist_Rec.segment29;
4640:
4641: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT30') and
4642: (c_Dist_Rec.segment30 is not null)) then
4643: l_seg_val(l_index) := c_Dist_Rec.segment30;
4644:
4645: else

Line 4656: n_segments => PSB_WS_ACCT1.g_num_segs,

4652: (application_short_name => 'SQLGL',
4653: key_flex_code => 'GL#',
4654: structure_number => p_flex_code,
4655: validation_date => sysdate,
4656: n_segments => PSB_WS_ACCT1.g_num_segs,
4657: segments => l_seg_val,
4658: combination_id => l_ccid) then
4659: begin
4660:

Line 4667: (n_segments => PSB_WS_ACCT1.g_num_segs,

4663: key_flex_code => 'GL#',
4664: structure_number => p_flex_code);
4665:
4666: l_concat_segments := FND_FLEX_EXT.Concatenate_Segments
4667: (n_segments => PSB_WS_ACCT1.g_num_segs,
4668: segments => l_seg_val,
4669: delimiter => l_flex_delimiter);
4670:
4671: FND_MSG_PUB.Add;

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

4856: /* Bug 3610713 End */
4857:
4858: BEGIN
4859: /* Bug 3610713 Start */
4860: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years
4861: LOOP
4862:
4863: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN
4864: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;

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

4859: /* Bug 3610713 Start */
4860: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years
4861: LOOP
4862:
4863: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN
4864: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
4865: END IF;
4866:
4867: END LOOP;

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

4860: FOR l_year_index in 1..PSB_WS_ACCT1.g_num_budget_years
4861: LOOP
4862:
4863: IF PSB_WS_ACCT1.g_budget_years(l_year_index).budget_year_id = p_budget_year_id THEN
4864: l_year_start_date := PSB_WS_ACCT1.g_budget_years(l_year_index).start_date;
4865: END IF;
4866:
4867: END LOOP;
4868: /* Bug 3610713 End */

Line 4871: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop

4867: END LOOP;
4868: /* Bug 3610713 End */
4869:
4870: l_num_budget_periods := 0;
4871: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
4872: if (PSB_WS_ACCT1.g_budget_periods(l_year_index).budget_year_id = p_budget_year_id) then
4873: l_num_budget_periods := l_num_budget_periods + 1;
4874: end if;
4875: end loop;

Line 4872: if (PSB_WS_ACCT1.g_budget_periods(l_year_index).budget_year_id = p_budget_year_id) then

4868: /* Bug 3610713 End */
4869:
4870: l_num_budget_periods := 0;
4871: for l_year_index in 1..PSB_WS_ACCT1.g_num_budget_periods loop
4872: if (PSB_WS_ACCT1.g_budget_periods(l_year_index).budget_year_id = p_budget_year_id) then
4873: l_num_budget_periods := l_num_budget_periods + 1;
4874: end if;
4875: end loop;
4876:

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

4884: /* Bug 3610713 Start */
4885: IF l_year_start_date < p_dist_start_date THEN
4886:
4887: l_ctr := 0;
4888: FOR l_period_index IN 1..PSB_WS_ACCT1.g_num_budget_periods
4889: LOOP
4890:
4891: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
4892: p_budget_year_id THEN

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

4887: l_ctr := 0;
4888: FOR l_period_index IN 1..PSB_WS_ACCT1.g_num_budget_periods
4889: LOOP
4890:
4891: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
4892: p_budget_year_id THEN
4893: l_ctr := l_ctr +1 ;
4894: END IF;
4895:

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

4892: p_budget_year_id THEN
4893: l_ctr := l_ctr +1 ;
4894: END IF;
4895:
4896: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
4897: p_budget_year_id AND
4898: p_dist_start_date BETWEEN
4899: PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date AND
4900: PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date THEN

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

4895:
4896: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
4897: p_budget_year_id AND
4898: p_dist_start_date BETWEEN
4899: PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date AND
4900: PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date THEN
4901:
4902: l_start_num := l_ctr;
4903: l_end_num := (l_ctr-1) + ceil(l_dist_periods);

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

4896: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
4897: p_budget_year_id AND
4898: p_dist_start_date BETWEEN
4899: PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date AND
4900: PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date THEN
4901:
4902: l_start_num := l_ctr;
4903: l_end_num := (l_ctr-1) + ceil(l_dist_periods);
4904: END IF;

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

4915: /* Bug 3610713 Start */
4916: IF l_year_start_date < p_dist_start_date THEN
4917:
4918: l_ctr := 0;
4919: FOR l_period_index IN 1..PSB_WS_ACCT1.g_num_budget_periods
4920: LOOP
4921:
4922: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
4923: p_budget_year_id THEN

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

4918: l_ctr := 0;
4919: FOR l_period_index IN 1..PSB_WS_ACCT1.g_num_budget_periods
4920: LOOP
4921:
4922: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
4923: p_budget_year_id THEN
4924: l_ctr := l_ctr +1 ;
4925: END IF;
4926:

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

4923: p_budget_year_id THEN
4924: l_ctr := l_ctr +1 ;
4925: END IF;
4926:
4927: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
4928: p_budget_year_id AND
4929: p_dist_start_date BETWEEN
4930: PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date AND
4931: PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date THEN

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

4926:
4927: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
4928: p_budget_year_id AND
4929: p_dist_start_date BETWEEN
4930: PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date AND
4931: PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date THEN
4932:
4933: l_start_num := l_ctr;
4934: l_end_num := (l_ctr-1) + ceil(l_dist_periods);

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

4927: IF PSB_WS_ACCT1.g_budget_periods(l_period_index).budget_year_id =
4928: p_budget_year_id AND
4929: p_dist_start_date BETWEEN
4930: PSB_WS_ACCT1.g_budget_periods(l_period_index).start_date AND
4931: PSB_WS_ACCT1.g_budget_periods(l_period_index).end_date THEN
4932:
4933: l_start_num := l_ctr;
4934: l_end_num := (l_ctr-1) + ceil(l_dist_periods);
4935: END IF;