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_PVT dependencies on PA_PROJ_FP_OPTIONS

Line 53: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

49: -- plan version is user.TRUE is returned otherwise
50: -- Created 19-FEB-03 sgoteti
51: --
52: PROCEDURE valid_rate_type
53: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
54: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
55: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
56: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
57: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

Line 54: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

50: -- Created 19-FEB-03 sgoteti
51: --
52: PROCEDURE valid_rate_type
53: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
54: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
55: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
56: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
57: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
58: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

Line 55: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

51: --
52: PROCEDURE valid_rate_type
53: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
54: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
55: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
56: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
57: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
58: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
59: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

Line 56: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

52: PROCEDURE valid_rate_type
53: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
54: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
55: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
56: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
57: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
58: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
59: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
60: ,p_pv_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

Line 57: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

53: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
54: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
55: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
56: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
57: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
58: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
59: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
60: ,p_pv_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
61: ,x_is_rate_type_valid OUT NOCOPY BOOLEAN --File.Sql.39 bug 4440895

Line 58: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

54: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
55: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
56: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
57: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
58: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
59: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
60: ,p_pv_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
61: ,x_is_rate_type_valid OUT NOCOPY BOOLEAN --File.Sql.39 bug 4440895
62: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 59: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

55: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
56: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
57: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
58: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
59: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
60: ,p_pv_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
61: ,x_is_rate_type_valid OUT NOCOPY BOOLEAN --File.Sql.39 bug 4440895
62: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
63: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 60: ,p_pv_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

56: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
57: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
58: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
59: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
60: ,p_pv_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
61: ,x_is_rate_type_valid OUT NOCOPY BOOLEAN --File.Sql.39 bug 4440895
62: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
63: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
64: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 163: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895

159: ,px_resource_list_id IN OUT NOCOPY pa_resource_lists_all_bg.resource_list_id%TYPE --File.Sql.39 bug 4440895
160: ,px_fin_plan_type_id IN OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
161: ,px_fin_plan_type_name IN OUT NOCOPY pa_fin_plan_types_tl.name%TYPE --File.Sql.39 bug 4440895
162: ,px_version_type IN OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
163: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
164: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
165: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
166: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

Line 164: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895

160: ,px_fin_plan_type_id IN OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
161: ,px_fin_plan_type_name IN OUT NOCOPY pa_fin_plan_types_tl.name%TYPE --File.Sql.39 bug 4440895
162: ,px_version_type IN OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
163: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
164: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
165: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
166: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895

Line 165: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895

161: ,px_fin_plan_type_name IN OUT NOCOPY pa_fin_plan_types_tl.name%TYPE --File.Sql.39 bug 4440895
162: ,px_version_type IN OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
163: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
164: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
165: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
166: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895

Line 166: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

162: ,px_version_type IN OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
163: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
164: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
165: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
166: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

Line 167: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

163: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
164: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
165: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
166: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
171: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895

Line 168: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895

164: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
165: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
166: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
171: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
172: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895

Line 169: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895

165: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
166: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
171: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
172: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
173: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

Line 170: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

166: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
171: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
172: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
173: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
174: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895

Line 171: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895

167: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
171: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
172: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
173: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
174: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
175: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895

Line 172: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895

168: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
171: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
172: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
173: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
174: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
175: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
176: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

Line 173: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

169: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
171: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
172: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
173: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
174: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
175: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
176: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
177: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895

Line 174: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895

170: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
171: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
172: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
173: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
174: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
175: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
176: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
177: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
178: ,px_raw_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 175: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895

171: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
172: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
173: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
174: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
175: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
176: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
177: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
178: ,px_raw_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
179: ,px_burdened_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 176: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

172: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
173: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
174: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
175: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
176: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
177: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
178: ,px_raw_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
179: ,px_burdened_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
180: ,px_revenue_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 177: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895

173: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
174: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
175: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
176: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
177: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
178: ,px_raw_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
179: ,px_burdened_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
180: ,px_revenue_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
181: ,px_cost_qty_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 241: FROM pa_proj_fp_options

237: ,project_cost_rate_date
238: ,project_rev_rate_type
239: ,project_rev_rate_date_type
240: ,project_rev_rate_date
241: FROM pa_proj_fp_options
242: WHERE project_id=c_project_id
243: AND fin_plan_type_id=c_fin_plan_type_id
244: AND fin_plan_version_id IS NULL
245: AND fin_plan_option_level_code= PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

Line 281: FROM pa_proj_fp_options

277: ,decode(c_version_type,
278: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,
279: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,
280: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_time_phased_code) time_phased_code
281: FROM pa_proj_fp_options
282: WHERE project_id=c_project_id
283: AND fin_plan_type_id=c_fin_plan_type_id
284: AND fin_plan_version_id IS NULL
285: AND fin_plan_option_level_code= PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

Line 334: FROM pa_fin_plan_types_b fin ,pa_proj_fp_options pfo

330: ( c_budget_type_code pa_budget_types.budget_type_code%TYPE
331: ,c_project_id pa_projects_all.project_id%TYPE)
332: IS
333: SELECT 'X'
334: FROM pa_fin_plan_types_b fin ,pa_proj_fp_options pfo
335: WHERE pfo.project_id=c_project_id
336: AND pfo.fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE --AMG UT2
337: AND pfo.fin_plan_type_id = fin.fin_plan_type_id
338: AND fin.migrated_frm_bdgt_typ_code = c_budget_type_code;

Line 2764: FROM pa_proj_fp_options

2760: ,decode(c_version_type,
2761: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,
2762: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,
2763: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_time_phased_code) time_phased_code
2764: FROM pa_proj_fp_options
2765: WHERE project_id=c_project_id
2766: AND fin_plan_type_id=c_fin_plan_type_id
2767: AND fin_plan_version_id = c_fin_plan_version_id;
2768:

Line 2851: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;

2847: l_balance_type VARCHAR2(1) := NULL;
2848:
2849: l_targ_request_id pa_budget_versions.request_id%TYPE;
2850: /*Variables added for bug 6408139*/
2851: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
2852: lx_raw_cost_flag VARCHAR2(1) ;
2853: lx_burdened_cost_flag VARCHAR2(1);
2854: lx_revenue_flag VARCHAR2(1);
2855: lx_cost_qty_flag VARCHAR2(1);

Line 5682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE

5678: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
5679: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
5680: ,p_version_type IN pa_budget_versions.version_type%TYPE
5681: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
5682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
5683: ,p_budget_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
5684: ,p_entry_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
5685: ,p_allow_qty_flag IN VARCHAR2
5686: ,p_allow_raw_cost_flag IN VARCHAR2

Line 5684: ,p_entry_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

5680: ,p_version_type IN pa_budget_versions.version_type%TYPE
5681: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
5682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
5683: ,p_budget_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
5684: ,p_entry_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
5685: ,p_allow_qty_flag IN VARCHAR2
5686: ,p_allow_raw_cost_flag IN VARCHAR2
5687: ,p_allow_burdened_cost_flag IN VARCHAR2
5688: ,p_allow_revenue_flag IN VARCHAR2

Line 5689: ,p_multi_currency_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE

5685: ,p_allow_qty_flag IN VARCHAR2
5686: ,p_allow_raw_cost_flag IN VARCHAR2
5687: ,p_allow_burdened_cost_flag IN VARCHAR2
5688: ,p_allow_revenue_flag IN VARCHAR2
5689: ,p_multi_currency_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
5690: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
5691: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
5692: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
5693: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE

Line 5690: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

5686: ,p_allow_raw_cost_flag IN VARCHAR2
5687: ,p_allow_burdened_cost_flag IN VARCHAR2
5688: ,p_allow_revenue_flag IN VARCHAR2
5689: ,p_multi_currency_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
5690: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
5691: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
5692: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
5693: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
5694: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

Line 5691: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

5687: ,p_allow_burdened_cost_flag IN VARCHAR2
5688: ,p_allow_revenue_flag IN VARCHAR2
5689: ,p_multi_currency_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
5690: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
5691: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
5692: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
5693: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
5694: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
5695: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

Line 5692: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

5688: ,p_allow_revenue_flag IN VARCHAR2
5689: ,p_multi_currency_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
5690: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
5691: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
5692: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
5693: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
5694: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
5695: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
5696: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

Line 5694: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

5690: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
5691: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
5692: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
5693: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
5694: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
5695: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
5696: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
5697: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
5698: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

Line 5695: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

5691: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
5692: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
5693: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
5694: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
5695: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
5696: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
5697: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
5698: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
5699: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

Line 5696: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

5692: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
5693: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
5694: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
5695: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
5696: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
5697: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
5698: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
5699: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
5700: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

Line 5698: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

5694: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
5695: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
5696: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
5697: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
5698: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
5699: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
5700: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
5701: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5702: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

Line 5699: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

5695: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
5696: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
5697: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
5698: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
5699: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
5700: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
5701: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5702: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
5703: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

Line 5700: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

5696: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
5697: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
5698: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
5699: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
5700: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
5701: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5702: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
5703: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
5704: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

Line 5702: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

5698: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
5699: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
5700: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
5701: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5702: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
5703: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
5704: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
5705: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5706:

Line 5703: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

5699: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
5700: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
5701: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5702: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
5703: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
5704: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
5705: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5706:
5707: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added */

Line 5704: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

