APPS.XTR_WRAPPER_API_P dependencies on XTR_SETTLEMENT_SUMMARY

Line 95: From Xtr_Settlement_Summary

91: Select *
92: From Xtr_Deal_Date_Amounts
93: Where settlement_number in
94: (Select settlement_number
95: From Xtr_Settlement_Summary
96: Where net_ID = p_settlement_summary_ID)
97: For update of reconciled_reference;
98:
99:

Line 104: From Xtr_Settlement_Summary

100: cursor pop_dda_var is
101: select deal_number,transaction_number,date_type,amount_type,amount_date,currency,account_no,settlement_number
102: from xtr_deal_date_amounts Where settlement_number in
103: (Select settlement_number
104: From Xtr_Settlement_Summary
105: Where settlement_summary_id = p_settlement_summary_ID);
106:
107:
108: cursor DDA (P_DEAL_NO number, P_TRANS_NO number, P_DATE_TYPE varchar2,

Line 152: From Xtr_Settlement_Summary

148:
149: BEGIN --12733323
150: select deal_type into l_deal_type from xtr_deal_date_amounts where settlement_number in
151: (Select settlement_number
152: From Xtr_Settlement_Summary
153: Where settlement_summary_id = p_settlement_summary_ID);
154: EXCEPTION
155: WHEN No_Data_Found THEN
156: l_deal_type:='X';

Line 166: From Xtr_Settlement_Summary

162:
163: /* Calculate Adjustments */
164: select amount into l_dda_amount from xtr_deal_date_amounts where settlement_number in
165: (Select settlement_number
166: From Xtr_Settlement_Summary
167: Where settlement_summary_id = p_settlement_summary_ID);
168:
169: l_adjust := nvl(abs(P_RECON_AMT),0) - nvl(abs(l_dda_amount),0);
170:

Line 221: Update Xtr_Settlement_Summary

217: HCE_AMOUNT = decode(DATE_TYPE,'FORCAST',l_hce_amt,HCE_AMOUNT),
218: CASHFLOW_AMOUNT = decode(DATE_TYPE,'FORCAST',l_cashflow_amt,CASHFLOW_AMOUNT)
219: where rowid = DDA_ROW.rowid;
220:
221: Update Xtr_Settlement_Summary
222: Set status = 'R'
223: Where settlement_number = DDA_ROW.Settlement_Number;
224:
225: exit;

Line 245: /* This is to update Xtr_Settlement_Summary about the successful completion of Reconciliation */

241: commit;
242: -- ER 7601596 End
243: else
244:
245: /* This is to update Xtr_Settlement_Summary about the successful completion of Reconciliation */
246: Update xtr_settlement_summary
247: set status = 'R'
248: Where settlement_summary_id = p_settlement_summary_ID;
249:

Line 246: Update xtr_settlement_summary

242: -- ER 7601596 End
243: else
244:
245: /* This is to update Xtr_Settlement_Summary about the successful completion of Reconciliation */
246: Update xtr_settlement_summary
247: set status = 'R'
248: Where settlement_summary_id = p_settlement_summary_ID;
249:
250: If SQL%Found then

Line 258: From Xtr_Settlement_Summary

254: End if;
255:
256: Select settlement_number
257: Into v_settlement_number
258: From Xtr_Settlement_Summary
259: Where settlement_summary_id = p_settlement_summary_ID;
260:
261: Select Xtr_Deal_Date_Amounts_S.Nextval
262: Into v_reconciled_reference

Line 289: From Xtr_Settlement_Summary

285:
286: BEGIN --12733323
287: select distinct deal_type into l_deal_type from xtr_deal_date_amounts where settlement_number in
288: (Select settlement_number
289: From Xtr_Settlement_Summary
290: Where settlement_summary_id = p_settlement_summary_ID);
291: EXCEPTION
292: WHEN No_Data_Found THEN
293: l_deal_type:='X';

Line 304: (SELECT settlement_number FROM xtr_settlement_summary WHERE settlement_summary_id = p_settlement_summary_ID);

300: begin
301:
302: SELECT DISTINCT reconciled_reference into v_recon_ref FROM xtr_deal_date_amounts
303: WHERE settlement_number IN
304: (SELECT settlement_number FROM xtr_settlement_summary WHERE settlement_summary_id = p_settlement_summary_ID);
305:
306: XTR_AUTO_RECONCILIATION.REVERSE_ROLL_TRANS_RTMM(
307: null,
308: v_recon_ref,

Line 314: /* After successful Un-Reconciliation, Xtr_Settlement_Summary is updated for availability of record for future reconciliation */

310: 'MANUAL',P_VAL_DATE); end;
311: end if;
312: -- ER 7601596 End
313:
314: /* After successful Un-Reconciliation, Xtr_Settlement_Summary is updated for availability of record for future reconciliation */
315: Update xtr_settlement_summary
316: set status = 'A'
317: Where settlement_summary_id = p_settlement_summary_ID;
318: If SQL%Found then

Line 315: Update xtr_settlement_summary

311: end if;
312: -- ER 7601596 End
313:
314: /* After successful Un-Reconciliation, Xtr_Settlement_Summary is updated for availability of record for future reconciliation */
315: Update xtr_settlement_summary
316: set status = 'A'
317: Where settlement_summary_id = p_settlement_summary_ID;
318: If SQL%Found then
319: P_Result := 'XTR2_SUCCESS';

Line 326: From Xtr_Settlement_Summary

322: End if;
323:
324: Select settlement_number
325: Into v_settlement_number
326: From Xtr_Settlement_Summary
327: Where settlement_summary_id = p_settlement_summary_ID;
328:
329: Update Xtr_Deal_Date_Amounts
330: Set Reconciled_Reference = null,