eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_PRINTING_PKG dependencies on XMLTYPE

Line 1748: xml_res XMLType;

1744:
1745:
1746: xml_clob CLOB;
1747:
1748: xml_res XMLType;
1749: attachments_res XMLType;
1750: doc_rules_res XMLType;
1751: generic_msgs_res XMLType;
1752: doc_msgs_res XMLType;

Line 1749: attachments_res XMLType;

1745:
1746: xml_clob CLOB;
1747:
1748: xml_res XMLType;
1749: attachments_res XMLType;
1750: doc_rules_res XMLType;
1751: generic_msgs_res XMLType;
1752: doc_msgs_res XMLType;
1753: lines_res XMLType;

Line 1750: doc_rules_res XMLType;

1746: xml_clob CLOB;
1747:
1748: xml_res XMLType;
1749: attachments_res XMLType;
1750: doc_rules_res XMLType;
1751: generic_msgs_res XMLType;
1752: doc_msgs_res XMLType;
1753: lines_res XMLType;
1754: collab_team_res XMLType;

Line 1751: generic_msgs_res XMLType;

1747:
1748: xml_res XMLType;
1749: attachments_res XMLType;
1750: doc_rules_res XMLType;
1751: generic_msgs_res XMLType;
1752: doc_msgs_res XMLType;
1753: lines_res XMLType;
1754: collab_team_res XMLType;
1755: scoring_team_res XMLType;

Line 1752: doc_msgs_res XMLType;

1748: xml_res XMLType;
1749: attachments_res XMLType;
1750: doc_rules_res XMLType;
1751: generic_msgs_res XMLType;
1752: doc_msgs_res XMLType;
1753: lines_res XMLType;
1754: collab_team_res XMLType;
1755: scoring_team_res XMLType;
1756: scoring_mems_res XMLType;

Line 1753: lines_res XMLType;

1749: attachments_res XMLType;
1750: doc_rules_res XMLType;
1751: generic_msgs_res XMLType;
1752: doc_msgs_res XMLType;
1753: lines_res XMLType;
1754: collab_team_res XMLType;
1755: scoring_team_res XMLType;
1756: scoring_mems_res XMLType;
1757: scoring_secs_res XMLType;

Line 1754: collab_team_res XMLType;

1750: doc_rules_res XMLType;
1751: generic_msgs_res XMLType;
1752: doc_msgs_res XMLType;
1753: lines_res XMLType;
1754: collab_team_res XMLType;
1755: scoring_team_res XMLType;
1756: scoring_mems_res XMLType;
1757: scoring_secs_res XMLType;
1758: abstracts_res XMLType;

Line 1755: scoring_team_res XMLType;

1751: generic_msgs_res XMLType;
1752: doc_msgs_res XMLType;
1753: lines_res XMLType;
1754: collab_team_res XMLType;
1755: scoring_team_res XMLType;
1756: scoring_mems_res XMLType;
1757: scoring_secs_res XMLType;
1758: abstracts_res XMLType;
1759: currency_res XMLType;

Line 1756: scoring_mems_res XMLType;

1752: doc_msgs_res XMLType;
1753: lines_res XMLType;
1754: collab_team_res XMLType;
1755: scoring_team_res XMLType;
1756: scoring_mems_res XMLType;
1757: scoring_secs_res XMLType;
1758: abstracts_res XMLType;
1759: currency_res XMLType;
1760: invited_supp_cur_res XMLType;

Line 1757: scoring_secs_res XMLType;

1753: lines_res XMLType;
1754: collab_team_res XMLType;
1755: scoring_team_res XMLType;
1756: scoring_mems_res XMLType;
1757: scoring_secs_res XMLType;
1758: abstracts_res XMLType;
1759: currency_res XMLType;
1760: invited_supp_cur_res XMLType;
1761: header_attr_res XMLType;

Line 1758: abstracts_res XMLType;

1754: collab_team_res XMLType;
1755: scoring_team_res XMLType;
1756: scoring_mems_res XMLType;
1757: scoring_secs_res XMLType;
1758: abstracts_res XMLType;
1759: currency_res XMLType;
1760: invited_supp_cur_res XMLType;
1761: header_attr_res XMLType;
1762: invited_supp_res XMLType;

Line 1759: currency_res XMLType;

1755: scoring_team_res XMLType;
1756: scoring_mems_res XMLType;
1757: scoring_secs_res XMLType;
1758: abstracts_res XMLType;
1759: currency_res XMLType;
1760: invited_supp_cur_res XMLType;
1761: header_attr_res XMLType;
1762: invited_supp_res XMLType;
1763: line_attr_res XMLType;

Line 1760: invited_supp_cur_res XMLType;

1756: scoring_mems_res XMLType;
1757: scoring_secs_res XMLType;
1758: abstracts_res XMLType;
1759: currency_res XMLType;
1760: invited_supp_cur_res XMLType;
1761: header_attr_res XMLType;
1762: invited_supp_res XMLType;
1763: line_attr_res XMLType;
1764: line_attr_score_res XMLType;

Line 1761: header_attr_res XMLType;

1757: scoring_secs_res XMLType;
1758: abstracts_res XMLType;
1759: currency_res XMLType;
1760: invited_supp_cur_res XMLType;
1761: header_attr_res XMLType;
1762: invited_supp_res XMLType;
1763: line_attr_res XMLType;
1764: line_attr_score_res XMLType;
1765: pf_res XMLType;

Line 1762: invited_supp_res XMLType;

1758: abstracts_res XMLType;
1759: currency_res XMLType;
1760: invited_supp_cur_res XMLType;
1761: header_attr_res XMLType;
1762: invited_supp_res XMLType;
1763: line_attr_res XMLType;
1764: line_attr_score_res XMLType;
1765: pf_res XMLType;
1766: line_pf_res XMLType;

Line 1763: line_attr_res XMLType;

1759: currency_res XMLType;
1760: invited_supp_cur_res XMLType;
1761: header_attr_res XMLType;
1762: invited_supp_res XMLType;
1763: line_attr_res XMLType;
1764: line_attr_score_res XMLType;
1765: pf_res XMLType;
1766: line_pf_res XMLType;
1767: buyer_pf_res XMLType;

Line 1764: line_attr_score_res XMLType;

