eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_STAGE dependencies on HZ_WORD_REPLACEMENTS

Line 2916: CURSOR c_delete IS SELECT 1 FROM HZ_WORD_REPLACEMENTS

2912: END new_primary_trans;
2913:
2914: PROCEDURE update_word_replacements
2915: IS
2916: CURSOR c_delete IS SELECT 1 FROM HZ_WORD_REPLACEMENTS
2917: WHERE DELETE_FLAG ='Y'
2918: AND ROWNUM =1;
2919: CURSOR c_staged IS SELECT 1 FROM HZ_WORD_REPLACEMENTS
2920: WHERE STAGED_FLAG ='N'

Line 2919: CURSOR c_staged IS SELECT 1 FROM HZ_WORD_REPLACEMENTS

2915: IS
2916: CURSOR c_delete IS SELECT 1 FROM HZ_WORD_REPLACEMENTS
2917: WHERE DELETE_FLAG ='Y'
2918: AND ROWNUM =1;
2919: CURSOR c_staged IS SELECT 1 FROM HZ_WORD_REPLACEMENTS
2920: WHERE STAGED_FLAG ='N'
2921: AND ROWNUM =1;
2922: l_val NUMBER;
2923: BEGIN

Line 2931: DELETE FROM HZ_WORD_REPLACEMENTS WHERE DELETE_FLAG = 'Y';

2927: CLOSE c_delete;
2928: -- Delete the records marked for delete.
2929: IF(l_val > 0)THEN
2930: log('Deleting word replacements that are marked for delete..');
2931: DELETE FROM HZ_WORD_REPLACEMENTS WHERE DELETE_FLAG = 'Y';
2932: log('Done deleting word replacements.');
2933: END IF;
2934: l_val := 0;
2935: OPEN c_staged;

Line 2941: UPDATE HZ_WORD_REPLACEMENTS SET STAGED_FLAG = 'Y'

2937: CLOSE c_staged;
2938: -- Update the staged flag to 'Y'
2939: IF(l_val > 0)THEN
2940: log('Updating the staged_flag of word replacements to Y ..');
2941: UPDATE HZ_WORD_REPLACEMENTS SET STAGED_FLAG = 'Y'
2942: WHERE STAGED_FLAG = 'N';
2943: log('Done updating staged_flag of word replacements.');
2944: END IF;
2945: END update_word_replacements;