DBA Data[Home] [Help]

APPS.AMS_SETUP_TYPES_PKG dependencies on AMS_SETUP_TYPES_S

Line 121: update AMS_SETUP_TYPES set

117: X_LAST_UPDATED_BY in NUMBER,
118: X_LAST_UPDATE_LOGIN in NUMBER
119: ) is
120: begin
121: update AMS_SETUP_TYPES set
122: DISPLAY_SEQUENCE_NO = X_DISPLAY_SEQUENCE_NO,
123: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
124: OBJECT_TYPE = X_OBJECT_TYPE,
125: ACTIVITY_TYPE_CODE = X_ACTIVITY_TYPE_CODE,

Line 204: select AMS_SETUP_TYPES_S.nextval

200: from AMS_SETUP_TYPES
201: where setup_type_id = X_SETUP_TYPE_ID;
202:
203: cursor c_get_setid is
204: select AMS_SETUP_TYPES_S.nextval
205: from dual;
206: BEGIN
207:
208: if X_OWNER = 'SEED' then