APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_PARTY_SITES

Line 35: IF p_owner_table_name = 'HZ_PARTY_SITES' then

31: l_owner_table_name VARCHAR2(30);
32: BEGIN
33: -- Resolve passed in owner table name according to HZ conventions
34:
35: IF p_owner_table_name = 'HZ_PARTY_SITES' then
36: l_owner_table_name := 'HZ_LOCATIONS';
37: ELSIF p_owner_table_name = 'HZ_FINANCIAL_NUMBERS' then
38: l_owner_table_name := 'HZ_FINANCIAL_REPORTS';
39: ELSE

Line 116: if p_owner_table_name = 'HZ_PARTIES' OR p_owner_table_name = 'HZ_PARTY_SITES' then

112: l_count Number;
113:
114: begin
115:
116: if p_owner_table_name = 'HZ_PARTIES' OR p_owner_table_name = 'HZ_PARTY_SITES' then
117: open get_pps_ssc_csr;
118: fetch get_pps_ssc_csr into l_count;
119: close get_pps_ssc_csr;
120:

Line 636: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES'

632:
633: END;
634:
635: -- SYNC PARTY SITES
636: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES'
637: THEN
638: BEGIN--bug 6069559
639: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=p_orig_sys_reference_rec.owner_table_id ;
640:

Line 639: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=p_orig_sys_reference_rec.owner_table_id ;

635: -- SYNC PARTY SITES
636: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES'
637: THEN
638: BEGIN--bug 6069559
639: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=p_orig_sys_reference_rec.owner_table_id ;
640:
641: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
642: HZ_DQM_SYNC.sync_party_site(p_orig_sys_reference_rec.owner_table_id ,'U') ;
643: END IF;

Line 976: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES'

972:
973: END;
974:
975: -- SYNC PARTY SITES
976: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES'
977: THEN
978: BEGIN--bug 6069559
979: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=l_temp;
980:

Line 979: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=l_temp;

975: -- SYNC PARTY SITES
976: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES'
977: THEN
978: BEGIN--bug 6069559
979: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=l_temp;
980:
981: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
982: HZ_DQM_SYNC.sync_party_site(l_temp ,'U') ;
983: END IF;

Line 1927: --// Table hz_party_sites

1923: x_party_id OUT NOCOPY NUMBER
1924: )
1925: IS
1926:
1927: --// Table hz_party_sites
1928: cursor c_party_site_id is
1929: select party_id
1930: from hz_party_sites
1931: where party_site_id = p_owner_table_id;

Line 1930: from hz_party_sites

1926:
1927: --// Table hz_party_sites
1928: cursor c_party_site_id is
1929: select party_id
1930: from hz_party_sites
1931: where party_site_id = p_owner_table_id;
1932: --and status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1933:
1934: --//Table hz_cust_accounts

Line 1967: from hz_party_sites psite,hz_contact_points cont

1963: and cont.owner_table_id = party.party_id
1964: --and cont.status = 'A' -- Bug 3196803 : Removed the check of status = 'A'
1965: union
1966: select psite.party_site_id
1967: from hz_party_sites psite,hz_contact_points cont
1968: where cont.contact_point_id = p_owner_table_id
1969: and cont.owner_table_id = psite.party_site_id;
1970: --and cont.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1971:

Line 2004: elsif p_owner_table_name = 'HZ_PARTY_SITES' then

2000:
2001: if p_owner_table_name = 'HZ_PARTIES' then
2002: x_party_id := p_owner_table_id;
2003:
2004: elsif p_owner_table_name = 'HZ_PARTY_SITES' then
2005: open c_party_site_id;
2006: fetch c_party_site_id into x_party_id;
2007: close c_party_site_id;
2008: