DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PUB dependencies on JTF_TERRITORY_PUB

Line 256: l_terrkren_rec jtf_territory_pub.jtf_kren_rec_type;

252: x_msg_data OUT NOCOPY Varchar2,
253: x_winning_res_id OUT NOCOPY NUMBER, --l_salesrep_id,
254: x_winning_user_id OUT NOCOPY NUMBER
255: ) IS
256: l_terrkren_rec jtf_territory_pub.jtf_kren_rec_type;
257: l_resource_type varchar2(100) := to_char(null);
258: l_role varchar2(100) := to_char(null);
259: l_return_status varchar2(1);
260: l_msg_count NUMBER;

Line 262: l_terrresource_tbl jtf_territory_pub.winningterrmember_tbl_type;

258: l_role varchar2(100) := to_char(null);
259: l_return_status varchar2(1);
260: l_msg_count NUMBER;
261: l_msg_data varchar2(2000);
262: l_terrresource_tbl jtf_territory_pub.winningterrmember_tbl_type;
263: l_user_id fnd_user.user_id%TYPE;
264:
265: CURSOR resource_details(p_resource_id number) IS
266: SELECT fu.user_id