[Home] [Help]
216: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
217: 'fnd.plsql.UMXVRRSB.update_reg_request.begin', 'Begin');
218: end if;
219:
220: UMX_REG_REQUESTS_PKG.update_row (
221: X_REG_REQUEST_ID => p_reg_request.reg_request_id,
222: X_STATUS_CODE => p_reg_request.status_code,
223: X_REQUESTED_BY_USER_ID => fnd_global.user_id,
224: X_REQUESTED_FOR_USER_ID => p_reg_request.requested_for_user_id,
274: 'fnd.plsql.UMXVRRSB.delete_reg_request.begin',
275: 'regRequestId: ' || p_reg_request_id);
276: end if;
277:
278: UMX_REG_REQUESTS_PKG.DELETE_ROW (X_REG_REQUEST_ID => p_reg_request_id);
279:
280: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
281: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
282: 'fnd.plsql.UMXVRRSB.delete_reg_request.end', 'End');
470: l_requested_by_user_id := l_user_id;
471: end if;
472:
473: -- Update the Reg Requests table
474: UMX_REG_REQUESTS_PKG.update_row (
475: X_REG_REQUEST_ID => p_reg_request_id,
476: X_REQUESTED_BY_USER_ID => l_requested_by_user_id,
477: X_REQUESTED_FOR_USER_ID => l_USER_ID,
478: X_REQUESTED_USERNAME => p_username,
554: x_owner => NULL,
555: x_person_party_id => p_person_party_id);
556:
557: -- Update the record in the Reg Requests table with status and party id
558: UMX_REG_REQUESTS_PKG.update_row (
559: X_REG_REQUEST_ID => p_reg_request_id,
560: X_STATUS_CODE => 'APPROVED',
561: X_REQUESTED_FOR_PARTY_ID => p_person_party_id);
562:
650: -- requested_by_user_id to null.
651: l_requested_by_user_id := fnd_api.g_miss_num;
652: end if;
653:
654: UMX_REG_REQUESTS_PKG.update_row (
655: X_REG_REQUEST_ID => p_reg_request_id,
656: X_STATUS_CODE => p_status_code,
657: X_REQUESTED_FOR_USER_ID => fnd_api.g_miss_num,
658: X_REQUESTED_BY_USER_ID => l_requested_by_user_id);
799: ' | statusCode: ' || p_status_code);
800: end if;
801:
802: -- update the record in the Reg Requests table with status to status_code
803: UMX_REG_REQUESTS_PKG.update_row (X_REG_REQUEST_ID => p_reg_request_id,
804: X_STATUS_CODE => p_status_code);
805:
806: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
807: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,