85: -- Parameters
86: --
87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_related_lines_rec IN related_lines_rec_type Required
93: --
86: --
87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_related_lines_rec IN related_lines_rec_type Required
93: --
94: -- OUT
87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_related_lines_rec IN related_lines_rec_type Required
93: --
94: -- OUT
95: -- x_return_status OUT VARCHAR2
104: --
105:
106: PROCEDURE Create_Related_Lines(
107: p_api_version_number IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111:
112: x_return_status OUT NOCOPY VARCHAR2,
105:
106: PROCEDURE Create_Related_Lines(
107: p_api_version_number IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111:
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
106: PROCEDURE Create_Related_Lines(
107: p_api_version_number IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111:
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
129: -- Parameters
130: --
131: -- IN
132: -- p_api_version_number IN NUMBER Required
133: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
135: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
136: -- p_related_lines_rec IN related_lines_rec_type Required
137: --
130: --
131: -- IN
132: -- p_api_version_number IN NUMBER Required
133: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
135: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
136: -- p_related_lines_rec IN related_lines_rec_type Required
137: --
138: -- OUT
131: -- IN
132: -- p_api_version_number IN NUMBER Required
133: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
135: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
136: -- p_related_lines_rec IN related_lines_rec_type Required
137: --
138: -- OUT
139: -- x_return_status OUT VARCHAR2
148: --
149:
150: PROCEDURE Update_Related_Lines(
151: p_api_version_number IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155:
156: x_return_status OUT NOCOPY VARCHAR2,
149:
150: PROCEDURE Update_Related_Lines(
151: p_api_version_number IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155:
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
150: PROCEDURE Update_Related_Lines(
151: p_api_version_number IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155:
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
173: -- Parameters
174: --
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_RELATED_DEAL_LINES_ID IN NUMBER
181: -- p_object_version_number IN NUMBER Optional Default = NULL
174: --
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_RELATED_DEAL_LINES_ID IN NUMBER
181: -- p_object_version_number IN NUMBER Optional Default = NULL
182: --
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_RELATED_DEAL_LINES_ID IN NUMBER
181: -- p_object_version_number IN NUMBER Optional Default = NULL
182: --
183: -- OUT
193: --
194:
195: PROCEDURE Delete_Related_Lines(
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_Related_Lines(
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_Related_Lines(
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_related_deal_lines_id IN NUMBER,
216: -- Parameters
217: --
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_related_lines_rec IN related_lines_rec_type Required
224: --
217: --
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_related_lines_rec IN related_lines_rec_type Required
224: --
225: -- OUT
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_related_lines_rec IN related_lines_rec_type Required
224: --
225: -- OUT
226: -- x_return_status OUT VARCHAR2
235: --
236:
237: PROCEDURE Lock_Related_Lines(
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,
259: -- End of Comments
260:
261: PROCEDURE Validate_related_lines(
262: p_api_version_number IN NUMBER,
263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update,
266: p_related_lines_rec IN related_lines_rec_type,
267: x_return_status OUT NOCOPY VARCHAR2,
260:
261: PROCEDURE Validate_related_lines(
262: p_api_version_number IN NUMBER,
263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update,
266: p_related_lines_rec IN related_lines_rec_type,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
298: -- End of Comments
299:
300: PROCEDURE Validate_related_lines_rec(
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: x_return_status OUT NOCOPY VARCHAR2,
304: x_msg_count OUT NOCOPY NUMBER,
305: x_msg_data OUT NOCOPY VARCHAR2,
306: p_related_lines_rec IN related_lines_rec_type