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.HXC_RETRIEVAL_ROLLBACK dependencies on HXC_PAY_LATEST_DETAILS

Line 1511: FROM hxc_pay_latest_details hld,

1507: CURSOR get_measure
1508: IS SELECT NVL(htb.measure,(htb.stop_time-htb.start_time)*24),
1509: htb.time_building_block_id,
1510: htb.application_set_id
1511: FROM hxc_pay_latest_details hld,
1512: hxc_time_building_blocks htb
1513: WHERE hld.timecard_id = p_timecard_id
1514: AND htb.time_building_block_id = hld.time_building_block_id
1515: AND htb.object_version_number = hld.object_version_number;

Line 1520: FROM hxc_pay_latest_details hld,

1516:
1517: CURSOR get_attribute
1518: IS SELECT REPLACE(hta.attribute_category,'ELEMENT - '),
1519: hld.time_building_block_id
1520: FROM hxc_pay_latest_details hld,
1521: hxc_time_attribute_usages hau,
1522: hxc_time_attributes hta
1523: WHERE hld.timecard_id = p_timecard_id
1524: AND hau.time_building_block_id = hld.time_building_block_id

Line 1543: UPDATE hxc_pay_latest_details

1539:
1540: IF l_measure.COUNT > 0
1541: THEN
1542: FORALL i IN l_measure.FIRST..l_measure.LAST
1543: UPDATE hxc_pay_latest_details
1544: SET measure = l_measure(i),
1545: application_set_id = l_application(i)
1546: WHERE time_building_block_id = l_dettab(i);
1547: END IF;

Line 1557: UPDATE hxc_pay_latest_details

1553:
1554: IF l_attribute.COUNT > 0
1555: THEN
1556: FORALL i IN l_attribute.FIRST..l_attribute.LAST
1557: UPDATE hxc_pay_latest_details
1558: SET attribute1 = l_attribute(i)
1559: WHERE time_building_block_id = l_dettab(i);
1560: END IF;
1561:

Line 2056: INSERT INTO hxc_pay_latest_details

2052:
2053: l_ora_error := FALSE;
2054: BEGIN
2055: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST SAVE EXCEPTIONS
2056: INSERT INTO hxc_pay_latest_details
2057: (
2058: resource_id,
2059: time_building_block_id,
2060: object_version_number,

Line 2210: INSERT INTO hxc_pay_latest_details

2206:
2207: l_ora_error := FALSE;
2208: BEGIN
2209: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST SAVE EXCEPTIONS
2210: INSERT INTO hxc_pay_latest_details
2211: (
2212: resource_id,
2213: time_building_block_id,
2214: object_version_number,

Line 2347: INSERT INTO hxc_pay_latest_details

2343:
2344: l_ora_error := FALSE;
2345: BEGIN
2346: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST SAVE EXCEPTIONS
2347: INSERT INTO hxc_pay_latest_details
2348: (
2349: resource_id,
2350: time_building_block_id,
2351: object_version_number,

Line 2941: INSERT INTO hxc_pay_latest_details

2937:
2938: l_ora_error := FALSE;
2939: BEGIN
2940: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST SAVE EXCEPTIONS
2941: INSERT INTO hxc_pay_latest_details
2942: (
2943: resource_id,
2944: time_building_block_id,
2945: object_version_number,