41: -- ***************************************************
42: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_LOOKUP_PUB';
43: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfplkub.pls';
44:
45: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
46: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
47: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
48: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
49: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
42: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_LOOKUP_PUB';
43: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfplkub.pls';
44:
45: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
46: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
47: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
48: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
49: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
50: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
43: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfplkub.pls';
44:
45: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
46: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
47: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
48: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
49: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
50: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
51: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
44:
45: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
46: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
47: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
48: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
49: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
50: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
51: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
52:
45: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
46: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
47: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
48: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
49: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
50: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
51: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
52:
53:
46: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
47: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
48: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
49: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
50: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
51: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
52:
53:
54: --
47: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
48: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
49: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
50: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
51: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
52:
53:
54: --
55: -- ***************************************************