DBA Data[Home] [Help]

APPS.CCT_SERVICEROUTING_PUB dependencies on JTF_TERRITORY_PUB

Line 46: l_agents_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

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

Line 47: l_acct_rec JTF_TERRITORY_PUB.JTF_Account_rec_type;

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;

Line 131: l_agents_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

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

Line 132: l_acct_rec JTF_TERRITORY_PUB.JTF_Oppor_rec_type;

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;