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 495: x_projectNum := pjm_project.all_proj_idtonum(l_locProjectID);

491: end if;
492:
493: x_projectID := l_locProjectID;
494: x_taskID := l_locTaskID;
495: x_projectNum := pjm_project.all_proj_idtonum(l_locProjectID);
496: x_taskNum := pjm_project.all_task_idtonum(l_locTaskID);
497:
498: select project_id, task_id
499: into l_jobProjectID, l_jobTaskID

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

492:
493: x_projectID := l_locProjectID;
494: x_taskID := l_locTaskID;
495: x_projectNum := pjm_project.all_proj_idtonum(l_locProjectID);
496: x_taskNum := pjm_project.all_task_idtonum(l_locTaskID);
497:
498: select project_id, task_id
499: into l_jobProjectID, l_jobTaskID
500: from wip_discrete_jobs

Line 533: from pjm_project_parameters pp,

529: -- allow cross issue
530: if ( l_locProjectID <> l_jobProjectID and p_allowCrossIssue = 1 ) then
531: select count(*)
532: into l_num
533: from pjm_project_parameters pp,
534: pjm_project_parameters jpp
535: where pp.organization_id = p_orgID
536: and pp.project_id = l_locProjectID
537: and jpp.organization_id = p_orgID

Line 534: pjm_project_parameters jpp

530: if ( l_locProjectID <> l_jobProjectID and p_allowCrossIssue = 1 ) then
531: select count(*)
532: into l_num
533: from pjm_project_parameters pp,
534: pjm_project_parameters jpp
535: where pp.organization_id = p_orgID
536: and pp.project_id = l_locProjectID
537: and jpp.organization_id = p_orgID
538: and jpp.project_id = l_jobProjectID