APPS.JTF_PERZ_PROFILE_PVT dependencies on JTF_PERZ_PROFILE_S

Line 77: CURSOR C2 IS SELECT JTF_PERZ_PROFILE_S.NEXTVAL FROM SYS.DUAL;

73:
74: CURSOR C IS SELECT rowid FROM JTF_PERZ_PROFILE
75: WHERE PROFILE_ID = x_PROFILE_ID;
76:
77: CURSOR C2 IS SELECT JTF_PERZ_PROFILE_S.NEXTVAL FROM SYS.DUAL;
78:
79: BEGIN
80:
81: IF (X_PROFILE_ID IS NULL) OR ( X_PROFILE_ID = FND_API.G_MISS_NUM) THEN

Line 133: UPDATE JTF_PERZ_PROFILE SET

129: l_object_version_number NUMBER := p_OBJECT_VERSION_NUMBER;
130:
131: BEGIN
132:
133: UPDATE JTF_PERZ_PROFILE SET
134: PROFILE_NAME = decode( x_PROFILE_NAME, FND_API.G_MISS_CHAR, PROFILE_NAME, x_PROFILE_NAME ),
135: PROFILE_TYPE = decode( x_PROFILE_TYPE, FND_API.G_MISS_CHAR, PROFILE_TYPE, x_PROFILE_TYPE ),
136: PROFILE_DESCRIPTION = decode( x_PROFILE_DESCRIPTION, FND_API.G_MISS_CHAR,
137: PROFILE_DESCRIPTION,x_PROFILE_DESCRIPTION ),