1760: invited_supp_cur_res XMLType;
1761: header_attr_res XMLType;
1762: invited_supp_res XMLType;
1763: line_attr_res XMLType;
1764: line_attr_score_res XMLType;
1765: pf_res XMLType;
1766: line_pf_res XMLType;
1767: buyer_pf_res XMLType;
1768: dist_buyer_pf_res XMLType;

Line 1765: pf_res XMLType;

1761: header_attr_res XMLType;
1762: invited_supp_res XMLType;
1763: line_attr_res XMLType;
1764: line_attr_score_res XMLType;
1765: pf_res XMLType;
1766: line_pf_res XMLType;
1767: buyer_pf_res XMLType;
1768: dist_buyer_pf_res XMLType;
1769: large_neg_bur_pf_res XMLType;

Line 1766: line_pf_res XMLType;

1762: invited_supp_res XMLType;
1763: line_attr_res XMLType;
1764: line_attr_score_res XMLType;
1765: pf_res XMLType;
1766: line_pf_res XMLType;
1767: buyer_pf_res XMLType;
1768: dist_buyer_pf_res XMLType;
1769: large_neg_bur_pf_res XMLType;
1770: item_pb_res XMLType;

Line 1767: buyer_pf_res XMLType;

1763: line_attr_res XMLType;
1764: line_attr_score_res XMLType;
1765: pf_res XMLType;
1766: line_pf_res XMLType;
1767: buyer_pf_res XMLType;
1768: dist_buyer_pf_res XMLType;
1769: large_neg_bur_pf_res XMLType;
1770: item_pb_res XMLType;
1771: item_quan_res XMLType;

Line 1768: dist_buyer_pf_res XMLType;

1764: line_attr_score_res XMLType;
1765: pf_res XMLType;
1766: line_pf_res XMLType;
1767: buyer_pf_res XMLType;
1768: dist_buyer_pf_res XMLType;
1769: large_neg_bur_pf_res XMLType;
1770: item_pb_res XMLType;
1771: item_quan_res XMLType;
1772: pay_items_res XMLType;

Line 1769: large_neg_bur_pf_res XMLType;

1765: pf_res XMLType;
1766: line_pf_res XMLType;
1767: buyer_pf_res XMLType;
1768: dist_buyer_pf_res XMLType;
1769: large_neg_bur_pf_res XMLType;
1770: item_pb_res XMLType;
1771: item_quan_res XMLType;
1772: pay_items_res XMLType;
1773: pb_loc_res XMLType;

Line 1770: item_pb_res XMLType;

1766: line_pf_res XMLType;
1767: buyer_pf_res XMLType;
1768: dist_buyer_pf_res XMLType;
1769: large_neg_bur_pf_res XMLType;
1770: item_pb_res XMLType;
1771: item_quan_res XMLType;
1772: pay_items_res XMLType;
1773: pb_loc_res XMLType;
1774: line_price_diff_res XMLType;

Line 1771: item_quan_res XMLType;

1767: buyer_pf_res XMLType;
1768: dist_buyer_pf_res XMLType;
1769: large_neg_bur_pf_res XMLType;
1770: item_pb_res XMLType;
1771: item_quan_res XMLType;
1772: pay_items_res XMLType;
1773: pb_loc_res XMLType;
1774: line_price_diff_res XMLType;
1775: item_price_diff_res XMLType;

Line 1772: pay_items_res XMLType;

1768: dist_buyer_pf_res XMLType;
1769: large_neg_bur_pf_res XMLType;
1770: item_pb_res XMLType;
1771: item_quan_res XMLType;
1772: pay_items_res XMLType;
1773: pb_loc_res XMLType;
1774: line_price_diff_res XMLType;
1775: item_price_diff_res XMLType;
1776: price_diff_types_res XMLType;

Line 1773: pb_loc_res XMLType;

1769: large_neg_bur_pf_res XMLType;
1770: item_pb_res XMLType;
1771: item_quan_res XMLType;
1772: pay_items_res XMLType;
1773: pb_loc_res XMLType;
1774: line_price_diff_res XMLType;
1775: item_price_diff_res XMLType;
1776: price_diff_types_res XMLType;
1777:

Line 1774: line_price_diff_res XMLType;

1770: item_pb_res XMLType;
1771: item_quan_res XMLType;
1772: pay_items_res XMLType;
1773: pb_loc_res XMLType;
1774: line_price_diff_res XMLType;
1775: item_price_diff_res XMLType;
1776: price_diff_types_res XMLType;
1777:
1778: res CLOB;

Line 1775: item_price_diff_res XMLType;

1771: item_quan_res XMLType;
1772: pay_items_res XMLType;
1773: pb_loc_res XMLType;
1774: line_price_diff_res XMLType;
1775: item_price_diff_res XMLType;
1776: price_diff_types_res XMLType;
1777:
1778: res CLOB;
1779:

Line 1776: price_diff_types_res XMLType;

1772: pay_items_res XMLType;
1773: pb_loc_res XMLType;
1774: line_price_diff_res XMLType;
1775: item_price_diff_res XMLType;
1776: price_diff_types_res XMLType;
1777:
1778: res CLOB;
1779:
1780: xml_stmt varchar2(500);

Line 2677: DBMS_XMLGEN.getXMLType(queryCtx, xml_res, DBMS_XMLGEN.NONE);

2673: BEGIN
2674: queryCtx := DBMS_XMLGEN.newContext(xml_query_cursor);
2675: DBMS_XMLGEN.SetRowSetTag(queryCtx, null);
2676: DBMS_XMLGEN.SetRowTag(queryCtx, null);
2677: DBMS_XMLGEN.getXMLType(queryCtx, xml_res, DBMS_XMLGEN.NONE);
2678: xml_clob := xml_res.getCLOBVal();
2679: DBMS_XMLGEN.closeContext (queryCtx);
2680: exception when others then
2681: DBMS_XMLGEN.closeContext (queryCtx);

Line 2902: DBMS_XMLGEN.getXMLType(linesCtx, lines_res, DBMS_XMLGEN.NONE);

2898: BEGIN
2899: DBMS_XMLGEN.SetRowSetTag(linesCtx, null);
2900: DBMS_XMLGEN.SetRowTag(linesCtx, null);
2901: lines_res := NULL;
2902: DBMS_XMLGEN.getXMLType(linesCtx, lines_res, DBMS_XMLGEN.NONE);
2903: Dbms_Lob.append(xml_clob, lines_res.getCLOBVal());
2904: exception when others then
2905: DBMS_XMLGEN.closeContext (linesCtx);
2906: RAISE;

