APPS.AMS_LISTDEDUPE_PVT dependencies on AMS_LIST_HEADERS_ALL

Line 266: -- p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE

262: --
263: -- Pre-reqs : None
264: -- Paramaeters :
265: -- IN :
266: -- p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE
267: -- p_enabled_wordreplacement_flag AMS_LIST_HEADERS_ALL.ENABLED_WORDREPLACEMENT_FLAG%TYPE
268: -- p_send_to_log VARCHAR2 := 'N'
269: -- p_object_name VARCHAR2 := 'AMS_LIST_ENTRIES'
270: --

Line 267: -- p_enabled_wordreplacement_flag AMS_LIST_HEADERS_ALL.ENABLED_WORDREPLACEMENT_FLAG%TYPE

263: -- Pre-reqs : None
264: -- Paramaeters :
265: -- IN :
266: -- p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE
267: -- p_enabled_wordreplacement_flag AMS_LIST_HEADERS_ALL.ENABLED_WORDREPLACEMENT_FLAG%TYPE
268: -- p_send_to_log VARCHAR2 := 'N'
269: -- p_object_name VARCHAR2 := 'AMS_LIST_ENTRIES'
270: --
271: -- HISTORY

Line 278: (p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE

274: -- from AMS_IMP_SOURCE_LINE table
275: -- End Of Comments
276:
277: FUNCTION Dedupe_List
278: (p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE
279: ,p_enable_word_replacement_flag
280: AMS_LIST_HEADERS_ALL.ENABLE_WORD_REPLACEMENT_FLAG%TYPE
281: ,p_send_to_log VARCHAR2 := 'N'
282: ,p_object_name VARCHAR2 := 'AMS_LIST_ENTRIES'

Line 280: AMS_LIST_HEADERS_ALL.ENABLE_WORD_REPLACEMENT_FLAG%TYPE

276:
277: FUNCTION Dedupe_List
278: (p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE
279: ,p_enable_word_replacement_flag
280: AMS_LIST_HEADERS_ALL.ENABLE_WORD_REPLACEMENT_FLAG%TYPE
281: ,p_send_to_log VARCHAR2 := 'N'
282: ,p_object_name VARCHAR2 := 'AMS_LIST_ENTRIES'
283: )
284: RETURN NUMBER IS

Line 308: FROM ams_list_headers_all

304: -- perform a check to see if this list has been deduped already.
305: CURSOR c_deduped_before (my_list_header_id IN NUMBER)
306: IS
307: SELECT last_deduped_by_user_id
308: FROM ams_list_headers_all
309: WHERE list_header_id = my_list_header_id;
310:
311: -- get a distinct list of merge keys for the list and a
312: -- count of the occurance of each key

Line 334: l_last_dedupe_by ams_list_headers_all.last_deduped_by_user_id%TYPE;

330: --l_temp_fields VARCHAR2(10000);
331: l_no_of_masters NUMBER := 0;
332: l_list_rule_id ams_list_rules_all.list_rule_id%TYPE;
333: --l_list_entry_id ams_list_entries.list_entry_id%TYPE;
334: l_last_dedupe_by ams_list_headers_all.last_deduped_by_user_id%TYPE;
335: l_dedupe_key ams_list_entries.dedupe_key%TYPE;
336: l_dedupe_key_count NUMBER;
337: l_rank_count NUMBER;
338: i BINARY_INTEGER := 1;

Line 638: UPDATE ams_list_headers_all

634: TO_CHAR (SYSDATE, 'DD-MON-RRRR HH24:MM:SS') );
635: END IF;*/
636:
637: --recording who performed the deduplication and at what time.
638: UPDATE ams_list_headers_all
639: SET last_deduped_by_user_id = FND_GLOBAL.User_Id
640: ,last_dedupe_date = SYSDATE
641: WHERE list_header_id = p_list_header_id;
642:

Line 651: UPDATE ams_list_headers_all

647: TO_CHAR (SYSDATE, 'DD-MON-RRRR HH24:MM:SS') );
648: END IF;*/
649:
650: --recording the number of duplicates found.
651: UPDATE ams_list_headers_all
652: SET no_of_rows_duplicates = (
653: SELECT COUNT (*)
654: FROM ams_list_entries
655: WHERE list_header_id = p_list_header_id