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_SE_WORK_TIME_CERTIFICATE dependencies on PAY_ACTION_INFORMATION

Line 1671: pay_action_information_api.create_action_information

1667: -- *****************************************************************************
1668: -- *****************************************************************************
1669:
1670: -- Insert the report Parameters
1671: pay_action_information_api.create_action_information
1672: (p_action_information_id => l_action_info_id
1673: ,p_action_context_id => p_payroll_action_id
1674: ,p_action_context_type => 'PA'
1675: ,p_object_version_number => l_ovn

Line 1691: pay_action_information_api.create_action_information

1687: ,p_action_information8 => NULL
1688: ,p_action_information9 => NULL
1689: ,p_action_information10 => NULL
1690: );
1691: pay_action_information_api.create_action_information
1692: (p_action_information_id => l_action_info_id
1693: ,p_action_context_id => p_payroll_action_id
1694: ,p_action_context_type => 'PA'
1695: ,p_object_version_number => l_ovn

Line 1734: pay_action_information_api.create_action_information

1730: ,p_action_information29 => NULL
1731: ,p_action_information30 => g_person_id
1732: ,p_assignment_id => g_assignment_id
1733: );
1734: pay_action_information_api.create_action_information
1735: (p_action_information_id => l_action_info_id
1736: ,p_action_context_id => p_payroll_action_id
1737: ,p_action_context_type => 'PA'
1738: ,p_object_version_number => l_ovn

Line 1781: pay_action_information_api.create_action_information

1777: ,p_action_information29 => NULL
1778: ,p_action_information30 => g_person_id
1779: ,p_assignment_id => g_assignment_id
1780: );
1781: pay_action_information_api.create_action_information
1782: (p_action_information_id => l_action_info_id
1783: ,p_action_context_id => p_payroll_action_id
1784: ,p_action_context_type => 'PA'
1785: ,p_object_version_number => l_ovn

Line 1822: pay_action_information_api.create_action_information

1818: ,p_action_information29 => NULL
1819: ,p_action_information30 => g_person_id
1820: ,p_assignment_id => g_assignment_id
1821: );
1822: pay_action_information_api.create_action_information
1823: (p_action_information_id => l_action_info_id
1824: ,p_action_context_id => p_payroll_action_id
1825: ,p_action_context_type => 'PA'
1826: ,p_object_version_number => l_ovn

Line 2015: pay_action_information_api.create_action_information

2011: l_set := l_set + 1;
2012: END IF;
2013:
2014:
2015: pay_action_information_api.create_action_information
2016: (p_action_information_id => l_action_info_id
2017: ,p_action_context_id => p_payroll_action_id
2018: ,p_action_context_type => 'PA'
2019: ,p_object_version_number => l_ovn

Line 2084: pay_action_information_api.create_action_information

2080:
2081:
2082:
2083: ------------------------------ Archive for Addl/Suplementary Hrs and Overtime Hours --------------
2084: pay_action_information_api.create_action_information
2085: (p_action_information_id => l_action_info_id
2086: ,p_action_context_id => p_payroll_action_id
2087: ,p_action_context_type => 'PA'
2088: ,p_object_version_number => l_ovn

Line 2153: pay_action_information_api.create_action_information

2149:
2150:
2151:
2152: ---------------------- Populate Absence Fields ---------------------------------------------
2153: pay_action_information_api.create_action_information
2154: (p_action_information_id => l_action_info_id
2155: ,p_action_context_id => p_payroll_action_id
2156: ,p_action_context_type => 'PA'
2157: ,p_object_version_number => l_ovn

Line 2656: l_payroll_action_id pay_action_information.action_information1%TYPE;

2652: )
2653: IS
2654: --Variables needed for the report
2655: l_counter NUMBER := 0;
2656: l_payroll_action_id pay_action_information.action_information1%TYPE;
2657: --- Digits added for Break-up of Person Number and Date
2658: l_digit1 NUMBER(1);
2659: l_digit2 NUMBER(1);
2660: l_digit3 NUMBER(1);

Line 2676: csr_v_pa_id pay_action_information.action_context_id%TYPE

2672:
2673:
2674: --Cursors needed for report
2675: CURSOR csr_all_legal_employer (
2676: csr_v_pa_id pay_action_information.action_context_id%TYPE
2677: )
2678: IS
2679: SELECT action_information3
2680: ,action_information4

Line 2682: FROM pay_action_information

2678: IS
2679: SELECT action_information3
2680: ,action_information4
2681: ,action_information5
2682: FROM pay_action_information
2683: WHERE action_context_type = 'PA'
2684: AND action_context_id = csr_v_pa_id
2685: AND action_information_category = 'EMEA REPORT INFORMATION'
2686: AND action_information1 = 'PYSEWTCR'

Line 2690: csr_v_pa_id pay_action_information.action_context_id%TYPE

2686: AND action_information1 = 'PYSEWTCR'
2687: AND action_information2 = 'LE';
2688:
2689: CURSOR csr_wtc_person1 (
2690: csr_v_pa_id pay_action_information.action_context_id%TYPE
2691: )
2692: IS
2693: SELECT action_information3 person_number
2694: ,action_information4 emp_last_name

Line 2738: FROM pay_action_information

2734: ,action_information17 employees_request
2735: ,action_information18 termination_reason
2736: ,action_information19 absence_percentage
2737: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information20),'YYYYMMDD'))employment_end_date
2738: FROM pay_action_information
2739: WHERE action_context_type = 'PA'
2740: AND action_context_id = csr_v_pa_id
2741: AND action_information_category = 'EMEA REPORT INFORMATION'
2742: AND action_information1 = 'PYSEWTCA'

Line 2746: csr_v_pa_id pay_action_information.action_context_id%TYPE

2742: AND action_information1 = 'PYSEWTCA'
2743: AND action_information2 = 'WTC_PERSON1';
2744:
2745: CURSOR csr_wtc_person2 (
2746: csr_v_pa_id pay_action_information.action_context_id%TYPE
2747: )
2748: IS
2749: SELECT action_information3 continuous_offer
2750: ,action_information4 permanent_check

Line 2803: FROM pay_action_information

2799: ,action_information22 paid_sick_leave_days
2800: ,action_information23 teaching_load
2801: ,action_information24 aggrmnt_of_compn_signed --EOY 2008
2802: ,action_information26 teaching_load_check_box -- EOY 2008
2803: FROM pay_action_information
2804: WHERE action_context_type = 'PA'
2805: AND action_context_id = csr_v_pa_id
2806: AND action_information_category = 'EMEA REPORT INFORMATION'
2807: AND action_information1 = 'PYSEWTCA'

Line 2811: csr_v_pa_id pay_action_information.action_context_id%TYPE

2807: AND action_information1 = 'PYSEWTCA'
2808: AND action_information2 = 'WTC_PERSON2';
2809:
2810: CURSOR csr_wtc_person3 (
2811: csr_v_pa_id pay_action_information.action_context_id%TYPE
2812: )
2813: IS
2814: SELECT action_information3 assign_full_time
2815: ,action_information4 assign_hours_week

Line 2830: FROM pay_action_information

2826: ,action_information15 emp_with_holiday_pay
2827: ,action_information16 paid_days_off_duty_time
2828: ,action_information17 employed_educational_assoc
2829: ,action_information18 holiday_pay_amount
2830: FROM pay_action_information
2831: WHERE action_context_type = 'PA'
2832: AND action_context_id = csr_v_pa_id
2833: AND action_information_category = 'EMEA REPORT INFORMATION'
2834: AND action_information1 = 'PYSEWTCA'

Line 2838: csr_v_pa_id pay_action_information.action_context_id%TYPE

2834: AND action_information1 = 'PYSEWTCA'
2835: AND action_information2 = 'WTC_PERSON3';
2836:
2837: CURSOR csr_wtc_person4 (
2838: csr_v_pa_id pay_action_information.action_context_id%TYPE
2839: )
2840: IS
2841: SELECT action_information3 holiday_duty
2842: ,action_information4 lay_off_period_paid_days

