eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_LEADS_PVT dependencies on FND_GLOBAL

Line 3406: IF FND_GLOBAL.User_Id IS NULL

3402:
3403: -- ******************************************************************
3404: -- Validate Environment
3405: -- ******************************************************************
3406: IF FND_GLOBAL.User_Id IS NULL
3407: THEN
3408: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3409: THEN
3410: AS_UTILITY_PVT.Set_Message(

Line 3764: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

3760:
3761: AS_SALES_LEADS_PKG.Sales_Lead_Insert_Row(
3762: px_SALES_LEAD_ID => x_SALES_LEAD_ID,
3763: p_LAST_UPDATE_DATE => SYSDATE,
3764: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3765: p_CREATION_DATE => SYSDATE,
3766: p_CREATED_BY => FND_GLOBAL.USER_ID,
3767: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
3768: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

Line 3766: p_CREATED_BY => FND_GLOBAL.USER_ID,

3762: px_SALES_LEAD_ID => x_SALES_LEAD_ID,
3763: p_LAST_UPDATE_DATE => SYSDATE,
3764: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3765: p_CREATION_DATE => SYSDATE,
3766: p_CREATED_BY => FND_GLOBAL.USER_ID,
3767: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
3768: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
3769: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
3770: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

Line 3767: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

3763: p_LAST_UPDATE_DATE => SYSDATE,
3764: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3765: p_CREATION_DATE => SYSDATE,
3766: p_CREATED_BY => FND_GLOBAL.USER_ID,
3767: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
3768: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
3769: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
3770: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
3771: p_PROGRAM_UPDATE_DATE => SYSDATE,

Line 3768: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

3764: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3765: p_CREATION_DATE => SYSDATE,
3766: p_CREATED_BY => FND_GLOBAL.USER_ID,
3767: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
3768: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
3769: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
3770: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
3771: p_PROGRAM_UPDATE_DATE => SYSDATE,
3772: p_LEAD_NUMBER => x_SALES_LEAD_ID,

Line 3769: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,

3765: p_CREATION_DATE => SYSDATE,
3766: p_CREATED_BY => FND_GLOBAL.USER_ID,
3767: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
3768: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
3769: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
3770: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
3771: p_PROGRAM_UPDATE_DATE => SYSDATE,
3772: p_LEAD_NUMBER => x_SALES_LEAD_ID,
3773: --p_STATUS_CODE => l_qualified,

Line 3770: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

3766: p_CREATED_BY => FND_GLOBAL.USER_ID,
3767: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
3768: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
3769: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
3770: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
3771: p_PROGRAM_UPDATE_DATE => SYSDATE,
3772: p_LEAD_NUMBER => x_SALES_LEAD_ID,
3773: --p_STATUS_CODE => l_qualified,
3774: p_STATUS_CODE => l_SALES_LEAD_rec.STATUS_CODE,

Line 3911: p_created_by => fnd_global.user_id,

3907:
3908: AS_SALES_LEADS_LOG_PKG.Insert_Row(
3909: px_log_id => l_sales_lead_log_id ,
3910: p_sales_lead_id => l_sales_lead_id,
3911: p_created_by => fnd_global.user_id,
3912: p_creation_date => sysdate,
3913: p_last_updated_by => fnd_global.user_id,
3914: p_last_update_date => sysdate,
3915: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 3913: p_last_updated_by => fnd_global.user_id,

3909: px_log_id => l_sales_lead_log_id ,
3910: p_sales_lead_id => l_sales_lead_id,
3911: p_created_by => fnd_global.user_id,
3912: p_creation_date => sysdate,
3913: p_last_updated_by => fnd_global.user_id,
3914: p_last_update_date => sysdate,
3915: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3916: -- using standard parameters for program who columns
3917: p_request_id => FND_GLOBAL.Conc_Request_Id,

Line 3915: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

3911: p_created_by => fnd_global.user_id,
3912: p_creation_date => sysdate,
3913: p_last_updated_by => fnd_global.user_id,
3914: p_last_update_date => sysdate,
3915: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3916: -- using standard parameters for program who columns
3917: p_request_id => FND_GLOBAL.Conc_Request_Id,
3918: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
3919: p_program_id => FND_GLOBAL.Conc_Program_Id,

Line 3917: p_request_id => FND_GLOBAL.Conc_Request_Id,

3913: p_last_updated_by => fnd_global.user_id,
3914: p_last_update_date => sysdate,
3915: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3916: -- using standard parameters for program who columns
3917: p_request_id => FND_GLOBAL.Conc_Request_Id,
3918: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
3919: p_program_id => FND_GLOBAL.Conc_Program_Id,
3920: p_program_update_date => sysdate,
3921: p_status_code => l_sales_lead_rec.status_code,

Line 3918: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

3914: p_last_update_date => sysdate,
3915: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3916: -- using standard parameters for program who columns
3917: p_request_id => FND_GLOBAL.Conc_Request_Id,
3918: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
3919: p_program_id => FND_GLOBAL.Conc_Program_Id,
3920: p_program_update_date => sysdate,
3921: p_status_code => l_sales_lead_rec.status_code,
3922: p_assign_to_person_id => l_sales_lead_rec.assign_to_person_id,

Line 3919: p_program_id => FND_GLOBAL.Conc_Program_Id,

3915: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3916: -- using standard parameters for program who columns
3917: p_request_id => FND_GLOBAL.Conc_Request_Id,
3918: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
3919: p_program_id => FND_GLOBAL.Conc_Program_Id,
3920: p_program_update_date => sysdate,
3921: p_status_code => l_sales_lead_rec.status_code,
3922: p_assign_to_person_id => l_sales_lead_rec.assign_to_person_id,
3923: p_assign_to_salesforce_id=>l_sales_lead_rec.assign_to_salesforce_id,

Line 3946: p_created_by => fnd_global.user_id,

3942:
3943: AS_SALES_LEADS_LOG_PKG.Insert_Row(
3944: px_log_id => l_sales_lead_log_id ,
3945: p_sales_lead_id => l_sales_lead_id,
3946: p_created_by => fnd_global.user_id,
3947: p_creation_date => sysdate,
3948: p_last_updated_by => fnd_global.user_id,
3949: p_last_update_date => sysdate,
3950: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 3948: p_last_updated_by => fnd_global.user_id,

3944: px_log_id => l_sales_lead_log_id ,
3945: p_sales_lead_id => l_sales_lead_id,
3946: p_created_by => fnd_global.user_id,
3947: p_creation_date => sysdate,
3948: p_last_updated_by => fnd_global.user_id,
3949: p_last_update_date => sysdate,
3950: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3951: -- using standard parameters for program who columns
3952: p_request_id => FND_GLOBAL.Conc_Request_Id,

Line 3950: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

3946: p_created_by => fnd_global.user_id,
3947: p_creation_date => sysdate,
3948: p_last_updated_by => fnd_global.user_id,
3949: p_last_update_date => sysdate,
3950: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3951: -- using standard parameters for program who columns
3952: p_request_id => FND_GLOBAL.Conc_Request_Id,
3953: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
3954: p_program_id => FND_GLOBAL.Conc_Program_Id,

Line 3952: p_request_id => FND_GLOBAL.Conc_Request_Id,

3948: p_last_updated_by => fnd_global.user_id,
3949: p_last_update_date => sysdate,
3950: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3951: -- using standard parameters for program who columns
3952: p_request_id => FND_GLOBAL.Conc_Request_Id,
3953: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
3954: p_program_id => FND_GLOBAL.Conc_Program_Id,
3955: p_program_update_date => sysdate,
3956: p_status_code => l_referral_status_profile, -- for referral log, we use referral status

Line 3953: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

3949: p_last_update_date => sysdate,
3950: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3951: -- using standard parameters for program who columns
3952: p_request_id => FND_GLOBAL.Conc_Request_Id,
3953: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
3954: p_program_id => FND_GLOBAL.Conc_Program_Id,
3955: p_program_update_date => sysdate,
3956: p_status_code => l_referral_status_profile, -- for referral log, we use referral status
3957: p_assign_to_person_id => l_sales_lead_rec.assign_to_person_id,

Line 3954: p_program_id => FND_GLOBAL.Conc_Program_Id,

3950: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3951: -- using standard parameters for program who columns
3952: p_request_id => FND_GLOBAL.Conc_Request_Id,
3953: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
3954: p_program_id => FND_GLOBAL.Conc_Program_Id,
3955: p_program_update_date => sysdate,
3956: p_status_code => l_referral_status_profile, -- for referral log, we use referral status
3957: p_assign_to_person_id => l_sales_lead_rec.assign_to_person_id,
3958: p_assign_to_salesforce_id=>l_sales_lead_rec.assign_to_salesforce_id,

Line 4014: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;

4010: l_sales_lead_rec.assign_to_salesforce_id <> FND_API.G_MISS_NUM THEN
4011: -- Create access security in as_accesses_all
4012: -- l_Sales_Team_Rec.access_id := FND_API.G_MISS_NUM;
4013: l_Sales_Team_Rec.last_update_date := SYSDATE;
4014: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
4015: l_Sales_Team_Rec.creation_date := SYSDATE;
4016: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;
4017: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
4018: -- l_Sales_Team_Rec.team_leader_flag := FND_API.G_MISS_CHAR;

Line 4016: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;

4012: -- l_Sales_Team_Rec.access_id := FND_API.G_MISS_NUM;
4013: l_Sales_Team_Rec.last_update_date := SYSDATE;
4014: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
4015: l_Sales_Team_Rec.creation_date := SYSDATE;
4016: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;
4017: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
4018: -- l_Sales_Team_Rec.team_leader_flag := FND_API.G_MISS_CHAR;
4019: l_Sales_Team_Rec.customer_id := l_SALES_LEAD_rec.Customer_Id;
4020: l_Sales_Team_Rec.address_id := l_SALES_LEAD_rec.Address_Id;

Line 4017: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

4013: l_Sales_Team_Rec.last_update_date := SYSDATE;
4014: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
4015: l_Sales_Team_Rec.creation_date := SYSDATE;
4016: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;
4017: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
4018: -- l_Sales_Team_Rec.team_leader_flag := FND_API.G_MISS_CHAR;
4019: l_Sales_Team_Rec.customer_id := l_SALES_LEAD_rec.Customer_Id;
4020: l_Sales_Team_Rec.address_id := l_SALES_LEAD_rec.Address_Id;
4021: l_Sales_Team_Rec.salesforce_id :=

Line 5294: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

5290: -- Invoke table handler(Sales_Lead_Update_Row)
5291: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5292: p_SALES_LEAD_ID => l_tar_SALES_LEAD_rec.SALES_LEAD_ID,
5293: p_LAST_UPDATE_DATE => SYSDATE,
5294: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5295: p_CREATION_DATE => l_tar_SALES_LEAD_rec.CREATION_DATE,
5296: p_CREATED_BY => l_tar_SALES_LEAD_rec.CREATED_BY,
5297: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
5298: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

Line 5297: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

5293: p_LAST_UPDATE_DATE => SYSDATE,
5294: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5295: p_CREATION_DATE => l_tar_SALES_LEAD_rec.CREATION_DATE,
5296: p_CREATED_BY => l_tar_SALES_LEAD_rec.CREATED_BY,
5297: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
5298: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5299: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5300: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5301: p_PROGRAM_UPDATE_DATE => SYSDATE,

Line 5298: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

5294: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5295: p_CREATION_DATE => l_tar_SALES_LEAD_rec.CREATION_DATE,
5296: p_CREATED_BY => l_tar_SALES_LEAD_rec.CREATED_BY,
5297: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
5298: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5299: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5300: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5301: p_PROGRAM_UPDATE_DATE => SYSDATE,
5302: p_LEAD_NUMBER => l_tar_SALES_LEAD_rec.LEAD_NUMBER,

Line 5299: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,

5295: p_CREATION_DATE => l_tar_SALES_LEAD_rec.CREATION_DATE,
5296: p_CREATED_BY => l_tar_SALES_LEAD_rec.CREATED_BY,
5297: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
5298: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5299: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5300: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5301: p_PROGRAM_UPDATE_DATE => SYSDATE,
5302: p_LEAD_NUMBER => l_tar_SALES_LEAD_rec.LEAD_NUMBER,
5303: --p_STATUS_CODE => l_qualified,

Line 5300: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

5296: p_CREATED_BY => l_tar_SALES_LEAD_rec.CREATED_BY,
5297: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
5298: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5299: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5300: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5301: p_PROGRAM_UPDATE_DATE => SYSDATE,
5302: p_LEAD_NUMBER => l_tar_SALES_LEAD_rec.LEAD_NUMBER,
5303: --p_STATUS_CODE => l_qualified,
5304: p_STATUS_CODE => l_tar_SALES_LEAD_rec.STATUS_CODE,

Line 5593: p_created_by => fnd_global.user_id,

5589: -- Call API to create log entry
5590: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5591: px_log_id => l_sales_lead_log_id ,
5592: p_sales_lead_id => l_tar_sales_lead_rec.sales_lead_id,
5593: p_created_by => fnd_global.user_id,
5594: p_creation_date => sysdate,
5595: p_last_updated_by => fnd_global.user_id,
5596: p_last_update_date => sysdate,
5597: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 5595: p_last_updated_by => fnd_global.user_id,

5591: px_log_id => l_sales_lead_log_id ,
5592: p_sales_lead_id => l_tar_sales_lead_rec.sales_lead_id,
5593: p_created_by => fnd_global.user_id,
5594: p_creation_date => sysdate,
5595: p_last_updated_by => fnd_global.user_id,
5596: p_last_update_date => sysdate,
5597: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5598: -- using standard parameters for program who columns
5599: p_request_id => FND_GLOBAL.Conc_Request_Id,

Line 5597: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

5593: p_created_by => fnd_global.user_id,
5594: p_creation_date => sysdate,
5595: p_last_updated_by => fnd_global.user_id,
5596: p_last_update_date => sysdate,
5597: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5598: -- using standard parameters for program who columns
5599: p_request_id => FND_GLOBAL.Conc_Request_Id,
5600: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5601: p_program_id => FND_GLOBAL.Conc_Program_Id,

Line 5599: p_request_id => FND_GLOBAL.Conc_Request_Id,

5595: p_last_updated_by => fnd_global.user_id,
5596: p_last_update_date => sysdate,
5597: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5598: -- using standard parameters for program who columns
5599: p_request_id => FND_GLOBAL.Conc_Request_Id,
5600: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5601: p_program_id => FND_GLOBAL.Conc_Program_Id,
5602: p_program_update_date => sysdate,
5603: p_status_code =>

Line 5600: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

5596: p_last_update_date => sysdate,
5597: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5598: -- using standard parameters for program who columns
5599: p_request_id => FND_GLOBAL.Conc_Request_Id,
5600: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5601: p_program_id => FND_GLOBAL.Conc_Program_Id,
5602: p_program_update_date => sysdate,
5603: p_status_code =>
5604: --l_tar_sales_lead_rec.status_code,

Line 5601: p_program_id => FND_GLOBAL.Conc_Program_Id,

5597: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5598: -- using standard parameters for program who columns
5599: p_request_id => FND_GLOBAL.Conc_Request_Id,
5600: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5601: p_program_id => FND_GLOBAL.Conc_Program_Id,
5602: p_program_update_date => sysdate,
5603: p_status_code =>
5604: --l_tar_sales_lead_rec.status_code,
5605: l_log_status_code,

Line 5654: p_created_by => fnd_global.user_id,

5650:
5651: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5652: px_log_id => l_sales_lead_log_id ,
5653: p_sales_lead_id => l_tar_sales_lead_rec.sales_lead_id,
5654: p_created_by => fnd_global.user_id,
5655: p_creation_date => sysdate,
5656: p_last_updated_by => fnd_global.user_id,
5657: p_last_update_date => sysdate,
5658: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 5656: p_last_updated_by => fnd_global.user_id,

5652: px_log_id => l_sales_lead_log_id ,
5653: p_sales_lead_id => l_tar_sales_lead_rec.sales_lead_id,
5654: p_created_by => fnd_global.user_id,
5655: p_creation_date => sysdate,
5656: p_last_updated_by => fnd_global.user_id,
5657: p_last_update_date => sysdate,
5658: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5659: -- using standard parameters for program who columns
5660: p_request_id => FND_GLOBAL.Conc_Request_Id,

Line 5658: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

5654: p_created_by => fnd_global.user_id,
5655: p_creation_date => sysdate,
5656: p_last_updated_by => fnd_global.user_id,
5657: p_last_update_date => sysdate,
5658: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5659: -- using standard parameters for program who columns
5660: p_request_id => FND_GLOBAL.Conc_Request_Id,
5661: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5662: p_program_id => FND_GLOBAL.Conc_Program_Id,

Line 5660: p_request_id => FND_GLOBAL.Conc_Request_Id,

5656: p_last_updated_by => fnd_global.user_id,
5657: p_last_update_date => sysdate,
5658: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5659: -- using standard parameters for program who columns
5660: p_request_id => FND_GLOBAL.Conc_Request_Id,
5661: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5662: p_program_id => FND_GLOBAL.Conc_Program_Id,
5663: p_program_update_date => sysdate,
5664: p_status_code => l_referral_status_profile, -- for referral log, we use referral status

Line 5661: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

5657: p_last_update_date => sysdate,
5658: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5659: -- using standard parameters for program who columns
5660: p_request_id => FND_GLOBAL.Conc_Request_Id,
5661: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5662: p_program_id => FND_GLOBAL.Conc_Program_Id,
5663: p_program_update_date => sysdate,
5664: p_status_code => l_referral_status_profile, -- for referral log, we use referral status
5665: p_assign_to_person_id =>

Line 5662: p_program_id => FND_GLOBAL.Conc_Program_Id,

5658: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5659: -- using standard parameters for program who columns
5660: p_request_id => FND_GLOBAL.Conc_Request_Id,
5661: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5662: p_program_id => FND_GLOBAL.Conc_Program_Id,
5663: p_program_update_date => sysdate,
5664: p_status_code => l_referral_status_profile, -- for referral log, we use referral status
5665: p_assign_to_person_id =>
5666: --l_tar_sales_lead_rec.assign_to_person_id,

Line 5741: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;

5737: THEN
5738: -- Create access security in as_accesses_all
5739: -- l_Sales_Team_Rec.access_id := FND_API.G_MISS_NUM;
5740: l_Sales_Team_Rec.last_update_date := SYSDATE;
5741: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
5742: l_Sales_Team_Rec.creation_date := SYSDATE;
5743: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;
5744: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
5745:

Line 5743: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;

5739: -- l_Sales_Team_Rec.access_id := FND_API.G_MISS_NUM;
5740: l_Sales_Team_Rec.last_update_date := SYSDATE;
5741: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
5742: l_Sales_Team_Rec.creation_date := SYSDATE;
5743: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;
5744: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
5745:
5746: -- l_Sales_Team_Rec.team_leader_flag := FND_API.G_MISS_CHAR;
5747: l_Sales_Team_Rec.customer_id := l_tar_SALES_LEAD_rec.Customer_Id;

Line 5744: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

5740: l_Sales_Team_Rec.last_update_date := SYSDATE;
5741: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
5742: l_Sales_Team_Rec.creation_date := SYSDATE;
5743: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;
5744: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
5745:
5746: -- l_Sales_Team_Rec.team_leader_flag := FND_API.G_MISS_CHAR;
5747: l_Sales_Team_Rec.customer_id := l_tar_SALES_LEAD_rec.Customer_Id;
5748: l_Sales_Team_Rec.address_id := l_tar_SALES_LEAD_rec.Address_Id;

Line 5978: l_login_salesteam_rec.last_updated_by := FND_GLOBAL.USER_ID;

5974: -- now check if the logged in user is already in the salesteam or not.
5975: -- If already there, call update_sales_team otherwise call create_sales_team
5976:
5977: --l_login_salesteam_rec.last_update_date := SYSDATE;
5978: l_login_salesteam_rec.last_updated_by := FND_GLOBAL.USER_ID;
5979: --l_login_salesteam_rec.creation_date := SYSDATE;
5980: --l_login_salesteam_rec.created_by := FND_GLOBAL.USER_ID;
5981: l_login_salesteam_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
5982:

Line 5980: --l_login_salesteam_rec.created_by := FND_GLOBAL.USER_ID;

5976:
5977: --l_login_salesteam_rec.last_update_date := SYSDATE;
5978: l_login_salesteam_rec.last_updated_by := FND_GLOBAL.USER_ID;
5979: --l_login_salesteam_rec.creation_date := SYSDATE;
5980: --l_login_salesteam_rec.created_by := FND_GLOBAL.USER_ID;
5981: l_login_salesteam_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
5982:
5983: -- l_Sales_Team_Rec.team_leader_flag := FND_API.G_MISS_CHAR;
5984: l_login_salesteam_rec.salesforce_id :=

Line 5981: l_login_salesteam_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

5977: --l_login_salesteam_rec.last_update_date := SYSDATE;
5978: l_login_salesteam_rec.last_updated_by := FND_GLOBAL.USER_ID;
5979: --l_login_salesteam_rec.creation_date := SYSDATE;
5980: --l_login_salesteam_rec.created_by := FND_GLOBAL.USER_ID;
5981: l_login_salesteam_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
5982:
5983: -- l_Sales_Team_Rec.team_leader_flag := FND_API.G_MISS_CHAR;
5984: l_login_salesteam_rec.salesforce_id :=
5985: p_identity_salesforce_id;

Line 6048: l_login_salesteam_rec.created_by := FND_GLOBAL.USER_ID;

6044: END IF;
6045:
6046: l_login_salesteam_rec.last_update_date := SYSDATE;
6047: l_login_salesteam_rec.creation_date := SYSDATE;
6048: l_login_salesteam_rec.created_by := FND_GLOBAL.USER_ID;
6049: l_login_salesteam_rec.created_by_TAP_flag := 'N';
6050: l_login_salesteam_rec.customer_id := l_customer_id ; --l_tar_SALES_LEAD_rec.Customer_Id;
6051: l_login_salesteam_rec.address_id := l_tar_SALES_LEAD_rec.Address_Id;
6052: l_login_salesteam_rec.person_id := l_login_user_person_id;

Line 6096: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;

6092: l_tar_SALES_LEAD_rec.assign_to_salesforce_id = FND_API.G_MISS_NUM
6093: THEN
6094: -- Call update_salesteam to update the owner
6095:
6096: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
6097: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
6098: --l_Sales_Team_Rec.last_update_date := SYSDATE;
6099: -- l_Sales_Team_Rec.team_leader_flag := FND_API.G_MISS_CHAR;
6100: l_Sales_Team_Rec.customer_id := l_Customer_Id;

Line 6097: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

6093: THEN
6094: -- Call update_salesteam to update the owner
6095:
6096: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
6097: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
6098: --l_Sales_Team_Rec.last_update_date := SYSDATE;
6099: -- l_Sales_Team_Rec.team_leader_flag := FND_API.G_MISS_CHAR;
6100: l_Sales_Team_Rec.customer_id := l_Customer_Id;
6101: l_Sales_Team_Rec.address_id := l_tar_SALES_LEAD_rec.Address_Id;

Line 6184: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;

6180: l_tar_SALES_LEAD_rec.assign_to_salesforce_id <>
6181: l_assign_to_salesforce_id
6182: THEN
6183:
6184: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
6185: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
6186: --l_Sales_Team_Rec.last_update_date := SYSDATE;
6187: -- l_Sales_Team_Rec.team_leader_flag := FND_API.G_MISS_CHAR;
6188: l_Sales_Team_Rec.customer_id := l_Customer_Id;

Line 6185: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

6181: l_assign_to_salesforce_id
6182: THEN
6183:
6184: l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
6185: l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
6186: --l_Sales_Team_Rec.last_update_date := SYSDATE;
6187: -- l_Sales_Team_Rec.team_leader_flag := FND_API.G_MISS_CHAR;
6188: l_Sales_Team_Rec.customer_id := l_Customer_Id;
6189: l_Sales_Team_Rec.address_id := l_tar_SALES_LEAD_rec.Address_Id;

Line 6308: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;

6304: END IF;
6305:
6306: l_Sales_Team_Rec.last_update_date := SYSDATE;
6307: l_Sales_Team_Rec.creation_date := SYSDATE;
6308: l_Sales_Team_Rec.created_by := FND_GLOBAL.USER_ID;
6309: l_Sales_Team_Rec.created_by_TAP_flag := 'N';
6310:
6311: AS_ACCESS_PUB.Create_SalesTeam (
6312: p_api_version_number => 2.0

Line 6358: last_updated_by = fnd_global.user_id,

6354: if (l_old_status_flag = 'Y' AND l_new_status_flag = 'N') then
6355:
6356: update as_accesses_all
6357: set open_flag = null , last_update_date = sysdate,
6358: last_updated_by = fnd_global.user_id,
6359: last_update_login = fnd_global.conc_login_id
6360: where sales_lead_id = l_tar_SALES_LEAD_rec.SALES_LEAD_ID;
6361:
6362: elsif ( l_old_status_flag = 'N' AND l_new_status_flag = 'Y') then

Line 6359: last_update_login = fnd_global.conc_login_id

6355:
6356: update as_accesses_all
6357: set open_flag = null , last_update_date = sysdate,
6358: last_updated_by = fnd_global.user_id,
6359: last_update_login = fnd_global.conc_login_id
6360: where sales_lead_id = l_tar_SALES_LEAD_rec.SALES_LEAD_ID;
6361:
6362: elsif ( l_old_status_flag = 'N' AND l_new_status_flag = 'Y') then
6363:

Line 6366: last_updated_by = fnd_global.user_id,

6362: elsif ( l_old_status_flag = 'N' AND l_new_status_flag = 'Y') then
6363:
6364: update as_accesses_all
6365: set open_flag = 'Y', last_update_date = sysdate,
6366: last_updated_by = fnd_global.user_id,
6367: last_update_login = fnd_global.conc_login_id
6368: where sales_lead_id = l_tar_SALES_LEAD_rec.SALES_LEAD_ID;
6369:
6370: end if;

Line 6367: last_update_login = fnd_global.conc_login_id

6363:
6364: update as_accesses_all
6365: set open_flag = 'Y', last_update_date = sysdate,
6366: last_updated_by = fnd_global.user_id,
6367: last_update_login = fnd_global.conc_login_id
6368: where sales_lead_id = l_tar_SALES_LEAD_rec.SALES_LEAD_ID;
6369:
6370: end if;
6371:

Line 6390: last_updated_by = fnd_global.user_id,

6386: if ( l_new_lead_rank_score <> FND_API.G_MISS_NUM ) THEN
6387: -- update the as_accesses_all.lead_rank_score if the rank has been changed i.e not g_miss
6388: update as_accesses_all
6389: set lead_rank_score = l_new_lead_rank_score , last_update_date = sysdate,
6390: last_updated_by = fnd_global.user_id,
6391: last_update_login = fnd_global.conc_login_id
6392: where sales_lead_id = l_tar_SALES_LEAD_rec.SALES_LEAD_ID;
6393:
6394: END IF;

Line 6391: last_update_login = fnd_global.conc_login_id

6387: -- update the as_accesses_all.lead_rank_score if the rank has been changed i.e not g_miss
6388: update as_accesses_all
6389: set lead_rank_score = l_new_lead_rank_score , last_update_date = sysdate,
6390: last_updated_by = fnd_global.user_id,
6391: last_update_login = fnd_global.conc_login_id
6392: where sales_lead_id = l_tar_SALES_LEAD_rec.SALES_LEAD_ID;
6393:
6394: END IF;
6395: