eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CUST_SITE_USES_PKG dependencies on HZ_CUST_SITE_USES

Line 1: PACKAGE BODY HZ_CUST_SITE_USES_PKG AS

1: PACKAGE BODY HZ_CUST_SITE_USES_PKG AS
2: /*$Header: ARHASUTB.pls 120.2 2005/05/20 19:39:31 rborah ship $ */
3:
4: PROCEDURE Insert_Row (
5: X_SITE_USE_ID IN OUT NOCOPY NUMBER,

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 234: DECODE( X_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_CUST_SITE_USES_S.NEXTVAL, NULL, HZ_CUST_SITE_USES_S.NEXTVAL, X_SITE_USE_ID ),

230: APPLICATION_ID,
231: ORG_ID
232: )
233: VALUES (
234: DECODE( X_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_CUST_SITE_USES_S.NEXTVAL, NULL, HZ_CUST_SITE_USES_S.NEXTVAL, X_SITE_USE_ID ),
235: DECODE( X_CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
236: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
237: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
238: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 243: DECODE( X_LOCATION, FND_API.G_MISS_CHAR, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), NULL, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), X_LOCATION ),

239: HZ_UTILITY_V2PUB.CREATED_BY,
240: DECODE( X_SITE_USE_CODE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_CODE ),
241: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
242: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
243: DECODE( X_LOCATION, FND_API.G_MISS_CHAR, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), NULL, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), X_LOCATION ),
244: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
245: DECODE( X_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_ID ),
246: DECODE( X_BILL_TO_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_BILL_TO_SITE_USE_ID ),
247: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

Line 247: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

243: DECODE( X_LOCATION, FND_API.G_MISS_CHAR, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), NULL, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), X_LOCATION ),
244: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
245: DECODE( X_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_ID ),
246: DECODE( X_BILL_TO_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_BILL_TO_SITE_USE_ID ),
247: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
248: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
249: DECODE( X_PAYMENT_TERM_ID, FND_API.G_MISS_NUM, NULL, X_PAYMENT_TERM_ID ),
250: DECODE( X_GSA_INDICATOR, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_GSA_INDICATOR ),
251: -- DECODE( X_SHIP_PARTIAL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_SHIP_PARTIAL ),

Line 358: IF INSTRB( SQLERRM, 'HZ_CUST_SITE_USES_U1' ) <> 0 OR

354: l_success := 'Y';
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;

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 367: SELECT HZ_CUST_SITE_USES_S.NEXTVAL

363: l_dummy VARCHAR2(1);
364: BEGIN
365: l_count := 1;
366: WHILE l_count > 0 LOOP
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

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 732: SELECT * FROM HZ_CUST_SITE_USES

728: X_APPLICATION_ID IN NUMBER
729: ) IS
730:
731: CURSOR C IS
732: SELECT * FROM HZ_CUST_SITE_USES
733: WHERE ROWID = x_Rowid
734: FOR UPDATE NOWAIT;
735: Recinfo C%ROWTYPE;
736:

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;

Line 1423: END HZ_CUST_SITE_USES_PKG;

1419: END IF;
1420:
1421: END Delete_Row;
1422:
1423: END HZ_CUST_SITE_USES_PKG;