Line 3073: DBMS_XMLGEN.getXMLType(payItemsCtx, pay_items_res, DBMS_XMLGEN.NONE);

3069: payItemsCtx := DBMS_XMLGEN.newContext(pay_items_cursor);
3070: DBMS_XMLGEN.SetRowSetTag(payItemsCtx, 'PAY_ITEMS');
3071: DBMS_XMLGEN.SetRowTag(payItemsCtx, 'PAY_ITEMS_ROW');
3072: pay_items_res := NULL;
3073: DBMS_XMLGEN.getXMLType(payItemsCtx, pay_items_res, DBMS_XMLGEN.NONE);
3074: IF pay_items_res IS NULL THEN
3075: pay_items_res := XMLType('');
3076: END IF;
3077: Dbms_Lob.append(xml_clob, pay_items_res.getCLOBVal());

Line 3075: pay_items_res := XMLType('');

3071: DBMS_XMLGEN.SetRowTag(payItemsCtx, 'PAY_ITEMS_ROW');
3072: pay_items_res := NULL;
3073: DBMS_XMLGEN.getXMLType(payItemsCtx, pay_items_res, DBMS_XMLGEN.NONE);
3074: IF pay_items_res IS NULL THEN
3075: pay_items_res := XMLType('');
3076: END IF;
3077: Dbms_Lob.append(xml_clob, pay_items_res.getCLOBVal());
3078: exception when others then
3079: DBMS_XMLGEN.closeContext (payItemsCtx);

Line 3153: DBMS_XMLGEN.getXMLType(attrsCtx, line_attr_res, DBMS_XMLGEN.NONE);

3149: attrsCtx := DBMS_XMLGEN.newContext(line_attr_cursor);
3150: DBMS_XMLGEN.SetRowSetTag(attrsCtx, 'LINE_ATTRIBUTES');
3151: DBMS_XMLGEN.SetRowTag(attrsCtx, 'LINE_ATTRIBUTES_ROW');
3152: line_attr_res := NULL;
3153: DBMS_XMLGEN.getXMLType(attrsCtx, line_attr_res, DBMS_XMLGEN.NONE);
3154: IF line_attr_res IS NULL THEN
3155: line_attr_res := XMLType('');
3156: END IF;
3157: Dbms_Lob.append(xml_clob, line_attr_res.getCLOBVal());

Line 3155: line_attr_res := XMLType('');

3151: DBMS_XMLGEN.SetRowTag(attrsCtx, 'LINE_ATTRIBUTES_ROW');
3152: line_attr_res := NULL;
3153: DBMS_XMLGEN.getXMLType(attrsCtx, line_attr_res, DBMS_XMLGEN.NONE);
3154: IF line_attr_res IS NULL THEN
3155: line_attr_res := XMLType('');
3156: END IF;
3157: Dbms_Lob.append(xml_clob, line_attr_res.getCLOBVal());
3158: exception when others then
3159: DBMS_XMLGEN.closeContext (attrsCtx);

Line 3250: DBMS_XMLGEN.getXMLType(pfCtx, pf_res, DBMS_XMLGEN.NONE);

3246: pfCtx := DBMS_XMLGEN.newContext(pf_cursor);
3247: DBMS_XMLGEN.SetRowSetTag(pfCtx, 'PRICE_FACTORS');
3248: DBMS_XMLGEN.SetRowTag(pfCtx, 'PRICE_FACTORS_ROW');
3249: pf_res := NULL;
3250: DBMS_XMLGEN.getXMLType(pfCtx, pf_res, DBMS_XMLGEN.NONE);
3251: IF pf_res IS NULL THEN
3252: pf_res := XMLType('');
3253: END IF;
3254: Dbms_Lob.append(xml_clob, pf_res.getCLOBVal());

Line 3252: pf_res := XMLType('');

3248: DBMS_XMLGEN.SetRowTag(pfCtx, 'PRICE_FACTORS_ROW');
3249: pf_res := NULL;
3250: DBMS_XMLGEN.getXMLType(pfCtx, pf_res, DBMS_XMLGEN.NONE);
3251: IF pf_res IS NULL THEN
3252: pf_res := XMLType('');
3253: END IF;
3254: Dbms_Lob.append(xml_clob, pf_res.getCLOBVal());
3255: exception when others then
3256: DBMS_XMLGEN.closeContext (pfCtx);

Line 3285: DBMS_XMLGEN.getXMLType(linepdiffCtx, line_price_diff_res, DBMS_XMLGEN.NONE);

3281: linepdiffCtx := DBMS_XMLGEN.newContext(line_price_diff_cursor);
3282: DBMS_XMLGEN.SetRowSetTag(linepdiffCtx, 'LINE_PRICE_DIFFERENTIALS');
3283: DBMS_XMLGEN.SetRowTag(linepdiffCtx, 'LINE_PRICE_DIFFERENTIALS_ROW');
3284: line_price_diff_res := NULL;
3285: DBMS_XMLGEN.getXMLType(linepdiffCtx, line_price_diff_res, DBMS_XMLGEN.NONE);
3286: IF line_price_diff_res IS NULL THEN
3287: line_price_diff_res := XMLType('');
3288: END IF;
3289: Dbms_Lob.append(xml_clob, line_price_diff_res.getCLOBVal());

Line 3287: line_price_diff_res := XMLType('');

3283: DBMS_XMLGEN.SetRowTag(linepdiffCtx, 'LINE_PRICE_DIFFERENTIALS_ROW');
3284: line_price_diff_res := NULL;
3285: DBMS_XMLGEN.getXMLType(linepdiffCtx, line_price_diff_res, DBMS_XMLGEN.NONE);
3286: IF line_price_diff_res IS NULL THEN
3287: line_price_diff_res := XMLType('');
3288: END IF;
3289: Dbms_Lob.append(xml_clob, line_price_diff_res.getCLOBVal());
3290: exception when others then
3291: DBMS_XMLGEN.closeContext (linepdiffCtx);

Line 3379: DBMS_XMLGEN.getXMLType(itempbreaksCtx, item_pb_res, DBMS_XMLGEN.NONE);

