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

Line 164: ,pay_action_information ref_actinfo

160:
161: CURSOR c_existing_archive (p_company_id_chr in varchar2) is
162: SELECT payact.payroll_action_id
163: FROM pay_payroll_actions payact
164: ,pay_action_information ref_actinfo
165: WHERE payact.payroll_action_id = ref_actinfo.action_context_id
166: and ref_actinfo.action_information_category = 'FR_DUCS_REFERENCE_INFO'
167: and ref_actinfo.action_context_type = 'PA'
168: and ref_actinfo.action_information1 = p_company_id_chr

Line 367: , pay_action_information actinfo

363: CURSOR csr_locking_archive(p_run_act_id number) is
364: SELECT /*+ ORDERED */ 1
365: FROM pay_action_interlocks plock
366: , pay_assignment_actions assact
367: , pay_action_information actinfo
368: WHERE plock.locked_action_id = p_run_act_id
369: AND plock.locking_action_id = assact.assignment_action_id
370: AND assact.payroll_action_id = actinfo.action_context_id
371: AND actinfo.action_context_type = 'PA'

Line 674: l_action_info_id pay_action_information.action_information_id%TYPE;

670: l_page_type pay_run_result_values.result_value%TYPE;
671: l_subpage_identifier varchar2(150);
672:
673:
674: l_action_info_id pay_action_information.action_information_id%TYPE;
675: l_ovn pay_action_information.object_version_number%TYPE;
676:
677:
678: l_rate_type pay_fr_contribution_usages.RATE_TYPE%TYPE;

Line 675: l_ovn pay_action_information.object_version_number%TYPE;

671: l_subpage_identifier varchar2(150);
672:
673:
674: l_action_info_id pay_action_information.action_information_id%TYPE;
675: l_ovn pay_action_information.object_version_number%TYPE;
676:
677:
678: l_rate_type pay_fr_contribution_usages.RATE_TYPE%TYPE;
679:

