APPS.IGW_PROP_PERSONS_TBH dependencies on IGW_PROP_PERSONS

Line 1: PACKAGE BODY Igw_Prop_Persons_Tbh AS

1: PACKAGE BODY Igw_Prop_Persons_Tbh AS
2: /* $Header: igwtperb.pls 115.6 2002/11/15 00:40:41 ashkumar ship $ */
3:
4: ---------------------------------------------------------------------------
5:

Line 6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_PERSONS_TBH';

2: /* $Header: igwtperb.pls 115.6 2002/11/15 00:40:41 ashkumar ship $ */
3:
4: ---------------------------------------------------------------------------
5:
6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_PERSONS_TBH';
7:
8: ---------------------------------------------------------------------------
9:
10: PROCEDURE Insert_Row

Line 36: FROM igw_prop_persons

32: l_person_sequence NUMBER;
33:
34: CURSOR c IS
35: SELECT rowid
36: FROM igw_prop_persons
37: WHERE proposal_id = p_proposal_id AND
38: person_party_id = p_person_party_id;
39:
40: BEGIN

Line 58: FROM igw_prop_persons

54: END IF;
55:
56: SELECT Nvl(Max(person_sequence) + 1,1)
57: INTO l_person_sequence
58: FROM igw_prop_persons
59: WHERE proposal_id = p_proposal_id;
60:
61: INSERT INTO igw_prop_persons
62: (

Line 61: INSERT INTO igw_prop_persons

57: INTO l_person_sequence
58: FROM igw_prop_persons
59: WHERE proposal_id = p_proposal_id;
60:
61: INSERT INTO igw_prop_persons
62: (
63: proposal_id,
64: person_id,
65: person_party_id,

Line 170: UPDATE igw_prop_persons

166: App_Exception.Raise_Exception;
167:
168: END IF;
169:
170: UPDATE igw_prop_persons
171: SET proposal_id = p_proposal_id,
172: person_id = p_person_id,
173: person_party_id = p_person_party_id,
174: proposal_role_code = p_proposal_role_code,

Line 226: DELETE igw_prop_persons

222: BEGIN
223:
224: x_return_status := Fnd_Api.G_Ret_Sts_Success;
225:
226: DELETE igw_prop_persons
227: WHERE rowid = p_rowid
228: AND record_version_number = p_record_version_number;
229:
230: IF SQL%NotFound THEN

Line 256: END Igw_Prop_Persons_Tbh;

252: END Delete_Row;
253:
254: ---------------------------------------------------------------------------
255:
256: END Igw_Prop_Persons_Tbh;