APPS.AMS_ADV_FILTER_PVT dependencies on JTF_PERZ_QUERY_PARAM

Line 62: SELECT JTF_PERZ_QUERY_PARAM_S.NEXTVAL

58:
59: l_filter_rec filter_rec_type := p_filter_rec;
60:
61: CURSOR c_id IS
62: SELECT JTF_PERZ_QUERY_PARAM_S.NEXTVAL
63: FROM dual;
64:
65: CURSOR c_id_exists (l_id IN NUMBER) IS
66: SELECT 1

Line 67: FROM JTF_PERZ_QUERY_PARAM

63: FROM dual;
64:
65: CURSOR c_id_exists (l_id IN NUMBER) IS
66: SELECT 1
67: FROM JTF_PERZ_QUERY_PARAM
68: WHERE QUERY_PARAM_ID = l_id;
69:
70: l_obj_type VARCHAR2(30);
71: l_obj_id NUMBER;

Line 274: FROM JTF_PERZ_QUERY_PARAM

270: IS
271:
272: CURSOR c_get_filter_row(p_query_param_id NUMBER) IS
273: SELECT *
274: FROM JTF_PERZ_QUERY_PARAM
275: WHERE query_param_id = p_query_param_id;
276:
277: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Filter_Row';
278: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 478: FROM JTF_PERZ_QUERY_PARAM

474: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
475:
476: CURSOR c_get_parameter_type(p_query_param_id NUMBER) IS
477: SELECT parameter_type
478: FROM JTF_PERZ_QUERY_PARAM
479: WHERE query_param_id = p_query_param_id;
480:
481: l_obj_type VARCHAR2(30);
482: l_obj_id NUMBER;

Line 627: -- 'JTF_PERZ_QUERY_PARAM',

623: x_return_status := FND_API.g_ret_sts_success;
624: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
625: l_valid_flag := 'T';
626: -- AMS_Utility_PVT.check_uniqueness(
627: -- 'JTF_PERZ_QUERY_PARAM',
628: -- 'query_param_id = 0'
629: -- || p_filter_rec.query_param_id ||''''
630: -- );
631: ELSE

Line 633: 'JTF_PERZ_QUERY_PARAM',

629: -- || p_filter_rec.query_param_id ||''''
630: -- );
631: ELSE
632: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
633: 'JTF_PERZ_QUERY_PARAM',
634: 'query_param_id= ''' || p_filter_rec.query_param_id ||
635: ''' AND query_param_id <> ' || p_filter_rec.query_param_id
636: );
637: END IF;

Line 802: FROM jtf_perz_query_param

798: l_return_status VARCHAR2(1);
799:
800: CURSOR c_complete IS
801: SELECT *
802: FROM jtf_perz_query_param
803: WHERE query_param_id = p_filter_rec.query_param_id ;
804:
805: l_filter_rec c_complete%ROWTYPE;
806:

Line 1066: FROM JTF_PERZ_QUERY Query, JTF_PERZ_QUERY_PARAM QParam, AMS_LIST_SRC_FIELDS Fields

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 );

Line 1075: FROM jtf_perz_query_param

1071:
1072: /* SELECT query_param_id ,parameter_name,parameter_type,parameter_value
1073: ,parameter_condition,parameter_sequence,created_by,last_updated_by
1074: ,last_update_date,last_update_login
1075: FROM jtf_perz_query_param
1076: WHERE query_id = l_qid
1077: AND parameter_type = l_ptype;
1078: */
1079:

Line 1239: FROM JTF_PERZ_QUERY_PARAM

1235: IS
1236:
1237: CURSOR c_get_filter_row(p_query_param_id NUMBER) IS
1238: SELECT *
1239: FROM JTF_PERZ_QUERY_PARAM
1240: WHERE query_param_id = p_query_param_id;
1241:
1242: l_ref_filter_rec c_get_filter_row%ROWTYPE ;
1243:

Line 1312: FROM JTF_PERZ_QUERY_PARAM QParam, AMS_LIST_SRC_FIELDS fields

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: