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_PKG dependencies on HXC_UPGRADE_PKG

Line 886: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')

882:
883: -- If the new datamodel is to be considered, use the new query texts.
884:
885: IF g_params.p_process = 'Projects Retrieval Process'
886: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')
887: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'
888: THEN
889: l_root_day := l_root_day_pa;
890: l_root := l_root_pa;

Line 892: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')

888: THEN
889: l_root_day := l_root_day_pa;
890: l_root := l_root_pa;
891: ELSIF g_params.p_process IN ('BEE Retrieval Process','Apply Schedule Rules')
892: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')
893: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'
894: THEN
895: l_root_day := l_root_day_pay;
896: l_root := l_root_pay;

Line 904: AND hxc_upgrade_pkg.ret_upgrade_completed

900: -- Bug 8888911
901: -- Picking up the Org id or BG id to trim hxc_latest_details.
902: -- do this only if the upgrade is complete.
903: IF g_params.p_process = 'Projects Retrieval Process'
904: AND hxc_upgrade_pkg.ret_upgrade_completed
905: THEN
906: IF Pa_Utils.Pa_Morg_Implemented = 'Y'
907: THEN
908: l_org_strip :=

Line 914: AND hxc_upgrade_pkg.ret_upgrade_completed

910: ELSE
911: l_org_strip := ' ';
912: END IF;
913: ELSIF g_params.p_process IN ('BEE Retrieval Process','Apply Schedule Rules')
914: AND hxc_upgrade_pkg.ret_upgrade_completed
915: THEN
916: l_org_strip :=
917: ' AND tbb.business_group_id = '||to_char(fnd_profile.value('PER_BUSINESS_GROUP_ID'))||' ';
918: ELSE

Line 1181: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')

1177:
1178:
1179: -- Bug 9458888
1180: IF g_params.p_process = 'Projects Retrieval Process'
1181: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')
1182: THEN
1183: l_rdb_process_sql := REPLACE(l_rdb_process_sql,'LATEST_DETAILS','HXC_PA_LATEST_DETAILS');
1184: l_rdb_process_sql := REPLACE(l_rdb_process_sql,'RETRIEVALPROCESS',''''||g_params.p_process||'''');
1185: l_rdb_process_sql := l_rdb_process_sql||' '||l_org_strip||l_appln_strip;

Line 1189: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')

1185: l_rdb_process_sql := l_rdb_process_sql||' '||l_org_strip||l_appln_strip;
1186: mark_for_retrieval(TRUNC(SYSDATE) - fnd_profile.value('HXC_RETRIEVAL_CHANGES_DATE'),
1187: l_rdb_process_sql);
1188: ELSIF g_params.p_process IN ('BEE Retrieval Process','Apply Schedule Rules')
1189: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')
1190: THEN
1191: l_rdb_process_sql := REPLACE(l_rdb_process_sql,'LATEST_DETAILS','HXC_PAY_LATEST_DETAILS');
1192: l_rdb_process_sql := REPLACE(l_rdb_process_sql,'RETRIEVALPROCESS',''''||g_params.p_process||'''');
1193:

Line 1829: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')

1825: -- use the new queries.
1826: -- Here, l_not_exists is not added because these tables are
1827: -- dynamically maintained with only the records left to be retrieved.
1828: IF g_params.p_process = 'Projects Retrieval Process'
1829: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')
1830: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'
1831: THEN
1832: l_select_from := l_select_from_pa;
1833: l_not_exists := ' ';

Line 1835: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')

1831: THEN
1832: l_select_from := l_select_from_pa;
1833: l_not_exists := ' ';
1834: ELSIF g_params.p_process IN ('BEE Retrieval Process','Apply Schedule Rules')
1835: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')
1836: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'
1837: THEN
1838: l_select_from := l_select_from_pay;
1839: l_not_exists := ' ';

Line 2047: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')

2043: DBMS_SQL.parse (l_csr, l_ret_range_query, DBMS_SQL.native);
2044:
2045: -- Bug 9394444
2046: IF ( g_params.p_process = 'Projects Retrieval Process'
2047: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')
2048: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y' )
2049: OR ( g_params.p_process IN ( 'BEE Retrieval Process','Apply Schedule Rules')
2050: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')
2051: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y' )

Line 2050: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')

2046: IF ( g_params.p_process = 'Projects Retrieval Process'
2047: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')
2048: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y' )
2049: OR ( g_params.p_process IN ( 'BEE Retrieval Process','Apply Schedule Rules')
2050: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')
2051: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y' )
2052: THEN
2053: NULL;
2054: ELSE

Line 7369: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')

7365: BEGIN -- build query
7366:
7367: -- Bug 9394444
7368: IF g_params.p_process = 'Projects Retrieval Process'
7369: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')
7370: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'
7371: THEN
7372: l_inline_view := l_inline_view_pa;
7373: l_incremental_from := l_incremental_from_pa;

Line 7376: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')

7372: l_inline_view := l_inline_view_pa;
7373: l_incremental_from := l_incremental_from_pa;
7374: ELSIF g_params.p_process IN ('BEE Retrieval Process','Apply Schedule Rules')
7375: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'
7376: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')
7377: THEN
7378: l_inline_view := l_inline_view_pay;
7379: l_incremental_from := l_incremental_from_pay;
7380: END IF;

Line 8009: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')

8005: put_log(' ');
8006: put_log(' ');
8007:
8008: IF p_process = 'Projects Retrieval Process'
8009: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')
8010: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'
8011: THEN
8012: put_log('Process is running on Upgraded Mode ');
8013: ELSIF p_process IN ('BEE Retrieval Process','Apply Schedule Rules')

Line 8014: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')

8010: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'
8011: THEN
8012: put_log('Process is running on Upgraded Mode ');
8013: ELSIF p_process IN ('BEE Retrieval Process','Apply Schedule Rules')
8014: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')
8015: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'
8016: THEN
8017: put_log('Process is running on Upgraded Mode ');
8018: ELSIF NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'