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 DBMS_LOB

Line 988: dbms_lob.createtemporary(result, TRUE);

984: and flv.language(+) = USERENV('LANG')
985: and flv.lookup_code(+) = pah.EMD_TYPE;
986: -- and fu.USER_ID = pah.CREATED_BY;
987:
988: dbms_lob.createtemporary(result, TRUE);
989:
990: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;
991:
992: xml_stmt := 'DECLARE

Line 1435: dbms_lob.createtemporary(result, TRUE);

1431: and HZ.party_id(+) = paha.trading_partner_contact_id;
1432: --END: Added by Chaoqun on 22-DEC-2008
1433: END IF;
1434:
1435: dbms_lob.createtemporary(result, TRUE);
1436:
1437: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;
1438:
1439: xml_stmt := 'DECLARE

Line 1655: dbms_lob.createtemporary(result, TRUE);

1651: and f1.lookup_type = 'PON_AUCTION_DOC_TYPES'
1652: and f1.lookup_code = doc.internal_name
1653: and hz.party_id(+) = paha.trading_partner_contact_id;
1654:
1655: dbms_lob.createtemporary(result, TRUE);
1656:
1657: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;
1658:
1659: xml_stmt := 'DECLARE

Line 2667: --dbms_lob.createtemporary(result, TRUE);

2663: and flv.language(+) = USERENV('LANG')
2664: and flv.lookup_code(+) = pah.EMD_TYPE;
2665: -------------------------------------------------
2666:
2667: --dbms_lob.createtemporary(result, TRUE);
2668:
2669: SELECT CURRENT_DATE INTO l_start_time FROM DUAL;
2670:
2671:

Line 2687: Dbms_Lob.append(xml_clob, '');

2683: END;
2684:
2685: CLOSE xml_query_cursor;
2686:
2687: Dbms_Lob.append(xml_clob, '');
2688: OPEN line_num_cur;
2689: LOOP
2690: FETCH line_num_cur INTO line_num;
2691:

Line 2897: Dbms_Lob.append(xml_clob, '');

2893: order by paip.disp_line_number;
2894:
2895: linesCtx := DBMS_XMLGEN.newContext(lines_cursor);
2896:
2897: Dbms_Lob.append(xml_clob, '');
2898: BEGIN
2899: DBMS_XMLGEN.SetRowSetTag(linesCtx, null);
2900: DBMS_XMLGEN.SetRowTag(linesCtx, null);
2901: lines_res := NULL;

Line 2903: Dbms_Lob.append(xml_clob, lines_res.getCLOBVal());

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;
2907: END;

Line 3077: Dbms_Lob.append(xml_clob, pay_items_res.getCLOBVal());

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);
3080: RAISE;
3081: END;

Line 3157: Dbms_Lob.append(xml_clob, line_attr_res.getCLOBVal());

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);
3160: RAISE;
3161: END;

Line 3254: Dbms_Lob.append(xml_clob, pf_res.getCLOBVal());

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);
3257: RAISE;
3258: END;

Line 3289: Dbms_Lob.append(xml_clob, line_price_diff_res.getCLOBVal());

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);
3292: RAISE;
3293: END;

Line 3383: Dbms_Lob.append(xml_clob, item_pb_res.getCLOBVal());

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);
3386: RAISE;
3387: END;

Line 3420: Dbms_Lob.append(xml_clob, item_price_diff_res.getCLOBVal());

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);
3423: RAISE;
3424: END;

Line 3484: Dbms_Lob.append(xml_clob, item_quan_res.getCLOBVal());

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);
3487: RAISE;
3488: END;

Line 3492: Dbms_Lob.append(xml_clob, '');

3488: END;
3489:
3490: CLOSE item_quan_cursor;
3491:
3492: Dbms_Lob.append(xml_clob, '');
3493: CLOSE lines_cursor;
3494: END LOOP;
3495: DBMS_XMLGEN.closeContext (linesCtx);
3496: DBMS_XMLGEN.closeContext (payItemsCtx);

Line 3503: Dbms_Lob.append(xml_clob, '');

3499: DBMS_XMLGEN.closeContext (linepdiffCtx);
3500: DBMS_XMLGEN.closeContext (itempbreaksCtx);
3501: DBMS_XMLGEN.closeContext (itempdiffsCtx);
3502: DBMS_XMLGEN.closeContext (quanTiersCtx);
3503: Dbms_Lob.append(xml_clob, '');
3504:
3505: CLOSE line_num_cur;
3506:
3507: OPEN collab_team_cursor FOR

