APPS.PA_FP_WEBADI_UTILS dependencies on PA_FP_WEBADI_UPLOAD_INF

Line 2427: l_run_id pa_fp_webadi_upload_inf.run_id%TYPE;

2423: l_data VARCHAR2(2000);
2424: l_msg_data VARCHAR2(2000);
2425: l_msg_index_out NUMBER;
2426:
2427: l_run_id pa_fp_webadi_upload_inf.run_id%TYPE;
2428: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2429:
2430: BEGIN
2431: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 2470: FROM pa_fp_webadi_upload_inf

2466: SELECT run_id,
2467: budget_version_id
2468: INTO l_run_id,
2469: l_budget_version_id
2470: FROM pa_fp_webadi_upload_inf
2471: WHERE request_id = p_request_id
2472: AND ROWNUM = 1;
2473: EXCEPTION
2474: WHEN NO_DATA_FOUND THEN

Line 2571: l_run_id pa_fp_webadi_upload_inf.run_id%TYPE;

2567: l_data VARCHAR2(2000);
2568: l_msg_data VARCHAR2(2000);
2569: l_msg_index_out NUMBER;
2570:
2571: l_run_id pa_fp_webadi_upload_inf.run_id%TYPE;
2572: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2573: l_new_request_id pa_budget_versions.request_id%TYPE;
2574: -- MOAC changes.
2575: l_org_id pa_projects_all.org_id%TYPE;

Line 2616: FROM pa_fp_webadi_upload_inf

2612: SELECT run_id,
2613: budget_version_id
2614: INTO l_run_id,
2615: l_budget_version_id
2616: FROM pa_fp_webadi_upload_inf
2617: WHERE request_id = p_old_request_id
2618: AND ROWNUM = 1;
2619: EXCEPTION
2620: WHEN NO_DATA_FOUND THEN

Line 2695: UPDATE pa_fp_webadi_upload_inf

2691: request_id = l_new_request_id
2692: WHERE budget_version_id = l_budget_version_id;
2693:
2694: -- updating the interface table with the new request_id
2695: UPDATE pa_fp_webadi_upload_inf
2696: SET request_id = l_new_request_id
2697: WHERE budget_version_id = l_budget_version_id
2698: AND run_id = l_run_id;
2699: