DBA Data[Home] [Help]

APPS.CZ_PB_MGR dependencies on JDR_DOCBUILDER

Line 2669: RETURN jdr_docbuilder.ELEMENT

2665: END get_oa_uis;
2666:
2667: -------------------
2668: FUNCTION createelement(p_namespace IN OUT NOCOPY VARCHAR2, p_tagname IN VARCHAR2)
2669: RETURN jdr_docbuilder.ELEMENT
2670: IS
2671: l_child_element jdr_docbuilder.ELEMENT;
2672: BEGIN
2673: IF (p_namespace IS NULL)

Line 2671: l_child_element jdr_docbuilder.ELEMENT;

2667: -------------------
2668: FUNCTION createelement(p_namespace IN OUT NOCOPY VARCHAR2, p_tagname IN VARCHAR2)
2669: RETURN jdr_docbuilder.ELEMENT
2670: IS
2671: l_child_element jdr_docbuilder.ELEMENT;
2672: BEGIN
2673: IF (p_namespace IS NULL)
2674: THEN
2675: p_namespace := 'jrad:';

Line 2678: l_child_element := jdr_docbuilder.createelement(p_namespace, p_tagname);

2674: THEN
2675: p_namespace := 'jrad:';
2676: END IF;
2677:
2678: l_child_element := jdr_docbuilder.createelement(p_namespace, p_tagname);
2679: RETURN l_child_element;
2680: EXCEPTION
2681: WHEN OTHERS
2682: THEN

Line 2804: p_jrad_parent_element IN jdr_docbuilder.ELEMENT

2800: END;
2801:
2802: -----------------------------------------------------
2803: PROCEDURE exploretree(
2804: p_jrad_parent_element IN jdr_docbuilder.ELEMENT
2805: ,p_dom_parent_element IN xmldom.domnode
2806: ,p_grouping_tag IN VARCHAR2
2807: ,p_link_name IN VARCHAR2
2808: )

Line 2825: l_parent_element jdr_docbuilder.ELEMENT;

2821: attrval VARCHAR2(4000);
2822: l_groupingns VARCHAR2(255);
2823: l_groupingtagname VARCHAR2(255);
2824: l_grouping_tag VARCHAR2(255);
2825: l_parent_element jdr_docbuilder.ELEMENT;
2826: l_child_element jdr_docbuilder.ELEMENT;
2827: l_ampers VARCHAR2(1) := fnd_global.local_chr(38);
2828: l_parent_tag_name VARCHAR2(255);
2829: BEGIN

Line 2826: l_child_element jdr_docbuilder.ELEMENT;

2822: l_groupingns VARCHAR2(255);
2823: l_groupingtagname VARCHAR2(255);
2824: l_grouping_tag VARCHAR2(255);
2825: l_parent_element jdr_docbuilder.ELEMENT;
2826: l_child_element jdr_docbuilder.ELEMENT;
2827: l_ampers VARCHAR2(1) := fnd_global.local_chr(38);
2828: l_parent_tag_name VARCHAR2(255);
2829: BEGIN
2830: l_child_nodes := xmldom.getchildnodes(p_dom_parent_element);

Line 2874: jdr_docbuilder.setattribute(l_child_element, attrname, attrval);

2870: attrval := REPLACE(attrval, '>', l_ampers || 'gt;');
2871: attrval := REPLACE(attrval, '<', l_ampers || 'lt;');
2872: attrval := REPLACE(attrval, '"', l_ampers || 'quot;');
2873: attrval := REPLACE(attrval, '''', l_ampers || 'apos;');
2874: jdr_docbuilder.setattribute(l_child_element, attrname, attrval);
2875: END LOOP;
2876: END IF;
2877:
2878: l_groupingns := SUBSTR(p_grouping_tag, 1, INSTR(p_grouping_tag, ':'));

Line 2886: jdr_docbuilder.addchild(p_jrad_parent_element, l_groupingns, l_groupingtagname, l_child_element);

2882: THEN
2883: l_groupingns := 'jrad:';
2884: END IF;
2885:
2886: jdr_docbuilder.addchild(p_jrad_parent_element, l_groupingns, l_groupingtagname, l_child_element);
2887: exploretree(l_child_element, l_child_node, l_grouping_tag, p_link_name);
2888: ELSE
2889: l_namespace := SUBSTR(xmldom.getnodename(l_child_node), 1, INSTR(xmldom.getnodename(l_child_node), ':'));
2890: l_tagname := SUBSTR(xmldom.getnodename(l_child_node), INSTR(xmldom.getnodename(l_child_node), ':') + 1);

Line 2905: jdr_docbuilder.setattribute(l_child_element, attrname, attrval);

2901: attrval := REPLACE(attrval, '>', l_ampers || 'gt;');
2902: attrval := REPLACE(attrval, '<', l_ampers || 'lt;');
2903: attrval := REPLACE(attrval, '"', l_ampers || 'quot;');
2904: attrval := REPLACE(attrval, '''', l_ampers || 'apos;');
2905: jdr_docbuilder.setattribute(l_child_element, attrname, attrval);
2906: END LOOP;
2907: END IF;
2908:
2909: IF (l_grouping_tag IS NULL)

Line 2911: jdr_docbuilder.addchild(p_jrad_parent_element, l_child_element);

2907: END IF;
2908:
2909: IF (l_grouping_tag IS NULL)
2910: THEN
2911: jdr_docbuilder.addchild(p_jrad_parent_element, l_child_element);
2912: exploretree(l_child_element, l_child_node, l_grouping_tag, p_link_name);
2913: ELSE
2914: exploretree(p_jrad_parent_element, l_child_node, l_grouping_tag, p_link_name);
2915: END IF;

Line 2998: jdr_docbuilder.REFRESH;

2994: pbdebug := 22021;
2995: x_return_status := FND_API.G_RET_STS_SUCCESS;
2996: x_msg_count := 0;
2997: x_msg_data := '';
2998: jdr_docbuilder.REFRESH;
2999:
3000: IF (p_document_name IS NULL) THEN
3001: RAISE document_is_null;
3002: END IF;

Line 3041: jdr_docbuilder.REFRESH;

3037: END LOOP;
3038: END IF;
3039:
3040: COMMIT;
3041: jdr_docbuilder.REFRESH;
3042: EXCEPTION
3043: WHEN document_is_null THEN
3044: x_return_status := FND_API.G_RET_STS_ERROR;
3045: x_msg_count := 1;

Line 3106: jdr_docbuilder.REFRESH;

3102: pbdebug := 22022;
3103: x_return_status := FND_API.G_RET_STS_SUCCESS;
3104: x_msg_count := 0;
3105: x_msg_data := '';
3106: jdr_docbuilder.REFRESH;
3107:
3108: IF (p_document_name IS NULL) THEN
3109: RAISE document_is_null;
3110: END IF;

Line 3223: jdr_docbuilder.REFRESH;

3219: END LOOP;
3220: END IF;
3221:
3222: COMMIT;
3223: jdr_docbuilder.REFRESH;
3224: EXCEPTION
3225: WHEN document_is_null THEN
3226: x_return_status := FND_API.G_RET_STS_ERROR;
3227: x_msg_count := 1;

Line 3277: l_doc jdr_docbuilder.document;

3273: attrval VARCHAR2(255);
3274: newattrname VARCHAR2(255);
3275: name_space VARCHAR2(255);
3276: tag_name VARCHAR2(255);
3277: l_doc jdr_docbuilder.document;
3278: top_element jdr_docbuilder.ELEMENT;
3279: g_document jdr_docbuilder.document;
3280: l_new_document jdr_docbuilder.document;
3281: jrad_save_status PLS_INTEGER;

Line 3278: top_element jdr_docbuilder.ELEMENT;

3274: newattrname VARCHAR2(255);
3275: name_space VARCHAR2(255);
3276: tag_name VARCHAR2(255);
3277: l_doc jdr_docbuilder.document;
3278: top_element jdr_docbuilder.ELEMENT;
3279: g_document jdr_docbuilder.document;
3280: l_new_document jdr_docbuilder.document;
3281: jrad_save_status PLS_INTEGER;
3282: document_is_null EXCEPTION;

Line 3279: g_document jdr_docbuilder.document;

3275: name_space VARCHAR2(255);
3276: tag_name VARCHAR2(255);
3277: l_doc jdr_docbuilder.document;
3278: top_element jdr_docbuilder.ELEMENT;
3279: g_document jdr_docbuilder.document;
3280: l_new_document jdr_docbuilder.document;
3281: jrad_save_status PLS_INTEGER;
3282: document_is_null EXCEPTION;
3283: l_msg VARCHAR2(2000);

Line 3280: l_new_document jdr_docbuilder.document;

3276: tag_name VARCHAR2(255);
3277: l_doc jdr_docbuilder.document;
3278: top_element jdr_docbuilder.ELEMENT;
3279: g_document jdr_docbuilder.document;
3280: l_new_document jdr_docbuilder.document;
3281: jrad_save_status PLS_INTEGER;
3282: document_is_null EXCEPTION;
3283: l_msg VARCHAR2(2000);
3284:

Line 3294: jdr_docbuilder.REFRESH;

3290:
3291: OPEN jrad_docs_cur;
3292:
3293: LOOP
3294: jdr_docbuilder.REFRESH;
3295:
3296: FETCH jrad_docs_cur
3297: INTO l_jrad_doc;
3298:

Line 3336: l_doc := jdr_docbuilder.createdocument(l_jrad_doc);

3332: xmlparser.parseclob(p, l_lob);
3333: doc := xmlparser.getdocument(p);
3334: SYS.DBMS_LOB.CLOSE(l_lob);
3335: SYS.DBMS_LOB.freetemporary(l_lob);
3336: l_doc := jdr_docbuilder.createdocument(l_jrad_doc);
3337: top_node := xmldom.makenode(xmldom.getdocumentelement(doc));
3338:
3339: IF (g_toplevel_attr_tbl.COUNT > 0)
3340: THEN

Line 3367: jdr_docbuilder.setattribute(top_element, attrname, attrval);

3363: LOOP
3364: n := xmldom.item(nnm, i);
3365: attrname := xmldom.getnodename(n);
3366: attrval := xmldom.getnodevalue(n);
3367: jdr_docbuilder.setattribute(top_element, attrname, attrval);
3368: END LOOP;
3369: END IF;
3370:
3371: jdr_docbuilder.settoplevelelement(l_doc, top_element);

Line 3371: jdr_docbuilder.settoplevelelement(l_doc, top_element);

3367: jdr_docbuilder.setattribute(top_element, attrname, attrval);
3368: END LOOP;
3369: END IF;
3370:
3371: jdr_docbuilder.settoplevelelement(l_doc, top_element);
3372:
3373: BEGIN
3374: exploretree(top_element, top_node, '', ' ');
3375: EXCEPTION

Line 3381: jrad_save_status := jdr_docbuilder.SAVE;

3377: THEN
3378: RAISE_APPLICATION_ERROR(-20001, 'EXPLORETREE_ERROR') ;
3379: END;
3380:
3381: jrad_save_status := jdr_docbuilder.SAVE;
3382: xmlparser.freeparser(p);
3383: xmldom.freeDocument(doc);
3384: COMMIT;
3385: jdr_docbuilder.REFRESH;

Line 3385: jdr_docbuilder.REFRESH;

3381: jrad_save_status := jdr_docbuilder.SAVE;
3382: xmlparser.freeparser(p);
3383: xmldom.freeDocument(doc);
3384: COMMIT;
3385: jdr_docbuilder.REFRESH;
3386: END LOOP;
3387:
3388: CLOSE jrad_docs_cur;
3389:

Line 3395: jdr_docbuilder.REFRESH;

3391: EXCEPTION
3392: WHEN OTHERS
3393: THEN
3394: ROLLBACK;
3395: jdr_docbuilder.REFRESH;
3396: IF l_jrad_doc is not null THEN
3397: l_msg := l_jrad_doc || '-' || SQLERRM;
3398: ELSE
3399: l_msg := SQLERRM;

Line 3633: l_doc jdr_docbuilder.document;

3629: attrval VARCHAR2(255);
3630: newattrname VARCHAR2(255);
3631: name_space VARCHAR2(255);
3632: tag_name VARCHAR2(255);
3633: l_doc jdr_docbuilder.document;
3634: top_element jdr_docbuilder.ELEMENT;
3635: g_document jdr_docbuilder.document;
3636: l_new_document jdr_docbuilder.document;
3637: jrad_save_status PLS_INTEGER;

Line 3634: top_element jdr_docbuilder.ELEMENT;

3630: newattrname VARCHAR2(255);
3631: name_space VARCHAR2(255);
3632: tag_name VARCHAR2(255);
3633: l_doc jdr_docbuilder.document;
3634: top_element jdr_docbuilder.ELEMENT;
3635: g_document jdr_docbuilder.document;
3636: l_new_document jdr_docbuilder.document;
3637: jrad_save_status PLS_INTEGER;
3638: document_is_null EXCEPTION;

Line 3635: g_document jdr_docbuilder.document;

3631: name_space VARCHAR2(255);
3632: tag_name VARCHAR2(255);
3633: l_doc jdr_docbuilder.document;
3634: top_element jdr_docbuilder.ELEMENT;
3635: g_document jdr_docbuilder.document;
3636: l_new_document jdr_docbuilder.document;
3637: jrad_save_status PLS_INTEGER;
3638: document_is_null EXCEPTION;
3639:

Line 3636: l_new_document jdr_docbuilder.document;

3632: tag_name VARCHAR2(255);
3633: l_doc jdr_docbuilder.document;
3634: top_element jdr_docbuilder.ELEMENT;
3635: g_document jdr_docbuilder.document;
3636: l_new_document jdr_docbuilder.document;
3637: jrad_save_status PLS_INTEGER;
3638: document_is_null EXCEPTION;
3639:
3640: TYPE char_tbl_type IS TABLE OF VARCHAR2(255);

Line 3646: jdr_docbuilder.REFRESH;

3642: g_toplevel_attr_tbl char_tbl_type := char_tbl_type('version', 'xml:lang', 'xmlns:oa', 'xmlns:ui', 'xmlns:jrad', 'xmlns:user', 'xmlns');
3643: l_exportfinished BOOLEAN;
3644: BEGIN
3645: pbdebug := 22027;
3646: jdr_docbuilder.REFRESH;
3647:
3648: IF (p_old_document_name IS NULL)
3649: THEN
3650: RAISE document_is_null;

Line 3699: l_doc := jdr_docbuilder.createdocument(p_new_document_name);

3695: xmlparser.parseclob(p, l_lob);
3696: doc := xmlparser.getdocument(p);
3697: SYS.DBMS_LOB.CLOSE(l_lob);
3698: SYS.DBMS_LOB.freetemporary(l_lob);
3699: l_doc := jdr_docbuilder.createdocument(p_new_document_name);
3700: top_node := xmldom.makenode(xmldom.getdocumentelement(doc));
3701:
3702: IF (g_toplevel_attr_tbl.COUNT > 0)
3703: THEN

Line 3730: jdr_docbuilder.setattribute(top_element, attrname, attrval);

3726: LOOP
3727: n := xmldom.item(nnm, i);
3728: attrname := xmldom.getnodename(n);
3729: attrval := xmldom.getnodevalue(n);
3730: jdr_docbuilder.setattribute(top_element, attrname, attrval);
3731: END LOOP;
3732: END IF;
3733:
3734: jdr_docbuilder.settoplevelelement(l_doc, top_element);

Line 3734: jdr_docbuilder.settoplevelelement(l_doc, top_element);

3730: jdr_docbuilder.setattribute(top_element, attrname, attrval);
3731: END LOOP;
3732: END IF;
3733:
3734: jdr_docbuilder.settoplevelelement(l_doc, top_element);
3735:
3736: BEGIN
3737: exploretree(top_element, top_node, '', ' ');
3738: EXCEPTION

Line 3744: jrad_save_status := jdr_docbuilder.SAVE;

3740: THEN
3741: RAISE_APPLICATION_ERROR(-20001, 'EXPLORETREE_ERROR') ;
3742: END;
3743:
3744: jrad_save_status := jdr_docbuilder.SAVE;
3745: xmlparser.freeparser(p);
3746: COMMIT;
3747: cz_pb_mgr.g_jrad_trans_list := jdr_utils.translationlist();
3748: cz_pb_mgr.g_jrad_trans_list := jdr_utils.gettranslations(p_old_document_name);

Line 3755: jdr_docbuilder.REFRESH;

3751: THEN
3752: jdr_utils.savetranslations(p_new_document_name, cz_pb_mgr.g_jrad_trans_list);
3753: END IF;
3754:
3755: jdr_docbuilder.REFRESH;
3756: COMMIT;
3757: EXCEPTION
3758: WHEN document_is_null
3759: THEN

Line 3763: EXECUTE IMMEDIATE 'BEGIN jdr_docbuilder.refresh; END;';

3759: THEN
3760: NULL;
3761: WHEN OTHERS
3762: THEN
3763: EXECUTE IMMEDIATE 'BEGIN jdr_docbuilder.refresh; END;';
3764:
3765: RAISE;
3766: END insert_into_repository;
3767:

Line 3783: jdr_docbuilder.REFRESH;

3779: pbdebug := 22028;
3780:
3781: IF (cz_pb_mgr.v_server_id <> 0)
3782: THEN
3783: jdr_docbuilder.REFRESH;
3784:
3785: IF (p_old_document_name IS NULL)
3786: THEN
3787: RAISE document_is_null;

Line 3816: EXECUTE IMMEDIATE 'BEGIN jdr_docbuilder.refresh; END;';

3812:
3813: RAISE;
3814: WHEN OTHERS
3815: THEN
3816: EXECUTE IMMEDIATE 'BEGIN jdr_docbuilder.refresh; END;';
3817:
3818: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_JRAD_DOC_ERR', 'JRADDOC', p_old_document_name, 'SQLERRM', SQLERRM);
3819: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTOJRADREPOS', SQLCODE);
3820: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;