DBA Data[Home] [Help]

APPS.JTF_XML_IA_PUB dependencies on STANDARD

Line 41: -- Standard Start of API savepoint

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 (

Line 44: -- Standard call to check for call compatibility.

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,

Line 104: -- Standard check of p_commit.

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:

Line 109: -- Standard call to get message count and if count is 1, get message info.

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:

Line 166: -- Standard Start of API savepoint

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:

Line 171: -- Standard call to check for call compatibility.

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,

Line 217: -- Standard check of p_commit.

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:

Line 222: -- Standard call to get message count and if count is 1, get message info.

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:

Line 278: -- Standard Start of API savepoint

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 (

Line 281: -- Standard call to check for call compatibility.

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,

Line 313: -- Standard check of p_commit.

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:

Line 318: -- Standard call to get message count and if count is 1, get message info.

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:

Line 379: -- Standard Start of API savepoint

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 (

Line 382: -- Standard call to check for call compatibility.

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,

Line 431: -- Standard check of p_commit.

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:

Line 436: -- Standard call to get message count and if count is 1, get message info.

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:

Line 487: -- Standard Start of API savepoint

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:

Line 492: -- Standard call to check for call compatibility.

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,

Line 533: -- Standard check of p_commit.

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:

Line 538: -- Standard call to get message count and if count is 1, get message info.

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:

Line 591: -- Standard Start of API savepoint

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 (

Line 594: -- Standard call to check for call compatibility.

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,

Line 633: -- Standard check of p_commit.

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:

Line 638: -- Standard call to get message count and if count is 1, get message info.

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: