eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_BUDGET_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 112: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

108: /*Parameters due fin plan model */
109: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
110: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
111: ,p_version_type IN pa_budget_versions.version_type%TYPE
112: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
113: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
114: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
115: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
116: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

Line 113: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE

109: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
110: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
111: ,p_version_type IN pa_budget_versions.version_type%TYPE
112: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
113: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
114: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
115: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
116: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
117: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

Line 114: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE

110: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
111: ,p_version_type IN pa_budget_versions.version_type%TYPE
112: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
113: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
114: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
115: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
116: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
117: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
118: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

Line 115: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

111: ,p_version_type IN pa_budget_versions.version_type%TYPE
112: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
113: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
114: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
115: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
116: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
117: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
118: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
119: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

Line 116: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

112: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
113: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
114: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
115: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
116: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
117: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
118: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
119: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
120: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

Line 117: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

113: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
114: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
115: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
116: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
117: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
118: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
119: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
120: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
121: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

Line 118: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

114: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
115: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
116: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
117: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
118: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
119: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
120: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
121: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
122: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

Line 119: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

115: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
116: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
117: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
118: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
119: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
120: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
121: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
122: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
123: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

Line 120: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

116: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
117: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
118: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
119: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
120: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
121: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
122: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
123: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
124: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

Line 121: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

117: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
118: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
119: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
120: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
121: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
122: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
123: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
124: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
125: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

Line 122: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

118: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
119: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
120: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
121: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
122: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
123: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
124: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
125: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
126: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

Line 123: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

119: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
120: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
121: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
122: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
123: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
124: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
125: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
126: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
127: ,p_raw_cost_flag IN VARCHAR2

Line 124: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

120: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
121: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
122: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
123: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
124: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
125: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
126: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
127: ,p_raw_cost_flag IN VARCHAR2
128: ,p_burdened_cost_flag IN VARCHAR2

Line 125: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

121: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
122: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
123: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
124: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
125: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
126: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
127: ,p_raw_cost_flag IN VARCHAR2
128: ,p_burdened_cost_flag IN VARCHAR2
129: ,p_revenue_flag IN VARCHAR2

Line 126: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

122: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
123: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
124: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
125: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
126: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
127: ,p_raw_cost_flag IN VARCHAR2
128: ,p_burdened_cost_flag IN VARCHAR2
129: ,p_revenue_flag IN VARCHAR2
130: ,p_cost_qty_flag IN VARCHAR2

Line 211: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;

207:
208: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
209: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
210: l_version_type pa_budget_versions.version_type%TYPE ;
211: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
212: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
213: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
214: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
215: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;

Line 212: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;

208: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
209: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
210: l_version_type pa_budget_versions.version_type%TYPE ;
211: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
212: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
213: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
214: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
215: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
216: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;

Line 213: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

209: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
210: l_version_type pa_budget_versions.version_type%TYPE ;
211: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
212: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
213: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
214: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
215: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
216: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
217: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

Line 214: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;

210: l_version_type pa_budget_versions.version_type%TYPE ;
211: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
212: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
213: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
214: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
215: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
216: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
217: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
218: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;

Line 215: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;

211: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
212: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
213: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
214: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
215: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
216: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
217: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
218: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
219: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

Line 216: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;

212: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
213: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
214: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
215: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
216: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
217: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
218: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
219: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
220: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

Line 217: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

213: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
214: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
215: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
216: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
217: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
218: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
219: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
220: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
221: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

Line 218: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;

214: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
215: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
216: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
217: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
218: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
219: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
220: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
221: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
222: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

Line 219: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

215: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
216: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
217: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
218: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
219: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
220: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
221: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
222: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
223: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

Line 220: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

216: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
217: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
218: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
219: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
220: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
221: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
222: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
223: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
224: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

Line 221: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

217: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
218: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
219: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
220: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
221: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
222: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
223: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
224: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
225: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

Line 222: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

218: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
219: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
220: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
221: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
222: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
223: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
224: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
225: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
226: l_raw_cost_flag VARCHAR2(1) ;

Line 223: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

219: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
220: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
221: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
222: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
223: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
224: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
225: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
226: l_raw_cost_flag VARCHAR2(1) ;
227: l_burdened_cost_flag VARCHAR2(1);

Line 224: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

220: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
221: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
222: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
223: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
224: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
225: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
226: l_raw_cost_flag VARCHAR2(1) ;
227: l_burdened_cost_flag VARCHAR2(1);
228: l_revenue_flag VARCHAR2(1);

Line 225: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

221: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
222: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
223: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
224: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
225: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
226: l_raw_cost_flag VARCHAR2(1) ;
227: l_burdened_cost_flag VARCHAR2(1);
228: l_revenue_flag VARCHAR2(1);
229: l_cost_qty_flag VARCHAR2(1);

Line 261: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

