[Home] [Help]
PACKAGE: APPS.PA_WP_EXCEPTION_UTILS
Source
1 package PA_WP_EXCEPTION_UTILS AUTHID CURRENT_USER as
2 /*$Header: PAWPXCUS.pls 120.1 2005/08/19 17:08:07 mwasowic noship $*/
3
4 -- API name : get_wp_exception_value
5 -- Type : Utils Procedure
6 -- Pre-reqs : None
7 -- Return Value : N/A
8 -- Parameters
9 --
10 -- 25-JUN-01 HSIU -Created
11 --
12
13 procedure get_wp_exception_value
14 (
15 p_object_type IN VARCHAR2,
16 p_object_id IN NUMBER,
17 p_measure_id IN NUMBER,
18 p_period_type IN VARCHAR2,
19 x_measure_value OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
20 x_period_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
21 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
22 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
23 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
24 );
25
26
27 PROCEDURE get_ITD_workplan_effort_var
28 (
29 p_object_type IN VARCHAR2,
30 p_object_id IN NUMBER,
31 p_measure_id IN NUMBER,
32 p_period_type IN VARCHAR2,
33 x_measure_value OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
34 x_period_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
35 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
36 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
37 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
38 );
39
40 PROCEDURE get_forecast_wp_eff_var
41 (
42 p_object_type IN VARCHAR2,
43 p_object_id IN NUMBER,
44 p_measure_id IN NUMBER,
45 p_period_type IN VARCHAR2,
46 x_measure_value OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
47 x_period_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
48 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
49 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
50 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
51 );
52
53 PROCEDURE get_cur_fc_to_pri_effort_var
54 (
55 p_object_type IN VARCHAR2,
56 p_object_id IN NUMBER,
57 p_measure_id IN NUMBER,
58 p_period_type IN VARCHAR2,
59 x_measure_value OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
60 x_period_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
61 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
62 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
63 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
64 );
65
66 PROCEDURE get_sch_bsln_fin_var
67 (
68 p_object_type IN VARCHAR2,
69 p_object_id IN NUMBER,
70 p_measure_id IN NUMBER,
71 p_period_type IN VARCHAR2,
72 x_measure_value OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
73 x_period_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
74 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
75 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
76 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
77 );
78
79 PROCEDURE get_sch_bsln_st_var
80 (
81 p_object_type IN VARCHAR2,
82 p_object_id IN NUMBER,
83 p_measure_id IN NUMBER,
84 p_period_type IN VARCHAR2,
85 x_measure_value OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
86 x_period_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
87 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
88 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
89 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90 );
91
92 PROCEDURE get_sch_pri_pub_ver_fin_var
93 (
94 p_object_type IN VARCHAR2,
95 p_object_id IN NUMBER,
96 p_measure_id IN NUMBER,
97 p_period_type IN VARCHAR2,
98 x_measure_value OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
99 x_period_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
100 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
101 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
102 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
103 );
104
105 PROCEDURE get_sch_pri_pub_ver_st_var
106 (
107 p_object_type IN VARCHAR2,
108 p_object_id IN NUMBER,
109 p_measure_id IN NUMBER,
110 p_period_type IN VARCHAR2,
111 x_measure_value OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
112 x_period_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
113 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
114 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
115 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
116 );
117
118 PROCEDURE get_sch_est_fin_var
119 (
120 p_object_type IN VARCHAR2,
121 p_object_id IN NUMBER,
122 p_measure_id IN NUMBER,
123 p_period_type IN VARCHAR2,
124 x_measure_value OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
125 x_period_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
126 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
127 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
128 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
129 );
130
131 PROCEDURE get_sch_est_st_var
132 (
133 p_object_type IN VARCHAR2,
134 p_object_id IN NUMBER,
135 p_measure_id IN NUMBER,
136 p_period_type IN VARCHAR2,
137 x_measure_value OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
138 x_period_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
139 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
140 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
141 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
142 );
143
144 end PA_WP_EXCEPTION_UTILS;