DBA Data[Home] [Help]

APPS.PV_BG_PARTNER_MATCHING_PUB dependencies on JTF_NUMBER_TABLE

Line 914: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

910:
911: cursor lc_get_lead_detail (pc_lead_id number) is
912: select customer_id, address_id, source_promotion_id from as_leads_all where lead_id = pc_lead_id;
913:
914: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
915: l_partner_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
916: l_partner_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
917:
918: l_partner_id_tmp NUMBER;

Line 915: l_partner_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

911: cursor lc_get_lead_detail (pc_lead_id number) is
912: select customer_id, address_id, source_promotion_id from as_leads_all where lead_id = pc_lead_id;
913:
914: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
915: l_partner_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
916: l_partner_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
917:
918: l_partner_id_tmp NUMBER;
919: l_partner_rank_tmp NUMBER;