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.PQH_BUDGET dependencies on PQH_BUDGET

Line 1: package body pqh_budget as

1: package body pqh_budget as
2: /* $Header: pqprochg.pkb 120.3.12000000.2 2007/04/12 13:21:57 brsinha noship $ */
3: type t_org_table is table of number(15) index by binary_integer;
4: p_what_org_is_del t_org_table ;
5: p_what_org_can_del t_org_table ;

Line 18: g_package varchar2(100) := 'PQH_BUDGET.' ;

14: unit2_value number,
15: unit3_value number);
16: type t_prd_table is table of t_prd_rec index by binary_integer;
17: p_prd_unit_tab t_prd_table ;
18: g_package varchar2(100) := 'PQH_BUDGET.' ;
19: procedure lock_worksheet_detail(p_worksheet_detail_id in number,
20: p_object_version_number in number default null,
21: p_status out nocopy varchar2) is
22: l_object_version_number number;

Line 1909: from pqh_budget_versions

1905: p_copy_budget_periods in varchar2,
1906: p_budget_style_cd in varchar,
1907: p_rows_inserted out nocopy number) IS
1908: cursor c0 is select budget_unit1_value,budget_unit2_value,budget_unit3_value
1909: from pqh_budget_versions
1910: where budget_version_id = p_budget_version_id;
1911: cursor c1 is select position_id , grade_id, bud.organization_id organization_id, job_id,budget_detail_id,
1912: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1913: budget_unit1_available,budget_unit2_available,budget_unit3_available,

Line 1916: from pqh_budget_details bud, hr_organization_units org

1912: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1913: budget_unit1_available,budget_unit2_available,budget_unit3_available,
1914: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1915: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1916: from pqh_budget_details bud, hr_organization_units org
1917: where org.business_group_id = p_business_group_id
1918: and bud.organization_id = org.organization_id
1919: and bud.budget_version_id = p_budget_version_id;
1920: cursor c2 is select bud.position_id, bud.grade_id, bud.organization_id , bud.job_id,bud.budget_detail_id,

Line 1931: , pqh_budget_details bud

1927: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
1928: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
1929: union all
1930: select p_start_organization_id organization_id_child from dual )x
1931: , pqh_budget_details bud
1932: where bud.budget_version_id = p_budget_version_id
1933: and bud.organization_id = x.organization_id_child;
1934: cursor c3 is select position_id , grade_id, bud.organization_id organization_id, job_id,budget_detail_id,
1935: budget_unit1_value,budget_unit2_value,budget_unit3_value,

Line 1939: from pqh_budget_details bud, hr_organization_units org

1935: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1936: budget_unit1_available,budget_unit2_available,budget_unit3_available,
1937: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1938: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1939: from pqh_budget_details bud, hr_organization_units org
1940: where org.business_group_id = p_business_group_id
1941: and bud.organization_id = org.organization_id
1942: and pqh_budget.already_budgeted_org(bud.organization_id) = 'FALSE'
1943: and bud.budget_version_id = p_budget_version_id;

Line 1942: and pqh_budget.already_budgeted_org(bud.organization_id) = 'FALSE'

1938: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1939: from pqh_budget_details bud, hr_organization_units org
1940: where org.business_group_id = p_business_group_id
1941: and bud.organization_id = org.organization_id
1942: and pqh_budget.already_budgeted_org(bud.organization_id) = 'FALSE'
1943: and bud.budget_version_id = p_budget_version_id;
1944: cursor c4 is select position_id, grade_id, organization_id , job_id,budget_detail_id,
1945: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1946: budget_unit1_available,budget_unit2_available,budget_unit3_available,

Line 1955: , pqh_budget_details

1951: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
1952: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
1953: union all
1954: select p_start_organization_id organization_id_child from dual )x
1955: , pqh_budget_details
1956: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'
1957: and budget_version_id = p_budget_version_id
1958: and organization_id = x.organization_id_child;
1959: cursor c5 is select position_id ,grade_id, organization_id , job_id,budget_detail_id,

Line 1956: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'

1952: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
1953: union all
1954: select p_start_organization_id organization_id_child from dual )x
1955: , pqh_budget_details
1956: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'
1957: and budget_version_id = p_budget_version_id
1958: and organization_id = x.organization_id_child;
1959: cursor c5 is select position_id ,grade_id, organization_id , job_id,budget_detail_id,
1960: budget_unit1_value,budget_unit2_value,budget_unit3_value,

Line 1964: from pqh_budget_details

1960: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1961: budget_unit1_available,budget_unit2_available,budget_unit3_available,
1962: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1963: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1964: from pqh_budget_details
1965: where pqh_budget.already_budgeted_job(job_id) = 'FALSE'
1966: and budget_version_id = p_budget_version_id;
1967: cursor c6 is select position_id ,grade_id, organization_id , job_id,budget_detail_id,
1968: budget_unit1_value,budget_unit2_value,budget_unit3_value,

Line 1965: where pqh_budget.already_budgeted_job(job_id) = 'FALSE'

1961: budget_unit1_available,budget_unit2_available,budget_unit3_available,
1962: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1963: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1964: from pqh_budget_details
1965: where pqh_budget.already_budgeted_job(job_id) = 'FALSE'
1966: and budget_version_id = p_budget_version_id;
1967: cursor c6 is select position_id ,grade_id, organization_id , job_id,budget_detail_id,
1968: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1969: budget_unit1_available,budget_unit2_available,budget_unit3_available,

Line 1972: from pqh_budget_details

1968: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1969: budget_unit1_available,budget_unit2_available,budget_unit3_available,
1970: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1971: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1972: from pqh_budget_details
1973: where pqh_budget.already_budgeted_grd(grade_id) = 'FALSE'
1974: and budget_version_id = p_budget_version_id;
1975: cursor c7 is select position_id ,grade_id, organization_id , job_id,budget_detail_id,
1976: budget_unit1_value,budget_unit2_value,budget_unit3_value,

Line 1973: where pqh_budget.already_budgeted_grd(grade_id) = 'FALSE'

1969: budget_unit1_available,budget_unit2_available,budget_unit3_available,
1970: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1971: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1972: from pqh_budget_details
1973: where pqh_budget.already_budgeted_grd(grade_id) = 'FALSE'
1974: and budget_version_id = p_budget_version_id;
1975: cursor c7 is select position_id ,grade_id, organization_id , job_id,budget_detail_id,
1976: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1977: budget_unit1_available,budget_unit2_available,budget_unit3_available,

Line 1980: from pqh_budget_details

1976: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1977: budget_unit1_available,budget_unit2_available,budget_unit3_available,
1978: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1979: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1980: from pqh_budget_details
1981: where budget_version_id = p_budget_version_id;
1982: l_budget_unit1_percent number(5,2);
1983: l_budget_unit2_percent number(5,2);
1984: l_budget_unit3_percent number(5,2);

Line 2009: if pqh_budget.already_budgeted_pos(i.position_id) = 'FALSE' then

2005: hr_utility.set_location('budget entity is Position '||l_proc,20);
2006: if p_org_hier_ver is null then
2007: hr_utility.set_location('org hier is null using BG '||l_proc,30);
2008: for i in c1 loop
2009: if pqh_budget.already_budgeted_pos(i.position_id) = 'FALSE' then
2010: l_rows_inserted := l_rows_inserted + 1;
2011: hr_utility.set_location('calculating new % figures'||l_proc,60);
2012: if p_budget_style_cd ='TOP' then
2013: if nvl(p_worksheet_unit1_value,0) <> 0 then

Line 2031: pqh_budget.insert_pos_is_bud(i.position_id);

