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_PKG dependencies on PA_FP_WEBADI_XFACE_TMP

Line 147: --Cursor based on Global Temporay Table pa_fp_webadi_xface_tmp.

143: g_fp_webadi_rec_tbl G_FP_WEBADI_GLOBAL := G_FP_WEBADI_GLOBAL();
144:
145: /* Start of changes done for Bug : 4584865*/
146:
147: --Cursor based on Global Temporay Table pa_fp_webadi_xface_tmp.
148: CURSOR global_tmp_cur
149: IS
150: SELECT * FROM pa_fp_webadi_xface_tmp;
151: --Record based on Global Temporay Table pa_fp_webadi_xface_tmp.

Line 150: SELECT * FROM pa_fp_webadi_xface_tmp;

146:
147: --Cursor based on Global Temporay Table pa_fp_webadi_xface_tmp.
148: CURSOR global_tmp_cur
149: IS
150: SELECT * FROM pa_fp_webadi_xface_tmp;
151: --Record based on Global Temporay Table pa_fp_webadi_xface_tmp.
152: -- l_global_tmp_rec pa_fp_webadi_xface_tmp%ROWTYPE; --Bug 5284640.
153: --Table based on Cursor global_tmp_cur.
154: TYPE global_tmp_tbl IS TABLE OF global_tmp_cur%ROWTYPE;

Line 151: --Record based on Global Temporay Table pa_fp_webadi_xface_tmp.

147: --Cursor based on Global Temporay Table pa_fp_webadi_xface_tmp.
148: CURSOR global_tmp_cur
149: IS
150: SELECT * FROM pa_fp_webadi_xface_tmp;
151: --Record based on Global Temporay Table pa_fp_webadi_xface_tmp.
152: -- l_global_tmp_rec pa_fp_webadi_xface_tmp%ROWTYPE; --Bug 5284640.
153: --Table based on Cursor global_tmp_cur.
154: TYPE global_tmp_tbl IS TABLE OF global_tmp_cur%ROWTYPE;
155: l_global_tmp_tbl global_tmp_tbl;

Line 152: -- l_global_tmp_rec pa_fp_webadi_xface_tmp%ROWTYPE; --Bug 5284640.

148: CURSOR global_tmp_cur
149: IS
150: SELECT * FROM pa_fp_webadi_xface_tmp;
151: --Record based on Global Temporay Table pa_fp_webadi_xface_tmp.
152: -- l_global_tmp_rec pa_fp_webadi_xface_tmp%ROWTYPE; --Bug 5284640.
153: --Table based on Cursor global_tmp_cur.
154: TYPE global_tmp_tbl IS TABLE OF global_tmp_cur%ROWTYPE;
155: l_global_tmp_tbl global_tmp_tbl;
156: -- Bug 5284640 : Commented out the below variables.

Line 272: --This API is called to insert records into pa_fp_webadi_xface_tmp

268: p_submit_ver_flag IN VARCHAR2,
269: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE);
270:
271: --Bug 4584865.
272: --This API is called to insert records into pa_fp_webadi_xface_tmp
273: --during downloading budget line details into excel spreadsheet.
274: PROCEDURE insert_periodic_tmp_table(p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,