APPS.IGW_STUDY_TITLES_PVT dependencies on IGW_STUDY_TITLES

Line 1: PACKAGE BODY IGW_STUDY_TITLES_PVT AS

1: PACKAGE BODY IGW_STUDY_TITLES_PVT AS
2: --$Header: igwvsttb.pls 115.8 2002/11/18 19:20:11 ashkumar ship $
3:
4:
5: PROCEDURE CREATE_STUDY_TITLE

Line 73: select IGW_STUDY_TITLES_S.NEXTVAL

69: End if;
70:
71:
72: begin
73: select IGW_STUDY_TITLES_S.NEXTVAL
74: into l_study_title_id
75: from dual;
76: exception
77: when others then

Line 82: IGW_STUDY_TITLES_TBH.INSERT_ROW (

78: x_return_status:= fnd_api.g_ret_sts_unexp_error;
79: raise;
80: end;
81:
82: IGW_STUDY_TITLES_TBH.INSERT_ROW (
83: X_ROWID => x_rowid,
84: X_STUDY_TITLE_ID => l_study_title_id,
85: X_STUDY_TITLE => p_study_title,
86: X_ENROLLMENT_STATUS => p_enrollment_status,

Line 129: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',

125: IF p_commit = FND_API.G_TRUE THEN
126: ROLLBACK TO create_study_title;
127: END IF;
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',
130: p_procedure_name => 'CREATE_STUDY_TITLE');
131: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
132: p_data => x_msg_data);
133: END CREATE_STUDY_TITLE;

Line 226: IGW_STUDY_TITLES_TBH.UPDATE_ROW (

222: RAISE FND_API.G_EXC_ERROR;
223: End if;
224:
225:
226: IGW_STUDY_TITLES_TBH.UPDATE_ROW (
227: X_ROWID => p_rowid,
228: X_STUDY_TITLE_ID => p_study_title_id,
229: X_STUDY_TITLE => p_study_title,
230: X_ENROLLMENT_STATUS => p_enrollment_status,

Line 284: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',

280: IF p_commit = FND_API.G_TRUE THEN
281: ROLLBACK TO update_study_title;
282: END IF;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',
285: p_procedure_name => 'UPDATE_STUDY_TITLE');
286: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
287: p_data => x_msg_data);
288:

Line 340: IGW_STUDY_TITLES_TBH.DELETE_ROW(

336: End if;
337:
338: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
339:
340: IGW_STUDY_TITLES_TBH.DELETE_ROW(
341: x_rowid => x_rowid,
342: x_study_title_id => p_study_title_id,
343: x_record_version_number => p_record_version_number,
344: x_return_status => x_return_status);

Line 393: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',

389: IF p_commit = FND_API.G_TRUE THEN
390: ROLLBACK TO update_study_title;
391: END IF;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',
394: p_procedure_name => 'DELETE_STUDY_TITLE');
395: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
396: p_data => x_msg_data);
397: END;

Line 409: from igw_study_titles

405: l_dummy integer;
406: BEGIN
407: select 1
408: into l_dummy
409: from igw_study_titles
410: where rowid = x_rowid
411: and record_version_number = p_record_version_number;
412:
413: EXCEPTION

Line 422: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',

418: raise fnd_api.g_exc_error;
419:
420: WHEN OTHERS THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_STUDY_TITLES_PVT',
423: p_procedure_name => 'CHECK_LOCK');
424: raise fnd_api.g_exc_unexpected_error;
425:
426:

Line 429: END IGW_STUDY_TITLES_PVT;

425:
426:
427: END CHECK_LOCK;
428:
429: END IGW_STUDY_TITLES_PVT;