[Home] [Help]
1048: AND tu.team_id = t.team_id
1049: AND tu.usage = 'SALES'
1050: AND tm.team_member_id = trr.role_resource_id
1051: AND tm.delete_flag <> 'Y'
1052: AND tm.resource_type = 'INDIVIDUAL'
1053: AND trr.role_resource_type = 'RS_TEAM_MEMBER'
1054: AND trr.delete_flag <> 'Y'
1055: AND SYSDATE BETWEEN trr.start_date_active
1056: AND NVL(trr.end_date_active,SYSDATE)
1144: GROUP BY m.group_member_id, m.resource_id, m.person_id,
1145: m.group_id, res.category) j
1146: WHERE j.group_id = c_group_id;
1147:
1148: Cursor C_Validate_Salesforce(C_Resource_Id NUMBER, c_rs_individual VARCHAR2,
1149: c_sales VARCHAR2, c_telesales VARCHAR2,
1150: c_fieldsales VARCHAR2, c_prm VARCHAR2,
1151: c_n VARCHAR2, c_employee VARCHAR2) IS
1152: SELECT 'Y'
1156: jtf_rs_roles_b role
1157: WHERE TRUNC(SYSDATE) BETWEEN per.effective_start_date
1158: AND per.effective_end_date
1159: AND res.resource_id = rrel.role_resource_id
1160: AND rrel.role_resource_type = c_rs_individual --'RS_INDIVIDUAL'
1161: AND rrel.role_id = role.role_id
1162: AND role.role_type_code IN (c_sales, c_telesales, c_fieldsales, c_prm) --'SALES', 'TELESALES', 'FIELDSALES', 'PRM')
1163: AND NVL(role.admin_flag, 'N') = c_n --'N'
1164: AND res.source_id = per.person_id
1198:
1199: -- Get sequence
1200: CURSOR c_get_conseq_cur IS
1201: SELECT fnd_concurrent_requests_s.nextval
1202: FROM dual;
1203:
1204: l_api_name CONSTANT VARCHAR2(30)
1205: := 'Build_Lead_Sales_Team';
1206: l_api_version_number CONSTANT NUMBER := 2.0;
1808: -- not resource team or resource group
1809: l_salesforce_flag := 'N';
1810: OPEN C_Validate_Salesforce(
1811: l_AssignResources_tbl(i).Resource_Id,
1812: 'RS_INDIVIDUAL', 'SALES', 'TELESALES',
1813: 'FIELDSALES', 'PRM', 'N', 'EMPLOYEE');
1814: FETCH C_Validate_Salesforce INTO l_salesforce_flag;
1815: CLOSE C_Validate_Salesforce;
1816:
2172: AND tu.team_id = t.team_id
2173: AND tu.usage = 'SALES'
2174: AND tm.team_member_id = trr.role_resource_id
2175: AND tm.delete_flag <> 'Y'
2176: AND tm.resource_type = 'INDIVIDUAL'
2177: AND trr.role_resource_type = 'RS_TEAM_MEMBER'
2178: AND trr.delete_flag <> 'Y'
2179: AND SYSDATE BETWEEN trr.start_date_active
2180: AND NVL(trr.end_date_active,SYSDATE)
2268: GROUP BY m.group_member_id, m.resource_id, m.person_id,
2269: m.group_id, res.category) j
2270: WHERE j.group_id = c_group_id;
2271:
2272: Cursor C_Validate_Salesforce(C_Resource_Id NUMBER, c_rs_individual VARCHAR2,
2273: c_sales VARCHAR2, c_telesales VARCHAR2,
2274: c_fieldsales VARCHAR2, c_prm VARCHAR2,
2275: c_n VARCHAR2, c_employee VARCHAR2) IS
2276: SELECT 'Y'
2280: jtf_rs_roles_b role
2281: WHERE TRUNC(SYSDATE) BETWEEN per.effective_start_date
2282: AND per.effective_end_date
2283: AND res.resource_id = rrel.role_resource_id
2284: AND rrel.role_resource_type = c_rs_individual --'RS_INDIVIDUAL'
2285: AND rrel.role_id = role.role_id
2286: AND role.role_type_code IN (c_sales, c_telesales, c_fieldsales, c_prm) --'SALES', 'TELESALES', 'FIELDSALES', 'PRM')
2287: AND NVL(role.admin_flag, 'N') = c_n --'N'
2288: AND res.source_id = per.person_id
2302:
2303: -- Get sequence
2304: CURSOR c_get_conseq_cur IS
2305: SELECT fnd_concurrent_requests_s.nextval
2306: FROM dual;
2307:
2308: -- Check whether owner exists or not
2309: CURSOR c_check_owner_exists(c_sales_lead_id NUMBER) IS
2310: SELECT 'Y'
2871: -- not resource team or resource group
2872: l_salesforce_flag := 'N';
2873: OPEN C_Validate_Salesforce(
2874: l_AssignResources_tbl(i).Resource_Id,
2875: 'RS_INDIVIDUAL', 'SALES', 'TELESALES',
2876: 'FIELDSALES', 'PRM', 'N', 'EMPLOYEE');
2877: FETCH C_Validate_Salesforce INTO l_salesforce_flag;
2878: CLOSE C_Validate_Salesforce;
2879:
3363: l_i NUMBER; -- index to Insert array
3364:
3365: CURSOR c_get_access_id IS
3366: SELECT AS_ACCESSES_S.NEXTVAL
3367: FROM SYS.DUAL;
3368:
3369: BEGIN
3370: l_i := g_i_count;
3371:
3507: AND ROWNUM <= 1;
3508:
3509: CURSOR c_get_new_access_id IS
3510: SELECT AS_ACCESSES_S.NEXTVAL
3511: FROM SYS.DUAL;
3512:
3513: BEGIN
3514: IF (AS_DEBUG_LOW_ON) THEN
3515: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
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
4266: FROM sys.dual;
4267: ELSIF l_team_leader_flag = 'N'
4268: THEN
4269: -- lead creator is in sales team, but no full access
4270: UPDATE as_accesses_all
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
4655: FROM sys.dual;
4656: ELSE
4657: -- Default resource is in sales team, update this resource
4658: -- as owner.
4659: UPDATE as_accesses_all
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
5000: FROM SYS.DUAL;
5001:
5002: END IF; -- l_access_exist_flag = 'Y'
5003: END IF; -- l_resource_id IS NULL
5004: END Oracle_Internal_CUHK;
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
5337: FROM SYS.DUAL;
5338: END IF; -- l_access_exist_flag = 'Y'
5339:
5340: END Get_Partner_Lead_Owner;
5341:
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
6135: FROM SYS.DUAL;
6136: END IF; -- l_access_exist_flag IS NOT NULL
6137:
6138: IF (AS_DEBUG_LOW_ON) THEN
6139: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,