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_GENERIC_RETRIEVAL_UTILS dependencies on HXC_GENERIC_RETRIEVAL_PKG

Line 1304: (p_process_locker_type => hxc_generic_retrieval_pkg.g_lock_type

1300: IF ( p_day_retrieve AND p_tc_first_lock )
1301: THEN
1302:
1303: hxc_lock_api.request_lock
1304: (p_process_locker_type => hxc_generic_retrieval_pkg.g_lock_type
1305: ,p_time_building_block_id => p_tc_bb_id
1306: ,p_time_building_block_ovn => p_tc_bb_ovn
1307: ,p_expiration_time => 60
1308: ,p_messages => l_message_table

Line 1311: ,p_transaction_lock_id => hxc_generic_retrieval_pkg.g_transaction_id

1307: ,p_expiration_time => 60
1308: ,p_messages => l_message_table
1309: ,p_row_lock_id => l_rowid
1310: ,p_locked_success => p_tc_locked
1311: ,p_transaction_lock_id => hxc_generic_retrieval_pkg.g_transaction_id
1312: );
1313:
1314: IF ( NOT p_tc_locked )
1315: THEN

Line 1388: hxc_generic_retrieval_pkg.g_retrieval_process_id ) )

1384: p_tc_bb_ovn,
1385: p_resource_id,
1386: p_bb_start_time,
1387: p_bb_id,
1388: hxc_generic_retrieval_pkg.g_retrieval_process_id ) )
1389: THEN
1390: -- If you need adjustments, log it down.
1391: IF(g_debug)
1392: THEN

Line 1432: IF ( ( hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT <> 0 )

1428: l_proc := g_package||'set_parent_statuses';
1429: hr_utility.set_location('Processing '||l_proc, 10);
1430: END IF;
1431:
1432: IF ( ( hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT <> 0 )
1433: AND ( hxc_generic_retrieval_pkg.t_tx_time_bb_id.COUNT <> 0 )
1434: AND ( hxc_generic_retrieval_pkg.t_tx_day_bb_id.COUNT <> 0 ) )
1435: THEN
1436:

Line 1433: AND ( hxc_generic_retrieval_pkg.t_tx_time_bb_id.COUNT <> 0 )

1429: hr_utility.set_location('Processing '||l_proc, 10);
1430: END IF;
1431:
1432: IF ( ( hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT <> 0 )
1433: AND ( hxc_generic_retrieval_pkg.t_tx_time_bb_id.COUNT <> 0 )
1434: AND ( hxc_generic_retrieval_pkg.t_tx_day_bb_id.COUNT <> 0 ) )
1435: THEN
1436:
1437: IF ( g_debug ) THEN

Line 1434: AND ( hxc_generic_retrieval_pkg.t_tx_day_bb_id.COUNT <> 0 ) )

1430: END IF;
1431:
1432: IF ( ( hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT <> 0 )
1433: AND ( hxc_generic_retrieval_pkg.t_tx_time_bb_id.COUNT <> 0 )
1434: AND ( hxc_generic_retrieval_pkg.t_tx_day_bb_id.COUNT <> 0 ) )
1435: THEN
1436:
1437: IF ( g_debug ) THEN
1438: hr_utility.set_location('Processing '||l_proc, 20);

Line 1443: FOR time IN hxc_generic_retrieval_pkg.t_tx_time_bb_id.FIRST ..

1439: END IF;
1440:
1441: -- loop through timecard statuses
1442:
1443: FOR time IN hxc_generic_retrieval_pkg.t_tx_time_bb_id.FIRST ..
1444: hxc_generic_retrieval_pkg.t_tx_time_bb_id.LAST
1445: LOOP
1446: IF ( g_debug ) THEN
1447: hr_utility.set_location('Processing '||l_proc, 30);

Line 1444: hxc_generic_retrieval_pkg.t_tx_time_bb_id.LAST

1440:
1441: -- loop through timecard statuses
1442:
1443: FOR time IN hxc_generic_retrieval_pkg.t_tx_time_bb_id.FIRST ..
1444: hxc_generic_retrieval_pkg.t_tx_time_bb_id.LAST
1445: LOOP
1446: IF ( g_debug ) THEN
1447: hr_utility.set_location('Processing '||l_proc, 30);
1448: END IF;

Line 1450: l_day_parent := hxc_generic_retrieval_pkg.t_tx_time_bb_id(time);

1446: IF ( g_debug ) THEN
1447: hr_utility.set_location('Processing '||l_proc, 30);
1448: END IF;
1449:
1450: l_day_parent := hxc_generic_retrieval_pkg.t_tx_time_bb_id(time);
1451: l_day_changed := TRUE;
1452:
1453: -- loop through day statues
1454:

Line 1455: l_day_index := NVL( l_last_day_index, hxc_generic_retrieval_pkg.t_tx_day_bb_id.FIRST );

1451: l_day_changed := TRUE;
1452:
1453: -- loop through day statues
1454:
1455: l_day_index := NVL( l_last_day_index, hxc_generic_retrieval_pkg.t_tx_day_bb_id.FIRST );
1456:
1457: WHILE ( l_day_changed )
1458: LOOP
1459: IF ( g_debug ) THEN

Line 1465: l_day_table(hxc_generic_retrieval_pkg.t_tx_day_bb_id(l_day_index)).ind := l_day_index;

1461: END IF;
1462:
1463: -- store day index in day table indexed by day bb id
1464:
1465: l_day_table(hxc_generic_retrieval_pkg.t_tx_day_bb_id(l_day_index)).ind := l_day_index;
1466:
1467: l_day_index := hxc_generic_retrieval_pkg.t_tx_day_bb_id.NEXT(l_day_index);
1468:
1469: IF ( l_day_index IS NOT NULL )

Line 1467: l_day_index := hxc_generic_retrieval_pkg.t_tx_day_bb_id.NEXT(l_day_index);

1463: -- store day index in day table indexed by day bb id
1464:
1465: l_day_table(hxc_generic_retrieval_pkg.t_tx_day_bb_id(l_day_index)).ind := l_day_index;
1466:
1467: l_day_index := hxc_generic_retrieval_pkg.t_tx_day_bb_id.NEXT(l_day_index);
1468:
1469: IF ( l_day_index IS NOT NULL )
1470: THEN
1471: IF ( g_debug ) THEN

Line 1475: IF ( hxc_generic_retrieval_pkg.t_tx_day_parent_id(l_day_index) <> l_day_parent )

1471: IF ( g_debug ) THEN
1472: hr_utility.set_location('Processing '||l_proc, 50);
1473: END IF;
1474:
1475: IF ( hxc_generic_retrieval_pkg.t_tx_day_parent_id(l_day_index) <> l_day_parent )
1476: THEN
1477: IF ( g_debug ) THEN
1478: hr_utility.set_location('Processing '||l_proc, 60);
1479: END IF;

Line 1512: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.FIRST );

1508: -- get detail statuses
1509:
1510: l_same_timecard := TRUE;
1511: l_detail_index := NVL( l_last_detail_index,
1512: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.FIRST );
1513: l_overall_status:= 'IN PROGRESS';
1514:
1515: WHILE ( l_same_timecard )
1516: LOOP

Line 1521: IF ( hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index) = 'ERRORS' )

1517: IF ( g_debug ) THEN
1518: hr_utility.set_location('Processing '||l_proc, 110);
1519: END IF;
1520:
1521: IF ( hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index) = 'ERRORS' )
1522: THEN
1523: l_overall_status := 'ERRORS';
1524:
1525: ELSIF (hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index) = 'SUCCESS'

Line 1525: ELSIF (hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index) = 'SUCCESS'

1521: IF ( hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index) = 'ERRORS' )
1522: THEN
1523: l_overall_status := 'ERRORS';
1524:
1525: ELSIF (hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index) = 'SUCCESS'
1526: AND l_overall_status <> 'ERRORS' )
1527: THEN
1528: l_overall_status := 'SUCCESS';
1529: END IF;

Line 1535: IF NOT ( l_day_table.EXISTS( hxc_generic_retrieval_pkg.t_tx_detail_parent_id(l_detail_index) ) )

