APPS.AS_LEAD_ROUTING_WF dependencies on AS_ACCESSES_ALL

Line 35: -- Add open_flag in as_accesses_all table.

31: -- 02/20/2003 SOLIN Bug 2796503
32: -- Show message if no more available resource can be
33: -- lead owner.
34: -- 03/20/2003 SOLIN Bug 2831426
35: -- Add open_flag in as_accesses_all table.
36: -- 04/28/2003 SOLIN Bug 2926777
37: -- Close_reason should not be changed when
38: -- lead is reassigned.
39: -- 05/01/2003 SOLIN Bug 2928041

Line 41: -- lead_rank_score in as_accesses_all table

37: -- Close_reason should not be changed when
38: -- lead is reassigned.
39: -- 05/01/2003 SOLIN Bug 2928041
40: -- Add open_flag, object_creation_date, and
41: -- lead_rank_score in as_accesses_all table
42: -- 09/11/2003 SOLIN Change for Sales_Lead_Update_Row new columns
43: --
44: -- END of Comments
45:

Line 438: FROM AS_ACCESSES_ALL ACC

434: -- Leads re-route must not be routed back to a resource that has previously
435: -- owned the lead before.
436: CURSOR c_get_lead_resource(c_sales_lead_id NUMBER) IS
437: SELECT ACC.SALESFORCE_ID, ACC.SALES_GROUP_ID, ACC.PERSON_ID, 'T'
438: FROM AS_ACCESSES_ALL ACC
439: WHERE ACC.SALES_LEAD_ID = c_sales_lead_id
440: AND ACC.CREATED_BY_TAP_FLAG = 'Y'
441: AND NOT EXISTS (
442: SELECT 1

Line 633: FROM AS_ACCESSES_ALL ACC

629: WHERE SALES_LEAD_ID = c_sales_lead_id;
630:
631: CURSOR c_get_resource_avail(c_sales_lead_id NUMBER) IS
632: SELECT 'Y'
633: FROM AS_ACCESSES_ALL ACC
634: WHERE ACC.SALES_LEAD_ID = c_sales_lead_id
635: AND ACC.CREATED_BY_TAP_FLAG = 'Y';
636: BEGIN
637: IF (AS_DEBUG_LOW_ON) THEN

Line 900: FROM as_accesses_all

896:
897: CURSOR c_access_exist(c_sales_lead_id NUMBER, c_resource_id NUMBER,
898: c_group_id NUMBER) IS
899: SELECT freeze_flag
900: FROM as_accesses_all
901: WHERE sales_lead_id = c_sales_lead_id
902: AND salesforce_id = c_resource_id
903: AND ((sales_group_id = c_group_id) OR
904: (sales_group_id IS NULL AND c_group_id IS NULL));

Line 1089: -- Clear owner in as_accesses_all.

1085: OPEN c_access_exist(l_sales_lead_id, l_resource_id, l_group_id);
1086: FETCH c_access_exist INTO l_access_exist_flag;
1087: CLOSE c_access_exist;
1088:
1089: -- Clear owner in as_accesses_all.
1090: -- There may be more than one owner_flag='Y' for the lead in
1091: -- as_accesses_all:
1092: -- 1. When owner rejects the lead
1093: -- 2. When monitoring engine times out

Line 1091: -- as_accesses_all:

1087: CLOSE c_access_exist;
1088:
1089: -- Clear owner in as_accesses_all.
1090: -- There may be more than one owner_flag='Y' for the lead in
1091: -- as_accesses_all:
1092: -- 1. When owner rejects the lead
1093: -- 2. When monitoring engine times out
1094: UPDATE as_accesses_all
1095: SET owner_flag = 'N'

Line 1094: UPDATE as_accesses_all

1090: -- There may be more than one owner_flag='Y' for the lead in
1091: -- as_accesses_all:
1092: -- 1. When owner rejects the lead
1093: -- 2. When monitoring engine times out
1094: UPDATE as_accesses_all
1095: SET owner_flag = 'N'
1096: WHERE sales_lead_id = l_sales_lead_id;
1097:
1098: IF l_access_exist_flag IS NOT NULL

Line 1106: UPDATE as_accesses_all

1102: IF l_access_exist_flag = 'Y'
1103: THEN
1104: l_freeze_flag := 'Y';
1105: END IF;
1106: UPDATE as_accesses_all
1107: SET team_leader_flag = 'Y',
1108: owner_flag = 'Y',
1109: freeze_flag = l_freeze_flag,
1110: created_by_tap_flag = 'Y'

Line 1121: INSERT INTO as_accesses_all

1117: FETCH c_get_open_status_flag INTO l_open_status_flag,
1118: l_lead_rank_score, l_creation_date;
1119: CLOSE c_get_open_status_flag;
1120:
1121: INSERT INTO as_accesses_all
1122: (ACCESS_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY
1123: ,CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN
1124: ,ACCESS_TYPE, FREEZE_FLAG, REASSIGN_FLAG, TEAM_LEADER_FLAG
1125: ,OWNER_FLAG, CREATED_BY_TAP_FLAG