DBA Data[Home] [Help]

APPS.ZX_TEST_API dependencies on ZX_TRANSACTION_LINES_GT

Line 1797: | ZX_TRANSACTION_LINES_GT. Some values |

1793:
1794:
1795: /* ============================================================================*
1796: | PROCEDURE insert_data_trx_lines_gt : Inserts data for lines in |
1797: | ZX_TRANSACTION_LINES_GT. Some values |
1798: | are obtained from the Header row |
1799: * ============================================================================*/
1800:
1801: PROCEDURE insert_data_trx_lines_gt(p_header_row NUMBER,

Line 1809: -- INSERT INTO TABLE ZX_TRANSACTION_LINES_GT

1805: l_counter NUMBER;
1806: i NUMBER;
1807: BEGIN
1808: ---------------------------------------------
1809: -- INSERT INTO TABLE ZX_TRANSACTION_LINES_GT
1810: ---------------------------------------------
1811: for i in p_starting_line_row..p_ending_line_row loop
1812: write_message('Inserting into ZX_TRANSACTION_LINES_GT rec_tbl_row:'||to_char(i));
1813:

Line 1812: write_message('Inserting into ZX_TRANSACTION_LINES_GT rec_tbl_row:'||to_char(i));

1808: ---------------------------------------------
1809: -- INSERT INTO TABLE ZX_TRANSACTION_LINES_GT
1810: ---------------------------------------------
1811: for i in p_starting_line_row..p_ending_line_row loop
1812: write_message('Inserting into ZX_TRANSACTION_LINES_GT rec_tbl_row:'||to_char(i));
1813:
1814: --forall i in p_starting_line_row..p_ending_line_row
1815: INSERT INTO ZX_TRANSACTION_LINES_GT(
1816: APPLICATION_ID ,

Line 1815: INSERT INTO ZX_TRANSACTION_LINES_GT(

1811: for i in p_starting_line_row..p_ending_line_row loop
1812: write_message('Inserting into ZX_TRANSACTION_LINES_GT rec_tbl_row:'||to_char(i));
1813:
1814: --forall i in p_starting_line_row..p_ending_line_row
1815: INSERT INTO ZX_TRANSACTION_LINES_GT(
1816: APPLICATION_ID ,
1817: ENTITY_CODE ,
1818: EVENT_CLASS_CODE ,
1819: TRX_ID ,

Line 7440: -- zx_transaction_lines_gt

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
7444: ( INTERNAL_ORGANIZATION_ID,

Line 7468: --- Inserting into zx_transaction_lines_gt has changed. Correct it later.

7464: FROM zx_lines
7465: WHERE trx_id = p_transaction_id
7466: AND tax_only_line_flag= 'N';
7467:
7468: --- Inserting into zx_transaction_lines_gt has changed. Correct it later.
7469: /* Insert into zx_transaction_lines_gt
7470: ( APPLICATION_ID,
7471: ENTITY_CODE,
7472: EVENT_CLASS_CODE,

Line 7469: /* Insert into zx_transaction_lines_gt

7465: WHERE trx_id = p_transaction_id
7466: AND tax_only_line_flag= 'N';
7467:
7468: --- Inserting into zx_transaction_lines_gt has changed. Correct it later.
7469: /* Insert into zx_transaction_lines_gt
7470: ( APPLICATION_ID,
7471: ENTITY_CODE,
7472: EVENT_CLASS_CODE,
7473: TRX_LEVEL_TYPE,

Line 8059: write_message('Rows have been inserted in ZX_TRANSACTION_LINES_GT');

8055: p_end_row_imp_tax_link => l_ending_row
8056: );
8057: END IF;
8058:
8059: write_message('Rows have been inserted in ZX_TRANSACTION_LINES_GT');
8060: write_message('. ZX_IMPORT_TAX_LINES_GT');
8061: write_message('. ZX_TRX_TAX_LINE_GT.');
8062:
8063: ELSIF p_service = 'VALIDATE_DOCUMENT_WITH_TAX' THEN