APPS.IGW_PROP_ABSTRACTS_PUB dependencies on IGW_PROP_ABSTRACTS

Line 1: PACKAGE BODY Igw_Prop_Abstracts_Pub AS

1: PACKAGE BODY Igw_Prop_Abstracts_Pub AS
2: --$Header: igwpabsb.pls 115.0 2002/12/19 22:43:38 ashkumar noship $
3:
4: ---------------------------------------------------------------------------
5:

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

2: --$Header: igwpabsb.pls 115.0 2002/12/19 22:43:38 ashkumar noship $
3:
4: ---------------------------------------------------------------------------
5:
6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_ABSTRACTS_PUB';
7:
8: ---------------------------------------------------------------------------
9:
10: PROCEDURE Create_Prop_Abstract

Line 24: l_abstract_type_code IGW_PROP_ABSTRACTS.ABSTRACT_TYPE_CODE%TYPE;

20: ) IS
21:
22: l_api_name CONSTANT VARCHAR2(30) := 'Create_Prop_Abstract';
23: l_proposal_id IGW_PROPOSALS_ALL.PROPOSAL_ID%TYPE;
24: l_abstract_type_code IGW_PROP_ABSTRACTS.ABSTRACT_TYPE_CODE%TYPE;
25: l_rowid VARCHAR2(60);
26: l_record_version_number NUMBER;
27:
28: BEGIN

Line 108: Igw_Prop_Abstracts_Pvt.Populate_Prop_Abstracts(l_proposal_id);

104: RAISE Fnd_Api.G_Exc_Error;
105:
106: END IF;
107:
108: Igw_Prop_Abstracts_Pvt.Populate_Prop_Abstracts(l_proposal_id);
109:
110: /*
111: ** Establish Savepoint for Rollback
112: */

Line 120: FROM igw_prop_abstracts

116: SELECT rowid,
117: record_version_number
118: INTO l_rowid,
119: l_record_version_number
120: FROM igw_prop_abstracts
121: WHERE proposal_id = l_proposal_id
122: AND abstract_type = 'IGW_ABSTRACT_TYPES'
123: AND abstract_type_code = l_abstract_type_code;
124:

Line 125: Igw_Prop_Abstracts_Pvt.Update_Prop_Abstract

121: WHERE proposal_id = l_proposal_id
122: AND abstract_type = 'IGW_ABSTRACT_TYPES'
123: AND abstract_type_code = l_abstract_type_code;
124:
125: Igw_Prop_Abstracts_Pvt.Update_Prop_Abstract
126: (
127: p_init_msg_list => Fnd_Api.G_True,
128: p_validate_only => p_validate_only,
129: p_commit => Fnd_Api.G_False,

Line 213: END Igw_Prop_Abstracts_Pub;

209: END Create_Prop_Abstract;
210:
211: ---------------------------------------------------------------------------
212:
213: END Igw_Prop_Abstracts_Pub;