DBA Data[Home] [Help]

APPS.AMS_LIST_RULES_PKG dependencies on AMS_LIST_RULE_FIELDS_S

Line 495: update AMS_LIST_RULE_FIELDS set

491: x_WORD_REPLACEMENT_CODE in VARCHAR2,
492: x_LIST_SOURCE_FIELD_ID in NUMBER
493: ) is
494: begin
495: update AMS_LIST_RULE_FIELDS set
496: FIELD_COLUMN_NAME = X_FIELD_COLUMN_NAME,
497: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
498: SUBSTRING_LENGTH = X_SUBSTRING_LENGTH,
499: WEIGHTAGE = X_WEIGHTAGE,

Line 567: SELECT ams_list_rule_fields_s.NEXTVAL

563: WHERE LIST_RULE_ID = X_LIST_RULE_ID
564: AND LAST_UPDATED_BY <> 1 and last_updated_by <> 2 and last_updated_by <> 0;
565:
566: CURSOR c_get_id is
567: SELECT ams_list_rule_fields_s.NEXTVAL
568: FROM DUAL;
569: l_dummy_rule_char varchar2(1);
570: BEGIN
571: if X_OWNER = 'SEED' then