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_HA_EVENT_PKG dependencies on CSM_VARCHAR_LIST

Line 8: p_PK_NAME_LIST IN CSM_VARCHAR_LIST,

4: G_IS_END_TRACKING_CALL BOOLEAN := FALSE;
5:
6: PROCEDURE GET_XML_PAYLOAD
7: ( p_TABLE_NAME IN VARCHAR2,
8: p_PK_NAME_LIST IN CSM_VARCHAR_LIST,
9: p_PK_TYPE_LIST IN CSM_VARCHAR_LIST,
10: p_PK_CHAR_LIST IN CSM_VARCHAR_LIST,
11: x_XML_PAYLOAD OUT NOCOPY CLOB,
12: x_XML_CONTEXT OUT NOCOPY CLOB,

Line 9: p_PK_TYPE_LIST IN CSM_VARCHAR_LIST,

5:
6: PROCEDURE GET_XML_PAYLOAD
7: ( p_TABLE_NAME IN VARCHAR2,
8: p_PK_NAME_LIST IN CSM_VARCHAR_LIST,
9: p_PK_TYPE_LIST IN CSM_VARCHAR_LIST,
10: p_PK_CHAR_LIST IN CSM_VARCHAR_LIST,
11: x_XML_PAYLOAD OUT NOCOPY CLOB,
12: x_XML_CONTEXT OUT NOCOPY CLOB,
13: x_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 10: p_PK_CHAR_LIST IN CSM_VARCHAR_LIST,

6: PROCEDURE GET_XML_PAYLOAD
7: ( p_TABLE_NAME IN VARCHAR2,
8: p_PK_NAME_LIST IN CSM_VARCHAR_LIST,
9: p_PK_TYPE_LIST IN CSM_VARCHAR_LIST,
10: p_PK_CHAR_LIST IN CSM_VARCHAR_LIST,
11: x_XML_PAYLOAD OUT NOCOPY CLOB,
12: x_XML_CONTEXT OUT NOCOPY CLOB,
13: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
14: x_ERROR_MESSAGE OUT NOCOPY VARCHAR2

Line 71: FUNCTION get_stringfrom_list (pk_list IN CSM_VARCHAR_LIST)

67: x_return_status := FND_API.G_RET_STS_ERROR;
68: x_error_message := 'XML Retrieve Failed With Message : ' || SUBSTR(SQLERRM,1,3000) ;
69: END GET_XML_PAYLOAD;
70:
71: FUNCTION get_stringfrom_list (pk_list IN CSM_VARCHAR_LIST)
72: RETURN VARCHAR2
73: IS
74: l_string VARCHAR2(1000):='';
75: BEGIN

Line 89: PROCEDURE TRACK_TABLE(p_table_name IN VARCHAR2,p_PK_NAME_LIST IN CSM_VARCHAR_LIST,

85: RETURN l_string;
86: END get_stringfrom_list;
87:
88:
89: PROCEDURE TRACK_TABLE(p_table_name IN VARCHAR2,p_PK_NAME_LIST IN CSM_VARCHAR_LIST,
90: p_PK_TYPE_LIST CSM_VARCHAR_LIST,p_mobile_data IN VARCHAR2)
91: IS
92: l_stmt VARCHAR2(4000);
93: l_pk_names VARCHAR2(1000);

Line 90: p_PK_TYPE_LIST CSM_VARCHAR_LIST,p_mobile_data IN VARCHAR2)

86: END get_stringfrom_list;
87:
88:
89: PROCEDURE TRACK_TABLE(p_table_name IN VARCHAR2,p_PK_NAME_LIST IN CSM_VARCHAR_LIST,
90: p_PK_TYPE_LIST CSM_VARCHAR_LIST,p_mobile_data IN VARCHAR2)
91: IS
92: l_stmt VARCHAR2(4000);
93: l_pk_names VARCHAR2(1000);
94: type t_curs is ref cursor;

Line 97: p_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

93: l_pk_names VARCHAR2(1000);
94: type t_curs is ref cursor;
95: cur t_curs;
96: l_cnt NUMBER;
97: p_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
98:
99: BEGIN
100:
101: CSM_UTIL_PKG.LOG

Line 153: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');

149: END TRACK_MFS_REC_NO_PLD;
150:
151: PROCEDURE RECORD_CSM_TABLES
152: IS
153: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
154: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
155: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
156:
157: type t_curs is ref cursor;

Line 154: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');

150:
151: PROCEDURE RECORD_CSM_TABLES
152: IS
153: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
154: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
155: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
156:
157: type t_curs is ref cursor;
158: cur t_curs;

Line 155: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');

151: PROCEDURE RECORD_CSM_TABLES
152: IS
153: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
154: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
155: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
156:
157: type t_curs is ref cursor;
158: cur t_curs;
159: BEGIN

Line 234: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

230: END RECORD_CSM_TABLES;
231:
232: PROCEDURE RECORD_MFS_DATA
233: IS
234: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
235: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
236: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
237: type t_curs is ref cursor;
238: cur t_curs;

Line 235: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

231:
232: PROCEDURE RECORD_MFS_DATA
233: IS
234: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
235: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
236: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
237: type t_curs is ref cursor;
238: cur t_curs;
239:

Line 236: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

232: PROCEDURE RECORD_MFS_DATA
233: IS
234: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
235: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
236: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
237: type t_curs is ref cursor;
238: cur t_curs;
239:
240: BEGIN

Line 785: l_sequence_list CSM_VARCHAR_LIST;

781: l_end_seq_value NUMBER :=0;
782: l_inc_by_value NUMBER :=0;
783: L_SQL_QUERY varchar2(4000);
784:
785: l_sequence_list CSM_VARCHAR_LIST;
786: l_curr_seq_value number;
787: L_APPLIED_SEQUENCE_VALUE NUMBER;
788:
789: TYPE l_num_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 908: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');

904: END MANAGE_MFS_CONC;
905:
906: PROCEDURE RECORD_MISC_DATA
907: IS
908: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
909: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
910: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
911:
912: BEGIN

Line 909: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');

905:
906: PROCEDURE RECORD_MISC_DATA
907: IS
908: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
909: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
910: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
911:
912: BEGIN
913:

Line 910: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');

906: PROCEDURE RECORD_MISC_DATA
907: IS
908: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
909: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
910: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
911:
912: BEGIN
913:
914: CSM_UTIL_PKG.LOG('Recording Incident Links','CSM_HA_EVENT_PKG.RECORD_MISC_DATA', FND_LOG.LEVEL_PROCEDURE);

Line 1191: FUNCTION get_listfrom_String(p_object_name IN VARCHAR2) return CSM_VARCHAR_LIST

1187: SET_HA_PROFILE('HA_RECORD');
1188: RAISE;
1189: END END_HA_TRACKING;
1190:
1191: FUNCTION get_listfrom_String(p_object_name IN VARCHAR2) return CSM_VARCHAR_LIST
1192: IS
1193: l_temp VARCHAR2(1000);
1194: list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
1195: l_item1 VARCHAR2(500);

Line 1194: list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

1190:
1191: FUNCTION get_listfrom_String(p_object_name IN VARCHAR2) return CSM_VARCHAR_LIST
1192: IS
1193: l_temp VARCHAR2(1000);
1194: list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
1195: l_item1 VARCHAR2(500);
1196: l_item2 VARCHAR2(500);
1197: l_cnt NUMBER :=1;
1198: BEGIN

Line 1276: l_pk_col_list CSM_VARCHAR_LIST;

1272: END get_pk_column_name;
1273:
1274: FUNCTION get_predicate_clause(p_cols IN VARCHAR2,p_values IN VARCHAR2) return VARCHAR2
1275: IS
1276: l_pk_col_list CSM_VARCHAR_LIST;
1277: l_pk_value_list CSM_VARCHAR_LIST;
1278: l_clause VARCHAR2(3000);
1279: BEGIN
1280: l_pk_col_list:=get_listfrom_String(p_cols);

Line 1277: l_pk_value_list CSM_VARCHAR_LIST;

1273:
1274: FUNCTION get_predicate_clause(p_cols IN VARCHAR2,p_values IN VARCHAR2) return VARCHAR2
1275: IS
1276: l_pk_col_list CSM_VARCHAR_LIST;
1277: l_pk_value_list CSM_VARCHAR_LIST;
1278: l_clause VARCHAR2(3000);
1279: BEGIN
1280: l_pk_col_list:=get_listfrom_String(p_cols);
1281: l_pk_value_list:=get_listfrom_String(p_values);

Line 1307: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

1303:
1304: l_bo_name VARCHAR2(100);
1305: l_pk_value VARCHAR2(100);
1306:
1307: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
1308: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
1309: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
1310:
1311: BEGIN

Line 1308: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

1304: l_bo_name VARCHAR2(100);
1305: l_pk_value VARCHAR2(100);
1306:
1307: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
1308: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
1309: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
1310:
1311: BEGIN
1312:

Line 1309: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

1305: l_pk_value VARCHAR2(100);
1306:
1307: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
1308: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
1309: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
1310:
1311: BEGIN
1312:
1313: SELECT OBJECT_NAME,PK_VALUE INTO l_bo_name,l_pk_value

Line 1358: PROCEDURE TRACK_HA_RECORD(p_TABLE_NAME VARCHAR2,p_PK_NAME_LIST CSM_VARCHAR_LIST, p_PK_TYPE_LIST CSM_VARCHAR_LIST,p_PK_VALUE_LIST CSM_VARCHAR_LIST,

1354: END LOOP;
1355:
1356: END TRACK_AUX_TABLE_RECORDS;
1357:
1358: PROCEDURE TRACK_HA_RECORD(p_TABLE_NAME VARCHAR2,p_PK_NAME_LIST CSM_VARCHAR_LIST, p_PK_TYPE_LIST CSM_VARCHAR_LIST,p_PK_VALUE_LIST CSM_VARCHAR_LIST,
1359: p_dml_type VARCHAR2,p_mobile_data VARCHAR2,p_parent_payload_id IN NUMBER)
1360: IS
1361: l_XML_PAYLOAD CLOB;
1362: l_XML_CONTEXT CLOB;

Line 1432: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');

1428: END TRACK_HA_RECORD;
1429:
1430: PROCEDURE TRACK_HA_ATTACHMENTS
1431: IS
1432: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
1433: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
1434: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
1435:
1436: CURSOR c_last_run_date

Line 1433: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');

1429:
1430: PROCEDURE TRACK_HA_ATTACHMENTS
1431: IS
1432: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
1433: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
1434: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
1435:
1436: CURSOR c_last_run_date
1437: IS

Line 1434: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');

1430: PROCEDURE TRACK_HA_ATTACHMENTS
1431: IS
1432: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
1433: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
1434: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST('');
1435:
1436: CURSOR c_last_run_date
1437: IS
1438: SELECT NVL(last_run_date,to_date(1,'J'))