83: -- Parameters
84: --
85: -- IN
86: -- p_api_version_number IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
88: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
89: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
90: -- p_ptr_pgrm_type_rec IN ptr_prgm_type_rec_type Required
91: --
84: --
85: -- IN
86: -- p_api_version_number IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
88: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
89: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
90: -- p_ptr_pgrm_type_rec IN ptr_prgm_type_rec_type Required
91: --
92: -- OUT
85: -- IN
86: -- p_api_version_number IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
88: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
89: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
90: -- p_ptr_pgrm_type_rec IN ptr_prgm_type_rec_type Required
91: --
92: -- OUT
93: -- x_return_status OUT VARCHAR2
101: -- ==============================================================================
102: --
103: PROCEDURE Create_Partner_Pgm_Type(
104: p_api_version_number IN NUMBER
105: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
106: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
107: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
108: ,x_return_status OUT NOCOPY VARCHAR2
109: ,x_msg_count OUT NOCOPY NUMBER
102: --
103: PROCEDURE Create_Partner_Pgm_Type(
104: p_api_version_number IN NUMBER
105: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
106: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
107: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
108: ,x_return_status OUT NOCOPY VARCHAR2
109: ,x_msg_count OUT NOCOPY NUMBER
110: ,x_msg_data OUT NOCOPY VARCHAR2
103: PROCEDURE Create_Partner_Pgm_Type(
104: p_api_version_number IN NUMBER
105: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
106: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
107: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
108: ,x_return_status OUT NOCOPY VARCHAR2
109: ,x_msg_count OUT NOCOPY NUMBER
110: ,x_msg_data OUT NOCOPY VARCHAR2
111: ,p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type := g_miss_ptr_prgm_type_rec
127: -- Parameters
128: --
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134: -- p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type Required
135: --
128: --
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134: -- p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type Required
135: --
136: -- OUT
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134: -- p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type Required
135: --
136: -- OUT
137: -- x_return_status OUT VARCHAR2
145: -- ==============================================================================
146: --
147: PROCEDURE Update_Partner_Pgm_Type(
148: p_api_version_number IN NUMBER
149: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
150: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
151: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
152:
153: ,x_return_status OUT NOCOPY VARCHAR2
146: --
147: PROCEDURE Update_Partner_Pgm_Type(
148: p_api_version_number IN NUMBER
149: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
150: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
151: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
152:
153: ,x_return_status OUT NOCOPY VARCHAR2
154: ,x_msg_count OUT NOCOPY NUMBER
147: PROCEDURE Update_Partner_Pgm_Type(
148: p_api_version_number IN NUMBER
149: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
150: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
151: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
152:
153: ,x_return_status OUT NOCOPY VARCHAR2
154: ,x_msg_count OUT NOCOPY NUMBER
155: ,x_msg_data OUT NOCOPY VARCHAR2
174: -- Parameters
175: --
176: -- IN
177: -- p_api_version_number IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
179: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
180: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
181: -- p_PROGRAM_TYPE_ID IN NUMBER
182: -- p_object_version_number IN NUMBER Optional Default = NULL
175: --
176: -- IN
177: -- p_api_version_number IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
179: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
180: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
181: -- p_PROGRAM_TYPE_ID IN NUMBER
182: -- p_object_version_number IN NUMBER Optional Default = NULL
183: --
176: -- IN
177: -- p_api_version_number IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
179: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
180: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
181: -- p_PROGRAM_TYPE_ID IN NUMBER
182: -- p_object_version_number IN NUMBER Optional Default = NULL
183: --
184: -- OUT
193: -- ==============================================================================
194: --
195: PROCEDURE Delete_Partner_Pgm_Type(
196: p_api_version_number IN NUMBER
197: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
198: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
199: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
200: ,x_return_status OUT NOCOPY VARCHAR2
201: ,x_msg_count OUT NOCOPY NUMBER
194: --
195: PROCEDURE Delete_Partner_Pgm_Type(
196: p_api_version_number IN NUMBER
197: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
198: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
199: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
200: ,x_return_status OUT NOCOPY VARCHAR2
201: ,x_msg_count OUT NOCOPY NUMBER
202: ,x_msg_data OUT NOCOPY VARCHAR2
195: PROCEDURE Delete_Partner_Pgm_Type(
196: p_api_version_number IN NUMBER
197: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
198: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
199: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
200: ,x_return_status OUT NOCOPY VARCHAR2
201: ,x_msg_count OUT NOCOPY NUMBER
202: ,x_msg_data OUT NOCOPY VARCHAR2
203: ,p_PROGRAM_TYPE_ID IN NUMBER
219: -- Parameters
220: --
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type Required
227: --
220: --
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type Required
227: --
228: -- OUT
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type Required
227: --
228: -- OUT
229: -- x_return_status OUT VARCHAR2
237: -- ==============================================================================
238: --
239: PROCEDURE Lock_Partner_Pgm_Type(
240: p_api_version_number IN NUMBER
241: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
242:
243: ,x_return_status OUT NOCOPY VARCHAR2
244: ,x_msg_count OUT NOCOPY NUMBER
245: ,x_msg_data OUT NOCOPY VARCHAR2
266: -- End of Comments
267: -- ==============================================================================
268: PROCEDURE Validate_partner_pgm_type(
269: p_api_version_number IN NUMBER
270: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
271: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
272: ,p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type
273: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
274: ,x_return_status OUT NOCOPY VARCHAR2
267: -- ==============================================================================
268: PROCEDURE Validate_partner_pgm_type(
269: p_api_version_number IN NUMBER
270: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
271: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
272: ,p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type
273: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
274: ,x_return_status OUT NOCOPY VARCHAR2
275: ,x_msg_count OUT NOCOPY NUMBER
317: -- End of Comments
318: -- ==============================================================================
319: PROCEDURE Validate_Rec(
320: p_api_version_number IN NUMBER
321: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
322: ,x_return_status OUT NOCOPY VARCHAR2
323: ,x_msg_count OUT NOCOPY NUMBER
324: ,x_msg_data OUT NOCOPY VARCHAR2
325: ,p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type