APPS.WMA_MATERIAL dependencies on PJM_PROJECT

Line 162: if ( pjm_project_locator.check_project_references(

158: return false;
159: end if;
160:
161: -- check the project reference
162: if ( pjm_project_locator.check_project_references(
163: param.environment.orgID,
164: param.locatorID,
165: 'SPECIFIC',
166: 'N',

Line 487: x_projectNum := pjm_project.all_proj_idtonum(l_locProjectID);

483: end if;
484:
485: x_projectID := l_locProjectID;
486: x_taskID := l_locTaskID;
487: x_projectNum := pjm_project.all_proj_idtonum(l_locProjectID);
488: x_taskNum := pjm_project.all_task_idtonum(l_locTaskID);
489:
490: select project_id, task_id
491: into l_jobProjectID, l_jobTaskID

Line 488: x_taskNum := pjm_project.all_task_idtonum(l_locTaskID);

484:
485: x_projectID := l_locProjectID;
486: x_taskID := l_locTaskID;
487: x_projectNum := pjm_project.all_proj_idtonum(l_locProjectID);
488: x_taskNum := pjm_project.all_task_idtonum(l_locTaskID);
489:
490: select project_id, task_id
491: into l_jobProjectID, l_jobTaskID
492: from wip_discrete_jobs

Line 525: from pjm_project_parameters pp,

521: -- allow cross issue
522: if ( l_locProjectID <> l_jobProjectID and p_allowCrossIssue = 1 ) then
523: select count(*)
524: into l_num
525: from pjm_project_parameters pp,
526: pjm_project_parameters jpp
527: where pp.organization_id = p_orgID
528: and pp.project_id = l_locProjectID
529: and jpp.organization_id = p_orgID

Line 526: pjm_project_parameters jpp

522: if ( l_locProjectID <> l_jobProjectID and p_allowCrossIssue = 1 ) then
523: select count(*)
524: into l_num
525: from pjm_project_parameters pp,
526: pjm_project_parameters jpp
527: where pp.organization_id = p_orgID
528: and pp.project_id = l_locProjectID
529: and jpp.organization_id = p_orgID
530: and jpp.project_id = l_jobProjectID