[Home] [Help]
8: g_object_name CONSTANT VARCHAR2(30) := 'CSM_QUERY_INSTANCE_PKG';
9: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_QUERY_INSTANCES';
10: g_pub_qvv_name CONSTANT VARCHAR2(30) := 'CSM_QUERY_VARIABLE_VALUES';
11: g_debug_level NUMBER; -- debug level
12: g_seqno_lst CSM_INTEGER_LIST;
13: /* Select all inq records */
14: CURSOR c_query_instances( b_user_name VARCHAR2, b_tranid NUMBER, b_from_sync VARCHAR2) is
15: SELECT inq.*
16: FROM CSM_QUERY_INSTANCES_INQ inq,
82:
83: --Variable Declarations
84: l_msg_count NUMBER;
85: l_msg_data VARCHAR2(4000);
86: l_variable_id_lst CSM_INTEGER_LIST;
87: l_var_value_char_lst CSM_VARCHAR_LIST;
88: l_var_value_date_lst CSM_DATE_LIST;
89: l_var_type_lst CSM_VARCHAR_LIST;
90: l_variable_id_inq_lst CSM_INTEGER_LIST;
86: l_variable_id_lst CSM_INTEGER_LIST;
87: l_var_value_char_lst CSM_VARCHAR_LIST;
88: l_var_value_date_lst CSM_DATE_LIST;
89: l_var_type_lst CSM_VARCHAR_LIST;
90: l_variable_id_inq_lst CSM_INTEGER_LIST;
91: l_var_value_char_inq_lst CSM_VARCHAR_LIST;
92: l_var_value_date_inq_lst CSM_DATE_LIST;
93: l_query_id NUMBER;
94: l_variable_cnt NUMBER;