APPS.PA_FP_WEBADI_PKG dependencies on PA_FP_WEBADI_XFACE_TMP

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

12054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12055: END GET_PERIOD_INFORMATION;
12056:
12057: --Bug 4584865.
12058: --This API is called to insert records into pa_fp_webadi_xface_tmp
12059: --during downloading budget line details into excel spreadsheet.
12060:
12061: PROCEDURE insert_periodic_tmp_table
12062: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

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

12257: TYPE txn_curr_rate_tbl IS TABLE OF txn_curr_rate_cur%ROWTYPE INDEX BY VARCHAR2(15);
12258: */ --Bug 5144013.
12259: /* End of code changes for bug 5330532*/
12260:
12261: l_global_tmp_rec pa_fp_webadi_xface_tmp%ROWTYPE; --Bug 5284640.
12262: NO_RA_EXC EXCEPTION; --Bug 5360205.
12263:
12264: l_debug_mode VARCHAR2(1);
12265: l_return_status VARCHAR2(1);

Line 12329: delete from pa_fp_webadi_xface_tmp where budget_version_id = l_budget_version_id;

12325:
12326: l_budget_version_id := p_budget_version_id;
12327:
12328: -- Bug 9963788
12329: delete from pa_fp_webadi_xface_tmp where budget_version_id = l_budget_version_id;
12330:
12331: --Validating Input Parameters.
12332: IF p_budget_version_id IS NULL THEN
12333: IF l_debug_mode = 'Y' THEN

Line 12963: /*Populating Global Temparory Table pa_fp_webadi_xface_tmp using the PL/SQL

12959: l_position := 0;
12960: l_global_tmp_rec := null;
12961: l_return := 0;
12962: END;
12963: /*Populating Global Temparory Table pa_fp_webadi_xface_tmp using the PL/SQL
12964: table l_global_tmp_tbl which contains all the budget line details.
12965: */
12966: IF l_debug_mode = 'Y' THEN
12967: pa_debug.g_err_stage := 'Before inerting into Global Temporary Table';

Line 12973: INSERT INTO pa_fp_webadi_xface_tmp

12969: END IF;
12970: BEGIN
12971: /* FOR tmp IN l_global_tmp_tbl.first..l_global_tmp_tbl.last
12972: LOOP
12973: INSERT INTO pa_fp_webadi_xface_tmp
12974: VALUES l_global_tmp_tbl(tmp);
12975: END LOOP;
12976: commit;*/
12977: FORALL tmp IN l_global_tmp_tbl.first..l_global_tmp_tbl.last

Line 12978: INSERT INTO pa_fp_webadi_xface_tmp

12974: VALUES l_global_tmp_tbl(tmp);
12975: END LOOP;
12976: commit;*/
12977: FORALL tmp IN l_global_tmp_tbl.first..l_global_tmp_tbl.last
12978: INSERT INTO pa_fp_webadi_xface_tmp
12979: VALUES l_global_tmp_tbl(tmp);
12980: EXCEPTION
12981: WHEN OTHERS THEN
12982: RAISE;

Line 13017: INSERT INTO pa_fp_webadi_xface_tmp (BUDGET_VERSION_ID, PROJECT_ID, PROJECT_NAME, PROJECT_NUMBER, RECORD_VERSION_NUMBER)

13013: -- Bug 5360205: Added NO_RA_EXC block.
13014: WHEN NO_RA_EXC THEN
13015: x_return_status := FND_API.G_RET_STS_SUCCESS;
13016: --bug#12703175
13017: INSERT INTO pa_fp_webadi_xface_tmp (BUDGET_VERSION_ID, PROJECT_ID, PROJECT_NAME, PROJECT_NUMBER, RECORD_VERSION_NUMBER)
13018: VALUES (l_budget_version_id, l_project_id, l_project_name, l_project_number, l_rec_version_number);
13019: IF l_debug_mode = 'Y' THEN
13020: pa_debug.reset_curr_function;
13021: END IF;