2027: p_worksheet_unit2_value := nvl(p_worksheet_unit2_value,0) + nvl(i.budget_unit2_value,0) ;
2028: p_worksheet_unit3_value := nvl(p_worksheet_unit3_value,0) + nvl(i.budget_unit3_value,0) ;
2029: end if;
2030: hr_utility.set_location('inserting into plsql table'||l_proc,70);
2031: pqh_budget.insert_pos_is_bud(i.position_id);
2032: hr_utility.set_location('inserting into worksheet_detail table'||l_proc,80);
2033: insert_worksheet_detail(p_worksheet_detail_id => l_worksheet_detail_id
2034: ,p_worksheet_id => p_worksheet_id
2035: ,p_organization_id => i.organization_id

Line 2072: if pqh_budget.already_budgeted_pos(i.position_id) = 'FALSE' then

2068: else
2069: hr_utility.set_location('using org hier '||l_proc,120);
2070: hr_utility.set_location('before insert loop '||l_proc,135);
2071: for i in c2 loop
2072: if pqh_budget.already_budgeted_pos(i.position_id) = 'FALSE' then
2073: hr_utility.set_location('inside insert loop '||l_proc,140);
2074: l_rows_inserted := l_rows_inserted + 1;
2075: if p_budget_style_cd ='TOP' then
2076: hr_utility.set_location('budget style top '||l_proc,141);

Line 2107: pqh_budget.insert_pos_is_bud(i.position_id);

2103: p_worksheet_unit3_value := nvl(p_worksheet_unit3_value,0) + nvl(i.budget_unit3_value,0);
2104: hr_utility.set_location('value recalc '||l_proc,147);
2105: end if;
2106: hr_utility.set_location('going for insert '||l_proc,148);
2107: pqh_budget.insert_pos_is_bud(i.position_id);
2108: insert_worksheet_detail(p_worksheet_detail_id => l_worksheet_detail_id
2109: ,p_worksheet_id => p_worksheet_id
2110: ,p_organization_id => i.organization_id
2111: ,p_job_id => i.job_id

Line 2169: pqh_budget.insert_org_is_bud(i.organization_id);

2165: p_worksheet_unit1_value := nvl(p_worksheet_unit1_value,0) + nvl(i.budget_unit1_value,0);
2166: p_worksheet_unit1_value := nvl(p_worksheet_unit1_value,0) + nvl(i.budget_unit1_value,0);
2167: p_worksheet_unit1_value := nvl(p_worksheet_unit1_value,0) + nvl(i.budget_unit1_value,0);
2168: end if;
2169: pqh_budget.insert_org_is_bud(i.organization_id);
2170: insert_worksheet_detail(p_worksheet_detail_id => l_worksheet_detail_id
2171: ,p_worksheet_id => p_worksheet_id
2172: ,p_organization_id => i.organization_id
2173: ,p_job_id => i.job_id

Line 2227: pqh_budget.insert_org_is_bud(i.organization_id);

2223: p_worksheet_unit1_value := nvl(p_worksheet_unit1_value,0) + nvl(i.budget_unit1_value,0);
2224: p_worksheet_unit2_value := nvl(p_worksheet_unit2_value,0) + nvl(i.budget_unit2_value,0);
2225: p_worksheet_unit3_value := nvl(p_worksheet_unit3_value,0) + nvl(i.budget_unit3_value,0);
2226: end if;
2227: pqh_budget.insert_org_is_bud(i.organization_id);
2228: insert_worksheet_detail
2229: (
2230: p_worksheet_detail_id => l_worksheet_detail_id
2231: ,p_worksheet_id => p_worksheet_id

Line 2294: pqh_budget.insert_job_is_bud(i.job_id);

2290: p_worksheet_unit1_value := nvl(p_worksheet_unit1_value,0) + nvl(i.budget_unit1_value,0);
2291: p_worksheet_unit2_value := nvl(p_worksheet_unit2_value,0) + nvl(i.budget_unit2_value,0);
2292: p_worksheet_unit3_value := nvl(p_worksheet_unit3_value,0) + nvl(i.budget_unit3_value,0);
2293: end if;
2294: pqh_budget.insert_job_is_bud(i.job_id);
2295: insert_worksheet_detail (
2296: p_worksheet_detail_id => l_worksheet_detail_id
2297: ,p_worksheet_id => p_worksheet_id
2298: ,p_organization_id => i.organization_id

Line 2354: pqh_budget.insert_grd_is_bud(i.grade_id);

2350: p_worksheet_unit1_value := nvl(p_worksheet_unit1_value,0) + nvl(i.budget_unit1_value,0);
2351: p_worksheet_unit2_value := nvl(p_worksheet_unit2_value,0) + nvl(i.budget_unit2_value,0);
2352: p_worksheet_unit3_value := nvl(p_worksheet_unit3_value,0) + nvl(i.budget_unit3_value,0);
2353: end if;
2354: pqh_budget.insert_grd_is_bud(i.grade_id);
2355: insert_worksheet_detail (
2356: p_worksheet_detail_id => l_worksheet_detail_id
2357: ,p_worksheet_id => p_worksheet_id
2358: ,p_organization_id => i.organization_id

Line 2470: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;

2466: p_business_group_id in number,
2467: p_rows_inserted out nocopy number) as
2468: l_budget_start_date date;
2469: l_budget_end_date date;
2470: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
2471: l_budget_entity_cd pqh_budgets.budgeted_entity_cd%type;
2472:
2473: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
2474: from pqh_budgets bge, pqh_worksheets wks

Line 2471: l_budget_entity_cd pqh_budgets.budgeted_entity_cd%type;

2467: p_rows_inserted out nocopy number) as
2468: l_budget_start_date date;
2469: l_budget_end_date date;
2470: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
2471: l_budget_entity_cd pqh_budgets.budgeted_entity_cd%type;
2472:
2473: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
2474: from pqh_budgets bge, pqh_worksheets wks
2475: where wks.budget_id = bge.budget_id

Line 2474: from pqh_budgets bge, pqh_worksheets wks

2470: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
2471: l_budget_entity_cd pqh_budgets.budgeted_entity_cd%type;
2472:
2473: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
2474: from pqh_budgets bge, pqh_worksheets wks
2475: where wks.budget_id = bge.budget_id
2476: and wks.worksheet_id = p_worksheet_id;
2477: cursor c1 is select grade_id from per_grades a
2478: where business_group_id = p_business_group_id

Line 2497: if pqh_budget.already_budgeted_grd(i.grade_id) = 'FALSE' then

2493: close c0;
2494: hr_utility.set_location('budget start date '||l_budget_start_date||l_proc,11);
2495: hr_utility.set_location('budget end date '||l_budget_end_date||l_proc,12);
2496: for i in c1 loop
2497: if pqh_budget.already_budgeted_grd(i.grade_id) = 'FALSE' then
2498: l_rows_inserted := l_rows_inserted + 1;
2499: insert_worksheet_detail (
2500: p_worksheet_detail_id => l_worksheet_detail_id
2501: ,p_worksheet_id => p_worksheet_id

Line 2511: pqh_budget.insert_grd_is_bud(i.grade_id);

2507: ,p_budget_detail_id => ''
2508: ,p_parent_worksheet_detail_id => p_parent_worksheet_detail_id
2509: ,p_user_id => ''
2510: ,p_action_cd => 'B');
2511: pqh_budget.insert_grd_is_bud(i.grade_id);
2512: end if;
2513: end loop;
2514: p_rows_inserted := l_rows_inserted;
2515: hr_utility.set_location('exiting '||l_proc,1000);

Line 2527: from pqh_budgets bgt, pqh_worksheets wks

2523: p_rows_inserted out nocopy number) as
2524: l_budget_start_date date;
2525: l_budget_end_date date;
2526: cursor c0 is select budget_start_date,budget_end_date
2527: from pqh_budgets bgt, pqh_worksheets wks
2528: where wks.budget_id = bgt.budget_id
2529: and wks.worksheet_id = p_worksheet_id;
2530: cursor c1 is select job_id from per_jobs
2531: where business_group_id = p_business_group_id

Line 2546: if pqh_budget.already_budgeted_job(i.job_id) = 'FALSE' then

2542: close c0;
2543: hr_utility.set_location('budget start date '||l_budget_start_date||l_proc,11);
2544: hr_utility.set_location('budget end date '||l_budget_end_date||l_proc,12);
2545: for i in c1 loop
2546: if pqh_budget.already_budgeted_job(i.job_id) = 'FALSE' then
2547: l_rows_inserted := l_rows_inserted + 1;
2548: insert_worksheet_detail (
2549: p_worksheet_detail_id => l_worksheet_detail_id
2550: ,p_worksheet_id => p_worksheet_id

Line 2560: pqh_budget.insert_job_is_bud(i.job_id);

2556: ,p_budget_detail_id => ''
2557: ,p_parent_worksheet_detail_id => p_parent_worksheet_detail_id
2558: ,p_user_id => ''
2559: ,p_action_cd => 'B');
2560: pqh_budget.insert_job_is_bud(i.job_id);
2561: end if;
2562: end loop;
2563: p_rows_inserted := l_rows_inserted;
2564: hr_utility.set_location('exiting '||l_proc,1000);

Line 2579: from pqh_budgets bgt, pqh_worksheets wks

2575: p_rows_inserted out nocopy number) as
2576: l_budget_start_date date;
2577: l_budget_end_date date;
2578: cursor c0 is select budget_start_date,budget_end_date
2579: from pqh_budgets bgt, pqh_worksheets wks
2580: where wks.budget_id = bgt.budget_id
2581: and wks.worksheet_id = p_worksheet_id;
2582: cursor c1 is select position_id,job_id,organization_id,availability_status_id
2583: from hr_positions

Line 2621: if pqh_budget.already_budgeted_pos(i.position_id) = 'FALSE'

2617: hr_utility.set_location('budget end date '||l_budget_end_date||l_proc,12);
2618: if p_org_hier_ver is null then
2619: hr_utility.set_location('Business group cursor selected '||l_proc,20);
2620: for i in c1 loop
2621: if pqh_budget.already_budgeted_pos(i.position_id) = 'FALSE'
2622: and pqh_wks_budget.get_position_budget_flag(i.availability_status_id) = 'Y' then
2623: l_rows_inserted := l_rows_inserted + 1;
2624: insert_worksheet_detail (
2625: p_worksheet_detail_id => l_worksheet_detail_id

Line 2636: pqh_budget.insert_pos_is_bud(i.position_id);

2632: ,p_budget_detail_id => ''
2633: ,p_parent_worksheet_detail_id => p_parent_worksheet_detail_id
2634: ,p_user_id => ''
2635: ,p_action_cd => 'B');
2636: pqh_budget.insert_pos_is_bud(i.position_id);
2637: hr_utility.set_location('position inserted '||i.position_id||l_proc,40);
2638: end if;
2639: end loop;
2640: else

Line 2645: if pqh_budget.already_budgeted_pos(i.position_id) = 'FALSE'

2641: hr_utility.set_location('Org hierarchy cursor selected '||l_proc,45);
2642: for k in csr_orgs loop
2643: hr_utility.set_location('Org is'||k.organization_id_child,46);
2644: for i in csr_pos(k.organization_id_child) loop
2645: if pqh_budget.already_budgeted_pos(i.position_id) = 'FALSE'
2646: and pqh_wks_budget.get_position_budget_flag(i.availability_status_id) = 'Y' then
2647: l_rows_inserted := l_rows_inserted + 1;
2648: insert_worksheet_detail ( p_worksheet_detail_id => l_worksheet_detail_id
2649: ,p_worksheet_id => p_worksheet_id

Line 2659: pqh_budget.insert_pos_is_bud(i.position_id);

2655: ,p_budget_detail_id => ''
2656: ,p_parent_worksheet_detail_id => p_parent_worksheet_detail_id
2657: ,p_user_id => ''
2658: ,p_action_cd => 'B');
2659: pqh_budget.insert_pos_is_bud(i.position_id);
2660: hr_utility.set_location('position inserted '||i.position_id||l_proc,50);
2661: end if;
2662: end loop;
2663: end loop;

Line 2680: from pqh_budgets bgt, pqh_worksheets wks

2676: p_rows_inserted out nocopy number) as
2677: l_budget_start_date date;
2678: l_budget_end_date date;
2679: cursor c0 is select budget_start_date,budget_end_date
2680: from pqh_budgets bgt, pqh_worksheets wks
2681: where wks.budget_id = bgt.budget_id
2682: and wks.worksheet_id = p_worksheet_id;
2683: cursor c1 is select organization_id
2684: from hr_organization_units

Line 2688: and pqh_budget.already_budgeted_org(organization_id) = 'FALSE' ;

2684: from hr_organization_units
2685: where business_group_id = p_business_group_id
2686: and date_from < l_budget_end_date
2687: and (date_to > l_budget_start_date or date_to is null)
2688: and pqh_budget.already_budgeted_org(organization_id) = 'FALSE' ;
2689: cursor c2 is select organization_id
2690: from (select organization_id_child from pqh_worksheet_organizations_v
2691: where org_structure_version_id = p_org_hier_ver
2692: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver

Line 2697: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'

2693: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
2694: union all
2695: select p_start_organization_id organization_id_child from dual )x,
2696: hr_organization_units
2697: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'
2698: and date_from < l_budget_end_date
2699: and (date_to > l_budget_start_date or date_to is null)
2700: and organization_id = x.organization_id_child;
2701: l_worksheet_detail_id number;

Line 2729: pqh_budget.insert_org_is_bud(i.organization_id);

2725: ,p_parent_worksheet_detail_id => p_parent_worksheet_detail_id
2726: ,p_user_id => ''
2727: ,p_action_cd => 'B');
2728: hr_utility.set_location('org is added '||i.organization_id||l_proc,30);
2729: pqh_budget.insert_org_is_bud(i.organization_id);
2730: end loop;
2731: else
2732: hr_utility.set_location('oh is used '||l_proc,40);
2733: for i in c2 loop

