DBA Data[Home] [Help]

APPS.CN_JOB_TITLE_PKG dependencies on CN_JOB_TITLE_PVT

Line 5: CN_JOB_TITLE_PVT.JOB_ROLE_REC_TYPE) IS

1: PACKAGE BODY CN_JOB_TITLE_PKG AS
2: /*$Header: cntjobb.pls 115.4 2002/11/21 21:09:45 hlchen ship $*/
3:
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

Line 73: CN_JOB_TITLE_PVT.JOB_ROLE_REC_TYPE) IS

69: 1);
70: END Insert_Row;
71:
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;