DBA Data[Home] [Help]

APPS.AS_INTEREST_PVT dependencies on FND_GLOBAL

Line 7: /* Remove dependency on global variable, use FND_GLOBAL.xxx directly

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_INTEREST_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvintb.pls';
6:
7: /* Remove dependency on global variable, use FND_GLOBAL.xxx directly
8: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
9: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

Line 8: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;

4: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_INTEREST_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvintb.pls';
6:
7: /* Remove dependency on global variable, use FND_GLOBAL.xxx directly
8: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
9: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
12: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;

Line 9: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;

5: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvintb.pls';
6:
7: /* Remove dependency on global variable, use FND_GLOBAL.xxx directly
8: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
9: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
12: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
13: */

Line 10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;

6:
7: /* Remove dependency on global variable, use FND_GLOBAL.xxx directly
8: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
9: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
12: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
13: */
14: --

Line 11: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

7: /* Remove dependency on global variable, use FND_GLOBAL.xxx directly
8: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
9: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
12: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
13: */
14: --
15: -- NAME

Line 12: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;

8: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
9: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
12: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
13: */
14: --
15: -- NAME
16: -- AS_INTEREST_PVT

Line 415: IF FND_GLOBAL.User_Id IS NULL

411:
412: -- ******************************************************************
413: -- Validate Environment
414: -- ******************************************************************
415: IF FND_GLOBAL.User_Id IS NULL
416: THEN
417: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
418: THEN
419: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');

Line 693: X_Last_Updated_By =>FND_GLOBAL.User_Id,

