DBA Data[Home] [Help]

APPS.AMS_LIST_FIELDS_PKG dependencies on AMS_LIST_FIELDS_B_S

Line 178: update AMS_LIST_FIELDS_B set

174: X_LAST_UPDATED_BY in NUMBER,
175: X_LAST_UPDATE_LOGIN in NUMBER
176: ) is
177: begin
178: update AMS_LIST_FIELDS_B set
179: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
180: FIELD_TABLE_NAME = X_FIELD_TABLE_NAME,
181: FIELD_COLUMN_NAME = X_FIELD_COLUMN_NAME,
182: COLUMN_DATA_TYPE = X_COLUMN_DATA_TYPE,

Line 335: SELECT ams_list_fields_b_s.NEXTVAL

331: FROM ams_list_fields_b
332: WHERE list_field_id = x_list_field_id;
333:
334: CURSOR c_get_lfd_id is
335: SELECT ams_list_fields_b_s.NEXTVAL
336: FROM DUAL;
337: BEGIN
338: if X_OWNER = 'SEED' then
339: l_user_id := 1;