DBA Data[Home] [Help]

APPS.AMS_CUSTOM_SETUPS_PKG dependencies on AMS_CUSTOM_SETUPS_B_S

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 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,