[Home] [Help]
11823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11824: END GET_PERIOD_INFORMATION;
11825:
11826: --Bug 4584865.
11827: --This API is called to insert records into pa_fp_webadi_xface_tmp
11828: --during downloading budget line details into excel spreadsheet.
11829:
11830: PROCEDURE insert_periodic_tmp_table
11831: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
12024: TYPE txn_curr_rate_tbl IS TABLE OF txn_curr_rate_cur%ROWTYPE INDEX BY VARCHAR2(15);
12025: */ --Bug 5144013.
12026: /* End of code changes for bug 5330532*/
12027:
12028: l_global_tmp_rec pa_fp_webadi_xface_tmp%ROWTYPE; --Bug 5284640.
12029: NO_RA_EXC EXCEPTION; --Bug 5360205.
12030:
12031: l_debug_mode VARCHAR2(1);
12032: l_return_status VARCHAR2(1);
12714: l_position := 0;
12715: l_global_tmp_rec := null;
12716: l_return := 0;
12717: END;
12718: /*Populating Global Temparory Table pa_fp_webadi_xface_tmp using the PL/SQL
12719: table l_global_tmp_tbl which contains all the budget line details.
12720: */
12721: IF l_debug_mode = 'Y' THEN
12722: pa_debug.g_err_stage := 'Before inerting into Global Temporary Table';
12724: END IF;
12725: BEGIN
12726: /* FOR tmp IN l_global_tmp_tbl.first..l_global_tmp_tbl.last
12727: LOOP
12728: INSERT INTO pa_fp_webadi_xface_tmp
12729: VALUES l_global_tmp_tbl(tmp);
12730: END LOOP;
12731: commit;*/
12732: FORALL tmp IN l_global_tmp_tbl.first..l_global_tmp_tbl.last
12729: VALUES l_global_tmp_tbl(tmp);
12730: END LOOP;
12731: commit;*/
12732: FORALL tmp IN l_global_tmp_tbl.first..l_global_tmp_tbl.last
12733: INSERT INTO pa_fp_webadi_xface_tmp
12734: VALUES l_global_tmp_tbl(tmp);
12735: EXCEPTION
12736: WHEN OTHERS THEN
12737: RAISE;