257: l_module_name VARCHAR2(80);
258: l_debug_level3 CONSTANT NUMBER := 3;
259: l_debug_level5 CONSTANT NUMBER := 5;
260: j NUMBER;
261: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
262: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
263: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;
264: l_user_id NUMBER := 0;
265: l_resp_id NUMBER := 0;

Line 2618: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

2614:
2615: --Changes the default of the following parameters from NULL to G_PA_MISS_XXX 24-APR-03 by Xin Liu
2616: ,p_txn_currency_code IN pa_fp_txn_currencies.txn_currency_code%TYPE
2617: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2618: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2619: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2620: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2621: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2622: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

Line 2620: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

2616: ,p_txn_currency_code IN pa_fp_txn_currencies.txn_currency_code%TYPE
2617: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2618: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2619: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2620: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2621: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2622: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2623: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2624: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE

Line 2622: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

2618: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2619: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2620: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2621: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2622: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2623: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2624: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2625: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2626: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

Line 2626: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

2622: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2623: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2624: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2625: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2626: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2627: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2628: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2629: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2630: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

Line 2628: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

2624: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2625: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2626: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2627: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2628: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2629: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2630: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2631: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2632: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE

Line 2630: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

2626: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2627: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2628: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2629: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2630: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2631: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2632: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2633: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2634: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

Line 2634: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

2630: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2631: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2632: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2633: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2634: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2635: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2636: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2637: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2638: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

Line 2636: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

2632: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2633: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2634: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2635: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2636: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2637: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2638: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2639: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2640: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE

Line 2638: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

2634: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2635: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2636: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2637: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2638: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2639: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2640: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
2641: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2642: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

Line 2642: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

2638: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2639: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2640: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
2641: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2642: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2643: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2644: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2645: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2646: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

Line 2644: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

2640: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
2641: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2642: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2643: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2644: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2645: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2646: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2647: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2648: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE

Line 2646: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

2642: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2643: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2644: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2645: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2646: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2647: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2648: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
2649: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2650: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE

Line 2886: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

2882: --Added the following parameters for changes in AMG due to finplan model
2883: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
2884: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
2885: ,p_version_type IN pa_budget_versions.version_type%TYPE
2886: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2887: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2888: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2889: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2890: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

Line 2887: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE

2883: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
2884: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
2885: ,p_version_type IN pa_budget_versions.version_type%TYPE
2886: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2887: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2888: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2889: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2890: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2891: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

Line 2888: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE

2884: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
2885: ,p_version_type IN pa_budget_versions.version_type%TYPE
2886: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2887: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2888: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2889: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2890: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2891: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2892: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

Line 2889: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

2885: ,p_version_type IN pa_budget_versions.version_type%TYPE
2886: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2887: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2888: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2889: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2890: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2891: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2892: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2893: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

Line 2890: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

2886: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2887: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2888: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2889: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2890: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2891: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2892: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2893: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2894: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

Line 2891: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

2887: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2888: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2889: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2890: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2891: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2892: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2893: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2894: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2895: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

Line 2892: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

2888: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2889: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2890: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2891: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2892: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2893: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2894: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2895: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2896: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

Line 2893: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

2889: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2890: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2891: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2892: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2893: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2894: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2895: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2896: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2897: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

Line 2894: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

2890: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2891: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2892: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2893: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2894: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2895: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2896: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2897: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2898: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

Line 2895: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

2891: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2892: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2893: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2894: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2895: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2896: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2897: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2898: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2899: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

Line 2896: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

2892: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2893: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2894: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2895: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2896: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2897: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2898: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2899: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2900: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

Line 2897: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

2893: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2894: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2895: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2896: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2897: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2898: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2899: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2900: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2901: ,p_raw_cost_flag IN VARCHAR2

Line 2898: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

2894: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2895: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2896: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2897: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2898: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2899: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2900: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2901: ,p_raw_cost_flag IN VARCHAR2
2902: ,p_burdened_cost_flag IN VARCHAR2

Line 2899: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

2895: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2896: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2897: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2898: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2899: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2900: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2901: ,p_raw_cost_flag IN VARCHAR2
2902: ,p_burdened_cost_flag IN VARCHAR2
2903: ,p_revenue_flag IN VARCHAR2

Line 2900: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

2896: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2897: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2898: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2899: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2900: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2901: ,p_raw_cost_flag IN VARCHAR2
2902: ,p_burdened_cost_flag IN VARCHAR2
2903: ,p_revenue_flag IN VARCHAR2
2904: ,p_cost_qty_flag IN VARCHAR2

Line 3431: c_fin_plan_type_id pa_proj_fp_options.proj_fp_options_id%TYPE)

3427:
3428: -- Needed to check whether the plan type id passed is attached to the project or Not
3429: CURSOR l_plan_type_option_csr
3430: (c_project_id pa_projects_all.project_id%TYPE,
3431: c_fin_plan_type_id pa_proj_fp_options.proj_fp_options_id%TYPE)
3432: IS
3433: SELECT 'X'
3434: FROM pa_proj_fp_options pfo
3435: WHERE pfo.project_id=c_project_id

