APPS.HZ_CUST_PROFILE_AMTS_PKG dependencies on HZ_CUST_PROFILE_AMTS_S

Line 195: DECODE( X_CUST_ACCT_PROFILE_AMT_ID, FND_API.G_MISS_NUM, HZ_CUST_PROFILE_AMTS_S.NEXTVAL, NULL, HZ_CUST_PROFILE_AMTS_S.NEXTVAL, X_CUST_ACCT_PROFILE_AMT_ID ),

191: PENALTY_FIXED_AMOUNT,
192: PENALTY_SCHEDULE_ID
193: )
194: VALUES (
195: DECODE( X_CUST_ACCT_PROFILE_AMT_ID, FND_API.G_MISS_NUM, HZ_CUST_PROFILE_AMTS_S.NEXTVAL, NULL, HZ_CUST_PROFILE_AMTS_S.NEXTVAL, X_CUST_ACCT_PROFILE_AMT_ID ),
196: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
197: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
198: HZ_UTILITY_V2PUB.CREATED_BY,
199: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 307: SELECT HZ_CUST_PROFILE_AMTS_S.NEXTVAL

303: l_dummy VARCHAR2(1);
304: BEGIN
305: l_count := 1;
306: WHILE l_count > 0 LOOP
307: SELECT HZ_CUST_PROFILE_AMTS_S.NEXTVAL
308: INTO X_CUST_ACCT_PROFILE_AMT_ID FROM dual;
309: BEGIN
310: SELECT 'Y' INTO l_dummy
311: FROM HZ_CUST_PROFILE_AMTS

Line 420: UPDATE HZ_CUST_PROFILE_AMTS SET

416: ) IS
417:
418: BEGIN
419:
420: UPDATE HZ_CUST_PROFILE_AMTS SET
421: CUST_ACCT_PROFILE_AMT_ID = DECODE( X_CUST_ACCT_PROFILE_AMT_ID, NULL, CUST_ACCT_PROFILE_AMT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_PROFILE_AMT_ID ),
422: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
423: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
424: CREATED_BY = CREATED_BY,