[Home] [Help]
PACKAGE BODY: APPS.IGW_CREATE_PROPOSAL_PVT
Source
1 PACKAGE BODY Igw_Create_Proposal_Pvt AS
2 --$Header: igwvcprb.pls 120.5 2005/09/12 21:05:54 vmedikon ship $
3
4 ---------------------------------------------------------------------------
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGW_CREATE_PROPOSAL_PVT';
7
8 ---------------------------------------------------------------------------
9
10 PROCEDURE Get_Proposal_Numbering_Method
11 (x_proposal_numbering_method OUT NOCOPY VARCHAR2) IS
12
13
14
15 BEGIN
16
17 null;
18
19 END Get_Proposal_Numbering_Method;
20
21 ---------------------------------------------------------------------------
22
23 FUNCTION Is_Positive_Integer(p_value VARCHAR2) RETURN BOOLEAN IS
24
25
26
27 BEGIN
28
29 RETURN TRUE;
30 END Is_Positive_Integer;
31
32 -----------------------------------------------------------------------------
33
34 FUNCTION Get_Lookup_Code(p_lookup_type VARCHAR2,p_lookup_code VARCHAR2,p_meaning VARCHAR2)
35 RETURN VARCHAR2 IS
36
37 l_api_name CONSTANT VARCHAR2(30) := 'Get_Lookup_Code';
38
39 l_lookup_code fnd_lookups.lookup_code%TYPE;
40
41 BEGIN
42
43 null;
44
45 END Get_Lookup_Code;
46
47 -----------------------------------------------------------------------------
48
49 FUNCTION Get_Party_Id(p_party_type VARCHAR2,p_party_id NUMBER,p_party_name VARCHAR2)
50 RETURN NUMBER IS
51
52 l_api_name CONSTANT VARCHAR2(30) := 'Get_Party_Id';
53
54 l_party_id Hz_Parties.Party_Id%TYPE;
55
56 BEGIN
57
58 null;
59 END Get_Party_Id;
60
61 -----------------------------------------------------------------------------
62
63 FUNCTION Get_Organization_Id(p_organization_id NUMBER,p_org_name VARCHAR2)
64 RETURN NUMBER IS
65
66 l_api_name CONSTANT VARCHAR2(30) := 'Get_Organization_Id';
67
68 l_organization_id Hr_Organization_Units.Organization_Id%TYPE;
69
70 BEGIN
71
72 null;
73
74 END Get_Organization_Id;
75
76 -----------------------------------------------------------------------------
77
78 FUNCTION Get_Proposal_Id(p_proposal_id NUMBER,p_proposal_number VARCHAR2)
79 RETURN NUMBER IS
80
81 l_api_name CONSTANT VARCHAR2(30) := 'Get_Proposal_Id';
82
83 l_proposal_id Igw_Proposals_All.Proposal_Id%TYPE;
84
85 BEGIN
86
87 null;
88
89 END Get_Proposal_Id;
90
91 -----------------------------------------------------------------------------
92
93 PROCEDURE Create_Proposal
94 (
95 p_init_msg_list IN VARCHAR2,
96 p_commit IN VARCHAR2,
97 p_validate_only IN VARCHAR2,
98 p_proposal_number IN igw_proposals_all.proposal_number%TYPE,
99 p_proposal_short_title IN VARCHAR2,
100 p_proposal_title IN igw_proposals_all.proposal_title%TYPE,
101 p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
102 p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
103 p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
104 p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
105 p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,
106 p_proposal_type_meaning IN fnd_lookups.meaning%TYPE,
107 p_activity_type_code IN igw_proposals_all.activity_type_code%type,
108 p_activity_type_meaning IN fnd_lookups.meaning%TYPE,
109 p_proposal_category_code IN VARCHAR2,
110 p_proposal_category_meaning IN fnd_lookups.meaning%TYPE,
111 p_proposal_purpose_code IN VARCHAR2,
112 p_proposal_purpose_meaning IN fnd_lookups.meaning%TYPE,
113 p_cross_cut_type_code IN VARCHAR2,
114 p_cross_cut_type_meaning IN fnd_lookups.meaning%TYPE,
115 p_proposal_url IN VARCHAR2,
116 p_grantor_id IN NUMBER,
117 p_grantor_name IN VARCHAR2,
118 p_proposal_manager_id IN NUMBER,
119 p_proposal_manager_name IN hz_parties.party_name%TYPE,
120 p_signing_official_party_id IN NUMBER,
121 p_signing_official_name IN hz_parties.party_name%TYPE,
122 p_admin_official_party_id IN NUMBER,
123 p_admin_official_name IN hz_parties.party_name%TYPE,
124 p_submitting_organization_id IN igw_proposals_all.submitting_organization_id%TYPE,
125 p_submitting_party_id IN NUMBER,
126 p_lead_organization_id IN NUMBER,
127 p_applicant_unit_name IN VARCHAR2,
128 p_org_id IN igw_proposals_all.org_id%TYPE,
129 p_original_proposal_id IN NUMBER,
130 p_original_proposal_number IN igw_proposals_all.proposal_number%TYPE,
131 p_parent_proposal_id IN NUMBER,
132 p_parent_proposal_number IN igw_proposals_all.proposal_number%TYPE,
133 p_sponsor_application_number IN VARCHAR2,
134 p_external_applicant_unit_id IN NUMBER,
135 p_attribute_category IN igw_proposals_all.attribute_category%TYPE,
136 p_attribute1 IN igw_proposals_all.attribute1%TYPE,
137 p_attribute2 IN igw_proposals_all.attribute2%TYPE,
138 p_attribute3 IN igw_proposals_all.attribute3%TYPE,
139 p_attribute4 IN igw_proposals_all.attribute4%TYPE,
140 p_attribute5 IN igw_proposals_all.attribute5%TYPE,
141 p_attribute6 IN igw_proposals_all.attribute6%TYPE,
142 p_attribute7 IN igw_proposals_all.attribute7%TYPE,
143 p_attribute8 IN igw_proposals_all.attribute8%TYPE,
144 p_attribute9 IN igw_proposals_all.attribute9%TYPE,
145 p_attribute10 IN igw_proposals_all.attribute10%TYPE,
146 p_attribute11 IN igw_proposals_all.attribute11%TYPE,
147 p_attribute12 IN igw_proposals_all.attribute12%TYPE,
148 p_attribute13 IN igw_proposals_all.attribute13%TYPE,
149 p_attribute14 IN igw_proposals_all.attribute14%TYPE,
150 p_attribute15 IN igw_proposals_all.attribute15%TYPE,
151 p_igw_mode IN VARCHAR2,
152 x_proposal_id OUT NOCOPY igw_proposals_all.proposal_id%TYPE,
153 x_proposal_number OUT NOCOPY igw_proposals_all.proposal_number%TYPE,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2
157 ) IS
158
159
160
161
162 BEGIN
163
164 null;
165 END Create_Proposal;
166
167 -----------------------------------------------------------------------------
168
169 END Igw_Create_Proposal_Pvt;