APPS.AMS_CPAG_QUERIES_PKG dependencies on AMS_CPAG_QUERIES_PKG

Line 1: package body AMS_CPAG_QUERIES_PKG as

1: package body AMS_CPAG_QUERIES_PKG as
2: /* $Header: amslcqrb.pls 115.0 2002/06/13 19:01:57 gdeodhar noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out VARCHAR2,
5: X_QUERY_ID in NUMBER,

Line 174: AMS_CPAG_QUERIES_PKG.INSERT_ROW(

170: close c_chk_qry_exists;
171:
172: l_obj_verno := 1;
173:
174: AMS_CPAG_QUERIES_PKG.INSERT_ROW(
175: X_ROWID => l_row_id,
176: X_QUERY_ID => X_QUERY_ID,
177: X_QUERY_TEXT => X_QUERY_TEXT,
178: X_UPLOAD_DATE => X_UPLOAD_DATE,

Line 192: AMS_CPAG_QUERIES_PKG.UPDATE_ROW(

188: close c_chk_qry_exists;
189: open c_obj_verno;
190: fetch c_obj_verno into l_obj_verno;
191: close c_obj_verno;
192: AMS_CPAG_QUERIES_PKG.UPDATE_ROW(
193: X_QUERY_ID => X_QUERY_ID,
194: X_QUERY_TEXT => X_QUERY_TEXT,
195: X_UPLOAD_DATE => X_UPLOAD_DATE,
196: X_EXPIRATION_DATE => X_EXPIRATION_DATE,

Line 206: end AMS_CPAG_QUERIES_PKG;

202: end if;
203:
204: END LOAD_ROW;
205:
206: end AMS_CPAG_QUERIES_PKG;