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.PQP_UTILITIES dependencies on PAY_INTERPRETER_PKG

Line 2676: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

2672: ,t_event_details OUT NOCOPY pqp_utilities.t_event_details_table_type
2673: )
2674: RETURN NUMBER
2675: IS
2676: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
2677: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
2678: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
2679: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
2680: l_event_details pqp_utilities.t_event_details_table_type;

Line 2677: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

2673: )
2674: RETURN NUMBER
2675: IS
2676: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
2677: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
2678: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
2679: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
2680: l_event_details pqp_utilities.t_event_details_table_type;
2681: l_event_group_id pay_event_groups.event_group_id%TYPE;

Line 2678: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;

2674: RETURN NUMBER
2675: IS
2676: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
2677: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
2678: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
2679: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
2680: l_event_details pqp_utilities.t_event_details_table_type;
2681: l_event_group_id pay_event_groups.event_group_id%TYPE;
2682: l_dt_event_found VARCHAR2(20) := 'N'; -- Default NOTFOUND

Line 2679: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;

2675: IS
2676: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
2677: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
2678: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
2679: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
2680: l_event_details pqp_utilities.t_event_details_table_type;
2681: l_event_group_id pay_event_groups.event_group_id%TYPE;
2682: l_dt_event_found VARCHAR2(20) := 'N'; -- Default NOTFOUND
2683: l_itr NUMBER;

Line 2702: pay_interpreter_pkg.entry_affected(

2698: END IF;
2699: IF g_debug THEN
2700: debug(l_proc_name, 10);
2701: END IF;
2702: pay_interpreter_pkg.entry_affected(
2703: p_element_entry_id => p_element_entry_id
2704: ,p_assignment_action_id => p_assignment_action_id
2705: ,p_assignment_id => p_assignment_id
2706: ,p_mode => NULL

Line 2712: -- Passing the BG ID explicitly. else pay_interpreter_pkg uses the cached BGID

2708: ,p_event_group_id => l_event_group_id
2709: ,p_process_mode => p_process_mode
2710: ,p_start_date => p_start_date
2711: ,p_end_date => p_end_date
2712: -- Passing the BG ID explicitly. else pay_interpreter_pkg uses the cached BGID
2713: ,p_business_group_id => p_business_group_id
2714: ,t_detailed_output => l_detail_tab -- OUT
2715: ,t_proration_dates => l_proration_dates -- OUT
2716: ,t_proration_change_type => l_proration_changes -- OUT

Line 2791: ,t_proration_dates OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type

2787: ,p_process_mode IN VARCHAR2 DEFAULT 'ENTRY_EFFECTIVE_DATE'
2788: ,p_event_group_name IN VARCHAR2
2789: ,p_start_date IN DATE
2790: ,p_end_date IN DATE
2791: ,t_proration_dates OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type
2792: ,t_proration_change_type OUT NOCOPY pay_interpreter_pkg.t_proration_type_table_type
2793: )
2794: RETURN NUMBER
2795: IS

Line 2792: ,t_proration_change_type OUT NOCOPY pay_interpreter_pkg.t_proration_type_table_type

2788: ,p_event_group_name IN VARCHAR2
2789: ,p_start_date IN DATE
2790: ,p_end_date IN DATE
2791: ,t_proration_dates OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type
2792: ,t_proration_change_type OUT NOCOPY pay_interpreter_pkg.t_proration_type_table_type
2793: )
2794: RETURN NUMBER
2795: IS
2796: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

Line 2796: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

2792: ,t_proration_change_type OUT NOCOPY pay_interpreter_pkg.t_proration_type_table_type
2793: )
2794: RETURN NUMBER
2795: IS
2796: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
2797: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
2798: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
2799: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
2800: l_event_details pqp_utilities.t_event_details_table_type;

Line 2797: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

2793: )
2794: RETURN NUMBER
2795: IS
2796: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
2797: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
2798: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
2799: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
2800: l_event_details pqp_utilities.t_event_details_table_type;
2801: l_event_group_id pay_event_groups.event_group_id%TYPE;

Line 2798: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;

2794: RETURN NUMBER
2795: IS
2796: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
2797: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
2798: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
2799: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
2800: l_event_details pqp_utilities.t_event_details_table_type;
2801: l_event_group_id pay_event_groups.event_group_id%TYPE;
2802: l_dt_event_found VARCHAR2(20) := 'N'; -- Default NOTFOUND

Line 2799: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;

2795: IS
2796: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
2797: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
2798: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
2799: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
2800: l_event_details pqp_utilities.t_event_details_table_type;
2801: l_event_group_id pay_event_groups.event_group_id%TYPE;
2802: l_dt_event_found VARCHAR2(20) := 'N'; -- Default NOTFOUND
2803: l_itr NUMBER;

