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

Line 260: FROM pay_action_information

256: -- fnd_file.put_line(fnd_file.log,'Range Code 4');
257:
258: SELECT count(*)
259: INTO l_count
260: FROM pay_action_information
261: WHERE action_information_category = 'EMEA REPORT DETAILS'
262: AND action_information1 = 'PYDKEINA'
263: AND action_context_id = p_payroll_action_id;
264:

Line 315: pay_action_information_api.create_action_information (

311: end if;
312:
313: --Employer Level Information
314: if(rg_Legal_Emp_Details.ORG_INFORMATION3 = 'Y') then -- if the legal emp has data supplier set to 'Y'
315: pay_action_information_api.create_action_information (
316: p_action_information_id => l_action_info_id
317: ,p_action_context_id => p_payroll_action_id
318: ,p_action_context_type => 'PA'
319: ,p_object_version_number => l_ovn

Line 366: pay_action_information_api.create_action_information (

362: if(sp.org_information3<>'Y') then
363: fnd_file.put_line(fnd_file.log,HR_DK_UTILITY.GET_MESSAGE('PAY','HR_377103_DK_EINCOME_STATUS'));
364: g_flag:=1;
365: else
366: pay_action_information_api.create_action_information (
367: p_action_information_id => l_action_info_id
368: ,p_action_context_id => p_payroll_action_id
369: ,p_action_context_type => 'PA'
370: ,p_object_version_number => l_ovn

Line 411: pay_action_information_api.create_action_information (

407: end if;
408:
409: if(g_flag=0) then
410: -- Record 2001
411: pay_action_information_api.create_action_information (
412: p_action_information_id => l_action_info_id
413: ,p_action_context_id => p_payroll_action_id
414: ,p_action_context_type => 'PA'
415: ,p_object_version_number => l_ovn

Line 458: pay_action_information_api.create_action_information (

454: close csr_pay_periods;
455:
456: if(g_company_terminating='N') then
457: -- Record 5000
458: pay_action_information_api.create_action_information (
459: p_action_information_id => l_action_info_id
460: ,p_action_context_id => p_payroll_action_id
461: ,p_action_context_type => 'PA'
462: ,p_object_version_number => l_ovn

Line 506: pay_action_information_api.create_action_information (

502: close csr_payroll_name;
503:
504: -- fnd_file.put_line(fnd_file.log,'Range Code 14');
505: --Report Level Information
506: pay_action_information_api.create_action_information (
507: p_action_information_id => l_action_info_id
508: ,p_action_context_id => p_payroll_action_id
509: ,p_action_context_type => 'PA'
510: ,p_object_version_number => l_ovn

Line 988: pid pay_action_information.action_information1%type

984: l_org_id NUMBER;
985: l_hd VARCHAR2(100);
986:
987: PROCEDURE rec_6001(
988: pid pay_action_information.action_information1%type
989: ,aid pay_action_information.action_information1%type
990: ,code pay_action_information.action_information1%type
991: ,amt pay_action_information.action_information1%type
992: ,sgn pay_action_information.action_information1%type

Line 989: ,aid pay_action_information.action_information1%type

985: l_hd VARCHAR2(100);
986:
987: PROCEDURE rec_6001(
988: pid pay_action_information.action_information1%type
989: ,aid pay_action_information.action_information1%type
990: ,code pay_action_information.action_information1%type
991: ,amt pay_action_information.action_information1%type
992: ,sgn pay_action_information.action_information1%type
993: )

Line 990: ,code pay_action_information.action_information1%type

986:
987: PROCEDURE rec_6001(
988: pid pay_action_information.action_information1%type
989: ,aid pay_action_information.action_information1%type
990: ,code pay_action_information.action_information1%type
991: ,amt pay_action_information.action_information1%type
992: ,sgn pay_action_information.action_information1%type
993: )
994: IS

Line 991: ,amt pay_action_information.action_information1%type

987: PROCEDURE rec_6001(
988: pid pay_action_information.action_information1%type
989: ,aid pay_action_information.action_information1%type
990: ,code pay_action_information.action_information1%type
991: ,amt pay_action_information.action_information1%type
992: ,sgn pay_action_information.action_information1%type
993: )
994: IS
995: l_sgn pay_action_information.action_information1%type:=NULL;

Line 992: ,sgn pay_action_information.action_information1%type

988: pid pay_action_information.action_information1%type
989: ,aid pay_action_information.action_information1%type
990: ,code pay_action_information.action_information1%type
991: ,amt pay_action_information.action_information1%type
992: ,sgn pay_action_information.action_information1%type
993: )
994: IS
995: l_sgn pay_action_information.action_information1%type:=NULL;
996: amt1 pay_action_information.action_information1%type:=NULL;

Line 995: l_sgn pay_action_information.action_information1%type:=NULL;

991: ,amt pay_action_information.action_information1%type
992: ,sgn pay_action_information.action_information1%type
993: )
994: IS
995: l_sgn pay_action_information.action_information1%type:=NULL;
996: amt1 pay_action_information.action_information1%type:=NULL;
997: BEGIN
998:
999: if(sgn='-1') then

Line 996: amt1 pay_action_information.action_information1%type:=NULL;

992: ,sgn pay_action_information.action_information1%type
993: )
994: IS
995: l_sgn pay_action_information.action_information1%type:=NULL;
996: amt1 pay_action_information.action_information1%type:=NULL;
997: BEGIN
998:
999: if(sgn='-1') then
1000: l_sgn:='-';

Line 1007: pay_action_information_api.create_action_information (

1003: end if;
1004:
1005: amt1:=lpad(amt,16,'0');
1006: --Record - 6001
1007: pay_action_information_api.create_action_information (
1008: p_action_information_id => l_action_info_id
1009: ,p_action_context_id => p_assignment_action_id
1010: ,p_action_context_type => 'AAP'
1011: ,p_object_version_number => l_ovn

Line 1172: pay_action_information_api.create_action_information (

1168: l_cpr_number:= rg_csr_get_person_details.cpr;
1169: if((rg_csr_latest_hire_date.lhd between l_start_date and l_end_date) and to_char(l_end_date,'mm')<'06' and to_char(l_end_date,'yyyy')<='2008') then
1170: -- fnd_file.put_line(fnd_file.log,'Inserting starters');
1171: --Record - 2101
1172: pay_action_information_api.create_action_information (
1173: p_action_information_id => l_action_info_id
1174: ,p_action_context_id => p_assignment_action_id
1175: ,p_action_context_type => 'AAP'
1176: ,p_object_version_number => l_ovn

Line 1220: pay_action_information_api.create_action_information (

1216:
1217: if(rg_csr_asg_terminator.effective_end_date <= l_end_date) then
1218: -- fnd_file.put_line(fnd_file.log,'Inserting terminators');
1219: --Record - 2101
1220: pay_action_information_api.create_action_information (
1221: p_action_information_id => l_action_info_id
1222: ,p_action_context_id => p_assignment_action_id
1223: ,p_action_context_type => 'AAP'
1224: ,p_object_version_number => l_ovn

Line 1277: pay_action_information_api.create_action_information (

1273:
1274: -- fnd_file.put_line(fnd_file.log,'Person name : '||rg_csr_get_person_details.full_name);
1275:
1276: --Record - 6000
1277: pay_action_information_api.create_action_information (
1278: p_action_information_id => l_action_info_id
1279: ,p_action_context_id => p_assignment_action_id
1280: ,p_action_context_type => 'AAP'
1281: ,p_object_version_number => l_ovn

Line 1429: pay_action_information_api.create_action_information (

1425: end if;
1426:
1427: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 13');
1428: --Record - 6002
1429: pay_action_information_api.create_action_information (
1430: p_action_information_id => l_action_info_id
1431: ,p_action_context_id => p_assignment_action_id
1432: ,p_action_context_type => 'AAP'
1433: ,p_object_version_number => l_ovn

Line 1471: pay_action_information_api.create_action_information (

1467: ,p_action_information30 => null);
1468:
1469: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 14');
1470: --Record - 6004
1471: pay_action_information_api.create_action_information (
1472: p_action_information_id => l_action_info_id
1473: ,p_action_context_id => p_assignment_action_id
1474: ,p_action_context_type => 'AAP'
1475: ,p_object_version_number => l_ovn

Line 1516: pay_action_information_api.create_action_information (

1512: l_total_atp_hours := ROUND(l_total_atp_hours,2); -- rounding to 2 decimals
1513:
1514: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15');
1515: --Record - 6005
1516: pay_action_information_api.create_action_information (
1517: p_action_information_id => l_action_info_id
1518: ,p_action_context_id => p_assignment_action_id
1519: ,p_action_context_type => 'AAP'
1520: ,p_object_version_number => l_ovn

Line 1581: FROM pay_action_information pai

1577: /* Cursors to fetch data for record numbering*/
1578:
1579: CURSOR csr_all_rec ( p_payroll_action_id NUMBER) IS
1580: SELECT *
1581: FROM pay_action_information pai
1582: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
1583: AND pai.action_information1 = 'PYDKEINA'
1584: AND pai.action_information2 = to_char(p_payroll_action_id)
1585: AND pai.action_information3 IN ('1000','2001','2101','5000','6000')

Line 1591: FROM pay_action_information pai

1587: FOR UPDATE;
1588:
1589: CURSOR csr_asg_all_rec ( p_payroll_action_id NUMBER,p_person_id NUMBER) IS
1590: SELECT *
1591: FROM pay_action_information pai
1592: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
1593: AND pai.action_information1 = 'PYDKEINA'
1594: AND pai.action_information2 = to_char(p_payroll_action_id)
1595: AND pai.action_information4 = to_char(p_person_id)

Line 1617: UPDATE pay_action_information pai

1613: LOOP
1614: l_end_code:=l_end_code + 1 ;
1615: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 2');
1616:
1617: UPDATE pay_action_information pai
1618: SET pai.action_information30 =LPAD(l_end_code,7,'0')
1619: WHERE CURRENT OF csr_all_rec;
1620:
1621: /* fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 3');

Line 1629: UPDATE pay_action_information pai

1625: IF rg_csr_all_rec.action_information3='6000' THEN
1626: FOR rg_csr_asg_all_rec IN csr_asg_all_rec( p_payroll_action_id,to_number(rg_csr_all_rec.action_information4))
1627: LOOP
1628: l_end_code:=l_end_code + 1 ;
1629: UPDATE pay_action_information pai
1630: SET pai.action_information30 =LPAD(l_end_code,7,'0')
1631: WHERE CURRENT OF csr_asg_all_rec;
1632: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 4');
1633: END LOOP;

Line 1641: pay_action_information_api.create_action_information (

1637: l_end_code:=l_end_code + 1 ;
1638:
1639: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 6');
1640:
1641: pay_action_information_api.create_action_information (
1642: p_action_information_id=> l_action_info_id,
1643: p_action_context_id=> p_payroll_action_id,
1644: p_action_context_type=> 'PA',
1645: p_object_version_number=> l_ovn,