eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_NEW_SERVICES_PKG dependencies on ZX_LINES

Line 411: into zx_lines_det_factors depending on the line_level_action for tax event type UPDATE*/

407: 'CANCEL','U',
408: 'SYNCHRONIZE','U',
409: 'DELETE','U') INSERT_UPDATE_FLAG
410: /* The update insert flag is to determine the records that need to be inserted/updated
411: into zx_lines_det_factors depending on the line_level_action for tax event type UPDATE*/
412: FROM ZX_TRANSACTION_LINES_GT trxlines,
413: ZX_TRX_HEADERS_GT header
414: WHERE trxlines.application_id = header.application_id
415: AND trxlines.entity_code = header.entity_code

Line 510: UPDATE ZX_LINES_DET_FACTORS SET

506: END IF;
507:
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: FORALL i IN NVL(p_trx_line_dist_tbl.application_id.FIRST,0) .. NVL(p_trx_line_dist_tbl.application_id.LAST,-99)
510: UPDATE ZX_LINES_DET_FACTORS SET
511: EVENT_ID = p_event_class_rec.event_id,
512: INTERNAL_ORGANIZATION_ID = p_trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(i),
513: EVENT_TYPE_CODE = p_trx_line_dist_tbl.EVENT_TYPE_CODE(i),
514: DOC_EVENT_STATUS = p_event_class_rec.DOC_STATUS_CODE,

Line 935: SELECT ZX_LINES_DET_FACTORS_S.NEXTVAL

931:
932: /*-----------------------------------------+
933: | Get the event id for the whole document |
934: +-----------------------------------------*/
935: SELECT ZX_LINES_DET_FACTORS_S.NEXTVAL
936: INTO l_event_class_rec.event_id
937: FROM dual;
938:
939: /*------------------------------------------------+

Line 940: | Update zx_lines_det_factors |

936: INTO l_event_class_rec.event_id
937: FROM dual;
938:
939: /*------------------------------------------------+
940: | Update zx_lines_det_factors |
941: +------------------------------------------------*/
942: FORALL i IN NVL(p_trx_line_dist_id_tbl.FIRST,0) ..NVL(p_trx_line_dist_id_tbl.LAST, -1)
943: UPDATE /*+ cardinality(ZX_LINES_DET_FACTORS,100) */ ZX_LINES_DET_FACTORS
944: SET EVENT_TYPE_CODE = p_transaction_rec.event_type_code,

Line 943: UPDATE /+ cardinality(ZX_LINES_DET_FACTORS,100) / ZX_LINES_DET_FACTORS

939: /*------------------------------------------------+
940: | Update zx_lines_det_factors |
941: +------------------------------------------------*/
942: FORALL i IN NVL(p_trx_line_dist_id_tbl.FIRST,0) ..NVL(p_trx_line_dist_id_tbl.LAST, -1)
943: UPDATE /*+ cardinality(ZX_LINES_DET_FACTORS,100) */ ZX_LINES_DET_FACTORS
944: SET EVENT_TYPE_CODE = p_transaction_rec.event_type_code,
945: TAX_EVENT_TYPE_CODE = p_transaction_rec.tax_event_type_code,
946: EVENT_ID = l_event_class_rec.event_id,
947: DOC_EVENT_STATUS = l_event_class_rec.doc_status_code

Line 963: UPDATE /+ cardinality(ZX_LINES_DET_FACTORS,100) / ZX_LINES_DET_FACTORS

959: AND trx_line_dist_id = p_trx_line_dist_id_tbl(i)
960: );
961:
962: -- Update Pseudo Item Lines for Tax only lines.
963: UPDATE /*+ cardinality(ZX_LINES_DET_FACTORS,100) */ ZX_LINES_DET_FACTORS
964: SET EVENT_TYPE_CODE = p_transaction_rec.event_type_code,
965: TAX_EVENT_TYPE_CODE = p_transaction_rec.tax_event_type_code,
966: EVENT_ID = l_event_class_rec.event_id,
967: DOC_EVENT_STATUS = l_event_class_rec.doc_status_code

Line 1005: UPDATE ZX_LINES ZL

1001: AND trx_id = p_transaction_rec.trx_id
1002: AND tax_only_line_flag = 'Y';
1003:
1004: FORALL i IN NVL(p_trx_line_dist_id_tbl.FIRST,0) ..NVL(p_trx_line_dist_id_tbl.LAST, -1)
1005: UPDATE ZX_LINES ZL
1006: SET associated_child_frozen_flag ='Y',
1007: event_type_code = l_event_class_rec.event_type_code,
1008: tax_event_type_code = l_event_class_rec.tax_event_type_code,
1009: doc_event_status = l_event_class_rec.doc_status_code

Line 1020: UPDATE ZX_LINES ZL

