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

Line 103: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,

99: p_RETENTION_DAYS IN NUMBER,
100: p_TEMPLATE IN VARCHAR2,
101: p_TEMPLATE_FILE IN VARCHAR2,
102: p_EXECUTION_MODE IN VARCHAR2,
103: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
104: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
105: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
106: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
107: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,

Line 104: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,

100: p_TEMPLATE IN VARCHAR2,
101: p_TEMPLATE_FILE IN VARCHAR2,
102: p_EXECUTION_MODE IN VARCHAR2,
103: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
104: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
105: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
106: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
107: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
108: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,

Line 105: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,

101: p_TEMPLATE_FILE IN VARCHAR2,
102: p_EXECUTION_MODE IN VARCHAR2,
103: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
104: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
105: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
106: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
107: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
108: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,
109: p_EMAIL_ENABLED IN VARCHAR2,

Line 107: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,

103: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
104: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
105: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
106: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
107: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
108: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,
109: p_EMAIL_ENABLED IN VARCHAR2,
110: p_RESTRICTED_FLAG IN VARCHAR2,
111: p_DISABLED_FLAG IN VARCHAR2,

Line 108: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,

104: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
105: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
106: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
107: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
108: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,
109: p_EMAIL_ENABLED IN VARCHAR2,
110: p_RESTRICTED_FLAG IN VARCHAR2,
111: p_DISABLED_FLAG IN VARCHAR2,
112: x_return_status OUT NOCOPY VARCHAR2,

Line 329: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,

325: p_RETENTION_DAYS IN NUMBER,
326: p_TEMPLATE IN VARCHAR2,
327: p_TEMPLATE_FILE IN VARCHAR2,
328: p_EXECUTION_MODE IN VARCHAR2,
329: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
330: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
331: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
332: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
333: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,

Line 330: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,

326: p_TEMPLATE IN VARCHAR2,
327: p_TEMPLATE_FILE IN VARCHAR2,
328: p_EXECUTION_MODE IN VARCHAR2,
329: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
330: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
331: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
332: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
333: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
334: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,

Line 331: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,

327: p_TEMPLATE_FILE IN VARCHAR2,
328: p_EXECUTION_MODE IN VARCHAR2,
329: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
330: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
331: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
332: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
333: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
334: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,
335: p_EMAIL_ENABLED IN VARCHAR2,

Line 333: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,

329: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
330: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
331: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
332: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
333: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
334: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,
335: p_EMAIL_ENABLED IN VARCHAR2,
336: p_RESTRICTED_FLAG IN VARCHAR2,
337: p_DISABLED_FLAG IN VARCHAR2,

Line 334: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,

330: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
331: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
332: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
333: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
334: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,
335: p_EMAIL_ENABLED IN VARCHAR2,
336: p_RESTRICTED_FLAG IN VARCHAR2,
337: p_DISABLED_FLAG IN VARCHAR2,
338: x_return_status OUT NOCOPY VARCHAR2,

Line 895: l_var_value_char_lst CSM_VARCHAR_LIST;

891: l_cursor_ret INTEGER;
892: l_PROCEDURE_NAME VARCHAR2(255);
893: l_procedure_stmt VARCHAR2(32767);
894: l_variable_id_lst CSM_INTEGER_LIST;
895: l_var_value_char_lst CSM_VARCHAR_LIST;
896: l_var_value_date_lst CSM_DATE_LIST;
897: l_var_type_lst CSM_VARCHAR_LIST;
898: l_var_name_lst CSM_VARCHAR_LIST;
899: l_return_status VARCHAR2(4000);

Line 897: l_var_type_lst CSM_VARCHAR_LIST;

893: l_procedure_stmt VARCHAR2(32767);
894: l_variable_id_lst CSM_INTEGER_LIST;
895: l_var_value_char_lst CSM_VARCHAR_LIST;
896: l_var_value_date_lst CSM_DATE_LIST;
897: l_var_type_lst CSM_VARCHAR_LIST;
898: l_var_name_lst CSM_VARCHAR_LIST;
899: l_return_status VARCHAR2(4000);
900: l_return_message VARCHAR2(4000);
901: i NUMBER;

Line 898: l_var_name_lst CSM_VARCHAR_LIST;

894: l_variable_id_lst CSM_INTEGER_LIST;
895: l_var_value_char_lst CSM_VARCHAR_LIST;
896: l_var_value_date_lst CSM_DATE_LIST;
897: l_var_type_lst CSM_VARCHAR_LIST;
898: l_var_name_lst CSM_VARCHAR_LIST;
899: l_return_status VARCHAR2(4000);
900: l_return_message VARCHAR2(4000);
901: i NUMBER;
902: l_bind_count NUMBER;

Line 1184: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,

1180: p_QUERY_ID IN NUMBER,
1181: p_INSTANCE_ID IN VARCHAR2 DEFAULT NULL,
1182: p_INSTANCE_NAME IN VARCHAR2,
1183: p_VARIABLE_ID IN CSM_INTEGER_LIST,
1184: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
1185: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
1186: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,
1187: x_INSTANCE_ID OUT NOCOPY NUMBER,
1188: x_return_status OUT NOCOPY VARCHAR2,

Line 1226: l_var_value_char_lst CSM_VARCHAR_LIST;

1222: SELECT CSM_QUERY_VARIABLE_VAL_ACC_S.NEXTVAL
1223: FROM DUAL;
1224:
1225: l_variable_id_lst CSM_INTEGER_LIST;
1226: l_var_value_char_lst CSM_VARCHAR_LIST;
1227: l_var_value_date_lst CSM_DATE_LIST;
1228: l_var_type_lst CSM_VARCHAR_LIST;
1229: l_query_id NUMBER;
1230: l_variable_cnt NUMBER;

Line 1228: l_var_type_lst CSM_VARCHAR_LIST;

1224:
1225: l_variable_id_lst CSM_INTEGER_LIST;
1226: l_var_value_char_lst CSM_VARCHAR_LIST;
1227: l_var_value_date_lst CSM_DATE_LIST;
1228: l_var_type_lst CSM_VARCHAR_LIST;
1229: l_query_id NUMBER;
1230: l_variable_cnt NUMBER;
1231: l_ins_variable_cnt NUMBER;
1232: l_instance_name VARCHAR2(255);

Line 1736: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,

1732: ***/
1733: PROCEDURE VALIDATE_WORKFLOW
1734: ( p_QUERY_ID IN NUMBER DEFAULT NULL,
1735: p_WORKFLOW IN VARCHAR2 DEFAULT NULL,
1736: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
1737: x_return_status OUT NOCOPY VARCHAR2,
1738: x_error_message OUT NOCOPY VARCHAR2
1739: )
1740: AS