APPS.ZX_TEST_API dependencies on ZX_TRX_HEADERS_GT

Line 1646: | PROCEDURE insert_data_trx_headers_gt : Inserts a row in zx_trx_headers_gt|

1642: END put_data_in_party_rec;
1643:
1644:
1645: /* ================================================================================*
1646: | PROCEDURE insert_data_trx_headers_gt : Inserts a row in zx_trx_headers_gt|
1647: * ================================================================================*/
1648:
1649: PROCEDURE insert_data_trx_headers_gt(p_row_id IN NUMBER)
1650: IS

Line 1652: write_message('Inserting into zx_trx_headers_gt rec_tbl_row:'||to_char(p_row_id));

1648:
1649: PROCEDURE insert_data_trx_headers_gt(p_row_id IN NUMBER)
1650: IS
1651: BEGIN
1652: write_message('Inserting into zx_trx_headers_gt rec_tbl_row:'||to_char(p_row_id));
1653: ----------------------------------------------
1654: -- INSERT INTO TABLE zx_trx_headers_gt
1655: ----------------------------------------------
1656:

Line 1654: -- INSERT INTO TABLE zx_trx_headers_gt

1650: IS
1651: BEGIN
1652: write_message('Inserting into zx_trx_headers_gt rec_tbl_row:'||to_char(p_row_id));
1653: ----------------------------------------------
1654: -- INSERT INTO TABLE zx_trx_headers_gt
1655: ----------------------------------------------
1656:
1657: INSERT INTO zx_trx_headers_gt(
1658: INTERNAL_ORGANIZATION_ID ,

Line 1657: INSERT INTO zx_trx_headers_gt(

1653: ----------------------------------------------
1654: -- INSERT INTO TABLE zx_trx_headers_gt
1655: ----------------------------------------------
1656:
1657: INSERT INTO zx_trx_headers_gt(
1658: INTERNAL_ORGANIZATION_ID ,
1659: INTERNAL_ORG_LOCATION_ID ,
1660: APPLICATION_ID ,
1661: ENTITY_CODE ,

Line 4560: select count(*) into l_dummy from zx_trx_headers_gt;

4556: -----------------------------------------------------------
4557: -- Proceeds to Call the APIs Calculate Tax
4558: -----------------------------------------------------------
4559: IF p_api_service = 'CALCULATE_TAX' THEN
4560: select count(*) into l_dummy from zx_trx_headers_gt;
4561: write_message('zx_transaction_headers_gt contains rows:'||to_char(l_dummy));
4562:
4563: zx_api_pub.calculate_tax (
4564: l_api_version ,

Line 7439: -- Inserting into zx_trx_headers_gt and

7435: END;
7436:
7437:
7438: -----------------------------------------------------------
7439: -- Inserting into zx_trx_headers_gt and
7440: -- zx_transaction_lines_gt
7441: -----------------------------------------------------------
7442:
7443: Insert into zx_trx_headers_gt

Line 7443: Insert into zx_trx_headers_gt

7439: -- Inserting into zx_trx_headers_gt and
7440: -- zx_transaction_lines_gt
7441: -----------------------------------------------------------
7442:
7443: Insert into zx_trx_headers_gt
7444: ( INTERNAL_ORGANIZATION_ID,
7445: APPLICATION_ID,
7446: ENTITY_CODE,
7447: EVENT_CLASS_CODE,

Line 7825: write_message('Row has been inserted in ZX_TRX_HEADERS_GT!');

7821: ---------------------------------------------------------------
7822: --Insert the data in the GTT for Transaction Headers
7823: ---------------------------------------------------------------
7824: insert_data_trx_headers_gt(p_header_row_id);
7825: write_message('Row has been inserted in ZX_TRX_HEADERS_GT!');
7826:
7827: ---------------------------------------------------------------
7828: --Insert the data in the GTT for Transaction Lines
7829: ---------------------------------------------------------------

Line 7866: DELETE from ZX_TRX_HEADERS_GT

7862: -- EVENT_TYPE_CODE = STANDARD DISTRIBUTE
7863: -- I'll delete and reinsert the entire Header Information
7864: -- for Determine Recovey as other columns may have changed.
7865: ----------------------------------------------------------------------------
7866: DELETE from ZX_TRX_HEADERS_GT
7867: WHERE trx_id = g_suite_rec_tbl.TRX_ID(p_header_row_id);
7868:
7869: write_message('--Row for Calculate has been deleted from ZX_TRX_HEADERS_GT!!!');
7870:

Line 7869: write_message('--Row for Calculate has been deleted from ZX_TRX_HEADERS_GT!!!');

7865: ----------------------------------------------------------------------------
7866: DELETE from ZX_TRX_HEADERS_GT
7867: WHERE trx_id = g_suite_rec_tbl.TRX_ID(p_header_row_id);
7868:
7869: write_message('--Row for Calculate has been deleted from ZX_TRX_HEADERS_GT!!!');
7870:
7871:
7872: ----------------------------------
7873: -- Insert the Transaction Header

Line 7876: write_message('--Row for Recovery has been inserted in ZX_TRX_HEADERS_GT!!!');

7872: ----------------------------------
7873: -- Insert the Transaction Header
7874: ----------------------------------
7875: insert_data_trx_headers_gt(l_header_row);
7876: write_message('--Row for Recovery has been inserted in ZX_TRX_HEADERS_GT!!!');
7877:
7878:
7879: ----------------------------------------------------------
7880: -- Retrieve the initial and ending lines for Imp Tax Lines

Line 7938: write_message('-- A row has been inserted in ZX_TRX_HEADERS_GT!!!');

7934: --------------------------
7935: --Insert the row in the GT
7936: --------------------------
7937: insert_data_trx_headers_gt(p_header_row_id);
7938: write_message('-- A row has been inserted in ZX_TRX_HEADERS_GT!!!');
7939:
7940: -----------------------------------------------------------
7941: -- Logic to get the start and end number in the case
7942: -----------------------------------------------------------

Line 7990: write_message('Row has been inserted in ZX_TRX_HEADERS_GT!');

7986: ---------------------------------------------------------------
7987: --Insert the data in the GTT for Transaction Headers
7988: ---------------------------------------------------------------
7989: insert_data_trx_headers_gt(p_header_row_id);
7990: write_message('Row has been inserted in ZX_TRX_HEADERS_GT!');
7991:
7992: --------------------------------------------------------------
7993: -- Retrieve the initial and ending lines for Transaction Lines
7994: --------------------------------------------------------------