APPS.WIP_VALIDATEMLHEADER_PVT dependencies on PJM_PROJECT

Line 3539: from pjm_projects_v mpv,

3535: -- Bug 4890514. Performance Fix
3536: -- saugupta 25th-May-2006
3537: select mpv.project_id --if the project has tasks, this query returns multiple rows
3538: into wjsi_row.project_id
3539: from pjm_projects_v mpv,
3540: pjm_project_parameters ppp
3541: where mpv.project_number = wjsi_row.project_number
3542: and mpv.project_id = ppp.project_id
3543: and ppp.organization_id = wjsi_row.organization_id;

Line 3540: pjm_project_parameters ppp

3536: -- saugupta 25th-May-2006
3537: select mpv.project_id --if the project has tasks, this query returns multiple rows
3538: into wjsi_row.project_id
3539: from pjm_projects_v mpv,
3540: pjm_project_parameters ppp
3541: where mpv.project_number = wjsi_row.project_number
3542: and mpv.project_id = ppp.project_id
3543: and ppp.organization_id = wjsi_row.organization_id;
3544: end if;

Line 3562: from pjm_projects_v mpv,

3558: -- Bug 4890514. Performance Fix
3559: -- saugupta 25th-May-2006
3560: select mpv.project_id --this query will return multiple rows if the project has tasks
3561: into l_dummy
3562: from pjm_projects_v mpv,
3563: pjm_project_parameters ppp,
3564: mtl_parameters mp
3565: where mpv.project_id = ppp.project_id
3566: and mpv.project_id = wjsi_row.project_id

Line 3563: pjm_project_parameters ppp,

3559: -- saugupta 25th-May-2006
3560: select mpv.project_id --this query will return multiple rows if the project has tasks
3561: into l_dummy
3562: from pjm_projects_v mpv,
3563: pjm_project_parameters ppp,
3564: mtl_parameters mp
3565: where mpv.project_id = ppp.project_id
3566: and mpv.project_id = wjsi_row.project_id
3567: and ppp.organization_id = wjsi_row.organization_id

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

3611: l_projectID := nvl(wjsi_row.project_id, wdj_row.project_id);
3612: end if;
3613: begin
3614:
3615: if (PJM_PROJECT.val_task_idtonum(l_projectID, wjsi_row.task_id)
3616: is null) then
3617: raise fnd_api.g_exc_unexpected_error;
3618: end if;
3619:

Line 3631: l_result := PJM_PROJECT.VALIDATE_PROJ_REFERENCES

3627: end if;
3628:
3629: if ( wjsi_row.load_type = wip_constants.create_job and
3630: wjsi_row.project_id is not null ) then
3631: l_result := PJM_PROJECT.VALIDATE_PROJ_REFERENCES
3632: (x_inventory_org_id => wjsi_row.organization_id,
3633: x_project_id => wjsi_row.project_id,
3634: x_task_id => wjsi_row.task_id,
3635: x_date1 => wjsi_row.first_unit_start_date,

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

3636: x_date2 => wjsi_row.last_unit_completion_date,
3637: x_calling_function => 'WILMLX',
3638: x_error_code => l_errCode
3639: );
3640: if ( l_result <> PJM_PROJECT.G_VALIDATE_SUCCESS ) then
3641: wip_utilities.get_message_stack(p_delete_stack => 'T',
3642: p_msg => x_errorMsg);
3643: if ( l_result = PJM_PROJECT.G_VALIDATE_FAILURE ) then
3644: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);

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

3639: );
3640: if ( l_result <> PJM_PROJECT.G_VALIDATE_SUCCESS ) then
3641: wip_utilities.get_message_stack(p_delete_stack => 'T',
3642: p_msg => x_errorMsg);
3643: if ( l_result = PJM_PROJECT.G_VALIDATE_FAILURE ) then
3644: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3645: raise line_validation_error;
3646: else
3647: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationWarning);

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

4681: --end if;
4682: end if;
4683:
4684: if ( wjsi_row.project_id is not null) then
4685: if(pjm_project_locator.check_itemLocatorControl(wjsi_row.organization_id,
4686: wjsi_row.completion_subinventory,
4687: wjsi_row.completion_locator_id,
4688: primary_item_row.inventory_item_id,
4689: 2)) then

Line 4690: pjm_project_locator.get_defaultProjectLocator(wjsi_row.organization_id,

4686: wjsi_row.completion_subinventory,
4687: wjsi_row.completion_locator_id,
4688: primary_item_row.inventory_item_id,
4689: 2)) then
4690: pjm_project_locator.get_defaultProjectLocator(wjsi_row.organization_id,
4691: wjsi_row.completion_locator_id,
4692: wjsi_row.project_id,
4693: wjsi_row.task_id,
4694: l_projectLocID);

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

4693: wjsi_row.task_id,
4694: l_projectLocID);
4695: if ( l_projectLocID is not null ) then
4696: wjsi_row.completion_locator_id := l_projectLocID;
4697: if(not pjm_project_locator.check_project_references(wjsi_row.organization_id,
4698: l_projectLocID,
4699: 'SPECIFIC', -- validation mode
4700: 'Y', -- required?
4701: wjsi_row.project_id,