78: -- Parameters
79: --
80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type Required
86: --
79: --
80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type Required
86: --
87: -- OUT
80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type Required
86: --
87: -- OUT
88: -- x_return_status OUT VARCHAR2
96: -- ==============================================================================
97: --
98: PROCEDURE Create_Prgm_Ptr_Type(
99: p_api_version_number IN NUMBER
100: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
101: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
102: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
103: ,x_return_status OUT NOCOPY VARCHAR2
104: ,x_msg_count OUT NOCOPY NUMBER
97: --
98: PROCEDURE Create_Prgm_Ptr_Type(
99: p_api_version_number IN NUMBER
100: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
101: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
102: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
103: ,x_return_status OUT NOCOPY VARCHAR2
104: ,x_msg_count OUT NOCOPY NUMBER
105: ,x_msg_data OUT NOCOPY VARCHAR2
98: PROCEDURE Create_Prgm_Ptr_Type(
99: p_api_version_number IN NUMBER
100: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
101: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
102: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
103: ,x_return_status OUT NOCOPY VARCHAR2
104: ,x_msg_count OUT NOCOPY NUMBER
105: ,x_msg_data OUT NOCOPY VARCHAR2
106: ,p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type := g_miss_prgm_ptr_types_rec
123: -- Parameters
124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type Required
131: --
124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type Required
131: --
132: -- OUT
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type Required
131: --
132: -- OUT
133: -- x_return_status OUT VARCHAR2
141: -- ==============================================================================
142: --
143: PROCEDURE Update_Prgm_Ptr_Type(
144: p_api_version_number IN NUMBER
145: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
146: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
147: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
148: ,x_return_status OUT NOCOPY VARCHAR2
149: ,x_msg_count OUT NOCOPY NUMBER
142: --
143: PROCEDURE Update_Prgm_Ptr_Type(
144: p_api_version_number IN NUMBER
145: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
146: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
147: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
148: ,x_return_status OUT NOCOPY VARCHAR2
149: ,x_msg_count OUT NOCOPY NUMBER
150: ,x_msg_data OUT NOCOPY VARCHAR2
143: PROCEDURE Update_Prgm_Ptr_Type(
144: p_api_version_number IN NUMBER
145: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
146: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
147: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
148: ,x_return_status OUT NOCOPY VARCHAR2
149: ,x_msg_count OUT NOCOPY NUMBER
150: ,x_msg_data OUT NOCOPY VARCHAR2
151: ,p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type
166: -- Parameters
167: --
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_program_partner_types_id IN NUMBER
174: -- p_object_version_number IN NUMBER Optional Default = NULL
167: --
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_program_partner_types_id IN NUMBER
174: -- p_object_version_number IN NUMBER Optional Default = NULL
175: --
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_program_partner_types_id IN NUMBER
174: -- p_object_version_number IN NUMBER Optional Default = NULL
175: --
176: -- OUT
185: -- ==============================================================================
186: --
187: PROCEDURE Delete_Prgm_Ptr_Type(
188: p_api_version_number IN NUMBER
189: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
190: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
191: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
192: ,x_return_status OUT NOCOPY VARCHAR
193: ,x_msg_count OUT NOCOPY NUMBER
186: --
187: PROCEDURE Delete_Prgm_Ptr_Type(
188: p_api_version_number IN NUMBER
189: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
190: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
191: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
192: ,x_return_status OUT NOCOPY VARCHAR
193: ,x_msg_count OUT NOCOPY NUMBER
194: ,x_msg_data OUT NOCOPY VARCHAR2
187: PROCEDURE Delete_Prgm_Ptr_Type(
188: p_api_version_number IN NUMBER
189: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
190: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
191: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
192: ,x_return_status OUT NOCOPY VARCHAR
193: ,x_msg_count OUT NOCOPY NUMBER
194: ,x_msg_data OUT NOCOPY VARCHAR2
195: ,p_program_partner_types_id IN NUMBER
212: -- Parameters
213: --
214: -- IN
215: -- p_api_version_number IN NUMBER Required
216: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
218: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
219: -- p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type Required
220: --
213: --
214: -- IN
215: -- p_api_version_number IN NUMBER Required
216: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
218: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
219: -- p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type Required
220: --
221: -- OUT
214: -- IN
215: -- p_api_version_number IN NUMBER Required
216: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
218: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
219: -- p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type Required
220: --
221: -- OUT
222: -- x_return_status OUT VARCHAR2
230: -- ==============================================================================
231: --
232: PROCEDURE Lock_Prgm_Ptr_Type(
233: p_api_version_number IN NUMBER
234: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
235: ,x_return_status OUT NOCOPY VARCHAR2
236: ,x_msg_count OUT NOCOPY NUMBER
237: ,x_msg_data OUT NOCOPY VARCHAR2
238: ,p_program_partner_types_id IN NUMBER
257: -- End of Comments
258: -- ==============================================================================
259: PROCEDURE Validate_Prgm_Ptr_Type(
260: p_api_version_number IN NUMBER
261: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
262: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
263: ,p_validation_mode IN VARCHAR2
264: ,p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type
265: ,x_return_status OUT NOCOPY VARCHAR2
258: -- ==============================================================================
259: PROCEDURE Validate_Prgm_Ptr_Type(
260: p_api_version_number IN NUMBER
261: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
262: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
263: ,p_validation_mode IN VARCHAR2
264: ,p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type
265: ,x_return_status OUT NOCOPY VARCHAR2
266: ,x_msg_count OUT NOCOPY NUMBER
309: -- End of Comments
310: -- ==============================================================================
311: PROCEDURE Validate_Rec(
312: p_api_version_number IN NUMBER
313: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
314: ,x_return_status OUT NOCOPY VARCHAR2
315: ,x_msg_count OUT NOCOPY NUMBER
316: ,x_msg_data OUT NOCOPY VARCHAR
317: ,p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type