74:
75: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_ASSIGN_PUB';
76: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfptrwb.pls';
77:
78: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
79: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
80: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
81: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
82: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
75: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_ASSIGN_PUB';
76: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfptrwb.pls';
77:
78: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
79: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
80: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
81: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
82: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
83: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
76: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfptrwb.pls';
77:
78: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
79: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
80: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
81: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
82: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
83: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
84: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
77:
78: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
79: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
80: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
81: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
82: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
83: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
84: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
85:
78: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
79: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
80: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
81: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
82: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
83: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
84: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
85:
86: -- ***************************************************
79: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
80: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
81: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
82: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
83: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
84: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
85:
86: -- ***************************************************
87: -- API Body Definitions
80: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
81: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
82: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
83: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
84: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
85:
86: -- ***************************************************
87: -- API Body Definitions
88: -- ***************************************************