[Home] [Help]
38: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_List_Query';
39: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
40: l_pvt_list_query_rec AMS_List_Query_PVT.list_query_rec_type:=p_list_query_rec;
41: BEGIN
42: -- Standard Start of API savepoint
43: SAVEPOINT CREATE_List_Query_PUB;
44:
45: -- Standard call to check for call compatibility.
46: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
41: BEGIN
42: -- Standard Start of API savepoint
43: SAVEPOINT CREATE_List_Query_PUB;
44:
45: -- Standard call to check for call compatibility.
46: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
47: p_api_version_number,
48: l_api_name,
49: G_PKG_NAME)
93: --
94: -- End of API body.
95: --
96:
97: -- Standard check for p_commit
98: IF FND_API.to_Boolean( p_commit )
99: THEN
100: COMMIT WORK;
101: END IF;
106:
107: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
108: END IF;
109:
110: -- Standard call to get message count and if count is 1, get message info.
111: FND_MSG_PUB.Count_And_Get
112: (p_count => x_msg_count,
113: p_data => x_msg_data
114: );
120:
121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO CREATE_List_Query_PUB;
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: -- Standard call to get message count and if count=1, get the message
125: FND_MSG_PUB.Count_And_Get (
126: p_encoded => FND_API.G_FALSE,
127: p_count => x_msg_count,
128: p_data => x_msg_data
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO CREATE_List_Query_PUB;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: -- Standard call to get message count and if count=1, get the message
135: FND_MSG_PUB.Count_And_Get (
136: p_encoded => FND_API.G_FALSE,
137: p_count => x_msg_count,
138: p_data => x_msg_data
144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148: -- Standard call to get message count and if count=1, get the message
149: FND_MSG_PUB.Count_And_Get (
150: p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count,
152: p_data => x_msg_data
174: l_pvt_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl:=p_list_query_rec_tbl;
175: l_pvt_sql_string_tbl AMS_List_Query_PVT.sql_string_tbl:=p_sql_string_tbl;
176:
177: BEGIN
178: -- Standard Start of API savepoint
179: SAVEPOINT CREATE_List_Query_PUB;
180:
181: -- Standard call to check for call compatibility.
182: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
177: BEGIN
178: -- Standard Start of API savepoint
179: SAVEPOINT CREATE_List_Query_PUB;
180:
181: -- Standard call to check for call compatibility.
182: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
183: p_api_version_number,
184: l_api_name,
185: G_PKG_NAME)
230: --
231: -- End of API body.
232: --
233:
234: -- Standard check for p_commit
235: IF FND_API.to_Boolean( p_commit )
236: THEN
237: COMMIT WORK;
238: END IF;
243:
244: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
245: END IF;
246:
247: -- Standard call to get message count and if count is 1, get message info.
248: FND_MSG_PUB.Count_And_Get
249: (p_count => x_msg_count,
250: p_data => x_msg_data
251: );
257:
258: WHEN FND_API.G_EXC_ERROR THEN
259: ROLLBACK TO CREATE_List_Query_PUB;
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: -- Standard call to get message count and if count=1, get the message
262: FND_MSG_PUB.Count_And_Get (
263: p_encoded => FND_API.G_FALSE,
264: p_count => x_msg_count,
265: p_data => x_msg_data
267:
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269: ROLLBACK TO CREATE_List_Query_PUB;
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: -- Standard call to get message count and if count=1, get the message
272: FND_MSG_PUB.Count_And_Get (
273: p_encoded => FND_API.G_FALSE,
274: p_count => x_msg_count,
275: p_data => x_msg_data
281: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
282: THEN
283: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
284: END IF;
285: -- Standard call to get message count and if count=1, get the message
286: FND_MSG_PUB.Count_And_Get (
287: p_encoded => FND_API.G_FALSE,
288: p_count => x_msg_count,
289: p_data => x_msg_data
311: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
312: l_object_version_number NUMBER;
313: l_pvt_list_query_rec AMS_List_Query_PVT.list_query_rec_type:=p_list_query_rec;
314: BEGIN
315: -- Standard Start of API savepoint
316: SAVEPOINT UPDATE_List_Query_PUB;
317:
318: -- Standard call to check for call compatibility.
319: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
314: BEGIN
315: -- Standard Start of API savepoint
316: SAVEPOINT UPDATE_List_Query_PUB;
317:
318: -- Standard call to check for call compatibility.
319: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
320: p_api_version_number,
321: l_api_name,
322: G_PKG_NAME)
364: --
365: -- End of API body
366: --
367:
368: -- Standard check for p_commit
369: IF FND_API.to_Boolean( p_commit )
370: THEN
371: COMMIT WORK;
372: END IF;
377:
378: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
379: END IF;
380:
381: -- Standard call to get message count and if count is 1, get message info.
382: FND_MSG_PUB.Count_And_Get
383: (p_count => x_msg_count,
384: p_data => x_msg_data
385: );
391:
392: WHEN FND_API.G_EXC_ERROR THEN
393: ROLLBACK TO UPDATE_List_Query_PUB;
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: -- Standard call to get message count and if count=1, get the message
396: FND_MSG_PUB.Count_And_Get (
397: p_encoded => FND_API.G_FALSE,
398: p_count => x_msg_count,
399: p_data => x_msg_data
401:
402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
403: ROLLBACK TO UPDATE_List_Query_PUB;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: -- Standard call to get message count and if count=1, get the message
406: FND_MSG_PUB.Count_And_Get (
407: p_encoded => FND_API.G_FALSE,
408: p_count => x_msg_count,
409: p_data => x_msg_data
415: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
416: THEN
417: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
418: END IF;
419: -- Standard call to get message count and if count=1, get the message
420: FND_MSG_PUB.Count_And_Get (
421: p_encoded => FND_API.G_FALSE,
422: p_count => x_msg_count,
423: p_data => x_msg_data
447: l_pvt_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl:=p_list_query_rec_tbl;
448: l_pvt_sql_string_tbl AMS_List_Query_PVT.sql_string_tbl:=p_sql_string_tbl;
449:
450: BEGIN
451: -- Standard Start of API savepoint
452: SAVEPOINT UPDATE_List_Query_PUB;
453:
454: -- Standard call to check for call compatibility.
455: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
450: BEGIN
451: -- Standard Start of API savepoint
452: SAVEPOINT UPDATE_List_Query_PUB;
453:
454: -- Standard call to check for call compatibility.
455: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
456: p_api_version_number,
457: l_api_name,
458: G_PKG_NAME)
502: --
503: -- End of API body
504: --
505:
506: -- Standard check for p_commit
507: IF FND_API.to_Boolean( p_commit )
508: THEN
509: COMMIT WORK;
510: END IF;
515:
516: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
517: END IF;
518:
519: -- Standard call to get message count and if count is 1, get message info.
520: FND_MSG_PUB.Count_And_Get
521: (p_count => x_msg_count,
522: p_data => x_msg_data
523: );
529:
530: WHEN FND_API.G_EXC_ERROR THEN
531: ROLLBACK TO UPDATE_List_Query_PUB;
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get (
535: p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data
539:
540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
541: ROLLBACK TO UPDATE_List_Query_PUB;
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: -- Standard call to get message count and if count=1, get the message
544: FND_MSG_PUB.Count_And_Get (
545: p_encoded => FND_API.G_FALSE,
546: p_count => x_msg_count,
547: p_data => x_msg_data
553: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
554: THEN
555: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
556: END IF;
557: -- Standard call to get message count and if count=1, get the message
558: FND_MSG_PUB.Count_And_Get (
559: p_encoded => FND_API.G_FALSE,
560: p_count => x_msg_count,
561: p_data => x_msg_data
582: l_LIST_QUERY_ID NUMBER := p_LIST_QUERY_ID;
583: l_object_version_number NUMBER := p_object_version_number;
584: l_pvt_list_query_rec AMS_List_Query_PVT.list_query_rec_type;
585: BEGIN
586: -- Standard Start of API savepoint
587: SAVEPOINT DELETE_List_Query_PUB;
588:
589: -- Standard call to check for call compatibility.
590: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
585: BEGIN
586: -- Standard Start of API savepoint
587: SAVEPOINT DELETE_List_Query_PUB;
588:
589: -- Standard call to check for call compatibility.
590: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
591: p_api_version_number,
592: l_api_name,
593: G_PKG_NAME)
635: --
636: -- End of API body
637: --
638:
639: -- Standard check for p_commit
640: IF FND_API.to_Boolean( p_commit )
641: THEN
642: COMMIT WORK;
643: END IF;
648:
649: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
650: END IF;
651:
652: -- Standard call to get message count and if count is 1, get message info.
653: FND_MSG_PUB.Count_And_Get
654: (p_count => x_msg_count,
655: p_data => x_msg_data
656: );
662:
663: WHEN FND_API.G_EXC_ERROR THEN
664: ROLLBACK TO DELETE_List_Query_PUB;
665: x_return_status := FND_API.G_RET_STS_ERROR;
666: -- Standard call to get message count and if count=1, get the message
667: FND_MSG_PUB.Count_And_Get (
668: p_encoded => FND_API.G_FALSE,
669: p_count => x_msg_count,
670: p_data => x_msg_data
672:
673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
674: ROLLBACK TO DELETE_List_Query_PUB;
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,
680: p_data => x_msg_data
686: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
687: THEN
688: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
689: END IF;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data
714: l_LIST_QUERY_ID NUMBER := p_parent_LIST_QUERY_ID;
715: l_object_version_number NUMBER := p_object_version_number;
716: l_pvt_list_query_rec AMS_List_Query_PVT.list_query_rec_type;
717: BEGIN
718: -- Standard Start of API savepoint
719: SAVEPOINT DELETE_List_Query_PUB;
720:
721: -- Standard call to check for call compatibility.
722: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
717: BEGIN
718: -- Standard Start of API savepoint
719: SAVEPOINT DELETE_List_Query_PUB;
720:
721: -- Standard call to check for call compatibility.
722: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
723: p_api_version_number,
724: l_api_name,
725: G_PKG_NAME)
767: --
768: -- End of API body
769: --
770:
771: -- Standard check for p_commit
772: IF FND_API.to_Boolean( p_commit )
773: THEN
774: COMMIT WORK;
775: END IF;
780:
781: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
782: END IF;
783:
784: -- Standard call to get message count and if count is 1, get message info.
785: FND_MSG_PUB.Count_And_Get
786: (p_count => x_msg_count,
787: p_data => x_msg_data
788: );
794:
795: WHEN FND_API.G_EXC_ERROR THEN
796: ROLLBACK TO DELETE_List_Query_PUB;
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: -- Standard call to get message count and if count=1, get the message
799: FND_MSG_PUB.Count_And_Get (
800: p_encoded => FND_API.G_FALSE,
801: p_count => x_msg_count,
802: p_data => x_msg_data
804:
805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
806: ROLLBACK TO DELETE_List_Query_PUB;
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808: -- Standard call to get message count and if count=1, get the message
809: FND_MSG_PUB.Count_And_Get (
810: p_encoded => FND_API.G_FALSE,
811: p_count => x_msg_count,
812: p_data => x_msg_data
818: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
819: THEN
820: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
821: END IF;
822: -- Standard call to get message count and if count=1, get the message
823: FND_MSG_PUB.Count_And_Get (
824: p_encoded => FND_API.G_FALSE,
825: p_count => x_msg_count,
826: p_data => x_msg_data
845: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
846: l_pvt_list_query_rec AMS_List_Query_PVT.list_query_rec_type;
847: BEGIN
848:
849: -- Standard call to check for call compatibility.
850: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
851: p_api_version_number,
852: l_api_name,
853: G_PKG_NAME)
910:
911: WHEN FND_API.G_EXC_ERROR THEN
912: ROLLBACK TO LOCK_List_Query_PUB;
913: x_return_status := FND_API.G_RET_STS_ERROR;
914: -- Standard call to get message count and if count=1, get the message
915: FND_MSG_PUB.Count_And_Get (
916: p_encoded => FND_API.G_FALSE,
917: p_count => x_msg_count,
918: p_data => x_msg_data
920:
921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
922: ROLLBACK TO LOCK_List_Query_PUB;
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: -- Standard call to get message count and if count=1, get the message
925: FND_MSG_PUB.Count_And_Get (
926: p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,
928: p_data => x_msg_data
934: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
935: THEN
936: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
937: END IF;
938: -- Standard call to get message count and if count=1, get the message
939: FND_MSG_PUB.Count_And_Get (
940: p_encoded => FND_API.G_FALSE,
941: p_count => x_msg_count,
942: p_data => x_msg_data