APPS.GMO_OC_TRANS_PKG dependencies on XMLTYPE

Line 13: l_result XMLType;

9: FromDate IN VARCHAR2,
10: ToDate IN VARCHAR2) IS
11: TYPE refcur IS REF CURSOR;
12: l_refcur refcur;
13: l_result XMLType;
14: l_final_clob CLOB ;
15: l_len number;
16: l_xml_data varchar2(10);
17: l_limit number;

Line 68: XMLTYPE(''''||:x||''''),

64: l_operator_name := GMO_UTILITIES.GET_USER_DISPLAY_NAME(operator_id);
65: END IF;
66:
67: l_argument_string := 'SELECT XMLELEMENT("OPERATORHISTORY", XMLCONCAT(XMLSEQUENCETYPE(
68: XMLTYPE(''''||:x||''''),
69: XMLTYPE(''''||:y||''''),
70: XMLTYPE(''''),
71: XMLTYPE(''''||:xx||''''),
72: XMLTYPE(''''||:yy||''''),

Line 69: XMLTYPE(''''||:y||''''),

65: END IF;
66:
67: l_argument_string := 'SELECT XMLELEMENT("OPERATORHISTORY", XMLCONCAT(XMLSEQUENCETYPE(
68: XMLTYPE(''''||:x||''''),
69: XMLTYPE(''''||:y||''''),
70: XMLTYPE(''''),
71: XMLTYPE(''''||:xx||''''),
72: XMLTYPE(''''||:yy||''''),
73: XMLTYPE(''''||:zz||''''))),

Line 70: XMLTYPE(''''),

66:
67: l_argument_string := 'SELECT XMLELEMENT("OPERATORHISTORY", XMLCONCAT(XMLSEQUENCETYPE(
68: XMLTYPE(''''||:x||''''),
69: XMLTYPE(''''||:y||''''),
70: XMLTYPE(''''),
71: XMLTYPE(''''||:xx||''''),
72: XMLTYPE(''''||:yy||''''),
73: XMLTYPE(''''||:zz||''''))),
74: XMLAGG(XMLELEMENT("OPERATORCERTHEADER",

Line 71: XMLTYPE(''''||:xx||''''),

67: l_argument_string := 'SELECT XMLELEMENT("OPERATORHISTORY", XMLCONCAT(XMLSEQUENCETYPE(
68: XMLTYPE(''''||:x||''''),
69: XMLTYPE(''''||:y||''''),
70: XMLTYPE(''''),
71: XMLTYPE(''''||:xx||''''),
72: XMLTYPE(''''||:yy||''''),
73: XMLTYPE(''''||:zz||''''))),
74: XMLAGG(XMLELEMENT("OPERATORCERTHEADER",
75: XMLFOREST(:orgName as OrganizationName ,

Line 72: XMLTYPE(''''||:yy||''''),

68: XMLTYPE(''''||:x||''''),
69: XMLTYPE(''''||:y||''''),
70: XMLTYPE(''''),
71: XMLTYPE(''''||:xx||''''),
72: XMLTYPE(''''||:yy||''''),
73: XMLTYPE(''''||:zz||''''))),
74: XMLAGG(XMLELEMENT("OPERATORCERTHEADER",
75: XMLFOREST(:orgName as OrganizationName ,
76: DECODE(oc_trans_hdr.TRANS_OBJECT_ID,1,

Line 73: XMLTYPE(''''||:zz||''''))),

69: XMLTYPE(''''||:y||''''),
70: XMLTYPE(''''),
71: XMLTYPE(''''||:xx||''''),
72: XMLTYPE(''''||:yy||''''),
73: XMLTYPE(''''||:zz||''''))),
74: XMLAGG(XMLELEMENT("OPERATORCERTHEADER",
75: XMLFOREST(:orgName as OrganizationName ,
76: DECODE(oc_trans_hdr.TRANS_OBJECT_ID,1,
77: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 1),2,