APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on HXC_ABSENCE_TYPE_ELEMENTS

Line 350: from hxc_absence_type_elements table

346: /*
347: Added for 8645021 HR OTL Absence Integration
348:
349: This procedure is called in undo part of GFMP, in which all absence info is removed
350: from hxc_absence_type_elements table
351: */
352:
353: --Change start
354: PROCEDURE REMOVE_HXC_ABS_ELEM_INFO(p_error_msg OUT NOCOPY VARCHAR2,

Line 355: p_element_type_id IN hxc_absence_type_elements.element_type_id%type)

351: */
352:
353: --Change start
354: PROCEDURE REMOVE_HXC_ABS_ELEM_INFO(p_error_msg OUT NOCOPY VARCHAR2,
355: p_element_type_id IN hxc_absence_type_elements.element_type_id%type)
356: IS
357:
358: CURSOR chk_abs_elem_exists(p_element_type_id IN NUMBER)
359:

Line 364: hxc_absence_type_elements

360: IS
361: SELECT
362: 1
363: FROM
364: hxc_absence_type_elements
365: WHERE
366: element_type_id = p_element_type_id;
367:
368:

Line 393: delete from hxc_absence_type_elements -- hxc_absence_type_elements

389: CLOSE chk_abs_elem_exists;
390:
391: IF x_var = 1 THEN
392:
393: delete from hxc_absence_type_elements -- hxc_absence_type_elements
394: where element_type_id=p_element_type_id;
395:
396: if g_debug then
397:

Line 493: Call to delete any existing absence info in hxc_absence_type_elements

489:
490: /*
491: Added for 8645021 HR OTL Absence Integration
492:
493: Call to delete any existing absence info in hxc_absence_type_elements
494: */
495: -- change start
496:
497: remove_hxc_abs_elem_info(p_err_msg,ele_rec.element_type_id);

Line 1552: Call to insert absence info from the element set to hxc_absence_type_elements

1548:
1549: /*
1550: Added for 8645021 HR OTL Absence Integration
1551:
1552: Call to insert absence info from the element set to hxc_absence_type_elements
1553: */
1554:
1555: --change start
1556: PROCEDURE INSERT_INTO_HXC_ABSENCES(p_error_msg OUT NOCOPY VARCHAR2,

Line 1568: hxc_absence_type_elements

1564: IS
1565: SELECT
1566: 1
1567: FROM
1568: hxc_absence_type_elements
1569: WHERE
1570: absence_attendance_type_id = p_absence_attendance_type_id AND
1571: element_type_id = p_element_type_id;
1572:

Line 1613: insert into hxc_absence_type_elements -- hxc_absence_type_elements

1609:
1610:
1611: end if;
1612:
1613: insert into hxc_absence_type_elements -- hxc_absence_type_elements
1614: (
1615: ABSENCE_ATTENDANCE_TYPE_ID,
1616: ELEMENT_TYPE_ID,
1617: EDIT_FLAG,

Line 1642: UPDATE hxc_absence_type_elements

1638: hr_utility.trace('ABSENCE_CATEGORY NEW = '||p_abs_info(tab_count).ABSENCE_CATEGORY);
1639: end if;
1640:
1641:
1642: UPDATE hxc_absence_type_elements
1643: SET UOM = p_abs_info(tab_count).UOM,
1644: ABSENCE_CATEGORY = p_abs_info(tab_count).ABSENCE_CATEGORY
1645: WHERE absence_attendance_type_id = p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID
1646: AND element_type_id = p_abs_info(tab_count).ELEMENT_TYPE_ID;

Line 2550: Insertion into hxc_absence_type_elements

2546:
2547: /*
2548: Added for 8645021 HR OTL Absence Integration
2549:
2550: Insertion into hxc_absence_type_elements
2551: */
2552: -- change start
2553: IF (p_incl_abs_flg = 'Y' and hxc_abs_tab.COUNT>0) THEN
2554: