APPS.AMS_QUERY_COND_DISP_STRUCT_PKG dependencies on AMS_QUERY_COND_DISP_STRUCT_ALL

Line 30: cursor C is select ROWID from AMS_QUERY_COND_DISP_STRUCT_ALL

26: X_PROGRAM_ID in NUMBER,
27: X_PROGRAM_APPLICATION_ID in NUMBER,
28: X_PROGRAM_UPDATE_DATE in DATE
29: ) is
30: cursor C is select ROWID from AMS_QUERY_COND_DISP_STRUCT_ALL
31: where QUERY_COND_DISP_STRUCT_ID = X_QUERY_COND_DISP_STRUCT_ID
32: ;
33: begin
34: insert into AMS_QUERY_COND_DISP_STRUCT_ALL (

Line 34: insert into AMS_QUERY_COND_DISP_STRUCT_ALL (

30: cursor C is select ROWID from AMS_QUERY_COND_DISP_STRUCT_ALL
31: where QUERY_COND_DISP_STRUCT_ID = X_QUERY_COND_DISP_STRUCT_ID
32: ;
33: begin
34: insert into AMS_QUERY_COND_DISP_STRUCT_ALL (
35: QUERY_COND_DISP_STRUCT_ID,
36: QUERY_TEMPLATE_ID,
37: QUERY_CONDITION_ID,
38: TOKEN_TYPE,

Line 158: from AMS_QUERY_COND_DISP_STRUCT_ALL

154: EXP_DISPLAY_SEQ,
155: OBJECT_VERSION_NUMBER,
156: REQUEST_ID,
157: SECURITY_GROUP_ID
158: from AMS_QUERY_COND_DISP_STRUCT_ALL
159: where QUERY_COND_DISP_STRUCT_ID = X_QUERY_COND_DISP_STRUCT_ID
160: for update of QUERY_COND_DISP_STRUCT_ID nowait;
161: recinfo c%rowtype;
162:

Line 254: update AMS_QUERY_COND_DISP_STRUCT_ALL set

250: X_PROGRAM_APPLICATION_ID in NUMBER,
251: X_PROGRAM_UPDATE_DATE in DATE
252: ) is
253: begin
254: update AMS_QUERY_COND_DISP_STRUCT_ALL set
255: QUERY_TEMPLATE_ID = X_QUERY_TEMPLATE_ID,
256: QUERY_CONDITION_ID = X_QUERY_CONDITION_ID,
257: TOKEN_TYPE = X_TOKEN_TYPE,
258: TOKEN_SEQUENCE = X_TOKEN_SEQUENCE,

Line 323: FROM AMS_QUERY_COND_DISP_STRUCT_ALL

319: l_db_luby_id number;
320:
321: CURSOR c_obj_verno IS
322: SELECT object_version_number, last_updated_by
323: FROM AMS_QUERY_COND_DISP_STRUCT_ALL
324: WHERE QUERY_COND_DISP_STRUCT_ID = X_QUERY_COND_DISP_STRUCT_ID;
325:
326: CURSOR c_chk_exists is
327: SELECT 'x'

Line 328: FROM AMS_QUERY_COND_DISP_STRUCT_ALL

324: WHERE QUERY_COND_DISP_STRUCT_ID = X_QUERY_COND_DISP_STRUCT_ID;
325:
326: CURSOR c_chk_exists is
327: SELECT 'x'
328: FROM AMS_QUERY_COND_DISP_STRUCT_ALL
329: WHERE QUERY_COND_DISP_STRUCT_ID = X_QUERY_COND_DISP_STRUCT_ID;
330:
331: CURSOR c_get_id is
332: SELECT AMS_QUERY_COND_DISP_STRUCT_S.NEXTVAL

Line 435: delete from AMS_QUERY_COND_DISP_STRUCT_ALL

431: if (sql%notfound) then
432: raise no_data_found;
433: end if;
434:
435: delete from AMS_QUERY_COND_DISP_STRUCT_ALL
436: where QUERY_COND_DISP_STRUCT_ID = X_QUERY_COND_DISP_STRUCT_ID;
437:
438: if (sql%notfound) then
439: raise no_data_found;

Line 449: from AMS_QUERY_COND_DISP_STRUCT_ALL B

445: begin
446: delete from AMS_QUERY_COND_DISP_STRUCT_TL T
447: where not exists
448: (select NULL
449: from AMS_QUERY_COND_DISP_STRUCT_ALL B
450: where B.QUERY_COND_DISP_STRUCT_ID = T.QUERY_COND_DISP_STRUCT_ID
451: );
452:
453: update AMS_QUERY_COND_DISP_STRUCT_TL T set (