APPS.AS_SALES_LEADS_PUB dependencies on AS_TERRITORY_ACCESSES

Line 4132: -- The following variables are for as_territory_accesses

4128: l_qualified_flag VARCHAR2(1);
4129: l_lead_rank_id NUMBER;
4130:
4131: -- Bug 2822580, SOLIN, 03/07/2003
4132: -- The following variables are for as_territory_accesses
4133: l_ta_access_id_tbl JTF_NUMBER_TABLE;
4134: l_ta_terr_id_tbl JTF_NUMBER_TABLE;
4135: l_owner_exists_flag VARCHAR2(1);
4136:

Line 4142: FROM AS_ACCESSES_ALL ACC, AS_TERRITORY_ACCESSES TERRACC

4138: -- Delete these records before new resource records are created in
4139: -- AS_ACCESSES_ALL table.
4140: CURSOR C_Get_Acc_Terr(c_sales_lead_id NUMBER) IS
4141: SELECT ACC.ACCESS_ID, TERRACC.TERRITORY_ID
4142: FROM AS_ACCESSES_ALL ACC, AS_TERRITORY_ACCESSES TERRACC
4143: WHERE ACC.FREEZE_FLAG = 'N'
4144: AND ACC.SALES_LEAD_ID = c_sales_lead_id
4145: AND ACC.ACCESS_ID = TERRACC.ACCESS_ID;
4146: -- Bug 2822580, SOLIN, 03/07/2003, end

Line 4268: DELETE FROM AS_TERRITORY_ACCESSES

4264: DELETE FROM AS_ACCESSES_ALL
4265: WHERE ACCESS_ID = l_ta_access_id_tbl(l_i);
4266:
4267: FORALL l_i IN 1..l_ta_terr_id_tbl.count
4268: DELETE FROM AS_TERRITORY_ACCESSES
4269: WHERE ACCESS_ID = l_ta_access_id_tbl(l_i)
4270: AND TERRITORY_ID = l_ta_terr_id_tbl(l_i);
4271: END IF;
4272:

Line 4280: FROM as_territory_accesses terracc

4276: AND acc.freeze_flag = 'N'
4277: --AND acc.salesforce_id <> p_identity_salesforce_id
4278: AND NOT EXISTS (
4279: SELECT 1
4280: FROM as_territory_accesses terracc
4281: WHERE terracc.access_id = acc.access_id);
4282: -- Bug 2822580, SOLIN, 03/07/2003, end
4283:
4284: