37:
38: CURSOR auth_id_s IS SELECT JTF_XML_INV_AUTHS_S.NEXTVAL FROM sys.dual;
39:
40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT CREATE_AUTH;
43:
44: -- Standard call to check for call compatibility.
45: IF NOT FND_API.Compatible_API_Call (
40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT CREATE_AUTH;
43:
44: -- Standard call to check for call compatibility.
45: IF NOT FND_API.Compatible_API_Call (
46: l_api_version,
47: p_api_version,
48: l_api_name,
100: p_OBJECT_VERSION := 1;
101: -----------------------
102: -- end of real logic --
103:
104: -- Standard check of p_commit.
105: IF (FND_API.To_Boolean(p_commit)) THEN
106: COMMIT WORK;
107: END IF;
108:
105: IF (FND_API.To_Boolean(p_commit)) THEN
106: COMMIT WORK;
107: END IF;
108:
109: -- Standard call to get message count and if count is 1, get message info.
110: FND_MSG_PUB.Count_And_Get(
111: p_count => x_msg_count,
112: p_data => x_msg_data );
113:
162:
163: -- l_ip_row JTF_XML_INV_PARAMS%ROWTYPE;
164:
165: BEGIN
166: -- Standard Start of API savepoint
167: SAVEPOINT REMOVE_AUTH;
168:
169: -- dbms_output.PUT_LINE('$$$$');
170:
167: SAVEPOINT REMOVE_AUTH;
168:
169: -- dbms_output.PUT_LINE('$$$$');
170:
171: -- Standard call to check for call compatibility.
172: IF NOT FND_API.Compatible_API_Call (
173: l_api_version,
174: p_api_version,
175: l_api_name,
213: -- P_OBJ_VER_NUMBER := P_OBJ_VER_NUMBER + 1;
214: -----------------------
215: -- end of real logic --
216:
217: -- Standard check of p_commit.
218: IF (FND_API.To_Boolean(p_commit)) THEN
219: COMMIT WORK;
220: END IF;
221:
218: IF (FND_API.To_Boolean(p_commit)) THEN
219: COMMIT WORK;
220: END IF;
221:
222: -- Standard call to get message count and if count is 1, get message info.
223: FND_MSG_PUB.Count_And_Get(
224: p_count => x_msg_count,
225: p_data => x_msg_data );
226:
274: l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;
275: l_commit VARCHAR2(1) := FND_API.G_FALSE;
276:
277: BEGIN
278: -- Standard Start of API savepoint
279: SAVEPOINT GET_OBJECT_VERSION;
280:
281: -- Standard call to check for call compatibility.
282: IF NOT FND_API.Compatible_API_Call (
277: BEGIN
278: -- Standard Start of API savepoint
279: SAVEPOINT GET_OBJECT_VERSION;
280:
281: -- Standard call to check for call compatibility.
282: IF NOT FND_API.Compatible_API_Call (
283: l_api_version,
284: p_api_version,
285: l_api_name,
309: END IF;
310: --------------------------------------
311: -- end of real logic --
312:
313: -- Standard check of p_commit.
314: IF (FND_API.To_Boolean(p_commit)) THEN
315: COMMIT WORK;
316: END IF;
317:
314: IF (FND_API.To_Boolean(p_commit)) THEN
315: COMMIT WORK;
316: END IF;
317:
318: -- Standard call to get message count and if count is 1, get message info.
319: FND_MSG_PUB.Count_And_Get(
320: p_count => x_msg_count,
321: p_data => x_msg_data );
322:
375: l_object_version NUMBER := NULL;
376:
377: --l_ip_row JTF_XML_INV_PARAMS%ROWTYPE;
378: BEGIN
379: -- Standard Start of API savepoint
380: SAVEPOINT UPDATE_AUTH;
381:
382: -- Standard call to check for call compatibility.
383: IF NOT FND_API.Compatible_API_Call (
378: BEGIN
379: -- Standard Start of API savepoint
380: SAVEPOINT UPDATE_AUTH;
381:
382: -- Standard call to check for call compatibility.
383: IF NOT FND_API.Compatible_API_Call (
384: l_api_version,
385: p_api_version,
386: l_api_name,
427: -- P_OBJ_VER_NUMBER := P_OBJ_VER_NUMBER + 1;
428: -----------------------
429: -- end of real logic --
430:
431: -- Standard check of p_commit.
432: IF (FND_API.To_Boolean(p_commit)) THEN
433: COMMIT WORK;
434: END IF;
435:
432: IF (FND_API.To_Boolean(p_commit)) THEN
433: COMMIT WORK;
434: END IF;
435:
436: -- Standard call to get message count and if count is 1, get message info.
437: FND_MSG_PUB.Count_And_Get(
438: p_count => x_msg_count,
439: p_data => x_msg_data );
440:
483: l_api_name CONSTANT VARCHAR2(30) := 'REMOVE_URL';
484: l_api_version CONSTANT NUMBER := p_api_version;
485:
486: BEGIN
487: -- Standard Start of API savepoint
488: SAVEPOINT REMOVE_URL;
489:
490: -- dbms_output.PUT_LINE('$$$$');
491:
488: SAVEPOINT REMOVE_URL;
489:
490: -- dbms_output.PUT_LINE('$$$$');
491:
492: -- Standard call to check for call compatibility.
493: IF NOT FND_API.Compatible_API_Call (
494: l_api_version,
495: p_api_version,
496: l_api_name,
529: -- P_OBJ_VER_NUMBER := P_OBJ_VER_NUMBER + 1;
530: -----------------------
531: -- end of real logic --
532:
533: -- Standard check of p_commit.
534: IF (FND_API.To_Boolean(p_commit)) THEN
535: COMMIT WORK;
536: END IF;
537:
534: IF (FND_API.To_Boolean(p_commit)) THEN
535: COMMIT WORK;
536: END IF;
537:
538: -- Standard call to get message count and if count is 1, get message info.
539: FND_MSG_PUB.Count_And_Get(
540: p_count => x_msg_count,
541: p_data => x_msg_data );
542:
587: l_api_version NUMBER := p_api_version;
588: l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;
589: l_commit VARCHAR2(1) := FND_API.G_FALSE;
590: BEGIN
591: -- Standard Start of API savepoint
592: SAVEPOINT UPDATE_URL;
593:
594: -- Standard call to check for call compatibility.
595: IF NOT FND_API.Compatible_API_Call (
590: BEGIN
591: -- Standard Start of API savepoint
592: SAVEPOINT UPDATE_URL;
593:
594: -- Standard call to check for call compatibility.
595: IF NOT FND_API.Compatible_API_Call (
596: l_api_version,
597: p_api_version,
598: l_api_name,
629: where URL = p_URL and END_DATE is NULL;
630: -----------------------
631: -- end of real logic --
632:
633: -- Standard check of p_commit.
634: IF (FND_API.To_Boolean(p_commit)) THEN
635: COMMIT WORK;
636: END IF;
637:
634: IF (FND_API.To_Boolean(p_commit)) THEN
635: COMMIT WORK;
636: END IF;
637:
638: -- Standard call to get message count and if count is 1, get message info.
639: FND_MSG_PUB.Count_And_Get(
640: p_count => x_msg_count,
641: p_data => x_msg_data );
642: