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 611: pay_action_information_api.create_action_information

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

Line 638: pay_action_information_api.create_action_information

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

Line 715: pay_action_information_api.create_action_information

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

Line 777: pay_action_information_api.create_action_information

773: --logger ('l_TOWN_OR_CITY', l_town_or_city);
774: --logger ('l_REGION_1', l_region_1);
775: --logger ('l_REGION_2', l_region_2);
776: --logger ('l_TERRITORY_SHORT_NAME', l_territory_short_name);
777: pay_action_information_api.create_action_information
778: (p_action_information_id => l_action_info_id
779: ,p_action_context_id => p_payroll_action_id
780: ,p_action_context_type => 'PA'
781: ,p_object_version_number => l_ovn

Line 1805: l_action_info_id pay_action_information.action_information_id%TYPE;

1801: l_end_date per_time_periods.end_date%TYPE;
1802: l_date_earned pay_payroll_actions.date_earned%TYPE;
1803: l_effective_date pay_payroll_actions.effective_date%TYPE;
1804: l_start_date per_time_periods.start_date%TYPE;
1805: l_action_info_id pay_action_information.action_information_id%TYPE;
1806: l_ovn pay_action_information.object_version_number%TYPE;
1807: l_flag NUMBER := 0;
1808: -- The place for Variables which fetches the values to be archived
1809: l_employee_last_name VARCHAR2 (240);

Line 1806: l_ovn pay_action_information.object_version_number%TYPE;

1802: l_date_earned pay_payroll_actions.date_earned%TYPE;
1803: l_effective_date pay_payroll_actions.effective_date%TYPE;
1804: l_start_date per_time_periods.start_date%TYPE;
1805: l_action_info_id pay_action_information.action_information_id%TYPE;
1806: l_ovn pay_action_information.object_version_number%TYPE;
1807: l_flag NUMBER := 0;
1808: -- The place for Variables which fetches the values to be archived
1809: l_employee_last_name VARCHAR2 (240);
1810: l_employee_name VARCHAR2 (240);

Line 3941: FROM pay_action_information

3937: BEGIN
3938: /*
3939: SELECT 1
3940: INTO l_flag
3941: FROM pay_action_information
3942: WHERE action_information_category = 'EMEA REPORT INFORMATION'
3943: AND action_information1 = 'PYSEINSA'
3944: AND action_context_id = p_assignment_action_id;
3945: EXCEPTION

Line 3950: pay_action_information_api.create_action_information

3946: WHEN NO_DATA_FOUND
3947: THEN
3948: */
3949: --logger ('g_payroll_action_id', g_payroll_action_id);
3950: pay_action_information_api.create_action_information
3951: (p_action_information_id => l_action_info_id
3952: ,p_action_context_id => p_assignment_action_id
3953: ,p_action_context_type => 'AAP'
3954: ,p_object_version_number => l_ovn

Line 3993: pay_action_information_api.create_action_information

3989: ,p_assignment_id => l_assignment_id
3990: );
3991: --logger ('l_action_info_id', l_action_info_id);
3992:
3993: pay_action_information_api.create_action_information
3994: (p_action_information_id => l_action_info_id
3995: ,p_action_context_id => p_assignment_action_id
3996: ,p_action_context_type => 'AAP'
3997: ,p_object_version_number => l_ovn

Line 4040: pay_action_information_api.create_action_information

4036: ,p_action_information30 => l_person_id
4037: ,p_assignment_id => l_assignment_id
4038: );
4039: --logger ('l_action_info_id', l_action_info_id);
4040: pay_action_information_api.create_action_information
4041: (p_action_information_id => l_action_info_id
4042: ,p_action_context_id => p_assignment_action_id
4043: ,p_action_context_type => 'AAP'
4044: ,p_object_version_number => l_ovn

Line 4093: pay_action_information_api.create_action_information

4089: ,p_action_information30 => l_person_id
4090: ,p_assignment_id => l_assignment_id
4091: );
4092: --logger ('l_action_info_id', l_action_info_id);
4093: pay_action_information_api.create_action_information
4094: (p_action_information_id => l_action_info_id
4095: ,p_action_context_id => p_assignment_action_id
4096: ,p_action_context_type => 'AAP'
4097: ,p_object_version_number => l_ovn

Line 4322: l_payroll_action_id pay_action_information.action_information1%TYPE;

4318: )
4319: IS
4320: --Variables needed for the report
4321: l_counter NUMBER := 0;
4322: l_payroll_action_id pay_action_information.action_information1%TYPE;
4323:
4324: --Cursors needed for report
4325: CURSOR csr_all_legal_employer (
4326: csr_v_pa_id pay_action_information.action_context_id%TYPE

Line 4326: csr_v_pa_id pay_action_information.action_context_id%TYPE

4322: l_payroll_action_id pay_action_information.action_information1%TYPE;
4323:
4324: --Cursors needed for report
4325: CURSOR csr_all_legal_employer (
4326: csr_v_pa_id pay_action_information.action_context_id%TYPE
4327: )
4328: IS
4329: SELECT *
4330: FROM pay_action_information

Line 4330: FROM pay_action_information

4326: csr_v_pa_id pay_action_information.action_context_id%TYPE
4327: )
4328: IS
4329: SELECT *
4330: FROM pay_action_information
4331: WHERE action_context_type = 'PA'
4332: AND action_context_id = csr_v_pa_id
4333: AND action_information_category = 'EMEA REPORT INFORMATION'
4334: AND action_information1 = 'PYSEINSA'

Line 4338: csr_v_pa_id pay_action_information.action_context_id%TYPE

4334: AND action_information1 = 'PYSEINSA'
4335: AND action_information2 = 'LE';
4336:
4337: CURSOR csr_media_provider (
4338: csr_v_pa_id pay_action_information.action_context_id%TYPE
4339: )
4340: IS
4341: SELECT *
4342: FROM pay_action_information

Line 4342: FROM pay_action_information

4338: csr_v_pa_id pay_action_information.action_context_id%TYPE
4339: )
4340: IS
4341: SELECT *
4342: FROM pay_action_information
4343: WHERE action_context_type = 'PA'
4344: AND action_context_id = csr_v_pa_id
4345: AND action_information_category = 'EMEA REPORT INFORMATION'
4346: AND action_information1 = 'PYSEINSA'

Line 4352: csr_v_pa_id pay_action_information.action_context_id%TYPE

4348:
4349: lr_media_provider csr_media_provider%ROWTYPE;
4350:
4351: CURSOR csr_report_details (
4352: csr_v_pa_id pay_action_information.action_context_id%TYPE
4353: )
4354: IS
4355: SELECT *
4356: FROM pay_action_information

Line 4356: FROM pay_action_information

4352: csr_v_pa_id pay_action_information.action_context_id%TYPE
4353: )
4354: IS
4355: SELECT *
4356: FROM pay_action_information
4357: WHERE action_context_type = 'PA'
4358: AND action_context_id = csr_v_pa_id
4359: AND action_information_category = 'EMEA REPORT DETAILS'
4360: AND action_information1 = 'PYSEINSA';

Line 4365: csr_v_pa_id pay_action_information.action_information3%TYPE

4361:
4362: lr_report_details csr_report_details%ROWTYPE;
4363:
4364: CURSOR csr_all_employees_under_le (
4365: csr_v_pa_id pay_action_information.action_information3%TYPE
4366: ,csr_v_le_id pay_action_information.action_information15%TYPE
4367: ,csr_v_stmt_type pay_action_information.action_information4%TYPE
4368: ,csr_v_sort_order pay_action_information.action_information4%TYPE
4369: )

Line 4366: ,csr_v_le_id pay_action_information.action_information15%TYPE

4362: lr_report_details csr_report_details%ROWTYPE;
4363:
4364: CURSOR csr_all_employees_under_le (
4365: csr_v_pa_id pay_action_information.action_information3%TYPE
4366: ,csr_v_le_id pay_action_information.action_information15%TYPE
4367: ,csr_v_stmt_type pay_action_information.action_information4%TYPE
4368: ,csr_v_sort_order pay_action_information.action_information4%TYPE
4369: )
4370: IS

Line 4367: ,csr_v_stmt_type pay_action_information.action_information4%TYPE

4363:
4364: CURSOR csr_all_employees_under_le (
4365: csr_v_pa_id pay_action_information.action_information3%TYPE
4366: ,csr_v_le_id pay_action_information.action_information15%TYPE
4367: ,csr_v_stmt_type pay_action_information.action_information4%TYPE
4368: ,csr_v_sort_order pay_action_information.action_information4%TYPE
4369: )
4370: IS
4371: SELECT *

Line 4368: ,csr_v_sort_order pay_action_information.action_information4%TYPE

4364: CURSOR csr_all_employees_under_le (
4365: csr_v_pa_id pay_action_information.action_information3%TYPE
4366: ,csr_v_le_id pay_action_information.action_information15%TYPE
4367: ,csr_v_stmt_type pay_action_information.action_information4%TYPE
4368: ,csr_v_sort_order pay_action_information.action_information4%TYPE
4369: )
4370: IS
4371: SELECT *
4372: FROM pay_action_information

Line 4372: FROM pay_action_information

4368: ,csr_v_sort_order pay_action_information.action_information4%TYPE
4369: )
4370: IS
4371: SELECT *
4372: FROM pay_action_information
4373: WHERE action_context_type = 'AAP'
4374: AND action_information_category = 'EMEA REPORT INFORMATION'
4375: AND action_information1 = 'PYSEINSA'
4376: AND action_information2 = 'PERSON'

Line 4387: csr_v_record pay_action_information.action_information3%TYPE

4383: ,'EMPLAN',action_information7
4384: );
4385:
4386: CURSOR csr_get_person (
4387: csr_v_record pay_action_information.action_information3%TYPE
4388: ,csr_v_pa_id pay_action_information.action_information3%TYPE
4389: ,csr_v_person_id pay_action_information.action_information30%TYPE
4390: )
4391: IS

Line 4388: ,csr_v_pa_id pay_action_information.action_information3%TYPE

4384: );
4385:
4386: CURSOR csr_get_person (
4387: csr_v_record pay_action_information.action_information3%TYPE
4388: ,csr_v_pa_id pay_action_information.action_information3%TYPE
4389: ,csr_v_person_id pay_action_information.action_information30%TYPE
4390: )
4391: IS
4392: SELECT *

Line 4389: ,csr_v_person_id pay_action_information.action_information30%TYPE

4385:
4386: CURSOR csr_get_person (
4387: csr_v_record pay_action_information.action_information3%TYPE
4388: ,csr_v_pa_id pay_action_information.action_information3%TYPE
4389: ,csr_v_person_id pay_action_information.action_information30%TYPE
4390: )
4391: IS
4392: SELECT *
4393: FROM pay_action_information

Line 4393: FROM pay_action_information

4389: ,csr_v_person_id pay_action_information.action_information30%TYPE
4390: )
4391: IS
4392: SELECT *
4393: FROM pay_action_information
4394: WHERE action_context_type = 'AAP'
4395: AND action_information_category = 'EMEA REPORT INFORMATION'
4396: AND action_information1 = 'PYSEINSA'
4397: AND action_information2 = csr_v_record