APPS.IGW_PROP_USER_ROLES_TBH dependencies on IGW_PROP_USER_ROLES

Line 1: package body IGW_PROP_USER_ROLES_TBH as

1: package body IGW_PROP_USER_ROLES_TBH as
2: /* $Header: igwtpurb.pls 115.4 2002/11/15 00:47:12 ashkumar ship $*/
3:
4: PROCEDURE INSERT_ROW (
5: x_rowid out NOCOPY VARCHAR2,

Line 13: cursor c is select ROWID from IGW_PROP_USER_ROLES

9: p_mode in VARCHAR2 default 'R',
10: x_return_status out NOCOPY VARCHAR2
11: ) is
12:
13: cursor c is select ROWID from IGW_PROP_USER_ROLES
14: where proposal_id = p_proposal_id
15: and user_id = p_user_id
16: and role_id = p_role_id;
17:

Line 47: insert into igw_prop_user_roles (

43: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
44: app_exception.raise_exception;
45: end if;
46:
47: insert into igw_prop_user_roles (
48: proposal_id,
49: user_id,
50: role_id,
51: last_update_date,

Line 79: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_TBH',

75: close c;
76:
77: EXCEPTION
78: when others then
79: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_TBH',
80: p_procedure_name => 'INSERT_ROW',
81: p_error_text => SUBSTRB(SQLERRM, 1, 240));
82: x_return_status := fnd_api.g_ret_sts_unexp_error;
83: raise;

Line 127: update IGW_PROP_USER_ROLES set

123: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
124: app_exception.raise_exception;
125: end if;
126:
127: update IGW_PROP_USER_ROLES set
128: proposal_id = p_proposal_id,
129: user_id = p_user_id,
130: role_id = p_role_id,
131: last_update_date = l_last_update_date,

Line 146: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_TBH',

142: end if;
143:
144: EXCEPTION
145: when others then
146: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_TBH',
147: p_procedure_name => 'UPDATE_ROW',
148: p_error_text => SUBSTRB(SQLERRM, 1, 240));
149: x_return_status := fnd_api.g_ret_sts_unexp_error;
150: raise;

Line 164: delete from IGW_PROP_USER_ROLES

160:
161: BEGIN
162: x_return_status := fnd_api.g_ret_sts_success;
163:
164: delete from IGW_PROP_USER_ROLES
165: where rowid = x_rowid
166: and record_version_number = p_record_version_number;
167:
168: if (sql%notfound) then

Line 177: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_TBH',

173:
174:
175: EXCEPTION
176: when others then
177: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_TBH',
178: p_procedure_name => 'DELETE_ROW',
179: p_error_text => SUBSTRB(SQLERRM, 1, 240));
180: x_return_status := fnd_api.g_ret_sts_unexp_error;
181: raise;

Line 296: END IGW_PROP_USER_ROLES_TBH;

292: return;
293: end LOCK_ROW;
294: */
295:
296: END IGW_PROP_USER_ROLES_TBH;