APPS.IGW_PROP_PERSON_QUESTIONS_TBH dependencies on IGW_PROP_PERSON_QUESTIONS

Line 1: package body IGW_PROP_PERSON_QUESTIONS_TBH as

1: package body IGW_PROP_PERSON_QUESTIONS_TBH as
2: /* $Header: igwtppqb.pls 115.5 2002/11/15 00:42:17 ashkumar ship $*/
3:
4: PROCEDURE INSERT_ROW (
5: x_rowid out NOCOPY VARCHAR2,

Line 17: cursor c is select ROWID from IGW_PROP_PERSON_QUESTIONS

13: p_mode in VARCHAR2,
14: x_return_status out NOCOPY VARCHAR2
15: ) is
16:
17: cursor c is select ROWID from IGW_PROP_PERSON_QUESTIONS
18: where proposal_id = p_proposal_id
19: and party_id = p_party_id
20: and question_number = p_question_number;
21:

Line 51: insert into igw_prop_person_questions (

47: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
48: app_exception.raise_exception;
49: end if;
50:
51: insert into igw_prop_person_questions (
52: proposal_id,
53: party_id,
54: person_id,
55: question_number,

Line 91: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_QUESTIONS_TBH',

87: close c;
88:
89: EXCEPTION
90: when others then
91: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_QUESTIONS_TBH',
92: p_procedure_name => 'INSERT_ROW',
93: p_error_text => SUBSTRB(SQLERRM, 1, 240));
94: x_return_status := fnd_api.g_ret_sts_unexp_error;
95: raise;

Line 142: update IGW_PROP_PERSON_QUESTIONS set

138: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
139: app_exception.raise_exception;
140: end if;
141:
142: update IGW_PROP_PERSON_QUESTIONS set
143: proposal_id = p_proposal_id,
144: party_id = p_party_id,
145: person_id = p_person_id,
146: question_number = p_question_number,

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

162:
163:
164: EXCEPTION
165: when others then
166: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_QUESTIONS_TBH',
167: p_procedure_name => 'UPDATE_ROW',
168: p_error_text => SUBSTRB(SQLERRM, 1, 240));
169: x_return_status := fnd_api.g_ret_sts_unexp_error;
170: raise;

Line 184: delete from IGW_PROP_PERSON_QUESTIONS

180:
181: BEGIN
182: x_return_status := fnd_api.g_ret_sts_success;
183:
184: delete from IGW_PROP_PERSON_QUESTIONS
185: where rowid = x_rowid
186: and record_version_number = p_record_version_number;
187:
188: if (sql%notfound) then

Line 197: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_QUESTIONS_TBH',

193:
194:
195: EXCEPTION
196: when others then
197: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_QUESTIONS_TBH',
198: p_procedure_name => 'DELETE_ROW',
199: p_error_text => SUBSTRB(SQLERRM, 1, 240));
200: x_return_status := fnd_api.g_ret_sts_unexp_error;
201: raise;

Line 205: END IGW_PROP_PERSON_QUESTIONS_TBH;

201: raise;
202:
203: END DELETE_ROW;
204:
205: END IGW_PROP_PERSON_QUESTIONS_TBH;