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

Line 29: (p_uom IN per_cagr_entitlement_items.uom%TYPE) RETURN CHAR IS

25: -- |--------------------< convert_uom_to_data_type >--------------------------|
26: -- ----------------------------------------------------------------------------
27: --
28: FUNCTION convert_uom_to_data_type
29: (p_uom IN per_cagr_entitlement_items.uom%TYPE) RETURN CHAR IS
30: --
31: -- Delcare Local Variables
32: --
33: l_proc VARCHAR2(72) := g_pkg||'convert_uom_to_data_type';

Line 34: l_data_type per_cagr_entitlement_items.column_type%TYPE;

30: --
31: -- Delcare Local Variables
32: --
33: l_proc VARCHAR2(72) := g_pkg||'convert_uom_to_data_type';
34: l_data_type per_cagr_entitlement_items.column_type%TYPE;
35: --
36: BEGIN
37: --
38: hr_utility.set_location('Entering '||l_proc||'/'||p_uom,10);

Line 439: l_return_value per_cagr_entitlement_items.column_type%TYPE;

435: ,p_effective_date IN DATE) RETURN VARCHAR2 IS
436: --
437: -- Delcare Local Variables
438: --
439: l_return_value per_cagr_entitlement_items.column_type%TYPE;
440: l_proc VARCHAR2(72) := g_pkg||'get_column_type';
441: l_item_category per_cagr_entitlement_items.category_name%TYPE;
442: l_input_value_id pay_input_values.input_value_id%TYPE;
443: l_uom per_cagr_entitlement_items.uom%TYPE;

Line 441: l_item_category per_cagr_entitlement_items.category_name%TYPE;

437: -- Delcare Local Variables
438: --
439: l_return_value per_cagr_entitlement_items.column_type%TYPE;
440: l_proc VARCHAR2(72) := g_pkg||'get_column_type';
441: l_item_category per_cagr_entitlement_items.category_name%TYPE;
442: l_input_value_id pay_input_values.input_value_id%TYPE;
443: l_uom per_cagr_entitlement_items.uom%TYPE;
444: l_column_type per_cagr_entitlement_items.column_type%TYPE;
445: l_uom_lookup per_cagr_api_parameters.uom_lookup%TYPE;

Line 443: l_uom per_cagr_entitlement_items.uom%TYPE;

439: l_return_value per_cagr_entitlement_items.column_type%TYPE;
440: l_proc VARCHAR2(72) := g_pkg||'get_column_type';
441: l_item_category per_cagr_entitlement_items.category_name%TYPE;
442: l_input_value_id pay_input_values.input_value_id%TYPE;
443: l_uom per_cagr_entitlement_items.uom%TYPE;
444: l_column_type per_cagr_entitlement_items.column_type%TYPE;
445: l_uom_lookup per_cagr_api_parameters.uom_lookup%TYPE;
446: --
447: CURSOR csr_get_uom_details IS

Line 444: l_column_type per_cagr_entitlement_items.column_type%TYPE;

440: l_proc VARCHAR2(72) := g_pkg||'get_column_type';
441: l_item_category per_cagr_entitlement_items.category_name%TYPE;
442: l_input_value_id pay_input_values.input_value_id%TYPE;
443: l_uom per_cagr_entitlement_items.uom%TYPE;
444: l_column_type per_cagr_entitlement_items.column_type%TYPE;
445: l_uom_lookup per_cagr_api_parameters.uom_lookup%TYPE;
446: --
447: CURSOR csr_get_uom_details IS
448: SELECT cei.uom,

Line 451: FROM per_cagr_entitlement_items cei,

447: CURSOR csr_get_uom_details IS
448: SELECT cei.uom,
449: cei.column_type,
450: p.uom_lookup
451: FROM per_cagr_entitlement_items cei,
452: per_cagr_api_parameters p
453: WHERE cei.cagr_entitlement_item_id = p_cagr_entitlement_item_id
454: AND p.cagr_api_param_id (+) = cei.cagr_api_param_id;
455: --

Line 459: FROM per_cagr_entitlement_items pce

455: --
456: CURSOR c_item_category IS
457: SELECT pce.category_name,
458: pce.input_value_id
459: FROM per_cagr_entitlement_items pce
460: WHERE pce.cagr_entitlement_item_id = p_cagr_entitlement_item_id;
461: --
462: CURSOR c_pay_item_type IS
463: SELECT piv.uom

Line 471: FROM per_cagr_entitlement_items pce

467: AND piv.effective_end_date;
468: --
469: CURSOR c_item_type IS
470: SELECT pce.column_type
471: FROM per_cagr_entitlement_items pce
472: WHERE pce.cagr_entitlement_item_id = p_cagr_entitlement_item_id;
473: --
474: BEGIN
475: --

Line 688: per_cagr_entitlement_items pci

684: CURSOR csr_entitlement_details IS
685: SELECT pci.flex_value_set_id,
686: pci.business_group_id
687: FROM per_cagr_entitlements pce,
688: per_cagr_entitlement_items pci
689: WHERE pci.cagr_entitlement_item_id = pce.cagr_entitlement_item_id
690: AND pce.cagr_entitlement_id = p_cagr_entitlement_id;
691: --
692: -- Delcare Local Variables

Line 694: l_flex_value_set_id per_cagr_entitlement_items.flex_value_set_id%TYPE;

690: AND pce.cagr_entitlement_id = p_cagr_entitlement_id;
691: --
692: -- Delcare Local Variables
693: --
694: l_flex_value_set_id per_cagr_entitlement_items.flex_value_set_id%TYPE;
695: l_business_group_id per_cagr_entitlement_items.business_group_id%TYPE;
696: l_sql_statement VARCHAR2(2000);
697: l_value_id VARCHAR2(10);
698: l_id_column VARCHAR2(200);

Line 695: l_business_group_id per_cagr_entitlement_items.business_group_id%TYPE;

691: --
692: -- Delcare Local Variables
693: --
694: l_flex_value_set_id per_cagr_entitlement_items.flex_value_set_id%TYPE;
695: l_business_group_id per_cagr_entitlement_items.business_group_id%TYPE;
696: l_sql_statement VARCHAR2(2000);
697: l_value_id VARCHAR2(10);
698: l_id_column VARCHAR2(200);
699: l_name VARCHAR2(2000);