DBA Data[Home] [Help]

APPS.PSB_YEAR_TYPE_PVT dependencies on STANDARD

Line 27: -- Standard Start of API savepoint

23: l_seq_count NUMBER ;
24:
25: BEGIN
26:
27: -- Standard Start of API savepoint
28:
29: SAVEPOINT Check_Unique_Sequence;
30:
31: -- Standard call to check for call compatibility.

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

27: -- Standard Start of API savepoint
28:
29: SAVEPOINT Check_Unique_Sequence;
30:
31: -- Standard call to check for call compatibility.
32:
33: if not FND_API.Compatible_API_Call (l_api_version,
34: p_api_version,
35: l_api_name,

Line 66: -- Standard check of p_commit.

62: RAISE FND_API.G_EXC_ERROR;
63: end if;
64: --
65:
66: -- Standard check of p_commit.
67:
68: if FND_API.to_Boolean (p_commit) then
69: commit work;
70: end if;

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

68: if FND_API.to_Boolean (p_commit) then
69: commit work;
70: end if;
71:
72: -- Standard call to get message count and if count is 1, get message info.
73:
74: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
75: p_data => p_msg_data);
76:

Line 145: -- Standard Start of API savepoint

141: GROUP BY 1 ;
142: --
143: BEGIN
144:
145: -- Standard Start of API savepoint
146:
147: SAVEPOINT Check_Sequence;
148:
149: -- Standard call to check for call compatibility.

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

145: -- Standard Start of API savepoint
146:
147: SAVEPOINT Check_Sequence;
148:
149: -- Standard call to check for call compatibility.
150:
151: if not FND_API.Compatible_API_Call (l_api_version,
152: p_api_version,
153: l_api_name,

Line 220: -- Standard check of p_commit.

216: end if;
217: --
218: -- End of API body.
219:
220: -- Standard check of p_commit.
221:
222: if FND_API.to_Boolean (p_commit) then
223: commit work;
224: end if;

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

222: if FND_API.to_Boolean (p_commit) then
223: commit work;
224: end if;
225:
226: -- Standard call to get message count and if count is 1, get message info.
227:
228: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
229: p_data => p_msg_data);
230:

Line 287: -- Standard Start of API savepoint

283: l_cy_count NUMBER ;
284:
285: BEGIN
286:
287: -- Standard Start of API savepoint
288:
289: SAVEPOINT Check_CY_Count;
290:
291: -- Standard call to check for call compatibility.

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

287: -- Standard Start of API savepoint
288:
289: SAVEPOINT Check_CY_Count;
290:
291: -- Standard call to check for call compatibility.
292:
293: if not FND_API.Compatible_API_Call (l_api_version,
294: p_api_version,
295: l_api_name,

Line 326: -- Standard check of p_commit.

322: RAISE FND_API.G_EXC_ERROR ;
323: end if;
324: -- End of API body.
325:
326: -- Standard check of p_commit.
327:
328: if FND_API.to_Boolean (p_commit) then
329: commit work;
330: end if;

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

328: if FND_API.to_Boolean (p_commit) then
329: commit work;
330: end if;
331:
332: -- Standard call to get message count and if count is 1, get message info.
333:
334: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
335: p_data => p_msg_data);
336:

Line 394: -- Standard Start of API savepoint

390: l_dummy NUMBER ;
391:
392: BEGIN
393:
394: -- Standard Start of API savepoint
395:
396: SAVEPOINT Check_Ref_Integrity;
397:
398: -- Standard call to check for call compatibility.

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

394: -- Standard Start of API savepoint
395:
396: SAVEPOINT Check_Ref_Integrity;
397:
398: -- Standard call to check for call compatibility.
399:
400: if not FND_API.Compatible_API_Call (l_api_version,
401: p_api_version,
402: l_api_name,

Line 428: -- Standard check of p_commit.

424: FROM psb_budget_periods
425: WHERE budget_year_type_id = p_year_type_id);
426: -- End of API body.
427:
428: -- Standard check of p_commit.
429:
430: if FND_API.to_Boolean (p_commit) then
431: commit work;
432: end if;

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

430: if FND_API.to_Boolean (p_commit) then
431: commit work;
432: end if;
433:
434: -- Standard call to get message count and if count is 1, get message info.
435:
436: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
437: p_data => p_msg_data);
438:

Line 509: -- Standard Start of API savepoint

505: l_seq_count NUMBER ;
506:
507: BEGIN
508:
509: -- Standard Start of API savepoint
510:
511: SAVEPOINT Check_Unique_Name;
512:
513: -- Standard call to check for call compatibility.

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

