DBA Data[Home] [Help]

APPS.PA_FP_VIEW_PLANS_TXN_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 42: G_REPORT_LABOR_HRS_FROM_CODE pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

38: G_REV_VERSION_ID NUMBER(15);
39: G_SINGLE_VERSION_ID NUMBER(15); -- used only for gathering summary #'s
40: G_COST_RESOURCE_LIST_ID NUMBER(15); -- for Resource Group, Resource LOV filter
41: G_REVENUE_RESOURCE_LIST_ID NUMBER(15); -- for Resource Group, Resource LOV filter
42: G_REPORT_LABOR_HRS_FROM_CODE pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
43: G_DERIVE_MARGIN_FROM_CODE VARCHAR2(30); -- R=rawcost, B=burdenedcost
44: G_DISPLAY_FROM VARCHAR2(30); -- 'COST' = COST_ONLY version
45: -- 'REVENUE' = REVENUE_ONLY version
46: -- 'BOTH' = COST_AND_REV_SEP

Line 102: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895

98: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895
99: x_multicurrency_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
100: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
101: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
102: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
103: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
104: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
105: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
106: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 108: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895

104: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
105: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
106: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
107: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
108: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
109: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
110: x_plan_class_code OUT NOCOPY VARCHAR2, -- FP L: Plan Class Security --File.Sql.39 bug 4440895
111: x_display_res_flag OUT NOCOPY VARCHAR2, -- bug 3081511 --File.Sql.39 bug 4440895
112: x_display_resgp_flag OUT NOCOPY VARCHAR2, -- bug 3081511 --File.Sql.39 bug 4440895

Line 121: -- p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,

117: );
118: procedure nonhgrid_edit_initialize
119: (p_project_id IN pa_budget_versions.project_id%TYPE,
120: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
121: -- p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,
122: -- p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
123: -- p_working_or_baselined IN VARCHAR2,
124: -- p_cost_or_revenue IN VARCHAR2,
125: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

Line 122: -- p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,

118: procedure nonhgrid_edit_initialize
119: (p_project_id IN pa_budget_versions.project_id%TYPE,
120: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
121: -- p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,
122: -- p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
123: -- p_working_or_baselined IN VARCHAR2,
124: -- p_cost_or_revenue IN VARCHAR2,
125: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
126: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895

Line 139: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895

135: x_multicurrency_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
136: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
137: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
138: x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
139: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
140: x_plan_version_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
141: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
142: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
143: x_auto_baselined_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 140: x_plan_version_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895

136: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
137: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
138: x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
139: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
140: x_plan_version_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
141: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
142: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
143: x_auto_baselined_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
144: x_plan_class_code OUT NOCOPY VARCHAR2, -- FP L: Plan Class Security --File.Sql.39 bug 4440895

Line 186: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895

182: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895
183: x_multicurrency_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
184: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
185: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
186: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
187: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
188: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
189: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
190: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 192: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895

188: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
189: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
190: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
191: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
192: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
193: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
194: x_auto_baselined_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
195: x_display_res_flag OUT NOCOPY VARCHAR2, -- bug 3081511 --File.Sql.39 bug 4440895
196: x_display_resgp_flag OUT NOCOPY VARCHAR2, -- bug 3081511 --File.Sql.39 bug 4440895