1: PACKAGE BODY Igw_Prop_Special_Reviews_Pub AS
2: --$Header: igwprevb.pls 115.0 2002/12/19 22:44:07 ashkumar noship $
3:
4: ---------------------------------------------------------------------------
5:
2: --$Header: igwprevb.pls 115.0 2002/12/19 22:44:07 ashkumar noship $
3:
4: ---------------------------------------------------------------------------
5:
6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_SPECIAL_REVIEWS_PUB';
7:
8: ---------------------------------------------------------------------------
9:
10: PROCEDURE Create_Prop_Special_Review
26:
27: l_api_name CONSTANT VARCHAR2(30) := 'Create_Prop_Special_Review';
28: l_rowid VARCHAR2(60);
29: l_proposal_id IGW_PROPOSALS_ALL.PROPOSAL_ID%TYPE;
30: l_special_review_code IGW_PROP_SPECIAL_REVIEWS.SPECIAL_REVIEW_CODE%TYPE;
31: l_special_review_type IGW_PROP_SPECIAL_REVIEWS.SPECIAL_REVIEW_TYPE%TYPE;
32: l_approval_type_code IGW_PROP_SPECIAL_REVIEWS.APPROVAL_TYPE_CODE%TYPE;
33:
34: BEGIN
27: l_api_name CONSTANT VARCHAR2(30) := 'Create_Prop_Special_Review';
28: l_rowid VARCHAR2(60);
29: l_proposal_id IGW_PROPOSALS_ALL.PROPOSAL_ID%TYPE;
30: l_special_review_code IGW_PROP_SPECIAL_REVIEWS.SPECIAL_REVIEW_CODE%TYPE;
31: l_special_review_type IGW_PROP_SPECIAL_REVIEWS.SPECIAL_REVIEW_TYPE%TYPE;
32: l_approval_type_code IGW_PROP_SPECIAL_REVIEWS.APPROVAL_TYPE_CODE%TYPE;
33:
34: BEGIN
35:
28: l_rowid VARCHAR2(60);
29: l_proposal_id IGW_PROPOSALS_ALL.PROPOSAL_ID%TYPE;
30: l_special_review_code IGW_PROP_SPECIAL_REVIEWS.SPECIAL_REVIEW_CODE%TYPE;
31: l_special_review_type IGW_PROP_SPECIAL_REVIEWS.SPECIAL_REVIEW_TYPE%TYPE;
32: l_approval_type_code IGW_PROP_SPECIAL_REVIEWS.APPROVAL_TYPE_CODE%TYPE;
33:
34: BEGIN
35:
36: /*
134: RAISE Fnd_Api.G_Exc_Error;
135:
136: END IF;
137:
138: Igw_Prop_Special_Reviews_Pvt.Create_Prop_Special_Reviews
139: (
140: p_init_msg_list => Fnd_Api.G_True,
141: p_commit => Fnd_Api.G_False,
142: p_validate_only => p_validate_only,
211: END Create_Prop_Special_Review;
212:
213: ---------------------------------------------------------------------------
214:
215: END Igw_Prop_Special_Reviews_Pub;