3375: itempbreaksCtx := DBMS_XMLGEN.newContext(item_pb_cursor);
3376: DBMS_XMLGEN.SetRowSetTag(itempbreaksCtx, 'ITEM_PRICE_BREAKS');
3377: DBMS_XMLGEN.SetRowTag(itempbreaksCtx, 'ITEM_PRICE_BREAKS_ROW');
3378: item_pb_res := NULL;
3379: DBMS_XMLGEN.getXMLType(itempbreaksCtx, item_pb_res, DBMS_XMLGEN.NONE);
3380: IF item_pb_res IS NULL THEN
3381: item_pb_res := XMLType('');
3382: END IF;
3383: Dbms_Lob.append(xml_clob, item_pb_res.getCLOBVal());

Line 3381: item_pb_res := XMLType('');

3377: DBMS_XMLGEN.SetRowTag(itempbreaksCtx, 'ITEM_PRICE_BREAKS_ROW');
3378: item_pb_res := NULL;
3379: DBMS_XMLGEN.getXMLType(itempbreaksCtx, item_pb_res, DBMS_XMLGEN.NONE);
3380: IF item_pb_res IS NULL THEN
3381: item_pb_res := XMLType('');
3382: END IF;
3383: Dbms_Lob.append(xml_clob, item_pb_res.getCLOBVal());
3384: exception when others then
3385: DBMS_XMLGEN.closeContext (itempbreaksCtx);

Line 3416: DBMS_XMLGEN.getXMLType(itempdiffsCtx, item_price_diff_res, DBMS_XMLGEN.NONE);

3412: itempdiffsCtx := DBMS_XMLGEN.newContext(item_price_diff_cursor);
3413: DBMS_XMLGEN.SetRowSetTag(itempdiffsCtx, 'ITEM_PRICE_DIFFERENTIALS');
3414: DBMS_XMLGEN.SetRowTag(itempdiffsCtx, 'ITEM_PRICE_DIFFERENTIALS_ROW');
3415: item_price_diff_res := NULL;
3416: DBMS_XMLGEN.getXMLType(itempdiffsCtx, item_price_diff_res, DBMS_XMLGEN.NONE);
3417: IF item_price_diff_res IS NULL THEN
3418: item_price_diff_res := XMLType('');
3419: END IF;
3420: Dbms_Lob.append(xml_clob, item_price_diff_res.getCLOBVal());

Line 3418: item_price_diff_res := XMLType('');

3414: DBMS_XMLGEN.SetRowTag(itempdiffsCtx, 'ITEM_PRICE_DIFFERENTIALS_ROW');
3415: item_price_diff_res := NULL;
3416: DBMS_XMLGEN.getXMLType(itempdiffsCtx, item_price_diff_res, DBMS_XMLGEN.NONE);
3417: IF item_price_diff_res IS NULL THEN
3418: item_price_diff_res := XMLType('');
3419: END IF;
3420: Dbms_Lob.append(xml_clob, item_price_diff_res.getCLOBVal());
3421: exception when others then
3422: DBMS_XMLGEN.closeContext (itempdiffsCtx);

Line 3480: DBMS_XMLGEN.getXMLType(quanTiersCtx, item_quan_res, DBMS_XMLGEN.NONE);

3476: quanTiersCtx := DBMS_XMLGEN.newContext(item_quan_cursor);
3477: DBMS_XMLGEN.SetRowSetTag(quanTiersCtx, 'ITEM_QUANTITY_TIERS');
3478: DBMS_XMLGEN.SetRowTag(quanTiersCtx, 'ITEM_QUANTITY_TIERS_ROW');
3479: item_quan_res := NULL;
3480: DBMS_XMLGEN.getXMLType(quanTiersCtx, item_quan_res, DBMS_XMLGEN.NONE);
3481: IF item_quan_res IS NULL THEN
3482: item_quan_res := XMLType('');
3483: END IF;
3484: Dbms_Lob.append(xml_clob, item_quan_res.getCLOBVal());

Line 3482: item_quan_res := XMLType('');

3478: DBMS_XMLGEN.SetRowTag(quanTiersCtx, 'ITEM_QUANTITY_TIERS_ROW');
3479: item_quan_res := NULL;
3480: DBMS_XMLGEN.getXMLType(quanTiersCtx, item_quan_res, DBMS_XMLGEN.NONE);
3481: IF item_quan_res IS NULL THEN
3482: item_quan_res := XMLType('');
3483: END IF;
3484: Dbms_Lob.append(xml_clob, item_quan_res.getCLOBVal());
3485: exception when others then
3486: DBMS_XMLGEN.closeContext (quanTiersCtx);

Line 3561: DBMS_XMLGEN.getXMLType(queryCtx, collab_team_res, DBMS_XMLGEN.NONE);

3557: BEGIN
3558: queryCtx := DBMS_XMLGEN.newContext(collab_team_cursor);
3559: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'COLLABORATION_TEAM');
3560: DBMS_XMLGEN.SetRowTag(queryCtx, 'COLLABORATION_TEAM_ROW');
3561: DBMS_XMLGEN.getXMLType(queryCtx, collab_team_res, DBMS_XMLGEN.NONE);
3562: IF collab_team_res IS NULL THEN
3563: collab_team_res := XMLType('');
3564: END IF;
3565: Dbms_Lob.append(xml_clob, collab_team_res.getCLOBVal());

Line 3563: collab_team_res := XMLType('');

3559: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'COLLABORATION_TEAM');
3560: DBMS_XMLGEN.SetRowTag(queryCtx, 'COLLABORATION_TEAM_ROW');
3561: DBMS_XMLGEN.getXMLType(queryCtx, collab_team_res, DBMS_XMLGEN.NONE);
3562: IF collab_team_res IS NULL THEN
3563: collab_team_res := XMLType('');
3564: END IF;
3565: Dbms_Lob.append(xml_clob, collab_team_res.getCLOBVal());
3566: DBMS_XMLGEN.closeContext (queryCtx);
3567: exception when others then

Line 3590: DBMS_XMLGEN.getXMLType(queryCtx, scoring_team_res, DBMS_XMLGEN.NONE);

3586: BEGIN
3587: queryCtx := DBMS_XMLGEN.newContext(scoring_team_cursor);
3588: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'SCORING_TEAMS');
3589: DBMS_XMLGEN.SetRowTag(queryCtx, 'SCORING_TEAMS_ROW');
3590: DBMS_XMLGEN.getXMLType(queryCtx, scoring_team_res, DBMS_XMLGEN.NONE);
3591: IF scoring_team_res IS NULL THEN
3592: scoring_team_res := XMLType('');
3593: END IF;
3594: Dbms_Lob.append(xml_clob, scoring_team_res.getCLOBVal());

