APPS.WSMPOPRN dependencies on WIP_ENTITIES

Line 1840: -- The function will update wip_entities with the new job name only

1836: x_error_msg OUT NOCOPY VARCHAR2
1837: ) return VARCHAR2 IS
1838:
1839: -- Added the parameter P_UPDATE_FLAG to the function update_job_name.
1840: -- The function will update wip_entities with the new job name only
1841: -- if p_update_flag has the value 'TRUE'.
1842:
1843: l_sep VARCHAR2(1);
1844: l_suffix VARCHAR2(30);

Line 1912: from wip_entities we,

1908: BEGIN
1909: l_stat_num := 20;
1910: select l_sep || wse.sector_extension_code
1911: into l_suffix
1912: from wip_entities we,
1913: wsm_sector_extensions wse,
1914: wsm_item_extensions wie
1915: where we.wip_entity_id = p_wip_entity_id
1916: and we.primary_item_id = wie.inventory_item_id

Line 1946: from wip_entities

1942:
1943: l_stat_num := 40;
1944: select wip_entity_name
1945: into l_new_name
1946: from wip_entities
1947: where wip_entity_id = p_wip_entity_id
1948: and organization_id = p_org_id; -- as part of bugfix 2062110 : added orgn_id
1949:
1950: IF l_suffix is null THEN

Line 1961: from wip_entities

1957:
1958: l_stat_num := 50;
1959: select count(*)
1960: into l_count
1961: from wip_entities
1962: where wip_entity_name = l_new_name
1963: /*BA#2073251*/
1964: and organization_id = p_org_id;
1965: /*EA#2073251*/

Line 1970: update wip_entities

1966:
1967: IF l_count = 0 THEN
1968: l_stat_num := 60;
1969: if (g_update_flag) THEN
1970: update wip_entities
1971: set wip_entity_name = l_new_name
1972: where wip_entity_id = p_wip_entity_id
1973: and organization_id = p_org_id; -- as part of bugfix 2062110 : added orgn_id
1974: end if;

Line 1989: from wip_entities

1985: l_stat_num := 20;
1986:
1987: select wip_entity_name
1988: into l_entity_name
1989: from wip_entities
1990: where wip_entity_id = p_wip_entity_id
1991: and organization_id = p_org_id;
1992:
1993: l_stat_num := 30;

Line 2012: from wip_entities

2008:
2009: if (l_entity_name <> l_new_name) then -- bugfix 2820900 : added if clause
2010: select count(*)
2011: into l_count
2012: from wip_entities
2013: where wip_entity_name = l_new_name
2014: and organization_id = p_org_id;
2015:
2016: -- p_dup_job_name := l_new_name; -- bugfix 2820900: moved the assigment above.

Line 2026: update wip_entities

2022:
2023: l_stat_num := 50;
2024:
2025: if (g_update_flag) THEN
2026: update wip_entities
2027: set wip_entity_name = l_new_name
2028: where wip_entity_id = p_wip_entity_id
2029: and organization_id = p_org_id;
2030: end if;

Line 2039: from wip_entities

2035: elsif(l_reuse_jobname = 2) then
2036: l_stat_num := 60;
2037: select wip_entity_name
2038: into l_entity_name
2039: from wip_entities
2040: where wip_entity_id = p_wip_entity_id
2041: and organization_id = p_org_id;
2042:
2043: return(l_entity_name);

Line 2130: from wip_entities

2126: l_stat_num := 10;
2127:
2128: select count(*)
2129: into l_count
2130: from wip_entities
2131: where wip_entity_name = p_reentered_job_name
2132: /*BA#2073251*/
2133: and organization_id = p_org_id;
2134: /*EA#2073251*/

Line 2142: update wip_entities

2138: end if;
2139:
2140: l_stat_num := 20;
2141:
2142: update wip_entities
2143: set wip_entity_name = p_reentered_job_name
2144: where wip_entity_id = p_wip_entity_id
2145: and organization_id = p_org_id;
2146: