64:
65: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TAE_ASSIGN_PUB';
66: G_FILE_NAME CONSTANT VARCHAR2(12):='jtftaeab.pls';
67:
68: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
69: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
70: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
71: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
72: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
65: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TAE_ASSIGN_PUB';
66: G_FILE_NAME CONSTANT VARCHAR2(12):='jtftaeab.pls';
67:
68: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
69: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
70: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
71: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
72: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
73: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
66: G_FILE_NAME CONSTANT VARCHAR2(12):='jtftaeab.pls';
67:
68: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
69: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
70: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
71: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
72: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
73: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
74: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
67:
68: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
69: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
70: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
71: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
72: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
73: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
74: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
75:
68: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
69: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
70: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
71: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
72: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
73: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
74: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
75:
76: NO_TAE_DATA_FOUND EXCEPTION;
69: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
70: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
71: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
72: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
73: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
74: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
75:
76: NO_TAE_DATA_FOUND EXCEPTION;
77:
70: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
71: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
72: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
73: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
74: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
75:
76: NO_TAE_DATA_FOUND EXCEPTION;
77:
78: /******************* FYI: FND_API STUFF ********************************