APPS.HZ_CUSTOMER_INT dependencies on HZ_WIN_SOURCE_EXCEPS

Line 2234: DELETE hz_win_source_exceps

2230: END LOOP;
2231:
2232: IF p_ue_ranking = 1 THEN
2233: FORALL i IN 1..total
2234: DELETE hz_win_source_exceps
2235: WHERE party_id = i_party_id(i)
2236: AND entity_attr_id = p_entity_attr_id;
2237: ELSE
2238: FORALL i IN 1..total

Line 2239: UPDATE hz_win_source_exceps exp

2235: WHERE party_id = i_party_id(i)
2236: AND entity_attr_id = p_entity_attr_id;
2237: ELSE
2238: FORALL i IN 1..total
2239: UPDATE hz_win_source_exceps exp
2240: SET content_source_type = 'USER_ENTERED',
2241: exception_type = (
2242: SELECT DECODE(sign(s.ranking-p_ue_ranking), 0, exp.exception_type,
2243: 1, 'Migration', -1, 'Exception')

Line 2258: INSERT INTO hz_win_source_exceps (

2254: WHERE party_id = i_party_id(i)
2255: AND entity_attr_id = p_entity_attr_id;
2256:
2257: FORALL i IN 1..total
2258: INSERT INTO hz_win_source_exceps (
2259: party_id,
2260: entity_attr_id,
2261: content_source_type,
2262: exception_type,

Line 2289: FROM hz_win_source_exceps

2285: SYSDATE
2286: FROM dual
2287: WHERE NOT EXISTS (
2288: SELECT 'Y'
2289: FROM hz_win_source_exceps
2290: WHERE party_id = i_party_id(i)
2291: AND entity_attr_id = p_entity_attr_id );
2292: END IF;
2293: END update_exception_table;