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 350: from XTR_PAY_REC_RECONCILIATION_V

346: and TRANSACTION_NUMBER = l_trans_no;
347: -- Created cursor Bug 4226409
348: CURSOR SETTLE_DATE(p_rec_ref NUMBER) is
349: select VALUE_DATE
350: from XTR_PAY_REC_RECONCILIATION_V
351: where RECONCILED_REFERENCE = p_rec_ref ;
352: --
353: BEGIN
354: -- set parameters

Line 1240: from XTR_PAY_REC_RECONCILIATION

1236: where RECONCILED_PASS_CODE = P_PASS_CODE;
1237: p_det PASS_DETAILS%ROWTYPE;
1238: cursor REC is
1239: select *
1240: from XTR_PAY_REC_RECONCILIATION
1241: where IMPORT_REFERENCE = P_IMPORT_REFERENCE
1242: and RECONCILED_PASS_CODE is NULL
1243: and RECONCILED_REFERENCE is NULL
1244: for UPDATE OF IMPORT_REFERENCE;

Line 1739: update XTR_PAY_REC_RECONCILIATION

1735: End Loop;
1736: End if;
1737: End if;
1738:
1739: update XTR_PAY_REC_RECONCILIATION
1740: set RECONCILED_REFERENCE = l_rec_nos,
1741: RECONCILED_PASS_CODE = P_PASS_CODE
1742: where CURRENT OF REC;
1743: EXIT;

Line 1902: update XTR_PAY_REC_RECONCILIATION

1898:
1899: End if;
1900: End if;
1901:
1902: update XTR_PAY_REC_RECONCILIATION
1903: set RECONCILED_REFERENCE = l_rec_nos,
1904: RECONCILED_PASS_CODE = P_PASS_CODE
1905: where CURRENT OF REC;
1906: EXIT;

Line 2096: update XTR_PAY_REC_RECONCILIATION

2092: End Loop;
2093: End if;
2094: End if;
2095:
2096: update XTR_PAY_REC_RECONCILIATION
2097: set RECONCILED_REFERENCE = l_rec_nos,
2098: RECONCILED_PASS_CODE = P_PASS_CODE
2099: where CURRENT OF REC;
2100: end if;

Line 2262: update XTR_PAY_REC_RECONCILIATION

2258: End Loop;
2259: End if;
2260: End if;
2261:
2262: update XTR_PAY_REC_RECONCILIATION
2263: set RECONCILED_REFERENCE = l_rec_nos,
2264: RECONCILED_PASS_CODE = P_PASS_CODE
2265: where CURRENT OF REC;
2266: end if;

Line 2493: update XTR_PAY_REC_RECONCILIATION

2489: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2490: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> UPDATE XTR_PAY_REC_REOCNCILIATION ');
2491: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_rec_nos = ' || to_char(l_rec_nos));
2492: END IF;
2493: update XTR_PAY_REC_RECONCILIATION
2494: set RECONCILED_REFERENCE = l_rec_nos,
2495: RECONCILED_PASS_CODE = P_PASS_CODE
2496: where CURRENT OF REC;
2497: