1: PACKAGE BODY pa_proj_fp_options_pkg as
2: /* $Header: PAFPPOTB.pls 120.3 2007/02/06 10:04:58 dthakker ship $ */
3: -- Start of Comments
4: -- Package name : PA_PROJ_FP_OPTIONS_PKG
5: -- Purpose :
1: PACKAGE BODY pa_proj_fp_options_pkg as
2: /* $Header: PAFPPOTB.pls 120.3 2007/02/06 10:04:58 dthakker ship $ */
3: -- Start of Comments
4: -- Package name : PA_PROJ_FP_OPTIONS_PKG
5: -- Purpose :
6: -- History :
7: -- 15-May-2002 Vejayara Added parameters for columns factor_by_code
8: -- and plan_in_multi_curr_flag
62: -- Removed referenced to column RES_CLASS_BURDEN_SCH_ID
63: -- in apis insert_row and update_row as this
64: -- column has been removed.
65: -- 20-MAR-2004 rravipat - Bug 3519062
66: -- Impact of new columns to pa_proj_fp_options
67: -- New columns have been included to hold workplan
68: -- version details if workplan is the source of
69: -- generation
70:
85: -- Included parameter revenue_derivation_method in Insert_Row, update_row
86: -- NOTE :
87: -- End of Comments
88:
89: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJ_FP_OPTIONS_PKG';
90: G_FILE_NAME CONSTANT VARCHAR2(12) := 'PAFPPOTB.pls';
91:
92: PROCEDURE Insert_Row
93: ( px_proj_fp_options_id
90: G_FILE_NAME CONSTANT VARCHAR2(12) := 'PAFPPOTB.pls';
91:
92: PROCEDURE Insert_Row
93: ( px_proj_fp_options_id
94: IN OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
95: ,p_project_id
96: IN pa_proj_fp_options.project_id%TYPE := FND_API.G_MISS_NUM
97: ,p_fin_plan_option_level_code
98: IN pa_proj_fp_options.fin_plan_option_level_code%TYPE := FND_API.G_MISS_CHAR
92: PROCEDURE Insert_Row
93: ( px_proj_fp_options_id
94: IN OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
95: ,p_project_id
96: IN pa_proj_fp_options.project_id%TYPE := FND_API.G_MISS_NUM
97: ,p_fin_plan_option_level_code
98: IN pa_proj_fp_options.fin_plan_option_level_code%TYPE := FND_API.G_MISS_CHAR
99: ,p_fin_plan_type_id
100: IN pa_proj_fp_options.fin_plan_type_id%TYPE := FND_API.G_MISS_NUM
94: IN OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
95: ,p_project_id
96: IN pa_proj_fp_options.project_id%TYPE := FND_API.G_MISS_NUM
97: ,p_fin_plan_option_level_code
98: IN pa_proj_fp_options.fin_plan_option_level_code%TYPE := FND_API.G_MISS_CHAR
99: ,p_fin_plan_type_id
100: IN pa_proj_fp_options.fin_plan_type_id%TYPE := FND_API.G_MISS_NUM
101: ,p_fin_plan_start_date
102: IN pa_proj_fp_options.fin_plan_start_date%TYPE := FND_API.G_MISS_DATE
96: IN pa_proj_fp_options.project_id%TYPE := FND_API.G_MISS_NUM
97: ,p_fin_plan_option_level_code
98: IN pa_proj_fp_options.fin_plan_option_level_code%TYPE := FND_API.G_MISS_CHAR
99: ,p_fin_plan_type_id
100: IN pa_proj_fp_options.fin_plan_type_id%TYPE := FND_API.G_MISS_NUM
101: ,p_fin_plan_start_date
102: IN pa_proj_fp_options.fin_plan_start_date%TYPE := FND_API.G_MISS_DATE
103: ,p_fin_plan_end_date
104: IN pa_proj_fp_options.fin_plan_end_date%TYPE := FND_API.G_MISS_DATE
98: IN pa_proj_fp_options.fin_plan_option_level_code%TYPE := FND_API.G_MISS_CHAR
99: ,p_fin_plan_type_id
100: IN pa_proj_fp_options.fin_plan_type_id%TYPE := FND_API.G_MISS_NUM
101: ,p_fin_plan_start_date
102: IN pa_proj_fp_options.fin_plan_start_date%TYPE := FND_API.G_MISS_DATE
103: ,p_fin_plan_end_date
104: IN pa_proj_fp_options.fin_plan_end_date%TYPE := FND_API.G_MISS_DATE
105: ,p_fin_plan_preference_code
106: IN pa_proj_fp_options.fin_plan_preference_code%TYPE := FND_API.G_MISS_CHAR
100: IN pa_proj_fp_options.fin_plan_type_id%TYPE := FND_API.G_MISS_NUM
101: ,p_fin_plan_start_date
102: IN pa_proj_fp_options.fin_plan_start_date%TYPE := FND_API.G_MISS_DATE
103: ,p_fin_plan_end_date
104: IN pa_proj_fp_options.fin_plan_end_date%TYPE := FND_API.G_MISS_DATE
105: ,p_fin_plan_preference_code
106: IN pa_proj_fp_options.fin_plan_preference_code%TYPE := FND_API.G_MISS_CHAR
107: ,p_cost_amount_set_id
108: IN pa_proj_fp_options.cost_amount_set_id%TYPE := FND_API.G_MISS_NUM
102: IN pa_proj_fp_options.fin_plan_start_date%TYPE := FND_API.G_MISS_DATE
103: ,p_fin_plan_end_date
104: IN pa_proj_fp_options.fin_plan_end_date%TYPE := FND_API.G_MISS_DATE
105: ,p_fin_plan_preference_code
106: IN pa_proj_fp_options.fin_plan_preference_code%TYPE := FND_API.G_MISS_CHAR
107: ,p_cost_amount_set_id
108: IN pa_proj_fp_options.cost_amount_set_id%TYPE := FND_API.G_MISS_NUM
109: ,p_revenue_amount_set_id
110: IN pa_proj_fp_options.revenue_amount_set_id%TYPE := FND_API.G_MISS_NUM
104: IN pa_proj_fp_options.fin_plan_end_date%TYPE := FND_API.G_MISS_DATE
105: ,p_fin_plan_preference_code
106: IN pa_proj_fp_options.fin_plan_preference_code%TYPE := FND_API.G_MISS_CHAR
107: ,p_cost_amount_set_id
108: IN pa_proj_fp_options.cost_amount_set_id%TYPE := FND_API.G_MISS_NUM
109: ,p_revenue_amount_set_id
110: IN pa_proj_fp_options.revenue_amount_set_id%TYPE := FND_API.G_MISS_NUM
111: ,p_all_amount_set_id
112: IN pa_proj_fp_options.all_amount_set_id%TYPE := FND_API.G_MISS_NUM
106: IN pa_proj_fp_options.fin_plan_preference_code%TYPE := FND_API.G_MISS_CHAR
107: ,p_cost_amount_set_id
108: IN pa_proj_fp_options.cost_amount_set_id%TYPE := FND_API.G_MISS_NUM
109: ,p_revenue_amount_set_id
110: IN pa_proj_fp_options.revenue_amount_set_id%TYPE := FND_API.G_MISS_NUM
111: ,p_all_amount_set_id
112: IN pa_proj_fp_options.all_amount_set_id%TYPE := FND_API.G_MISS_NUM
113: ,p_cost_fin_plan_level_code
114: IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
108: IN pa_proj_fp_options.cost_amount_set_id%TYPE := FND_API.G_MISS_NUM
109: ,p_revenue_amount_set_id
110: IN pa_proj_fp_options.revenue_amount_set_id%TYPE := FND_API.G_MISS_NUM
111: ,p_all_amount_set_id
112: IN pa_proj_fp_options.all_amount_set_id%TYPE := FND_API.G_MISS_NUM
113: ,p_cost_fin_plan_level_code
114: IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
115: ,p_cost_time_phased_code
116: IN pa_proj_fp_options.cost_time_phased_code%TYPE := FND_API.G_MISS_CHAR
110: IN pa_proj_fp_options.revenue_amount_set_id%TYPE := FND_API.G_MISS_NUM
111: ,p_all_amount_set_id
112: IN pa_proj_fp_options.all_amount_set_id%TYPE := FND_API.G_MISS_NUM
113: ,p_cost_fin_plan_level_code
114: IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
115: ,p_cost_time_phased_code
116: IN pa_proj_fp_options.cost_time_phased_code%TYPE := FND_API.G_MISS_CHAR
117: ,p_cost_resource_list_id
118: IN pa_proj_fp_options.cost_resource_list_id%TYPE := FND_API.G_MISS_NUM
112: IN pa_proj_fp_options.all_amount_set_id%TYPE := FND_API.G_MISS_NUM
113: ,p_cost_fin_plan_level_code
114: IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
115: ,p_cost_time_phased_code
116: IN pa_proj_fp_options.cost_time_phased_code%TYPE := FND_API.G_MISS_CHAR
117: ,p_cost_resource_list_id
118: IN pa_proj_fp_options.cost_resource_list_id%TYPE := FND_API.G_MISS_NUM
119: ,p_revenue_fin_plan_level_code
120: IN pa_proj_fp_options.revenue_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
114: IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
115: ,p_cost_time_phased_code
116: IN pa_proj_fp_options.cost_time_phased_code%TYPE := FND_API.G_MISS_CHAR
117: ,p_cost_resource_list_id
118: IN pa_proj_fp_options.cost_resource_list_id%TYPE := FND_API.G_MISS_NUM
119: ,p_revenue_fin_plan_level_code
120: IN pa_proj_fp_options.revenue_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
121: ,p_revenue_time_phased_code
122: IN pa_proj_fp_options.revenue_time_phased_code%TYPE := FND_API.G_MISS_CHAR
116: IN pa_proj_fp_options.cost_time_phased_code%TYPE := FND_API.G_MISS_CHAR
117: ,p_cost_resource_list_id
118: IN pa_proj_fp_options.cost_resource_list_id%TYPE := FND_API.G_MISS_NUM
119: ,p_revenue_fin_plan_level_code
120: IN pa_proj_fp_options.revenue_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
121: ,p_revenue_time_phased_code
122: IN pa_proj_fp_options.revenue_time_phased_code%TYPE := FND_API.G_MISS_CHAR
123: ,p_revenue_resource_list_id
124: IN pa_proj_fp_options.revenue_resource_list_id%TYPE := FND_API.G_MISS_NUM
118: IN pa_proj_fp_options.cost_resource_list_id%TYPE := FND_API.G_MISS_NUM
119: ,p_revenue_fin_plan_level_code
120: IN pa_proj_fp_options.revenue_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
121: ,p_revenue_time_phased_code
122: IN pa_proj_fp_options.revenue_time_phased_code%TYPE := FND_API.G_MISS_CHAR
123: ,p_revenue_resource_list_id
124: IN pa_proj_fp_options.revenue_resource_list_id%TYPE := FND_API.G_MISS_NUM
125: ,p_all_fin_plan_level_code
126: IN pa_proj_fp_options.all_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
120: IN pa_proj_fp_options.revenue_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
121: ,p_revenue_time_phased_code
122: IN pa_proj_fp_options.revenue_time_phased_code%TYPE := FND_API.G_MISS_CHAR
123: ,p_revenue_resource_list_id
124: IN pa_proj_fp_options.revenue_resource_list_id%TYPE := FND_API.G_MISS_NUM
125: ,p_all_fin_plan_level_code
126: IN pa_proj_fp_options.all_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
127: ,p_all_time_phased_code
128: IN pa_proj_fp_options.all_time_phased_code%TYPE := FND_API.G_MISS_CHAR
122: IN pa_proj_fp_options.revenue_time_phased_code%TYPE := FND_API.G_MISS_CHAR
123: ,p_revenue_resource_list_id
124: IN pa_proj_fp_options.revenue_resource_list_id%TYPE := FND_API.G_MISS_NUM
125: ,p_all_fin_plan_level_code
126: IN pa_proj_fp_options.all_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
127: ,p_all_time_phased_code
128: IN pa_proj_fp_options.all_time_phased_code%TYPE := FND_API.G_MISS_CHAR
129: ,p_all_resource_list_id
130: IN pa_proj_fp_options.all_resource_list_id%TYPE := FND_API.G_MISS_NUM
124: IN pa_proj_fp_options.revenue_resource_list_id%TYPE := FND_API.G_MISS_NUM
125: ,p_all_fin_plan_level_code
126: IN pa_proj_fp_options.all_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
127: ,p_all_time_phased_code
128: IN pa_proj_fp_options.all_time_phased_code%TYPE := FND_API.G_MISS_CHAR
129: ,p_all_resource_list_id
130: IN pa_proj_fp_options.all_resource_list_id%TYPE := FND_API.G_MISS_NUM
131: ,p_report_labor_hrs_from_code
132: IN pa_proj_fp_options.report_labor_hrs_from_code%TYPE := FND_API.G_MISS_CHAR
126: IN pa_proj_fp_options.all_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
127: ,p_all_time_phased_code
128: IN pa_proj_fp_options.all_time_phased_code%TYPE := FND_API.G_MISS_CHAR
129: ,p_all_resource_list_id
130: IN pa_proj_fp_options.all_resource_list_id%TYPE := FND_API.G_MISS_NUM
131: ,p_report_labor_hrs_from_code
132: IN pa_proj_fp_options.report_labor_hrs_from_code%TYPE := FND_API.G_MISS_CHAR
133: ,p_fin_plan_version_id
134: IN pa_proj_fp_options.fin_plan_version_id%TYPE := FND_API.G_MISS_NUM
128: IN pa_proj_fp_options.all_time_phased_code%TYPE := FND_API.G_MISS_CHAR
129: ,p_all_resource_list_id
130: IN pa_proj_fp_options.all_resource_list_id%TYPE := FND_API.G_MISS_NUM
131: ,p_report_labor_hrs_from_code
132: IN pa_proj_fp_options.report_labor_hrs_from_code%TYPE := FND_API.G_MISS_CHAR
133: ,p_fin_plan_version_id
134: IN pa_proj_fp_options.fin_plan_version_id%TYPE := FND_API.G_MISS_NUM
135: /* added for financial planning */
136: ,p_plan_in_multi_curr_flag
130: IN pa_proj_fp_options.all_resource_list_id%TYPE := FND_API.G_MISS_NUM
131: ,p_report_labor_hrs_from_code
132: IN pa_proj_fp_options.report_labor_hrs_from_code%TYPE := FND_API.G_MISS_CHAR
133: ,p_fin_plan_version_id
134: IN pa_proj_fp_options.fin_plan_version_id%TYPE := FND_API.G_MISS_NUM
135: /* added for financial planning */
136: ,p_plan_in_multi_curr_flag
137: IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := FND_API.G_MISS_CHAR
138: ,p_factor_by_code
133: ,p_fin_plan_version_id
134: IN pa_proj_fp_options.fin_plan_version_id%TYPE := FND_API.G_MISS_NUM
135: /* added for financial planning */
136: ,p_plan_in_multi_curr_flag
137: IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := FND_API.G_MISS_CHAR
138: ,p_factor_by_code
139: IN pa_proj_fp_options.factor_by_code%TYPE := FND_API.G_MISS_CHAR
140: ,p_default_amount_type_code
141: IN pa_proj_fp_options.default_amount_type_code%TYPE := FND_API.G_MISS_CHAR
135: /* added for financial planning */
136: ,p_plan_in_multi_curr_flag
137: IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := FND_API.G_MISS_CHAR
138: ,p_factor_by_code
139: IN pa_proj_fp_options.factor_by_code%TYPE := FND_API.G_MISS_CHAR
140: ,p_default_amount_type_code
141: IN pa_proj_fp_options.default_amount_type_code%TYPE := FND_API.G_MISS_CHAR
142: ,p_default_amount_subtype_code
143: IN pa_proj_fp_options.default_amount_subtype_code%TYPE := FND_API.G_MISS_CHAR
137: IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := FND_API.G_MISS_CHAR
138: ,p_factor_by_code
139: IN pa_proj_fp_options.factor_by_code%TYPE := FND_API.G_MISS_CHAR
140: ,p_default_amount_type_code
141: IN pa_proj_fp_options.default_amount_type_code%TYPE := FND_API.G_MISS_CHAR
142: ,p_default_amount_subtype_code
143: IN pa_proj_fp_options.default_amount_subtype_code%TYPE := FND_API.G_MISS_CHAR
144: ,p_approved_cost_plan_type_flag
145: IN pa_proj_fp_options.approved_cost_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
139: IN pa_proj_fp_options.factor_by_code%TYPE := FND_API.G_MISS_CHAR
140: ,p_default_amount_type_code
141: IN pa_proj_fp_options.default_amount_type_code%TYPE := FND_API.G_MISS_CHAR
142: ,p_default_amount_subtype_code
143: IN pa_proj_fp_options.default_amount_subtype_code%TYPE := FND_API.G_MISS_CHAR
144: ,p_approved_cost_plan_type_flag
145: IN pa_proj_fp_options.approved_cost_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
146: ,p_approved_rev_plan_type_flag
147: IN pa_proj_fp_options.approved_rev_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
141: IN pa_proj_fp_options.default_amount_type_code%TYPE := FND_API.G_MISS_CHAR
142: ,p_default_amount_subtype_code
143: IN pa_proj_fp_options.default_amount_subtype_code%TYPE := FND_API.G_MISS_CHAR
144: ,p_approved_cost_plan_type_flag
145: IN pa_proj_fp_options.approved_cost_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
146: ,p_approved_rev_plan_type_flag
147: IN pa_proj_fp_options.approved_rev_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
148: ,p_projfunc_cost_rate_type
149: IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
143: IN pa_proj_fp_options.default_amount_subtype_code%TYPE := FND_API.G_MISS_CHAR
144: ,p_approved_cost_plan_type_flag
145: IN pa_proj_fp_options.approved_cost_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
146: ,p_approved_rev_plan_type_flag
147: IN pa_proj_fp_options.approved_rev_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
148: ,p_projfunc_cost_rate_type
149: IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
150: ,p_projfunc_cost_rate_date_type
151: IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
145: IN pa_proj_fp_options.approved_cost_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
146: ,p_approved_rev_plan_type_flag
147: IN pa_proj_fp_options.approved_rev_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
148: ,p_projfunc_cost_rate_type
149: IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
150: ,p_projfunc_cost_rate_date_type
151: IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
152: ,p_projfunc_cost_rate_date
153: IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := FND_API.G_MISS_DATE
147: IN pa_proj_fp_options.approved_rev_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
148: ,p_projfunc_cost_rate_type
149: IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
150: ,p_projfunc_cost_rate_date_type
151: IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
152: ,p_projfunc_cost_rate_date
153: IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := FND_API.G_MISS_DATE
154: ,p_projfunc_rev_rate_type
155: IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
149: IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
150: ,p_projfunc_cost_rate_date_type
151: IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
152: ,p_projfunc_cost_rate_date
153: IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := FND_API.G_MISS_DATE
154: ,p_projfunc_rev_rate_type
155: IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
156: ,p_projfunc_rev_rate_date_type
157: IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
151: IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
152: ,p_projfunc_cost_rate_date
153: IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := FND_API.G_MISS_DATE
154: ,p_projfunc_rev_rate_type
155: IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
156: ,p_projfunc_rev_rate_date_type
157: IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
158: ,p_projfunc_rev_rate_date
159: IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := FND_API.G_MISS_DATE
153: IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := FND_API.G_MISS_DATE
154: ,p_projfunc_rev_rate_type
155: IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
156: ,p_projfunc_rev_rate_date_type
157: IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
158: ,p_projfunc_rev_rate_date
159: IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := FND_API.G_MISS_DATE
160: ,p_project_cost_rate_type
161: IN pa_proj_fp_options.project_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
155: IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
156: ,p_projfunc_rev_rate_date_type
157: IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
158: ,p_projfunc_rev_rate_date
159: IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := FND_API.G_MISS_DATE
160: ,p_project_cost_rate_type
161: IN pa_proj_fp_options.project_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
162: ,p_project_cost_rate_date_type
163: IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
157: IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
158: ,p_projfunc_rev_rate_date
159: IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := FND_API.G_MISS_DATE
160: ,p_project_cost_rate_type
161: IN pa_proj_fp_options.project_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
162: ,p_project_cost_rate_date_type
163: IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
164: ,p_project_cost_rate_date
165: IN pa_proj_fp_options.project_cost_rate_date%TYPE := FND_API.G_MISS_DATE
159: IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := FND_API.G_MISS_DATE
160: ,p_project_cost_rate_type
161: IN pa_proj_fp_options.project_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
162: ,p_project_cost_rate_date_type
163: IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
164: ,p_project_cost_rate_date
165: IN pa_proj_fp_options.project_cost_rate_date%TYPE := FND_API.G_MISS_DATE
166: ,p_project_rev_rate_type
167: IN pa_proj_fp_options.project_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
161: IN pa_proj_fp_options.project_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
162: ,p_project_cost_rate_date_type
163: IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
164: ,p_project_cost_rate_date
165: IN pa_proj_fp_options.project_cost_rate_date%TYPE := FND_API.G_MISS_DATE
166: ,p_project_rev_rate_type
167: IN pa_proj_fp_options.project_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
168: ,p_project_rev_rate_date_type
169: IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
163: IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
164: ,p_project_cost_rate_date
165: IN pa_proj_fp_options.project_cost_rate_date%TYPE := FND_API.G_MISS_DATE
166: ,p_project_rev_rate_type
167: IN pa_proj_fp_options.project_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
168: ,p_project_rev_rate_date_type
169: IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
170: ,p_project_rev_rate_date
171: IN pa_proj_fp_options.project_rev_rate_date%TYPE := FND_API.G_MISS_DATE
165: IN pa_proj_fp_options.project_cost_rate_date%TYPE := FND_API.G_MISS_DATE
166: ,p_project_rev_rate_type
167: IN pa_proj_fp_options.project_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
168: ,p_project_rev_rate_date_type
169: IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
170: ,p_project_rev_rate_date
171: IN pa_proj_fp_options.project_rev_rate_date%TYPE := FND_API.G_MISS_DATE
172: ,p_margin_derived_from_code
173: IN pa_proj_fp_options.margin_derived_from_code%TYPE := FND_API.G_MISS_CHAR
167: IN pa_proj_fp_options.project_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
168: ,p_project_rev_rate_date_type
169: IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
170: ,p_project_rev_rate_date
171: IN pa_proj_fp_options.project_rev_rate_date%TYPE := FND_API.G_MISS_DATE
172: ,p_margin_derived_from_code
173: IN pa_proj_fp_options.margin_derived_from_code%TYPE := FND_API.G_MISS_CHAR
174: /* ended additions for fin plan */
175: /* Bug 2920954 start of additional parameters for post FP-k one off */
169: IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
170: ,p_project_rev_rate_date
171: IN pa_proj_fp_options.project_rev_rate_date%TYPE := FND_API.G_MISS_DATE
172: ,p_margin_derived_from_code
173: IN pa_proj_fp_options.margin_derived_from_code%TYPE := FND_API.G_MISS_CHAR
174: /* ended additions for fin plan */
175: /* Bug 2920954 start of additional parameters for post FP-k one off */
176: ,p_select_cost_res_auto_flag
177: IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
173: IN pa_proj_fp_options.margin_derived_from_code%TYPE := FND_API.G_MISS_CHAR
174: /* ended additions for fin plan */
175: /* Bug 2920954 start of additional parameters for post FP-k one off */
176: ,p_select_cost_res_auto_flag
177: IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
178: ,p_cost_res_planning_level
179: IN pa_proj_fp_options.cost_res_planning_level%TYPE := FND_API.G_MISS_CHAR
180: ,p_select_rev_res_auto_flag
181: IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
175: /* Bug 2920954 start of additional parameters for post FP-k one off */
176: ,p_select_cost_res_auto_flag
177: IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
178: ,p_cost_res_planning_level
179: IN pa_proj_fp_options.cost_res_planning_level%TYPE := FND_API.G_MISS_CHAR
180: ,p_select_rev_res_auto_flag
181: IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
182: ,p_revenue_res_planning_level
183: IN pa_proj_fp_options.revenue_res_planning_level%TYPE := FND_API.G_MISS_CHAR
177: IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
178: ,p_cost_res_planning_level
179: IN pa_proj_fp_options.cost_res_planning_level%TYPE := FND_API.G_MISS_CHAR
180: ,p_select_rev_res_auto_flag
181: IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
182: ,p_revenue_res_planning_level
183: IN pa_proj_fp_options.revenue_res_planning_level%TYPE := FND_API.G_MISS_CHAR
184: ,p_select_all_res_auto_flag
185: IN pa_proj_fp_options.select_all_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
179: IN pa_proj_fp_options.cost_res_planning_level%TYPE := FND_API.G_MISS_CHAR
180: ,p_select_rev_res_auto_flag
181: IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
182: ,p_revenue_res_planning_level
183: IN pa_proj_fp_options.revenue_res_planning_level%TYPE := FND_API.G_MISS_CHAR
184: ,p_select_all_res_auto_flag
185: IN pa_proj_fp_options.select_all_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
186: ,p_all_res_planning_level
187: IN pa_proj_fp_options.all_res_planning_level%TYPE := FND_API.G_MISS_CHAR
181: IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
182: ,p_revenue_res_planning_level
183: IN pa_proj_fp_options.revenue_res_planning_level%TYPE := FND_API.G_MISS_CHAR
184: ,p_select_all_res_auto_flag
185: IN pa_proj_fp_options.select_all_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
186: ,p_all_res_planning_level
187: IN pa_proj_fp_options.all_res_planning_level%TYPE := FND_API.G_MISS_CHAR
188: ,p_refresh_required_flag
189: IN pa_budget_versions.PROCESS_UPDATE_WBS_FLAG%TYPE := FND_API.G_MISS_CHAR
183: IN pa_proj_fp_options.revenue_res_planning_level%TYPE := FND_API.G_MISS_CHAR
184: ,p_select_all_res_auto_flag
185: IN pa_proj_fp_options.select_all_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
186: ,p_all_res_planning_level
187: IN pa_proj_fp_options.all_res_planning_level%TYPE := FND_API.G_MISS_CHAR
188: ,p_refresh_required_flag
189: IN pa_budget_versions.PROCESS_UPDATE_WBS_FLAG%TYPE := FND_API.G_MISS_CHAR
190: ,p_request_id
191: IN pa_budget_versions.REQUEST_ID%TYPE := FND_API.G_MISS_NUM
192: ,p_processing_code
193: IN pa_budget_versions.PLAN_PROCESSING_CODE%TYPE := FND_API.G_MISS_CHAR
194: /* Bug 2920954 end of additional parameters for post FP-k one off */
195: ,p_primary_cost_forecast_flag
196: IN PA_PROJ_FP_OPTIONS.primary_cost_forecast_flag%TYPE := FND_API.G_MISS_CHAR
197: ,p_primary_rev_forecast_flag
198: IN PA_PROJ_FP_OPTIONS.primary_rev_forecast_flag%TYPE := FND_API.G_MISS_CHAR
199: ,p_use_planning_rates_flag
200: IN PA_PROJ_FP_OPTIONS.use_planning_rates_flag%TYPE := FND_API.G_MISS_CHAR
194: /* Bug 2920954 end of additional parameters for post FP-k one off */
195: ,p_primary_cost_forecast_flag
196: IN PA_PROJ_FP_OPTIONS.primary_cost_forecast_flag%TYPE := FND_API.G_MISS_CHAR
197: ,p_primary_rev_forecast_flag
198: IN PA_PROJ_FP_OPTIONS.primary_rev_forecast_flag%TYPE := FND_API.G_MISS_CHAR
199: ,p_use_planning_rates_flag
200: IN PA_PROJ_FP_OPTIONS.use_planning_rates_flag%TYPE := FND_API.G_MISS_CHAR
201: ,p_rbs_version_id
202: IN PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE := FND_API.G_MISS_NUM
196: IN PA_PROJ_FP_OPTIONS.primary_cost_forecast_flag%TYPE := FND_API.G_MISS_CHAR
197: ,p_primary_rev_forecast_flag
198: IN PA_PROJ_FP_OPTIONS.primary_rev_forecast_flag%TYPE := FND_API.G_MISS_CHAR
199: ,p_use_planning_rates_flag
200: IN PA_PROJ_FP_OPTIONS.use_planning_rates_flag%TYPE := FND_API.G_MISS_CHAR
201: ,p_rbs_version_id
202: IN PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE := FND_API.G_MISS_NUM
203: ,p_res_class_raw_cost_sch_id
204: IN PA_PROJ_FP_OPTIONS.res_class_raw_cost_sch_id%TYPE := FND_API.G_MISS_NUM
198: IN PA_PROJ_FP_OPTIONS.primary_rev_forecast_flag%TYPE := FND_API.G_MISS_CHAR
199: ,p_use_planning_rates_flag
200: IN PA_PROJ_FP_OPTIONS.use_planning_rates_flag%TYPE := FND_API.G_MISS_CHAR
201: ,p_rbs_version_id
202: IN PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE := FND_API.G_MISS_NUM
203: ,p_res_class_raw_cost_sch_id
204: IN PA_PROJ_FP_OPTIONS.res_class_raw_cost_sch_id%TYPE := FND_API.G_MISS_NUM
205: ,p_res_class_bill_rate_sch_id
206: IN PA_PROJ_FP_OPTIONS.res_class_bill_rate_sch_id%TYPE := FND_API.G_MISS_NUM
200: IN PA_PROJ_FP_OPTIONS.use_planning_rates_flag%TYPE := FND_API.G_MISS_CHAR
201: ,p_rbs_version_id
202: IN PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE := FND_API.G_MISS_NUM
203: ,p_res_class_raw_cost_sch_id
204: IN PA_PROJ_FP_OPTIONS.res_class_raw_cost_sch_id%TYPE := FND_API.G_MISS_NUM
205: ,p_res_class_bill_rate_sch_id
206: IN PA_PROJ_FP_OPTIONS.res_class_bill_rate_sch_id%TYPE := FND_API.G_MISS_NUM
207: ,p_cost_emp_rate_sch_id
208: IN PA_PROJ_FP_OPTIONS.cost_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
202: IN PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE := FND_API.G_MISS_NUM
203: ,p_res_class_raw_cost_sch_id
204: IN PA_PROJ_FP_OPTIONS.res_class_raw_cost_sch_id%TYPE := FND_API.G_MISS_NUM
205: ,p_res_class_bill_rate_sch_id
206: IN PA_PROJ_FP_OPTIONS.res_class_bill_rate_sch_id%TYPE := FND_API.G_MISS_NUM
207: ,p_cost_emp_rate_sch_id
208: IN PA_PROJ_FP_OPTIONS.cost_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
209: ,p_cost_job_rate_sch_id
210: IN PA_PROJ_FP_OPTIONS.cost_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
204: IN PA_PROJ_FP_OPTIONS.res_class_raw_cost_sch_id%TYPE := FND_API.G_MISS_NUM
205: ,p_res_class_bill_rate_sch_id
206: IN PA_PROJ_FP_OPTIONS.res_class_bill_rate_sch_id%TYPE := FND_API.G_MISS_NUM
207: ,p_cost_emp_rate_sch_id
208: IN PA_PROJ_FP_OPTIONS.cost_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
209: ,p_cost_job_rate_sch_id
210: IN PA_PROJ_FP_OPTIONS.cost_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
211: ,p_cst_non_labr_res_rate_sch_id
212: IN PA_PROJ_FP_OPTIONS.cost_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
206: IN PA_PROJ_FP_OPTIONS.res_class_bill_rate_sch_id%TYPE := FND_API.G_MISS_NUM
207: ,p_cost_emp_rate_sch_id
208: IN PA_PROJ_FP_OPTIONS.cost_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
209: ,p_cost_job_rate_sch_id
210: IN PA_PROJ_FP_OPTIONS.cost_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
211: ,p_cst_non_labr_res_rate_sch_id
212: IN PA_PROJ_FP_OPTIONS.cost_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
213: ,p_cost_res_class_rate_sch_id
214: IN PA_PROJ_FP_OPTIONS.cost_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
208: IN PA_PROJ_FP_OPTIONS.cost_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
209: ,p_cost_job_rate_sch_id
210: IN PA_PROJ_FP_OPTIONS.cost_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
211: ,p_cst_non_labr_res_rate_sch_id
212: IN PA_PROJ_FP_OPTIONS.cost_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
213: ,p_cost_res_class_rate_sch_id
214: IN PA_PROJ_FP_OPTIONS.cost_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
215: ,p_cost_burden_rate_sch_id
216: IN PA_PROJ_FP_OPTIONS.cost_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
210: IN PA_PROJ_FP_OPTIONS.cost_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
211: ,p_cst_non_labr_res_rate_sch_id
212: IN PA_PROJ_FP_OPTIONS.cost_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
213: ,p_cost_res_class_rate_sch_id
214: IN PA_PROJ_FP_OPTIONS.cost_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
215: ,p_cost_burden_rate_sch_id
216: IN PA_PROJ_FP_OPTIONS.cost_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
217: ,p_cost_current_planning_period
218: IN PA_PROJ_FP_OPTIONS.cost_current_planning_period%TYPE := FND_API.G_MISS_CHAR
212: IN PA_PROJ_FP_OPTIONS.cost_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
213: ,p_cost_res_class_rate_sch_id
214: IN PA_PROJ_FP_OPTIONS.cost_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
215: ,p_cost_burden_rate_sch_id
216: IN PA_PROJ_FP_OPTIONS.cost_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
217: ,p_cost_current_planning_period
218: IN PA_PROJ_FP_OPTIONS.cost_current_planning_period%TYPE := FND_API.G_MISS_CHAR
219: ,p_cost_period_mask_id
220: IN PA_PROJ_FP_OPTIONS.cost_period_mask_id%TYPE := FND_API.G_MISS_NUM
214: IN PA_PROJ_FP_OPTIONS.cost_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
215: ,p_cost_burden_rate_sch_id
216: IN PA_PROJ_FP_OPTIONS.cost_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
217: ,p_cost_current_planning_period
218: IN PA_PROJ_FP_OPTIONS.cost_current_planning_period%TYPE := FND_API.G_MISS_CHAR
219: ,p_cost_period_mask_id
220: IN PA_PROJ_FP_OPTIONS.cost_period_mask_id%TYPE := FND_API.G_MISS_NUM
221: ,p_rev_emp_rate_sch_id
222: IN PA_PROJ_FP_OPTIONS.rev_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
216: IN PA_PROJ_FP_OPTIONS.cost_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
217: ,p_cost_current_planning_period
218: IN PA_PROJ_FP_OPTIONS.cost_current_planning_period%TYPE := FND_API.G_MISS_CHAR
219: ,p_cost_period_mask_id
220: IN PA_PROJ_FP_OPTIONS.cost_period_mask_id%TYPE := FND_API.G_MISS_NUM
221: ,p_rev_emp_rate_sch_id
222: IN PA_PROJ_FP_OPTIONS.rev_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
223: ,p_rev_job_rate_sch_id
224: IN PA_PROJ_FP_OPTIONS.rev_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
218: IN PA_PROJ_FP_OPTIONS.cost_current_planning_period%TYPE := FND_API.G_MISS_CHAR
219: ,p_cost_period_mask_id
220: IN PA_PROJ_FP_OPTIONS.cost_period_mask_id%TYPE := FND_API.G_MISS_NUM
221: ,p_rev_emp_rate_sch_id
222: IN PA_PROJ_FP_OPTIONS.rev_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
223: ,p_rev_job_rate_sch_id
224: IN PA_PROJ_FP_OPTIONS.rev_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
225: ,p_rev_non_labr_res_rate_sch_id
226: IN PA_PROJ_FP_OPTIONS.rev_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
220: IN PA_PROJ_FP_OPTIONS.cost_period_mask_id%TYPE := FND_API.G_MISS_NUM
221: ,p_rev_emp_rate_sch_id
222: IN PA_PROJ_FP_OPTIONS.rev_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
223: ,p_rev_job_rate_sch_id
224: IN PA_PROJ_FP_OPTIONS.rev_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
225: ,p_rev_non_labr_res_rate_sch_id
226: IN PA_PROJ_FP_OPTIONS.rev_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
227: ,p_rev_res_class_rate_sch_id
228: IN PA_PROJ_FP_OPTIONS.rev_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
222: IN PA_PROJ_FP_OPTIONS.rev_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
223: ,p_rev_job_rate_sch_id
224: IN PA_PROJ_FP_OPTIONS.rev_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
225: ,p_rev_non_labr_res_rate_sch_id
226: IN PA_PROJ_FP_OPTIONS.rev_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
227: ,p_rev_res_class_rate_sch_id
228: IN PA_PROJ_FP_OPTIONS.rev_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
229: ,p_rev_current_planning_period
230: IN PA_PROJ_FP_OPTIONS.rev_current_planning_period%TYPE := FND_API.G_MISS_CHAR
224: IN PA_PROJ_FP_OPTIONS.rev_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
225: ,p_rev_non_labr_res_rate_sch_id
226: IN PA_PROJ_FP_OPTIONS.rev_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
227: ,p_rev_res_class_rate_sch_id
228: IN PA_PROJ_FP_OPTIONS.rev_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
229: ,p_rev_current_planning_period
230: IN PA_PROJ_FP_OPTIONS.rev_current_planning_period%TYPE := FND_API.G_MISS_CHAR
231: ,p_rev_period_mask_id
232: IN PA_PROJ_FP_OPTIONS.rev_period_mask_id%TYPE := FND_API.G_MISS_NUM
226: IN PA_PROJ_FP_OPTIONS.rev_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
227: ,p_rev_res_class_rate_sch_id
228: IN PA_PROJ_FP_OPTIONS.rev_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
229: ,p_rev_current_planning_period
230: IN PA_PROJ_FP_OPTIONS.rev_current_planning_period%TYPE := FND_API.G_MISS_CHAR
231: ,p_rev_period_mask_id
232: IN PA_PROJ_FP_OPTIONS.rev_period_mask_id%TYPE := FND_API.G_MISS_NUM
233: /** Bug 3580727 Columns have been dropped
234: ,p_all_emp_rate_sch_id
228: IN PA_PROJ_FP_OPTIONS.rev_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
229: ,p_rev_current_planning_period
230: IN PA_PROJ_FP_OPTIONS.rev_current_planning_period%TYPE := FND_API.G_MISS_CHAR
231: ,p_rev_period_mask_id
232: IN PA_PROJ_FP_OPTIONS.rev_period_mask_id%TYPE := FND_API.G_MISS_NUM
233: /** Bug 3580727 Columns have been dropped
234: ,p_all_emp_rate_sch_id
235: IN PA_PROJ_FP_OPTIONS.all_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
236: ,p_all_job_rate_sch_id
231: ,p_rev_period_mask_id
232: IN PA_PROJ_FP_OPTIONS.rev_period_mask_id%TYPE := FND_API.G_MISS_NUM
233: /** Bug 3580727 Columns have been dropped
234: ,p_all_emp_rate_sch_id
235: IN PA_PROJ_FP_OPTIONS.all_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
236: ,p_all_job_rate_sch_id
237: IN PA_PROJ_FP_OPTIONS.all_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
238: ,p_all_non_labr_res_rate_sch_id
239: IN PA_PROJ_FP_OPTIONS.all_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
233: /** Bug 3580727 Columns have been dropped
234: ,p_all_emp_rate_sch_id
235: IN PA_PROJ_FP_OPTIONS.all_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
236: ,p_all_job_rate_sch_id
237: IN PA_PROJ_FP_OPTIONS.all_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
238: ,p_all_non_labr_res_rate_sch_id
239: IN PA_PROJ_FP_OPTIONS.all_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
240: ,p_all_res_class_rate_sch_id
241: IN PA_PROJ_FP_OPTIONS.all_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
235: IN PA_PROJ_FP_OPTIONS.all_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
236: ,p_all_job_rate_sch_id
237: IN PA_PROJ_FP_OPTIONS.all_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
238: ,p_all_non_labr_res_rate_sch_id
239: IN PA_PROJ_FP_OPTIONS.all_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
240: ,p_all_res_class_rate_sch_id
241: IN PA_PROJ_FP_OPTIONS.all_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
242: ,p_all_burden_rate_sch_id
243: IN PA_PROJ_FP_OPTIONS.all_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
237: IN PA_PROJ_FP_OPTIONS.all_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
238: ,p_all_non_labr_res_rate_sch_id
239: IN PA_PROJ_FP_OPTIONS.all_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
240: ,p_all_res_class_rate_sch_id
241: IN PA_PROJ_FP_OPTIONS.all_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
242: ,p_all_burden_rate_sch_id
243: IN PA_PROJ_FP_OPTIONS.all_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
244: **/
245: ,p_all_current_planning_period
239: IN PA_PROJ_FP_OPTIONS.all_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
240: ,p_all_res_class_rate_sch_id
241: IN PA_PROJ_FP_OPTIONS.all_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
242: ,p_all_burden_rate_sch_id
243: IN PA_PROJ_FP_OPTIONS.all_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
244: **/
245: ,p_all_current_planning_period
246: IN PA_PROJ_FP_OPTIONS.all_current_planning_period%TYPE := FND_API.G_MISS_CHAR
247: ,p_all_period_mask_id
242: ,p_all_burden_rate_sch_id
243: IN PA_PROJ_FP_OPTIONS.all_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
244: **/
245: ,p_all_current_planning_period
246: IN PA_PROJ_FP_OPTIONS.all_current_planning_period%TYPE := FND_API.G_MISS_CHAR
247: ,p_all_period_mask_id
248: IN PA_PROJ_FP_OPTIONS.all_period_mask_id%TYPE := FND_API.G_MISS_NUM
249: ,p_gen_cost_src_code
250: IN PA_PROJ_FP_OPTIONS.gen_cost_src_code%TYPE := FND_API.G_MISS_CHAR
244: **/
245: ,p_all_current_planning_period
246: IN PA_PROJ_FP_OPTIONS.all_current_planning_period%TYPE := FND_API.G_MISS_CHAR
247: ,p_all_period_mask_id
248: IN PA_PROJ_FP_OPTIONS.all_period_mask_id%TYPE := FND_API.G_MISS_NUM
249: ,p_gen_cost_src_code
250: IN PA_PROJ_FP_OPTIONS.gen_cost_src_code%TYPE := FND_API.G_MISS_CHAR
251: ,p_gen_cost_etc_src_code
252: IN PA_PROJ_FP_OPTIONS.gen_cost_etc_src_code%TYPE := FND_API.G_MISS_CHAR
246: IN PA_PROJ_FP_OPTIONS.all_current_planning_period%TYPE := FND_API.G_MISS_CHAR
247: ,p_all_period_mask_id
248: IN PA_PROJ_FP_OPTIONS.all_period_mask_id%TYPE := FND_API.G_MISS_NUM
249: ,p_gen_cost_src_code
250: IN PA_PROJ_FP_OPTIONS.gen_cost_src_code%TYPE := FND_API.G_MISS_CHAR
251: ,p_gen_cost_etc_src_code
252: IN PA_PROJ_FP_OPTIONS.gen_cost_etc_src_code%TYPE := FND_API.G_MISS_CHAR
253: ,p_gn_cost_incl_change_doc_flag
254: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
248: IN PA_PROJ_FP_OPTIONS.all_period_mask_id%TYPE := FND_API.G_MISS_NUM
249: ,p_gen_cost_src_code
250: IN PA_PROJ_FP_OPTIONS.gen_cost_src_code%TYPE := FND_API.G_MISS_CHAR
251: ,p_gen_cost_etc_src_code
252: IN PA_PROJ_FP_OPTIONS.gen_cost_etc_src_code%TYPE := FND_API.G_MISS_CHAR
253: ,p_gn_cost_incl_change_doc_flag
254: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
255: ,p_gen_cost_incl_open_comm_flag
256: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
250: IN PA_PROJ_FP_OPTIONS.gen_cost_src_code%TYPE := FND_API.G_MISS_CHAR
251: ,p_gen_cost_etc_src_code
252: IN PA_PROJ_FP_OPTIONS.gen_cost_etc_src_code%TYPE := FND_API.G_MISS_CHAR
253: ,p_gn_cost_incl_change_doc_flag
254: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
255: ,p_gen_cost_incl_open_comm_flag
256: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
257: ,p_gn_cost_ret_manual_line_flag
258: IN PA_PROJ_FP_OPTIONS.gen_cost_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
252: IN PA_PROJ_FP_OPTIONS.gen_cost_etc_src_code%TYPE := FND_API.G_MISS_CHAR
253: ,p_gn_cost_incl_change_doc_flag
254: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
255: ,p_gen_cost_incl_open_comm_flag
256: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
257: ,p_gn_cost_ret_manual_line_flag
258: IN PA_PROJ_FP_OPTIONS.gen_cost_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
259: ,p_gn_cst_incl_unspent_amt_flag
260: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
254: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
255: ,p_gen_cost_incl_open_comm_flag
256: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
257: ,p_gn_cost_ret_manual_line_flag
258: IN PA_PROJ_FP_OPTIONS.gen_cost_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
259: ,p_gn_cst_incl_unspent_amt_flag
260: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
261: ,p_gen_rev_src_code
262: IN PA_PROJ_FP_OPTIONS.gen_rev_src_code%TYPE := FND_API.G_MISS_CHAR
256: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
257: ,p_gn_cost_ret_manual_line_flag
258: IN PA_PROJ_FP_OPTIONS.gen_cost_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
259: ,p_gn_cst_incl_unspent_amt_flag
260: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
261: ,p_gen_rev_src_code
262: IN PA_PROJ_FP_OPTIONS.gen_rev_src_code%TYPE := FND_API.G_MISS_CHAR
263: ,p_gen_rev_etc_src_code
264: IN PA_PROJ_FP_OPTIONS.gen_rev_etc_src_code%TYPE := FND_API.G_MISS_CHAR
258: IN PA_PROJ_FP_OPTIONS.gen_cost_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
259: ,p_gn_cst_incl_unspent_amt_flag
260: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
261: ,p_gen_rev_src_code
262: IN PA_PROJ_FP_OPTIONS.gen_rev_src_code%TYPE := FND_API.G_MISS_CHAR
263: ,p_gen_rev_etc_src_code
264: IN PA_PROJ_FP_OPTIONS.gen_rev_etc_src_code%TYPE := FND_API.G_MISS_CHAR
265: ,p_gen_rev_incl_change_doc_flag
266: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
260: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
261: ,p_gen_rev_src_code
262: IN PA_PROJ_FP_OPTIONS.gen_rev_src_code%TYPE := FND_API.G_MISS_CHAR
263: ,p_gen_rev_etc_src_code
264: IN PA_PROJ_FP_OPTIONS.gen_rev_etc_src_code%TYPE := FND_API.G_MISS_CHAR
265: ,p_gen_rev_incl_change_doc_flag
266: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
267: ,p_gen_rev_incl_bill_event_flag
268: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
262: IN PA_PROJ_FP_OPTIONS.gen_rev_src_code%TYPE := FND_API.G_MISS_CHAR
263: ,p_gen_rev_etc_src_code
264: IN PA_PROJ_FP_OPTIONS.gen_rev_etc_src_code%TYPE := FND_API.G_MISS_CHAR
265: ,p_gen_rev_incl_change_doc_flag
266: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
267: ,p_gen_rev_incl_bill_event_flag
268: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
269: ,p_gen_rev_ret_manual_line_flag
270: IN PA_PROJ_FP_OPTIONS.gen_rev_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
264: IN PA_PROJ_FP_OPTIONS.gen_rev_etc_src_code%TYPE := FND_API.G_MISS_CHAR
265: ,p_gen_rev_incl_change_doc_flag
266: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
267: ,p_gen_rev_incl_bill_event_flag
268: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
269: ,p_gen_rev_ret_manual_line_flag
270: IN PA_PROJ_FP_OPTIONS.gen_rev_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
271: /** Bug 3580727
272: ,p_gn_rev_incl_unspent_amt_flag
266: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
267: ,p_gen_rev_incl_bill_event_flag
268: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
269: ,p_gen_rev_ret_manual_line_flag
270: IN PA_PROJ_FP_OPTIONS.gen_rev_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
271: /** Bug 3580727
272: ,p_gn_rev_incl_unspent_amt_flag
273: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
274: **/
269: ,p_gen_rev_ret_manual_line_flag
270: IN PA_PROJ_FP_OPTIONS.gen_rev_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
271: /** Bug 3580727
272: ,p_gn_rev_incl_unspent_amt_flag
273: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
274: **/
275: ,p_gen_src_cost_plan_type_id
276: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_type_id%TYPE := FND_API.G_MISS_NUM
277: ,p_gen_src_cost_plan_version_id
272: ,p_gn_rev_incl_unspent_amt_flag
273: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
274: **/
275: ,p_gen_src_cost_plan_type_id
276: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_type_id%TYPE := FND_API.G_MISS_NUM
277: ,p_gen_src_cost_plan_version_id
278: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_version_id%TYPE := FND_API.G_MISS_NUM
279: ,p_gen_src_cost_plan_ver_code
280: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
274: **/
275: ,p_gen_src_cost_plan_type_id
276: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_type_id%TYPE := FND_API.G_MISS_NUM
277: ,p_gen_src_cost_plan_version_id
278: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_version_id%TYPE := FND_API.G_MISS_NUM
279: ,p_gen_src_cost_plan_ver_code
280: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
281: ,p_gen_src_rev_plan_type_id
282: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_type_id%TYPE := FND_API.G_MISS_NUM
276: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_type_id%TYPE := FND_API.G_MISS_NUM
277: ,p_gen_src_cost_plan_version_id
278: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_version_id%TYPE := FND_API.G_MISS_NUM
279: ,p_gen_src_cost_plan_ver_code
280: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
281: ,p_gen_src_rev_plan_type_id
282: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_type_id%TYPE := FND_API.G_MISS_NUM
283: ,p_gen_src_rev_plan_version_id
284: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_version_id%TYPE := FND_API.G_MISS_NUM
278: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_version_id%TYPE := FND_API.G_MISS_NUM
279: ,p_gen_src_cost_plan_ver_code
280: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
281: ,p_gen_src_rev_plan_type_id
282: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_type_id%TYPE := FND_API.G_MISS_NUM
283: ,p_gen_src_rev_plan_version_id
284: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_version_id%TYPE := FND_API.G_MISS_NUM
285: ,p_gen_src_rev_plan_ver_code
286: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
280: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
281: ,p_gen_src_rev_plan_type_id
282: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_type_id%TYPE := FND_API.G_MISS_NUM
283: ,p_gen_src_rev_plan_version_id
284: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_version_id%TYPE := FND_API.G_MISS_NUM
285: ,p_gen_src_rev_plan_ver_code
286: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
287: ,p_gen_src_all_plan_type_id
288: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_type_id%TYPE := FND_API.G_MISS_NUM
282: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_type_id%TYPE := FND_API.G_MISS_NUM
283: ,p_gen_src_rev_plan_version_id
284: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_version_id%TYPE := FND_API.G_MISS_NUM
285: ,p_gen_src_rev_plan_ver_code
286: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
287: ,p_gen_src_all_plan_type_id
288: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_type_id%TYPE := FND_API.G_MISS_NUM
289: ,p_gen_src_all_plan_version_id
290: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_version_id%TYPE := FND_API.G_MISS_NUM
284: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_version_id%TYPE := FND_API.G_MISS_NUM
285: ,p_gen_src_rev_plan_ver_code
286: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
287: ,p_gen_src_all_plan_type_id
288: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_type_id%TYPE := FND_API.G_MISS_NUM
289: ,p_gen_src_all_plan_version_id
290: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_version_id%TYPE := FND_API.G_MISS_NUM
291: ,p_gen_src_all_plan_ver_code
292: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
286: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
287: ,p_gen_src_all_plan_type_id
288: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_type_id%TYPE := FND_API.G_MISS_NUM
289: ,p_gen_src_all_plan_version_id
290: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_version_id%TYPE := FND_API.G_MISS_NUM
291: ,p_gen_src_all_plan_ver_code
292: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
293: ,p_gen_all_src_code
294: IN PA_PROJ_FP_OPTIONS.gen_all_src_code%TYPE := FND_API.G_MISS_CHAR
288: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_type_id%TYPE := FND_API.G_MISS_NUM
289: ,p_gen_src_all_plan_version_id
290: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_version_id%TYPE := FND_API.G_MISS_NUM
291: ,p_gen_src_all_plan_ver_code
292: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
293: ,p_gen_all_src_code
294: IN PA_PROJ_FP_OPTIONS.gen_all_src_code%TYPE := FND_API.G_MISS_CHAR
295: ,p_gen_all_etc_src_code
296: IN PA_PROJ_FP_OPTIONS.gen_all_etc_src_code%TYPE := FND_API.G_MISS_CHAR
290: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_version_id%TYPE := FND_API.G_MISS_NUM
291: ,p_gen_src_all_plan_ver_code
292: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
293: ,p_gen_all_src_code
294: IN PA_PROJ_FP_OPTIONS.gen_all_src_code%TYPE := FND_API.G_MISS_CHAR
295: ,p_gen_all_etc_src_code
296: IN PA_PROJ_FP_OPTIONS.gen_all_etc_src_code%TYPE := FND_API.G_MISS_CHAR
297: ,p_gen_all_incl_change_doc_flag
298: IN PA_PROJ_FP_OPTIONS.gen_all_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
292: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
293: ,p_gen_all_src_code
294: IN PA_PROJ_FP_OPTIONS.gen_all_src_code%TYPE := FND_API.G_MISS_CHAR
295: ,p_gen_all_etc_src_code
296: IN PA_PROJ_FP_OPTIONS.gen_all_etc_src_code%TYPE := FND_API.G_MISS_CHAR
297: ,p_gen_all_incl_change_doc_flag
298: IN PA_PROJ_FP_OPTIONS.gen_all_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
299: ,p_gen_all_incl_open_comm_flag
300: IN PA_PROJ_FP_OPTIONS.gen_all_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
294: IN PA_PROJ_FP_OPTIONS.gen_all_src_code%TYPE := FND_API.G_MISS_CHAR
295: ,p_gen_all_etc_src_code
296: IN PA_PROJ_FP_OPTIONS.gen_all_etc_src_code%TYPE := FND_API.G_MISS_CHAR
297: ,p_gen_all_incl_change_doc_flag
298: IN PA_PROJ_FP_OPTIONS.gen_all_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
299: ,p_gen_all_incl_open_comm_flag
300: IN PA_PROJ_FP_OPTIONS.gen_all_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
301: ,p_gen_all_ret_manual_line_flag
302: IN PA_PROJ_FP_OPTIONS.gen_all_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
296: IN PA_PROJ_FP_OPTIONS.gen_all_etc_src_code%TYPE := FND_API.G_MISS_CHAR
297: ,p_gen_all_incl_change_doc_flag
298: IN PA_PROJ_FP_OPTIONS.gen_all_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
299: ,p_gen_all_incl_open_comm_flag
300: IN PA_PROJ_FP_OPTIONS.gen_all_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
301: ,p_gen_all_ret_manual_line_flag
302: IN PA_PROJ_FP_OPTIONS.gen_all_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
303: ,p_gen_all_incl_bill_event_flag
304: IN PA_PROJ_FP_OPTIONS.gen_all_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
298: IN PA_PROJ_FP_OPTIONS.gen_all_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
299: ,p_gen_all_incl_open_comm_flag
300: IN PA_PROJ_FP_OPTIONS.gen_all_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
301: ,p_gen_all_ret_manual_line_flag
302: IN PA_PROJ_FP_OPTIONS.gen_all_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
303: ,p_gen_all_incl_bill_event_flag
304: IN PA_PROJ_FP_OPTIONS.gen_all_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
305: ,p_gn_all_incl_unspent_amt_flag
306: IN PA_PROJ_FP_OPTIONS.gen_all_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
300: IN PA_PROJ_FP_OPTIONS.gen_all_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
301: ,p_gen_all_ret_manual_line_flag
302: IN PA_PROJ_FP_OPTIONS.gen_all_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
303: ,p_gen_all_incl_bill_event_flag
304: IN PA_PROJ_FP_OPTIONS.gen_all_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
305: ,p_gn_all_incl_unspent_amt_flag
306: IN PA_PROJ_FP_OPTIONS.gen_all_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
307: ,p_gn_cst_actual_amts_thru_code
308: IN PA_PROJ_FP_OPTIONS.gen_cost_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
302: IN PA_PROJ_FP_OPTIONS.gen_all_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
303: ,p_gen_all_incl_bill_event_flag
304: IN PA_PROJ_FP_OPTIONS.gen_all_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
305: ,p_gn_all_incl_unspent_amt_flag
306: IN PA_PROJ_FP_OPTIONS.gen_all_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
307: ,p_gn_cst_actual_amts_thru_code
308: IN PA_PROJ_FP_OPTIONS.gen_cost_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
309: ,p_gn_rev_actual_amts_thru_code
310: IN PA_PROJ_FP_OPTIONS.gen_rev_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
304: IN PA_PROJ_FP_OPTIONS.gen_all_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
305: ,p_gn_all_incl_unspent_amt_flag
306: IN PA_PROJ_FP_OPTIONS.gen_all_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
307: ,p_gn_cst_actual_amts_thru_code
308: IN PA_PROJ_FP_OPTIONS.gen_cost_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
309: ,p_gn_rev_actual_amts_thru_code
310: IN PA_PROJ_FP_OPTIONS.gen_rev_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_gn_all_actual_amts_thru_code
312: IN PA_PROJ_FP_OPTIONS.gen_all_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
306: IN PA_PROJ_FP_OPTIONS.gen_all_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
307: ,p_gn_cst_actual_amts_thru_code
308: IN PA_PROJ_FP_OPTIONS.gen_cost_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
309: ,p_gn_rev_actual_amts_thru_code
310: IN PA_PROJ_FP_OPTIONS.gen_rev_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_gn_all_actual_amts_thru_code
312: IN PA_PROJ_FP_OPTIONS.gen_all_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_track_workplan_costs_flag
314: IN PA_PROJ_FP_OPTIONS.track_workplan_costs_flag%TYPE := FND_API.G_MISS_CHAR
308: IN PA_PROJ_FP_OPTIONS.gen_cost_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
309: ,p_gn_rev_actual_amts_thru_code
310: IN PA_PROJ_FP_OPTIONS.gen_rev_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_gn_all_actual_amts_thru_code
312: IN PA_PROJ_FP_OPTIONS.gen_all_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_track_workplan_costs_flag
314: IN PA_PROJ_FP_OPTIONS.track_workplan_costs_flag%TYPE := FND_API.G_MISS_CHAR
315: -- bug 3519062 start of workplan gen source related columns
316: ,p_gen_src_cost_wp_version_id
310: IN PA_PROJ_FP_OPTIONS.gen_rev_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_gn_all_actual_amts_thru_code
312: IN PA_PROJ_FP_OPTIONS.gen_all_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_track_workplan_costs_flag
314: IN PA_PROJ_FP_OPTIONS.track_workplan_costs_flag%TYPE := FND_API.G_MISS_CHAR
315: -- bug 3519062 start of workplan gen source related columns
316: ,p_gen_src_cost_wp_version_id
317: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_version_id%TYPE := FND_API.G_MISS_NUM
318: ,p_gen_src_cost_wp_ver_code
313: ,p_track_workplan_costs_flag
314: IN PA_PROJ_FP_OPTIONS.track_workplan_costs_flag%TYPE := FND_API.G_MISS_CHAR
315: -- bug 3519062 start of workplan gen source related columns
316: ,p_gen_src_cost_wp_version_id
317: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_version_id%TYPE := FND_API.G_MISS_NUM
318: ,p_gen_src_cost_wp_ver_code
319: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
320: ,p_gen_src_rev_wp_version_id
321: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_version_id%TYPE := FND_API.G_MISS_NUM
315: -- bug 3519062 start of workplan gen source related columns
316: ,p_gen_src_cost_wp_version_id
317: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_version_id%TYPE := FND_API.G_MISS_NUM
318: ,p_gen_src_cost_wp_ver_code
319: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
320: ,p_gen_src_rev_wp_version_id
321: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_version_id%TYPE := FND_API.G_MISS_NUM
322: ,p_gen_src_rev_wp_ver_code
323: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
317: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_version_id%TYPE := FND_API.G_MISS_NUM
318: ,p_gen_src_cost_wp_ver_code
319: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
320: ,p_gen_src_rev_wp_version_id
321: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_version_id%TYPE := FND_API.G_MISS_NUM
322: ,p_gen_src_rev_wp_ver_code
323: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
324: ,p_gen_src_all_wp_version_id
325: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_version_id%TYPE := FND_API.G_MISS_NUM
319: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
320: ,p_gen_src_rev_wp_version_id
321: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_version_id%TYPE := FND_API.G_MISS_NUM
322: ,p_gen_src_rev_wp_ver_code
323: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
324: ,p_gen_src_all_wp_version_id
325: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_version_id%TYPE := FND_API.G_MISS_NUM
326: ,p_gen_src_all_wp_ver_code
327: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
321: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_version_id%TYPE := FND_API.G_MISS_NUM
322: ,p_gen_src_rev_wp_ver_code
323: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
324: ,p_gen_src_all_wp_version_id
325: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_version_id%TYPE := FND_API.G_MISS_NUM
326: ,p_gen_src_all_wp_ver_code
327: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
328: -- bug 3519062 end of workplan gen source related columns
329:
323: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
324: ,p_gen_src_all_wp_version_id
325: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_version_id%TYPE := FND_API.G_MISS_NUM
326: ,p_gen_src_all_wp_ver_code
327: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
328: -- bug 3519062 end of workplan gen source related columns
329:
330: --Added for webAdi changes for the amount types to be displayed
331: ,p_cost_layout_code
328: -- bug 3519062 end of workplan gen source related columns
329:
330: --Added for webAdi changes for the amount types to be displayed
331: ,p_cost_layout_code
332: IN PA_PROJ_FP_OPTIONS.cost_layout_code%TYPE := FND_API.G_MISS_CHAR
333: ,p_revenue_layout_code
334: IN PA_PROJ_FP_OPTIONS.revenue_layout_code%TYPE := FND_API.G_MISS_CHAR
335: ,p_all_layout_code
336: IN PA_PROJ_FP_OPTIONS.all_layout_code%TYPE := FND_API.G_MISS_CHAR
330: --Added for webAdi changes for the amount types to be displayed
331: ,p_cost_layout_code
332: IN PA_PROJ_FP_OPTIONS.cost_layout_code%TYPE := FND_API.G_MISS_CHAR
333: ,p_revenue_layout_code
334: IN PA_PROJ_FP_OPTIONS.revenue_layout_code%TYPE := FND_API.G_MISS_CHAR
335: ,p_all_layout_code
336: IN PA_PROJ_FP_OPTIONS.all_layout_code%TYPE := FND_API.G_MISS_CHAR
337: ,p_revenue_derivation_method
338: IN PA_PROJ_FP_OPTIONS.revenue_derivation_method%TYPE := FND_API.G_MISS_CHAR --Bug 5462471
332: IN PA_PROJ_FP_OPTIONS.cost_layout_code%TYPE := FND_API.G_MISS_CHAR
333: ,p_revenue_layout_code
334: IN PA_PROJ_FP_OPTIONS.revenue_layout_code%TYPE := FND_API.G_MISS_CHAR
335: ,p_all_layout_code
336: IN PA_PROJ_FP_OPTIONS.all_layout_code%TYPE := FND_API.G_MISS_CHAR
337: ,p_revenue_derivation_method
338: IN PA_PROJ_FP_OPTIONS.revenue_derivation_method%TYPE := FND_API.G_MISS_CHAR --Bug 5462471
339: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
340: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
334: IN PA_PROJ_FP_OPTIONS.revenue_layout_code%TYPE := FND_API.G_MISS_CHAR
335: ,p_all_layout_code
336: IN PA_PROJ_FP_OPTIONS.all_layout_code%TYPE := FND_API.G_MISS_CHAR
337: ,p_revenue_derivation_method
338: IN PA_PROJ_FP_OPTIONS.revenue_derivation_method%TYPE := FND_API.G_MISS_CHAR --Bug 5462471
339: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
340: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
341: IS
342: CURSOR C2 IS SELECT pa_proj_fp_options_s.nextval FROM sys.dual;
338: IN PA_PROJ_FP_OPTIONS.revenue_derivation_method%TYPE := FND_API.G_MISS_CHAR --Bug 5462471
339: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
340: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
341: IS
342: CURSOR C2 IS SELECT pa_proj_fp_options_s.nextval FROM sys.dual;
343: BEGIN
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345:
346: IF (px_proj_fp_options_id IS NULL) OR
348: open c2;
349: fetch c2 into px_proj_fp_options_id;
350: close c2;
351: end if;
352: INSERT INTO pa_proj_fp_options(
353: proj_fp_options_id
354: ,record_version_number
355: ,project_id
356: ,fin_plan_option_level_code
612:
613: EXCEPTION
614: WHEN OTHERS THEN
615: FND_MSG_PUB.add_exc_msg( p_pkg_name
616: => 'PA_PROJ_FP_OPTIONS_PKG'
617: ,p_procedure_name
618: => 'Insert_Row');
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: RAISE;
623:
624:
625: PROCEDURE Update_Row
626: ( p_proj_fp_options_id
627: IN pa_proj_fp_options.proj_fp_options_id%TYPE := FND_API.G_MISS_NUM
628: ,p_record_version_number
629: IN NUMBER := NULL
630: ,p_project_id
631: IN pa_proj_fp_options.project_id%TYPE := FND_API.G_MISS_NUM
627: IN pa_proj_fp_options.proj_fp_options_id%TYPE := FND_API.G_MISS_NUM
628: ,p_record_version_number
629: IN NUMBER := NULL
630: ,p_project_id
631: IN pa_proj_fp_options.project_id%TYPE := FND_API.G_MISS_NUM
632: ,p_fin_plan_option_level_code
633: IN pa_proj_fp_options.fin_plan_option_level_code%TYPE := FND_API.G_MISS_CHAR
634: ,p_fin_plan_type_id
635: IN pa_proj_fp_options.fin_plan_type_id%TYPE := FND_API.G_MISS_NUM
629: IN NUMBER := NULL
630: ,p_project_id
631: IN pa_proj_fp_options.project_id%TYPE := FND_API.G_MISS_NUM
632: ,p_fin_plan_option_level_code
633: IN pa_proj_fp_options.fin_plan_option_level_code%TYPE := FND_API.G_MISS_CHAR
634: ,p_fin_plan_type_id
635: IN pa_proj_fp_options.fin_plan_type_id%TYPE := FND_API.G_MISS_NUM
636: ,p_fin_plan_start_date
637: IN pa_proj_fp_options.fin_plan_start_date%TYPE := FND_API.G_MISS_DATE
631: IN pa_proj_fp_options.project_id%TYPE := FND_API.G_MISS_NUM
632: ,p_fin_plan_option_level_code
633: IN pa_proj_fp_options.fin_plan_option_level_code%TYPE := FND_API.G_MISS_CHAR
634: ,p_fin_plan_type_id
635: IN pa_proj_fp_options.fin_plan_type_id%TYPE := FND_API.G_MISS_NUM
636: ,p_fin_plan_start_date
637: IN pa_proj_fp_options.fin_plan_start_date%TYPE := FND_API.G_MISS_DATE
638: ,p_fin_plan_end_date
639: IN pa_proj_fp_options.fin_plan_end_date%TYPE := FND_API.G_MISS_DATE
633: IN pa_proj_fp_options.fin_plan_option_level_code%TYPE := FND_API.G_MISS_CHAR
634: ,p_fin_plan_type_id
635: IN pa_proj_fp_options.fin_plan_type_id%TYPE := FND_API.G_MISS_NUM
636: ,p_fin_plan_start_date
637: IN pa_proj_fp_options.fin_plan_start_date%TYPE := FND_API.G_MISS_DATE
638: ,p_fin_plan_end_date
639: IN pa_proj_fp_options.fin_plan_end_date%TYPE := FND_API.G_MISS_DATE
640: ,p_fin_plan_preference_code
641: IN pa_proj_fp_options.fin_plan_preference_code%TYPE := FND_API.G_MISS_CHAR
635: IN pa_proj_fp_options.fin_plan_type_id%TYPE := FND_API.G_MISS_NUM
636: ,p_fin_plan_start_date
637: IN pa_proj_fp_options.fin_plan_start_date%TYPE := FND_API.G_MISS_DATE
638: ,p_fin_plan_end_date
639: IN pa_proj_fp_options.fin_plan_end_date%TYPE := FND_API.G_MISS_DATE
640: ,p_fin_plan_preference_code
641: IN pa_proj_fp_options.fin_plan_preference_code%TYPE := FND_API.G_MISS_CHAR
642: ,p_cost_amount_set_id
643: IN pa_proj_fp_options.cost_amount_set_id%TYPE := FND_API.G_MISS_NUM
637: IN pa_proj_fp_options.fin_plan_start_date%TYPE := FND_API.G_MISS_DATE
638: ,p_fin_plan_end_date
639: IN pa_proj_fp_options.fin_plan_end_date%TYPE := FND_API.G_MISS_DATE
640: ,p_fin_plan_preference_code
641: IN pa_proj_fp_options.fin_plan_preference_code%TYPE := FND_API.G_MISS_CHAR
642: ,p_cost_amount_set_id
643: IN pa_proj_fp_options.cost_amount_set_id%TYPE := FND_API.G_MISS_NUM
644: ,p_revenue_amount_set_id
645: IN pa_proj_fp_options.revenue_amount_set_id%TYPE := FND_API.G_MISS_NUM
639: IN pa_proj_fp_options.fin_plan_end_date%TYPE := FND_API.G_MISS_DATE
640: ,p_fin_plan_preference_code
641: IN pa_proj_fp_options.fin_plan_preference_code%TYPE := FND_API.G_MISS_CHAR
642: ,p_cost_amount_set_id
643: IN pa_proj_fp_options.cost_amount_set_id%TYPE := FND_API.G_MISS_NUM
644: ,p_revenue_amount_set_id
645: IN pa_proj_fp_options.revenue_amount_set_id%TYPE := FND_API.G_MISS_NUM
646: ,p_all_amount_set_id
647: IN pa_proj_fp_options.all_amount_set_id%TYPE := FND_API.G_MISS_NUM
641: IN pa_proj_fp_options.fin_plan_preference_code%TYPE := FND_API.G_MISS_CHAR
642: ,p_cost_amount_set_id
643: IN pa_proj_fp_options.cost_amount_set_id%TYPE := FND_API.G_MISS_NUM
644: ,p_revenue_amount_set_id
645: IN pa_proj_fp_options.revenue_amount_set_id%TYPE := FND_API.G_MISS_NUM
646: ,p_all_amount_set_id
647: IN pa_proj_fp_options.all_amount_set_id%TYPE := FND_API.G_MISS_NUM
648: ,p_cost_fin_plan_level_code
649: IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
643: IN pa_proj_fp_options.cost_amount_set_id%TYPE := FND_API.G_MISS_NUM
644: ,p_revenue_amount_set_id
645: IN pa_proj_fp_options.revenue_amount_set_id%TYPE := FND_API.G_MISS_NUM
646: ,p_all_amount_set_id
647: IN pa_proj_fp_options.all_amount_set_id%TYPE := FND_API.G_MISS_NUM
648: ,p_cost_fin_plan_level_code
649: IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
650: ,p_cost_time_phased_code
651: IN pa_proj_fp_options.cost_time_phased_code%TYPE := FND_API.G_MISS_CHAR
645: IN pa_proj_fp_options.revenue_amount_set_id%TYPE := FND_API.G_MISS_NUM
646: ,p_all_amount_set_id
647: IN pa_proj_fp_options.all_amount_set_id%TYPE := FND_API.G_MISS_NUM
648: ,p_cost_fin_plan_level_code
649: IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
650: ,p_cost_time_phased_code
651: IN pa_proj_fp_options.cost_time_phased_code%TYPE := FND_API.G_MISS_CHAR
652: ,p_cost_resource_list_id
653: IN pa_proj_fp_options.cost_resource_list_id%TYPE := FND_API.G_MISS_NUM
647: IN pa_proj_fp_options.all_amount_set_id%TYPE := FND_API.G_MISS_NUM
648: ,p_cost_fin_plan_level_code
649: IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
650: ,p_cost_time_phased_code
651: IN pa_proj_fp_options.cost_time_phased_code%TYPE := FND_API.G_MISS_CHAR
652: ,p_cost_resource_list_id
653: IN pa_proj_fp_options.cost_resource_list_id%TYPE := FND_API.G_MISS_NUM
654: ,p_revenue_fin_plan_level_code
655: IN pa_proj_fp_options.revenue_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
649: IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
650: ,p_cost_time_phased_code
651: IN pa_proj_fp_options.cost_time_phased_code%TYPE := FND_API.G_MISS_CHAR
652: ,p_cost_resource_list_id
653: IN pa_proj_fp_options.cost_resource_list_id%TYPE := FND_API.G_MISS_NUM
654: ,p_revenue_fin_plan_level_code
655: IN pa_proj_fp_options.revenue_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
656: ,p_revenue_time_phased_code
657: IN pa_proj_fp_options.revenue_time_phased_code%TYPE := FND_API.G_MISS_CHAR
651: IN pa_proj_fp_options.cost_time_phased_code%TYPE := FND_API.G_MISS_CHAR
652: ,p_cost_resource_list_id
653: IN pa_proj_fp_options.cost_resource_list_id%TYPE := FND_API.G_MISS_NUM
654: ,p_revenue_fin_plan_level_code
655: IN pa_proj_fp_options.revenue_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
656: ,p_revenue_time_phased_code
657: IN pa_proj_fp_options.revenue_time_phased_code%TYPE := FND_API.G_MISS_CHAR
658: ,p_revenue_resource_list_id
659: IN pa_proj_fp_options.revenue_resource_list_id%TYPE := FND_API.G_MISS_NUM
653: IN pa_proj_fp_options.cost_resource_list_id%TYPE := FND_API.G_MISS_NUM
654: ,p_revenue_fin_plan_level_code
655: IN pa_proj_fp_options.revenue_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
656: ,p_revenue_time_phased_code
657: IN pa_proj_fp_options.revenue_time_phased_code%TYPE := FND_API.G_MISS_CHAR
658: ,p_revenue_resource_list_id
659: IN pa_proj_fp_options.revenue_resource_list_id%TYPE := FND_API.G_MISS_NUM
660: ,p_all_fin_plan_level_code
661: IN pa_proj_fp_options.all_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
655: IN pa_proj_fp_options.revenue_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
656: ,p_revenue_time_phased_code
657: IN pa_proj_fp_options.revenue_time_phased_code%TYPE := FND_API.G_MISS_CHAR
658: ,p_revenue_resource_list_id
659: IN pa_proj_fp_options.revenue_resource_list_id%TYPE := FND_API.G_MISS_NUM
660: ,p_all_fin_plan_level_code
661: IN pa_proj_fp_options.all_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
662: ,p_all_time_phased_code
663: IN pa_proj_fp_options.all_time_phased_code%TYPE := FND_API.G_MISS_CHAR
657: IN pa_proj_fp_options.revenue_time_phased_code%TYPE := FND_API.G_MISS_CHAR
658: ,p_revenue_resource_list_id
659: IN pa_proj_fp_options.revenue_resource_list_id%TYPE := FND_API.G_MISS_NUM
660: ,p_all_fin_plan_level_code
661: IN pa_proj_fp_options.all_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
662: ,p_all_time_phased_code
663: IN pa_proj_fp_options.all_time_phased_code%TYPE := FND_API.G_MISS_CHAR
664: ,p_all_resource_list_id
665: IN pa_proj_fp_options.all_resource_list_id%TYPE := FND_API.G_MISS_NUM
659: IN pa_proj_fp_options.revenue_resource_list_id%TYPE := FND_API.G_MISS_NUM
660: ,p_all_fin_plan_level_code
661: IN pa_proj_fp_options.all_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
662: ,p_all_time_phased_code
663: IN pa_proj_fp_options.all_time_phased_code%TYPE := FND_API.G_MISS_CHAR
664: ,p_all_resource_list_id
665: IN pa_proj_fp_options.all_resource_list_id%TYPE := FND_API.G_MISS_NUM
666: ,p_report_labor_hrs_from_code
667: IN pa_proj_fp_options.report_labor_hrs_from_code%TYPE := FND_API.G_MISS_CHAR
661: IN pa_proj_fp_options.all_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
662: ,p_all_time_phased_code
663: IN pa_proj_fp_options.all_time_phased_code%TYPE := FND_API.G_MISS_CHAR
664: ,p_all_resource_list_id
665: IN pa_proj_fp_options.all_resource_list_id%TYPE := FND_API.G_MISS_NUM
666: ,p_report_labor_hrs_from_code
667: IN pa_proj_fp_options.report_labor_hrs_from_code%TYPE := FND_API.G_MISS_CHAR
668: ,p_fin_plan_version_id
669: IN pa_proj_fp_options.fin_plan_version_id%TYPE := FND_API.G_MISS_NUM
663: IN pa_proj_fp_options.all_time_phased_code%TYPE := FND_API.G_MISS_CHAR
664: ,p_all_resource_list_id
665: IN pa_proj_fp_options.all_resource_list_id%TYPE := FND_API.G_MISS_NUM
666: ,p_report_labor_hrs_from_code
667: IN pa_proj_fp_options.report_labor_hrs_from_code%TYPE := FND_API.G_MISS_CHAR
668: ,p_fin_plan_version_id
669: IN pa_proj_fp_options.fin_plan_version_id%TYPE := FND_API.G_MISS_NUM
670: /* added for financial planning */
671: ,p_plan_in_multi_curr_flag
665: IN pa_proj_fp_options.all_resource_list_id%TYPE := FND_API.G_MISS_NUM
666: ,p_report_labor_hrs_from_code
667: IN pa_proj_fp_options.report_labor_hrs_from_code%TYPE := FND_API.G_MISS_CHAR
668: ,p_fin_plan_version_id
669: IN pa_proj_fp_options.fin_plan_version_id%TYPE := FND_API.G_MISS_NUM
670: /* added for financial planning */
671: ,p_plan_in_multi_curr_flag
672: IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := FND_API.G_MISS_CHAR
673: ,p_factor_by_code
668: ,p_fin_plan_version_id
669: IN pa_proj_fp_options.fin_plan_version_id%TYPE := FND_API.G_MISS_NUM
670: /* added for financial planning */
671: ,p_plan_in_multi_curr_flag
672: IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := FND_API.G_MISS_CHAR
673: ,p_factor_by_code
674: IN pa_proj_fp_options.factor_by_code%TYPE := FND_API.G_MISS_CHAR
675: ,p_default_amount_type_code
676: IN pa_proj_fp_options.default_amount_type_code%TYPE := FND_API.G_MISS_CHAR
670: /* added for financial planning */
671: ,p_plan_in_multi_curr_flag
672: IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := FND_API.G_MISS_CHAR
673: ,p_factor_by_code
674: IN pa_proj_fp_options.factor_by_code%TYPE := FND_API.G_MISS_CHAR
675: ,p_default_amount_type_code
676: IN pa_proj_fp_options.default_amount_type_code%TYPE := FND_API.G_MISS_CHAR
677: ,p_default_amount_subtype_code
678: IN pa_proj_fp_options.default_amount_subtype_code%TYPE := FND_API.G_MISS_CHAR
672: IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := FND_API.G_MISS_CHAR
673: ,p_factor_by_code
674: IN pa_proj_fp_options.factor_by_code%TYPE := FND_API.G_MISS_CHAR
675: ,p_default_amount_type_code
676: IN pa_proj_fp_options.default_amount_type_code%TYPE := FND_API.G_MISS_CHAR
677: ,p_default_amount_subtype_code
678: IN pa_proj_fp_options.default_amount_subtype_code%TYPE := FND_API.G_MISS_CHAR
679: ,p_approved_cost_plan_type_flag
680: IN pa_proj_fp_options.approved_cost_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
674: IN pa_proj_fp_options.factor_by_code%TYPE := FND_API.G_MISS_CHAR
675: ,p_default_amount_type_code
676: IN pa_proj_fp_options.default_amount_type_code%TYPE := FND_API.G_MISS_CHAR
677: ,p_default_amount_subtype_code
678: IN pa_proj_fp_options.default_amount_subtype_code%TYPE := FND_API.G_MISS_CHAR
679: ,p_approved_cost_plan_type_flag
680: IN pa_proj_fp_options.approved_cost_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
681: ,p_approved_rev_plan_type_flag
682: IN pa_proj_fp_options.approved_rev_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
676: IN pa_proj_fp_options.default_amount_type_code%TYPE := FND_API.G_MISS_CHAR
677: ,p_default_amount_subtype_code
678: IN pa_proj_fp_options.default_amount_subtype_code%TYPE := FND_API.G_MISS_CHAR
679: ,p_approved_cost_plan_type_flag
680: IN pa_proj_fp_options.approved_cost_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
681: ,p_approved_rev_plan_type_flag
682: IN pa_proj_fp_options.approved_rev_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
683: ,p_projfunc_cost_rate_type
684: IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
678: IN pa_proj_fp_options.default_amount_subtype_code%TYPE := FND_API.G_MISS_CHAR
679: ,p_approved_cost_plan_type_flag
680: IN pa_proj_fp_options.approved_cost_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
681: ,p_approved_rev_plan_type_flag
682: IN pa_proj_fp_options.approved_rev_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
683: ,p_projfunc_cost_rate_type
684: IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
685: ,p_projfunc_cost_rate_date_type
686: IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
680: IN pa_proj_fp_options.approved_cost_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
681: ,p_approved_rev_plan_type_flag
682: IN pa_proj_fp_options.approved_rev_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
683: ,p_projfunc_cost_rate_type
684: IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
685: ,p_projfunc_cost_rate_date_type
686: IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
687: ,p_projfunc_cost_rate_date
688: IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := FND_API.G_MISS_DATE
682: IN pa_proj_fp_options.approved_rev_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
683: ,p_projfunc_cost_rate_type
684: IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
685: ,p_projfunc_cost_rate_date_type
686: IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
687: ,p_projfunc_cost_rate_date
688: IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := FND_API.G_MISS_DATE
689: ,p_projfunc_rev_rate_type
690: IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
684: IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
685: ,p_projfunc_cost_rate_date_type
686: IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
687: ,p_projfunc_cost_rate_date
688: IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := FND_API.G_MISS_DATE
689: ,p_projfunc_rev_rate_type
690: IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
691: ,p_projfunc_rev_rate_date_type
692: IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
686: IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
687: ,p_projfunc_cost_rate_date
688: IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := FND_API.G_MISS_DATE
689: ,p_projfunc_rev_rate_type
690: IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
691: ,p_projfunc_rev_rate_date_type
692: IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
693: ,p_projfunc_rev_rate_date
694: IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := FND_API.G_MISS_DATE
688: IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := FND_API.G_MISS_DATE
689: ,p_projfunc_rev_rate_type
690: IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
691: ,p_projfunc_rev_rate_date_type
692: IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
693: ,p_projfunc_rev_rate_date
694: IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := FND_API.G_MISS_DATE
695: ,p_project_cost_rate_type
696: IN pa_proj_fp_options.project_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
690: IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
691: ,p_projfunc_rev_rate_date_type
692: IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
693: ,p_projfunc_rev_rate_date
694: IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := FND_API.G_MISS_DATE
695: ,p_project_cost_rate_type
696: IN pa_proj_fp_options.project_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
697: ,p_project_cost_rate_date_type
698: IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
692: IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
693: ,p_projfunc_rev_rate_date
694: IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := FND_API.G_MISS_DATE
695: ,p_project_cost_rate_type
696: IN pa_proj_fp_options.project_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
697: ,p_project_cost_rate_date_type
698: IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
699: ,p_project_cost_rate_date
700: IN pa_proj_fp_options.project_cost_rate_date%TYPE := FND_API.G_MISS_DATE
694: IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := FND_API.G_MISS_DATE
695: ,p_project_cost_rate_type
696: IN pa_proj_fp_options.project_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
697: ,p_project_cost_rate_date_type
698: IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
699: ,p_project_cost_rate_date
700: IN pa_proj_fp_options.project_cost_rate_date%TYPE := FND_API.G_MISS_DATE
701: ,p_project_rev_rate_type
702: IN pa_proj_fp_options.project_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
696: IN pa_proj_fp_options.project_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
697: ,p_project_cost_rate_date_type
698: IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
699: ,p_project_cost_rate_date
700: IN pa_proj_fp_options.project_cost_rate_date%TYPE := FND_API.G_MISS_DATE
701: ,p_project_rev_rate_type
702: IN pa_proj_fp_options.project_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
703: ,p_project_rev_rate_date_type
704: IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
698: IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
699: ,p_project_cost_rate_date
700: IN pa_proj_fp_options.project_cost_rate_date%TYPE := FND_API.G_MISS_DATE
701: ,p_project_rev_rate_type
702: IN pa_proj_fp_options.project_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
703: ,p_project_rev_rate_date_type
704: IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_rev_rate_date
706: IN pa_proj_fp_options.project_rev_rate_date%TYPE := FND_API.G_MISS_DATE
700: IN pa_proj_fp_options.project_cost_rate_date%TYPE := FND_API.G_MISS_DATE
701: ,p_project_rev_rate_type
702: IN pa_proj_fp_options.project_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
703: ,p_project_rev_rate_date_type
704: IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_rev_rate_date
706: IN pa_proj_fp_options.project_rev_rate_date%TYPE := FND_API.G_MISS_DATE
707: ,p_margin_derived_from_code
708: IN pa_proj_fp_options.margin_derived_from_code%TYPE := FND_API.G_MISS_CHAR
702: IN pa_proj_fp_options.project_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
703: ,p_project_rev_rate_date_type
704: IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_rev_rate_date
706: IN pa_proj_fp_options.project_rev_rate_date%TYPE := FND_API.G_MISS_DATE
707: ,p_margin_derived_from_code
708: IN pa_proj_fp_options.margin_derived_from_code%TYPE := FND_API.G_MISS_CHAR
709: /* ended additions for fin plan */
710: /* Bug 2920954 start of additional parameters for post FP-k one off */
704: IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_rev_rate_date
706: IN pa_proj_fp_options.project_rev_rate_date%TYPE := FND_API.G_MISS_DATE
707: ,p_margin_derived_from_code
708: IN pa_proj_fp_options.margin_derived_from_code%TYPE := FND_API.G_MISS_CHAR
709: /* ended additions for fin plan */
710: /* Bug 2920954 start of additional parameters for post FP-k one off */
711: ,p_select_cost_res_auto_flag
712: IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
708: IN pa_proj_fp_options.margin_derived_from_code%TYPE := FND_API.G_MISS_CHAR
709: /* ended additions for fin plan */
710: /* Bug 2920954 start of additional parameters for post FP-k one off */
711: ,p_select_cost_res_auto_flag
712: IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
713: ,p_cost_res_planning_level
714: IN pa_proj_fp_options.cost_res_planning_level%TYPE := FND_API.G_MISS_CHAR
715: ,p_select_rev_res_auto_flag
716: IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
710: /* Bug 2920954 start of additional parameters for post FP-k one off */
711: ,p_select_cost_res_auto_flag
712: IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
713: ,p_cost_res_planning_level
714: IN pa_proj_fp_options.cost_res_planning_level%TYPE := FND_API.G_MISS_CHAR
715: ,p_select_rev_res_auto_flag
716: IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
717: ,p_revenue_res_planning_level
718: IN pa_proj_fp_options.revenue_res_planning_level%TYPE := FND_API.G_MISS_CHAR
712: IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
713: ,p_cost_res_planning_level
714: IN pa_proj_fp_options.cost_res_planning_level%TYPE := FND_API.G_MISS_CHAR
715: ,p_select_rev_res_auto_flag
716: IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
717: ,p_revenue_res_planning_level
718: IN pa_proj_fp_options.revenue_res_planning_level%TYPE := FND_API.G_MISS_CHAR
719: ,p_select_all_res_auto_flag
720: IN pa_proj_fp_options.select_all_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
714: IN pa_proj_fp_options.cost_res_planning_level%TYPE := FND_API.G_MISS_CHAR
715: ,p_select_rev_res_auto_flag
716: IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
717: ,p_revenue_res_planning_level
718: IN pa_proj_fp_options.revenue_res_planning_level%TYPE := FND_API.G_MISS_CHAR
719: ,p_select_all_res_auto_flag
720: IN pa_proj_fp_options.select_all_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
721: ,p_all_res_planning_level
722: IN pa_proj_fp_options.all_res_planning_level%TYPE := FND_API.G_MISS_CHAR
716: IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
717: ,p_revenue_res_planning_level
718: IN pa_proj_fp_options.revenue_res_planning_level%TYPE := FND_API.G_MISS_CHAR
719: ,p_select_all_res_auto_flag
720: IN pa_proj_fp_options.select_all_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
721: ,p_all_res_planning_level
722: IN pa_proj_fp_options.all_res_planning_level%TYPE := FND_API.G_MISS_CHAR
723: /* Bug 2920954 end of additional parameters for post FP-k one off */
724: ,p_primary_cost_forecast_flag
718: IN pa_proj_fp_options.revenue_res_planning_level%TYPE := FND_API.G_MISS_CHAR
719: ,p_select_all_res_auto_flag
720: IN pa_proj_fp_options.select_all_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
721: ,p_all_res_planning_level
722: IN pa_proj_fp_options.all_res_planning_level%TYPE := FND_API.G_MISS_CHAR
723: /* Bug 2920954 end of additional parameters for post FP-k one off */
724: ,p_primary_cost_forecast_flag
725: IN PA_PROJ_FP_OPTIONS.primary_cost_forecast_flag%TYPE := FND_API.G_MISS_CHAR
726: ,p_primary_rev_forecast_flag
721: ,p_all_res_planning_level
722: IN pa_proj_fp_options.all_res_planning_level%TYPE := FND_API.G_MISS_CHAR
723: /* Bug 2920954 end of additional parameters for post FP-k one off */
724: ,p_primary_cost_forecast_flag
725: IN PA_PROJ_FP_OPTIONS.primary_cost_forecast_flag%TYPE := FND_API.G_MISS_CHAR
726: ,p_primary_rev_forecast_flag
727: IN PA_PROJ_FP_OPTIONS.primary_rev_forecast_flag%TYPE := FND_API.G_MISS_CHAR
728: ,p_use_planning_rates_flag
729: IN PA_PROJ_FP_OPTIONS.use_planning_rates_flag%TYPE := FND_API.G_MISS_CHAR
723: /* Bug 2920954 end of additional parameters for post FP-k one off */
724: ,p_primary_cost_forecast_flag
725: IN PA_PROJ_FP_OPTIONS.primary_cost_forecast_flag%TYPE := FND_API.G_MISS_CHAR
726: ,p_primary_rev_forecast_flag
727: IN PA_PROJ_FP_OPTIONS.primary_rev_forecast_flag%TYPE := FND_API.G_MISS_CHAR
728: ,p_use_planning_rates_flag
729: IN PA_PROJ_FP_OPTIONS.use_planning_rates_flag%TYPE := FND_API.G_MISS_CHAR
730: ,p_rbs_version_id
731: IN PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE := FND_API.G_MISS_NUM
725: IN PA_PROJ_FP_OPTIONS.primary_cost_forecast_flag%TYPE := FND_API.G_MISS_CHAR
726: ,p_primary_rev_forecast_flag
727: IN PA_PROJ_FP_OPTIONS.primary_rev_forecast_flag%TYPE := FND_API.G_MISS_CHAR
728: ,p_use_planning_rates_flag
729: IN PA_PROJ_FP_OPTIONS.use_planning_rates_flag%TYPE := FND_API.G_MISS_CHAR
730: ,p_rbs_version_id
731: IN PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE := FND_API.G_MISS_NUM
732: ,p_res_class_raw_cost_sch_id
733: IN PA_PROJ_FP_OPTIONS.res_class_raw_cost_sch_id%TYPE := FND_API.G_MISS_NUM
727: IN PA_PROJ_FP_OPTIONS.primary_rev_forecast_flag%TYPE := FND_API.G_MISS_CHAR
728: ,p_use_planning_rates_flag
729: IN PA_PROJ_FP_OPTIONS.use_planning_rates_flag%TYPE := FND_API.G_MISS_CHAR
730: ,p_rbs_version_id
731: IN PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE := FND_API.G_MISS_NUM
732: ,p_res_class_raw_cost_sch_id
733: IN PA_PROJ_FP_OPTIONS.res_class_raw_cost_sch_id%TYPE := FND_API.G_MISS_NUM
734: ,p_res_class_bill_rate_sch_id
735: IN PA_PROJ_FP_OPTIONS.res_class_bill_rate_sch_id%TYPE := FND_API.G_MISS_NUM
729: IN PA_PROJ_FP_OPTIONS.use_planning_rates_flag%TYPE := FND_API.G_MISS_CHAR
730: ,p_rbs_version_id
731: IN PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE := FND_API.G_MISS_NUM
732: ,p_res_class_raw_cost_sch_id
733: IN PA_PROJ_FP_OPTIONS.res_class_raw_cost_sch_id%TYPE := FND_API.G_MISS_NUM
734: ,p_res_class_bill_rate_sch_id
735: IN PA_PROJ_FP_OPTIONS.res_class_bill_rate_sch_id%TYPE := FND_API.G_MISS_NUM
736: ,p_cost_emp_rate_sch_id
737: IN PA_PROJ_FP_OPTIONS.cost_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
731: IN PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE := FND_API.G_MISS_NUM
732: ,p_res_class_raw_cost_sch_id
733: IN PA_PROJ_FP_OPTIONS.res_class_raw_cost_sch_id%TYPE := FND_API.G_MISS_NUM
734: ,p_res_class_bill_rate_sch_id
735: IN PA_PROJ_FP_OPTIONS.res_class_bill_rate_sch_id%TYPE := FND_API.G_MISS_NUM
736: ,p_cost_emp_rate_sch_id
737: IN PA_PROJ_FP_OPTIONS.cost_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
738: ,p_cost_job_rate_sch_id
739: IN PA_PROJ_FP_OPTIONS.cost_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
733: IN PA_PROJ_FP_OPTIONS.res_class_raw_cost_sch_id%TYPE := FND_API.G_MISS_NUM
734: ,p_res_class_bill_rate_sch_id
735: IN PA_PROJ_FP_OPTIONS.res_class_bill_rate_sch_id%TYPE := FND_API.G_MISS_NUM
736: ,p_cost_emp_rate_sch_id
737: IN PA_PROJ_FP_OPTIONS.cost_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
738: ,p_cost_job_rate_sch_id
739: IN PA_PROJ_FP_OPTIONS.cost_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
740: ,P_CST_NON_LABR_RES_RATE_SCH_ID
741: IN PA_PROJ_FP_OPTIONS.cost_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
735: IN PA_PROJ_FP_OPTIONS.res_class_bill_rate_sch_id%TYPE := FND_API.G_MISS_NUM
736: ,p_cost_emp_rate_sch_id
737: IN PA_PROJ_FP_OPTIONS.cost_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
738: ,p_cost_job_rate_sch_id
739: IN PA_PROJ_FP_OPTIONS.cost_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
740: ,P_CST_NON_LABR_RES_RATE_SCH_ID
741: IN PA_PROJ_FP_OPTIONS.cost_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
742: ,p_cost_res_class_rate_sch_id
743: IN PA_PROJ_FP_OPTIONS.cost_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
737: IN PA_PROJ_FP_OPTIONS.cost_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
738: ,p_cost_job_rate_sch_id
739: IN PA_PROJ_FP_OPTIONS.cost_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
740: ,P_CST_NON_LABR_RES_RATE_SCH_ID
741: IN PA_PROJ_FP_OPTIONS.cost_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
742: ,p_cost_res_class_rate_sch_id
743: IN PA_PROJ_FP_OPTIONS.cost_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
744: ,p_cost_burden_rate_sch_id
745: IN PA_PROJ_FP_OPTIONS.cost_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
739: IN PA_PROJ_FP_OPTIONS.cost_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
740: ,P_CST_NON_LABR_RES_RATE_SCH_ID
741: IN PA_PROJ_FP_OPTIONS.cost_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
742: ,p_cost_res_class_rate_sch_id
743: IN PA_PROJ_FP_OPTIONS.cost_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
744: ,p_cost_burden_rate_sch_id
745: IN PA_PROJ_FP_OPTIONS.cost_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
746: ,p_cost_current_planning_period
747: IN PA_PROJ_FP_OPTIONS.cost_current_planning_period%TYPE := FND_API.G_MISS_CHAR
741: IN PA_PROJ_FP_OPTIONS.cost_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
742: ,p_cost_res_class_rate_sch_id
743: IN PA_PROJ_FP_OPTIONS.cost_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
744: ,p_cost_burden_rate_sch_id
745: IN PA_PROJ_FP_OPTIONS.cost_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
746: ,p_cost_current_planning_period
747: IN PA_PROJ_FP_OPTIONS.cost_current_planning_period%TYPE := FND_API.G_MISS_CHAR
748: ,p_cost_period_mask_id
749: IN PA_PROJ_FP_OPTIONS.cost_period_mask_id%TYPE := FND_API.G_MISS_NUM
743: IN PA_PROJ_FP_OPTIONS.cost_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
744: ,p_cost_burden_rate_sch_id
745: IN PA_PROJ_FP_OPTIONS.cost_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
746: ,p_cost_current_planning_period
747: IN PA_PROJ_FP_OPTIONS.cost_current_planning_period%TYPE := FND_API.G_MISS_CHAR
748: ,p_cost_period_mask_id
749: IN PA_PROJ_FP_OPTIONS.cost_period_mask_id%TYPE := FND_API.G_MISS_NUM
750: ,p_rev_emp_rate_sch_id
751: IN PA_PROJ_FP_OPTIONS.rev_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
745: IN PA_PROJ_FP_OPTIONS.cost_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
746: ,p_cost_current_planning_period
747: IN PA_PROJ_FP_OPTIONS.cost_current_planning_period%TYPE := FND_API.G_MISS_CHAR
748: ,p_cost_period_mask_id
749: IN PA_PROJ_FP_OPTIONS.cost_period_mask_id%TYPE := FND_API.G_MISS_NUM
750: ,p_rev_emp_rate_sch_id
751: IN PA_PROJ_FP_OPTIONS.rev_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
752: ,p_rev_job_rate_sch_id
753: IN PA_PROJ_FP_OPTIONS.rev_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
747: IN PA_PROJ_FP_OPTIONS.cost_current_planning_period%TYPE := FND_API.G_MISS_CHAR
748: ,p_cost_period_mask_id
749: IN PA_PROJ_FP_OPTIONS.cost_period_mask_id%TYPE := FND_API.G_MISS_NUM
750: ,p_rev_emp_rate_sch_id
751: IN PA_PROJ_FP_OPTIONS.rev_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
752: ,p_rev_job_rate_sch_id
753: IN PA_PROJ_FP_OPTIONS.rev_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
754: ,P_REV_NON_LABR_RES_RATE_SCH_ID
755: IN PA_PROJ_FP_OPTIONS.rev_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
749: IN PA_PROJ_FP_OPTIONS.cost_period_mask_id%TYPE := FND_API.G_MISS_NUM
750: ,p_rev_emp_rate_sch_id
751: IN PA_PROJ_FP_OPTIONS.rev_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
752: ,p_rev_job_rate_sch_id
753: IN PA_PROJ_FP_OPTIONS.rev_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
754: ,P_REV_NON_LABR_RES_RATE_SCH_ID
755: IN PA_PROJ_FP_OPTIONS.rev_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
756: ,p_rev_res_class_rate_sch_id
757: IN PA_PROJ_FP_OPTIONS.rev_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
751: IN PA_PROJ_FP_OPTIONS.rev_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
752: ,p_rev_job_rate_sch_id
753: IN PA_PROJ_FP_OPTIONS.rev_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
754: ,P_REV_NON_LABR_RES_RATE_SCH_ID
755: IN PA_PROJ_FP_OPTIONS.rev_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
756: ,p_rev_res_class_rate_sch_id
757: IN PA_PROJ_FP_OPTIONS.rev_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
758: ,p_rev_current_planning_period
759: IN PA_PROJ_FP_OPTIONS.rev_current_planning_period%TYPE := FND_API.G_MISS_CHAR
753: IN PA_PROJ_FP_OPTIONS.rev_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
754: ,P_REV_NON_LABR_RES_RATE_SCH_ID
755: IN PA_PROJ_FP_OPTIONS.rev_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
756: ,p_rev_res_class_rate_sch_id
757: IN PA_PROJ_FP_OPTIONS.rev_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
758: ,p_rev_current_planning_period
759: IN PA_PROJ_FP_OPTIONS.rev_current_planning_period%TYPE := FND_API.G_MISS_CHAR
760: ,p_rev_period_mask_id
761: IN PA_PROJ_FP_OPTIONS.rev_period_mask_id%TYPE := FND_API.G_MISS_NUM
755: IN PA_PROJ_FP_OPTIONS.rev_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
756: ,p_rev_res_class_rate_sch_id
757: IN PA_PROJ_FP_OPTIONS.rev_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
758: ,p_rev_current_planning_period
759: IN PA_PROJ_FP_OPTIONS.rev_current_planning_period%TYPE := FND_API.G_MISS_CHAR
760: ,p_rev_period_mask_id
761: IN PA_PROJ_FP_OPTIONS.rev_period_mask_id%TYPE := FND_API.G_MISS_NUM
762: /** Bug 3580727 Columns have been dropped
763: ,p_all_emp_rate_sch_id
757: IN PA_PROJ_FP_OPTIONS.rev_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
758: ,p_rev_current_planning_period
759: IN PA_PROJ_FP_OPTIONS.rev_current_planning_period%TYPE := FND_API.G_MISS_CHAR
760: ,p_rev_period_mask_id
761: IN PA_PROJ_FP_OPTIONS.rev_period_mask_id%TYPE := FND_API.G_MISS_NUM
762: /** Bug 3580727 Columns have been dropped
763: ,p_all_emp_rate_sch_id
764: IN PA_PROJ_FP_OPTIONS.all_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
765: ,p_all_job_rate_sch_id
760: ,p_rev_period_mask_id
761: IN PA_PROJ_FP_OPTIONS.rev_period_mask_id%TYPE := FND_API.G_MISS_NUM
762: /** Bug 3580727 Columns have been dropped
763: ,p_all_emp_rate_sch_id
764: IN PA_PROJ_FP_OPTIONS.all_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
765: ,p_all_job_rate_sch_id
766: IN PA_PROJ_FP_OPTIONS.all_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
767: ,P_ALL_NON_LABR_RES_RATE_SCH_ID
768: IN PA_PROJ_FP_OPTIONS.all_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
762: /** Bug 3580727 Columns have been dropped
763: ,p_all_emp_rate_sch_id
764: IN PA_PROJ_FP_OPTIONS.all_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
765: ,p_all_job_rate_sch_id
766: IN PA_PROJ_FP_OPTIONS.all_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
767: ,P_ALL_NON_LABR_RES_RATE_SCH_ID
768: IN PA_PROJ_FP_OPTIONS.all_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
769: ,p_all_res_class_rate_sch_id
770: IN PA_PROJ_FP_OPTIONS.all_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
764: IN PA_PROJ_FP_OPTIONS.all_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
765: ,p_all_job_rate_sch_id
766: IN PA_PROJ_FP_OPTIONS.all_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
767: ,P_ALL_NON_LABR_RES_RATE_SCH_ID
768: IN PA_PROJ_FP_OPTIONS.all_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
769: ,p_all_res_class_rate_sch_id
770: IN PA_PROJ_FP_OPTIONS.all_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
771: ,p_all_burden_rate_sch_id
772: IN PA_PROJ_FP_OPTIONS.all_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
766: IN PA_PROJ_FP_OPTIONS.all_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
767: ,P_ALL_NON_LABR_RES_RATE_SCH_ID
768: IN PA_PROJ_FP_OPTIONS.all_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
769: ,p_all_res_class_rate_sch_id
770: IN PA_PROJ_FP_OPTIONS.all_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
771: ,p_all_burden_rate_sch_id
772: IN PA_PROJ_FP_OPTIONS.all_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
773: **/
774: ,p_all_current_planning_period
768: IN PA_PROJ_FP_OPTIONS.all_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
769: ,p_all_res_class_rate_sch_id
770: IN PA_PROJ_FP_OPTIONS.all_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
771: ,p_all_burden_rate_sch_id
772: IN PA_PROJ_FP_OPTIONS.all_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
773: **/
774: ,p_all_current_planning_period
775: IN PA_PROJ_FP_OPTIONS.all_current_planning_period%TYPE := FND_API.G_MISS_CHAR
776: ,p_all_period_mask_id
771: ,p_all_burden_rate_sch_id
772: IN PA_PROJ_FP_OPTIONS.all_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
773: **/
774: ,p_all_current_planning_period
775: IN PA_PROJ_FP_OPTIONS.all_current_planning_period%TYPE := FND_API.G_MISS_CHAR
776: ,p_all_period_mask_id
777: IN PA_PROJ_FP_OPTIONS.all_period_mask_id%TYPE := FND_API.G_MISS_NUM
778: ,p_gen_cost_src_code
779: IN PA_PROJ_FP_OPTIONS.gen_cost_src_code%TYPE := FND_API.G_MISS_CHAR
773: **/
774: ,p_all_current_planning_period
775: IN PA_PROJ_FP_OPTIONS.all_current_planning_period%TYPE := FND_API.G_MISS_CHAR
776: ,p_all_period_mask_id
777: IN PA_PROJ_FP_OPTIONS.all_period_mask_id%TYPE := FND_API.G_MISS_NUM
778: ,p_gen_cost_src_code
779: IN PA_PROJ_FP_OPTIONS.gen_cost_src_code%TYPE := FND_API.G_MISS_CHAR
780: ,p_gen_cost_etc_src_code
781: IN PA_PROJ_FP_OPTIONS.gen_cost_etc_src_code%TYPE := FND_API.G_MISS_CHAR
775: IN PA_PROJ_FP_OPTIONS.all_current_planning_period%TYPE := FND_API.G_MISS_CHAR
776: ,p_all_period_mask_id
777: IN PA_PROJ_FP_OPTIONS.all_period_mask_id%TYPE := FND_API.G_MISS_NUM
778: ,p_gen_cost_src_code
779: IN PA_PROJ_FP_OPTIONS.gen_cost_src_code%TYPE := FND_API.G_MISS_CHAR
780: ,p_gen_cost_etc_src_code
781: IN PA_PROJ_FP_OPTIONS.gen_cost_etc_src_code%TYPE := FND_API.G_MISS_CHAR
782: ,P_GN_COST_INCL_CHANGE_DOC_FLAG
783: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
777: IN PA_PROJ_FP_OPTIONS.all_period_mask_id%TYPE := FND_API.G_MISS_NUM
778: ,p_gen_cost_src_code
779: IN PA_PROJ_FP_OPTIONS.gen_cost_src_code%TYPE := FND_API.G_MISS_CHAR
780: ,p_gen_cost_etc_src_code
781: IN PA_PROJ_FP_OPTIONS.gen_cost_etc_src_code%TYPE := FND_API.G_MISS_CHAR
782: ,P_GN_COST_INCL_CHANGE_DOC_FLAG
783: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
784: ,p_gen_cost_incl_open_comm_flag
785: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
779: IN PA_PROJ_FP_OPTIONS.gen_cost_src_code%TYPE := FND_API.G_MISS_CHAR
780: ,p_gen_cost_etc_src_code
781: IN PA_PROJ_FP_OPTIONS.gen_cost_etc_src_code%TYPE := FND_API.G_MISS_CHAR
782: ,P_GN_COST_INCL_CHANGE_DOC_FLAG
783: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
784: ,p_gen_cost_incl_open_comm_flag
785: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
786: ,P_GN_COST_RET_MANUAL_LINE_FLAG
787: IN PA_PROJ_FP_OPTIONS.gen_cost_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
781: IN PA_PROJ_FP_OPTIONS.gen_cost_etc_src_code%TYPE := FND_API.G_MISS_CHAR
782: ,P_GN_COST_INCL_CHANGE_DOC_FLAG
783: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
784: ,p_gen_cost_incl_open_comm_flag
785: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
786: ,P_GN_COST_RET_MANUAL_LINE_FLAG
787: IN PA_PROJ_FP_OPTIONS.gen_cost_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
788: ,P_GN_CST_INCL_UNSPENT_AMT_FLAG
789: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
783: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
784: ,p_gen_cost_incl_open_comm_flag
785: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
786: ,P_GN_COST_RET_MANUAL_LINE_FLAG
787: IN PA_PROJ_FP_OPTIONS.gen_cost_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
788: ,P_GN_CST_INCL_UNSPENT_AMT_FLAG
789: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
790: ,p_gen_rev_src_code
791: IN PA_PROJ_FP_OPTIONS.gen_rev_src_code%TYPE := FND_API.G_MISS_CHAR
785: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
786: ,P_GN_COST_RET_MANUAL_LINE_FLAG
787: IN PA_PROJ_FP_OPTIONS.gen_cost_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
788: ,P_GN_CST_INCL_UNSPENT_AMT_FLAG
789: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
790: ,p_gen_rev_src_code
791: IN PA_PROJ_FP_OPTIONS.gen_rev_src_code%TYPE := FND_API.G_MISS_CHAR
792: ,p_gen_rev_etc_src_code
793: IN PA_PROJ_FP_OPTIONS.gen_rev_etc_src_code%TYPE := FND_API.G_MISS_CHAR
787: IN PA_PROJ_FP_OPTIONS.gen_cost_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
788: ,P_GN_CST_INCL_UNSPENT_AMT_FLAG
789: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
790: ,p_gen_rev_src_code
791: IN PA_PROJ_FP_OPTIONS.gen_rev_src_code%TYPE := FND_API.G_MISS_CHAR
792: ,p_gen_rev_etc_src_code
793: IN PA_PROJ_FP_OPTIONS.gen_rev_etc_src_code%TYPE := FND_API.G_MISS_CHAR
794: ,p_gen_rev_incl_change_doc_flag
795: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
789: IN PA_PROJ_FP_OPTIONS.gen_cost_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
790: ,p_gen_rev_src_code
791: IN PA_PROJ_FP_OPTIONS.gen_rev_src_code%TYPE := FND_API.G_MISS_CHAR
792: ,p_gen_rev_etc_src_code
793: IN PA_PROJ_FP_OPTIONS.gen_rev_etc_src_code%TYPE := FND_API.G_MISS_CHAR
794: ,p_gen_rev_incl_change_doc_flag
795: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
796: ,p_gen_rev_incl_bill_event_flag
797: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
791: IN PA_PROJ_FP_OPTIONS.gen_rev_src_code%TYPE := FND_API.G_MISS_CHAR
792: ,p_gen_rev_etc_src_code
793: IN PA_PROJ_FP_OPTIONS.gen_rev_etc_src_code%TYPE := FND_API.G_MISS_CHAR
794: ,p_gen_rev_incl_change_doc_flag
795: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
796: ,p_gen_rev_incl_bill_event_flag
797: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
798: ,p_gen_rev_ret_manual_line_flag
799: IN PA_PROJ_FP_OPTIONS.gen_rev_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
793: IN PA_PROJ_FP_OPTIONS.gen_rev_etc_src_code%TYPE := FND_API.G_MISS_CHAR
794: ,p_gen_rev_incl_change_doc_flag
795: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
796: ,p_gen_rev_incl_bill_event_flag
797: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
798: ,p_gen_rev_ret_manual_line_flag
799: IN PA_PROJ_FP_OPTIONS.gen_rev_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
800: /** Bug 3580727
801: ,P_GN_REV_INCL_UNSPENT_AMT_FLAG
795: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
796: ,p_gen_rev_incl_bill_event_flag
797: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
798: ,p_gen_rev_ret_manual_line_flag
799: IN PA_PROJ_FP_OPTIONS.gen_rev_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
800: /** Bug 3580727
801: ,P_GN_REV_INCL_UNSPENT_AMT_FLAG
802: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
803: **/
798: ,p_gen_rev_ret_manual_line_flag
799: IN PA_PROJ_FP_OPTIONS.gen_rev_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
800: /** Bug 3580727
801: ,P_GN_REV_INCL_UNSPENT_AMT_FLAG
802: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
803: **/
804: ,p_gen_src_cost_plan_type_id
805: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_type_id%TYPE := FND_API.G_MISS_NUM
806: ,p_gen_src_cost_plan_version_id
801: ,P_GN_REV_INCL_UNSPENT_AMT_FLAG
802: IN PA_PROJ_FP_OPTIONS.gen_rev_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
803: **/
804: ,p_gen_src_cost_plan_type_id
805: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_type_id%TYPE := FND_API.G_MISS_NUM
806: ,p_gen_src_cost_plan_version_id
807: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_version_id%TYPE := FND_API.G_MISS_NUM
808: ,p_gen_src_cost_plan_ver_code
809: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
803: **/
804: ,p_gen_src_cost_plan_type_id
805: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_type_id%TYPE := FND_API.G_MISS_NUM
806: ,p_gen_src_cost_plan_version_id
807: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_version_id%TYPE := FND_API.G_MISS_NUM
808: ,p_gen_src_cost_plan_ver_code
809: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
810: ,p_gen_src_rev_plan_type_id
811: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_type_id%TYPE := FND_API.G_MISS_NUM
805: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_type_id%TYPE := FND_API.G_MISS_NUM
806: ,p_gen_src_cost_plan_version_id
807: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_version_id%TYPE := FND_API.G_MISS_NUM
808: ,p_gen_src_cost_plan_ver_code
809: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
810: ,p_gen_src_rev_plan_type_id
811: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_type_id%TYPE := FND_API.G_MISS_NUM
812: ,p_gen_src_rev_plan_version_id
813: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_version_id%TYPE := FND_API.G_MISS_NUM
807: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_version_id%TYPE := FND_API.G_MISS_NUM
808: ,p_gen_src_cost_plan_ver_code
809: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
810: ,p_gen_src_rev_plan_type_id
811: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_type_id%TYPE := FND_API.G_MISS_NUM
812: ,p_gen_src_rev_plan_version_id
813: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_version_id%TYPE := FND_API.G_MISS_NUM
814: ,p_gen_src_rev_plan_ver_code
815: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
809: IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
810: ,p_gen_src_rev_plan_type_id
811: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_type_id%TYPE := FND_API.G_MISS_NUM
812: ,p_gen_src_rev_plan_version_id
813: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_version_id%TYPE := FND_API.G_MISS_NUM
814: ,p_gen_src_rev_plan_ver_code
815: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
816: ,p_gen_src_all_plan_type_id
817: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_type_id%TYPE := FND_API.G_MISS_NUM
811: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_type_id%TYPE := FND_API.G_MISS_NUM
812: ,p_gen_src_rev_plan_version_id
813: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_version_id%TYPE := FND_API.G_MISS_NUM
814: ,p_gen_src_rev_plan_ver_code
815: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
816: ,p_gen_src_all_plan_type_id
817: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_type_id%TYPE := FND_API.G_MISS_NUM
818: ,p_gen_src_all_plan_version_id
819: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_version_id%TYPE := FND_API.G_MISS_NUM
813: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_version_id%TYPE := FND_API.G_MISS_NUM
814: ,p_gen_src_rev_plan_ver_code
815: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
816: ,p_gen_src_all_plan_type_id
817: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_type_id%TYPE := FND_API.G_MISS_NUM
818: ,p_gen_src_all_plan_version_id
819: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_version_id%TYPE := FND_API.G_MISS_NUM
820: ,p_gen_src_all_plan_ver_code
821: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
815: IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
816: ,p_gen_src_all_plan_type_id
817: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_type_id%TYPE := FND_API.G_MISS_NUM
818: ,p_gen_src_all_plan_version_id
819: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_version_id%TYPE := FND_API.G_MISS_NUM
820: ,p_gen_src_all_plan_ver_code
821: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
822: ,p_gen_all_src_code
823: IN PA_PROJ_FP_OPTIONS.gen_all_src_code%TYPE := FND_API.G_MISS_CHAR
817: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_type_id%TYPE := FND_API.G_MISS_NUM
818: ,p_gen_src_all_plan_version_id
819: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_version_id%TYPE := FND_API.G_MISS_NUM
820: ,p_gen_src_all_plan_ver_code
821: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
822: ,p_gen_all_src_code
823: IN PA_PROJ_FP_OPTIONS.gen_all_src_code%TYPE := FND_API.G_MISS_CHAR
824: ,p_gen_all_etc_src_code
825: IN PA_PROJ_FP_OPTIONS.gen_all_etc_src_code%TYPE := FND_API.G_MISS_CHAR
819: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_version_id%TYPE := FND_API.G_MISS_NUM
820: ,p_gen_src_all_plan_ver_code
821: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
822: ,p_gen_all_src_code
823: IN PA_PROJ_FP_OPTIONS.gen_all_src_code%TYPE := FND_API.G_MISS_CHAR
824: ,p_gen_all_etc_src_code
825: IN PA_PROJ_FP_OPTIONS.gen_all_etc_src_code%TYPE := FND_API.G_MISS_CHAR
826: ,p_gen_all_incl_change_doc_flag
827: IN PA_PROJ_FP_OPTIONS.gen_all_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
821: IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
822: ,p_gen_all_src_code
823: IN PA_PROJ_FP_OPTIONS.gen_all_src_code%TYPE := FND_API.G_MISS_CHAR
824: ,p_gen_all_etc_src_code
825: IN PA_PROJ_FP_OPTIONS.gen_all_etc_src_code%TYPE := FND_API.G_MISS_CHAR
826: ,p_gen_all_incl_change_doc_flag
827: IN PA_PROJ_FP_OPTIONS.gen_all_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
828: ,p_gen_all_incl_open_comm_flag
829: IN PA_PROJ_FP_OPTIONS.gen_all_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
823: IN PA_PROJ_FP_OPTIONS.gen_all_src_code%TYPE := FND_API.G_MISS_CHAR
824: ,p_gen_all_etc_src_code
825: IN PA_PROJ_FP_OPTIONS.gen_all_etc_src_code%TYPE := FND_API.G_MISS_CHAR
826: ,p_gen_all_incl_change_doc_flag
827: IN PA_PROJ_FP_OPTIONS.gen_all_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
828: ,p_gen_all_incl_open_comm_flag
829: IN PA_PROJ_FP_OPTIONS.gen_all_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
830: ,p_gen_all_ret_manual_line_flag
831: IN PA_PROJ_FP_OPTIONS.gen_all_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
825: IN PA_PROJ_FP_OPTIONS.gen_all_etc_src_code%TYPE := FND_API.G_MISS_CHAR
826: ,p_gen_all_incl_change_doc_flag
827: IN PA_PROJ_FP_OPTIONS.gen_all_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
828: ,p_gen_all_incl_open_comm_flag
829: IN PA_PROJ_FP_OPTIONS.gen_all_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
830: ,p_gen_all_ret_manual_line_flag
831: IN PA_PROJ_FP_OPTIONS.gen_all_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
832: ,p_gen_all_incl_bill_event_flag
833: IN PA_PROJ_FP_OPTIONS.gen_all_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
827: IN PA_PROJ_FP_OPTIONS.gen_all_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
828: ,p_gen_all_incl_open_comm_flag
829: IN PA_PROJ_FP_OPTIONS.gen_all_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
830: ,p_gen_all_ret_manual_line_flag
831: IN PA_PROJ_FP_OPTIONS.gen_all_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
832: ,p_gen_all_incl_bill_event_flag
833: IN PA_PROJ_FP_OPTIONS.gen_all_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
834: ,P_GN_ALL_INCL_UNSPENT_AMT_FLAG
835: IN PA_PROJ_FP_OPTIONS.gen_all_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
829: IN PA_PROJ_FP_OPTIONS.gen_all_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
830: ,p_gen_all_ret_manual_line_flag
831: IN PA_PROJ_FP_OPTIONS.gen_all_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
832: ,p_gen_all_incl_bill_event_flag
833: IN PA_PROJ_FP_OPTIONS.gen_all_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
834: ,P_GN_ALL_INCL_UNSPENT_AMT_FLAG
835: IN PA_PROJ_FP_OPTIONS.gen_all_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
836: ,P_GN_CST_ACTUAL_AMTS_THRU_CODE
837: IN PA_PROJ_FP_OPTIONS.gen_cost_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
831: IN PA_PROJ_FP_OPTIONS.gen_all_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
832: ,p_gen_all_incl_bill_event_flag
833: IN PA_PROJ_FP_OPTIONS.gen_all_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
834: ,P_GN_ALL_INCL_UNSPENT_AMT_FLAG
835: IN PA_PROJ_FP_OPTIONS.gen_all_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
836: ,P_GN_CST_ACTUAL_AMTS_THRU_CODE
837: IN PA_PROJ_FP_OPTIONS.gen_cost_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
838: ,P_GN_REV_ACTUAL_AMTS_THRU_CODE
839: IN PA_PROJ_FP_OPTIONS.gen_rev_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
833: IN PA_PROJ_FP_OPTIONS.gen_all_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
834: ,P_GN_ALL_INCL_UNSPENT_AMT_FLAG
835: IN PA_PROJ_FP_OPTIONS.gen_all_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
836: ,P_GN_CST_ACTUAL_AMTS_THRU_CODE
837: IN PA_PROJ_FP_OPTIONS.gen_cost_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
838: ,P_GN_REV_ACTUAL_AMTS_THRU_CODE
839: IN PA_PROJ_FP_OPTIONS.gen_rev_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
840: ,P_GN_ALL_ACTUAL_AMTS_THRU_CODE
841: IN PA_PROJ_FP_OPTIONS.gen_all_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
835: IN PA_PROJ_FP_OPTIONS.gen_all_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
836: ,P_GN_CST_ACTUAL_AMTS_THRU_CODE
837: IN PA_PROJ_FP_OPTIONS.gen_cost_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
838: ,P_GN_REV_ACTUAL_AMTS_THRU_CODE
839: IN PA_PROJ_FP_OPTIONS.gen_rev_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
840: ,P_GN_ALL_ACTUAL_AMTS_THRU_CODE
841: IN PA_PROJ_FP_OPTIONS.gen_all_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
842: ,p_track_workplan_costs_flag
843: IN PA_PROJ_FP_OPTIONS.track_workplan_costs_flag%TYPE := FND_API.G_MISS_CHAR
837: IN PA_PROJ_FP_OPTIONS.gen_cost_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
838: ,P_GN_REV_ACTUAL_AMTS_THRU_CODE
839: IN PA_PROJ_FP_OPTIONS.gen_rev_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
840: ,P_GN_ALL_ACTUAL_AMTS_THRU_CODE
841: IN PA_PROJ_FP_OPTIONS.gen_all_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
842: ,p_track_workplan_costs_flag
843: IN PA_PROJ_FP_OPTIONS.track_workplan_costs_flag%TYPE := FND_API.G_MISS_CHAR
844: -- bug 3519062 start of workplan gen source related columns
845: ,p_gen_src_cost_wp_version_id
839: IN PA_PROJ_FP_OPTIONS.gen_rev_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
840: ,P_GN_ALL_ACTUAL_AMTS_THRU_CODE
841: IN PA_PROJ_FP_OPTIONS.gen_all_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
842: ,p_track_workplan_costs_flag
843: IN PA_PROJ_FP_OPTIONS.track_workplan_costs_flag%TYPE := FND_API.G_MISS_CHAR
844: -- bug 3519062 start of workplan gen source related columns
845: ,p_gen_src_cost_wp_version_id
846: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_version_id%TYPE := FND_API.G_MISS_NUM
847: ,p_gen_src_cost_wp_ver_code
842: ,p_track_workplan_costs_flag
843: IN PA_PROJ_FP_OPTIONS.track_workplan_costs_flag%TYPE := FND_API.G_MISS_CHAR
844: -- bug 3519062 start of workplan gen source related columns
845: ,p_gen_src_cost_wp_version_id
846: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_version_id%TYPE := FND_API.G_MISS_NUM
847: ,p_gen_src_cost_wp_ver_code
848: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
849: ,p_gen_src_rev_wp_version_id
850: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_version_id%TYPE := FND_API.G_MISS_NUM
844: -- bug 3519062 start of workplan gen source related columns
845: ,p_gen_src_cost_wp_version_id
846: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_version_id%TYPE := FND_API.G_MISS_NUM
847: ,p_gen_src_cost_wp_ver_code
848: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
849: ,p_gen_src_rev_wp_version_id
850: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_version_id%TYPE := FND_API.G_MISS_NUM
851: ,p_gen_src_rev_wp_ver_code
852: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
846: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_version_id%TYPE := FND_API.G_MISS_NUM
847: ,p_gen_src_cost_wp_ver_code
848: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
849: ,p_gen_src_rev_wp_version_id
850: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_version_id%TYPE := FND_API.G_MISS_NUM
851: ,p_gen_src_rev_wp_ver_code
852: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
853: ,p_gen_src_all_wp_version_id
854: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_version_id%TYPE := FND_API.G_MISS_NUM
848: IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
849: ,p_gen_src_rev_wp_version_id
850: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_version_id%TYPE := FND_API.G_MISS_NUM
851: ,p_gen_src_rev_wp_ver_code
852: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
853: ,p_gen_src_all_wp_version_id
854: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_version_id%TYPE := FND_API.G_MISS_NUM
855: ,p_gen_src_all_wp_ver_code
856: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
850: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_version_id%TYPE := FND_API.G_MISS_NUM
851: ,p_gen_src_rev_wp_ver_code
852: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
853: ,p_gen_src_all_wp_version_id
854: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_version_id%TYPE := FND_API.G_MISS_NUM
855: ,p_gen_src_all_wp_ver_code
856: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
857: -- bug 3519062 end of workplan gen source related columns
858:
852: IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
853: ,p_gen_src_all_wp_version_id
854: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_version_id%TYPE := FND_API.G_MISS_NUM
855: ,p_gen_src_all_wp_ver_code
856: IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
857: -- bug 3519062 end of workplan gen source related columns
858:
859: --Added for webAdi changes for the amount types to be displayed
860: ,p_cost_layout_code
857: -- bug 3519062 end of workplan gen source related columns
858:
859: --Added for webAdi changes for the amount types to be displayed
860: ,p_cost_layout_code
861: IN PA_PROJ_FP_OPTIONS.cost_layout_code%TYPE := FND_API.G_MISS_CHAR
862: ,p_revenue_layout_code
863: IN PA_PROJ_FP_OPTIONS.revenue_layout_code%TYPE := FND_API.G_MISS_CHAR
864: ,p_all_layout_code
865: IN PA_PROJ_FP_OPTIONS.all_layout_code%TYPE := FND_API.G_MISS_CHAR
859: --Added for webAdi changes for the amount types to be displayed
860: ,p_cost_layout_code
861: IN PA_PROJ_FP_OPTIONS.cost_layout_code%TYPE := FND_API.G_MISS_CHAR
862: ,p_revenue_layout_code
863: IN PA_PROJ_FP_OPTIONS.revenue_layout_code%TYPE := FND_API.G_MISS_CHAR
864: ,p_all_layout_code
865: IN PA_PROJ_FP_OPTIONS.all_layout_code%TYPE := FND_API.G_MISS_CHAR
866: ,p_revenue_derivation_method
867: IN PA_PROJ_FP_OPTIONS.revenue_derivation_method%TYPE := FND_API.G_MISS_CHAR --Bug 5462471
861: IN PA_PROJ_FP_OPTIONS.cost_layout_code%TYPE := FND_API.G_MISS_CHAR
862: ,p_revenue_layout_code
863: IN PA_PROJ_FP_OPTIONS.revenue_layout_code%TYPE := FND_API.G_MISS_CHAR
864: ,p_all_layout_code
865: IN PA_PROJ_FP_OPTIONS.all_layout_code%TYPE := FND_API.G_MISS_CHAR
866: ,p_revenue_derivation_method
867: IN PA_PROJ_FP_OPTIONS.revenue_derivation_method%TYPE := FND_API.G_MISS_CHAR --Bug 5462471
868: ,p_row_id
869: IN ROWID := NULL
863: IN PA_PROJ_FP_OPTIONS.revenue_layout_code%TYPE := FND_API.G_MISS_CHAR
864: ,p_all_layout_code
865: IN PA_PROJ_FP_OPTIONS.all_layout_code%TYPE := FND_API.G_MISS_CHAR
866: ,p_revenue_derivation_method
867: IN PA_PROJ_FP_OPTIONS.revenue_derivation_method%TYPE := FND_API.G_MISS_CHAR --Bug 5462471
868: ,p_row_id
869: IN ROWID := NULL
870: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
871: IS
871: IS
872: BEGIN
873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875: UPDATE pa_proj_fp_options
876: SET
877: record_version_number = nvl(record_version_number,0) +1
878: ,project_id = DECODE( p_project_id, FND_API.G_MISS_NUM, project_id,
879: p_project_id)
1141: END IF;
1142: EXCEPTION
1143: WHEN OTHERS THEN
1144: FND_MSG_PUB.add_exc_msg( p_pkg_name
1145: => 'PA_PROJ_FP_OPTIONS_PKG'
1146: ,p_procedure_name
1147: => 'Update_Row');
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1149: RAISE;
1149: RAISE;
1150: END Update_Row;
1151:
1152: PROCEDURE Delete_Row
1153: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
1154: := FND_API.G_MISS_NUM
1155: ,p_record_version_number IN NUMBER
1156: := NULL
1157: ,p_row_id IN ROWID
1163:
1164: IF (p_proj_fp_options_id IS NOT NULL AND
1165: p_proj_fp_options_id <> FND_API.G_MISS_NUM) THEN
1166:
1167: DELETE FROM pa_proj_fp_options
1168: WHERE proj_fp_options_id = p_proj_fp_options_id
1169: AND nvl(p_record_version_number, nvl(record_version_number,0)) =
1170: nvl(record_version_number,0);
1171: ELSIF (p_row_id IS NOT NULL) THEN
1168: WHERE proj_fp_options_id = p_proj_fp_options_id
1169: AND nvl(p_record_version_number, nvl(record_version_number,0)) =
1170: nvl(record_version_number,0);
1171: ELSIF (p_row_id IS NOT NULL) THEN
1172: DELETE FROM pa_proj_fp_options
1173: WHERE rowid = p_row_id
1174: AND nvl(p_record_version_number, nvl(record_version_number,0)) =
1175: nvl(record_version_number,0);
1176: END IF;
1183:
1184: EXCEPTION
1185: WHEN OTHERS THEN
1186: FND_MSG_PUB.add_exc_msg( p_pkg_name
1187: => 'PA_PROJ_FP_OPTIONS_PKG'
1188: ,p_procedure_name
1189: => 'Delete_Row');
1190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1191: RAISE;
1191: RAISE;
1192: END Delete_Row;
1193:
1194: PROCEDURE Lock_Row
1195: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
1196: := FND_API.G_MISS_NUM
1197: ,p_record_version_number IN NUMBER
1198: := NULL
1199: ,p_row_id IN ROWID
1204: BEGIN
1205: x_return_status := FND_API.G_RET_STS_SUCCESS;
1206:
1207: SELECT rowid into l_row_id
1208: FROM pa_proj_fp_options
1209: WHERE proj_fp_options_id = p_proj_fp_options_id
1210: OR rowid = p_row_id
1211: FOR UPDATE NOWAIT;
1212:
1212:
1213: EXCEPTION
1214: WHEN OTHERS THEN
1215: FND_MSG_PUB.add_exc_msg( p_pkg_name
1216: => 'PA_PROJ_FP_OPTIONS_PKG'
1217: ,p_procedure_name
1218: => 'Lock_Row');
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: RAISE;
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: RAISE;
1221: END Lock_Row;
1222:
1223: END pa_proj_fp_options_pkg;