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_REC_NREC_DIST

Line 954: FROM zx_rec_nrec_dist dist

950: AND EVENT_CLASS_CODE = p_transaction_rec.EVENT_CLASS_CODE
951: AND TRX_ID = p_transaction_rec.TRX_ID
952: AND (TRX_LINE_ID, TRX_LEVEL_TYPE) IN
953: (SELECT /*+ use_hash(dist) */ dist.trx_line_id, dist.trx_level_type
954: FROM zx_rec_nrec_dist dist
955: WHERE application_id = p_transaction_rec.application_id
956: AND entity_code = p_transaction_rec.entity_code
957: AND event_class_code = p_transaction_rec.event_class_code
958: AND trx_id = p_transaction_rec.trx_id

Line 974: FROM zx_rec_nrec_dist dist

970: AND EVENT_CLASS_CODE = p_transaction_rec.EVENT_CLASS_CODE
971: AND TRX_ID = p_transaction_rec.TRX_ID
972: AND (TRX_LINE_ID, TRX_LEVEL_TYPE) IN
973: (SELECT dist.trx_line_id, dist.trx_level_type
974: FROM zx_rec_nrec_dist dist
975: WHERE application_id = p_transaction_rec.application_id
976: AND entity_code = p_transaction_rec.entity_code
977: AND event_class_code = p_transaction_rec.event_class_code
978: AND trx_id = p_transaction_rec.trx_id

Line 983: UPDATE ZX_REC_NREC_DIST

979: AND tax_only_line_flag = 'Y'
980: );
981:
982: FORALL i IN NVL(p_trx_line_dist_id_tbl.FIRST,0) ..NVL(p_trx_line_dist_id_tbl.LAST, -1)
983: UPDATE ZX_REC_NREC_DIST
984: SET freeze_flag = 'Y',
985: event_type_code = l_event_class_rec.event_type_code,
986: tax_event_type_code = l_event_class_rec.tax_event_type_code
987: WHERE application_id = p_transaction_rec.application_id

Line 994: UPDATE ZX_REC_NREC_DIST

990: AND trx_id = p_transaction_rec.trx_id
991: AND trx_line_dist_id = p_trx_line_dist_id_tbl(i);
992:
993: -- Update freeze_flag for tax only distributions.
994: UPDATE ZX_REC_NREC_DIST
995: SET freeze_flag = 'Y',
996: event_type_code = l_event_class_rec.event_type_code,
997: tax_event_type_code = l_event_class_rec.tax_event_type_code
998: WHERE application_id = p_transaction_rec.application_id

Line 1011: FROM ZX_REC_NREC_DIST ZD

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
1010: WHERE TAX_LINE_ID IN (SELECT ZD.TAX_LINE_ID
1011: FROM ZX_REC_NREC_DIST ZD
1012: WHERE application_id = p_transaction_rec.application_id
1013: AND entity_code = p_transaction_rec.entity_code
1014: AND event_class_code = p_transaction_rec.event_class_code
1015: AND trx_id = p_transaction_rec.trx_id

Line 1026: FROM ZX_REC_NREC_DIST ZD

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
1025: WHERE TAX_LINE_ID IN (SELECT ZD.TAX_LINE_ID
1026: FROM ZX_REC_NREC_DIST ZD
1027: WHERE application_id = p_transaction_rec.application_id
1028: AND entity_code = p_transaction_rec.entity_code
1029: AND event_class_code = p_transaction_rec.event_class_code
1030: AND trx_id = p_transaction_rec.trx_id

Line 1958: FROM ZX_REC_NREC_DIST

1954: sum(rec_nrec_tax_amt),
1955: sum(rec_nrec_tax_amt_tax_curr),
1956: sum(rec_nrec_tax_amt_funcl_curr),
1957: tax_line_id
1958: FROM ZX_REC_NREC_DIST
1959: WHERE application_id = p_transaction_rec.application_id
1960: AND entity_code = p_transaction_rec.entity_code
1961: AND event_class_code = p_transaction_rec.event_class_code
1962: AND trx_id = p_transaction_rec.trx_id

Line 1971: FROM ZX_REC_NREC_DIST

1967: sum(rec_nrec_tax_amt),
1968: sum(rec_nrec_tax_amt_tax_curr),
1969: sum(rec_nrec_tax_amt_funcl_curr),
1970: tax_line_id
1971: FROM ZX_REC_NREC_DIST
1972: WHERE application_id = p_transaction_rec.application_id
1973: AND entity_code = p_transaction_rec.entity_code
1974: AND event_class_code = p_transaction_rec.event_class_code
1975: AND trx_id = p_transaction_rec.trx_id

Line 2054: zx_rec_nrec_dist zd

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
2058: AND zl.trx_id = p_transaction_rec.trx_id

Line 2334: UPDATE ZX_REC_NREC_DIST

2330: 'Updating the Freeze_Flag for the distributions');
2331: END IF;
2332:
2333: -- Update the freeze flag on the distributions
2334: UPDATE ZX_REC_NREC_DIST
2335: SET FREEZE_FLAG = 'Y'
2336: WHERE APPLICATION_ID = p_transaction_rec.application_id
2337: AND ENTITY_CODE = p_transaction_rec.entity_code
2338: AND EVENT_CLASS_CODE = p_transaction_rec.event_class_code

Line 2505: UPDATE ZX_REC_NREC_DIST

2501: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2502: 'Updating the Freeze_Flag');
2503: END IF;
2504:
2505: UPDATE ZX_REC_NREC_DIST
2506: SET FREEZE_FLAG = 'Y'
2507: WHERE APPLICATION_ID = p_transaction_rec.application_id
2508: AND ENTITY_CODE = p_transaction_rec.entity_code
2509: AND EVENT_CLASS_CODE = p_transaction_rec.event_class_code

Line 2598: FROM zx_rec_nrec_dist zd

2594: AND zl.trx_id = p_transaction_rec.trx_id
2595: AND NVL(zl.tax_only_line_flag,'N') <> 'Y'
2596: AND NVL(zl.cancel_flag,'N') <> 'Y'
2597: AND NOT EXISTS (SELECT /*+first_rows(1)*/ 1
2598: FROM zx_rec_nrec_dist zd
2599: WHERE zd.trx_id = zl.trx_id
2600: AND zd.application_id = zl.application_id
2601: AND zd.entity_code = zl.entity_code
2602: AND zd.event_class_code = zl.event_class_code

Line 2663: FROM ZX_REC_NREC_DIST ZD

2659: AND ZL.TRX_ID = p_transaction_rec.trx_id
2660: AND NVL(ZL.TAX_ONLY_LINE_FLAG,'N') <> 'Y'
2661: AND NVL(ZL.CANCEL_FLAG,'N') <> 'Y'
2662: AND NOT EXISTS (SELECT /*+first_rows(1)*/ 1
2663: FROM ZX_REC_NREC_DIST ZD
2664: WHERE ZD.TRX_ID = ZL.TRX_ID
2665: AND ZD.APPLICATION_ID = ZL.APPLICATION_ID
2666: AND ZD.ENTITY_CODE = ZL.ENTITY_CODE
2667: AND ZD.EVENT_CLASS_CODE = ZL.EVENT_CLASS_CODE

Line 3145: FROM zx_rec_nrec_dist zd, zx_tax_dist_id_gt zgt

3141: l_chk_tot_dist_amt_tbl num_tbl_type;
3142:
3143: CURSOR get_tax_line_id_cur IS
3144: SELECT tax_line_id
3145: FROM zx_rec_nrec_dist zd, zx_tax_dist_id_gt zgt
3146: WHERE zd.rec_nrec_tax_dist_id = zgt.tax_dist_id;
3147:
3148: -- Preventive check cursor to check if any tax line exists where tax amount
3149: -- of tax line is not equal to the sum of amounts of its distributions

Line 3155: zx_rec_nrec_dist zd

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,
3159: zx_tax_dist_id_gt zgt

Line 3158: FROM zx_rec_nrec_dist zd,

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,
3159: zx_tax_dist_id_gt zgt
3160: WHERE zd.rec_nrec_tax_dist_id = zgt.tax_dist_id)
3161: AND zd.application_id = zl.application_id
3162: AND zd.entity_code = zl.entity_code

Line 3225: DELETE FROM zx_rec_nrec_dist

3221: /*-----------------------------------------+
3222: | Delete tax distributions |
3223: +-----------------------------------------*/
3224:
3225: DELETE FROM zx_rec_nrec_dist
3226: WHERE application_id = p_transaction_line_rec.application_id
3227: AND entity_code = p_transaction_line_rec.entity_code
3228: AND event_class_code = p_transaction_line_rec.event_class_code
3229: AND trx_id = p_transaction_line_rec.trx_id

Line 3254: UPDATE zx_rec_nrec_dist zd

3250: -- Bug 11931349, while deleting candidate tax dists, reset the reverse flag for the parent tax dists so that during
3251: -- subsequent validation,tax distributions are reversed in ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line
3252:
3253: FORALL i IN NVL(l_tax_line_id_tbl.FIRST, 0) .. NVL(l_tax_line_id_tbl.LAST, -1)
3254: UPDATE zx_rec_nrec_dist zd
3255: SET reverse_flag = NULL
3256: WHERE application_id = p_transaction_line_rec.application_id
3257: AND entity_code = p_transaction_line_rec.entity_code
3258: AND event_class_code = p_transaction_line_rec.event_class_code

Line 3262: AND NOT EXISTS (SELECT 1 FROM zx_rec_nrec_dist zd1

3258: AND event_class_code = p_transaction_line_rec.event_class_code
3259: AND trx_id = p_transaction_line_rec.trx_id
3260: AND tax_line_id = l_tax_line_id_tbl(i)
3261: AND NVL(reverse_flag,'N') = 'Y'
3262: AND NOT EXISTS (SELECT 1 FROM zx_rec_nrec_dist zd1
3263: WHERE zd1.application_id = zd.application_id
3264: AND zd1.entity_code = zd.entity_code
3265: AND zd1.event_class_code = zd.event_class_code
3266: AND zd1.trx_id = zd.trx_id

Line 3326: FROM zx_rec_nrec_dist

3322: INTO l_msg_context_info_rec.application_id,
3323: l_msg_context_info_rec.entity_code,
3324: l_msg_context_info_rec.event_class_code,
3325: l_msg_context_info_rec.trx_id
3326: FROM zx_rec_nrec_dist
3327: WHERE rec_nrec_tax_dist_id IN
3328: (SELECT tax_dist_id FROM zx_tax_dist_id_gt)
3329: AND ROWNUM = 1;
3330: EXCEPTION

Line 3484: | Update zx_rec_nrec_dist |

3480: ZX_API_PUB.G_DATA_TRANSFER_MODE := 'PLS';
3481: ZX_API_PUB.G_EXTERNAL_API_CALL := 'N';
3482:
3483: /*------------------------------------------------+
3484: | Update zx_rec_nrec_dist |
3485: +------------------------------------------------*/
3486: FORALL i IN NVL(p_tax_dist_dff_tbl.rec_nrec_tax_dist_id.FIRST,0)..NVL(p_tax_dist_dff_tbl.rec_nrec_tax_dist_id.LAST, -1)
3487: UPDATE zx_rec_nrec_dist
3488: SET attribute1 = p_tax_dist_dff_tbl.attribute1(i),

Line 3487: UPDATE zx_rec_nrec_dist

3483: /*------------------------------------------------+
3484: | Update zx_rec_nrec_dist |
3485: +------------------------------------------------*/
3486: FORALL i IN NVL(p_tax_dist_dff_tbl.rec_nrec_tax_dist_id.FIRST,0)..NVL(p_tax_dist_dff_tbl.rec_nrec_tax_dist_id.LAST, -1)
3487: UPDATE zx_rec_nrec_dist
3488: SET attribute1 = p_tax_dist_dff_tbl.attribute1(i),
3489: attribute2 = p_tax_dist_dff_tbl.attribute2(i),
3490: attribute3 = p_tax_dist_dff_tbl.attribute3(i),
3491: attribute4 = p_tax_dist_dff_tbl.attribute4(i),