APPS.PAY_NO_SUPPORT_ORDER dependencies on PAY_ACTION_INFORMATION

Line 311: FROM pay_action_information

307: THEN
308:
309: -- check if record for current archive exists
310: SELECT count(*) INTO l_count
311: FROM pay_action_information
312: WHERE action_information_category = 'EMEA REPORT DETAILS'
313: AND action_information1 = 'PYNOSUPORDA'
314: AND action_context_id = pactid;
315:

Line 418: pay_action_information_api.create_action_information (

414: -------------------------------------------------------------------
415:
416: -- Archive the REPORT DETAILS
417:
418: pay_action_information_api.create_action_information (
419: p_action_information_id => l_action_info_id -- out parameter
420: ,p_object_version_number => l_ovn -- out parameter
421: ,p_action_context_id => pactid -- context id = payroll action id (of Archive)
422: ,p_action_context_type => 'PA' -- context type

Line 652: pay_action_information_api.create_action_information (

648: hr_nonrun_asact.insact(l_actid ,rec_asg.asg_id ,p_payroll_action_id ,p_chunk ,NULL);
649:
650:
651: -- Creating Initial Archive Entries
652: pay_action_information_api.create_action_information (
653:
654: p_action_information_id => l_action_info_id -- out parameter
655: ,p_object_version_number => l_ovn -- out parameter
656: ,p_action_context_id => l_actid -- context id = assignment action id (of Archive)

Line 697: from pay_action_information

693: select to_number(ACTION_INFORMATION_ID) action_info_id
694: ,to_number(ACTION_INFORMATION4) main_asg_act_id
695: ,to_number(ACTION_INFORMATION2) local_unit_id
696: ,jurisdiction_code
697: from pay_action_information
698: where ACTION_INFORMATION_CATEGORY = 'EMEA REPORT INFORMATION'
699: and ACTION_INFORMATION1 = 'PYNOSUPORDA'
700: and ACTION_CONTEXT_TYPE = 'AAP'
701: and ACTION_CONTEXT_ID = p_assignment_action_id

Line 719: from pay_action_information

715: ,to_number(ACTION_INFORMATION16) ipv_ref_num -- Input Value ID 4 = Reference Number
716: ,to_number(ACTION_INFORMATION17) ipv_pay_value -- Input Value ID 5 = Pay Value
717: ,to_number(ACTION_INFORMATION18) def_bal_id -- Deduction Basis Balance : Defined Balance ID
718:
719: from pay_action_information
720:
721: where ACTION_INFORMATION_CATEGORY = 'EMEA REPORT DETAILS'
722: and ACTION_INFORMATION1 = 'PYNOSUPORDA'
723: and ACTION_CONTEXT_TYPE = 'PA'

Line 984: pay_action_information_api.update_action_information (

980: l_emp_ni := substr(rec_asg_detail.per_ni,1,6)||'-'||
981: substr(rec_asg_detail.per_ni,7,5) ;
982:
983: -- Updating the Initial Archive Entries
984: pay_action_information_api.update_action_information (
985: p_action_information_id => rec_info.action_info_id -- in parameter
986: ,p_object_version_number => l_ovn -- in out parameter
987: ,p_action_information5 => l_third_party_id --Third Party ID (Tax Collector ID)
988: ,p_action_information6 => l_third_party_name --Third Party Name (Tax Collector's Name)

Line 1045: from pay_action_information

1041: ,action_information6 to_date
1042: ,action_information11 ele_name
1043: ,action_information12 ele_code
1044: ,action_information20 archived_on
1045: from pay_action_information
1046: where action_context_id = p_payroll_action_id ;
1047:
1048:
1049: -- cursor to get assignment and person details

Line 1072: from pay_action_information pai

1068: ,action_information23 percentage
1069: ,action_information24 amount
1070: ,action_information25 deductedthisperiod
1071: ,action_information26 deductionBasis
1072: from pay_action_information pai
1073: where action_information3 = to_char(p_payroll_action_id)
1074: order by thirdparty_name , order_name;
1075:
1076:

Line 1086: l_thirdparty_id pay_action_information.ACTION_INFORMATION5%TYPE := '-999';

1082: l_to_date VARCHAR2(240);
1083: l_ele_name varchar2(240);
1084: l_ele_code varchar2(240);
1085: l_archived_on varchar2(240);
1086: l_thirdparty_id pay_action_information.ACTION_INFORMATION5%TYPE := '-999';
1087: l_IANA_charset VARCHAR2 (50);
1088:
1089: BEGIN
1090: