1 PACKAGE IGW_PROPOSALS_ALL_PVT AS
2 --$Header: igwvbass.pls 120.3 2005/10/30 05:50:33 appldev ship $
3
4 /*
5 PROCEDURE CREATE_PROPOSAL
6 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
7 , p_commit IN VARCHAR2 := FND_API.G_FALSE
8 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
9 , p_proposal_number IN VARCHAR2
10 , p_proposal_title IN VARCHAR2
11 , p_proposal_start_date IN DATE
12 , p_proposal_end_date IN DATE
13 , p_proposal_status_code IN VARCHAR2
14 , p_proposal_status IN VARCHAR2
15 , p_proposal_type_code IN VARCHAR2
16 , p_proposal_type IN VARCHAR2
17 , p_activity_type_code IN VARCHAR2
18 , p_activity_type IN VARCHAR2
19 , p_submitting_organization_id IN NUMBER
20 , p_submitting_organization_name IN VARCHAR2
21 , p_sponsor_id IN NUMBER
22 , p_sponsor_name IN VARCHAR2
23 , p_proposal_manager_id IN NUMBER
24 , p_proposal_manager_name IN VARCHAR2
25 , p_funding_sponsor_unit IN VARCHAR2
26 , p_original_sponsor_id IN NUMBER
27 , p_original_sponsor_name IN VARCHAR2
28 , p_original_proposal_number IN VARCHAR2
29 , p_original_award_number IN VARCHAR2
30 , p_user_id IN NUMBER
31 , p_user_name IN VARCHAR2
32 , p_signing_official_id IN NUMBER
33 , p_signing_official_name IN VARCHAR2
34 , p_admin_official_id IN NUMBER
35 , p_admin_official_name IN VARCHAR2
36 , p_attribute_category IN VARCHAR2 := null
37 , p_attribute1 IN VARCHAR2 := null
38 , p_attribute2 IN VARCHAR2 := null
39 , p_attribute3 IN VARCHAR2 := null
40 , p_attribute4 IN VARCHAR2 := null
41 , p_attribute5 IN VARCHAR2 := null
42 , p_attribute6 IN VARCHAR2 := null
43 , p_attribute7 IN VARCHAR2 := null
44 , p_attribute8 IN VARCHAR2 := null
45 , p_attribute9 IN VARCHAR2 := null
46 , p_attribute10 IN VARCHAR2 := null
47 , p_attribute11 IN VARCHAR2 := null
48 , p_attribute12 IN VARCHAR2 := null
49 , p_attribute13 IN VARCHAR2 := null
50 , p_attribute14 IN VARCHAR2 := null
51 , p_attribute15 IN VARCHAR2 := null
52 , x_proposal_id OUT NOCOPY NUMBER
53 , x_rowid OUT NOCOPY ROWID
54 , x_return_status OUT NOCOPY VARCHAR2
55 , x_msg_count OUT NOCOPY NUMBER
56 , x_msg_data OUT NOCOPY VARCHAR2) ;
57 */
58
59 --
60
61 PROCEDURE UPDATE_PROPOSAL_BASIC_INFO
62 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
63 , p_commit IN VARCHAR2 := FND_API.G_FALSE
64 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
65 , p_proposal_id IN NUMBER
66 , p_proposal_number IN VARCHAR2
67 , p_proposal_title IN VARCHAR2
68 , p_proposal_start_date IN DATE
69 , p_proposal_end_date IN DATE
70 , p_proposal_status_code IN VARCHAR2
71 , p_proposal_status IN VARCHAR2
72 , p_proposal_type_code IN VARCHAR2
73 , p_proposal_type IN VARCHAR2
74 , p_activity_type_code IN VARCHAR2
75 , p_activity_type IN VARCHAR2
76 , p_lead_organization_id IN NUMBER
77 , p_lead_organization_name IN VARCHAR2
78 , p_submitting_organization_id IN NUMBER
79 , p_submitting_organization_name IN VARCHAR2
80 , p_sponsor_id IN NUMBER
81 , p_sponsor_name IN VARCHAR2
82 , p_proposal_manager_id IN NUMBER
83 , p_proposal_manager_name IN VARCHAR2
84 , p_funding_sponsor_unit IN VARCHAR2
85 , p_original_sponsor_id IN NUMBER
86 , p_original_sponsor_name IN VARCHAR2
87 , p_original_proposal_number IN VARCHAR2
88 , p_original_award_number IN VARCHAR2
89 , p_original_proposal_start_date IN DATE
90 , p_original_proposal_end_date IN DATE
91 , p_user_id IN NUMBER
92 , p_user_name IN VARCHAR2
93 , p_signing_official_id IN NUMBER
94 , p_signing_official_name IN VARCHAR2
95 , p_admin_official_id IN NUMBER
96 , p_admin_official_name IN VARCHAR2
97 , p_record_version_number IN NUMBER
98 , p_rowid IN ROWID
99 , p_attribute_category IN VARCHAR2 := null
100 , p_attribute1 IN VARCHAR2 := null
101 , p_attribute2 IN VARCHAR2 := null
102 , p_attribute3 IN VARCHAR2 := null
103 , p_attribute4 IN VARCHAR2 := null
104 , p_attribute5 IN VARCHAR2 := null
105 , p_attribute6 IN VARCHAR2 := null
106 , p_attribute7 IN VARCHAR2 := null
107 , p_attribute8 IN VARCHAR2 := null
108 , p_attribute9 IN VARCHAR2 := null
109 , p_attribute10 IN VARCHAR2 := null
110 , p_attribute11 IN VARCHAR2 := null
111 , p_attribute12 IN VARCHAR2 := null
112 , p_attribute13 IN VARCHAR2 := null
113 , p_attribute14 IN VARCHAR2 := null
114 , p_attribute15 IN VARCHAR2 := null
115 , x_sponsor_id OUT NOCOPY NUMBER
116 , x_return_status OUT NOCOPY VARCHAR2
117 , x_msg_count OUT NOCOPY NUMBER
118 , x_msg_data OUT NOCOPY VARCHAR2);
119
120
121
122
123 PROCEDURE UPDATE_PROPOSAL_PROGRAM
124 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125 , p_commit IN VARCHAR2 := FND_API.G_FALSE
126 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
127 , p_proposal_id IN NUMBER
128 , p_proposal_number IN VARCHAR2
129 , p_notice_opportunity_code IN VARCHAR2
130 , p_notice_opportunity IN VARCHAR2
131 , p_program_number IN VARCHAR2
132 , p_program_title IN VARCHAR2
133 , p_program_url IN VARCHAR2
134 , p_deadline_date IN DATE
135 , p_deadline_type IN VARCHAR2
136 , p_letter_of_intent_due_date IN DATE
137 , p_record_version_number IN NUMBER
138 , p_rowid IN ROWID
139 , x_return_status OUT NOCOPY VARCHAR2
140 , x_msg_count OUT NOCOPY NUMBER
141 , x_msg_data OUT NOCOPY VARCHAR2);
142
143
144 PROCEDURE DELETE_PROPOSAL
145 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
146 , p_commit IN VARCHAR2 := FND_API.G_FALSE
147 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
148 , p_rowid IN ROWID
149 , p_proposal_id IN NUMBER
150 , x_return_status OUT NOCOPY VARCHAR2
151 , x_msg_count OUT NOCOPY NUMBER
152 , x_msg_data OUT NOCOPY VARCHAR2);
153
154
155
156
157 PROCEDURE UPDATE_SPONSOR_ACTION
158 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
159 , p_commit IN VARCHAR2 := FND_API.G_FALSE
160 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
161 , p_proposal_id IN NUMBER
162 , p_sponsor_action_date IN DATE
163 , p_sponsor_action_code IN VARCHAR2
164 , p_award_number IN VARCHAR2
165 , p_award_amount IN NUMBER
166 , p_record_version_number IN NUMBER
167 , p_rowid IN ROWID
168 , x_return_status OUT NOCOPY VARCHAR2
169 , x_msg_count OUT NOCOPY NUMBER
170 , x_msg_data OUT NOCOPY VARCHAR2);
171
172
173 END IGW_PROPOSALS_ALL_PVT;