27: -- ***************************************************
28: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_OKS_PUB';
29: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfptscb.pls';
30:
31: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
32: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
33: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
34: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
35: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
28: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_OKS_PUB';
29: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfptscb.pls';
30:
31: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
32: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
33: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
34: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
35: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
36: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
29: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfptscb.pls';
30:
31: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
32: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
33: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
34: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
35: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
36: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
37: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
30:
31: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
32: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
33: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
34: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
35: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
36: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
37: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
38: --
31: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
32: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
33: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
34: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
35: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
36: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
37: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
38: --
39: -- Start of Comments
32: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
33: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
34: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
35: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
36: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
37: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
38: --
39: -- Start of Comments
40:
33: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
34: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
35: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
36: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
37: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
38: --
39: -- Start of Comments
40:
41: -- ***************************************************