APPS.AMS_QUERY_ALIAS_PKG dependencies on AMS_QUERY_ALIAS

Line 1: package body AMS_QUERY_ALIAS_PKG as

1: package body AMS_QUERY_ALIAS_PKG as
2: /* $Header: amstqalb.pls 120.0 2005/06/01 23:39:11 appldev noship $ */
3: procedure INSERT_ROW (
4: X_QUERY_ALIAS_ID in NUMBER,
5: X_OBJECT_VERSION_NUMBER in NUMBER,

Line 18: insert into AMS_QUERY_ALIAS (

14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: begin
18: insert into AMS_QUERY_ALIAS (
19: CREATION_DATE,
20: CREATED_BY,
21: LAST_UPDATE_LOGIN,
22: OBJECT_VERSION_NUMBER,

Line 63: from AMS_QUERY_ALIAS

59: OBJECT_NAME,
60: ALIAS_SEQ,
61: PARENT_QUERY_ALIAS_ID,
62: TEMPLATE_ID
63: from AMS_QUERY_ALIAS
64: where QUERY_ALIAS_ID = X_QUERY_ALIAS_ID
65: for update of QUERY_ALIAS_ID nowait;
66: begin
67: for Recinfo in c1 loop

Line 103: update AMS_QUERY_ALIAS set

99: X_LAST_UPDATED_BY in NUMBER,
100: X_LAST_UPDATE_LOGIN in NUMBER
101: ) is
102: begin
103: update AMS_QUERY_ALIAS set
104: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
105: REQUEST_ID = X_REQUEST_ID,
106: OBJECT_NAME = X_OBJECT_NAME,
107: ALIAS_SEQ = X_ALIAS_SEQ,

Line 125: delete from AMS_QUERY_ALIAS

121: procedure DELETE_ROW (
122: X_QUERY_ALIAS_ID in NUMBER
123: ) is
124: begin
125: delete from AMS_QUERY_ALIAS
126: where QUERY_ALIAS_ID = X_QUERY_ALIAS_ID;
127:
128: if (sql%notfound) then
129: raise no_data_found;

Line 154: FROM AMS_QUERY_ALIAS

150: l_db_luby_id number;
151:
152: CURSOR c_obj_verno IS
153: SELECT object_version_number, last_updated_by
154: FROM AMS_QUERY_ALIAS
155: WHERE QUERY_ALIAS_ID = x_QUERY_ALIAS_ID;
156:
157: CURSOR c_chk_exists is
158: SELECT 'x'

Line 159: FROM AMS_QUERY_ALIAS

155: WHERE QUERY_ALIAS_ID = x_QUERY_ALIAS_ID;
156:
157: CURSOR c_chk_exists is
158: SELECT 'x'
159: FROM AMS_QUERY_ALIAS
160: WHERE QUERY_ALIAS_ID = x_QUERY_ALIAS_ID;
161:
162: CURSOR c_get_id is
163: SELECT AMS_QUERY_ALIAS_s.NEXTVAL

Line 163: SELECT AMS_QUERY_ALIAS_s.NEXTVAL

159: FROM AMS_QUERY_ALIAS
160: WHERE QUERY_ALIAS_ID = x_QUERY_ALIAS_ID;
161:
162: CURSOR c_get_id is
163: SELECT AMS_QUERY_ALIAS_s.NEXTVAL
164: FROM DUAL;
165: BEGIN
166: if X_OWNER = 'SEED' then
167: l_user_id := 1;

Line 189: AMS_QUERY_ALIAS_PKG.insert_row (

185: l_QUERY_ALIAS_ID := x_QUERY_ALIAS_ID;
186: END IF;
187: l_obj_verno := 1;
188:
189: AMS_QUERY_ALIAS_PKG.insert_row (
190: x_QUERY_ALIAS_ID => l_QUERY_ALIAS_ID,
191: X_OBJECT_NAME => X_OBJECT_NAME,
192: x_last_update_date => SYSDATE,
193: x_last_updated_by => l_user_id,

Line 215: AMS_QUERY_ALIAS_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_ALIAS_PKG.update_row (
216: x_QUERY_ALIAS_ID => x_QUERY_ALIAS_ID,
217: X_OBJECT_NAME => X_OBJECT_NAME,
218: x_last_update_date => SYSDATE,
219: x_last_updated_by => l_user_id,

Line 235: end AMS_QUERY_ALIAS_PKG;

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