APPS.CN_JOB_TITLE_PVT dependencies on CN_JOB_TITLES

Line 4: (job_title_id cn_job_titles.job_title_id%type,

1: PACKAGE cn_job_title_pvt AUTHID CURRENT_USER AS
2: --$Header: cnvjobs.pls 115.5 2002/11/21 21:14:11 hlchen ship $
3: TYPE job_title_rec_type IS record
4: (job_title_id cn_job_titles.job_title_id%type,
5: name cn_job_titles.name%type,
6: job_code cn_job_titles.job_code%type,
7: role_id cn_roles.role_id%type,
8: role_name cn_roles.name%type);

Line 5: name cn_job_titles.name%type,

1: PACKAGE cn_job_title_pvt AUTHID CURRENT_USER AS
2: --$Header: cnvjobs.pls 115.5 2002/11/21 21:14:11 hlchen ship $
3: TYPE job_title_rec_type IS record
4: (job_title_id cn_job_titles.job_title_id%type,
5: name cn_job_titles.name%type,
6: job_code cn_job_titles.job_code%type,
7: role_id cn_roles.role_id%type,
8: role_name cn_roles.name%type);
9:

Line 6: job_code cn_job_titles.job_code%type,

2: --$Header: cnvjobs.pls 115.5 2002/11/21 21:14:11 hlchen ship $
3: TYPE job_title_rec_type IS record
4: (job_title_id cn_job_titles.job_title_id%type,
5: name cn_job_titles.name%type,
6: job_code cn_job_titles.job_code%type,
7: role_id cn_roles.role_id%type,
8: role_name cn_roles.name%type);
9:
10: TYPE job_title_tbl_type IS table OF job_title_rec_type

Line 114: (p_job_title_id IN cn_job_titles.job_title_id%type,

110: --
111: -- End of comments
112:
113: PROCEDURE Get_Job_Details
114: (p_job_title_id IN cn_job_titles.job_title_id%type,
115: x_result_tbl OUT NOCOPY job_role_tbl_type);
116:
117: -- Start of comments
118: -- API name : Get_Job_Titles - Private