APPS.HZ_COPY_REL_PVT dependencies on HZ_PARTIES

Line 212: FROM hz_parties

208: ) RETURN VARCHAR2 IS
209:
210: CURSOR c_party IS
211: SELECT party_name
212: FROM hz_parties
213: WHERE party_id = p_party_id;
214:
215: l_party_name VARCHAR2(400);
216:

Line 377: IF p_child_table_name = 'HZ_PARTIES' THEN

373: x_return_status := 'E';
374:
375: -- prepare for message format 1
376: --
377: IF p_child_table_name = 'HZ_PARTIES' THEN
378: l_party_name := get_party_name(p_child_id);
379: ELSE
380: l_party_name := p_child_table_name||':'||p_child_id;
381: END IF;

Line 403: IF i_parent_table_name(i) = 'HZ_PARTIES' THEN

399: x_return_status := 'E';
400:
401: -- prepare for message format 1
402: --
403: IF i_parent_table_name(i) = 'HZ_PARTIES' THEN
404: l_party_name := get_party_name(i_parent_id(i));
405: ELSE
406: l_party_name := i_parent_table_name(i)||':'||i_parent_id(i);
407: END IF;

Line 426: IF l_table_name = 'HZ_PARTIES' THEN

422: LENGTHB(l_id)+2,
423: INSTRB(g_parent_nodes_tbl(j), '#', LENGTH(l_id)+2)-LENGTHB(l_id)-2);
424:
425: IF INSTRB(g_indexed_parent_nodes_tbl(l_id), '-1#'||g_parent_nodes_tbl(j)) > 0 THEN
426: IF l_table_name = 'HZ_PARTIES' THEN
427: l_party_name := get_party_name(l_id);
428: ELSE
429: l_party_name := l_table_name||':'||l_id;
430: END IF;