DBA Data[Home] [Help]

APPS.CN_SECURITY_PROFILES_PKG dependencies on DUAL

Line 20: FROM dual;

16: PROCEDURE get_security_profile_id(x_security_profile_id IN OUT NUMBER) IS
17: BEGIN
18: SELECT cn_security_profiles_s.NEXTVAL
19: INTO x_security_profile_id
20: FROM dual;
21: END get_security_profile_id;
22:
23: PROCEDURE Insert_Row( x_new_rec IN OUT security_profiles_rec_type) IS
24: CURSOR c IS

Line 120: FROM dual;

116: x_new_rec.creation_date,
117: x_new_rec.last_update_login,
118: x_new_rec.last_update_date,
119: x_new_rec.last_updated_by
120: FROM dual;
121:
122: INSERT INTO cn_security_profiles
123: (security_profile_id,
124: profile_user_id,

Line 285: FROM dual;

281: rec.attribute15,
282: rec.last_update_login,
283: rec.last_update_date,
284: rec.last_updated_by
285: FROM dual;
286:
287: UPDATE cn_security_profiles SET
288: profile_user_id = rec.profile_user_id,
289: attribute_category = rec.attribute_category,