DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 625: pay_action_information_api.create_action_information

621:
622: IF rec.accrual_plan_name IS NOT NULL THEN
623: --
624:
625: pay_action_information_api.create_action_information
626: (
627: p_action_information_id => l_action_info_id
628: ,p_action_context_id => p_assact_id
629: ,p_action_context_type => 'AAP'

Line 786: pay_action_information_api.create_action_information

782: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
783:
784: l_ovn := 1;
785:
786: pay_action_information_api.create_action_information
787: (
788: p_action_information_id => l_action_info_id
789: ,p_action_context_id => p_arch_act_id
790: ,p_action_context_type => 'AAP'

Line 916: pay_action_information_api.create_action_information

912: l_no_value_archived :='Yes';
913: ELSE
914: pay_in_utils.set_location(g_debug,l_procedure, 30);
915:
916: pay_action_information_api.create_action_information
917: (
918: p_action_information_id => l_action_info_id
919: ,p_action_context_id => p_assact_id
920: ,p_action_context_type => 'AAP'

Line 956: pay_action_information_api.create_action_information

952:
953:
954:
955: IF l_excess_pf <> 0 THEN
956: pay_action_information_api.create_action_information
957: (
958: p_action_information_id => l_action_info_id
959: ,p_action_context_id => p_assact_id
960: ,p_action_context_type => 'AAP'

Line 1051: pay_action_information_api.create_action_information

1047: pay_in_utils.trace('Effective Date ',p_effective_date);
1048: pay_in_utils.trace('**************************************************','********************');
1049: END IF;
1050:
1051: pay_action_information_api.create_action_information
1052: (
1053: p_action_information_id => l_action_info_id
1054: ,p_action_context_id => p_assact_id
1055: ,p_action_context_type => 'AAP'

Line 1198: -- It then calls pay_action_information_api. --

1194: -- 2. Income Tax This Pay --
1195: -- 3. TDS on Direct Payments --
1196: -- 4. Surcharge This Pay --
1197: -- 5. Education Cess This Pay --
1198: -- It then calls pay_action_information_api. --
1199: -- create_action_information to archive individual balances --
1200: -- --
1201: -- Parameters : --
1202: -- IN : p_assignment_action_id NUMBER --

Line 1440: pay_action_information_api.create_action_information

1436: l_tan := pay_in_form_24q_web_adi.get_tan_number(p_assignment_id, nvl(l_date, p_effective_date));
1437: l_period := pay_in_tax_utils.get_period_number(l_payroll_id, nvl(TRUNC(l_date), p_effective_date));
1438: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 35);
1439:
1440: pay_action_information_api.create_action_information
1441: (
1442: p_action_information_id => l_action_info_id
1443: ,p_action_context_id => p_assact_id
1444: ,p_assignment_id => p_assignment_id

Line 1546: FROM pay_action_information

1542: IS
1543: SELECT action_information_id
1544: ,action_information1
1545: ,action_information2
1546: FROM pay_action_information
1547: WHERE action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
1548: AND action_context_id = p_assactid
1549: AND action_context_type = 'AAP';
1550: --

Line 1559: FROM pay_action_information

1555:
1556: CURSOR csr_emp_det_action_info_id
1557: IS
1558: SELECT action_information_id
1559: FROM pay_action_information
1560: WHERE action_information_category = 'EMPLOYEE DETAILS'
1561: AND action_context_id = p_assactid
1562: AND action_context_type = 'AAP';
1563:

Line 1648: FROM pay_action_information

1644: -- Cursor to select the archived information for category 'EMPLOYEE DETAILS'
1645: CURSOR csr_emp_details
1646: IS
1647: SELECT action_information_id
1648: FROM pay_action_information
1649: WHERE action_information_category = 'EMPLOYEE DETAILS'
1650: AND action_context_id = p_assactid
1651: AND action_context_type = 'AAP';
1652:

Line 1698: l_act_inf_id pay_action_information.action_information_id%TYPE;

1694: l_month VARCHAR2(30);
1695: l_year VARCHAR2(30);
1696: /* Bug 4159662*/
1697: l_reg_name hr_organization_units.name%TYPE;
1698: l_act_inf_id pay_action_information.action_information_id%TYPE;
1699: l_message VARCHAR2(255);
1700: l_full_name per_people_f.full_name%TYPE;
1701: l_email_address per_people_f.email_address%TYPE;
1702:

Line 1759: pay_action_information_api.update_action_information

1755: OPEN csr_emp_details;
1756: FETCH csr_emp_details INTO l_act_inf_id;
1757: CLOSE csr_emp_details;
1758:
1759: pay_action_information_api.update_action_information
1760: (
1761: p_action_information_id => l_act_inf_id
1762: ,p_object_version_number => l_ovn
1763: ,p_action_information18 => l_reg_name

Line 1804: pay_action_information_api.update_action_information

1800: END IF;
1801: pay_in_utils.set_location(g_debug,l_procedure, 70);
1802: l_ovn := 1;
1803:
1804: pay_action_information_api.update_action_information
1805: (
1806: p_action_information_id => net_pay_rec.action_information_id
1807: ,p_object_version_number => l_ovn
1808: ,p_action_information5 => l_bank

Line 1852: pay_action_information_api.create_action_information

1848:
1849: IF l_email_address IS NOT NULL
1850: THEN
1851: pay_in_utils.set_location(g_debug,l_procedure, 105);
1852: pay_action_information_api.create_action_information
1853: (p_action_context_id => p_assactid
1854: ,p_action_context_type => 'AAP'
1855: ,p_action_information_category => 'IN_EMPLOYEE_DETAILS'
1856: ,p_effective_date => p_pre_effective_date

Line 1885: pay_action_information_api.update_action_information

1881: --
1882:
1883: pay_in_utils.set_location(g_debug,l_procedure, 120);
1884: l_ovn := 1;
1885: pay_action_information_api.update_action_information
1886: (
1887: p_action_information_id => l_emp_det_act_info_id
1888: ,p_object_version_number => l_ovn
1889: ,p_action_information1 => l_full_name

Line 2557: pay_action_information_api.create_action_information

2553: pay_in_utils.trace('PF Computation Salary PTD ',l_pf_comp_salary);
2554: END IF;
2555: pay_in_utils.set_location(g_debug,l_procedure, 240);
2556:
2557: pay_action_information_api.create_action_information
2558: (p_action_context_id => p_archive_action_id --Archive Action id
2559: ,p_action_context_type => 'AAP'
2560: ,p_action_information_category => 'IN_PF_ASG'
2561: ,p_tax_unit_id => null

Line 3206: pay_action_information_api.create_action_information

3202: pay_in_utils.trace('Contribution Period End ',l_contr_period);
3203: END IF;
3204:
3205:
3206: pay_action_information_api.create_action_information
3207: (p_action_context_id => p_archive_action_id --Archive Action id
3208: ,p_action_context_type => 'AAP'
3209: ,p_action_information_category => 'IN_ESI_ASG'
3210: ,p_tax_unit_id => null

Line 3388: FROM pay_action_information

3384: ,p_contribution_period VARCHAR2
3385: )
3386: IS
3387: SELECT 1
3388: FROM pay_action_information
3389: WHERE action_context_id = p_payroll_action_id
3390: AND action_information_category = 'IN_'||p_context||'_PAY'
3391: AND action_information1 = p_contribution_period
3392: AND action_information2 = p_organization_id

Line 3548: pay_action_information_api.create_action_information

3544:
3545: SELECT DECODE(p_context,'PF',l_class,l_rep_addr) INTO l_context
3546: FROM dual;--case p_context when 'PF' then l_class else l_rep_addr end --PF CLass or ESI Org Rep Addr
3547:
3548: pay_action_information_api.create_action_information
3549: (p_action_context_id => l_act_id --Payroll Action id
3550: ,p_action_context_type => 'PA'
3551: ,p_action_information_category => l_act_inf_cat
3552: ,p_tax_unit_id => null

Line 3904: pay_action_information_api.create_action_information

3900:
3901: l_contrib_month := TO_CHAR(ADD_MONTHS(p_payroll_date, -3), 'MM');
3902: l_contrib_year := TO_CHAR(pay_in_tax_utils.get_financial_year_start(p_payroll_date), 'YYYY')||'-'|| TO_CHAR(pay_in_tax_utils.get_financial_year_end(p_payroll_date), 'YYYY');
3903:
3904: pay_action_information_api.create_action_information
3905: (p_action_context_id => p_archive_action_id --Archive Action id
3906: ,p_action_context_type => 'AAP'
3907: ,p_action_information_category => 'IN_PT_ASG'
3908: ,p_tax_unit_id => null

Line 4153: pay_action_information_api.create_action_information

4149: CLOSE c_rep_pos;
4150:
4151: pay_in_utils.set_location(g_debug,l_procedure, 60);
4152:
4153: pay_action_information_api.create_action_information
4154: (p_action_context_id => l_act_id --Payroll Action id
4155: ,p_action_context_type => 'PA'
4156: ,p_action_information_category => l_act_inf_cat
4157: ,p_tax_unit_id => null