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.PER_RSL_BUS dependencies on PER_RATING_SCALES

Line 35: -- per_rating_scales_tl and PER_BUSINESS_GROUPS

31: -- Name : M. Burton
32: -- Date 02-DEC-2002
33: -- Description Amended to add MLS functionality
34: -- In the following cursor statement add join(s) between
35: -- per_rating_scales_tl and PER_BUSINESS_GROUPS
36: -- so that the security_group_id for
37: -- the current business group context can be derived.
38: cursor csr_sec_grp is
39: select pbg.security_group_id

Line 41: , per_rating_scales_tl rsl_tl

37: -- the current business group context can be derived.
38: cursor csr_sec_grp is
39: select pbg.security_group_id
40: from per_business_groups pbg
41: , per_rating_scales_tl rsl_tl
42: , per_rating_scales rsl
43: where rsl.rating_scale_id = p_rating_scale_id
44: and rsl.rating_scale_id = rsl_tl.rating_scale_id
45: and pbg.business_group_id = rsl.business_group_id;

Line 42: , per_rating_scales rsl

38: cursor csr_sec_grp is
39: select pbg.security_group_id
40: from per_business_groups pbg
41: , per_rating_scales_tl rsl_tl
42: , per_rating_scales rsl
43: where rsl.rating_scale_id = p_rating_scale_id
44: and rsl.rating_scale_id = rsl_tl.rating_scale_id
45: and pbg.business_group_id = rsl.business_group_id;
46: --

Line 109: -- per_rating_scales_tl and PER_BUSINESS_GROUPS

105: -- Date 29-NOV-2002
106: -- Declare cursor
107: --
108: -- In the following cursor statement add join(s) between
109: -- per_rating_scales_tl and PER_BUSINESS_GROUPS
110: -- so that the legislation_code for
111: -- the current business group context can be derived.
112:
113: cursor csr_leg_code is

Line 116: , per_rating_scales_tl rsl_tl

112:
113: cursor csr_leg_code is
114: select pbg.legislation_code
115: from per_business_groups pbg
116: , per_rating_scales_tl rsl_tl
117: , per_rating_scales rsl
118: where
119: rsl.rating_scale_id = p_rating_scale_id
120: and rsl_tl.language = p_language

Line 117: , per_rating_scales rsl

113: cursor csr_leg_code is
114: select pbg.legislation_code
115: from per_business_groups pbg
116: , per_rating_scales_tl rsl_tl
117: , per_rating_scales rsl
118: where
119: rsl.rating_scale_id = p_rating_scale_id
120: and rsl_tl.language = p_language
121: and pbg.business_group_id = rsl.business_group_id

Line 268: (p_rating_scale_id in per_rating_scales_tl.rating_scale_id%TYPE

264: --
265: --
266:
267: procedure chk_name
268: (p_rating_scale_id in per_rating_scales_tl.rating_scale_id%TYPE
269: ,p_language in per_rating_scales_tl.language%TYPE
270: ,p_business_group_id in per_rating_scales.business_group_id%TYPE
271: ,p_name in per_rating_scales_tl.name%TYPE
272: )

Line 269: ,p_language in per_rating_scales_tl.language%TYPE

265: --
266:
267: procedure chk_name
268: (p_rating_scale_id in per_rating_scales_tl.rating_scale_id%TYPE
269: ,p_language in per_rating_scales_tl.language%TYPE
270: ,p_business_group_id in per_rating_scales.business_group_id%TYPE
271: ,p_name in per_rating_scales_tl.name%TYPE
272: )
273: is

Line 270: ,p_business_group_id in per_rating_scales.business_group_id%TYPE

266:
267: procedure chk_name
268: (p_rating_scale_id in per_rating_scales_tl.rating_scale_id%TYPE
269: ,p_language in per_rating_scales_tl.language%TYPE
270: ,p_business_group_id in per_rating_scales.business_group_id%TYPE
271: ,p_name in per_rating_scales_tl.name%TYPE
272: )
273: is
274: --

Line 271: ,p_name in per_rating_scales_tl.name%TYPE

267: procedure chk_name
268: (p_rating_scale_id in per_rating_scales_tl.rating_scale_id%TYPE
269: ,p_language in per_rating_scales_tl.language%TYPE
270: ,p_business_group_id in per_rating_scales.business_group_id%TYPE
271: ,p_name in per_rating_scales_tl.name%TYPE
272: )
273: is
274: --
275: l_exists per_rating_scales.business_group_id%TYPE;

Line 275: l_exists per_rating_scales.business_group_id%TYPE;

271: ,p_name in per_rating_scales_tl.name%TYPE
272: )
273: is
274: --
275: l_exists per_rating_scales.business_group_id%TYPE;
276: l_api_updating boolean;
277: l_proc varchar2(72) := g_package||'chk_name';
278: l_business_group_id number(15);
279: --

