DBA Data[Home] [Help]

APPS.AS_OPP_LINE_PVT dependencies on FND_GLOBAL

Line 57: last_updated_by = FND_GLOBAL.USER_ID,

53: UPDATE as_leads_all
54: SET total_amount = nvl(l_line_total, 0),
55: TOTAL_REVENUE_OPP_FORECAST_AMT = l_tot_revenue_opp_forecast_amt, -- Added for ASNB
56: last_update_date = SYSDATE,
57: last_updated_by = FND_GLOBAL.USER_ID,
58: -- creation_Date = SYSDATE, -- solin, for bug 1579950
59: -- created_by = FND_GLOBAL.USER_ID, -- solin, for bug 1579950
60: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
61: WHERE lead_id = p_lead_id;

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

55: TOTAL_REVENUE_OPP_FORECAST_AMT = l_tot_revenue_opp_forecast_amt, -- Added for ASNB
56: last_update_date = SYSDATE,
57: last_updated_by = FND_GLOBAL.USER_ID,
58: -- creation_Date = SYSDATE, -- solin, for bug 1579950
59: -- created_by = FND_GLOBAL.USER_ID, -- solin, for bug 1579950
60: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
61: WHERE lead_id = p_lead_id;
62: IF (SQL%NOTFOUND) THEN
63: RAISE NO_DATA_FOUND;

Line 60: last_update_login = FND_GLOBAL.CONC_LOGIN_ID

56: last_update_date = SYSDATE,
57: last_updated_by = FND_GLOBAL.USER_ID,
58: -- creation_Date = SYSDATE, -- solin, for bug 1579950
59: -- created_by = FND_GLOBAL.USER_ID, -- solin, for bug 1579950
60: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
61: WHERE lead_id = p_lead_id;
62: IF (SQL%NOTFOUND) THEN
63: RAISE NO_DATA_FOUND;
64: END IF;

Line 211: last_updated_by = FND_GLOBAL.USER_ID,

207: UPDATE as_sales_credits
208: SET object_version_number = nvl(object_version_number,0) + 1, credit_percent = l_credit_percent,
209: credit_amount = l_credit_amount,
210: last_update_date = SYSDATE,
211: last_updated_by = FND_GLOBAL.USER_ID,
212: opp_worst_forecast_amount = nvl(l_opp_worst_forecast_amount,
213: opp_worst_forecast_amount),
214: opp_forecast_amount = nvl(l_opp_forecast_amount,
215: opp_forecast_amount),

Line 256: last_updated_by = FND_GLOBAL.USER_ID,

252: UPDATE as_sales_credits
253: SET object_version_number = nvl(object_version_number,0) + 1, credit_percent = l_credit_percent,
254: credit_amount = l_credit_amount,
255: last_update_date = SYSDATE,
256: last_updated_by = FND_GLOBAL.USER_ID,
257: opp_worst_forecast_amount = nvl(l_opp_worst_forecast_amount,
258: opp_worst_forecast_amount),
259: opp_forecast_amount = nvl(l_opp_forecast_amount,
260: opp_forecast_amount),

Line 857: IF FND_GLOBAL.User_Id IS NULL

853:
854: -- ******************************************************************
855: -- Validate Environment
856: -- ******************************************************************
857: IF FND_GLOBAL.User_Id IS NULL
858: THEN
859: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
860: THEN
861: FND_MESSAGE.Set_Name(' + appShortName +',

Line 1119: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1115: -- Invoke table handler(AS_LEAD_LINES_PKG.Insert_Row)
1116: AS_LEAD_LINES_PKG.Insert_Row(
1117: px_LEAD_LINE_ID => l_LEAD_LINE_ID,
1118: p_LAST_UPDATE_DATE => SYSDATE,
1119: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1120: p_CREATION_DATE => SYSDATE,
1121: p_CREATED_BY => FND_GLOBAL.USER_ID,
1122: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1123: p_REQUEST_ID => l_Line_Rec.REQUEST_ID,

Line 1121: p_CREATED_BY => FND_GLOBAL.USER_ID,

1117: px_LEAD_LINE_ID => l_LEAD_LINE_ID,
1118: p_LAST_UPDATE_DATE => SYSDATE,
1119: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1120: p_CREATION_DATE => SYSDATE,
1121: p_CREATED_BY => FND_GLOBAL.USER_ID,
1122: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1123: p_REQUEST_ID => l_Line_Rec.REQUEST_ID,
1124: p_PROGRAM_APPLICATION_ID => l_Line_Rec.PROGRAM_APPLICATION_ID,
1125: p_PROGRAM_ID => l_Line_Rec.PROGRAM_ID,

Line 1122: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

1118: p_LAST_UPDATE_DATE => SYSDATE,
1119: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1120: p_CREATION_DATE => SYSDATE,
1121: p_CREATED_BY => FND_GLOBAL.USER_ID,
1122: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1123: p_REQUEST_ID => l_Line_Rec.REQUEST_ID,
1124: p_PROGRAM_APPLICATION_ID => l_Line_Rec.PROGRAM_APPLICATION_ID,
1125: p_PROGRAM_ID => l_Line_Rec.PROGRAM_ID,
1126: p_PROGRAM_UPDATE_DATE => l_Line_Rec.PROGRAM_UPDATE_DATE,

Line 1197: l_sales_credit_rec.last_updated_by := FND_GLOBAL.USER_ID;

1193: -- CLOSE c_salesgroup_id;
1194:
1195: -- Build l_sales_credit_rec
1196: l_sales_credit_rec.last_update_date := SYSDATE;
1197: l_sales_credit_rec.last_updated_by := FND_GLOBAL.USER_ID;
1198: l_sales_credit_rec.creation_Date := SYSDATE;
1199: l_sales_credit_rec.created_by := FND_GLOBAL.USER_ID;
1200: l_sales_credit_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
1201: l_sales_credit_rec.lead_id := l_Line_Rec.lead_id;

Line 1199: l_sales_credit_rec.created_by := FND_GLOBAL.USER_ID;

1195: -- Build l_sales_credit_rec
1196: l_sales_credit_rec.last_update_date := SYSDATE;
1197: l_sales_credit_rec.last_updated_by := FND_GLOBAL.USER_ID;
1198: l_sales_credit_rec.creation_Date := SYSDATE;
1199: l_sales_credit_rec.created_by := FND_GLOBAL.USER_ID;
1200: l_sales_credit_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
1201: l_sales_credit_rec.lead_id := l_Line_Rec.lead_id;
1202: l_sales_credit_rec.lead_line_id := l_LEAD_LINE_ID;
1203: l_sales_credit_rec.salesforce_id := l_identity_sales_member_rec.salesforce_id;

Line 1200: l_sales_credit_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

1196: l_sales_credit_rec.last_update_date := SYSDATE;
1197: l_sales_credit_rec.last_updated_by := FND_GLOBAL.USER_ID;
1198: l_sales_credit_rec.creation_Date := SYSDATE;
1199: l_sales_credit_rec.created_by := FND_GLOBAL.USER_ID;
1200: l_sales_credit_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
1201: l_sales_credit_rec.lead_id := l_Line_Rec.lead_id;
1202: l_sales_credit_rec.lead_line_id := l_LEAD_LINE_ID;
1203: l_sales_credit_rec.salesforce_id := l_identity_sales_member_rec.salesforce_id;
1204: l_sales_credit_rec.person_id := l_identity_sales_member_rec.employee_person_id;

Line 1778: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1774: -- Invoke table handler(AS_LEAD_LINES_PKG.Update_Row)
1775: AS_LEAD_LINES_PKG.Update_Row(
1776: p_LEAD_LINE_ID => l_Line_rec.LEAD_LINE_ID,
1777: p_LAST_UPDATE_DATE => SYSDATE,
1778: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1779: p_CREATION_DATE => FND_API.G_MISS_DATE,
1780: p_CREATED_BY => FND_API.G_MISS_NUM,
1781: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1782: p_REQUEST_ID => l_Line_rec.REQUEST_ID,

Line 1781: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

1777: p_LAST_UPDATE_DATE => SYSDATE,
1778: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1779: p_CREATION_DATE => FND_API.G_MISS_DATE,
1780: p_CREATED_BY => FND_API.G_MISS_NUM,
1781: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1782: p_REQUEST_ID => l_Line_rec.REQUEST_ID,
1783: p_PROGRAM_APPLICATION_ID => l_Line_rec.PROGRAM_APPLICATION_ID,
1784: p_PROGRAM_ID => l_Line_rec.PROGRAM_ID,
1785: p_PROGRAM_UPDATE_DATE => l_Line_rec.PROGRAM_UPDATE_DATE,