Line 3592: scoring_team_res := XMLType('');

3588: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'SCORING_TEAMS');
3589: DBMS_XMLGEN.SetRowTag(queryCtx, 'SCORING_TEAMS_ROW');
3590: DBMS_XMLGEN.getXMLType(queryCtx, scoring_team_res, DBMS_XMLGEN.NONE);
3591: IF scoring_team_res IS NULL THEN
3592: scoring_team_res := XMLType('');
3593: END IF;
3594: Dbms_Lob.append(xml_clob, scoring_team_res.getCLOBVal());
3595: DBMS_XMLGEN.closeContext (queryCtx);
3596: exception when others then

Line 3624: DBMS_XMLGEN.getXMLType(queryCtx, scoring_mems_res, DBMS_XMLGEN.NONE);

3620: BEGIN
3621: queryCtx := DBMS_XMLGEN.newContext(scoring_mems_cursor);
3622: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'SCORING_TEAM_MEMBERS');
3623: DBMS_XMLGEN.SetRowTag(queryCtx, 'SCORING_TEAM_MEMBERS_ROW');
3624: DBMS_XMLGEN.getXMLType(queryCtx, scoring_mems_res, DBMS_XMLGEN.NONE);
3625: IF scoring_mems_res IS NULL THEN
3626: scoring_mems_res := XMLType('');
3627: END IF;
3628: Dbms_Lob.append(xml_clob, scoring_mems_res.getCLOBVal());

Line 3626: scoring_mems_res := XMLType('');

3622: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'SCORING_TEAM_MEMBERS');
3623: DBMS_XMLGEN.SetRowTag(queryCtx, 'SCORING_TEAM_MEMBERS_ROW');
3624: DBMS_XMLGEN.getXMLType(queryCtx, scoring_mems_res, DBMS_XMLGEN.NONE);
3625: IF scoring_mems_res IS NULL THEN
3626: scoring_mems_res := XMLType('');
3627: END IF;
3628: Dbms_Lob.append(xml_clob, scoring_mems_res.getCLOBVal());
3629: DBMS_XMLGEN.closeContext (queryCtx);
3630: exception when others then

Line 3657: DBMS_XMLGEN.getXMLType(queryCtx, scoring_secs_res, DBMS_XMLGEN.NONE);

3653: BEGIN
3654: queryCtx := DBMS_XMLGEN.newContext(scoring_secs_cursor);
3655: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'SCORING_TEAM_SECTIONS');
3656: DBMS_XMLGEN.SetRowTag(queryCtx, 'SCORING_TEAM_SECTIONS_ROW');
3657: DBMS_XMLGEN.getXMLType(queryCtx, scoring_secs_res, DBMS_XMLGEN.NONE);
3658: IF scoring_secs_res IS NULL THEN
3659: scoring_secs_res := XMLType('');
3660: END IF;
3661: Dbms_Lob.append(xml_clob, scoring_secs_res.getCLOBVal());

Line 3659: scoring_secs_res := XMLType('');

3655: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'SCORING_TEAM_SECTIONS');
3656: DBMS_XMLGEN.SetRowTag(queryCtx, 'SCORING_TEAM_SECTIONS_ROW');
3657: DBMS_XMLGEN.getXMLType(queryCtx, scoring_secs_res, DBMS_XMLGEN.NONE);
3658: IF scoring_secs_res IS NULL THEN
3659: scoring_secs_res := XMLType('');
3660: END IF;
3661: Dbms_Lob.append(xml_clob, scoring_secs_res.getCLOBVal());
3662: DBMS_XMLGEN.closeContext (queryCtx);
3663: exception when others then

Line 3694: DBMS_XMLGEN.getXMLType(queryCtx, abstracts_res, DBMS_XMLGEN.NONE);

3690: BEGIN
3691: queryCtx := DBMS_XMLGEN.newContext(abstracts_cursor);
3692: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'ABSTRACT_AND_FORMS');
3693: DBMS_XMLGEN.SetRowTag(queryCtx, 'ABSTRACT_AND_FORMS_ROW');
3694: DBMS_XMLGEN.getXMLType(queryCtx, abstracts_res, DBMS_XMLGEN.NONE);
3695: IF abstracts_res IS NULL THEN
3696: abstracts_res := XMLType('');
3697: END IF;
3698: Dbms_Lob.append(xml_clob, abstracts_res.getCLOBVal());

Line 3696: abstracts_res := XMLType('');

3692: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'ABSTRACT_AND_FORMS');
3693: DBMS_XMLGEN.SetRowTag(queryCtx, 'ABSTRACT_AND_FORMS_ROW');
3694: DBMS_XMLGEN.getXMLType(queryCtx, abstracts_res, DBMS_XMLGEN.NONE);
3695: IF abstracts_res IS NULL THEN
3696: abstracts_res := XMLType('');
3697: END IF;
3698: Dbms_Lob.append(xml_clob, abstracts_res.getCLOBVal());
3699: DBMS_XMLGEN.closeContext (queryCtx);
3700: exception when others then

Line 3730: DBMS_XMLGEN.getXMLType(queryCtx, currency_res, DBMS_XMLGEN.NONE);

3726: BEGIN
3727: queryCtx := DBMS_XMLGEN.newContext(currency_cursor);
3728: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'CURRENCY');
3729: DBMS_XMLGEN.SetRowTag(queryCtx, 'CURRENCY_ROW');
3730: DBMS_XMLGEN.getXMLType(queryCtx, currency_res, DBMS_XMLGEN.NONE);
3731: IF currency_res IS NULL THEN
3732: currency_res := XMLType('');
3733: END IF;
3734: Dbms_Lob.append(xml_clob, currency_res.getCLOBVal());

Line 3732: currency_res := XMLType('');

3728: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'CURRENCY');
3729: DBMS_XMLGEN.SetRowTag(queryCtx, 'CURRENCY_ROW');
3730: DBMS_XMLGEN.getXMLType(queryCtx, currency_res, DBMS_XMLGEN.NONE);
3731: IF currency_res IS NULL THEN
3732: currency_res := XMLType('');
3733: END IF;
3734: Dbms_Lob.append(xml_clob, currency_res.getCLOBVal());
3735: DBMS_XMLGEN.closeContext (queryCtx);
3736: exception when others then

Line 3771: DBMS_XMLGEN.getXMLType(queryCtx, invited_supp_cur_res, DBMS_XMLGEN.NONE);

3767: BEGIN
3768: queryCtx := DBMS_XMLGEN.newContext(invited_supp_cur_cursor);
3769: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'INVITED_SUPPLIER_CURRENCY');
3770: DBMS_XMLGEN.SetRowTag(queryCtx, 'INVITED_SUPPLIER_CURRENCY_ROW');
3771: DBMS_XMLGEN.getXMLType(queryCtx, invited_supp_cur_res, DBMS_XMLGEN.NONE);
3772: IF invited_supp_cur_res IS NULL THEN
3773: invited_supp_cur_res := XMLType('');
3774: END IF;
3775: Dbms_Lob.append(xml_clob, invited_supp_cur_res.getCLOBVal());

Line 3773: invited_supp_cur_res := XMLType('');

3769: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'INVITED_SUPPLIER_CURRENCY');
3770: DBMS_XMLGEN.SetRowTag(queryCtx, 'INVITED_SUPPLIER_CURRENCY_ROW');
3771: DBMS_XMLGEN.getXMLType(queryCtx, invited_supp_cur_res, DBMS_XMLGEN.NONE);
3772: IF invited_supp_cur_res IS NULL THEN
3773: invited_supp_cur_res := XMLType('');
3774: END IF;
3775: Dbms_Lob.append(xml_clob, invited_supp_cur_res.getCLOBVal());
3776: DBMS_XMLGEN.closeContext (queryCtx);
3777: exception when others then

Line 3880: DBMS_XMLGEN.getXMLType(queryCtx, header_attr_res, DBMS_XMLGEN.NONE);

3876: BEGIN
3877: queryCtx := DBMS_XMLGEN.newContext(header_attr_cursor);
3878: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'GROUP_HEADER_ATTRIBUTES');
3879: DBMS_XMLGEN.SetRowTag(queryCtx, 'GROUP_HEADER_ATTRIBUTES_ROW');
3880: DBMS_XMLGEN.getXMLType(queryCtx, header_attr_res, DBMS_XMLGEN.NONE);
3881: IF header_attr_res IS NULL THEN
3882: header_attr_res := XMLType('');
3883: END IF;
3884: Dbms_Lob.append(xml_clob, header_attr_res.getCLOBVal());

Line 3882: header_attr_res := XMLType('');

3878: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'GROUP_HEADER_ATTRIBUTES');
3879: DBMS_XMLGEN.SetRowTag(queryCtx, 'GROUP_HEADER_ATTRIBUTES_ROW');
3880: DBMS_XMLGEN.getXMLType(queryCtx, header_attr_res, DBMS_XMLGEN.NONE);
3881: IF header_attr_res IS NULL THEN
3882: header_attr_res := XMLType('');
3883: END IF;
3884: Dbms_Lob.append(xml_clob, header_attr_res.getCLOBVal());
3885: DBMS_XMLGEN.closeContext (queryCtx);
3886: exception when others then

Line 3919: DBMS_XMLGEN.getXMLType(queryCtx, invited_supp_res, DBMS_XMLGEN.NONE);

3915: BEGIN
3916: queryCtx := DBMS_XMLGEN.newContext(invited_supp_cursor);
3917: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'INVITED_SUPPLIERS');
3918: DBMS_XMLGEN.SetRowTag(queryCtx, 'INVITED_SUPPLIERS_ROW');
3919: DBMS_XMLGEN.getXMLType(queryCtx, invited_supp_res, DBMS_XMLGEN.NONE);
3920: IF invited_supp_res IS NULL THEN
3921: invited_supp_res := XMLType('');
3922: END IF;
3923: Dbms_Lob.append(xml_clob, invited_supp_res.getCLOBVal());

Line 3921: invited_supp_res := XMLType('');

3917: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'INVITED_SUPPLIERS');
3918: DBMS_XMLGEN.SetRowTag(queryCtx, 'INVITED_SUPPLIERS_ROW');
3919: DBMS_XMLGEN.getXMLType(queryCtx, invited_supp_res, DBMS_XMLGEN.NONE);
3920: IF invited_supp_res IS NULL THEN
3921: invited_supp_res := XMLType('');
3922: END IF;
3923: Dbms_Lob.append(xml_clob, invited_supp_res.getCLOBVal());
3924: DBMS_XMLGEN.closeContext (queryCtx);
3925: exception when others then

Line 3961: DBMS_XMLGEN.getXMLType(queryCtx, line_pf_res, DBMS_XMLGEN.NONE);

3957: BEGIN
3958: queryCtx := DBMS_XMLGEN.newContext(line_pf_cursor);
3959: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'LINE_PRICE_PF_DETAILS');
3960: DBMS_XMLGEN.SetRowTag(queryCtx, 'LINE_PRICE_PF_DETAILS_ROW');
3961: DBMS_XMLGEN.getXMLType(queryCtx, line_pf_res, DBMS_XMLGEN.NONE);
3962: IF line_pf_res IS NULL THEN
3963: line_pf_res := XMLType('');
3964: END IF;
3965: Dbms_Lob.append(xml_clob, line_pf_res.getCLOBVal());

Line 3963: line_pf_res := XMLType('');

3959: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'LINE_PRICE_PF_DETAILS');
3960: DBMS_XMLGEN.SetRowTag(queryCtx, 'LINE_PRICE_PF_DETAILS_ROW');
3961: DBMS_XMLGEN.getXMLType(queryCtx, line_pf_res, DBMS_XMLGEN.NONE);
3962: IF line_pf_res IS NULL THEN
3963: line_pf_res := XMLType('');
3964: END IF;
3965: Dbms_Lob.append(xml_clob, line_pf_res.getCLOBVal());
3966: DBMS_XMLGEN.closeContext (queryCtx);
3967: exception when others then

Line 4002: DBMS_XMLGEN.getXMLType(queryCtx, buyer_pf_res, DBMS_XMLGEN.NONE);

3998: BEGIN
3999: queryCtx := DBMS_XMLGEN.newContext(buyer_pf_cursor);
4000: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'BUYER_PF_VALUES');
4001: DBMS_XMLGEN.SetRowTag(queryCtx, 'BUYER_PF_VALUES_ROW');
4002: DBMS_XMLGEN.getXMLType(queryCtx, buyer_pf_res, DBMS_XMLGEN.NONE);
4003: IF buyer_pf_res IS NULL THEN
4004: buyer_pf_res := XMLType('');
4005: END IF;
4006: Dbms_Lob.append(xml_clob, buyer_pf_res.getCLOBVal());

Line 4004: buyer_pf_res := XMLType('');

4000: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'BUYER_PF_VALUES');
4001: DBMS_XMLGEN.SetRowTag(queryCtx, 'BUYER_PF_VALUES_ROW');
4002: DBMS_XMLGEN.getXMLType(queryCtx, buyer_pf_res, DBMS_XMLGEN.NONE);
4003: IF buyer_pf_res IS NULL THEN
4004: buyer_pf_res := XMLType('');
4005: END IF;
4006: Dbms_Lob.append(xml_clob, buyer_pf_res.getCLOBVal());
4007: DBMS_XMLGEN.closeContext (queryCtx);
4008: exception when others then

Line 4043: DBMS_XMLGEN.getXMLType(queryCtx, dist_buyer_pf_res, DBMS_XMLGEN.NONE);

4039: BEGIN
4040: queryCtx := DBMS_XMLGEN.newContext(dist_buyer_pf_cursor);
4041: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'DISTINCT_BUYER_PFS');
4042: DBMS_XMLGEN.SetRowTag(queryCtx, 'DISTINCT_BUYER_PFS_ROW');
4043: DBMS_XMLGEN.getXMLType(queryCtx, dist_buyer_pf_res, DBMS_XMLGEN.NONE);
4044: IF dist_buyer_pf_res IS NULL THEN
4045: dist_buyer_pf_res := XMLType('');
4046: END IF;
4047: Dbms_Lob.append(xml_clob, dist_buyer_pf_res.getCLOBVal());

Line 4045: dist_buyer_pf_res := XMLType('');

4041: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'DISTINCT_BUYER_PFS');
4042: DBMS_XMLGEN.SetRowTag(queryCtx, 'DISTINCT_BUYER_PFS_ROW');
4043: DBMS_XMLGEN.getXMLType(queryCtx, dist_buyer_pf_res, DBMS_XMLGEN.NONE);
4044: IF dist_buyer_pf_res IS NULL THEN
4045: dist_buyer_pf_res := XMLType('');
4046: END IF;
4047: Dbms_Lob.append(xml_clob, dist_buyer_pf_res.getCLOBVal());
4048: DBMS_XMLGEN.closeContext (queryCtx);
4049: exception when others then

Line 4081: DBMS_XMLGEN.getXMLType(queryCtx, large_neg_bur_pf_res, DBMS_XMLGEN.NONE);

4077: BEGIN
4078: queryCtx := DBMS_XMLGEN.newContext(large_neg_bur_pf_cursor);
4079: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'LARGE_NEG_BUYER_PF_VALUES');
4080: DBMS_XMLGEN.SetRowTag(queryCtx, 'LARGE_NEG_BUYER_PF_VALUES_ROW');
4081: DBMS_XMLGEN.getXMLType(queryCtx, large_neg_bur_pf_res, DBMS_XMLGEN.NONE);
4082: IF large_neg_bur_pf_res IS NULL THEN
4083: large_neg_bur_pf_res := XMLType('');
4084: END IF;
4085: Dbms_Lob.append(xml_clob, large_neg_bur_pf_res.getCLOBVal());

Line 4083: large_neg_bur_pf_res := XMLType('');

4079: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'LARGE_NEG_BUYER_PF_VALUES');
4080: DBMS_XMLGEN.SetRowTag(queryCtx, 'LARGE_NEG_BUYER_PF_VALUES_ROW');
4081: DBMS_XMLGEN.getXMLType(queryCtx, large_neg_bur_pf_res, DBMS_XMLGEN.NONE);
4082: IF large_neg_bur_pf_res IS NULL THEN
4083: large_neg_bur_pf_res := XMLType('');
4084: END IF;
4085: Dbms_Lob.append(xml_clob, large_neg_bur_pf_res.getCLOBVal());
4086: DBMS_XMLGEN.closeContext (queryCtx);
4087: exception when others then

Line 4177: DBMS_XMLGEN.getXMLType(queryCtx, pb_loc_res, DBMS_XMLGEN.NONE);

4173: BEGIN
4174: queryCtx := DBMS_XMLGEN.newContext(pb_loc_cursor);
4175: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'PRICE_BREAK_LOCATIONS');
4176: DBMS_XMLGEN.SetRowTag(queryCtx, 'PRICE_BREAK_LOCATIONS_ROW');
4177: DBMS_XMLGEN.getXMLType(queryCtx, pb_loc_res, DBMS_XMLGEN.NONE);
4178: IF pb_loc_res IS NULL THEN
4179: pb_loc_res := XMLType('');
4180: END IF;
4181: Dbms_Lob.append(xml_clob, pb_loc_res.getCLOBVal());

Line 4179: pb_loc_res := XMLType('');

4175: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'PRICE_BREAK_LOCATIONS');
4176: DBMS_XMLGEN.SetRowTag(queryCtx, 'PRICE_BREAK_LOCATIONS_ROW');
4177: DBMS_XMLGEN.getXMLType(queryCtx, pb_loc_res, DBMS_XMLGEN.NONE);
4178: IF pb_loc_res IS NULL THEN
4179: pb_loc_res := XMLType('');
4180: END IF;
4181: Dbms_Lob.append(xml_clob, pb_loc_res.getCLOBVal());
4182: DBMS_XMLGEN.closeContext (queryCtx);
4183: exception when others then

Line 4202: DBMS_XMLGEN.getXMLType(queryCtx, price_diff_types_res, DBMS_XMLGEN.NONE);

4198: BEGIN
4199: queryCtx := DBMS_XMLGEN.newContext(price_diff_types_cursor);
4200: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'PRICE_DIFFERENTIAL_TYPES');
4201: DBMS_XMLGEN.SetRowTag(queryCtx, 'PRICE_DIFFERENTIAL_TYPES_ROW');
4202: DBMS_XMLGEN.getXMLType(queryCtx, price_diff_types_res, DBMS_XMLGEN.NONE);
4203: IF price_diff_types_res IS NULL THEN
4204: price_diff_types_res := XMLType('');
4205: END IF;
4206: Dbms_Lob.append(xml_clob, price_diff_types_res.getCLOBVal());

Line 4204: price_diff_types_res := XMLType('');

