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

APPS.PA_FIN_PLAN_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 61: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

57:
58:
59:
60: FUNCTION Get_Resource_List_Id (
61: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
62: RETURN pa_proj_fp_options.all_resource_list_id%TYPE;
63: --PRAGMA RESTRICT_REFERENCES ( Get_Resource_List_Id, WNDS, WNPS);
64:
65: FUNCTION Get_Time_Phased_code (

Line 62: RETURN pa_proj_fp_options.all_resource_list_id%TYPE;

58:
59:
60: FUNCTION Get_Resource_List_Id (
61: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
62: RETURN pa_proj_fp_options.all_resource_list_id%TYPE;
63: --PRAGMA RESTRICT_REFERENCES ( Get_Resource_List_Id, WNDS, WNPS);
64:
65: FUNCTION Get_Time_Phased_code (
66: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

Line 66: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

62: RETURN pa_proj_fp_options.all_resource_list_id%TYPE;
63: --PRAGMA RESTRICT_REFERENCES ( Get_Resource_List_Id, WNDS, WNPS);
64:
65: FUNCTION Get_Time_Phased_code (
66: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
67: RETURN pa_proj_fp_options.all_time_phased_code%TYPE;
68: --PRAGMA RESTRICT_REFERENCES ( Get_Time_Phased_code , WNDS, WNPS);
69:
70: FUNCTION Get_Multi_Curr_Flag(

Line 67: RETURN pa_proj_fp_options.all_time_phased_code%TYPE;

63: --PRAGMA RESTRICT_REFERENCES ( Get_Resource_List_Id, WNDS, WNPS);
64:
65: FUNCTION Get_Time_Phased_code (
66: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
67: RETURN pa_proj_fp_options.all_time_phased_code%TYPE;
68: --PRAGMA RESTRICT_REFERENCES ( Get_Time_Phased_code , WNDS, WNPS);
69:
70: FUNCTION Get_Multi_Curr_Flag(
71: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

Line 71: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

67: RETURN pa_proj_fp_options.all_time_phased_code%TYPE;
68: --PRAGMA RESTRICT_REFERENCES ( Get_Time_Phased_code , WNDS, WNPS);
69:
70: FUNCTION Get_Multi_Curr_Flag(
71: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
72: RETURN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
73:
74: FUNCTION Get_Fin_Plan_Level_Code(
75: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

Line 72: RETURN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

68: --PRAGMA RESTRICT_REFERENCES ( Get_Time_Phased_code , WNDS, WNPS);
69:
70: FUNCTION Get_Multi_Curr_Flag(
71: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
72: RETURN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
73:
74: FUNCTION Get_Fin_Plan_Level_Code(
75: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
76: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 75: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

71: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
72: RETURN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
73:
74: FUNCTION Get_Fin_Plan_Level_Code(
75: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
76: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;
77: --PRAGMA RESTRICT_REFERENCES ( Get_Fin_Plan_Level_Code, WNDS, WNPS);
78:
79: FUNCTION Get_Amount_Set_Id(

Line 76: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;

72: RETURN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
73:
74: FUNCTION Get_Fin_Plan_Level_Code(
75: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
76: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;
77: --PRAGMA RESTRICT_REFERENCES ( Get_Fin_Plan_Level_Code, WNDS, WNPS);
78:
79: FUNCTION Get_Amount_Set_Id(
80: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

Line 80: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

76: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;
77: --PRAGMA RESTRICT_REFERENCES ( Get_Fin_Plan_Level_Code, WNDS, WNPS);
78:
79: FUNCTION Get_Amount_Set_Id(
80: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
81: RETURN pa_proj_fp_options.all_amount_set_id%TYPE;
82: --PRAGMA RESTRICT_REFERENCES ( Get_Amount_Set_Id, WNDS, WNPS);
83:
84: FUNCTION Get_Period_Profile_Start_Date

Line 81: RETURN pa_proj_fp_options.all_amount_set_id%TYPE;

77: --PRAGMA RESTRICT_REFERENCES ( Get_Fin_Plan_Level_Code, WNDS, WNPS);
78:
79: FUNCTION Get_Amount_Set_Id(
80: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
81: RETURN pa_proj_fp_options.all_amount_set_id%TYPE;
82: --PRAGMA RESTRICT_REFERENCES ( Get_Amount_Set_Id, WNDS, WNPS);
83:
84: FUNCTION Get_Period_Profile_Start_Date
85: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)

Line 117: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

113:
114:
115: PROCEDURE Get_Appr_Cost_Plan_Type_Info(
116: p_project_id IN pa_projects_all.project_id%TYPE
117: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
118: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
119: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
120: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
121:

Line 124: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

120: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
121:
122: PROCEDURE Get_Appr_Rev_Plan_Type_Info(
123: p_project_id IN pa_projects_all.project_id%TYPE
124: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
125: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
126: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
127: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
128:

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

129: PROCEDURE Get_Baselined_Version_Info(
130: p_project_id IN pa_projects_all.project_id%TYPE
131: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
132: ,p_version_type IN pa_budget_versions.version_type%TYPE
133: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
134: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
135: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
136: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
137: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 134: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895

130: p_project_id IN pa_projects_all.project_id%TYPE
131: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
132: ,p_version_type IN pa_budget_versions.version_type%TYPE
133: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
134: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
135: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
136: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
137: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
138:

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

155: PROCEDURE Get_Curr_Working_Version_Info(
156: p_project_id IN pa_projects_all.project_id%TYPE
157: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
158: ,p_version_type IN pa_budget_versions.version_type%TYPE
159: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
160: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
161: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
162: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
163: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 160: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895

156: p_project_id IN pa_projects_all.project_id%TYPE
157: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
158: ,p_version_type IN pa_budget_versions.version_type%TYPE
159: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
160: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
161: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
162: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
163: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
164:

Line 173: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,

169: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
170: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
171: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,
172: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,
173: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
174: /* Changes for FP.M, Tracking Bug No - 3354518
175: Adding three new IN parameters p_bill_rate_flag,
176: p_cost_rate_flag, p_burden_rate below for
177: new columns in pa_fin_plan_amount_sets */

Line 218: P_PROJ_FP_OPTIONS_ID IN pa_proj_fp_options.proj_fp_options_id%TYPE,

214: Modifying the type of the IN parameter p_element_type
215: below as pa_fp_elements is being obsoleted. */
216: /*
217: FUNCTION GET_OPTION_PLANNING_LEVEL(
218: P_PROJ_FP_OPTIONS_ID IN pa_proj_fp_options.proj_fp_options_id%TYPE,
219: P_ELEMENT_TYPE IN pa_fp_elements.element_type%TYPE)
220: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;
221: */
222: FUNCTION GET_OPTION_PLANNING_LEVEL(

Line 220: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;

216: /*
217: FUNCTION GET_OPTION_PLANNING_LEVEL(
218: P_PROJ_FP_OPTIONS_ID IN pa_proj_fp_options.proj_fp_options_id%TYPE,
219: P_ELEMENT_TYPE IN pa_fp_elements.element_type%TYPE)
220: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;
221: */
222: FUNCTION GET_OPTION_PLANNING_LEVEL(
223: P_PROJ_FP_OPTIONS_ID IN pa_proj_fp_options.proj_fp_options_id%TYPE,
224: P_ELEMENT_TYPE IN pa_budget_versions.version_type%TYPE)

Line 223: P_PROJ_FP_OPTIONS_ID IN pa_proj_fp_options.proj_fp_options_id%TYPE,

219: P_ELEMENT_TYPE IN pa_fp_elements.element_type%TYPE)
220: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;
221: */
222: FUNCTION GET_OPTION_PLANNING_LEVEL(
223: P_PROJ_FP_OPTIONS_ID IN pa_proj_fp_options.proj_fp_options_id%TYPE,
224: P_ELEMENT_TYPE IN pa_budget_versions.version_type%TYPE)
225: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;
226:
227:

Line 225: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;

221: */
222: FUNCTION GET_OPTION_PLANNING_LEVEL(
223: P_PROJ_FP_OPTIONS_ID IN pa_proj_fp_options.proj_fp_options_id%TYPE,
224: P_ELEMENT_TYPE IN pa_budget_versions.version_type%TYPE)
225: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;
226:
227:
228: FUNCTION get_person_name
229: (p_person_id IN NUMBER) return VARCHAR2;

Line 340: (p_project_id IN pa_proj_fp_options.project_id%TYPE)

336: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
337: x_error_msg OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
338:
339: FUNCTION check_proj_fp_options_exists
340: (p_project_id IN pa_proj_fp_options.project_id%TYPE)
341: return NUMBER;
342:
343: FUNCTION get_amttype_id
344: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE) RETURN NUMBER;

Line 412: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

408: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
409:
410: PROCEDURE Is_AC_PT_Attached_After_UPG(
411: p_project_id IN pa_projects_all.project_id%TYPE
412: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
413: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
414: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
415: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
416:

Line 419: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

415: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
416:
417: PROCEDURE Is_AR_PT_Attached_After_UPG(
418: p_project_id IN pa_projects_all.project_id%TYPE
419: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
420: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
421: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
422: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
423:

Line 437: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE;

433: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
434: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
435:
436: FUNCTION get_period_start_date (p_input_date IN pa_periods_all.start_date%TYPE,
437: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE;
438:
439: FUNCTION get_period_end_date (p_input_date IN pa_periods_all.end_date%TYPE,
440: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE;
441: /*==============================================================================

Line 440: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE;

436: FUNCTION get_period_start_date (p_input_date IN pa_periods_all.start_date%TYPE,
437: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE;
438:
439: FUNCTION get_period_end_date (p_input_date IN pa_periods_all.end_date%TYPE,
440: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE;
441: /*==============================================================================
442: This api returns the current baselined version for a given project and
443: budget_type_code or fin_plan_type combination.
444: 1)If the plan type is COST_AND_REV_SAME, then it returns 'ALL' version

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

551: ,p_quantity_type IN VARCHAR2
552: ,p_ci_id IN NUMBER DEFAULT NULL) RETURN pa_budget_lines.quantity%TYPE;
553:
554: PROCEDURE VALIDATE_CURRENCY_ATTRIBUTES
555: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
556: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
557: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
558: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
559: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

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

552: ,p_ci_id IN NUMBER DEFAULT NULL) RETURN pa_budget_lines.quantity%TYPE;
553:
554: PROCEDURE VALIDATE_CURRENCY_ATTRIBUTES
555: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
556: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
557: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
558: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
559: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
560: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

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

553:
554: PROCEDURE VALIDATE_CURRENCY_ATTRIBUTES
555: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
556: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
557: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
558: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
559: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
560: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
561: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895

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

555: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
556: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
557: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
558: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
559: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
560: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
561: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
562: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
563: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895

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

556: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
557: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
558: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
559: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
560: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
561: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
562: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
563: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
564: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

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

557: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
558: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
559: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
560: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
561: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
562: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
563: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
564: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
565: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895

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

559: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
560: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
561: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
562: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
563: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
564: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
565: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
566: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
567: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895

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

560: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
561: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
562: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
563: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
564: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
565: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
566: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
567: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
568: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

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

561: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
562: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
563: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
564: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
565: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
566: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
567: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
568: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
569: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895

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

563: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
564: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
565: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
566: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
567: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
568: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
569: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
570: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
571: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE

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

564: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
565: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
566: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
567: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
568: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
569: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
570: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
571: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
572: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

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

565: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
566: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
567: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
568: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
569: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
570: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
571: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
572: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
573: ,p_txn_currency_code IN pa_projects_all.projfunc_currency_code%TYPE DEFAULT NULL

Line 581: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

577: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
578: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
579:
580: PROCEDURE VALIDATE_CONV_ATTRIBUTES
581: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
582: ,px_rate_date_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
583: ,px_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
584: ,px_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
585: ,p_amount_type_code IN VARCHAR2

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

578: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
579:
580: PROCEDURE VALIDATE_CONV_ATTRIBUTES
581: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
582: ,px_rate_date_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
583: ,px_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
584: ,px_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
585: ,p_amount_type_code IN VARCHAR2
586: ,p_currency_type_code IN VARCHAR2

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

579:
580: PROCEDURE VALIDATE_CONV_ATTRIBUTES
581: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
582: ,px_rate_date_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
583: ,px_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
584: ,px_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
585: ,p_amount_type_code IN VARCHAR2
586: ,p_currency_type_code IN VARCHAR2
587: ,p_calling_context IN VARCHAR2

Line 596: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE

592: ) ;
593:
594: PROCEDURE GET_PLAN_TYPE_OPTS_FOR_VER
595: (
596: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
597: ,x_fin_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
598: ,x_plan_type_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
599: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
600: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 597: ,x_fin_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

593:
594: PROCEDURE GET_PLAN_TYPE_OPTS_FOR_VER
595: (
596: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
597: ,x_fin_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
598: ,x_plan_type_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
599: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
600: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
601: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

594: PROCEDURE GET_PLAN_TYPE_OPTS_FOR_VER
595: (
596: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
597: ,x_fin_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
598: ,x_plan_type_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
599: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
600: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
601: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
602: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 644: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE

640: -- This procedure is used to derive the version type given the project id and
641: -- fin plan type id
642: PROCEDURE get_version_type
643: ( p_project_id IN pa_projects_all.project_id%TYPE
644: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
645: ,px_version_type IN OUT NOCOPY pa_budget_Versions.version_type%TYPE --File.Sql.39 bug 4440895
646: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
647: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
648: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 653: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE

649: );
650:
651: PROCEDURE get_version_id
652: ( p_project_id IN pa_projects_all.project_id%TYPE
653: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
654: ,p_version_type IN pa_budget_Versions.version_type%TYPE
655: ,p_version_number IN pa_budget_Versions.version_number%TYPE
656: ,x_budget_version_id OUT NOCOPY pa_budget_Versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
657: ,x_ci_id OUT NOCOPY pa_budget_Versions.ci_id%TYPE --File.Sql.39 bug 4440895

Line 760: , p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE

756: FUNCTION Get_Budgeted_Amount
757: (
758: p_project_id IN pa_projects_all.project_id%TYPE
759: , p_task_id IN pa_tasks.task_id%TYPE
760: , p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
761: , p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
762: , p_amount_type IN VARCHAR2
763: )
764: RETURN NUMBER ;

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

787: PROCEDURE Get_Curr_Original_Version_Info(
788: p_project_id IN pa_projects_all.project_id%TYPE
789: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
790: ,p_version_type IN pa_budget_versions.version_type%TYPE
791: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
792: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
793: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
794: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
795: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 792: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895

788: p_project_id IN pa_projects_all.project_id%TYPE
789: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
790: ,p_version_type IN pa_budget_versions.version_type%TYPE
791: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
792: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
793: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
794: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
795: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
796:

Line 854: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

850: ==============================================================================*/
851:
852: PROCEDURE IS_PRI_FCST_COST_PT_ATTACHED(
853: p_project_id IN pa_projects_all.project_id%TYPE
854: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
855: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
856: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
857: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
858:

Line 867: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

863: ==============================================================================*/
864:
865: PROCEDURE IS_PRI_FCST_REV_PT_ATTACHED(
866: p_project_id IN pa_projects_all.project_id%TYPE
867: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
868: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
869: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
870: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
871:

Line 921: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code of cost version - Bug 3734840 --File.Sql.39 bug 4440895

917: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
918: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
919: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895
920: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895
921: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code of cost version - Bug 3734840 --File.Sql.39 bug 4440895
922: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
923: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
924: ,X_msg_count OUT NOCOPY NUMBER); -- Indicates the number of error messages --File.Sql.39 bug 4440895
925:

Line 948: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code - Bug 3734840 --File.Sql.39 bug 4440895

944: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
945: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
946: ,X_margin OUT NOCOPY Number -- Margin --File.Sql.39 bug 4440895
947: ,X_margin_percent OUT NOCOPY Number -- Margin percent --File.Sql.39 bug 4440895
948: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code - Bug 3734840 --File.Sql.39 bug 4440895
949: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
950: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
951: ,X_msg_count OUT NOCOPY NUMBER); -- Indicates the number of error messages --File.Sql.39 bug 4440895
952:

Line 1069: ,p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE

1065:
1066: FUNCTION Is_source_for_gen_options
1067: (p_project_id IN pa_projects_all.project_id%TYPE
1068: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
1069: ,p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
1070: ) RETURN VARCHAR2;
1071:
1072:
1073: /* bug 4494740: the following global variable added so that they

Line 1079: g_fp_wa_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

1075: */
1076:
1077: g_fp_wa_struct_ver_id pa_proj_element_versions.parent_structure_version_id%TYPE;
1078: g_fp_wa_struct_status_flag VARCHAR2(1);
1079: g_fp_wa_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
1080:
1081: TYPE fp_wa_task_pc_compl_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1082:
1083: g_fp_wa_task_pc_compl_tbl fp_wa_task_pc_compl_tab;

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

1167: /*Parameters due fin plan model */
1168: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1169: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1170: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1171: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1172: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1173: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1174: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1175: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1168: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1169: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1170: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1171: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1172: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1173: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1174: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1175: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1176: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

1169: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1170: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1171: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1172: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1173: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1174: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1175: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1176: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1177: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1170: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1171: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1172: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1173: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1174: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1175: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1176: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1177: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1178: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1171: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1172: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1173: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1174: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1175: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1176: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1177: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1178: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1179: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

1172: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1173: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1174: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1175: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1176: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1177: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1178: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1179: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1180: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1173: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1174: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1175: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1176: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1177: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1178: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1179: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1180: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1181: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1174: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1175: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1176: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1177: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1178: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1179: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1180: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1181: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1182: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

1175: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1176: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1177: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1178: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1179: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1180: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1181: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1182: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1183: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1176: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1177: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1178: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1179: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1180: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1181: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1182: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1183: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1184: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1177: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1178: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1179: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1180: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1181: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1182: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1183: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1184: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1185: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

1178: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1179: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1180: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1181: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1182: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1183: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1184: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1185: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1186: ,p_raw_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1179: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1180: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1181: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1182: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1183: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1184: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1185: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1186: ,p_raw_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1187: ,p_burdened_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1180: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1181: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1182: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1183: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1184: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1185: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1186: ,p_raw_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1187: ,p_burdened_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1188: ,p_revenue_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1181: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1182: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1183: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1184: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1185: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1186: ,p_raw_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1187: ,p_burdened_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1188: ,p_revenue_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1189: ,p_cost_qty_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR