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

Line 77: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

73: );
74: */
75:
76: PROCEDURE VALIDATE_TXN_CURRENCY_CODE
77: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
78: ,p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
79: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
80: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
81: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 86: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

82: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
83: );
84: /* Bug 5350437: Commented the below API
85: PROCEDURE GET_VERSION_PERIODS_INFO
86: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
87: ,x_period_name_tbl OUT NOCOPY pa_fp_webadi_pkg.l_period_name_tbl_typ --File.Sql.39 bug 4440895
88: ,x_start_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_start_date_tbl_typ --File.Sql.39 bug 4440895
89: ,x_end_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_end_date_tbl_typ --File.Sql.39 bug 4440895
90: ,x_number_of_pds OUT NOCOPY pa_proj_period_profiles.number_of_periods%TYPE --File.Sql.39 bug 4440895

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

87: ,x_period_name_tbl OUT NOCOPY pa_fp_webadi_pkg.l_period_name_tbl_typ --File.Sql.39 bug 4440895
88: ,x_start_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_start_date_tbl_typ --File.Sql.39 bug 4440895
89: ,x_end_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_end_date_tbl_typ --File.Sql.39 bug 4440895
90: ,x_number_of_pds OUT NOCOPY pa_proj_period_profiles.number_of_periods%TYPE --File.Sql.39 bug 4440895
91: ,x_period_profile_id OUT NOCOPY pa_budget_versions.period_profile_id%TYPE --File.Sql.39 bug 4440895
92: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
93: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
94: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95: ) ;

Line 99: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

95: ) ;
96: */
97:
98: PROCEDURE CHECK_OVERLAPPING_DATES
99: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
100: ,x_rec_failed_validation OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
101: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
102: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
103: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 167: (p_request_id IN pa_budget_versions.request_id%TYPE,

163: -- This api would be called from a java method when the user wants to delete the data from the excel interface
164: -- that is downloaded for a session.
165:
166: PROCEDURE delete_interface_tbl_data
167: (p_request_id IN pa_budget_versions.request_id%TYPE,
168: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
169: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
170: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
171:

Line 176: (p_old_request_id IN pa_budget_versions.request_id%TYPE,

172: -- This api would be called from a java method when the user wants to resubmit the request for the concurrent
173: -- program, if the upload processing of the plan version fails for some reason.
174:
175: PROCEDURE resubmit_conc_request
176: (p_old_request_id IN pa_budget_versions.request_id%TYPE,
177: x_new_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE, --File.Sql.39 bug 4440895
178: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
179: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
180: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

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

173: -- program, if the upload processing of the plan version fails for some reason.
174:
175: PROCEDURE resubmit_conc_request
176: (p_old_request_id IN pa_budget_versions.request_id%TYPE,
177: x_new_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE, --File.Sql.39 bug 4440895
178: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
179: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
180: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
181: