APPS.JTF_PERZ_PROFILE_PVT dependencies on JTF_PERZ_PROFILE_ATTRIB_S

Line 166: CURSOR C2 IS SELECT jtf_perz_profile_attrib_s.NEXTVAL FROM SYS.DUAL;

162: ) IS
163:
164: CURSOR C IS SELECT rowid FROM jtf_perz_profile_attrib
165: WHERE PROFILE_ID = x_PROFILE_ID AND ROWNUM = 1;
166: CURSOR C2 IS SELECT jtf_perz_profile_attrib_s.NEXTVAL FROM SYS.DUAL;
167:
168: BEGIN
169: IF (X_PROFILE_ATTRIB_ID IS NULL) OR
170: (X_PROFILE_ATTRIB_ID = FND_API.G_MISS_NUM) THEN

Line 215: UPDATE jtf_perz_profile_attrib SET

211: ) IS
212:
213: BEGIN
214:
215: UPDATE jtf_perz_profile_attrib SET
216: ATTRIBUTE_TYPE = decode( x_ATTRIBUTE_TYPE, FND_API.G_MISS_CHAR,
217: ATTRIBUTE_TYPE, x_ATTRIBUTE_TYPE ),
218: ATTRIBUTE_VALUE = decode( x_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR,
219: ATTRIBUTE_VALUE, x_ATTRIBUTE_VALUE ),