APPS.AMS_LISTDEDUPE_PVT dependencies on AMS_LIST_HEADERS_ALL

Line 267: -- p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE

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

Line 268: -- p_enabled_wordreplacement_flag AMS_LIST_HEADERS_ALL.ENABLED_WORDREPLACEMENT_FLAG%TYPE

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

Line 279: (p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE

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

Line 281: AMS_LIST_HEADERS_ALL.ENABLE_WORD_REPLACEMENT_FLAG%TYPE

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

Line 309: FROM ams_list_headers_all

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

Line 335: l_last_dedupe_by ams_list_headers_all.last_deduped_by_user_id%TYPE;

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

Line 642: UPDATE ams_list_headers_all

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

Line 655: UPDATE ams_list_headers_all

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