APPS.AS_SALES_LEADS_PUB dependencies on JTF_NUMBER_TABLE

Line 60: -- Use type JTF_NUMBER_TABLE, instead of NUMBER_TABLE

56: -- 06/16/2003 SOLIN Bug 3007246
57: -- Route_Lead_To_Marketing should update sales_group_id
58: -- for as_accesses_all table once a new owner is found.
59: -- 08/19/2003 SOLIN Bug 3102332
60: -- Use type JTF_NUMBER_TABLE, instead of NUMBER_TABLE
61: --
62: -- End of Comments
63:
64: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEADS_PUB';

Line 4133: l_ta_access_id_tbl JTF_NUMBER_TABLE;

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:
4137: -- Get access_id, terr_id for the records that come from LEAD territory.

Line 4134: l_ta_terr_id_tbl JTF_NUMBER_TABLE;

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:
4137: -- Get access_id, terr_id for the records that come from LEAD territory.
4138: -- Delete these records before new resource records are created in