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_MR_PVT dependencies on HZ_DQM_DUP_ID_PKG

Line 411: l(' x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;');

407: l('-------------------- TCA JOIN BEGINS --------------------------');
408: l('---------------------------------------------------------------');
409: l('PROCEDURE tca_join_entities(trap_explosion in varchar2, rows_in_chunk in number, inserted_duplicates out number)');
410: l('IS');
411: l(' x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;');
412: temp := get_insert_threshold(p_match_rule_id);
413: l(' x_insert_threshold number := ' || temp || ';');
414: l(' l_party_limit NUMBER := 50000;');
415: l(' l_detail_limit NUMBER := 100000;');

Line 598: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

594: l('-- do an or between all the transformations of an attribute -- ');
595: l('(');
596: l('(s1.'|| trans.staged_attribute_column || ' is not null and ' ||
597: 's2.'|| trans.staged_attribute_column || ' like s1.'||
598: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
599: FIRST := FALSE;
600: ELSE
601: l('or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
602: 's2.'|| trans.staged_attribute_column || ' like s1.'||

Line 603: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

599: FIRST := FALSE;
600: ELSE
601: l('or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
602: 's2.'|| trans.staged_attribute_column || ' like s1.'||
603: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
604: END IF;
605:
606: END LOOP;
607: l(')');

Line 886: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

882: l('-- do an or between all the transformations of an attribute -- ');
883: l('(');
884: l('(s1.'|| trans.staged_attribute_column || ' is not null and ' ||
885: 's2.'|| trans.staged_attribute_column || ' like s1.'||
886: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
887: FIRST := FALSE;
888: ELSE
889: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
890: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||

Line 891: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

887: FIRST := FALSE;
888: ELSE
889: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
890: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||
891: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
892: END IF;
893:
894: END LOOP;
895: l(')');

Line 957: l('HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);');

953: ELSE
954: l(';');
955: END IF;
956:
957: l('HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);');
958: l('close x_ent_cur;');
959: l('FND_FILE.put_line(FND_FILE.log,''Number of parties updated ''||SQL%ROWCOUNT);');
960: l('FND_FILE.put_line(FND_FILE.log,''End time to update ''||to_char(sysdate,''hh24:mi:ss''));');
961: l('FND_FILE.put_line(FND_FILE.log,'||''''|| 'Ending update of Parties on the basis of ' || p_entity || ''''|| ');');

Line 1229: l('x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;');

1225: l('---------------------------------------------------------------');
1226: l('PROCEDURE interface_tca_join_entities( p_batch_id in number, from_osr in varchar2, to_osr in varchar2,');
1227: l(' p_threshold in number, p_auto_merge_threshold in number)');
1228: l('IS');
1229: l('x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;');
1230: temp := get_insert_threshold(p_match_rule_id);
1231: l('x_insert_threshold number := ' || temp || ';');
1232: l('BEGIN');
1233: l('FND_FILE.put_line(FND_FILE.log,''------------------------------------------------'');');

Line 1427: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

1423: l('-- do an or between all the transformations of an attribute -- ');
1424: l('(');
1425: l('(s1.'|| trans.staged_attribute_column || ' is not null and ' ||
1426: 's2.'|| trans.staged_attribute_column || ' like s1.'||
1427: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
1428: FIRST := FALSE;
1429: ELSE
1430: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
1431: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||

Line 1432: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

1428: FIRST := FALSE;
1429: ELSE
1430: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
1431: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||
1432: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
1433: END IF;
1434:
1435: END LOOP;
1436: l(')');

Line 1633: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

1629: l('-- do an or between all the transformations of an attribute -- ');
1630: l('(');
1631: l('(s1.'|| trans.staged_attribute_column || ' is not null and ' ||
1632: 's2.'|| trans.staged_attribute_column || ' like s1.'||
1633: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
1634: FIRST := FALSE;
1635: ELSE
1636: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
1637: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||

Line 1638: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

1634: FIRST := FALSE;
1635: ELSE
1636: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
1637: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||
1638: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
1639: END IF;
1640:
1641: END LOOP;
1642: l(')');

Line 1708: l('HZ_DQM_DUP_ID_PKG.update_detail_dqm_action_flag(''' ||p_entity ||''',p_batch_id, x_ent_cur);');

1704: l('select distinct a.record_osr, a.record_os');
1705: l('from hz_imp_dup_details a');
1706: l('where a.batch_id = p_batch_id');
1707: l('and a.party_osr between from_osr and to_osr and a.entity =''' || p_entity || ''';') ;
1708: l('HZ_DQM_DUP_ID_PKG.update_detail_dqm_action_flag(''' ||p_entity ||''',p_batch_id, x_ent_cur);');
1709: l('-------------' || p_entity || ' LEVEL DUPLICATE IDENTIFICATION ENDS ------------------------');
1710: l('FND_FILE.put_line(FND_FILE.log,'||''''|| 'Ending insert of ' || p_entity || ''''|| ');');
1711: l('FND_FILE.put_line(FND_FILE.log,''Number of records inserted ''||SQL%ROWCOUNT);');
1712: l('FND_FILE.put_line(FND_FILE.log,''End time to insert ''||to_char(sysdate,''hh24:mi:ss''));');

Line 1925: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

1921: l('-- do an or between all the transformations of an attribute -- ');
1922: l('(');
1923: l('(s1.'|| trans.staged_attribute_column || ' is not null and ' ||
1924: 's2.'|| trans.staged_attribute_column || ' like s1.'||
1925: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
1926: FIRST := FALSE;
1927: ELSE
1928: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
1929: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||

Line 1930: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

1926: FIRST := FALSE;
1927: ELSE
1928: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
1929: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||
1930: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
1931: END IF;
1932:
1933: END LOOP;
1934: l(')');

Line 1987: l('HZ_DQM_DUP_ID_PKG.update_hz_imp_dup_parties(p_batch_id, x_ent_cur);');

1983: END LOOP;
1984: l(')');
1985: END LOOP;
1986: l(') group by f,t ;');
1987: l('HZ_DQM_DUP_ID_PKG.update_hz_imp_dup_parties(p_batch_id, x_ent_cur);');
1988: l('close x_ent_cur;');
1989: l('FND_FILE.put_line(FND_FILE.log,''Number of parties updated ''||SQL%ROWCOUNT);');
1990: l('FND_FILE.put_line(FND_FILE.log,''End time to update ''||to_char(sysdate,''hh24:mi:ss''));');
1991: l('FND_FILE.put_line(FND_FILE.log,'||''''|| 'Ending update of Parties on the basis of ' || p_entity || ''''|| ');');

Line 2038: l('HZ_DQM_DUP_ID_PKG.update_party_dqm_action_flag(p_batch_id, x_ent_cur);');

2034: l('select a.party_osr, a.party_os, a.auto_merge_flag');
2035: l('from hz_imp_dup_parties a');
2036: l('where a.batch_id = p_batch_id');
2037: l('and a.party_osr between from_osr and to_osr ;');
2038: l('HZ_DQM_DUP_ID_PKG.update_party_dqm_action_flag(p_batch_id, x_ent_cur);');
2039: l('----------------------PARTY LEVEL DUPLICATE IDENTIFICATION ENDS --------------------');
2040: l('');
2041: END ;
2042: -------------------------------------------------------------------------

Line 2366: l('x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;');

2362: l('---------------------------------------------------------------');
2363: l('PROCEDURE interface_join_entities(p_batch_id in number,');
2364: l(' from_osr in varchar2, to_osr in varchar2, p_threshold in number)');
2365: l('IS');
2366: l('x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;');
2367: temp := get_insert_threshold(p_match_rule_id);
2368: l(' x_insert_threshold number := ' || temp || ';');
2369: l('BEGIN');
2370: l('FND_FILE.put_line(FND_FILE.log,''------------------------------------------------'');');

Line 2518: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

2514: l('-- do an or between all the transformations of an attribute -- ');
2515: l('(');
2516: l('(s1.'|| trans.staged_attribute_column || ' is not null and ' ||
2517: 's2.'|| trans.staged_attribute_column || ' like s1.'||
2518: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
2519: FIRST := FALSE;
2520: ELSE
2521: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
2522: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||

Line 2523: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

2519: FIRST := FALSE;
2520: ELSE
2521: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
2522: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||
2523: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
2524: END IF;
2525:
2526: END LOOP;
2527: l(')');

Line 2732: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

2728: l('-- do an or between all the transformations of an attribute -- ');
2729: l('(');
2730: l('(s1.'|| trans.staged_attribute_column || ' is not null and ' ||
2731: 's2.'|| trans.staged_attribute_column || ' like s1.'||
2732: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
2733: FIRST := FALSE;
2734: ELSE
2735: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
2736: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||

Line 2737: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

2733: FIRST := FALSE;
2734: ELSE
2735: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
2736: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||
2737: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
2738: END IF;
2739:
2740: END LOOP;
2741: l(')');

Line 3021: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

3017: l('-- do an or between all the transformations of an attribute -- ');
3018: l('(');
3019: l('(s1.'|| trans.staged_attribute_column || ' is not null and ' ||
3020: 's2.'|| trans.staged_attribute_column || ' like s1.'||
3021: trans.staged_attribute_column || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
3022: FIRST := FALSE;
3023: ELSE
3024: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
3025: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||

Line 3026: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');

3022: FIRST := FALSE;
3023: ELSE
3024: l(' or (s1.'|| trans.staged_attribute_column || ' is not null and ' ||
3025: 's2.'|| trans.staged_attribute_column || ' '|| ' like s1.'||
3026: trans.staged_attribute_column || ' ' || ' || decode(sign(lengthb(s1.' || trans.staged_attribute_column || ')-'|| HZ_DQM_DUP_ID_PKG.l_like_comparison_min_length || '),1,''%'',''''))');
3027: END IF;
3028:
3029: END LOOP;
3030: l(')');

Line 3081: l('HZ_DQM_DUP_ID_PKG.update_hz_int_dup_results(p_batch_id,x_ent_cur);');

3077: END LOOP;
3078: l(')');
3079: END LOOP;
3080: l(') group by f,t ;');
3081: l('HZ_DQM_DUP_ID_PKG.update_hz_int_dup_results(p_batch_id,x_ent_cur);');
3082: l('close x_ent_cur;');
3083: l('FND_FILE.put_line(FND_FILE.log,''Number of parties updated ''||SQL%ROWCOUNT);');
3084: l('FND_FILE.put_line(FND_FILE.log,''End time to update ''||to_char(sysdate,''hh24:mi:ss''));');
3085: l('FND_FILE.put_line(FND_FILE.log,'||''''|| 'Ending update of Parties on the basis of ' || p_entity || ''''|| ');');