APPS.AMS_CPAG_QUERIES_PKG dependencies on AMS_CPAG_QUERIES

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 16: cursor C is select ROWID from AMS_CPAG_QUERIES

12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER,
14: X_OBJECT_VERSION_NUMBER in NUMBER
15: ) is
16: cursor C is select ROWID from AMS_CPAG_QUERIES
17: where QUERY_ID = X_QUERY_ID
18: ;
19: begin
20: insert into AMS_CPAG_QUERIES (

Line 20: insert into AMS_CPAG_QUERIES (

16: cursor C is select ROWID from AMS_CPAG_QUERIES
17: where QUERY_ID = X_QUERY_ID
18: ;
19: begin
20: insert into AMS_CPAG_QUERIES (
21: QUERY_ID,
22: QUERY_TEXT,
23: UPLOAD_DATE,
24: EXPIRATION_DATE,

Line 66: from AMS_CPAG_QUERIES

62: OBJECT_VERSION_NUMBER
63: ,QUERY_TEXT
64: ,UPLOAD_DATE
65: ,EXPIRATION_DATE
66: from AMS_CPAG_QUERIES
67: where QUERY_ID = X_QUERY_ID
68: for update of QUERY_ID nowait;
69: recinfo c%rowtype;
70:

Line 109: update AMS_CPAG_QUERIES set

105: X_LAST_UPDATED_BY in NUMBER,
106: X_LAST_UPDATE_LOGIN in NUMBER
107: ) is
108: begin
109: update AMS_CPAG_QUERIES set
110: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
111: QUERY_TEXT = X_QUERY_TEXT,
112: UPLOAD_DATE = X_UPLOAD_DATE,
113: EXPIRATION_DATE = X_EXPIRATION_DATE,

Line 128: delete from AMS_CPAG_QUERIES

124: procedure DELETE_ROW (
125: X_QUERY_ID in NUMBER
126: ) is
127: begin
128: delete from AMS_CPAG_QUERIES
129: where QUERY_ID = X_QUERY_ID;
130:
131: if (sql%notfound) then
132: raise no_data_found;

Line 152: from AMS_CPAG_QUERIES

148: l_row_id varchar2(100);
149:
150: cursor c_obj_verno is
151: select object_version_number
152: from AMS_CPAG_QUERIES
153: where query_id = X_QUERY_ID;
154:
155: cursor c_chk_qry_exists is
156: select 'x'

Line 157: from AMS_CPAG_QUERIES

153: where query_id = X_QUERY_ID;
154:
155: cursor c_chk_qry_exists is
156: select 'x'
157: from AMS_CPAG_QUERIES
158: where QUERY_ID = X_QUERY_ID;
159:
160: BEGIN
161:

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;