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.PQH_BUDGET_DATA_MIGRATION dependencies on PER_SHARED_TYPES

Line 89: -- populate the per_shared_types table with user defined codes

85:
86: -- populate the globals
87: populate_globals;
88:
89: -- populate the per_shared_types table with user defined codes
90: populate_per_shared_types;
91:
92:
93: -- open the per_budget_cursor

Line 90: populate_per_shared_types;

86: -- populate the globals
87: populate_globals;
88:
89: -- populate the per_shared_types table with user defined codes
90: populate_per_shared_types;
91:
92:
93: -- open the per_budget_cursor
94: OPEN per_budget_cur;

Line 679: FROM per_shared_types_vl pst , hr_standard_lookups lk

675: IS
676:
677: CURSOR uom_csr IS
678: SELECT pst.shared_type_id
679: FROM per_shared_types_vl pst , hr_standard_lookups lk
680: WHERE lk.lookup_type = pst.lookup_type
681: and lk.lookup_code = pst.system_type_cd
682: and lk.meaning = pst.shared_type_name
683: and lk.lookup_code = p_unit

Line 720: PROCEDURE populate_per_shared_types

716: WHEN others THEN
717: raise;
718: END;
719: --------------------------------------------------------------------------------------------------------------
720: PROCEDURE populate_per_shared_types
721: IS
722: /*
723: This procedure will populate per_shared_types with lookup_code that the user may have
724: defined for lookup_type = BUDGET_MEASUREMENT_TYPE

Line 723: This procedure will populate per_shared_types with lookup_code that the user may have

719: --------------------------------------------------------------------------------------------------------------
720: PROCEDURE populate_per_shared_types
721: IS
722: /*
723: This procedure will populate per_shared_types with lookup_code that the user may have
724: defined for lookup_type = BUDGET_MEASUREMENT_TYPE
725: */
726: -- local variables and cursors
727:

Line 728: l_proc varchar2(72) := g_package||'populate_per_shared_types';

724: defined for lookup_type = BUDGET_MEASUREMENT_TYPE
725: */
726: -- local variables and cursors
727:
728: l_proc varchar2(72) := g_package||'populate_per_shared_types';
729: l_object_version_number per_shared_types.object_version_number%TYPE;
730: l_shared_type_id per_shared_types.shared_type_id%TYPE;
731: l_lookup_code per_shared_types.system_type_cd%TYPE;
732: l_meaning per_shared_types.shared_type_name%TYPE;

Line 729: l_object_version_number per_shared_types.object_version_number%TYPE;

725: */
726: -- local variables and cursors
727:
728: l_proc varchar2(72) := g_package||'populate_per_shared_types';
729: l_object_version_number per_shared_types.object_version_number%TYPE;
730: l_shared_type_id per_shared_types.shared_type_id%TYPE;
731: l_lookup_code per_shared_types.system_type_cd%TYPE;
732: l_meaning per_shared_types.shared_type_name%TYPE;
733:

Line 730: l_shared_type_id per_shared_types.shared_type_id%TYPE;

726: -- local variables and cursors
727:
728: l_proc varchar2(72) := g_package||'populate_per_shared_types';
729: l_object_version_number per_shared_types.object_version_number%TYPE;
730: l_shared_type_id per_shared_types.shared_type_id%TYPE;
731: l_lookup_code per_shared_types.system_type_cd%TYPE;
732: l_meaning per_shared_types.shared_type_name%TYPE;
733:
734:

Line 731: l_lookup_code per_shared_types.system_type_cd%TYPE;

727:
728: l_proc varchar2(72) := g_package||'populate_per_shared_types';
729: l_object_version_number per_shared_types.object_version_number%TYPE;
730: l_shared_type_id per_shared_types.shared_type_id%TYPE;
731: l_lookup_code per_shared_types.system_type_cd%TYPE;
732: l_meaning per_shared_types.shared_type_name%TYPE;
733:
734:
735: CURSOR pop_uom_csr is

Line 732: l_meaning per_shared_types.shared_type_name%TYPE;

728: l_proc varchar2(72) := g_package||'populate_per_shared_types';
729: l_object_version_number per_shared_types.object_version_number%TYPE;
730: l_shared_type_id per_shared_types.shared_type_id%TYPE;
731: l_lookup_code per_shared_types.system_type_cd%TYPE;
732: l_meaning per_shared_types.shared_type_name%TYPE;
733:
734:
735: CURSOR pop_uom_csr is
736: SELECT lookup_code, meaning

Line 742: FROM per_shared_types

738: WHERE lookup_type = 'BUDGET_MEASUREMENT_TYPE'
739: AND enabled_flag = 'Y'
740: AND sysdate BETWEEN NVL(start_date_active,sysdate) AND NVL(end_date_active,sysdate)
741: AND lookup_code NOT IN ( SELECT system_type_cd
742: FROM per_shared_types
743: WHERE lookup_type = 'BUDGET_MEASUREMENT_TYPE' );
744:
745: BEGIN
746:

Line 755: per_shared_types_api.create_shared_type

751:
752: FETCH pop_uom_csr into l_lookup_code, l_meaning;
753: EXIT WHEN pop_uom_csr%NOTFOUND;
754:
755: per_shared_types_api.create_shared_type
756: (
757: p_shared_type_id => l_shared_type_id
758: ,p_shared_type_name => l_meaning
759: ,p_system_type_cd => l_lookup_code

Line 766: hr_utility.set_location('Ins Per Shared Types '||l_lookup_code,10);

762: ,p_lookup_type => 'BUDGET_MEASUREMENT_TYPE'
763: ,p_effective_date => sysdate
764: );
765:
766: hr_utility.set_location('Ins Per Shared Types '||l_lookup_code,10);
767:
768: END LOOP;
769:
770: CLOSE pop_uom_csr;