APPS.PQH_BUDGET dependencies on PQH_WORKSHEET_DETAILS

Line 24: from pqh_worksheet_details

20: p_object_version_number in number default null,
21: p_status out nocopy varchar2) is
22: l_object_version_number number;
23: cursor c0 is select object_version_number
24: from pqh_worksheet_details
25: where worksheet_detail_id = p_worksheet_detail_id;
26: l_proc varchar2(100) := g_package||'lck_wkd';
27: begin
28: -- return 'N' if lock failed else return 'Y'

Line 69: cursor c2 is select user_id from pqh_worksheet_details

65: where transaction_id = p_worksheet_detail_id
66: and transaction_category_id = p_transaction_category_id
67: and routing_history_id = l_max_routing_history_id ;
68: -- for pulling up the manager for the delegated worksheet
69: cursor c2 is select user_id from pqh_worksheet_details
70: where worksheet_detail_id = p_worksheet_detail_id;
71: -- for pulling up the user_details
72: cursor c4(p_user_id number) is select user_name from fnd_user
73: where user_id = p_user_id;

Line 149: from pqh_worksheet_details

145: p_transaction_category_id in number,
146: p_status in out nocopy varchar2,
147: p_working_users in out nocopy varchar2) is
148: cursor c1 is select worksheet_detail_id
149: from pqh_worksheet_details
150: where parent_worksheet_detail_id = p_worksheet_detail_id;
151: l_working_user varchar2(200);
152: l_user_type varchar2(30);
153: l_proc varchar2(100) := g_package||'lck_child' ;

Line 192: from pqh_worksheet_details

188: p_transaction_category_id in number,
189: p_status in out nocopy varchar2,
190: p_working_users in out nocopy varchar2) is
191: cursor c1 is select worksheet_detail_id
192: from pqh_worksheet_details
193: where parent_worksheet_detail_id = p_worksheet_detail_id
194: and action_cd ='D';
195: l_working_user varchar2(200);
196: l_user_type varchar2(30);

Line 245: from pqh_worksheet_details

241: l_workflow_name varchar2(200);
242: l_itemkey varchar2(200);
243: cursor c_child is
244: select worksheet_detail_id,status,object_version_number
245: from pqh_worksheet_details
246: where action_cd ='D'
247: and parent_worksheet_detail_id = p_worksheet_detail_id;
248: l_proc varchar2(100) := g_package||'complete_workflow' ;
249: l_wkd_ovn number;

Line 263: from pqh_worksheet_details wkd, pqh_worksheets wks

259: hr_utility.set_location('workflow name is '||l_workflow_name||l_proc,20);
260: select wkd.status,wkd.parent_worksheet_detail_id,wkd.object_version_number,
261: wks.worksheet_id,wks.object_version_number
262: into l_status,l_parent_wkd_id,l_wkd_ovn,l_worksheet_id,l_wks_ovn
263: from pqh_worksheet_details wkd, pqh_worksheets wks
264: where wkd.worksheet_detail_id = p_worksheet_detail_id
265: and wkd.worksheet_id = wks.worksheet_id;
266: if p_result_status = 'REJECT' then
267: hr_utility.set_location('result_status is '||p_result_status||l_proc,30);

Line 457: from pqh_worksheet_details wkd, pqh_worksheets wks

453: p_status => p_result_status);
454: -- status is changed to terminated, get the ovn's
455: select wkd.object_version_number,wks.object_version_number
456: into l_wkd_ovn,l_wks_ovn
457: from pqh_worksheet_details wkd, pqh_worksheets wks
458: where wkd.worksheet_detail_id = p_worksheet_detail_id
459: and wkd.worksheet_id = wks.worksheet_id;
460: end if;
461: select wkd.object_version_number, wks.object_version_number

Line 463: from pqh_worksheet_details wkd, pqh_worksheets wks

459: and wkd.worksheet_id = wks.worksheet_id;
460: end if;
461: select wkd.object_version_number, wks.object_version_number
462: into l_wkd_ovn,l_wks_ovn
463: from pqh_worksheet_details wkd, pqh_worksheets wks
464: where wkd.worksheet_detail_id = p_worksheet_detail_id
465: and wkd.worksheet_id = wks.worksheet_id;
466: p_wkd_object_version_number := l_wkd_ovn;
467: p_wks_object_version_number := l_wks_ovn;

Line 495: from pqh_worksheet_details

491: budget_unit1_value_type_cd,
492: budget_unit2_value_type_cd,
493: budget_unit3_value_type_cd,
494: status,organization_id,worksheet_detail_id,object_version_number,propagation_method
495: from pqh_worksheet_details
496: where parent_worksheet_detail_id = p_worksheet_detail_id
497: and action_cd ='D'
498: and status ='APPROVED'
499: for update of status;

Line 502: from pqh_worksheet_details

498: and status ='APPROVED'
499: for update of status;
500: cursor c2 is select budget_unit1_available,budget_unit2_available,
501: budget_unit3_available,worksheet_detail_id,object_version_number
502: from pqh_worksheet_details
503: where worksheet_detail_id = p_worksheet_detail_id;
504: l_chg_unit1_available number;
505: l_chg_unit2_available number;
506: l_chg_unit3_available number;

Line 597: from pqh_worksheet_details

593: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd,
594: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
595: budget_unit1_available,budget_unit2_available,budget_unit3_available,
596: object_version_number
597: from pqh_worksheet_details
598: where parent_worksheet_detail_id = p_worksheet_detail_id
599: and nvl(action_cd,'D') = 'B'
600: for update of budget_unit1_value,budget_unit2_value,budget_unit3_value,
601: budget_unit1_available,budget_unit2_available,budget_unit3_available,

Line 610: from pqh_worksheet_details

606: old_unit1_value,old_unit2_value,old_unit3_value,
607: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd,
608: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
609: budget_unit1_available,budget_unit2_available,budget_unit3_available
610: from pqh_worksheet_details
611: where parent_worksheet_detail_id = p_worksheet_detail_id
612: and nvl(action_cd,'D') = 'D'
613: for update of status,budget_unit1_value,budget_unit2_value,budget_unit3_value,
614: old_unit1_value,old_unit2_value,old_unit3_value,

Line 618: from pqh_worksheets wks, pqh_worksheet_details wkd

614: old_unit1_value,old_unit2_value,old_unit3_value,
615: budget_unit1_available,budget_unit2_available,budget_unit3_available,
616: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent ;
617: cursor c3 is select wks.propagation_method
618: from pqh_worksheets wks, pqh_worksheet_details wkd
619: where wks.worksheet_id = wkd.worksheet_id
620: and worksheet_detail_id = p_worksheet_detail_id;
621: l_budget_unit1_value number;
622: l_budget_unit2_value number;

Line 1524: from pqh_worksheet_details

1520: budget_unit1_percent,budget_unit1_value,budget_unit1_value_type_cd,
1521: budget_unit2_percent,budget_unit2_value,budget_unit2_value_type_cd,
1522: budget_unit3_percent,budget_unit3_value,budget_unit3_value_type_cd,
1523: object_version_number
1524: from pqh_worksheet_details
1525: where parent_worksheet_detail_id = p_parent_wd_id
1526: and action_cd ='B'
1527: for update of parent_worksheet_detail_id ,budget_unit1_percent,budget_unit2_percent,budget_unit3_percent;
1528:

Line 1661: from pqh_worksheet_details

1657: end delegate_adjustment ;
1658:
1659: procedure delete_delegate(p_worksheet_detail_id in number) as
1660: cursor c1 is select worksheet_detail_id,rowid row_id
1661: from pqh_worksheet_details
1662: where parent_worksheet_detail_id = p_worksheet_detail_id
1663: and action_cd ='D'
1664: for update of worksheet_detail_id ;
1665: cursor c2(p_parent_wd_id number) is

Line 1667: from pqh_worksheet_details

1663: and action_cd ='D'
1664: for update of worksheet_detail_id ;
1665: cursor c2(p_parent_wd_id number) is
1666: select count(*)
1667: from pqh_worksheet_details
1668: where parent_worksheet_detail_id = p_parent_wd_id;
1669: l_count number;
1670: l_proc varchar2(100) := g_package||'delete_delegate' ;
1671: begin

Line 1692: delete from pqh_worksheet_details where rowid = i.row_id;

1688: delete_delegate(i.worksheet_detail_id);
1689: end if;
1690: hr_utility.set_location('deleting worksheet detail '||i.worksheet_detail_id||l_proc,30);
1691: hr_utility.set_location('deleting worksheet detail rowid 2 - '||i.row_id||l_proc,30);
1692: delete from pqh_worksheet_details where rowid = i.row_id;
1693: end loop;
1694: hr_utility.set_location('exiting '||l_proc,1000);
1695: end delete_delegate;
1696:

Line 1700: from pqh_worksheet_details

1696:
1697: procedure delete_delegate_chk(p_worksheet_detail_id in number,
1698: p_status_flag out nocopy number) as
1699: cursor c1 is select worksheet_detail_id,status
1700: from pqh_worksheet_details
1701: where parent_worksheet_detail_id = p_worksheet_detail_id
1702: and action_cd ='D'
1703: for update of worksheet_detail_id ;
1704: cursor c2(p_parent_wd_id number) is

Line 1706: from pqh_worksheet_details

1702: and action_cd ='D'
1703: for update of worksheet_detail_id ;
1704: cursor c2(p_parent_wd_id number) is
1705: select count(*)
1706: from pqh_worksheet_details
1707: where parent_worksheet_detail_id = p_parent_wd_id
1708: and action_cd ='D';
1709: l_proc varchar2(100) := g_package||'delete_delegate_chk' ;
1710: l_status number;

