APPS.AMS_LIST_RULES_PKG dependencies on AMS_LIST_RULE_FIELDS

Line 368: ------------------ AMS_LIST_RULE_FIELDS -------------------------------

364: end if;
365: END TRANSLATE_ROW;
366:
367:
368: ------------------ AMS_LIST_RULE_FIELDS -------------------------------
369: procedure INSERT_FIELD (
370: X_ROWID in OUT NOCOPY VARCHAR2,
371: X_LIST_RULE_FIELD_ID in NUMBER,
372: X_FIELD_COLUMN_NAME in VARCHAR2,

Line 387: cursor C is select ROWID from AMS_LIST_RULE_FIELDS

383: X_LAST_UPDATE_LOGIN in NUMBER,
384: x_WORD_REPLACEMENT_CODE in VARCHAR2,
385: x_LIST_SOURCE_FIELD_ID in NUMBER
386: ) is
387: cursor C is select ROWID from AMS_LIST_RULE_FIELDS
388: where LIST_RULE_FIELD_ID = X_LIST_RULE_FIELD_ID
389: ;
390: begin
391: insert into AMS_LIST_RULE_FIELDS (

Line 391: insert into AMS_LIST_RULE_FIELDS (

387: cursor C is select ROWID from AMS_LIST_RULE_FIELDS
388: where LIST_RULE_FIELD_ID = X_LIST_RULE_FIELD_ID
389: ;
390: begin
391: insert into AMS_LIST_RULE_FIELDS (
392: FIELD_COLUMN_NAME,
393: OBJECT_VERSION_NUMBER,
394: SUBSTRING_LENGTH,
395: WEIGHTAGE,

Line 453: from AMS_LIST_RULE_FIELDS

449: WEIGHTAGE,
450: SEQUENCE_NUMBER,
451: LIST_RULE_ID,
452: FIELD_TABLE_NAME
453: from AMS_LIST_RULE_FIELDS
454: where LIST_RULE_FIELD_ID = X_LIST_RULE_FIELD_ID
455: for update of LIST_RULE_FIELD_ID nowait;
456: begin
457: for tlinfo in c1 loop

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 519: delete from AMS_LIST_RULE_FIELDS

515: procedure DELETE_FIELD (
516: X_LIST_RULE_FIELD_ID in NUMBER
517: ) is
518: begin
519: delete from AMS_LIST_RULE_FIELDS
520: where LIST_RULE_FIELD_ID = X_LIST_RULE_FIELD_ID;
521:
522: if (sql%notfound) then
523: raise no_data_found;

Line 552: FROM ams_list_rule_fields

548: l_last_updated_by number;
549:
550: CURSOR c_obj_verno IS
551: SELECT object_version_number, last_updated_by
552: FROM ams_list_rule_fields
553: WHERE list_rule_field_id = x_list_rule_field_id;
554:
555: CURSOR c_chk_exists is
556: SELECT 'x'

Line 557: FROM ams_list_rule_fields

553: WHERE list_rule_field_id = x_list_rule_field_id;
554:
555: CURSOR c_chk_exists is
556: SELECT 'x'
557: FROM ams_list_rule_fields
558: WHERE list_rule_field_id = x_list_rule_field_id;
559:
560: CURSOR c_mod_rule is
561: SELECT 'x'

Line 562: FROM ams_list_rule_fields

558: WHERE list_rule_field_id = x_list_rule_field_id;
559:
560: CURSOR c_mod_rule is
561: SELECT 'x'
562: FROM ams_list_rule_fields
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

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