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 3032: CURSOR c_delete IS SELECT 1 FROM HZ_WORD_REPLACEMENTS

3028: END new_primary_trans;
3029:
3030: PROCEDURE update_word_replacements
3031: IS
3032: CURSOR c_delete IS SELECT 1 FROM HZ_WORD_REPLACEMENTS
3033: WHERE DELETE_FLAG ='Y'
3034: AND ROWNUM =1;
3035: CURSOR c_staged IS SELECT 1 FROM HZ_WORD_REPLACEMENTS
3036: WHERE STAGED_FLAG ='N'

Line 3035: CURSOR c_staged IS SELECT 1 FROM HZ_WORD_REPLACEMENTS

3031: IS
3032: CURSOR c_delete IS SELECT 1 FROM HZ_WORD_REPLACEMENTS
3033: WHERE DELETE_FLAG ='Y'
3034: AND ROWNUM =1;
3035: CURSOR c_staged IS SELECT 1 FROM HZ_WORD_REPLACEMENTS
3036: WHERE STAGED_FLAG ='N'
3037: AND ROWNUM =1;
3038: l_val NUMBER;
3039: BEGIN

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

3043: CLOSE c_delete;
3044: -- Delete the records marked for delete.
3045: IF(l_val > 0)THEN
3046: log('Deleting word replacements that are marked for delete..');
3047: DELETE FROM HZ_WORD_REPLACEMENTS WHERE DELETE_FLAG = 'Y';
3048: log('Done deleting word replacements.');
3049: END IF;
3050: l_val := 0;
3051: OPEN c_staged;

Line 3057: UPDATE HZ_WORD_REPLACEMENTS SET STAGED_FLAG = 'Y'

3053: CLOSE c_staged;
3054: -- Update the staged flag to 'Y'
3055: IF(l_val > 0)THEN
3056: log('Updating the staged_flag of word replacements to Y ..');
3057: UPDATE HZ_WORD_REPLACEMENTS SET STAGED_FLAG = 'Y'
3058: WHERE STAGED_FLAG = 'N';
3059: log('Done updating staged_flag of word replacements.');
3060: END IF;
3061: END update_word_replacements;