APPS.IGW_PROP_SPECIAL_REVIEWS_TBH dependencies on IGW_PROP_SPECIAL_REVIEWS

Line 1: PACKAGE BODY Igw_Prop_Special_Reviews_Tbh AS

1: PACKAGE BODY Igw_Prop_Special_Reviews_Tbh AS
2: /* $Header: igwtrevb.pls 115.4 2002/11/15 00:45:59 ashkumar ship $ */
3:
4: ---------------------------------------------------------------------------
5:

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

2: /* $Header: igwtrevb.pls 115.4 2002/11/15 00:45:59 ashkumar ship $ */
3:
4: ---------------------------------------------------------------------------
5:
6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_SPECIAL_REVIEWS_TBH';
7:
8: ---------------------------------------------------------------------------
9:
10: PROCEDURE Insert_Row

Line 35: FROM igw_prop_special_reviews

31: l_person_sequence NUMBER;
32:
33: CURSOR c IS
34: SELECT rowid
35: FROM igw_prop_special_reviews
36: WHERE proposal_id = p_proposal_id AND
37: special_review_code = p_special_review_code;
38:
39: BEGIN

Line 56: INSERT INTO igw_prop_special_reviews

52:
53: END IF;
54:
55:
56: INSERT INTO igw_prop_special_reviews
57: (
58: proposal_id,
59: special_review_code,
60: special_review_type,

Line 160: UPDATE igw_prop_special_reviews

156: App_Exception.Raise_Exception;
157:
158: END IF;
159:
160: UPDATE igw_prop_special_reviews
161: SET proposal_id = p_proposal_id,
162: special_review_code = p_special_review_code,
163: special_review_type = p_special_review_type,
164: approval_type_code = p_approval_type_code,

Line 215: DELETE igw_prop_special_reviews

211: BEGIN
212:
213: x_return_status := Fnd_Api.G_Ret_Sts_Success;
214:
215: DELETE igw_prop_special_reviews
216: WHERE rowid = p_rowid
217: AND record_version_number = p_record_version_number;
218:
219: IF SQL%NotFound THEN

Line 245: END Igw_Prop_Special_Reviews_Tbh;

241: END Delete_Row;
242:
243: ---------------------------------------------------------------------------
244:
245: END Igw_Prop_Special_Reviews_Tbh;