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 515: HZ_PARTY_SITES PARTY_SITE,

511: -- Populate data into tax assignment table.
512:
513: SELECT LOC.LOCATION_ID INTO l_location_id
514: FROM HZ_LOCATIONS LOC,
515: HZ_PARTY_SITES PARTY_SITE,
516: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
517: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
518: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
519: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 695: * for synchronizing the status in HZ_PARTY_SITES.

691: * FND_NEW_MESSAGES is 'HZ_INACTIVATE_ACCOUNT_SITE_UI'.
692: * 02-AUG-2004 Rajib Ranjan Borah o Bug 3805019.party_site_id can be null during update.
693: * Therefore read the value of party_site_id from the
694: * database instead of using p_cust_acct_site_rec.party_site_id
695: * for synchronizing the status in HZ_PARTY_SITES.
696: * o Moreover the cursor does not pick rowid.
697: * o Removed redundant local variables l_dummy, l_ps_rowid.
698: * 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)
699: */

Line 829: FROM HZ_PARTY_SITES

825: -- Code modified for Bug 3714636 ends here
826: BEGIN
827: SELECT /*ROWID,*/ OBJECT_VERSION_NUMBER
828: INTO /*l_ps_rowid,*/ l_ps_object_version_number
829: FROM HZ_PARTY_SITES
830: WHERE PARTY_SITE_ID = l_party_site_id /* Bug 3805019: p_cust_acct_site_rec.party_site_id */
831: FOR UPDATE NOWAIT;
832:
833: --p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 939: HZ_PARTY_SITES PARTY_SITE,

935: -- Update location should populate the change to tax assignment.
936: -- Bug Fix : 2230802.
937: SELECT LOC.LOCATION_ID INTO l_location_id
938: FROM HZ_LOCATIONS LOC,
939: HZ_PARTY_SITES PARTY_SITE,
940: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
941: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
942: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
943: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;