DBA Data[Home] [Help]

APPS.AMS_LISTDEDUPE_PVT dependencies on AMS_LIST_RULE_FIELDS

Line 45: -- p_table_name AMS_LIST_RULE_FIELDS.TABLE_NAME%TYPE

41: -- Paramaeters :
42: -- IN :
43: -- p_word VARCHAR2
44: -- p_substr_len AMS_LIST_RULE_ENTRIES.SUBSTRING_LEN%TYPE
45: -- p_table_name AMS_LIST_RULE_FIELDS.TABLE_NAME%TYPE
46: -- p_column_name AMS_LIST_RULE_FIELDS.COLUMN_NAME%TYPE
47: --
48: -- NOTES
49: --

Line 46: -- p_column_name AMS_LIST_RULE_FIELDS.COLUMN_NAME%TYPE

42: -- IN :
43: -- p_word VARCHAR2
44: -- p_substr_len AMS_LIST_RULE_ENTRIES.SUBSTRING_LEN%TYPE
45: -- p_table_name AMS_LIST_RULE_FIELDS.TABLE_NAME%TYPE
46: -- p_column_name AMS_LIST_RULE_FIELDS.COLUMN_NAME%TYPE
47: --
48: -- NOTES
49: --
50: --

Line 59: ,p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LENGTH%TYPE

55:
56:
57: FUNCTION Filter_Word
58: (p_word VARCHAR2
59: ,p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LENGTH%TYPE
60: ,p_field_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE
61: ,p_field_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE
62: )
63: RETURN VARCHAR2;

Line 60: ,p_field_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE

56:
57: FUNCTION Filter_Word
58: (p_word VARCHAR2
59: ,p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LENGTH%TYPE
60: ,p_field_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE
61: ,p_field_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE
62: )
63: RETURN VARCHAR2;
64:

Line 61: ,p_field_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE

57: FUNCTION Filter_Word
58: (p_word VARCHAR2
59: ,p_substr_len AMS_LIST_RULE_FIELDS.SUBSTRING_LENGTH%TYPE
60: ,p_field_table_name AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME%TYPE
61: ,p_field_column_name AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME%TYPE
62: )
63: RETURN VARCHAR2;
64:
65: /*****************************************************************************************/