DBA Data[Home] [Help]

APPS.XTR_WRAPPER_API_P dependencies on DUAL

Line 103: From dual;

99: Where settlement_summary_id = p_settlement_summary_ID;
100:
101: Select Xtr_Deal_Date_Amounts_S.Nextval
102: Into v_reconciled_reference
103: From dual;
104:
105: /* This is to update DDA about the successful completion of Reconciliation */
106: Update Xtr_Deal_Date_Amounts
107: Set Reconciled_Reference = v_reconciled_reference,

Line 1859: open c_param ('DUAL_AUTHORISE');

1855: Return FALSE;
1856: END;
1857:
1858: BEGIN
1859: open c_param ('DUAL_AUTHORISE');
1860: fetch c_param into l_validate_deal;
1861: close c_param;
1862:
1863: open c_param ('DUAL_AUTHORISE_IAC');

Line 1863: open c_param ('DUAL_AUTHORISE_IAC');

1859: open c_param ('DUAL_AUTHORISE');
1860: fetch c_param into l_validate_deal;
1861: close c_param;
1862:
1863: open c_param ('DUAL_AUTHORISE_IAC');
1864: fetch c_param into l_validate_iac;
1865: close c_param;
1866:
1867: open c_param ('IAC_AUTO_SETTLE');