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 780: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

776: l_party_type VARCHAR2(60);
777: l_sql_err_message VARCHAR2(2000);
778: BEGIN
779: l_party_id := 0;
780: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
781: IF (L_REALTIME_SYNC_VALUE = 'Y') THEN
782: -- REPURI. SYNC Perf Improvements. Insert directly into staging tables
783: HZ_STAGE_MAP_TRANSFORM.sync_single_cpt_online(p_contact_point_id, p_create_upd);
784: --Check if sync went through successfully

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

871:
872: l_org_contact_id NUMBER;
873:
874: BEGIN
875: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
876: IF ( L_REALTIME_SYNC_VALUE = 'Y' OR L_REALTIME_SYNC_VALUE = 'N')
877: THEN
878: OPEN org_contacts;
879: LOOP

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

912:
913: l_party_site_id NUMBER;
914:
915: BEGIN
916: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
917: IF ( L_REALTIME_SYNC_VALUE = 'Y' OR L_REALTIME_SYNC_VALUE = 'N')
918: THEN
919: OPEN party_sites;
920: LOOP

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

958: l_party_id NUMBER;
959: l_party_type VARCHAR2(200);
960:
961: BEGIN
962: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
963: IF ( L_REALTIME_SYNC_VALUE = 'Y' OR L_REALTIME_SYNC_VALUE = 'N')
964: THEN
965: OPEN c_cust_party;
966: FETCH c_cust_party INTO l_party_id, l_party_type;

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

1052:
1053: is_real_time VARCHAR2(1);
1054:
1055: BEGIN
1056: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1057: IF (L_REALTIME_SYNC_VALUE = 'Y') THEN
1058: is_real_time := 'Y';
1059: END IF;
1060:

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

1125:
1126: is_real_time VARCHAR2(1);
1127:
1128: BEGIN
1129: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1130: IF (L_REALTIME_SYNC_VALUE = 'Y') THEN
1131: is_real_time := 'Y';
1132: END IF;
1133:

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

1247: outandlog('Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
1248: outandlog('NEWLINE');
1249:
1250: BEGIN
1251: l_prof := FND_PROFILE.VALUE('HZ_DQM_OPT_MAXTIME');
1252: IF upper(l_prof) = 'UNLIMITED' THEN
1253: l_prof_val := null;
1254: ELSE
1255: l_prof_val := TO_NUMBER(l_prof);

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

1380:
1381: BEGIN
1382:
1383: x_return_status := FND_API.G_RET_STS_SUCCESS;
1384: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1385:
1386: SELECT party_type INTO l_party_type
1387: FROM HZ_PARTIES
1388: WHERE party_id = p_from_id;

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

1439: l_party_site_stage_rec HZ_PARTY_STAGE.PARTY_SITE_STAGE_REC_TYPE;
1440:
1441: BEGIN
1442: x_return_status := FND_API.G_RET_STS_SUCCESS;
1443: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1444:
1445: IF ( L_REALTIME_SYNC_VALUE = 'Y') THEN
1446: BEGIN
1447: DELETE FROM HZ_STAGED_PARTY_SITES

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

1536: BEGIN
1537:
1538: x_return_status := FND_API.G_RET_STS_SUCCESS;
1539:
1540: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1541:
1542: IF ( L_REALTIME_SYNC_VALUE = 'Y') THEN
1543: BEGIN
1544: DELETE FROM HZ_STAGED_CONTACT_POINTS

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

1642: l_rel_party_id NUMBER;
1643: BEGIN
1644:
1645: x_return_status := FND_API.G_RET_STS_SUCCESS;
1646: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1647:
1648: IF ( L_REALTIME_SYNC_VALUE = 'Y') THEN
1649: BEGIN
1650: DELETE FROM HZ_STAGED_CONTACTS

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

2354: END LOOP;
2355: END IF;
2356: --Start of Bug No : 4915282
2357: --Set the index transactional, if the search on non indexed records is enabled.
2358: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
2359: IF(L_REALTIME_SYNC_VALUE = 'Y') THEN
2360: OPEN c_non_indexed;
2361: FETCH c_non_indexed INTO l_index_count;
2362: if(c_non_indexed%FOUND) then