APPS.CSM_MOBILE_QUERY_PKG dependencies on CSM_VARCHAR_LIST

Line 53: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,

49: p_RETENTION_DAYS IN NUMBER,
50: p_TEMPLATE IN VARCHAR2,
51: p_TEMPLATE_FILE IN VARCHAR2,
52: p_EXECUTION_MODE IN VARCHAR2,
53: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
54: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
55: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
56: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
57: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,

Line 54: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,

50: p_TEMPLATE IN VARCHAR2,
51: p_TEMPLATE_FILE IN VARCHAR2,
52: p_EXECUTION_MODE IN VARCHAR2,
53: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
54: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
55: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
56: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
57: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
58: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,

Line 55: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,

51: p_TEMPLATE_FILE IN VARCHAR2,
52: p_EXECUTION_MODE IN VARCHAR2,
53: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
54: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
55: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
56: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
57: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
58: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,
59: x_return_status OUT NOCOPY VARCHAR2,

Line 57: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,

53: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
54: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
55: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
56: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
57: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
58: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_error_message OUT NOCOPY VARCHAR2
61: )

Line 58: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,

54: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
55: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
56: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
57: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
58: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_error_message OUT NOCOPY VARCHAR2
61: )
62: AS

Line 281: l_variable_name_lst CSM_VARCHAR_LIST;

277: SELECT USER_ID
278: FROM ASG_USER
279: WHERE USER_NAME =c_user_name;
280: --Variable Declarations
281: l_variable_name_lst CSM_VARCHAR_LIST;
282: l_var_type_lst CSM_VARCHAR_LIST;
283: l_var_value_char_lst CSM_VARCHAR_LIST;
284: l_var_value_date_lst CSM_DATE_LIST;
285: l_var_hidden_lst CSM_VARCHAR_LIST;

Line 282: l_var_type_lst CSM_VARCHAR_LIST;

278: FROM ASG_USER
279: WHERE USER_NAME =c_user_name;
280: --Variable Declarations
281: l_variable_name_lst CSM_VARCHAR_LIST;
282: l_var_type_lst CSM_VARCHAR_LIST;
283: l_var_value_char_lst CSM_VARCHAR_LIST;
284: l_var_value_date_lst CSM_DATE_LIST;
285: l_var_hidden_lst CSM_VARCHAR_LIST;
286: l_var_default_lst CSM_VARCHAR_LIST;

Line 283: l_var_value_char_lst CSM_VARCHAR_LIST;

279: WHERE USER_NAME =c_user_name;
280: --Variable Declarations
281: l_variable_name_lst CSM_VARCHAR_LIST;
282: l_var_type_lst CSM_VARCHAR_LIST;
283: l_var_value_char_lst CSM_VARCHAR_LIST;
284: l_var_value_date_lst CSM_DATE_LIST;
285: l_var_hidden_lst CSM_VARCHAR_LIST;
286: l_var_default_lst CSM_VARCHAR_LIST;
287: l_user_id NUMBER;

Line 285: l_var_hidden_lst CSM_VARCHAR_LIST;

281: l_variable_name_lst CSM_VARCHAR_LIST;
282: l_var_type_lst CSM_VARCHAR_LIST;
283: l_var_value_char_lst CSM_VARCHAR_LIST;
284: l_var_value_date_lst CSM_DATE_LIST;
285: l_var_hidden_lst CSM_VARCHAR_LIST;
286: l_var_default_lst CSM_VARCHAR_LIST;
287: l_user_id NUMBER;
288: l_QUERY_ID NUMBER;
289: l_QUERY_NAME VARCHAR2(255);

Line 286: l_var_default_lst CSM_VARCHAR_LIST;

282: l_var_type_lst CSM_VARCHAR_LIST;
283: l_var_value_char_lst CSM_VARCHAR_LIST;
284: l_var_value_date_lst CSM_DATE_LIST;
285: l_var_hidden_lst CSM_VARCHAR_LIST;
286: l_var_default_lst CSM_VARCHAR_LIST;
287: l_user_id NUMBER;
288: l_QUERY_ID NUMBER;
289: l_QUERY_NAME VARCHAR2(255);
290: l_QUERY_TYPE VARCHAR2(255);