APPS.IGW_PROP_NARRATIVES_TBH dependencies on IGW_PROP_NARRATIVES

Line 1: package body IGW_PROP_NARRATIVES_TBH as

1: package body IGW_PROP_NARRATIVES_TBH as
2: /* $Header: igwtprnb.pls 115.4 2002/11/15 00:39:05 ashkumar ship $*/
3:
4: PROCEDURE INSERT_ROW (
5: X_ROWID OUT NOCOPY VARCHAR2,

Line 18: cursor c is select ROWID from IGW_PROP_NARRATIVES

14: X_RETURN_STATUS OUT NOCOPY VARCHAR2) is
15:
16: L_MODULE_ID NUMBER;
17:
18: cursor c is select ROWID from IGW_PROP_NARRATIVES
19: where proposal_id = p_proposal_id
20: and module_id = l_module_id;
21:
22: l_last_update_date DATE;

Line 53: insert into igw_prop_narratives (

49: app_exception.raise_exception;
50: end if;
51:
52:
53: insert into igw_prop_narratives (
54: PROPOSAL_ID
55: ,MODULE_ID
56: ,MODULE_TITLE
57: ,MODULE_STATUS

Line 70: ,IGW_PROP_NARRATIVES_S.NEXTVAL

66: ,LAST_UPDATE_LOGIN
67: ,RECORD_VERSION_NUMBER
68: ) values (
69: P_PROPOSAL_ID
70: ,IGW_PROP_NARRATIVES_S.NEXTVAL
71: ,P_MODULE_TITLE
72: ,P_MODULE_STATUS
73: ,P_CONTACT_NAME
74: ,P_PHONE_NUMBER

Line 96: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_TBH',

92: close c;
93:
94: EXCEPTION
95: when others then
96: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_TBH',
97: p_procedure_name => 'INSERT_ROW',
98: p_error_text => SUBSTRB(SQLERRM, 1, 240));
99: x_return_status := fnd_api.g_ret_sts_unexp_error;
100: raise;

Line 149: update IGW_PROP_NARRATIVES set

145: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
146: app_exception.raise_exception;
147: end if;
148:
149: update IGW_PROP_NARRATIVES set
150: PROPOSAL_ID = P_PROPOSAL_ID
151: ,MODULE_ID = P_MODULE_ID
152: ,MODULE_TITLE = P_MODULE_TITLE
153: ,MODULE_STATUS = P_MODULE_STATUS

Line 173: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_TBH',

169: end if;
170:
171: EXCEPTION
172: when others then
173: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_TBH',
174: p_procedure_name => 'UPDATE_ROW',
175: p_error_text => SUBSTRB(SQLERRM, 1, 240));
176: x_return_status := fnd_api.g_ret_sts_unexp_error;
177: raise;

Line 192: delete from IGW_PROP_NARRATIVES

188:
189: BEGIN
190: x_return_status := fnd_api.g_ret_sts_success;
191:
192: delete from IGW_PROP_NARRATIVES
193: where rowid = x_rowid
194: and record_version_number = p_record_version_number;
195:
196: if (sql%notfound) then

Line 205: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_TBH',

201:
202:
203: EXCEPTION
204: when others then
205: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_TBH',
206: p_procedure_name => 'DELETE_ROW',
207: p_error_text => SUBSTRB(SQLERRM, 1, 240));
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: raise;

Line 325: END IGW_PROP_NARRATIVES_TBH;

321: return;
322: end LOCK_ROW;
323: */
324:
325: END IGW_PROP_NARRATIVES_TBH;