35: -------------------------
36: -- Initialise Variables
37: -------------------------
38: limit_error := FALSE;
39: G_User_Id := fnd_global.user_id;
40: g_currency_first := null;
41: g_currency_second := null;
42: G_Pricing_Model := null;
43: Select Trunc(sysdate) Into G_Curr_Date From Dual;
128: close c_deal_no;
129:
130: XTR_LIMITS_P.UPDATE_LIMIT_EXCESS_LOG(deal_num,
131: 1,
132: Fnd_Global.User_Id,
133: v_limit_log_return);
134:
135: /*----------------------------------------------------*/
136: /* Call the insert procedure to insert into xtr_deals */
1818: ARec_Fx.ATTRIBUTE12 ,
1819: ARec_Fx.ATTRIBUTE13 ,
1820: ARec_Fx.ATTRIBUTE14 ,
1821: ARec_Fx.ATTRIBUTE15 ,
1822: FND_GLOBAL.conc_request_id ,
1823: FND_GLOBAL.prog_appl_id ,
1824: FND_GLOBAL.conc_program_id ,
1825: g_curr_date
1826: );
1819: ARec_Fx.ATTRIBUTE13 ,
1820: ARec_Fx.ATTRIBUTE14 ,
1821: ARec_Fx.ATTRIBUTE15 ,
1822: FND_GLOBAL.conc_request_id ,
1823: FND_GLOBAL.prog_appl_id ,
1824: FND_GLOBAL.conc_program_id ,
1825: g_curr_date
1826: );
1827:
1820: ARec_Fx.ATTRIBUTE14 ,
1821: ARec_Fx.ATTRIBUTE15 ,
1822: FND_GLOBAL.conc_request_id ,
1823: FND_GLOBAL.prog_appl_id ,
1824: FND_GLOBAL.conc_program_id ,
1825: g_curr_date
1826: );
1827:
1828: xtr_reval_process_p.xtr_ins_init_fv(ARec_Fx.COMPANY_CODE,p_deal_no,ARec_Fx.DEAL_TYPE,NULL);