Line 3434: FROM pa_proj_fp_options pfo

3430: (c_project_id pa_projects_all.project_id%TYPE,
3431: c_fin_plan_type_id pa_proj_fp_options.proj_fp_options_id%TYPE)
3432: IS
3433: SELECT 'X'
3434: FROM pa_proj_fp_options pfo
3435: WHERE pfo.project_id=c_project_id
3436: AND pfo.fin_plan_type_id=c_fin_plan_type_id
3437: AND pfo.fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
3438:

Line 3475: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

3471: l_debug_level4 CONSTANT NUMBER := 4;
3472: l_debug_level5 CONSTANT NUMBER := 5;
3473: l_version_type pa_budget_Versions.version_type%TYPE;
3474: l_security_ret_code VARCHAR2(1);
3475: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3476: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3477: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3478: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;
3479: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;

Line 3477: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

3473: l_version_type pa_budget_Versions.version_type%TYPE;
3474: l_security_ret_code VARCHAR2(1);
3475: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3476: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3477: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3478: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;
3479: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;
3480: l_CW_record_version_number pa_budget_Versions.record_version_number%TYPE;
3481: l_any_error_occurred_flag VARCHAR2(1);

Line 5186: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

5182: l_budget_version_id NUMBER;
5183: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
5184: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5185: l_budget_amount_code pa_budget_types.budget_amount_code%type;
5186: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
5187: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
5188: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
5189: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
5190: l_record_version_number pa_budget_versions.record_version_number%TYPE;

Line 5187: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

5183: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
5184: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5185: l_budget_amount_code pa_budget_types.budget_amount_code%type;
5186: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
5187: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
5188: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
5189: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
5190: l_record_version_number pa_budget_versions.record_version_number%TYPE;
5191:

Line 5188: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

5184: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5185: l_budget_amount_code pa_budget_types.budget_amount_code%type;
5186: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
5187: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
5188: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
5189: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
5190: l_record_version_number pa_budget_versions.record_version_number%TYPE;
5191:
5192: l_resource_name VARCHAR2(80); --bug 3711693

Line 5204: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;

5200: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
5201: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
5202:
5203: --Following parameters are needed for amounts check
5204: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
5205: lx_raw_cost_flag VARCHAR2(1) := NULL;
5206: lx_burdened_cost_flag VARCHAR2(1) := NULL;
5207: lx_revenue_flag VARCHAR2(1) := NULL;
5208: lx_cost_qty_flag VARCHAR2(1) := NULL;

Line 6241: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

6237: l_result VARCHAR2(1);
6238: l_record_version_number pa_budget_versions.record_version_number%TYPE;
6239: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6240: --Added by Xin Liu. 28-APR-03
6241: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6242: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6243: ll_version_type pa_budget_versions.version_type%TYPE;
6244: ll_version_number pa_budget_versions.version_number%TYPE;
6245:

Line 6940: --pa_proj_fp_options table and increase the record_version_no

6936: --Bug 4224464: Following DMLs have been added as part of
6937: --FP M Changes for delete_draft_budget
6938: --If the budget version being deleted is a generation source
6939: --then we null out the GEN_SRC_XXX_PLAN_VERSION_ID column in
6940: --pa_proj_fp_options table and increase the record_version_no
6941: IF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_COST
6942: THEN
6943: UPDATE pa_proj_fp_options
6944: SET gen_src_cost_plan_version_id = NULL,

Line 6943: UPDATE pa_proj_fp_options

6939: --then we null out the GEN_SRC_XXX_PLAN_VERSION_ID column in
6940: --pa_proj_fp_options table and increase the record_version_no
6941: IF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_COST
6942: THEN
6943: UPDATE pa_proj_fp_options
6944: SET gen_src_cost_plan_version_id = NULL,
6945: record_version_number = record_version_number + 1,
6946: last_update_date = SYSDATE,
6947: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

Line 6953: UPDATE pa_proj_fp_options

6949: WHERE project_id = l_project_id
6950: AND gen_src_cost_plan_version_id = l_budget_version_id;
6951: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_REVENUE
6952: THEN
6953: UPDATE pa_proj_fp_options
6954: SET gen_src_rev_plan_version_id = NULL,
6955: record_version_number = record_version_number + 1,
6956: last_update_date = SYSDATE,
6957: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

Line 6963: UPDATE pa_proj_fp_options

6959: WHERE project_id = l_project_id
6960: AND gen_src_rev_plan_version_id = l_budget_version_id;
6961: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL
6962: THEN
6963: UPDATE pa_proj_fp_options
6964: SET gen_src_all_plan_version_id = NULL,
6965: record_version_number = record_version_number + 1,
6966: last_update_date = SYSDATE,
6967: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

Line 6973: --if any record had been updated in pa_proj_fp_options then

6969: WHERE project_id = l_project_id
6970: AND gen_src_all_plan_version_id = l_budget_version_id;
6971: END IF;
6972:
6973: --if any record had been updated in pa_proj_fp_options then
6974: --we do a dummy update in pa_budget_versions also for the
6975: --budget version that is being updated to increase the record version number
6976: IF SQL%ROWCOUNT > 0 THEN
6977: UPDATE pa_budget_versions

Line 7853: --pa_proj_fp_options table and increase the record_version_no

7849: END IF;
7850:
7851: --If the budget version being deleted is a generation source
7852: --then we null out the GEN_SRC_XXX_PLAN_VERSION_ID column in
7853: --pa_proj_fp_options table and increase the record_version_no
7854: IF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_COST
7855: THEN
7856: UPDATE pa_proj_fp_options
7857: SET gen_src_cost_plan_version_id = NULL,

Line 7856: UPDATE pa_proj_fp_options

7852: --then we null out the GEN_SRC_XXX_PLAN_VERSION_ID column in
7853: --pa_proj_fp_options table and increase the record_version_no
7854: IF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_COST
7855: THEN
7856: UPDATE pa_proj_fp_options
7857: SET gen_src_cost_plan_version_id = NULL,
7858: record_version_number = record_version_number + 1,
7859: last_update_date = SYSDATE,
7860: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

Line 7866: UPDATE pa_proj_fp_options

7862: WHERE project_id = l_project_id
7863: AND gen_src_cost_plan_version_id = l_budget_version_id;
7864: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_REVENUE
7865: THEN
7866: UPDATE pa_proj_fp_options
7867: SET gen_src_rev_plan_version_id = NULL,
7868: record_version_number = record_version_number + 1,
7869: last_update_date = SYSDATE,
7870: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

Line 7876: UPDATE pa_proj_fp_options

7872: WHERE project_id = l_project_id
7873: AND gen_src_rev_plan_version_id = l_budget_version_id;
7874: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL
7875: THEN
7876: UPDATE pa_proj_fp_options
7877: SET gen_src_all_plan_version_id = NULL,
7878: record_version_number = record_version_number + 1,
7879: last_update_date = SYSDATE,
7880: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

Line 7886: --if any record had been updated in pa_proj_fp_options then

7882: WHERE project_id = l_project_id
7883: AND gen_src_all_plan_version_id = l_budget_version_id;
7884: END IF;
7885:
7886: --if any record had been updated in pa_proj_fp_options then
7887: --we do a dummy update in pa_budget_versions also for the
7888: --budget version that is being updated to increase the record version number
7889: IF SQL%ROWCOUNT > 0 THEN
7890: UPDATE pa_budget_versions

Line 8150: FROM pa_proj_fp_options

8146: ( c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE
8147: ,c_project_id pa_projects_all.project_id%TYPE)
8148: IS
8149: SELECT approved_rev_plan_type_flag
8150: FROM pa_proj_fp_options
8151: WHERE project_id=c_project_id
8152: AND fin_plan_type_id=c_fin_plan_type_id
8153: AND fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
8154:

Line 8212: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

8208: l_budget_version_id NUMBER;
8209: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
8210: l_resource_list_id NUMBER;
8211: l_budget_amount_code pa_budget_types.budget_amount_code%type;
8212: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
8213: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
8214: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8215: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
8216: l_record_version_number NUMBER;

Line 8213: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

8209: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
8210: l_resource_list_id NUMBER;
8211: l_budget_amount_code pa_budget_types.budget_amount_code%type;
8212: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
8213: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
8214: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8215: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
8216: l_record_version_number NUMBER;
8217: l_task_id NUMBER;

Line 8214: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

8210: l_resource_list_id NUMBER;
8211: l_budget_amount_code pa_budget_types.budget_amount_code%type;
8212: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
8213: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
8214: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8215: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
8216: l_record_version_number NUMBER;
8217: l_task_id NUMBER;
8218: l_resource_list_member_id NUMBER;

Line 9181: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

9177: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9178: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9179: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9180: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9181: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9182: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9183: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9184: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9185: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 9182: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

9178: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9179: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9180: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9181: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9182: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9183: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9184: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9185: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9186: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 9183: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

9179: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9180: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9181: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9182: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9183: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9184: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9185: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9186: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9187: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9184: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

9180: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9181: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9182: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9183: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9184: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9185: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9186: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9187: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9188: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9185: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

9181: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9182: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9183: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9184: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9185: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9186: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9187: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9188: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9189: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 9187: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

9183: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9184: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9185: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9186: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9187: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9188: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9189: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9190: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9191: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9188: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

9184: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9185: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9186: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9187: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9188: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9189: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9190: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9191: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9192: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9189: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

9185: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9186: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9187: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9188: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9189: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9190: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9191: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9192: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9193: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 9191: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

9187: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9188: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9189: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9190: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9191: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9192: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9193: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9194: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9195: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9192: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

9188: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9189: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9190: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9191: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9192: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9193: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9194: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9195: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9196: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9193: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

9189: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9190: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9191: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9192: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9193: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9194: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9195: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9196: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9197: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 9195: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