Line 3565: Dbms_Lob.append(xml_clob, collab_team_res.getCLOBVal());

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
3568: DBMS_XMLGEN.closeContext (queryCtx);
3569: RAISE;

Line 3594: Dbms_Lob.append(xml_clob, scoring_team_res.getCLOBVal());

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
3597: DBMS_XMLGEN.closeContext (queryCtx);
3598: RAISE;

Line 3628: Dbms_Lob.append(xml_clob, scoring_mems_res.getCLOBVal());

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
3631: DBMS_XMLGEN.closeContext (queryCtx);
3632: RAISE;

Line 3661: Dbms_Lob.append(xml_clob, scoring_secs_res.getCLOBVal());

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
3664: DBMS_XMLGEN.closeContext (queryCtx);
3665: RAISE;

Line 3698: Dbms_Lob.append(xml_clob, abstracts_res.getCLOBVal());

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
3701: DBMS_XMLGEN.closeContext (queryCtx);
3702: RAISE;

Line 3734: Dbms_Lob.append(xml_clob, currency_res.getCLOBVal());

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
3737: DBMS_XMLGEN.closeContext (queryCtx);
3738: RAISE;

Line 3775: Dbms_Lob.append(xml_clob, invited_supp_cur_res.getCLOBVal());

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
3778: DBMS_XMLGEN.closeContext (queryCtx);
3779: RAISE;

Line 3884: Dbms_Lob.append(xml_clob, header_attr_res.getCLOBVal());

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
3887: DBMS_XMLGEN.closeContext (queryCtx);
3888: RAISE;

Line 3923: Dbms_Lob.append(xml_clob, invited_supp_res.getCLOBVal());

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
3926: DBMS_XMLGEN.closeContext (queryCtx);
3927: RAISE;

Line 3965: Dbms_Lob.append(xml_clob, line_pf_res.getCLOBVal());

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
3968: DBMS_XMLGEN.closeContext (queryCtx);
3969: RAISE;

Line 4006: Dbms_Lob.append(xml_clob, buyer_pf_res.getCLOBVal());

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
4009: DBMS_XMLGEN.closeContext (queryCtx);
4010: RAISE;

Line 4047: Dbms_Lob.append(xml_clob, dist_buyer_pf_res.getCLOBVal());

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
4050: DBMS_XMLGEN.closeContext (queryCtx);
4051: RAISE;

Line 4085: Dbms_Lob.append(xml_clob, large_neg_bur_pf_res.getCLOBVal());

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
4088: DBMS_XMLGEN.closeContext (queryCtx);
4089: RAISE;

Line 4181: Dbms_Lob.append(xml_clob, pb_loc_res.getCLOBVal());

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
4184: DBMS_XMLGEN.closeContext (queryCtx);
4185: RAISE;

Line 4206: Dbms_Lob.append(xml_clob, price_diff_types_res.getCLOBVal());

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
4209: DBMS_XMLGEN.closeContext (queryCtx);
4210: RAISE;

Line 4369: Dbms_Lob.append(xml_clob, attachments_res.getCLOBVal());

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
4372: DBMS_XMLGEN.closeContext (queryCtx);
4373: RAISE;

Line 4429: Dbms_Lob.append(xml_clob, doc_rules_res.getCLOBVal());

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
4432: DBMS_XMLGEN.closeContext (queryCtx);
4433: RAISE;

Line 4776: Dbms_Lob.append(xml_clob, generic_msgs_res.getCLOBVal());

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
4779: DBMS_XMLGEN.closeContext (queryCtx);
4780: RAISE;

Line 4811: Dbms_Lob.append(xml_clob, doc_msgs_res.getCLOBVal());

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
4814: DBMS_XMLGEN.closeContext (queryCtx);
4815: RAISE;

Line 4820: dbms_lob.createtemporary(res, TRUE);

4816: END;
4817:
4818: CLOSE doc_msgs_cursor;
4819:
4820: dbms_lob.createtemporary(res, TRUE);
4821: queryCtx := DBMS_XMLGEN.newContext('select null from dual');
4822: DBMS_XMLGEN.SetRowSetTag(queryCtx, null);
4823: DBMS_XMLGEN.SetRowTag(queryCtx, null);
4824: DBMS_XMLGEN.getXML(queryCtx, res, DBMS_XMLGEN.NONE);