Line 2748: pqh_budget.insert_org_is_bud(i.organization_id);

2744: ,p_parent_worksheet_detail_id => p_parent_worksheet_detail_id
2745: ,p_user_id => ''
2746: ,p_action_cd => 'B');
2747: hr_utility.set_location('org is added '||i.organization_id||l_proc,50);
2748: pqh_budget.insert_org_is_bud(i.organization_id);
2749: end loop;
2750: end if;
2751: p_rows_inserted := l_rows_inserted;
2752: hr_utility.set_location('entering '||l_proc,10000);

Line 2766: from pqh_budgets bgt, pqh_worksheets wks

2762: p_rows_inserted out nocopy number) as
2763: l_budget_start_date date;
2764: l_budget_end_date date;
2765: cursor c0 is select budget_start_date,budget_end_date
2766: from pqh_budgets bgt, pqh_worksheets wks
2767: where wks.budget_id = bgt.budget_id
2768: and wks.worksheet_id = p_worksheet_id;
2769: cursor c1 is select hier.organization_id_child
2770: from per_org_structure_elements hier, hr_organization_units org

Line 2776: and pqh_budget.already_delegated_org(hier.organization_id_child) = 'FALSE' ;

2772: and org.date_from < l_budget_end_date
2773: and (org.date_to > l_budget_start_date or org.date_to is null)
2774: and org.organization_id = hier.organization_id_child
2775: and hier.organization_id_parent = p_start_organization_id
2776: and pqh_budget.already_delegated_org(hier.organization_id_child) = 'FALSE' ;
2777: l_worksheet_detail_id number;
2778: l_object_version_number number := 1;
2779: l_proc varchar2(100) := g_package||'populate_del_orgs' ;
2780: l_rows_inserted number := 0;

Line 2806: pqh_budget.insert_org_is_del(i.organization_id_child);

2802: ,p_action_cd => 'D'
2803: ,p_status => 'PENDING'
2804: ,p_defer_flag => ''
2805: ,p_propagation_method => p_wks_propagation_method);
2806: pqh_budget.insert_org_is_del(i.organization_id_child);
2807: end loop;
2808: p_rows_inserted := l_rows_inserted;
2809: hr_utility.set_location('exiting '||l_proc,30);
2810: exception when others then

