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

Line 392: pay_action_information_api.create_action_information (

388: Mandatory_Check('PAY_NL_ER_NSI_REQUIRED_FIELD','NL_ER_REG_NUMBER',l_Employer_Reg_Number);
389: Mandatory_Check('PAY_NL_ER_NSI_REQUIRED_FIELD','NL_ER_ADDR',SUBSTR(v_csr_get_address1.street_name||v_csr_get_address1.House_Num||v_csr_get_address1.House_Num_Add,1,20));
390:
391: IF g_error_count=0 THEN
392: pay_action_information_api.create_action_information (
393: p_action_information_id => l_action_info_id
394: ,p_action_context_id => pactid
395: ,p_action_context_type => 'PA'
396: ,p_object_version_number => l_ovn

Line 654: FROM PAY_ACTION_INFORMATION nl_ee_nsi

650: ,nl_ee_nsi.action_information14 Code_Insurance_Basis
651: ,nl_ee_nsi.action_information15 Code_Occupation
652: ,nl_ee_nsi.action_information16 Work_Pattern
653: ,nl_ee_nsi.action_information17 St_Date_Lab_Rel
654: FROM PAY_ACTION_INFORMATION nl_ee_nsi
655: where nl_ee_nsi.action_context_type='AAP'
656: and nl_ee_nsi.action_information_category = 'NL NSI EMPLOYEE DETAILS'
657: and nl_ee_nsi.action_information1 = lp_employer_id
658: and nl_ee_nsi.action_information2 = lp_person_id

Line 680: FROM PAY_ACTION_INFORMATION nl_ee_nsi1

676: ,lp_nsi_process_date DATE) IS
677: SELECT
678: min(TO_DATE(nl_ee_nsi1.action_information10,'DDMMYYYY')) notify_a_date,
679: min(TO_DATE(nl_ee_nsi1.action_information12,'DDMMYYYY')) notify_b_date
680: FROM PAY_ACTION_INFORMATION nl_ee_nsi1
681: where nl_ee_nsi1.action_context_type='AAP'
682: and nl_ee_nsi1.action_information_category = 'NL NSI EMPLOYEE DETAILS'
683: and nl_ee_nsi1.action_information1 = lp_employer_id
684: and nl_ee_nsi1.action_information2 = lp_person_id

Line 846: l_action_info_id pay_action_information.action_information_id%TYPE;

842:
843: l_last_nsi_min_notify_date DATE;
844:
845:
846: l_action_info_id pay_action_information.action_information_id%TYPE;
847: l_ovn pay_action_information.object_version_number%TYPE;
848:
849: l_effective_date DATE;
850: l_Employer_ID hr_organization_units.organization_id%TYPE;

Line 847: l_ovn pay_action_information.object_version_number%TYPE;

843: l_last_nsi_min_notify_date DATE;
844:
845:
846: l_action_info_id pay_action_information.action_information_id%TYPE;
847: l_ovn pay_action_information.object_version_number%TYPE;
848:
849: l_effective_date DATE;
850: l_Employer_ID hr_organization_units.organization_id%TYPE;
851: l_Person_ID per_all_assignments_f.person_id%TYPE;

Line 1580: pay_action_information_api.create_action_information (

1576: l_Notification_b_date := NULL;
1577: l_Multiple_NSI := TRUE;
1578: END IF;
1579:
1580: pay_action_information_api.create_action_information (
1581: p_action_information_id => l_action_info_id
1582: ,p_action_context_id => l_asg_act_id
1583: ,p_action_context_type => 'AAP'
1584: ,p_object_version_number => l_ovn

Line 1622: pay_action_information_api.create_action_information (

1618: l_Notification_a_date := NULL;
1619: l_Notification_b := l_Prev_Notification_b;
1620: l_Notification_b_date := l_Prev_Notification_b_Date;
1621: l_Multiple_NSI := FALSE;
1622: pay_action_information_api.create_action_information (
1623: p_action_information_id => l_action_info_id
1624: ,p_action_context_id => l_asg_act_id
1625: ,p_action_context_type => 'AAP'
1626: ,p_object_version_number => l_ovn

Line 1716: FROM PAY_ACTION_INFORMATION nl_ee_nsi

1712: ,nl_ee_nsi.action_information21 Employee_Pop_Reg_Add
1713: ,nl_ee_nsi.action_information22 Gak_Rep_Info
1714: ,nl_ee_nsi.action_information23 Cadans_Rep_Info
1715: ,nl_ee_nsi.action_information24 Employee_Details
1716: FROM PAY_ACTION_INFORMATION nl_ee_nsi
1717: where nl_ee_nsi.action_context_type='AAP'
1718: and nl_ee_nsi.action_information_category = 'NL NSI EMPLOYEE DETAILS'
1719: and nl_ee_nsi.action_information1 = lp_employer_id
1720: and nl_ee_nsi.action_information2 = lp_person_id

Line 1737: FROM PAY_ACTION_INFORMATION nl_ee_nsi1

1733: ,lp_assignment_id number
1734: ,lp_nsi_process_date date) IS
1735: SELECT
1736: max(effective_date) prev_nsi_process_date
1737: FROM PAY_ACTION_INFORMATION nl_ee_nsi1
1738: where nl_ee_nsi1.action_context_type='AAP'
1739: and nl_ee_nsi1.action_information_category = 'NL NSI EMPLOYEE DETAILS'
1740: and nl_ee_nsi1.action_information1 = lp_employer_id
1741: and nl_ee_nsi1.action_information2 = lp_person_id

Line 1750: l_action_info_id pay_action_information.action_information_id%TYPE;

1746: v_csr_ee_prev_nsi csr_ee_prev_nsi%ROWTYPE;
1747:
1748:
1749: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE;
1750: l_action_info_id pay_action_information.action_information_id%TYPE;
1751: l_ovn pay_action_information.object_version_number%TYPE;
1752: l_withdrawn_action_count NUMBER :=0;
1753: BEGIN
1754: hr_utility.set_location('Entering Withdraw NSI Notification',360);

Line 1751: l_ovn pay_action_information.object_version_number%TYPE;

1747:
1748:
1749: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE;
1750: l_action_info_id pay_action_information.action_information_id%TYPE;
1751: l_ovn pay_action_information.object_version_number%TYPE;
1752: l_withdrawn_action_count NUMBER :=0;
1753: BEGIN
1754: hr_utility.set_location('Entering Withdraw NSI Notification',360);
1755:

Line 1784: pay_action_information_api.create_action_information (

1780: END IF;
1781: hr_utility.set_location('NSI Archive Assignment Action Id '||l_asg_act_id,450);
1782:
1783:
1784: pay_action_information_api.create_action_information (
1785: p_action_information_id => l_action_info_id
1786: ,p_action_context_id => l_asg_act_id
1787: ,p_action_context_type => 'AAP'
1788: ,p_object_version_number => l_ovn

Line 1934: FROM PAY_ACTION_INFORMATION nl_ee_nsi1

1930: ,lp_assignment_id number
1931: ,lp_nsi_process_date date) IS
1932: SELECT
1933: max(effective_date) nsi_process_date
1934: FROM PAY_ACTION_INFORMATION nl_ee_nsi1
1935: where nl_ee_nsi1.action_context_type='AAP'
1936: and nl_ee_nsi1.action_information_category = 'NL NSI EMPLOYEE DETAILS'
1937: and nl_ee_nsi1.action_information1 = lp_employer_id
1938: and nl_ee_nsi1.action_information2 = lp_person_id

Line 1972: l_action_info_id pay_action_information.action_information_id%TYPE;

1968: --
1969: l_prepay_action_id NUMBER;
1970:
1971:
1972: l_action_info_id pay_action_information.action_information_id%TYPE;
1973: l_ovn pay_action_information.object_version_number%TYPE;
1974: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE;
1975:
1976: l_Create_NSI BOOLEAN;--Flag to Control Creation of NSI Record

Line 1973: l_ovn pay_action_information.object_version_number%TYPE;

1969: l_prepay_action_id NUMBER;
1970:
1971:
1972: l_action_info_id pay_action_information.action_information_id%TYPE;
1973: l_ovn pay_action_information.object_version_number%TYPE;
1974: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE;
1975:
1976: l_Create_NSI BOOLEAN;--Flag to Control Creation of NSI Record
1977: v_Skip_Asg BOOLEAN;--Flag to control if processed asg can be skipped