[Home] [Help]
462: where wjsi.group_id = p_groupID
463: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
464: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
465: and not exists (select 1
466: from wip_parameters wp,
467: mtl_parameters mp,
468: hr_organization_units ood
469: where wp.organization_id = mp.organization_id
470: and wp.organization_id = ood.organization_id
3136: -- saugupta 25th-May-2006
3137: /*
3138: select ood.operating_unit
3139: into l_operatingUnit
3140: from wip_parameters wp,
3141: mtl_parameters mp,
3142: org_organization_definitions ood
3143: where wp.organization_id = mp.organization_id
3144: and wp.organization_id = ood.organization_id
3150: decode(hoi.org_information_context, 'Accounting Information',
3151: to_number(hoi.org_information3), to_number(null)) operating_unit
3152: INTO l_operatingUnit
3153: FROM hr_organization_units hou,
3154: wip_parameters wp,
3155: mtl_parameters mp,
3156: hr_organization_information hoi
3157: WHERE hou.organization_id = hoi.organization_id
3158: and ( hoi.org_information_context || '') = 'Accounting Information'
4021: if ( po_code_release_grp.Current_Release >=
4022: po_code_release_grp.PRC_11i_Family_Pack_J ) then
4023: select propagate_job_change_to_po
4024: into l_propagate_job_change_to_po
4025: from wip_parameters wp
4026: where organization_id = wjsi_row.organization_id;
4027:
4028: if ( l_propagate_job_change_to_po = wip_constants.yes and
4029: wjsi_row.status_type in (wip_constants.cancelled,
4507: l_startOp,
4508: l_wipID,
4509: l_primaryItem,
4510: l_orgID
4511: from wip_parameters wp, wip_job_schedule_interface wjsi
4512: where wjsi.rowid = p_rowid
4513: and wjsi.organization_id = wp.organization_id;
4514:
4515: if( l_startOp is not null or l_primaryItem is null ) then