APPS.AMS_QUERY_TMP_ASSOC_PKG dependencies on AMS_QUERY_TEMP_INST_COND_ASSOC

Line 19: insert into AMS_QUERY_TEMP_INST_COND_ASSOC (

15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: begin
19: insert into AMS_QUERY_TEMP_INST_COND_ASSOC (
20: ASSOC_ID,
21: TEMPLATE_INSTANCE_ID,
22: QUERY_CONDITION_ID,
23: CONDITION_SEQUENCE,

Line 69: from AMS_QUERY_TEMP_INST_COND_ASSOC

65: RUNNING_TOTAL,
66: DELTA,
67: OBJECT_VERSION_NUMBER,
68: ASSOC_ID
69: from AMS_QUERY_TEMP_INST_COND_ASSOC
70: where ASSOC_ID = X_ASSOC_ID
71: for update of ASSOC_ID nowait;
72: begin
73: for Recinfo in c1 loop

Line 112: update AMS_QUERY_TEMP_INST_COND_ASSOC set

108: X_LAST_UPDATED_BY in NUMBER,
109: X_LAST_UPDATE_LOGIN in NUMBER
110: ) is
111: begin
112: update AMS_QUERY_TEMP_INST_COND_ASSOC set
113: TEMPLATE_INSTANCE_ID = X_TEMPLATE_INSTANCE_ID,
114: QUERY_CONDITION_ID = X_QUERY_CONDITION_ID,
115: CONDITION_SEQUENCE = X_CONDITION_SEQUENCE,
116: RUNNING_TOTAL = X_RUNNING_TOTAL,

Line 136: delete from AMS_QUERY_TEMP_INST_COND_ASSOC

132: procedure DELETE_ROW (
133: X_ASSOC_ID in NUMBER
134: ) is
135: begin
136: delete from AMS_QUERY_TEMP_INST_COND_ASSOC
137: where ASSOC_ID = X_ASSOC_ID;
138:
139: if (sql%notfound) then
140: raise no_data_found;

Line 167: FROM AMS_QUERY_TEMP_INST_COND_ASSOC

163: l_db_luby_id number;
164:
165: CURSOR c_obj_verno IS
166: SELECT object_version_number, last_updated_by
167: FROM AMS_QUERY_TEMP_INST_COND_ASSOC
168: WHERE ASSOC_ID = x_ASSOC_ID;
169:
170: CURSOR c_chk_exists is
171: SELECT 'x'

Line 172: FROM AMS_QUERY_TEMP_INST_COND_ASSOC

168: WHERE ASSOC_ID = x_ASSOC_ID;
169:
170: CURSOR c_chk_exists is
171: SELECT 'x'
172: FROM AMS_QUERY_TEMP_INST_COND_ASSOC
173: WHERE ASSOC_ID = x_ASSOC_ID;
174:
175: CURSOR c_get_id is
176: SELECT AMS_QUERY_TEMP_INST_COND_ASC_S.NEXTVAL