APPS.CN_JOB_TITLE_PKG dependencies on CN_JOB_ROLES

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 12: INSERT into cn_job_roles

8: SELECT cn_job_roles_s.nextval
9: INTO newrec.job_role_id
10: FROM dual;
11:
12: INSERT into cn_job_roles
13: (job_role_id,
14: job_title_id,
15: role_id,
16: start_date,

Line 76: FROM cn_job_roles

72: PROCEDURE Update_Row(newrec
73: CN_JOB_TITLE_PVT.JOB_ROLE_REC_TYPE) IS
74: CURSOR c IS
75: SELECT *
76: FROM cn_job_roles
77: WHERE job_role_id = newrec.job_role_id;
78: oldrec c%ROWTYPE;
79: BEGIN
80: open c;

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,

Line 161: from cn_job_roles

157: p_object_version_number IN NUMBER) IS
158:
159: cursor c is
160: select object_version_number
161: from cn_job_roles
162: where job_role_id = p_job_role_id
163: for update of job_role_id nowait;
164: tlinfo c%rowtype ;
165: BEGIN

Line 186: DELETE from cn_job_roles

182: END LOCK_ROW;
183:
184: PROCEDURE Delete_Row(p_job_role_id NUMBER) IS
185: BEGIN
186: DELETE from cn_job_roles
187: WHERE job_role_id = p_job_role_id;
188: if (sql%notfound) then
189: raise no_data_found;
190: end if;