Line 2822: pay_interpreter_pkg.entry_affected(

2818: END IF;
2819: IF g_debug THEN
2820: debug(l_proc_name, 10);
2821: END IF;
2822: pay_interpreter_pkg.entry_affected(
2823: p_element_entry_id => p_element_entry_id
2824: ,p_assignment_action_id => p_assignment_action_id
2825: ,p_assignment_id => p_assignment_id
2826: ,p_mode => NULL

Line 2832: -- Passing the BG ID explicitly. else pay_interpreter_pkg uses the cached BGID

2828: ,p_event_group_id => l_event_group_id
2829: ,p_process_mode => p_process_mode
2830: ,p_start_date => p_start_date
2831: ,p_end_date => p_end_date
2832: -- Passing the BG ID explicitly. else pay_interpreter_pkg uses the cached BGID
2833: ,p_business_group_id => p_business_group_id
2834: ,t_detailed_output => l_detail_tab -- OUT
2835: ,t_proration_dates => l_proration_dates -- OUT
2836: ,t_proration_change_type => l_proration_changes -- OUT

Line 3400: /--Description: This is a wrapper procedure on pay_interpreter_pkg.entries_affected

3396: hr_utility.set_location('Leaving '||l_proc,10);
3397: END get_kflex_value;
3398: --
3399: /*---------------------------------------------------------------/
3400: /--Description: This is a wrapper procedure on pay_interpreter_pkg.entries_affected
3401: -- pay_interpreter_pkg.entry_affected.
3402: -- Depending upon the elements entries on the assignment
3403: -- which are of type of elements which are attached to
3404: -- the element set which are attached to the event group

Line 3401: -- pay_interpreter_pkg.entry_affected.

3397: END get_kflex_value;
3398: --
3399: /*---------------------------------------------------------------/
3400: /--Description: This is a wrapper procedure on pay_interpreter_pkg.entries_affected
3401: -- pay_interpreter_pkg.entry_affected.
3402: -- Depending upon the elements entries on the assignment
3403: -- which are of type of elements which are attached to
3404: -- the element set which are attached to the event group
3405: -- usages, this procedure calls entries_affected or entry_affected

Line 3416: ,p_detailed_output OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type

3412: ,p_mode IN VARCHAR2 DEFAULT NULL
3413: ,p_start_date IN DATE DEFAULT hr_api.g_sot
3414: ,p_end_date IN DATE DEFAULT hr_api.g_eot
3415: ,p_business_group_id IN NUMBER
3416: ,p_detailed_output OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
3417: ,p_process_mode IN VARCHAR2 DEFAULT 'ENTRY_CREATION_DATE'
3418: )
3419: IS
3420: TYPE t_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 3431: l_global_env pay_interpreter_pkg.t_global_env_rec;

3427:
3428: l_proc VARCHAR2(70) := g_package_name||'.entries_effected';
3429: l_datetrack_ee_tab r_element_entries;
3430: l_count NUMBER := 0;
3431: l_global_env pay_interpreter_pkg.t_global_env_rec;
3432: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3433: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3434: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3435: l_eg_has_ee_tab VARCHAR2(1);

Line 3432: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

3428: l_proc VARCHAR2(70) := g_package_name||'.entries_effected';
3429: l_datetrack_ee_tab r_element_entries;
3430: l_count NUMBER := 0;
3431: l_global_env pay_interpreter_pkg.t_global_env_rec;
3432: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3433: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3434: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3435: l_eg_has_ee_tab VARCHAR2(1);
3436:

Line 3433: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

3429: l_datetrack_ee_tab r_element_entries;
3430: l_count NUMBER := 0;
3431: l_global_env pay_interpreter_pkg.t_global_env_rec;
3432: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3433: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3434: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3435: l_eg_has_ee_tab VARCHAR2(1);
3436:
3437:

Line 3434: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;

3430: l_count NUMBER := 0;
3431: l_global_env pay_interpreter_pkg.t_global_env_rec;
3432: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3433: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3434: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3435: l_eg_has_ee_tab VARCHAR2(1);
3436:
3437:
3438: CURSOR csr_chk_eg_for_ee_tab

Line 3652: pay_interpreter_pkg.t_distinct_tab := pay_interpreter_pkg.glo_monitored_events;

3648:
3649: -----
3650: -- This line can be removed after fix from pay for missing events on mix of calls to
3651: -- entry_affected and entries_affected - kkarri
3652: pay_interpreter_pkg.t_distinct_tab := pay_interpreter_pkg.glo_monitored_events;
3653: -----
3654: IF l_count > 0 THEN
3655: hr_utility.trace('Our procedure');
3656: hr_utility.trace('Setup the global area');

Line 3657: pay_interpreter_pkg.initialise_global(l_global_env);

3653: -----
3654: IF l_count > 0 THEN
3655: hr_utility.trace('Our procedure');
3656: hr_utility.trace('Setup the global area');
3657: pay_interpreter_pkg.initialise_global(l_global_env);
3658: pay_interpreter_pkg.event_group_tables
3659: (p_event_group_id => p_event_group_id
3660: ,p_distinct_tab => pay_interpreter_pkg.glo_monitored_events
3661: );

Line 3658: pay_interpreter_pkg.event_group_tables

3654: IF l_count > 0 THEN
3655: hr_utility.trace('Our procedure');
3656: hr_utility.trace('Setup the global area');
3657: pay_interpreter_pkg.initialise_global(l_global_env);
3658: pay_interpreter_pkg.event_group_tables
3659: (p_event_group_id => p_event_group_id
3660: ,p_distinct_tab => pay_interpreter_pkg.glo_monitored_events
3661: );
3662: --The start and end pointers can be just for the event group.

Line 3660: ,p_distinct_tab => pay_interpreter_pkg.glo_monitored_events

3656: hr_utility.trace('Setup the global area');
3657: pay_interpreter_pkg.initialise_global(l_global_env);
3658: pay_interpreter_pkg.event_group_tables
3659: (p_event_group_id => p_event_group_id
3660: ,p_distinct_tab => pay_interpreter_pkg.glo_monitored_events
3661: );
3662: --The start and end pointers can be just for the event group.
3663: -- So, commenting out these lines. - kkarri
3664: /*l_global_env.monitor_start_ptr := 1;

Line 3665: l_global_env.monitor_end_ptr := pay_interpreter_pkg.glo_monitored_events.count;*/

3661: );
3662: --The start and end pointers can be just for the event group.
3663: -- So, commenting out these lines. - kkarri
3664: /*l_global_env.monitor_start_ptr := 1;
3665: l_global_env.monitor_end_ptr := pay_interpreter_pkg.glo_monitored_events.count;*/
3666: l_global_env.monitor_start_ptr
3667: := pay_interpreter_pkg.t_proration_group_tab(p_event_group_id).range_start;
3668: l_global_env.monitor_end_ptr
3669: := pay_interpreter_pkg.t_proration_group_tab(p_event_group_id).range_end;

Line 3667: := pay_interpreter_pkg.t_proration_group_tab(p_event_group_id).range_start;

3663: -- So, commenting out these lines. - kkarri
3664: /*l_global_env.monitor_start_ptr := 1;
3665: l_global_env.monitor_end_ptr := pay_interpreter_pkg.glo_monitored_events.count;*/
3666: l_global_env.monitor_start_ptr
3667: := pay_interpreter_pkg.t_proration_group_tab(p_event_group_id).range_start;
3668: l_global_env.monitor_end_ptr
3669: := pay_interpreter_pkg.t_proration_group_tab(p_event_group_id).range_end;
3670: ---
3671: l_global_env.datetrack_ee_tab_use := TRUE;

Line 3669: := pay_interpreter_pkg.t_proration_group_tab(p_event_group_id).range_end;

3665: l_global_env.monitor_end_ptr := pay_interpreter_pkg.glo_monitored_events.count;*/
3666: l_global_env.monitor_start_ptr
3667: := pay_interpreter_pkg.t_proration_group_tab(p_event_group_id).range_start;
3668: l_global_env.monitor_end_ptr
3669: := pay_interpreter_pkg.t_proration_group_tab(p_event_group_id).range_end;
3670: ---
3671: l_global_env.datetrack_ee_tab_use := TRUE;
3672: l_global_env.validate_run_actions := FALSE;
3673:

Line 3680: pay_interpreter_pkg.add_datetrack_event_to_entry

3676: hr_utility.trace('----------------------------------');
3677: hr_utility.trace('i: '||i);
3678: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));
3679: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));
3680: pay_interpreter_pkg.add_datetrack_event_to_entry
3681: (p_datetracked_evt_id => l_datetrack_ee_tab.datetracked_event_id(i)
3682: ,p_element_entry_id => l_datetrack_ee_tab.element_entry_id(i)
3683: ,p_global_env => l_global_env
3684: );

