43:
44: UPDATE as_sales_leads
45: SET total_amount = nvl(l_line_total, 0),
46: last_update_date = SYSDATE,
47: last_updated_by = FND_GLOBAL.USER_ID,
48: -- creation_Date = SYSDATE, -- solin, for bug 1579950
49: -- created_by = FND_GLOBAL.USER_ID, -- solin, for bug 1579950
50: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
51: WHERE sales_lead_id = p_sales_lead_id;
45: SET total_amount = nvl(l_line_total, 0),
46: last_update_date = SYSDATE,
47: last_updated_by = FND_GLOBAL.USER_ID,
48: -- creation_Date = SYSDATE, -- solin, for bug 1579950
49: -- created_by = FND_GLOBAL.USER_ID, -- solin, for bug 1579950
50: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
51: WHERE sales_lead_id = p_sales_lead_id;
52: IF (SQL%NOTFOUND) THEN
53: RAISE NO_DATA_FOUND;
46: last_update_date = SYSDATE,
47: last_updated_by = FND_GLOBAL.USER_ID,
48: -- creation_Date = SYSDATE, -- solin, for bug 1579950
49: -- created_by = FND_GLOBAL.USER_ID, -- solin, for bug 1579950
50: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
51: WHERE sales_lead_id = p_sales_lead_id;
52: IF (SQL%NOTFOUND) THEN
53: RAISE NO_DATA_FOUND;
54: END IF;
1081: -- ******************************************************************
1082: -- Validate Environment
1083: -- ******************************************************************
1084:
1085: IF FND_GLOBAL.User_Id IS NULL
1086: THEN
1087: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1088: THEN
1089: AS_UTILITY_PVT.Set_Message(
1359: -- Invoke table handler(Sales_Lead_Line_Insert_Row)
1360: AS_SALES_LEAD_LINES_PKG.Sales_Lead_Line_Insert_Row(
1361: px_SALES_LEAD_LINE_ID => l_sales_lead_line_id,
1362: p_LAST_UPDATE_DATE => SYSDATE,
1363: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1364: p_CREATION_DATE => SYSDATE,
1365: p_CREATED_BY => FND_GLOBAL.USER_ID,
1366: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1367: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
1361: px_SALES_LEAD_LINE_ID => l_sales_lead_line_id,
1362: p_LAST_UPDATE_DATE => SYSDATE,
1363: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1364: p_CREATION_DATE => SYSDATE,
1365: p_CREATED_BY => FND_GLOBAL.USER_ID,
1366: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1367: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
1368: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
1369: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
1362: p_LAST_UPDATE_DATE => SYSDATE,
1363: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1364: p_CREATION_DATE => SYSDATE,
1365: p_CREATED_BY => FND_GLOBAL.USER_ID,
1366: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1367: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
1368: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
1369: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
1370: p_PROGRAM_UPDATE_DATE => SYSDATE,
1363: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1364: p_CREATION_DATE => SYSDATE,
1365: p_CREATED_BY => FND_GLOBAL.USER_ID,
1366: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1367: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
1368: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
1369: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
1370: p_PROGRAM_UPDATE_DATE => SYSDATE,
1371: p_SALES_LEAD_ID => l_SALES_LEAD_LINE_rec.SALES_LEAD_ID,
1364: p_CREATION_DATE => SYSDATE,
1365: p_CREATED_BY => FND_GLOBAL.USER_ID,
1366: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1367: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
1368: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
1369: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
1370: p_PROGRAM_UPDATE_DATE => SYSDATE,
1371: p_SALES_LEAD_ID => l_SALES_LEAD_LINE_rec.SALES_LEAD_ID,
1372: p_STATUS_CODE => l_SALES_LEAD_LINE_rec.STATUS_CODE,
1365: p_CREATED_BY => FND_GLOBAL.USER_ID,
1366: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1367: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
1368: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
1369: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
1370: p_PROGRAM_UPDATE_DATE => SYSDATE,
1371: p_SALES_LEAD_ID => l_SALES_LEAD_LINE_rec.SALES_LEAD_ID,
1372: p_STATUS_CODE => l_SALES_LEAD_LINE_rec.STATUS_CODE,
1373: /*p_INTEREST_TYPE_ID => l_SALES_LEAD_LINE_rec.INTEREST_TYPE_ID,
1610:
1611: -- ******************************************************************
1612: -- Validate Environment
1613: -- ******************************************************************
1614: IF FND_GLOBAL.User_Id IS NULL
1615: THEN
1616: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1617: THEN
1618: AS_UTILITY_PVT.Set_Message(
1803: -- Invoke table handler(sales_lead_line_Update_Row)
1804: AS_SALES_LEAD_LINES_PKG.Sales_Lead_line_Update_Row(
1805: p_SALES_LEAD_LINE_ID => l_tar_SALES_LEAD_LINE_rec.SALES_LEAD_LINE_ID,
1806: p_LAST_UPDATE_DATE => SYSDATE,
1807: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1808: p_CREATION_DATE => l_tar_SALES_LEAD_LINE_rec.CREATION_DATE,
1809: p_CREATED_BY => l_tar_SALES_LEAD_LINE_rec.CREATED_BY,
1810: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1811: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
1806: p_LAST_UPDATE_DATE => SYSDATE,
1807: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1808: p_CREATION_DATE => l_tar_SALES_LEAD_LINE_rec.CREATION_DATE,
1809: p_CREATED_BY => l_tar_SALES_LEAD_LINE_rec.CREATED_BY,
1810: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1811: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
1812: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
1813: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
1814: p_PROGRAM_UPDATE_DATE => SYSDATE,
1807: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1808: p_CREATION_DATE => l_tar_SALES_LEAD_LINE_rec.CREATION_DATE,
1809: p_CREATED_BY => l_tar_SALES_LEAD_LINE_rec.CREATED_BY,
1810: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1811: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
1812: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
1813: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
1814: p_PROGRAM_UPDATE_DATE => SYSDATE,
1815: p_SALES_LEAD_ID => l_tar_SALES_LEAD_LINE_rec.SALES_LEAD_ID,
1808: p_CREATION_DATE => l_tar_SALES_LEAD_LINE_rec.CREATION_DATE,
1809: p_CREATED_BY => l_tar_SALES_LEAD_LINE_rec.CREATED_BY,
1810: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1811: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
1812: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
1813: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
1814: p_PROGRAM_UPDATE_DATE => SYSDATE,
1815: p_SALES_LEAD_ID => l_tar_SALES_LEAD_LINE_rec.SALES_LEAD_ID,
1816: p_STATUS_CODE => l_tar_SALES_LEAD_LINE_rec.STATUS_CODE,
1809: p_CREATED_BY => l_tar_SALES_LEAD_LINE_rec.CREATED_BY,
1810: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1811: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
1812: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
1813: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
1814: p_PROGRAM_UPDATE_DATE => SYSDATE,
1815: p_SALES_LEAD_ID => l_tar_SALES_LEAD_LINE_rec.SALES_LEAD_ID,
1816: p_STATUS_CODE => l_tar_SALES_LEAD_LINE_rec.STATUS_CODE,
1817:
2034:
2035: -- ******************************************************************
2036: -- Validate Environment
2037: -- ******************************************************************
2038: IF FND_GLOBAL.User_Id IS NULL
2039: THEN
2040: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2041: THEN
2042: AS_UTILITY_PVT.Set_Message(