[Home] [Help]
PACKAGE: APPS.PQH_BUDGET_ANALYSIS_PKG
Source
1 Package pqh_budget_analysis_pkg as
2 /* $Header: pqbgtanl.pkh 120.0 2005/05/29 01:31:00 appldev noship $ */
3 --
4 --
5 procedure salary_analysis(
6 errbuf out nocopy varchar2
7 , retcode out nocopy varchar2
8 , p_batch_name varchar2 default null
9 , p_effective_date varchar2 default null
10 , p_start_org_id number default null
11 , p_start_date varchar2 default null
12 , p_end_date varchar2 default null
13 , p_business_group_id number default null);
14 --
15 PROCEDURE get_pos_actual_commit_amt(p_position_id in number,
16 p_start_date in date,
17 p_end_date in date,
18 p_effective_date in date,
19 p_actual_amount OUT nocopy number,
20 p_commitment_amount OUT nocopy number,
21 p_total_amount OUT nocopy number
22 );
23
24 --
25 Procedure get_entity(errbuf OUT nocopy varchar2
26 , retcode OUT nocopy varchar2
27 , p_batch_name IN varchar2
28 , p_effective_date IN varchar2
29 , p_start_date IN varchar2
30 , p_end_date IN varchar2
31 , p_entity_code IN varchar2
32 , p_unit_of_measure IN varchar2
33 , p_business_group_id IN number
34 , p_start_org_id IN number default null
35 , p_org_structure_id IN number default null
36 );
37 --
38 Procedure position_analysis(
39 errbuf out nocopy varchar2
40 , retcode out nocopy varchar2
41 , p_batch_name varchar2
42 , p_effective_date varchar2
43 , p_start_org_id number
44 , p_org_structure_id number
45 , p_start_date varchar2
46 , p_end_date varchar2
47 , p_unit_of_measure varchar2
48 , p_business_group_id number
49 );
50
51 --
52 Procedure job_analysis(
53 errbuf out nocopy varchar2
54 , retcode out nocopy varchar2
55 , p_batch_name varchar2
56 , p_effective_date varchar2
57 , p_start_date varchar2
58 , p_end_date varchar2
59 , p_unit_of_measure varchar2
60 , p_business_group_id number
61 );
62 --
63
64 --
65 Procedure grade_analysis(
66 errbuf out nocopy varchar2
67 , retcode out nocopy varchar2
68 , p_batch_name varchar2
69 , p_effective_date varchar2
70 , p_start_date varchar2
71 , p_end_date varchar2
72 , p_unit_of_measure varchar2
73 , p_business_group_id number
74 );
75 --
76 Procedure organization_analysis(
77 errbuf out nocopy varchar2
78 , retcode out nocopy varchar2
79 , p_batch_name varchar2
80 , p_effective_date varchar2
81 , p_start_org_id number
82 , p_org_structure_id number
83 , p_start_date varchar2
84 , p_end_date varchar2
85 , p_unit_of_measure varchar2
86 , p_business_group_id number
87 );
88
89 --
90 FUNCTION fyi_notification (p_transaction_id in number) RETURN varchar2;
91 --
92 function get_budget_currency( p_position_id in number default null
93 ,p_job_id in number default null
94 ,p_grade_id in number default null
95 ,p_organization_id in number default null
96 ,p_budget_entity in varchar2
97 ,p_start_date in date default sysdate
98 ,p_end_date in date default sysdate
99 ,p_effective_date in date default sysdate
100 ,p_business_group_id in number
101 ) return varchar2;
102 end;