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_FP_VIEW_PLANS_TXN_PUB dependencies on PA_BUDGET_VERSIONS

Line 50: G_COST_RECORD_VERSION_NUM pa_budget_versions.record_version_number%TYPE;

46: -- 'BOTH' = COST_AND_REV_SEP
47: -- 'ANY' = 'COST_AND_REV_SAME'
48: G_COST_VERSION_GROUPING VARCHAR2(30); -- used in VO Decode for resource/resource group
49: G_REV_VERSION_GROUPING VARCHAR2(30); -- used in VO Decode for resource/resource group
50: G_COST_RECORD_VERSION_NUM pa_budget_versions.record_version_number%TYPE;
51: G_REV_RECORD_VERSION_NUM pa_budget_versions.record_version_number%TYPE;
52: G_DISPLAY_CURRENCY_TYPE VARCHAR2(30); -- 'PROJECT' or 'PROJFUNC' currency
53:
54: function Get_Multicurrency_Flag return VARCHAR2;

Line 51: G_REV_RECORD_VERSION_NUM pa_budget_versions.record_version_number%TYPE;

47: -- 'ANY' = 'COST_AND_REV_SAME'
48: G_COST_VERSION_GROUPING VARCHAR2(30); -- used in VO Decode for resource/resource group
49: G_REV_VERSION_GROUPING VARCHAR2(30); -- used in VO Decode for resource/resource group
50: G_COST_RECORD_VERSION_NUM pa_budget_versions.record_version_number%TYPE;
51: G_REV_RECORD_VERSION_NUM pa_budget_versions.record_version_number%TYPE;
52: G_DISPLAY_CURRENCY_TYPE VARCHAR2(30); -- 'PROJECT' or 'PROJFUNC' currency
53:
54: function Get_Multicurrency_Flag return VARCHAR2;
55: function Get_Plan_Type_Id return NUMBER;

Line 82: (p_project_id IN pa_budget_versions.project_id%TYPE,

78: function get_resource_name
79: (p_resource_id IN pa_resources.resource_id%TYPE) return VARCHAR2;
80:
81: procedure nonhgrid_view_initialize
82: (p_project_id IN pa_budget_versions.project_id%TYPE,
83: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
84: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
85: p_user_id IN NUMBER,
86: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,

Line 83: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

79: (p_resource_id IN pa_resources.resource_id%TYPE) return VARCHAR2;
80:
81: procedure nonhgrid_view_initialize
82: (p_project_id IN pa_budget_versions.project_id%TYPE,
83: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
84: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
85: p_user_id IN NUMBER,
86: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
87: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

Line 84: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,

80:
81: procedure nonhgrid_view_initialize
82: (p_project_id IN pa_budget_versions.project_id%TYPE,
83: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
84: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
85: p_user_id IN NUMBER,
86: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
87: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
88: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

Line 86: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,

82: (p_project_id IN pa_budget_versions.project_id%TYPE,
83: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
84: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
85: p_user_id IN NUMBER,
86: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
87: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
88: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
89: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
90: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 87: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

83: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
84: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
85: p_user_id IN NUMBER,
86: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
87: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
88: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
89: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
90: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
91: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

Line 88: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

84: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
85: p_user_id IN NUMBER,
86: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
87: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
88: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
89: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
90: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
91: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
92: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

Line 89: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

85: p_user_id IN NUMBER,
86: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
87: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
88: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
89: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
90: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
91: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
92: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
93: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,

Line 90: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

86: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
87: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
88: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
89: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
90: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
91: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
92: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
93: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
94: -- x_rev_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,

Line 91: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

87: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
88: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
89: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
90: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
91: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
92: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
93: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
94: -- x_rev_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
95: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 92: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

88: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
89: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
90: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
91: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
92: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
93: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
94: -- x_rev_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
95: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
96: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895

Line 93: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,

89: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
90: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
91: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
92: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
93: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
94: -- x_rev_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
95: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
96: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
97: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895

Line 94: -- x_rev_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,

90: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
91: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
92: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
93: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
94: -- x_rev_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
95: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
96: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
97: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895
98: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895

Line 103: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895

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

Line 104: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895

100: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
101: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
102: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
103: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
104: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
105: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
106: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
107: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
108: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895

Line 119: (p_project_id IN pa_budget_versions.project_id%TYPE,

115: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
116: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
117: );
118: procedure nonhgrid_edit_initialize
119: (p_project_id IN pa_budget_versions.project_id%TYPE,
120: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
121: -- p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,
122: -- p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
123: -- p_working_or_baselined IN VARCHAR2,

Line 120: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

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

Line 125: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

121: -- p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,
122: -- p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
123: -- p_working_or_baselined IN VARCHAR2,
124: -- p_cost_or_revenue IN VARCHAR2,
125: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
126: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895
127: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
128: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
129: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

Line 126: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895

122: -- p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
123: -- p_working_or_baselined IN VARCHAR2,
124: -- p_cost_or_revenue IN VARCHAR2,
125: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
126: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895
127: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
128: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
129: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
130: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

Line 127: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

123: -- p_working_or_baselined IN VARCHAR2,
124: -- p_cost_or_revenue IN VARCHAR2,
125: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
126: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895
127: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
128: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
129: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
130: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
131: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 128: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

124: -- p_cost_or_revenue IN VARCHAR2,
125: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
126: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895
127: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
128: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
129: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
130: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
131: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
132: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895

Line 129: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

125: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
126: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895
127: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
128: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
129: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
130: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
131: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
132: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
133: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895

Line 130: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

126: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895
127: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
128: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
129: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
130: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
131: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
132: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
133: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895
134: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895

Line 138: x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895

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

Line 154: p_project_id IN pa_budget_versions.project_id%TYPE,

150: );
151:
152: procedure view_plans_txn_populate_tmp
153: (p_page_mode IN VARCHAR2, /* V - View mode ; E - Edit Mode */
154: p_project_id IN pa_budget_versions.project_id%TYPE,
155: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
156: p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE,
157: p_both_version_id IN pa_budget_versions.budget_version_id%TYPE,
158: p_project_currency IN pa_projects_all.project_currency_code%TYPE,

Line 155: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

151:
152: procedure view_plans_txn_populate_tmp
153: (p_page_mode IN VARCHAR2, /* V - View mode ; E - Edit Mode */
154: p_project_id IN pa_budget_versions.project_id%TYPE,
155: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
156: p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE,
157: p_both_version_id IN pa_budget_versions.budget_version_id%TYPE,
158: p_project_currency IN pa_projects_all.project_currency_code%TYPE,
159: p_get_display_from IN VARCHAR2, -- 'COST', 'REVENUE', 'BOTH', 'ANY'

Line 156: p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE,

152: procedure view_plans_txn_populate_tmp
153: (p_page_mode IN VARCHAR2, /* V - View mode ; E - Edit Mode */
154: p_project_id IN pa_budget_versions.project_id%TYPE,
155: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
156: p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE,
157: p_both_version_id IN pa_budget_versions.budget_version_id%TYPE,
158: p_project_currency IN pa_projects_all.project_currency_code%TYPE,
159: p_get_display_from IN VARCHAR2, -- 'COST', 'REVENUE', 'BOTH', 'ANY'
160: p_filter_task_id IN pa_resource_assignments.task_id%TYPE,

Line 157: p_both_version_id IN pa_budget_versions.budget_version_id%TYPE,

153: (p_page_mode IN VARCHAR2, /* V - View mode ; E - Edit Mode */
154: p_project_id IN pa_budget_versions.project_id%TYPE,
155: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
156: p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE,
157: p_both_version_id IN pa_budget_versions.budget_version_id%TYPE,
158: p_project_currency IN pa_projects_all.project_currency_code%TYPE,
159: p_get_display_from IN VARCHAR2, -- 'COST', 'REVENUE', 'BOTH', 'ANY'
160: p_filter_task_id IN pa_resource_assignments.task_id%TYPE,
161: p_filter_resource_id IN pa_resource_list_members.resource_id%TYPE,

Line 171: (p_project_id IN pa_budget_versions.project_id%TYPE,

167:
168: ----------- BEGIN OF CHANGE ORDER / CONTROL ITEM -------------
169:
170: procedure nonhgrid_view_initialize_ci
171: (p_project_id IN pa_budget_versions.project_id%TYPE,
172: p_ci_id IN pa_budget_versions.ci_id%TYPE,
173: p_user_id IN NUMBER,
174: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
175: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 172: p_ci_id IN pa_budget_versions.ci_id%TYPE,

168: ----------- BEGIN OF CHANGE ORDER / CONTROL ITEM -------------
169:
170: procedure nonhgrid_view_initialize_ci
171: (p_project_id IN pa_budget_versions.project_id%TYPE,
172: p_ci_id IN pa_budget_versions.ci_id%TYPE,
173: p_user_id IN NUMBER,
174: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
175: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
176: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 174: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

170: procedure nonhgrid_view_initialize_ci
171: (p_project_id IN pa_budget_versions.project_id%TYPE,
172: p_ci_id IN pa_budget_versions.ci_id%TYPE,
173: p_user_id IN NUMBER,
174: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
175: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
176: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
177: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
178: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

Line 175: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

171: (p_project_id IN pa_budget_versions.project_id%TYPE,
172: p_ci_id IN pa_budget_versions.ci_id%TYPE,
173: p_user_id IN NUMBER,
174: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
175: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
176: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
177: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
178: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
179: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 176: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

172: p_ci_id IN pa_budget_versions.ci_id%TYPE,
173: p_user_id IN NUMBER,
174: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
175: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
176: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
177: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
178: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
179: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
180: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895

Line 177: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

173: p_user_id IN NUMBER,
174: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
175: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
176: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
177: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
178: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
179: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
180: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
181: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895

Line 178: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

174: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
175: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
176: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
177: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
178: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
179: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
180: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
181: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895
182: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895

Line 187: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895

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

Line 188: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895

184: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
185: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
186: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
187: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
188: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
189: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
190: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
191: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
192: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895

Line 203: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

199: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
200: );
201:
202: procedure calculate_amounts_for_version
203: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
204: ,p_calling_context IN VARCHAR2
205: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
206: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
207: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895