APPS.AS_PIPELINE_MOVE_PUB dependencies on AS_ACCESSES_ALL

Line 84: FROM AS_ACCESSES_ALL ACC

80: AND LD.WIN_PROBABILITY BETWEEN from_win_prob AND to_win_prob
81: AND STATUS || '' IN in_status
82: AND EXISTS
83: (SELECT 1
84: FROM AS_ACCESSES_ALL ACC
85: WHERE ACC.LEAD_ID = LD.LEAD_ID
86: AND ACC.SALESFORCE_ID = from_sf_id
87: AND ACC.SALES_GROUP_ID = from_sg_id);
88: */

Line 194: sqlstr := sqlstr || ' FROM AS_ACCESSES_ALL ACC ';

190: sqlstr := sqlstr || ' AND UPPER(STATUS) IN ';
191: sqlstr := sqlstr || status_str ;
192: sqlstr := sqlstr || ' AND EXISTS ';
193: sqlstr := sqlstr || ' (SELECT 1';
194: sqlstr := sqlstr || ' FROM AS_ACCESSES_ALL ACC ';
195: sqlstr := sqlstr || ' WHERE ACC.LEAD_ID = LD.LEAD_ID ';
196: sqlstr := sqlstr || ' AND ACC.SALESFORCE_ID = :from_sf_id ';
197: sqlstr := sqlstr || ' AND ACC.SALES_GROUP_ID = :from_sg_id) ';
198: OPEN curs for sqlstr using from_close_date ,to_close_date ,from_win_prob ,to_win_prob ,from_res ,from_group_id ;

Line 275: SELECT COUNT(*) INTO is_in_sales_team FROM AS_ACCESSES_ALL ACC WHERE ACC.LEAD_ID = L_LEAD_ID AND ACC.SALESFORCE_ID = to_res AND ACC.SALES_GROUP_ID = to_group_id;

271: --dbms_output.put_line('After deleteing sales credit:'|| SQL%ROWCOUNT);
272: END LOOP;
273: --* UPDATE LEADS *
274: SELECT COUNT(*) INTO is_owner FROM AS_LEADS_ALL L WHERE L.LEAD_ID = L_LEAD_ID AND L.OWNER_SALESFORCE_ID = from_res AND L.OWNER_SALES_GROUP_ID = from_group_id;
275: SELECT COUNT(*) INTO is_in_sales_team FROM AS_ACCESSES_ALL ACC WHERE ACC.LEAD_ID = L_LEAD_ID AND ACC.SALESFORCE_ID = to_res AND ACC.SALES_GROUP_ID = to_group_id;
276: --* CASE 1 - IF SR1 was owner *
277: IF is_owner = 1 THEN
278: BEGIN
279: UPDATE AS_LEADS_ALL L

Line 290: DELETE FROM AS_ACCESSES_ALL ACC

286: --* CASE 1 - SR1/GRP1 moved to SR2/GRP2 *
287: If is_in_sales_team = 1 THEN --* CASE 1A - SR2/GRP2 is already in SALES TEAM *
288: BEGIN
289: -- delete SR1/GR1 from SALES TEAM
290: DELETE FROM AS_ACCESSES_ALL ACC
291: WHERE ACC.LEAD_ID = L_LEAD_ID
292: AND ACC.SALESFORCE_ID = from_res
293: AND ACC.SALES_GROUP_ID = from_group_id
294: AND ACC.PERSON_ID = from_person ;

Line 296: UPDATE AS_ACCESSES_ALL ACC

292: AND ACC.SALESFORCE_ID = from_res
293: AND ACC.SALES_GROUP_ID = from_group_id
294: AND ACC.PERSON_ID = from_person ;
295: -- IF SR1 was the owner then give full access and ownership TO SR2
296: UPDATE AS_ACCESSES_ALL ACC
297: SET object_version_number = nvl(object_version_number,0) + 1, OWNER_FLAG = 'Y',
298: TEAM_LEADER_FLAG = 'Y'
299: WHERE ACC.LEAD_ID = L_LEAD_ID
300: AND ACC.SALESFORCE_ID = to_res

Line 306: UPDATE AS_ACCESSES_ALL ACC

302: AND ACC.PERSON_ID = to_person ;
303: END;
304: ELSE --* CASE 1B - SR2/GRP2 is NOT in SALES TEAM *
305: BEGIN
306: UPDATE AS_ACCESSES_ALL ACC
307: SET object_version_number = nvl(object_version_number,0) + 1, SALESFORCE_ID = to_res,
308: SALES_GROUP_ID = to_group_id,
309: PERSON_ID = to_person,
310: OWNER_FLAG = 'Y',

Line 327: DELETE FROM AS_ACCESSES_ALL ACC

323: --* CASE 1 - SR1/GRP1 moved to SR2/GRP2 *
324: If is_in_sales_team = 1 THEN --* CASE 1A - SR2/GRP2 is already in SALES TEAM *
325: BEGIN
326: -- delete SR1/GR1 from SALES TEAM
327: DELETE FROM AS_ACCESSES_ALL ACC
328: WHERE ACC.LEAD_ID = L_LEAD_ID
329: AND ACC.SALESFORCE_ID = from_res
330: AND ACC.SALES_GROUP_ID = from_group_id
331: AND ACC.PERSON_ID = from_person ;

Line 337: UPDATE AS_ACCESSES_ALL ACC

333: -- No need to do this here since SR1 was not the owner.
334: END;
335: ELSE --** CASE 1B - SR2/GRP2 is NOT in SALES TEAM *
336: BEGIN
337: UPDATE AS_ACCESSES_ALL ACC
338: SET object_version_number = nvl(object_version_number,0) + 1, SALESFORCE_ID = to_res,
339: SALES_GROUP_ID = to_group_id,
340: PERSON_ID = to_person
341: WHERE ACC.LEAD_ID = L_LEAD_ID