9191: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9192: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9193: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9194: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9195: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9196: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9197: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9198: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9199: /* Plan Amount Entry flags introduced by bug 6408139 */

Line 9196: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

9192: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9193: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9194: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9195: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9196: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9197: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9198: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9199: /* Plan Amount Entry flags introduced by bug 6408139 */
9200: ,p_raw_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9197: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

9193: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9194: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9195: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9196: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9197: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9198: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9199: /* Plan Amount Entry flags introduced by bug 6408139 */
9200: ,p_raw_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9201: ,p_burdened_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9496: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;

9492: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;
9493: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9494: l_record_version_number pa_budget_versions.record_version_number%TYPE;
9495:
9496: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
9497: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE :=null;
9498: l_person_id per_all_people_f.person_id%TYPE;
9499: l_resource_id per_all_people_f.person_id%TYPE;
9500: l_baselined_version_id NUMBER;

Line 9497: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE :=null;

9493: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9494: l_record_version_number pa_budget_versions.record_version_number%TYPE;
9495:
9496: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
9497: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE :=null;
9498: l_person_id per_all_people_f.person_id%TYPE;
9499: l_resource_id per_all_people_f.person_id%TYPE;
9500: l_baselined_version_id NUMBER;
9501: l_debug_mode VARCHAR2(1);

Line 9527: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

9523: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9524: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9525: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9526: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;
9527: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
9528: lx_time_phased_type_code pa_proj_fp_options.cost_time_phased_code%TYPE;
9529: lx_resource_list_name pa_resource_lists_all_bg.Name%TYPE := null;
9530: lx_raw_cost_flag VARCHAR2(1) ;
9531: lx_burdened_cost_flag VARCHAR2(1);

Line 9528: lx_time_phased_type_code pa_proj_fp_options.cost_time_phased_code%TYPE;

9524: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9525: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9526: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;
9527: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
9528: lx_time_phased_type_code pa_proj_fp_options.cost_time_phased_code%TYPE;
9529: lx_resource_list_name pa_resource_lists_all_bg.Name%TYPE := null;
9530: lx_raw_cost_flag VARCHAR2(1) ;
9531: lx_burdened_cost_flag VARCHAR2(1);
9532: lx_revenue_flag VARCHAR2(1);

Line 9537: lx_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;

9533: lx_cost_qty_flag VARCHAR2(1);
9534: lx_revenue_qty_flag VARCHAR2(1);
9535: lx_all_qty_flag VARCHAR2(1);
9536: x_return_status VARCHAR2(1);
9537: lx_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9538: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
9539: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9540: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9541: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;

Line 9538: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;

9534: lx_revenue_qty_flag VARCHAR2(1);
9535: lx_all_qty_flag VARCHAR2(1);
9536: x_return_status VARCHAR2(1);
9537: lx_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9538: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
9539: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9540: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9541: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9542: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

Line 9539: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;

9535: lx_all_qty_flag VARCHAR2(1);
9536: x_return_status VARCHAR2(1);
9537: lx_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9538: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
9539: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9540: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9541: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9542: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9543: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

Line 9540: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

9536: x_return_status VARCHAR2(1);
9537: lx_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9538: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
9539: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9540: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9541: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9542: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9543: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9544: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

Line 9541: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;

9537: lx_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9538: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
9539: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9540: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9541: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9542: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9543: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9544: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9545: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

Line 9542: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

9538: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
9539: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9540: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9541: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9542: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9543: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9544: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9545: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9546: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

Line 9543: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

9539: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9540: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9541: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9542: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9543: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9544: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9545: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9546: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9547: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

Line 9544: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

9540: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9541: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9542: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9543: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9544: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9545: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9546: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9547: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9548: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

Line 9545: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

9541: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9542: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9543: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9544: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9545: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9546: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9547: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9548: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
9549:

Line 9546: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

9542: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9543: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9544: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9545: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9546: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9547: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9548: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
9549:
9550: l_project_currency_code pa_projects_all.project_currency_code%TYPE; -- 3453650

Line 9547: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

9543: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9544: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9545: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9546: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9547: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9548: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
9549:
9550: l_project_currency_code pa_projects_all.project_currency_code%TYPE; -- 3453650
9551: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE; -- 3453650

Line 9548: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

9544: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9545: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9546: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9547: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9548: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
9549:
9550: l_project_currency_code pa_projects_all.project_currency_code%TYPE; -- 3453650
9551: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE; -- 3453650
9552:

Line 9574: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

9570: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
9571: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9572: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
9573: l_amg_project_number pa_projects_all.segment1%TYPE;
9574: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
9575: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
9576: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;
9577: l_allow_qty_flag VARCHAR2(1);
9578: l_conv_attrs_to_be_validated VARCHAR2(30);

Line 9581: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;

9577: l_allow_qty_flag VARCHAR2(1);
9578: l_conv_attrs_to_be_validated VARCHAR2(30);
9579: l_is_rate_type_valid BOOLEAN;
9580: l_call_validate_curr_api_flg VARCHAR2(1);
9581: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9582: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9583: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9584: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9585: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;

