[Home] [Help]
348: P_Calling_Sequence IN VARCHAR2,
349: P_Amount IN NUMBER) RETURN VARCHAR2 IS
350:
351:
352: TYPE Trans_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;
353: TYPE CC_Lines_Tab_Type IS TABLE OF igc_cc_acct_lines%ROWTYPE;
354: l_trans_lines Trans_Lines_Tab_Type := Trans_Lines_Tab_Type();
355: l_cc_line_list CC_Lines_Tab_Type := CC_Lines_Tab_Type();
356: l_return_status VARCHAR2(32) := FND_API.G_RET_STS_SUCCESS;
376: CLOSE CC_Acct_Lines;
377: END IF;
378:
379: /* Bug 6719456 - Deleting all records instead of just passed line*/
380: DELETE FROM zx_transaction_lines_gt
381: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
382: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
383: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
384: AND trx_id = P_CC_Header_Rec.cc_header_id
491: trans_lines(i).ctrl_total_line_tx_amt := l_inv_line_list(i).control_amount;
492:
493: */
494: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
495: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');
496: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'event_class_code: ' || l_trans_lines(i).event_class_code);
497: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_id: ' || l_trans_lines(i).trx_id);
498: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_line_id: ' || l_trans_lines(i).trx_line_id);
499: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_level_type: ' || l_trans_lines(i).trx_level_type);
509: -------------------------------------------------------------------
510: l_debug_info := 'Bulk Insert into global temp table';
511: -------------------------------------------------------------------
512: FORALL i IN l_trans_lines.FIRST .. l_trans_lines.LAST
513: INSERT INTO zx_transaction_lines_gt
514: VALUES l_trans_lines(i);
515: RETURN l_return_status;
516: EXCEPTION
517: WHEN OTHERS THEN