APPS.HZ_CUSTOMER_PROFILES_PKG dependencies on HZ_CUSTOMER_PROFILES_S

Line 250: 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 ),

246: MULTIPLE_INTEREST_RATES_FLAG,
247: CHARGE_BEGIN_DATE
248: )
249: VALUES (
250: 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 ),
251: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
252: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
253: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
254: HZ_UTILITY_V2PUB.CREATED_BY,

Line 387: SELECT HZ_CUSTOMER_PROFILES_S.NEXTVAL

383: l_dummy VARCHAR2(1);
384: BEGIN
385: l_count := 1;
386: WHILE l_count > 0 LOOP
387: SELECT HZ_CUSTOMER_PROFILES_S.NEXTVAL
388: INTO X_CUST_ACCOUNT_PROFILE_ID FROM dual;
389: BEGIN
390: SELECT 'Y' INTO l_dummy
391: FROM HZ_CUSTOMER_PROFILES

Line 536: UPDATE HZ_CUSTOMER_PROFILES SET

532: FROM HZ_CUST_PROFILE_CLASSES
533: WHERE PROFILE_CLASS_ID = X_PROFILE_CLASS_ID;
534: END IF;
535:
536: UPDATE HZ_CUSTOMER_PROFILES SET
537: 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 ),
538: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
539: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
540: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,