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_STC_BUS dependencies on PER_SOLUTION_TYPE_CMPTS

Line 32: -- per_solution_type_cmpts and PER_BUSINESS_GROUPS

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

Line 39: , per_solution_type_cmpts stc

35: -- Remove this comment when the edit has been completed.
36: cursor csr_sec_grp is
37: select pbg.security_group_id
38: from per_business_groups pbg
39: , per_solution_type_cmpts stc
40: -- , EDIT_HERE table_name(s) 333
41: where stc.component_name = p_component_name
42: and stc.solution_type_name = p_solution_type_name;
43: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 119: from per_solution_type_cmpts stc

115: -- Declare cursor
116: --
117: cursor csr_leg_code is
118: select stc.legislation_code
119: from per_solution_type_cmpts stc
120: where stc.component_name = p_component_name
121: and stc.solution_type_name = p_solution_type_name;
122: --
123: -- Declare local variables

Line 278: (p_component_name in per_solution_type_cmpts.component_name%TYPE

274: -- Access Status:
275: -- Internal Table Handler Use Only.
276: --
277: procedure chk_updateable
278: (p_component_name in per_solution_type_cmpts.component_name%TYPE
279: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
280: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
281: ,p_updateable in per_solution_type_cmpts.updateable%TYPE
282: ,p_effective_date in date

Line 279: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE

275: -- Internal Table Handler Use Only.
276: --
277: procedure chk_updateable
278: (p_component_name in per_solution_type_cmpts.component_name%TYPE
279: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
280: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
281: ,p_updateable in per_solution_type_cmpts.updateable%TYPE
282: ,p_effective_date in date
283: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE

Line 280: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE

276: --
277: procedure chk_updateable
278: (p_component_name in per_solution_type_cmpts.component_name%TYPE
279: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
280: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
281: ,p_updateable in per_solution_type_cmpts.updateable%TYPE
282: ,p_effective_date in date
283: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
284: )

Line 281: ,p_updateable in per_solution_type_cmpts.updateable%TYPE

277: procedure chk_updateable
278: (p_component_name in per_solution_type_cmpts.component_name%TYPE
279: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
280: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
281: ,p_updateable in per_solution_type_cmpts.updateable%TYPE
282: ,p_effective_date in date
283: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
284: )
285: is

Line 283: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE

279: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
280: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
281: ,p_updateable in per_solution_type_cmpts.updateable%TYPE
282: ,p_effective_date in date
283: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
284: )
285: is
286: --
287: l_exists varchar2(1);

Line 390: (p_component_name in per_solution_type_cmpts.component_name%TYPE

386: -- Access Status:
387: -- Internal Table Handler Use Only.
388: --
389: procedure chk_extensible
390: (p_component_name in per_solution_type_cmpts.component_name%TYPE
391: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
392: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
393: ,p_extensible in per_solution_type_cmpts.extensible%TYPE
394: ,p_effective_date in date

Line 391: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE

387: -- Internal Table Handler Use Only.
388: --
389: procedure chk_extensible
390: (p_component_name in per_solution_type_cmpts.component_name%TYPE
391: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
392: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
393: ,p_extensible in per_solution_type_cmpts.extensible%TYPE
394: ,p_effective_date in date
395: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE

Line 392: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE

388: --
389: procedure chk_extensible
390: (p_component_name in per_solution_type_cmpts.component_name%TYPE
391: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
392: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
393: ,p_extensible in per_solution_type_cmpts.extensible%TYPE
394: ,p_effective_date in date
395: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
396: )

Line 393: ,p_extensible in per_solution_type_cmpts.extensible%TYPE

389: procedure chk_extensible
390: (p_component_name in per_solution_type_cmpts.component_name%TYPE
391: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
392: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
393: ,p_extensible in per_solution_type_cmpts.extensible%TYPE
394: ,p_effective_date in date
395: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
396: )
397: is

Line 395: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE

391: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
392: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
393: ,p_extensible in per_solution_type_cmpts.extensible%TYPE
394: ,p_effective_date in date
395: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
396: )
397: is
398: --
399: l_exists varchar2(1);