DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_LINES_PVT dependencies on FND_GLOBAL

Line 47: last_updated_by = FND_GLOBAL.USER_ID,

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;

Line 49: -- created_by = FND_GLOBAL.USER_ID, -- solin, for bug 1579950

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;

Line 50: last_update_login = FND_GLOBAL.CONC_LOGIN_ID

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;

Line 1085: IF FND_GLOBAL.User_Id IS NULL

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(

Line 1363: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

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,

Line 1365: p_CREATED_BY => FND_GLOBAL.USER_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,

Line 1366: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_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,

Line 1367: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

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,

Line 1368: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_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,

Line 1369: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

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,

Line 1614: IF FND_GLOBAL.User_Id IS NULL

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(

Line 1807: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

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,

Line 1810: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_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,

Line 1811: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

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,

Line 1812: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_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,

Line 1813: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

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:

Line 2038: IF FND_GLOBAL.User_Id IS NULL

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(