APPS.AHL_VWP_PROJ_PROD_PVT dependencies on PJM_PROJECT_PARAMETERS

Line 2533: FROM pjm_project_parameters_v

2529: WHERE PPEV.PROJ_ELEMENT_ID = c_project_task_id;
2530:
2531: CURSOR c_pjm_param(x_proj_id IN NUMBER,x_org_id IN NUMBER) IS
2532: SELECT 'x'
2533: FROM pjm_project_parameters_v
2534: WHERE project_id = x_proj_id
2535: AND organization_id = x_org_id;
2536:
2537: l_dummy VARCHAR2(1);

Line 3882: -- To find whether the visit project occurs in PJM_PROJECT_PARAMETERS table

3878: SELECT * FROM AHL_VISITS_VL
3879: WHERE VISIT_ID = x_id;
3880: c_visit_rec c_visit%ROWTYPE;
3881:
3882: -- To find whether the visit project occurs in PJM_PROJECT_PARAMETERS table
3883: CURSOR c_Project(x_proj_id IN NUMBER) IS
3884: SELECT count(*) FROM PJM_PROJECT_PARAMETERS
3885: WHERE Project_ID = x_proj_id;
3886: BEGIN

Line 3884: SELECT count(*) FROM PJM_PROJECT_PARAMETERS

3880: c_visit_rec c_visit%ROWTYPE;
3881:
3882: -- To find whether the visit project occurs in PJM_PROJECT_PARAMETERS table
3883: CURSOR c_Project(x_proj_id IN NUMBER) IS
3884: SELECT count(*) FROM PJM_PROJECT_PARAMETERS
3885: WHERE Project_ID = x_proj_id;
3886: BEGIN
3887:
3888: SAVEPOINT Delete_project;

Line 5094: l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : This project should be included in PJM_PROJECT_PARAMETERS from PA' ;

5090: OPEN c_Project(c_visit_rec.Project_Id);
5091: FETCH c_Project INTO l_count;
5092: CLOSE c_Project;
5093: IF l_count = 0 THEN
5094: l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : This project should be included in PJM_PROJECT_PARAMETERS from PA' ;
5095: l_error_tbl(j).Msg_Index := j;
5096: l_error_tbl(j).Msg_Data := l_temp;
5097: j := j + 1;
5098: END IF;