APPS.AS_PIPELINE_MOVE_PUB dependencies on AS_LEADS_ALL

Line 78: FROM AS_LEADS_ALL LD

74: from_sg_id NUMBER,
75: in_status VARCHAR)
76: IS
77: SELECT LD.LEAD_ID LEAD_ID
78: FROM AS_LEADS_ALL LD
79: WHERE LD.DECISION_DATE BETWEEN from_close_date AND to_close_date
80: AND LD.WIN_PROBABILITY BETWEEN from_win_prob AND to_win_prob
81: AND STATUS || '' IN in_status
82: AND EXISTS

Line 187: sqlstr := sqlstr || ' FROM AS_LEADS_ALL LD ';

183: BEGIN
184: -- ** LOOP THRO ALL LEADS THAT SATISFY INPUT CRITERIA *
185: -- dbms_output.put_line('Status is:'|| status_str);
186: sqlstr := ' SELECT LD.LEAD_ID lead_id ';
187: sqlstr := sqlstr || ' FROM AS_LEADS_ALL LD ';
188: sqlstr := sqlstr || ' WHERE LD.DECISION_DATE BETWEEN :from_close_date AND :to_close_date ';
189: sqlstr := sqlstr || ' AND LD.WIN_PROBABILITY BETWEEN :from_win_prob AND :to_win_prob ';
190: sqlstr := sqlstr || ' AND UPPER(STATUS) IN ';
191: sqlstr := sqlstr || status_str ;

Line 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;

270: AND CREDIT_TYPE_ID = SC_REC.CREDIT_TYPE_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

Line 279: UPDATE AS_LEADS_ALL L

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
280: SET object_version_number = nvl(object_version_number,0) + 1, L.OWNER_SALESFORCE_ID = to_res,
281: L.OWNER_SALES_GROUP_ID = to_group_id
282: WHERE L.LEAD_ID = L_LEAD_ID
283: AND L.OWNER_SALESFORCE_ID = from_res

Line 321: --- We will NTO be updating AS_LEADS_ALL

317: END IF;
318: END;
319: ELSE --- SR1 is NOT the owner
320: BEGIN
321: --- We will NTO be updating AS_LEADS_ALL
322: --* UPDATE SALES TEAM *
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

Line 516: from AS_LEADS_ALL ld

512: person_id = to_person,
513: salesgroup_id = to_sg_id
514: where exists
515: ( select ld.lead_id
516: from AS_LEADS_ALL ld
517: where ld.win_probability between from_win_prob and to_win_prob
518: and ld.decision_date between from_close_date and to_close_date
519: and ld.lead_id = sc.lead_id )
520: and sc.salesforce_id = from_sf_id

Line 535: from AS_LEADS_ALL ld

531: person_id = to_person,
532: salesgroup_id = to_sg_id
533: where exists
534: ( select ld.lead_id
535: from AS_LEADS_ALL ld
536: where ld.win_probability between from_win_prob and to_win_prob
537: and ld.decision_date between from_close_date and to_close_date
538: and ld.status = ld_status(i_count).status
539: and ld.lead_id = sc.lead_id )