APPS.IGW_PROP_USERS_TBH dependencies on IGW_PROP_USERS

Line 1: package body IGW_PROP_USERS_TBH as

1: package body IGW_PROP_USERS_TBH as
2: /* $Header: igwtprub.pls 115.4 2002/11/15 00:46:34 ashkumar ship $*/
3:
4: PROCEDURE INSERT_ROW (
5: x_rowid out NOCOPY VARCHAR2,

Line 14: cursor c is select ROWID from IGW_PROP_USERS

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

Line 47: insert into igw_prop_users (

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

Line 81: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_TBH',

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

Line 129: update IGW_PROP_USERS set

125: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
126: app_exception.raise_exception;
127: end if;
128:
129: update IGW_PROP_USERS set
130: proposal_id = p_proposal_id,
131: user_id = p_user_id,
132: start_date_active = p_start_date_active,
133: end_date_active = p_end_date_active,

Line 150: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_TBH',

146:
147:
148: EXCEPTION
149: when others then
150: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_TBH',
151: p_procedure_name => 'UPDATE_ROW',
152: p_error_text => SUBSTRB(SQLERRM, 1, 240));
153: x_return_status := fnd_api.g_ret_sts_unexp_error;
154: raise;

Line 168: delete from IGW_PROP_USERS

164:
165: BEGIN
166: x_return_status := fnd_api.g_ret_sts_success;
167:
168: delete from IGW_PROP_USERS
169: where rowid = x_rowid
170: and record_version_number = p_record_version_number;
171:
172: if (sql%notfound) then

Line 181: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_TBH',

177:
178:
179: EXCEPTION
180: when others then
181: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_TBH',
182: p_procedure_name => 'DELETE_ROW',
183: p_error_text => SUBSTRB(SQLERRM, 1, 240));
184: x_return_status := fnd_api.g_ret_sts_unexp_error;
185: raise;

Line 299: END IGW_PROP_USERS_TBH;

295: return;
296: end LOCK_ROW;
297: */
298:
299: END IGW_PROP_USERS_TBH;