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;
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;
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: */
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: --
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
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
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');
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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');