689: -- Insert interest row
690: AS_INTERESTS_PKG.Insert_Row ( X_Rowid => l_rowid,
691: X_Interest_Id => l_interest_tbl(l_curr_row).interest_id,
692: X_Last_Update_Date =>sysdate,
693: X_Last_Updated_By =>FND_GLOBAL.User_Id,
694: X_Creation_Date => SYSDATE,
695: X_Created_By =>FND_GLOBAL.User_Id,
696: X_Last_Update_Login =>FND_GLOBAL.Conc_Login_Id,
697: X_Request_Id => FND_GLOBAL.Conc_Request_Id,

Line 695: X_Created_By =>FND_GLOBAL.User_Id,

691: X_Interest_Id => l_interest_tbl(l_curr_row).interest_id,
692: X_Last_Update_Date =>sysdate,
693: X_Last_Updated_By =>FND_GLOBAL.User_Id,
694: X_Creation_Date => SYSDATE,
695: X_Created_By =>FND_GLOBAL.User_Id,
696: X_Last_Update_Login =>FND_GLOBAL.Conc_Login_Id,
697: X_Request_Id => FND_GLOBAL.Conc_Request_Id,
698: X_Program_Application_Id => FND_GLOBAL.Prog_Appl_Id,
699: X_Program_Id => FND_GLOBAL.Conc_Program_Id,

Line 696: X_Last_Update_Login =>FND_GLOBAL.Conc_Login_Id,

692: X_Last_Update_Date =>sysdate,
693: X_Last_Updated_By =>FND_GLOBAL.User_Id,
694: X_Creation_Date => SYSDATE,
695: X_Created_By =>FND_GLOBAL.User_Id,
696: X_Last_Update_Login =>FND_GLOBAL.Conc_Login_Id,
697: X_Request_Id => FND_GLOBAL.Conc_Request_Id,
698: X_Program_Application_Id => FND_GLOBAL.Prog_Appl_Id,
699: X_Program_Id => FND_GLOBAL.Conc_Program_Id,
700: X_Program_Update_Date => SYSDATE,

Line 697: X_Request_Id => FND_GLOBAL.Conc_Request_Id,

693: X_Last_Updated_By =>FND_GLOBAL.User_Id,
694: X_Creation_Date => SYSDATE,
695: X_Created_By =>FND_GLOBAL.User_Id,
696: X_Last_Update_Login =>FND_GLOBAL.Conc_Login_Id,
697: X_Request_Id => FND_GLOBAL.Conc_Request_Id,
698: X_Program_Application_Id => FND_GLOBAL.Prog_Appl_Id,
699: X_Program_Id => FND_GLOBAL.Conc_Program_Id,
700: X_Program_Update_Date => SYSDATE,
701: X_Interest_Use_Code => p_interest_use_code,

Line 698: X_Program_Application_Id => FND_GLOBAL.Prog_Appl_Id,

694: X_Creation_Date => SYSDATE,
695: X_Created_By =>FND_GLOBAL.User_Id,
696: X_Last_Update_Login =>FND_GLOBAL.Conc_Login_Id,
697: X_Request_Id => FND_GLOBAL.Conc_Request_Id,
698: X_Program_Application_Id => FND_GLOBAL.Prog_Appl_Id,
699: X_Program_Id => FND_GLOBAL.Conc_Program_Id,
700: X_Program_Update_Date => SYSDATE,
701: X_Interest_Use_Code => p_interest_use_code,
702: X_Interest_Type_Id => l_interest_tbl(l_curr_row).Interest_Type_Id,

Line 699: X_Program_Id => FND_GLOBAL.Conc_Program_Id,

695: X_Created_By =>FND_GLOBAL.User_Id,
696: X_Last_Update_Login =>FND_GLOBAL.Conc_Login_Id,
697: X_Request_Id => FND_GLOBAL.Conc_Request_Id,
698: X_Program_Application_Id => FND_GLOBAL.Prog_Appl_Id,
699: X_Program_Id => FND_GLOBAL.Conc_Program_Id,
700: X_Program_Update_Date => SYSDATE,
701: X_Interest_Use_Code => p_interest_use_code,
702: X_Interest_Type_Id => l_interest_tbl(l_curr_row).Interest_Type_Id,
703: X_Contact_Id => p_contact_id,

Line 1284: X_Last_Updated_By => FND_GLOBAL.USER_ID,

1280:
1281: AS_INTERESTS_PKG.Update_Row ( X_Rowid => l_rowid,
1282: X_Interest_Id => p_interest_rec.interest_id,
1283: X_Last_Update_Date => SYSDATE,
1284: X_Last_Updated_By => FND_GLOBAL.USER_ID,
1285: X_Last_Update_Login => FND_GLOBAL.Conc_Login_Id,
1286: X_Request_Id => FND_GLOBAL.Conc_Request_Id,
1287: X_Program_Application_Id => FND_GLOBAL.Prog_Appl_Id,
1288: X_Program_Id => FND_GLOBAL.Conc_Program_Id,

Line 1285: X_Last_Update_Login => FND_GLOBAL.Conc_Login_Id,

1281: AS_INTERESTS_PKG.Update_Row ( X_Rowid => l_rowid,
1282: X_Interest_Id => p_interest_rec.interest_id,
1283: X_Last_Update_Date => SYSDATE,
1284: X_Last_Updated_By => FND_GLOBAL.USER_ID,
1285: X_Last_Update_Login => FND_GLOBAL.Conc_Login_Id,
1286: X_Request_Id => FND_GLOBAL.Conc_Request_Id,
1287: X_Program_Application_Id => FND_GLOBAL.Prog_Appl_Id,
1288: X_Program_Id => FND_GLOBAL.Conc_Program_Id,
1289: X_Program_Update_Date => SYSDATE,

Line 1286: X_Request_Id => FND_GLOBAL.Conc_Request_Id,

1282: X_Interest_Id => p_interest_rec.interest_id,
1283: X_Last_Update_Date => SYSDATE,
1284: X_Last_Updated_By => FND_GLOBAL.USER_ID,
1285: X_Last_Update_Login => FND_GLOBAL.Conc_Login_Id,
1286: X_Request_Id => FND_GLOBAL.Conc_Request_Id,
1287: X_Program_Application_Id => FND_GLOBAL.Prog_Appl_Id,
1288: X_Program_Id => FND_GLOBAL.Conc_Program_Id,
1289: X_Program_Update_Date => SYSDATE,
1290: X_Interest_Use_Code => p_interest_use_code,

Line 1287: X_Program_Application_Id => FND_GLOBAL.Prog_Appl_Id,

1283: X_Last_Update_Date => SYSDATE,
1284: X_Last_Updated_By => FND_GLOBAL.USER_ID,
1285: X_Last_Update_Login => FND_GLOBAL.Conc_Login_Id,
1286: X_Request_Id => FND_GLOBAL.Conc_Request_Id,
1287: X_Program_Application_Id => FND_GLOBAL.Prog_Appl_Id,
1288: X_Program_Id => FND_GLOBAL.Conc_Program_Id,
1289: X_Program_Update_Date => SYSDATE,
1290: X_Interest_Use_Code => p_interest_use_code,
1291: X_Interest_Type_Id => p_interest_rec.Interest_Type_Id,

Line 1288: X_Program_Id => FND_GLOBAL.Conc_Program_Id,

1284: X_Last_Updated_By => FND_GLOBAL.USER_ID,
1285: X_Last_Update_Login => FND_GLOBAL.Conc_Login_Id,
1286: X_Request_Id => FND_GLOBAL.Conc_Request_Id,
1287: X_Program_Application_Id => FND_GLOBAL.Prog_Appl_Id,
1288: X_Program_Id => FND_GLOBAL.Conc_Program_Id,
1289: X_Program_Update_Date => SYSDATE,
1290: X_Interest_Use_Code => p_interest_use_code,
1291: X_Interest_Type_Id => p_interest_rec.Interest_Type_Id,
1292: X_Contact_Id => p_interest_rec.contact_id,

Line 1489: IF FND_GLOBAL.User_Id IS NULL

1485:
1486: -- ******************************************************************
1487: -- Validate Environment
1488: -- ******************************************************************
1489: IF FND_GLOBAL.User_Id IS NULL
1490: THEN
1491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1492: THEN
1493: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');