APPS.AMS_CTD_USAGES_PKG dependencies on AMS_CLIK_THRU_USAGES

Line 15: cursor c is select ROWID from AMS_CLIK_THRU_USAGES

11: X_CREATED_BY in NUMBER,
12: X_LAST_UPDATE_LOGIN in NUMBER,
13: X_OBJECT_VERSION_NUMBER in NUMBER
14: ) is
15: cursor c is select ROWID from AMS_CLIK_THRU_USAGES
16: where USAGE_ID = X_USAGE_ID
17: ;
18:
19: begin

Line 20: insert into AMS_CLIK_THRU_USAGES (

16: where USAGE_ID = X_USAGE_ID
17: ;
18:
19: begin
20: insert into AMS_CLIK_THRU_USAGES (
21: USAGE_ID,
22: ACTION_ID,
23: APPLICABLE_FOR,
24: LAST_UPDATE_DATE,

Line 70: from AMS_CLIK_THRU_USAGES

66: LAST_UPDATED_BY,
67: CREATION_DATE,
68: CREATED_BY,
69: LAST_UPDATE_LOGIN
70: from AMS_CLIK_THRU_USAGES
71: where USAGE_ID = X_USAGE_ID
72: for update of USAGE_ID nowait;
73: recinfo c%rowtype;
74:

Line 114: update AMS_CLIK_THRU_USAGES set

110: X_LAST_UPDATED_BY in NUMBER,
111: X_LAST_UPDATE_LOGIN in NUMBER
112: ) is
113: begin
114: update AMS_CLIK_THRU_USAGES set
115: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
116: ,ACTION_ID = X_ACTION_ID
117: ,APPLICABLE_FOR = X_APPLICABLE_FOR
118: ,LAST_UPDATE_DATE = X_LAST_UPDATE_DATE

Line 135: delete from AMS_CLIK_THRU_USAGES

131: X_USAGE_ID IN NUMBER
132: ) is
133: begin
134:
135: delete from AMS_CLIK_THRU_USAGES
136: where USAGE_ID = X_USAGE_ID;
137:
138: if (sql%notfound) then
139: raise no_data_found;

Line 163: from AMS_CLIK_THRU_USAGES

159:
160: cursor c_obj_verno is
161: select OBJECT_VERSION_NUMBER,
162: last_updated_by
163: from AMS_CLIK_THRU_USAGES
164: where USAGE_ID = X_USAGE_ID;
165:
166: cursor c_chk_prd_exists is
167: select 'x'

Line 168: from AMS_CLIK_THRU_USAGES

164: where USAGE_ID = X_USAGE_ID;
165:
166: cursor c_chk_prd_exists is
167: select 'x'
168: from AMS_CLIK_THRU_USAGES
169: where USAGE_ID = X_USAGE_ID;
170:
171: BEGIN
172: