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.CSM_HTML5_PKG dependencies on CSM_VARCHAR_LIST

Line 73: X_COL_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,

69: DBMS_SESSION.SET_CONTEXT ('CSM5_VAULT_NS','APPLICATION','STARTED');
70: END dbms_createContext;
71:
72: PROCEDURE PARSE_XML(l_xml_clob_payload IN CLOB,
73: X_COL_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,
74: X_COL_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,
75: X_COL_NAME_IDX OUT NOCOPY numtype,
76: X_COL_CLOB_LIST OUT NOCOPY clobtype,
77: p_fix_esc_chars IN BOOLEAN:=false)

Line 74: X_COL_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,

70: END dbms_createContext;
71:
72: PROCEDURE PARSE_XML(l_xml_clob_payload IN CLOB,
73: X_COL_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,
74: X_COL_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,
75: X_COL_NAME_IDX OUT NOCOPY numtype,
76: X_COL_CLOB_LIST OUT NOCOPY clobtype,
77: p_fix_esc_chars IN BOOLEAN:=false)
78:

Line 90: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();

86: l_xml_node_list xmldom.DOMNodeList;
87: l_xml_node xmldom.DOMNode;
88: l_xml_node_len NUMBER;
89: len2 number;
90: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
91: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
92:
93: BEGIN
94: --Convert it to CLOB to parse it

Line 91: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();

87: l_xml_node xmldom.DOMNode;
88: l_xml_node_len NUMBER;
89: len2 number;
90: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
91: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
92:
93: BEGIN
94: --Convert it to CLOB to parse it
95: /*l_xml_clob_payload := l_xml_payload.getCLOBVal();*/

Line 874: l_ch CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

870: IS
871:
872: instId number:=-1; ret VARCHAR2(1); m varchar2(4000);
873: l_id CSM_INTEGER_LIST :=CSM_INTEGER_LIST();
874: l_ch CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
875: l_dt CSM_DATE_LIST:=CSM_DATE_LIST();
876: l_blob BLOB:=empty_blob();
877:
878: BEGIN

Line 1124: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();

1120: l_AUTH Boolean :=false;
1121: l_cached boolean:=false;
1122: l_cache CLOB;
1123:
1124: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
1125: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
1126: l_COL_NAME_IDX numtype;
1127: l_COL_CLOB_LIST clobtype;
1128:

Line 1125: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();

1121: l_cached boolean:=false;
1122: l_cache CLOB;
1123:
1124: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
1125: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
1126: l_COL_NAME_IDX numtype;
1127: l_COL_CLOB_LIST clobtype;
1128:
1129: l_uname varchar2(200); l_lang varchar2(10);

Line 1379: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();

1375: TYPE c_curtype is ref cursor;
1376: c_cur c_curtype;
1377: l_final CLOB := EMPTY_CLOB();
1378: l_pk_value VARCHAR2(200);
1379: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
1380: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
1381: l_COL_NAME_IDX numtype;
1382: l_COL_CLOB_LIST clobtype;
1383: l_stmt CLOB:=NULL;

Line 1380: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();

1376: c_cur c_curtype;
1377: l_final CLOB := EMPTY_CLOB();
1378: l_pk_value VARCHAR2(200);
1379: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
1380: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
1381: l_COL_NAME_IDX numtype;
1382: l_COL_CLOB_LIST clobtype;
1383: l_stmt CLOB:=NULL;
1384: l_rec_count NUMBER:=p_count;

Line 1537: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();

1533: l_stmt CLOB;
1534: l_final CLOB:=NULL;
1535: l_pk_value VARCHAR2(200);
1536:
1537: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
1538: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
1539: l_COL_NAME_IDX numtype;
1540: l_COL_CLOB_LIST clobtype;
1541:

Line 1538: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();

1534: l_final CLOB:=NULL;
1535: l_pk_value VARCHAR2(200);
1536:
1537: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
1538: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
1539: l_COL_NAME_IDX numtype;
1540: l_COL_CLOB_LIST clobtype;
1541:
1542: l_uname varchar2(200); l_lang varchar2(10);

Line 2277: l_ch CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

2273: l_resp_id NUMBER:=23675;
2274: l_user_id NUMBER;
2275: instId number:=-1; ret VARCHAR2(1); m varchar2(4000);
2276: l_id CSM_INTEGER_LIST :=CSM_INTEGER_LIST();
2277: l_ch CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
2278: l_dt CSM_DATE_LIST:=CSM_DATE_LIST();
2279: req_id number:=0;
2280: l_ret VARCHAR2(100);
2281: l_err varchar2(4000);

Line 2590: l_ch CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

2586: procedure generate_html5_data(p_user_name IN VARCHAR2)
2587: is
2588: instId number:=-1; ret VARCHAR2(1); m varchar2(4000);
2589: l_id CSM_INTEGER_LIST :=CSM_INTEGER_LIST();
2590: l_ch CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
2591: l_dt CSM_DATE_LIST:=CSM_DATE_LIST();
2592: req_id number:=0;
2593: begin
2594: l_id.extend(1);l_ch.extend(1);l_dt.extend(1);

Line 2621: PROCEDURE GET_INQ_INS_ST(P_TABLE_NAME IN VARCHAR2,P_COL_NAME_LIST IN CSM_VARCHAR_LIST,P_COL_VALUE_LIST IN CSM_VARCHAR_LIST,P_COL_IDX_LIST numtype,p_result OUT NOCOPY CLOB)

2617: begin
2618: query_sync_data_js(p_user_name, null,p_result,x_return_status,x_error_message,true);
2619: end query_generate_html5_data;
2620:
2621: PROCEDURE GET_INQ_INS_ST(P_TABLE_NAME IN VARCHAR2,P_COL_NAME_LIST IN CSM_VARCHAR_LIST,P_COL_VALUE_LIST IN CSM_VARCHAR_LIST,P_COL_IDX_LIST numtype,p_result OUT NOCOPY CLOB)
2622: IS
2623: L_STMT CLOB :=empty_clob();
2624: l_part CLOB :=empty_clob();
2625: l_cnt NUMBER:=1;

Line 2696: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();

2692: l_xml_DATA_node_list xmldom.DOMNodeList;
2693: l_xml_node xmldom.DOMNode;
2694: l_xml_node_len NUMBER;
2695: dummy number;
2696: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
2697: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
2698: l_COL_NAME_IDX numtype;
2699: l_COL_CLOB_LIST clobtype;
2700:

Line 2697: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();

2693: l_xml_node xmldom.DOMNode;
2694: l_xml_node_len NUMBER;
2695: dummy number;
2696: l_COL_NAME_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
2697: L_COL_VALUE_LIST CSM_VARCHAR_LIST := CSM_VARCHAR_LIST();
2698: l_COL_NAME_IDX numtype;
2699: l_COL_CLOB_LIST clobtype;
2700:
2701: