APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_RES_LIST_MAP_TMP1

Line 2373: DELETE FROM PA_RES_LIST_MAP_TMP1;

2369: END;
2370: END IF;
2371: END LOOP;
2372:
2373: DELETE FROM PA_RES_LIST_MAP_TMP1;
2374: DELETE FROM PA_RES_LIST_MAP_TMP4;
2375:
2376: l_TXN_SOURCE_ID_tab := l_proj_assignment_id;
2377: l_PERSON_ID_tab := l_proj_person_id;

Line 5177: DELETE from pa_res_list_map_tmp1;

5173: END IF;
5174: --dbms_output.put_line('before res_list_map');
5175: /* we need to pass only distinct
5176: RLM ids to the get res defa API */
5177: DELETE from pa_res_list_map_tmp1;
5178:
5179: FORALL pp in 1 .. l_res_list_member_id.count
5180: INSERT INTO pa_res_list_map_tmp1
5181: (txn_resource_list_member_id)

Line 5180: INSERT INTO pa_res_list_map_tmp1

5176: RLM ids to the get res defa API */
5177: DELETE from pa_res_list_map_tmp1;
5178:
5179: FORALL pp in 1 .. l_res_list_member_id.count
5180: INSERT INTO pa_res_list_map_tmp1
5181: (txn_resource_list_member_id)
5182: VALUES
5183: (l_res_list_member_id(pp));
5184:

Line 5190: FROM pa_res_list_map_tmp1;

5186:
5187: SELECT DISTINCT txn_resource_list_member_id
5188: BULK COLLECT
5189: INTO l_unique_rlm_id_tab
5190: FROM pa_res_list_map_tmp1;
5191:
5192: DELETE FROM pa_res_list_map_tmp1;
5193:
5194: FOR kk in 1 .. l_unique_rlm_id_tab.count LOOP

Line 5192: DELETE FROM pa_res_list_map_tmp1;

5188: BULK COLLECT
5189: INTO l_unique_rlm_id_tab
5190: FROM pa_res_list_map_tmp1;
5191:
5192: DELETE FROM pa_res_list_map_tmp1;
5193:
5194: FOR kk in 1 .. l_unique_rlm_id_tab.count LOOP
5195: l_da_resource_list_members_tab.extend;
5196: l_da_resource_list_members_tab(kk) := l_unique_rlm_id_tab(kk);

Line 5604: DELETE from pa_res_list_map_tmp1;

5600: END IF;
5601: RETURN;
5602: END IF;
5603: --dbms_output.put_line('before res_list_map');
5604: DELETE from pa_res_list_map_tmp1;
5605:
5606: FORALL pp in 1 .. l_res_list_member_id.count
5607: INSERT INTO pa_res_list_map_tmp1
5608: (txn_resource_list_member_id)

Line 5607: INSERT INTO pa_res_list_map_tmp1

5603: --dbms_output.put_line('before res_list_map');
5604: DELETE from pa_res_list_map_tmp1;
5605:
5606: FORALL pp in 1 .. l_res_list_member_id.count
5607: INSERT INTO pa_res_list_map_tmp1
5608: (txn_resource_list_member_id)
5609: VALUES
5610: (l_res_list_member_id(pp));
5611:

Line 5617: FROM pa_res_list_map_tmp1;

5613:
5614: SELECT DISTINCT txn_resource_list_member_id
5615: BULK COLLECT
5616: INTO l_unique_rlm_id_tab
5617: FROM pa_res_list_map_tmp1;
5618:
5619: DELETE FROM pa_res_list_map_tmp1;
5620:
5621: FOR kk in 1 .. l_unique_rlm_id_tab.count LOOP

Line 5619: DELETE FROM pa_res_list_map_tmp1;

5615: BULK COLLECT
5616: INTO l_unique_rlm_id_tab
5617: FROM pa_res_list_map_tmp1;
5618:
5619: DELETE FROM pa_res_list_map_tmp1;
5620:
5621: FOR kk in 1 .. l_unique_rlm_id_tab.count LOOP
5622: l_da_resource_list_members_tab.extend;
5623: l_da_resource_list_members_tab(kk) := l_unique_rlm_id_tab(kk);