DBA Data[Home] [Help]

APPS.ZX_TAXWARE_TAX_SERVICE_PKG dependencies on ZX_SYNC_TAX_LINES_INPUT_V

Line 3785: FROM ZX_SYNC_TAX_LINES_INPUT_V

3781: LAST_MANUAL_ENTRY ,
3782: MANUALLY_ENTERED_FLAG ,
3783: CANCEL_FLAG ,
3784: DELETE_FLAG
3785: FROM ZX_SYNC_TAX_LINES_INPUT_V
3786: ORDER BY DOCUMENT_TYPE_ID,
3787: TRANSACTION_ID,
3788: TRANSACTION_LINE_ID,
3789: TRX_LEVEL_TYPE;

Line 3798: l_transaction_line_id ZX_SYNC_TAX_LINES_INPUT_V.transaction_line_id%type;

3794: l_document_type_id ZX_SYNC_HDR_INPUT_V.document_type_id%type;
3795: l_transaction_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
3796: l_legal_entity_number ZX_SYNC_HDR_INPUT_V.legal_entity_number%type;
3797: l_establishment_number ZX_SYNC_HDR_INPUT_V.establishment_number%type; -- Bug 5139731
3798: l_transaction_line_id ZX_SYNC_TAX_LINES_INPUT_V.transaction_line_id%type;
3799: l_count number;
3800: l_event_type varchar2(20);
3801: l_write_record boolean;
3802: l_event_class_code varchar2(20);

Line 3950: Deleted line is passed thru zx_sync_tax_lines_input_v and there is

3946: ' No of records in ZX_PTNR_NEG_TAX_LINE_GT = ' || l_count);
3947: END IF;
3948:
3949: /* Check if the Line is present in ZX_PTNR_NEG_TAX_LINE_GT table.
3950: Deleted line is passed thru zx_sync_tax_lines_input_v and there is
3951: no corresponding line in ZX_PTNR_NEG_TAX_LINE_GT */
3952:
3953: IF (l_count=1) THEN /*Line is present. Hence, it is an UPDATE action */
3954: l_event_type :='TAX_LINE_UPDATE';