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