Line 284: from per_rating_scales rsc

280: --
281: -- Cursor to check name is unique within business group
282: cursor csr_name_exists is
283: select rsc.business_group_id
284: from per_rating_scales rsc
285: , per_rating_scales_tl rsl
286: where rsc.rating_scale_id = rsl.rating_scale_id
287: and rsl.language = p_language
288: and ( (p_rating_scale_id is null)

Line 285: , per_rating_scales_tl rsl

281: -- Cursor to check name is unique within business group
282: cursor csr_name_exists is
283: select rsc.business_group_id
284: from per_rating_scales rsc
285: , per_rating_scales_tl rsl
286: where rsc.rating_scale_id = rsl.rating_scale_id
287: and rsl.language = p_language
288: and ( (p_rating_scale_id is null)
289: or(rsc.rating_scale_id <> p_rating_scale_id)

Line 295: from per_rating_scales rsc

291: and rsl.name = p_name
292: and p_business_group_id is null
293: UNION
294: select rsc.business_group_id
295: from per_rating_scales rsc
296: , per_rating_scales_tl rsl
297: where rsc.rating_scale_id = rsl.rating_scale_id
298: and rsl.language = p_language
299: and ( (p_rating_scale_id is null)

Line 296: , per_rating_scales_tl rsl

292: and p_business_group_id is null
293: UNION
294: select rsc.business_group_id
295: from per_rating_scales rsc
296: , per_rating_scales_tl rsl
297: where rsc.rating_scale_id = rsl.rating_scale_id
298: and rsl.language = p_language
299: and ( (p_rating_scale_id is null)
300: or(rsc.rating_scale_id <> p_rating_scale_id)

Line 363: ,p_rating_scale_id in per_rating_scales_tl.rating_scale_id%TYPE default null

359: -- |------------------------< validate_translation>--------------------------|
360: -- ----------------------------------------------------------------------------
361: Procedure validate_translation
362: (p_rec in per_rsl_shd.g_rec_type
363: ,p_rating_scale_id in per_rating_scales_tl.rating_scale_id%TYPE default null
364: ) IS
365: --
366: l_proc varchar2(72) := g_package||'validate_translation';
367: --

Line 372: from per_rating_scales rsc

368: -- Declare cursor
369: --
370: cursor csr_rating_scale is
371: select rsc.business_group_id
372: from per_rating_scales rsc
373: where rsc.rating_scale_id = nvl(p_rec.rating_scale_id, p_rating_scale_id);
374: --
375: l_rsc_rec csr_rating_scale%ROWTYPE;
376: --

Line 401: ,p_rating_scale_id in per_rating_scales_tl.rating_scale_id%TYPE

397: -- |---------------------------< insert_validate >----------------------------|
398: -- ----------------------------------------------------------------------------
399: Procedure insert_validate
400: (p_rec in per_rsl_shd.g_rec_type
401: ,p_rating_scale_id in per_rating_scales_tl.rating_scale_id%TYPE
402: ) is
403: --
404: -- Name : M. Burton
405: -- Date 02-DEC-2002