eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_JOB_TITLE_PVT dependencies on CN_JOB_ROLES

Line 6: PROCEDURE valid_no_srp(p_job_role_id IN cn_job_roles.job_role_id%type) IS

2: --$Header: cnvjobb.pls 115.14.115100.3 2004/05/11 01:32:51 sbadami noship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CN_JOB_TITLE_PVT';
5:
6: PROCEDURE valid_no_srp(p_job_role_id IN cn_job_roles.job_role_id%type) IS
7: l_count NUMBER;
8: BEGIN
9: -- make sure the job title and role involved in this record is
10: -- not being used by any salesrep.

Line 14: FROM cn_job_roles jr

10: -- not being used by any salesrep.
11: BEGIN
12: SELECT 1
13: INTO l_count
14: FROM cn_job_roles jr
15: WHERE jr.job_role_id = p_job_role_id
16: AND EXISTS (
17: SELECT 1
18: FROM cn_srp_role_dtls_v sr

Line 47: from cn_job_roles jr,

43: -- assigned to an srp for this job_role assignment
44: SELECT COUNT(sj.srp_id), min(sj.start_date),
45: MAX(sj.end_date)
46: into l_count,l_min_start_date , l_max_end_date
47: from cn_job_roles jr,
48: cn_srp_job_titles sj,
49: cn_srp_roles sr
50: where jr.job_role_id = p_rec.job_role_id
51: and jr.job_title_id = sj.job_title_id

Line 95: x_job_role_id OUT NOCOPY cn_job_roles.job_role_id%type) IS

91: p_rec IN job_role_rec_type,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,
95: x_job_role_id OUT NOCOPY cn_job_roles.job_role_id%type) IS
96:
97: l_api_name CONSTANT VARCHAR2(30) := 'Create_Job_Role';
98: l_api_version CONSTANT NUMBER := 1.0;
99: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');

Line 135: from cn_job_roles

131:
132:
133: --
134: select count(job_role_id) into l_count
135: from cn_job_roles
136: where job_title_id = l_newrec.job_title_id
137: and default_flag = 'Y'
138: and ((start_date <= l_newrec.start_date and
139: nvl(end_date, l_null_date) >=

Line 151: from cn_job_roles

147: RAISE FND_API.G_EXC_ERROR;
148: end if;
149:
150: select count(job_role_id) into l_count
151: from cn_job_roles
152: where job_title_id = l_newrec.job_title_id
153: and role_id = l_newrec.role_id
154: and ((start_date <= l_newrec.start_date and
155: nvl(end_date, l_null_date) >=

Line 167: from cn_job_roles

163: RAISE FND_API.G_EXC_ERROR;
164: end if;
165:
166: select count(1) into l_count
167: from cn_job_roles
168: where role_id = l_newrec.role_id
169: and job_title_id = l_newrec.job_title_id
170: and trunc(start_date) = trunc(l_newrec.start_date)
171: ;

Line 278: from cn_job_roles

274: -- if default, make sure it doesn't overlap with another default
275:
276: -- make sure record to be updated exists.
277: select count(*) into l_count
278: from cn_job_roles
279: where job_role_id = l_newrec.job_role_id;
280:
281: if l_count = 0 then
282: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_UPDATE_REC');

Line 299: from cn_job_roles

295: -- make sure it is not being used by any salesrep if we are narrowing
296: -- the assignment interval
297: select start_date, end_date
298: into l_old_start, l_old_end
299: from cn_job_roles
300: where job_role_id = l_newrec.job_role_id;
301:
302: if l_old_start < l_newrec.start_date OR
303: nvl(l_old_end, to_date('12-31-9999','MM-DD-YYYY')) >

Line 309: from cn_job_roles

305: verify_date(l_newrec);
306: end if;
307:
308: select count(job_role_id) into l_count
309: from cn_job_roles
310: where job_title_id = l_newrec.job_title_id
311: and job_role_id <> l_newrec.job_role_id
312: and default_flag = 'Y'
313: and ((start_date <= l_newrec.start_date and

Line 324: from cn_job_roles

320: RAISE FND_API.G_EXC_ERROR;
321: end if;
322:
323: select count(job_role_id) into l_count
324: from cn_job_roles
325: where job_title_id = l_newrec.job_title_id
326: and job_role_id <> l_newrec.job_role_id
327: and role_id = l_newrec.role_id
328: and ((start_date <= l_newrec.start_date and

Line 397: p_job_role_id IN cn_job_roles.job_role_id%type,

393: (p_api_version IN NUMBER,
394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
395: p_commit IN VARCHAR2 := FND_API.G_FALSE,
396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
397: p_job_role_id IN cn_job_roles.job_role_id%type,
398: p_object_version_number IN cn_job_roles.object_version_number%type,
399: x_return_status OUT NOCOPY VARCHAR2,
400: x_msg_count OUT NOCOPY NUMBER,
401: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 398: p_object_version_number IN cn_job_roles.object_version_number%type,

394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
395: p_commit IN VARCHAR2 := FND_API.G_FALSE,
396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
397: p_job_role_id IN cn_job_roles.job_role_id%type,
398: p_object_version_number IN cn_job_roles.object_version_number%type,
399: x_return_status OUT NOCOPY VARCHAR2,
400: x_msg_count OUT NOCOPY NUMBER,
401: x_msg_data OUT NOCOPY VARCHAR2) IS
402:

Line 427: from cn_job_roles

423: x_return_status := FND_API.G_RET_STS_SUCCESS;
424:
425: -- make sure record to be deleted exists.
426: select count(*) into l_count
427: from cn_job_roles
428: where job_role_id = p_job_role_id;
429:
430: if l_count = 0 then
431: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_DEL_REC');

Line 500: from cn_job_roles

496: attribute1, attribute2, attribute3, attribute4, attribute5,
497: attribute6, attribute7, attribute8, attribute9, attribute10,
498: attribute11, attribute12, attribute13, attribute14, attribute15,
499: object_version_number
500: from cn_job_roles
501: where job_title_id = p_job_title_id
502: order by start_date;
503:
504: BEGIN

Line 608: from cn_job_roles jr,

604: j.name job_name,
605: j.job_code,
606: jr.role_id,
607: r.role_name
608: from cn_job_roles jr,
609: cn_job_titles j,
610: jtf_rs_roles_vl r
611: where jr.job_title_id = j.job_title_id
612: and r.role_type_code= 'SALES_COMP'