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_GENERIC_UPGRADE dependencies on PAY_UPGRADE_DEFINITIONS

Line 175: from pay_upgrade_definitions pud

171: is
172: cursor get_upg_def (p_legislation in varchar2)
173: is
174: select pud.upgrade_definition_id
175: from pay_upgrade_definitions pud
176: where pud.upgrade_level = 'B' -- Business Group
177: and ( pud.legislation_code = p_legislation
178: or ( pud.legislation_code is null
179: and ( nvl(pud.legislatively_enabled, 'N') = 'N'

Line 197: from pay_upgrade_definitions pud

193: cursor get_upg_def_leg (p_legislation in varchar2,
194: p_business_group in number)
195: is
196: select pud.upgrade_definition_id
197: from pay_upgrade_definitions pud
198: where pud.upgrade_level = 'L' -- Business Group
199: and ( pud.legislation_code = p_legislation
200: or ( pud.legislation_code is null
201: and nvl(pud.legislatively_enabled, 'N') = 'Y'

Line 231: from pay_upgrade_definitions pud

227:
228: cursor get_upg_def_glo (p_business_group in number)
229: is
230: select pud.upgrade_definition_id
231: from pay_upgrade_definitions pud
232: where pud.upgrade_level = 'G'
233: and nvl(pud.legislatively_enabled, 'N') = 'N'
234: and not exists (select 1
235: from per_business_groups_perf

Line 294: l_upg_def_nm pay_upgrade_definitions.short_name%type;

290: Arguments :
291: Notes :
292: */
293: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
294: l_upg_def_nm pay_upgrade_definitions.short_name%type;
295: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
296: l_upg_level pay_upgrade_definitions.upgrade_level%type;
297: l_bus_grp_id pay_payroll_actions.business_group_id%type;
298: l_leg_code per_business_groups.legislation_code%type;

Line 295: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;

291: Notes :
292: */
293: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
294: l_upg_def_nm pay_upgrade_definitions.short_name%type;
295: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
296: l_upg_level pay_upgrade_definitions.upgrade_level%type;
297: l_bus_grp_id pay_payroll_actions.business_group_id%type;
298: l_leg_code per_business_groups.legislation_code%type;
299: l_thread_level pay_upgrade_definitions.threading_level%type;

Line 296: l_upg_level pay_upgrade_definitions.upgrade_level%type;

292: */
293: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
294: l_upg_def_nm pay_upgrade_definitions.short_name%type;
295: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
296: l_upg_level pay_upgrade_definitions.upgrade_level%type;
297: l_bus_grp_id pay_payroll_actions.business_group_id%type;
298: l_leg_code per_business_groups.legislation_code%type;
299: l_thread_level pay_upgrade_definitions.threading_level%type;
300: l_report_type pay_report_format_mappings_f.report_type%type;

Line 299: l_thread_level pay_upgrade_definitions.threading_level%type;

295: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
296: l_upg_level pay_upgrade_definitions.upgrade_level%type;
297: l_bus_grp_id pay_payroll_actions.business_group_id%type;
298: l_leg_code per_business_groups.legislation_code%type;
299: l_thread_level pay_upgrade_definitions.threading_level%type;
300: l_report_type pay_report_format_mappings_f.report_type%type;
301: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;
302: --
303:

Line 356: from pay_upgrade_definitions

352: threading_level
353: into l_upg_level,
354: l_upg_def_id,
355: l_thread_level
356: from pay_upgrade_definitions
357: where short_name = l_upg_def_nm;
358: --
359: end if;
360: if (l_thread_level in ('PER', 'ASG')) then

Line 722: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;

718: select distinct pet.element_type_id
719: from pay_element_types_f pet
720: where pet.element_type_id between cp_stetid and cp_endetid;
721: --
722: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
723: l_upg_def_nm pay_upgrade_definitions.short_name%type;
724: l_upg_level pay_upgrade_definitions.upgrade_level%type;
725: l_thread_level pay_upgrade_definitions.threading_level%type;
726: l_qual_proc pay_upgrade_definitions.qualifying_procedure%type;

Line 723: l_upg_def_nm pay_upgrade_definitions.short_name%type;

719: from pay_element_types_f pet
720: where pet.element_type_id between cp_stetid and cp_endetid;
721: --
722: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
723: l_upg_def_nm pay_upgrade_definitions.short_name%type;
724: l_upg_level pay_upgrade_definitions.upgrade_level%type;
725: l_thread_level pay_upgrade_definitions.threading_level%type;
726: l_qual_proc pay_upgrade_definitions.qualifying_procedure%type;
727: l_report_type pay_report_format_mappings_f.report_type%type;

Line 724: l_upg_level pay_upgrade_definitions.upgrade_level%type;

720: where pet.element_type_id between cp_stetid and cp_endetid;
721: --
722: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
723: l_upg_def_nm pay_upgrade_definitions.short_name%type;
724: l_upg_level pay_upgrade_definitions.upgrade_level%type;
725: l_thread_level pay_upgrade_definitions.threading_level%type;
726: l_qual_proc pay_upgrade_definitions.qualifying_procedure%type;
727: l_report_type pay_report_format_mappings_f.report_type%type;
728: l_report_format pay_report_format_mappings_f.report_format%type;

Line 725: l_thread_level pay_upgrade_definitions.threading_level%type;

721: --
722: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
723: l_upg_def_nm pay_upgrade_definitions.short_name%type;
724: l_upg_level pay_upgrade_definitions.upgrade_level%type;
725: l_thread_level pay_upgrade_definitions.threading_level%type;
726: l_qual_proc pay_upgrade_definitions.qualifying_procedure%type;
727: l_report_type pay_report_format_mappings_f.report_type%type;
728: l_report_format pay_report_format_mappings_f.report_format%type;
729: l_report_qualifier pay_report_format_mappings_f.report_qualifier%type;

Line 726: l_qual_proc pay_upgrade_definitions.qualifying_procedure%type;

722: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
723: l_upg_def_nm pay_upgrade_definitions.short_name%type;
724: l_upg_level pay_upgrade_definitions.upgrade_level%type;
725: l_thread_level pay_upgrade_definitions.threading_level%type;
726: l_qual_proc pay_upgrade_definitions.qualifying_procedure%type;
727: l_report_type pay_report_format_mappings_f.report_type%type;
728: l_report_format pay_report_format_mappings_f.report_format%type;
729: l_report_qualifier pay_report_format_mappings_f.report_qualifier%type;
730: l_report_category pay_report_format_mappings_f.report_category%type;

Line 778: from pay_upgrade_definitions

774: into l_upg_level,
775: l_thread_level,
776: l_upg_def_id,
777: l_qual_proc
778: from pay_upgrade_definitions
779: where short_name = l_upg_def_nm;
780: end if;
781: --
782: if (l_upg_level = 'B') then

Line 947: upgrade_proc pay_upgrade_definitions.upgrade_procedure%TYPE;

943: procedure upgrade_data(p_assactid in number, p_effective_date in date) is
944: --
945: sql_cur number;
946: ignore number;
947: upgrade_proc pay_upgrade_definitions.upgrade_procedure%TYPE;
948: statem varchar2(256);
949: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
950: l_upg_def_nm pay_upgrade_definitions.short_name%type;
951: object_id pay_temp_object_actions.object_id%type;

Line 949: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;

945: sql_cur number;
946: ignore number;
947: upgrade_proc pay_upgrade_definitions.upgrade_procedure%TYPE;
948: statem varchar2(256);
949: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
950: l_upg_def_nm pay_upgrade_definitions.short_name%type;
951: object_id pay_temp_object_actions.object_id%type;
952: --
953: begin

Line 950: l_upg_def_nm pay_upgrade_definitions.short_name%type;

946: ignore number;
947: upgrade_proc pay_upgrade_definitions.upgrade_procedure%TYPE;
948: statem varchar2(256);
949: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
950: l_upg_def_nm pay_upgrade_definitions.short_name%type;
951: object_id pay_temp_object_actions.object_id%type;
952: --
953: begin
954: --

Line 969: from pay_upgrade_definitions

965: select upgrade_procedure,
966: upgrade_definition_id
967: into upgrade_proc,
968: l_upg_def_id
969: from pay_upgrade_definitions
970: where short_name = l_upg_def_nm;
971: --
972: statem := 'BEGIN '||upgrade_proc||'(:objectid); END;';
973: --

Line 998: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;

994: is
995: --
996: l_remove_act varchar2(10);
997: cnt_incomplete_actions number;
998: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
999: l_upg_def_nm pay_upgrade_definitions.short_name%type;
1000: l_upg_level pay_upgrade_definitions.upgrade_level%type;
1001: l_bus_grp_id pay_payroll_actions.business_group_id%type;
1002: l_leg_code per_business_groups.legislation_code%type;

Line 999: l_upg_def_nm pay_upgrade_definitions.short_name%type;

995: --
996: l_remove_act varchar2(10);
997: cnt_incomplete_actions number;
998: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
999: l_upg_def_nm pay_upgrade_definitions.short_name%type;
1000: l_upg_level pay_upgrade_definitions.upgrade_level%type;
1001: l_bus_grp_id pay_payroll_actions.business_group_id%type;
1002: l_leg_code per_business_groups.legislation_code%type;
1003: l_report_type pay_payroll_actions.report_type%type;

Line 1000: l_upg_level pay_upgrade_definitions.upgrade_level%type;

996: l_remove_act varchar2(10);
997: cnt_incomplete_actions number;
998: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
999: l_upg_def_nm pay_upgrade_definitions.short_name%type;
1000: l_upg_level pay_upgrade_definitions.upgrade_level%type;
1001: l_bus_grp_id pay_payroll_actions.business_group_id%type;
1002: l_leg_code per_business_groups.legislation_code%type;
1003: l_report_type pay_payroll_actions.report_type%type;
1004: --

Line 1048: from pay_upgrade_definitions

1044: select upgrade_level,
1045: upgrade_definition_id
1046: into l_upg_level,
1047: l_upg_def_id
1048: from pay_upgrade_definitions
1049: where short_name = l_upg_def_nm;
1050: --
1051: select count(*)
1052: into cnt_incomplete_actions