APPS.AMS_LISTDEDUPE_PVT dependencies on AMS_LIST_RULE_FIELDS

Line 197: -- p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LEN%TYPE

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

Line 198: -- p_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE

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

Line 199: -- p_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE

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

Line 205: ,p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LENGTH%TYPE

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

Line 206: ,p_field_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE

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

Line 207: ,p_field_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE

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

Line 302: FROM ams_list_rule_fields

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

Line 733: FROM ams_list_rule_fields

729: CURSOR c_fields IS
730: SELECT field_table_name,
731: field_column_name,
732: substring_length
733: FROM ams_list_rule_fields
734: WHERE list_rule_id = p_list_rule_id;
735: BEGIN
736: --------------------- initialize -----------------------
737: IF (AMS_DEBUG_HIGH_ON) THEN