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_CEI_BUS dependencies on PER_CAGR_ENTITLEMENT_ITEMS

Line 29: , per_cagr_entitlement_items cei

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , per_cagr_entitlement_items cei
30: where cei.cagr_entitlement_item_id = p_cagr_entitlement_item_id
31: and pbg.business_group_id = cei.business_group_id;
32: --
33: -- Declare local variables

Line 89: , per_cagr_entitlement_items cei

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , per_cagr_entitlement_items cei
90: where cei.cagr_entitlement_item_id = p_cagr_entitlement_item_id
91: and pbg.business_group_id = cei.business_group_id;
92: --
93: -- Declare local variables

Line 373: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

369: --
370: -- ---------------------------------------------------------------------------
371: --
372: PROCEDURE chk_item_name
373: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
374: ,p_item_name IN per_cagr_entitlement_items.item_name%TYPE
375: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
376: ,p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE
377: ,p_business_group_id IN per_cagr_entitlement_items.business_group_id%TYPE) IS

Line 374: ,p_item_name IN per_cagr_entitlement_items.item_name%TYPE

370: -- ---------------------------------------------------------------------------
371: --
372: PROCEDURE chk_item_name
373: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
374: ,p_item_name IN per_cagr_entitlement_items.item_name%TYPE
375: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
376: ,p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE
377: ,p_business_group_id IN per_cagr_entitlement_items.business_group_id%TYPE) IS
378: --

Line 375: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE

371: --
372: PROCEDURE chk_item_name
373: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
374: ,p_item_name IN per_cagr_entitlement_items.item_name%TYPE
375: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
376: ,p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE
377: ,p_business_group_id IN per_cagr_entitlement_items.business_group_id%TYPE) IS
378: --
379: -- Declare Cursors

Line 376: ,p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE

372: PROCEDURE chk_item_name
373: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
374: ,p_item_name IN per_cagr_entitlement_items.item_name%TYPE
375: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
376: ,p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE
377: ,p_business_group_id IN per_cagr_entitlement_items.business_group_id%TYPE) IS
378: --
379: -- Declare Cursors
380: --

Line 377: ,p_business_group_id IN per_cagr_entitlement_items.business_group_id%TYPE) IS

373: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
374: ,p_item_name IN per_cagr_entitlement_items.item_name%TYPE
375: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
376: ,p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE
377: ,p_business_group_id IN per_cagr_entitlement_items.business_group_id%TYPE) IS
378: --
379: -- Declare Cursors
380: --
381: CURSOR chk_for_global_item IS

Line 383: FROM per_cagr_entitlement_items cei

379: -- Declare Cursors
380: --
381: CURSOR chk_for_global_item IS
382: SELECT cei.item_name
383: FROM per_cagr_entitlement_items cei
384: WHERE cei.item_name = p_item_name
385: AND cei.category_name = p_category_name
386: AND cei.business_group_id IS NULL
387: AND cei.legislation_code IS NULL;

Line 391: FROM per_cagr_entitlement_items cei

387: AND cei.legislation_code IS NULL;
388: --
389: CURSOR chk_for_legislation_item IS
390: SELECT cei.item_name
391: FROM per_cagr_entitlement_items cei
392: WHERE cei.item_name = p_item_name
393: AND cei.category_name = p_category_name
394: AND cei.business_group_id IS NULL
395: AND cei.legislation_code = p_legislation_code;

Line 399: FROM per_cagr_entitlement_items cei

395: AND cei.legislation_code = p_legislation_code;
396: --
397: CURSOR chk_for_customer_item IS
398: SELECT cei.item_name
399: FROM per_cagr_entitlement_items cei
400: WHERE cei.item_name = p_item_name
401: AND cei.category_name = p_category_name
402: AND cei.business_group_id = p_business_group_id
403: AND cei.legislation_code = p_legislation_code;

Line 406: l_item_name per_cagr_entitlement_items.item_name%TYPE;

402: AND cei.business_group_id = p_business_group_id
403: AND cei.legislation_code = p_legislation_code;
404: --
405: l_proc VARCHAR2(72) := g_package||'chk_item_name';
406: l_item_name per_cagr_entitlement_items.item_name%TYPE;
407: --
408: BEGIN
409: --
410: hr_utility.set_location('Entering:'||l_proc, 10);

Line 511: (p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE) IS

507: --
508: -- ---------------------------------------------------------------------------
509: --
510: PROCEDURE chk_legislation_code
511: (p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE) IS
512: --
513: -- Local declarations
514: --
515: l_proc VARCHAR2(72) := g_package||'chk_legislation_code';

Line 594: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

590: --
591: -- ---------------------------------------------------------------------------
592: --
593: PROCEDURE chk_beneficial_rule
594: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
595: ,p_beneficial_rule IN per_cagr_entitlement_items.beneficial_rule%TYPE
596: ,p_ben_rule_value_set_id IN NUMBER
597: ,p_effective_date IN DATE) IS
598: --

Line 595: ,p_beneficial_rule IN per_cagr_entitlement_items.beneficial_rule%TYPE

591: -- ---------------------------------------------------------------------------
592: --
593: PROCEDURE chk_beneficial_rule
594: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
595: ,p_beneficial_rule IN per_cagr_entitlement_items.beneficial_rule%TYPE
596: ,p_ben_rule_value_set_id IN NUMBER
597: ,p_effective_date IN DATE) IS
598: --
599: -- Local declarations

Line 684: ,p_column_type IN OUT NOCOPY per_cagr_entitlement_items.column_type%TYPE

680: -- ---------------------------------------------------------------------------
681: --
682: PROCEDURE chk_column_type
683: (p_cagr_entitlement_item_id IN NUMBER
684: ,p_column_type IN OUT NOCOPY per_cagr_entitlement_items.column_type%TYPE
685: ,p_uom IN per_cagr_entitlement_items.uom%TYPE
686: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
687: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
688: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE

Line 685: ,p_uom IN per_cagr_entitlement_items.uom%TYPE

681: --
682: PROCEDURE chk_column_type
683: (p_cagr_entitlement_item_id IN NUMBER
684: ,p_column_type IN OUT NOCOPY per_cagr_entitlement_items.column_type%TYPE
685: ,p_uom IN per_cagr_entitlement_items.uom%TYPE
686: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
687: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
688: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
689: ,p_effective_date IN DATE) IS

Line 686: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE

682: PROCEDURE chk_column_type
683: (p_cagr_entitlement_item_id IN NUMBER
684: ,p_column_type IN OUT NOCOPY per_cagr_entitlement_items.column_type%TYPE
685: ,p_uom IN per_cagr_entitlement_items.uom%TYPE
686: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
687: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
688: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
689: ,p_effective_date IN DATE) IS
690: --

Line 687: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE

683: (p_cagr_entitlement_item_id IN NUMBER
684: ,p_column_type IN OUT NOCOPY per_cagr_entitlement_items.column_type%TYPE
685: ,p_uom IN per_cagr_entitlement_items.uom%TYPE
686: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
687: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
688: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
689: ,p_effective_date IN DATE) IS
690: --
691: -- Declare Cursors

Line 688: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE

684: ,p_column_type IN OUT NOCOPY per_cagr_entitlement_items.column_type%TYPE
685: ,p_uom IN per_cagr_entitlement_items.uom%TYPE
686: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
687: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
688: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
689: ,p_effective_date IN DATE) IS
690: --
691: -- Declare Cursors
692: --

Line 930: (p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE

926: --
927: -- ---------------------------------------------------------------------------
928: --
929: PROCEDURE chk_cagr_api_id
930: (p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
931: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
932: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
933: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE) IS
934: --

Line 931: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE

927: -- ---------------------------------------------------------------------------
928: --
929: PROCEDURE chk_cagr_api_id
930: (p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
931: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
932: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
933: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE) IS
934: --
935: -- Local declarations

Line 932: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

928: --
929: PROCEDURE chk_cagr_api_id
930: (p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
931: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
932: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
933: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE) IS
934: --
935: -- Local declarations
936: --

Line 933: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE) IS

929: PROCEDURE chk_cagr_api_id
930: (p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
931: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
932: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
933: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE) IS
934: --
935: -- Local declarations
936: --
937: l_proc VARCHAR2(72) := g_package||'chk_cagr_api_id';

Line 938: l_cagr_api_id per_cagr_entitlement_items.cagr_api_id%TYPE;

934: --
935: -- Local declarations
936: --
937: l_proc VARCHAR2(72) := g_package||'chk_cagr_api_id';
938: l_cagr_api_id per_cagr_entitlement_items.cagr_api_id%TYPE;
939: --
940: CURSOR csr_cagr_api_id IS
941: SELECT cagr_api_id
942: FROM per_cagr_apis pca

Line 1045: (p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE

1041: --
1042: -- ---------------------------------------------------------------------------
1043: --
1044: PROCEDURE chk_cagr_api_param_id
1045: (p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1046: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1047: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1048: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE) IS
1049: --

Line 1046: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE

1042: -- ---------------------------------------------------------------------------
1043: --
1044: PROCEDURE chk_cagr_api_param_id
1045: (p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1046: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1047: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1048: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE) IS
1049: --
1050: -- Local declarations

Line 1047: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

1043: --
1044: PROCEDURE chk_cagr_api_param_id
1045: (p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1046: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1047: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1048: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE) IS
1049: --
1050: -- Local declarations
1051: --

Line 1048: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE) IS

1044: PROCEDURE chk_cagr_api_param_id
1045: (p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1046: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1047: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1048: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE) IS
1049: --
1050: -- Local declarations
1051: --
1052: l_proc VARCHAR2(72) := g_package||'chk_cagr_api_param_id';

Line 1053: l_cagr_api_param_id per_cagr_entitlement_items.cagr_api_param_id%TYPE;

1049: --
1050: -- Local declarations
1051: --
1052: l_proc VARCHAR2(72) := g_package||'chk_cagr_api_param_id';
1053: l_cagr_api_param_id per_cagr_entitlement_items.cagr_api_param_id%TYPE;
1054: --
1055: CURSOR csr_cagr_api_param_id IS
1056: SELECT cagr_api_param_id
1057: FROM per_cagr_api_parameters cap

Line 1160: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

1156: --
1157: -- ---------------------------------------------------------------------------
1158: --
1159: PROCEDURE chk_category_name
1160: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1161: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1162: ,p_effective_date IN DATE) IS
1163: --
1164: -- Local declarations

Line 1161: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE

1157: -- ---------------------------------------------------------------------------
1158: --
1159: PROCEDURE chk_category_name
1160: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1161: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1162: ,p_effective_date IN DATE) IS
1163: --
1164: -- Local declarations
1165: --

Line 1241: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

1237: --
1238: -- ---------------------------------------------------------------------------
1239: --
1240: PROCEDURE chk_uom
1241: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1242: ,p_uom IN OUT NOCOPY per_cagr_entitlement_items.uom%TYPE
1243: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1244: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1245: ,p_effective_date IN DATE) IS

Line 1242: ,p_uom IN OUT NOCOPY per_cagr_entitlement_items.uom%TYPE

1238: -- ---------------------------------------------------------------------------
1239: --
1240: PROCEDURE chk_uom
1241: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1242: ,p_uom IN OUT NOCOPY per_cagr_entitlement_items.uom%TYPE
1243: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1244: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1245: ,p_effective_date IN DATE) IS
1246: --

Line 1243: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE

1239: --
1240: PROCEDURE chk_uom
1241: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1242: ,p_uom IN OUT NOCOPY per_cagr_entitlement_items.uom%TYPE
1243: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1244: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1245: ,p_effective_date IN DATE) IS
1246: --
1247: CURSOR csr_get_param_uom IS

Line 1244: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE

1240: PROCEDURE chk_uom
1241: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1242: ,p_uom IN OUT NOCOPY per_cagr_entitlement_items.uom%TYPE
1243: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1244: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1245: ,p_effective_date IN DATE) IS
1246: --
1247: CURSOR csr_get_param_uom IS
1248: SELECT p.uom_lookup,

Line 1448: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE) IS

1444: --
1445: -- ---------------------------------------------------------------------------
1446: --
1447: PROCEDURE chk_item_use
1448: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE) IS
1449: --
1450: l_proc varchar2(72) := g_package || 'chk_item_use';
1451: l_item_in_use BOOLEAN;
1452: --

