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.ZX_MIGRATE_UTIL dependencies on ZX_RATES_B

Line 337: | Description: This function is used to bump the zx_rates_b_s sequence |

333: end get_next_seqid;
334:
335: /*===========================================================================+
336: | Procedure : ZX_ALTER_RATES_SEQUENCE |
337: | Description: This function is used to bump the zx_rates_b_s sequence |
338: | |
339: | ARGUMENTS : None |
340: | |
341: | |

Line 356: SELECT count(tax_rate_id) into l_rates_count from zx_rates_b where record_type_code = 'MIGRATED';

352: l_rates_count NUMBER;
353:
354: BEGIN
355:
356: SELECT count(tax_rate_id) into l_rates_count from zx_rates_b where record_type_code = 'MIGRATED';
357:
358: IF l_rates_count = 0
359: THEN
360:

Line 368: EXECUTE IMMEDIATE 'DROP SEQUENCE ZX.ZX_RATES_B_S';

364: INTO l_new_seq_id
365: FROM DUAL;
366:
367:
368: EXECUTE IMMEDIATE 'DROP SEQUENCE ZX.ZX_RATES_B_S';
369: EXECUTE IMMEDIATE 'CREATE SEQUENCE ZX.ZX_RATES_B_S START WITH '||l_new_seq_id;
370:
371: END IF;
372:

Line 369: EXECUTE IMMEDIATE 'CREATE SEQUENCE ZX.ZX_RATES_B_S START WITH '||l_new_seq_id;

365: FROM DUAL;
366:
367:
368: EXECUTE IMMEDIATE 'DROP SEQUENCE ZX.ZX_RATES_B_S';
369: EXECUTE IMMEDIATE 'CREATE SEQUENCE ZX.ZX_RATES_B_S START WITH '||l_new_seq_id;
370:
371: END IF;
372:
373: