APPS.AMS_CPAG_QUERY_USAGES_PKG dependencies on AMS_CPAG_QUERY_USAGES_PKG

Line 1: package body AMS_CPAG_QUERY_USAGES_PKG as

1: package body AMS_CPAG_QUERY_USAGES_PKG as
2: /* $Header: amslcqub.pls 115.0 2002/06/13 19:02:15 gdeodhar noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out VARCHAR2,
5: X_QUERY_USAGE_ID in NUMBER,

Line 174: AMS_CPAG_QUERY_USAGES_PKG.INSERT_ROW(

170: close c_chk_qry_exists;
171:
172: l_obj_verno := 1;
173:
174: AMS_CPAG_QUERY_USAGES_PKG.INSERT_ROW(
175: X_ROWID => l_row_id,
176: X_QUERY_USAGE_ID => X_QUERY_USAGE_ID,
177: X_QUERY_USED_BY_TYPE => X_QUERY_USED_BY_TYPE,
178: X_QUERY_USED_BY_ID => X_QUERY_USED_BY_ID,

Line 192: AMS_CPAG_QUERY_USAGES_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_QUERY_USAGES_PKG.UPDATE_ROW(
193: X_QUERY_USAGE_ID => X_QUERY_USAGE_ID,
194: X_QUERY_USED_BY_TYPE => X_QUERY_USED_BY_TYPE,
195: X_QUERY_USED_BY_ID => X_QUERY_USED_BY_ID,
196: X_QUERY_ID => X_QUERY_ID,

Line 206: end AMS_CPAG_QUERY_USAGES_PKG;

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