APPS.AMS_CUSTOM_SETUPS_PKG dependencies on AMS_CUSTOM_SETUPS_B

Line 24: cursor C is select ROWID from AMS_CUSTOM_SETUPS_B

20: X_ALLOW_ESSENTIAL_GROUPING in VARCHAR2,
21: X_USAGE in VARCHAR2,
22: X_MIGRATED_CUSTOM_SETUP_ID in NUMBER
23: ) is
24: cursor C is select ROWID from AMS_CUSTOM_SETUPS_B
25: where CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID
26: ;
27: begin
28: insert into AMS_CUSTOM_SETUPS_B (

Line 28: insert into AMS_CUSTOM_SETUPS_B (

24: cursor C is select ROWID from AMS_CUSTOM_SETUPS_B
25: where CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID
26: ;
27: begin
28: insert into AMS_CUSTOM_SETUPS_B (
29: CUSTOM_SETUP_ID,
30: OBJECT_VERSION_NUMBER,
31: ACTIVITY_TYPE_CODE,
32: MEDIA_ID,

Line 126: from AMS_CUSTOM_SETUPS_B

122: OBJECT_TYPE,
123: ALLOW_ESSENTIAL_GROUPING,
124: USAGE,
125: MIGRATED_CUSTOM_SETUP_ID
126: from AMS_CUSTOM_SETUPS_B
127: where CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID
128: for update of CUSTOM_SETUP_ID nowait;
129: recinfo c%rowtype;
130:

Line 201: update AMS_CUSTOM_SETUPS_B set

197: X_USAGE in VARCHAR2,
198: X_MIGRATED_CUSTOM_SETUP_ID in NUMBER
199: ) is
200: begin
201: update AMS_CUSTOM_SETUPS_B set
202: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
203: ACTIVITY_TYPE_CODE = X_ACTIVITY_TYPE_CODE,
204: MEDIA_ID = X_MEDIA_ID,
205: ENABLED_FLAG = X_ENABLED_FLAG,

Line 247: delete from AMS_CUSTOM_SETUPS_B

243: if (sql%notfound) then
244: raise no_data_found;
245: end if;
246:
247: delete from AMS_CUSTOM_SETUPS_B
248: where CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID;
249:
250: if (sql%notfound) then
251: raise no_data_found;

Line 261: from AMS_CUSTOM_SETUPS_B B

257: begin
258: delete from AMS_CUSTOM_SETUPS_TL T
259: where not exists
260: (select NULL
261: from AMS_CUSTOM_SETUPS_B B
262: where B.CUSTOM_SETUP_ID = T.CUSTOM_SETUP_ID
263: );
264:
265: update AMS_CUSTOM_SETUPS_TL T set (

Line 385: from ams_custom_setups_b

381: l_db_luby_id NUMBER;
382:
383: cursor c_db_data_details is
384: select last_updated_by, nvl(object_version_number,1)
385: from ams_custom_setups_b
386: where CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID;
387:
388: cursor c_chk_cus_exists is
389: select 1

Line 390: from ams_custom_setups_b

386: where CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID;
387:
388: cursor c_chk_cus_exists is
389: select 1
390: from ams_custom_setups_b
391: where CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID;
392:
393: cursor c_get_cusid is
394: select ams_custom_setups_b_S.nextval

Line 394: select ams_custom_setups_b_S.nextval

390: from ams_custom_setups_b
391: where CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID;
392:
393: cursor c_get_cusid is
394: select ams_custom_setups_b_S.nextval
395: from dual;
396:
397: BEGIN
398:

Line 476: update AMS_CUSTOM_SETUPS_B set

472: );
473: --Commented OUT NOCOPY as this will not be ever needed as per nrengasw, and bgeorge.
474: /*
475: else
476: update AMS_CUSTOM_SETUPS_B set
477: OBJECT_VERSION_NUMBER = l_obj_verno + 1,
478: OBJECT_TYPE = X_OBJECT_TYPE,
479: ACTIVITY_TYPE_CODE = X_ACTIVITY_TYPE_CODE,
480: SOURCE_CODE_SUFFIX = X_SOURCE_CODE_SUFFIX,