51: TYPE prgm_pmt_mode_rec_type IS RECORD
52: (
53: -- Following are the changes made for the new API standars
54:
55: -- program_payment_mode_id NUMBER := FND_API.G_MISS_NUM
56: -- ,program_id NUMBER := FND_API.G_MISS_NUM
57: -- ,geo_hierarchy_id NUMBER := FND_API.G_MISS_NUM
58: -- ,mode_of_payment VARCHAR2(15) := FND_API.G_MISS_CHAR
59: -- ,last_update_date DATE := FND_API.G_MISS_DATE
52: (
53: -- Following are the changes made for the new API standars
54:
55: -- program_payment_mode_id NUMBER := FND_API.G_MISS_NUM
56: -- ,program_id NUMBER := FND_API.G_MISS_NUM
57: -- ,geo_hierarchy_id NUMBER := FND_API.G_MISS_NUM
58: -- ,mode_of_payment VARCHAR2(15) := FND_API.G_MISS_CHAR
59: -- ,last_update_date DATE := FND_API.G_MISS_DATE
60: -- ,last_updated_by NUMBER := FND_API.G_MISS_NUM
53: -- Following are the changes made for the new API standars
54:
55: -- program_payment_mode_id NUMBER := FND_API.G_MISS_NUM
56: -- ,program_id NUMBER := FND_API.G_MISS_NUM
57: -- ,geo_hierarchy_id NUMBER := FND_API.G_MISS_NUM
58: -- ,mode_of_payment VARCHAR2(15) := FND_API.G_MISS_CHAR
59: -- ,last_update_date DATE := FND_API.G_MISS_DATE
60: -- ,last_updated_by NUMBER := FND_API.G_MISS_NUM
61: -- ,creation_date DATE := FND_API.G_MISS_DATE
54:
55: -- program_payment_mode_id NUMBER := FND_API.G_MISS_NUM
56: -- ,program_id NUMBER := FND_API.G_MISS_NUM
57: -- ,geo_hierarchy_id NUMBER := FND_API.G_MISS_NUM
58: -- ,mode_of_payment VARCHAR2(15) := FND_API.G_MISS_CHAR
59: -- ,last_update_date DATE := FND_API.G_MISS_DATE
60: -- ,last_updated_by NUMBER := FND_API.G_MISS_NUM
61: -- ,creation_date DATE := FND_API.G_MISS_DATE
62: -- ,created_by NUMBER := FND_API.G_MISS_NUM
55: -- program_payment_mode_id NUMBER := FND_API.G_MISS_NUM
56: -- ,program_id NUMBER := FND_API.G_MISS_NUM
57: -- ,geo_hierarchy_id NUMBER := FND_API.G_MISS_NUM
58: -- ,mode_of_payment VARCHAR2(15) := FND_API.G_MISS_CHAR
59: -- ,last_update_date DATE := FND_API.G_MISS_DATE
60: -- ,last_updated_by NUMBER := FND_API.G_MISS_NUM
61: -- ,creation_date DATE := FND_API.G_MISS_DATE
62: -- ,created_by NUMBER := FND_API.G_MISS_NUM
63: -- ,last_update_login NUMBER := FND_API.G_MISS_NUM
56: -- ,program_id NUMBER := FND_API.G_MISS_NUM
57: -- ,geo_hierarchy_id NUMBER := FND_API.G_MISS_NUM
58: -- ,mode_of_payment VARCHAR2(15) := FND_API.G_MISS_CHAR
59: -- ,last_update_date DATE := FND_API.G_MISS_DATE
60: -- ,last_updated_by NUMBER := FND_API.G_MISS_NUM
61: -- ,creation_date DATE := FND_API.G_MISS_DATE
62: -- ,created_by NUMBER := FND_API.G_MISS_NUM
63: -- ,last_update_login NUMBER := FND_API.G_MISS_NUM
64: -- ,object_version_number NUMBER := FND_API.G_MISS_NUM
57: -- ,geo_hierarchy_id NUMBER := FND_API.G_MISS_NUM
58: -- ,mode_of_payment VARCHAR2(15) := FND_API.G_MISS_CHAR
59: -- ,last_update_date DATE := FND_API.G_MISS_DATE
60: -- ,last_updated_by NUMBER := FND_API.G_MISS_NUM
61: -- ,creation_date DATE := FND_API.G_MISS_DATE
62: -- ,created_by NUMBER := FND_API.G_MISS_NUM
63: -- ,last_update_login NUMBER := FND_API.G_MISS_NUM
64: -- ,object_version_number NUMBER := FND_API.G_MISS_NUM
65:
58: -- ,mode_of_payment VARCHAR2(15) := FND_API.G_MISS_CHAR
59: -- ,last_update_date DATE := FND_API.G_MISS_DATE
60: -- ,last_updated_by NUMBER := FND_API.G_MISS_NUM
61: -- ,creation_date DATE := FND_API.G_MISS_DATE
62: -- ,created_by NUMBER := FND_API.G_MISS_NUM
63: -- ,last_update_login NUMBER := FND_API.G_MISS_NUM
64: -- ,object_version_number NUMBER := FND_API.G_MISS_NUM
65:
66: program_payment_mode_id NUMBER
59: -- ,last_update_date DATE := FND_API.G_MISS_DATE
60: -- ,last_updated_by NUMBER := FND_API.G_MISS_NUM
61: -- ,creation_date DATE := FND_API.G_MISS_DATE
62: -- ,created_by NUMBER := FND_API.G_MISS_NUM
63: -- ,last_update_login NUMBER := FND_API.G_MISS_NUM
64: -- ,object_version_number NUMBER := FND_API.G_MISS_NUM
65:
66: program_payment_mode_id NUMBER
67: ,program_id NUMBER
60: -- ,last_updated_by NUMBER := FND_API.G_MISS_NUM
61: -- ,creation_date DATE := FND_API.G_MISS_DATE
62: -- ,created_by NUMBER := FND_API.G_MISS_NUM
63: -- ,last_update_login NUMBER := FND_API.G_MISS_NUM
64: -- ,object_version_number NUMBER := FND_API.G_MISS_NUM
65:
66: program_payment_mode_id NUMBER
67: ,program_id NUMBER
68: ,geo_hierarchy_id NUMBER
97: -- Parameters
98: --
99: -- IN
100: -- p_api_version_number IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
102: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
104: -- p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type Required
105: --
98: --
99: -- IN
100: -- p_api_version_number IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
102: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
104: -- p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type Required
105: --
106: -- OUT
99: -- IN
100: -- p_api_version_number IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
102: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
104: -- p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type Required
105: --
106: -- OUT
107: -- x_return_status OUT VARCHAR2
114: -- End of Comments
115: -- ==============================================================================
116: PROCEDURE Create_Prgm_Pmt_Mode(
117: p_api_version_number IN NUMBER
118: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
119: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
120: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
121:
122: ,x_return_status OUT NOCOPY VARCHAR2
115: -- ==============================================================================
116: PROCEDURE Create_Prgm_Pmt_Mode(
117: p_api_version_number IN NUMBER
118: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
119: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
120: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
121:
122: ,x_return_status OUT NOCOPY VARCHAR2
123: ,x_msg_count OUT NOCOPY NUMBER
116: PROCEDURE Create_Prgm_Pmt_Mode(
117: p_api_version_number IN NUMBER
118: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
119: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
120: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
121:
122: ,x_return_status OUT NOCOPY VARCHAR2
123: ,x_msg_count OUT NOCOPY NUMBER
124: ,x_msg_data OUT NOCOPY VARCHAR2
142: -- Parameters
143: --
144: -- IN
145: -- p_api_version_number IN NUMBER Required
146: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
149: -- p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type Required
150: --
143: --
144: -- IN
145: -- p_api_version_number IN NUMBER Required
146: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
149: -- p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type Required
150: --
151: -- OUT
144: -- IN
145: -- p_api_version_number IN NUMBER Required
146: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
149: -- p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type Required
150: --
151: -- OUT
152: -- x_return_status OUT VARCHAR2
159: -- End of Comments
160: -- ==============================================================================
161: PROCEDURE Update_Prgm_Pmt_Mode(
162: p_api_version_number IN NUMBER
163: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
164: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
165: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
166:
167: ,x_return_status OUT NOCOPY VARCHAR2
160: -- ==============================================================================
161: PROCEDURE Update_Prgm_Pmt_Mode(
162: p_api_version_number IN NUMBER
163: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
164: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
165: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
166:
167: ,x_return_status OUT NOCOPY VARCHAR2
168: ,x_msg_count OUT NOCOPY NUMBER
161: PROCEDURE Update_Prgm_Pmt_Mode(
162: p_api_version_number IN NUMBER
163: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
164: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
165: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
166:
167: ,x_return_status OUT NOCOPY VARCHAR2
168: ,x_msg_count OUT NOCOPY NUMBER
169: ,x_msg_data OUT NOCOPY VARCHAR2
186: -- Parameters
187: --
188: -- IN
189: -- p_api_version_number IN NUMBER Required
190: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
191: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
192: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
193: -- p_program_payment_mode_id IN NUMBER
194: -- p_object_version_number IN NUMBER Optional Default = NULL
187: --
188: -- IN
189: -- p_api_version_number IN NUMBER Required
190: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
191: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
192: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
193: -- p_program_payment_mode_id IN NUMBER
194: -- p_object_version_number IN NUMBER Optional Default = NULL
195: --
188: -- IN
189: -- p_api_version_number IN NUMBER Required
190: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
191: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
192: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
193: -- p_program_payment_mode_id IN NUMBER
194: -- p_object_version_number IN NUMBER Optional Default = NULL
195: --
196: -- OUT
204: -- End of Comments
205: -- ==============================================================================
206: PROCEDURE Delete_Prgm_Pmt_Mode(
207: p_api_version_number IN NUMBER
208: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
209: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
210: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
211:
212: ,x_return_status OUT NOCOPY VARCHAR2
205: -- ==============================================================================
206: PROCEDURE Delete_Prgm_Pmt_Mode(
207: p_api_version_number IN NUMBER
208: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
209: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
210: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
211:
212: ,x_return_status OUT NOCOPY VARCHAR2
213: ,x_msg_count OUT NOCOPY NUMBER
206: PROCEDURE Delete_Prgm_Pmt_Mode(
207: p_api_version_number IN NUMBER
208: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
209: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
210: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
211:
212: ,x_return_status OUT NOCOPY VARCHAR2
213: ,x_msg_count OUT NOCOPY NUMBER
214: ,x_msg_data OUT NOCOPY VARCHAR2
231: -- Parameters
232: --
233: -- IN
234: -- p_api_version_number IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
238: -- p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type Required
239: --
232: --
233: -- IN
234: -- p_api_version_number IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
238: -- p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type Required
239: --
240: -- OUT
233: -- IN
234: -- p_api_version_number IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
238: -- p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type Required
239: --
240: -- OUT
241: -- x_return_status OUT VARCHAR2
248: -- End of Comments
249: -- ==============================================================================
250: PROCEDURE Lock_Prgm_Pmt_Mode(
251: p_api_version_number IN NUMBER
252: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
253:
254: ,x_return_status OUT NOCOPY VARCHAR2
255: ,x_msg_count OUT NOCOPY NUMBER
256: ,x_msg_data OUT NOCOPY VARCHAR2
276: -- End of Comments
277: -- =======================================
278: PROCEDURE Validate_Prgm_Pmt_Mode(
279: p_api_version_number IN NUMBER
280: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
281: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
282: ,p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type
283: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
284:
277: -- =======================================
278: PROCEDURE Validate_Prgm_Pmt_Mode(
279: p_api_version_number IN NUMBER
280: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
281: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
282: ,p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type
283: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
284:
285: ,x_return_status OUT NOCOPY VARCHAR2
330: -- End of Comments
331: -- ==============================================================================
332: PROCEDURE Validate_Rec(
333: p_api_version_number IN NUMBER
334: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
335:
336: ,x_return_status OUT NOCOPY VARCHAR2
337: ,x_msg_count OUT NOCOPY NUMBER
338: ,x_msg_data OUT NOCOPY VARCHAR2