DBA Data[Home] [Help]

APPS.AS_LEAD_ROUTING_WF dependencies on FND_GLOBAL

Line 257: AND res.user_id = fnd_global.user_id;

253: CURSOR C_get_current_resource IS
254: SELECT res.resource_id
255: FROM jtf_rs_resource_extns res
256: WHERE res.category = 'EMPLOYEE'
257: AND res.user_id = fnd_global.user_id;
258:
259: CURSOR c_get_group_id(c_resource_id NUMBER) IS
260: SELECT grp.group_id
261: FROM JTF_RS_GROUP_MEMBERS mem,

Line 965: p_created_by => fnd_global.user_id,

961: -- Call API to create log entry
962: AS_SALES_LEADS_LOG_PKG.Insert_Row(
963: px_log_id => l_sales_lead_log_id ,
964: p_sales_lead_id => l_sales_lead_id,
965: p_created_by => fnd_global.user_id,
966: p_creation_date => SYSDATE,
967: p_last_updated_by => fnd_global.user_id,
968: p_last_update_date => SYSDATE,
969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 967: p_last_updated_by => fnd_global.user_id,

963: px_log_id => l_sales_lead_log_id ,
964: p_sales_lead_id => l_sales_lead_id,
965: p_created_by => fnd_global.user_id,
966: p_creation_date => SYSDATE,
967: p_last_updated_by => fnd_global.user_id,
968: p_last_update_date => SYSDATE,
969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
970: p_request_id => FND_GLOBAL.Conc_Request_Id,
971: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

Line 969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

965: p_created_by => fnd_global.user_id,
966: p_creation_date => SYSDATE,
967: p_last_updated_by => fnd_global.user_id,
968: p_last_update_date => SYSDATE,
969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
970: p_request_id => FND_GLOBAL.Conc_Request_Id,
971: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
972: p_program_id => FND_GLOBAL.Conc_Program_Id,
973: p_program_update_date => SYSDATE,

Line 970: p_request_id => FND_GLOBAL.Conc_Request_Id,

966: p_creation_date => SYSDATE,
967: p_last_updated_by => fnd_global.user_id,
968: p_last_update_date => SYSDATE,
969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
970: p_request_id => FND_GLOBAL.Conc_Request_Id,
971: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
972: p_program_id => FND_GLOBAL.Conc_Program_Id,
973: p_program_update_date => SYSDATE,
974: p_status_code => l_status_code,

Line 971: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

967: p_last_updated_by => fnd_global.user_id,
968: p_last_update_date => SYSDATE,
969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
970: p_request_id => FND_GLOBAL.Conc_Request_Id,
971: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
972: p_program_id => FND_GLOBAL.Conc_Program_Id,
973: p_program_update_date => SYSDATE,
974: p_status_code => l_status_code,
975: p_assign_to_person_id => l_person_id,

Line 972: p_program_id => FND_GLOBAL.Conc_Program_Id,

968: p_last_update_date => SYSDATE,
969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
970: p_request_id => FND_GLOBAL.Conc_Request_Id,
971: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
972: p_program_id => FND_GLOBAL.Conc_Program_Id,
973: p_program_update_date => SYSDATE,
974: p_status_code => l_status_code,
975: p_assign_to_person_id => l_person_id,
976: p_assign_to_salesforce_id => l_resource_id,

Line 988: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

984: -- in case current user doesn't have update privilege.
985: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
986: p_SALES_LEAD_ID => l_SALES_LEAD_ID,
987: p_LAST_UPDATE_DATE => SYSDATE,
988: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
989: p_CREATION_DATE => FND_API.G_MISS_DATE,
990: p_CREATED_BY => FND_API.G_MISS_NUM,
991: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

Line 992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

988: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
989: p_CREATION_DATE => FND_API.G_MISS_DATE,
990: p_CREATED_BY => FND_API.G_MISS_NUM,
991: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
993: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
994: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
995: p_PROGRAM_UPDATE_DATE => SYSDATE,
996: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,

Line 993: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,

989: p_CREATION_DATE => FND_API.G_MISS_DATE,
990: p_CREATED_BY => FND_API.G_MISS_NUM,
991: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
993: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
994: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
995: p_PROGRAM_UPDATE_DATE => SYSDATE,
996: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
997: p_STATUS_CODE => FND_API.G_MISS_CHAR,

Line 994: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

990: p_CREATED_BY => FND_API.G_MISS_NUM,
991: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
993: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
994: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
995: p_PROGRAM_UPDATE_DATE => SYSDATE,
996: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
997: p_STATUS_CODE => FND_API.G_MISS_CHAR,
998: p_CUSTOMER_ID => l_CUSTOMER_ID,

Line 1129: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,

1125: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
1126: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
1127: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
1128: ,OBJECT_CREATION_DATE)
1129: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
1130: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, 'X',
1131: l_freeze_flag ,'N', 'Y', 'Y', 'Y',
1132: l_customer_id, l_address_id, l_sales_lead_id,
1133: l_resource_id, l_person_id, l_group_id, l_open_status_flag,

Line 1130: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, 'X',

1126: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
1127: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
1128: ,OBJECT_CREATION_DATE)
1129: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
1130: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, 'X',
1131: l_freeze_flag ,'N', 'Y', 'Y', 'Y',
1132: l_customer_id, l_address_id, l_sales_lead_id,
1133: l_resource_id, l_person_id, l_group_id, l_open_status_flag,
1134: l_lead_rank_score, l_creation_date