APPS.PO_EDA_DATATEMPLATE_PKG dependencies on XMLTYPE

Line 427: l_uda_xml XMLTYPE;

423: L_OP VARCHAR2(32767);
424: L_ATTR_GRP NUMBER;
425: L_CTR NUMBER;
426: L_O_CTR NUMBER;
427: l_uda_xml XMLTYPE;
428: L_SQL2 VARCHAR2(32767);
429: l_value VARCHAR2(4000);
430:
431: BEGIN

Line 501: l_uda_xml XMLTYPE;

497: L_OP VARCHAR2(32767);
498: L_ATTR_GRP NUMBER;
499: L_CTR NUMBER;
500: L_O_CTR NUMBER;
501: l_uda_xml XMLTYPE;
502: BEGIN
503:
504: FOR c IN c_line LOOP
505: DELETE FROM po_eda_uda_attr_values WHERE pk1_value = c.po_line_id AND lvl='AWARDLINE' AND pk2_value = DRAFTID;

Line 575: l_uda_xml XMLTYPE;

571: L_OP VARCHAR2(32767);
572: L_ATTR_GRP NUMBER;
573: L_CTR NUMBER;
574: L_O_CTR NUMBER;
575: l_uda_xml XMLTYPE;
576: L_SQL2 VARCHAR2(32767);
577: l_value VARCHAR2(4000);
578:
579:

Line 901: l_xml XMLType;

897: l_change_flag VARCHAR2(50);
898: l_change_text VARCHAR2(4000);
899: l_ele_exists VARCHAR2(1):='N';
900: l_clob CLOB;
901: l_xml XMLType;
902:
903: BEGIN
904:
905: OPEN c_ele_exists;