APPS.CN_JOB_TITLE_PKG dependencies on CN_JOB_ROLES_S

Line 8: SELECT cn_job_roles_s.nextval

4: PROCEDURE Insert_Row(newrec IN OUT
5: CN_JOB_TITLE_PVT.JOB_ROLE_REC_TYPE) IS
6: BEGIN
7: -- get the next pk from sequence
8: SELECT cn_job_roles_s.nextval
9: INTO newrec.job_role_id
10: FROM dual;
11:
12: INSERT into cn_job_roles

Line 84: update cn_job_roles set

80: open c;
81: fetch c into oldrec;
82: close c;
83:
84: update cn_job_roles set
85: job_title_id = decode(newrec.job_title_id, fnd_api.g_miss_num,
86: oldrec.job_title_id,
87: newrec.job_title_id),
88: role_id = decode(newrec.role_id, fnd_api.g_miss_char,