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.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PER_HU_ABS_REP_ARCHIVE_PKG

Line 1: PACKAGE BODY PER_HU_ABS_REP_ARCHIVE_PKG AS

1: PACKAGE BODY PER_HU_ABS_REP_ARCHIVE_PKG AS
2: /* $Header: pehuarep.pkb 120.1 2006/08/30 13:33:41 rbhardwa noship $ */
3: --
4: --globals
5: --

Line 57: ,fnd_date.canonical_to_date(per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'DATE'))

53: ) IS
54: --
55: CURSOR csr_parameter_info (c_payroll_action_id NUMBER) IS
56: SELECT effective_date
57: ,fnd_date.canonical_to_date(per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'DATE'))
58: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'PAYROLL_ID')
59: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'ASG_SET_ID')
60: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'EMP_ID')
61: ,business_group_id

Line 58: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'PAYROLL_ID')

54: --
55: CURSOR csr_parameter_info (c_payroll_action_id NUMBER) IS
56: SELECT effective_date
57: ,fnd_date.canonical_to_date(per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'DATE'))
58: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'PAYROLL_ID')
59: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'ASG_SET_ID')
60: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'EMP_ID')
61: ,business_group_id
62: FROM pay_payroll_actions

Line 59: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'ASG_SET_ID')

55: CURSOR csr_parameter_info (c_payroll_action_id NUMBER) IS
56: SELECT effective_date
57: ,fnd_date.canonical_to_date(per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'DATE'))
58: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'PAYROLL_ID')
59: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'ASG_SET_ID')
60: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'EMP_ID')
61: ,business_group_id
62: FROM pay_payroll_actions
63: WHERE payroll_action_id = c_payroll_action_id;

Line 60: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'EMP_ID')

56: SELECT effective_date
57: ,fnd_date.canonical_to_date(per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'DATE'))
58: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'PAYROLL_ID')
59: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'ASG_SET_ID')
60: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'EMP_ID')
61: ,business_group_id
62: FROM pay_payroll_actions
63: WHERE payroll_action_id = c_payroll_action_id;
64: --

Line 109: per_hu_abs_rep_archive_pkg.get_all_parameters (

105: lfull_name per_all_people_f.full_name%TYPE;
106: lbusiness_group_id per_all_people_f.business_group_id%TYPE;
107: BEGIN
108: --
109: per_hu_abs_rep_archive_pkg.get_all_parameters (
110: p_payroll_action_id => p_actid
111: ,p_business_group_id => lbusiness_group_id
112: ,p_effective_date => leffective_date
113: ,p_reporting_date => lreporting_date

Line 165: per_hu_abs_rep_archive_pkg.get_all_parameters (

161: l_emp_id per_all_people_f.person_id%TYPE;
162: l_exsist NUMBER;
163: BEGIN
164: --
165: per_hu_abs_rep_archive_pkg.get_all_parameters (
166: p_payroll_action_id => p_actid
167: ,p_business_group_id => g_business_group_id
168: ,p_effective_date => l_effective_date
169: ,p_reporting_date => g_reporting_date

Line 446: per_hu_abs_rep_archive_pkg.get_all_parameters (

442: l_base_hol_carry_over_sum := 0;
443: l_child_hol_carry_over_sum := 0;
444: l_add_hol_carry_over_sum := 0;
445: --
446: per_hu_abs_rep_archive_pkg.get_all_parameters (
447: p_payroll_action_id => p_actid
448: ,p_business_group_id => g_business_group_id
449: ,p_effective_date => l_effective_date
450: ,p_reporting_date => g_reporting_date

Line 1196: l_blind_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id

1192: EXIT WHEN csr_disability%NOTFOUND;
1193: IF p_disability_start_date>=p_period_start_date AND
1194: p_disability_start_date<=p_period_end_date AND
1195: p_disability_end_date>=p_period_end_date THEN
1196: l_blind_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id
1197: ,p_business_group_id
1198: ,p_disability_start_date
1199: ,p_period_end_date);
1200: ELSIF p_disability_start_date>=p_period_start_date AND

Line 1203: l_blind_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id

1199: ,p_period_end_date);
1200: ELSIF p_disability_start_date>=p_period_start_date AND
1201: p_disability_start_date<=p_period_end_date AND
1202: p_disability_end_date 1203: l_blind_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id
1204: ,p_business_group_id
1205: ,p_disability_start_date
1206: ,p_disability_end_date);
1207: ELSIF p_disability_start_date

Line 1209: l_blind_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id

1205: ,p_disability_start_date
1206: ,p_disability_end_date);
1207: ELSIF p_disability_start_date 1208: p_disability_end_date<=p_period_end_date THEN
1209: l_blind_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id
1210: ,p_business_group_id
1211: ,p_period_start_date
1212: ,p_disability_end_date);
1213: ELSIF p_disability_start_date<=p_period_start_date AND

Line 1215: l_blind_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id

1211: ,p_period_start_date
1212: ,p_disability_end_date);
1213: ELSIF p_disability_start_date<=p_period_start_date AND
1214: p_disability_end_date>=p_period_end_date THEN
1215: l_blind_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id
1216: ,p_business_group_id
1217: ,p_period_start_date
1218: ,p_period_end_date);
1219: END IF;

