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.HZ_DQM_SYNC dependencies on FND_PROFILE

Line 9: L_REALTIME_SYNC_VALUE VARCHAR2(15) := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

5: -- Note that when this profile option is not set, the default value is Y
6: -- i.e., SYNC is assumed to be in REALTIME.
7: -- Need to look into the impact of this, for customers who do not need DQM out of the box.
8: ---------------------------------------------------------------------------------
9: L_REALTIME_SYNC_VALUE VARCHAR2(15) := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
10:
11:
12: PROCEDURE REALTIME_SYNC_INDEXES(i_party IN boolean,
13: i_party_sites IN boolean,

Line 67: l_ignore_conc_limits := nvl(FND_PROFILE.VALUE('HZ_DQM_IGNORE_CONC_LIMITS'), 'N');

63: l_conc_req_limit VARCHAR2(80);
64: BEGIN
65: -- Fix for bug 5061761.
66: -- Check for Profile Value to decide if conc req limit per user can be ignored.
67: l_ignore_conc_limits := nvl(FND_PROFILE.VALUE('HZ_DQM_IGNORE_CONC_LIMITS'), 'N');
68: IF l_ignore_conc_limits = 'Y' THEN
69: l_conc_req_limit := nvl(FND_PROFILE.VALUE('CONC_REQUEST_LIMIT'), '0');
70: IF l_conc_req_limit <> '0' THEN
71: FND_PROFILE.PUT (

Line 69: l_conc_req_limit := nvl(FND_PROFILE.VALUE('CONC_REQUEST_LIMIT'), '0');

65: -- Fix for bug 5061761.
66: -- Check for Profile Value to decide if conc req limit per user can be ignored.
67: l_ignore_conc_limits := nvl(FND_PROFILE.VALUE('HZ_DQM_IGNORE_CONC_LIMITS'), 'N');
68: IF l_ignore_conc_limits = 'Y' THEN
69: l_conc_req_limit := nvl(FND_PROFILE.VALUE('CONC_REQUEST_LIMIT'), '0');
70: IF l_conc_req_limit <> '0' THEN
71: FND_PROFILE.PUT (
72: NAME => 'CONC_REQUEST_LIMIT',
73: VAL => NULL

Line 71: FND_PROFILE.PUT (

67: l_ignore_conc_limits := nvl(FND_PROFILE.VALUE('HZ_DQM_IGNORE_CONC_LIMITS'), 'N');
68: IF l_ignore_conc_limits = 'Y' THEN
69: l_conc_req_limit := nvl(FND_PROFILE.VALUE('CONC_REQUEST_LIMIT'), '0');
70: IF l_conc_req_limit <> '0' THEN
71: FND_PROFILE.PUT (
72: NAME => 'CONC_REQUEST_LIMIT',
73: VAL => NULL
74: );
75: END IF;

Line 83: FND_PROFILE.PUT (

79: 'DQM Serial Sync Index Program',
80: NULL,
81: FALSE
82: );
83: FND_PROFILE.PUT (
84: NAME => 'CONC_REQUEST_LIMIT',
85: VAL => l_conc_req_limit
86: );
87: ELSE

Line 159: l_prof := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

155: RETURN BOOLEAN
156: IS
157: l_prof VARCHAR2(1);
158: BEGIN
159: l_prof := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
160: IF (l_prof = 'Y') THEN
161: RETURN TRUE;
162: ELSE
163: RETURN FALSE;

Line 555: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

551: p_create_upd IN VARCHAR2
552: ) IS
553: l_sql_err_message VARCHAR2(2000);
554: BEGIN
555: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
556: IF ( L_REALTIME_SYNC_VALUE = 'Y') THEN
557: -- REPURI. SYNC Perf Improvements. Insert directly into staging tables
558: HZ_STAGE_MAP_TRANSFORM.sync_single_party_online(p_party_id, p_create_upd);
559: --Check if sync went through successfully

Line 599: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

595: AND pr.subject_table_name = 'HZ_PARTIES'
596: AND pr.object_table_name = 'HZ_PARTIES'
597: AND pr.directional_flag = 'F';
598: BEGIN
599: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
600: IF (L_REALTIME_SYNC_VALUE = 'Y') THEN
601: -- REPURI. SYNC Perf Improvements. Insert directly into staging tables
602: HZ_STAGE_MAP_TRANSFORM.sync_single_party_online(p_party_id, p_create_upd);
603: --Check if sync went through successfully

Line 649: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

645: l_org_contact_id NUMBER;
646: l_party_type VARCHAR2(255);
647: l_sql_err_message VARCHAR2(2000) ;
648: BEGIN
649: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
650: IF (L_REALTIME_SYNC_VALUE = 'Y') THEN
651: -- REPURI. SYNC Perf Improvements. Insert directly into staging tables
652: HZ_STAGE_MAP_TRANSFORM.sync_single_party_site_online(p_party_site_id, p_create_upd);
653: --Check if sync went through successfully

Line 712: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

708: ) IS
709: l_party_id NUMBER;
710: l_sql_err_message VARCHAR2(2000);
711: BEGIN
712: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
713: IF (L_REALTIME_SYNC_VALUE = 'Y') THEN
714: -- REPURI. SYNC Perf Improvements. Insert directly into staging tables
715: HZ_STAGE_MAP_TRANSFORM.sync_single_contact_online(p_org_contact_id, p_create_upd);
716: --Check if sync went through successfully

Line 769: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

765: l_party_type VARCHAR2(60);
766: l_sql_err_message VARCHAR2(2000);
767: BEGIN
768: l_party_id := 0;
769: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
770: IF (L_REALTIME_SYNC_VALUE = 'Y') THEN
771: -- REPURI. SYNC Perf Improvements. Insert directly into staging tables
772: HZ_STAGE_MAP_TRANSFORM.sync_single_cpt_online(p_contact_point_id, p_create_upd);
773: --Check if sync went through successfully

Line 864: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

860:
861: l_org_contact_id NUMBER;
862:
863: BEGIN
864: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
865: IF ( L_REALTIME_SYNC_VALUE = 'Y' OR L_REALTIME_SYNC_VALUE = 'N')
866: THEN
867: OPEN org_contacts;
868: LOOP

Line 905: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

901:
902: l_party_site_id NUMBER;
903:
904: BEGIN
905: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
906: IF ( L_REALTIME_SYNC_VALUE = 'Y' OR L_REALTIME_SYNC_VALUE = 'N')
907: THEN
908: OPEN party_sites;
909: LOOP

Line 951: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

947: l_party_id NUMBER;
948: l_party_type VARCHAR2(200);
949:
950: BEGIN
951: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
952: IF ( L_REALTIME_SYNC_VALUE = 'Y' OR L_REALTIME_SYNC_VALUE = 'N')
953: THEN
954: OPEN c_cust_party;
955: FETCH c_cust_party INTO l_party_id, l_party_type;

Line 1045: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

1041:
1042: is_real_time VARCHAR2(1);
1043:
1044: BEGIN
1045: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1046: IF (L_REALTIME_SYNC_VALUE = 'Y') THEN
1047: is_real_time := 'Y';
1048: END IF;
1049:

Line 1118: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

1114:
1115: is_real_time VARCHAR2(1);
1116:
1117: BEGIN
1118: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1119: IF (L_REALTIME_SYNC_VALUE = 'Y') THEN
1120: is_real_time := 'Y';
1121: END IF;
1122:

Line 1201: l_prof := FND_PROFILE.VALUE('HZ_DQM_OPT_MAXTIME');

1197: outandlog('Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
1198: outandlog('NEWLINE');
1199:
1200: BEGIN
1201: l_prof := FND_PROFILE.VALUE('HZ_DQM_OPT_MAXTIME');
1202: IF upper(l_prof) = 'UNLIMITED' THEN
1203: l_prof_val := null;
1204: ELSE
1205: l_prof_val := TO_NUMBER(l_prof);

Line 2179: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

2175: END LOOP;
2176: END IF;
2177: --Start of Bug No : 4915282
2178: --Set the index transactional, if the search on non indexed records is enabled.
2179: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
2180: IF(L_REALTIME_SYNC_VALUE = 'Y') THEN
2181: OPEN c_non_indexed;
2182: FETCH c_non_indexed INTO l_index_count;
2183: if(c_non_indexed%FOUND) then