2: /* $Header: astvschb.pls 115.12 2002/02/06 11:44:32 pkm ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) :='AST_SEARCHURL_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) :='astvsrch.pls';
6: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
7: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
8: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
9: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) :='AST_SEARCHURL_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) :='astvsrch.pls';
6: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
7: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
8: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
9: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11:
4: G_PKG_NAME CONSTANT VARCHAR2(30) :='AST_SEARCHURL_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) :='astvsrch.pls';
6: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
7: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
8: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
9: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11:
12: PROCEDURE Query_SearchURL (p_api_version IN NUMBER := 1.0,
5: G_FILE_NAME CONSTANT VARCHAR2(12) :='astvsrch.pls';
6: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
7: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
8: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
9: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11:
12: PROCEDURE Query_SearchURL (p_api_version IN NUMBER := 1.0,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
7: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
8: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
9: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11:
12: PROCEDURE Query_SearchURL (p_api_version IN NUMBER := 1.0,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,