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.

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 2588: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

2584:
2585: --Changes the default of the following parameters from NULL to G_PA_MISS_XXX 24-APR-03 by Xin Liu
2586: ,p_txn_currency_code IN pa_fp_txn_currencies.txn_currency_code%TYPE
2587: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2588: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2589: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2590: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2591: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2592: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

Line 2590: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

2586: ,p_txn_currency_code IN pa_fp_txn_currencies.txn_currency_code%TYPE
2587: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2588: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2589: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2590: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2591: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2592: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2593: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2594: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE

Line 2592: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

2588: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2589: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2590: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2591: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2592: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2593: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2594: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2595: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2596: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

Line 2596: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

2592: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2593: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2594: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2595: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2596: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2597: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2598: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2599: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2600: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

Line 2598: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

2594: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2595: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2596: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2597: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2598: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2599: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2600: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2601: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2602: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE

Line 2600: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

2596: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2597: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2598: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2599: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2600: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2601: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2602: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2603: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2604: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

Line 2604: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

2600: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2601: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2602: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2603: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2604: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2605: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2606: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2607: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2608: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

Line 2606: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

2602: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2603: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2604: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2605: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2606: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2607: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2608: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2609: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2610: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE

Line 2608: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

2604: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2605: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2606: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2607: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2608: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2609: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2610: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
2611: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2612: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

Line 2612: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

2608: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2609: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2610: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
2611: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2612: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2613: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2614: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2615: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2616: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

Line 2614: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

2610: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
2611: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2612: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2613: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2614: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2615: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2616: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2617: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2618: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE

Line 2616: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

2612: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2613: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2614: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2615: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2616: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2617: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2618: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
2619: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2620: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE

Line 2822: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

2818: --Added the following parameters for changes in AMG due to finplan model
2819: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
2820: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
2821: ,p_version_type IN pa_budget_versions.version_type%TYPE
2822: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2823: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2824: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2825: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2826: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

Line 2823: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE

2819: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
2820: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
2821: ,p_version_type IN pa_budget_versions.version_type%TYPE
2822: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2823: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2824: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2825: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2826: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2827: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

Line 2824: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE

2820: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
2821: ,p_version_type IN pa_budget_versions.version_type%TYPE
2822: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2823: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2824: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2825: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2826: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2827: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2828: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

Line 2825: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

2821: ,p_version_type IN pa_budget_versions.version_type%TYPE
2822: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2823: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2824: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2825: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2826: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2827: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2828: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2829: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

Line 2826: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

2822: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2823: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2824: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2825: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2826: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2827: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2828: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2829: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2830: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

Line 2827: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

2823: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2824: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2825: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2826: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2827: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2828: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2829: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2830: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2831: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

Line 2828: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

2824: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2825: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2826: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2827: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2828: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2829: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2830: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2831: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2832: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

Line 2829: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

2825: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2826: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2827: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2828: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2829: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2830: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2831: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2832: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2833: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

Line 2830: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

2826: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2827: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2828: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2829: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2830: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2831: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2832: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2833: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2834: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

Line 2831: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

2827: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2828: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2829: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2830: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2831: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2832: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2833: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2834: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2835: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

Line 2832: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

2828: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2829: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2830: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2831: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2832: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2833: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2834: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2835: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2836: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

Line 2833: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

2829: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2830: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2831: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2832: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2833: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2834: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2835: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2836: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2837: ,p_raw_cost_flag IN VARCHAR2

Line 2834: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

2830: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2831: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2832: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2833: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2834: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2835: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2836: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2837: ,p_raw_cost_flag IN VARCHAR2
2838: ,p_burdened_cost_flag IN VARCHAR2

Line 2835: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

2831: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2832: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2833: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2834: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2835: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2836: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2837: ,p_raw_cost_flag IN VARCHAR2
2838: ,p_burdened_cost_flag IN VARCHAR2
2839: ,p_revenue_flag IN VARCHAR2

Line 2836: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

2832: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2833: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2834: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2835: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2836: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2837: ,p_raw_cost_flag IN VARCHAR2
2838: ,p_burdened_cost_flag IN VARCHAR2
2839: ,p_revenue_flag IN VARCHAR2
2840: ,p_cost_qty_flag IN VARCHAR2

Line 3359: c_fin_plan_type_id pa_proj_fp_options.proj_fp_options_id%TYPE)

3355:
3356: -- Needed to check whether the plan type id passed is attached to the project or Not
3357: CURSOR l_plan_type_option_csr
3358: (c_project_id pa_projects_all.project_id%TYPE,
3359: c_fin_plan_type_id pa_proj_fp_options.proj_fp_options_id%TYPE)
3360: IS
3361: SELECT 'X'
3362: FROM pa_proj_fp_options pfo
3363: WHERE pfo.project_id=c_project_id

Line 3362: FROM pa_proj_fp_options pfo

3358: (c_project_id pa_projects_all.project_id%TYPE,
3359: c_fin_plan_type_id pa_proj_fp_options.proj_fp_options_id%TYPE)
3360: IS
3361: SELECT 'X'
3362: FROM pa_proj_fp_options pfo
3363: WHERE pfo.project_id=c_project_id
3364: AND pfo.fin_plan_type_id=c_fin_plan_type_id
3365: AND pfo.fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
3366:

Line 3403: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

3399: l_debug_level4 CONSTANT NUMBER := 4;
3400: l_debug_level5 CONSTANT NUMBER := 5;
3401: l_version_type pa_budget_Versions.version_type%TYPE;
3402: l_security_ret_code VARCHAR2(1);
3403: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3404: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3405: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3406: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;
3407: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;

Line 3405: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

3401: l_version_type pa_budget_Versions.version_type%TYPE;
3402: l_security_ret_code VARCHAR2(1);
3403: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3404: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3405: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3406: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;
3407: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;
3408: l_CW_record_version_number pa_budget_Versions.record_version_number%TYPE;
3409: l_any_error_occurred_flag VARCHAR2(1);

Line 5076: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

5072: l_budget_version_id NUMBER;
5073: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
5074: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5075: l_budget_amount_code pa_budget_types.budget_amount_code%type;
5076: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
5077: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
5078: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
5079: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
5080: l_record_version_number pa_budget_versions.record_version_number%TYPE;

Line 5077: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

5073: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
5074: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5075: l_budget_amount_code pa_budget_types.budget_amount_code%type;
5076: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
5077: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
5078: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
5079: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
5080: l_record_version_number pa_budget_versions.record_version_number%TYPE;
5081:

Line 5078: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

5074: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5075: l_budget_amount_code pa_budget_types.budget_amount_code%type;
5076: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
5077: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
5078: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
5079: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
5080: l_record_version_number pa_budget_versions.record_version_number%TYPE;
5081:
5082: l_resource_name VARCHAR2(80); --bug 3711693

Line 5094: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;

5090: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
5091: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
5092:
5093: --Following parameters are needed for amounts check
5094: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
5095: lx_raw_cost_flag VARCHAR2(1) := NULL;
5096: lx_burdened_cost_flag VARCHAR2(1) := NULL;
5097: lx_revenue_flag VARCHAR2(1) := NULL;
5098: lx_cost_qty_flag VARCHAR2(1) := NULL;

Line 6089: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

6085: l_result VARCHAR2(1);
6086: l_record_version_number pa_budget_versions.record_version_number%TYPE;
6087: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6088: --Added by Xin Liu. 28-APR-03
6089: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6090: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6091: ll_version_type pa_budget_versions.version_type%TYPE;
6092: ll_version_number pa_budget_versions.version_number%TYPE;
6093:

Line 6788: --pa_proj_fp_options table and increase the record_version_no

6784: --Bug 4224464: Following DMLs have been added as part of
6785: --FP M Changes for delete_draft_budget
6786: --If the budget version being deleted is a generation source
6787: --then we null out the GEN_SRC_XXX_PLAN_VERSION_ID column in
6788: --pa_proj_fp_options table and increase the record_version_no
6789: IF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_COST
6790: THEN
6791: UPDATE pa_proj_fp_options
6792: SET gen_src_cost_plan_version_id = NULL,

Line 6791: UPDATE pa_proj_fp_options

6787: --then we null out the GEN_SRC_XXX_PLAN_VERSION_ID column in
6788: --pa_proj_fp_options table and increase the record_version_no
6789: IF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_COST
6790: THEN
6791: UPDATE pa_proj_fp_options
6792: SET gen_src_cost_plan_version_id = NULL,
6793: record_version_number = record_version_number + 1,
6794: last_update_date = SYSDATE,
6795: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

Line 6801: UPDATE pa_proj_fp_options

6797: WHERE project_id = l_project_id
6798: AND gen_src_cost_plan_version_id = l_budget_version_id;
6799: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_REVENUE
6800: THEN
6801: UPDATE pa_proj_fp_options
6802: SET gen_src_rev_plan_version_id = NULL,
6803: record_version_number = record_version_number + 1,
6804: last_update_date = SYSDATE,
6805: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

Line 6811: UPDATE pa_proj_fp_options

6807: WHERE project_id = l_project_id
6808: AND gen_src_rev_plan_version_id = l_budget_version_id;
6809: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL
6810: THEN
6811: UPDATE pa_proj_fp_options
6812: SET gen_src_all_plan_version_id = NULL,
6813: record_version_number = record_version_number + 1,
6814: last_update_date = SYSDATE,
6815: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

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

6817: WHERE project_id = l_project_id
6818: AND gen_src_all_plan_version_id = l_budget_version_id;
6819: END IF;
6820:
6821: --if any record had been updated in pa_proj_fp_options then
6822: --we do a dummy update in pa_budget_versions also for the
6823: --budget version that is being updated to increase the record version number
6824: IF SQL%ROWCOUNT > 0 THEN
6825: UPDATE pa_budget_versions

Line 7699: --pa_proj_fp_options table and increase the record_version_no

7695: END IF;
7696:
7697: --If the budget version being deleted is a generation source
7698: --then we null out the GEN_SRC_XXX_PLAN_VERSION_ID column in
7699: --pa_proj_fp_options table and increase the record_version_no
7700: IF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_COST
7701: THEN
7702: UPDATE pa_proj_fp_options
7703: SET gen_src_cost_plan_version_id = NULL,

Line 7702: UPDATE pa_proj_fp_options

7698: --then we null out the GEN_SRC_XXX_PLAN_VERSION_ID column in
7699: --pa_proj_fp_options table and increase the record_version_no
7700: IF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_COST
7701: THEN
7702: UPDATE pa_proj_fp_options
7703: SET gen_src_cost_plan_version_id = NULL,
7704: record_version_number = record_version_number + 1,
7705: last_update_date = SYSDATE,
7706: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

Line 7712: UPDATE pa_proj_fp_options

7708: WHERE project_id = l_project_id
7709: AND gen_src_cost_plan_version_id = l_budget_version_id;
7710: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_REVENUE
7711: THEN
7712: UPDATE pa_proj_fp_options
7713: SET gen_src_rev_plan_version_id = NULL,
7714: record_version_number = record_version_number + 1,
7715: last_update_date = SYSDATE,
7716: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

Line 7722: UPDATE pa_proj_fp_options

7718: WHERE project_id = l_project_id
7719: AND gen_src_rev_plan_version_id = l_budget_version_id;
7720: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL
7721: THEN
7722: UPDATE pa_proj_fp_options
7723: SET gen_src_all_plan_version_id = NULL,
7724: record_version_number = record_version_number + 1,
7725: last_update_date = SYSDATE,
7726: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

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

7728: WHERE project_id = l_project_id
7729: AND gen_src_all_plan_version_id = l_budget_version_id;
7730: END IF;
7731:
7732: --if any record had been updated in pa_proj_fp_options then
7733: --we do a dummy update in pa_budget_versions also for the
7734: --budget version that is being updated to increase the record version number
7735: IF SQL%ROWCOUNT > 0 THEN
7736: UPDATE pa_budget_versions

Line 7990: FROM pa_proj_fp_options

7986: ( c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE
7987: ,c_project_id pa_projects_all.project_id%TYPE)
7988: IS
7989: SELECT approved_rev_plan_type_flag
7990: FROM pa_proj_fp_options
7991: WHERE project_id=c_project_id
7992: AND fin_plan_type_id=c_fin_plan_type_id
7993: AND fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
7994:

Line 8052: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

8048: l_budget_version_id NUMBER;
8049: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
8050: l_resource_list_id NUMBER;
8051: l_budget_amount_code pa_budget_types.budget_amount_code%type;
8052: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
8053: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
8054: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8055: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
8056: l_record_version_number NUMBER;

Line 8053: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

8049: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
8050: l_resource_list_id NUMBER;
8051: l_budget_amount_code pa_budget_types.budget_amount_code%type;
8052: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
8053: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
8054: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8055: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
8056: l_record_version_number NUMBER;
8057: l_task_id NUMBER;

Line 8054: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

8050: l_resource_list_id NUMBER;
8051: l_budget_amount_code pa_budget_types.budget_amount_code%type;
8052: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
8053: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
8054: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8055: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
8056: l_record_version_number NUMBER;
8057: l_task_id NUMBER;
8058: l_resource_list_member_id NUMBER;

Line 9002: ,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

8998: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8999: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9000: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9001: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9002: ,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
9003: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9004: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9005: ,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
9006: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

8999: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9000: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9001: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9002: ,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
9003: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9004: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9005: ,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
9006: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9007: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

9000: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9001: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9002: ,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
9003: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9004: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9005: ,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
9006: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9007: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9008: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9005: ,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

9001: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9002: ,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
9003: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9004: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9005: ,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
9006: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9007: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9008: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9009: ,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 9006: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

9002: ,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
9003: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9004: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9005: ,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
9006: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9007: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9008: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9009: ,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
9010: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

9004: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9005: ,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
9006: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9007: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9008: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9009: ,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
9010: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9011: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9012: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9009: ,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

9005: ,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
9006: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9007: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9008: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9009: ,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
9010: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9011: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9012: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9013: ,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 9010: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

9006: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9007: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9008: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9009: ,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
9010: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9011: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9012: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9013: ,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
9014: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

9008: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9009: ,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
9010: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9011: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9012: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9013: ,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
9014: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9015: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9016: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9013: ,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

9009: ,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
9010: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9011: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9012: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9013: ,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
9014: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9015: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9016: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9017: ,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 9014: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

9010: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9011: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9012: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9013: ,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
9014: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9015: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9016: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9017: ,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
9018: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

9012: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9013: ,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
9014: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9015: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9016: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9017: ,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
9018: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9019: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9020: /* Plan Amount Entry flags introduced by bug 6408139 */

Line 9017: ,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

9013: ,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
9014: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9015: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9016: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9017: ,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
9018: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9019: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9020: /* Plan Amount Entry flags introduced by bug 6408139 */
9021: ,p_raw_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

9014: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9015: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9016: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9017: ,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
9018: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9019: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9020: /* Plan Amount Entry flags introduced by bug 6408139 */
9021: ,p_raw_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9022: ,p_burdened_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9313: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;

9309: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;
9310: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9311: l_record_version_number pa_budget_versions.record_version_number%TYPE;
9312:
9313: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
9314: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE :=null;
9315: l_person_id per_all_people_f.person_id%TYPE;
9316: l_resource_id per_all_people_f.person_id%TYPE;
9317: l_baselined_version_id NUMBER;

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

9310: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9311: l_record_version_number pa_budget_versions.record_version_number%TYPE;
9312:
9313: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
9314: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE :=null;
9315: l_person_id per_all_people_f.person_id%TYPE;
9316: l_resource_id per_all_people_f.person_id%TYPE;
9317: l_baselined_version_id NUMBER;
9318: l_debug_mode VARCHAR2(1);

Line 9344: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

9340: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9341: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9342: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9343: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;
9344: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
9345: lx_time_phased_type_code pa_proj_fp_options.cost_time_phased_code%TYPE;
9346: lx_resource_list_name pa_resource_lists_all_bg.Name%TYPE := null;
9347: lx_raw_cost_flag VARCHAR2(1) ;
9348: lx_burdened_cost_flag VARCHAR2(1);

Line 9345: lx_time_phased_type_code pa_proj_fp_options.cost_time_phased_code%TYPE;

9341: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9342: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9343: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;
9344: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
9345: lx_time_phased_type_code pa_proj_fp_options.cost_time_phased_code%TYPE;
9346: lx_resource_list_name pa_resource_lists_all_bg.Name%TYPE := null;
9347: lx_raw_cost_flag VARCHAR2(1) ;
9348: lx_burdened_cost_flag VARCHAR2(1);
9349: lx_revenue_flag VARCHAR2(1);

Line 9354: lx_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;

9350: lx_cost_qty_flag VARCHAR2(1);
9351: lx_revenue_qty_flag VARCHAR2(1);
9352: lx_all_qty_flag VARCHAR2(1);
9353: x_return_status VARCHAR2(1);
9354: lx_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9355: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
9356: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9357: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9358: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;

Line 9355: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;

9351: lx_revenue_qty_flag VARCHAR2(1);
9352: lx_all_qty_flag VARCHAR2(1);
9353: x_return_status VARCHAR2(1);
9354: lx_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9355: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
9356: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9357: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9358: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9359: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

Line 9356: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;

9352: lx_all_qty_flag VARCHAR2(1);
9353: x_return_status VARCHAR2(1);
9354: lx_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9355: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
9356: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9357: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9358: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9359: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9360: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

Line 9357: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

9353: x_return_status VARCHAR2(1);
9354: lx_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9355: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
9356: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9357: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9358: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9359: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9360: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9361: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

Line 9358: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;

9354: lx_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9355: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
9356: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9357: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9358: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9359: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9360: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9361: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9362: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

Line 9359: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

9355: lx_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
9356: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9357: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9358: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9359: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9360: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9361: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9362: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9363: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

Line 9360: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

9356: lx_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
9357: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9358: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9359: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9360: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9361: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9362: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9363: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9364: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

Line 9361: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

9357: lx_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9358: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9359: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9360: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9361: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9362: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9363: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9364: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9365: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

Line 9362: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

9358: lx_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
9359: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9360: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9361: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9362: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9363: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9364: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9365: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
9366:

Line 9363: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

9359: lx_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
9360: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9361: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9362: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9363: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9364: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9365: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
9366:
9367: l_project_currency_code pa_projects_all.project_currency_code%TYPE; -- 3453650

Line 9364: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

9360: lx_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9361: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9362: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9363: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9364: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9365: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
9366:
9367: l_project_currency_code pa_projects_all.project_currency_code%TYPE; -- 3453650
9368: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE; -- 3453650

Line 9365: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

9361: lx_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
9362: lx_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
9363: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9364: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9365: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
9366:
9367: l_project_currency_code pa_projects_all.project_currency_code%TYPE; -- 3453650
9368: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE; -- 3453650
9369:

Line 9391: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

9387: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
9388: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9389: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
9390: l_amg_project_number pa_projects_all.segment1%TYPE;
9391: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
9392: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
9393: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;
9394: l_allow_qty_flag VARCHAR2(1);
9395: l_conv_attrs_to_be_validated VARCHAR2(30);

Line 9398: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;

9394: l_allow_qty_flag VARCHAR2(1);
9395: l_conv_attrs_to_be_validated VARCHAR2(30);
9396: l_is_rate_type_valid BOOLEAN;
9397: l_call_validate_curr_api_flg VARCHAR2(1);
9398: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9399: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9400: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9401: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9402: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;

Line 9399: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

9395: l_conv_attrs_to_be_validated VARCHAR2(30);
9396: l_is_rate_type_valid BOOLEAN;
9397: l_call_validate_curr_api_flg VARCHAR2(1);
9398: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9399: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9400: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9401: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9402: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9403: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;

Line 9400: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

9396: l_is_rate_type_valid BOOLEAN;
9397: l_call_validate_curr_api_flg VARCHAR2(1);
9398: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9399: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9400: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9401: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9402: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9403: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
9404: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;

Line 9401: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

9397: l_call_validate_curr_api_flg VARCHAR2(1);
9398: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9399: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9400: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9401: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9402: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9403: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
9404: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
9405: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

Line 9409: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

9405: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
9406:
9407: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
9408: /*Added local variables for bug 6408139*/
9409: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9410: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9411: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9412: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9413: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 9413: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;

9409: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9410: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9411: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9412: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9413: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;
9414:
9415:
9416: /*Added local variables for Bug 6417360*/
9417: l_attribute_category pa_budget_versions.attribute_category%type;

Line 10444: l_proj_fp_options_id_new := PA_PROJ_FP_OPTIONS_PUB.Get_FP_Option_ID

10440: pa_debug.g_err_stage:= 'Amount set id is -> ' || l_amount_set_id;
10441: pa_debug.write('UPDATE_BUDGET: ' || g_module_name,pa_debug.g_err_stage,3);
10442: END IF;
10443:
10444: l_proj_fp_options_id_new := PA_PROJ_FP_OPTIONS_PUB.Get_FP_Option_ID
10445: (p_project_id => l_project_id
10446: ,p_plan_type_id => l_fin_plan_type_id
10447: ,p_plan_version_id => l_budget_version_id
10448: );

