APPS.HZ_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_PARTY_SITES

Line 173: * HZ_PARTY_SITES need not be read for synchronizing

169: * 02-AUG-2004 Rajib Ranjan Borah o Bug 3805019. If status is NULL and the corresponding
170: * status is 'A', then warning HZ_ACCT_SITE_INHERIT_STATUS
171: * will not be displayed.
172: * o Rowid and object_version_number in
173: * HZ_PARTY_SITES need not be read for synchronizing
174: * statuses.
175: * Removed unnecessary variables l_ps_rowid,
176: * l_ps_object_version_number and l_dummy.
177: * 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)

Line 264: FROM HZ_PARTY_SITES

260: -- Code modified for Bug 3714636 ends here
261: BEGIN
262: SELECT /*ROWID, OBJECT_VERSION_NUMBER,*/status
263: INTO /*l_ps_rowid, l_ps_object_version_number,*/l_status
264: FROM HZ_PARTY_SITES
265: WHERE PARTY_SITE_ID = p_cust_acct_site_rec.party_site_id
266: FOR UPDATE NOWAIT;
267:
268: --p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 504: HZ_PARTY_SITES PARTY_SITE,

500: -- Populate data into tax assignment table.
501:
502: SELECT LOC.LOCATION_ID INTO l_location_id
503: FROM HZ_LOCATIONS LOC,
504: HZ_PARTY_SITES PARTY_SITE,
505: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
506: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
507: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
508: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 616: * for synchronizing the status in HZ_PARTY_SITES.

612: * FND_NEW_MESSAGES is 'HZ_INACTIVATE_ACCOUNT_SITE_UI'.
613: * 02-AUG-2004 Rajib Ranjan Borah o Bug 3805019.party_site_id can be null during update.
614: * Therefore read the value of party_site_id from the
615: * database instead of using p_cust_acct_site_rec.party_site_id
616: * for synchronizing the status in HZ_PARTY_SITES.
617: * o Moreover the cursor does not pick rowid.
618: * o Removed redundant local variables l_dummy, l_ps_rowid.
619: * 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)
620: */

Line 750: FROM HZ_PARTY_SITES

746: -- Code modified for Bug 3714636 ends here
747: BEGIN
748: SELECT /*ROWID,*/ OBJECT_VERSION_NUMBER
749: INTO /*l_ps_rowid,*/ l_ps_object_version_number
750: FROM HZ_PARTY_SITES
751: WHERE PARTY_SITE_ID = l_party_site_id /* Bug 3805019: p_cust_acct_site_rec.party_site_id */
752: FOR UPDATE NOWAIT;
753:
754: --p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 857: HZ_PARTY_SITES PARTY_SITE,

853: -- Update location should populate the change to tax assignment.
854: -- Bug Fix : 2230802.
855: SELECT LOC.LOCATION_ID INTO l_location_id
856: FROM HZ_LOCATIONS LOC,
857: HZ_PARTY_SITES PARTY_SITE,
858: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
859: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
860: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
861: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;