APPS.CTO_CHANGE_ORDER_PK dependencies on INV_ORGANIZATION_NAME_V

Line 2114: -- Replaced org_organization_definitions with inv_organization_name_v

2110: -- l_atxtvalue(i) := pchgtype(i).old_value||' TO '||pchgtype(i).new_value;
2111:
2112: begin
2113: -- rkaza. 3742393. 08/12/2004.
2114: -- Replaced org_organization_definitions with inv_organization_name_v
2115:
2116: select organization_name into v_old_org
2117: from inv_organization_name_v
2118: where organization_id = pchgtype(i).old_value ;

Line 2117: from inv_organization_name_v

2113: -- rkaza. 3742393. 08/12/2004.
2114: -- Replaced org_organization_definitions with inv_organization_name_v
2115:
2116: select organization_name into v_old_org
2117: from inv_organization_name_v
2118: where organization_id = pchgtype(i).old_value ;
2119:
2120:
2121: exception

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

2120:
2121: exception
2122: when others then
2123:
2124: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || 'exception while querying inv_organization_name_v for ' ||
2125: nvl( pchgtype(i).old_value , 'NULL' ) ) ;
2126:
2127: v_old_org := pchgtype(i).old_value ;
2128: end ;

Line 2134: from inv_organization_name_v

2130:
2131:
2132: begin
2133: select organization_name into v_new_org
2134: from inv_organization_name_v
2135: where organization_id = pchgtype(i).new_value ;
2136:
2137: exception
2138: when others then

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

2136:
2137: exception
2138: when others then
2139:
2140: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || 'exception while querying inv_organization_name_v for ' ||
2141: nvl( pchgtype(i).new_value , 'NULL' ) ) ;
2142:
2143: v_new_org := pchgtype(i).new_value ;
2144: end ;