[Home] [Help]
1062: CURSOR c_filterRec(l_qid IN NUMBER ,l_ptype in VARCHAR2) IS
1063: SELECT QParam.query_param_id ,QParam.parameter_name,QParam.parameter_type,QParam.parameter_value
1064: ,QParam.parameter_condition,QParam.parameter_sequence,QParam.created_by,QParam.last_updated_by
1065: ,QParam.last_update_date,QParam.last_update_login
1066: FROM JTF_PERZ_QUERY Query, JTF_PERZ_QUERY_PARAM QParam, AMS_LIST_SRC_FIELDS Fields
1067: WHERE (Query.query_id = l_qid
1068: AND QParam.parameter_type = l_ptype
1069: AND QParam.parameter_name = fields.list_source_field_id
1070: AND Query.query_id = QParam.query_id );
1078: */
1079:
1080: CURSOR c_fieldName(l_fieldId IN NUMBER , p_ds_id IN NUMBER) IS
1081: SELECT b.source_object_name || '.' || a.source_column_name
1082: FROM ams_list_src_fields_vl a , ams_list_src_types b , ams_list_src_types d
1083: WHERE a.list_source_field_id = l_fieldId
1084: AND a.list_source_type_id = b.list_source_type_id
1085: AND d.list_source_type_id = p_ds_id
1086: AND d.enabled_flag = 'Y'
1299: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1300:
1301: CURSOR c_fieldId(p_fieldName IN VARCHAR2 , p_ds_id IN NUMBER) IS
1302: SELECT to_char(list_source_field_id)
1303: FROM ams_list_src_fields_vl
1304: WHERE source_column_name = SUBSTR(p_fieldName , INSTR(p_fieldName , '.') + 1)
1305: AND list_source_type_id = p_ds_id
1306: ;
1307: l_fieldName VARCHAR2(60);
1308:
1309: --start kbasavar 4/23/2004 for bug 3565835
1310: CURSOR c_get_data_source(p_query_param_id IN NUMBER) IS
1311: SELECT Fields.LIST_SOURCE_TYPE_ID
1312: FROM JTF_PERZ_QUERY_PARAM QParam, AMS_LIST_SRC_FIELDS fields
1313: WHERE (QParam.QUERY_PARAM_ID = p_query_param_id AND QParam.parameter_name = fields.list_source_field_id );
1314: l_data_source NUMBER ;
1315: --end kbasavar 4/23/2004 for bug 3565835
1316: