[Home] [Help]
PACKAGE: APPS.PA_FP_EDIT_LINE_PKG
Source
1 PACKAGE PA_FP_EDIT_LINE_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAFPEDLS.pls 120.2 2005/09/26 11:26:04 rnamburi noship $ */
3
4 /* Variable used for setting function security of current user */
5 G_IS_FN_SECURITY_AVAILABLE varchar2(1);
6
7 PROCEDURE POPULATE_ROLLUP_TMP(
8 p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
9 ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
10 ,p_calling_context IN VARCHAR2
11 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
12 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13 ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
14
15 PROCEDURE DERIVE_PD_SD_START_END_DATES
16 (p_calling_context IN VARCHAR2
17 ,p_pp_st_dt IN pa_budget_lines.start_date%TYPE
18 ,p_pp_end_dt IN pa_budget_lines.start_date%TYPE
19 ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE
20 ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
21 ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE
22 ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
23 ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
24 ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895
25 ,x_sd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
26 ,x_sd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
27 ,x_sd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895
28 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
29 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
30 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
31
32 /* Bug# 2674353 - Included p_calling_context parameter */
33
34 PROCEDURE PROCESS_MODIFIED_LINES
35 ( --Bug Fix: 4569365. Removed MRC code.
36 p_calling_context IN VARCHAR2 --pa_mrc_finplan.g_calling_module%TYPE DEFAULT NULL
37 ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
38 ,p_fin_plan_version_id IN pa_resource_assignments.budget_version_id%TYPE DEFAULT NULL
39 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
41 ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
42
43
44 PROCEDURE GET_ELEMENT_AMOUNT_INFO
45 ( p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
46 ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
47 ,p_calling_context IN VARCHAR2
48 ,x_quantity_flag OUT NOCOPY pa_fin_plan_amount_sets.cost_qty_flag%TYPE --File.Sql.39 bug 4440895
49 ,x_raw_cost_flag OUT NOCOPY pa_fin_plan_amount_sets.raw_cost_flag%TYPE --File.Sql.39 bug 4440895
50 ,x_burdened_cost_flag OUT NOCOPY pa_fin_plan_amount_sets.burdened_cost_flag%TYPE --File.Sql.39 bug 4440895
51 ,x_revenue_flag OUT NOCOPY pa_fin_plan_amount_sets.revenue_flag%TYPE --File.Sql.39 bug 4440895
52 /* Changes for FP.M, Tracking Bug No - 3354518. Adding three new OUT parameters x_bill_rate_flag,
53 x_cost_rate_flag, x_burden_multiplier_flag below for new columns in pa_fin_plan_amount_sets */
54 /* Changes for FP.M, Tracking Bug No - 3354518. Start here*/
55 ,x_bill_rate_flag OUT NOCOPY pa_fin_plan_amount_sets.bill_rate_flag%TYPE --File.Sql.39 bug 4440895
56 ,x_cost_rate_flag OUT NOCOPY pa_fin_plan_amount_sets.cost_rate_flag%TYPE --File.Sql.39 bug 4440895
57 ,x_burden_multiplier_flag OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE --File.Sql.39 bug 4440895
58 /* Changes for FP.M, Tracking Bug No - 3354518. End here*/
59 ,x_period_profile_id OUT NOCOPY pa_proj_periods_denorm.PERIOD_PROFILE_ID%TYPE --File.Sql.39 bug 4440895
60 ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.PLAN_PERIOD_TYPE%TYPE --File.Sql.39 bug 4440895
61 ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
62 ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
63 ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
64 ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
65 ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
66 ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
67 ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
68 ,x_projfunc_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
69 ,x_projfunc_margin_percent OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
70 ,x_proj_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
71 ,x_proj_margin_percent OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
72 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
74 ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
75
76 PROCEDURE CALL_CLIENT_EXTENSIONS
77 ( p_project_id IN pa_projects_all.PROJECT_ID%TYPE
78 ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
79 ,p_task_id IN pa_tasks.TASK_ID%TYPE
80 ,p_resource_list_member_id IN pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE
81 ,p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
82 ,p_resource_id IN pa_resources.RESOURCE_ID%TYPE
83 ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
84 ,p_product_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
85 ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
86 ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
87 ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
88 ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
89 ,px_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
90 ,px_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
91 ,px_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
92 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
93 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
94 ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
95
96 PROCEDURE POPULATE_ELIGIBLE_PERIODS
97 ( p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
98 ,p_period_profile_start_date IN pa_budget_lines.start_date%TYPE
99 ,p_period_profile_end_date IN pa_budget_lines.end_date%TYPE
100 ,p_preceding_prd_start_date IN pa_budget_lines.start_Date%TYPE
101 ,p_succeeding_prd_start_date IN pa_budget_lines.start_Date%TYPE
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 PROCEDURE GET_PRECEDING_SUCCEEDING_AMT(
107 p_budget_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE -- Added for #2839138
108 ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
109 ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
110 ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
111 ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
112 ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
113 ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
114 ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
115 ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
116 ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
117 ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
118 ,x_succeeding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
119 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
120 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
121 ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
122
123 FUNCTION get_is_fn_security_available RETURN VARCHAR2;
124
125 PROCEDURE CALL_CLIENT_EXTENSIONS
126 ( p_project_id IN pa_projects_all.PROJECT_ID%TYPE
127 ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
128 ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type
129 ,p_res_list_member_id_tbl IN SYSTEM.pa_num_tbl_type
130 ,p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
131 ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type
132 ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
133 ,p_product_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
134 ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
135 ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
136 ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
137 ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
138 ,px_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
139 ,px_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
140 ,px_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
141 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
142 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
143 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
144 ) ;
145
146 PROCEDURE Find_dup_rows_in_rollup_tmp
147 ( x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
148 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
149 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
150
151 PROCEDURE GET_PD_SD_AMT_IN_PC_PFC(
152 p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
153 ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
154 ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
155 ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
156 ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
157 ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
158 ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
159 ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
160 ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
161 ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
162 ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
163 ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
164 ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
165 ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
166 ,x_sd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
167 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
168 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
169 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
170
171 PROCEDURE PROCESS_BDGTLINES_FOR_VERSION
172 ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
173 ,p_calling_context IN VARCHAR2
174 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
175 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
176 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
177 );
178
179 END PA_FP_EDIT_LINE_PKG ;
180
181
182