74: -- Parameters
75: --
76: -- IN
77: -- p_api_version_number IN NUMBER Required
78: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
81: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
82: --
75: --
76: -- IN
77: -- p_api_version_number IN NUMBER Required
78: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
81: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
82: --
83: -- OUT
76: -- IN
77: -- p_api_version_number IN NUMBER Required
78: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
81: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
82: --
83: -- OUT
84: -- x_return_status OUT VARCHAR2
96: -- ==============================================================================
97:
98: PROCEDURE Create_Mmbr_Trans(
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:
104: x_return_status OUT NOCOPY VARCHAR2,
97:
98: PROCEDURE Create_Mmbr_Trans(
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:
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
98: PROCEDURE Create_Mmbr_Trans(
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:
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
121: -- Parameters
122: --
123: -- IN
124: -- p_api_version_number IN NUMBER Required
125: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
128: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
129: --
122: --
123: -- IN
124: -- p_api_version_number IN NUMBER Required
125: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
128: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
129: --
130: -- OUT
123: -- IN
124: -- p_api_version_number IN NUMBER Required
125: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
128: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
129: --
130: -- OUT
131: -- x_return_status OUT VARCHAR2
143: -- ==============================================================================
144:
145: PROCEDURE Update_Mmbr_Trans(
146: p_api_version_number IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150:
151: x_return_status OUT NOCOPY VARCHAR2,
144:
145: PROCEDURE Update_Mmbr_Trans(
146: p_api_version_number IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150:
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
145: PROCEDURE Update_Mmbr_Trans(
146: p_api_version_number IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150:
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
167: -- Parameters
168: --
169: -- IN
170: -- p_api_version_number IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_mmbr_transition_id IN NUMBER
175: -- p_object_version_number IN NUMBER Optional Default = NULL
168: --
169: -- IN
170: -- p_api_version_number IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_mmbr_transition_id IN NUMBER
175: -- p_object_version_number IN NUMBER Optional Default = NULL
176: --
169: -- IN
170: -- p_api_version_number IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_mmbr_transition_id IN NUMBER
175: -- p_object_version_number IN NUMBER Optional Default = NULL
176: --
177: -- OUT
190: -- ==============================================================================
191:
192: PROCEDURE Delete_Mmbr_Trans(
193: p_api_version_number IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
191:
192: PROCEDURE Delete_Mmbr_Trans(
193: p_api_version_number IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
192: PROCEDURE Delete_Mmbr_Trans(
193: p_api_version_number IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_mmbr_transition_id IN NUMBER,
213: -- Parameters
214: --
215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
221: --
214: --
215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
221: --
222: -- OUT
215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
221: --
222: -- OUT
223: -- x_return_status OUT VARCHAR2
235: -- ==============================================================================
236:
237: PROCEDURE Lock_Mmbr_Trans(
238: p_api_version_number IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240:
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,
269:
270:
271: PROCEDURE Validate_Mmbr_Trans(
272: p_api_version_number IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: p_mmbr_tran_rec IN mmbr_tran_rec_type,
276: p_validation_mode IN VARCHAR2,
277: x_return_status OUT NOCOPY VARCHAR2,
270:
271: PROCEDURE Validate_Mmbr_Trans(
272: p_api_version_number IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: p_mmbr_tran_rec IN mmbr_tran_rec_type,
276: p_validation_mode IN VARCHAR2,
277: x_return_status OUT NOCOPY VARCHAR2,
278: x_msg_count OUT NOCOPY NUMBER,
328:
329:
330: PROCEDURE Validate_Mmbr_Tran_Rec (
331: p_api_version_number IN NUMBER,
332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_msg_count OUT NOCOPY NUMBER,
335: x_msg_data OUT NOCOPY VARCHAR2,
336: p_mmbr_tran_rec IN mmbr_tran_rec_type