eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VP_JTF_PARTY_NAME_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 158: p_role_code IN OKC_K_PARTY_ROLES_V.rle_code%Type,

154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_chr_id IN VARCHAR2,
157: p_cle_id IN VARCHAR2,
158: p_role_code IN OKC_K_PARTY_ROLES_V.rle_code%Type,
159: p_intent IN VARCHAR2 default 'S',
160: x_party_tab out nocopy party_tab_type) is
161: CURSOR party_role_curs(p_chr_id IN NUMBER,
162: p_cle_id IN NUMBER,

Line 187: from OKC_K_PARTY_ROLES_V

183: select object1_id1,
184: object1_id2,
185: jtot_object1_code,
186: rle_code
187: from OKC_K_PARTY_ROLES_V
188: where rle_code = nvl(p_role_code,rle_code)
189: and nvl(cle_id,-99999) = p_cle_id
190: and nvl(chr_id,-99999) = p_chr_id
191: and dnz_chr_id = decode(p_chr_id,null,dnz_chr_id,p_dnz_chr_id)

Line 200: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

196: l_from_clause varchar2(2000) default null;
197: l_where_clause varchar2(2000) default null;
198: l_order_by_clause varchar2(2000) default null;
199: l_query_string varchar2(2000) default null;
200: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
201: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
202: l_name VARCHAR2(250) Default Null;
203: l_Description VARCHAR2(250) Default Null;
204: l_object_code VARCHAR2(30) Default Null;

Line 201: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;

197: l_where_clause varchar2(2000) default null;
198: l_order_by_clause varchar2(2000) default null;
199: l_query_string varchar2(2000) default null;
200: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
201: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
202: l_name VARCHAR2(250) Default Null;
203: l_Description VARCHAR2(250) Default Null;
204: l_object_code VARCHAR2(30) Default Null;
205: type party_curs_type is REF CURSOR;

Line 407: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

403: l_from_clause varchar2(2000) default null;
404: l_where_clause varchar2(2000) default null;
405: l_order_by_clause varchar2(2000) default null;
406: l_query_string varchar2(2000) default null;
407: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
408: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
409: l_name VARCHAR2(250) Default Null;
410: l_Description VARCHAR2(250) Default Null;
411: l_object_code VARCHAR2(30) Default Null;

Line 408: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;

404: l_where_clause varchar2(2000) default null;
405: l_order_by_clause varchar2(2000) default null;
406: l_query_string varchar2(2000) default null;
407: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
408: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
409: l_name VARCHAR2(250) Default Null;
410: l_Description VARCHAR2(250) Default Null;
411: l_object_code VARCHAR2(30) Default Null;
412: type party_curs_type is REF CURSOR;