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_SGD_PKG dependencies on XMLTYPE

Line 192: FUNCTION get_uda_header_xml(p_headerId number, p_draft_id number) RETURN XMLType IS

188: return(l_sql);
189: end get_uda_attr_desc_sql;
190:
191:
192: FUNCTION get_uda_header_xml(p_headerId number, p_draft_id number) RETURN XMLType IS
193: CURSOR C_ATTR_GRP IS
194: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
195: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
196: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,

Line 231: l_uda_xml XMLTYPE;

227: L_OP CLOB;
228: L_ATTR_GRP NUMBER;
229: L_CTR NUMBER;
230: L_O_CTR NUMBER;
231: l_uda_xml XMLTYPE;
232: BEGIN
233:
234: L_O_CTR := 0;
235: FOR REC IN C_ATTR_GRP LOOP

Line 289: RETURN XMLType IS

285: RETURN (l_uda_xml);
286: END get_uda_header_xml;
287:
288: FUNCTION get_uda_line_xml(p_po_line_id NUMBER, p_draft_id NUMBER)
289: RETURN XMLType IS
290: CURSOR C_ATTR_GRP IS
291: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
292: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
293: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,

Line 329: l_uda_xml XMLTYPE;

325: L_OP CLOB;
326: L_ATTR_GRP NUMBER;
327: L_CTR NUMBER;
328: L_O_CTR NUMBER;
329: l_uda_xml XMLTYPE;
330: BEGIN
331:
332: L_O_CTR := 0;
333: FOR REC IN C_ATTR_GRP LOOP

Line 388: FUNCTION get_uda_lineloc_xml(p_line_location_id number, p_draft_id number) RETURN XMLType IS

384: RETURN (l_uda_xml);
385: END get_uda_line_xml;
386:
387:
388: FUNCTION get_uda_lineloc_xml(p_line_location_id number, p_draft_id number) RETURN XMLType IS
389: CURSOR C_ATTR_GRP IS
390: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
391: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
392: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,

Line 427: l_uda_xml XMLTYPE;

423: L_OP CLOB;
424: L_ATTR_GRP NUMBER;
425: L_CTR NUMBER;
426: L_O_CTR NUMBER;
427: l_uda_xml XMLTYPE;
428:
429: BEGIN
430:
431: L_O_CTR := 0;

Line 558: base_pk5_value NUMBER default null ) RETURN XMLType IS

554: base_pk1_value NUMBER default null,
555: base_pk2_value NUMBER default null,
556: base_pk3_value NUMBER default null,
557: base_pk4_value NUMBER default null,
558: base_pk5_value NUMBER default null ) RETURN XMLType IS
559:
560: l_where_stmt VARCHAR2(500);
561: l_sql_stmt CLOB;
562: l_xml XMLTYPE;

Line 562: l_xml XMLTYPE;

558: base_pk5_value NUMBER default null ) RETURN XMLType IS
559:
560: l_where_stmt VARCHAR2(500);
561: l_sql_stmt CLOB;
562: l_xml XMLTYPE;
563:
564: BEGIN
565:
566:

Line 702: base_pk5_value NUMBER default null ) RETURN XMLType IS

698: base_pk1_value NUMBER default null,
699: base_pk2_value NUMBER default null,
700: base_pk3_value NUMBER default null,
701: base_pk4_value NUMBER default null,
702: base_pk5_value NUMBER default null ) RETURN XMLType IS
703:
704: l_rollup_rc SYS_REFCURSOR;
705: l_linecont_rc SYS_REFCURSOR;
706:

Line 713: l_xml XMLTYPE;

709:
710: l_where_stmt VARCHAR2(500);
711: l_groupby_stmt VARCHAR2(200);
712: l_sql_stmt CLOB;
713: l_xml XMLTYPE;
714:
715: l_colname VARCHAR2(60);
716: l_msgcode VARCHAR2(100);
717: l_origvalue VARCHAR2(4000);

Line 951: base_pk5_value NUMBER default null ) RETURN XMLType IS

947: base_pk1_value NUMBER default null,
948: base_pk2_value NUMBER default null,
949: base_pk3_value NUMBER default null,
950: base_pk4_value NUMBER default null,
951: base_pk5_value NUMBER default null ) RETURN XMLType IS
952:
953: l_rollup_rc SYS_REFCURSOR;
954: l_shipno_rc SYS_REFCURSOR;
955: l_linecont_rc SYS_REFCURSOR;

Line 964: l_xml XMLTYPE;

960:
961: l_where_stmt VARCHAR2(500);
962: l_groupby_stmt VARCHAR2(200);
963: l_sql_stmt CLOB;
964: l_xml XMLTYPE;
965:
966: l_colname VARCHAR2(60);
967: l_msgcode VARCHAR2(100);
968: l_origvalue VARCHAR2(4000);

Line 1237: base_pk5_value NUMBER default null ) RETURN XMLType IS

1233: base_pk1_value NUMBER default null,
1234: base_pk2_value NUMBER default null,
1235: base_pk3_value NUMBER default null,
1236: base_pk4_value NUMBER default null,
1237: base_pk5_value NUMBER default null ) RETURN XMLType IS
1238:
1239: l_rollup_rc SYS_REFCURSOR;
1240: l_shipno_rc SYS_REFCURSOR;
1241: l_linecont_rc SYS_REFCURSOR;

Line 1250: l_xml XMLTYPE;

1246:
1247: l_where_stmt VARCHAR2(500);
1248: l_groupby_stmt VARCHAR2(200);
1249: l_sql_stmt CLOB;
1250: l_xml XMLTYPE;
1251:
1252: l_colname VARCHAR2(60);
1253: l_msgcode VARCHAR2(100);
1254: l_origvalue VARCHAR2(4000);

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

1726: END IF;
1727: END;
1728:
1729:
1730: FUNCTION get_req_numbers(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType IS
1731:
1732: l_req_nums XMLType;
1733: BEGIN
1734:

Line 1732: l_req_nums XMLType;

1728:
1729:
1730: FUNCTION get_req_numbers(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType IS
1731:
1732: l_req_nums XMLType;
1733: BEGIN
1734:
1735: SELECT XMLAgg(XMLElement("REF_PR_NUM", segment1))
1736: INTO l_req_nums

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

1749: RETURN l_req_nums;
1750: END get_req_numbers;
1751:
1752:
1753: FUNCTION get_bpa_req_numbers(p_auction_header_id NUMBER, p_auction_line_number NUMBER) RETURN XMLType IS
1754:
1755: l_req_nums XMLType;
1756: BEGIN
1757:

Line 1755: l_req_nums XMLType;

1751:
1752:
1753: FUNCTION get_bpa_req_numbers(p_auction_header_id NUMBER, p_auction_line_number NUMBER) RETURN XMLType IS
1754:
1755: l_req_nums XMLType;
1756: BEGIN
1757:
1758: SELECT XMLAgg(XMLElement("REF_PR_NUM", requisition_number))
1759: INTO l_req_nums

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

1765: RETURN l_req_nums;
1766: END get_bpa_req_numbers;
1767:
1768:
1769: FUNCTION get_acrns(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType IS
1770:
1771: l_acrns XMLType;
1772: BEGIN
1773: SELECT XMLAgg(XMLElement("ACRN", acrn))

Line 1771: l_acrns XMLType;

1767:
1768:
1769: FUNCTION get_acrns(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType IS
1770:
1771: l_acrns XMLType;
1772: BEGIN
1773: SELECT XMLAgg(XMLElement("ACRN", acrn))
1774: INTO l_acrns
1775: FROM (SELECT distinct pod.acrn