APPS.HZ_CUST_ACCT_SITES_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 78: INSERT INTO HZ_CUST_ACCT_SITES_ALL ( -- Bug 3456489

74: END IF;
75:
76: WHILE l_success = 'N' LOOP
77: BEGIN
78: INSERT INTO HZ_CUST_ACCT_SITES_ALL ( -- Bug 3456489
79: CUST_ACCT_SITE_ID,
80: CUST_ACCOUNT_ID,
81: PARTY_SITE_ID,
82: LAST_UPDATE_DATE,

Line 243: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

239: SELECT HZ_CUST_ACCT_SITES_S.NEXTVAL
240: INTO X_CUST_ACCT_SITE_ID FROM dual;
241: BEGIN
242: SELECT 'Y' INTO l_dummy
243: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
244: WHERE CUST_ACCT_SITE_ID = X_CUST_ACCT_SITE_ID;
245: l_count := 1;
246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN

Line 265: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

261: SELECT HZ_CUST_ACCT_SITES_S.NEXTVAL
262: INTO X_CUST_ACCT_SITE_ID FROM dual;
263: BEGIN
264: SELECT 'Y' INTO l_dummy
265: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
266: WHERE ORIG_SYSTEM_REFERENCE = to_char(X_CUST_ACCT_SITE_ID)
267: AND ORG_ID = X_ORG_ID; -- Bug 3456489
268:
269: l_count := 1;

Line 351: UPDATE HZ_CUST_ACCT_SITES_ALL SET

347: ) IS
348:
349: BEGIN
350:
351: UPDATE HZ_CUST_ACCT_SITES_ALL SET
352: CUST_ACCT_SITE_ID = DECODE( X_CUST_ACCT_SITE_ID, NULL, CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
353: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
354: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
355: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 919: FROM HZ_CUST_ACCT_SITES_ALL

915: X_TRANSLATED_CUSTOMER_NAME,
916: X_CREATED_BY_MODULE,
917: X_APPLICATION_ID,
918: X_ORG_ID
919: FROM HZ_CUST_ACCT_SITES_ALL
920: WHERE CUST_ACCT_SITE_ID = X_CUST_ACCT_SITE_ID;
921:
922: EXCEPTION
923: WHEN NO_DATA_FOUND THEN

Line 938: DELETE FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

934: ) IS
935:
936: BEGIN
937:
938: DELETE FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
939: WHERE CUST_ACCT_SITE_ID = X_CUST_ACCT_SITE_ID;
940:
941: IF ( SQL%NOTFOUND ) THEN
942: RAISE NO_DATA_FOUND;