DBA Data[Home] [Help]

APPS.HXC_UPGRADE_PKG dependencies on HXC_TIMECARD_SUMMARY

Line 114: FROM hxc_timecard_summary

110:
111: CURSOR get_timecard_summaries
112: IS SELECT timecard_id,
113: timecard_ovn
114: FROM hxc_timecard_summary
115: WHERE transferred_to IS NULL
116: ORDER BY timecard_id;
117:
118:

Line 1511: -- Populating hxc_timecard_summary.Xferred_to

1507:
1508: END IF;
1509:
1510: -- Bug 9938394
1511: -- Populating hxc_timecard_summary.Xferred_to
1512: IF (p_type ='XFER_TO')
1513: THEN
1514:
1515: l_thread_id := p_start;

Line 1655: UPDATE hxc_timecard_summary

1651:
1652: EXIT WHEN tcsumidtab.COUNT = 0;
1653:
1654: FORALL i IN tcsumidtab.FIRST..tcsumidtab.LAST
1655: UPDATE hxc_timecard_summary
1656: SET transferred_to = LTRIM(NVL(transferred_to,',')||','||xfertab(i),',')
1657: WHERE timecard_id = tcsumidtab(i)
1658: AND timecard_ovn = tcsumovntab(i);
1659: