88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,
90: p_chr_id IN VARCHAR2,
91: p_cle_id IN VARCHAR2,
92: p_role_code IN OKC_K_PARTY_ROLES_V.rle_code%Type,
93: p_intent IN VARCHAR2 default 'S',
94: x_party_tab out nocopy party_tab_type) is
95:
96: CURSOR party_role_curs(p_chr_id IN NUMBER,
100: select object1_id1,
101: object1_id2,
102: jtot_object1_code,
103: rle_code
104: from OKC_K_PARTY_ROLES_V
105: where rle_code = nvl(p_role_code,rle_code)
106: and nvl(cle_id,-99999) = p_cle_id
107: and nvl(chr_id,-99999) = p_chr_id
108: and dnz_chr_id = decode(p_chr_id,null,dnz_chr_id,p_dnz_chr_id)
112: l_from_clause varchar2(2000) default null;
113: l_where_clause varchar2(2000) default null;
114: l_order_by_clause varchar2(2000) default null;
115: l_query_string varchar2(2000) default null;
116: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
117: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
118: l_name VARCHAR2(250) Default Null;
119: l_Description VARCHAR2(250) Default Null;
120: l_object_code VARCHAR2(30) Default Null;
113: l_where_clause varchar2(2000) default null;
114: l_order_by_clause varchar2(2000) default null;
115: l_query_string varchar2(2000) default null;
116: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
117: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
118: l_name VARCHAR2(250) Default Null;
119: l_Description VARCHAR2(250) Default Null;
120: l_object_code VARCHAR2(30) Default Null;
121: type party_curs_type is REF CURSOR;
267: l_from_clause varchar2(2000) default null;
268: l_where_clause varchar2(2000) default null;
269: l_order_by_clause varchar2(2000) default null;
270: l_query_string varchar2(2000) default null;
271: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
272: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
273: l_name VARCHAR2(250) Default Null;
274: l_Description VARCHAR2(250) Default Null;
275: l_object_code VARCHAR2(30) Default Null;
268: l_where_clause varchar2(2000) default null;
269: l_order_by_clause varchar2(2000) default null;
270: l_query_string varchar2(2000) default null;
271: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
272: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
273: l_name VARCHAR2(250) Default Null;
274: l_Description VARCHAR2(250) Default Null;
275: l_object_code VARCHAR2(30) Default Null;
276: type party_curs_type is REF CURSOR;