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 430: IF FND_GLOBAL.User_Id IS NULL

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

Line 773: IF FND_GLOBAL.User_Id IS NULL

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

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

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

Line 1298: IF FND_GLOBAL.User_Id IS NULL

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

Line 1847: l_request_id := FND_GLOBAL.Conc_Request_Id;

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

Line 2472: IF FND_GLOBAL.User_Id IS NULL

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

Line 2739: l_request_id := FND_GLOBAL.Conc_Request_Id;

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

Line 3895: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 3896: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

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

Line 3897: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,

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

Line 3919: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 3920: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

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

Line 3921: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,

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

Line 3997: FND_GLOBAL.USER_ID,

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

Line 3999: FND_GLOBAL.USER_ID,

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

Line 4000: FND_GLOBAL.CONC_LOGIN_ID,

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

Line 4001: FND_GLOBAL.PROG_APPL_ID,

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

Line 4042: FND_GLOBAL.USER_ID,

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

Line 4044: FND_GLOBAL.USER_ID,

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

Line 4045: FND_GLOBAL.CONC_LOGIN_ID,

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

Line 4046: FND_GLOBAL.PROG_APPL_ID,

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

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

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

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

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

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

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

Line 4261: FND_GLOBAL.PROG_APPL_ID, SYSDATE,

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

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

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

Line 4487: p_created_by => fnd_global.user_id,

4483: -- Call API to create log entry
4484: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4485: px_log_id => l_sales_lead_log_id ,
4486: p_sales_lead_id => p_sales_lead_id,
4487: p_created_by => fnd_global.user_id,
4488: p_creation_date => SYSDATE,
4489: p_last_updated_by => fnd_global.user_id,
4490: p_last_update_date => SYSDATE,
4491: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 4489: p_last_updated_by => fnd_global.user_id,

4485: px_log_id => l_sales_lead_log_id ,
4486: p_sales_lead_id => p_sales_lead_id,
4487: p_created_by => fnd_global.user_id,
4488: p_creation_date => SYSDATE,
4489: p_last_updated_by => fnd_global.user_id,
4490: p_last_update_date => SYSDATE,
4491: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4492: p_request_id => FND_GLOBAL.Conc_Request_Id,
4493: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

Line 4491: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

4487: p_created_by => fnd_global.user_id,
4488: p_creation_date => SYSDATE,
4489: p_last_updated_by => fnd_global.user_id,
4490: p_last_update_date => SYSDATE,
4491: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
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,

Line 4492: p_request_id => FND_GLOBAL.Conc_Request_Id,

4488: p_creation_date => SYSDATE,
4489: p_last_updated_by => fnd_global.user_id,
4490: p_last_update_date => SYSDATE,
4491: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
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_status_code => l_status_code, --l_routing_status,

Line 4493: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

4489: p_last_updated_by => fnd_global.user_id,
4490: p_last_update_date => SYSDATE,
4491: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
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_status_code => l_status_code, --l_routing_status,
4497: p_assign_to_person_id => l_person_id,

Line 4494: p_program_id => FND_GLOBAL.Conc_Program_Id,

4490: p_last_update_date => SYSDATE,
4491: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
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_status_code => l_status_code, --l_routing_status,
4497: p_assign_to_person_id => l_person_id,
4498: p_assign_to_salesforce_id => l_resource_id,

Line 4510: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

4506: -- in case current user doesn't have update privilege.
4507: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
4508: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4509: p_LAST_UPDATE_DATE => SYSDATE,
4510: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4511: p_CREATION_DATE => FND_API.G_MISS_DATE,
4512: p_CREATED_BY => FND_API.G_MISS_NUM,
4513: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4514: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

Line 4514: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

4510: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4511: p_CREATION_DATE => FND_API.G_MISS_DATE,
4512: p_CREATED_BY => FND_API.G_MISS_NUM,
4513: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4514: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4515: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4516: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4517: p_PROGRAM_UPDATE_DATE => SYSDATE,
4518: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,

Line 4515: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,

4511: p_CREATION_DATE => FND_API.G_MISS_DATE,
4512: p_CREATED_BY => FND_API.G_MISS_NUM,
4513: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4514: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4515: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4516: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4517: p_PROGRAM_UPDATE_DATE => SYSDATE,
4518: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4519: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,

Line 4516: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

4512: p_CREATED_BY => FND_API.G_MISS_NUM,
4513: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4514: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4515: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4516: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4517: p_PROGRAM_UPDATE_DATE => SYSDATE,
4518: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4519: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4520: p_CUSTOMER_ID => l_CUSTOMER_ID,

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

