870: ---IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_EMPLOYEE' THEN
871: UPDATE AS_ACCESSES_ALL ACC
872: SET object_version_number = nvl(object_version_number,0) + 1,
873: ACC.last_update_date = SYSDATE,
874: ACC.last_updated_by = FND_GLOBAL.USER_ID,
875: ACC.last_update_login = FND_GLOBAL.USER_ID,
876: ACC.team_leader_flag = NVL(p_WinningTerrMember_tbl.full_access_flag(l_index),'N')
877: WHERE ACC.customer_id = G_PARTY_ID
878: AND ACC.lead_id IS NULL
871: UPDATE AS_ACCESSES_ALL ACC
872: SET object_version_number = nvl(object_version_number,0) + 1,
873: ACC.last_update_date = SYSDATE,
874: ACC.last_updated_by = FND_GLOBAL.USER_ID,
875: ACC.last_update_login = FND_GLOBAL.USER_ID,
876: ACC.team_leader_flag = NVL(p_WinningTerrMember_tbl.full_access_flag(l_index),'N')
877: WHERE ACC.customer_id = G_PARTY_ID
878: AND ACC.lead_id IS NULL
879: AND ACC.sales_lead_id IS NULL
948: created_by_tap_flag,
949: salesforce_role_code
950: FROM
951: (SELECT SYSDATE last_update_date,
952: FND_GLOBAL.USER_ID last_updated_by,
953: SYSDATE creation_date,
954: FND_GLOBAL.USER_ID created_by,
955: FND_GLOBAL.USER_ID last_update_login,
956: 'Online' access_type,
950: FROM
951: (SELECT SYSDATE last_update_date,
952: FND_GLOBAL.USER_ID last_updated_by,
953: SYSDATE creation_date,
954: FND_GLOBAL.USER_ID created_by,
955: FND_GLOBAL.USER_ID last_update_login,
956: 'Online' access_type,
957: 'N' freeze_flag,
958: 'N' reassign_flag,
951: (SELECT SYSDATE last_update_date,
952: FND_GLOBAL.USER_ID last_updated_by,
953: SYSDATE creation_date,
954: FND_GLOBAL.USER_ID created_by,
955: FND_GLOBAL.USER_ID last_update_login,
956: 'Online' access_type,
957: 'N' freeze_flag,
958: 'N' reassign_flag,
959: DECODE(p_WinningTerrMember_tbl.full_access_flag(l_index),'Y','Y','N') team_leader_flag,
1006: partner_customer_id,
1007: partner_cont_party_id,org_id)
1008: SELECT AS_ACCESSES_S.NEXTVAL,
1009: SYSDATE,
1010: FND_GLOBAL.USER_ID,
1011: SYSDATE,
1012: FND_GLOBAL.USER_ID,
1013: FND_GLOBAL.USER_ID,
1014: 'Online',
1008: SELECT AS_ACCESSES_S.NEXTVAL,
1009: SYSDATE,
1010: FND_GLOBAL.USER_ID,
1011: SYSDATE,
1012: FND_GLOBAL.USER_ID,
1013: FND_GLOBAL.USER_ID,
1014: 'Online',
1015: 'N',
1016: 'N',
1009: SYSDATE,
1010: FND_GLOBAL.USER_ID,
1011: SYSDATE,
1012: FND_GLOBAL.USER_ID,
1013: FND_GLOBAL.USER_ID,
1014: 'Online',
1015: 'N',
1016: 'N',
1017: DECODE(p_WinningTerrMember_tbl.full_access_flag(l_index),'Y','Y','N'),
1080: ACC.access_id,
1081: p_WinningTerrMember_tbl.terr_id(l_index),
1082: p_WinningTerrMember_tbl.terr_id(l_index),
1083: SYSDATE,
1084: FND_GLOBAL.USER_ID,
1085: SYSDATE,
1086: FND_GLOBAL.USER_ID,
1087: FND_GLOBAL.USER_ID
1088: FROM AS_ACCESSES_ALL ACC
1082: p_WinningTerrMember_tbl.terr_id(l_index),
1083: SYSDATE,
1084: FND_GLOBAL.USER_ID,
1085: SYSDATE,
1086: FND_GLOBAL.USER_ID,
1087: FND_GLOBAL.USER_ID
1088: FROM AS_ACCESSES_ALL ACC
1089: WHERE ACC.customer_id = G_PARTY_ID
1090: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)
1083: SYSDATE,
1084: FND_GLOBAL.USER_ID,
1085: SYSDATE,
1086: FND_GLOBAL.USER_ID,
1087: FND_GLOBAL.USER_ID
1088: FROM AS_ACCESSES_ALL ACC
1089: WHERE ACC.customer_id = G_PARTY_ID
1090: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)
1091: AND ACC.sales_group_id = p_WinningTerrMember_tbl.group_id(l_index)
1106: SELECT ACC.access_id,
1107: p_WinningTerrMember_tbl.terr_id(l_index),
1108: p_WinningTerrMember_tbl.terr_id(l_index),
1109: SYSDATE,
1110: FND_GLOBAL.USER_ID,
1111: SYSDATE,
1112: FND_GLOBAL.USER_ID,
1113: FND_GLOBAL.USER_ID
1114: FROM AS_ACCESSES_ALL ACC
1108: p_WinningTerrMember_tbl.terr_id(l_index),
1109: SYSDATE,
1110: FND_GLOBAL.USER_ID,
1111: SYSDATE,
1112: FND_GLOBAL.USER_ID,
1113: FND_GLOBAL.USER_ID
1114: FROM AS_ACCESSES_ALL ACC
1115: WHERE ACC.customer_id = G_PARTY_ID
1116: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)
1109: SYSDATE,
1110: FND_GLOBAL.USER_ID,
1111: SYSDATE,
1112: FND_GLOBAL.USER_ID,
1113: FND_GLOBAL.USER_ID
1114: FROM AS_ACCESSES_ALL ACC
1115: WHERE ACC.customer_id = G_PARTY_ID
1116: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)
1117: AND NVL(ACC.sales_group_id,-777) = NVL(p_WinningTerrMember_tbl.group_id(l_index),-777)