4200: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'PRICE_DIFFERENTIAL_TYPES');
4201: DBMS_XMLGEN.SetRowTag(queryCtx, 'PRICE_DIFFERENTIAL_TYPES_ROW');
4202: DBMS_XMLGEN.getXMLType(queryCtx, price_diff_types_res, DBMS_XMLGEN.NONE);
4203: IF price_diff_types_res IS NULL THEN
4204: price_diff_types_res := XMLType('');
4205: END IF;
4206: Dbms_Lob.append(xml_clob, price_diff_types_res.getCLOBVal());
4207: DBMS_XMLGEN.closeContext (queryCtx);
4208: exception when others then

Line 4365: DBMS_XMLGEN.getXMLType(queryCtx, attachments_res, DBMS_XMLGEN.NONE);

4361: BEGIN
4362: queryCtx := DBMS_XMLGEN.newContext(attachments_cursor);
4363: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'ATTACHMENTS');
4364: DBMS_XMLGEN.SetRowTag(queryCtx, 'ATTACHMENTS_ROW');
4365: DBMS_XMLGEN.getXMLType(queryCtx, attachments_res, DBMS_XMLGEN.NONE);
4366: IF attachments_res IS NULL THEN
4367: attachments_res := XMLType('');
4368: END IF;
4369: Dbms_Lob.append(xml_clob, attachments_res.getCLOBVal());

Line 4367: attachments_res := XMLType('');

4363: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'ATTACHMENTS');
4364: DBMS_XMLGEN.SetRowTag(queryCtx, 'ATTACHMENTS_ROW');
4365: DBMS_XMLGEN.getXMLType(queryCtx, attachments_res, DBMS_XMLGEN.NONE);
4366: IF attachments_res IS NULL THEN
4367: attachments_res := XMLType('');
4368: END IF;
4369: Dbms_Lob.append(xml_clob, attachments_res.getCLOBVal());
4370: DBMS_XMLGEN.closeContext (queryCtx);
4371: exception when others then

Line 4425: DBMS_XMLGEN.getXMLType(queryCtx, doc_rules_res, DBMS_XMLGEN.NONE);

4421: BEGIN
4422: queryCtx := DBMS_XMLGEN.newContext(doc_rules_cursor);
4423: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'DOCUMENT_TYPE_RULES');
4424: DBMS_XMLGEN.SetRowTag(queryCtx, 'DOCUMENT_TYPE_RULES_ROW');
4425: DBMS_XMLGEN.getXMLType(queryCtx, doc_rules_res, DBMS_XMLGEN.NONE);
4426: IF doc_rules_res IS NULL THEN
4427: doc_rules_res := XMLType('');
4428: END IF;
4429: Dbms_Lob.append(xml_clob, doc_rules_res.getCLOBVal());

Line 4427: doc_rules_res := XMLType('');

4423: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'DOCUMENT_TYPE_RULES');
4424: DBMS_XMLGEN.SetRowTag(queryCtx, 'DOCUMENT_TYPE_RULES_ROW');
4425: DBMS_XMLGEN.getXMLType(queryCtx, doc_rules_res, DBMS_XMLGEN.NONE);
4426: IF doc_rules_res IS NULL THEN
4427: doc_rules_res := XMLType('');
4428: END IF;
4429: Dbms_Lob.append(xml_clob, doc_rules_res.getCLOBVal());
4430: DBMS_XMLGEN.closeContext (queryCtx);
4431: exception when others then

Line 4772: DBMS_XMLGEN.getXMLType(queryCtx, generic_msgs_res, DBMS_XMLGEN.NONE);

4768: BEGIN
4769: queryCtx := DBMS_XMLGEN.newContext(generic_msgs_cursor);
4770: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'GENERIC_MESSAGES');
4771: DBMS_XMLGEN.SetRowTag(queryCtx, 'GENERIC_MESSAGES_ROW');
4772: DBMS_XMLGEN.getXMLType(queryCtx, generic_msgs_res, DBMS_XMLGEN.NONE);
4773: IF generic_msgs_res IS NULL THEN
4774: generic_msgs_res := XMLType('');
4775: END IF;
4776: Dbms_Lob.append(xml_clob, generic_msgs_res.getCLOBVal());

Line 4774: generic_msgs_res := XMLType('');

4770: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'GENERIC_MESSAGES');
4771: DBMS_XMLGEN.SetRowTag(queryCtx, 'GENERIC_MESSAGES_ROW');
4772: DBMS_XMLGEN.getXMLType(queryCtx, generic_msgs_res, DBMS_XMLGEN.NONE);
4773: IF generic_msgs_res IS NULL THEN
4774: generic_msgs_res := XMLType('');
4775: END IF;
4776: Dbms_Lob.append(xml_clob, generic_msgs_res.getCLOBVal());
4777: DBMS_XMLGEN.closeContext (queryCtx);
4778: exception when others then

Line 4807: DBMS_XMLGEN.getXMLType(queryCtx, doc_msgs_res, DBMS_XMLGEN.NONE);

4803: BEGIN
4804: queryCtx := DBMS_XMLGEN.newContext(doc_msgs_cursor);
4805: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'DOCUMENT_SPECIFIC_MESSAGES');
4806: DBMS_XMLGEN.SetRowTag(queryCtx, 'DOCUMENT_SPECIFIC_MESSAGES_ROW');
4807: DBMS_XMLGEN.getXMLType(queryCtx, doc_msgs_res, DBMS_XMLGEN.NONE);
4808: IF doc_msgs_res IS NULL THEN
4809: doc_msgs_res := XMLType('');
4810: END IF;
4811: Dbms_Lob.append(xml_clob, doc_msgs_res.getCLOBVal());

Line 4809: doc_msgs_res := XMLType('');

4805: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'DOCUMENT_SPECIFIC_MESSAGES');
4806: DBMS_XMLGEN.SetRowTag(queryCtx, 'DOCUMENT_SPECIFIC_MESSAGES_ROW');
4807: DBMS_XMLGEN.getXMLType(queryCtx, doc_msgs_res, DBMS_XMLGEN.NONE);
4808: IF doc_msgs_res IS NULL THEN
4809: doc_msgs_res := XMLType('');
4810: END IF;
4811: Dbms_Lob.append(xml_clob, doc_msgs_res.getCLOBVal());
4812: DBMS_XMLGEN.closeContext (queryCtx);
4813: exception when others then