APPS.PON_SGD_PKG dependencies on XMLTYPE

Line 4: FUNCTION get_uda_header_xml RETURN XMLType IS

1: PACKAGE BODY PON_SGD_PKG AS
2: /* $Header: PON_SGD_PKG.plb 120.4 2012/01/23 06:24:05 nbingi noship $ */
3:
4: FUNCTION get_uda_header_xml RETURN XMLType IS
5: CURSOR C_ATTR_GRP IS
6: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
7: ATTR_GROUP_ID,
8: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW

Line 45: l_uda_xml XMLTYPE;

41: L_OP CLOB;
42: L_ATTR_GRP NUMBER;
43: L_CTR NUMBER;
44: L_O_CTR NUMBER;
45: l_uda_xml XMLTYPE;
46:
47: p_application_id number := 201;
48: p_attr_internal_str_value varchar2(100);
49:

Line 261: FUNCTION get_uda_lines_xml(p_line_id NUMBER) RETURN XMLTYPE IS

257: end if;
258: return(clob_cnt);
259: end get_contactsxml;
260:
261: FUNCTION get_uda_lines_xml(p_line_id NUMBER) RETURN XMLTYPE IS
262: CURSOR C_ATTR_GRP IS
263: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
264: ATTR_GROUP_ID,
265: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW

Line 303: l_uda_xml XMLTYPE;

299: L_OP CLOB;
300: L_ATTR_GRP NUMBER;
301: L_CTR NUMBER;
302: L_O_CTR NUMBER;
303: l_uda_xml XMLTYPE;
304:
305: p_application_id number := 201;
306: p_attr_internal_str_value varchar2(100);
307:

Line 482: p_base_pk5_value NUMBER default null ) RETURN XMLType IS

478: p_base_pk1_value NUMBER default null,
479: p_base_pk2_value NUMBER default null,
480: p_base_pk3_value NUMBER default null,
481: p_base_pk4_value NUMBER default null,
482: p_base_pk5_value NUMBER default null ) RETURN XMLType IS
483:
484: l_finalXML XMLTYPE;
485: l_sql_stmt CLOB;
486:

Line 484: l_finalXML XMLTYPE;

480: p_base_pk3_value NUMBER default null,
481: p_base_pk4_value NUMBER default null,
482: p_base_pk5_value NUMBER default null ) RETURN XMLType IS
483:
484: l_finalXML XMLTYPE;
485: l_sql_stmt CLOB;
486:
487: BEGIN
488:

Line 566: base_pk5_value NUMBER default null ) RETURN XMLType IS

562: base_pk1_value NUMBER default null,
563: base_pk2_value NUMBER default null,
564: base_pk3_value NUMBER default null,
565: base_pk4_value NUMBER default null,
566: base_pk5_value NUMBER default null ) RETURN XMLType IS
567:
568: --cursor which gets the rollup change by grouping rows in po_entity_rollup_gt table
569: CURSOR c_rollup_changes IS
570: SELECT d.mod_doc_source_name,

Line 650: l_finalXML XMLTYPE;

646:
647: ORDER By orderseq, fromline
648: );
649:
650: l_finalXML XMLTYPE;
651: l_ctr number := 0;
652: rollup_pk CLOB;
653: l_sql_stmt CLOB;
654: