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_ACCOUNTS_PKG dependencies on HZ_CUST_ACCOUNTS

Line 1: PACKAGE BODY HZ_CUST_ACCOUNTS_PKG AS

1: PACKAGE BODY HZ_CUST_ACCOUNTS_PKG AS
2: /*$Header: ARHCACTB.pls 120.8 2012/01/13 14:19:30 rgokavar ship $ */
3:
4: PROCEDURE Insert_Row (
5: X_CUST_ACCOUNT_ID IN OUT NOCOPY NUMBER,

Line 132: INSERT INTO HZ_CUST_ACCOUNTS (

128: END IF;
129:
130: WHILE l_success = 'N' LOOP
131: BEGIN
132: INSERT INTO HZ_CUST_ACCOUNTS (
133: CUST_ACCOUNT_ID,
134: ACCOUNT_NUMBER,
135: PARTY_ID,
136: LAST_UPDATE_DATE,

Line 238: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCOUNTS_S.NEXTVAL, NULL, HZ_CUST_ACCOUNTS_S.NEXTVAL, X_CUST_ACCOUNT_ID ),

234: DUNS_EXTENSION,
235: ADVANCE_PAYMENT_INDICATOR
236: )
237: VALUES (
238: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCOUNTS_S.NEXTVAL, NULL, HZ_CUST_ACCOUNTS_S.NEXTVAL, X_CUST_ACCOUNT_ID ),
239: DECODE( X_ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), NULL, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), X_ACCOUNT_NUMBER ),
240: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
241: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
242: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 292: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCOUNT_ID,HZ_CUST_ACCOUNTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCOUNT_ID,HZ_CUST_ACCOUNTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

288: DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
289: DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
290: DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
291: DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
292: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCOUNT_ID,HZ_CUST_ACCOUNTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCOUNT_ID,HZ_CUST_ACCOUNTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
293: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
294: DECODE( X_CUSTOMER_TYPE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_TYPE ),
295: DECODE( X_CUSTOMER_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CLASS_CODE ),
296: DECODE( X_SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, X_SALES_CHANNEL_CODE ),

Line 353: IF INSTRB( SQLERRM, 'HZ_CUST_ACCOUNTS_U1' ) <> 0 OR

349: l_success := 'Y';
350:
351: EXCEPTION
352: WHEN DUP_VAL_ON_INDEX THEN
353: IF INSTRB( SQLERRM, 'HZ_CUST_ACCOUNTS_U1' ) <> 0 OR
354: INSTRB( SQLERRM, 'HZ_CUST_ACCOUNTS_PK' ) <> 0
355: THEN
356: DECLARE
357: l_count NUMBER;

Line 354: INSTRB( SQLERRM, 'HZ_CUST_ACCOUNTS_PK' ) <> 0

350:
351: EXCEPTION
352: WHEN DUP_VAL_ON_INDEX THEN
353: IF INSTRB( SQLERRM, 'HZ_CUST_ACCOUNTS_U1' ) <> 0 OR
354: INSTRB( SQLERRM, 'HZ_CUST_ACCOUNTS_PK' ) <> 0
355: THEN
356: DECLARE
357: l_count NUMBER;
358: l_dummy VARCHAR2(1);

Line 362: SELECT HZ_CUST_ACCOUNTS_S.NEXTVAL

358: l_dummy VARCHAR2(1);
359: BEGIN
360: l_count := 1;
361: WHILE l_count > 0 LOOP
362: SELECT HZ_CUST_ACCOUNTS_S.NEXTVAL
363: INTO X_CUST_ACCOUNT_ID FROM dual;
364: BEGIN
365: SELECT 'Y' INTO l_dummy
366: FROM HZ_CUST_ACCOUNTS

Line 366: FROM HZ_CUST_ACCOUNTS

362: SELECT HZ_CUST_ACCOUNTS_S.NEXTVAL
363: INTO X_CUST_ACCOUNT_ID FROM dual;
364: BEGIN
365: SELECT 'Y' INTO l_dummy
366: FROM HZ_CUST_ACCOUNTS
367: WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID;
368: l_count := 1;
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN

Line 375: ELSIF INSTRB( SQLERRM, 'HZ_CUST_ACCOUNTS_U2' ) <> 0 THEN

371: l_count := 0;
372: END;
373: END LOOP;
374: END;
375: ELSIF INSTRB( SQLERRM, 'HZ_CUST_ACCOUNTS_U2' ) <> 0 THEN
376: DECLARE
377: l_count NUMBER;
378: l_dummy VARCHAR2(1);
379: l_profile VARCHAR2(1);

Line 400: FROM HZ_CUST_ACCOUNTS

396: SELECT TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL )
397: INTO X_ACCOUNT_NUMBER FROM dual;
398: BEGIN
399: SELECT 'Y' INTO l_dummy
400: FROM HZ_CUST_ACCOUNTS
401: WHERE ACCOUNT_NUMBER = X_ACCOUNT_NUMBER;
402: l_count := 1;
403: EXCEPTION
404: WHEN NO_DATA_FOUND THEN

Line 539: UPDATE HZ_CUST_ACCOUNTS SET

535: ||' AdvPmntInd : '|| X_ADVANCE_PAYMENT_INDICATOR,
536: p_prefix=>l_debug_prefix,
537: p_msg_level=>fnd_log.level_procedure);
538: END IF;
539: UPDATE HZ_CUST_ACCOUNTS SET
540: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
541: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
542: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
543: ACCOUNT_NUMBER = DECODE( X_ACCOUNT_NUMBER, NULL, ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_ACCOUNT_NUMBER ),

Line 772: SELECT * FROM HZ_CUST_ACCOUNTS

768: X_ADVANCE_PAYMENT_INDICATOR IN VARCHAR2
769: ) IS
770:
771: CURSOR C IS
772: SELECT * FROM HZ_CUST_ACCOUNTS
773: WHERE ROWID = x_Rowid
774: FOR UPDATE NOWAIT;
775: Recinfo C%ROWTYPE;
776:

Line 1423: FROM HZ_CUST_ACCOUNTS

1419: X_FEDERAL_ENTITY_TYPE,
1420: X_TRADING_PARTNER_AGENCY_ID,
1421: X_DUNS_EXTENSION,
1422: X_ADVANCE_PAYMENT_INDICATOR
1423: FROM HZ_CUST_ACCOUNTS
1424: WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID;
1425:
1426: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1427: hz_utility_v2pub.debug(p_message=>'FV Attributes at Tab Handler select_row API'

Line 1452: DELETE FROM HZ_CUST_ACCOUNTS

1448: ) IS
1449:
1450: BEGIN
1451:
1452: DELETE FROM HZ_CUST_ACCOUNTS
1453: WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID;
1454:
1455: IF ( SQL%NOTFOUND ) THEN
1456: RAISE NO_DATA_FOUND;

Line 1461: END HZ_CUST_ACCOUNTS_PKG;

1457: END IF;
1458:
1459: END Delete_Row;
1460:
1461: END HZ_CUST_ACCOUNTS_PKG;