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.

[Home] [Help]

APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on PAY_ACTION_INFORMATION

Line 1693: pay_action_information_api.create_action_information

1689: -- *****************************************************************************
1690: -- *****************************************************************************
1691:
1692: -- Insert the report Parameters
1693: pay_action_information_api.create_action_information
1694: (p_action_information_id => l_action_info_id
1695: ,p_action_context_id => p_payroll_action_id
1696: ,p_action_context_type => 'PA'
1697: ,p_object_version_number => l_ovn

Line 1713: pay_action_information_api.create_action_information

1709: ,p_action_information8 => NULL
1710: ,p_action_information9 => NULL
1711: ,p_action_information10 => NULL
1712: );
1713: pay_action_information_api.create_action_information
1714: (p_action_information_id => l_action_info_id
1715: ,p_action_context_id => p_payroll_action_id
1716: ,p_action_context_type => 'PA'
1717: ,p_object_version_number => l_ovn

Line 1756: pay_action_information_api.create_action_information

1752: ,p_action_information29 => NULL
1753: ,p_action_information30 => g_person_id
1754: ,p_assignment_id => g_assignment_id
1755: );
1756: pay_action_information_api.create_action_information
1757: (p_action_information_id => l_action_info_id
1758: ,p_action_context_id => p_payroll_action_id
1759: ,p_action_context_type => 'PA'
1760: ,p_object_version_number => l_ovn

Line 1803: pay_action_information_api.create_action_information

1799: ,p_action_information29 => NULL
1800: ,p_action_information30 => g_person_id
1801: ,p_assignment_id => g_assignment_id
1802: );
1803: pay_action_information_api.create_action_information
1804: (p_action_information_id => l_action_info_id
1805: ,p_action_context_id => p_payroll_action_id
1806: ,p_action_context_type => 'PA'
1807: ,p_object_version_number => l_ovn

Line 1844: pay_action_information_api.create_action_information

1840: ,p_action_information29 => NULL
1841: ,p_action_information30 => g_person_id
1842: ,p_assignment_id => g_assignment_id
1843: );
1844: pay_action_information_api.create_action_information
1845: (p_action_information_id => l_action_info_id
1846: ,p_action_context_id => p_payroll_action_id
1847: ,p_action_context_type => 'PA'
1848: ,p_object_version_number => l_ovn

Line 2055: pay_action_information_api.create_action_information

2051: l_set := l_set + 1;
2052: END IF;
2053:
2054:
2055: pay_action_information_api.create_action_information
2056: (p_action_information_id => l_action_info_id
2057: ,p_action_context_id => p_payroll_action_id
2058: ,p_action_context_type => 'PA'
2059: ,p_object_version_number => l_ovn

Line 2124: pay_action_information_api.create_action_information

2120:
2121:
2122:
2123: ------------------------------ Archive for Addl/Suplementary Hrs and Overtime Hours --------------
2124: pay_action_information_api.create_action_information
2125: (p_action_information_id => l_action_info_id
2126: ,p_action_context_id => p_payroll_action_id
2127: ,p_action_context_type => 'PA'
2128: ,p_object_version_number => l_ovn

Line 2193: pay_action_information_api.create_action_information

2189:
2190:
2191:
2192: ---------------------- Populate Absence Fields ---------------------------------------------
2193: pay_action_information_api.create_action_information
2194: (p_action_information_id => l_action_info_id
2195: ,p_action_context_id => p_payroll_action_id
2196: ,p_action_context_type => 'PA'
2197: ,p_object_version_number => l_ovn

Line 2696: l_payroll_action_id pay_action_information.action_information1%TYPE;

2692: )
2693: IS
2694: --Variables needed for the report
2695: l_counter NUMBER := 0;
2696: l_payroll_action_id pay_action_information.action_information1%TYPE;
2697: --- Digits added for Break-up of Person Number and Date
2698: l_digit1 NUMBER(1);
2699: l_digit2 NUMBER(1);
2700: l_digit3 NUMBER(1);

Line 2716: csr_v_pa_id pay_action_information.action_context_id%TYPE

2712:
2713:
2714: --Cursors needed for report
2715: CURSOR csr_all_legal_employer (
2716: csr_v_pa_id pay_action_information.action_context_id%TYPE
2717: )
2718: IS
2719: SELECT action_information3
2720: ,action_information4

Line 2722: FROM pay_action_information

2718: IS
2719: SELECT action_information3
2720: ,action_information4
2721: ,action_information5
2722: FROM pay_action_information
2723: WHERE action_context_type = 'PA'
2724: AND action_context_id = csr_v_pa_id
2725: AND action_information_category = 'EMEA REPORT INFORMATION'
2726: AND action_information1 = 'PYSEWTCR'

Line 2730: csr_v_pa_id pay_action_information.action_context_id%TYPE

2726: AND action_information1 = 'PYSEWTCR'
2727: AND action_information2 = 'LE';
2728:
2729: CURSOR csr_wtc_person1 (
2730: csr_v_pa_id pay_action_information.action_context_id%TYPE
2731: )
2732: IS
2733: SELECT action_information3 person_number
2734: ,action_information4 emp_last_name

Line 2778: FROM pay_action_information

2774: ,action_information17 employees_request
2775: ,action_information18 termination_reason
2776: ,action_information19 absence_percentage
2777: ,FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(action_information20),'YYYYMMDD'))employment_end_date
2778: FROM pay_action_information
2779: WHERE action_context_type = 'PA'
2780: AND action_context_id = csr_v_pa_id
2781: AND action_information_category = 'EMEA REPORT INFORMATION'
2782: AND action_information1 = 'PYSEWTCA'

Line 2786: csr_v_pa_id pay_action_information.action_context_id%TYPE

2782: AND action_information1 = 'PYSEWTCA'
2783: AND action_information2 = 'WTC_PERSON1';
2784:
2785: CURSOR csr_wtc_person2 (
2786: csr_v_pa_id pay_action_information.action_context_id%TYPE
2787: )
2788: IS
2789: SELECT action_information3 continuous_offer
2790: ,action_information4 permanent_check

Line 2843: FROM pay_action_information

2839: ,action_information22 paid_sick_leave_days
2840: ,action_information23 teaching_load
2841: ,action_information24 aggrmnt_of_compn_signed --EOY 2008
2842: ,action_information26 teaching_load_check_box -- EOY 2008
2843: FROM pay_action_information
2844: WHERE action_context_type = 'PA'
2845: AND action_context_id = csr_v_pa_id
2846: AND action_information_category = 'EMEA REPORT INFORMATION'
2847: AND action_information1 = 'PYSEWTCA'

Line 2851: csr_v_pa_id pay_action_information.action_context_id%TYPE

2847: AND action_information1 = 'PYSEWTCA'
2848: AND action_information2 = 'WTC_PERSON2';
2849:
2850: CURSOR csr_wtc_person3 (
2851: csr_v_pa_id pay_action_information.action_context_id%TYPE
2852: )
2853: IS
2854: SELECT action_information3 assign_full_time
2855: ,action_information4 assign_hours_week

Line 2870: FROM pay_action_information

2866: ,action_information15 emp_with_holiday_pay
2867: ,action_information16 paid_days_off_duty_time
2868: ,action_information17 employed_educational_assoc
2869: ,action_information18 holiday_pay_amount
2870: FROM pay_action_information
2871: WHERE action_context_type = 'PA'
2872: AND action_context_id = csr_v_pa_id
2873: AND action_information_category = 'EMEA REPORT INFORMATION'
2874: AND action_information1 = 'PYSEWTCA'

Line 2878: csr_v_pa_id pay_action_information.action_context_id%TYPE

2874: AND action_information1 = 'PYSEWTCA'
2875: AND action_information2 = 'WTC_PERSON3';
2876:
2877: CURSOR csr_wtc_person4 (
2878: csr_v_pa_id pay_action_information.action_context_id%TYPE
2879: )
2880: IS
2881: SELECT action_information3 holiday_duty
2882: ,action_information4 lay_off_period_paid_days

Line 2915: FROM pay_action_information

2911: ,action_information21 hourly_pay_variable
2912: ,action_information22 hourly_overtime_rate
2913: ,action_information23 hourly_addl_suppl_time
2914: ,action_information24 other_taxable_compensation
2915: FROM pay_action_information
2916: WHERE action_context_type = 'PA'
2917: AND action_context_id = csr_v_pa_id
2918: AND action_information_category = 'EMEA REPORT INFORMATION'
2919: AND action_information1 = 'PYSEWTCA'

Line 2923: csr_v_pa_id pay_action_information.action_context_id%TYPE

2919: AND action_information1 = 'PYSEWTCA'
2920: AND action_information2 = 'WTC_PERSON4';
2921:
2922: CURSOR csr_wtc_get_group (
2923: csr_v_pa_id pay_action_information.action_context_id%TYPE
2924: )
2925: IS
2926: SELECT action_information28 GROUP_ID
2927: FROM pay_action_information

Line 2927: FROM pay_action_information

2923: csr_v_pa_id pay_action_information.action_context_id%TYPE
2924: )
2925: IS
2926: SELECT action_information28 GROUP_ID
2927: FROM pay_action_information
2928: WHERE action_context_type = 'PA'
2929: AND action_context_id = csr_v_pa_id
2930: AND action_information_category = 'EMEA REPORT INFORMATION'
2931: AND action_information1 = 'PYSEWTCA'

