APPS.HZ_CUST_PROF_CLASS_AMTS_PKG dependencies on HZ_CUST_PROF_CLASS_AMTS_S

Line 185: DECODE( X_PROFILE_CLASS_AMOUNT_ID, FND_API.G_MISS_NUM, HZ_CUST_PROF_CLASS_AMTS_S.NEXTVAL, NULL, HZ_CUST_PROF_CLASS_AMTS_S.NEXTVAL, X_PROFILE_CLASS_AMOUNT_ID ),

181: PENALTY_FIXED_AMOUNT,
182: PENALTY_SCHEDULE_ID
183: )
184: VALUES (
185: DECODE( X_PROFILE_CLASS_AMOUNT_ID, FND_API.G_MISS_NUM, HZ_CUST_PROF_CLASS_AMTS_S.NEXTVAL, NULL, HZ_CUST_PROF_CLASS_AMTS_S.NEXTVAL, X_PROFILE_CLASS_AMOUNT_ID ),
186: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
188: HZ_UTILITY_V2PUB.CREATED_BY,
189: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 292: SELECT HZ_CUST_PROF_CLASS_AMTS_S.NEXTVAL

288: l_dummy VARCHAR2(1);
289: BEGIN
290: l_count := 1;
291: WHILE l_count > 0 LOOP
292: SELECT HZ_CUST_PROF_CLASS_AMTS_S.NEXTVAL
293: INTO X_PROFILE_CLASS_AMOUNT_ID FROM dual;
294: BEGIN
295: SELECT 'Y' INTO l_dummy
296: FROM HZ_CUST_PROF_CLASS_AMTS

Line 400: UPDATE HZ_CUST_PROF_CLASS_AMTS SET

396: ) IS
397:
398: BEGIN
399:
400: UPDATE HZ_CUST_PROF_CLASS_AMTS SET
401: PROFILE_CLASS_AMOUNT_ID = DECODE( X_PROFILE_CLASS_AMOUNT_ID, NULL, PROFILE_CLASS_AMOUNT_ID, FND_API.G_MISS_NUM, NULL, X_PROFILE_CLASS_AMOUNT_ID ),
402: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
403: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
404: CREATED_BY = CREATED_BY,