42: l_proc_name VARCHAR2(30) := 'Set_Customer_Filter';
43: l_num_agents NUMBER := 0;
44: l_customer_ID NUMBER;
45: l_call_ID VARCHAR2(32);
46: l_agents_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
47: l_acct_rec JTF_TERRITORY_PUB.JTF_Account_rec_type;
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(2000);
50: l_return_status varchar2(01);
43: l_num_agents NUMBER := 0;
44: l_customer_ID NUMBER;
45: l_call_ID VARCHAR2(32);
46: l_agents_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
47: l_acct_rec JTF_TERRITORY_PUB.JTF_Account_rec_type;
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(2000);
50: l_return_status varchar2(01);
51: l_ret BOOLEAN;
127: l_proc_name VARCHAR2(30) := 'Set_Product_Filter';
128: l_num_agents NUMBER := 0;
129: l_product_ID NUMBER;
130: l_call_ID VARCHAR2(32);
131: l_agents_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
132: l_acct_rec JTF_TERRITORY_PUB.JTF_Oppor_rec_type;
133: l_msg_count NUMBER;
134: l_msg_data VARCHAR2(2000);
135: l_return_status varchar2(01);
128: l_num_agents NUMBER := 0;
129: l_product_ID NUMBER;
130: l_call_ID VARCHAR2(32);
131: l_agents_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
132: l_acct_rec JTF_TERRITORY_PUB.JTF_Oppor_rec_type;
133: l_msg_count NUMBER;
134: l_msg_data VARCHAR2(2000);
135: l_return_status varchar2(01);
136: l_ret BOOLEAN;