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 790: from pqh_worksheet_details

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

Line 1231: cursor c1 is select worksheet_id from pqh_worksheet_details

1227: close c1;
1228: return l_budget_id;
1229: end get_wks_budget;
1230: function get_wkd_budget( p_worksheet_detail_id in number) return number is
1231: cursor c1 is select worksheet_id from pqh_worksheet_details
1232: where worksheet_detail_id = p_worksheet_detail_id;
1233: l_worksheet_id number;
1234: l_budget_id number;
1235: begin

Line 1503: from pqh_worksheets wks, pqh_worksheet_details wkd

1499: l_org_id number;
1500: l_transaction_name varchar2(300);
1501: cursor c1 is
1502: select wks.worksheet_name,wkd.organization_id
1503: from pqh_worksheets wks, pqh_worksheet_details wkd
1504: where wkd.worksheet_id = wks.worksheet_id
1505: and worksheet_detail_id = p_worksheet_detail_id
1506: and nvl(action_cd,'D') ='D';
1507: begin

Line 1665: update pqh_worksheet_details

1661: end valid_position_txn;
1662: */
1663: procedure update_wkd_pot(p_worksheet_detail_id number) is
1664: begin
1665: update pqh_worksheet_details
1666: set position_transaction_id = null
1667: where worksheet_detail_id = p_worksheet_detail_id;
1668: end update_wkd_pot;
1669:

Line 1714: from pqh_worksheet_details where worksheet_detail_id = p_worksheet_detail_id;

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

Line 1717: update pqh_worksheet_details

1713: into l_parent_wkd_id,l_budget_unit1_value,l_budget_unit2_value,l_budget_unit3_value,l_object_version_number
1714: from pqh_worksheet_details where worksheet_detail_id = p_worksheet_detail_id;
1715:
1716: if p_budget_style_cd ='TOP' then
1717: update pqh_worksheet_details
1718: set budget_unit1_available = nvl(budget_unit1_available,0) - nvl(l_budget_unit1_value,0),
1719: budget_unit2_available = nvl(budget_unit2_available,0) - nvl(l_budget_unit2_value,0),
1720: budget_unit3_available = nvl(budget_unit3_available,0) - nvl(l_budget_unit3_value,0)
1721: where worksheet_detail_id = l_parent_wkd_id;

Line 1723: update pqh_worksheet_details

1719: budget_unit2_available = nvl(budget_unit2_available,0) - nvl(l_budget_unit2_value,0),
1720: budget_unit3_available = nvl(budget_unit3_available,0) - nvl(l_budget_unit3_value,0)
1721: where worksheet_detail_id = l_parent_wkd_id;
1722: else
1723: update pqh_worksheet_details
1724: set budget_unit1_value = nvl(budget_unit1_value,0) - nvl(l_budget_unit1_value,0),
1725: budget_unit2_value = nvl(budget_unit2_value,0) - nvl(l_budget_unit2_value,0),
1726: budget_unit3_value = nvl(budget_unit3_value,0) - nvl(l_budget_unit3_value,0)
1727: where worksheet_detail_id = l_parent_wkd_id;

Line 1729: pqh_worksheet_details_api.DELETE_WORKSHEET_DETAIL(

1725: budget_unit2_value = nvl(budget_unit2_value,0) - nvl(l_budget_unit2_value,0),
1726: budget_unit3_value = nvl(budget_unit3_value,0) - nvl(l_budget_unit3_value,0)
1727: where worksheet_detail_id = l_parent_wkd_id;
1728: end if;
1729: pqh_worksheet_details_api.DELETE_WORKSHEET_DETAIL(
1730: P_WORKSHEET_DETAIL_ID => p_worksheet_detail_id,
1731: P_EFFECTIVE_DATE => trunc(sysdate),
1732: P_OBJECT_VERSION_NUMBER => l_object_version_number);
1733: end purge_wkd;

Line 1744: from pqh_worksheet_details

1740: l_budget_style_cd varchar2(80);
1741: l_worksheet_detail_id number;
1742: cursor c_worksheet_detail is
1743: select position_id,worksheet_detail_id
1744: from pqh_worksheet_details
1745: where worksheet_detail_id = p_worksheet_detail_id;
1746: begin
1747: /*
1748: ---------- logic of the program --------------------------------