89: -- Parameters
90: --
91: -- IN
92: -- p_api_version_number IN NUMBER Required
93: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
94: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
95: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
96: -- p_prgm_contracts_rec IN prgm_contracts_rec_type Required
97: --
90: --
91: -- IN
92: -- p_api_version_number IN NUMBER Required
93: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
94: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
95: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
96: -- p_prgm_contracts_rec IN prgm_contracts_rec_type Required
97: --
98: -- OUT
91: -- IN
92: -- p_api_version_number IN NUMBER Required
93: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
94: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
95: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
96: -- p_prgm_contracts_rec IN prgm_contracts_rec_type Required
97: --
98: -- OUT
99: -- x_return_status OUT VARCHAR2
107: -- ==============================================================================
108: --
109: PROCEDURE Create_Prgm_Contracts(
110: p_api_version_number IN NUMBER
111: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
112: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
113: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
114:
115: ,x_return_status OUT NOCOPY VARCHAR2
108: --
109: PROCEDURE Create_Prgm_Contracts(
110: p_api_version_number IN NUMBER
111: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
112: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
113: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
114:
115: ,x_return_status OUT NOCOPY VARCHAR2
116: ,x_msg_count OUT NOCOPY NUMBER
109: PROCEDURE Create_Prgm_Contracts(
110: p_api_version_number IN NUMBER
111: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
112: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
113: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
114:
115: ,x_return_status OUT NOCOPY VARCHAR2
116: ,x_msg_count OUT NOCOPY NUMBER
117: ,x_msg_data OUT NOCOPY VARCHAR2
135: -- Parameters
136: --
137: -- IN
138: -- p_api_version_number IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
140: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
142: -- p_prgm_contracts_rec IN prgm_contracts_rec_type Required
143: --
136: --
137: -- IN
138: -- p_api_version_number IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
140: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
142: -- p_prgm_contracts_rec IN prgm_contracts_rec_type Required
143: --
144: -- OUT
137: -- IN
138: -- p_api_version_number IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
140: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
142: -- p_prgm_contracts_rec IN prgm_contracts_rec_type Required
143: --
144: -- OUT
145: -- x_return_status OUT VARCHAR2
153: -- ==============================================================================
154: --
155: PROCEDURE Update_Prgm_Contracts(
156: p_api_version_number IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160:
161: ,x_return_status OUT NOCOPY VARCHAR2
154: --
155: PROCEDURE Update_Prgm_Contracts(
156: p_api_version_number IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160:
161: ,x_return_status OUT NOCOPY VARCHAR2
162: ,x_msg_count OUT NOCOPY NUMBER
155: PROCEDURE Update_Prgm_Contracts(
156: p_api_version_number IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160:
161: ,x_return_status OUT NOCOPY VARCHAR2
162: ,x_msg_count OUT NOCOPY NUMBER
163: ,x_msg_data OUT NOCOPY VARCHAR2
181: -- Parameters
182: --
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
188: -- p_program_contracts_id IN NUMBER
189: -- p_object_version_number IN NUMBER Optional Default = NULL
182: --
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
188: -- p_program_contracts_id IN NUMBER
189: -- p_object_version_number IN NUMBER Optional Default = NULL
190: --
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
188: -- p_program_contracts_id IN NUMBER
189: -- p_object_version_number IN NUMBER Optional Default = NULL
190: --
191: -- OUT
200: -- ==============================================================================
201: --
202: PROCEDURE Delete_Prgm_Contracts(
203: p_api_version_number IN NUMBER
204: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
205: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
206: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
207: ,x_return_status OUT NOCOPY VARCHAR2
208: ,x_msg_count OUT NOCOPY NUMBER
201: --
202: PROCEDURE Delete_Prgm_Contracts(
203: p_api_version_number IN NUMBER
204: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
205: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
206: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
207: ,x_return_status OUT NOCOPY VARCHAR2
208: ,x_msg_count OUT NOCOPY NUMBER
209: ,x_msg_data OUT NOCOPY VARCHAR2
202: PROCEDURE Delete_Prgm_Contracts(
203: p_api_version_number IN NUMBER
204: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
205: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
206: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
207: ,x_return_status OUT NOCOPY VARCHAR2
208: ,x_msg_count OUT NOCOPY NUMBER
209: ,x_msg_data OUT NOCOPY VARCHAR2
210: ,p_program_contracts_id IN NUMBER
223: -- Parameters
224: --
225: -- IN
226: -- p_api_version_number IN NUMBER Required
227: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
228: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
229: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
230: -- p_prgm_contracts_rec IN prgm_contracts_rec_type Required
231: --
224: --
225: -- IN
226: -- p_api_version_number IN NUMBER Required
227: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
228: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
229: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
230: -- p_prgm_contracts_rec IN prgm_contracts_rec_type Required
231: --
232: -- OUT
225: -- IN
226: -- p_api_version_number IN NUMBER Required
227: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
228: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
229: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
230: -- p_prgm_contracts_rec IN prgm_contracts_rec_type Required
231: --
232: -- OUT
233: -- x_return_status OUT VARCHAR2
241: -- ==============================================================================
242: --
243: PROCEDURE Lock_Prgm_Contracts(
244: p_api_version_number IN NUMBER
245: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
246:
247: ,x_return_status OUT NOCOPY VARCHAR2
248: ,x_msg_count OUT NOCOPY NUMBER
249: ,x_msg_data OUT NOCOPY VARCHAR2
270: -- ======================================================================
271:
272: PROCEDURE Validate_Prgm_Contracts(
273: p_api_version_number IN NUMBER
274: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
275: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
276: ,p_prgm_contracts_rec IN prgm_contracts_rec_type
277: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
278:
271:
272: PROCEDURE Validate_Prgm_Contracts(
273: p_api_version_number IN NUMBER
274: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
275: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
276: ,p_prgm_contracts_rec IN prgm_contracts_rec_type
277: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
278:
279: ,x_return_status OUT NOCOPY VARCHAR2
324: -- End of Comments
325: -- ==============================================================================
326: PROCEDURE Validate_Rec(
327: p_api_version_number IN NUMBER
328: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
329:
330: ,x_return_status OUT NOCOPY VARCHAR2
331: ,x_msg_count OUT NOCOPY NUMBER
332: ,x_msg_data OUT NOCOPY VARCHAR2