Line 2875: FROM pay_action_information

2871: ,action_information21 hourly_pay_variable
2872: ,action_information22 hourly_overtime_rate
2873: ,action_information23 hourly_addl_suppl_time
2874: ,action_information24 other_taxable_compensation
2875: FROM pay_action_information
2876: WHERE action_context_type = 'PA'
2877: AND action_context_id = csr_v_pa_id
2878: AND action_information_category = 'EMEA REPORT INFORMATION'
2879: AND action_information1 = 'PYSEWTCA'

Line 2883: csr_v_pa_id pay_action_information.action_context_id%TYPE

2879: AND action_information1 = 'PYSEWTCA'
2880: AND action_information2 = 'WTC_PERSON4';
2881:
2882: CURSOR csr_wtc_get_group (
2883: csr_v_pa_id pay_action_information.action_context_id%TYPE
2884: )
2885: IS
2886: SELECT action_information28 GROUP_ID
2887: FROM pay_action_information

Line 2887: FROM pay_action_information

2883: csr_v_pa_id pay_action_information.action_context_id%TYPE
2884: )
2885: IS
2886: SELECT action_information28 GROUP_ID
2887: FROM pay_action_information
2888: WHERE action_context_type = 'PA'
2889: AND action_context_id = csr_v_pa_id
2890: AND action_information_category = 'EMEA REPORT INFORMATION'
2891: AND action_information1 = 'PYSEWTCA'

Line 2896: csr_v_pa_id pay_action_information.action_context_id%TYPE

2892: AND action_information2 = 'WTC_PERSON5'
2893: GROUP BY action_information28;
2894:
2895: CURSOR csr_wtc_get_month_value (
2896: csr_v_pa_id pay_action_information.action_context_id%TYPE
2897: ,csr_v_group_id pay_action_information.action_information28%TYPE
2898: )
2899: IS
2900: SELECT ROWNUM

Line 2897: ,csr_v_group_id pay_action_information.action_information28%TYPE

2893: GROUP BY action_information28;
2894:
2895: CURSOR csr_wtc_get_month_value (
2896: csr_v_pa_id pay_action_information.action_context_id%TYPE
2897: ,csr_v_group_id pay_action_information.action_information28%TYPE
2898: )
2899: IS
2900: SELECT ROWNUM
2901: ,action_information3 jan_days

Line 2926: FROM pay_action_information

2922: ,action_information24 sep_hours
2923: ,action_information25 oct_hours
2924: ,action_information26 nov_hours
2925: ,action_information27 dec_hours
2926: FROM pay_action_information
2927: WHERE action_context_type = 'PA'
2928: AND action_context_id = csr_v_pa_id
2929: AND action_information_category = 'EMEA REPORT INFORMATION'
2930: AND action_information1 = 'PYSEWTCA'

Line 2935: csr_v_pa_id pay_action_information.action_context_id%TYPE

2931: AND action_information2 = 'WTC_PERSON5'
2932: AND action_information28 = csr_v_group_id;
2933:
2934: CURSOR csr_report_details (
2935: csr_v_pa_id pay_action_information.action_context_id%TYPE
2936: )
2937: IS
2938: SELECT action_information2 rpt_person_id
2939: ,action_information3 rpt_assignment_id

Line 2942: FROM pay_action_information

2938: SELECT action_information2 rpt_person_id
2939: ,action_information3 rpt_assignment_id
2940: ,action_information4 rpt_still_employed
2941: ,action_information5 rpt_business_group_id
2942: FROM pay_action_information
2943: WHERE action_context_type = 'PA'
2944: AND action_context_id = csr_v_pa_id
2945: AND action_information_category = 'EMEA REPORT DETAILS'
2946: AND action_information1 = 'PYSEWTCA';

Line 2957: csr_v_pa_id pay_action_information.action_information3%TYPE

2953: lr_wtc_get_group csr_wtc_get_group%ROWTYPE;
2954: lr_wtc_get_month_value csr_wtc_get_month_value%ROWTYPE;
2955:
2956: CURSOR csr_all_employees_under_le (
2957: csr_v_pa_id pay_action_information.action_information3%TYPE
2958: ,csr_v_le_id pay_action_information.action_information15%TYPE
2959: )
2960: IS
2961: SELECT *

Line 2958: ,csr_v_le_id pay_action_information.action_information15%TYPE

2954: lr_wtc_get_month_value csr_wtc_get_month_value%ROWTYPE;
2955:
2956: CURSOR csr_all_employees_under_le (
2957: csr_v_pa_id pay_action_information.action_information3%TYPE
2958: ,csr_v_le_id pay_action_information.action_information15%TYPE
2959: )
2960: IS
2961: SELECT *
2962: FROM pay_action_information

Line 2962: FROM pay_action_information

2958: ,csr_v_le_id pay_action_information.action_information15%TYPE
2959: )
2960: IS
2961: SELECT *
2962: FROM pay_action_information
2963: WHERE action_context_type = 'AAP'
2964: AND action_information_category = 'EMEA REPORT INFORMATION'
2965: AND action_information1 = 'PYSEWTCR'
2966: AND action_information3 = csr_v_pa_id

Line 2979: csr_v_pa_id pay_action_information.action_context_id%TYPE

2975: -- *****************************************************************************
2976: -- Add Individual Months Overtime and Addl/Supplemtary hours
2977: -- *****************************************************************************
2978: CURSOR csr_wtc_get_ovr_addl_val (
2979: csr_v_pa_id pay_action_information.action_context_id%TYPE
2980: ,csr_v_group_id pay_action_information.action_information28%TYPE
2981: )
2982: IS
2983: SELECT ROWNUM

Line 2980: ,csr_v_group_id pay_action_information.action_information28%TYPE

2976: -- Add Individual Months Overtime and Addl/Supplemtary hours
2977: -- *****************************************************************************
2978: CURSOR csr_wtc_get_ovr_addl_val (
2979: csr_v_pa_id pay_action_information.action_context_id%TYPE
2980: ,csr_v_group_id pay_action_information.action_information28%TYPE
2981: )
2982: IS
2983: SELECT ROWNUM
2984: ,action_information3 jan_addl_time

Line 3009: FROM pay_action_information

3005: ,action_information24 sep_overtime
3006: ,action_information25 oct_overtime
3007: ,action_information26 nov_overtime
3008: ,action_information27 dec_overtime
3009: FROM pay_action_information
3010: WHERE action_context_type = 'PA'
3011: AND action_context_id = csr_v_pa_id
3012: AND action_information_category = 'EMEA REPORT INFORMATION'
3013: AND action_information1 = 'PYSEWTCA'

Line 3024: csr_v_pa_id pay_action_information.action_context_id%TYPE

3020: -- *****************************************************************************
3021: -- Add Individual Months Absence hours
3022: -- *****************************************************************************
3023: CURSOR csr_wtc_get_absence_val (
3024: csr_v_pa_id pay_action_information.action_context_id%TYPE
3025: ,csr_v_group_id pay_action_information.action_information28%TYPE
3026: )
3027: IS
3028: SELECT ROWNUM

Line 3025: ,csr_v_group_id pay_action_information.action_information28%TYPE

3021: -- Add Individual Months Absence hours
3022: -- *****************************************************************************
3023: CURSOR csr_wtc_get_absence_val (
3024: csr_v_pa_id pay_action_information.action_context_id%TYPE
3025: ,csr_v_group_id pay_action_information.action_information28%TYPE
3026: )
3027: IS
3028: SELECT ROWNUM
3029: ,action_information3 jan_absence_time

Line 3042: FROM pay_action_information

3038: ,action_information12 oct_absence_time
3039: ,action_information13 nov_absence_time
3040: ,action_information14 dec_absence_time
3041: ,action_information15 YEAR
3042: FROM pay_action_information
3043: WHERE action_context_type = 'PA'
3044: AND action_context_id = csr_v_pa_id
3045: AND action_information_category = 'EMEA REPORT INFORMATION'
3046: AND action_information1 = 'PYSEWTCA'