APPS.AHL_VWP_VISITS_PVT dependencies on PA_PROJECTS_ALL

Line 1195: PA_PROJECTS_ALL PA, AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB

1191: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,
1192: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1193: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,
1194: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,
1195: PA_PROJECTS_ALL PA, AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1196: WHERE AVTS.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID(+)
1197: AND AVTS.ITEM_INSTANCE_ID = CSIS.INSTANCE_ID(+)
1198: AND AVTS.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+)
1199: AND AVTS.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+)

Line 1247: --PA_PROJECTS_ALL PA,

1243: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1244: FND_LOOKUP_VALUES FLVT, FND_LOOKUP_VALUES FLVT1,
1245: FND_LOOKUP_VALUES FLVT2, FND_LOOKUP_VALUES FLVT3,
1246: -- SKPATHAK :: Bug #8983097 :: 20-OCT-2009
1247: --PA_PROJECTS_ALL PA,
1248: AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1249: WHERE AVTS.VISIT_ID = AVTSTL.VISIT_ID
1250: AND AVTSTL.LANGUAGE = USERENV('LANG')
1251: AND ASPV.SIMULATION_PLAN_ID = ASPVTL.SIMULATION_PLAN_ID(+)

Line 1312: -- Fix for ADS bug# 4357001. Changed to use PA_PROJECTS_ALL table.

1308: AND VISIT_TASK_ID IS NULL;
1309:
1310: -- CURSOR added to get the Project Template Name
1311: -- Post 11.5.10
1312: -- Fix for ADS bug# 4357001. Changed to use PA_PROJECTS_ALL table.
1313: CURSOR c_proj_template(p_proj_temp_id IN NUMBER) IS
1314: SELECT name FROM PA_PROJECTS_ALL
1315: WHERE project_id = p_proj_temp_id;
1316:

Line 1314: SELECT name FROM PA_PROJECTS_ALL

1310: -- CURSOR added to get the Project Template Name
1311: -- Post 11.5.10
1312: -- Fix for ADS bug# 4357001. Changed to use PA_PROJECTS_ALL table.
1313: CURSOR c_proj_template(p_proj_temp_id IN NUMBER) IS
1314: SELECT name FROM PA_PROJECTS_ALL
1315: WHERE project_id = p_proj_temp_id;
1316:
1317: CURSOR c_uc_header(x_instance_id IN NUMBER) IS
1318: SELECT name, UNIT_CONFIG_HEADER_ID FROM ahl_unit_config_headers

Line 1324: SELECT name FROM PA_PROJECTS_ALL

1320: AND active_end_date is null;
1321:
1322: --PRAKKUM ::FP PIE :: 13-OCT-2010
1323: CURSOR get_project_name_csr(c_project_id IN NUMBER) IS
1324: SELECT name FROM PA_PROJECTS_ALL
1325: WHERE project_id = c_project_id;
1326:
1327: /*Added by sowsubra*/
1328: CURSOR c_get_subinv_loc_dtls(p_inv_locator_id IN NUMBER, p_org_id IN NUMBER) IS

Line 1779: FROM PA_PROJECTS_ALL

1775: --To get project id given the project name
1776: CURSOR get_project_id_csr (c_project_name IN VARCHAR2)
1777: IS
1778: SELECT project_id
1779: FROM PA_PROJECTS_ALL
1780: WHERE name = c_project_name;
1781:
1782: --PRAKKUM ::FP PIE :: 13-OCT-2010
1783: --To validate that the project completion is in future

Line 3459: FROM PA_PROJECTS_ALL

3455: --To get project id given the project name
3456: CURSOR get_project_id_csr (c_project_name IN VARCHAR2)
3457: IS
3458: SELECT project_id
3459: FROM PA_PROJECTS_ALL
3460: WHERE name = c_project_name;
3461:
3462:
3463: --PRAKKUM ::FP PIE :: 13-OCT-2010

Line 7101: -- if not null then update PA_PROJECTS_ALL and set the

7097: WHERE VISIT_ID = p_visit_id;
7098:
7099: -- ****** cancelled check has to be added to production api
7100: -- Check if visit project id is null
7101: -- if not null then update PA_PROJECTS_ALL and set the
7102: -- project status code to 'CLOSED'
7103: IF c_visit_rec.PROJECT_ID IS NOT NULL THEN
7104: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7105: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_PROJ_PROD_PVT.Update_Project');