APPS.CTO_CHANGE_ORDER_PK dependencies on INV_ORGANIZATION_NAME_V

Line 1913: -- Replaced org_organization_definitions with inv_organization_name_v

1909: -- l_atxtvalue(i) := pchgtype(i).old_value||' TO '||pchgtype(i).new_value;
1910:
1911: begin
1912: -- rkaza. 3742393. 08/12/2004.
1913: -- Replaced org_organization_definitions with inv_organization_name_v
1914:
1915: select organization_name into v_old_org
1916: from inv_organization_name_v
1917: where organization_id = pchgtype(i).old_value ;

Line 1916: from inv_organization_name_v

1912: -- rkaza. 3742393. 08/12/2004.
1913: -- Replaced org_organization_definitions with inv_organization_name_v
1914:
1915: select organization_name into v_old_org
1916: from inv_organization_name_v
1917: where organization_id = pchgtype(i).old_value ;
1918:
1919:
1920: exception

Line 1923: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || 'exception while querying inv_organization_name_v for ' ||

1919:
1920: exception
1921: when others then
1922:
1923: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || 'exception while querying inv_organization_name_v for ' ||
1924: nvl( pchgtype(i).old_value , 'NULL' ) ) ;
1925:
1926: v_old_org := pchgtype(i).old_value ;
1927: end ;

Line 1933: from inv_organization_name_v

1929:
1930:
1931: begin
1932: select organization_name into v_new_org
1933: from inv_organization_name_v
1934: where organization_id = pchgtype(i).new_value ;
1935:
1936: exception
1937: when others then

Line 1939: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || 'exception while querying inv_organization_name_v for ' ||

1935:
1936: exception
1937: when others then
1938:
1939: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || 'exception while querying inv_organization_name_v for ' ||
1940: nvl( pchgtype(i).new_value , 'NULL' ) ) ;
1941:
1942: v_new_org := pchgtype(i).new_value ;
1943: end ;