Line 10452: UPDATE pa_proj_fp_options

10448: );
10449:
10450:
10451: IF lx_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST THEN
10452: UPDATE pa_proj_fp_options
10453: SET cost_amount_set_id = l_amount_set_id
10454: WHERE proj_fp_options_id = l_proj_fp_options_id_new;
10455: ELSIF lx_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE THEN
10456: UPDATE pa_proj_fp_options

Line 10456: UPDATE pa_proj_fp_options

10452: UPDATE pa_proj_fp_options
10453: SET cost_amount_set_id = l_amount_set_id
10454: WHERE proj_fp_options_id = l_proj_fp_options_id_new;
10455: ELSIF lx_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE THEN
10456: UPDATE pa_proj_fp_options
10457: SET revenue_amount_set_id = l_amount_set_id
10458: WHERE proj_fp_options_id = l_proj_fp_options_id_new;
10459: ELSIF lx_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL THEN
10460: UPDATE pa_proj_fp_options

Line 10460: UPDATE pa_proj_fp_options

10456: UPDATE pa_proj_fp_options
10457: SET revenue_amount_set_id = l_amount_set_id
10458: WHERE proj_fp_options_id = l_proj_fp_options_id_new;
10459: ELSIF lx_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL THEN
10460: UPDATE pa_proj_fp_options
10461: SET all_amount_set_id = l_amount_set_id
10462: WHERE proj_fp_options_id = l_proj_fp_options_id_new;
10463: END IF;
10464:

Line 10884: FROM pa_proj_fp_options

10880: INTO l_projfunc_cost_rate_type
10881: ,l_projfunc_rev_rate_type
10882: ,l_project_cost_rate_type
10883: ,l_project_rev_rate_type
10884: FROM pa_proj_fp_options
10885: WHERE project_id = l_project_id
10886: AND fin_plan_type_id=l_fin_plan_type_id
10887: AND fin_plan_version_id IS NULL
10888: AND fin_plan_option_level_code= PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

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

10943: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10944: END IF;
10945:
10946: IF l_debug_mode = 'Y' THEN
10947: pa_debug.g_err_stage := 'Updating pa_proj_fp_options with multi currency conversion attributes';
10948: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
10949: END IF;
10950:
10951: update pa_proj_fp_options

Line 10951: update pa_proj_fp_options

10947: pa_debug.g_err_stage := 'Updating pa_proj_fp_options with multi currency conversion attributes';
10948: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
10949: END IF;
10950:
10951: update pa_proj_fp_options
10952: set
10953: 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)
10954: ,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)
10955: ,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 12681: ,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

12677: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12678: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12679: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12680: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12681: ,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
12682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12683: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12684: ,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
12685: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

12678: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12679: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12680: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12681: ,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
12682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12683: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12684: ,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
12685: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12686: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

12679: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12680: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12681: ,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
12682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12683: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12684: ,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
12685: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12686: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12687: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 12684: ,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

12680: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12681: ,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
12682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12683: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12684: ,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
12685: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12686: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12687: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12688: ,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 12685: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

12681: ,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
12682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12683: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12684: ,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
12685: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12686: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12687: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12688: ,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
12689: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

12683: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12684: ,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
12685: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12686: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12687: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12688: ,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
12689: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12690: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12691: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 12688: ,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

12684: ,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
12685: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12686: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12687: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12688: ,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
12689: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12690: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12691: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12692: ,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 12689: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

12685: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12686: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12687: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12688: ,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
12689: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12690: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12691: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12692: ,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
12693: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

12687: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12688: ,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
12689: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12690: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12691: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12692: ,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
12693: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12694: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12695: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 12692: ,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

12688: ,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
12689: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12690: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12691: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12692: ,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
12693: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12694: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12695: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12696: ,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 12693: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

12689: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12690: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12691: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12692: ,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
12693: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12694: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12695: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12696: ,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
12697: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

12691: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12692: ,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
12693: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12694: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12695: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12696: ,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
12697: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12698: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12699: )

Line 12696: ,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

12692: ,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
12693: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12694: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12695: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12696: ,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
12697: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12698: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12699: )
12700:

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

12693: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12694: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12695: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12696: ,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
12697: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12698: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12699: )
12700:
12701: IS

Line 13042: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

13038: l_budget_version_id NUMBER;
13039: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
13040: l_resource_list_id NUMBER;
13041: l_budget_amount_code pa_budget_types.budget_amount_code%type;
13042: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
13043: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
13044: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
13045: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
13046: l_record_version_number pa_budget_versions.record_version_number%TYPE;

Line 13043: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

13039: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
13040: l_resource_list_id NUMBER;
13041: l_budget_amount_code pa_budget_types.budget_amount_code%type;
13042: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
13043: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
13044: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
13045: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
13046: l_record_version_number pa_budget_versions.record_version_number%TYPE;
13047:

Line 13044: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

13040: l_resource_list_id NUMBER;
13041: l_budget_amount_code pa_budget_types.budget_amount_code%type;
13042: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
13043: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
13044: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
13045: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
13046: l_record_version_number pa_budget_versions.record_version_number%TYPE;
13047:
13048: l_budget_lines_in budget_line_in_tbl_type;

Line 14273: FROM pa_proj_fp_options pfo

14269:
14270: CURSOR proj_fp_options_cur
14271: (c_project_id IN NUMBER, c_fin_plan_type_id IN NUMBER) IS
14272: SELECT 'x'
14273: FROM pa_proj_fp_options pfo
14274: WHERE pfo.project_id = c_project_id
14275: AND pfo.fin_plan_type_id = c_fin_plan_type_id
14276: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
14277:

Line 14346: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

14342: l_bill_rate_override_tbl l_bill_rate_override_tbl_t;
14343:
14344:
14345: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
14346: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
14347: l_bdgt_lines_skip_flag varchar2(1);
14348: l_targ_request_id pa_budget_versions.request_id%TYPE;
14349:
14350: --This variable will be used to call pa_resource_asgn_curr maintenance api - IPM Arch Enhancement

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

17110: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17111: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17112: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17113: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17114: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17115: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17116: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17117: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17118: ,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 17117: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17113: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17114: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17115: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17116: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17117: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17118: ,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
17119: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17120: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17121: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17118: ,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

17114: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17115: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17116: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17117: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17118: ,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
17119: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17120: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17121: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17122: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17158: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

17154:
17155:
17156: /* SCALAR VARIABLES */
17157: l_task_number pa_tasks.task_number%TYPE;
17158: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17159: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
17160: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17161: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17162: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;

Line 17167: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

17163: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17164: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17165: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17166: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
17167: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
17168: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
17169: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
17170: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
17171: -- Bug Fix: 4569365. Removed MRC code.

Line 17178: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

17174:
17175: l_plan_tran_context VARCHAR2(30);
17176: l_record_version_number pa_budget_versions.record_version_number%TYPE;
17177: l_mixed_resource_planned_flag VARCHAR2(1);
17178: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17179: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
17180: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
17181: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
17182:

Line 17210: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;

17206: l_budget_version_name pa_budget_versions.version_name%type;
17207: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17208: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
17209: l_version_type pa_budget_versions.version_type%TYPE ;
17210: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
17211: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
17212:
17213: L_RAW_COST_FLAG VARCHAR2(1);
17214: L_BURDENED_COST_FLAG VARCHAR2(1);

Line 17211: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;

17207: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17208: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
17209: l_version_type pa_budget_versions.version_type%TYPE ;
17210: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
17211: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
17212:
17213: L_RAW_COST_FLAG VARCHAR2(1);
17214: L_BURDENED_COST_FLAG VARCHAR2(1);
17215: L_REVENUE_FLAG VARCHAR2(1);

Line 17224: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

17220: L_CREATE_NEW_WORKING_FLAG VARCHAR2(1);
17221: L_REPLACE_CURRENT_WORKING_FLAG VARCHAR2(1);
17222: L_USING_RESOURCE_LISTS_FLAG VARCHAR2(1);
17223:
17224: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
17225: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
17226: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17227: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17228: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

Line 17225: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;

17221: L_REPLACE_CURRENT_WORKING_FLAG VARCHAR2(1);
17222: L_USING_RESOURCE_LISTS_FLAG VARCHAR2(1);
17223:
17224: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
17225: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
17226: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17227: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17228: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17229: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;

Line 17226: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;

17222: L_USING_RESOURCE_LISTS_FLAG VARCHAR2(1);
17223:
17224: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
17225: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
17226: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17227: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17228: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17229: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17230: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

Line 17227: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;

17223:
17224: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
17225: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
17226: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17227: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17228: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17229: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17230: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17231: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

Line 17228: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

17224: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
17225: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
17226: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17227: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17228: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17229: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17230: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17231: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17232: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

Line 17229: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;

17225: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
17226: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17227: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17228: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17229: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17230: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17231: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17232: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17233: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

Line 17230: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

17226: l_projfunc_cost_rate_date_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE ;
17227: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17228: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17229: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17230: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17231: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17232: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17233: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17234: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

Line 17231: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

17227: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
17228: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17229: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17230: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17231: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17232: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17233: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17234: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
17235: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

Line 17232: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

17228: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
17229: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17230: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17231: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17232: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17233: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17234: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
17235: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
17236: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

Line 17233: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

17229: l_projfunc_rev_rate_date_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
17230: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17231: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17232: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17233: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17234: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
17235: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
17236: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
17237:

Line 17234: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

17230: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
17231: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17232: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17233: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17234: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
17235: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
17236: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
17237:
17238: /**PLSQL TABLES**/

Line 17235: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

17231: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
17232: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17233: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17234: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
17235: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
17236: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
17237:
17238: /**PLSQL TABLES**/
17239: l_pm_task_reference_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 17236: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

17232: l_project_cost_rate_date_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
17233: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
17234: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
17235: l_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
17236: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
17237:
17238: /**PLSQL TABLES**/
17239: l_pm_task_reference_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
17240: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 17334: l_pt_amount_set_id pa_proj_fp_options.cost_amount_set_id%TYPE;

17330:
17331: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
17332:
17333: --Bug 5475184. In the below set, pt stands for "plan type".
17334: l_pt_amount_set_id pa_proj_fp_options.cost_amount_set_id%TYPE;
17335: l_pt_raw_cost_flag VARCHAR2(1);
17336: l_pt_burdened_flag VARCHAR2(1);
17337: l_pt_revenue_flag VARCHAR2(1);
17338: l_pt_cost_quantity_flag VARCHAR2(1);

Line 17760: FROM pa_proj_fp_options

17756: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_amount_set_id,
17757: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_amount_set_id,
17758: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_amount_set_id)
17759: INTO l_pt_amount_set_id
17760: FROM pa_proj_fp_options
17761: WHERE project_id=l_project_id
17762: AND fin_plan_type_id=l_fin_plan_type_id
17763: AND fin_plan_version_id IS NULL;
17764:

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

18859: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18860: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18861: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18862: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18863: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18864: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18865: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18866: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18867: ,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 18866: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

18862: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18863: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18864: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18865: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18866: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18867: ,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
18868: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18869: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18870: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 18867: ,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

18863: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18864: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18865: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18866: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18867: ,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
18868: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18869: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18870: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18871: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19116: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

19112: l_budget_version_id NUMBER;
19113: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
19114: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
19115: l_budget_amount_code pa_budget_types.budget_amount_code%type;
19116: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
19117: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
19118: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
19119: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
19120: l_project_number pa_projects_all.segment1%type;

Line 19117: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

19113: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
19114: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
19115: l_budget_amount_code pa_budget_types.budget_amount_code%type;
19116: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
19117: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
19118: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
19119: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
19120: l_project_number pa_projects_all.segment1%type;
19121:

Line 19118: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

19114: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
19115: l_budget_amount_code pa_budget_types.budget_amount_code%type;
19116: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
19117: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
19118: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
19119: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
19120: l_project_number pa_projects_all.segment1%type;
19121:
19122: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type;

Line 19496: pa_proj_fp_options pf

19492: ,pa.PROJFUNC_CURRENCY_CODE
19493: ,pa.PROJECT_CURRENCY_CODE)
19494: INTO l_currency_code
19495: FROM pa_projects_all pa,
19496: pa_proj_fp_options pf
19497: WHERE pa.project_id=l_project_id
19498: AND pa.project_id=pf.project_id
19499: AND pf.fin_plan_version_id=l_budget_version_id;
19500: