APPS.PAY_FI_ARCHIVE_ACRA dependencies on PAY_ACTION_INFORMATION

Line 293: FROM pay_action_information

289: d_element_type_id:=l_element_type_id;
290: d_local_unit_id:=l_local_unit_id;
291: IF l_archive = 'Y' THEN
292: SELECT count(*) INTO l_count
293: FROM pay_action_information
294: WHERE action_information_category = 'EMEA REPORT DETAILS'
295: AND action_information1= 'PYFIACRA'
296: AND action_context_id= p_payroll_action_id;
297: IF l_count < 1 then

Line 303: pay_action_information_api.create_action_information (

299: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;
300: CLOSE csr_Legal_Emp_Details;
301: l_le_name := rg_Legal_Emp_Details.name ;
302: l_y_number := rg_Legal_Emp_Details.ORG_INFORMATION1 ;
303: pay_action_information_api.create_action_information (
304: p_action_information_id => l_action_info_id
305: ,p_action_context_id => p_payroll_action_id
306: ,p_action_context_type => 'PA'
307: ,p_object_version_number => l_ovn

Line 328: pay_action_information_api.create_action_information (

324: CLOSE csr_Local_Unit_Details;
325: l_lu_name:= rg_Local_Unit_Details.name ;
326: l_business_id:= rg_Local_Unit_Details.ORG_INFORMATION1 ;
327: l_emp_name:=l_lu_name;
328: pay_action_information_api.create_action_information (
329: p_action_information_id => l_action_info_id
330: ,p_action_context_id => p_payroll_action_id
331: ,p_action_context_type => 'PA'
332: ,p_object_version_number => l_ovn

Line 359: pay_action_information_api.create_action_information (

355: debit:=csr_cost.costed_Value;
356: END IF;
357: END LOOP;
358: IF l_cost_value IS NOT NULL THEN
359: pay_action_information_api.create_action_information (
360: p_action_information_id => l_action_info_id
361: ,p_action_context_id => p_payroll_action_id
362: ,p_action_context_type => 'PA'
363: ,p_object_version_number => l_ovn

Line 386: pay_action_information_api.create_action_information (

382: FETCH csr_ElementSet_Details INTO rg_ElementSet_Details;
383: l_element_set_name:=
384: rg_ElementSet_Details.element_set_name;
385: CLOSE csr_ElementSet_Details;
386: pay_action_information_api.create_action_information (
387: p_action_information_id => l_action_info_id
388: ,p_action_context_id => p_payroll_action_id
389: ,p_action_context_type => 'PA'
390: ,p_object_version_number => l_ovn

Line 415: pay_action_information_api.create_action_information (

411: debit:=csr_cost.costed_Value;
412: END IF;
413: END LOOP;
414: IF l_cost_value IS NOT NULL THEN
415: pay_action_information_api.create_action_information (
416: p_action_information_id => l_action_info_id
417: ,p_action_context_id => p_payroll_action_id
418: ,p_action_context_type => 'PA'
419: ,p_object_version_number => l_ovn

Line 449: pay_action_information_api.create_action_information (

445: l_local:=To_char(l_local_unit_id);
446: l_lu_name := rg_Local_Unit_Details.name ;
447: l_business_id := rg_Local_Unit_Details.ORG_INFORMATION1 ;
448: l_emp_name:=l_lu_name;
449: pay_action_information_api.create_action_information (
450: p_action_information_id => l_action_info_id
451: ,p_action_context_id => p_payroll_action_id
452: ,p_action_context_type => 'PA'
453: ,p_object_version_number => l_ovn

Line 479: pay_action_information_api.create_action_information (

475: debit:=csr_cost.costed_Value;
476: END IF;
477: END LOOP;
478: IF l_cost_value IS NOT NULL THEN
479: pay_action_information_api.create_action_information (
480: p_action_information_id => l_action_info_id
481: ,p_action_context_id => p_payroll_action_id
482: ,p_action_context_type => 'PA'
483: ,p_object_version_number => l_ovn

Line 502: FROM pay_action_information

498: credit:=NULL;
499: debit:=NULL;
500: ELSE
501: SELECT count(*) INTO l_count
502: FROM pay_action_information
503: WHERE action_information_category = 'EMEA REPORT INFORMATION'
504: AND action_information1='PYFIACRA'
505: AND action_information2='ES'
506: AND action_context_id= p_payroll_action_id;

Line 514: pay_action_information_api.create_action_information (

510: rg_ElementSet_Details;
511: l_element_set_name:=
512: rg_ElementSet_Details.element_set_name;
513: CLOSE csr_ElementSet_Details;
514: pay_action_information_api.create_action_information (
515: p_action_information_id => l_action_info_id
516: ,p_action_context_id => p_payroll_action_id
517: ,p_action_context_type => 'PA'
518: ,p_object_version_number => l_ovn

Line 544: pay_action_information_api.create_action_information (

540: debit:=csr_cost.costed_Value;
541: END IF;
542: END LOOP;
543: IF l_cost_value IS NOT NULL THEN
544: pay_action_information_api.create_action_information (
545: p_action_information_id => l_action_info_id
546: ,p_action_context_id => p_payroll_action_id
547: ,p_action_context_type => 'PA'
548: ,p_object_version_number => l_ovn

Line 576: pay_action_information_api.create_action_information (

572: END IF;
573: IF d_element_type_id IS NULL THEN
574: l_element_name:=NULL;
575: END IF;
576: pay_action_information_api.create_action_information (
577: p_action_information_id => l_action_info_id
578: ,p_action_context_id => p_payroll_action_id
579: ,p_action_context_type => 'PA'
580: ,p_object_version_number => l_ovn