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 335: | Description: This function is used to bump the zx_rates_b_s sequence |

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

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

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

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

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

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

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