Line 9582: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

9578: l_conv_attrs_to_be_validated VARCHAR2(30);
9579: l_is_rate_type_valid BOOLEAN;
9580: l_call_validate_curr_api_flg VARCHAR2(1);
9581: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9582: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9583: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9584: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9585: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9586: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;

Line 9583: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

9579: l_is_rate_type_valid BOOLEAN;
9580: l_call_validate_curr_api_flg VARCHAR2(1);
9581: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9582: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9583: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9584: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9585: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9586: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
9587: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;

Line 9584: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

9580: l_call_validate_curr_api_flg VARCHAR2(1);
9581: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9582: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9583: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9584: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9585: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9586: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
9587: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
9588: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

Line 9592: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

9588: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
9589:
9590: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
9591: /*Added local variables for bug 6408139*/
9592: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9593: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9594: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9595: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9596: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 9596: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;

9592: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9593: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9594: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9595: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9596: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;
9597:
9598:
9599: /*Added local variables for Bug 6417360*/
9600: l_attribute_category pa_budget_versions.attribute_category%type;

Line 10627: l_proj_fp_options_id_new := PA_PROJ_FP_OPTIONS_PUB.Get_FP_Option_ID

10623: pa_debug.g_err_stage:= 'Amount set id is -> ' || l_amount_set_id;
10624: pa_debug.write('UPDATE_BUDGET: ' || g_module_name,pa_debug.g_err_stage,3);
10625: END IF;
10626:
10627: l_proj_fp_options_id_new := PA_PROJ_FP_OPTIONS_PUB.Get_FP_Option_ID
10628: (p_project_id => l_project_id
10629: ,p_plan_type_id => l_fin_plan_type_id
10630: ,p_plan_version_id => l_budget_version_id
10631: );

Line 10635: UPDATE pa_proj_fp_options

10631: );
10632:
10633:
10634: IF lx_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST THEN
10635: UPDATE pa_proj_fp_options
10636: SET cost_amount_set_id = l_amount_set_id
10637: WHERE proj_fp_options_id = l_proj_fp_options_id_new;
10638: ELSIF lx_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE THEN
10639: UPDATE pa_proj_fp_options

Line 10639: UPDATE pa_proj_fp_options

10635: UPDATE pa_proj_fp_options
10636: SET cost_amount_set_id = l_amount_set_id
10637: WHERE proj_fp_options_id = l_proj_fp_options_id_new;
10638: ELSIF lx_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE THEN
10639: UPDATE pa_proj_fp_options
10640: SET revenue_amount_set_id = l_amount_set_id
10641: WHERE proj_fp_options_id = l_proj_fp_options_id_new;
10642: ELSIF lx_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL THEN
10643: UPDATE pa_proj_fp_options

Line 10643: UPDATE pa_proj_fp_options

10639: UPDATE pa_proj_fp_options
10640: SET revenue_amount_set_id = l_amount_set_id
10641: WHERE proj_fp_options_id = l_proj_fp_options_id_new;
10642: ELSIF lx_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL THEN
10643: UPDATE pa_proj_fp_options
10644: SET all_amount_set_id = l_amount_set_id
10645: WHERE proj_fp_options_id = l_proj_fp_options_id_new;
10646: END IF;
10647:

Line 11082: FROM pa_proj_fp_options

11078: INTO l_projfunc_cost_rate_type
11079: ,l_projfunc_rev_rate_type
11080: ,l_project_cost_rate_type
11081: ,l_project_rev_rate_type
11082: FROM pa_proj_fp_options
11083: WHERE project_id = l_project_id
11084: AND fin_plan_type_id=l_fin_plan_type_id
11085: AND fin_plan_version_id IS NULL
11086: AND fin_plan_option_level_code= PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

Line 11145: pa_debug.g_err_stage := 'Updating pa_proj_fp_options with multi currency conversion attributes';

11141: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11142: END IF;
11143:
11144: IF l_debug_mode = 'Y' THEN
11145: pa_debug.g_err_stage := 'Updating pa_proj_fp_options with multi currency conversion attributes';
11146: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
11147: END IF;
11148:
11149: update pa_proj_fp_options

Line 11149: update pa_proj_fp_options

11145: pa_debug.g_err_stage := 'Updating pa_proj_fp_options with multi currency conversion attributes';
11146: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
11147: END IF;
11148:
11149: update pa_proj_fp_options
11150: set
11151: projfunc_cost_rate_type = decode(p_projfunc_cost_rate_type, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, projfunc_cost_rate_type , p_projfunc_cost_rate_type)
11152: ,projfunc_cost_rate_date_type = decode(p_projfunc_cost_rate_date_typ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, projfunc_cost_rate_date_type, p_projfunc_cost_rate_date_typ)
11153: ,projfunc_cost_rate_date = decode(p_projfunc_cost_rate_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE, projfunc_cost_rate_date , p_projfunc_cost_rate_date)

