APPS.AMS_LISTDEDUPE_PVT dependencies on AMS_LISTDEDUPE_PVT

Line 1: PACKAGE BODY AMS_ListDedupe_PVT as

1: PACKAGE BODY AMS_ListDedupe_PVT as
2: /* $Header: amsvlddb.pls 120.2 2005/12/28 09:32:21 bmuthukr noship $ */
3: -- Start of Comments
4: --
5: -- NAME

Line 6: -- AMS_ListDedupe_PVT

2: /* $Header: amsvlddb.pls 120.2 2005/12/28 09:32:21 bmuthukr noship $ */
3: -- Start of Comments
4: --
5: -- NAME
6: -- AMS_ListDedupe_PVT
7: --
8: -- PURPOSE
9: -- This package is a Private API for managing List Deduplication information in
10: -- AMS. It contains specification for pl/sql records and tables

Line 43: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_ListDedupe_PVT';

39: --
40: -- End of Comments
41:
42: -- global constants
43: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_ListDedupe_PVT';
44: g_original_text VARCHAR2(50) := 'z!"#$%&''()*+,-./:;<=>?@[\]^_`{|}~';
45: g_replace_text VARCHAR2(50) := 'z';
46:
47: TYPE original_key IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;

Line 475: 'AMS_ListDedupe_PVT.replace_word(' ||

471: IF (p_enable_word_replacement_flag = 'Y') THEN
472: Write_To_Act_Log (p_list_header_id, 'Calling replace word procedure','LOW' );
473: l_fields :=
474: l_fields ||
475: 'AMS_ListDedupe_PVT.replace_word(' ||
476: upper(list_rules (i).field_column_name) ||
477: ',' ||
478: '''' ||
479: list_rules (i).word_replacement_code||

Line 677: -- 11-Nov-1999 choang Moved to AMS_ListDedupe_PVT.

673: -- PROCEDURE
674: -- Generate_Key
675: -- HISTORY
676: -- 10-Nov-1999 choang Created.
677: -- 11-Nov-1999 choang Moved to AMS_ListDedupe_PVT.
678: --------------------------------------------------------------------
679: PROCEDURE Generate_Key (
680: p_api_version IN NUMBER,
681: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 778: -- SELECT AMS_ListDedupe_PVT.filter_word ( the_word, the_length, the_table, the_column )

774: -- to call the filter word function.
775: IF (p_word_replacement_flag = 'Y') THEN
776: --
777: -- Construct select SQL clause in the format:
778: -- SELECT AMS_ListDedupe_PVT.filter_word ( the_word, the_length, the_table, the_column )
779: -- The final result of the query will look like: A.B.C.D
780: --
781: l_select_sql :=
782: l_select_sql ||

Line 783: 'AMS_ListDedupe_PVT.filter_word (' ||

779: -- The final result of the query will look like: A.B.C.D
780: --
781: l_select_sql :=
782: l_select_sql ||
783: 'AMS_ListDedupe_PVT.filter_word (' ||
784: l_field_column_name ||
785: ',' ||
786: NVL (TO_CHAR (l_substring_length), 'NULL') ||
787: ',' ||

Line 831: 'AMS_ListDedupe_PVT.filter_word (' || l_field_column_name || ', '

827:
828: /***
829: IF p_word_replacement_flag = 'Y' THEN
830: l_select_sql := l_select_sql ||
831: 'AMS_ListDedupe_PVT.filter_word (' || l_field_column_name || ', '
832: || l_substring_length || ', '
833: || l_field_table_name || ', '
834: || '''' || l_field_column_name || '''),'
835: ELSE

Line 1028: END AMS_ListDedupe_PVT;

1024: RETURN l_key;
1025: END Replace_Word;
1026:
1027:
1028: END AMS_ListDedupe_PVT;