APPS.AMS_QUERY_COND_PKG dependencies on AMS_QUERY_CONDITION

Line 27: insert into AMS_QUERY_CONDITION (

23: X_LAST_UPDATED_BY in NUMBER,
24: X_LAST_UPDATE_LOGIN in NUMBER
25: ) is
26: begin
27: insert into AMS_QUERY_CONDITION (
28: PARAMETER_KEY,
29: QUERY_CONDITION_ID,
30: TEMPLATE_ID,
31: JOIN_CONDITION,

Line 106: from AMS_QUERY_CONDITION

102: MAX_TOKEN_COUNT,
103: OBJECT_VERSION_NUMBER,
104: COND_KEYWORD,
105: QUERY_CONDITION_ID
106: from AMS_QUERY_CONDITION
107: where QUERY_CONDITION_ID = X_QUERY_CONDITION_ID
108: for update of QUERY_CONDITION_ID nowait;
109: begin
110: for Recinfo in c1 loop

Line 172: update AMS_QUERY_CONDITION set

168: X_LAST_UPDATED_BY in NUMBER,
169: X_LAST_UPDATE_LOGIN in NUMBER
170: ) is
171: begin
172: update AMS_QUERY_CONDITION set
173: PARAMETER_KEY = X_PARAMETER_KEY,
174: TEMPLATE_ID = X_TEMPLATE_ID,
175: JOIN_CONDITION = X_JOIN_CONDITION,
176: OPERAND_DATA_TYPE = X_OPERAND_DATA_TYPE,

Line 203: delete from AMS_QUERY_CONDITION

199: procedure DELETE_ROW (
200: X_QUERY_CONDITION_ID in NUMBER
201: ) is
202: begin
203: delete from AMS_QUERY_CONDITION
204: where QUERY_CONDITION_ID = X_QUERY_CONDITION_ID;
205:
206: if (sql%notfound) then
207: raise no_data_found;

Line 241: FROM AMS_QUERY_CONDITION

237: l_db_luby_id number;
238:
239: CURSOR c_obj_verno IS
240: SELECT object_version_number, last_updated_by
241: FROM AMS_QUERY_CONDITION
242: WHERE QUERY_CONDITION_ID = x_QUERY_CONDITION_ID;
243:
244: CURSOR c_chk_exists is
245: SELECT 'x'

Line 246: FROM AMS_QUERY_CONDITION

242: WHERE QUERY_CONDITION_ID = x_QUERY_CONDITION_ID;
243:
244: CURSOR c_chk_exists is
245: SELECT 'x'
246: FROM AMS_QUERY_CONDITION
247: WHERE QUERY_CONDITION_ID = x_QUERY_CONDITION_ID;
248:
249: CURSOR c_get_id is
250: SELECT AMS_QUERY_CONDITION_s.NEXTVAL

Line 250: SELECT AMS_QUERY_CONDITION_s.NEXTVAL

246: FROM AMS_QUERY_CONDITION
247: WHERE QUERY_CONDITION_ID = x_QUERY_CONDITION_ID;
248:
249: CURSOR c_get_id is
250: SELECT AMS_QUERY_CONDITION_s.NEXTVAL
251: FROM DUAL;
252: BEGIN
253: if X_OWNER = 'SEED' then
254: l_user_id := 1;