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_TEST_API dependencies on ZX_TAX_DIST_ID_GT

Line 2551: | PROCEDURE Insert rows into ZX_TAX_DIST_ID_GT from zx_rec_nrec_dist |

2547: END insert_itm_distributions_gt;
2548:
2549:
2550: /* ========================================================================*
2551: | PROCEDURE Insert rows into ZX_TAX_DIST_ID_GT from zx_rec_nrec_dist |
2552: * ========================================================================*/
2553: PROCEDURE insert_rows_tax_dist_id_gt( p_trx_id IN NUMBER)
2554: IS
2555: BEGIN

Line 2556: INSERT INTO ZX_TAX_DIST_ID_GT

2552: * ========================================================================*/
2553: PROCEDURE insert_rows_tax_dist_id_gt( p_trx_id IN NUMBER)
2554: IS
2555: BEGIN
2556: INSERT INTO ZX_TAX_DIST_ID_GT
2557: (
2558: TAX_DIST_ID
2559: )
2560: SELECT

Line 9308: | Also Pupulates ZX_TAX_DIST_ID_GT |

9304: | The Structures are: |
9305: | STRUCTURE_TAX_LINE_KEY |
9306: | STRUCTURE_ITEM_DISTRIBUTION_KEY |
9307: | STRUCTURE_TRANSACTION_LINE_KEY |
9308: | Also Pupulates ZX_TAX_DIST_ID_GT |
9309: * =========================================================================*/
9310: PROCEDURE insert_tax_dist_id_gt
9311: (
9312: p_suite IN VARCHAR2,

Line 9340: -- Inserts into ZX_TAX_DIST_ID_GT

9336: x_end_row => l_end_row
9337: );
9338:
9339: -----------------------------------
9340: -- Inserts into ZX_TAX_DIST_ID_GT
9341: -----------------------------------
9342: FOR i in l_start_row..l_end_row LOOP
9343: INSERT INTO ZX_TAX_DIST_ID_GT
9344: (

Line 9343: INSERT INTO ZX_TAX_DIST_ID_GT

9339: -----------------------------------
9340: -- Inserts into ZX_TAX_DIST_ID_GT
9341: -----------------------------------
9342: FOR i in l_start_row..l_end_row LOOP
9343: INSERT INTO ZX_TAX_DIST_ID_GT
9344: (
9345: TAX_DIST_ID
9346: )
9347: (SELECT

Line 9362: write_message('An error has ocurred while populating ZX_TAX_DIST_ID_GT for Structure Trx Line Key');

9358:
9359: EXCEPTION
9360: --Code the Appropiate Exception Here
9361: WHEN OTHERS THEN
9362: write_message('An error has ocurred while populating ZX_TAX_DIST_ID_GT for Structure Trx Line Key');
9363: END;
9364:
9365:
9366: ELSIF p_structure = 'STRUCTURE_ITEM_DISTRIBUTION_KEY' THEN

Line 9381: -- Inserts into ZX_TAX_DIST_ID_GT

9377: );
9378:
9379: BEGIN
9380: -----------------------------------
9381: -- Inserts into ZX_TAX_DIST_ID_GT
9382: -----------------------------------
9383: FOR i in l_start_row..l_end_row LOOP
9384: INSERT INTO ZX_TAX_DIST_ID_GT
9385: (

Line 9384: INSERT INTO ZX_TAX_DIST_ID_GT

9380: -----------------------------------
9381: -- Inserts into ZX_TAX_DIST_ID_GT
9382: -----------------------------------
9383: FOR i in l_start_row..l_end_row LOOP
9384: INSERT INTO ZX_TAX_DIST_ID_GT
9385: (
9386: TAX_DIST_ID
9387: )
9388: (SELECT rec_nrec_tax_dist_id

Line 9401: write_message('An error has ocurred while populating ZX_TAX_DIST_ID_GT for Structure Item Dist Key');

9397: END LOOP;
9398: EXCEPTION
9399: --Code the Appropiate Exception Here, by now only messages.
9400: WHEN OTHERS THEN
9401: write_message('An error has ocurred while populating ZX_TAX_DIST_ID_GT for Structure Item Dist Key');
9402: END;
9403:
9404: ELSIF p_structure = 'STRUCTURE_TAX_LINE_KEY' THEN
9405: BEGIN

Line 9418: -- Inserts into ZX_TAX_DIST_ID_GT

9414: x_start_row => l_start_row,
9415: x_end_row => l_end_row
9416: );
9417: -----------------------------------
9418: -- Inserts into ZX_TAX_DIST_ID_GT
9419: -----------------------------------
9420: FOR i in l_start_row..l_end_row LOOP
9421: INSERT INTO ZX_TAX_DIST_ID_GT
9422: (

Line 9421: INSERT INTO ZX_TAX_DIST_ID_GT

9417: -----------------------------------
9418: -- Inserts into ZX_TAX_DIST_ID_GT
9419: -----------------------------------
9420: FOR i in l_start_row..l_end_row LOOP
9421: INSERT INTO ZX_TAX_DIST_ID_GT
9422: (
9423: TAX_DIST_ID
9424: )
9425: (SELECT

Line 9443: write_message('An error has ocurred populating ZX_TAX_DIST_ID_GT for Structure Tax Line Key');

9439: END LOOP;
9440: EXCEPTION
9441: --Code the Appropiate Exception Here, by now only messages.
9442: WHEN OTHERS THEN
9443: write_message('An error has ocurred populating ZX_TAX_DIST_ID_GT for Structure Tax Line Key');
9444: END;
9445: ELSIF p_structure = 'STRUCTURE_ITEM_DISTRIBUTIONS' THEN
9446:
9447: ---------------------------------------------------------------

Line 9471: -- Inserts into ZX_TAX_DIST_ID_GT

9467: x_start_row => l_start_row,
9468: x_end_row => l_end_row
9469: );
9470: -----------------------------------
9471: -- Inserts into ZX_TAX_DIST_ID_GT
9472: -----------------------------------
9473: --write_message(to_char(l_start_row)||','||to_char(l_end_row));
9474: FOR i in l_start_row..l_end_row LOOP
9475: --write_message('i:'||to_number(i));

Line 9477: INSERT INTO ZX_TAX_DIST_ID_GT

9473: --write_message(to_char(l_start_row)||','||to_char(l_end_row));
9474: FOR i in l_start_row..l_end_row LOOP
9475: --write_message('i:'||to_number(i));
9476: --write_message('tax_dist_id:'||g_suite_rec_tbl.tax_dist_id(i));
9477: INSERT INTO ZX_TAX_DIST_ID_GT
9478: (
9479: TAX_DIST_ID
9480: )
9481: VALUES