APPS.AMS_CLIK_THRU_ACT_PKG dependencies on AMS_CLIK_THRU_ACTIONS_B

Line 28: cursor c is select ROWID from AMS_CLIK_THRU_ACTIONS_B

24: X_CREATED_BY in NUMBER,
25: X_LAST_UPDATE_LOGIN in NUMBER,
26: X_OBJECT_VERSION_NUMBER in NUMBER
27: ) is
28: cursor c is select ROWID from AMS_CLIK_THRU_ACTIONS_B
29: where ACTION_ID = X_ACTION_ID
30: ;
31: cursor ctl is select ROWID from AMS_CLIK_THRU_ACTIONS_TL
32: where ACTION_ID = X_ACTION_ID

Line 35: insert into AMS_CLIK_THRU_ACTIONS_B (

31: cursor ctl is select ROWID from AMS_CLIK_THRU_ACTIONS_TL
32: where ACTION_ID = X_ACTION_ID
33: ;
34: begin
35: insert into AMS_CLIK_THRU_ACTIONS_B (
36: ACTION_ID
37: ,ACTION_CODE
38: ,EXECUTABLE_NAME
39: ,SERVER_URL

Line 167: from AMS_CLIK_THRU_ACTIONS_B

163: ,LAST_UPDATED_BY
164: ,CREATION_DATE
165: ,CREATED_BY
166: ,LAST_UPDATE_LOGIN
167: from AMS_CLIK_THRU_ACTIONS_B
168: where ACTION_ID = X_ACTION_ID
169: for update of ACTION_ID nowait;
170: recinfo c%rowtype;
171:

Line 283: update AMS_CLIK_THRU_ACTIONS_B set

279: X_LAST_UPDATED_BY in NUMBER,
280: X_LAST_UPDATE_LOGIN in NUMBER
281: ) is
282: begin
283: update AMS_CLIK_THRU_ACTIONS_B set
284: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
285: ,ACTION_CODE = X_ACTION_CODE
286: ,EXECUTABLE_NAME = X_EXECUTABLE_NAME
287: ,SERVER_URL = X_SERVER_URL

Line 334: delete from AMS_CLIK_THRU_ACTIONS_B

330: if (sql%notfound) then
331: raise no_data_found;
332: end if;
333:
334: delete from AMS_CLIK_THRU_ACTIONS_B
335: where ACTION_ID = X_ACTION_ID;
336:
337: if (sql%notfound) then
338: raise no_data_found;

Line 373: from AMS_CLIK_THRU_ACTIONS_B

369:
370: cursor c_obj_verno is
371: select OBJECT_VERSION_NUMBER,
372: last_updated_by
373: from AMS_CLIK_THRU_ACTIONS_B
374: where ACTION_ID = X_ACTION_ID;
375:
376: cursor c_chk_cta_exists is
377: select 'x'

Line 378: from AMS_CLIK_THRU_ACTIONS_B

374: where ACTION_ID = X_ACTION_ID;
375:
376: cursor c_chk_cta_exists is
377: select 'x'
378: from AMS_CLIK_THRU_ACTIONS_B
379: where ACTION_ID = X_ACTION_ID;
380:
381: cursor ctl_chk_cta_exists is
382: select 'x'

Line 513: FROM AMS_CLIK_THRU_ACTIONS_B B

509: BEGIN
510: DELETE FROM AMS_CLIK_THRU_ACTIONS_TL T
511: WHERE NOT EXISTS
512: (SELECT NULL
513: FROM AMS_CLIK_THRU_ACTIONS_B B
514: WHERE B.ACTION_ID = T.ACTION_ID
515: );
516:
517: UPDATE AMS_CLIK_THRU_ACTIONS_TL T SET (