APPS.AHL_VWP_PROJ_PROD_PVT dependencies on PJM_PROJECT_PARAMETERS

Line 1603: FROM pjm_project_parameters_v

1599: c_task_proj_rec c_task_proj%ROWTYPE;
1600:
1601: CURSOR c_pjm_param(x_proj_id IN NUMBER,x_org_id IN NUMBER) IS
1602: SELECT 'x'
1603: FROM pjm_project_parameters_v
1604: WHERE project_id = x_proj_id
1605: AND organization_id = x_org_id;
1606:
1607: l_dummy VARCHAR2(1);

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

2033: SELECT * FROM AHL_VISITS_VL
2034: WHERE VISIT_ID = x_id;
2035: c_visit_rec c_visit%ROWTYPE;
2036:
2037: -- To find whether the visit project occurs in PJM_PROJECT_PARAMETERS table
2038: CURSOR c_Project(x_proj_id IN NUMBER) IS
2039: SELECT count(*) FROM PJM_PROJECT_PARAMETERS
2040: WHERE Project_ID = x_proj_id;
2041: BEGIN

Line 2039: SELECT count(*) FROM PJM_PROJECT_PARAMETERS

2035: c_visit_rec c_visit%ROWTYPE;
2036:
2037: -- To find whether the visit project occurs in PJM_PROJECT_PARAMETERS table
2038: CURSOR c_Project(x_proj_id IN NUMBER) IS
2039: SELECT count(*) FROM PJM_PROJECT_PARAMETERS
2040: WHERE Project_ID = x_proj_id;
2041: BEGIN
2042:
2043: SAVEPOINT Delete_project;

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

2997: OPEN c_Project(c_visit_rec.Project_Id);
2998: FETCH c_Project INTO l_count;
2999: CLOSE c_Project;
3000: IF l_count = 0 THEN
3001: l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : This project should be included in PJM_PROJECT_PARAMETERS from PA' ;
3002: l_error_tbl(j).Msg_Index := j;
3003: l_error_tbl(j).Msg_Data := l_temp;
3004: j := j + 1;
3005: END IF;