DBA Data[Home] [Help]

APPS.CSM_EMAIL_QUERY_PKG dependencies on CSM_VARCHAR_LIST

Line 345: p_var_value_lst IN CSM_VARCHAR_LIST,

341:
342: PROCEDURE EXECUTE_COMMAND
343: ( p_email_id IN VARCHAR2,
344: p_command_name IN VARCHAR2,
345: p_var_value_lst IN CSM_VARCHAR_LIST,
346: p_instance_id OUT nocopy NUMBER,
347: x_return_status OUT nocopy VARCHAR2,
348: x_error_message OUT nocopy VARCHAR2
349: )

Line 399: l_var_value_char_lst CSM_VARCHAR_LIST;

395: l_level_value NUMBER;
396: l_instance_id NUMBER;
397: j NUMBER;
398: l_variable_id_lst CSM_INTEGER_LIST;
399: l_var_value_char_lst CSM_VARCHAR_LIST;
400: l_var_value_date_lst CSM_DATE_LIST;
401: l_var_type_lst CSM_VARCHAR_LIST;
402: l_var_value_lst CSM_VARCHAR_LIST;
403: l_default_flag_lst CSM_VARCHAR_LIST;

Line 401: l_var_type_lst CSM_VARCHAR_LIST;

397: j NUMBER;
398: l_variable_id_lst CSM_INTEGER_LIST;
399: l_var_value_char_lst CSM_VARCHAR_LIST;
400: l_var_value_date_lst CSM_DATE_LIST;
401: l_var_type_lst CSM_VARCHAR_LIST;
402: l_var_value_lst CSM_VARCHAR_LIST;
403: l_default_flag_lst CSM_VARCHAR_LIST;
404: l_reqd_var_count NUMBER;
405: l_application_id NUMBER;

Line 402: l_var_value_lst CSM_VARCHAR_LIST;

398: l_variable_id_lst CSM_INTEGER_LIST;
399: l_var_value_char_lst CSM_VARCHAR_LIST;
400: l_var_value_date_lst CSM_DATE_LIST;
401: l_var_type_lst CSM_VARCHAR_LIST;
402: l_var_value_lst CSM_VARCHAR_LIST;
403: l_default_flag_lst CSM_VARCHAR_LIST;
404: l_reqd_var_count NUMBER;
405: l_application_id NUMBER;
406: l_resp_id NUMBER;

Line 403: l_default_flag_lst CSM_VARCHAR_LIST;

399: l_var_value_char_lst CSM_VARCHAR_LIST;
400: l_var_value_date_lst CSM_DATE_LIST;
401: l_var_type_lst CSM_VARCHAR_LIST;
402: l_var_value_lst CSM_VARCHAR_LIST;
403: l_default_flag_lst CSM_VARCHAR_LIST;
404: l_reqd_var_count NUMBER;
405: l_application_id NUMBER;
406: l_resp_id NUMBER;
407: l_old_user_id NUMBER;

Line 499: l_var_value_lst := CSM_VARCHAR_LIST();

495: -- Assuming no Date parames are passed.
496: IF p_var_value_lst.count = l_variable_id_lst.count THEN
497: l_var_value_lst := p_var_value_lst;
498: ELSE
499: l_var_value_lst := CSM_VARCHAR_LIST();
500: j := 1;
501: FOR i IN 1 .. l_variable_id_lst.count LOOP
502: l_var_value_lst.EXTEND(1);
503: if L_DEFAULT_FLAG_LST(I) = 'Y' then