183: VALUES( ln_org_unit_id ,
184: pr_new.tax_type ,
185: 0 ,
186: lv_register_type ,
187: fnd_global.user_id ,
188: sysdate ,
189: fnd_global.user_id ,
190: sysdate ,
191: fnd_global.login_id
185: 0 ,
186: lv_register_type ,
187: fnd_global.user_id ,
188: sysdate ,
189: fnd_global.user_id ,
190: sysdate ,
191: fnd_global.login_id
192: );
193:
187: fnd_global.user_id ,
188: sysdate ,
189: fnd_global.user_id ,
190: sysdate ,
191: fnd_global.login_id
192: );
193:
194: END IF;
195:
208: END IF ;
209:
210: UPDATE JAI_CMN_RG_OTH_BALANCES
211: SET balance = pr_new.closing_balance,
212: last_updated_by = fnd_global.user_id,
213: last_update_date = sysdate,
214: last_update_login = fnd_global.login_id
215: WHERE org_unit_id = ln_org_unit_id
216: AND tax_type = pr_new.tax_type
210: UPDATE JAI_CMN_RG_OTH_BALANCES
211: SET balance = pr_new.closing_balance,
212: last_updated_by = fnd_global.user_id,
213: last_update_date = sysdate,
214: last_update_login = fnd_global.login_id
215: WHERE org_unit_id = ln_org_unit_id
216: AND tax_type = pr_new.tax_type
217: AND register_type = lv_register_type;
218: