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 1453: (p_process_locker_type => hxc_generic_retrieval_pkg.g_lock_type

1449: IF ( p_day_retrieve AND p_tc_first_lock )
1450: THEN
1451:
1452: hxc_lock_api.request_lock
1453: (p_process_locker_type => hxc_generic_retrieval_pkg.g_lock_type
1454: ,p_time_building_block_id => p_tc_bb_id
1455: ,p_time_building_block_ovn => p_tc_bb_ovn
1456: ,p_expiration_time => 60
1457: ,p_messages => l_message_table

Line 1460: ,p_transaction_lock_id => hxc_generic_retrieval_pkg.g_transaction_id

1456: ,p_expiration_time => 60
1457: ,p_messages => l_message_table
1458: ,p_row_lock_id => l_rowid
1459: ,p_locked_success => p_tc_locked
1460: ,p_transaction_lock_id => hxc_generic_retrieval_pkg.g_transaction_id
1461: );
1462:
1463: IF ( NOT p_tc_locked )
1464: THEN

Line 1539: hxc_generic_retrieval_pkg.g_retrieval_process_id ) )

1535: p_bb_start_time,
1536: p_bb_id,
1537: p_bb_ovn, -- Bug 8366309
1538: 'N', -- Bug 8366309 'N' is an UPDATE or NEW entry; DELETED = 'N'
1539: hxc_generic_retrieval_pkg.g_retrieval_process_id ) )
1540: THEN
1541: -- If you need adjustments, log it down.
1542: IF(g_debug)
1543: THEN

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

1579: l_proc := g_package||'set_parent_statuses';
1580: hr_utility.set_location('Processing '||l_proc, 10);
1581: END IF;
1582:
1583: IF ( ( hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT <> 0 )
1584: AND ( hxc_generic_retrieval_pkg.t_tx_time_bb_id.COUNT <> 0 )
1585: AND ( hxc_generic_retrieval_pkg.t_tx_day_bb_id.COUNT <> 0 ) )
1586: THEN
1587:

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

1580: hr_utility.set_location('Processing '||l_proc, 10);
1581: END IF;
1582:
1583: IF ( ( hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT <> 0 )
1584: AND ( hxc_generic_retrieval_pkg.t_tx_time_bb_id.COUNT <> 0 )
1585: AND ( hxc_generic_retrieval_pkg.t_tx_day_bb_id.COUNT <> 0 ) )
1586: THEN
1587:
1588: IF ( g_debug ) THEN

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

1581: END IF;
1582:
1583: IF ( ( hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT <> 0 )
1584: AND ( hxc_generic_retrieval_pkg.t_tx_time_bb_id.COUNT <> 0 )
1585: AND ( hxc_generic_retrieval_pkg.t_tx_day_bb_id.COUNT <> 0 ) )
1586: THEN
1587:
1588: IF ( g_debug ) THEN
1589: hr_utility.set_location('Processing '||l_proc, 20);

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

1590: END IF;
1591:
1592: -- loop through timecard statuses
1593:
1594: FOR time IN hxc_generic_retrieval_pkg.t_tx_time_bb_id.FIRST ..
1595: hxc_generic_retrieval_pkg.t_tx_time_bb_id.LAST
1596: LOOP
1597: IF ( g_debug ) THEN
1598: hr_utility.set_location('Processing '||l_proc, 30);

Line 1595: hxc_generic_retrieval_pkg.t_tx_time_bb_id.LAST

1591:
1592: -- loop through timecard statuses
1593:
1594: FOR time IN hxc_generic_retrieval_pkg.t_tx_time_bb_id.FIRST ..
1595: hxc_generic_retrieval_pkg.t_tx_time_bb_id.LAST
1596: LOOP
1597: IF ( g_debug ) THEN
1598: hr_utility.set_location('Processing '||l_proc, 30);
1599: END IF;

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

1597: IF ( g_debug ) THEN
1598: hr_utility.set_location('Processing '||l_proc, 30);
1599: END IF;
1600:
1601: l_day_parent := hxc_generic_retrieval_pkg.t_tx_time_bb_id(time);
1602: l_day_changed := TRUE;
1603:
1604: -- loop through day statues
1605:

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

1602: l_day_changed := TRUE;
1603:
1604: -- loop through day statues
1605:
1606: l_day_index := NVL( l_last_day_index, hxc_generic_retrieval_pkg.t_tx_day_bb_id.FIRST );
1607:
1608: WHILE ( l_day_changed )
1609: LOOP
1610: IF ( g_debug ) THEN

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

1612: END IF;
1613:
1614: -- store day index in day table indexed by day bb id
1615:
1616: l_day_table(hxc_generic_retrieval_pkg.t_tx_day_bb_id(l_day_index)).ind := l_day_index;
1617:
1618: l_day_index := hxc_generic_retrieval_pkg.t_tx_day_bb_id.NEXT(l_day_index);
1619:
1620: IF ( l_day_index IS NOT NULL )

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

1614: -- store day index in day table indexed by day bb id
1615:
1616: l_day_table(hxc_generic_retrieval_pkg.t_tx_day_bb_id(l_day_index)).ind := l_day_index;
1617:
1618: l_day_index := hxc_generic_retrieval_pkg.t_tx_day_bb_id.NEXT(l_day_index);
1619:
1620: IF ( l_day_index IS NOT NULL )
1621: THEN
1622: IF ( g_debug ) THEN

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

1622: IF ( g_debug ) THEN
1623: hr_utility.set_location('Processing '||l_proc, 50);
1624: END IF;
1625:
1626: IF ( hxc_generic_retrieval_pkg.t_tx_day_parent_id(l_day_index) <> l_day_parent )
1627: THEN
1628: IF ( g_debug ) THEN
1629: hr_utility.set_location('Processing '||l_proc, 60);
1630: END IF;

Line 1663: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.FIRST );

1659: -- get detail statuses
1660:
1661: l_same_timecard := TRUE;
1662: l_detail_index := NVL( l_last_detail_index,
1663: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.FIRST );
1664: l_overall_status:= 'IN PROGRESS';
1665:
1666: WHILE ( l_same_timecard )
1667: LOOP

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

1668: IF ( g_debug ) THEN
1669: hr_utility.set_location('Processing '||l_proc, 110);
1670: END IF;
1671:
1672: IF ( hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index) = 'ERRORS' )
1673: THEN
1674: l_overall_status := 'ERRORS';
1675:
1676: ELSIF (hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index) = 'SUCCESS'

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

1672: IF ( hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index) = 'ERRORS' )
1673: THEN
1674: l_overall_status := 'ERRORS';
1675:
1676: ELSIF (hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index) = 'SUCCESS'
1677: AND l_overall_status <> 'ERRORS' )
1678: THEN
1679: l_overall_status := 'SUCCESS';
1680: END IF;

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

1682: IF ( g_debug ) THEN
1683: hr_utility.set_location('Processing '||l_proc, 120);
1684: END IF;
1685:
1686: IF NOT ( l_day_table.EXISTS( hxc_generic_retrieval_pkg.t_tx_detail_parent_id(l_detail_index) ) )
1687: THEN
1688: IF ( g_debug ) THEN
1689: hr_utility.set_location('Processing '||l_proc, 130);
1690: END IF;

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

1690: END IF;
1691:
1692: l_same_timecard := FALSE;
1693: l_last_detail_index := l_detail_index;
1694: hxc_generic_retrieval_pkg.t_tx_time_status(time) := l_overall_status;
1695: l_day_table.DELETE;
1696: ELSE
1697: IF ( g_debug ) THEN
1698: hr_utility.set_location('Processing '||l_proc, 140);

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

1698: hr_utility.set_location('Processing '||l_proc, 140);
1699: END IF;
1700:
1701:
1702: hxc_generic_retrieval_pkg.t_tx_day_status(l_day_table(hxc_generic_retrieval_pkg.t_tx_detail_parent_id(l_detail_index)).ind)
1703: := hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index);
1704: END IF;
1705:
1706: l_detail_index :=

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

1699: END IF;
1700:
1701:
1702: hxc_generic_retrieval_pkg.t_tx_day_status(l_day_table(hxc_generic_retrieval_pkg.t_tx_detail_parent_id(l_detail_index)).ind)
1703: := hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index);
1704: END IF;
1705:
1706: l_detail_index :=
1707: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.NEXT(l_detail_index);

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

1703: := hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index);
1704: END IF;
1705:
1706: l_detail_index :=
1707: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.NEXT(l_detail_index);
1708:
1709: IF ( l_detail_index IS NULL )
1710: THEN
1711: IF ( g_debug ) THEN

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

1711: IF ( g_debug ) THEN
1712: hr_utility.set_location('Processing '||l_proc, 150);
1713: END IF;
1714:
1715: hxc_generic_retrieval_pkg.t_tx_time_status(time) := l_overall_status;
1716: l_same_timecard := FALSE;
1717: END IF;
1718:
1719: END LOOP; -- detail loop

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

1726:
1727: END LOOP; -- timecard loop
1728:
1729:
1730: END IF; -- hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT <> 0 )
1731:
1732: IF ( g_debug ) THEN
1733: hr_utility.set_location('Processing '||l_proc, 170);
1734: END IF;

Line 1951: , p_process_locker_type => hxc_generic_retrieval_pkg.g_lock_type

1947:
1948: -- unlock any outstanding TC locks
1949:
1950: hxc_lock_api.release_lock ( p_transaction_lock_id => l_index
1951: , p_process_locker_type => hxc_generic_retrieval_pkg.g_lock_type
1952: , p_row_lock_id => NULL
1953: , p_messages => l_message_table
1954: , p_released_success => l_boolean );
1955:

Line 2069: l_ret_criteria hxc_generic_retrieval_pkg.r_ret_criteria;

2065: l_eff_date_criteria VARCHAR2(200) := '
2066: and tbb_latest.start_time
2067: between paa.effective_start_date and paa.effective_end_date )';
2068:
2069: l_ret_criteria hxc_generic_retrieval_pkg.r_ret_criteria;
2070: BEGIN
2071:
2072: l_ret_criteria := hxc_generic_retrieval_pkg.g_ret_criteria;
2073:

Line 2072: l_ret_criteria := hxc_generic_retrieval_pkg.g_ret_criteria;

2068:
2069: l_ret_criteria hxc_generic_retrieval_pkg.r_ret_criteria;
2070: BEGIN
2071:
2072: l_ret_criteria := hxc_generic_retrieval_pkg.g_ret_criteria;
2073:
2074: IF l_ret_criteria.gre_id is not null then
2075: l_ret_criteria_clause := ' AND exists (
2076: select 1