APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_SETTLEMENT_SUMMARY

Line 1255: select net_id from xtr_settlement_summary

1251: from DUAL;
1252: --
1253:
1254: Cursor C1(p_netoff_number number) is
1255: select net_id from xtr_settlement_summary
1256: where settlement_number =
1257: (select settlement_number
1258: from xtr_deal_date_amounts
1259: where netoff_number = p_netoff_number

Line 1662: Update Xtr_Settlement_Summary

1658: utl_file.put_line (l_file,'>>------------------------------');
1659: /***************/
1660: For C2_Rec in C2(l_Rec_nos)
1661: Loop
1662: Update Xtr_Settlement_Summary
1663: Set status = 'R'
1664: Where settlement_number = C2_Rec.settlement_number;
1665: /***************/
1666: utl_file.put_line(l_file, '>>----DDA_SUM_DATE ------');

Line 1727: Update Xtr_Settlement_Summary

1723: utl_file.put_line (l_file,'>>------------------------------');
1724: /***************/
1725: For C1_Rec in C1(v_netoff_number)
1726: Loop
1727: Update Xtr_Settlement_Summary
1728: Set status = 'R'
1729: Where settlement_summary_id = C1_Rec.net_ID;
1730: /***************/
1731: utl_file.put_line(l_file, '>>----DDA ------');

Line 1823: Update Xtr_Settlement_Summary

1819: utl_file.put_line (l_file,'>>------------------------------');
1820: /***************/
1821: For C2_Rec in C2(l_rec_nos)
1822: Loop
1823: Update Xtr_Settlement_Summary
1824: Set status = 'R'
1825: Where settlement_number = C2_Rec.settlement_number;
1826: /***************/
1827: utl_file.put_line(l_file, '>>----DDA_SUM_DATE ------');

Line 1889: Update Xtr_Settlement_Summary

1885: utl_file.put_line (l_file,'>>------------------------------');
1886: /***************/
1887: For C1_Rec in C1(v_netoff_number)
1888: Loop
1889: Update Xtr_Settlement_Summary
1890: Set status = 'R'
1891: Where settlement_summary_id = C1_Rec.net_ID;
1892: /***************/
1893: utl_file.put_line(l_file, '>>----DDA ------');

Line 2017: Update Xtr_Settlement_Summary

2013: utl_file.put_line (l_file,'>>------------------------------');
2014: /***************/
2015: For C2_Rec in C2(l_rec_nos)
2016: Loop
2017: Update Xtr_Settlement_Summary
2018: Set status = 'R'
2019: Where settlement_number = C2_Rec.Settlement_Number;
2020: /***************/
2021: utl_file.put_line (l_file,'>>----DDA');

Line 2084: Update Xtr_Settlement_Summary

2080: utl_file.put_line (l_file,'>>------------------------------');
2081: /***************/
2082: For C1_Rec in C1(v_netoff_number)
2083: Loop
2084: Update Xtr_Settlement_Summary
2085: Set status = 'R'
2086: Where settlement_summary_id = C1_Rec.net_ID;
2087: /***************/
2088: utl_file.put_line(l_file, '>>----DDA ------');

Line 2184: Update Xtr_Settlement_Summary

2180: utl_file.put_line (l_file,'>>------------------------------');
2181: /***************/
2182: For C2_Rec in C2(l_rec_nos)
2183: Loop
2184: Update Xtr_Settlement_Summary
2185: Set status = 'R'
2186: Where settlement_number = C2_Rec.Settlement_Number;
2187: /***************/
2188: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');

Line 2250: Update Xtr_Settlement_Summary

2246: utl_file.put_line (l_file,'>>------------------------------');
2247: /***************/
2248: For C1_Rec in C1(v_netoff_number)
2249: Loop
2250: Update Xtr_Settlement_Summary
2251: Set status = 'R'
2252: Where settlement_summary_id = C1_Rec.net_ID;
2253: /***************/
2254: utl_file.put_line(l_file, '>>----DDA ------');

Line 2400: Update Xtr_Settlement_Summary

2396: utl_file.put_line (l_file,'>>------------------------------');
2397: /***************/
2398: For C2_Rec in C2(l_rec_nos)
2399: Loop
2400: Update Xtr_Settlement_Summary
2401: Set status = 'R'
2402: Where settlement_number = C2_Rec.Settlement_Number;
2403: /***************/
2404: utl_file.put_line (l_file,'>>----DDA');

Line 2477: Update Xtr_Settlement_Summary

2473: utl_file.put_line (l_file,'>>------------------------------');
2474: /***************/
2475: For C1_Rec in C1(v_netoff_number)
2476: Loop
2477: Update Xtr_Settlement_Summary
2478: Set status = 'R'
2479: Where settlement_summary_id = C1_Rec.net_ID;
2480: /***************/
2481: utl_file.put_line(l_file, '>>----DDA ------');