APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_SETTLEMENT_SUMMARY

Line 459: (SELECT settlement_summary_id FROM xtr_settlement_summary WHERE settlement_number

455: -- Created cursor Bug 4226409
456: CURSOR SETTLE_DATE(p_rec_ref NUMBER) is
457: SELECT effective_date FROM ce_statement_lines WHERE statement_line_id IN (
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 ; */

Line 1532: select net_id from xtr_settlement_summary

1528: from DUAL;
1529: --
1530:
1531: Cursor C1(p_netoff_number number) is
1532: select net_id from xtr_settlement_summary
1533: where settlement_number =
1534: (select settlement_number
1535: from xtr_deal_date_amounts
1536: where netoff_number = p_netoff_number

Line 1939: Update Xtr_Settlement_Summary

1935: utl_file.put_line (l_file,'>>------------------------------');
1936: /***************/
1937: For C2_Rec in C2(l_Rec_nos)
1938: Loop
1939: Update Xtr_Settlement_Summary
1940: Set status = 'R'
1941: Where settlement_number = C2_Rec.settlement_number;
1942: /***************/
1943: utl_file.put_line(l_file, '>>----DDA_SUM_DATE ------');

Line 2004: Update Xtr_Settlement_Summary

2000: utl_file.put_line (l_file,'>>------------------------------');
2001: /***************/
2002: For C1_Rec in C1(v_netoff_number)
2003: Loop
2004: Update Xtr_Settlement_Summary
2005: Set status = 'R'
2006: Where settlement_summary_id = C1_Rec.net_ID;
2007: /***************/
2008: utl_file.put_line(l_file, '>>----DDA ------');

Line 2100: Update Xtr_Settlement_Summary

2096: utl_file.put_line (l_file,'>>------------------------------');
2097: /***************/
2098: For C2_Rec in C2(l_rec_nos)
2099: Loop
2100: Update Xtr_Settlement_Summary
2101: Set status = 'R'
2102: Where settlement_number = C2_Rec.settlement_number;
2103: /***************/
2104: utl_file.put_line(l_file, '>>----DDA_SUM_DATE ------');

Line 2166: Update Xtr_Settlement_Summary

2162: utl_file.put_line (l_file,'>>------------------------------');
2163: /***************/
2164: For C1_Rec in C1(v_netoff_number)
2165: Loop
2166: Update Xtr_Settlement_Summary
2167: Set status = 'R'
2168: Where settlement_summary_id = C1_Rec.net_ID;
2169: /***************/
2170: utl_file.put_line(l_file, '>>----DDA ------');

Line 2294: Update Xtr_Settlement_Summary

2290: utl_file.put_line (l_file,'>>------------------------------');
2291: /***************/
2292: For C2_Rec in C2(l_rec_nos)
2293: Loop
2294: Update Xtr_Settlement_Summary
2295: Set status = 'R'
2296: Where settlement_number = C2_Rec.Settlement_Number;
2297: /***************/
2298: utl_file.put_line (l_file,'>>----DDA');

Line 2361: Update Xtr_Settlement_Summary

2357: utl_file.put_line (l_file,'>>------------------------------');
2358: /***************/
2359: For C1_Rec in C1(v_netoff_number)
2360: Loop
2361: Update Xtr_Settlement_Summary
2362: Set status = 'R'
2363: Where settlement_summary_id = C1_Rec.net_ID;
2364: /***************/
2365: utl_file.put_line(l_file, '>>----DDA ------');

Line 2461: Update Xtr_Settlement_Summary

2457: utl_file.put_line (l_file,'>>------------------------------');
2458: /***************/
2459: For C2_Rec in C2(l_rec_nos)
2460: Loop
2461: Update Xtr_Settlement_Summary
2462: Set status = 'R'
2463: Where settlement_number = C2_Rec.Settlement_Number;
2464: /***************/
2465: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');

Line 2527: Update Xtr_Settlement_Summary

2523: utl_file.put_line (l_file,'>>------------------------------');
2524: /***************/
2525: For C1_Rec in C1(v_netoff_number)
2526: Loop
2527: Update Xtr_Settlement_Summary
2528: Set status = 'R'
2529: Where settlement_summary_id = C1_Rec.net_ID;
2530: /***************/
2531: utl_file.put_line(l_file, '>>----DDA ------');

Line 2677: Update Xtr_Settlement_Summary

2673: utl_file.put_line (l_file,'>>------------------------------');
2674: /***************/
2675: For C2_Rec in C2(l_rec_nos)
2676: Loop
2677: Update Xtr_Settlement_Summary
2678: Set status = 'R'
2679: Where settlement_number = C2_Rec.Settlement_Number;
2680: /***************/
2681: utl_file.put_line (l_file,'>>----DDA');

Line 2754: Update Xtr_Settlement_Summary

2750: utl_file.put_line (l_file,'>>------------------------------');
2751: /***************/
2752: For C1_Rec in C1(v_netoff_number)
2753: Loop
2754: Update Xtr_Settlement_Summary
2755: Set status = 'R'
2756: Where settlement_summary_id = C1_Rec.net_ID;
2757: /***************/
2758: utl_file.put_line(l_file, '>>----DDA ------');