[Home] [Help]
1756: l_asset_group NUMBER;
1757: l_charge_dept NUMBER;
1758: l_dept_id NUMBER;
1759: l_operation_number NUMBER;
1760: l_org_id wip_discrete_jobs.organization_id%type;
1761: l_resource_id NUMBER;
1762: l_wip_entity_id NUMBER;
1763: -- End of deposit mapping variable declarations
1764:
1962:
1963: -- 1. Check whether the work order is a maintenance work order or not.
1964:
1965: if l_wip_entity_id <> -9999 and l_org_id <> -9999 then
1966: select job_type into l_job_type from wip_discrete_jobs where
1967: wip_entity_id = l_wip_entity_id
1968: and organization_id = l_org_id;
1969: if l_job_type <> 3 then -- not a maintenance work order
1970: -- Add the corresponding error message to the message table
1984:
1985: -- 2. Asset group - work order association is correct.
1986: if l_wip_entity_id <> -9999 and l_org_id <> -9999 and l_asset_group <> -9999 then
1987: -- bug 4146481. added NVL in query
1988: select count(*) into l_count from wip_discrete_jobs where
1989: wip_entity_id = l_wip_entity_id and
1990: organization_id = l_org_id and
1991: nvl(asset_group_id,rebuild_item_id) = l_asset_group;
1992: if l_count = 0 then
2029:
2030: -- 4. asset number and work order association is correct.
2031: if l_asset_number <> ' ' and l_org_id <> -9999 and l_wip_entity_id <> -9999 then
2032: -- bug 4146481. added NVL in query
2033: select count(*) into l_count from wip_discrete_jobs where
2034: nvl(asset_number,rebuild_serial_number) = l_asset_number and
2035: wip_entity_id = l_wip_entity_id and
2036: organization_id = l_org_id;
2037: if l_count = 0 then