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_PVT dependencies on AMS_LIST_QUERY_PVT

Line 1: PACKAGE BODY AMS_List_Query_PVT as

1: PACKAGE BODY AMS_List_Query_PVT as
2: /* $Header: amsvliqb.pls 120.1 2005/09/20 05:50:34 aanjaria noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_List_Query_PVT

2: /* $Header: amsvliqb.pls 120.1 2005/09/20 05:50:34 aanjaria noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_List_Query_PVT
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_List_Query_PVT';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_List_Query_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvliqb.pls';
19:
20:
21: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

Line 618: l_tar_list_query_rec AMS_List_Query_PVT.list_query_rec_type := P_list_query_rec;

614: -- Local Variables
615: l_object_version_number NUMBER;
616: l_LIST_QUERY_ID NUMBER;
617: l_ref_list_query_rec c_get_List_Query%ROWTYPE ;
618: l_tar_list_query_rec AMS_List_Query_PVT.list_query_rec_type := P_list_query_rec;
619: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type := P_list_query_rec;
620: l_rowid ROWID;
621:
622: BEGIN

Line 619: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type := P_list_query_rec;

615: l_object_version_number NUMBER;
616: l_LIST_QUERY_ID NUMBER;
617: l_ref_list_query_rec c_get_List_Query%ROWTYPE ;
618: l_tar_list_query_rec AMS_List_Query_PVT.list_query_rec_type := P_list_query_rec;
619: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type := P_list_query_rec;
620: l_rowid ROWID;
621:
622: BEGIN
623: -- Standard Start of API savepoint

Line 842: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type ;

838: -- Local Variables
839: l_object_version_number NUMBER;
840: l_LIST_QUERY_ID NUMBER;
841: l_list_query_temp number;
842: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type ;
843: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;
844: l_rowid ROWID;
845: l_no_of_records number;
846: l_no_of_records_upd number;

Line 843: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;

839: l_object_version_number NUMBER;
840: l_LIST_QUERY_ID NUMBER;
841: l_list_query_temp number;
842: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type ;
843: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;
844: l_rowid ROWID;
845: l_no_of_records number;
846: l_no_of_records_upd number;
847: l_parent_list_query_id number;

Line 860: l_sql_string_tbl AMS_List_Query_PVT.sql_string_tbl ;

856: select query --sql_string column is obsolete bug 4604653
857: from ams_list_queries_all
858: where parent_list_query_id = cur_parent_query_id;
859: l_sql_string varchar2(4000);
860: l_sql_string_tbl AMS_List_Query_PVT.sql_string_tbl ;
861: j number:=0 ;
862: BEGIN
863: -- Standard Start of API savepoint
864: SAVEPOINT UPDATE_List_Query_PVT_TBL;

Line 1898: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type;

1894: IS
1895: L_API_NAME CONSTANT VARCHAR2(30) := 'Validate_List_Query';
1896: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1897: l_object_version_number NUMBER;
1898: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type;
1899:
1900: BEGIN
1901: -- Standard Start of API savepoint
1902: SAVEPOINT VALIDATE_List_Query_;

Line 2414: FND_MESSAGE.Set_Token('TEXT', 'AMS_List_Query_PVT.Copy_List_Queries: Start', TRUE);

2410:
2411: -- Debug Message
2412: IF (AMS_DEBUG_HIGH_ON) THEN
2413: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2414: FND_MESSAGE.Set_Token('TEXT', 'AMS_List_Query_PVT.Copy_List_Queries: Start', TRUE);
2415: FND_MSG_PUB.Add;
2416: END IF;
2417:
2418: -- Initialize API return status to success

Line 2520: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Query_PVT.Copy_List_Queries', TRUE);

2516: -- Success Message
2517: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2518: THEN
2519: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2520: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Query_PVT.Copy_List_Queries', TRUE);
2521: FND_MSG_PUB.Add;
2522: END IF;
2523:
2524: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2526: FND_MESSAGE.Set_Token('TEXT', 'AMS_List_Query_PVT.Copy_List_Queries: END', TRUE);

2522: END IF;
2523:
2524: IF (AMS_DEBUG_HIGH_ON) THEN
2525: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2526: FND_MESSAGE.Set_Token('TEXT', 'AMS_List_Query_PVT.Copy_List_Queries: END', TRUE);
2527: FND_MSG_PUB.Add;
2528: END IF;
2529:
2530:

Line 2577: END AMS_List_Query_PVT;

2573:
2574: END Copy_List_Queries;
2575:
2576:
2577: END AMS_List_Query_PVT;