APPS.HZ_CUST_SITE_USES_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 119: INSERT INTO HZ_CUST_SITE_USES_ALL (

115: X_SITE_USE_ID := NULL;
116: END IF;
117: WHILE l_success = 'N' LOOP
118: BEGIN
119: INSERT INTO HZ_CUST_SITE_USES_ALL (
120: SITE_USE_ID,
121: CUST_ACCT_SITE_ID,
122: LAST_UPDATE_DATE,
123: LAST_UPDATED_BY,

Line 359: INSTRB( SQLERRM, 'HZ_CUST_SITE_USES_ALL_PK' ) <> 0

355:
356: EXCEPTION
357: WHEN DUP_VAL_ON_INDEX THEN
358: IF INSTRB( SQLERRM, 'HZ_CUST_SITE_USES_U1' ) <> 0 OR
359: INSTRB( SQLERRM, 'HZ_CUST_SITE_USES_ALL_PK' ) <> 0
360: THEN
361: DECLARE
362: l_count NUMBER;
363: l_dummy VARCHAR2(1);

Line 371: FROM HZ_CUST_SITE_USES_ALL

367: SELECT HZ_CUST_SITE_USES_S.NEXTVAL
368: INTO X_SITE_USE_ID FROM dual;
369: BEGIN
370: SELECT 'Y' INTO l_dummy
371: FROM HZ_CUST_SITE_USES_ALL
372: WHERE SITE_USE_ID = X_SITE_USE_ID;
373: l_count := 1;
374: EXCEPTION
375: WHEN NO_DATA_FOUND THEN

Line 497: UPDATE HZ_CUST_SITE_USES_ALL SET

493: ) IS
494:
495: BEGIN
496:
497: UPDATE HZ_CUST_SITE_USES_ALL SET
498: SITE_USE_ID = DECODE( X_SITE_USE_ID, NULL, SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_SITE_USE_ID ),
499: 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 ),
500: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
501: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 1395: FROM HZ_CUST_SITE_USES_ALL

1391: X_TAX_CLASSIFICATION,
1392: X_CREATED_BY_MODULE,
1393: X_APPLICATION_ID,
1394: X_ORG_ID -- Bug 3456489
1395: FROM HZ_CUST_SITE_USES_ALL
1396: WHERE SITE_USE_ID = X_SITE_USE_ID;
1397:
1398: EXCEPTION
1399: WHEN NO_DATA_FOUND THEN

Line 1414: DELETE FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489

1410: ) IS
1411:
1412: BEGIN
1413:
1414: DELETE FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489
1415: WHERE SITE_USE_ID = X_SITE_USE_ID;
1416:
1417: IF ( SQL%NOTFOUND ) THEN
1418: RAISE NO_DATA_FOUND;