[Home] [Help]
1008: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,
1009: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1010: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,
1011: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,
1012: PA_PROJECTS_ALL PA, AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1013: WHERE AVTS.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID(+)
1014: AND AVTS.ITEM_INSTANCE_ID = CSIS.INSTANCE_ID(+)
1015: AND AVTS.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+)
1016: AND AVTS.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+)
1056: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS_TL HROU,
1057: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1058: FND_LOOKUP_VALUES FLVT, FND_LOOKUP_VALUES FLVT1,
1059: FND_LOOKUP_VALUES FLVT2, FND_LOOKUP_VALUES FLVT3,
1060: PA_PROJECTS_ALL PA,
1061: AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1062: WHERE AVTS.VISIT_ID = AVTSTL.VISIT_ID
1063: AND AVTSTL.LANGUAGE = USERENV('LANG')
1064: AND ASPV.SIMULATION_PLAN_ID = ASPVTL.SIMULATION_PLAN_ID(+)
1107: AND VISIT_TASK_ID IS NULL;
1108:
1109: -- CURSOR added to get the Project Template Name
1110: -- Post 11.5.10
1111: -- Fix for ADS bug# 4357001. Changed to use PA_PROJECTS_ALL table.
1112: CURSOR c_proj_template(p_proj_temp_id IN NUMBER) IS
1113: SELECT name FROM PA_PROJECTS_ALL
1114: WHERE project_id = p_proj_temp_id;
1115:
1109: -- CURSOR added to get the Project Template Name
1110: -- Post 11.5.10
1111: -- Fix for ADS bug# 4357001. Changed to use PA_PROJECTS_ALL table.
1112: CURSOR c_proj_template(p_proj_temp_id IN NUMBER) IS
1113: SELECT name FROM PA_PROJECTS_ALL
1114: WHERE project_id = p_proj_temp_id;
1115:
1116: CURSOR c_uc_header(x_instance_id IN NUMBER) IS
1117: SELECT name, UNIT_CONFIG_HEADER_ID FROM ahl_unit_config_headers
5348: WHERE VISIT_ID = p_visit_id;
5349:
5350: -- ****** cancelled check has to be added to production api
5351: -- Check if visit project id is null
5352: -- if not null then update PA_PROJECTS_ALL and set the
5353: -- project status code to 'CLOSED'
5354: IF c_visit_rec.PROJECT_ID IS NOT NULL THEN
5355: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5356: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_PROJ_PROD_PVT.Update_Project');