APPS.PQH_WKS_BUDGET dependencies on PQH_WORKSHEET_DETAILS

Line 48: cursor c1 is select parent_worksheet_detail_id from pqh_worksheet_details

44: */
45: end;
46:
47: function can_apply(p_worksheet_detail_id in number) return varchar2 is
48: cursor c1 is select parent_worksheet_detail_id from pqh_worksheet_details
49: where worksheet_detail_id = p_worksheet_detail_id;
50: l_apply varchar2(30) := 'Y';
51: begin
52: for i in c1 loop

Line 63: cursor c1 is select status from pqh_worksheet_details

59: return l_apply;
60: end;
61:
62: function can_approve(p_worksheet_detail_id in number) return varchar2 is
63: cursor c1 is select status from pqh_worksheet_details
64: where action_cd ='D'
65: and parent_worksheet_detail_id = p_worksheet_detail_id;
66: l_approve varchar2(30) := 'YES';
67: -- as discussed with dinesh, right now, we will return force when there is any delegated worksheet

Line 102: from pqh_budgets bgt,pqh_worksheets wks, pqh_worksheet_details wkd

98: p_unit1_desc out nocopy varchar2,
99: p_unit2_desc out nocopy varchar2,
100: p_unit3_desc out nocopy varchar2) is
101: cursor c1 is select budget_unit1_id,budget_unit2_id,budget_unit3_id
102: from pqh_budgets bgt,pqh_worksheets wks, pqh_worksheet_details wkd
103: where wkd.worksheet_id = wks.worksheet_id
104: and wks.budget_id = bgt.budget_id
105: and wkd.worksheet_detail_id = p_worksheet_detail_id;
106: l_budget_unit1_id pqh_budgets.budget_unit1_id%type;

Line 206: from pqh_worksheet_details

202: function get_parent_value(p_worksheet_detail_id in number,
203: p_worksheet_propagate_code in varchar2) return varchar2 is
204: cursor c1(p_worksheet_detail_id number) is
205: select parent_worksheet_detail_id,worksheet_id
206: from pqh_worksheet_details
207: where worksheet_detail_id = p_worksheet_detail_id ;
208: cursor c2(p_worksheet_detail_id number) is
209: select propagation_method,worksheet_detail_id
210: from pqh_worksheet_details

Line 210: from pqh_worksheet_details

206: from pqh_worksheet_details
207: where worksheet_detail_id = p_worksheet_detail_id ;
208: cursor c2(p_worksheet_detail_id number) is
209: select propagation_method,worksheet_detail_id
210: from pqh_worksheet_details
211: where worksheet_detail_id = p_worksheet_detail_id ;
212: cursor c3(p_worksheet_id number) is
213: select propagation_method
214: from pqh_worksheets

Line 307: cursor c0 is select worksheet_id,propagation_method from pqh_worksheet_details

303: return l_desc;
304: end lookup_desc;
305: procedure wkd_propagation_method(p_worksheet_detail_id in number,
306: p_propagation_method out nocopy varchar2 ) is
307: cursor c0 is select worksheet_id,propagation_method from pqh_worksheet_details
308: where worksheet_detail_id = p_worksheet_detail_id ;
309: l_change_mode varchar2(3);
310: l_wks_change_mode varchar2(3);
311: l_effective_change_mode varchar2(3);

Line 414: from pqh_worksheet_details wkd, pqh_worksheets wks

410: p_unit2_precision out nocopy number,
411: p_unit3_precision out nocopy number ) is
412: l_budget_id number;
413: cursor c1 is select wks.budget_id
414: from pqh_worksheet_details wkd, pqh_worksheets wks
415: where wkd.worksheet_detail_id = p_worksheet_detail_id
416: and wkd.worksheet_id = wks.worksheet_id;
417: begin
418: open c1;

Line 456: from pqh_worksheets wks, pqh_worksheet_details wkd, pqh_budgets bgt

452: p_unit1_aggregate out nocopy varchar2,
453: p_unit2_aggregate out nocopy varchar2,
454: p_unit3_aggregate out nocopy varchar2 ) is
455: cursor c1 is select bgt.budget_unit1_aggregate,bgt.budget_unit2_aggregate,bgt.budget_unit3_aggregate
456: from pqh_worksheets wks, pqh_worksheet_details wkd, pqh_budgets bgt
457: where wks.worksheet_id = wkd.worksheet_id
458: and wks.budget_id = bgt.budget_id
459: and wkd.worksheet_detail_id = p_worksheet_detail_id;
460: begin

Line 584: from pqh_worksheet_details

580: p_member_cd in varchar,
581: p_action_date in date,
582: p_transaction_category_id in number) is
583: cursor c1 is select worksheet_detail_id,user_id,status,defer_flag,object_version_number
584: from pqh_worksheet_details
585: where action_cd ='D'
586: and parent_worksheet_detail_id = p_worksheet_detail_id
587: and nvl(defer_flag,'N') = 'N'
588: and user_id is not null

Line 786: from pqh_worksheet_details

