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_FI_ARCHIVE_PSTA dependencies on PAY_FI_ARCHIVE_PSTA

Line 1: package body pay_fi_archive_psta as

1: package body pay_fi_archive_psta as
2: /* $Header: pyfipsta.pkb 120.1 2010/10/27 14:20:56 vijranga ship $ */
3: /* Define the Global variables */
4: type lock_rec is record (
5: archive_assact_id number

Line 13: g_package varchar2 (33) := 'PAY_FI_ARCHIVE_PSTA .';

9: index by binary_integer;
10:
11: g_actid number;
12: g_run_payroll_action_id number;
13: g_package varchar2 (33) := 'PAY_FI_ARCHIVE_PSTA .';
14: g_debug boolean := hr_utility.debug_enabled;
15: g_business_group_id number;
16: g_legal_employer_id number;
17: g_effective_date date;

Line 113: select pay_fi_archive_psta.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER_ID'),

109: ) is
110: cursor csr_parameter_info (
111: p_payroll_action_id number
112: ) is
113: select pay_fi_archive_psta.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER_ID'),
114: pay_fi_archive_psta.get_parameter (legislative_parameters, 'ARCHIVE'),
115: pay_fi_archive_psta.get_parameter (legislative_parameters, 'LOCAL_UNIT_ID'),
116: pay_fi_archive_psta.get_parameter (legislative_parameters, 'YEAR_RPT'),
117: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_TYPE'),

Line 114: pay_fi_archive_psta.get_parameter (legislative_parameters, 'ARCHIVE'),

110: cursor csr_parameter_info (
111: p_payroll_action_id number
112: ) is
113: select pay_fi_archive_psta.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER_ID'),
114: pay_fi_archive_psta.get_parameter (legislative_parameters, 'ARCHIVE'),
115: pay_fi_archive_psta.get_parameter (legislative_parameters, 'LOCAL_UNIT_ID'),
116: pay_fi_archive_psta.get_parameter (legislative_parameters, 'YEAR_RPT'),
117: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_TYPE'),
118: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_ID'), effective_date, business_group_id

Line 115: pay_fi_archive_psta.get_parameter (legislative_parameters, 'LOCAL_UNIT_ID'),

111: p_payroll_action_id number
112: ) is
113: select pay_fi_archive_psta.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER_ID'),
114: pay_fi_archive_psta.get_parameter (legislative_parameters, 'ARCHIVE'),
115: pay_fi_archive_psta.get_parameter (legislative_parameters, 'LOCAL_UNIT_ID'),
116: pay_fi_archive_psta.get_parameter (legislative_parameters, 'YEAR_RPT'),
117: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_TYPE'),
118: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_ID'), effective_date, business_group_id
119: from pay_payroll_actions

Line 116: pay_fi_archive_psta.get_parameter (legislative_parameters, 'YEAR_RPT'),

112: ) is
113: select pay_fi_archive_psta.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER_ID'),
114: pay_fi_archive_psta.get_parameter (legislative_parameters, 'ARCHIVE'),
115: pay_fi_archive_psta.get_parameter (legislative_parameters, 'LOCAL_UNIT_ID'),
116: pay_fi_archive_psta.get_parameter (legislative_parameters, 'YEAR_RPT'),
117: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_TYPE'),
118: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_ID'), effective_date, business_group_id
119: from pay_payroll_actions
120: where payroll_action_id = p_payroll_action_id;

Line 117: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_TYPE'),

113: select pay_fi_archive_psta.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER_ID'),
114: pay_fi_archive_psta.get_parameter (legislative_parameters, 'ARCHIVE'),
115: pay_fi_archive_psta.get_parameter (legislative_parameters, 'LOCAL_UNIT_ID'),
116: pay_fi_archive_psta.get_parameter (legislative_parameters, 'YEAR_RPT'),
117: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_TYPE'),
118: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_ID'), effective_date, business_group_id
119: from pay_payroll_actions
120: where payroll_action_id = p_payroll_action_id;
121:

Line 118: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_ID'), effective_date, business_group_id

114: pay_fi_archive_psta.get_parameter (legislative_parameters, 'ARCHIVE'),
115: pay_fi_archive_psta.get_parameter (legislative_parameters, 'LOCAL_UNIT_ID'),
116: pay_fi_archive_psta.get_parameter (legislative_parameters, 'YEAR_RPT'),
117: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_TYPE'),
118: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_ID'), effective_date, business_group_id
119: from pay_payroll_actions
120: where payroll_action_id = p_payroll_action_id;
121:
122: l_proc varchar2 (240) := g_package || ' GET_ALL_PARAMETERS ';

Line 222: pay_fi_archive_psta.get_all_parameters (

218: ORDER BY ppf.person_id';
219: --
220: --
221: /* Get the Parameters'value */
222: pay_fi_archive_psta.get_all_parameters (
223: p_payroll_action_id,
224: g_business_group_id,
225: g_legal_employer_id,
226: g_local_unit_id,

Line 313: l_country := pay_fi_archive_psta.get_country_name (rl_get_org_address.country);

309: l_postal_code := rl_get_org_address.postal_code;
310: end if;
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,

Line 867: pay_fi_archive_psta.get_all_parameters (

863: end;
864: -- l_prepay_action_id NUMBER;
865: begin
866: /* Get the Parameters'value */
867: pay_fi_archive_psta.get_all_parameters (
868: p_payroll_action_id,
869: g_business_group_id,
870: g_legal_employer_id,
871: g_local_unit_id,

Line 1462: l_country := pay_fi_archive_psta.get_country_name (rl_primary_address.country);

1458: else
1459: l_postal_code := rl_primary_address.postal_code;
1460: end if;
1461:
1462: l_country := pay_fi_archive_psta.get_country_name (rl_primary_address.country);
1463: /* Retrieve the Permanent Address*/
1464: open csr_permanent_address (i.person_id, l_effective_date);
1465: fetch csr_permanent_address into rl_permanent_address;
1466: close csr_permanent_address;

Line 1474: l_permanent_country := pay_fi_archive_psta.get_country_name (rl_permanent_address.country);

1470: else
1471: l_permanent_postal_code := rl_permanent_address.postal_code;
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,

Line 1515: pay_fi_archive_psta.archive_person_address_details (

1511: p_action_information27 => l_permanent_country,
1512: p_assignment_id => i.assignment_id
1513: );
1514: /* Call procedure to archive person details
1515: pay_fi_archive_psta.archive_person_address_details (
1516: p_person_id => i.person_id,
1517: p_assignment_action_id => p_arch_assignment_action_id,
1518: p_assignment_id => i.assignment_id
1519: );*/

Line 1732: l_country := pay_fi_archive_psta.get_country_name (rl_primary_address.country);

1728: else
1729: l_postal_code := rl_primary_address.postal_code;
1730: end if;
1731:
1732: l_country := pay_fi_archive_psta.get_country_name (rl_primary_address.country);
1733: /* Retrieve the Permanent Address*/
1734: open csr_permanent_address (p_person_id);
1735: fetch csr_permanent_address into rl_permanent_address;
1736: close csr_permanent_address;

Line 1744: l_permanent_country := pay_fi_archive_psta.get_country_name (rl_permanent_address.country);

1740: else
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',

Line 1843: end pay_fi_archive_psta;

1839: hr_utility.trace ('SQLERR - ' || sqlerrm);
1840: end get_balance_value;
1841: --
1842: --
1843: end pay_fi_archive_psta;