120: -- select * from JTF_TERR_JSP_LOV_REC_TBL;
121:
122:
123: BEGIN
124: G_NEW_LINE := FND_GLOBAL.Local_Chr(10);
125: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
126: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
127: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
128: G_USER_ID := FND_GLOBAL.User_Id;
121:
122:
123: BEGIN
124: G_NEW_LINE := FND_GLOBAL.Local_Chr(10);
125: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
126: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
127: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
128: G_USER_ID := FND_GLOBAL.User_Id;
129: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
122:
123: BEGIN
124: G_NEW_LINE := FND_GLOBAL.Local_Chr(10);
125: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
126: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
127: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
128: G_USER_ID := FND_GLOBAL.User_Id;
129: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
130: G_APP_SHORT_NAME := FND_GLOBAL.Application_Short_Name;
123: BEGIN
124: G_NEW_LINE := FND_GLOBAL.Local_Chr(10);
125: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
126: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
127: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
128: G_USER_ID := FND_GLOBAL.User_Id;
129: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
130: G_APP_SHORT_NAME := FND_GLOBAL.Application_Short_Name;
131: G_test_var := 5;
124: G_NEW_LINE := FND_GLOBAL.Local_Chr(10);
125: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
126: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
127: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
128: G_USER_ID := FND_GLOBAL.User_Id;
129: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
130: G_APP_SHORT_NAME := FND_GLOBAL.Application_Short_Name;
131: G_test_var := 5;
132: G_test_var2 := 4;
125: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
126: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
127: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
128: G_USER_ID := FND_GLOBAL.User_Id;
129: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
130: G_APP_SHORT_NAME := FND_GLOBAL.Application_Short_Name;
131: G_test_var := 5;
132: G_test_var2 := 4;
133:
126: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
127: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
128: G_USER_ID := FND_GLOBAL.User_Id;
129: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
130: G_APP_SHORT_NAME := FND_GLOBAL.Application_Short_Name;
131: G_test_var := 5;
132: G_test_var2 := 4;
133:
134: l_column1 := p_in_filter_lov_rec.column1;