APPS.IGW_PROP_USERS_PVT dependencies on IGW_PROP_USER_ROLES

Line 102: IGW_PROP_USER_ROLES_PVT.VALIDATE_LOGGED_USER_RIGHTS

98:
99: -------------------------------------------- validations -----------------------------------------------------
100: -- validate that the user who has logged on has the rights to modify user
101:
102: IGW_PROP_USER_ROLES_PVT.VALIDATE_LOGGED_USER_RIGHTS
103: (p_proposal_id => l_proposal_id
104: ,p_logged_user_id => p_logged_user_id
105: ,x_return_status => x_return_status);
106: check_errors;

Line 242: IGW_PROP_USER_ROLES_PVT.VALIDATE_LOGGED_USER_RIGHTS

238: check_errors;
239:
240: -- first validate that the user who has logged on has the rights to modify user roles
241:
242: IGW_PROP_USER_ROLES_PVT.VALIDATE_LOGGED_USER_RIGHTS
243: (p_proposal_id => l_proposal_id
244: ,p_logged_user_id => p_logged_user_id
245: ,x_return_status => x_return_status);
246:

Line 345: -- also update the detail records in igw_prop_user_roles

341: p_record_version_number => p_record_version_number,
342: p_mode => 'R',
343: x_return_status => l_return_status);
344:
345: -- also update the detail records in igw_prop_user_roles
346: if ((l_proposal_id <> l_proposal_id2) OR (l_user_id <> l_user_id2)) then
347: update igw_prop_user_roles
348: set proposal_id = l_proposal_id2,
349: user_id = l_user_id2

Line 347: update igw_prop_user_roles

343: x_return_status => l_return_status);
344:
345: -- also update the detail records in igw_prop_user_roles
346: if ((l_proposal_id <> l_proposal_id2) OR (l_user_id <> l_user_id2)) then
347: update igw_prop_user_roles
348: set proposal_id = l_proposal_id2,
349: user_id = l_user_id2
350: where proposal_id = l_proposal_id
351: and user_id = l_user_id;

Line 449: IGW_PROP_USER_ROLES_PVT.VALIDATE_LOGGED_USER_RIGHTS

445: ,x_return_status => x_return_status);
446:
447: -- validate that the user who has logged on has the rights to modify user roles
448:
449: IGW_PROP_USER_ROLES_PVT.VALIDATE_LOGGED_USER_RIGHTS
450: (p_proposal_id => l_proposal_id
451: ,p_logged_user_id => p_logged_user_id
452: ,x_return_status => x_return_status);
453:

Line 472: -- also delete the child rows in igw_prop_user_roles

468: igw_prop_users_tbh.delete_row (
469: x_rowid => x_rowid,
470: p_record_version_number => p_record_version_number,
471: x_return_status => l_return_status);
472: -- also delete the child rows in igw_prop_user_roles
473: delete from igw_prop_user_roles
474: where proposal_id = l_proposal_id
475: and user_id = l_user_id;
476:

Line 473: delete from igw_prop_user_roles

469: x_rowid => x_rowid,
470: p_record_version_number => p_record_version_number,
471: x_return_status => l_return_status);
472: -- also delete the child rows in igw_prop_user_roles
473: delete from igw_prop_user_roles
474: where proposal_id = l_proposal_id
475: and user_id = l_user_id;
476:
477: end if;

Line 531: from igw_prop_user_roles

527: BEGIN
528: x_return_status:= FND_API.G_RET_STS_SUCCESS;
529:
530: select count(*) into N
531: from igw_prop_user_roles
532: where proposal_id = p_proposal_id
533: and user_id = p_user_id
534: and role_id in (select role_id from igw_roles where seeded_flag = 'Y');
535:

Line 546: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PVT',

542:
543: EXCEPTION
544: WHEN OTHERS THEN
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_PVT',
547: p_procedure_name => 'CHECK_IF_SEEDED_ROLE',
548: p_error_text => SUBSTRB(SQLERRM,1,240));
549: raise fnd_api.g_exc_unexpected_error;
550: END CHECK_IF_USER_HAS_SEEDED_ROLE;