782:
783: cursor c1 is select worksheet_detail_id,object_version_number,
784: budget_unit1_value,budget_unit2_value,budget_unit3_value,
785: old_unit1_value,old_unit2_value,old_unit3_value
786: from pqh_worksheet_details
787: where parent_worksheet_detail_id = p_worksheet_detail_id
788: and action_cd ='D';
789: l_object_version_number number;
790: l_budget_unit1_value number;

Line 1226: cursor c1 is select worksheet_id from pqh_worksheet_details

1222: close c1;
1223: return l_budget_id;
1224: end get_wks_budget;
1225: function get_wkd_budget( p_worksheet_detail_id in number) return number is
1226: cursor c1 is select worksheet_id from pqh_worksheet_details
1227: where worksheet_detail_id = p_worksheet_detail_id;
1228: l_worksheet_id number;
1229: l_budget_id number;
1230: begin

Line 1498: from pqh_worksheets wks, pqh_worksheet_details wkd

1494: l_org_id number;
1495: l_transaction_name varchar2(300);
1496: cursor c1 is
1497: select wks.worksheet_name,wkd.organization_id
1498: from pqh_worksheets wks, pqh_worksheet_details wkd
1499: where wkd.worksheet_id = wks.worksheet_id
1500: and worksheet_detail_id = p_worksheet_detail_id
1501: and nvl(action_cd,'D') ='D';
1502: begin

Line 1660: update pqh_worksheet_details

1656: end valid_position_txn;
1657: */
1658: procedure update_wkd_pot(p_worksheet_detail_id number) is
1659: begin
1660: update pqh_worksheet_details
1661: set position_transaction_id = null
1662: where worksheet_detail_id = p_worksheet_detail_id;
1663: end update_wkd_pot;
1664:

Line 1709: from pqh_worksheet_details where worksheet_detail_id = p_worksheet_detail_id;

1705: end loop;
1706:
1707: select parent_worksheet_detail_id,budget_unit1_value,budget_unit2_value,budget_unit3_value,object_version_number
1708: into l_parent_wkd_id,l_budget_unit1_value,l_budget_unit2_value,l_budget_unit3_value,l_object_version_number
1709: from pqh_worksheet_details where worksheet_detail_id = p_worksheet_detail_id;
1710:
1711: if p_budget_style_cd ='TOP' then
1712: update pqh_worksheet_details
1713: set budget_unit1_available = nvl(budget_unit1_available,0) - nvl(l_budget_unit1_value,0),

Line 1712: update pqh_worksheet_details

1708: into l_parent_wkd_id,l_budget_unit1_value,l_budget_unit2_value,l_budget_unit3_value,l_object_version_number
1709: from pqh_worksheet_details where worksheet_detail_id = p_worksheet_detail_id;
1710:
1711: if p_budget_style_cd ='TOP' then
1712: update pqh_worksheet_details
1713: set budget_unit1_available = nvl(budget_unit1_available,0) - nvl(l_budget_unit1_value,0),
1714: budget_unit2_available = nvl(budget_unit2_available,0) - nvl(l_budget_unit2_value,0),
1715: budget_unit3_available = nvl(budget_unit3_available,0) - nvl(l_budget_unit3_value,0)
1716: where worksheet_detail_id = l_parent_wkd_id;

Line 1718: update pqh_worksheet_details

1714: budget_unit2_available = nvl(budget_unit2_available,0) - nvl(l_budget_unit2_value,0),
1715: budget_unit3_available = nvl(budget_unit3_available,0) - nvl(l_budget_unit3_value,0)
1716: where worksheet_detail_id = l_parent_wkd_id;
1717: else
1718: update pqh_worksheet_details
1719: set budget_unit1_value = nvl(budget_unit1_value,0) - nvl(l_budget_unit1_value,0),
1720: budget_unit2_value = nvl(budget_unit2_value,0) - nvl(l_budget_unit2_value,0),
1721: budget_unit3_value = nvl(budget_unit3_value,0) - nvl(l_budget_unit3_value,0)
1722: where worksheet_detail_id = l_parent_wkd_id;

Line 1724: pqh_worksheet_details_api.DELETE_WORKSHEET_DETAIL(

1720: budget_unit2_value = nvl(budget_unit2_value,0) - nvl(l_budget_unit2_value,0),
1721: budget_unit3_value = nvl(budget_unit3_value,0) - nvl(l_budget_unit3_value,0)
1722: where worksheet_detail_id = l_parent_wkd_id;
1723: end if;
1724: pqh_worksheet_details_api.DELETE_WORKSHEET_DETAIL(
1725: P_WORKSHEET_DETAIL_ID => p_worksheet_detail_id,
1726: P_EFFECTIVE_DATE => trunc(sysdate),
1727: P_OBJECT_VERSION_NUMBER => l_object_version_number);
1728: end purge_wkd;

Line 1739: from pqh_worksheet_details

1735: l_budget_style_cd varchar2(80);
1736: l_worksheet_detail_id number;
1737: cursor c_worksheet_detail is
1738: select position_id,worksheet_detail_id
1739: from pqh_worksheet_details
1740: where worksheet_detail_id = p_worksheet_detail_id;
1741: begin
1742: /*
1743: ---------- logic of the program --------------------------------