1531: IF ( g_debug ) THEN
1532: hr_utility.set_location('Processing '||l_proc, 120);
1533: END IF;
1534:
1535: IF NOT ( l_day_table.EXISTS( hxc_generic_retrieval_pkg.t_tx_detail_parent_id(l_detail_index) ) )
1536: THEN
1537: IF ( g_debug ) THEN
1538: hr_utility.set_location('Processing '||l_proc, 130);
1539: END IF;

Line 1543: hxc_generic_retrieval_pkg.t_tx_time_status(time) := l_overall_status;

1539: END IF;
1540:
1541: l_same_timecard := FALSE;
1542: l_last_detail_index := l_detail_index;
1543: hxc_generic_retrieval_pkg.t_tx_time_status(time) := l_overall_status;
1544: l_day_table.DELETE;
1545: ELSE
1546: IF ( g_debug ) THEN
1547: hr_utility.set_location('Processing '||l_proc, 140);

Line 1551: hxc_generic_retrieval_pkg.t_tx_day_status(l_day_table(hxc_generic_retrieval_pkg.t_tx_detail_parent_id(l_detail_index)).ind)

1547: hr_utility.set_location('Processing '||l_proc, 140);
1548: END IF;
1549:
1550:
1551: hxc_generic_retrieval_pkg.t_tx_day_status(l_day_table(hxc_generic_retrieval_pkg.t_tx_detail_parent_id(l_detail_index)).ind)
1552: := hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index);
1553: END IF;
1554:
1555: l_detail_index :=

Line 1552: := hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index);

1548: END IF;
1549:
1550:
1551: hxc_generic_retrieval_pkg.t_tx_day_status(l_day_table(hxc_generic_retrieval_pkg.t_tx_detail_parent_id(l_detail_index)).ind)
1552: := hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index);
1553: END IF;
1554:
1555: l_detail_index :=
1556: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.NEXT(l_detail_index);

Line 1556: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.NEXT(l_detail_index);

1552: := hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index);
1553: END IF;
1554:
1555: l_detail_index :=
1556: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.NEXT(l_detail_index);
1557:
1558: IF ( l_detail_index IS NULL )
1559: THEN
1560: IF ( g_debug ) THEN

Line 1564: hxc_generic_retrieval_pkg.t_tx_time_status(time) := l_overall_status;

1560: IF ( g_debug ) THEN
1561: hr_utility.set_location('Processing '||l_proc, 150);
1562: END IF;
1563:
1564: hxc_generic_retrieval_pkg.t_tx_time_status(time) := l_overall_status;
1565: l_same_timecard := FALSE;
1566: END IF;
1567:
1568: END LOOP; -- detail loop

Line 1579: END IF; -- hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT <> 0 )

1575:
1576: END LOOP; -- timecard loop
1577:
1578:
1579: END IF; -- hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT <> 0 )
1580:
1581: IF ( g_debug ) THEN
1582: hr_utility.set_location('Processing '||l_proc, 170);
1583: END IF;

Line 1800: , p_process_locker_type => hxc_generic_retrieval_pkg.g_lock_type

1796:
1797: -- unlock any outstanding TC locks
1798:
1799: hxc_lock_api.release_lock ( p_transaction_lock_id => l_index
1800: , p_process_locker_type => hxc_generic_retrieval_pkg.g_lock_type
1801: , p_row_lock_id => NULL
1802: , p_messages => l_message_table
1803: , p_released_success => l_boolean );
1804:

Line 1918: l_ret_criteria hxc_generic_retrieval_pkg.r_ret_criteria;

1914: l_eff_date_criteria VARCHAR2(200) := '
1915: and tbb_latest.start_time
1916: between paa.effective_start_date and paa.effective_end_date )';
1917:
1918: l_ret_criteria hxc_generic_retrieval_pkg.r_ret_criteria;
1919: BEGIN
1920:
1921: l_ret_criteria := hxc_generic_retrieval_pkg.g_ret_criteria;
1922:

Line 1921: l_ret_criteria := hxc_generic_retrieval_pkg.g_ret_criteria;

1917:
1918: l_ret_criteria hxc_generic_retrieval_pkg.r_ret_criteria;
1919: BEGIN
1920:
1921: l_ret_criteria := hxc_generic_retrieval_pkg.g_ret_criteria;
1922:
1923: IF l_ret_criteria.gre_id is not null then
1924: l_ret_criteria_clause := ' AND exists (
1925: select 1