APPS.ZX_NEW_SERVICES_PKG dependencies on ZX_LINES_SUMMARY

Line 2443: UPDATE ZX_LINES_SUMMARY

2439: TO_CHAR(i)||': Tax_Amt = ' || l_tax_amt_tbl(i) ||
2440: ', Summary_Tax_Line_Id = ' || l_summary_tax_line_id_tbl(i));
2441: END IF;
2442:
2443: UPDATE ZX_LINES_SUMMARY
2444: SET TAX_AMT = l_tax_amt_tbl(i),
2445: TAX_AMT_TAX_CURR = l_tax_amt_tax_curr_tbl(i),
2446: TAX_AMT_FUNCL_CURR = l_tax_amt_funcl_curr_tbl(i),
2447: TOTAL_REC_TAX_AMT = DECODE(p_line_level_action, 'DISCARD', l_tot_rec_amt_tbl(i), 'UNAPPLY_FROM', l_tot_rec_amt_tbl(i), TOTAL_REC_TAX_AMT),

Line 2700: UPDATE ZX_LINES_SUMMARY

2696: l_summary_tax_line_id_tbl
2697: LIMIT G_LINES_PER_FETCH;
2698:
2699: FOR i IN NVL(l_summary_tax_line_id_tbl.FIRST,0) .. NVL(l_summary_tax_line_id_tbl.LAST,-99) LOOP
2700: UPDATE ZX_LINES_SUMMARY
2701: SET TAX_AMT = l_tax_amt_tbl(i),
2702: TAX_AMT_TAX_CURR = l_tax_amt_tax_curr_tbl(i),
2703: TAX_AMT_FUNCL_CURR = l_tax_amt_funcl_curr_tbl(i),
2704: TOTAL_REC_TAX_AMT = DECODE(p_line_level_action, 'DISCARD', l_tot_rec_amt_tbl(i), 'UNAPPLY_FROM', l_tot_rec_amt_tbl(i), TOTAL_REC_TAX_AMT),

Line 2796: UPDATE ZX_LINES_SUMMARY

2792: l_summary_tax_line_id_tbl
2793: LIMIT G_LINES_PER_FETCH;
2794:
2795: FOR i IN NVL(l_summary_tax_line_id_tbl.FIRST,0) .. NVL(l_summary_tax_line_id_tbl.LAST,-99) LOOP
2796: UPDATE ZX_LINES_SUMMARY
2797: SET TAX_AMT = l_tax_amt_tbl(i),
2798: TAX_AMT_TAX_CURR = l_tax_amt_tax_curr_tbl(i),
2799: TAX_AMT_FUNCL_CURR = l_tax_amt_funcl_curr_tbl(i),
2800: TOTAL_REC_TAX_AMT = DECODE(p_line_level_action, 'DISCARD', l_tot_rec_amt_tbl(i), 'UNAPPLY_FROM', l_tot_rec_amt_tbl(i), TOTAL_REC_TAX_AMT),

Line 2863: UPDATE ZX_LINES_SUMMARY

2859: AND TRX_ID = p_transaction_rec.trx_id
2860: AND NVL(TAX_ONLY_LINE_FLAG,'N') <> 'Y';
2861:
2862: IF l_summarization_flag = 'Y' THEN
2863: UPDATE ZX_LINES_SUMMARY
2864: SET TAX_AMT = 0,
2865: TAX_AMT_TAX_CURR = 0,
2866: TAX_AMT_FUNCL_CURR = 0,
2867: TOTAL_REC_TAX_AMT = DECODE(p_line_level_action, 'DISCARD', 0, 'UNAPPLY_FROM', 0, TOTAL_REC_TAX_AMT),