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_LEAD_ASSIGN_PVT dependencies on FND_GLOBAL

Line 429: IF FND_GLOBAL.User_Id IS NULL

425: -- Validate Environment
426: -- ******************************************************************
427:
428: /* ffang 112800
429: IF FND_GLOBAL.User_Id IS NULL
430: THEN
431: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
432: THEN
433: AS_UTILITY_PVT.Set_Message(

Line 772: IF FND_GLOBAL.User_Id IS NULL

768: --
769: -- ******************************************************************
770: -- Validate Environment
771: -- ******************************************************************
772: IF FND_GLOBAL.User_Id IS NULL
773: THEN
774: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
775: THEN
776: AS_UTILITY_PVT.Set_Message(

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

1167: CURSOR C_get_current_resource IS
1168: SELECT res.resource_id
1169: FROM jtf_rs_resource_extns res
1170: WHERE res.category IN ('EMPLOYEE', 'PARTY')
1171: AND res.user_id = fnd_global.user_id;
1172:
1173: CURSOR c_get_group_id (c_resource_id NUMBER, c_rs_group_member VARCHAR2,
1174: c_sales VARCHAR2, c_telesales VARCHAR2,
1175: c_fieldsales VARCHAR2, c_prm VARCHAR2, c_y VARCHAR2) IS

Line 1297: IF FND_GLOBAL.User_Id IS NULL

1293: -- ******************************************************************
1294: -- Validate Environment
1295: -- ******************************************************************
1296:
1297: IF FND_GLOBAL.User_Id IS NULL
1298: THEN
1299: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1300: THEN
1301: AS_UTILITY_PVT.Set_Message(

Line 1846: l_request_id := FND_GLOBAL.Conc_Request_Id;

1842: END IF; -- resource type
1843: END LOOP; -- l_AssignResources_tbl.first..l_AssignResources_tbl.last
1844: END IF; -- l_AssignResources_tbl.COUNT > 0
1845:
1846: l_request_id := FND_GLOBAL.Conc_Request_Id;
1847: IF (AS_DEBUG_LOW_ON) THEN
1848: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1849: 'req_id :' || l_request_id);
1850: END IF;

Line 2471: IF FND_GLOBAL.User_Id IS NULL

2467: -- ******************************************************************
2468: -- Validate Environment
2469: -- ******************************************************************
2470:
2471: IF FND_GLOBAL.User_Id IS NULL
2472: THEN
2473: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2474: THEN
2475: AS_UTILITY_PVT.Set_Message(

Line 2738: l_request_id := FND_GLOBAL.Conc_Request_Id;

2734: THEN
2735: RAISE FND_API.G_EXC_ERROR;
2736: END IF;
2737:
2738: l_request_id := FND_GLOBAL.Conc_Request_Id;
2739: IF (AS_DEBUG_LOW_ON) THEN
2740: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2741: 'count=' || l_assignresources_tbl.count);
2742: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 3894: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

3890:
3891: FORALL l_i IN 1..l_u_num_rows
3892: UPDATE AS_ACCESSES_ALL
3893: SET LAST_UPDATE_DATE = SYSDATE,
3894: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3895: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
3896: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
3897: PROGRAM_UPDATE_DATE = SYSDATE,
3898: TEAM_LEADER_FLAG = g_u_full_access_flag(l_i),

Line 3895: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

3891: FORALL l_i IN 1..l_u_num_rows
3892: UPDATE AS_ACCESSES_ALL
3893: SET LAST_UPDATE_DATE = SYSDATE,
3894: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3895: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
3896: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
3897: PROGRAM_UPDATE_DATE = SYSDATE,
3898: TEAM_LEADER_FLAG = g_u_full_access_flag(l_i),
3899: REQUEST_ID = p_request_id

Line 3896: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,

3892: UPDATE AS_ACCESSES_ALL
3893: SET LAST_UPDATE_DATE = SYSDATE,
3894: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3895: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
3896: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
3897: PROGRAM_UPDATE_DATE = SYSDATE,
3898: TEAM_LEADER_FLAG = g_u_full_access_flag(l_i),
3899: REQUEST_ID = p_request_id
3900: WHERE ACCESS_ID = g_u_access_id(l_i);

Line 3918: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

3914:
3915: FORALL l_i IN 1..l_tu_num_rows
3916: UPDATE AS_TERRITORY_ACCESSES
3917: SET LAST_UPDATE_DATE = SYSDATE,
3918: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3919: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
3920: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
3921: PROGRAM_UPDATE_DATE = SYSDATE,
3922: REQUEST_ID = p_request_id

Line 3919: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

3915: FORALL l_i IN 1..l_tu_num_rows
3916: UPDATE AS_TERRITORY_ACCESSES
3917: SET LAST_UPDATE_DATE = SYSDATE,
3918: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3919: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
3920: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
3921: PROGRAM_UPDATE_DATE = SYSDATE,
3922: REQUEST_ID = p_request_id
3923: WHERE ACCESS_ID = g_tu_access_id(l_i)

Line 3920: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,

3916: UPDATE AS_TERRITORY_ACCESSES
3917: SET LAST_UPDATE_DATE = SYSDATE,
3918: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3919: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
3920: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
3921: PROGRAM_UPDATE_DATE = SYSDATE,
3922: REQUEST_ID = p_request_id
3923: WHERE ACCESS_ID = g_tu_access_id(l_i)
3924: AND TERRITORY_ID = g_tu_territory_id(l_i);

Line 3996: FND_GLOBAL.USER_ID,

3992: g_i_full_access_flag(l_i),
3993: 'N',
3994: DECODE(g_i_source(l_i), 'TERRITORY', 'Y', 'N'),
3995: SYSDATE,
3996: FND_GLOBAL.USER_ID,
3997: SYSDATE,
3998: FND_GLOBAL.USER_ID,
3999: FND_GLOBAL.CONC_LOGIN_ID,
4000: FND_GLOBAL.PROG_APPL_ID,

Line 3998: FND_GLOBAL.USER_ID,

3994: DECODE(g_i_source(l_i), 'TERRITORY', 'Y', 'N'),
3995: SYSDATE,
3996: FND_GLOBAL.USER_ID,
3997: SYSDATE,
3998: FND_GLOBAL.USER_ID,
3999: FND_GLOBAL.CONC_LOGIN_ID,
4000: FND_GLOBAL.PROG_APPL_ID,
4001: SYSDATE,
4002: p_request_id,

Line 3999: FND_GLOBAL.CONC_LOGIN_ID,

3995: SYSDATE,
3996: FND_GLOBAL.USER_ID,
3997: SYSDATE,
3998: FND_GLOBAL.USER_ID,
3999: FND_GLOBAL.CONC_LOGIN_ID,
4000: FND_GLOBAL.PROG_APPL_ID,
4001: SYSDATE,
4002: p_request_id,
4003: l_open_status_flag,

Line 4000: FND_GLOBAL.PROG_APPL_ID,

3996: FND_GLOBAL.USER_ID,
3997: SYSDATE,
3998: FND_GLOBAL.USER_ID,
3999: FND_GLOBAL.CONC_LOGIN_ID,
4000: FND_GLOBAL.PROG_APPL_ID,
4001: SYSDATE,
4002: p_request_id,
4003: l_open_status_flag,
4004: l_lead_rank_score,

Line 4041: FND_GLOBAL.USER_ID,

4037: (g_ti_access_id(l_i),
4038: g_ti_territory_id(l_i),
4039: g_ti_territory_id(l_i),
4040: SYSDATE,
4041: FND_GLOBAL.USER_ID,
4042: SYSDATE,
4043: FND_GLOBAL.USER_ID,
4044: FND_GLOBAL.CONC_LOGIN_ID,
4045: FND_GLOBAL.PROG_APPL_ID,

Line 4043: FND_GLOBAL.USER_ID,

4039: g_ti_territory_id(l_i),
4040: SYSDATE,
4041: FND_GLOBAL.USER_ID,
4042: SYSDATE,
4043: FND_GLOBAL.USER_ID,
4044: FND_GLOBAL.CONC_LOGIN_ID,
4045: FND_GLOBAL.PROG_APPL_ID,
4046: SYSDATE,
4047: p_request_id);

Line 4044: FND_GLOBAL.CONC_LOGIN_ID,

4040: SYSDATE,
4041: FND_GLOBAL.USER_ID,
4042: SYSDATE,
4043: FND_GLOBAL.USER_ID,
4044: FND_GLOBAL.CONC_LOGIN_ID,
4045: FND_GLOBAL.PROG_APPL_ID,
4046: SYSDATE,
4047: p_request_id);
4048: END IF;

Line 4045: FND_GLOBAL.PROG_APPL_ID,

4041: FND_GLOBAL.USER_ID,
4042: SYSDATE,
4043: FND_GLOBAL.USER_ID,
4044: FND_GLOBAL.CONC_LOGIN_ID,
4045: FND_GLOBAL.PROG_APPL_ID,
4046: SYSDATE,
4047: p_request_id);
4048: END IF;
4049:

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

4108: CURSOR C_get_current_resource IS
4109: SELECT res.resource_id
4110: FROM jtf_rs_resource_extns res
4111: WHERE res.category IN ('EMPLOYEE', 'PARTY')
4112: AND res.user_id = fnd_global.user_id;
4113:
4114: -- A resource may not be in any group. Besides, jtf_rs_group_members
4115: -- may not have person_id for all resources. Therefore, get person_id
4116: -- is this cursor.

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

4254: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
4255: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4256: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
4257: ,OBJECT_CREATION_DATE)
4258: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4259: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4260: FND_GLOBAL.PROG_APPL_ID, SYSDATE,
4261: 'X', 'Y' ,'N', 'Y', 'N', 'N',
4262: p_customer_id, p_address_id, p_sales_lead_id,

Line 4259: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,

4255: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4256: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
4257: ,OBJECT_CREATION_DATE)
4258: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4259: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4260: FND_GLOBAL.PROG_APPL_ID, SYSDATE,
4261: 'X', 'Y' ,'N', 'Y', 'N', 'N',
4262: p_customer_id, p_address_id, p_sales_lead_id,
4263: l_rs_id, l_person_id, l_group_id, l_open_status_flag,

Line 4260: FND_GLOBAL.PROG_APPL_ID, SYSDATE,

4256: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
4257: ,OBJECT_CREATION_DATE)
4258: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4259: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4260: FND_GLOBAL.PROG_APPL_ID, SYSDATE,
4261: 'X', 'Y' ,'N', 'Y', 'N', 'N',
4262: p_customer_id, p_address_id, p_sales_lead_id,
4263: l_rs_id, l_person_id, l_group_id, l_open_status_flag,
4264: l_lead_rank_score, l_creation_date

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

4319: CURSOR C_get_current_resource IS
4320: SELECT res.resource_id
4321: FROM jtf_rs_resource_extns res
4322: WHERE res.category IN ('EMPLOYEE', 'PARTY')
4323: AND res.user_id = fnd_global.user_id;
4324:
4325: CURSOR c_get_group_id(c_resource_id NUMBER) IS
4326: SELECT grp.group_id
4327: FROM JTF_RS_GROUP_MEMBERS mem,

Line 4465: p_created_by => fnd_global.user_id,

4461: -- Call API to create log entry
4462: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4463: px_log_id => l_sales_lead_log_id ,
4464: p_sales_lead_id => p_sales_lead_id,
4465: p_created_by => fnd_global.user_id,
4466: p_creation_date => SYSDATE,
4467: p_last_updated_by => fnd_global.user_id,
4468: p_last_update_date => SYSDATE,
4469: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 4467: p_last_updated_by => fnd_global.user_id,

4463: px_log_id => l_sales_lead_log_id ,
4464: p_sales_lead_id => p_sales_lead_id,
4465: p_created_by => fnd_global.user_id,
4466: p_creation_date => SYSDATE,
4467: p_last_updated_by => fnd_global.user_id,
4468: p_last_update_date => SYSDATE,
4469: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4470: p_request_id => FND_GLOBAL.Conc_Request_Id,
4471: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

Line 4469: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

4465: p_created_by => fnd_global.user_id,
4466: p_creation_date => SYSDATE,
4467: p_last_updated_by => fnd_global.user_id,
4468: p_last_update_date => SYSDATE,
4469: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4470: p_request_id => FND_GLOBAL.Conc_Request_Id,
4471: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
4472: p_program_id => FND_GLOBAL.Conc_Program_Id,
4473: p_program_update_date => SYSDATE,

Line 4470: p_request_id => FND_GLOBAL.Conc_Request_Id,

4466: p_creation_date => SYSDATE,
4467: p_last_updated_by => fnd_global.user_id,
4468: p_last_update_date => SYSDATE,
4469: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4470: p_request_id => FND_GLOBAL.Conc_Request_Id,
4471: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
4472: p_program_id => FND_GLOBAL.Conc_Program_Id,
4473: p_program_update_date => SYSDATE,
4474: p_status_code => l_status_code, --l_routing_status,

Line 4471: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

4467: p_last_updated_by => fnd_global.user_id,
4468: p_last_update_date => SYSDATE,
4469: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4470: p_request_id => FND_GLOBAL.Conc_Request_Id,
4471: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
4472: p_program_id => FND_GLOBAL.Conc_Program_Id,
4473: p_program_update_date => SYSDATE,
4474: p_status_code => l_status_code, --l_routing_status,
4475: p_assign_to_person_id => l_person_id,

Line 4472: p_program_id => FND_GLOBAL.Conc_Program_Id,

4468: p_last_update_date => SYSDATE,
4469: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4470: p_request_id => FND_GLOBAL.Conc_Request_Id,
4471: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
4472: p_program_id => FND_GLOBAL.Conc_Program_Id,
4473: p_program_update_date => SYSDATE,
4474: p_status_code => l_status_code, --l_routing_status,
4475: p_assign_to_person_id => l_person_id,
4476: p_assign_to_salesforce_id => l_resource_id,

Line 4488: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

4484: -- in case current user doesn't have update privilege.
4485: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
4486: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4487: p_LAST_UPDATE_DATE => SYSDATE,
4488: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4489: p_CREATION_DATE => FND_API.G_MISS_DATE,
4490: p_CREATED_BY => FND_API.G_MISS_NUM,
4491: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4492: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

Line 4492: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

4488: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4489: p_CREATION_DATE => FND_API.G_MISS_DATE,
4490: p_CREATED_BY => FND_API.G_MISS_NUM,
4491: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4492: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4493: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4494: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4495: p_PROGRAM_UPDATE_DATE => SYSDATE,
4496: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,

Line 4493: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,

4489: p_CREATION_DATE => FND_API.G_MISS_DATE,
4490: p_CREATED_BY => FND_API.G_MISS_NUM,
4491: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4492: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4493: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4494: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4495: p_PROGRAM_UPDATE_DATE => SYSDATE,
4496: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4497: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,

Line 4494: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

4490: p_CREATED_BY => FND_API.G_MISS_NUM,
4491: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4492: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4493: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4494: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4495: p_PROGRAM_UPDATE_DATE => SYSDATE,
4496: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4497: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4498: p_CUSTOMER_ID => l_CUSTOMER_ID,

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

4622: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
4623: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4624: ,PERSON_ID, SALES_GROUP_ID, REQUEST_ID, OPEN_FLAG
4625: ,LEAD_RANK_SCORE, OBJECT_CREATION_DATE)
4626: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4627: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4628: FND_GLOBAL.PROG_APPL_ID, SYSDATE,
4629: 'X', l_freeze_flag ,'N','Y', 'Y', 'N',
4630: l_customer_id, l_address_id, p_sales_lead_id,

Line 4627: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,

4623: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4624: ,PERSON_ID, SALES_GROUP_ID, REQUEST_ID, OPEN_FLAG
4625: ,LEAD_RANK_SCORE, OBJECT_CREATION_DATE)
4626: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4627: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4628: FND_GLOBAL.PROG_APPL_ID, SYSDATE,
4629: 'X', l_freeze_flag ,'N','Y', 'Y', 'N',
4630: l_customer_id, l_address_id, p_sales_lead_id,
4631: l_resource_id, l_person_id, l_group_id, p_request_id,

Line 4628: FND_GLOBAL.PROG_APPL_ID, SYSDATE,

4624: ,PERSON_ID, SALES_GROUP_ID, REQUEST_ID, OPEN_FLAG
4625: ,LEAD_RANK_SCORE, OBJECT_CREATION_DATE)
4626: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4627: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4628: FND_GLOBAL.PROG_APPL_ID, SYSDATE,
4629: 'X', l_freeze_flag ,'N','Y', 'Y', 'N',
4630: l_customer_id, l_address_id, p_sales_lead_id,
4631: l_resource_id, l_person_id, l_group_id, p_request_id,
4632: l_open_status_flag, l_lead_rank_score, l_creation_date

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

4700: CURSOR C_get_current_resource IS
4701: SELECT res.resource_id
4702: FROM jtf_rs_resource_extns res
4703: WHERE res.category IN ('EMPLOYEE', 'PARTY')
4704: AND res.user_id = fnd_global.user_id;
4705:
4706: CURSOR c_get_group_id(c_resource_id NUMBER) IS
4707: SELECT grp.group_id
4708: FROM JTF_RS_GROUP_MEMBERS mem,

Line 4806: p_created_by => fnd_global.user_id,

4802: -- Call API to create log entry
4803: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4804: px_log_id => l_sales_lead_log_id ,
4805: p_sales_lead_id => p_sales_lead_id,
4806: p_created_by => fnd_global.user_id,
4807: p_creation_date => SYSDATE,
4808: p_last_updated_by => fnd_global.user_id,
4809: p_last_update_date => SYSDATE,
4810: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 4808: p_last_updated_by => fnd_global.user_id,

4804: px_log_id => l_sales_lead_log_id ,
4805: p_sales_lead_id => p_sales_lead_id,
4806: p_created_by => fnd_global.user_id,
4807: p_creation_date => SYSDATE,
4808: p_last_updated_by => fnd_global.user_id,
4809: p_last_update_date => SYSDATE,
4810: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4811: p_request_id => FND_GLOBAL.Conc_Request_Id,
4812: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

Line 4810: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

4806: p_created_by => fnd_global.user_id,
4807: p_creation_date => SYSDATE,
4808: p_last_updated_by => fnd_global.user_id,
4809: p_last_update_date => SYSDATE,
4810: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4811: p_request_id => FND_GLOBAL.Conc_Request_Id,
4812: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
4813: p_program_id => FND_GLOBAL.Conc_Program_Id,
4814: p_program_update_date => SYSDATE,

Line 4811: p_request_id => FND_GLOBAL.Conc_Request_Id,

4807: p_creation_date => SYSDATE,
4808: p_last_updated_by => fnd_global.user_id,
4809: p_last_update_date => SYSDATE,
4810: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4811: p_request_id => FND_GLOBAL.Conc_Request_Id,
4812: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
4813: p_program_id => FND_GLOBAL.Conc_Program_Id,
4814: p_program_update_date => SYSDATE,
4815: p_status_code => l_status_code, --l_routing_status,

Line 4812: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

4808: p_last_updated_by => fnd_global.user_id,
4809: p_last_update_date => SYSDATE,
4810: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4811: p_request_id => FND_GLOBAL.Conc_Request_Id,
4812: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
4813: p_program_id => FND_GLOBAL.Conc_Program_Id,
4814: p_program_update_date => SYSDATE,
4815: p_status_code => l_status_code, --l_routing_status,
4816: p_assign_to_person_id => l_person_id,

Line 4813: p_program_id => FND_GLOBAL.Conc_Program_Id,

4809: p_last_update_date => SYSDATE,
4810: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4811: p_request_id => FND_GLOBAL.Conc_Request_Id,
4812: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
4813: p_program_id => FND_GLOBAL.Conc_Program_Id,
4814: p_program_update_date => SYSDATE,
4815: p_status_code => l_status_code, --l_routing_status,
4816: p_assign_to_person_id => l_person_id,
4817: p_assign_to_salesforce_id => l_resource_id,

Line 4829: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

4825: -- in case current user doesn't have update privilege.
4826: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
4827: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4828: p_LAST_UPDATE_DATE => SYSDATE,
4829: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4830: p_CREATION_DATE => FND_API.G_MISS_DATE,
4831: p_CREATED_BY => FND_API.G_MISS_NUM,
4832: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4833: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

Line 4833: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

4829: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4830: p_CREATION_DATE => FND_API.G_MISS_DATE,
4831: p_CREATED_BY => FND_API.G_MISS_NUM,
4832: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4833: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4834: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4835: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4836: p_PROGRAM_UPDATE_DATE => SYSDATE,
4837: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,

Line 4834: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,

4830: p_CREATION_DATE => FND_API.G_MISS_DATE,
4831: p_CREATED_BY => FND_API.G_MISS_NUM,
4832: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4833: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4834: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4835: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4836: p_PROGRAM_UPDATE_DATE => SYSDATE,
4837: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4838: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,

Line 4835: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

4831: p_CREATED_BY => FND_API.G_MISS_NUM,
4832: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4833: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4834: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4835: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4836: p_PROGRAM_UPDATE_DATE => SYSDATE,
4837: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4838: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4839: p_CUSTOMER_ID => l_CUSTOMER_ID,

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

4965: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
4966: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4967: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
4968: ,OBJECT_CREATION_DATE)
4969: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4970: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4971: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
4972: l_freeze_flag ,'N', 'Y', 'Y', 'N',
4973: l_customer_id, l_address_id, p_sales_lead_id,

Line 4970: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,

4966: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4967: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
4968: ,OBJECT_CREATION_DATE)
4969: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4970: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4971: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
4972: l_freeze_flag ,'N', 'Y', 'Y', 'N',
4973: l_customer_id, l_address_id, p_sales_lead_id,
4974: l_resource_id, l_person_id, l_group_id, l_open_status_flag,

Line 4971: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',

4967: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
4968: ,OBJECT_CREATION_DATE)
4969: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4970: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4971: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
4972: l_freeze_flag ,'N', 'Y', 'Y', 'N',
4973: l_customer_id, l_address_id, p_sales_lead_id,
4974: l_resource_id, l_person_id, l_group_id, l_open_status_flag,
4975: l_lead_rank_score, l_creation_date

Line 5143: p_created_by => fnd_global.user_id,

5139: -- Call API to create log entry
5140: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5141: px_log_id => l_sales_lead_log_id ,
5142: p_sales_lead_id => p_sales_lead_id,
5143: p_created_by => fnd_global.user_id,
5144: p_creation_date => SYSDATE,
5145: p_last_updated_by => fnd_global.user_id,
5146: p_last_update_date => SYSDATE,
5147: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 5145: p_last_updated_by => fnd_global.user_id,

5141: px_log_id => l_sales_lead_log_id ,
5142: p_sales_lead_id => p_sales_lead_id,
5143: p_created_by => fnd_global.user_id,
5144: p_creation_date => SYSDATE,
5145: p_last_updated_by => fnd_global.user_id,
5146: p_last_update_date => SYSDATE,
5147: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5148: p_request_id => FND_GLOBAL.Conc_Request_Id,
5149: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

Line 5147: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

5143: p_created_by => fnd_global.user_id,
5144: p_creation_date => SYSDATE,
5145: p_last_updated_by => fnd_global.user_id,
5146: p_last_update_date => SYSDATE,
5147: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5148: p_request_id => FND_GLOBAL.Conc_Request_Id,
5149: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5150: p_program_id => FND_GLOBAL.Conc_Program_Id,
5151: p_program_update_date => SYSDATE,

Line 5148: p_request_id => FND_GLOBAL.Conc_Request_Id,

5144: p_creation_date => SYSDATE,
5145: p_last_updated_by => fnd_global.user_id,
5146: p_last_update_date => SYSDATE,
5147: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5148: p_request_id => FND_GLOBAL.Conc_Request_Id,
5149: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5150: p_program_id => FND_GLOBAL.Conc_Program_Id,
5151: p_program_update_date => SYSDATE,
5152: p_status_code => l_status_code, --l_routing_status,

Line 5149: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

5145: p_last_updated_by => fnd_global.user_id,
5146: p_last_update_date => SYSDATE,
5147: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5148: p_request_id => FND_GLOBAL.Conc_Request_Id,
5149: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5150: p_program_id => FND_GLOBAL.Conc_Program_Id,
5151: p_program_update_date => SYSDATE,
5152: p_status_code => l_status_code, --l_routing_status,
5153: p_assign_to_person_id => l_person_id,

Line 5150: p_program_id => FND_GLOBAL.Conc_Program_Id,

5146: p_last_update_date => SYSDATE,
5147: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5148: p_request_id => FND_GLOBAL.Conc_Request_Id,
5149: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5150: p_program_id => FND_GLOBAL.Conc_Program_Id,
5151: p_program_update_date => SYSDATE,
5152: p_status_code => l_status_code, --l_routing_status,
5153: p_assign_to_person_id => l_person_id,
5154: p_assign_to_salesforce_id => l_resource_id,

Line 5166: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

5162: -- in case current user doesn't have update privilege.
5163: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5164: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5165: p_LAST_UPDATE_DATE => SYSDATE,
5166: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5167: p_CREATION_DATE => FND_API.G_MISS_DATE,
5168: p_CREATED_BY => FND_API.G_MISS_NUM,
5169: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5170: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

Line 5170: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

5166: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5167: p_CREATION_DATE => FND_API.G_MISS_DATE,
5168: p_CREATED_BY => FND_API.G_MISS_NUM,
5169: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5170: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5171: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5172: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5173: p_PROGRAM_UPDATE_DATE => SYSDATE,
5174: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,

Line 5171: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,

5167: p_CREATION_DATE => FND_API.G_MISS_DATE,
5168: p_CREATED_BY => FND_API.G_MISS_NUM,
5169: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5170: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5171: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5172: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5173: p_PROGRAM_UPDATE_DATE => SYSDATE,
5174: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5175: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,

Line 5172: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

5168: p_CREATED_BY => FND_API.G_MISS_NUM,
5169: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5170: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5171: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5172: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5173: p_PROGRAM_UPDATE_DATE => SYSDATE,
5174: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5175: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5176: p_CUSTOMER_ID => l_CUSTOMER_ID,

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

5302: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
5303: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
5304: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
5305: ,OBJECT_CREATION_DATE)
5306: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
5307: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
5308: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
5309: 'Y' ,'N', 'Y', 'Y', 'N',
5310: l_customer_id, l_address_id, p_sales_lead_id,

Line 5307: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,

5303: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
5304: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
5305: ,OBJECT_CREATION_DATE)
5306: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
5307: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
5308: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
5309: 'Y' ,'N', 'Y', 'Y', 'N',
5310: l_customer_id, l_address_id, p_sales_lead_id,
5311: l_resource_id, l_person_id, l_group_id, l_open_status_flag,

Line 5308: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',

5304: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
5305: ,OBJECT_CREATION_DATE)
5306: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
5307: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
5308: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
5309: 'Y' ,'N', 'Y', 'Y', 'N',
5310: l_customer_id, l_address_id, p_sales_lead_id,
5311: l_resource_id, l_person_id, l_group_id, l_open_status_flag,
5312: l_lead_rank_score, l_creation_date

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

5322: CURSOR C_get_current_resource IS
5323: SELECT res.resource_id
5324: FROM jtf_rs_resource_extns res
5325: WHERE res.category = 'EMPLOYEE'
5326: AND res.user_id = fnd_global.user_id;
5327:
5328: CURSOR c_get_group_id(c_resource_id NUMBER) IS
5329: SELECT grp.group_id
5330: FROM JTF_RS_GROUP_MEMBERS mem,

Line 5941: p_created_by => fnd_global.user_id,

5937: -- Call API to create log entry
5938: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5939: px_log_id => l_sales_lead_log_id ,
5940: p_sales_lead_id => p_sales_lead_id,
5941: p_created_by => fnd_global.user_id,
5942: p_creation_date => SYSDATE,
5943: p_last_updated_by => fnd_global.user_id,
5944: p_last_update_date => SYSDATE,
5945: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 5943: p_last_updated_by => fnd_global.user_id,

5939: px_log_id => l_sales_lead_log_id ,
5940: p_sales_lead_id => p_sales_lead_id,
5941: p_created_by => fnd_global.user_id,
5942: p_creation_date => SYSDATE,
5943: p_last_updated_by => fnd_global.user_id,
5944: p_last_update_date => SYSDATE,
5945: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5946: p_request_id => FND_GLOBAL.Conc_Request_Id,
5947: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

Line 5945: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

5941: p_created_by => fnd_global.user_id,
5942: p_creation_date => SYSDATE,
5943: p_last_updated_by => fnd_global.user_id,
5944: p_last_update_date => SYSDATE,
5945: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5946: p_request_id => FND_GLOBAL.Conc_Request_Id,
5947: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5948: p_program_id => FND_GLOBAL.Conc_Program_Id,
5949: p_program_update_date => SYSDATE,

Line 5946: p_request_id => FND_GLOBAL.Conc_Request_Id,

5942: p_creation_date => SYSDATE,
5943: p_last_updated_by => fnd_global.user_id,
5944: p_last_update_date => SYSDATE,
5945: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5946: p_request_id => FND_GLOBAL.Conc_Request_Id,
5947: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5948: p_program_id => FND_GLOBAL.Conc_Program_Id,
5949: p_program_update_date => SYSDATE,
5950: p_status_code => l_status_code, --l_routing_status,

Line 5947: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

5943: p_last_updated_by => fnd_global.user_id,
5944: p_last_update_date => SYSDATE,
5945: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5946: p_request_id => FND_GLOBAL.Conc_Request_Id,
5947: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5948: p_program_id => FND_GLOBAL.Conc_Program_Id,
5949: p_program_update_date => SYSDATE,
5950: p_status_code => l_status_code, --l_routing_status,
5951: p_assign_to_person_id => p_person_id,

Line 5948: p_program_id => FND_GLOBAL.Conc_Program_Id,

5944: p_last_update_date => SYSDATE,
5945: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5946: p_request_id => FND_GLOBAL.Conc_Request_Id,
5947: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5948: p_program_id => FND_GLOBAL.Conc_Program_Id,
5949: p_program_update_date => SYSDATE,
5950: p_status_code => l_status_code, --l_routing_status,
5951: p_assign_to_person_id => p_person_id,
5952: p_assign_to_salesforce_id => p_resource_id,

Line 5964: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

5960: -- in case current user doesn't have update privilege.
5961: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5962: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5963: p_LAST_UPDATE_DATE => SYSDATE,
5964: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5965: p_CREATION_DATE => FND_API.G_MISS_DATE,
5966: p_CREATED_BY => FND_API.G_MISS_NUM,
5967: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5968: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

Line 5968: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

5964: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5965: p_CREATION_DATE => FND_API.G_MISS_DATE,
5966: p_CREATED_BY => FND_API.G_MISS_NUM,
5967: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5968: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5969: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5970: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5971: p_PROGRAM_UPDATE_DATE => SYSDATE,
5972: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,

Line 5969: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,

5965: p_CREATION_DATE => FND_API.G_MISS_DATE,
5966: p_CREATED_BY => FND_API.G_MISS_NUM,
5967: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5968: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5969: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5970: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5971: p_PROGRAM_UPDATE_DATE => SYSDATE,
5972: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5973: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,

Line 5970: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

5966: p_CREATED_BY => FND_API.G_MISS_NUM,
5967: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5968: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5969: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5970: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5971: p_PROGRAM_UPDATE_DATE => SYSDATE,
5972: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5973: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5974: p_CUSTOMER_ID => l_CUSTOMER_ID,

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

6101: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
6102: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
6103: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
6104: ,OBJECT_CREATION_DATE)
6105: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
6106: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, 'X',
6107: l_freeze_flag ,'N', 'Y', 'Y', 'N',
6108: l_customer_id, l_address_id, p_sales_lead_id,
6109: p_resource_id, p_person_id, p_group_id, l_open_status_flag,

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

6102: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
6103: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
6104: ,OBJECT_CREATION_DATE)
6105: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
6106: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, 'X',
6107: l_freeze_flag ,'N', 'Y', 'Y', 'N',
6108: l_customer_id, l_address_id, p_sales_lead_id,
6109: p_resource_id, p_person_id, p_group_id, l_open_status_flag,
6110: l_lead_rank_score, l_creation_date