APPS.AMS_LISTDEDUPE_PVT dependencies on AMS_LIST_RULES_ALL

Line 295: ams_list_rules_all.list_rule_id%TYPE)

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

Line 332: l_list_rule_id ams_list_rules_all.list_rule_id%TYPE;

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