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.PAY_IP_STARTUP_UTIL dependencies on PAY_UPGRADE_DEFINITIONS

Line 2923: FROM pay_upgrade_definitions pud

2919: (p_legislation_code IN VARCHAR2) IS
2920:
2921: Cursor csr_gen_upg_exists (p_short_name varchar2)IS
2922: SELECT 'Y'
2923: FROM pay_upgrade_definitions pud
2924: WHERE pud.short_name = p_short_name
2925: AND pud.legislation_code = p_legislation_code;
2926:
2927: Cursor csr_get_gen_upg_values (p_short_name varchar2)IS

Line 2940: FROM pay_upgrade_definitions pud

2936: pud.upgrade_method,
2937: pud.upgrade_procedure,
2938: pud.qualifying_procedure,
2939: pud.owner_application_id
2940: FROM pay_upgrade_definitions pud
2941: WHERE pud.short_name = p_short_name
2942: AND pud.legislation_code = 'ZZ';
2943:
2944: TYPE character_data_table IS TABLE OF VARCHAR2(280)

Line 2953: ln_upg_id pay_upgrade_definitions.upgrade_definition_id%TYPE;

2949: ltt_gen_short_name character_data_table;
2950:
2951: --local variables for capturing generic upgrade definition.
2952:
2953: ln_upg_id pay_upgrade_definitions.upgrade_definition_id%TYPE;
2954:
2955: lv_short_name pay_upgrade_definitions.short_name%TYPE;
2956: lv_name pay_upgrade_definitions.name%TYPE;
2957: lv_description pay_upgrade_definitions.description%TYPE;

Line 2955: lv_short_name pay_upgrade_definitions.short_name%TYPE;

2951: --local variables for capturing generic upgrade definition.
2952:
2953: ln_upg_id pay_upgrade_definitions.upgrade_definition_id%TYPE;
2954:
2955: lv_short_name pay_upgrade_definitions.short_name%TYPE;
2956: lv_name pay_upgrade_definitions.name%TYPE;
2957: lv_description pay_upgrade_definitions.description%TYPE;
2958: lv_upgrade_level pay_upgrade_definitions.upgrade_level%TYPE;
2959: lv_criticality pay_upgrade_definitions.criticality%TYPE;

Line 2956: lv_name pay_upgrade_definitions.name%TYPE;

2952:
2953: ln_upg_id pay_upgrade_definitions.upgrade_definition_id%TYPE;
2954:
2955: lv_short_name pay_upgrade_definitions.short_name%TYPE;
2956: lv_name pay_upgrade_definitions.name%TYPE;
2957: lv_description pay_upgrade_definitions.description%TYPE;
2958: lv_upgrade_level pay_upgrade_definitions.upgrade_level%TYPE;
2959: lv_criticality pay_upgrade_definitions.criticality%TYPE;
2960: lv_threading_level pay_upgrade_definitions.threading_level%TYPE;

Line 2957: lv_description pay_upgrade_definitions.description%TYPE;

2953: ln_upg_id pay_upgrade_definitions.upgrade_definition_id%TYPE;
2954:
2955: lv_short_name pay_upgrade_definitions.short_name%TYPE;
2956: lv_name pay_upgrade_definitions.name%TYPE;
2957: lv_description pay_upgrade_definitions.description%TYPE;
2958: lv_upgrade_level pay_upgrade_definitions.upgrade_level%TYPE;
2959: lv_criticality pay_upgrade_definitions.criticality%TYPE;
2960: lv_threading_level pay_upgrade_definitions.threading_level%TYPE;
2961: lv_failure_point pay_upgrade_definitions.failure_point%TYPE;

Line 2958: lv_upgrade_level pay_upgrade_definitions.upgrade_level%TYPE;

2954:
2955: lv_short_name pay_upgrade_definitions.short_name%TYPE;
2956: lv_name pay_upgrade_definitions.name%TYPE;
2957: lv_description pay_upgrade_definitions.description%TYPE;
2958: lv_upgrade_level pay_upgrade_definitions.upgrade_level%TYPE;
2959: lv_criticality pay_upgrade_definitions.criticality%TYPE;
2960: lv_threading_level pay_upgrade_definitions.threading_level%TYPE;
2961: lv_failure_point pay_upgrade_definitions.failure_point%TYPE;
2962: lv_leg_enabled pay_upgrade_definitions.legislatively_enabled%TYPE;

Line 2959: lv_criticality pay_upgrade_definitions.criticality%TYPE;

2955: lv_short_name pay_upgrade_definitions.short_name%TYPE;
2956: lv_name pay_upgrade_definitions.name%TYPE;
2957: lv_description pay_upgrade_definitions.description%TYPE;
2958: lv_upgrade_level pay_upgrade_definitions.upgrade_level%TYPE;
2959: lv_criticality pay_upgrade_definitions.criticality%TYPE;
2960: lv_threading_level pay_upgrade_definitions.threading_level%TYPE;
2961: lv_failure_point pay_upgrade_definitions.failure_point%TYPE;
2962: lv_leg_enabled pay_upgrade_definitions.legislatively_enabled%TYPE;
2963: lv_upgrade_method pay_upgrade_definitions.upgrade_method%TYPE;

Line 2960: lv_threading_level pay_upgrade_definitions.threading_level%TYPE;

2956: lv_name pay_upgrade_definitions.name%TYPE;
2957: lv_description pay_upgrade_definitions.description%TYPE;
2958: lv_upgrade_level pay_upgrade_definitions.upgrade_level%TYPE;
2959: lv_criticality pay_upgrade_definitions.criticality%TYPE;
2960: lv_threading_level pay_upgrade_definitions.threading_level%TYPE;
2961: lv_failure_point pay_upgrade_definitions.failure_point%TYPE;
2962: lv_leg_enabled pay_upgrade_definitions.legislatively_enabled%TYPE;
2963: lv_upgrade_method pay_upgrade_definitions.upgrade_method%TYPE;
2964: lv_upgrade_proc pay_upgrade_definitions.upgrade_procedure%TYPE;

Line 2961: lv_failure_point pay_upgrade_definitions.failure_point%TYPE;

2957: lv_description pay_upgrade_definitions.description%TYPE;
2958: lv_upgrade_level pay_upgrade_definitions.upgrade_level%TYPE;
2959: lv_criticality pay_upgrade_definitions.criticality%TYPE;
2960: lv_threading_level pay_upgrade_definitions.threading_level%TYPE;
2961: lv_failure_point pay_upgrade_definitions.failure_point%TYPE;
2962: lv_leg_enabled pay_upgrade_definitions.legislatively_enabled%TYPE;
2963: lv_upgrade_method pay_upgrade_definitions.upgrade_method%TYPE;
2964: lv_upgrade_proc pay_upgrade_definitions.upgrade_procedure%TYPE;
2965: lv_qualifying_proc pay_upgrade_definitions.qualifying_procedure%TYPE;

Line 2962: lv_leg_enabled pay_upgrade_definitions.legislatively_enabled%TYPE;

2958: lv_upgrade_level pay_upgrade_definitions.upgrade_level%TYPE;
2959: lv_criticality pay_upgrade_definitions.criticality%TYPE;
2960: lv_threading_level pay_upgrade_definitions.threading_level%TYPE;
2961: lv_failure_point pay_upgrade_definitions.failure_point%TYPE;
2962: lv_leg_enabled pay_upgrade_definitions.legislatively_enabled%TYPE;
2963: lv_upgrade_method pay_upgrade_definitions.upgrade_method%TYPE;
2964: lv_upgrade_proc pay_upgrade_definitions.upgrade_procedure%TYPE;
2965: lv_qualifying_proc pay_upgrade_definitions.qualifying_procedure%TYPE;
2966: ln_own_appl_id pay_upgrade_definitions.owner_application_id%TYPE;

Line 2963: lv_upgrade_method pay_upgrade_definitions.upgrade_method%TYPE;

2959: lv_criticality pay_upgrade_definitions.criticality%TYPE;
2960: lv_threading_level pay_upgrade_definitions.threading_level%TYPE;
2961: lv_failure_point pay_upgrade_definitions.failure_point%TYPE;
2962: lv_leg_enabled pay_upgrade_definitions.legislatively_enabled%TYPE;
2963: lv_upgrade_method pay_upgrade_definitions.upgrade_method%TYPE;
2964: lv_upgrade_proc pay_upgrade_definitions.upgrade_procedure%TYPE;
2965: lv_qualifying_proc pay_upgrade_definitions.qualifying_procedure%TYPE;
2966: ln_own_appl_id pay_upgrade_definitions.owner_application_id%TYPE;
2967:

Line 2964: lv_upgrade_proc pay_upgrade_definitions.upgrade_procedure%TYPE;

2960: lv_threading_level pay_upgrade_definitions.threading_level%TYPE;
2961: lv_failure_point pay_upgrade_definitions.failure_point%TYPE;
2962: lv_leg_enabled pay_upgrade_definitions.legislatively_enabled%TYPE;
2963: lv_upgrade_method pay_upgrade_definitions.upgrade_method%TYPE;
2964: lv_upgrade_proc pay_upgrade_definitions.upgrade_procedure%TYPE;
2965: lv_qualifying_proc pay_upgrade_definitions.qualifying_procedure%TYPE;
2966: ln_own_appl_id pay_upgrade_definitions.owner_application_id%TYPE;
2967:
2968: BEGIN

Line 2965: lv_qualifying_proc pay_upgrade_definitions.qualifying_procedure%TYPE;

2961: lv_failure_point pay_upgrade_definitions.failure_point%TYPE;
2962: lv_leg_enabled pay_upgrade_definitions.legislatively_enabled%TYPE;
2963: lv_upgrade_method pay_upgrade_definitions.upgrade_method%TYPE;
2964: lv_upgrade_proc pay_upgrade_definitions.upgrade_procedure%TYPE;
2965: lv_qualifying_proc pay_upgrade_definitions.qualifying_procedure%TYPE;
2966: ln_own_appl_id pay_upgrade_definitions.owner_application_id%TYPE;
2967:
2968: BEGIN
2969:

Line 2966: ln_own_appl_id pay_upgrade_definitions.owner_application_id%TYPE;

2962: lv_leg_enabled pay_upgrade_definitions.legislatively_enabled%TYPE;
2963: lv_upgrade_method pay_upgrade_definitions.upgrade_method%TYPE;
2964: lv_upgrade_proc pay_upgrade_definitions.upgrade_procedure%TYPE;
2965: lv_qualifying_proc pay_upgrade_definitions.qualifying_procedure%TYPE;
2966: ln_own_appl_id pay_upgrade_definitions.owner_application_id%TYPE;
2967:
2968: BEGIN
2969:
2970: hr_utility.set_location('pay_ip_startup_util.create_gen_upg_dfn',10);

Line 3006: pay_upgrade_definitions_pkg.insert_row(

3002: lv_qualifying_proc,
3003: ln_own_appl_id;
3004: CLOSE csr_get_gen_upg_values;
3005:
3006: pay_upgrade_definitions_pkg.insert_row(
3007: P_SHORT_NAME => replace(lv_short_name,'ZZ',upper(p_legislation_code)),
3008: P_NAME => lv_name,
3009: P_DESCRIPTION => lv_description,
3010: P_LEGISLATION_CODE => p_legislation_code,