Line 1530: (p_mult_entries_allowed_flag IN per_cagr_entitlement_items.multiple_entries_allowed_flag%TYPE

1526: --
1527: -- ---------------------------------------------------------------------------
1528: --
1529: PROCEDURE chk_multiple_entries_flag
1530: (p_mult_entries_allowed_flag IN per_cagr_entitlement_items.multiple_entries_allowed_flag%TYPE
1531: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1532: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1533: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1534: ,p_business_group_id IN per_cagr_entitlement_items.business_group_id%TYPE

Line 1531: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

1527: -- ---------------------------------------------------------------------------
1528: --
1529: PROCEDURE chk_multiple_entries_flag
1530: (p_mult_entries_allowed_flag IN per_cagr_entitlement_items.multiple_entries_allowed_flag%TYPE
1531: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1532: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1533: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1534: ,p_business_group_id IN per_cagr_entitlement_items.business_group_id%TYPE
1535: ,p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE

Line 1532: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE

1528: --
1529: PROCEDURE chk_multiple_entries_flag
1530: (p_mult_entries_allowed_flag IN per_cagr_entitlement_items.multiple_entries_allowed_flag%TYPE
1531: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1532: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1533: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1534: ,p_business_group_id IN per_cagr_entitlement_items.business_group_id%TYPE
1535: ,p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE
1536: ,p_effective_date IN DATE) IS

Line 1533: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE

1529: PROCEDURE chk_multiple_entries_flag
1530: (p_mult_entries_allowed_flag IN per_cagr_entitlement_items.multiple_entries_allowed_flag%TYPE
1531: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1532: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1533: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1534: ,p_business_group_id IN per_cagr_entitlement_items.business_group_id%TYPE
1535: ,p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE
1536: ,p_effective_date IN DATE) IS
1537: --

Line 1534: ,p_business_group_id IN per_cagr_entitlement_items.business_group_id%TYPE

1530: (p_mult_entries_allowed_flag IN per_cagr_entitlement_items.multiple_entries_allowed_flag%TYPE
1531: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1532: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1533: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1534: ,p_business_group_id IN per_cagr_entitlement_items.business_group_id%TYPE
1535: ,p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE
1536: ,p_effective_date IN DATE) IS
1537: --
1538: CURSOR csr_get_pay_element IS

Line 1535: ,p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE

1531: ,p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1532: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1533: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1534: ,p_business_group_id IN per_cagr_entitlement_items.business_group_id%TYPE
1535: ,p_legislation_code IN per_cagr_entitlement_items.legislation_code%TYPE
1536: ,p_effective_date IN DATE) IS
1537: --
1538: CURSOR csr_get_pay_element IS
1539: SELECT multiple_entries_allowed_flag

Line 1682: (p_auto_create_entries_flag IN OUT NOCOPY per_cagr_entitlement_items.auto_create_entries_flag%TYPE

1678: --
1679: -- ---------------------------------------------------------------------------
1680: --
1681: PROCEDURE chk_auto_create_entries_flag
1682: (p_auto_create_entries_flag IN OUT NOCOPY per_cagr_entitlement_items.auto_create_entries_flag%TYPE
1683: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1684: ,p_effective_date IN DATE) IS
1685: --
1686: l_proc VARCHAR2(72) := g_package || 'chk_auto_create_entries_flag';

Line 1683: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE

1679: -- ---------------------------------------------------------------------------
1680: --
1681: PROCEDURE chk_auto_create_entries_flag
1682: (p_auto_create_entries_flag IN OUT NOCOPY per_cagr_entitlement_items.auto_create_entries_flag%TYPE
1683: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1684: ,p_effective_date IN DATE) IS
1685: --
1686: l_proc VARCHAR2(72) := g_package || 'chk_auto_create_entries_flag';
1687: --

Line 1767: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

1763: --
1764: -- ---------------------------------------------------------------------------
1765: --
1766: PROCEDURE chk_item_is_unique
1767: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1768: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1769: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
1770: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1771: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE

Line 1768: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE

1764: -- ---------------------------------------------------------------------------
1765: --
1766: PROCEDURE chk_item_is_unique
1767: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1768: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1769: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
1770: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1771: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1772: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE

Line 1769: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE

1765: --
1766: PROCEDURE chk_item_is_unique
1767: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1768: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1769: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
1770: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1771: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1772: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1773: ,p_legislation_code IN VARCHAR2

Line 1770: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE

1766: PROCEDURE chk_item_is_unique
1767: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1768: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1769: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
1770: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1771: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1772: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1773: ,p_legislation_code IN VARCHAR2
1774: ,p_business_group_id IN NUMBER

Line 1771: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE

1767: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1768: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1769: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
1770: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1771: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1772: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1773: ,p_legislation_code IN VARCHAR2
1774: ,p_business_group_id IN NUMBER
1775: ) IS

Line 1772: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE

1768: ,p_category_name IN per_cagr_entitlement_items.category_name%TYPE
1769: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
1770: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
1771: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1772: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1773: ,p_legislation_code IN VARCHAR2
1774: ,p_business_group_id IN NUMBER
1775: ) IS
1776: --

Line 1778: l_dummy per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE;

1774: ,p_business_group_id IN NUMBER
1775: ) IS
1776: --
1777: l_proc varchar2(72) := g_package || 'chk_item_is unique';
1778: l_dummy per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE;
1779: --
1780: -- Define a cursor that will check that an item as not already
1781: -- been defined for the same API and API Param. The cursor checks
1782: -- at the GLOBAL (NULL BG and LEG), LOCALISATION (NULL BG AND

Line 1788: FROM per_cagr_entitlement_items pce

1784: -- both populated).
1785: --
1786: CURSOR csr_chk_api_item IS
1787: SELECT pce.cagr_entitlement_item_id
1788: FROM per_cagr_entitlement_items pce
1789: WHERE pce.category_name = 'ASG'
1790: AND ((p_cagr_entitlement_item_id IS NULL) OR
1791: (pce.cagr_entitlement_item_id <> p_cagr_entitlement_item_id))
1792: AND ((pce.business_group_id IS NULL AND

Line 1803: FROM per_cagr_entitlement_items pce

1799: AND pce.cagr_api_param_id = p_cagr_api_param_id;
1800: --
1801: CURSOR csr_chk_pay_item IS
1802: SELECT pce.cagr_entitlement_item_id
1803: FROM per_cagr_entitlement_items pce
1804: WHERE ((p_cagr_entitlement_item_id IS NULL) OR
1805: (pce.cagr_entitlement_item_id <> p_cagr_entitlement_item_id))
1806: AND ((pce.business_group_id IS NULL AND
1807: pce.legislation_code IS NULL) OR

Line 1943: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

1939: --
1940: -- ---------------------------------------------------------------------------
1941: --
1942: PROCEDURE chk_element_type_id
1943: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1944: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
1945: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1946: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1947: ,p_effective_date IN DATE

Line 1944: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE

1940: -- ---------------------------------------------------------------------------
1941: --
1942: PROCEDURE chk_element_type_id
1943: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1944: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
1945: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1946: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1947: ,p_effective_date IN DATE
1948: ,p_legislation_code IN pay_element_types_f.legislation_code%TYPE

Line 1945: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE

1941: --
1942: PROCEDURE chk_element_type_id
1943: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1944: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
1945: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1946: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1947: ,p_effective_date IN DATE
1948: ,p_legislation_code IN pay_element_types_f.legislation_code%TYPE
1949: ,p_business_group_id IN pay_element_types_f.business_group_id%TYPE

Line 1946: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE

1942: PROCEDURE chk_element_type_id
1943: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
1944: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
1945: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1946: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1947: ,p_effective_date IN DATE
1948: ,p_legislation_code IN pay_element_types_f.legislation_code%TYPE
1949: ,p_business_group_id IN pay_element_types_f.business_group_id%TYPE
1950: ) IS

Line 2095: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

2091: --
2092: -- ---------------------------------------------------------------------------
2093: --
2094: PROCEDURE chk_input_value_id
2095: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
2096: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
2097: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
2098: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
2099: ,p_effective_date IN DATE

Line 2096: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE

2092: -- ---------------------------------------------------------------------------
2093: --
2094: PROCEDURE chk_input_value_id
2095: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
2096: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
2097: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
2098: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
2099: ,p_effective_date IN DATE
2100: ) IS

Line 2097: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE

2093: --
2094: PROCEDURE chk_input_value_id
2095: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
2096: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
2097: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
2098: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
2099: ,p_effective_date IN DATE
2100: ) IS
2101: --

Line 2098: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE

2094: PROCEDURE chk_input_value_id
2095: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
2096: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
2097: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
2098: ,p_cagr_api_param_id IN per_cagr_entitlement_items.cagr_api_param_id%TYPE
2099: ,p_effective_date IN DATE
2100: ) IS
2101: --
2102: l_proc varchar2(72) := g_package || 'chk_input_value_id';

Line 2236: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

2232: --
2233: -- ---------------------------------------------------------------------------
2234: --
2235: PROCEDURE chk_flex_value_set_id
2236: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
2237: ,p_flex_value_set_id IN per_cagr_entitlement_items.flex_value_set_id%TYPE) IS
2238: --
2239: CURSOR c_chk_id IS
2240: SELECT flex_value_set_id

Line 2237: ,p_flex_value_set_id IN per_cagr_entitlement_items.flex_value_set_id%TYPE) IS

2233: -- ---------------------------------------------------------------------------
2234: --
2235: PROCEDURE chk_flex_value_set_id
2236: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
2237: ,p_flex_value_set_id IN per_cagr_entitlement_items.flex_value_set_id%TYPE) IS
2238: --
2239: CURSOR c_chk_id IS
2240: SELECT flex_value_set_id
2241: FROM fnd_flex_value_sets F

Line 2249: l_dummy_id per_cagr_entitlement_items.flex_value_set_id%TYPE;

2245: (f.flex_value_set_name <> 'CAGR_EMPLOYMENT_CATEGORY')))
2246: AND f.validation_type = 'F';
2247: --
2248: l_proc VARCHAR2(72) := g_package||'chk_flex_value_set_id';
2249: l_dummy_id per_cagr_entitlement_items.flex_value_set_id%TYPE;
2250: --
2251: BEGIN
2252: --
2253: hr_utility.set_location('Entering:'||l_proc, 10);