Line 1756: from pqh_worksheet_details

1752: p_budget_unit2_available in out nocopy number,
1753: p_budget_unit3_available in out nocopy number)
1754: is
1755: cursor c2 is select worksheet_detail_id
1756: from pqh_worksheet_details
1757: where action_cd ='D'
1758: and parent_worksheet_detail_id = p_delegate_wd_id ;
1759: cursor c1 is select action_cd,parent_worksheet_detail_id,worksheet_detail_id,
1760: budget_unit1_percent,budget_unit1_value,budget_unit1_value_type_cd,

Line 1764: from pqh_worksheet_details

1760: budget_unit1_percent,budget_unit1_value,budget_unit1_value_type_cd,
1761: budget_unit2_percent,budget_unit2_value,budget_unit2_value_type_cd,
1762: budget_unit3_percent,budget_unit3_value,budget_unit3_value_type_cd,
1763: object_version_number
1764: from pqh_worksheet_details
1765: where action_cd = 'B'
1766: and parent_worksheet_detail_id = p_delegate_wd_id
1767: for update of parent_worksheet_detail_id,budget_unit1_percent,budget_unit2_percent,budget_unit3_percent ;
1768: l_budget_unit1_percent number(15,2);

Line 2819: from pqh_worksheet_details

2815: procedure copy_all_budget_details(p_worksheet_id in number) as
2816: cursor c1 is select worksheet_detail_id,budget_detail_id,object_version_number,
2817: budget_unit1_value,budget_unit2_value,budget_unit3_value,
2818: budget_unit1_available,budget_unit2_available,budget_unit3_available
2819: from pqh_worksheet_details
2820: where worksheet_id = p_worksheet_id
2821: and action_cd ='B'
2822: and budget_detail_id is not null
2823: for update of budget_unit1_available,budget_unit2_available,budget_unit3_available;

Line 3362: from pqh_worksheet_details

3358: end already_budgeted_pos;
3359: procedure pop_bud_tables(p_parent_worksheet_detail_id in number,
3360: p_budgeted_entity_cd in varchar) as
3361: cursor c1 is select position_id,job_id,organization_id,grade_id,position_transaction_id
3362: from pqh_worksheet_details
3363: where parent_worksheet_detail_id = p_parent_worksheet_detail_id
3364: and action_cd ='B';
3365: l_proc varchar2(100) := g_package||'pop_bud_tables' ;
3366: begin

Line 3427: from pqh_worksheet_details

3423: hr_utility.set_location('exiting '||l_proc,1000);
3424: end pop_bud_tables;
3425: procedure pop_del_tables(p_parent_worksheet_detail_id in number) as
3426: cursor c1 is select organization_id
3427: from pqh_worksheet_details
3428: where parent_worksheet_detail_id = p_parent_worksheet_detail_id
3429: and action_cd ='D' ;
3430: l_proc varchar2(100) := g_package||'pop_del_tables' ;
3431: begin

Line 3775: from pqh_worksheet_details

3771: cursor c1 is select worksheet_detail_id,propagation_method,object_version_number,
3772: old_unit1_value,old_unit2_value,old_unit3_value,
3773: budget_unit1_value,budget_unit2_value,budget_unit3_value,
3774: budget_unit1_available,budget_unit2_available,budget_unit3_available
3775: from pqh_worksheet_details
3776: where parent_worksheet_detail_id = p_worksheet_detail_id
3777: and action_cd ='D'
3778: for update of old_unit1_value,old_unit2_value,old_unit3_value,
3779: budget_unit1_available,budget_unit2_available,budget_unit3_available;

Line 4417: pqh_worksheet_details_api.create_worksheet_detail_bp(

4413: p_copy_budget_periods in varchar2 default 'N'
4414: ) is
4415: l_object_version_number number;
4416: begin
4417: pqh_worksheet_details_api.create_worksheet_detail_bp(
4418: p_validate => FALSE
4419: ,p_worksheet_detail_id => p_worksheet_detail_id
4420: ,p_worksheet_id => p_worksheet_id
4421: ,p_organization_id => p_organization_id

Line 4497: pqh_worksheet_details_api.update_worksheet_detail(

4493: begin
4494: hr_utility.set_location('entering'||l_proc,10);
4495: hr_utility.set_location('wkd id is'||p_worksheet_detail_id||l_proc,11);
4496: hr_utility.set_location('ovn is'||p_object_version_number||l_proc,12);
4497: pqh_worksheet_details_api.update_worksheet_detail(
4498: p_validate => FALSE
4499: ,p_worksheet_detail_id => p_worksheet_detail_id
4500: ,p_worksheet_id => p_worksheet_id
4501: ,p_organization_id => p_organization_id