[Home] [Help]
461: where wjsi.group_id = p_groupID
462: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
463: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
464: and not exists (select 1
465: from wip_parameters wp,
466: mtl_parameters mp,
467: hr_organization_units ood
468: where wp.organization_id = mp.organization_id
469: and wp.organization_id = ood.organization_id
3107: -- saugupta 25th-May-2006
3108: /*
3109: select ood.operating_unit
3110: into l_operatingUnit
3111: from wip_parameters wp,
3112: mtl_parameters mp,
3113: org_organization_definitions ood
3114: where wp.organization_id = mp.organization_id
3115: and wp.organization_id = ood.organization_id
3121: decode(hoi.org_information_context, 'Accounting Information',
3122: to_number(hoi.org_information3), to_number(null)) operating_unit
3123: INTO l_operatingUnit
3124: FROM hr_organization_units hou,
3125: wip_parameters wp,
3126: mtl_parameters mp,
3127: hr_organization_information hoi
3128: WHERE hou.organization_id = hoi.organization_id
3129: and ( hoi.org_information_context || '') = 'Accounting Information'
3893: if ( po_code_release_grp.Current_Release >=
3894: po_code_release_grp.PRC_11i_Family_Pack_J ) then
3895: select propagate_job_change_to_po
3896: into l_propagate_job_change_to_po
3897: from wip_parameters wp
3898: where organization_id = wjsi_row.organization_id;
3899:
3900: if ( l_propagate_job_change_to_po = wip_constants.yes and
3901: wjsi_row.status_type in (wip_constants.cancelled,
4378: l_startOp,
4379: l_wipID,
4380: l_primaryItem,
4381: l_orgID
4382: from wip_parameters wp, wip_job_schedule_interface wjsi
4383: where wjsi.rowid = p_rowid
4384: and wjsi.organization_id = wp.organization_id;
4385:
4386: if( l_startOp is not null or l_primaryItem is null ) then