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_CPA_BUS dependencies on PER_CAGR_API_PARAMETERS

Line 27: -- per_cagr_api_parameters and PER_BUSINESS_GROUPS

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

Line 34: , per_cagr_api_parameters cpa

30: -- Remove this comment when the edit has been completed.
31: cursor csr_sec_grp is
32: select pbg.security_group_id
33: from per_business_groups pbg
34: , per_cagr_api_parameters cpa
35: where cpa.cagr_api_param_id = p_cagr_api_param_id;
36: --
37: -- Declare local variables
38: --

Line 91: -- per_cagr_api_parameters and PER_BUSINESS_GROUPS

87: --
88: -- Declare cursor
89: --
90: -- EDIT_HERE In the following cursor statement add join(s) between
91: -- per_cagr_api_parameters and PER_BUSINESS_GROUPS
92: -- so that the legislation_code for
93: -- the current business group context can be derived.
94: -- Remove this comment when the edit has been completed.
95: cursor csr_leg_code is

Line 98: , per_cagr_api_parameters cpa

94: -- Remove this comment when the edit has been completed.
95: cursor csr_leg_code is
96: select pbg.legislation_code
97: from per_business_groups pbg
98: , per_cagr_api_parameters cpa
99: where cpa.cagr_api_param_id = p_cagr_api_param_id;
100: --
101: -- Declare local variables
102: --

Line 188: (p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE

184: --
185: -- ---------------------------------------------------------------------------
186: --
187: PROCEDURE chk_cagr_api_id
188: (p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE
189: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE) is
190: --
191: l_proc VARCHAR2(72) := g_package||'chk_cagr_api_id';
192: l_dummy NUMBER := NULL;

Line 189: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE) is

185: -- ---------------------------------------------------------------------------
186: --
187: PROCEDURE chk_cagr_api_id
188: (p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE
189: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE) is
190: --
191: l_proc VARCHAR2(72) := g_package||'chk_cagr_api_id';
192: l_dummy NUMBER := NULL;
193: --

Line 275: (p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE

271: --
272: -- ---------------------------------------------------------------------------
273: --
274: PROCEDURE chk_display_name
275: (p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE
276: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
277: ,p_display_name IN per_cagr_api_parameters.display_name%TYPE) IS
278: --
279: CURSOR csr_chk_display_name IS

Line 276: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE

272: -- ---------------------------------------------------------------------------
273: --
274: PROCEDURE chk_display_name
275: (p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE
276: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
277: ,p_display_name IN per_cagr_api_parameters.display_name%TYPE) IS
278: --
279: CURSOR csr_chk_display_name IS
280: SELECT display_name

Line 277: ,p_display_name IN per_cagr_api_parameters.display_name%TYPE) IS

273: --
274: PROCEDURE chk_display_name
275: (p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE
276: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
277: ,p_display_name IN per_cagr_api_parameters.display_name%TYPE) IS
278: --
279: CURSOR csr_chk_display_name IS
280: SELECT display_name
281: FROM per_cagr_api_parameters cpa

Line 281: FROM per_cagr_api_parameters cpa

277: ,p_display_name IN per_cagr_api_parameters.display_name%TYPE) IS
278: --
279: CURSOR csr_chk_display_name IS
280: SELECT display_name
281: FROM per_cagr_api_parameters cpa
282: WHERE display_name = p_display_name
283: AND cagr_api_id = p_cagr_api_id
284: AND ( (cagr_api_param_id <> p_cagr_api_param_id) OR
285: (p_cagr_api_param_id IS NULL));

Line 288: l_dummy per_cagr_api_parameters.display_name%TYPE;

284: AND ( (cagr_api_param_id <> p_cagr_api_param_id) OR
285: (p_cagr_api_param_id IS NULL));
286: --
287: l_proc VARCHAR2(72) := g_package || 'chk_display_name';
288: l_dummy per_cagr_api_parameters.display_name%TYPE;
289: --
290:
291: BEGIN
292: --

Line 371: (p_parameter_name IN per_cagr_api_parameters.parameter_name%TYPE

367: --
368: -- ---------------------------------------------------------------------------
369: --
370: PROCEDURE chk_parameter_name
371: (p_parameter_name IN per_cagr_api_parameters.parameter_name%TYPE
372: ,p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE
373: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_id%TYPE) IS
374: --
375: --

Line 372: ,p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE

368: -- ---------------------------------------------------------------------------
369: --
370: PROCEDURE chk_parameter_name
371: (p_parameter_name IN per_cagr_api_parameters.parameter_name%TYPE
372: ,p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE
373: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_id%TYPE) IS
374: --
375: --
376: CURSOR csr_chk_parameter_name IS

Line 373: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_id%TYPE) IS

369: --
370: PROCEDURE chk_parameter_name
371: (p_parameter_name IN per_cagr_api_parameters.parameter_name%TYPE
372: ,p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE
373: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_id%TYPE) IS
374: --
375: --
376: CURSOR csr_chk_parameter_name IS
377: SELECT parameter_name

