DBA Data[Home] [Help]

APPS.ZX_VERTEX_TAX_SERVICE_PKG dependencies on ZX_SYNC_HDR_INPUT_V

Line 4215: l_internal_organization_id ZX_SYNC_HDR_INPUT_V.internal_organization_id%type;

4211: TRX_LEVEL_TYPE;
4212:
4213:
4214: SYNC_TAX_LINES SYNC_TAX_LINES_TBL;
4215: l_internal_organization_id ZX_SYNC_HDR_INPUT_V.internal_organization_id%type;
4216: l_document_type_id ZX_SYNC_HDR_INPUT_V.document_type_id%type;
4217: l_transaction_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4218: l_legal_entity_number ZX_SYNC_HDR_INPUT_V.legal_entity_number%type;
4219: l_establishment_number ZX_SYNC_HDR_INPUT_V.establishment_number%type; -- Bug 5139731

Line 4216: l_document_type_id ZX_SYNC_HDR_INPUT_V.document_type_id%type;

4212:
4213:
4214: SYNC_TAX_LINES SYNC_TAX_LINES_TBL;
4215: l_internal_organization_id ZX_SYNC_HDR_INPUT_V.internal_organization_id%type;
4216: l_document_type_id ZX_SYNC_HDR_INPUT_V.document_type_id%type;
4217: l_transaction_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4218: l_legal_entity_number ZX_SYNC_HDR_INPUT_V.legal_entity_number%type;
4219: l_establishment_number ZX_SYNC_HDR_INPUT_V.establishment_number%type; -- Bug 5139731
4220: l_transaction_line_id ZX_SYNC_TAX_LINES_INPUT_V.transaction_line_id%type;

Line 4217: l_transaction_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;

4213:
4214: SYNC_TAX_LINES SYNC_TAX_LINES_TBL;
4215: l_internal_organization_id ZX_SYNC_HDR_INPUT_V.internal_organization_id%type;
4216: l_document_type_id ZX_SYNC_HDR_INPUT_V.document_type_id%type;
4217: l_transaction_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4218: l_legal_entity_number ZX_SYNC_HDR_INPUT_V.legal_entity_number%type;
4219: l_establishment_number ZX_SYNC_HDR_INPUT_V.establishment_number%type; -- Bug 5139731
4220: l_transaction_line_id ZX_SYNC_TAX_LINES_INPUT_V.transaction_line_id%type;
4221: l_count number;

Line 4218: l_legal_entity_number ZX_SYNC_HDR_INPUT_V.legal_entity_number%type;

4214: SYNC_TAX_LINES SYNC_TAX_LINES_TBL;
4215: l_internal_organization_id ZX_SYNC_HDR_INPUT_V.internal_organization_id%type;
4216: l_document_type_id ZX_SYNC_HDR_INPUT_V.document_type_id%type;
4217: l_transaction_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4218: l_legal_entity_number ZX_SYNC_HDR_INPUT_V.legal_entity_number%type;
4219: l_establishment_number ZX_SYNC_HDR_INPUT_V.establishment_number%type; -- Bug 5139731
4220: l_transaction_line_id ZX_SYNC_TAX_LINES_INPUT_V.transaction_line_id%type;
4221: l_count number;
4222: l_event_type varchar2(20);

Line 4219: l_establishment_number ZX_SYNC_HDR_INPUT_V.establishment_number%type; -- Bug 5139731

4215: l_internal_organization_id ZX_SYNC_HDR_INPUT_V.internal_organization_id%type;
4216: l_document_type_id ZX_SYNC_HDR_INPUT_V.document_type_id%type;
4217: l_transaction_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4218: l_legal_entity_number ZX_SYNC_HDR_INPUT_V.legal_entity_number%type;
4219: l_establishment_number ZX_SYNC_HDR_INPUT_V.establishment_number%type; -- Bug 5139731
4220: l_transaction_line_id ZX_SYNC_TAX_LINES_INPUT_V.transaction_line_id%type;
4221: l_count number;
4222: l_event_type varchar2(20);
4223: l_write_record boolean;

Line 4268: FROM ZX_SYNC_HDR_INPUT_V;

4264: l_document_type_id,
4265: l_transaction_id,
4266: l_legal_entity_number,
4267: l_establishment_number -- Bug 5139731
4268: FROM ZX_SYNC_HDR_INPUT_V;
4269: EXCEPTION
4270: WHEN TOO_MANY_ROWS THEN
4271: IF (g_level_exception >= g_current_runtime_level ) THEN
4272: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

Line 4575: FROM ZX_SYNC_HDR_INPUT_V)

4571: END IF;
4572:
4573: /*UPDATE ARP_TAX_VERTEX_AUDIT
4574: SET INVNO = (SELECT TRANSACTION_NUMBER
4575: FROM ZX_SYNC_HDR_INPUT_V)
4576: WHERE TRANSUSERAREA = (SELECT TRANSACTION_ID
4577: FROM ZX_SYNC_HDR_INPUT_V);*/
4578:
4579: BEGIN

Line 4577: FROM ZX_SYNC_HDR_INPUT_V);*/

4573: /*UPDATE ARP_TAX_VERTEX_AUDIT
4574: SET INVNO = (SELECT TRANSACTION_NUMBER
4575: FROM ZX_SYNC_HDR_INPUT_V)
4576: WHERE TRANSUSERAREA = (SELECT TRANSACTION_ID
4577: FROM ZX_SYNC_HDR_INPUT_V);*/
4578:
4579: BEGIN
4580: SELECT TRANSACTION_NUMBER, TO_CHAR(TRANSACTION_ID)
4581: INTO l_trx_number, char_ctrx_id

Line 4582: FROM ZX_SYNC_HDR_INPUT_V;

4578:
4579: BEGIN
4580: SELECT TRANSACTION_NUMBER, TO_CHAR(TRANSACTION_ID)
4581: INTO l_trx_number, char_ctrx_id
4582: FROM ZX_SYNC_HDR_INPUT_V;
4583: EXCEPTION
4584: WHEN TOO_MANY_ROWS THEN
4585: IF (g_level_exception >= g_current_runtime_level ) THEN
4586: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);