Line 3690: pay_interpreter_pkg.entries_affected

3686: hr_utility.trace('Entered all the dte_id X ee_ids');
3687:
3688: BEGIN
3689: --call entries_effected
3690: pay_interpreter_pkg.entries_affected
3691: (p_assignment_id => p_assignment_id
3692: ,p_mode => p_mode
3693: ,p_start_date => p_start_date
3694: ,p_end_date => p_end_date

Line 3707: pay_interpreter_pkg.clear_dt_event_for_entry

3703: hr_utility.set_message(8303,'BEN_94629_NO_ASG_ACTION_ID');
3704: hr_utility.raise_error;
3705: END;
3706: -- reset l_global_env
3707: pay_interpreter_pkg.clear_dt_event_for_entry
3708: (p_global_env => l_global_env);
3709: ELSE
3710: hr_utility.trace('Normal call to entries_effected');
3711: --call entry_affected

Line 3712: pay_interpreter_pkg.entry_affected(

3708: (p_global_env => l_global_env);
3709: ELSE
3710: hr_utility.trace('Normal call to entries_effected');
3711: --call entry_affected
3712: pay_interpreter_pkg.entry_affected(
3713: p_element_entry_id => NULL
3714: ,p_assignment_action_id => NULL
3715: ,p_assignment_id => p_assignment_id
3716: ,p_mode => p_mode