Line 887: pay_action_information_api.create_action_information (

883: END IF;
884: l_subpage_identifier := g_estab_pens_provs.pens_provs(l_Order_Number);
885: END IF;
886:
887: pay_action_information_api.create_action_information (
888: p_action_information_id => l_action_info_id
889: , p_action_context_id => p_assignment_action_id
890: , p_action_context_type => 'AAP'
891: , p_object_version_number => l_ovn

Line 993: l_page_id_chr pay_action_information.action_information1%TYPE:=

989: l_female_count number:=0;
990: l_total_count number:=0;
991: l_actions_count number:=0;
992: l_sex varchar2(2);
993: l_page_id_chr pay_action_information.action_information1%TYPE:=
994: fnd_number.number_to_canonical(p_page_identifier);
995:
996: CURSOR cur_per IS
997: SELECT distinct paa.person_id

Line 998: FROM pay_action_information pai

994: fnd_number.number_to_canonical(p_page_identifier);
995:
996: CURSOR cur_per IS
997: SELECT distinct paa.person_id
998: FROM pay_action_information pai
999: ,pay_assignment_actions pac
1000: ,per_all_assignments_f paa
1001: WHERE pac.payroll_action_id=p_payroll_action_id
1002: and pai.action_information_category = 'FR_DUCS_ACTION_CONTRIB_INFO'

Line 1016: FROM pay_action_information pai

1012:
1013: CURSOR cur_asg_count IS
1014: SELECT count(distinct pac.assignment_id),
1015: count(distinct pac.assignment_action_id)
1016: FROM pay_action_information pai
1017: ,pay_assignment_actions pac
1018: WHERE pac.payroll_action_id=p_payroll_action_id
1019: and pai.action_information_category = 'FR_DUCS_ACTION_CONTRIB_INFO'
1020: and pai.action_information1 = l_page_id_chr

Line 1146: l_contribution_text pay_action_information.action_information4%TYPE;

1142: l_organization_id varchar2(30);
1143: l_pension_provider varchar2(30);
1144: l_pension_provider_id varchar2(30);
1145:
1146: l_contribution_text pay_action_information.action_information4%TYPE;
1147: l_meaning varchar2(80);
1148: l_tag pay_action_information.action_information4%TYPE;
1149: l_pension_code varchar2(80);
1150: l_pay_value number;

Line 1148: l_tag pay_action_information.action_information4%TYPE;

1144: l_pension_provider_id varchar2(30);
1145:
1146: l_contribution_text pay_action_information.action_information4%TYPE;
1147: l_meaning varchar2(80);
1148: l_tag pay_action_information.action_information4%TYPE;
1149: l_pension_code varchar2(80);
1150: l_pay_value number;
1151:
1152: l_action_info_id pay_action_information.action_information_id%TYPE;

Line 1152: l_action_info_id pay_action_information.action_information_id%TYPE;

1148: l_tag pay_action_information.action_information4%TYPE;
1149: l_pension_code varchar2(80);
1150: l_pay_value number;
1151:
1152: l_action_info_id pay_action_information.action_information_id%TYPE;
1153: l_ovn pay_action_information.object_version_number%TYPE;
1154:
1155: --
1156: -- Cursors

Line 1153: l_ovn pay_action_information.object_version_number%TYPE;

1149: l_pension_code varchar2(80);
1150: l_pay_value number;
1151:
1152: l_action_info_id pay_action_information.action_information_id%TYPE;
1153: l_ovn pay_action_information.object_version_number%TYPE;
1154:
1155: --
1156: -- Cursors
1157: --

Line 1173: , pay_action_information contrib

1169: , fnd_number.canonical_to_number(contrib.action_information6) rate
1170: , sum(fnd_number.canonical_to_number(contrib.action_information7)) pay_value
1171: , count(distinct assact.assignment_id) number_of_employees
1172: FROM pay_assignment_actions assact
1173: , pay_action_information contrib
1174: WHERE
1175: assact.payroll_action_id in
1176: (SELECT payroll_action_id
1177: FROM pay_payroll_actions payact

Line 1178: , pay_action_information actinfo

1174: WHERE
1175: assact.payroll_action_id in
1176: (SELECT payroll_action_id
1177: FROM pay_payroll_actions payact
1178: , pay_action_information actinfo
1179: WHERE payact.effective_date between g_period_start_date
1180: and g_effective_date
1181: and payact.payroll_action_id = actinfo.action_context_id
1182: and actinfo.action_context_type = 'PA'

Line 1218: , pay_action_information contrib

1214: , sum(fnd_number.canonical_to_number(contrib.action_information7)) pay_value
1215: , count(distinct assact.assignment_id) number_of_employees
1216: FROM pay_payroll_actions payact
1217: , pay_assignment_actions assact
1218: , pay_action_information contrib
1219: WHERE assact.payroll_action_id = payact.payroll_action_id
1220: and payact.report_type = 'DUCS_ARCHIVE'
1221: and payact.report_qualifier = 'FR'
1222: and payact.report_category = 'DUCS_ARCHIVE'

Line 1310: pay_action_information_api.create_action_information (

1306:
1307: l_pay_value := round(l_pay_value,2);
1308:
1309:
1310: pay_action_information_api.create_action_information (
1311: p_action_information_id => l_action_info_id
1312: , p_action_context_id => p_payroll_action_id
1313: , p_action_context_type => 'PA'
1314: , p_object_version_number => l_ovn

Line 1412: pay_action_information_api.create_action_information (

1408: END IF;
1409:
1410: l_pay_value:=round(l_pay_value,2);
1411:
1412: pay_action_information_api.create_action_information (
1413: p_action_information_id => l_action_info_id
1414: , p_action_context_id => p_payroll_action_id
1415: , p_action_context_type => 'PA'
1416: , p_object_version_number => l_ovn

Line 1473: l_action_info_id pay_action_information.action_information_id%TYPE;

1469: l_currency varchar2(10);
1470: l_currency_code varchar2(10);
1471: l_currency_number varchar2(10);
1472:
1473: l_action_info_id pay_action_information.action_information_id%TYPE;
1474: l_ovn pay_action_information.object_version_number%TYPE;
1475:
1476: l_org_information_id number;
1477: l_object_version_number number;

Line 1474: l_ovn pay_action_information.object_version_number%TYPE;

1470: l_currency_code varchar2(10);
1471: l_currency_number varchar2(10);
1472:
1473: l_action_info_id pay_action_information.action_information_id%TYPE;
1474: l_ovn pay_action_information.object_version_number%TYPE;
1475:
1476: l_org_information_id number;
1477: l_object_version_number number;
1478:

Line 1519: ,pay_action_information ref_actinfo

1515:
1516: CURSOR c_existing_archive (p_company_id_chr in varchar2) is
1517: SELECT payact.payroll_action_id
1518: FROM pay_payroll_actions payact
1519: ,pay_action_information ref_actinfo
1520: WHERE payact.payroll_action_id = ref_actinfo.action_context_id
1521: and ref_actinfo.action_information_category = 'FR_DUCS_REFERENCE_INFO'
1522: and ref_actinfo.action_context_type = 'PA'
1523: and ref_actinfo.action_information1 = p_company_id_chr

Line 1792: DELETE FROM pay_action_information

1788: CLOSE c_existing_archive;
1789:
1790:
1791:
1792: DELETE FROM pay_action_information
1793: WHERE action_context_id = p_payroll_action_id
1794: and action_context_type = 'PA'
1795: and action_information_category IN
1796: ('FR_DUCS_COMP_INFO'

Line 1813: pay_action_information_api.create_action_information (

1809:
1810:
1811: FOR rec_company IN csr_company loop
1812:
1813: pay_action_information_api.create_action_information (
1814: p_action_information_id => l_action_info_id
1815: , p_action_context_id => p_payroll_action_id
1816: , p_action_context_type => 'PA'
1817: , p_object_version_number => l_ovn

Line 1838: -- Create a record in PAY_ACTION_INFORMATION --FR_DUCS_REFERENCE_INFO

1834: , p_action_information15 => rec_company.Activities_Suspended
1835: , p_action_information16 => rec_company.Keep_Account_Open);
1836:
1837:
1838: -- Create a record in PAY_ACTION_INFORMATION --FR_DUCS_REFERENCE_INFO
1839:
1840: pay_action_information_api.create_action_information (
1841: p_action_information_id => l_action_info_id
1842: , p_action_context_id => p_payroll_action_id

Line 1840: pay_action_information_api.create_action_information (

1836:
1837:
1838: -- Create a record in PAY_ACTION_INFORMATION --FR_DUCS_REFERENCE_INFO
1839:
1840: pay_action_information_api.create_action_information (
1841: p_action_information_id => l_action_info_id
1842: , p_action_context_id => p_payroll_action_id
1843: , p_action_context_type => 'PA'
1844: , p_object_version_number => l_ovn

Line 1867: pay_action_information_api.create_action_information (

1863:
1864: FOR rec_estab IN csr_estab(fnd_number.number_to_canonical(g_company_id))
1865: LOOP
1866:
1867: pay_action_information_api.create_action_information (
1868: p_action_information_id => l_action_info_id
1869: , p_action_context_id => p_payroll_action_id
1870: , p_action_context_type => 'PA'
1871: , p_object_version_number => l_ovn

Line 2016: pay_action_information_api.create_action_information (

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

Line 2182: pay_action_information_api.create_action_information (

2178: CLOSE cbank_info;
2179: END IF;
2180:
2181:
2182: pay_action_information_api.create_action_information (
2183: p_action_information_id => l_action_info_id
2184: ,p_action_context_id => p_payroll_action_id
2185: ,p_action_context_type => 'PA'
2186: ,p_object_version_number => l_ovn

Line 2348: pay_action_information_api.create_action_information (

2344: FETCH cbank_info INTO l_payment_3_acc_no;
2345: CLOSE cbank_info;
2346: END IF;
2347:
2348: pay_action_information_api.create_action_information (
2349: p_action_information_id => l_action_info_id
2350: ,p_action_context_id => p_payroll_action_id
2351: ,p_action_context_type => 'PA'
2352: ,p_object_version_number => l_ovn

Line 2459: , pay_action_information page

2455: , page.object_version_number
2456: , page.action_information4 organization_name
2457: , page.action_information25 total_contributions
2458: FROM hr_organization_information payment
2459: , pay_action_information page
2460: WHERE payment.organization_id = p_company_id
2461: and payment.org_information3 =
2462: to_char(l_period_end_date,'YY') ||
2463: to_char(l_period_end_date,'Q') ||

Line 2571: pay_action_information_api.update_action_information(

2567:
2568: -- Update FR_DUCS_PAGE_INFO record using the update API.
2569:
2570:
2571: pay_action_information_api.update_action_information(
2572: p_action_information_id => payment.action_information_id
2573: ,p_object_version_number => payment.object_version_number
2574: ,p_action_information11 => l_payment_1_acc_no
2575: ,p_action_information12 => fnd_number.number_to_canonical(l_payment_1_val)