51:
52: l_document VARCHAR2(32000) := '';
53: l_tax_amt NUMBER;
54:
55: NL VARCHAR2(1) := fnd_global.newline;
56:
57: BEGIN
58:
59: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
266:
267: l_document VARCHAR2(32000) := '';
268: l_tax_amt NUMBER;
269:
270: NL VARCHAR2(1) := fnd_global.newline;
271:
272: BEGIN
273:
274: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
471:
472: l_document VARCHAR2(32000) := '';
473: l_tax_amt NUMBER;
474:
475: NL VARCHAR2(1) := fnd_global.newline;
476:
477: BEGIN
478:
479: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
676:
677: l_document VARCHAR2(32000) := '';
678: l_tax_amt NUMBER;
679:
680: NL VARCHAR2(1) := fnd_global.newline;
681:
682: BEGIN
683:
684: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
872: l_document VARCHAR2(32000) := '';
873:
874: l_currency_code fnd_currencies.currency_code%TYPE := PO_CORE_S2.get_base_currency;
875:
876: NL VARCHAR2(1) := fnd_global.newline;
877:
878: CURSOR line_csr(v_document_id NUMBER) IS
879: SELECT rql.line_num,
880: msi.concatenated_segments,
1027: l_document VARCHAR2(32000) := '';
1028:
1029: l_history history_record;
1030:
1031: NL VARCHAR2(1) := fnd_global.newline;
1032:
1033: CURSOR history_csr(v_document_id NUMBER, v_object_type VARCHAR2) IS
1034:
1035: SELECT poh.SEQUENCE_NUM,