APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_PARTIES

Line 23: and child_entity_name = 'HZ_PARTIES'

19: SELECT 'Y'
20: FROM HZ_BUS_OBJ_TRACKING
21: WHERE parent_bo_code is null
22: and event_id = p_event_id
23: and child_entity_name = 'HZ_PARTIES'
24: and child_id = nvl(p_party_id, child_id)
25: and child_bo_code = p_bo_code
26: and nvl(parent_event_flag, p_event_type) = p_event_type
27: and rownum = 1;

Line 66: from hz_parties

62: l_party_type varchar2(30) := null;
63:
64: cursor c1 is
65: select party_type
66: from hz_parties
67: where party_id = p_parent_id;
68:
69: cursor c2 is
70: select party_type

Line 71: from hz_parties p, hz_cust_accounts ca

67: where party_id = p_parent_id;
68:
69: cursor c2 is
70: select party_type
71: from hz_parties p, hz_cust_accounts ca
72: where p.party_id = ca.party_id
73: and ca.cust_account_id = p_parent_id;
74:
75: cursor c_cp is

Line 81: if p_parent_table_name = 'HZ_PARTIES'

77: from HZ_CONTACT_POINTS
78: where contact_point_id = p_parent_id;
79:
80: BEGIN
81: if p_parent_table_name = 'HZ_PARTIES'
82: then
83: open c1;
84: fetch c1 into l_party_type;
85: close c1;

Line 101: ELSIF(p_parent_table_name = 'HZ_PARTIES') THEN

97:
98: -- Base on owner_table_name to return HZ_BUSINESS_OBJECTS lookup code
99: IF(p_parent_table_name = 'HZ_PARTY_SITES') THEN
100: RETURN 'PARTY_SITE';
101: ELSIF(p_parent_table_name = 'HZ_PARTIES') THEN
102: IF(l_party_type = 'ORGANIZATION') THEN
103: RETURN 'ORG';
104: ELSIF(l_party_type = 'PERSON') THEN
105: RETURN 'PERSON';

Line 159: and child_entity_name = 'HZ_PARTIES';

155: SELECT child_id
156: FROM HZ_BUS_OBJ_TRACKING
157: WHERE parent_bo_code is null
158: and event_id = p_event_id
159: and child_entity_name = 'HZ_PARTIES';
160:
161: begin
162: -- initialize API return status to success.
163: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 301: FROM HZ_PARTIES

297: WHERE org_contact_id = l_oc_id;
298:
299: CURSOR is_pty_valid(l_pty_id NUMBER, l_pty_type VARCHAR2) IS
300: SELECT 'X'
301: FROM HZ_PARTIES
302: WHERE party_id = l_pty_id
303: AND party_type = l_pty_type
304: AND status in ('A', 'I');
305:

Line 405: l_obj_type := 'HZ_PARTIES';

401: IF(l_ss_flag = 'Y')THEN
402: IF(p_obj_type in ('PHONE','TLX','EMAIL','WEB','EFT','EDI','SMS')) THEN
403: l_obj_type := 'HZ_CONTACT_POINTS';
404: ELSIF(p_obj_type in ('PERSON','ORGANIZATION','PARTY_RELATIONSHIP')) THEN
405: l_obj_type := 'HZ_PARTIES';
406: ELSE
407: l_obj_type := p_obj_type;
408: END IF;
409: