[Home] [Help]
221:
222:
223: /* Cursor for GTT version of calculate tax*/
224: Cursor lines(p_event_class_rec ZX_API_PUB.event_class_rec_type) is
225: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1 */
226: header.INTERNAL_ORGANIZATION_ID ,
227: header.APPLICATION_ID ,
228: header.ENTITY_CODE ,
229: header.EVENT_CLASS_CODE ,
581: null)INSERT_UPDATE_FLAG
582: /* The update insert flag is to determine the records that need to be inserted/updated
583: into zx_lines_det_factors depending on the line_level_action for tax event type UPDATE*/
584: FROM ZX_TRANSACTION_LINES_GT trxlines,
585: ZX_TRX_HEADERS_GT header
586: WHERE header.application_id = p_event_class_rec.application_id
587: AND header.entity_code = p_event_class_rec.entity_code
588: AND header.event_class_code = p_event_class_rec.event_class_code
589: AND header.trx_id = p_event_class_rec.trx_id
597:
598: -- bug fix 5417887 begin
599: /* Cursor for GTT version of calculate tax as well as import_document_with_tax AI */
600: Cursor c_lines(p_event_class_rec ZX_API_PUB.event_class_rec_type) is
601: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1) */
602: header.INTERNAL_ORGANIZATION_ID ,
603: header.APPLICATION_ID ,
604: header.ENTITY_CODE ,
605: header.EVENT_CLASS_CODE ,
956: 'DELETE','U') INSERT_UPDATE_FLAG
957: /* The update insert flag is to determine the records that need to be inserted/updated
958: into zx_lines_det_factors depending on the line_level_action for tax event type UPDATE*/
959: FROM ZX_TRANSACTION_LINES_GT trxlines,
960: ZX_TRX_HEADERS_GT header
961: WHERE trxlines.application_id = header.application_id
962: AND trxlines.entity_code = header.entity_code
963: AND trxlines.event_class_code = header.event_class_code
964: AND trxlines.trx_id = header.trx_id
8858: -- bug fix 5417887 end
8859:
8860: IF (ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' AND l_lines_passed = 1) THEN
8861: /*-----------------------------------------------------------+
8862: | Get no. of records from ZX_TRX_HEADERS_GT to segregate |
8863: | single transaction and multiple transactions processing |
8864: | l_no_of_trx = 1 => single transaction processing |
8865: | l_no_of_trx > 1 => multiple transactions processing |
8866: +-----------------------------------------------------------*/
8866: +-----------------------------------------------------------*/
8867: BEGIN
8868: SELECT count(*) No_of_records
8869: INTO l_no_of_trx
8870: FROM zx_trx_headers_gt;
8871: EXCEPTION
8872: WHEN OTHERS THEN
8873: l_no_of_trx := 0;
8874: END;
9617: -- Handling single trx and multiple trxs processing
9618: IF l_no_of_trx IS NULL then
9619: SELECT COUNT(*)
9620: INTO l_no_of_trx
9621: FROM zx_trx_headers_gt;
9622: END IF;
9623:
9624: IF l_no_of_trx = 0 THEN
9625: -- Return
10320:
10321: BEGIN
10322: SELECT event_type_code
10323: INTO p_event_class_rec.event_type_code
10324: FROM ZX_TRX_HEADERS_GT
10325: WHERE rownum=1;
10326: EXCEPTION
10327: WHEN OTHERS THEN
10328: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10603:
10604: Cursor for import_document_with_tax API - need to retrieve only those lines
10605: that have passed validation in the validate and default API run
10606: Cursor get_imported_lines(p_event_class_rec zx_api_pub.event_class_rec_type) is
10607: SELECT INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1)
10608: header.INTERNAL_ORGANIZATION_ID ,
10609: header.APPLICATION_ID ,
10610: header.ENTITY_CODE ,
10611: header.EVENT_CLASS_CODE ,
10943: trxlines.GLOBAL_ATTRIBUTE_CATEGORY,
10944: trxlines.GLOBAL_ATTRIBUTE1,
10945: to_number(null) TOTAL_INC_TAX_AMT ,
10946: trxlines.USER_UPD_DET_FACTORS_FLAG
10947: FROM ZX_TRANSACTION_LINES_GT trxlines, ZX_TRX_HEADERS_GT header
10948: WHERE header.application_id = p_event_class_rec.application_id
10949: AND header.entity_code = p_event_class_rec.entity_code
10950: AND header.event_class_code = p_event_class_rec.event_class_code
10951: -- AND header.trx_id = p_event_class_rec.trx_id
15806: -- This overloaded procedure acts as a wrapper on TDS default_tax_attribs
15807: -- procedure to default the tax determining attributes. It follows the
15808: -- following logic defaulting the determining attributes.
15809: --
15810: -- Fetch from zx_trx_headers_gt and zx_trx_transaction_lines_gt into
15811: -- global structure zx_global_structures_pkg.trx_line_dist_tbl
15812: -- For records in trx_line_dist_tbl
15813: -- Loop
15814: -- If all of defaulting attributes null (not including tax classification) then
15859: l_call_default_APIs BOOLEAN;
15860: l_context_info_rec ZX_API_PUB.context_info_rec_type;
15861:
15862: CURSOR lines (p_event_class_rec ZX_API_PUB.event_class_rec_type)is
15863: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1) */
15864: header.INTERNAL_ORGANIZATION_ID ,
15865: header.APPLICATION_ID ,
15866: header.ENTITY_CODE ,
15867: header.EVENT_CLASS_CODE ,
16200: trxlines.GLOBAL_ATTRIBUTE1,
16201: to_number(null) TOTAL_INC_TAX_AMT ,
16202: trxlines.USER_UPD_DET_FACTORS_FLAG
16203: FROM ZX_TRANSACTION_LINES_GT trxlines,
16204: ZX_TRX_HEADERS_GT header
16205: WHERE header.application_id = p_event_class_rec.application_id
16206: AND header.entity_code = p_event_class_rec.entity_code
16207: AND header.event_class_code = p_event_class_rec.event_class_code
16208: AND header.trx_id = p_event_class_rec.trx_id
16663: EXIT WHEN lines%NOTFOUND;
16664: END LOOP; --cursor
16665: CLOSE lines;
16666:
16667: --Update the zx_transaction_lines_gt and zx_trx_headers_gt with defaulted ATAs
16668:
16669: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST,-99)
16670: UPDATE ZX_TRANSACTION_LINES_GT SET
16671: trx_business_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_business_category(i),
16687: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(i)
16688: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(i);
16689:
16690: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST,-99)
16691: UPDATE ZX_TRX_HEADERS_GT SET
16692: default_taxation_country = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(i),
16693: document_sub_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.document_sub_type(i),
16694: tax_invoice_date = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_date(i),
16695: tax_invoice_number = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_number(i)