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.PO_DATATEMPLATE_PKG dependencies on XMLTYPE

Line 106: RETURN XMLType IS

102: RETURN (bil_indicator);
103: END get_bilateral_indicator;
104:
105: FUNCTION GET_LINE_ATTRIBUTE_VAL_XML(p_categoryId NUMBER, p_lineId NUMBER)
106: RETURN XMLType IS
107: CURSOR C_ATTR_KEY IS
108: SELECT ICA.ATTRIBUTE_ID, ICA.RT_CATEGORY_ID, REPLACE(ICA.KEY, ' ', '_') KEY, ICA.STORED_IN_TABLE, ICA.STORED_IN_COLUMN
109: from icx_cat_agreement_attrs_v ICA where
110: (ICA.rt_category_id = p_categoryId

Line 118: po_attr_uda_xml XMLTYPE;

114: )) and language = userenv('lang');
115:
116: S_SQL VARCHAR2(32767);
117: T_CTR NUMBER;
118: po_attr_uda_xml XMLTYPE;
119: BEGIN
120:
121: T_CTR := 0 ;
122: FOR REC IN C_ATTR_KEY LOOP

Line 140: RETURN XMLType IS

136: RETURN (po_attr_uda_xml);
137: END GET_LINE_ATTRIBUTE_VAL_XML;
138:
139: FUNCTION GET_LINE_ATTR_VAL_DRAFT_XML(p_categoryId NUMBER, p_lineId NUMBER, p_draftId NUMBER)
140: RETURN XMLType IS
141: CURSOR C_ATTR_KEY IS
142: SELECT ICA.ATTRIBUTE_ID, ICA.RT_CATEGORY_ID, REPLACE(ICA.KEY, ' ', '_') KEY, ICA.STORED_IN_TABLE, ICA.STORED_IN_COLUMN
143: from icx_cat_agreement_attrs_v ICA where
144: (ICA.rt_category_id = p_categoryId

Line 152: po_attr_uda_xml XMLTYPE;

148: )) and language = userenv('lang');
149:
150: S_SQL VARCHAR2(32767);
151: T_CTR NUMBER;
152: po_attr_uda_xml XMLTYPE;
153: BEGIN
154:
155: T_CTR := 0 ;
156: FOR REC IN C_ATTR_KEY LOOP

Line 246: RETURN XMLType IS

242: return(l_sql);
243: end get_uda_attr_desc_sql;
244:
245: FUNCTION GET_UDA_HEADER_XML_PVT(p_headerId number, p_draft_id number)
246: RETURN XMLType IS
247: CURSOR C_ATTR_GRP IS
248: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
249: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
250: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,

Line 285: l_uda_xml XMLTYPE;

281: L_OP VARCHAR2(32767);
282: L_ATTR_GRP NUMBER;
283: L_CTR NUMBER;
284: L_O_CTR NUMBER;
285: l_uda_xml XMLTYPE;
286: BEGIN
287:
288: L_O_CTR := 0;
289: FOR REC IN C_ATTR_GRP LOOP

Line 343: return XMLType is

339: RETURN (l_uda_xml);
340: END GET_UDA_HEADER_XML_PVT;
341:
342: function get_uda_llxml_pvt(p_line_location_id number, p_draft_id number)
343: return XMLType is
344: CURSOR C_ATTR_GRP IS
345: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
346: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
347: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,

Line 382: l_uda_xml XMLTYPE;

378: L_OP VARCHAR2(32767);
379: L_ATTR_GRP NUMBER;
380: L_CTR NUMBER;
381: L_O_CTR NUMBER;
382: l_uda_xml XMLTYPE;
383:
384: BEGIN
385:
386: L_O_CTR := 0;

Line 444: RETURN XMLType IS

440:
441: end get_uda_llxml_pvt;
442:
443: FUNCTION get_uda_line_xml_pvt(p_po_line_id NUMBER, p_draft_id number)
444: RETURN XMLType IS
445: CURSOR C_ATTR_GRP IS
446: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
447: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
448: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,

Line 484: l_uda_xml XMLTYPE;

480: L_OP VARCHAR2(32767);
481: L_ATTR_GRP NUMBER;
482: L_CTR NUMBER;
483: L_O_CTR NUMBER;
484: l_uda_xml XMLTYPE;
485: BEGIN
486:
487: L_O_CTR := 0;
488: FOR REC IN C_ATTR_GRP LOOP

Line 542: FUNCTION GET_UDA_HEADER_XML RETURN XMLType IS

538: execute immediate l_op into l_uda_xml;
539: RETURN (l_uda_xml);
540: end get_uda_line_xml_pvt;
541:
542: FUNCTION GET_UDA_HEADER_XML RETURN XMLType IS
543: begin
544: return(get_uda_header_xml_pvt(pt_headerId, -1));
545: END GET_UDA_HEADER_XML;
546:

Line 547: FUNCTION GET_UDA_HEADER_DRAFTS_XML(p_headerid NUMBER) RETURN XMLType IS

543: begin
544: return(get_uda_header_xml_pvt(pt_headerId, -1));
545: END GET_UDA_HEADER_XML;
546:
547: FUNCTION GET_UDA_HEADER_DRAFTS_XML(p_headerid NUMBER) RETURN XMLType IS
548: begin
549: return(get_uda_header_xml_pvt(p_headerid, draftId));
550: END GET_UDA_HEADER_DRAFTS_XML;
551:

Line 552: FUNCTION GET_UDA_LINES_XML(p_line_id number) RETURN XMLType IS

548: begin
549: return(get_uda_header_xml_pvt(p_headerid, draftId));
550: END GET_UDA_HEADER_DRAFTS_XML;
551:
552: FUNCTION GET_UDA_LINES_XML(p_line_id number) RETURN XMLType IS
553: begin
554: return(get_uda_line_xml_pvt(p_line_id, -1));
555: END get_uda_lines_xml;
556:

Line 557: FUNCTION GET_UDA_LINES_DRAFTS_XML(p_po_line_id NUMBER) RETURN XMLType IS

553: begin
554: return(get_uda_line_xml_pvt(p_line_id, -1));
555: END get_uda_lines_xml;
556:
557: FUNCTION GET_UDA_LINES_DRAFTS_XML(p_po_line_id NUMBER) RETURN XMLType IS
558: begin
559: return(get_uda_line_xml_pvt(p_po_line_id, draftId));
560: END GET_UDA_LINES_DRAFTS_XML;
561:

Line 563: RETURN XMLType IS

559: return(get_uda_line_xml_pvt(p_po_line_id, draftId));
560: END GET_UDA_LINES_DRAFTS_XML;
561:
562: FUNCTION GET_UDA_Line_Locations_XML(p_line_location_id NUMBER)
563: RETURN XMLType IS
564: begin
565: return(get_uda_llxml_pvt(p_line_location_id, -1));
566: END GET_UDA_Line_Locations_XML;
567:

Line 568: FUNCTION GET_UDA_LL_DRAFTS_XML(p_line_location_id NUMBER) RETURN XMLType IS

564: begin
565: return(get_uda_llxml_pvt(p_line_location_id, -1));
566: END GET_UDA_Line_Locations_XML;
567:
568: FUNCTION GET_UDA_LL_DRAFTS_XML(p_line_location_id NUMBER) RETURN XMLType IS
569: begin
570: return(get_uda_llxml_pvt(p_line_location_id, draftId));
571: END GET_UDA_LL_DRAFTS_XML;
572:

Line 1002: FUNCTION get_req_numbers(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType IS

998: p_fp_of347_EDWOSB := '''N''';
999:
1000: return(false);
1001: end set_business_classification;
1002: FUNCTION get_req_numbers(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType IS
1003:
1004: l_req_nums XMLType;
1005: BEGIN
1006:

Line 1004: l_req_nums XMLType;

1000: return(false);
1001: end set_business_classification;
1002: FUNCTION get_req_numbers(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType IS
1003:
1004: l_req_nums XMLType;
1005: BEGIN
1006:
1007: SELECT XMLAgg(XMLElement("REF_PR_NUM", segment1))
1008: INTO l_req_nums

Line 1025: FUNCTION get_bpa_req_numbers(p_auction_header_id NUMBER, p_auction_line_number NUMBER) RETURN XMLType IS

1021: RETURN l_req_nums;
1022: END get_req_numbers;
1023:
1024:
1025: FUNCTION get_bpa_req_numbers(p_auction_header_id NUMBER, p_auction_line_number NUMBER) RETURN XMLType IS
1026:
1027: l_req_nums XMLType;
1028: BEGIN
1029:

Line 1027: l_req_nums XMLType;

1023:
1024:
1025: FUNCTION get_bpa_req_numbers(p_auction_header_id NUMBER, p_auction_line_number NUMBER) RETURN XMLType IS
1026:
1027: l_req_nums XMLType;
1028: BEGIN
1029:
1030: SELECT XMLAgg(XMLElement("REF_PR_NUM", requisition_number))
1031: INTO l_req_nums

Line 1041: FUNCTION get_acrns(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType IS

1037: RETURN l_req_nums;
1038: END get_bpa_req_numbers;
1039:
1040:
1041: FUNCTION get_acrns(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType IS
1042:
1043: l_acrns XMLType;
1044: BEGIN
1045: SELECT XMLAgg(XMLElement("ACRN", acrn))

Line 1043: l_acrns XMLType;

1039:
1040:
1041: FUNCTION get_acrns(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType IS
1042:
1043: l_acrns XMLType;
1044: BEGIN
1045: SELECT XMLAgg(XMLElement("ACRN", acrn))
1046: INTO l_acrns
1047: FROM (SELECT distinct pod.acrn

Line 1116: RETURN XMLTYPE

1112: END calc_award_enc_amt;
1113:
1114: FUNCTION Get_closeout_uda_details(p_header_id NUMBER,
1115: p_template_id NUMBER)
1116: RETURN XMLTYPE
1117: AS
1118: l_sql VARCHAR2(4000);
1119: l_attr_col VARCHAR2(50);
1120: l_attr_grp_id NUMBER;

Line 1124: po_attr_uda_xml XMLTYPE;

1120: l_attr_grp_id NUMBER;
1121: l_attr_name VARCHAR2(50);
1122: l_attr_grp_name VARCHAR2(100);
1123: l_ctr NUMBER;
1124: po_attr_uda_xml XMLTYPE;
1125: CURSOR curr_uda_groups IS
1126: SELECT gr.attr_group_name,
1127: t1.attribute_group_id
1128: FROM po_uda_ag_template_usages t1,