APPS.XTR_WRAPPER_API_P dependencies on XTR_DEAL_DATE_AMOUNTS_S

Line 83: u_Settlement_Number XTR_DEAL_DATE_AMOUNTS.SETTLEMENT_NUMBER%TYPE;

79: u_amount_type XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE;
80: u_amount_date XTR_DEAL_DATE_AMOUNTS.AMOUNT_DATE%TYPE;
81: u_currency XTR_DEAL_DATE_AMOUNTS.CURRENCY%TYPE;
82: u_account_number XTR_DEAL_DATE_AMOUNTS.ACCOUNT_NO%TYPE;
83: u_Settlement_Number XTR_DEAL_DATE_AMOUNTS.SETTLEMENT_NUMBER%TYPE;
84: l_amount NUMBER;
85: l_hce_amt NUMBER;
86: l_test_number NUMBER;
87: l_cashflow_amt NUMBER;

Line 205: Select Xtr_Deal_Date_Amounts_S.Nextval

201: Else
202: l_cashflow_amt := nvl(DDA_ROW.cashflow_amount,0) + l_adjust;
203: End If;
204:
205: Select Xtr_Deal_Date_Amounts_S.Nextval
206: Into v_reconciled_reference
207: From dual;
208:
209:

Line 261: Select Xtr_Deal_Date_Amounts_S.Nextval

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
263: From dual;
264:
265: /* This is to update DDA about the successful completion of Reconciliation */