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.4.12020000.3 2013/02/01 06:47:33 bchaturv ship $ */
3: -- Start of Comments
4: --
5: -- NAME

Line 6: -- AMS_ListDedupe_PVT

2: /* $Header: amsvlddb.pls 120.4.12020000.3 2013/02/01 06:47:33 bchaturv ship $ */
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 44: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_ListDedupe_PVT';

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

Line 476: 'AMS_ListDedupe_PVT.replace_word(' ||

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

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

677: -- PROCEDURE
678: -- Generate_Key
679: -- HISTORY
680: -- 10-Nov-1999 choang Created.
681: -- 11-Nov-1999 choang Moved to AMS_ListDedupe_PVT.
682: --------------------------------------------------------------------
683: PROCEDURE Generate_Key (
684: p_api_version IN NUMBER,
685: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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

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

Line 787: 'AMS_ListDedupe_PVT.filter_word (' ||

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

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

831:
832: /***
833: IF p_word_replacement_flag = 'Y' THEN
834: l_select_sql := l_select_sql ||
835: 'AMS_ListDedupe_PVT.filter_word (' || l_field_column_name || ', '
836: || l_substring_length || ', '
837: || l_field_table_name || ', '
838: || '''' || l_field_column_name || '''),'
839: ELSE

Line 1033: END AMS_ListDedupe_PVT;

1029: RETURN l_key;
1030: END Replace_Word;
1031:
1032:
1033: END AMS_ListDedupe_PVT;