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 FND_PROFILE

Line 800: IF NVL(FND_PROFILE.VALUE('HXC_PARALLEL_RDB_SNAPSHOT'),'Y') = 'Y'

796: -- below table so that it can process later.
797: IF g_params.p_process = 'Projects Retrieval Process'
798: THEN
799:
800: IF NVL(FND_PROFILE.VALUE('HXC_PARALLEL_RDB_SNAPSHOT'),'Y') = 'Y'
801: THEN
802: l_request_id := FND_REQUEST.SUBMIT_REQUEST(application => 'HXC'
803: ,program => 'HXCRDBSNP'
804: ,description => NULL

Line 887: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'

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;
891: ELSIF g_params.p_process IN ('BEE Retrieval Process','Apply Schedule Rules')

Line 893: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'

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;
897: END IF;

Line 917: ' AND tbb.business_group_id = '||to_char(fnd_profile.value('PER_BUSINESS_GROUP_ID'))||' ';

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
919: l_org_strip := ' ';
920: END IF;
921:

Line 1186: mark_for_retrieval(TRUNC(SYSDATE) - fnd_profile.value('HXC_RETRIEVAL_CHANGES_DATE'),

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;
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

Line 1194: mark_for_retrieval(TRUNC(SYSDATE) - fnd_profile.value('HXC_RETRIEVAL_CHANGES_DATE'),

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:
1194: mark_for_retrieval(TRUNC(SYSDATE) - fnd_profile.value('HXC_RETRIEVAL_CHANGES_DATE'),
1195: l_rdb_process_sql,
1196: g_params.p_start_date,
1197: g_params.p_end_date);
1198: END IF;

Line 1830: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'

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 := ' ';
1834: ELSIF g_params.p_process IN ('BEE Retrieval Process','Apply Schedule Rules')

Line 1836: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'

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 := ' ';
1840: END IF;

Line 2048: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y' )

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' )
2052: THEN

Line 2051: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y' )

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
2055: DBMS_SQL.bind_variable (l_csr,

Line 7370: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'

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;
7374: ELSIF g_params.p_process IN ('BEE Retrieval Process','Apply Schedule Rules')

Line 7375: 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;
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;

Line 7825: g_conc_request_id := fnd_profile.VALUE ('CONC_REQUEST_ID');

7821:
7822: PROCEDURE maintain_globals
7823: IS
7824: BEGIN
7825: g_conc_request_id := fnd_profile.VALUE ('CONC_REQUEST_ID');
7826:
7827: IF g_debug
7828: THEN
7829: hr_utility.TRACE ('Conc Req ID is ' || TO_CHAR (g_conc_request_id)

Line 8010: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'

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')
8014: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')

Line 8015: 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'
8019: THEN

Line 8018: ELSIF NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y'

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'
8019: THEN
8020: put_log('Process is not running on Upgraded Mode because one or more ');
8021: put_log('Upgrade processes are not complete. ');
8022: END IF;

Line 8046: fnd_profile.VALUE ('HXC_RETRIEVAL_BATCH_SIZE');

8042: g_params.p_scope := p_scope;
8043: g_params.p_clusive := p_clusive;
8044: g_params.p_unique_params := p_unique_params;
8045: g_params.transfer_batch_size :=
8046: fnd_profile.VALUE ('HXC_RETRIEVAL_BATCH_SIZE');
8047: g_params.retrieval_options :=
8048: NVL (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS'), 'BOTH');
8049:
8050: IF (p_since_date IS NULL)

Line 8048: NVL (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS'), 'BOTH');

8044: g_params.p_unique_params := p_unique_params;
8045: g_params.transfer_batch_size :=
8046: fnd_profile.VALUE ('HXC_RETRIEVAL_BATCH_SIZE');
8047: g_params.retrieval_options :=
8048: NVL (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS'), 'BOTH');
8049:
8050: IF (p_since_date IS NULL)
8051: THEN
8052: -- then get value from the profile option

Line 8054: NVL (SUBSTR (fnd_profile.VALUE ('HXC_RETRIEVAL_CHANGES_DATE'),

8050: IF (p_since_date IS NULL)
8051: THEN
8052: -- then get value from the profile option
8053: l_since_date :=
8054: NVL (SUBSTR (fnd_profile.VALUE ('HXC_RETRIEVAL_CHANGES_DATE'),
8055: 1,
8056: 3
8057: ),
8058: 60

Line 10125: (fnd_profile.VALUE ('CONC_REQUEST_ID')

10121: END IF;
10122: END IF;
10123:
10124: IF (hxc_generic_retrieval_utils.chk_terminated
10125: (fnd_profile.VALUE ('CONC_REQUEST_ID')
10126: )
10127: )
10128: THEN
10129: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');