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

Line 32: l_result XMLType;

28: ToDate IN VARCHAR2)
29: IS
30: TYPE refcur IS REF CURSOR;
31: l_refcur refcur;
32: l_result XMLType;
33: l_final_clob CLOB ;
34: l_len number;
35: l_xml_data varchar2(10);
36: l_limit number;

Line 68: l_argument_string := 'select XMLELEMENT("DispenseDispatch", XMLCONCAT(XMLSEQUENCETYPE(XMLTYPE(''''||:x ||''''),

64: OPEN GET_ORG_NAME;
65: FETCH GET_ORG_NAME into l_org_name, l_org_code;
66: CLOSE GET_ORG_NAME;
67:
68: l_argument_string := 'select XMLELEMENT("DispenseDispatch", XMLCONCAT(XMLSEQUENCETYPE(XMLTYPE(''''||:x ||''''),
69: XMLTYPE('''' || :y||''''),
70: XMLTYPE('''' || :z||''''),
71: XMLTYPE('''' ||:xx||''''),
72: XMLTYPE(''''|| :yy ||'''')

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

65: FETCH GET_ORG_NAME into l_org_name, l_org_code;
66: CLOSE GET_ORG_NAME;
67:
68: l_argument_string := 'select XMLELEMENT("DispenseDispatch", XMLCONCAT(XMLSEQUENCETYPE(XMLTYPE(''''||:x ||''''),
69: XMLTYPE('''' || :y||''''),
70: XMLTYPE('''' || :z||''''),
71: XMLTYPE('''' ||:xx||''''),
72: XMLTYPE(''''|| :yy ||'''')
73: )),

Line 70: XMLTYPE('''' || :z||''''),

66: CLOSE GET_ORG_NAME;
67:
68: l_argument_string := 'select XMLELEMENT("DispenseDispatch", XMLCONCAT(XMLSEQUENCETYPE(XMLTYPE(''''||:x ||''''),
69: XMLTYPE('''' || :y||''''),
70: XMLTYPE('''' || :z||''''),
71: XMLTYPE('''' ||:xx||''''),
72: XMLTYPE(''''|| :yy ||'''')
73: )),
74: XMLAGG(XMLELEMENT("DispatchDetails",

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

67:
68: l_argument_string := 'select XMLELEMENT("DispenseDispatch", XMLCONCAT(XMLSEQUENCETYPE(XMLTYPE(''''||:x ||''''),
69: XMLTYPE('''' || :y||''''),
70: XMLTYPE('''' || :z||''''),
71: XMLTYPE('''' ||:xx||''''),
72: XMLTYPE(''''|| :yy ||'''')
73: )),
74: XMLAGG(XMLELEMENT("DispatchDetails",
75: XMLFOREST(:orgName as OrganizationName,

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

68: l_argument_string := 'select XMLELEMENT("DispenseDispatch", XMLCONCAT(XMLSEQUENCETYPE(XMLTYPE(''''||:x ||''''),
69: XMLTYPE('''' || :y||''''),
70: XMLTYPE('''' || :z||''''),
71: XMLTYPE('''' ||:xx||''''),
72: XMLTYPE(''''|| :yy ||'''')
73: )),
74: XMLAGG(XMLELEMENT("DispatchDetails",
75: XMLFOREST(:orgName as OrganizationName,
76: RES.subinventory_code as Location ,

Line 209: l_result XMLType;

205: OperatorID IN VARCHAR2)
206: IS
207: TYPE refcur IS REF CURSOR;
208: l_refcur refcur;
209: l_result XMLType;
210: l_final_clob CLOB ;
211: l_len number;
212: l_xml_data varchar2(10);
213: l_limit number;

Line 243: l_argument_string := 'select XMLELEMENT("DispenseHistory", XMLCONCAT(XMLSEQUENCETYPE(XMLTYPE(''''||:x||''''),

239: OPEN GET_ORG_NAME;
240: FETCH GET_ORG_NAME into l_org_name, l_org_code;
241: CLOSE GET_ORG_NAME;
242:
243: l_argument_string := 'select XMLELEMENT("DispenseHistory", XMLCONCAT(XMLSEQUENCETYPE(XMLTYPE(''''||:x||''''),
244: XMLTYPE(''''||:y||''''),
245: XMLTYPE(''''||:z||''''),
246: XMLTYPE(''''||:xx||''''),
247: XMLTYPE(''''||:yy||''''),

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

240: FETCH GET_ORG_NAME into l_org_name, l_org_code;
241: CLOSE GET_ORG_NAME;
242:
243: l_argument_string := 'select XMLELEMENT("DispenseHistory", XMLCONCAT(XMLSEQUENCETYPE(XMLTYPE(''''||:x||''''),
244: XMLTYPE(''''||:y||''''),
245: XMLTYPE(''''||:z||''''),
246: XMLTYPE(''''||:xx||''''),
247: XMLTYPE(''''||:yy||''''),
248: XMLTYPE(''''||:zz||'''')

Line 245: XMLTYPE(''''||:z||''''),

241: CLOSE GET_ORG_NAME;
242:
243: l_argument_string := 'select XMLELEMENT("DispenseHistory", XMLCONCAT(XMLSEQUENCETYPE(XMLTYPE(''''||:x||''''),
244: XMLTYPE(''''||:y||''''),
245: XMLTYPE(''''||:z||''''),
246: XMLTYPE(''''||:xx||''''),
247: XMLTYPE(''''||:yy||''''),
248: XMLTYPE(''''||:zz||'''')
249: )),

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

242:
243: l_argument_string := 'select XMLELEMENT("DispenseHistory", XMLCONCAT(XMLSEQUENCETYPE(XMLTYPE(''''||:x||''''),
244: XMLTYPE(''''||:y||''''),
245: XMLTYPE(''''||:z||''''),
246: XMLTYPE(''''||:xx||''''),
247: XMLTYPE(''''||:yy||''''),
248: XMLTYPE(''''||:zz||'''')
249: )),
250: XMLAGG(XMLELEMENT("DispenseHistoryDetails",

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

243: l_argument_string := 'select XMLELEMENT("DispenseHistory", XMLCONCAT(XMLSEQUENCETYPE(XMLTYPE(''''||:x||''''),
244: XMLTYPE(''''||:y||''''),
245: XMLTYPE(''''||:z||''''),
246: XMLTYPE(''''||:xx||''''),
247: XMLTYPE(''''||:yy||''''),
248: XMLTYPE(''''||:zz||'''')
249: )),
250: XMLAGG(XMLELEMENT("DispenseHistoryDetails",
251: XMLFOREST(:orgName as OrganizationName ,

Line 248: XMLTYPE(''''||:zz||'''')

244: XMLTYPE(''''||:y||''''),
245: XMLTYPE(''''||:z||''''),
246: XMLTYPE(''''||:xx||''''),
247: XMLTYPE(''''||:yy||''''),
248: XMLTYPE(''''||:zz||'''')
249: )),
250: XMLAGG(XMLELEMENT("DispenseHistoryDetails",
251: XMLFOREST(:orgName as OrganizationName ,
252: GMDL.subinventory_code as Location ,