4644: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
4645: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4646: ,PERSON_ID, SALES_GROUP_ID, REQUEST_ID, OPEN_FLAG
4647: ,LEAD_RANK_SCORE, OBJECT_CREATION_DATE)
4648: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4649: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4650: FND_GLOBAL.PROG_APPL_ID, SYSDATE,
4651: 'X', l_freeze_flag ,'N','Y', 'Y', 'N',
4652: l_customer_id, l_address_id, p_sales_lead_id,

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

4645: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4646: ,PERSON_ID, SALES_GROUP_ID, REQUEST_ID, OPEN_FLAG
4647: ,LEAD_RANK_SCORE, OBJECT_CREATION_DATE)
4648: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4649: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4650: FND_GLOBAL.PROG_APPL_ID, SYSDATE,
4651: 'X', l_freeze_flag ,'N','Y', 'Y', 'N',
4652: l_customer_id, l_address_id, p_sales_lead_id,
4653: l_resource_id, l_person_id, l_group_id, p_request_id,

Line 4650: FND_GLOBAL.PROG_APPL_ID, SYSDATE,

4646: ,PERSON_ID, SALES_GROUP_ID, REQUEST_ID, OPEN_FLAG
4647: ,LEAD_RANK_SCORE, OBJECT_CREATION_DATE)
4648: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4649: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4650: FND_GLOBAL.PROG_APPL_ID, SYSDATE,
4651: 'X', l_freeze_flag ,'N','Y', 'Y', 'N',
4652: l_customer_id, l_address_id, p_sales_lead_id,
4653: l_resource_id, l_person_id, l_group_id, p_request_id,
4654: l_open_status_flag, l_lead_rank_score, l_creation_date

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

4723: CURSOR C_get_current_resource IS
4724: SELECT res.resource_id
4725: FROM jtf_rs_resource_extns res
4726: WHERE res.category IN ('EMPLOYEE', 'PARTY')
4727: AND res.user_id = fnd_global.user_id;
4728:
4729: CURSOR c_get_group_id(c_resource_id NUMBER) IS
4730: SELECT grp.group_id
4731: FROM JTF_RS_GROUP_MEMBERS mem,

Line 4830: p_created_by => fnd_global.user_id,

4826: -- Call API to create log entry
4827: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4828: px_log_id => l_sales_lead_log_id ,
4829: p_sales_lead_id => p_sales_lead_id,
4830: p_created_by => fnd_global.user_id,
4831: p_creation_date => SYSDATE,
4832: p_last_updated_by => fnd_global.user_id,
4833: p_last_update_date => SYSDATE,
4834: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 4832: p_last_updated_by => fnd_global.user_id,

4828: px_log_id => l_sales_lead_log_id ,
4829: p_sales_lead_id => p_sales_lead_id,
4830: p_created_by => fnd_global.user_id,
4831: p_creation_date => SYSDATE,
4832: p_last_updated_by => fnd_global.user_id,
4833: p_last_update_date => SYSDATE,
4834: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4835: p_request_id => FND_GLOBAL.Conc_Request_Id,
4836: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

Line 4834: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

4830: p_created_by => fnd_global.user_id,
4831: p_creation_date => SYSDATE,
4832: p_last_updated_by => fnd_global.user_id,
4833: p_last_update_date => SYSDATE,
4834: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4835: p_request_id => FND_GLOBAL.Conc_Request_Id,
4836: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
4837: p_program_id => FND_GLOBAL.Conc_Program_Id,
4838: p_program_update_date => SYSDATE,

Line 4835: p_request_id => FND_GLOBAL.Conc_Request_Id,

4831: p_creation_date => SYSDATE,
4832: p_last_updated_by => fnd_global.user_id,
4833: p_last_update_date => SYSDATE,
4834: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4835: p_request_id => FND_GLOBAL.Conc_Request_Id,
4836: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
4837: p_program_id => FND_GLOBAL.Conc_Program_Id,
4838: p_program_update_date => SYSDATE,
4839: p_status_code => l_status_code, --l_routing_status,

Line 4836: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

4832: p_last_updated_by => fnd_global.user_id,
4833: p_last_update_date => SYSDATE,
4834: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4835: p_request_id => FND_GLOBAL.Conc_Request_Id,
4836: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
4837: p_program_id => FND_GLOBAL.Conc_Program_Id,
4838: p_program_update_date => SYSDATE,
4839: p_status_code => l_status_code, --l_routing_status,
4840: p_assign_to_person_id => l_person_id,

Line 4837: p_program_id => FND_GLOBAL.Conc_Program_Id,

4833: p_last_update_date => SYSDATE,
4834: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
4835: p_request_id => FND_GLOBAL.Conc_Request_Id,
4836: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
4837: p_program_id => FND_GLOBAL.Conc_Program_Id,
4838: p_program_update_date => SYSDATE,
4839: p_status_code => l_status_code, --l_routing_status,
4840: p_assign_to_person_id => l_person_id,
4841: p_assign_to_salesforce_id => l_resource_id,

Line 4853: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

4849: -- in case current user doesn't have update privilege.
4850: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
4851: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
4852: p_LAST_UPDATE_DATE => SYSDATE,
4853: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4854: p_CREATION_DATE => FND_API.G_MISS_DATE,
4855: p_CREATED_BY => FND_API.G_MISS_NUM,
4856: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4857: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

Line 4857: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

4853: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4854: p_CREATION_DATE => FND_API.G_MISS_DATE,
4855: p_CREATED_BY => FND_API.G_MISS_NUM,
4856: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4857: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4858: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4859: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4860: p_PROGRAM_UPDATE_DATE => SYSDATE,
4861: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,

Line 4858: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,

4854: p_CREATION_DATE => FND_API.G_MISS_DATE,
4855: p_CREATED_BY => FND_API.G_MISS_NUM,
4856: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4857: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4858: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4859: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4860: p_PROGRAM_UPDATE_DATE => SYSDATE,
4861: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4862: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,

Line 4859: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

4855: p_CREATED_BY => FND_API.G_MISS_NUM,
4856: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
4857: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
4858: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
4859: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
4860: p_PROGRAM_UPDATE_DATE => SYSDATE,
4861: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
4862: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
4863: p_CUSTOMER_ID => l_CUSTOMER_ID,

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

4989: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
4990: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4991: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
4992: ,OBJECT_CREATION_DATE)
4993: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4994: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4995: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
4996: l_freeze_flag ,'N', 'Y', 'Y', 'N',
4997: l_customer_id, l_address_id, p_sales_lead_id,

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

4990: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4991: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
4992: ,OBJECT_CREATION_DATE)
4993: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4994: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4995: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
4996: l_freeze_flag ,'N', 'Y', 'Y', 'N',
4997: l_customer_id, l_address_id, p_sales_lead_id,
4998: l_resource_id, l_person_id, l_group_id, l_open_status_flag,

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

4991: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
4992: ,OBJECT_CREATION_DATE)
4993: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4994: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4995: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
4996: l_freeze_flag ,'N', 'Y', 'Y', 'N',
4997: l_customer_id, l_address_id, p_sales_lead_id,
4998: l_resource_id, l_person_id, l_group_id, l_open_status_flag,
4999: l_lead_rank_score, l_creation_date

Line 5167: p_created_by => fnd_global.user_id,

5163: -- Call API to create log entry
5164: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5165: px_log_id => l_sales_lead_log_id ,
5166: p_sales_lead_id => p_sales_lead_id,
5167: p_created_by => fnd_global.user_id,
5168: p_creation_date => SYSDATE,
5169: p_last_updated_by => fnd_global.user_id,
5170: p_last_update_date => SYSDATE,
5171: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 5169: p_last_updated_by => fnd_global.user_id,

5165: px_log_id => l_sales_lead_log_id ,
5166: p_sales_lead_id => p_sales_lead_id,
5167: p_created_by => fnd_global.user_id,
5168: p_creation_date => SYSDATE,
5169: p_last_updated_by => fnd_global.user_id,
5170: p_last_update_date => SYSDATE,
5171: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5172: p_request_id => FND_GLOBAL.Conc_Request_Id,
5173: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

Line 5171: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

5167: p_created_by => fnd_global.user_id,
5168: p_creation_date => SYSDATE,
5169: p_last_updated_by => fnd_global.user_id,
5170: p_last_update_date => SYSDATE,
5171: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5172: p_request_id => FND_GLOBAL.Conc_Request_Id,
5173: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5174: p_program_id => FND_GLOBAL.Conc_Program_Id,
5175: p_program_update_date => SYSDATE,

Line 5172: p_request_id => FND_GLOBAL.Conc_Request_Id,

5168: p_creation_date => SYSDATE,
5169: p_last_updated_by => fnd_global.user_id,
5170: p_last_update_date => SYSDATE,
5171: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5172: p_request_id => FND_GLOBAL.Conc_Request_Id,
5173: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5174: p_program_id => FND_GLOBAL.Conc_Program_Id,
5175: p_program_update_date => SYSDATE,
5176: p_status_code => l_status_code, --l_routing_status,

Line 5173: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

5169: p_last_updated_by => fnd_global.user_id,
5170: p_last_update_date => SYSDATE,
5171: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5172: p_request_id => FND_GLOBAL.Conc_Request_Id,
5173: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5174: p_program_id => FND_GLOBAL.Conc_Program_Id,
5175: p_program_update_date => SYSDATE,
5176: p_status_code => l_status_code, --l_routing_status,
5177: p_assign_to_person_id => l_person_id,

Line 5174: p_program_id => FND_GLOBAL.Conc_Program_Id,

5170: p_last_update_date => SYSDATE,
5171: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5172: p_request_id => FND_GLOBAL.Conc_Request_Id,
5173: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5174: p_program_id => FND_GLOBAL.Conc_Program_Id,
5175: p_program_update_date => SYSDATE,
5176: p_status_code => l_status_code, --l_routing_status,
5177: p_assign_to_person_id => l_person_id,
5178: p_assign_to_salesforce_id => l_resource_id,

Line 5190: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

5186: -- in case current user doesn't have update privilege.
5187: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5188: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5189: p_LAST_UPDATE_DATE => SYSDATE,
5190: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5191: p_CREATION_DATE => FND_API.G_MISS_DATE,
5192: p_CREATED_BY => FND_API.G_MISS_NUM,
5193: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5194: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

Line 5194: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

5190: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5191: p_CREATION_DATE => FND_API.G_MISS_DATE,
5192: p_CREATED_BY => FND_API.G_MISS_NUM,
5193: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5194: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5195: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5196: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5197: p_PROGRAM_UPDATE_DATE => SYSDATE,
5198: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,

Line 5195: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,

5191: p_CREATION_DATE => FND_API.G_MISS_DATE,
5192: p_CREATED_BY => FND_API.G_MISS_NUM,
5193: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5194: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5195: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5196: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5197: p_PROGRAM_UPDATE_DATE => SYSDATE,
5198: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5199: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,

Line 5196: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

5192: p_CREATED_BY => FND_API.G_MISS_NUM,
5193: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5194: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5195: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5196: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5197: p_PROGRAM_UPDATE_DATE => SYSDATE,
5198: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5199: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5200: p_CUSTOMER_ID => l_CUSTOMER_ID,

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

5326: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
5327: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
5328: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
5329: ,OBJECT_CREATION_DATE)
5330: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
5331: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
5332: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
5333: 'Y' ,'N', 'Y', 'Y', 'N',
5334: l_customer_id, l_address_id, p_sales_lead_id,

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

5327: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
5328: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
5329: ,OBJECT_CREATION_DATE)
5330: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
5331: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
5332: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
5333: 'Y' ,'N', 'Y', 'Y', 'N',
5334: l_customer_id, l_address_id, p_sales_lead_id,
5335: l_resource_id, l_person_id, l_group_id, l_open_status_flag,

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

5328: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
5329: ,OBJECT_CREATION_DATE)
5330: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
5331: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
5332: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
5333: 'Y' ,'N', 'Y', 'Y', 'N',
5334: l_customer_id, l_address_id, p_sales_lead_id,
5335: l_resource_id, l_person_id, l_group_id, l_open_status_flag,
5336: l_lead_rank_score, l_creation_date

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

5346: CURSOR C_get_current_resource IS
5347: SELECT res.resource_id
5348: FROM jtf_rs_resource_extns res
5349: WHERE res.category = 'EMPLOYEE'
5350: AND res.user_id = fnd_global.user_id;
5351:
5352: CURSOR c_get_group_id(c_resource_id NUMBER) IS
5353: SELECT grp.group_id
5354: FROM JTF_RS_GROUP_MEMBERS mem,

Line 5965: p_created_by => fnd_global.user_id,

5961: -- Call API to create log entry
5962: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5963: px_log_id => l_sales_lead_log_id ,
5964: p_sales_lead_id => p_sales_lead_id,
5965: p_created_by => fnd_global.user_id,
5966: p_creation_date => SYSDATE,
5967: p_last_updated_by => fnd_global.user_id,
5968: p_last_update_date => SYSDATE,
5969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 5967: p_last_updated_by => fnd_global.user_id,