Line 1257: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id

1253: IF p_job_start_date>=p_period_start_date AND p_job_start_date<=p_period_end_date
1254: AND p_job_end_date>=p_period_end_date THEN
1255: -- check for date_to
1256: IF p_date_to <= p_period_end_date THEN
1257: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id
1258: ,p_business_group_id
1259: ,p_job_start_date
1260: ,p_date_to);
1261: ELSE

Line 1262: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id

1258: ,p_business_group_id
1259: ,p_job_start_date
1260: ,p_date_to);
1261: ELSE
1262: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id
1263: ,p_business_group_id
1264: ,p_job_start_date
1265: ,p_period_end_date);
1266: END IF;

Line 1272: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id

1268: p_job_start_date <= p_period_end_date AND
1269: p_job_end_date < p_period_end_date THEN
1270: -- check for date_to
1271: IF p_date_to <= p_job_end_date THEN
1272: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id
1273: ,p_business_group_id
1274: ,p_job_start_date
1275: ,p_date_to);
1276: ELSE

Line 1277: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id

1273: ,p_business_group_id
1274: ,p_job_start_date
1275: ,p_date_to);
1276: ELSE
1277: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id
1278: ,p_business_group_id
1279: ,p_job_start_date
1280: ,p_job_end_date);
1281: END IF;

Line 1286: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id

1282: ELSIF p_job_start_date < p_period_start_date AND
1283: p_job_end_date <= p_period_end_date THEN
1284: -- check for date_to
1285: IF p_date_to <=p_job_end_date THEN
1286: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id
1287: ,p_business_group_id
1288: ,p_period_start_date
1289: ,p_date_to);
1290: ELSE

Line 1291: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id

1287: ,p_business_group_id
1288: ,p_period_start_date
1289: ,p_date_to);
1290: ELSE
1291: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id
1292: ,p_business_group_id
1293: ,p_period_start_date
1294: ,p_job_end_date);
1295: END IF;

Line 1298: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id

1294: ,p_job_end_date);
1295: END IF;
1296: ELSIF p_job_start_date <= p_period_start_date AND
1297: p_job_end_date >= p_period_end_date THEN
1298: l_job_days := PER_HU_ABS_REP_ARCHIVE_PKG.working_day_count(p_assignment_id
1299: ,p_business_group_id
1300: ,p_period_start_date
1301: ,p_period_end_date);
1302: END IF;

Line 1335: END per_hu_abs_rep_archive_pkg;

1331: RETURN l_found_value;
1332: --
1333: END chk_entry_in_accrual_plan;
1334: --
1335: END per_hu_abs_rep_archive_pkg;