5700: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
5701: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5702: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
5703: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
5704: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
5705: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5706:
5707: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added */
5708: ,p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols

Line 5831: FROM pa_proj_fp_options

5827: ,c_project_id pa_projects_all.project_id%TYPE)
5828: IS
5829: SELECT approved_rev_plan_type_flag,
5830: proj_fp_options_id
5831: FROM pa_proj_fp_options
5832: WHERE project_id=c_project_id
5833: AND fin_plan_type_id=c_fin_plan_type_id
5834: AND fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
5835:

Line 5851: l_app_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;

5847: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5848: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
5849: /* Bug 4224464: FP M Changes End */
5850:
5851: l_app_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
5852:
5853: l_msg_count NUMBER := 0;
5854: l_data VARCHAR2(2000);
5855: l_msg_data VARCHAR2(2000);

Line 5938: l_wa_project_cost_rate_typ pa_proj_fp_options.project_cost_rate_type%TYPE;

5934:
5935: -- for bug 3954329
5936: l_rlm_migration_code pa_resource_lists_all_bg.migration_code%TYPE;
5937:
5938: l_wa_project_cost_rate_typ pa_proj_fp_options.project_cost_rate_type%TYPE;
5939: l_wa_project_cost_rate_dt_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE;
5940: l_wa_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
5941: l_wa_project_cost_exc_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
5942: l_wa_projfunc_cost_rate_typ pa_proj_fp_options.projfunc_cost_rate_type%TYPE;

Line 5939: l_wa_project_cost_rate_dt_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE;

5935: -- for bug 3954329
5936: l_rlm_migration_code pa_resource_lists_all_bg.migration_code%TYPE;
5937:
5938: l_wa_project_cost_rate_typ pa_proj_fp_options.project_cost_rate_type%TYPE;
5939: l_wa_project_cost_rate_dt_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE;
5940: l_wa_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
5941: l_wa_project_cost_exc_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
5942: l_wa_projfunc_cost_rate_typ pa_proj_fp_options.projfunc_cost_rate_type%TYPE;
5943: l_wa_projfunc_cost_rate_dt_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;

Line 5940: l_wa_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;

5936: l_rlm_migration_code pa_resource_lists_all_bg.migration_code%TYPE;
5937:
5938: l_wa_project_cost_rate_typ pa_proj_fp_options.project_cost_rate_type%TYPE;
5939: l_wa_project_cost_rate_dt_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE;
5940: l_wa_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
5941: l_wa_project_cost_exc_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
5942: l_wa_projfunc_cost_rate_typ pa_proj_fp_options.projfunc_cost_rate_type%TYPE;
5943: l_wa_projfunc_cost_rate_dt_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
5944: l_wa_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE;

Line 5942: l_wa_projfunc_cost_rate_typ pa_proj_fp_options.projfunc_cost_rate_type%TYPE;

5938: l_wa_project_cost_rate_typ pa_proj_fp_options.project_cost_rate_type%TYPE;
5939: l_wa_project_cost_rate_dt_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE;
5940: l_wa_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
5941: l_wa_project_cost_exc_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
5942: l_wa_projfunc_cost_rate_typ pa_proj_fp_options.projfunc_cost_rate_type%TYPE;
5943: l_wa_projfunc_cost_rate_dt_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
5944: l_wa_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE;
5945: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
5946: l_wa_project_rev_rate_typ pa_proj_fp_options.project_rev_rate_type%TYPE;

Line 5943: l_wa_projfunc_cost_rate_dt_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;

5939: l_wa_project_cost_rate_dt_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE;
5940: l_wa_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
5941: l_wa_project_cost_exc_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
5942: l_wa_projfunc_cost_rate_typ pa_proj_fp_options.projfunc_cost_rate_type%TYPE;
5943: l_wa_projfunc_cost_rate_dt_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
5944: l_wa_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE;
5945: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
5946: l_wa_project_rev_rate_typ pa_proj_fp_options.project_rev_rate_type%TYPE;
5947: l_wa_project_rev_rate_dt_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE;

Line 5944: l_wa_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE;

5940: l_wa_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
5941: l_wa_project_cost_exc_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
5942: l_wa_projfunc_cost_rate_typ pa_proj_fp_options.projfunc_cost_rate_type%TYPE;
5943: l_wa_projfunc_cost_rate_dt_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
5944: l_wa_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE;
5945: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
5946: l_wa_project_rev_rate_typ pa_proj_fp_options.project_rev_rate_type%TYPE;
5947: l_wa_project_rev_rate_dt_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE;
5948: l_wa_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE;

Line 5946: l_wa_project_rev_rate_typ pa_proj_fp_options.project_rev_rate_type%TYPE;

