APPS.PA_RESOURCE_MAPPING dependencies on PA_RES_LIST_MAP_TMP1

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

678: l_SELECT_clause VARCHAR2 (1000);
679: l_FROM_clause VARCHAR2 (1000);
680: l_WHERE_clause VARCHAR2 (2000);
681:
682: l_src_table VARCHAR2(20) := 'PA_RES_LIST_MAP_TMP1';
683:
684: BEGIN
685:
686: PA_DEBUG.init_err_stack('identify_new_plan_res');

Line 721: FROM pa_res_list_map_tmp1

717: BEGIN
718:
719: -- Removed tmp2 as part of bug fix : 4199314
720: /* SELECT count(*) into l_count
721: FROM pa_res_list_map_tmp1
722: IF (l_count = 0) THEN
723: RETURN FALSE;
724: ELSE
725: RETURN TRUE;

Line 730: FROM pa_res_list_map_tmp1);

726: END IF; */
727: -- Commented this as part of bug fix :4350603
728: SELECT 1
729: INTO l_count FROM dual WHERE EXISTS (SELECT 1
730: FROM pa_res_list_map_tmp1);
731: RETURN TRUE;
732: EXCEPTION WHEN NO_DATA_FOUND THEN
733: RETURN FALSE;
734: END;--end function txns_to_map_exists

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

894: l_INSERT_clause VARCHAR2 (4000);
895: l_SELECT_clause VARCHAR2 (5000);
896: l_FROM_clause VARCHAR2 (500);
897: l_WHERE_clause VARCHAR2 (500);
898: l_src_table VARCHAR2(20) := 'pa_res_list_map_tmp1';
899:
900: BEGIN
901:
902: PA_DEBUG.init_err_stack('process_mapped_txns');

Line 944: EXECUTE IMMEDIATE ('DELETE FROM ' || get_pa_schema_name || '.PA_RES_LIST_MAP_TMP1 TMP1' || ' WHERE ROWID IN ( SELECT tmp_rowid FROM pa_res_list_map_tmp4 tmp4 WHERE tmp4.tmp_rowid = tmp1.rowid ) ');

940: --Truncate processed txns in TMP1/TMP2
941: -- commenting OUT for bug : 4199314
942: -- As part of bug fix we are deleting all the records from TEMP1 that exists in
943: -- TEMP4
944: EXECUTE IMMEDIATE ('DELETE FROM ' || get_pa_schema_name || '.PA_RES_LIST_MAP_TMP1 TMP1' || ' WHERE ROWID IN ( SELECT tmp_rowid FROM pa_res_list_map_tmp4 tmp4 WHERE tmp4.tmp_rowid = tmp1.rowid ) ');
945:
946: pa_debug.reset_err_stack;
947:
948: RETURN 0;

Line 1136: UPDATE pa_res_list_map_tmp1 tmp1

1132:
1133: -- bug#3612772 and bug#3612591
1134: -- update resource attributes which can be derived but are not present
1135: /* split the below update into two to remove 9i dependencies
1136: UPDATE pa_res_list_map_tmp1 tmp1
1137: SET tmp1.EXPENDITURE_CATEGORY = nvl(tmp1.EXPENDITURE_CATEGORY, (SELECT typ.EXPENDITURE_CATEGORY
1138: FROM PA_EXPENDITURE_TYPES typ
1139: WHERE typ.EXPENDITURE_TYPE = tmp1.EXPENDITURE_TYPE ) )
1140: ,tmp1.ITEM_CATEGORY_ID = nvl(tmp1.ITEM_CATEGORY_ID, (SELECT cat.CATEGORY_ID

Line 1153: UPDATE pa_res_list_map_tmp1 tmp1

1149: cat.INVENTORY_ITEM_ID = tmp1.INVENTORY_ITEM_ID and
1150: cat.organization_id = tmp1.organization_id )
1151: ) ;
1152: */
1153: UPDATE pa_res_list_map_tmp1 tmp1
1154: SET tmp1.EXPENDITURE_CATEGORY = (SELECT typ.EXPENDITURE_CATEGORY
1155: FROM PA_EXPENDITURE_TYPES typ
1156: WHERE typ.EXPENDITURE_TYPE = tmp1.EXPENDITURE_TYPE )
1157: WHERE tmp1.EXPENDITURE_CATEGORY IS NULL;

Line 1158: UPDATE pa_res_list_map_tmp1 tmp1

1154: SET tmp1.EXPENDITURE_CATEGORY = (SELECT typ.EXPENDITURE_CATEGORY
1155: FROM PA_EXPENDITURE_TYPES typ
1156: WHERE typ.EXPENDITURE_TYPE = tmp1.EXPENDITURE_TYPE )
1157: WHERE tmp1.EXPENDITURE_CATEGORY IS NULL;
1158: UPDATE pa_res_list_map_tmp1 tmp1
1159: SET tmp1.ITEM_CATEGORY_ID = (SELECT cat.CATEGORY_ID
1160: FROM
1161: PA_RESOURCE_CLASSES_B classes,
1162: PA_PLAN_RES_DEFAULTS cls,

Line 1174: UPDATE pa_res_list_map_tmp1 tmp1

1170: WHERE tmp1.ITEM_CATEGORY_ID IS NULL;
1171:
1172: /* Added for bug 3653120 */
1173:
1174: UPDATE pa_res_list_map_tmp1 tmp1
1175: SET tmp1.revenue_category = (SELECT evt.revenue_category_code
1176: FROM pa_event_types evt
1177: WHERE evt.event_type=tmp1.event_type)
1178: WHERE tmp1.revenue_category IS NULL

Line 1181: UPDATE pa_res_list_map_tmp1 tmp1

1177: WHERE evt.event_type=tmp1.event_type)
1178: WHERE tmp1.revenue_category IS NULL
1179: AND tmp1.event_type IS NOT NULL;
1180:
1181: UPDATE pa_res_list_map_tmp1 tmp1
1182: SET tmp1.revenue_category = (SELECT et.revenue_category_code
1183: FROM pa_expenditure_types et
1184: WHERE et.expenditure_type=tmp1.expenditure_type)
1185: WHERE tmp1.revenue_category IS NULL

Line 1197: UPDATE pa_res_list_map_tmp1 tmp1

1193: WHEN NO_DATA_FOUND THEN
1194: NULL;
1195: END;
1196: IF l_job_group_id IS NOT NULL THEN
1197: UPDATE pa_res_list_map_tmp1 tmp1
1198: SET tmp1.job_id =
1199: (SELECT PA_Cross_Business_Grp.IsMappedToJob(tmp1.job_id, l_job_group_id) FROM DUAL)
1200: WHERE tmp1.job_id IS NOT NULL;
1201: END IF;