585: ,p_ins_rec.order_num
586: ,p_ins_rec.start_date
587: ,p_ins_rec.end_date
588: ,SYSDATE
589: ,nvl(FND_GLOBAL.user_id,-1)
590: ,SYSDATE
591: ,nvl(FND_GLOBAL.user_id,-1)
592: ,nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id)
593: ,222 );
587: ,p_ins_rec.end_date
588: ,SYSDATE
589: ,nvl(FND_GLOBAL.user_id,-1)
590: ,SYSDATE
591: ,nvl(FND_GLOBAL.user_id,-1)
592: ,nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id)
593: ,222 );
594:
595: x_request_control_id := l_request_control_id;
588: ,SYSDATE
589: ,nvl(FND_GLOBAL.user_id,-1)
590: ,SYSDATE
591: ,nvl(FND_GLOBAL.user_id,-1)
592: ,nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id)
593: ,222 );
594:
595: x_request_control_id := l_request_control_id;
596: log( message => 'new record request_control_id :'||l_request_control_id);
606: by setting the status to:'||p_status);
607: UPDATE xla_upgrade_requests
608: SET status_code = p_status
609: ,LAST_UPDATE_DATE = SYSDATE
610: ,LAST_UPDATED_BY = nvl(FND_GLOBAL.user_id,-1)
611: ,LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id)
612: WHERE request_control_id = p_request_control_id
613: AND application_id = 222;
614: END;
607: UPDATE xla_upgrade_requests
608: SET status_code = p_status
609: ,LAST_UPDATE_DATE = SYSDATE
610: ,LAST_UPDATED_BY = nvl(FND_GLOBAL.user_id,-1)
611: ,LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id)
612: WHERE request_control_id = p_request_control_id
613: AND application_id = 222;
614: END;
615: