2184: --
2185:
2186:
2187: l_progress := '007';
2188: --Populate PON_ATTACHMENTS_INTERFACE with header level attachments
2189: insert into pon_attachments_interface(
2190: interface_auction_header_id,
2191: interface_line_number,
2192: document_id,
2185:
2186:
2187: l_progress := '007';
2188: --Populate PON_ATTACHMENTS_INTERFACE with header level attachments
2189: insert into pon_attachments_interface(
2190: interface_auction_header_id,
2191: interface_line_number,
2192: document_id,
2193: seq_num,
2213: fad.pk1_value = to_char(p_po_header_id) AND
2214: fd.category_id <> 39;
2215:
2216: l_progress := '008';
2217: --Populate PON_ATTACHMENTS_INTERFACE with line level attachments
2218: insert into pon_attachments_interface(
2219: interface_auction_header_id,
2220: interface_line_number,
2221: document_id,
2214: fd.category_id <> 39;
2215:
2216: l_progress := '008';
2217: --Populate PON_ATTACHMENTS_INTERFACE with line level attachments
2218: insert into pon_attachments_interface(
2219: interface_auction_header_id,
2220: interface_line_number,
2221: document_id,
2222: seq_num,