DBA Data[Home] [Help]

APPS.HZ_EDUCATION_PKG dependencies on HZ_EDUCATION_S

Line 52: decode( x_EDUCATION_ID, FND_API.G_MISS_NUM, HZ_EDUCATION_S.NEXTVAL, NULL, HZ_EDUCATION_S.NEXTVAL, X_EDUCATION_ID ),

48: CREATED_BY_MODULE,
49: APPLICATION_ID
50:
51: ) VALUES (
52: decode( x_EDUCATION_ID, FND_API.G_MISS_NUM, HZ_EDUCATION_S.NEXTVAL, NULL, HZ_EDUCATION_S.NEXTVAL, X_EDUCATION_ID ),
53: decode( x_COURSE_MAJOR, FND_API.G_MISS_CHAR, NULL,x_COURSE_MAJOR),
54: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
55: decode( x_SCHOOL_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_SCHOOL_PARTY_ID),
56: decode( x_DEGREE_RECEIVED, FND_API.G_MISS_CHAR, NULL,x_DEGREE_RECEIVED),

Line 94: SELECT HZ_EDUCATION_S.NEXTVAL

90: l_dummy VARCHAR2(1);
91: BEGIN
92: l_count := 1;
93: WHILE l_count > 0 LOOP
94: SELECT HZ_EDUCATION_S.NEXTVAL
95: INTO X_EDUCATION_ID FROM dual;
96: BEGIN
97: SELECT 'Y' INTO l_dummy
98: FROM HZ_EDUCATION