Line 12898: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12894: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12895: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12896: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12897: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12898: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12899: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12900: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12901: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12902: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 12899: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12895: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12896: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12897: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12898: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12899: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12900: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12901: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12902: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12903: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 12900: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12896: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12897: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12898: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12899: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12900: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12901: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12902: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12903: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12904: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 12901: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12897: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12898: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12899: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12900: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12901: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12902: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12903: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12904: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12905: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 12902: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

12898: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12899: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12900: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12901: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12902: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12903: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12904: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12905: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12906: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 12904: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12900: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12901: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12902: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12903: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12904: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12905: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12906: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12907: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12908: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 12905: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12901: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12902: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12903: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12904: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12905: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12906: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12907: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12908: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12909: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 12906: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

12902: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12903: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12904: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12905: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12906: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12907: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12908: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12909: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12910: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 12908: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12904: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12905: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12906: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12907: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12908: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12909: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12910: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12911: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12912: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 12909: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12905: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12906: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12907: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12908: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12909: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12910: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12911: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12912: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12913: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 12910: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

12906: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12907: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12908: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12909: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12910: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12911: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12912: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12913: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12914: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 12912: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12908: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12909: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12910: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12911: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12912: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12913: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12914: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12915: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12916: )

Line 12913: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12909: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12910: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12911: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12912: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12913: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12914: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12915: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12916: )
12917:

Line 12914: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

12910: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12911: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12912: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12913: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12914: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12915: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12916: )
12917:
12918: IS

Line 13265: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

13261: l_budget_version_id NUMBER;
13262: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
13263: l_resource_list_id NUMBER;
13264: l_budget_amount_code pa_budget_types.budget_amount_code%type;
13265: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
13266: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
13267: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
13268: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
13269: l_record_version_number pa_budget_versions.record_version_number%TYPE;

Line 13266: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

13262: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
13263: l_resource_list_id NUMBER;
13264: l_budget_amount_code pa_budget_types.budget_amount_code%type;
13265: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
13266: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
13267: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
13268: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
13269: l_record_version_number pa_budget_versions.record_version_number%TYPE;
13270:

Line 13267: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

13263: l_resource_list_id NUMBER;
13264: l_budget_amount_code pa_budget_types.budget_amount_code%type;
13265: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
13266: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
13267: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
13268: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
13269: l_record_version_number pa_budget_versions.record_version_number%TYPE;
13270:
13271: l_budget_lines_in budget_line_in_tbl_type;

Line 14519: FROM pa_proj_fp_options pfo

14515:
14516: CURSOR proj_fp_options_cur
14517: (c_project_id IN NUMBER, c_fin_plan_type_id IN NUMBER) IS
14518: SELECT 'x'
14519: FROM pa_proj_fp_options pfo
14520: WHERE pfo.project_id = c_project_id
14521: AND pfo.fin_plan_type_id = c_fin_plan_type_id
14522: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
14523:

Line 14592: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

14588: l_bill_rate_override_tbl l_bill_rate_override_tbl_t;
14589:
14590:
14591: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
14592: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
14593: l_bdgt_lines_skip_flag varchar2(1);
14594: l_targ_request_id pa_budget_versions.request_id%TYPE;
14595:
14596: --This variable will be used to call pa_resource_asgn_curr maintenance api - IPM Arch Enhancement

Line 17373: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17369: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17370: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17371: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17372: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17373: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17374: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17375: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17376: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17377: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17376: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17372: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17373: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17374: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17375: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17376: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17377: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17378: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17379: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17380: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17377: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17373: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17374: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17375: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17376: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17377: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17378: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17379: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17380: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17381: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17417: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

17413:
17414:
17415: /* SCALAR VARIABLES */
17416: l_task_number pa_tasks.task_number%TYPE;
17417: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17418: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
17419: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17420: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17421: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;

Line 17426: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

17422: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17423: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17424: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17425: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
17426: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
17427: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
17428: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
17429: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
17430: -- Bug Fix: 4569365. Removed MRC code.

Line 17437: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

17433:
17434: l_plan_tran_context VARCHAR2(30);
17435: l_record_version_number pa_budget_versions.record_version_number%TYPE;
17436: l_mixed_resource_planned_flag VARCHAR2(1);
17437: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17438: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
17439: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
17440: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
17441:

Line 17469: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;

17465: l_budget_version_name pa_budget_versions.version_name%type;
17466: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17467: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
17468: l_version_type pa_budget_versions.version_type%TYPE ;
17469: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
17470: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
17471:
17472: L_RAW_COST_FLAG VARCHAR2(1);
17473: L_BURDENED_COST_FLAG VARCHAR2(1);

Line 17470: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;

17466: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17467: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
17468: l_version_type pa_budget_versions.version_type%TYPE ;
17469: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
17470: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
17471:
17472: L_RAW_COST_FLAG VARCHAR2(1);
17473: L_BURDENED_COST_FLAG VARCHAR2(1);
17474: L_REVENUE_FLAG VARCHAR2(1);

