APPS.PA_RESOURCE_MAPPING dependencies on PA_RES_LIST_MAP_TMP1

Line 775: l_src_table VARCHAR2(20) := 'PA_RES_LIST_MAP_TMP1';

771: l_SELECT_clause VARCHAR2 (1000);
772: l_FROM_clause VARCHAR2 (1000);
773: l_WHERE_clause VARCHAR2 (2000);
774:
775: l_src_table VARCHAR2(20) := 'PA_RES_LIST_MAP_TMP1';
776:
777:
778: BEGIN
779:

Line 823: FROM pa_res_list_map_tmp1

819: BEGIN
820:
821: -- Removed tmp2 as part of bug fix : 4199314
822: /* SELECT count(*) into l_count
823: FROM pa_res_list_map_tmp1
824: IF (l_count = 0) THEN
825: RETURN FALSE;
826: ELSE
827: RETURN TRUE;

Line 832: FROM pa_res_list_map_tmp1);

828: END IF; */
829: -- Commented this as part of bug fix :4350603
830: SELECT 1
831: INTO l_count FROM dual WHERE EXISTS (SELECT 1
832: FROM pa_res_list_map_tmp1);
833: RETURN TRUE;
834: EXCEPTION WHEN NO_DATA_FOUND THEN
835: RETURN FALSE;
836: END;--end function txns_to_map_exists

Line 1013: l_src_table VARCHAR2(20) := 'pa_res_list_map_tmp1';

1009: l_INSERT_clause VARCHAR2 (4000);
1010: l_SELECT_clause VARCHAR2 (5000);
1011: l_FROM_clause VARCHAR2 (500);
1012: l_WHERE_clause VARCHAR2 (500);
1013: l_src_table VARCHAR2(20) := 'pa_res_list_map_tmp1';
1014:
1015:
1016: BEGIN
1017:

Line 1069: EXECUTE IMMEDIATE ('DELETE FROM PA_RES_LIST_MAP_TMP1 TMP1' || ' WHERE ROWID IN ( SELECT tmp_rowid FROM pa_res_list_map_tmp4 tmp4 ) '); --bug#16865233

1065: -- commenting OUT for bug : 4199314
1066: -- As part of bug fix we are deleting all the records from TEMP1 that exists in
1067: -- TEMP4
1068: -- Pji_Pjp_Fp_Curr_Wrap.print_time(' Before RBS Mapping deletion. ' );
1069: EXECUTE IMMEDIATE ('DELETE FROM PA_RES_LIST_MAP_TMP1 TMP1' || ' WHERE ROWID IN ( SELECT tmp_rowid FROM pa_res_list_map_tmp4 tmp4 ) '); --bug#16865233
1070: -- Pji_Pjp_Fp_Curr_Wrap.print_time(' After RBS Mapping # records deleted = ' || SQL%ROWCOUNT );
1071:
1072: pa_debug.reset_err_stack;
1073:

Line 1378: UPDATE pa_res_list_map_tmp1 tmp1

1374:
1375: -- bug#3612772 and bug#3612591
1376: -- update resource attributes which can be derived but are not present
1377: /* split the below update into two to remove 9i dependencies
1378: UPDATE pa_res_list_map_tmp1 tmp1
1379: SET tmp1.EXPENDITURE_CATEGORY = nvl(tmp1.EXPENDITURE_CATEGORY, (SELECT typ.EXPENDITURE_CATEGORY
1380: FROM PA_EXPENDITURE_TYPES typ
1381: WHERE typ.EXPENDITURE_TYPE = tmp1.EXPENDITURE_TYPE ) )
1382: ,tmp1.ITEM_CATEGORY_ID = nvl(tmp1.ITEM_CATEGORY_ID, (SELECT cat.CATEGORY_ID

Line 1395: UPDATE pa_res_list_map_tmp1 tmp1

1391: cat.INVENTORY_ITEM_ID = tmp1.INVENTORY_ITEM_ID and
1392: cat.organization_id = tmp1.organization_id )
1393: ) ;
1394: */
1395: UPDATE pa_res_list_map_tmp1 tmp1
1396: SET tmp1.EXPENDITURE_CATEGORY = (SELECT typ.EXPENDITURE_CATEGORY
1397: FROM PA_EXPENDITURE_TYPES typ
1398: WHERE typ.EXPENDITURE_TYPE = tmp1.EXPENDITURE_TYPE )
1399: WHERE tmp1.EXPENDITURE_CATEGORY IS NULL;

Line 1400: UPDATE pa_res_list_map_tmp1 tmp1

1396: SET tmp1.EXPENDITURE_CATEGORY = (SELECT typ.EXPENDITURE_CATEGORY
1397: FROM PA_EXPENDITURE_TYPES typ
1398: WHERE typ.EXPENDITURE_TYPE = tmp1.EXPENDITURE_TYPE )
1399: WHERE tmp1.EXPENDITURE_CATEGORY IS NULL;
1400: UPDATE pa_res_list_map_tmp1 tmp1
1401: SET tmp1.ITEM_CATEGORY_ID = (SELECT cat.CATEGORY_ID
1402: FROM
1403: PA_RESOURCE_CLASSES_B classes,
1404: PA_PLAN_RES_DEFAULTS cls,

Line 1416: UPDATE pa_res_list_map_tmp1 tmp1

1412: WHERE tmp1.ITEM_CATEGORY_ID IS NULL;
1413:
1414: /* Added for bug 3653120 */
1415:
1416: UPDATE pa_res_list_map_tmp1 tmp1
1417: SET tmp1.revenue_category = (SELECT evt.revenue_category_code
1418: FROM pa_event_types evt
1419: WHERE evt.event_type=tmp1.event_type)
1420: WHERE tmp1.revenue_category IS NULL

Line 1423: UPDATE pa_res_list_map_tmp1 tmp1

1419: WHERE evt.event_type=tmp1.event_type)
1420: WHERE tmp1.revenue_category IS NULL
1421: AND tmp1.event_type IS NOT NULL;
1422:
1423: UPDATE pa_res_list_map_tmp1 tmp1
1424: SET tmp1.revenue_category = (SELECT et.revenue_category_code
1425: FROM pa_expenditure_types et
1426: WHERE et.expenditure_type=tmp1.expenditure_type)
1427: WHERE tmp1.revenue_category IS NULL

Line 1439: UPDATE pa_res_list_map_tmp1 tmp1

1435: WHEN NO_DATA_FOUND THEN
1436: NULL;
1437: END;
1438: IF l_job_group_id IS NOT NULL THEN
1439: UPDATE pa_res_list_map_tmp1 tmp1
1440: SET tmp1.job_id =
1441: (SELECT PA_Cross_Business_Grp.IsMappedToJob(tmp1.job_id, l_job_group_id) FROM DUAL)
1442: WHERE tmp1.job_id IS NOT NULL;
1443: END IF;