DBA Data[Home] [Help]

APPS.CN_SEC_PROF_ASSIGNS_PKG dependencies on DUAL

Line 20: FROM dual;

16: PROCEDURE get_sec_prof_assign_id(x_sec_prof_assign_id IN OUT NUMBER) IS
17: BEGIN
18: SELECT cn_sec_prof_assigns_s.NEXTVAL
19: INTO x_sec_prof_assign_id
20: FROM dual;
21: END get_sec_prof_assign_id;
22:
23: PROCEDURE Insert_Row( x_new_rec IN OUT sec_prof_assign_rec_type) IS
24: CURSOR c IS

Line 124: FROM dual;

120: x_new_rec.creation_date,
121: x_new_rec.last_update_login,
122: x_new_rec.last_update_date,
123: x_new_rec.last_updated_by
124: FROM dual;
125:
126: INSERT INTO cn_sec_prof_assigns
127: (sec_prof_assign_id,
128: security_profile_id,

Line 306: FROM dual;

302: rec.attribute15,
303: rec.last_update_login,
304: rec.last_update_date,
305: rec.last_updated_by
306: FROM dual;
307:
308: UPDATE cn_sec_prof_assigns SET
309: security_profile_id = rec.security_profile_id,
310: salesrep_id = rec.salesrep_id,