APPS.HZ_WORD_ARRAY_PKG dependencies on HZ_TRANS_PKG

Line 34: AND ((HZ_TRANS_PKG.staging_context = 'Y' AND DELETE_FLAG = 'N')

30: FOR indx IN (
31: SELECT original_word, replacement_word
32: FROM HZ_WORD_REPLACEMENTS
33: WHERE word_list_id = wl_id and nvl(condition_id, 0) = 0
34: AND ((HZ_TRANS_PKG.staging_context = 'Y' AND DELETE_FLAG = 'N')
35: OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')
36: )
37: )
38: LOOP

Line 35: OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')

31: SELECT original_word, replacement_word
32: FROM HZ_WORD_REPLACEMENTS
33: WHERE word_list_id = wl_id and nvl(condition_id, 0) = 0
34: AND ((HZ_TRANS_PKG.staging_context = 'Y' AND DELETE_FLAG = 'N')
35: OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')
36: )
37: )
38: LOOP
39: word_list_global_rep_lookup(wl_id)(indx.original_word) := indx.replacement_word ;

Line 50: AND ((HZ_TRANS_PKG.staging_context = 'Y' AND DELETE_FLAG = 'N')

46: FOR indx IN (
47: SELECT distinct original_word
48: FROM HZ_WORD_REPLACEMENTS
49: WHERE word_list_id = wl_id and condition_id > 0
50: AND ((HZ_TRANS_PKG.staging_context = 'Y' AND DELETE_FLAG = 'N')
51: OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')
52: )
53: order by original_word )
54: LOOP

Line 51: OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')

47: SELECT distinct original_word
48: FROM HZ_WORD_REPLACEMENTS
49: WHERE word_list_id = wl_id and condition_id > 0
50: AND ((HZ_TRANS_PKG.staging_context = 'Y' AND DELETE_FLAG = 'N')
51: OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')
52: )
53: order by original_word )
54: LOOP
55: word_list_global_rep_lookup(wl_id)(indx.original_word) := '-1' ;