APPS.AMS_LISTDEDUPE_PVT dependencies on AMS_LIST_RULES_ALL

Line 296: ams_list_rules_all.list_rule_id%TYPE)

292:
293: -- the list of fields for the list rule which are used to generate the key.
294: CURSOR c_rule_fields
295: (my_list_rule_id IN
296: ams_list_rules_all.list_rule_id%TYPE)
297: IS
298: SELECT field_table_name,
299: field_column_name,
300: substring_length,

Line 333: l_list_rule_id ams_list_rules_all.list_rule_id%TYPE;

329: --l_sqlcode VARCHAR2(1000);
330: l_fields VARCHAR2(10000);
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;