The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT hxt_seqno.nextval
INTO l_EXCEP_seqno
FROM dual;
insert into hxt_errors_f(id, error_msg, creation_date, location,--ORA135
created_by, err_type, PPB_ID, TIM_ID, HRW_ID, PTP_ID, ora_message
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
,PERSON_ID
,PAYROLL_ID
)
values(l_EXCEP_seqno,
substr(nvl(l_ERROR_MSG,'NOTPROVIDED'),1,239),
sysdate,
substr(nvl(p_LOCATION,'NOTPROVIDED'),1,119),
nvl(l_CREATED_BY,-1),
p_TYPE, p_PPB_id, p_TIM_id, p_HRW_ID, p_PTP_ID,
substr(p_ORA_MSG,1,119)
,nvl(p_EFFECTIVE_START_DATE,sysdate)
,nvl(p_EFFECTIVE_END_DATE,hr_general.end_of_time)
,l_Person_ID
,l_Payroll_ID
); --FORMS60
insert into hxt_errors_f(id, error_msg, creation_date, location,
created_by, err_type, PPB_ID, TIM_ID, HRW_ID, PTP_ID, ora_message
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE)
values(l_EXCEP_seqno,
FND_MESSAGE.GET||' '||nls_initcap(substr(p_error_msg,1,100)),
sysdate, 'ERROR', 999, 'NEW', 999, 999, 999, 999,
l_error
,nvl(p_EFFECTIVE_START_DATE,sysdate)
,nvl(p_EFFECTIVE_END_DATE,hr_general.end_of_time)); --FORMS60
SELECT hxt_seqno.nextval
INTO l_EXCEP_seqno
FROM dual;
insert into hxt_errors_f(id, error_msg, creation_date, location,--ORA135
created_by, err_type, TIM_ID, HRW_ID, PTP_ID, ora_message
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
,PERSON_ID --ER230
,PAYROLL_ID --ER230
)
values(l_EXCEP_seqno,
substr(nvl(l_ERROR_MSG,'NOTPROVIDED'),1,239),
sysdate,
substr(nvl(p_LOCATION,'NOTPROVIDED'),1,119),
nvl(l_CREATED_BY,-1),
p_TYPE, p_TIM_id, p_HRW_ID, p_PTP_ID,
substr(p_ORA_MSG,1,119)
,nvl(p_EFFECTIVE_START_DATE,sysdate)
,nvl(p_EFFECTIVE_END_DATE,hr_general.end_of_time)
,l_Person_ID
,l_Payroll_ID
);
insert into hxt_errors_f(id, error_msg, creation_date, location,
created_by, err_type, TIM_ID, HRW_ID, PTP_ID, ora_message
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE)
values(l_EXCEP_seqno,
FND_MESSAGE.GET||' '||nls_initcap(substr(p_error_msg,1,100)),
sysdate, 'ERROR', 999, 'NEW', 999, 999, 999,
l_error
,nvl(p_EFFECTIVE_START_DATE,sysdate)
,nvl(p_EFFECTIVE_END_DATE,hr_general.end_of_time));
select
ACCRUAL_PLAN_ID,
ACCRUAL_PLAN_NAME,
ACCRUAL_PLAN_ELEMENT_TYPE_ID,
ACCRUAL_CATEGORY,
ACCRUAL_CATEGORY_NAME,
PTO_ELEMENT_TYPE_ID,
PTO_ELEMENT_NAME,
PTO_INPUT_VALUE_ID,
PTO_INPUT_VALUE_NAME
FROM PAY_ACCRUAL_PLANS_V
WHERE PTO_ELEMENT_TYPE_ID = p_element_type_id;
select sum(hours)
from hxt_timecards tim, hxt_sum_hours_worked hrw
where hrw.tim_id = tim.id
and tim.time_period_id = p_period_id
and hrw.assignment_id = p_assignement_id
and hrw.element_type_id = p_element_type_id;
select hdy.id, hdy.hours, hdy.holiday_date
from hxt_holiday_days hdy
,hxt_holiday_calendars hcl
where hdy.holiday_date between p_date - 1 and p_date + 1
and hdy.hcl_id = hcl.id
and p_date between hcl.effective_start_date
and hcl.effective_end_date
and hcl.id = p_hol_id;
SELECT user_name
FROM fnd_user
WHERE user_id = a_user_id;
SELECT eltv.hxt_earning_category
INTO l_earning_cat
FROM hxt_pay_element_types_f_ddf_v eltv
WHERE eltv.element_type_id = p_element_type_id
AND p_date_worked BETWEEN eltv.effective_start_date
AND eltv.effective_end_date;
SELECT 1
FROM hxt_per_aei_ddf_v aeiv
WHERE ( aeiv.hxt_rotation_plan = p_policy_id
OR aeiv.hxt_earning_policy = p_policy_id
OR aeiv.hxt_hour_deduction_policy = p_policy_id
OR aeiv.hxt_shift_differential_policy = p_policy_id
)
AND ( p_policy_end_date
+ 1 BETWEEN aeiv.effective_start_date
AND aeiv.effective_end_date
OR p_policy_end_date IS NULL
);
SELECT aeiv.hxt_rotation_plan
, egp.id
, aeiv.hxt_hour_deduction_policy
, aeiv.hxt_shift_differential_policy
, egp.fcl_earn_type
, egp.egt_id
, egp.pep_id
, egp.pip_id
, egp.hcl_id
, egp.min_tcard_intvl
, egp.round_up
, hcl.element_type_id
FROM
hxt_earning_policies egp
, hxt_holiday_calendars hcl
, hxt_per_aei_ddf_v aeiv
, per_all_assignments_f asm
WHERE asm.assignment_id = p_assignment_id
AND asm.assignment_id = aeiv.assignment_id
AND c_date between aeiv.effective_start_date
and aeiv.effective_end_date
AND c_date between asm.effective_start_date
and asm.effective_end_date
AND c_date between hcl.effective_start_date
and hcl.effective_end_date
AND egp.hcl_id = hcl.id
AND c_date between egp.effective_start_date
and egp.effective_end_date
AND egp.id = DECODE(c_earn_pol_id, NULL, aeiv.hxt_earning_policy, c_earn_pol_id);
SELECT rts.tws_id
INTO p_work_id
FROM hxt_rotation_schedules rts
WHERE rts.rtp_id = p_rotation_id
AND rts.start_date = (SELECT MAX(start_date)
FROM hxt_rotation_schedules
WHERE rtp_id = p_rotation_id
AND start_date <= p_date
);
SELECT wsh.off_shift_prem_id,
wsh.shift_diff_ovrrd_id,
sht.standard_start,
sht.standard_stop,
sht.early_start,
sht.late_stop,
sht.hours
INTO p_osp_id,
p_sdf_id,
p_standard_start,
p_standard_stop,
p_early_start,
p_late_stop,
p_hours
FROM hxt_shifts sht,
hxt_weekly_work_schedules wws,
hxt_work_shifts wsh
WHERE wsh.week_day = hxt_util.get_week_day(p_date)
AND wws.id = wsh.tws_id
AND p_date between wws.date_from
and nvl(wws.date_to, p_date)
AND wws.id = p_work_id
AND sht.id = wsh.sht_id;
select ptp.end_date
from per_time_periods ptp,
hxt_timecards_f htf
where htf.batch_id = p_batch_id
and htf.time_period_id = ptp.time_period_id;
select ptp.end_date
from per_time_periods ptp,
hxt_det_hours_worked_f hdh,
hxt_timecards_f htf
where hdh.retro_batch_id = p_batch_id
and hdh.tim_id = htf.id
and htf.time_period_id = ptp.time_period_id;
SELECT NVL(MAX(seqno),0) INTO returned_seqno FROM hxt_sum_hours_worked thw --C421
WHERE thw.tim_id = a_timecard_id
AND thw.date_worked = a_date_worked;
SELECT start_date INTO returned_date
FROM per_time_periods
WHERE TIME_PERIOD_ID = a_period_id;
SELECT end_date INTO returned_date
FROM per_time_periods
WHERE TIME_PERIOD_ID = a_period_id;
select retro_batch_id, assignment_id
from hxt_det_hours_worked det,
hxt_batch_states tbs
where det.tim_id = p_tim_id
and tbs.batch_id=det.retro_batch_id
and tbs.status in ('H','VE')
and pay_status = 'R';
select retro_batch_id, assignment_id, pbh.batch_reference
from hxt_det_hours_worked det,
hxt_batch_states tbs,
pay_batch_headers pbh
where det.tim_id = p_tim_id
and tbs.batch_id = det.retro_batch_id
and tbs.status in ('H','VE')
and pay_status = 'R'
and pbh.batch_id = tbs.batch_id;
select payroll_id, time_period_id, for_person_id
from hxt_timecards
where id = p_tim_id;
select asm.business_group_id
from per_assignment_status_types ast,
per_assignments_f asm
where asm.person_id = c_person_id
and ast.assignment_status_type_id = asm.assignment_status_type_id
and ast.pay_system_status = 'P'; -- Check payroll status
/* INSERT INTO pay_batch_headers
(batch_id,
business_group_id,
batch_name,
batch_status,
action_if_exists,
batch_reference,
batch_source,
purge_after_transfer,
reject_if_future_changes,
created_by,
creation_date)
VALUES
(l_batch_id,
l_bus_group_id,
l_batch_name,
'U',
'I',
l_reference_num,
'OTM',
'N',
'N',
l_user_id,
l_sysdate);*/
pay_batch_element_entry_api.update_batch_header (
p_session_date => l_sysdate,
p_batch_id=> l_batch_id,
p_object_version_number=> l_object_version_number,
p_batch_name=> l_batch_name
);
Select vital information from the fnd_id_flex_structures and
fnd_id_flex_segments tables to build concatenated segments
string using the segment values passed into this function.
Then create a new entry to the pay_cost_allocation_keyflex table
for the Cost Allocation Flexfield or retrieve the id of an existing
one by calling the hr function hr_entry.maintain_cost_keyflex.
******************************************************************/
FUNCTION build_cost_alloc_flex_entry(i_segment1 IN VARCHAR2,
i_segment2 IN VARCHAR2,
i_segment3 IN VARCHAR2,
i_segment4 IN VARCHAR2,
i_segment5 IN VARCHAR2,
i_segment6 IN VARCHAR2,
i_segment7 IN VARCHAR2,
i_segment8 IN VARCHAR2,
i_segment9 IN VARCHAR2,
i_segment10 IN VARCHAR2,
i_segment11 IN VARCHAR2,
i_segment12 IN VARCHAR2,
i_segment13 IN VARCHAR2,
i_segment14 IN VARCHAR2,
i_segment15 IN VARCHAR2,
i_segment16 IN VARCHAR2,
i_segment17 IN VARCHAR2,
i_segment18 IN VARCHAR2,
i_segment19 IN VARCHAR2,
i_segment20 IN VARCHAR2,
i_segment21 IN VARCHAR2,
i_segment22 IN VARCHAR2,
i_segment23 IN VARCHAR2,
i_segment24 IN VARCHAR2,
i_segment25 IN VARCHAR2,
i_segment26 IN VARCHAR2,
i_segment27 IN VARCHAR2,
i_segment28 IN VARCHAR2,
i_segment29 IN VARCHAR2,
i_segment30 IN VARCHAR2,
i_business_group_id IN NUMBER,
io_keyflex_id IN OUT NOCOPY NUMBER,
o_error_msg OUT NOCOPY VARCHAR2)
-- p_mode IN VARCHAR2 default 'INSERT')
RETURN NUMBER IS
/* This cursor selects Cost Allocation Flexfield info needed */
/* to build an entry to pay_cost_allocation_keyflex */
CURSOR cost_cur IS
SELECT fifs.concatenated_segment_delimiter,
fifs.dynamic_inserts_allowed_flag,
fifs.enabled_flag,
fifs.freeze_flex_definition_flag
FROM fnd_id_flex_structures fifs,
per_business_groups_perf pbg
WHERE fifs.id_flex_code = 'COST'
AND fifs.application_id = 801
AND pbg.business_group_id = i_business_group_id
AND pbg.cost_allocation_structure = fifs.id_flex_num;
/* This cursor selects Cost Allocation Flexfield segments */
/* that have been defined and are enabled and have been */
/* qualified for element entry */
--CURSOR seg_cur IS
--CURSOR seg_cur(c_id_flex_num NUMBER) IS
-- SELECT seg.application_column_name,
-- seg.display_size,
-- seg.segment_num
-- FROM fnd_id_flex_segments seg
-- WHERE seg.id_flex_code = 'COST'
-- AND seg.application_id = 801
-- AND seg.id_flex_num = c_id_flex_num
-- AND seg.application_column_name IN
-- ('SEGMENT1','SEGMENT2','SEGMENT3','SEGMENT4','SEGMENT5',
-- 'SEGMENT6','SEGMENT7','SEGMENT8','SEGMENT9','SEGMENT10',
-- 'SEGMENT11','SEGMENT12','SEGMENT13','SEGMENT14','SEGMENT15',
-- 'SEGMENT16','SEGMENT17','SEGMENT18','SEGMENT19','SEGMENT20',
-- 'SEGMENT21','SEGMENT22','SEGMENT23','SEGMENT24','SEGMENT25',
-- 'SEGMENT26','SEGMENT27','SEGMENT28','SEGMENT29','SEGMENT30')
-- AND seg.enabled_flag = 'Y'
-- AND EXISTS (SELECT 'X'
-- FROM fnd_segment_attribute_values fsav
-- WHERE fsav.id_flex_code = 'COST'
-- AND fsav.application_id = 801
-- AND fsav.id_flex_num = seg.id_flex_num
-- AND fsav.application_column_name = seg.application_column_name
-- AND fsav.attribute_value = 'Y')
-- ORDER BY seg.segment_num;
l_allowed fnd_id_flex_structures.dynamic_inserts_allowed_flag%TYPE;
SELECT
PAP.ACCRUAL_PLAN_ID,
PAP.ACCRUAL_CATEGORY
FROM
PAY_ELEMENT_TYPES_F PETF,
PAY_ELEMENT_CLASSIFICATIONS PEC,
PAY_ELEMENT_ENTRIES_F PEEF,
PAY_ELEMENT_LINKS_F PELF,
PAY_ACCRUAL_PLANS PAP
WHERE
PEEF.ASSIGNMENT_ID=P_assignment_id
AND PETF.CLASSIFICATION_ID=PEC.CLASSIFICATION_ID
AND UPPER(PEC.CLASSIFICATION_NAME) LIKE UPPER('PTO Accrual%')
AND PETF.ELEMENT_TYPE_ID=PELF.ELEMENT_TYPE_ID
AND PEEF.ELEMENT_LINK_ID=PELF.ELEMENT_LINK_ID
AND p_calculation_date BETWEEN PETF.EFFECTIVE_START_DATE
AND PETF.EFFECTIVE_END_DATE
AND PETF.ELEMENT_TYPE_ID = PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID;
select sum(hrw.hours)
from
hxt_sum_hours_worked_x hrw
where
hrw.tim_id = p_tim_id
and hrw.assignment_id = p_assignment_id
and hrw.element_type_id = p_element_type_id;
SELECT vap.assignment_id, vap.accrual_plan_id, vap.accrual_plan_name,
vap.accrual_category, vap.business_group_id
FROM pay_view_accrual_plans_v vap
WHERE vap.assignment_id = p_assignment_id
AND p_calculation_date BETWEEN vap.asg_effective_start_date
AND vap.asg_effective_end_date
AND p_calculation_date BETWEEN vap.iv_effective_start_date
AND vap.iv_effective_end_date
AND p_calculation_date BETWEEN vap.e_entry_effective_start_date
AND vap.e_entry_effective_end_date
AND p_calculation_date BETWEEN vap.e_type_effective_start_date
AND vap.e_type_effective_end_date
AND p_calculation_date BETWEEN vap.e_link_effective_start_date
AND vap.e_link_effective_end_date;
SELECT pee.assignment_id,
pap.accrual_plan_id,
pap.accrual_plan_name,
pap.accrual_category,
pap.business_group_id
FROM pay_element_entries_f pee,
pay_element_links_f pel,
pay_element_types_f pet,
pay_accrual_plans pap
WHERE pee.assignment_id = p_assignment_id
AND p_calculation_date BETWEEN pee.effective_start_date
AND pee.effective_end_date
AND pel.element_link_id = pee.element_link_id
AND p_calculation_date BETWEEN pel.effective_start_date
AND pel.effective_end_date
AND pel.element_type_id = pet.element_type_id
AND p_calculation_date BETWEEN pet.effective_start_date
AND pet.effective_end_date
AND pet.element_type_id = pap.accrual_plan_element_type_id;
SELECT DISTINCT (assignment_id)
FROM hxt_sum_hours_worked_f
WHERE tim_id = p_tim_id
AND DATE_WORKED=p_calculation_date
AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
SELECT assignment_id
FROM hxt_sum_hours_worked_f
WHERE tim_id = p_tim_id
AND DATE_WORKED<=p_calculation_date
AND SYSDATE BETWEEN effective_start_date AND effective_end_date
ORDER BY date_worked DESC;
SELECT sum(hrw.hours*(-1)*(ncr.add_or_subtract))
FROM hxt_sum_hours_worked_f hrw,
pay_net_calculation_rules_v ncr
WHERE hrw.tim_id = p_tim_id
and SYSDATE between hrw.effective_start_date
and hrw.effective_end_date
AND hrw.assignment_id = p_assignment_id
AND ncr.business_group_id +0 = p_bus_group_id
AND ncr.accrual_plan_id = p_accrual_plan_id
AND ncr.element_type_id = hrw.element_type_id;
SELECT /*+ ORDERED */
SUM(hrw.hours*(-1)*(ncr.add_or_subtract))
FROM hxt_sum_hours_worked_f hrw,
pay_element_types_f pef,
pay_input_values_f piv,
pay_net_calculation_rules ncr
WHERE hrw.tim_id = p_tim_id
AND SYSDATE BETWEEN hrw.effective_start_date
AND hrw.effective_end_date
AND hrw.assignment_id = p_assignment_id
AND pef.element_type_id = hrw.element_type_id
AND SYSDATE BETWEEN pef.effective_start_date
AND pef.effective_end_date
AND piv.element_type_id = pef.element_type_id
AND SYSDATE BETWEEN piv.effective_start_date
AND piv.effective_end_date
AND piv.input_value_id = ncr.input_value_id
AND ncr.business_group_id +0 = p_bus_group_id
AND ncr.accrual_plan_id = p_accrual_plan_id ;
select max(batch_id) from pay_batch_headers pbh
where pbh.batch_status='T'
and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f
where tim_id=p_tim_id);
select batch_id from pay_batch_headers pbh
where pbh.batch_status='T'
and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f
where tim_id=p_tim_id);
select null from pay_batch_headers pbh
where pbh.batch_status='T'
and pbh.batch_id in (select distinct batch_id from hxt_timecards_f
where id=p_tim_id);
SELECT nvl(sum(det.hours*(-1)*(ncr.add_or_subtract)),0)
FROM hxt_det_hours_worked_f det,
pay_net_calculation_rules_v ncr
WHERE det.tim_id = p_tim_id
AND det.assignment_id = p_assignment_id
AND ncr.business_group_id = p_bus_group_id
AND ncr.accrual_plan_id = p_accrual_plan_id
AND ncr.element_type_id = det.element_type_id
AND det.retro_batch_id=p_batch_id;
SELECT nvl(sum(det.hours*(-1)*(ncr.add_or_subtract)),0)
FROM hxt_det_hours_worked_f det,
pay_net_calculation_rules_v ncr
WHERE det.tim_id = p_tim_id
AND det.assignment_id = p_assignment_id
AND ncr.business_group_id = p_bus_group_id
AND ncr.accrual_plan_id = p_accrual_plan_id
AND ncr.element_type_id = det.element_type_id
AND det.retro_batch_id is null;
SELECT pel.costable_type
FROM pay_element_links_f pel,
per_assignments_f asm
WHERE asm.assignment_id = p_assignment_id
AND p_date_worked BETWEEN asm.effective_start_date
AND asm.effective_end_date
AND nvl(pel.organization_id,nvl(asm.organization_id,-1)) = nvl(asm.organization_id,-1)
AND (pel.people_group_id IS NULL
OR exists (SELECT 'X'
FROM pay_assignment_link_usages_f usage
WHERE usage.assignment_id = asm.assignment_id
AND usage.element_link_id = pel.element_link_id
AND p_date_worked BETWEEN usage.effective_start_date
AND usage.effective_end_date))
AND nvl(pel.job_id, nvl(asm.job_id,-1)) = nvl(asm.job_id,-1)
AND nvl(pel.position_id, nvl(asm.position_id,-1)) = nvl(asm.position_id,-1)
AND nvl(pel.grade_id,nvl(asm.grade_id,-1)) = nvl(asm.grade_id,-1)
AND nvl(pel.location_id,nvl(asm.location_id,-1)) = nvl(asm.location_id,-1)
AND nvl(pel.payroll_id,nvl(asm.payroll_id,-1)) = nvl(asm.payroll_id,-1)
AND nvl(pel.employment_category,nvl(asm.employment_category,-1)) = nvl(asm.employment_category,-1)
AND nvl(pel.pay_basis_id,nvl(asm.pay_basis_id,-1)) = nvl(asm.pay_basis_id,-1)
AND nvl(pel.business_group_id,nvl(asm.business_group_id,-1)) = nvl(asm.business_group_id,-1)
AND p_date_worked BETWEEN pel.effective_start_date
AND pel.effective_end_date
AND pel.element_type_id = p_element_type_id;
* inserting record in HXT_ERRORS table when an error is found *
* regarding Timecard, summary, detailed Hours Worked orPay *
* Period record.of hxt_errors. *
* *
* Arguments *
* p_PBD_ID - The source of the error is the BATCH record *
* p_TIM_ID - The source of the error is the TIMECARD record *
* p_HRW_ID - The source of the error is the Hours Worked record *
* p_PTP_ID - The source of the error is the TIME PERIOD RECORD. *
* p_ERROR_MSG - the error message to show the user *
* p_LOCATION - the Procedure or Source *
* p_ORA_MSG - the ORACLE error number and message if any *
* *
********************************************************************/
Procedure SET_TIMECARD_ERROR (p_PPB_ID IN NUMBER,
p_TIM_ID IN NUMBER,
p_HRW_ID IN NUMBER,
p_PTP_ID IN NUMBER,
p_ERROR_MSG IN OUT NOCOPY VARCHAR2,
p_LOCATION IN VARCHAR2,
p_ORA_MSG IN VARCHAR2,
p_LOOKUP_CODE IN VARCHAR2,
p_valid OUT NOCOPY VARCHAR,
p_msg_level OUT NOCOPY VARCHAR2) IS
CURSOR tim_dates is
SELECT effective_start_date,
effective_end_date
FROM HXT_TIMECARDS_X
WHERE id = p_tim_id;
SELECT hxt_seqno.nextval
INTO l_EXCEP_seqno
FROM dual;
insert into hxt_errors_f(
id,
error_msg,
creation_date,
location,
created_by,
err_type,
PPB_ID,
TIM_ID,
HRW_ID,
PTP_ID,
ora_message,
EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE
,PERSON_ID --ER230
,PAYROLL_ID --ER230
)
values(l_EXCEP_seqno,
substr(nvl(l_ERROR_MSG,'NOTPROVIDED'),1,239),
sysdate,
substr(nvl(p_LOCATION,'NOTPROVIDED'),1,119),
nvl(l_CREATED_BY,-1),
l_TYPE,
p_PPB_id,
p_TIM_id,
p_HRW_ID,
p_PTP_ID,
substr(p_ORA_MSG,1,119),
nvl(l_eff_start,sysdate),
nvl(l_eff_end,hr_general.end_of_time)
,l_Person_ID /* ER230 */
,l_Payroll_ID /* ER230 */
);
insert into hxt_errors_f(
id,
error_msg,
creation_date,
location,
created_by,
err_type,
PPB_ID,
TIM_ID,
HRW_ID,
PTP_ID,
ora_message,
EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE)
values(l_EXCEP_seqno,
FND_MESSAGE.GET
||nls_initcap(substr(p_error_msg,1,100)),
sysdate,
'SET_TIMECARD_ERROR',
-1,
'NEW',
NULL,
NULL,
NULL,
NULL,
l_error,
nvl(l_eff_start,sysdate),
nvl(l_eff_end,hr_general.end_of_time)
);
select
meaning,
UPPER(TAG)
FROM fnd_lookup_values
WHERE lookup_code = p_lookup_code
AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE)
AND NVL(end_date_active, SYSDATE)
AND LANGUAGE = userenv('LANG')
AND VIEW_APPLICATION_ID = 3
AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE,VIEW_APPLICATION_ID)
AND enabled_flag = 'Y'
AND lookup_type = p_lookup_type;
select tim.for_person_id
from hxt_timecards_x tim
where tim.id = c_tim_id;
select ptp.payroll_id
from per_time_periods ptp
where ptp.time_period_id = c_ptp_id;
SELECT 'Y'
FROM pay_batch_headers pbh
WHERE pbh.batch_status <> 'T'
AND pbh.batch_id = p_batch_id
AND EXISTS ((SELECT HTF.batch_id
FROM hxt_timecards_f HTF
WHERE HTF.batch_id = pbh.batch_id)
UNION
(SELECT hdhw.retro_batch_id
FROM hxt_det_hours_worked_f hdhw
WHERE hdhw.retro_batch_id = pbh.batch_id));
HR_UTILITY.SET_MESSAGE(808, 'HXT_39144_CANT_DELETE_BATCH'); --This message is
select DECODE (MOD (trunc(p_date)-trunc(hr_general.START_OF_TIME),7),
0,'SAT',
1,'SUN',
2,'MON',
3,'TUE',
4,'WED',
5,'THU',
6,'FRI'
)
from dual;
SELECT 'Y'
FROM hxt_timecards_f
WHERE for_person_id = p_person_id;
SELECT 'Y'
FROM hxc_time_building_blocks
WHERE resource_id = p_person_id
AND date_to=hr_general.end_of_time
AND ROWNUM<2;