eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_QUERY_PUB dependencies on AMS_LIST_QUERY_PVT

Line 33: p_list_query_rec IN AMS_List_Query_PVT.list_query_rec_type,

29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32:
33: p_list_query_rec IN AMS_List_Query_PVT.list_query_rec_type,
34: x_list_query_id OUT NOCOPY NUMBER
35: )
36:
37: IS

Line 40: l_pvt_list_query_rec AMS_List_Query_PVT.list_query_rec_type:=p_list_query_rec;

36:
37: IS
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:

Line 75: AMS_List_Query_PVT.Create_List_Query(

71: -- API body
72: --
73: -- Calling Private package: Create_List_Query
74: -- Hint: Primary key needs to be returned
75: AMS_List_Query_PVT.Create_List_Query(
76: p_api_version_number => 1.0,
77: p_init_msg_list => FND_API.G_FALSE,
78: p_commit => FND_API.G_FALSE,
79: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 166: p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl ,

162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl ,
167: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
168:
169: x_parent_list_query_id OUT NOCOPY NUMBER
170: )

Line 167: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,

163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl ,
167: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
168:
169: x_parent_list_query_id OUT NOCOPY NUMBER
170: )
171: IS

Line 174: l_pvt_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl:=p_list_query_rec_tbl;

170: )
171: IS
172: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_List_Query';
173: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
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

Line 175: l_pvt_sql_string_tbl AMS_List_Query_PVT.sql_string_tbl:=p_sql_string_tbl;

171: IS
172: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_List_Query';
173: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
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;

Line 211: AMS_List_Query_PVT.Create_List_Query(

207: -- API body
208: --
209: -- Calling Private package: Create_List_Query
210: -- Hint: Primary key needs to be returned
211: AMS_List_Query_PVT.Create_List_Query(
212: p_api_version_number => 1.0,
213: p_init_msg_list => FND_API.G_FALSE,
214: p_commit => FND_API.G_FALSE,
215: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 305: p_list_query_rec IN AMS_List_Query_PVT.list_query_rec_type,

301: x_return_status OUT NOCOPY VARCHAR2,
302: x_msg_count OUT NOCOPY NUMBER,
303: x_msg_data OUT NOCOPY VARCHAR2,
304:
305: p_list_query_rec IN AMS_List_Query_PVT.list_query_rec_type,
306: x_object_version_number OUT NOCOPY NUMBER
307: )
308:
309: IS

Line 313: l_pvt_list_query_rec AMS_List_Query_PVT.list_query_rec_type:=p_list_query_rec;

309: IS
310: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_List_Query';
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:

Line 346: AMS_List_Query_PVT.Update_List_Query(

342:
343: --
344: -- API body
345: --
346: AMS_List_Query_PVT.Update_List_Query(
347: p_api_version_number => 1.0,
348: p_init_msg_list => FND_API.G_FALSE,
349: p_commit => p_commit,
350: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 438: p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl,

434: x_return_status OUT NOCOPY VARCHAR2,
435: x_msg_count OUT NOCOPY NUMBER,
436: x_msg_data OUT NOCOPY VARCHAR2,
437:
438: p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl,
439: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
440: x_object_version_number OUT NOCOPY NUMBER
441: )
442:

Line 439: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,

435: x_msg_count OUT NOCOPY NUMBER,
436: x_msg_data OUT NOCOPY VARCHAR2,
437:
438: p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl,
439: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
440: x_object_version_number OUT NOCOPY NUMBER
441: )
442:
443: IS

Line 447: l_pvt_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl:=p_list_query_rec_tbl;

443: IS
444: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_List_Query';
445: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
446: l_object_version_number NUMBER;
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

Line 448: l_pvt_sql_string_tbl AMS_List_Query_PVT.sql_string_tbl:=p_sql_string_tbl;

444: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_List_Query';
445: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
446: l_object_version_number NUMBER;
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;

Line 482: AMS_List_Query_PVT.Update_List_Query(

478:
479: --
480: -- API body
481: --
482: AMS_List_Query_PVT.Update_List_Query(
483: p_api_version_number => 1.0,
484: p_init_msg_list => FND_API.G_FALSE,
485: p_commit => p_commit,
486: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 584: l_pvt_list_query_rec AMS_List_Query_PVT.list_query_rec_type;

580: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_List_Query';
581: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
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:

Line 617: AMS_List_Query_PVT.Delete_List_Query(

613:
614: --
615: -- API body
616: --
617: AMS_List_Query_PVT.Delete_List_Query(
618: p_api_version_number => 1.0,
619: p_init_msg_list => FND_API.G_FALSE,
620: p_commit => p_commit,
621: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 716: l_pvt_list_query_rec AMS_List_Query_PVT.list_query_rec_type;

712: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_List_Query';
713: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
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:

Line 749: AMS_List_Query_PVT.Delete_parent_List_Query(

745:
746: --
747: -- API body
748: --
749: AMS_List_Query_PVT.Delete_parent_List_Query(
750: p_api_version_number => 1.0,
751: p_init_msg_list => FND_API.G_FALSE,
752: p_commit => p_commit,
753: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 846: l_pvt_list_query_rec AMS_List_Query_PVT.list_query_rec_type;

842:
843: IS
844: L_API_NAME CONSTANT VARCHAR2(30) := 'Lock_List_Query';
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,

Line 879: AMS_List_Query_PVT.Lock_List_Query(

875: -- API body
876: --
877: -- Calling Private package: Create_List_Query
878: -- Hint: Primary key needs to be returned
879: AMS_List_Query_PVT.Lock_List_Query(
880: p_api_version_number => 1.0,
881: p_init_msg_list => FND_API.G_FALSE,
882: x_return_status => x_return_status,
883: x_msg_count => x_msg_count,