5942: l_wa_projfunc_cost_rate_typ pa_proj_fp_options.projfunc_cost_rate_type%TYPE;
5943: l_wa_projfunc_cost_rate_dt_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
5944: l_wa_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE;
5945: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
5946: l_wa_project_rev_rate_typ pa_proj_fp_options.project_rev_rate_type%TYPE;
5947: l_wa_project_rev_rate_dt_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE;
5948: l_wa_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE;
5949: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5950: l_wa_projfunc_rev_rate_typ pa_proj_fp_options.projfunc_rev_rate_type%TYPE;

Line 5947: l_wa_project_rev_rate_dt_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE;

5943: l_wa_projfunc_cost_rate_dt_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
5944: l_wa_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE;
5945: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
5946: l_wa_project_rev_rate_typ pa_proj_fp_options.project_rev_rate_type%TYPE;
5947: l_wa_project_rev_rate_dt_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE;
5948: l_wa_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE;
5949: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5950: l_wa_projfunc_rev_rate_typ pa_proj_fp_options.projfunc_rev_rate_type%TYPE;
5951: l_wa_projfunc_rev_rate_dt_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;

Line 5948: l_wa_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE;

5944: l_wa_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE;
5945: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
5946: l_wa_project_rev_rate_typ pa_proj_fp_options.project_rev_rate_type%TYPE;
5947: l_wa_project_rev_rate_dt_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE;
5948: l_wa_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE;
5949: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5950: l_wa_projfunc_rev_rate_typ pa_proj_fp_options.projfunc_rev_rate_type%TYPE;
5951: l_wa_projfunc_rev_rate_dt_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
5952: l_wa_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE;

Line 5950: l_wa_projfunc_rev_rate_typ pa_proj_fp_options.projfunc_rev_rate_type%TYPE;

5946: l_wa_project_rev_rate_typ pa_proj_fp_options.project_rev_rate_type%TYPE;
5947: l_wa_project_rev_rate_dt_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE;
5948: l_wa_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE;
5949: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5950: l_wa_projfunc_rev_rate_typ pa_proj_fp_options.projfunc_rev_rate_type%TYPE;
5951: l_wa_projfunc_rev_rate_dt_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
5952: l_wa_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE;
5953: l_wa_projfunc_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5954: l_wa_val_conv_attr_flag VARCHAR2(1);

Line 5951: l_wa_projfunc_rev_rate_dt_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;

5947: l_wa_project_rev_rate_dt_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE;
5948: l_wa_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE;
5949: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5950: l_wa_projfunc_rev_rate_typ pa_proj_fp_options.projfunc_rev_rate_type%TYPE;
5951: l_wa_projfunc_rev_rate_dt_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
5952: l_wa_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE;
5953: l_wa_projfunc_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5954: l_wa_val_conv_attr_flag VARCHAR2(1);
5955: l_calling_model_context VARCHAR(30);

Line 5952: l_wa_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE;

5948: l_wa_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE;
5949: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5950: l_wa_projfunc_rev_rate_typ pa_proj_fp_options.projfunc_rev_rate_type%TYPE;
5951: l_wa_projfunc_rev_rate_dt_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
5952: l_wa_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE;
5953: l_wa_projfunc_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5954: l_wa_val_conv_attr_flag VARCHAR2(1);
5955: l_calling_model_context VARCHAR(30);
5956:

Line 6006: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

6002: l_period_start_date_tbl date_tbl_type;
6003: l_period_end_date_tbl date_tbl_type;
6004: l_period_plan_start_date_tbl date_tbl_type;
6005: l_period_plan_end_date_tbl date_tbl_type;
6006: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
6007:
6008: l_fixed_date_sp_id number;
6009: l_resource_assignment_id number;
6010: l_planning_start_date date;

Line 8549: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE; -- Added for BUG 6847497

8545: l_module_name VARCHAR2(80);
8546: l_tmp_return_status VARCHAR2(1);
8547: I NUMBER;
8548: l_count NUMBER;
8549: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE; -- Added for BUG 6847497
8550: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE; -- Added for BUG 6847497
8551:
8552: CURSOR get_primary_key_csr IS
8553: SELECT ra.task_id,

Line 8661: FROM pa_proj_fp_options , pa_resource_lists_all_bg prl

8657:
8658: SELECT nvl(cost_time_phased_code,NVL(revenue_time_phased_code,all_time_phased_code)), -- Added for BUG 6847497
8659: prl.uncategorized_flag
8660: INTO l_time_phased_code, l_uncategorized_flag
8661: FROM pa_proj_fp_options , pa_resource_lists_all_bg prl
8662: WHERE fin_plan_version_id=p_fin_plan_version_id
8663: AND nvl(cost_resource_list_id,nvl(revenue_resource_list_id,all_resource_list_id))=
8664: prl.resource_list_id;
8665: