DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PSTA dependencies on PAY_ACTION_INFORMATION

Line 273: pay_action_information_api.create_action_information (

269: g_local_unit_sd_no := rg_local_unit_details.local_unit_sd_no;
270: end if;
271:
272: /* Archive the Parameters */
273: pay_action_information_api.create_action_information (
274: p_action_information_id => l_action_info_id,
275: p_action_context_id => p_payroll_action_id,
276: p_action_context_type => 'PA',
277: p_object_version_number => l_ovn,

Line 315: pay_action_information_api.create_action_information (

311:
312: /* Get the Country Name */
313: l_country := pay_fi_archive_psta.get_country_name (rl_get_org_address.country);
314: /* Archive the Local Units Details */
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 773: pay_action_information_api.create_action_information (

769: p_payroll_action_id,
770: p_chunk,
771: null
772: );
773: pay_action_information_api.create_action_information (
774: p_action_information_id => l_action_info_id,
775: p_action_context_id => l_actid, --p_arch_assignment_action_id,
776: p_action_context_type => 'AAP',
777: p_object_version_number => l_ovn,

Line 828: pay_action_information_api.create_action_information (

824: car_element_detail.screen_entry_value
825: );
826: end if;
827:
828: pay_action_information_api.create_action_information (
829: p_action_information_id => l_action_info_id,
830: p_action_context_id => l_actid, --p_arch_assignment_action_id,
831: p_action_context_type => 'AAP',
832: p_object_version_number => l_ovn,

Line 1171: from pay_action_information pai, pay_assignment_actions paa

1167: cursor csr_person_archived (
1168: p_person_id number
1169: ) is
1170: select 'Y'
1171: from pay_action_information pai, pay_assignment_actions paa
1172: where pai.action_context_id = paa.assignment_action_id
1173: and paa.payroll_action_id = g_arch_payroll_action_id
1174: and action_information1 = 'PYFIPSTA'
1175: and action_information2 = 'PERSON DETAILS'

Line 1182: from pay_action_information pai, pay_assignment_actions paa

1178: cursor csr_payroll_archived (
1179: p_person_id number
1180: ) is
1181: select 'Y'
1182: from pay_action_information pai, pay_assignment_actions paa
1183: where pai.action_context_id = paa.assignment_action_id
1184: and paa.payroll_action_id = g_arch_payroll_action_id
1185: and action_information1 = 'PYFIPSTA'
1186: and action_information2 = 'Payroll Details'

Line 1260: l_payroll_id pay_action_information.action_information3%type;

1256: l_country per_addresses.country%type;
1257: rl_permanent_address csr_permanent_address%rowtype;
1258: l_permanent_postal_code per_addresses.postal_code%type;
1259: l_permanent_country per_addresses.country%type;
1260: l_payroll_id pay_action_information.action_information3%type;
1261: l_pay_period pay_action_information.action_information4%type;
1262: l_pay_period_start_date pay_action_information.action_information5%type;
1263: l_pay_period_end_date pay_action_information.action_information3%type;
1264: l_period_type pay_action_information.action_information3%type;

Line 1261: l_pay_period pay_action_information.action_information4%type;

1257: rl_permanent_address csr_permanent_address%rowtype;
1258: l_permanent_postal_code per_addresses.postal_code%type;
1259: l_permanent_country per_addresses.country%type;
1260: l_payroll_id pay_action_information.action_information3%type;
1261: l_pay_period pay_action_information.action_information4%type;
1262: l_pay_period_start_date pay_action_information.action_information5%type;
1263: l_pay_period_end_date pay_action_information.action_information3%type;
1264: l_period_type pay_action_information.action_information3%type;
1265: l_run_assignment_action_id number;

Line 1262: l_pay_period_start_date pay_action_information.action_information5%type;

1258: l_permanent_postal_code per_addresses.postal_code%type;
1259: l_permanent_country per_addresses.country%type;
1260: l_payroll_id pay_action_information.action_information3%type;
1261: l_pay_period pay_action_information.action_information4%type;
1262: l_pay_period_start_date pay_action_information.action_information5%type;
1263: l_pay_period_end_date pay_action_information.action_information3%type;
1264: l_period_type pay_action_information.action_information3%type;
1265: l_run_assignment_action_id number;
1266: -- l_benefit_type_code pay_element_types_f.element_information1%type;

Line 1263: l_pay_period_end_date pay_action_information.action_information3%type;

1259: l_permanent_country per_addresses.country%type;
1260: l_payroll_id pay_action_information.action_information3%type;
1261: l_pay_period pay_action_information.action_information4%type;
1262: l_pay_period_start_date pay_action_information.action_information5%type;
1263: l_pay_period_end_date pay_action_information.action_information3%type;
1264: l_period_type pay_action_information.action_information3%type;
1265: l_run_assignment_action_id number;
1266: -- l_benefit_type_code pay_element_types_f.element_information1%type;
1267: l_benefit_type varchar2 (200);

Line 1264: l_period_type pay_action_information.action_information3%type;

1260: l_payroll_id pay_action_information.action_information3%type;
1261: l_pay_period pay_action_information.action_information4%type;
1262: l_pay_period_start_date pay_action_information.action_information5%type;
1263: l_pay_period_end_date pay_action_information.action_information3%type;
1264: l_period_type pay_action_information.action_information3%type;
1265: l_run_assignment_action_id number;
1266: -- l_benefit_type_code pay_element_types_f.element_information1%type;
1267: l_benefit_type varchar2 (200);
1268: l_benefit_monetary_value number;

Line 1476: pay_action_information_api.create_action_information (

1472: end if;
1473:
1474: l_permanent_country := pay_fi_archive_psta.get_country_name (rl_permanent_address.country);
1475: /* Archive Person Details */
1476: pay_action_information_api.create_action_information (
1477: p_action_information_id => l_action_info_id,
1478: p_action_context_id => p_arch_assignment_action_id,
1479: p_action_context_type => 'AAP',
1480: p_object_version_number => l_ovn,

Line 1637: pay_action_information_api.create_action_information (

1633: else
1634: l_tax_amount := 0;
1635: end if;
1636:
1637: pay_action_information_api.create_action_information (
1638: p_action_information_id => l_action_info_id,
1639: p_action_context_id => p_arch_assignment_action_id,
1640: p_action_context_type => 'AAP',
1641: p_object_version_number => l_ovn,

Line 1745: pay_action_information_api.create_action_information (

1741: l_permanent_postal_code := rl_permanent_address.postal_code;
1742: end if;
1743:
1744: l_permanent_country := pay_fi_archive_psta.get_country_name (rl_permanent_address.country);
1745: pay_action_information_api.create_action_information (
1746: p_action_information_id => l_action_info_id,
1747: p_action_context_id => p_assignment_action_id,
1748: p_action_context_type => 'AAP',
1749: p_object_version_number => l_ovn,