509: -- Standard Start of API savepoint
510:
511: SAVEPOINT Check_Unique_Name;
512:
513: -- Standard call to check for call compatibility.
514:
515: if not FND_API.Compatible_API_Call (l_api_version,
516: p_api_version,
517: l_api_name,

Line 548: -- Standard check of p_commit.

544: RAISE FND_API.G_EXC_ERROR;
545: end if;
546: --
547:
548: -- Standard check of p_commit.
549:
550: if FND_API.to_Boolean (p_commit) then
551: commit work;
552: end if;

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

550: if FND_API.to_Boolean (p_commit) then
551: commit work;
552: end if;
553:
554: -- Standard call to get message count and if count is 1, get message info.
555:
556: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
557: p_data => p_msg_data);
558:

Line 651: -- Standard Start of API savepoint

647: where BUDGET_YEAR_TYPE_ID = p_BUDGET_YEAR_TYPE_ID
648: ;
649: BEGIN
650:
651: -- Standard Start of API savepoint
652:
653: SAVEPOINT Check_Unique_Name;
654:
655: -- Standard call to check for call compatibility.

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

651: -- Standard Start of API savepoint
652:
653: SAVEPOINT Check_Unique_Name;
654:
655: -- Standard call to check for call compatibility.
656:
657: if not FND_API.Compatible_API_Call (l_api_version,
658: p_api_version,
659: l_api_name,

Line 735: -- Standard check of p_commit.

731: raise no_data_found;
732: end if;
733: close c;
734:
735: -- Standard check of p_commit.
736:
737: if FND_API.to_Boolean (p_commit) then
738: commit work;
739: end if;

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

737: if FND_API.to_Boolean (p_commit) then
738: commit work;
739: end if;
740:
741: -- Standard call to get message count and if count is 1, get message info.
742:
743: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
744: p_data => p_msg_data);
745:

Line 823: -- Standard Start of API savepoint

819: l_api_version CONSTANT NUMBER := 1.0;
820:
821: BEGIN
822:
823: -- Standard Start of API savepoint
824:
825: SAVEPOINT Check_Unique_Name;
826:
827: -- Standard call to check for call compatibility.

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

823: -- Standard Start of API savepoint
824:
825: SAVEPOINT Check_Unique_Name;
826:
827: -- Standard call to check for call compatibility.
828:
829: if not FND_API.Compatible_API_Call (l_api_version,
830: p_api_version,
831: l_api_name,

Line 878: -- Standard check of p_commit.

874: end if;
875: end loop;
876: return;
877:
878: -- Standard check of p_commit.
879:
880: if FND_API.to_Boolean (p_commit) then
881: commit work;
882: end if;

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

880: if FND_API.to_Boolean (p_commit) then
881: commit work;
882: end if;
883:
884: -- Standard call to get message count and if count is 1, get message info.
885:
886: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
887: p_data => p_msg_data);
888:

Line 954: -- Standard Start of API savepoint

950: l_seq_count NUMBER ;
951:
952: BEGIN
953:
954: -- Standard Start of API savepoint
955:
956: SAVEPOINT Check_Unique_Name;
957:
958: -- Standard call to check for call compatibility.

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

954: -- Standard Start of API savepoint
955:
956: SAVEPOINT Check_Unique_Name;
957:
958: -- Standard call to check for call compatibility.
959:
960: if not FND_API.Compatible_API_Call (l_api_version,
961: p_api_version,
962: l_api_name,

Line 1004: -- Standard check of p_commit.

1000: if (sql%notfound) then
1001: raise no_data_found;
1002: end if;
1003:
1004: -- Standard check of p_commit.
1005:
1006: if FND_API.to_Boolean (p_commit) then
1007: commit work;
1008: end if;

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

1006: if FND_API.to_Boolean (p_commit) then
1007: commit work;
1008: end if;
1009:
1010: -- Standard call to get message count and if count is 1, get message info.
1011:
1012: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1013: p_data => p_msg_data);
1014:

Line 1070: -- Standard Start of API savepoint

1066: l_api_version CONSTANT NUMBER := 1.0;
1067:
1068: BEGIN
1069:
1070: -- Standard Start of API savepoint
1071:
1072: SAVEPOINT Check_Unique_Name;
1073:
1074: -- Standard call to check for call compatibility.

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

1070: -- Standard Start of API savepoint
1071:
1072: SAVEPOINT Check_Unique_Name;
1073:
1074: -- Standard call to check for call compatibility.
1075:
1076: if not FND_API.Compatible_API_Call (l_api_version,
1077: p_api_version,
1078: l_api_name,

Line 1108: -- Standard check of p_commit.

1104: if (sql%notfound) then
1105: raise no_data_found;
1106: end if;
1107:
1108: -- Standard check of p_commit.
1109:
1110: if FND_API.to_Boolean (p_commit) then
1111: commit work;
1112: end if;

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

1110: if FND_API.to_Boolean (p_commit) then
1111: commit work;
1112: end if;
1113:
1114: -- Standard call to get message count and if count is 1, get message info.
1115:
1116: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1117: p_data => p_msg_data);
1118: