DBA Data[Home] [Help]

APPS.HZ_CREDIT_RATINGS_PKG dependencies on HZ_CREDIT_RATINGS_S

Line 229: FND_API.G_MISS_NUM, HZ_CREDIT_RATINGS_S.NEXTVAL,

225: actual_content_source
226: )
227: VALUES (
228: DECODE(x_credit_rating_id,
229: FND_API.G_MISS_NUM, HZ_CREDIT_RATINGS_S.NEXTVAL,
230: NULL, HZ_CREDIT_RATINGS_S.NEXTVAL,
231: x_credit_rating_id),
232: DECODE(x_description,
233: FND_API.G_MISS_CHAR, NULL,

Line 230: NULL, HZ_CREDIT_RATINGS_S.NEXTVAL,

226: )
227: VALUES (
228: DECODE(x_credit_rating_id,
229: FND_API.G_MISS_NUM, HZ_CREDIT_RATINGS_S.NEXTVAL,
230: NULL, HZ_CREDIT_RATINGS_S.NEXTVAL,
231: x_credit_rating_id),
232: DECODE(x_description,
233: FND_API.G_MISS_CHAR, NULL,
234: x_description),

Line 559: SELECT HZ_CREDIT_RATINGS_S.NEXTVAL

555: l_dummy VARCHAR2(1);
556: BEGIN
557: l_count := 1;
558: WHILE l_count > 0 LOOP
559: SELECT HZ_CREDIT_RATINGS_S.NEXTVAL
560: INTO x_credit_rating_id FROM dual;
561: BEGIN
562: SELECT 'Y' INTO l_dummy
563: FROM HZ_CREDIT_RATINGS