[Home] [Help]
PACKAGE: APPS.PA_FP_ORG_FCST_UTILS
Source
4 -- Package name : PA_FP_ORG_FCST_UTILS
1 PACKAGE pa_fp_org_fcst_utils AUTHID CURRENT_USER as
2 /* $Header: PAFPORUS.pls 120.2 2005/08/19 16:27:54 mwasowic noship $ */
3 -- Start of Comments
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 /* 20-Mar-2002 SManivannan Added Procedure Get_Tp_Amount_Type */
11
15 ,x_act_period_type OUT NOCOPY gl_periods.period_type%TYPE --File.Sql.39 bug 4440895
12 PROCEDURE get_forecast_option_details
13 ( x_fcst_period_type OUT NOCOPY pa_forecasting_options_all.org_fcst_period_type%TYPE --File.Sql.39 bug 4440895
14 ,x_period_set_name OUT NOCOPY pa_implementations_all.period_set_name%TYPE --File.Sql.39 bug 4440895
16 ,x_org_projfunc_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE --File.Sql.39 bug 4440895
17 ,x_number_of_periods OUT NOCOPY pa_forecasting_options_all.number_of_periods%TYPE --File.Sql.39 bug 4440895
18 ,x_weighted_or_full_code OUT NOCOPY pa_forecasting_options_all.weighted_or_full_code%TYPE --File.Sql.39 bug 4440895
19 ,x_org_proj_template_id OUT NOCOPY pa_forecasting_options_all.org_fcst_project_template_id%TYPE --File.Sql.39 bug 4440895
20 ,x_org_structure_version_id OUT NOCOPY pa_implementations_all.org_structure_version_id%TYPE --File.Sql.39 bug 4440895
21 ,x_fcst_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
22 ,x_fcst_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
23 ,x_org_id OUT NOCOPY pa_implementations_all.org_id%TYPE --File.Sql.39 bug 4440895
24 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25 ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
26
27 PROCEDURE get_org_project_info
28 ( p_organization_id IN hr_organization_units.organization_id%TYPE
29 := NULL
30 ,x_org_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
31 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32 ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
33
34 PROCEDURE get_org_task_info
35 ( p_project_id IN pa_projects_all.project_id%TYPE
36 := NULL
37 ,x_org_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
38 ,x_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE --File.Sql.39 bug 4440895
39 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40 ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
41
42 PROCEDURE get_utilization_details
43 ( p_org_id IN pa_implementations_all.org_id%TYPE
44 := NULL
45 ,p_organization_id IN hr_organization_units.organization_id%TYPE
46 := NULL
47 ,p_period_type IN pa_forecasting_options_all.org_fcst_period_type%TYPE
48 := NULL
49 ,p_period_set_name IN gl_periods.period_set_name%TYPE
50 := NULL
51 ,p_period_name IN gl_periods.period_name%TYPE
52 := NULL
53 ,x_utl_hours OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
54 ,x_utl_capacity OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
55 ,x_utl_percent OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
56 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
57 ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
58
59 PROCEDURE get_headcount
60 ( p_organization_id IN hr_organization_units.organization_id%TYPE
61 := NULL
62 ,p_effective_date IN DATE
63 := NULL
64 ,x_headcount OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
65 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
66 ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
67
68 PROCEDURE get_probability_percent
69 ( p_project_id IN pa_projects_all.project_id%TYPE
70 := NULL
71 ,x_prob_percent OUT NOCOPY pa_probability_members.probability_percentage%TYPE --File.Sql.39 bug 4440895
72 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73 ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
74 PROCEDURE get_period_profile
75 ( p_project_id IN pa_projects_all.project_id%TYPE
76 := NULL
77 ,p_period_profile_type IN pa_proj_period_profiles.period_profile_type%TYPE
78 := NULL
79 ,p_plan_period_type IN pa_forecasting_options.org_fcst_period_type%TYPE
80 := NULL
81 ,p_period_set_name IN gl_periods.period_set_name%TYPE
82 := NULL
83 ,p_act_period_type IN gl_periods.period_type%TYPE
84 := NULL
85 ,p_start_date IN gl_periods.start_date%TYPE
86 := NULL
87 ,p_number_of_periods IN pa_forecasting_options.number_of_periods%TYPE
88 ,x_period_profile_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
89 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90 ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
91
92 FUNCTION check_org_proj_template
93 ( p_project_id IN pa_projects_all.project_id%TYPE
94 := NULL
95 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96 ,x_err_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
97 RETURN VARCHAR2;
98
99 PROCEDURE Get_Tp_Amount_Type(p_project_id IN NUMBER,
100 p_work_type_id IN NUMBER,
101 x_tp_amount_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
102 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
103 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
104 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
105
106 FUNCTION check_org_project
110 ,x_err_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
107 ( p_project_id IN pa_projects_all.project_id%TYPE
108 := NULL
109 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
111 RETURN VARCHAR2;
112
113 FUNCTION calculate_gl_amount
114 ( p_amount_code IN pa_amount_types_b.amount_type_code%TYPE
115 := NULL)
116 RETURN NUMBER;
117
118 FUNCTION calculate_pa_amount
119 ( p_amount_code IN pa_amount_types_b.amount_type_code%TYPE
120 := NULL)
121 RETURN NUMBER;
122
123 /* Dlai 04/21/02 -- added procedure detect_org_project */
124 PROCEDURE detect_org_project
125 ( p_project_id IN pa_projects_all.project_id%TYPE,
126 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
127 x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
128
129 /* Dlai 04/25/02 -- added function same_org_id and procedure check_same_org_id */
130 /* 07/13/05 -- commented out same_org_id and check_same_org_id, because */
131 /* in R12, CLIENT_INFO should no longer be used */
132 /*
133 FUNCTION same_org_id
134 (p_project_id IN pa_projects_all.project_id%TYPE)
135 RETURN VARCHAR2;
136
137 PROCEDURE check_same_org_id
138 (p_project_id IN pa_projects_all.project_id%TYPE,
139 x_return_status OUT VARCHAR2,
140 x_msg_count OUT NUMBER,
141 x_msg_data OUT VARCHAR2);
142 */
143
144 /* for Sheenie: function which takes in only 1 argument:
145 * returns 'Y' if project is an org project
146 * returns 'N' if project is not an org project
147 * returns 'E' if there is an exception error
148 */
149 FUNCTION is_org_project
150 ( p_project_id IN pa_projects_all.project_id%TYPE
151 := NULL)
152 RETURN VARCHAR2;
153
154 END pa_fp_org_fcst_utils;