[Home] [Help]
3771: END IF;
3772:
3773: /* for actual cost adjustments enhancement jboppana start*/
3774: IF l_cost_method_type = 1 THEN
3775: g_log_msg := 'Updating cm_adjs_dtl table';
3776:
3777: print_debug(g_log_msg);
3778: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3779: THEN
3783: message => g_log_msg
3784: );
3785: END IF;
3786:
3787: UPDATE cm_adjs_dtl
3788: SET gl_posted_ind = DECODE(G_accounting_mode, 'D', gl_posted_ind, 'F', 1)
3789: , last_update_date = sysdate
3790: , last_updated_by = g_user_id
3791: , last_update_login = g_login_id
3804: and xpae.event_class_code = gxem.event_class_code
3805: )
3806: ;
3807:
3808: g_log_msg := sql%rowcount || ' rows updated in cm_adjs_dtl table';
3809:
3810: print_debug(g_log_msg);
3811: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3812: THEN