5963: px_log_id => l_sales_lead_log_id ,
5964: p_sales_lead_id => p_sales_lead_id,
5965: p_created_by => fnd_global.user_id,
5966: p_creation_date => SYSDATE,
5967: p_last_updated_by => fnd_global.user_id,
5968: p_last_update_date => SYSDATE,
5969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5970: p_request_id => FND_GLOBAL.Conc_Request_Id,
5971: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

Line 5969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

5965: p_created_by => fnd_global.user_id,
5966: p_creation_date => SYSDATE,
5967: p_last_updated_by => fnd_global.user_id,
5968: p_last_update_date => SYSDATE,
5969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5970: p_request_id => FND_GLOBAL.Conc_Request_Id,
5971: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5972: p_program_id => FND_GLOBAL.Conc_Program_Id,
5973: p_program_update_date => SYSDATE,

Line 5970: p_request_id => FND_GLOBAL.Conc_Request_Id,

5966: p_creation_date => SYSDATE,
5967: p_last_updated_by => fnd_global.user_id,
5968: p_last_update_date => SYSDATE,
5969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5970: p_request_id => FND_GLOBAL.Conc_Request_Id,
5971: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5972: p_program_id => FND_GLOBAL.Conc_Program_Id,
5973: p_program_update_date => SYSDATE,
5974: p_status_code => l_status_code, --l_routing_status,

Line 5971: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,

5967: p_last_updated_by => fnd_global.user_id,
5968: p_last_update_date => SYSDATE,
5969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5970: p_request_id => FND_GLOBAL.Conc_Request_Id,
5971: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5972: p_program_id => FND_GLOBAL.Conc_Program_Id,
5973: p_program_update_date => SYSDATE,
5974: p_status_code => l_status_code, --l_routing_status,
5975: p_assign_to_person_id => p_person_id,

Line 5972: p_program_id => FND_GLOBAL.Conc_Program_Id,

5968: p_last_update_date => SYSDATE,
5969: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5970: p_request_id => FND_GLOBAL.Conc_Request_Id,
5971: p_program_application_id => FND_GLOBAL.Prog_Appl_Id,
5972: p_program_id => FND_GLOBAL.Conc_Program_Id,
5973: p_program_update_date => SYSDATE,
5974: p_status_code => l_status_code, --l_routing_status,
5975: p_assign_to_person_id => p_person_id,
5976: p_assign_to_salesforce_id => p_resource_id,

Line 5988: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

5984: -- in case current user doesn't have update privilege.
5985: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
5986: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
5987: p_LAST_UPDATE_DATE => SYSDATE,
5988: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5989: p_CREATION_DATE => FND_API.G_MISS_DATE,
5990: p_CREATED_BY => FND_API.G_MISS_NUM,
5991: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

Line 5992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,

5988: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
5989: p_CREATION_DATE => FND_API.G_MISS_DATE,
5990: p_CREATED_BY => FND_API.G_MISS_NUM,
5991: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5993: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5994: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5995: p_PROGRAM_UPDATE_DATE => SYSDATE,
5996: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,

Line 5993: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,

5989: p_CREATION_DATE => FND_API.G_MISS_DATE,
5990: p_CREATED_BY => FND_API.G_MISS_NUM,
5991: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5993: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5994: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5995: p_PROGRAM_UPDATE_DATE => SYSDATE,
5996: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5997: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,

Line 5994: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,

5990: p_CREATED_BY => FND_API.G_MISS_NUM,
5991: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
5992: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
5993: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
5994: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
5995: p_PROGRAM_UPDATE_DATE => SYSDATE,
5996: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
5997: p_STATUS_CODE => FND_API.G_MISS_CHAR, --l_routing_status,
5998: p_CUSTOMER_ID => l_CUSTOMER_ID,

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

6125: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
6126: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
6127: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
6128: ,OBJECT_CREATION_DATE)
6129: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
6130: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, 'X',
6131: l_freeze_flag ,'N', 'Y', 'Y', 'N',
6132: l_customer_id, l_address_id, p_sales_lead_id,
6133: p_resource_id, p_person_id, p_group_id, l_open_status_flag,

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

6126: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
6127: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
6128: ,OBJECT_CREATION_DATE)
6129: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
6130: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, 'X',
6131: l_freeze_flag ,'N', 'Y', 'Y', 'N',
6132: l_customer_id, l_address_id, p_sales_lead_id,
6133: p_resource_id, p_person_id, p_group_id, l_open_status_flag,
6134: l_lead_rank_score, l_creation_date