Line 2936: csr_v_pa_id pay_action_information.action_context_id%TYPE

2932: AND action_information2 = 'WTC_PERSON5'
2933: GROUP BY action_information28;
2934:
2935: CURSOR csr_wtc_get_month_value (
2936: csr_v_pa_id pay_action_information.action_context_id%TYPE
2937: ,csr_v_group_id pay_action_information.action_information28%TYPE
2938: )
2939: IS
2940: SELECT ROWNUM

Line 2937: ,csr_v_group_id pay_action_information.action_information28%TYPE

2933: GROUP BY action_information28;
2934:
2935: CURSOR csr_wtc_get_month_value (
2936: csr_v_pa_id pay_action_information.action_context_id%TYPE
2937: ,csr_v_group_id pay_action_information.action_information28%TYPE
2938: )
2939: IS
2940: SELECT ROWNUM
2941: ,action_information3 jan_days

Line 2966: FROM pay_action_information

2962: ,action_information24 sep_hours
2963: ,action_information25 oct_hours
2964: ,action_information26 nov_hours
2965: ,action_information27 dec_hours
2966: FROM pay_action_information
2967: WHERE action_context_type = 'PA'
2968: AND action_context_id = csr_v_pa_id
2969: AND action_information_category = 'EMEA REPORT INFORMATION'
2970: AND action_information1 = 'PYSEWTCA'

Line 2975: csr_v_pa_id pay_action_information.action_context_id%TYPE

2971: AND action_information2 = 'WTC_PERSON5'
2972: AND action_information28 = csr_v_group_id;
2973:
2974: CURSOR csr_report_details (
2975: csr_v_pa_id pay_action_information.action_context_id%TYPE
2976: )
2977: IS
2978: SELECT action_information2 rpt_person_id
2979: ,action_information3 rpt_assignment_id

Line 2982: FROM pay_action_information

2978: SELECT action_information2 rpt_person_id
2979: ,action_information3 rpt_assignment_id
2980: ,action_information4 rpt_still_employed
2981: ,action_information5 rpt_business_group_id
2982: FROM pay_action_information
2983: WHERE action_context_type = 'PA'
2984: AND action_context_id = csr_v_pa_id
2985: AND action_information_category = 'EMEA REPORT DETAILS'
2986: AND action_information1 = 'PYSEWTCA';

Line 2997: csr_v_pa_id pay_action_information.action_information3%TYPE

2993: lr_wtc_get_group csr_wtc_get_group%ROWTYPE;
2994: lr_wtc_get_month_value csr_wtc_get_month_value%ROWTYPE;
2995:
2996: CURSOR csr_all_employees_under_le (
2997: csr_v_pa_id pay_action_information.action_information3%TYPE
2998: ,csr_v_le_id pay_action_information.action_information15%TYPE
2999: )
3000: IS
3001: SELECT *

Line 2998: ,csr_v_le_id pay_action_information.action_information15%TYPE

2994: lr_wtc_get_month_value csr_wtc_get_month_value%ROWTYPE;
2995:
2996: CURSOR csr_all_employees_under_le (
2997: csr_v_pa_id pay_action_information.action_information3%TYPE
2998: ,csr_v_le_id pay_action_information.action_information15%TYPE
2999: )
3000: IS
3001: SELECT *
3002: FROM pay_action_information

Line 3002: FROM pay_action_information

2998: ,csr_v_le_id pay_action_information.action_information15%TYPE
2999: )
3000: IS
3001: SELECT *
3002: FROM pay_action_information
3003: WHERE action_context_type = 'AAP'
3004: AND action_information_category = 'EMEA REPORT INFORMATION'
3005: AND action_information1 = 'PYSEWTCR'
3006: AND action_information3 = csr_v_pa_id

Line 3019: csr_v_pa_id pay_action_information.action_context_id%TYPE

3015: -- *****************************************************************************
3016: -- Add Individual Months Overtime and Addl/Supplemtary hours
3017: -- *****************************************************************************
3018: CURSOR csr_wtc_get_ovr_addl_val (
3019: csr_v_pa_id pay_action_information.action_context_id%TYPE
3020: ,csr_v_group_id pay_action_information.action_information28%TYPE
3021: )
3022: IS
3023: SELECT ROWNUM

Line 3020: ,csr_v_group_id pay_action_information.action_information28%TYPE

3016: -- Add Individual Months Overtime and Addl/Supplemtary hours
3017: -- *****************************************************************************
3018: CURSOR csr_wtc_get_ovr_addl_val (
3019: csr_v_pa_id pay_action_information.action_context_id%TYPE
3020: ,csr_v_group_id pay_action_information.action_information28%TYPE
3021: )
3022: IS
3023: SELECT ROWNUM
3024: ,action_information3 jan_addl_time

Line 3049: FROM pay_action_information

3045: ,action_information24 sep_overtime
3046: ,action_information25 oct_overtime
3047: ,action_information26 nov_overtime
3048: ,action_information27 dec_overtime
3049: FROM pay_action_information
3050: WHERE action_context_type = 'PA'
3051: AND action_context_id = csr_v_pa_id
3052: AND action_information_category = 'EMEA REPORT INFORMATION'
3053: AND action_information1 = 'PYSEWTCA'

Line 3064: csr_v_pa_id pay_action_information.action_context_id%TYPE

3060: -- *****************************************************************************
3061: -- Add Individual Months Absence hours
3062: -- *****************************************************************************
3063: CURSOR csr_wtc_get_absence_val (
3064: csr_v_pa_id pay_action_information.action_context_id%TYPE
3065: ,csr_v_group_id pay_action_information.action_information28%TYPE
3066: )
3067: IS
3068: SELECT ROWNUM

Line 3065: ,csr_v_group_id pay_action_information.action_information28%TYPE

3061: -- Add Individual Months Absence hours
3062: -- *****************************************************************************
3063: CURSOR csr_wtc_get_absence_val (
3064: csr_v_pa_id pay_action_information.action_context_id%TYPE
3065: ,csr_v_group_id pay_action_information.action_information28%TYPE
3066: )
3067: IS
3068: SELECT ROWNUM
3069: ,action_information3 jan_absence_time

Line 3082: FROM pay_action_information

3078: ,action_information12 oct_absence_time
3079: ,action_information13 nov_absence_time
3080: ,action_information14 dec_absence_time
3081: ,action_information15 YEAR
3082: FROM pay_action_information
3083: WHERE action_context_type = 'PA'
3084: AND action_context_id = csr_v_pa_id
3085: AND action_information_category = 'EMEA REPORT INFORMATION'
3086: AND action_information1 = 'PYSEWTCA'