Line 2897: from pqh_budget_periods

2893: budget_unit1_value,budget_unit2_value,budget_unit3_value,
2894: -- budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
2895: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd,
2896: budget_unit1_available,budget_unit2_available,budget_unit3_available
2897: from pqh_budget_periods
2898: where budget_detail_id = p_budget_detail_id;
2899: cursor c2(p_budget_period_id number) is
2900: select budget_set_id,dflt_budget_set_id,
2901: budget_unit1_value,budget_unit2_value,budget_unit3_value,

Line 2905: from pqh_budget_sets

2901: budget_unit1_value,budget_unit2_value,budget_unit3_value,
2902: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd,
2903: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
2904: budget_unit1_available,budget_unit2_available,budget_unit3_available
2905: from pqh_budget_sets
2906: where budget_period_id = p_budget_period_id;
2907: cursor c3(p_budget_set_id number) is
2908: select budget_element_id,element_type_id,distribution_percentage
2909: from pqh_budget_elements

Line 2909: from pqh_budget_elements

2905: from pqh_budget_sets
2906: where budget_period_id = p_budget_period_id;
2907: cursor c3(p_budget_set_id number) is
2908: select budget_element_id,element_type_id,distribution_percentage
2909: from pqh_budget_elements
2910: where budget_set_id = p_budget_set_id;
2911: cursor c4(p_budget_element_id number) is
2912: select cost_allocation_keyflex_id,distribution_percentage
2913: from pqh_budget_fund_srcs

Line 2913: from pqh_budget_fund_srcs

2909: from pqh_budget_elements
2910: where budget_set_id = p_budget_set_id;
2911: cursor c4(p_budget_element_id number) is
2912: select cost_allocation_keyflex_id,distribution_percentage
2913: from pqh_budget_fund_srcs
2914: where budget_element_id = p_budget_element_id;
2915: l_worksheet_period_id number(15,2);
2916: l_worksheet_budget_set_id number(15,2);
2917: l_worksheet_bdgt_elmnt_id number(15,2);

Line 3372: pqh_budget.insert_pos_is_bud(i.position_id);

3368: if p_budgeted_entity_cd ='POSITION' then
3369: delete_pos_is_bud;
3370: delete_pot_is_bud;
3371: for i in c1 loop
3372: pqh_budget.insert_pos_is_bud(i.position_id);
3373: pqh_budget.insert_pot_is_bud(i.position_transaction_id);
3374: end loop;
3375: elsif p_budgeted_entity_cd ='ORGANIZATION' then
3376: delete_org_is_bud;

Line 3373: pqh_budget.insert_pot_is_bud(i.position_transaction_id);

3369: delete_pos_is_bud;
3370: delete_pot_is_bud;
3371: for i in c1 loop
3372: pqh_budget.insert_pos_is_bud(i.position_id);
3373: pqh_budget.insert_pot_is_bud(i.position_transaction_id);
3374: end loop;
3375: elsif p_budgeted_entity_cd ='ORGANIZATION' then
3376: delete_org_is_bud;
3377: for i in c1 loop

Line 3378: pqh_budget.insert_org_is_bud(i.organization_id);

3374: end loop;
3375: elsif p_budgeted_entity_cd ='ORGANIZATION' then
3376: delete_org_is_bud;
3377: for i in c1 loop
3378: pqh_budget.insert_org_is_bud(i.organization_id);
3379: end loop;
3380: elsif p_budgeted_entity_cd ='JOB' then
3381: delete_job_is_bud;
3382: for i in c1 loop

Line 3383: pqh_budget.insert_job_is_bud(i.job_id);

3379: end loop;
3380: elsif p_budgeted_entity_cd ='JOB' then
3381: delete_job_is_bud;
3382: for i in c1 loop
3383: pqh_budget.insert_job_is_bud(i.job_id);
3384: end loop;
3385: elsif p_budgeted_entity_cd ='GRADE' then
3386: delete_grd_is_bud;
3387: for i in c1 loop

Line 3388: pqh_budget.insert_grd_is_bud(i.grade_id);

3384: end loop;
3385: elsif p_budgeted_entity_cd ='GRADE' then
3386: delete_grd_is_bud;
3387: for i in c1 loop
3388: pqh_budget.insert_grd_is_bud(i.grade_id);
3389: end loop;
3390: end if;
3391: hr_utility.set_location('exiting '||l_proc,1000);
3392: end pop_bud_tables;

Line 3396: from pqh_budget_details

3392: end pop_bud_tables;
3393: procedure pop_bud_tables(p_budget_version_id in number,
3394: p_budgeted_entity_cd in varchar) as
3395: cursor c1 is select position_id,job_id,organization_id,grade_id
3396: from pqh_budget_details
3397: where budget_version_id = p_budget_version_id;
3398: l_proc varchar2(100) := g_package||'pop_bud_tables' ;
3399: begin
3400: hr_utility.set_location('entering '||l_proc,10);

Line 3405: pqh_budget.insert_pos_is_bud(i.position_id);

3401: if p_budgeted_entity_cd ='POSITION' then
3402: delete_pos_is_bud;
3403: delete_pot_is_bud;
3404: for i in c1 loop
3405: pqh_budget.insert_pos_is_bud(i.position_id);
3406: end loop;
3407: elsif p_budgeted_entity_cd ='ORGANIZATION' then
3408: delete_org_is_bud;
3409: for i in c1 loop

Line 3410: pqh_budget.insert_org_is_bud(i.organization_id);

3406: end loop;
3407: elsif p_budgeted_entity_cd ='ORGANIZATION' then
3408: delete_org_is_bud;
3409: for i in c1 loop
3410: pqh_budget.insert_org_is_bud(i.organization_id);
3411: end loop;
3412: elsif p_budgeted_entity_cd ='JOB' then
3413: delete_job_is_bud;
3414: for i in c1 loop

Line 3415: pqh_budget.insert_job_is_bud(i.job_id);

3411: end loop;
3412: elsif p_budgeted_entity_cd ='JOB' then
3413: delete_job_is_bud;
3414: for i in c1 loop
3415: pqh_budget.insert_job_is_bud(i.job_id);
3416: end loop;
3417: elsif p_budgeted_entity_cd ='GRADE' then
3418: delete_grd_is_bud;
3419: for i in c1 loop

Line 3420: pqh_budget.insert_grd_is_bud(i.grade_id);

3416: end loop;
3417: elsif p_budgeted_entity_cd ='GRADE' then
3418: delete_grd_is_bud;
3419: for i in c1 loop
3420: pqh_budget.insert_grd_is_bud(i.grade_id);
3421: end loop;
3422: end if;
3423: hr_utility.set_location('exiting '||l_proc,1000);
3424: end pop_bud_tables;

Line 3435: pqh_budget.insert_org_is_del(i.organization_id);

3431: begin
3432: hr_utility.set_location('entering '||l_proc,10);
3433: delete_org_is_del;
3434: for i in c1 loop
3435: pqh_budget.insert_org_is_del(i.organization_id);
3436: end loop;
3437: hr_utility.set_location('exiting '||l_proc,20);
3438: end pop_del_tables;
3439: procedure insert_pot_is_bud(p_pot_id number) as

Line 3840: pqh_budget.post_changes(p_worksheet_detail_id => i.worksheet_detail_id,

3836: p_old_unit1_value => null,
3837: p_old_unit2_value => null,
3838: p_old_unit3_value => null);
3839:
3840: pqh_budget.post_changes(p_worksheet_detail_id => i.worksheet_detail_id,
3841: p_budget_style_cd => p_budget_style_cd,
3842: p_unit1_aggregate => p_unit1_aggregate,
3843: p_unit2_aggregate => p_unit2_aggregate,
3844: p_unit3_aggregate => p_unit3_aggregate);

Line 3851: from pqh_budgets

3847: end post_changes;
3848:
3849: procedure init_prd_tab(p_budget_id in number) as
3850: cursor c1 is select period_set_name,budget_start_date,budget_end_date
3851: from pqh_budgets
3852: where budget_id = p_budget_id;
3853: l_period_set_name pqh_budgets.period_set_name%type;
3854: l_prd_start_date date;
3855: l_prd_end_date date;

Line 3853: l_period_set_name pqh_budgets.period_set_name%type;

3849: procedure init_prd_tab(p_budget_id in number) as
3850: cursor c1 is select period_set_name,budget_start_date,budget_end_date
3851: from pqh_budgets
3852: where budget_id = p_budget_id;
3853: l_period_set_name pqh_budgets.period_set_name%type;
3854: l_prd_start_date date;
3855: l_prd_end_date date;
3856: k number := 1;
3857: cursor c2 is select start_date

Line 4159: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe

4155: p_unit3_aggregate in varchar2) as
4156: cursor c1 is select tps.start_date prd_start_date,tpe.end_date prd_end_date,
4157: prd.budget_unit1_value unit1_value,prd.budget_unit2_value unit2_value,
4158: prd.budget_unit3_value unit3_value
4159: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe
4160: where prd.budget_detail_id = p_budget_detail_id
4161: and prd.start_time_period_id = tps.time_period_id
4162: and prd.end_time_period_id = tpe.time_period_id;
4163: l_proc varchar2(51) := g_package||'add_budgetrow';

Line 4188: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe

4184: p_unit3_aggregate in varchar2) as
4185: cursor c1 is select tps.start_date prd_start_date,tpe.end_date prd_end_date,
4186: prd.budget_unit1_value unit1_value,prd.budget_unit2_value unit2_value,
4187: prd.budget_unit3_value unit3_value
4188: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe
4189: where prd.budget_detail_id = p_budget_detail_id
4190: and prd.start_time_period_id = tps.time_period_id
4191: and prd.end_time_period_id = tpe.time_period_id;
4192: l_proc varchar2(51) := g_package||'sub_budgetrow';

Line 4622: from pqh_budget_periods

4618: procedure copy_budget_details(p_budget_detail_id in number,
4619: p_worksheet_detail_id in number) is
4620: cursor c1(p_budget_detail_id number) is
4621: select budget_period_id,start_time_period_id,end_time_period_id
4622: from pqh_budget_periods
4623: where budget_detail_id = p_budget_detail_id;
4624: cursor c2(p_budget_period_id number) is
4625: select budget_set_id,dflt_budget_set_id
4626: from pqh_budget_sets

Line 4626: from pqh_budget_sets

4622: from pqh_budget_periods
4623: where budget_detail_id = p_budget_detail_id;
4624: cursor c2(p_budget_period_id number) is
4625: select budget_set_id,dflt_budget_set_id
4626: from pqh_budget_sets
4627: where budget_period_id = p_budget_period_id;
4628: cursor c3(p_budget_set_id number) is
4629: select budget_element_id,element_type_id,distribution_percentage
4630: from pqh_budget_elements

Line 4630: from pqh_budget_elements

4626: from pqh_budget_sets
4627: where budget_period_id = p_budget_period_id;
4628: cursor c3(p_budget_set_id number) is
4629: select budget_element_id,element_type_id,distribution_percentage
4630: from pqh_budget_elements
4631: where budget_set_id = p_budget_set_id;
4632: cursor c4(p_budget_element_id number) is
4633: select cost_allocation_keyflex_id,distribution_percentage
4634: from pqh_budget_fund_srcs

Line 4634: from pqh_budget_fund_srcs

4630: from pqh_budget_elements
4631: where budget_set_id = p_budget_set_id;
4632: cursor c4(p_budget_element_id number) is
4633: select cost_allocation_keyflex_id,distribution_percentage
4634: from pqh_budget_fund_srcs
4635: where budget_element_id = p_budget_element_id;
4636: l_worksheet_period_id number(15,2);
4637: l_worksheet_budget_set_id number(15,2);
4638: l_worksheet_bdgt_elmnt_id number(15,2);

Line 4716: from pqh_budget_details bud, hr_organization_units org

4712: p_org_hier_ver in number,
4713: p_copy_budget_periods in varchar2,
4714: p_rows_inserted out nocopy number) IS
4715: cursor c1 is select position_id , grade_id, bud.organization_id organization_id, job_id,budget_detail_id
4716: from pqh_budget_details bud, hr_organization_units org
4717: where org.business_group_id = p_business_group_id
4718: and bud.organization_id = org.organization_id
4719: and pqh_budget.already_budgeted_pos(bud.position_id) = 'FALSE'
4720: and bud.budget_version_id = p_budget_version_id;

Line 4719: and pqh_budget.already_budgeted_pos(bud.position_id) = 'FALSE'

4715: cursor c1 is select position_id , grade_id, bud.organization_id organization_id, job_id,budget_detail_id
4716: from pqh_budget_details bud, hr_organization_units org
4717: where org.business_group_id = p_business_group_id
4718: and bud.organization_id = org.organization_id
4719: and pqh_budget.already_budgeted_pos(bud.position_id) = 'FALSE'
4720: and bud.budget_version_id = p_budget_version_id;
4721: cursor c2 is select bud.position_id, bud.grade_id, bud.organization_id , bud.job_id,bud.budget_detail_id
4722: from (select organization_id_child from pqh_worksheet_organizations_v
4723: where org_structure_version_id = p_org_hier_ver

Line 4728: , pqh_budget_details bud

4724: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
4725: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
4726: union all
4727: select p_start_organization_id organization_id_child from dual )x
4728: , pqh_budget_details bud
4729: where pqh_budget.already_budgeted_pos(bud.position_id) = 'FALSE'
4730: and bud.budget_version_id = p_budget_version_id
4731: and bud.organization_id = x.organization_id_child;
4732: cursor c3 is select position_id , grade_id, bud.organization_id organization_id, job_id,budget_detail_id

Line 4729: where pqh_budget.already_budgeted_pos(bud.position_id) = 'FALSE'

4725: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
4726: union all
4727: select p_start_organization_id organization_id_child from dual )x
4728: , pqh_budget_details bud
4729: where pqh_budget.already_budgeted_pos(bud.position_id) = 'FALSE'
4730: and bud.budget_version_id = p_budget_version_id
4731: and bud.organization_id = x.organization_id_child;
4732: cursor c3 is select position_id , grade_id, bud.organization_id organization_id, job_id,budget_detail_id
4733: from pqh_budget_details bud, hr_organization_units org

Line 4733: from pqh_budget_details bud, hr_organization_units org

4729: where pqh_budget.already_budgeted_pos(bud.position_id) = 'FALSE'
4730: and bud.budget_version_id = p_budget_version_id
4731: and bud.organization_id = x.organization_id_child;
4732: cursor c3 is select position_id , grade_id, bud.organization_id organization_id, job_id,budget_detail_id
4733: from pqh_budget_details bud, hr_organization_units org
4734: where org.business_group_id = p_business_group_id
4735: and bud.organization_id = org.organization_id
4736: and pqh_budget.already_budgeted_org(bud.organization_id) = 'FALSE'
4737: and bud.budget_version_id = p_budget_version_id;

Line 4736: and pqh_budget.already_budgeted_org(bud.organization_id) = 'FALSE'

4732: cursor c3 is select position_id , grade_id, bud.organization_id organization_id, job_id,budget_detail_id
4733: from pqh_budget_details bud, hr_organization_units org
4734: where org.business_group_id = p_business_group_id
4735: and bud.organization_id = org.organization_id
4736: and pqh_budget.already_budgeted_org(bud.organization_id) = 'FALSE'
4737: and bud.budget_version_id = p_budget_version_id;
4738: cursor c4 is select position_id, grade_id, organization_id , job_id,budget_detail_id
4739: from (select organization_id_child from pqh_worksheet_organizations_v
4740: where org_structure_version_id = p_org_hier_ver

Line 4745: , pqh_budget_details

4741: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
4742: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
4743: union all
4744: select p_start_organization_id organization_id_child from dual )x
4745: , pqh_budget_details
4746: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'
4747: and budget_version_id = p_budget_version_id
4748: and organization_id = x.organization_id_child;
4749: cursor c5 is select position_id ,grade_id, organization_id , job_id,budget_detail_id

Line 4746: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'

4742: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
4743: union all
4744: select p_start_organization_id organization_id_child from dual )x
4745: , pqh_budget_details
4746: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'
4747: and budget_version_id = p_budget_version_id
4748: and organization_id = x.organization_id_child;
4749: cursor c5 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4750: from pqh_budget_details

Line 4750: from pqh_budget_details

4746: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'
4747: and budget_version_id = p_budget_version_id
4748: and organization_id = x.organization_id_child;
4749: cursor c5 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4750: from pqh_budget_details
4751: where pqh_budget.already_budgeted_job(job_id) = 'FALSE'
4752: and budget_version_id = p_budget_version_id;
4753: cursor c6 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4754: from pqh_budget_details

Line 4751: where pqh_budget.already_budgeted_job(job_id) = 'FALSE'

4747: and budget_version_id = p_budget_version_id
4748: and organization_id = x.organization_id_child;
4749: cursor c5 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4750: from pqh_budget_details
4751: where pqh_budget.already_budgeted_job(job_id) = 'FALSE'
4752: and budget_version_id = p_budget_version_id;
4753: cursor c6 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4754: from pqh_budget_details
4755: where pqh_budget.already_budgeted_grd(grade_id) = 'FALSE'

Line 4754: from pqh_budget_details

4750: from pqh_budget_details
4751: where pqh_budget.already_budgeted_job(job_id) = 'FALSE'
4752: and budget_version_id = p_budget_version_id;
4753: cursor c6 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4754: from pqh_budget_details
4755: where pqh_budget.already_budgeted_grd(grade_id) = 'FALSE'
4756: and budget_version_id = p_budget_version_id;
4757: cursor c7 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4758: from pqh_budget_details

Line 4755: where pqh_budget.already_budgeted_grd(grade_id) = 'FALSE'

4751: where pqh_budget.already_budgeted_job(job_id) = 'FALSE'
4752: and budget_version_id = p_budget_version_id;
4753: cursor c6 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4754: from pqh_budget_details
4755: where pqh_budget.already_budgeted_grd(grade_id) = 'FALSE'
4756: and budget_version_id = p_budget_version_id;
4757: cursor c7 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4758: from pqh_budget_details
4759: where budget_version_id = p_budget_version_id;

Line 4758: from pqh_budget_details

4754: from pqh_budget_details
4755: where pqh_budget.already_budgeted_grd(grade_id) = 'FALSE'
4756: and budget_version_id = p_budget_version_id;
4757: cursor c7 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4758: from pqh_budget_details
4759: where budget_version_id = p_budget_version_id;
4760: l_rows_inserted number := 0;
4761: l_proc varchar2(100) := g_package||'insert_from_budget' ;
4762: l_worksheet_detail_id number;

Line 4779: pqh_budget.insert_pos_is_bud(i.position_id);

4775: hr_utility.set_location('org hier is null using BG '||l_proc,30);
4776: for i in c1 loop
4777: l_rows_inserted := l_rows_inserted + 1;
4778: hr_utility.set_location('inserting into plsql table'||l_proc,70);
4779: pqh_budget.insert_pos_is_bud(i.position_id);
4780: hr_utility.set_location('inserting into worksheet_detail table'||l_proc,80);
4781: insert_worksheet_detail(p_worksheet_detail_id => l_worksheet_detail_id
4782: ,p_worksheet_id => p_worksheet_id
4783: ,p_organization_id => i.organization_id

Line 4807: pqh_budget.insert_pos_is_bud(i.position_id);

4803: for i in c2 loop
4804: hr_utility.set_location('inside insert loop '||l_proc,140);
4805: l_rows_inserted := l_rows_inserted + 1;
4806: hr_utility.set_location('going for insert '||l_proc,148);
4807: pqh_budget.insert_pos_is_bud(i.position_id);
4808: insert_worksheet_detail(p_worksheet_detail_id => l_worksheet_detail_id
4809: ,p_worksheet_id => p_worksheet_id
4810: ,p_organization_id => i.organization_id
4811: ,p_job_id => i.job_id

Line 4836: pqh_budget.insert_org_is_bud(i.organization_id);

4832: hr_utility.set_location('org hier null using bg '||l_proc,170);
4833: hr_utility.set_location('before insert loop '||l_proc,190);
4834: for i in c3 loop
4835: l_rows_inserted := l_rows_inserted + 1;
4836: pqh_budget.insert_org_is_bud(i.organization_id);
4837: insert_worksheet_detail(p_worksheet_detail_id => l_worksheet_detail_id
4838: ,p_worksheet_id => p_worksheet_id
4839: ,p_organization_id => i.organization_id
4840: ,p_job_id => i.job_id

Line 4861: pqh_budget.insert_org_is_bud(i.organization_id);

4857: hr_utility.set_location('using org hier '||l_proc,210);
4858: hr_utility.set_location('before insert loop '||l_proc,230);
4859: for i in c4 loop
4860: l_rows_inserted := l_rows_inserted + 1;
4861: pqh_budget.insert_org_is_bud(i.organization_id);
4862: insert_worksheet_detail(p_worksheet_detail_id => l_worksheet_detail_id
4863: ,p_worksheet_id => p_worksheet_id
4864: ,p_organization_id => i.organization_id
4865: ,p_job_id => i.job_id

Line 4887: pqh_budget.insert_job_is_bud(i.job_id);

4883: hr_utility.set_location('budget entity job'||l_proc,260);
4884: hr_utility.set_location('before insert loop'||l_proc,270);
4885: for i in c5 loop
4886: l_rows_inserted := l_rows_inserted + 1;
4887: pqh_budget.insert_job_is_bud(i.job_id);
4888: insert_worksheet_detail
4889: (
4890: p_worksheet_detail_id => l_worksheet_detail_id
4891: ,p_worksheet_id => p_worksheet_id

Line 4915: pqh_budget.insert_grd_is_bud(i.grade_id);

4911: hr_utility.set_location('budget entity grade'||l_proc,300);
4912: hr_utility.set_location('before insert loop '||l_proc,310);
4913: for i in c6 loop
4914: l_rows_inserted := l_rows_inserted + 1;
4915: pqh_budget.insert_grd_is_bud(i.grade_id);
4916: insert_worksheet_detail
4917: (
4918: p_worksheet_detail_id => l_worksheet_detail_id
4919: ,p_worksheet_id => p_worksheet_id

Line 5013: FROM pqh_budgets bgt

5009: );
5010: --
5011: CURSOR csr_bgt IS
5012: SELECT currency_code,business_group_id
5013: FROM pqh_budgets bgt
5014: WHERE bgt.budget_id = p_budget_id;
5015: begin
5016: open csr_bgt;
5017: fetch csr_bgt into l_currency_code,l_business_group_id;

Line 5111: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe

5107: p_budget_id in number) as
5108: cursor c1 is select tps.start_date prd_start_date,tpe.end_date prd_end_date,
5109: prd.budget_unit1_value unit1_value,prd.budget_unit2_value unit2_value,
5110: prd.budget_unit3_value unit3_value
5111: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe
5112: where prd.budget_detail_id = p_budget_detail_id
5113: and prd.start_time_period_id = tps.time_period_id
5114: and prd.end_time_period_id = tpe.time_period_id;
5115: l_proc varchar2(51) := g_package||'add_budgetrow';

Line 5173: end pqh_budget;

5169: end loop;
5170: hr_utility.set_location('exit'||l_proc,100);
5171: end add_budgetrow;
5172: --
5173: end pqh_budget;