50: -- ***************************************************
51: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_SALES_PUB';
52: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfptsab.pls';
53:
54: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
55: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
56: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
57: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
58: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
51: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_SALES_PUB';
52: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfptsab.pls';
53:
54: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
55: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
56: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
57: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
58: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
59: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
52: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfptsab.pls';
53:
54: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
55: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
56: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
57: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
58: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
59: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
60: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
53:
54: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
55: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
56: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
57: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
58: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
59: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
60: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
61:
54: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
55: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
56: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
57: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
58: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
59: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
60: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
61:
62:
55: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
56: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
57: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
58: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
59: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
60: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
61:
62:
63: /*========================================================================================*/
56: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
57: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
58: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
59: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
60: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
61:
62:
63: /*========================================================================================*/
64: /*========================= ACCOUNT ======================================================*/