1016: AND trx_line_dist_id = p_trx_line_dist_id_tbl(i)
1017: );
1018:
1019: -- Update assciated_child_frozen_fag for tax only lines.
1020: UPDATE ZX_LINES ZL
1021: SET associated_child_frozen_flag ='Y',
1022: event_type_code = l_event_class_rec.event_type_code,
1023: tax_event_type_code = l_event_class_rec.tax_event_type_code,
1024: doc_event_status = l_event_class_rec.doc_status_code

Line 1219: select ZX_LINES_DET_FACTORS_S.nextval

1215: and event_class_code = p_transaction_rec.event_class_code
1216: and trx_id = p_transaction_rec.trx_id;
1217: END IF;
1218:
1219: select ZX_LINES_DET_FACTORS_S.nextval
1220: into l_event_id
1221: from dual;
1222:
1223: l_event_class_rec.EVENT_ID := l_event_id;

Line 1992: FROM ZX_LINES

1988: sum(nrec_tax_amt_tax_curr),
1989: sum(nrec_tax_amt_funcl_curr),
1990: decode((count(*) - Sum(Decode(cancel_flag, 'Y', 1, 0))), 0, 'Y', NULL) cancel_flag,
1991: summary_tax_line_id
1992: FROM ZX_LINES
1993: WHERE application_id = p_transaction_rec.application_id
1994: AND entity_code = p_transaction_rec.entity_code
1995: AND event_class_code = p_transaction_rec.event_class_code
1996: AND trx_id = p_transaction_rec.trx_id

Line 2011: FROM ZX_LINES zxl

2007: sum(zxl.nrec_tax_amt_tax_curr),
2008: sum(zxl.nrec_tax_amt_funcl_curr),
2009: decode((count(*) - Sum(Decode(cancel_flag, 'Y', 1, 0))), 0, 'Y', NULL) cancel_flag,
2010: zxl.summary_tax_line_id
2011: FROM ZX_LINES zxl
2012: WHERE zxl.application_id = p_transaction_rec.application_id
2013: AND zxl.entity_code = p_transaction_rec.entity_code
2014: AND zxl.event_class_code = p_transaction_rec.event_class_code
2015: AND zxl.trx_id = p_transaction_rec.trx_id

Line 2017: FROM ZX_LINES zd

2013: AND zxl.entity_code = p_transaction_rec.entity_code
2014: AND zxl.event_class_code = p_transaction_rec.event_class_code
2015: AND zxl.trx_id = p_transaction_rec.trx_id
2016: AND zxl.summary_tax_line_id IN (SELECT DISTINCT zd.summary_tax_line_id
2017: FROM ZX_LINES zd
2018: WHERE zd.application_id = zxl.application_id
2019: AND zd.entity_code = zxl.entity_code
2020: AND zd.event_class_code = zxl.event_class_code
2021: AND zd.trx_id = zxl.trx_id

Line 2038: FROM zx_lines zl

2034: CURSOR check_canceled_tax_lines (c_trx_line_id NUMBER) IS
2035: SELECT zl.tax_line_id,
2036: zl.tax_amt,
2037: zl.cancel_flag
2038: FROM zx_lines zl
2039: WHERE zl.application_id = p_transaction_rec.application_id
2040: AND zl.entity_code = p_transaction_rec.entity_code
2041: AND zl.event_class_code = p_transaction_rec.event_class_code
2042: AND zl.trx_id = p_transaction_rec.trx_id

Line 2053: FROM zx_lines zl,

2049: CURSOR check_tax_lines_dists_amt (c_trx_line_id NUMBER) IS
2050: SELECT zl.tax_line_id,
2051: zl.tax_amt,
2052: SUM(zd.rec_nrec_tax_amt) tot_rec_nrec_amt
2053: FROM zx_lines zl,
2054: zx_rec_nrec_dist zd
2055: WHERE zl.application_id = p_transaction_rec.application_id
2056: AND zl.entity_code = p_transaction_rec.entity_code
2057: AND zl.event_class_code = p_transaction_rec.event_class_code

Line 2268: -- Check if data exists in zx_lines_det_factors after

2264: END IF;
2265: END IF;
2266: END IF;
2267:
2268: -- Check if data exists in zx_lines_det_factors after
2269: -- on the fly upgrade, if not return control to payables
2270: -- as no tax impacts here
2271: ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated(
2272: p_upg_trx_info_rec => l_upg_trx_info_rec,

Line 2365: UPDATE ZX_LINES

2361: l_tax_line_id_tbl
2362: LIMIT G_LINES_PER_FETCH;
2363:
2364: FOR i IN NVL(l_tax_line_id_tbl.FIRST,0) .. NVL(l_tax_line_id_tbl.LAST,-99) LOOP
2365: UPDATE ZX_LINES
2366: SET ORIG_TAXABLE_AMT = NVL(orig_taxable_amt, taxable_amt),
2367: ORIG_TAXABLE_AMT_TAX_CURR = NVL(orig_taxable_amt_tax_curr, taxable_amt_tax_curr),
2368: ORIG_TAX_AMT = NVL(orig_tax_amt, tax_amt),
2369: ORIG_TAX_AMT_TAX_CURR = NVL(orig_tax_amt_tax_curr, tax_amt_tax_curr),

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 2533: UPDATE ZX_LINES

2529: l_tax_line_id_tbl
2530: LIMIT G_LINES_PER_FETCH;
2531:
2532: FOR i IN NVL(l_tax_line_id_tbl.FIRST,0) .. NVL(l_tax_line_id_tbl.LAST,-99) LOOP
2533: UPDATE ZX_LINES
2534: SET ORIG_TAXABLE_AMT = NVL(orig_taxable_amt, taxable_amt),
2535: ORIG_TAXABLE_AMT_TAX_CURR = NVL(orig_taxable_amt_tax_curr, taxable_amt_tax_curr),
2536: ORIG_TAX_AMT = NVL(orig_tax_amt, tax_amt),
2537: ORIG_TAX_AMT_TAX_CURR = NVL(orig_tax_amt_tax_curr, tax_amt_tax_curr),

Line 2590: FROM zx_lines zl

2586:
2587: BEGIN
2588: SELECT COUNT(zl.tax_line_id)
2589: INTO l_tax_line_count
2590: FROM zx_lines zl
2591: WHERE zl.application_id = p_transaction_rec.application_id
2592: AND zl.entity_code = p_transaction_rec.entity_code
2593: AND zl.event_class_code = p_transaction_rec.event_class_code
2594: AND zl.trx_id = p_transaction_rec.trx_id

Line 2621: UPDATE ZX_LINES ZL

2617: 'Count of Tax Lines without distributions = '||l_tax_line_count);
2618: END IF;
2619:
2620: IF l_tax_line_count > 0 THEN
2621: UPDATE ZX_LINES ZL
2622: SET ORIG_TAXABLE_AMT = NVL(orig_taxable_amt, taxable_amt),
2623: ORIG_TAXABLE_AMT_TAX_CURR = NVL(orig_taxable_amt_tax_curr, taxable_amt_tax_curr),
2624: ORIG_TAX_AMT = NVL(orig_tax_amt, tax_amt),
2625: ORIG_TAX_AMT_TAX_CURR = NVL(orig_tax_amt_tax_curr, tax_amt_tax_curr),

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 2731: UPDATE ZX_LINES

2727: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2728: 'If no distributions exists, Discard flow for Single item line : '|| p_trx_line_id);
2729: END IF;
2730: IF p_trx_line_id IS NOT NULL THEN
2731: UPDATE ZX_LINES
2732: SET ORIG_TAXABLE_AMT = NVL(orig_taxable_amt, taxable_amt),
2733: ORIG_TAXABLE_AMT_TAX_CURR = NVL(orig_taxable_amt_tax_curr, taxable_amt_tax_curr),
2734: ORIG_TAX_AMT = NVL(orig_tax_amt, tax_amt),
2735: ORIG_TAX_AMT_TAX_CURR = NVL(orig_tax_amt_tax_curr, tax_amt_tax_curr),

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 2821: UPDATE ZX_LINES

2817: END IF; --l_summarization_flag = 'Y'
2818:
2819: -- Cancel flow for entire Invoice.
2820: ELSE
2821: UPDATE ZX_LINES
2822: SET ORIG_TAXABLE_AMT = NVL(orig_taxable_amt, taxable_amt),
2823: ORIG_TAXABLE_AMT_TAX_CURR = NVL(orig_taxable_amt_tax_curr, taxable_amt_tax_curr),
2824: ORIG_TAX_AMT = NVL(orig_tax_amt, tax_amt),
2825: ORIG_TAX_AMT_TAX_CURR = NVL(orig_tax_amt_tax_curr, tax_amt_tax_curr),

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),

Line 3154: FROM zx_lines zl,

3150: CURSOR check_tax_lines_dists_amt IS
3151: SELECT zl.tax_line_id,
3152: zl.tax_amt,
3153: SUM(zd.rec_nrec_tax_amt) tot_rec_nrec_amt
3154: FROM zx_lines zl,
3155: zx_rec_nrec_dist zd
3156: WHERE zl.tax_line_id IN
3157: (SELECT zd.tax_line_id
3158: FROM zx_rec_nrec_dist zd,

Line 3235: UPDATE zx_lines

3231: AND rec_nrec_tax_dist_id IN (SELECT tax_dist_id FROM zx_tax_dist_id_gt);
3232:
3233: IF SQL%ROWCOUNT > 0 THEN
3234: FORALL i IN NVL(l_tax_line_id_tbl.FIRST, 0) .. NVL(l_tax_line_id_tbl.LAST, -1)
3235: UPDATE zx_lines
3236: SET process_for_recovery_flag = 'Y',
3237: rec_tax_amt = NULL,
3238: rec_tax_amt_tax_curr = NULL,
3239: rec_tax_amt_funcl_curr = NULL,