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_KW_ARCHIVE dependencies on PAY_KW_ARCHIVE

Line 1: PACKAGE BODY PAY_KW_ARCHIVE AS

1: PACKAGE BODY PAY_KW_ARCHIVE AS
2: /* $Header: pykwparc.pkb 120.8 2012/01/19 10:27:10 rpahune ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:

Line 38: g_package VARCHAR2(33) := ' PAY_KW_ARCHIVE.';

34: g_index NUMBER := -1;
35: g_index_assact NUMBER := -1;
36: g_index_bal NUMBER := -1;
37:
38: g_package VARCHAR2(33) := ' PAY_KW_ARCHIVE.';
39: g_payroll_action_id NUMBER;
40: g_arc_payroll_action_id NUMBER;
41: g_business_group_id NUMBER;
42: g_format_mask VARCHAR2(50);

Line 110: SELECT PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')

106: ,p_consolidation_set OUT NOCOPY VARCHAR2) IS
107: --
108: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
109:
110: SELECT PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
111: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
112: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
113: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
114: ,effective_date

Line 111: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')

107: --
108: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
109:
110: SELECT PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
111: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
112: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
113: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
114: ,effective_date
115: ,business_group_id

Line 112: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')

108: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
109:
110: SELECT PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
111: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
112: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
113: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
114: ,effective_date
115: ,business_group_id
116: FROM pay_payroll_actions

Line 113: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')

109:
110: SELECT PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
111: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
112: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
113: ,PAY_KW_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
114: ,effective_date
115: ,business_group_id
116: FROM pay_payroll_actions
117: WHERE payroll_action_id = p_payroll_action_id;

Line 254: PAY_KW_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

250: IF g_debug THEN
251: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
252: END IF;
253:
254: PAY_KW_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
255: ,l_business_group_id
256: ,l_start_date
257: ,l_end_date
258: ,l_effective_date

Line 520: PAY_KW_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

516: IF g_debug THEN
517: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
518: END IF;
519:
520: PAY_KW_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
521: ,l_business_group_id
522: ,l_start_date
523: ,l_end_date
524: ,l_effective_date

Line 1112: l_country:=PAY_KW_ARCHIVE.get_country_name(rec_primary_address.country);

1108:
1109: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
1110:
1111: /* COUNTRY */
1112: l_country:=PAY_KW_ARCHIVE.get_country_name(rec_primary_address.country);
1113:
1114: l_emp_country:=PAY_KW_ARCHIVE.get_country_name(rec_employer_address.country);
1115:
1116: l_org_country:=PAY_KW_ARCHIVE.get_country_name(rec_org_address.country);

Line 1114: l_emp_country:=PAY_KW_ARCHIVE.get_country_name(rec_employer_address.country);

1110:
1111: /* COUNTRY */
1112: l_country:=PAY_KW_ARCHIVE.get_country_name(rec_primary_address.country);
1113:
1114: l_emp_country:=PAY_KW_ARCHIVE.get_country_name(rec_employer_address.country);
1115:
1116: l_org_country:=PAY_KW_ARCHIVE.get_country_name(rec_org_address.country);
1117:
1118: /* Total Earnings YTD */

Line 1116: l_org_country:=PAY_KW_ARCHIVE.get_country_name(rec_org_address.country);

1112: l_country:=PAY_KW_ARCHIVE.get_country_name(rec_primary_address.country);
1113:
1114: l_emp_country:=PAY_KW_ARCHIVE.get_country_name(rec_employer_address.country);
1115:
1116: l_org_country:=PAY_KW_ARCHIVE.get_country_name(rec_org_address.country);
1117:
1118: /* Total Earnings YTD */
1119: l_defined_balance_id := PAY_KW_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_EARNINGS_ASG_YTD');
1120: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

Line 1119: l_defined_balance_id := PAY_KW_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_EARNINGS_ASG_YTD');

1115:
1116: l_org_country:=PAY_KW_ARCHIVE.get_country_name(rec_org_address.country);
1117:
1118: /* Total Earnings YTD */
1119: l_defined_balance_id := PAY_KW_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_EARNINGS_ASG_YTD');
1120: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
1121:
1122: l_formatted_value := to_char(l_balance_value, g_format_mask);
1123:

Line 1125: l_defined_balance_id_ded := PAY_KW_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_DEDUCTIONS_ASG_YTD');

1121:
1122: l_formatted_value := to_char(l_balance_value, g_format_mask);
1123:
1124: /* Total Deductions YTD */
1125: l_defined_balance_id_ded := PAY_KW_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_DEDUCTIONS_ASG_YTD');
1126: l_balance_value_ded := pay_balance_pkg.get_value(l_defined_balance_id_ded, p_assignment_action_id);
1127:
1128: l_formatted_value_ded := to_char(l_balance_value_ded, g_format_mask);
1129:

Line 1979: PAY_KW_ARCHIVE.SETUP_BALANCE_DEFINITIONS(p_balance_name => rec_get_balance.narrative

1975: OPEN csr_uom(rec_get_balance.balance_type_id);
1976: FETCH csr_uom INTO l_uom;
1977: CLOSE csr_uom;
1978:
1979: PAY_KW_ARCHIVE.SETUP_BALANCE_DEFINITIONS(p_balance_name => rec_get_balance.narrative
1980: ,p_defined_balance_id => l_defined_balance_id
1981: ,p_balance_type_id => rec_get_balance.balance_type_id
1982: ,p_uom => l_uom);
1983: END LOOP;

Line 2206: END PAY_KW_ARCHIVE;

2202: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
2203: END IF;
2204:
2205: END ARCHIVE_CODE;
2206: END PAY_KW_ARCHIVE;