DBA Data[Home] [Help]

APPS.UMX_REG_REQUESTS_PVT dependencies on UMX_REG_REQUESTS_PKG

Line 220: UMX_REG_REQUESTS_PKG.update_row (

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,

Line 278: UMX_REG_REQUESTS_PKG.DELETE_ROW (X_REG_REQUEST_ID => p_reg_request_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');

Line 474: UMX_REG_REQUESTS_PKG.update_row (

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,

Line 706: UMX_REG_REQUESTS_PKG.update_row (

702:
703:
704:
705: -- Update the record in the Reg Requests table with status and party id
706: UMX_REG_REQUESTS_PKG.update_row (
707: X_REG_REQUEST_ID => p_reg_request_id,
708: X_STATUS_CODE => 'APPROVED',
709: X_REQUESTED_FOR_PARTY_ID => p_person_party_id);
710:

Line 802: UMX_REG_REQUESTS_PKG.update_row (

798: -- requested_by_user_id to null.
799: l_requested_by_user_id := fnd_api.g_miss_num;
800: end if;
801:
802: UMX_REG_REQUESTS_PKG.update_row (
803: X_REG_REQUEST_ID => p_reg_request_id,
804: X_STATUS_CODE => p_status_code,
805: X_REQUESTED_FOR_USER_ID => fnd_api.g_miss_num,
806: X_REQUESTED_BY_USER_ID => l_requested_by_user_id);

Line 951: UMX_REG_REQUESTS_PKG.update_row (X_REG_REQUEST_ID => p_reg_request_id,

947: ' | statusCode: ' || p_status_code);
948: end if;
949:
950: -- update the record in the Reg Requests table with status to status_code
951: UMX_REG_REQUESTS_PKG.update_row (X_REG_REQUEST_ID => p_reg_request_id,
952: X_STATUS_CODE => p_status_code);
953:
954: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
955: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,