1 package pqh_wks_budget AUTHID CURRENT_USER as
2 /* $Header: pqwksbud.pkh 120.0.12020000.1 2012/06/28 06:50:18 appldev ship $ */
3 function valid_grade(p_position_id in number default null,
4 p_job_id in number default null,
5 p_grade_id in number) return varchar2 ;
6 function can_approve(p_worksheet_detail_id in number) return varchar2 ;
7 function can_apply(p_worksheet_detail_id in number) return varchar2 ;
8 PROCEDURE get_all_unit_desc(p_worksheet_detail_id in number,
9 p_unit1_desc out nocopy varchar2,
10 p_unit2_desc out nocopy varchar2,
11 p_unit3_desc out nocopy varchar2) ;
12 function get_unit_desc(p_unit_id in number) return varchar2 ;
13 function get_unit_type(p_unit_id in number) return varchar2 ;
14 function get_org_hier(p_org_structure_version_id in number) return varchar2 ;
15 function get_parent_value(p_worksheet_detail_id in number,
16 p_worksheet_propagate_code in varchar2) return varchar2 ;
17
18 function get_value(p_worksheet_detail_id in number,
19 p_worksheet_propagate_code in varchar2,
20 code in varchar2) return varchar2 ;
21
22 function lookup_desc(p_lookup_type in varchar2,
23 p_lookup_code in varchar2) return varchar2 ;
24 procedure wkd_propagation_method(p_worksheet_detail_id in number,
25 p_propagation_method out nocopy varchar2 ) ;
26
27 procedure delegating_org (p_worksheet_detail_id in number,
28 p_forwarded_by_user_id in number,
29 p_member_cd in varchar,
30 p_action_date in date,
31 p_transaction_category_id in number) ;
32 procedure get_bgt_unit_precision(p_budget_id in number,
33 p_unit1_precision out nocopy number,
34 p_unit2_precision out nocopy number,
35 p_unit3_precision out nocopy number ) ;
36 procedure get_wks_unit_precision(p_worksheet_id in number,
37 p_unit1_precision out nocopy number,
38 p_unit2_precision out nocopy number,
39 p_unit3_precision out nocopy number ) ;
40 procedure get_wkd_unit_precision(p_worksheet_detail_id in number,
41 p_unit1_precision out nocopy number,
42 p_unit2_precision out nocopy number,
43 p_unit3_precision out nocopy number ) ;
44 procedure get_wks_unit_aggregate(p_worksheet_id in number,
45 p_unit1_aggregate out nocopy varchar2,
46 p_unit2_aggregate out nocopy varchar2,
47 p_unit3_aggregate out nocopy varchar2 ) ;
48 procedure get_wkd_unit_aggregate(p_worksheet_detail_id in number,
49 p_unit1_aggregate out nocopy varchar2,
50 p_unit2_aggregate out nocopy varchar2,
51 p_unit3_aggregate out nocopy varchar2 ) ;
52 procedure insert_budgetset(p_dflt_budget_set_id number,
53 p_worksheet_budget_set_id number) ;
54 procedure insert_budgetset(p_dflt_budget_set_id number,
55 p_budget_set_id number) ;
56 procedure wks_date_validation( p_worksheet_mode in varchar2,
57 p_budget_id in number,
58 p_budget_version_id in number default null,
59 p_wks_start_date in date,
60 p_wks_end_date in date,
61 p_wks_ll_date out nocopy date,
62 p_wks_ul_date out nocopy date,
63 p_status out nocopy varchar2) ;
64 procedure propagate_bottom_up(p_worksheet_detail_id in number,
65 p_budget_unit1_value in out nocopy number,
66 p_budget_unit2_value in out nocopy number,
67 p_budget_unit3_value in out nocopy number,
68 p_status out nocopy varchar2);
69 procedure populate_bud_grades(p_budget_version_id in number,
70 p_business_group_id in number,
71 p_rows_inserted out nocopy number) ;
72 procedure populate_bud_jobs(p_budget_version_id in number,
73 p_business_group_id in number,
74 p_rows_inserted out nocopy number) ;
75 procedure populate_bud_positions(p_budget_version_id in number,
76 p_org_hier_ver in number,
77 p_start_organization_id in number,
78 p_business_group_id in number,
79 p_rows_inserted out nocopy number) ;
80 procedure populate_bud_organizations(p_budget_version_id in number,
81 p_org_hier_ver in number,
82 p_start_organization_id in number,
83 p_business_group_id in number,
84 p_rows_inserted out nocopy number) ;
85 function get_wkd_budget(p_worksheet_detail_id number) return number;
86 function get_wks_budget(p_worksheet_id number) return number;
87 function get_bgd_budget(p_budget_detail_id number) return number;
88 procedure insert_default_period(p_worksheet_detail_id in number,
89 p_wkd_ovn in out nocopy number,
90 p_worksheet_unit1_value in number default null,
91 p_worksheet_unit2_value in number default null,
92 p_worksheet_unit3_value in number default null,
93 p_worksheet_period_id out nocopy number,
94 p_wpr_ovn out nocopy number) ;
95 procedure apply_wks(p_transaction_id in number,
96 p_transaction_category_id in number,
97 p_wkd_ovn out nocopy number,
98 p_wks_ovn out nocopy number) ;
99 procedure pending_wks(p_transaction_id in number,
100 p_transaction_category_id in number,
101 p_wkd_ovn out nocopy number,
102 p_wks_ovn out nocopy number) ;
103 procedure approve_wks(p_transaction_id in number,
104 p_transaction_category_id in number,
105 p_wkd_ovn out nocopy number,
106 p_wks_ovn out nocopy number) ;
107 procedure reject_wks(p_transaction_id in number,
108 p_transaction_category_id in number,
109 p_wkd_ovn out nocopy number,
110 p_wks_ovn out nocopy number) ;
111 function get_transaction_name(p_worksheet_detail_id in number) return varchar2;
112 Function check_job_pos_for_valid_grd(p_position_id number default null,
113 p_job_id number default null,
114 p_grade_id number default null,
115 p_valid_grade_flag varchar2 default null)
116 Return varchar2;
117 Function get_valid_grade(p_position_id number default null,
118 p_job_id number default null,
119 p_grade_id number default null,
120 p_start_bud_date date,
121 p_end_bud_date date)
122 Return varchar2;
123 Function get_position_budget_flag(p_availability_status_id in number)
124 return varchar2;
125 procedure delete_wkd(p_worksheet_detail_id in number,
126 p_object_version_number in number) ;
127 FUNCTION PQH_CHECK_GMS_INSTALLED RETURN varchar2;
128 end pqh_wks_budget;