APPS.XTR_RESET_BOND_RATE dependencies on FND_GLOBAL

Line 349: UPDATED_BY = fnd_global.user_id

345: IF p_update_type = 'SINGLE' THEN
346: UPDATE XTR_ROLLOVER_TRANSACTIONS
347: SET INTEREST_RATE=P_NEW_RATE,
348: UPDATED_ON = SYSDATE,
349: UPDATED_BY = fnd_global.user_id
350: WHERE STATUS_CODE = 'CURRENT'
351: AND MATURITY_DATE = P_COUPON_DATE
352: AND DEAL_NUMBER = P_DEAL_NUMBER;
353:

Line 366: UPDATED_BY = fnd_global.user_id

362:
363: UPDATE XTR_ROLLOVER_TRANSACTIONS
364: SET INTEREST_RATE=P_NEW_RATE,
365: UPDATED_ON = SYSDATE,
366: UPDATED_BY = fnd_global.user_id
367: WHERE STATUS_CODE = 'CURRENT'
368: AND MATURITY_DATE = l_COUPON_DATE
369: AND DEAL_NUMBER = P_DEAL_NUMBER;
370:

Line 448: UPDATED_BY = fnd_global.user_id

444: UPDATE xtr_rollover_transactions
445: set interest=v_new_cpn_amt,interest_hce=v_hce_amt,
446: tax_amount=v_tax_amt,original_amount=v_new_cpn_amt,
447: UPDATED_ON = sysdate,
448: UPDATED_BY = fnd_global.user_id
449: where deal_number=curr_trans_info.deal_number
450: and transaction_number=curr_trans_info.transaction_number;
451: --update XTR_DEAL_DATE_AMOUNTS
452: if nvl(v_income_method,'NUL')='NIA' then

Line 461: UPDATED_BY = fnd_global.user_id

457: UPDATE xtr_deal_date_amounts
458: set amount=nvl(v_new_cpn_amt_dda,0),
459: cashflow_amount=decode(curr_trans_info.deal_subtype,'BUY',1,-1)*nvl(v_new_cpn_amt_dda,0),
460: UPDATED_ON = sysdate,
461: UPDATED_BY = fnd_global.user_id
462: where deal_type='BOND'
463: and deal_number=curr_trans_info.deal_number
464: and transaction_number=curr_trans_info.transaction_number
465: and amount_type='COUPON' and date_type='COUPON';

Line 472: UPDATED_BY = fnd_global.user_id

468: if nvl(v_income_method,'NUL')='NIA' then
469: UPDATE xtr_deal_date_amounts
470: set amount=v_tax_amt,
471: UPDATED_ON = sysdate,
472: UPDATED_BY = fnd_global.user_id
473: where deal_type='BOND'
474: and deal_number=curr_trans_info.deal_number
475: and transaction_number=curr_trans_info.transaction_number
476: and amount_type='TAX' and date_type='INCUR';