[Home] [Help]
2107: /* Bug 8758194 In case of Blanket POs with multiple releases for the same line, if po_release_id is populated
2108: in RTI, the following condition was failing since it was checking for po_release_id to be NULL, and hence
2109: the derivation of values was not taking place. Commented the unnecessary condition to ensure that derivation
2110: of values goes through fine for such a case. Further, modified the DEBUG messages.
2111: Moreover, Added code to derive the release number from po_releases_all if the po_release_id is populated and
2112: release_num is not populated in RTI.
2113: */
2114: IF (nvl(l_asn_type,'STD') <> 'WC' ) THEN --{
2115: IF (x_cascaded_table(n).error_status IN('S', 'W'))
2126: END IF;
2127:
2128: SELECT release_num
2129: INTO x_cascaded_table(n).release_num
2130: FROM po_releases_all
2131: WHERE po_header_id = x_cascaded_table(n).po_header_id
2132: AND po_release_id = x_cascaded_table(n).po_release_id;
2133:
2134: IF (g_asn_debug = 'Y') THEN
11423:
11424: if x_cascaded_table(n).po_release_id is not null then --5439085
11425: select release_num
11426: into l_po_rel_num
11427: from po_releases_all
11428: where po_release_id = x_cascaded_table(n).po_release_id;
11429: end if;
11430: EXCEPTION
11431: WHEN NO_DATA_FOUND THEN