Line 17483: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

17479: L_CREATE_NEW_WORKING_FLAG VARCHAR2(1);
17480: L_REPLACE_CURRENT_WORKING_FLAG VARCHAR2(1);
17481: L_USING_RESOURCE_LISTS_FLAG VARCHAR2(1);
17482:
17483: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
17484: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
17485: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17486: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17487: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

Line 17484: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;

17480: L_REPLACE_CURRENT_WORKING_FLAG VARCHAR2(1);
17481: L_USING_RESOURCE_LISTS_FLAG VARCHAR2(1);
17482:
17483: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
17484: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
17485: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17486: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17487: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17488: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;

Line 17485: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;

17481: L_USING_RESOURCE_LISTS_FLAG VARCHAR2(1);
17482:
17483: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
17484: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
17485: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17486: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17487: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17488: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17489: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

Line 17486: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;

17482:
17483: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
17484: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
17485: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17486: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17487: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17488: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17489: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17490: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

Line 17487: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

17483: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
17484: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
17485: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17486: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17487: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17488: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17489: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17490: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17491: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

Line 17488: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;

17484: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
17485: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17486: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17487: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17488: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17489: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17490: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17491: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17492: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

Line 17489: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

17485: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17486: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17487: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17488: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17489: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17490: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17491: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17492: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17493: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

Line 17490: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

17486: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17487: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17488: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17489: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17490: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17491: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17492: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17493: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
17494: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

Line 17491: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

17487: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17488: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17489: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17490: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17491: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17492: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17493: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
17494: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
17495: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

Line 17492: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

17488: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17489: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17490: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17491: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17492: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17493: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
17494: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
17495: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
17496:

Line 17493: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

17489: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17490: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17491: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17492: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17493: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
17494: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
17495: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
17496:
17497: /**PLSQL TABLES**/

Line 17494: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

17490: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17491: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17492: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17493: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
17494: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
17495: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
17496:
17497: /**PLSQL TABLES**/
17498: l_pm_task_reference_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 17495: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

17491: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17492: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17493: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
17494: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
17495: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
17496:
17497: /**PLSQL TABLES**/
17498: l_pm_task_reference_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
17499: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 17594: l_pt_amount_set_id pa_proj_fp_options.cost_amount_set_id%TYPE;

17590:
17591: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
17592:
17593: --Bug 5475184. In the below set, pt stands for "plan type".
17594: l_pt_amount_set_id pa_proj_fp_options.cost_amount_set_id%TYPE;
17595: l_pt_raw_cost_flag VARCHAR2(1);
17596: l_pt_burdened_flag VARCHAR2(1);
17597: l_pt_revenue_flag VARCHAR2(1);
17598: l_pt_cost_quantity_flag VARCHAR2(1);

Line 18020: FROM pa_proj_fp_options

18016: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_amount_set_id,
18017: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_amount_set_id,
18018: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_amount_set_id)
18019: INTO l_pt_amount_set_id
18020: FROM pa_proj_fp_options
18021: WHERE project_id=l_project_id
18022: AND fin_plan_type_id=l_fin_plan_type_id
18023: AND fin_plan_version_id IS NULL;
18024:

Line 19148: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19144: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19145: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19146: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19147: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19148: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19149: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19150: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19151: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19152: ,P_PLAN_IN_MULTI_CURR_FLAG IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19151: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19147: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19148: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19149: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19150: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19151: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19152: ,P_PLAN_IN_MULTI_CURR_FLAG IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19153: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19154: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19155: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19152: ,P_PLAN_IN_MULTI_CURR_FLAG IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19148: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19149: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19150: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19151: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19152: ,P_PLAN_IN_MULTI_CURR_FLAG IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19153: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19154: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19155: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19156: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19410: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

19406: l_budget_version_id NUMBER;
19407: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
19408: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
19409: l_budget_amount_code pa_budget_types.budget_amount_code%type;
19410: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
19411: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
19412: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
19413: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
19414: l_project_number pa_projects_all.segment1%type;

Line 19411: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

19407: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
19408: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
19409: l_budget_amount_code pa_budget_types.budget_amount_code%type;
19410: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
19411: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
19412: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
19413: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
19414: l_project_number pa_projects_all.segment1%type;
19415:

Line 19412: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

19408: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
19409: l_budget_amount_code pa_budget_types.budget_amount_code%type;
19410: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
19411: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
19412: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
19413: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
19414: l_project_number pa_projects_all.segment1%type;
19415:
19416: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type;

Line 19850: pa_proj_fp_options pf

19846: ,pa.PROJFUNC_CURRENCY_CODE
19847: ,pa.PROJECT_CURRENCY_CODE)
19848: INTO l_currency_code
19849: FROM pa_projects_all pa,
19850: pa_proj_fp_options pf
19851: WHERE pa.project_id=l_project_id
19852: AND pa.project_id=pf.project_id
19853: AND pf.fin_plan_version_id=l_budget_version_id;
19854: