DBA Data[Home] [Help]

APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_PROJ_PERIODS_DENORM

Line 64: x_default_amount_type_code OUT NOCOPY pa_proj_periods_denorm.amount_type_code%TYPE, --File.Sql.39 bug 4440895

60: return VARCHAR2;
61:
62: procedure assign_default_amount
63: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
64: x_default_amount_type_code OUT NOCOPY pa_proj_periods_denorm.amount_type_code%TYPE, --File.Sql.39 bug 4440895
65: x_default_amount_subtype_code OUT NOCOPY pa_proj_periods_denorm.amount_subtype_code%TYPE, --File.Sql.39 bug 4440895
66: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
67: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
68: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 65: x_default_amount_subtype_code OUT NOCOPY pa_proj_periods_denorm.amount_subtype_code%TYPE, --File.Sql.39 bug 4440895

61:
62: procedure assign_default_amount
63: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
64: x_default_amount_type_code OUT NOCOPY pa_proj_periods_denorm.amount_type_code%TYPE, --File.Sql.39 bug 4440895
65: x_default_amount_subtype_code OUT NOCOPY pa_proj_periods_denorm.amount_subtype_code%TYPE, --File.Sql.39 bug 4440895
66: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
67: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
68: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
69:

Line 73: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,

69:
70: function get_period_n_value
71: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
72: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
73: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
74: p_project_currency_type IN VARCHAR2,
75: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
76: p_period_number IN NUMBER) return NUMBER;
77:

Line 75: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,

71: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
72: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
73: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
74: p_project_currency_type IN VARCHAR2,
75: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
76: p_period_number IN NUMBER) return NUMBER;
77:
78: function calc_margin_percent
79: (p_cost_value IN NUMBER,