APPS.AMS_CLIK_THRU_ACT_PARAM_PKG dependencies on AMS_CLIK_THRU_ACT_PARAMS_B

Line 24: cursor c is select ROWID from AMS_CLIK_THRU_ACT_PARAMS_B

20: X_LAST_UPDATE_LOGIN in NUMBER,
21: X_OBJECT_VERSION_NUMBER in NUMBER
22: )
23: is
24: cursor c is select ROWID from AMS_CLIK_THRU_ACT_PARAMS_B
25: where ACTION_PARAM_ID = X_ACTION_PARAM_ID
26: ;
27: cursor ctl is select ROWID from AMS_CLIK_THRU_ACT_PARAMS_TL
28: where ACTION_PARAM_ID = X_ACTION_PARAM_ID

Line 32: insert into AMS_CLIK_THRU_ACT_PARAMS_B (

28: where ACTION_PARAM_ID = X_ACTION_PARAM_ID
29: ;
30: begin
31:
32: insert into AMS_CLIK_THRU_ACT_PARAMS_B (
33: ACTION_PARAM_ID
34: ,ACTION_ID
35: ,ACTION_CODE
36: ,ACTION_PARAM_CODE

Line 145: from AMS_CLIK_THRU_ACT_PARAMS_B

141: ,LAST_UPDATED_BY
142: ,CREATION_DATE
143: ,CREATED_BY
144: ,LAST_UPDATE_LOGIN
145: from AMS_CLIK_THRU_ACT_PARAMS_B
146: where ACTION_PARAM_ID = X_ACTION_PARAM_ID
147: for update of ACTION_PARAM_ID nowait;
148: recinfo c%rowtype;
149:

Line 234: update AMS_CLIK_THRU_ACT_PARAMS_B set

230: is
231: begin
232:
233:
234: update AMS_CLIK_THRU_ACT_PARAMS_B set
235: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
236: ,ACTION_ID = X_ACTION_ID
237: ,ACTION_CODE = X_ACTION_CODE
238: ,ACTION_PARAM_CODE = X_ACTION_PARAM_CODE

Line 282: delete from AMS_CLIK_THRU_ACT_PARAMS_B

278: if (sql%notfound) then
279: raise no_data_found;
280: end if;
281:
282: delete from AMS_CLIK_THRU_ACT_PARAMS_B
283: where ACTION_PARAM_ID = X_ACTION_PARAM_ID;
284:
285: if (sql%notfound) then
286: raise no_data_found;

Line 317: from AMS_CLIK_THRU_ACT_PARAMS_B

313: l_dummy_char varchar2(1);
314:
315: cursor c_obj_verno is
316: select OBJECT_VERSION_NUMBER, last_updated_by
317: from AMS_CLIK_THRU_ACT_PARAMS_B
318: where ACTION_PARAM_ID = X_ACTION_PARAM_ID;
319:
320: cursor c_ctp_exists is
321: select 'x'

Line 322: from AMS_CLIK_THRU_ACT_PARAMS_B

318: where ACTION_PARAM_ID = X_ACTION_PARAM_ID;
319:
320: cursor c_ctp_exists is
321: select 'x'
322: from AMS_CLIK_THRU_ACT_PARAMS_B
323: where ACTION_PARAM_ID = X_ACTION_PARAM_ID;
324:
325: BEGIN
326:

Line 442: FROM AMS_CLIK_THRU_ACT_PARAMS_B B

438: BEGIN
439: DELETE FROM AMS_CLIK_THRU_ACT_PARAMS_TL T
440: WHERE NOT EXISTS
441: (SELECT NULL
442: FROM AMS_CLIK_THRU_ACT_PARAMS_B B
443: WHERE B.ACTION_PARAM_ID = T.ACTION_PARAM_ID
444: );
445:
446: UPDATE AMS_CLIK_THRU_ACT_PARAMS_TL T SET (