APPS.IEC_DNC_PVT dependencies on HZ_CONTACT_PREFERENCES

Line 17: l_contact_restriction_type HZ_CONTACT_PREFERENCES.CONTACT_LEVEL_TABLE%TYPE;

13:
14: work_cursor FETCH_CURSOR;
15:
16: l_rlse_stmt VARCHAR2(4000);
17: l_contact_restriction_type HZ_CONTACT_PREFERENCES.CONTACT_LEVEL_TABLE%TYPE;
18: l_counter NUMBER := 0;
19: l_dont_use NUMBER := 0;
20: l_record_id NUMBER := 0;
21:

Line 29: l_rlse_stmt := 'select /*+ index ( HZ_CONTACT_PREFERENCES, HZ_CONTACT_PREFERENCES_N1 ) */ /*+ index ( AMS_LIST_ENTRIES, AMS_LIST_ENTRIES_N6 ) */ b.contact_level_table '

25:
26: -- Build the sql statement.
27: X_CALLABLE_FLAG := 'Y';
28:
29: l_rlse_stmt := 'select /*+ index ( HZ_CONTACT_PREFERENCES, HZ_CONTACT_PREFERENCES_N1 ) */ /*+ index ( AMS_LIST_ENTRIES, AMS_LIST_ENTRIES_N6 ) */ b.contact_level_table '
30: || ' from ams_list_entries a, hz_contact_preferences b, iec_g_return_entries c '
31: || ' where c.returns_id = :returnId '
32: || ' and c.list_entry_id = a.list_entry_id '
33: || ' and c.list_header_id = a.list_header_id '

Line 30: || ' from ams_list_entries a, hz_contact_preferences b, iec_g_return_entries c '

26: -- Build the sql statement.
27: X_CALLABLE_FLAG := 'Y';
28:
29: l_rlse_stmt := 'select /*+ index ( HZ_CONTACT_PREFERENCES, HZ_CONTACT_PREFERENCES_N1 ) */ /*+ index ( AMS_LIST_ENTRIES, AMS_LIST_ENTRIES_N6 ) */ b.contact_level_table '
30: || ' from ams_list_entries a, hz_contact_preferences b, iec_g_return_entries c '
31: || ' where c.returns_id = :returnId '
32: || ' and c.list_entry_id = a.list_entry_id '
33: || ' and c.list_header_id = a.list_header_id '
34: || ' and nvl( b.preference_code, ''DO'') = ''DO_NOT'' '

Line 75: -- dbms_output.put_line( 'IEC_DNC_PVT:IS_CALLABLE: No data found.. All are callable per HZ_CONTACT_PREFERENCES..' );

71: END IF;
72:
73: Exception
74: WHEN NO_DATA_FOUND THEN
75: -- dbms_output.put_line( 'IEC_DNC_PVT:IS_CALLABLE: No data found.. All are callable per HZ_CONTACT_PREFERENCES..' );
76: null;
77: End;
78:
79: return;