APPS.AMS_QUERY_TEMP_INST_PKG dependencies on AMS_QUERY_TEMPLATE_INSTANCE

Line 19: insert into AMS_QUERY_TEMPLATE_INSTANCE (

15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: begin
19: insert into AMS_QUERY_TEMPLATE_INSTANCE (
20: TEMPLATE_INSTANCE_ID,
21: TEMPLATE_ID,
22: ADMIN_INDICATOR_FLAG,
23: LAST_UPDATE_DATE,

Line 69: from AMS_QUERY_TEMPLATE_INSTANCE

65: VIEW_APPLICATION_ID,
66: INSTANCE_USED_BY,
67: INSTANCE_USED_BY_ID,
68: TEMPLATE_INSTANCE_ID
69: from AMS_QUERY_TEMPLATE_INSTANCE
70: where TEMPLATE_INSTANCE_ID = X_TEMPLATE_INSTANCE_ID
71: for update of TEMPLATE_INSTANCE_ID nowait;
72: begin
73: for Recinfo in c1 loop

Line 112: update AMS_QUERY_TEMPLATE_INSTANCE set

108: X_LAST_UPDATED_BY in NUMBER,
109: X_LAST_UPDATE_LOGIN in NUMBER
110: ) is
111: begin
112: update AMS_QUERY_TEMPLATE_INSTANCE set
113: TEMPLATE_ID = X_TEMPLATE_ID,
114: ADMIN_INDICATOR_FLAG = X_ADMIN_INDICATOR_FLAG,
115: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
116: REQUEST_ID = X_REQUEST_ID,

Line 135: delete from AMS_QUERY_TEMPLATE_INSTANCE

131: procedure DELETE_ROW (
132: X_TEMPLATE_INSTANCE_ID in NUMBER
133: ) is
134: begin
135: delete from AMS_QUERY_TEMPLATE_INSTANCE
136: where TEMPLATE_INSTANCE_ID = X_TEMPLATE_INSTANCE_ID;
137:
138: if (sql%notfound) then
139: raise no_data_found;

Line 165: FROM AMS_QUERY_TEMPLATE_INSTANCE

161: l_db_luby_id number;
162:
163: CURSOR c_obj_verno IS
164: SELECT object_version_number, last_updated_by
165: FROM AMS_QUERY_TEMPLATE_INSTANCE
166: WHERE TEMPLATE_INSTANCE_ID = x_TEMPLATE_INSTANCE_ID;
167:
168: CURSOR c_chk_exists is
169: SELECT 'x'

Line 170: FROM AMS_QUERY_TEMPLATE_INSTANCE

166: WHERE TEMPLATE_INSTANCE_ID = x_TEMPLATE_INSTANCE_ID;
167:
168: CURSOR c_chk_exists is
169: SELECT 'x'
170: FROM AMS_QUERY_TEMPLATE_INSTANCE
171: WHERE TEMPLATE_INSTANCE_ID = x_TEMPLATE_INSTANCE_ID;
172:
173: CURSOR c_get_id is
174: SELECT AMS_QUERY_TEMPLATE_INSTANCE_s.NEXTVAL

Line 174: SELECT AMS_QUERY_TEMPLATE_INSTANCE_s.NEXTVAL

170: FROM AMS_QUERY_TEMPLATE_INSTANCE
171: WHERE TEMPLATE_INSTANCE_ID = x_TEMPLATE_INSTANCE_ID;
172:
173: CURSOR c_get_id is
174: SELECT AMS_QUERY_TEMPLATE_INSTANCE_s.NEXTVAL
175: FROM DUAL;
176: BEGIN
177: if X_OWNER = 'SEED' then
178: l_user_id := 1;