DBA Data[Home] [Help]

APPS.XTR_STOCK_PKG dependencies on XTR_EXPOSURE_TRANSACTIONS

Line 319: -- Delete EXP record from XTR_EXPOSURE_TRANSACTIONS and DDA if there is any

315: where deal_type = 'STOCK'
316: and deal_no = p_deal_no;
317:
318: ----------------------------------------------------------------------------
319: -- Delete EXP record from XTR_EXPOSURE_TRANSACTIONS and DDA if there is any
320: --------------------------------------------------------------------------
321:
322: XTR_FPS2_P.DELETE_TAX_EXPOSURE(p_deal_no, l_dummy);
323:

Line 327: Delete from XTR_EXPOSURE_TRANSACTIONS

323:
324: Open BKGE_EXP;
325: Fetch BKGE_EXP into l_bkge_ref;
326: if BKGE_EXP%FOUND then
327: Delete from XTR_EXPOSURE_TRANSACTIONS
328: Where transaction_number = l_bkge_ref;
329:
330: Delete from XTR_DEAL_DATE_AMOUNTS
331: Where deal_type = 'EXP'

Line 798: l_tax_settled_reference XTR_EXPOSURE_TRANSACTIONS.Transaction_Number%Type;

794: l_level VARCHAR2(50);
795: l_cparty_acct VARCHAR2(20);
796:
797: /* Bug 3737048 Added the variable below. */
798: l_tax_settled_reference XTR_EXPOSURE_TRANSACTIONS.Transaction_Number%Type;
799:
800: one_step_rec XTR_FPS2_P.one_step_rec_type; /* p_schedule_code
801: p_currency
802: p_amount