35:
36: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_QUALIFIER_PVT';
37: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfvtrqb.pls';
38:
39: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
40: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
41: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
42: G_APP_SHORT_NAME VARCHAR2(50) := FND_GLOBAL.Application_Short_Name;
43:
36: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_QUALIFIER_PVT';
37: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfvtrqb.pls';
38:
39: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
40: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
41: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
42: G_APP_SHORT_NAME VARCHAR2(50) := FND_GLOBAL.Application_Short_Name;
43:
44:
37: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfvtrqb.pls';
38:
39: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
40: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
41: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
42: G_APP_SHORT_NAME VARCHAR2(50) := FND_GLOBAL.Application_Short_Name;
43:
44:
45: -- ******************************************************
38:
39: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
40: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
41: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
42: G_APP_SHORT_NAME VARCHAR2(50) := FND_GLOBAL.Application_Short_Name;
43:
44:
45: -- ******************************************************
46: -- PRIVATE ROUTINES