[Home] [Help]
1761: l_asset_group NUMBER;
1762: l_charge_dept NUMBER;
1763: l_dept_id NUMBER;
1764: l_operation_number NUMBER;
1765: l_org_id wip_discrete_jobs.organization_id%type;
1766: l_resource_id NUMBER;
1767: l_wip_entity_id NUMBER;
1768: -- End of deposit mapping variable declarations
1769:
1969:
1970: -- 1. Check whether the work order is a maintenance work order or not.
1971:
1972: if l_wip_entity_id <> -9999 and l_org_id <> -9999 then
1973: select job_type into l_job_type from wip_discrete_jobs where
1974: wip_entity_id = l_wip_entity_id
1975: and organization_id = l_org_id;
1976: if l_job_type <> 3 then -- not a maintenance work order
1977: -- Add the corresponding error message to the message table
1991:
1992: -- 2. Asset group - work order association is correct.
1993: if l_wip_entity_id <> -9999 and l_org_id <> -9999 and l_asset_group <> -9999 then
1994: -- bug 4146481. added NVL in query
1995: select count(*) into l_count from wip_discrete_jobs where
1996: wip_entity_id = l_wip_entity_id and
1997: organization_id = l_org_id and
1998: nvl(asset_group_id,rebuild_item_id) = l_asset_group;
1999: if l_count = 0 then
2036:
2037: -- 4. asset number and work order association is correct.
2038: if l_asset_number <> ' ' and l_org_id <> -9999 and l_wip_entity_id <> -9999 then
2039: -- bug 4146481. added NVL in query
2040: select count(*) into l_count from wip_discrete_jobs where
2041: nvl(asset_number,rebuild_serial_number) = l_asset_number and
2042: wip_entity_id = l_wip_entity_id and
2043: organization_id = l_org_id;
2044: if l_count = 0 then
2285: msg_tkn := '';
2286:
2287: end if;
2288: select date_released into l_wo_released_date
2289: from wip_discrete_jobs
2290: where wip_entity_id = l_wip_entity_id
2291: and organization_id = l_org_id;
2292:
2293: