[Home] [Help]
PACKAGE: APPS.PA_BUDGET_MATRIX
Source
1 PACKAGE pa_budget_matrix as
2 -- $Header: PAXBUMXS.pls 120.1 2005/08/19 17:10:41 mwasowic noship $
3 --==============================================================
4
5 --
6 -- Define Global Variables, Functions and Procedure
7 --
8
9 -- Define Global Variables
10 -- Global Record
11 TYPE GlobalVars IS RECORD
12 ( Project_id NUMBER(15)
13 , Budget_version_id NUMBER(15)
14 , Task_Id NUMBER(15)
15 , Prd1 DATE
16 , Prd2 DATE
17 , Prd3 DATE
18 , Prd4 DATE
19 , Prd5 DATE
20 , Totals_start_date DATE
21 , Totals_end_date DATE
22 , Raw_cost_flag VARCHAR2(2)
23 , Burdened_cost_flag VARCHAR2(2)
24 , Revenue_flag VARCHAR2(2)
25 , Quantity_flag VARCHAR2(2)
26
27 );
28
29 GlobVars GlobalVars;
30
31 --
32 ------------------------------------------------------------------------------------------
33 -- Define Functions to help pass Global Variables from to Views
34 ------------------------------------------------------------------------------------------
35 --
36
37 -- Derive Project_id
38 FUNCTION Get_Project_id RETURN NUMBER;
39 pragma RESTRICT_REFERENCES ( Get_Project_id, WNDS, WNPS );
40
41 -- Derive Budget_version_id
42 FUNCTION Get_Budget_version_id RETURN NUMBER;
43 pragma RESTRICT_REFERENCES ( Get_Budget_version_id, WNDS, WNPS );
44
45 -- Derive Task Id
46 FUNCTION Get_Task_Id RETURN NUMBER;
47 pragma RESTRICT_REFERENCES ( Get_Task_Id, WNDS, WNPS );
48
49 -- Derive Prd1
50 FUNCTION Get_Prd1 RETURN DATE;
51 pragma RESTRICT_REFERENCES ( Get_prd1, WNDS, WNPS );
52
53 -- Derive Prd2
54 FUNCTION Get_Prd2 RETURN DATE;
55 pragma RESTRICT_REFERENCES ( Get_prd2, WNDS, WNPS );
56
57 -- Derive Prd3
58 FUNCTION Get_Prd3 RETURN DATE;
59 pragma RESTRICT_REFERENCES ( Get_prd3, WNDS, WNPS );
60
61 -- Derive Prd4
62 FUNCTION Get_Prd4 RETURN DATE;
63 pragma RESTRICT_REFERENCES ( Get_prd4, WNDS, WNPS );
64
65 -- Derive Prd5
66 FUNCTION Get_Prd5 RETURN DATE;
67 pragma RESTRICT_REFERENCES ( Get_prd5, WNDS, WNPS );
68
69 -- Derive Totals_start_date
70 FUNCTION Get_totals_start_date RETURN DATE;
71 pragma RESTRICT_REFERENCES ( Get_totals_start_date, WNDS, WNPS );
72
73 -- Derive Totals_end_date
74 FUNCTION Get_totals_end_date RETURN DATE;
75 pragma RESTRICT_REFERENCES ( Get_totals_end_date, WNDS, WNPS );
76
77 -- Derive Raw Cost Flag
78 FUNCTION Get_Raw_Cost_Flag RETURN VARCHAR2;
79 pragma RESTRICT_REFERENCES ( Get_Raw_cost_Flag, WNDS, WNPS );
80
81 -- Derive Burdened Cost Flag
82 FUNCTION Get_Burdened_Cost_Flag RETURN VARCHAR2;
83 pragma RESTRICT_REFERENCES ( Get_Burdened_cost_Flag, WNDS, WNPS );
84
85 -- Derive Quantity Flag
86 FUNCTION Get_Quantity_Flag RETURN VARCHAR2;
87 pragma RESTRICT_REFERENCES ( Get_Quantity_Flag, WNDS, WNPS );
88
89 -- Derive Revenue Flag
90 FUNCTION Get_Revenue_Flag RETURN VARCHAR2;
91 pragma RESTRICT_REFERENCES ( Get_Revenue_Flag, WNDS, WNPS );
92
93 -- Define Procedure to Set Global Variables for Aforementioned Functions
94 --
95
96 PROCEDURE pa_budget_matrix_driver (
97 x_project_id IN NUMBER
98 , x_Budget_version_id IN NUMBER
99 , x_task_id IN NUMBER
100 , x_Prd1 IN DATE
101 , x_Prd2 IN DATE
102 , x_Prd3 IN DATE
103 , x_Prd4 IN DATE
104 , x_Prd5 IN DATE
105 , x_totals_start_date IN DATE
106 , x_totals_end_date IN DATE
107 , x_Raw_cost_flag IN VARCHAR2
108 , x_Burdened_cost_flag IN VARCHAR2
109 , x_Revenue_flag IN VARCHAR2
110 , x_Quantity_flag IN VARCHAR2);
111
112 PROCEDURE pa_calc_side_totals(
113 x_project_id IN NUMBER
114 , x_Budget_version_id IN NUMBER
115 , x_task_id IN NUMBER
116 , x_RLMI IN NUMBER
117 , x_Totals_start_date IN DATE
118 , x_Totals_end_date IN DATE
119 , x_amt_type IN VARCHAR2
120 , x_tot IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
121 , x_tot2 IN OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
122
123
124
125 PROCEDURE pa_calc_bottom_totals(
126 x_project_id IN NUMBER
127 , x_Budget_version_id IN NUMBER
128 , x_task_id IN NUMBER
129 , x_start_date IN DATE
130 , x_end_date IN DATE
131 , x_list_view_totals IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
132 , x_p1 IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
133 , x_p2 IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
134 , x_p3 IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
135 , x_p4 IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
136 , x_p1_tot IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
137 , x_p2_tot IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
138 , x_p3_tot IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
139 , x_p4_tot IN OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
140
141
142 PROCEDURE pa_calc_grand_totals(
143 x_project_id IN NUMBER
144 , x_Budget_version_id IN NUMBER
145 , x_task_id IN NUMBER
146 , x_start_date IN DATE
147 , x_end_date IN DATE
148 , x_list_view_totals IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
149 , x_grand_tot IN OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
150
151
152
153 END pa_budget_matrix;