[Home] [Help]
236:
237:
238: /* Cursor for GTT version of calculate tax*/
239: Cursor lines(p_event_class_rec ZX_API_PUB.event_class_rec_type) is
240: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1 */
241: header.INTERNAL_ORGANIZATION_ID ,
242: header.APPLICATION_ID ,
243: header.ENTITY_CODE ,
244: header.EVENT_CLASS_CODE ,
596: null)INSERT_UPDATE_FLAG
597: /* The update insert flag is to determine the records that need to be inserted/updated
598: into zx_lines_det_factors depending on the line_level_action for tax event type UPDATE*/
599: FROM ZX_TRANSACTION_LINES_GT trxlines,
600: ZX_TRX_HEADERS_GT header
601: WHERE header.application_id = p_event_class_rec.application_id
602: AND header.entity_code = p_event_class_rec.entity_code
603: AND header.event_class_code = p_event_class_rec.event_class_code
604: AND header.trx_id = p_event_class_rec.trx_id
612:
613: -- bug fix 5417887 begin
614: /* Cursor for GTT version of calculate tax as well as import_document_with_tax AI */
615: Cursor c_lines(p_event_class_rec ZX_API_PUB.event_class_rec_type) is
616: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1) */
617: header.INTERNAL_ORGANIZATION_ID ,
618: header.APPLICATION_ID ,
619: header.ENTITY_CODE ,
620: header.EVENT_CLASS_CODE ,
975: null TAX_CALCULATION_DONE_FLAG -- Bug 8931030
976: /* The update insert flag is to determine the records that need to be inserted/updated
977: into zx_lines_det_factors depending on the line_level_action for tax event type UPDATE*/
978: FROM ZX_TRANSACTION_LINES_GT trxlines,
979: ZX_TRX_HEADERS_GT header
980: WHERE trxlines.application_id = header.application_id
981: AND trxlines.entity_code = header.entity_code
982: AND trxlines.event_class_code = header.event_class_code
983: AND trxlines.trx_id = header.trx_id
9468: END IF;
9469:
9470: IF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' THEN
9471: SELECT COUNT(*) INTO l_no_of_trx
9472: FROM zx_trx_headers_gt;
9473:
9474: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9475: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
9476: 'No. of Transactions to be processed = '||l_no_of_trx);
9770: -- bug fix 5417887 end
9771:
9772: IF (ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' AND l_lines_passed = 1) THEN
9773: /*-----------------------------------------------------------+
9774: | Get no. of records from ZX_TRX_HEADERS_GT to segregate |
9775: | single transaction and multiple transactions processing |
9776: | l_no_of_trx = 1 => single transaction processing |
9777: | l_no_of_trx > 1 => multiple transactions processing |
9778: +-----------------------------------------------------------*/
9778: +-----------------------------------------------------------*/
9779: BEGIN
9780: SELECT count(*) No_of_records
9781: INTO l_no_of_trx
9782: FROM zx_trx_headers_gt;
9783: EXCEPTION
9784: WHEN OTHERS THEN
9785: l_no_of_trx := 0;
9786: END;
10652: -- Handling single trx and multiple trxs processing
10653: IF l_no_of_trx IS NULL then
10654: SELECT COUNT(*)
10655: INTO l_no_of_trx
10656: FROM zx_trx_headers_gt;
10657: END IF;
10658:
10659: IF l_no_of_trx = 0 THEN
10660: -- Return
11467: IF p_event_class_rec.EVENT_TYPE_CODE IS NULL THEN
11468: BEGIN
11469: SELECT event_type_code
11470: INTO p_event_class_rec.event_type_code
11471: FROM ZX_TRX_HEADERS_GT
11472: WHERE ROWNUM=1;
11473: EXCEPTION
11474: WHEN OTHERS THEN
11475: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13129: -- Handling single trx and multiple trxs processing
13130: IF l_no_of_trx IS NULL then
13131: SELECT COUNT(*)
13132: INTO l_no_of_trx
13133: FROM zx_trx_headers_gt;
13134: END IF;
13135:
13136: IF l_no_of_trx = 1 THEN
13137: -- Close cursor and Return
16917: -- This overloaded procedure acts as a wrapper on TDS default_tax_attribs
16918: -- procedure to default the tax determining attributes. It follows the
16919: -- following logic defaulting the determining attributes.
16920: --
16921: -- Fetch from zx_trx_headers_gt and zx_trx_transaction_lines_gt into
16922: -- global structure zx_global_structures_pkg.trx_line_dist_tbl
16923: -- For records in trx_line_dist_tbl
16924: -- Loop
16925: -- If all of defaulting attributes null (not including tax classification) then
16970: l_call_default_APIs BOOLEAN;
16971: l_context_info_rec ZX_API_PUB.context_info_rec_type;
16972:
16973: CURSOR lines (p_event_class_rec ZX_API_PUB.event_class_rec_type)is
16974: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1) */
16975: header.INTERNAL_ORGANIZATION_ID ,
16976: header.APPLICATION_ID ,
16977: header.ENTITY_CODE ,
16978: header.EVENT_CLASS_CODE ,
17311: trxlines.GLOBAL_ATTRIBUTE1,
17312: to_number(null) TOTAL_INC_TAX_AMT ,
17313: trxlines.USER_UPD_DET_FACTORS_FLAG
17314: FROM ZX_TRANSACTION_LINES_GT trxlines,
17315: ZX_TRX_HEADERS_GT header
17316: WHERE header.application_id = p_event_class_rec.application_id
17317: AND header.entity_code = p_event_class_rec.entity_code
17318: AND header.event_class_code = p_event_class_rec.event_class_code
17319: AND header.trx_id = p_event_class_rec.trx_id
17774: EXIT WHEN lines%NOTFOUND;
17775: END LOOP; --cursor
17776: CLOSE lines;
17777:
17778: --Update the zx_transaction_lines_gt and zx_trx_headers_gt with defaulted ATAs
17779:
17780: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST,-99)
17781: UPDATE ZX_TRANSACTION_LINES_GT SET
17782: trx_business_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_business_category(i),
17798: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(i)
17799: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(i);
17800:
17801: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST,-99)
17802: UPDATE ZX_TRX_HEADERS_GT SET
17803: default_taxation_country = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(i),
17804: document_sub_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.document_sub_type(i),
17805: tax_invoice_date = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_date(i),
17806: tax_invoice_number = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_number(i)