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

Line 609: pay_action_information_api.create_action_information

605: l_receiver := lr_post_header.org_information2;
606: l_information_type := lr_post_header.org_information3;
607:
608: -- Insert the report Parameters
609: pay_action_information_api.create_action_information
610: (p_action_information_id => l_action_info_id
611: ,p_action_context_id => p_payroll_action_id
612: ,p_action_context_type => 'PA'
613: ,p_object_version_number => l_ovn

Line 636: pay_action_information_api.create_action_information

632: -- *****************************************************************************
633: -- Insert for Media Provider Details
634: -- *****************************************************************************
635: -- *****************************************************************************
636: pay_action_information_api.create_action_information
637: (p_action_information_id => l_action_info_id
638: ,p_action_context_id => p_payroll_action_id
639: ,p_action_context_type => 'PA'
640: ,p_object_version_number => l_ovn

Line 711: pay_action_information_api.create_action_information

707: --logger ('l_TOWN_OR_CITY', l_town_or_city);
708: --logger ('l_REGION_1', l_region_1);
709: --logger ('l_REGION_2', l_region_2);
710: --logger ('l_TERRITORY_SHORT_NAME', l_territory_short_name);
711: pay_action_information_api.create_action_information
712: (p_action_information_id => l_action_info_id
713: ,p_action_context_id => p_payroll_action_id
714: ,p_action_context_type => 'PA'
715: ,p_object_version_number => l_ovn

Line 771: pay_action_information_api.create_action_information

767: --logger ('l_TOWN_OR_CITY', l_town_or_city);
768: --logger ('l_REGION_1', l_region_1);
769: --logger ('l_REGION_2', l_region_2);
770: --logger ('l_TERRITORY_SHORT_NAME', l_territory_short_name);
771: pay_action_information_api.create_action_information
772: (p_action_information_id => l_action_info_id
773: ,p_action_context_id => p_payroll_action_id
774: ,p_action_context_type => 'PA'
775: ,p_object_version_number => l_ovn

Line 1799: l_action_info_id pay_action_information.action_information_id%TYPE;

1795: l_end_date per_time_periods.end_date%TYPE;
1796: l_date_earned pay_payroll_actions.date_earned%TYPE;
1797: l_effective_date pay_payroll_actions.effective_date%TYPE;
1798: l_start_date per_time_periods.start_date%TYPE;
1799: l_action_info_id pay_action_information.action_information_id%TYPE;
1800: l_ovn pay_action_information.object_version_number%TYPE;
1801: l_flag NUMBER := 0;
1802: -- The place for Variables which fetches the values to be archived
1803: l_employee_last_name VARCHAR2 (240);

Line 1800: l_ovn pay_action_information.object_version_number%TYPE;

1796: l_date_earned pay_payroll_actions.date_earned%TYPE;
1797: l_effective_date pay_payroll_actions.effective_date%TYPE;
1798: l_start_date per_time_periods.start_date%TYPE;
1799: l_action_info_id pay_action_information.action_information_id%TYPE;
1800: l_ovn pay_action_information.object_version_number%TYPE;
1801: l_flag NUMBER := 0;
1802: -- The place for Variables which fetches the values to be archived
1803: l_employee_last_name VARCHAR2 (240);
1804: l_employee_name VARCHAR2 (240);

Line 3737: FROM pay_action_information

3733: BEGIN
3734: /*
3735: SELECT 1
3736: INTO l_flag
3737: FROM pay_action_information
3738: WHERE action_information_category = 'EMEA REPORT INFORMATION'
3739: AND action_information1 = 'PYSEINSA'
3740: AND action_context_id = p_assignment_action_id;
3741: EXCEPTION

Line 3746: pay_action_information_api.create_action_information

3742: WHEN NO_DATA_FOUND
3743: THEN
3744: */
3745: --logger ('g_payroll_action_id', g_payroll_action_id);
3746: pay_action_information_api.create_action_information
3747: (p_action_information_id => l_action_info_id
3748: ,p_action_context_id => p_assignment_action_id
3749: ,p_action_context_type => 'AAP'
3750: ,p_object_version_number => l_ovn

Line 3789: pay_action_information_api.create_action_information

3785: ,p_assignment_id => l_assignment_id
3786: );
3787: --logger ('l_action_info_id', l_action_info_id);
3788:
3789: pay_action_information_api.create_action_information
3790: (p_action_information_id => l_action_info_id
3791: ,p_action_context_id => p_assignment_action_id
3792: ,p_action_context_type => 'AAP'
3793: ,p_object_version_number => l_ovn

Line 3836: pay_action_information_api.create_action_information

3832: ,p_action_information30 => l_person_id
3833: ,p_assignment_id => l_assignment_id
3834: );
3835: --logger ('l_action_info_id', l_action_info_id);
3836: pay_action_information_api.create_action_information
3837: (p_action_information_id => l_action_info_id
3838: ,p_action_context_id => p_assignment_action_id
3839: ,p_action_context_type => 'AAP'
3840: ,p_object_version_number => l_ovn

Line 3887: pay_action_information_api.create_action_information

3883: ,p_action_information30 => l_person_id
3884: ,p_assignment_id => l_assignment_id
3885: );
3886: --logger ('l_action_info_id', l_action_info_id);
3887: pay_action_information_api.create_action_information
3888: (p_action_information_id => l_action_info_id
3889: ,p_action_context_id => p_assignment_action_id
3890: ,p_action_context_type => 'AAP'
3891: ,p_object_version_number => l_ovn

Line 4114: l_payroll_action_id pay_action_information.action_information1%TYPE;

4110: )
4111: IS
4112: --Variables needed for the report
4113: l_counter NUMBER := 0;
4114: l_payroll_action_id pay_action_information.action_information1%TYPE;
4115:
4116: --Cursors needed for report
4117: CURSOR csr_all_legal_employer (
4118: csr_v_pa_id pay_action_information.action_context_id%TYPE

Line 4118: csr_v_pa_id pay_action_information.action_context_id%TYPE

4114: l_payroll_action_id pay_action_information.action_information1%TYPE;
4115:
4116: --Cursors needed for report
4117: CURSOR csr_all_legal_employer (
4118: csr_v_pa_id pay_action_information.action_context_id%TYPE
4119: )
4120: IS
4121: SELECT *
4122: FROM pay_action_information

Line 4122: FROM pay_action_information

4118: csr_v_pa_id pay_action_information.action_context_id%TYPE
4119: )
4120: IS
4121: SELECT *
4122: FROM pay_action_information
4123: WHERE action_context_type = 'PA'
4124: AND action_context_id = csr_v_pa_id
4125: AND action_information_category = 'EMEA REPORT INFORMATION'
4126: AND action_information1 = 'PYSEINSA'

Line 4130: csr_v_pa_id pay_action_information.action_context_id%TYPE

4126: AND action_information1 = 'PYSEINSA'
4127: AND action_information2 = 'LE';
4128:
4129: CURSOR csr_media_provider (
4130: csr_v_pa_id pay_action_information.action_context_id%TYPE
4131: )
4132: IS
4133: SELECT *
4134: FROM pay_action_information

Line 4134: FROM pay_action_information

4130: csr_v_pa_id pay_action_information.action_context_id%TYPE
4131: )
4132: IS
4133: SELECT *
4134: FROM pay_action_information
4135: WHERE action_context_type = 'PA'
4136: AND action_context_id = csr_v_pa_id
4137: AND action_information_category = 'EMEA REPORT INFORMATION'
4138: AND action_information1 = 'PYSEINSA'

Line 4144: csr_v_pa_id pay_action_information.action_context_id%TYPE

4140:
4141: lr_media_provider csr_media_provider%ROWTYPE;
4142:
4143: CURSOR csr_report_details (
4144: csr_v_pa_id pay_action_information.action_context_id%TYPE
4145: )
4146: IS
4147: SELECT *
4148: FROM pay_action_information

Line 4148: FROM pay_action_information

4144: csr_v_pa_id pay_action_information.action_context_id%TYPE
4145: )
4146: IS
4147: SELECT *
4148: FROM pay_action_information
4149: WHERE action_context_type = 'PA'
4150: AND action_context_id = csr_v_pa_id
4151: AND action_information_category = 'EMEA REPORT DETAILS'
4152: AND action_information1 = 'PYSEINSA';

Line 4157: csr_v_pa_id pay_action_information.action_information3%TYPE

4153:
4154: lr_report_details csr_report_details%ROWTYPE;
4155:
4156: CURSOR csr_all_employees_under_le (
4157: csr_v_pa_id pay_action_information.action_information3%TYPE
4158: ,csr_v_le_id pay_action_information.action_information15%TYPE
4159: ,csr_v_stmt_type pay_action_information.action_information4%TYPE
4160: ,csr_v_sort_order pay_action_information.action_information4%TYPE
4161: )

Line 4158: ,csr_v_le_id pay_action_information.action_information15%TYPE

4154: lr_report_details csr_report_details%ROWTYPE;
4155:
4156: CURSOR csr_all_employees_under_le (
4157: csr_v_pa_id pay_action_information.action_information3%TYPE
4158: ,csr_v_le_id pay_action_information.action_information15%TYPE
4159: ,csr_v_stmt_type pay_action_information.action_information4%TYPE
4160: ,csr_v_sort_order pay_action_information.action_information4%TYPE
4161: )
4162: IS

Line 4159: ,csr_v_stmt_type pay_action_information.action_information4%TYPE

4155:
4156: CURSOR csr_all_employees_under_le (
4157: csr_v_pa_id pay_action_information.action_information3%TYPE
4158: ,csr_v_le_id pay_action_information.action_information15%TYPE
4159: ,csr_v_stmt_type pay_action_information.action_information4%TYPE
4160: ,csr_v_sort_order pay_action_information.action_information4%TYPE
4161: )
4162: IS
4163: SELECT *

Line 4160: ,csr_v_sort_order pay_action_information.action_information4%TYPE

4156: CURSOR csr_all_employees_under_le (
4157: csr_v_pa_id pay_action_information.action_information3%TYPE
4158: ,csr_v_le_id pay_action_information.action_information15%TYPE
4159: ,csr_v_stmt_type pay_action_information.action_information4%TYPE
4160: ,csr_v_sort_order pay_action_information.action_information4%TYPE
4161: )
4162: IS
4163: SELECT *
4164: FROM pay_action_information

Line 4164: FROM pay_action_information

4160: ,csr_v_sort_order pay_action_information.action_information4%TYPE
4161: )
4162: IS
4163: SELECT *
4164: FROM pay_action_information
4165: WHERE action_context_type = 'AAP'
4166: AND action_information_category = 'EMEA REPORT INFORMATION'
4167: AND action_information1 = 'PYSEINSA'
4168: AND action_information2 = 'PERSON'

Line 4179: csr_v_record pay_action_information.action_information3%TYPE

4175: ,'EMPLAN',action_information7
4176: );
4177:
4178: CURSOR csr_get_person (
4179: csr_v_record pay_action_information.action_information3%TYPE
4180: ,csr_v_pa_id pay_action_information.action_information3%TYPE
4181: ,csr_v_person_id pay_action_information.action_information30%TYPE
4182: )
4183: IS

Line 4180: ,csr_v_pa_id pay_action_information.action_information3%TYPE

4176: );
4177:
4178: CURSOR csr_get_person (
4179: csr_v_record pay_action_information.action_information3%TYPE
4180: ,csr_v_pa_id pay_action_information.action_information3%TYPE
4181: ,csr_v_person_id pay_action_information.action_information30%TYPE
4182: )
4183: IS
4184: SELECT *

Line 4181: ,csr_v_person_id pay_action_information.action_information30%TYPE

4177:
4178: CURSOR csr_get_person (
4179: csr_v_record pay_action_information.action_information3%TYPE
4180: ,csr_v_pa_id pay_action_information.action_information3%TYPE
4181: ,csr_v_person_id pay_action_information.action_information30%TYPE
4182: )
4183: IS
4184: SELECT *
4185: FROM pay_action_information

Line 4185: FROM pay_action_information

4181: ,csr_v_person_id pay_action_information.action_information30%TYPE
4182: )
4183: IS
4184: SELECT *
4185: FROM pay_action_information
4186: WHERE action_context_type = 'AAP'
4187: AND action_information_category = 'EMEA REPORT INFORMATION'
4188: AND action_information1 = 'PYSEINSA'
4189: AND action_information2 = csr_v_record