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 653: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES'

649:
650: END;
651:
652: -- SYNC PARTY SITES
653: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES'
654: THEN
655: BEGIN--bug 6069559
656: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=p_orig_sys_reference_rec.owner_table_id ;
657:

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

652: -- SYNC PARTY SITES
653: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES'
654: THEN
655: BEGIN--bug 6069559
656: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=p_orig_sys_reference_rec.owner_table_id ;
657:
658: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
659: HZ_DQM_SYNC.sync_party_site(p_orig_sys_reference_rec.owner_table_id ,'U') ;
660: END IF;

Line 1005: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES'

1001:
1002: END;
1003:
1004: -- SYNC PARTY SITES
1005: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES'
1006: THEN
1007: BEGIN--bug 6069559
1008: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=l_temp;
1009:

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

1004: -- SYNC PARTY SITES
1005: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES'
1006: THEN
1007: BEGIN--bug 6069559
1008: SELECT status INTO l_status FROM hz_party_sites WHERE party_site_id=l_temp;
1009:
1010: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
1011: HZ_DQM_SYNC.sync_party_site(l_temp ,'U') ;
1012: END IF;

Line 1974: --// Table hz_party_sites

1970: x_party_id OUT NOCOPY NUMBER
1971: )
1972: IS
1973:
1974: --// Table hz_party_sites
1975: cursor c_party_site_id is
1976: select party_id
1977: from hz_party_sites
1978: where party_site_id = p_owner_table_id;

Line 1977: from hz_party_sites

1973:
1974: --// Table hz_party_sites
1975: cursor c_party_site_id is
1976: select party_id
1977: from hz_party_sites
1978: where party_site_id = p_owner_table_id;
1979: --and status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1980:
1981: --//Table hz_cust_accounts

Line 2014: from hz_party_sites psite,hz_contact_points cont

2010: and cont.owner_table_id = party.party_id
2011: --and cont.status = 'A' -- Bug 3196803 : Removed the check of status = 'A'
2012: union
2013: select psite.party_site_id
2014: from hz_party_sites psite,hz_contact_points cont
2015: where cont.contact_point_id = p_owner_table_id
2016: and cont.owner_table_id = psite.party_site_id;
2017: --and cont.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
2018:

Line 2051: elsif p_owner_table_name = 'HZ_PARTY_SITES' then

2047:
2048: if p_owner_table_name = 'HZ_PARTIES' then
2049: x_party_id := p_owner_table_id;
2050:
2051: elsif p_owner_table_name = 'HZ_PARTY_SITES' then
2052: open c_party_site_id;
2053: fetch c_party_site_id into x_party_id;
2054: close c_party_site_id;
2055: