APPS.AMS_LISTDEDUPE_PVT dependencies on AMS_LIST_RULE_FIELDS

Line 196: -- p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LEN%TYPE

192: -- Pre-reqs : None
193: -- Paramaeters :
194: -- IN :
195: -- p_word VARCHAR2
196: -- p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LEN%TYPE
197: -- p_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE
198: -- p_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE
199: --
200: -- End Of Comments

Line 197: -- p_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE

193: -- Paramaeters :
194: -- IN :
195: -- p_word VARCHAR2
196: -- p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LEN%TYPE
197: -- p_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE
198: -- p_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE
199: --
200: -- End Of Comments
201:

Line 198: -- p_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE

194: -- IN :
195: -- p_word VARCHAR2
196: -- p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LEN%TYPE
197: -- p_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE
198: -- p_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE
199: --
200: -- End Of Comments
201:
202: FUNCTION Filter_Word

Line 204: ,p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LENGTH%TYPE

200: -- End Of Comments
201:
202: FUNCTION Filter_Word
203: (p_word VARCHAR2
204: ,p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LENGTH%TYPE
205: ,p_field_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE
206: ,p_field_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE
207: )
208: RETURN VARCHAR2

Line 205: ,p_field_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE

201:
202: FUNCTION Filter_Word
203: (p_word VARCHAR2
204: ,p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LENGTH%TYPE
205: ,p_field_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE
206: ,p_field_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE
207: )
208: RETURN VARCHAR2
209:

Line 206: ,p_field_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE

202: FUNCTION Filter_Word
203: (p_word VARCHAR2
204: ,p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LENGTH%TYPE
205: ,p_field_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE
206: ,p_field_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE
207: )
208: RETURN VARCHAR2
209:
210: IS

Line 301: FROM ams_list_rule_fields

297: SELECT field_table_name,
298: field_column_name,
299: substring_length,
300: word_replacement_code
301: FROM ams_list_rule_fields
302: WHERE list_rule_id = my_list_rule_id;
303:
304: -- perform a check to see if this list has been deduped already.
305: CURSOR c_deduped_before (my_list_header_id IN NUMBER)

Line 729: FROM ams_list_rule_fields

725: CURSOR c_fields IS
726: SELECT field_table_name,
727: field_column_name,
728: substring_length
729: FROM ams_list_rule_fields
730: WHERE list_rule_id = p_list_rule_id;
731: BEGIN
732: --------------------- initialize -----------------------
733: IF (AMS_DEBUG_HIGH_ON) THEN