APPS.WIP_VALIDATEMLHEADER_PVT dependencies on PJM_PROJECT

Line 3458: from pjm_projects_v mpv,

3454: -- Bug 4890514. Performance Fix
3455: -- saugupta 25th-May-2006
3456: select mpv.project_id --if the project has tasks, this query returns multiple rows
3457: into wjsi_row.project_id
3458: from pjm_projects_v mpv,
3459: pjm_project_parameters ppp
3460: where mpv.project_number = wjsi_row.project_number
3461: and mpv.project_id = ppp.project_id
3462: and ppp.organization_id = wjsi_row.organization_id;

Line 3459: pjm_project_parameters ppp

3455: -- saugupta 25th-May-2006
3456: select mpv.project_id --if the project has tasks, this query returns multiple rows
3457: into wjsi_row.project_id
3458: from pjm_projects_v mpv,
3459: pjm_project_parameters ppp
3460: where mpv.project_number = wjsi_row.project_number
3461: and mpv.project_id = ppp.project_id
3462: and ppp.organization_id = wjsi_row.organization_id;
3463: end if;

Line 3481: from pjm_projects_v mpv,

3477: -- Bug 4890514. Performance Fix
3478: -- saugupta 25th-May-2006
3479: select mpv.project_id --this query will return multiple rows if the project has tasks
3480: into l_dummy
3481: from pjm_projects_v mpv,
3482: pjm_project_parameters ppp,
3483: mtl_parameters mp
3484: where mpv.project_id = ppp.project_id
3485: and mpv.project_id = wjsi_row.project_id

Line 3482: pjm_project_parameters ppp,

3478: -- saugupta 25th-May-2006
3479: select mpv.project_id --this query will return multiple rows if the project has tasks
3480: into l_dummy
3481: from pjm_projects_v mpv,
3482: pjm_project_parameters ppp,
3483: mtl_parameters mp
3484: where mpv.project_id = ppp.project_id
3485: and mpv.project_id = wjsi_row.project_id
3486: and ppp.organization_id = wjsi_row.organization_id

Line 3534: if (PJM_PROJECT.val_task_idtonum(l_projectID, wjsi_row.task_id)

3530: l_projectID := nvl(wjsi_row.project_id, wdj_row.project_id);
3531: end if;
3532: begin
3533:
3534: if (PJM_PROJECT.val_task_idtonum(l_projectID, wjsi_row.task_id)
3535: is null) then
3536: raise fnd_api.g_exc_unexpected_error;
3537: end if;
3538:

Line 3550: l_result := PJM_PROJECT.VALIDATE_PROJ_REFERENCES

3546: end if;
3547:
3548: if ( wjsi_row.load_type = wip_constants.create_job and
3549: wjsi_row.project_id is not null ) then
3550: l_result := PJM_PROJECT.VALIDATE_PROJ_REFERENCES
3551: (x_inventory_org_id => wjsi_row.organization_id,
3552: x_project_id => wjsi_row.project_id,
3553: x_task_id => wjsi_row.task_id,
3554: x_date1 => wjsi_row.first_unit_start_date,

Line 3559: if ( l_result <> PJM_PROJECT.G_VALIDATE_SUCCESS ) then

3555: x_date2 => wjsi_row.last_unit_completion_date,
3556: x_calling_function => 'WILMLX',
3557: x_error_code => l_errCode
3558: );
3559: if ( l_result <> PJM_PROJECT.G_VALIDATE_SUCCESS ) then
3560: wip_utilities.get_message_stack(p_delete_stack => 'T',
3561: p_msg => x_errorMsg);
3562: if ( l_result = PJM_PROJECT.G_VALIDATE_FAILURE ) then
3563: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);

Line 3562: if ( l_result = PJM_PROJECT.G_VALIDATE_FAILURE ) then

3558: );
3559: if ( l_result <> PJM_PROJECT.G_VALIDATE_SUCCESS ) then
3560: wip_utilities.get_message_stack(p_delete_stack => 'T',
3561: p_msg => x_errorMsg);
3562: if ( l_result = PJM_PROJECT.G_VALIDATE_FAILURE ) then
3563: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3564: raise line_validation_error;
3565: else
3566: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationWarning);

Line 4556: if(pjm_project_locator.check_itemLocatorControl(wjsi_row.organization_id,

4552: --end if;
4553: end if;
4554:
4555: if ( wjsi_row.project_id is not null) then
4556: if(pjm_project_locator.check_itemLocatorControl(wjsi_row.organization_id,
4557: wjsi_row.completion_subinventory,
4558: wjsi_row.completion_locator_id,
4559: primary_item_row.inventory_item_id,
4560: 2)) then

Line 4561: pjm_project_locator.get_defaultProjectLocator(wjsi_row.organization_id,

4557: wjsi_row.completion_subinventory,
4558: wjsi_row.completion_locator_id,
4559: primary_item_row.inventory_item_id,
4560: 2)) then
4561: pjm_project_locator.get_defaultProjectLocator(wjsi_row.organization_id,
4562: wjsi_row.completion_locator_id,
4563: wjsi_row.project_id,
4564: wjsi_row.task_id,
4565: l_projectLocID);

Line 4568: if(not pjm_project_locator.check_project_references(wjsi_row.organization_id,

4564: wjsi_row.task_id,
4565: l_projectLocID);
4566: if ( l_projectLocID is not null ) then
4567: wjsi_row.completion_locator_id := l_projectLocID;
4568: if(not pjm_project_locator.check_project_references(wjsi_row.organization_id,
4569: l_projectLocID,
4570: 'SPECIFIC', -- validation mode
4571: 'Y', -- required?
4572: wjsi_row.project_id,