4: -- GLOBAL VARIABLES
5: -- ***************************************************
6: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_NAMEACC_PUB';
7: G_FILE_NAME CONSTANT VARCHAR2(12):='jtftrnpb.pls';
8: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
9: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
10: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
11: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
12: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
5: -- ***************************************************
6: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_NAMEACC_PUB';
7: G_FILE_NAME CONSTANT VARCHAR2(12):='jtftrnpb.pls';
8: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
9: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
10: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
11: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
12: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
13: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
6: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_NAMEACC_PUB';
7: G_FILE_NAME CONSTANT VARCHAR2(12):='jtftrnpb.pls';
8: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
9: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
10: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
11: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
12: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
13: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
14: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
7: G_FILE_NAME CONSTANT VARCHAR2(12):='jtftrnpb.pls';
8: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
9: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
10: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
11: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
12: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
13: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
14: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
15: ---------------------------------------------------------
8: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
9: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
10: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
11: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
12: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
13: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
14: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
15: ---------------------------------------------------------
16: -- Start of Comments
9: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
10: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
11: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
12: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
13: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
14: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
15: ---------------------------------------------------------
16: -- Start of Comments
17: -- ---------------------------------------------------
10: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
11: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
12: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
13: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
14: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
15: ---------------------------------------------------------
16: -- Start of Comments
17: -- ---------------------------------------------------
18: -- PACKAGE NAME: JTF_TERR_NAMEACC_PUB