Line 378: FROM per_cagr_api_parameters cpa

374: --
375: --
376: CURSOR csr_chk_parameter_name IS
377: SELECT parameter_name
378: FROM per_cagr_api_parameters cpa
379: WHERE parameter_name = p_parameter_name
380: AND cagr_api_id = p_cagr_api_id
381: AND ((cagr_api_param_id <> p_cagr_api_param_id) OR
382: (p_cagr_api_param_id IS NULL));

Line 385: l_dummy per_cagr_api_parameters.parameter_name%TYPE;

381: AND ((cagr_api_param_id <> p_cagr_api_param_id) OR
382: (p_cagr_api_param_id IS NULL));
383: --
384: l_proc VARCHAR2(72) := g_package || 'chk_parameter_name';
385: l_dummy per_cagr_api_parameters.parameter_name%TYPE;
386: --
387:
388: BEGIN
389: --

Line 469: (p_hidden IN per_cagr_api_parameters.hidden%TYPE

465: --
466: -- ---------------------------------------------------------------------------
467: --
468: PROCEDURE chk_hidden
469: (p_hidden IN per_cagr_api_parameters.hidden%TYPE
470: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
471: ,p_effective_date IN DATE) IS
472: --
473: l_proc VARCHAR2(72) := g_package || 'chk_hidden';

Line 470: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE

466: -- ---------------------------------------------------------------------------
467: --
468: PROCEDURE chk_hidden
469: (p_hidden IN per_cagr_api_parameters.hidden%TYPE
470: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
471: ,p_effective_date IN DATE) IS
472: --
473: l_proc VARCHAR2(72) := g_package || 'chk_hidden';
474: --

Line 546: (p_column_type IN per_cagr_api_parameters.column_type%TYPE

542: --
543: -- ---------------------------------------------------------------------------
544: --
545: PROCEDURE chk_column_type
546: (p_column_type IN per_cagr_api_parameters.column_type%TYPE
547: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
548: ,p_effective_date IN DATE) IS
549: --
550: l_proc VARCHAR2(72) := g_package || 'chk_column_type';

Line 547: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE

543: -- ---------------------------------------------------------------------------
544: --
545: PROCEDURE chk_column_type
546: (p_column_type IN per_cagr_api_parameters.column_type%TYPE
547: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
548: ,p_effective_date IN DATE) IS
549: --
550: l_proc VARCHAR2(72) := g_package || 'chk_column_type';
551: --

Line 623: (p_column_size IN per_cagr_api_parameters.column_size%TYPE) IS

619: --
620: -- ---------------------------------------------------------------------------
621: --
622: PROCEDURE chk_column_size
623: (p_column_size IN per_cagr_api_parameters.column_size%TYPE) IS
624: --
625: l_proc VARCHAR2(72) := g_package || 'chk_column_size';
626: --
627: BEGIN

Line 674: (p_uom_parameter IN per_cagr_api_parameters.uom_parameter%TYPE

670: --
671: -- ---------------------------------------------------------------------------
672: --
673: PROCEDURE chk_uom_parameter
674: (p_uom_parameter IN per_cagr_api_parameters.uom_parameter%TYPE
675: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
676: ,p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE) IS
677: --
678: l_proc VARCHAR2(72) := g_package || 'chk_uom_parameter';

Line 675: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE

671: -- ---------------------------------------------------------------------------
672: --
673: PROCEDURE chk_uom_parameter
674: (p_uom_parameter IN per_cagr_api_parameters.uom_parameter%TYPE
675: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
676: ,p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE) IS
677: --
678: l_proc VARCHAR2(72) := g_package || 'chk_uom_parameter';
679: l_dummy per_cagr_api_parameters.uom_parameter%TYPE;

Line 676: ,p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE) IS

672: --
673: PROCEDURE chk_uom_parameter
674: (p_uom_parameter IN per_cagr_api_parameters.uom_parameter%TYPE
675: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
676: ,p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE) IS
677: --
678: l_proc VARCHAR2(72) := g_package || 'chk_uom_parameter';
679: l_dummy per_cagr_api_parameters.uom_parameter%TYPE;
680: --

Line 679: l_dummy per_cagr_api_parameters.uom_parameter%TYPE;

675: ,p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
676: ,p_cagr_api_id IN per_cagr_api_parameters.cagr_api_id%TYPE) IS
677: --
678: l_proc VARCHAR2(72) := g_package || 'chk_uom_parameter';
679: l_dummy per_cagr_api_parameters.uom_parameter%TYPE;
680: --
681: CURSOR csr_get_uom_parameter IS
682: SELECT cap.uom_parameter
683: FROM per_cagr_api_parameters cap

Line 683: FROM per_cagr_api_parameters cap

679: l_dummy per_cagr_api_parameters.uom_parameter%TYPE;
680: --
681: CURSOR csr_get_uom_parameter IS
682: SELECT cap.uom_parameter
683: FROM per_cagr_api_parameters cap
684: WHERE cap.cagr_api_id = p_cagr_api_id
685: AND cap.uom_parameter = p_uom_parameter
686: AND ((cap.cagr_api_param_id <> p_cagr_api_param_id) OR
687: (p_cagr_api_param_id IS NULL));

Line 760: (p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE

756: --
757: -- ---------------------------------------------------------------------------
758: --
759: PROCEDURE chk_uom_lookup
760: (p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
761: ,p_uom_lookup IN per_cagr_api_parameters.uom_lookup%TYPE
762: ,p_default_uom IN per_cagr_api_parameters.default_uom%TYPE
763: ,p_effective_date IN DATE) IS
764: --

Line 761: ,p_uom_lookup IN per_cagr_api_parameters.uom_lookup%TYPE

757: -- ---------------------------------------------------------------------------
758: --
759: PROCEDURE chk_uom_lookup
760: (p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
761: ,p_uom_lookup IN per_cagr_api_parameters.uom_lookup%TYPE
762: ,p_default_uom IN per_cagr_api_parameters.default_uom%TYPE
763: ,p_effective_date IN DATE) IS
764: --
765: l_proc VARCHAR2(72) := g_package || 'chk_uom_lookup';

Line 762: ,p_default_uom IN per_cagr_api_parameters.default_uom%TYPE

758: --
759: PROCEDURE chk_uom_lookup
760: (p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
761: ,p_uom_lookup IN per_cagr_api_parameters.uom_lookup%TYPE
762: ,p_default_uom IN per_cagr_api_parameters.default_uom%TYPE
763: ,p_effective_date IN DATE) IS
764: --
765: l_proc VARCHAR2(72) := g_package || 'chk_uom_lookup';
766: l_dummy per_cagr_api_parameters.uom_lookup%TYPE;

Line 766: l_dummy per_cagr_api_parameters.uom_lookup%TYPE;

762: ,p_default_uom IN per_cagr_api_parameters.default_uom%TYPE
763: ,p_effective_date IN DATE) IS
764: --
765: l_proc VARCHAR2(72) := g_package || 'chk_uom_lookup';
766: l_dummy per_cagr_api_parameters.uom_lookup%TYPE;
767: --
768: CURSOR csr_get_lookup_type IS
769: SELECT hl.lookup_type
770: FROM hr_standard_lookups hl

Line 867: (p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE

863: --
864: -- ---------------------------------------------------------------------------
865: --
866: PROCEDURE chk_default_uom
867: (p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
868: ,p_default_uom IN per_cagr_api_parameters.default_uom%TYPE
869: ,p_uom_lookup IN per_cagr_api_parameters.uom_lookup%TYPE
870: ,p_effective_date IN DATE) IS
871: --

Line 868: ,p_default_uom IN per_cagr_api_parameters.default_uom%TYPE

864: -- ---------------------------------------------------------------------------
865: --
866: PROCEDURE chk_default_uom
867: (p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
868: ,p_default_uom IN per_cagr_api_parameters.default_uom%TYPE
869: ,p_uom_lookup IN per_cagr_api_parameters.uom_lookup%TYPE
870: ,p_effective_date IN DATE) IS
871: --
872: l_proc VARCHAR2(72) := g_package || 'chk_uom_lookup';

Line 869: ,p_uom_lookup IN per_cagr_api_parameters.uom_lookup%TYPE

865: --
866: PROCEDURE chk_default_uom
867: (p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE
868: ,p_default_uom IN per_cagr_api_parameters.default_uom%TYPE
869: ,p_uom_lookup IN per_cagr_api_parameters.uom_lookup%TYPE
870: ,p_effective_date IN DATE) IS
871: --
872: l_proc VARCHAR2(72) := g_package || 'chk_uom_lookup';
873: l_dummy per_cagr_api_parameters.uom_lookup%TYPE;

Line 873: l_dummy per_cagr_api_parameters.uom_lookup%TYPE;

869: ,p_uom_lookup IN per_cagr_api_parameters.uom_lookup%TYPE
870: ,p_effective_date IN DATE) IS
871: --
872: l_proc VARCHAR2(72) := g_package || 'chk_uom_lookup';
873: l_dummy per_cagr_api_parameters.uom_lookup%TYPE;
874: --
875: BEGIN
876: --
877: hr_utility.set_location('Entering :'||l_proc,10);

Line 956: (p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE) IS

952: --
953: -- ---------------------------------------------------------------------------
954: --
955: PROCEDURE chk_parameter_use
956: (p_cagr_api_param_id IN per_cagr_api_parameters.cagr_api_param_id%TYPE) IS
957: --
958: l_proc varchar2(72) := g_package || 'chk_parameter_use';
959: l_dummy per_cagr_entitlement_items.item_name%TYPE;
960: --