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_CUSTOMER_PROFILES_PKG dependencies on HZ_CUSTOMER_PROFILES_S

Line 253: DECODE( X_CUST_ACCOUNT_PROFILE_ID, FND_API.G_MISS_NUM, HZ_CUSTOMER_PROFILES_S.NEXTVAL, NULL, HZ_CUSTOMER_PROFILES_S.NEXTVAL, X_CUST_ACCOUNT_PROFILE_ID ),

249: CHARGE_BEGIN_DATE,
250: AUTOMATCH_SET_ID
251: )
252: VALUES (
253: DECODE( X_CUST_ACCOUNT_PROFILE_ID, FND_API.G_MISS_NUM, HZ_CUSTOMER_PROFILES_S.NEXTVAL, NULL, HZ_CUSTOMER_PROFILES_S.NEXTVAL, X_CUST_ACCOUNT_PROFILE_ID ),
254: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
255: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
256: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
257: HZ_UTILITY_V2PUB.CREATED_BY,

Line 397: SELECT HZ_CUSTOMER_PROFILES_S.NEXTVAL

393: l_dummy VARCHAR2(1);
394: BEGIN
395: l_count := 1;
396: WHILE l_count > 0 LOOP
397: SELECT HZ_CUSTOMER_PROFILES_S.NEXTVAL
398: INTO X_CUST_ACCOUNT_PROFILE_ID FROM dual;
399: BEGIN
400: SELECT 'Y' INTO l_dummy
401: FROM HZ_CUSTOMER_PROFILES

Line 547: UPDATE HZ_CUSTOMER_PROFILES SET

543: FROM HZ_CUST_PROFILE_CLASSES
544: WHERE PROFILE_CLASS_ID = X_PROFILE_CLASS_ID;
545: END IF;
546:
547: UPDATE HZ_CUSTOMER_PROFILES SET
548: CUST_ACCOUNT_PROFILE_ID = DECODE( X_CUST_ACCOUNT_PROFILE_ID, NULL, CUST_ACCOUNT_PROFILE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_PROFILE_ID ),
549: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
550: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
551: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,