APPS.PON_COPY_UDAS_GRP dependencies on PON_AUCTION_HEADERS_EXT_B

Line 1170: open addrExtnCur for select extension_id from pon_auction_headers_ext_b where

1166: if ( p_src_doc_type = 'REQ' ) then
1167: open addrExtnCur for select extension_id from po_req_headers_ext_b where
1168: requisition_header_id = p_src_pkey(1) and attr_group_id = l_attr_grp_id order by extension_id;
1169: else
1170: open addrExtnCur for select extension_id from pon_auction_headers_ext_b where
1171: auction_header_id = p_src_pkey(1) and attr_group_id = l_attr_grp_id order by extension_id;
1172: end if;
1173: fetch addrExtnCur bulk Collect into l_extn_id_list;
1174: close addrExtnCur;

Line 1253: delete from pon_auction_headers_ext_b

1249: --delete irrelevant addresses
1250: if ( p_excl_addr_types.count > 0 ) Then
1251: for i in p_excl_addr_types.FIRST..p_excl_addr_types.LAST
1252: loop
1253: delete from pon_auction_headers_ext_b
1254: where auction_header_id = p_tar_pkey(1)
1255: and c_ext_attr39 = p_excl_addr_types(i);
1256: end loop;
1257: end if;