DBA Data[Home] [Help]

APPS.ZX_VERTEX_TAX_SERVICE_PKG dependencies on ZX_SYNC_HDR_INPUT_V

Line 4435: l_internal_organization_id ZX_SYNC_HDR_INPUT_V.internal_organization_id%type;

4431: TRX_LEVEL_TYPE;
4432:
4433:
4434: SYNC_TAX_LINES SYNC_TAX_LINES_TBL;
4435: l_internal_organization_id ZX_SYNC_HDR_INPUT_V.internal_organization_id%type;
4436: l_document_type_id ZX_SYNC_HDR_INPUT_V.document_type_id%type;
4437: l_transaction_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4438: l_legal_entity_number ZX_SYNC_HDR_INPUT_V.legal_entity_number%type;
4439: l_establishment_number ZX_SYNC_HDR_INPUT_V.establishment_number%type; -- Bug 5139731

Line 4436: l_document_type_id ZX_SYNC_HDR_INPUT_V.document_type_id%type;

4432:
4433:
4434: SYNC_TAX_LINES SYNC_TAX_LINES_TBL;
4435: l_internal_organization_id ZX_SYNC_HDR_INPUT_V.internal_organization_id%type;
4436: l_document_type_id ZX_SYNC_HDR_INPUT_V.document_type_id%type;
4437: l_transaction_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4438: l_legal_entity_number ZX_SYNC_HDR_INPUT_V.legal_entity_number%type;
4439: l_establishment_number ZX_SYNC_HDR_INPUT_V.establishment_number%type; -- Bug 5139731
4440: l_transaction_line_id ZX_SYNC_TAX_LINES_INPUT_V.transaction_line_id%type;

Line 4437: l_transaction_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;

4433:
4434: SYNC_TAX_LINES SYNC_TAX_LINES_TBL;
4435: l_internal_organization_id ZX_SYNC_HDR_INPUT_V.internal_organization_id%type;
4436: l_document_type_id ZX_SYNC_HDR_INPUT_V.document_type_id%type;
4437: l_transaction_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4438: l_legal_entity_number ZX_SYNC_HDR_INPUT_V.legal_entity_number%type;
4439: l_establishment_number ZX_SYNC_HDR_INPUT_V.establishment_number%type; -- Bug 5139731
4440: l_transaction_line_id ZX_SYNC_TAX_LINES_INPUT_V.transaction_line_id%type;
4441: l_event_type VARCHAR2(20);

Line 4438: l_legal_entity_number ZX_SYNC_HDR_INPUT_V.legal_entity_number%type;

4434: SYNC_TAX_LINES SYNC_TAX_LINES_TBL;
4435: l_internal_organization_id ZX_SYNC_HDR_INPUT_V.internal_organization_id%type;
4436: l_document_type_id ZX_SYNC_HDR_INPUT_V.document_type_id%type;
4437: l_transaction_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4438: l_legal_entity_number ZX_SYNC_HDR_INPUT_V.legal_entity_number%type;
4439: l_establishment_number ZX_SYNC_HDR_INPUT_V.establishment_number%type; -- Bug 5139731
4440: l_transaction_line_id ZX_SYNC_TAX_LINES_INPUT_V.transaction_line_id%type;
4441: l_event_type VARCHAR2(20);
4442: l_write_record BOOLEAN;

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

4435: l_internal_organization_id ZX_SYNC_HDR_INPUT_V.internal_organization_id%type;
4436: l_document_type_id ZX_SYNC_HDR_INPUT_V.document_type_id%type;
4437: l_transaction_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4438: l_legal_entity_number ZX_SYNC_HDR_INPUT_V.legal_entity_number%type;
4439: l_establishment_number ZX_SYNC_HDR_INPUT_V.establishment_number%type; -- Bug 5139731
4440: l_transaction_line_id ZX_SYNC_TAX_LINES_INPUT_V.transaction_line_id%type;
4441: l_event_type VARCHAR2(20);
4442: l_write_record BOOLEAN;
4443: l_event_class_code VARCHAR2(20);

Line 4469: l_adj_trx_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;

4465: l_neg_trx_line_count NUMBER; -- Added for Bug#12544630
4466: l_update_mode BOOLEAN; -- Added for Bug#12544630
4467:
4468: l_line_action zx_lines_det_factors.line_level_action%type;
4469: l_adj_trx_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4470: BEGIN
4471: x_return_status := FND_API.G_RET_STS_SUCCESS;
4472: err_count := 0;
4473:

Line 4492: FROM ZX_SYNC_HDR_INPUT_V;

4488: l_document_type_id,
4489: l_transaction_id,
4490: l_legal_entity_number,
4491: l_establishment_number -- Bug 5139731
4492: FROM ZX_SYNC_HDR_INPUT_V;
4493: EXCEPTION
4494: WHEN TOO_MANY_ROWS THEN
4495: IF (g_level_exception >= g_current_runtime_level ) THEN
4496: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

Line 5144: -- FROM ZX_SYNC_HDR_INPUT_V)

5140: END IF;
5141:
5142: -- UPDATE ARP_TAX_VERTEX_AUDIT
5143: -- SET INVNO = (SELECT TRANSACTION_NUMBER
5144: -- FROM ZX_SYNC_HDR_INPUT_V)
5145: -- WHERE TRANSUSERAREA = (SELECT TRANSACTION_ID
5146: -- FROM ZX_SYNC_HDR_INPUT_V);
5147:
5148: BEGIN

Line 5146: -- FROM ZX_SYNC_HDR_INPUT_V);

5142: -- UPDATE ARP_TAX_VERTEX_AUDIT
5143: -- SET INVNO = (SELECT TRANSACTION_NUMBER
5144: -- FROM ZX_SYNC_HDR_INPUT_V)
5145: -- WHERE TRANSUSERAREA = (SELECT TRANSACTION_ID
5146: -- FROM ZX_SYNC_HDR_INPUT_V);
5147:
5148: BEGIN
5149: SELECT TRANSACTION_NUMBER, TO_CHAR(TRANSACTION_ID)
5150: INTO l_trx_number, char_ctrx_id

Line 5151: FROM ZX_SYNC_HDR_INPUT_V;

5147:
5148: BEGIN
5149: SELECT TRANSACTION_NUMBER, TO_CHAR(TRANSACTION_ID)
5150: INTO l_trx_number, char_ctrx_id
5151: FROM ZX_SYNC_HDR_INPUT_V;
5152: EXCEPTION
5153: WHEN TOO_MANY_ROWS THEN
5154: IF (g_level_exception >= g_current_runtime_level ) THEN
5155: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);