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_SLS_BUS dependencies on PER_SOLUTION_SETS

Line 31: -- per_solution_sets and PER_BUSINESS_GROUPS

27: --
28: -- Declare cursor
29: --
30: -- EDIT_HERE In the following cursor statement add join(s) between
31: -- per_solution_sets and PER_BUSINESS_GROUPS
32: -- so that the security_group_id for
33: -- the current business group context can be derived.
34: -- Remove this comment when the edit has been completed.
35: cursor csr_sec_grp is

Line 38: , per_solution_sets sls

34: -- Remove this comment when the edit has been completed.
35: cursor csr_sec_grp is
36: select pbg.security_group_id
37: from per_business_groups pbg
38: , per_solution_sets sls
39: -- , EDIT_HERE table_name(s) 333
40: where sls.solution_set_name = p_solution_set_name
41: and sls.user_id = p_user_id;
42: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 110: -- per_solution_sets and PER_BUSINESS_GROUPS

106: --
107: -- Declare cursor
108: --
109: -- EDIT_HERE In the following cursor statement add join(s) between
110: -- per_solution_sets and PER_BUSINESS_GROUPS
111: -- so that the legislation_code for
112: -- the current business group context can be derived.
113: -- Remove this comment when the edit has been completed.
114: cursor csr_leg_code is

Line 117: , per_solution_sets sls

113: -- Remove this comment when the edit has been completed.
114: cursor csr_leg_code is
115: select pbg.legislation_code
116: from per_business_groups pbg
117: , per_solution_sets sls
118: -- , EDIT_HERE table_name(s) 333
119: where sls.solution_set_name = p_solution_set_name
120: and sls.user_id = p_user_id;
121: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 280: (p_solution_set_name in per_solution_sets.solution_set_name%TYPE

276: -- Access Status:
277: -- Internal Table Handler Use Only.
278: --
279: procedure chk_status
280: (p_solution_set_name in per_solution_sets.solution_set_name%TYPE
281: ,p_user_id in per_solution_sets.user_id%TYPE
282: ,p_status in per_solution_sets.status%TYPE
283: ,p_effective_date in date
284: ,p_object_version_number in per_solution_sets.object_version_number%TYPE

Line 281: ,p_user_id in per_solution_sets.user_id%TYPE

277: -- Internal Table Handler Use Only.
278: --
279: procedure chk_status
280: (p_solution_set_name in per_solution_sets.solution_set_name%TYPE
281: ,p_user_id in per_solution_sets.user_id%TYPE
282: ,p_status in per_solution_sets.status%TYPE
283: ,p_effective_date in date
284: ,p_object_version_number in per_solution_sets.object_version_number%TYPE
285: )

Line 282: ,p_status in per_solution_sets.status%TYPE

278: --
279: procedure chk_status
280: (p_solution_set_name in per_solution_sets.solution_set_name%TYPE
281: ,p_user_id in per_solution_sets.user_id%TYPE
282: ,p_status in per_solution_sets.status%TYPE
283: ,p_effective_date in date
284: ,p_object_version_number in per_solution_sets.object_version_number%TYPE
285: )
286: is

Line 284: ,p_object_version_number in per_solution_sets.object_version_number%TYPE

280: (p_solution_set_name in per_solution_sets.solution_set_name%TYPE
281: ,p_user_id in per_solution_sets.user_id%TYPE
282: ,p_status in per_solution_sets.status%TYPE
283: ,p_effective_date in date
284: ,p_object_version_number in per_solution_sets.object_version_number%TYPE
285: )
286: is
287: --
288: l_exists varchar2(1);