APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_PAY_REC_RECONCILIATION

Line 27: XTR_PAY_REC_RECONCILIATION_V prr

23: itr.account_number
24: from xtr_source_of_imports_v sim,
25: xtr_available_for_recon_v are,
26: xtr_import_trailer_details_v itr,
27: XTR_PAY_REC_RECONCILIATION_V prr
28: where sim.source = itr.source
29: AND are.import_reference = itr.import_reference
30: AND prr.import_reference = are.import_reference
31: AND prr.import_reference = itr.import_reference

Line 462: from XTR_PAY_REC_RECONCILIATION_V

458: SELECT statement_line_id FROM ce_statement_reconcils_all WHERE reference_id in
459: (SELECT settlement_summary_id FROM xtr_settlement_summary WHERE settlement_number
460: IN (SELECT settlement_number FROM xtr_deal_date_amounts WHERE reconciled_reference = p_rec_ref )));
461: /* select VALUE_DATE
462: from XTR_PAY_REC_RECONCILIATION_V
463: where RECONCILED_REFERENCE = p_rec_ref ; */
464: --
465: BEGIN
466: -- set parameters

Line 627: from XTR_PAY_REC_RECONCILIATION_V

623: and TRANSACTION_NUMBER = l_trans_no;
624: -- Created cursor Bug 4226409
625: CURSOR SETTLE_DATE(p_rec_ref NUMBER) is
626: select VALUE_DATE
627: from XTR_PAY_REC_RECONCILIATION_V
628: where RECONCILED_REFERENCE = p_rec_ref ;
629: --
630: BEGIN
631: -- set parameters

Line 1517: from XTR_PAY_REC_RECONCILIATION

1513: where RECONCILED_PASS_CODE = P_PASS_CODE;
1514: p_det PASS_DETAILS%ROWTYPE;
1515: cursor REC is
1516: select *
1517: from XTR_PAY_REC_RECONCILIATION
1518: where IMPORT_REFERENCE = P_IMPORT_REFERENCE
1519: and RECONCILED_PASS_CODE is NULL
1520: and RECONCILED_REFERENCE is NULL
1521: for UPDATE OF IMPORT_REFERENCE;

Line 2016: update XTR_PAY_REC_RECONCILIATION

2012: End Loop;
2013: End if;
2014: End if;
2015:
2016: update XTR_PAY_REC_RECONCILIATION
2017: set RECONCILED_REFERENCE = l_rec_nos,
2018: RECONCILED_PASS_CODE = P_PASS_CODE
2019: where CURRENT OF REC;
2020: EXIT;

Line 2179: update XTR_PAY_REC_RECONCILIATION

2175:
2176: End if;
2177: End if;
2178:
2179: update XTR_PAY_REC_RECONCILIATION
2180: set RECONCILED_REFERENCE = l_rec_nos,
2181: RECONCILED_PASS_CODE = P_PASS_CODE
2182: where CURRENT OF REC;
2183: EXIT;

Line 2373: update XTR_PAY_REC_RECONCILIATION

2369: End Loop;
2370: End if;
2371: End if;
2372:
2373: update XTR_PAY_REC_RECONCILIATION
2374: set RECONCILED_REFERENCE = l_rec_nos,
2375: RECONCILED_PASS_CODE = P_PASS_CODE
2376: where CURRENT OF REC;
2377: end if;

Line 2539: update XTR_PAY_REC_RECONCILIATION

2535: End Loop;
2536: End if;
2537: End if;
2538:
2539: update XTR_PAY_REC_RECONCILIATION
2540: set RECONCILED_REFERENCE = l_rec_nos,
2541: RECONCILED_PASS_CODE = P_PASS_CODE
2542: where CURRENT OF REC;
2543: end if;

Line 2770: update XTR_PAY_REC_RECONCILIATION

2766: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2767: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> UPDATE XTR_PAY_REC_REOCNCILIATION ');
2768: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_rec_nos = ' || to_char(l_rec_nos));
2769: END IF;
2770: update XTR_PAY_REC_RECONCILIATION
2771: set RECONCILED_REFERENCE = l_rec_nos,
2772: RECONCILED_PASS_CODE = P_PASS_CODE
2773: where CURRENT OF REC;
2774: