[Home] [Help]
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
267: FROM jtf_rs_resource_extns jrd,
264:
265: CURSOR resource_details(p_resource_id number) IS
266: SELECT fu.user_id
267: FROM jtf_rs_resource_extns jrd,
268: fnd_user fu
269: WHERE jrd.resource_id=p_resource_id
270: AND fu.user_id = jrd.user_id;
271:
272:
751:
752: PROCEDURE NOTIFY_TERRITORY_ADMIN (p_chr_id IN Number,p_contract_number IN VARCHAR2, p_contract_number_modifier IN VARCHAR2, p_mesg IN VARCHAR2) IS
753: CURSOR l_fnd_csr(p_user_id NUMBER) IS
754: SELECT user_name
755: FROM fnd_user
756: WHERE user_id = p_user_id ;
757:
758:
759: l_msg_count NUMBER;
877: l_msg_count Number;
878: l_user_name Varchar2(2000);
879: l_subj Varchar2(4000) := Null;
880:
881: cursor l_fnd_csr is select user_name from fnd_user where user_id = p_notify_id;
882:
883: Begin
884:
885: if p_type = 'NSA' Then
1731: ---------------------------------------------------------------------
1732:
1733: CURSOR resource_details(p_resource_id number) IS
1734: SELECT fu.user_id
1735: FROM jtf_rs_resource_extns jrd,fnd_user fu
1736: WHERE jrd.resource_id=p_resource_id
1737: AND fu.user_id = jrd.user_id;
1738:
1739: CURSOR create_contact_resource IS