APPS.IGW_PROP_USERS_PVT dependencies on IGW_PROP_USERS

Line 1: PACKAGE BODY IGW_PROP_USERS_PVT as

1: PACKAGE BODY IGW_PROP_USERS_PVT as
2: /* $Header: igwvprub.pls 115.9 2002/11/15 00:46:16 ashkumar ship $*/
3: PROCEDURE create_prop_user (
4: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 124: igw_prop_users_tbh.insert_row (

120: check_errors;
121:
122: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
123:
124: igw_prop_users_tbh.insert_row (
125: x_rowid => x_rowid,
126: p_proposal_id => l_proposal_id,
127: p_user_id => l_user_id,
128: p_start_date_active => p_start_date_active,

Line 166: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',

162: END IF;
163:
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
165:
166: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',
167: p_procedure_name => 'CREATE_PROP_USER',
168: p_error_text => SUBSTRB(SQLERRM,1,240));
169:
170: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 227: -- get proposal_id, user_id from igw_prop_users using x_rowid and record_version_number

223:
224: -- initialize return_status to success
225: x_return_status := fnd_api.g_ret_sts_success;
226:
227: -- get proposal_id, user_id from igw_prop_users using x_rowid and record_version_number
228: -- and also check locking. The columns fetched are the old data, i.e., the data that is being overwritten
229: CHECK_LOCK_GET_COLS
230: (x_rowid => x_rowid
231: ,p_record_version_number => p_record_version_number

Line 335: igw_prop_users_tbh.update_row (

331:
332: check_errors;
333:
334: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
335: igw_prop_users_tbh.update_row (
336: x_rowid => x_rowid,
337: p_proposal_id => l_proposal_id2,
338: p_user_id => l_user_id2,
339: p_start_date_active => p_start_date_active,

Line 388: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',

384: END IF;
385:
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',
389: p_procedure_name => 'UPDATE_PROP_USER',
390: p_error_text => SUBSTRB(SQLERRM,1,240));
391:
392: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 436: -- get proposal_id, user_id, role_id from igw_prop_users using x_rowid and record_version_number

432:
433: -- initialize return_status to sucess
434: x_return_status := fnd_api.g_ret_sts_success;
435:
436: -- get proposal_id, user_id, role_id from igw_prop_users using x_rowid and record_version_number
437: -- and also check locking
438: CHECK_LOCK_GET_COLS
439: (x_rowid => x_rowid
440: ,p_record_version_number => p_record_version_number

Line 468: igw_prop_users_tbh.delete_row (

464:
465: check_errors;
466:
467: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
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

Line 509: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',

505: END IF;
506:
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508:
509: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',
510: p_procedure_name => 'DELETE_PROP_USER',
511: p_error_text => SUBSTRB(SQLERRM,1,240));
512:
513: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 565: from igw_prop_users

561:
562: BEGIN
563: select proposal_id, user_id, start_date_active, end_date_active
564: into x_proposal_id, x_user_id, x_start_date_active, x_end_date_active
565: from igw_prop_users
566: where rowid = x_rowid
567: and record_version_number = p_record_version_number;
568:
569: EXCEPTION

Line 578: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',

574: raise fnd_api.g_exc_error;
575:
576: WHEN OTHERS THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_PVT',
579: p_procedure_name => 'CHECK_LOCK_GET_PK',
580: p_error_text => SUBSTRB(SQLERRM,1,240));
581: raise fnd_api.g_exc_unexpected_error;
582:

Line 597: END IGW_PROP_USERS_PVT;

593: END IF;
594:
595: END CHECK_ERRORS;
596:
597: END IGW_PROP_USERS_PVT;