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.HR_PERSON_ABSENCE_API dependencies on HR_PERSON_ABSENCE_SWI

Line 3180: hr_person_absence_swi.getStartDate(hat.transaction_id) ActualDateStart,

3176:
3177: cursor csr_sshr_abs_records(p_mode varchar2) is
3178:
3179: select
3180: hr_person_absence_swi.getStartDate(hat.transaction_id) ActualDateStart,
3181: hr_person_absence_swi.getEndDate(hat.transaction_id) ActualDateEnd,
3182: nvl(hr_xml_util.get_node_value(hat.transaction_id,'TimeStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3183: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
3184: hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',

Line 3181: hr_person_absence_swi.getEndDate(hat.transaction_id) ActualDateEnd,

3177: cursor csr_sshr_abs_records(p_mode varchar2) is
3178:
3179: select
3180: hr_person_absence_swi.getStartDate(hat.transaction_id) ActualDateStart,
3181: hr_person_absence_swi.getEndDate(hat.transaction_id) ActualDateEnd,
3182: nvl(hr_xml_util.get_node_value(hat.transaction_id,'TimeStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3183: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
3184: hr_xml_util.get_node_value(hat.transaction_id,'TimeProjectedStart','Transaction/TransCache/AM/TXN/EO/PerAbsenceAttendancesEORow',
3185: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)),

Line 3211: AND hr_person_absence_swi.getstartdate(hat.transaction_id) is NOT NULL

3207: --hat.creator_person_id = 125
3208: and hat.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES'
3209: and hrtsteps.TRANSACTION_ID= hat.TRANSACTION_ID
3210: and hat.STATUS not in ('W','S','N','D','AC') -- bug9554066
3211: AND hr_person_absence_swi.getstartdate(hat.transaction_id) is NOT NULL
3212: AND hr_person_absence_swi.getenddate(hat.transaction_id) is NOT NULL
3213: and (p_start_date <= hr_person_absence_swi.getEndDate(hat.transaction_id) and
3214: p_end_date >= hr_person_absence_swi.getStartDate(hat.transaction_id) )
3215:

Line 3212: AND hr_person_absence_swi.getenddate(hat.transaction_id) is NOT NULL

3208: and hat.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES'
3209: and hrtsteps.TRANSACTION_ID= hat.TRANSACTION_ID
3210: and hat.STATUS not in ('W','S','N','D','AC') -- bug9554066
3211: AND hr_person_absence_swi.getstartdate(hat.transaction_id) is NOT NULL
3212: AND hr_person_absence_swi.getenddate(hat.transaction_id) is NOT NULL
3213: and (p_start_date <= hr_person_absence_swi.getEndDate(hat.transaction_id) and
3214: p_end_date >= hr_person_absence_swi.getStartDate(hat.transaction_id) )
3215:
3216: and hr_xml_util.get_node_value(hat.transaction_id,'AbsenceAction','Transaction/TransCtx/CNode',

Line 3213: and (p_start_date <= hr_person_absence_swi.getEndDate(hat.transaction_id) and

3209: and hrtsteps.TRANSACTION_ID= hat.TRANSACTION_ID
3210: and hat.STATUS not in ('W','S','N','D','AC') -- bug9554066
3211: AND hr_person_absence_swi.getstartdate(hat.transaction_id) is NOT NULL
3212: AND hr_person_absence_swi.getenddate(hat.transaction_id) is NOT NULL
3213: and (p_start_date <= hr_person_absence_swi.getEndDate(hat.transaction_id) and
3214: p_end_date >= hr_person_absence_swi.getStartDate(hat.transaction_id) )
3215:
3216: and hr_xml_util.get_node_value(hat.transaction_id,'AbsenceAction','Transaction/TransCtx/CNode',
3217: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)=p_mode

Line 3214: p_end_date >= hr_person_absence_swi.getStartDate(hat.transaction_id) )

3210: and hat.STATUS not in ('W','S','N','D','AC') -- bug9554066
3211: AND hr_person_absence_swi.getstartdate(hat.transaction_id) is NOT NULL
3212: AND hr_person_absence_swi.getenddate(hat.transaction_id) is NOT NULL
3213: and (p_start_date <= hr_person_absence_swi.getEndDate(hat.transaction_id) and
3214: p_end_date >= hr_person_absence_swi.getStartDate(hat.transaction_id) )
3215:
3216: and hr_xml_util.get_node_value(hat.transaction_id,'AbsenceAction','Transaction/TransCtx/CNode',
3217: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)=p_mode
3218: and p_start_date between piv.EFFECTIVE_START_DATE and piv.EFFECTIVE_END_DATE

Line 3259: AND hr_person_absence_swi.getstartdate(hat.transaction_id) is NOT NULL

3255: --hat.creator_person_id = 125
3256: and hat.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES'
3257: and hrtsteps.TRANSACTION_ID= hat.TRANSACTION_ID
3258: and hat.STATUS not in ('W','S','N','D','AC') -- BUG 9554066
3259: AND hr_person_absence_swi.getstartdate(hat.transaction_id) is NOT NULL
3260: AND hr_person_absence_swi.getenddate(hat.transaction_id) is NOT NULL
3261: and (p_start_date <= hr_person_absence_swi.getEndDate(hat.transaction_id) and
3262: p_end_date >= hr_person_absence_swi.getStartDate(hat.transaction_id) ));
3263:

Line 3260: AND hr_person_absence_swi.getenddate(hat.transaction_id) is NOT NULL

3256: and hat.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES'
3257: and hrtsteps.TRANSACTION_ID= hat.TRANSACTION_ID
3258: and hat.STATUS not in ('W','S','N','D','AC') -- BUG 9554066
3259: AND hr_person_absence_swi.getstartdate(hat.transaction_id) is NOT NULL
3260: AND hr_person_absence_swi.getenddate(hat.transaction_id) is NOT NULL
3261: and (p_start_date <= hr_person_absence_swi.getEndDate(hat.transaction_id) and
3262: p_end_date >= hr_person_absence_swi.getStartDate(hat.transaction_id) ));
3263:
3264:

Line 3261: and (p_start_date <= hr_person_absence_swi.getEndDate(hat.transaction_id) and

3257: and hrtsteps.TRANSACTION_ID= hat.TRANSACTION_ID
3258: and hat.STATUS not in ('W','S','N','D','AC') -- BUG 9554066
3259: AND hr_person_absence_swi.getstartdate(hat.transaction_id) is NOT NULL
3260: AND hr_person_absence_swi.getenddate(hat.transaction_id) is NOT NULL
3261: and (p_start_date <= hr_person_absence_swi.getEndDate(hat.transaction_id) and
3262: p_end_date >= hr_person_absence_swi.getStartDate(hat.transaction_id) ));
3263:
3264:
3265: l_commitElement xmldom.DOMElement;

Line 3262: p_end_date >= hr_person_absence_swi.getStartDate(hat.transaction_id) ));

3258: and hat.STATUS not in ('W','S','N','D','AC') -- BUG 9554066
3259: AND hr_person_absence_swi.getstartdate(hat.transaction_id) is NOT NULL
3260: AND hr_person_absence_swi.getenddate(hat.transaction_id) is NOT NULL
3261: and (p_start_date <= hr_person_absence_swi.getEndDate(hat.transaction_id) and
3262: p_end_date >= hr_person_absence_swi.getStartDate(hat.transaction_id) ));
3263:
3264:
3265: l_commitElement xmldom.DOMElement;
3266: l_parser xmlparser.Parser;