10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_FOUNDATION_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvfoub.pls';
13:
14: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
16: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
17: --G_USER_ID NUMBER := FND_GLOBAL.User_Id;
18: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_FOUNDATION_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvfoub.pls';
13:
14: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
16: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
17: --G_USER_ID NUMBER := FND_GLOBAL.User_Id;
18: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
19:
12: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvfoub.pls';
13:
14: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
16: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
17: --G_USER_ID NUMBER := FND_GLOBAL.User_Id;
18: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
19:
20: G_MAX NUMBER := 14;
13:
14: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
16: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
17: --G_USER_ID NUMBER := FND_GLOBAL.User_Id;
18: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
19:
20: G_MAX NUMBER := 14;
21:
14: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
16: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
17: --G_USER_ID NUMBER := FND_GLOBAL.User_Id;
18: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
19:
20: G_MAX NUMBER := 14;
21:
22: FUNCTION get_subOrderBy(p_col_choice IN NUMBER, p_col_name IN VARCHAR2)
124: --
125:
126: -- Validate Environment
127:
128: IF FND_GLOBAL.User_Id IS NULL
129: THEN
130: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
131: THEN
132: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
348: --
349:
350: -- Validate Environment
351:
352: IF FND_GLOBAL.User_Id IS NULL
353: THEN
354: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
355: THEN
356: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');