APPS.AMS_QUERY_CONDITION_VALUE_PKG dependencies on AMS_QUERY_CONDITION_VALUE

Line 1: package body AMS_QUERY_CONDITION_VALUE_PKG as

1: package body AMS_QUERY_CONDITION_VALUE_PKG as
2: /* $Header: amstqcvb.pls 120.0 2005/05/31 17:18:36 appldev noship $ */
3: procedure INSERT_ROW (
4: X_QUERY_COND_VALUE_ID in NUMBER,
5: X_ASSOC_ID in NUMBER,

Line 18: insert into AMS_QUERY_CONDITION_VALUE (

14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: begin
18: insert into AMS_QUERY_CONDITION_VALUE (
19: QUERY_COND_VALUE_ID,
20: ASSOC_ID,
21: QUERY_COND_DISP_STRUCT_ID,
22: VALUE,

Line 64: from AMS_QUERY_CONDITION_VALUE

60: VALUE,
61: LOV_VALUES_INCLUDED_FLAG,
62: OBJECT_VERSION_NUMBER,
63: QUERY_COND_VALUE_ID
64: from AMS_QUERY_CONDITION_VALUE
65: where QUERY_COND_VALUE_ID = X_QUERY_COND_VALUE_ID
66: for update of QUERY_COND_VALUE_ID nowait;
67: begin
68: for Recinfo in c1 loop

Line 105: update AMS_QUERY_CONDITION_VALUE set

101: X_LAST_UPDATED_BY in NUMBER,
102: X_LAST_UPDATE_LOGIN in NUMBER
103: ) is
104: begin
105: update AMS_QUERY_CONDITION_VALUE set
106: ASSOC_ID = X_ASSOC_ID,
107: QUERY_COND_DISP_STRUCT_ID = X_QUERY_COND_DISP_STRUCT_ID,
108: VALUE = X_VALUE,
109: LOV_VALUES_INCLUDED_FLAG = X_LOV_VALUES_INCLUDED_FLAG,

Line 127: delete from AMS_QUERY_CONDITION_VALUE

123: procedure DELETE_ROW (
124: X_QUERY_COND_VALUE_ID in NUMBER
125: ) is
126: begin
127: delete from AMS_QUERY_CONDITION_VALUE
128: where QUERY_COND_VALUE_ID = X_QUERY_COND_VALUE_ID;
129:
130: if (sql%notfound) then
131: raise no_data_found;

Line 155: FROM AMS_QUERY_CONDITION_VALUE

151: l_db_luby_id number;
152:
153: CURSOR c_obj_verno IS
154: SELECT object_version_number, last_updated_by
155: FROM AMS_QUERY_CONDITION_VALUE
156: WHERE QUERY_COND_VALUE_ID = x_QUERY_COND_VALUE_ID;
157:
158: CURSOR c_chk_exists is
159: SELECT 'x'

Line 160: FROM AMS_QUERY_CONDITION_VALUE

156: WHERE QUERY_COND_VALUE_ID = x_QUERY_COND_VALUE_ID;
157:
158: CURSOR c_chk_exists is
159: SELECT 'x'
160: FROM AMS_QUERY_CONDITION_VALUE
161: WHERE QUERY_COND_VALUE_ID = x_QUERY_COND_VALUE_ID;
162:
163: CURSOR c_get_id is
164: SELECT AMS_COND_STRUCT_RESTRICT_VAL_s.NEXTVAL

Line 190: AMS_QUERY_CONDITION_VALUE_PKG.insert_row (

186: l_QUERY_COND_VALUE_ID := x_QUERY_COND_VALUE_ID;
187: END IF;
188: l_obj_verno := 1;
189:
190: AMS_QUERY_CONDITION_VALUE_PKG.insert_row (
191: x_QUERY_COND_VALUE_ID => l_QUERY_COND_VALUE_ID,
192: X_ASSOC_ID => X_ASSOC_ID,
193: x_last_update_date => SYSDATE,
194: x_last_updated_by => l_user_id,

Line 215: AMS_QUERY_CONDITION_VALUE_PKG.update_row (

211:
212: if (l_db_luby_id IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
213: then
214:
215: AMS_QUERY_CONDITION_VALUE_PKG.update_row (
216: x_QUERY_COND_VALUE_ID => x_QUERY_COND_VALUE_ID,
217: X_ASSOC_ID => X_ASSOC_ID,
218: x_last_update_date => SYSDATE,
219: x_last_updated_by => l_user_id,

Line 235: end AMS_QUERY_CONDITION_VALUE_PKG;

231: END load_row;
232:
233:
234:
235: end AMS_QUERY_CONDITION_VALUE_PKG;