[Home] [Help]
49:
50: /*
51: Bug Number: 9397208
52: For Performance reasons, iby_xml_fndcpt_doc_headers_v view has been replaced
53: with global temporary tables iby_ar_doc_header_gt and iby_ar_doc_lines_gt.
54: Data will be inserted into GTs before extract view call
55: */
56: CURSOR l_doc_rec_csr
57: (c_extension_id iby_trxn_summaries_all.initiator_extension_id%TYPE,
184: ELSE
185: NULL
186: END
187: )))
188: FROM iby_ar_doc_header_gt headergt
189: WHERE headergt.initiator_extension_id = c_extension_id;
190:
191: BEGIN
192:
249:
250: /*
251: Bug Number: 9397208
252: For Performance reasons, iby_xml_fndcpt_doc_headers_v view has been replaced
253: with global temporary tables iby_ar_doc_header_gt and iby_ar_doc_lines_gt.
254: Data will be inserted into GTs before extract view call
255: */
256: CURSOR l_doc_rec_csr
257: (c_extension_id iby_trxn_summaries_all.initiator_extension_id%TYPE,
384: ELSE
385: NULL
386: END
387: )))
388: FROM iby_ar_doc_header_gt headergt
389: WHERE headergt.initiator_extension_id = c_extension_id;
390:
391: BEGIN
392: iby_debug_pub.add('p_trxntypeid: ' || p_trxntypeid,