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_PARTY_MERGE dependencies on HZ_MERGE_DICTIONARY

Line 28: p_proc_name IN HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE,

24: x_return_status IN OUT NOCOPY VARCHAR2);
25:
26: PROCEDURE exec_merge_r(
27: p_entity_name IN VARCHAR2,
28: p_proc_name IN HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE,
29: p_from_id IN ROWID,
30: x_to_id IN OUT NOCOPY ROWID,
31: p_par_from_id IN NUMBER,
32: p_par_to_id IN NUMBER,

Line 33: p_parent_entity IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,

29: p_from_id IN ROWID,
30: x_to_id IN OUT NOCOPY ROWID,
31: p_par_from_id IN NUMBER,
32: p_par_to_id IN NUMBER,
33: p_parent_entity IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,
34: p_batch_id IN NUMBER,
35: p_batch_party_id IN NUMBER,
36: x_return_status IN OUT NOCOPY VARCHAR2);
37:

Line 41: p_proc_name IN HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE,

37:
38:
39: PROCEDURE exec_merge(
40: p_entity_name IN VARCHAR2,
41: p_proc_name IN HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE,
42: p_from_id IN NUMBER,
43: x_to_id IN OUT NOCOPY NUMBER,
44: p_par_from_id IN NUMBER,
45: p_par_to_id IN NUMBER,

Line 46: p_parent_entity IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,

42: p_from_id IN NUMBER,
43: x_to_id IN OUT NOCOPY NUMBER,
44: p_par_from_id IN NUMBER,
45: p_par_to_id IN NUMBER,
46: p_parent_entity IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,
47: p_batch_id IN NUMBER,
48: p_batch_party_id IN NUMBER,
49: x_return_status IN OUT NOCOPY VARCHAR2);
50:

Line 242: FROM HZ_MERGE_DICTIONARY WHERE DICT_APPLICATION_ID<>222

238: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');
239: g_skip_dict_id.DELETE;
240: FOR ENTITY IN (
241: SELECT DISTINCT MERGE_DICT_ID, ENTITY_NAME
242: FROM HZ_MERGE_DICTIONARY WHERE DICT_APPLICATION_ID<>222
243: AND NVL(batch_merge_flag, 'N') <> 'Y') LOOP
244:
245: BEGIN
246: --4534175 EXECUTE IMMEDIATE 'DECLARE x NUMBER; BEGIN SELECT 1 INTO x FROM dual where exists ( select 1 from '||ENTITY.ENTITY_NAME||'); END;';

Line 381: FROM HZ_MERGE_DICTIONARY

377:
378:
379: CURSOR c_dict_id(cp_ruleset_name VARCHAR2, cp_entity_name VARCHAR2) IS
380: SELECT merge_dict_id
381: FROM HZ_MERGE_DICTIONARY
382: WHERE RULE_SET_NAME = cp_ruleset_name
383: AND ENTITY_NAME = cp_entity_name;
384:
385: cursor c_request_type(cp_batch_id NUMBER) is

Line 398: from hz_merge_dictionary

394: and mb.batch_id = cp_batch_id;
395:
396: cursor c_dict_no_fktype is
397: select entity_name, fk_column_name, merge_dict_id, dict_application_id
398: from hz_merge_dictionary
399: where fk_data_type is null;
400:
401: cursor app_name(app_id NUMBER) IS
402: Select application_short_name from fnd_application where application_id=app_id;

Line 414: from hz_merge_dictionary

410: --start bug 4634891
411:
412: CURSOR batch_merge_procedures IS
413: select merge_dict_id, entity_name, procedure_name
414: from hz_merge_dictionary
415: where merge_dict_id in (
416: select min(merge_dict_id)
417: from HZ_MERGE_DICTIONARY where batch_merge_flag = 'Y'
418: group by procedure_name);

Line 417: from HZ_MERGE_DICTIONARY where batch_merge_flag = 'Y'

413: select merge_dict_id, entity_name, procedure_name
414: from hz_merge_dictionary
415: where merge_dict_id in (
416: select min(merge_dict_id)
417: from HZ_MERGE_DICTIONARY where batch_merge_flag = 'Y'
418: group by procedure_name);
419:
420: CURSOR merge_to_parties IS
421: select DISTINCT(to_party_id)

Line 427: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;

423: where batch_id = p_batch_id
424: and merge_status = 'DONE';
425:
426:
427: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
428: --end bug 4634891
429:
430: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
431: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;

Line 456: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;

452:
453: l_from_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
454: l_to_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
455:
456: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
457: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
458:
459:
460: l_num_merged NUMBER;

Line 457: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

453: l_from_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
454: l_to_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
455:
456: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
457: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
458:
459:
460: l_num_merged NUMBER;
461:

Line 630: update hz_merge_dictionary

626: close app_name;
627:
628: l_data_type:=get_col_type(l_sub_entity_name,l_sub_fk_column_name,l_app_name);
629:
630: update hz_merge_dictionary
631: set fk_data_type = l_data_type
632: where merge_dict_id = l_merge_dict_id;
633:
634: end loop;

Line 1383: FROM HZ_MERGE_DICTIONARY

1379: x_return_status IN OUT NOCOPY VARCHAR2) IS
1380:
1381: CURSOR c_dict_id(cp_ruleset_name VARCHAR2, cp_entity_name VARCHAR2) IS
1382: SELECT merge_dict_id, DESCRIPTION
1383: FROM HZ_MERGE_DICTIONARY
1384: WHERE RULE_SET_NAME = cp_ruleset_name
1385: AND ENTITY_NAME = cp_entity_name;
1386:
1387: l_dict_id NUMBER;

Line 1388: l_desc HZ_MERGE_DICTIONARY.DESCRIPTION%TYPE;

1384: WHERE RULE_SET_NAME = cp_ruleset_name
1385: AND ENTITY_NAME = cp_entity_name;
1386:
1387: l_dict_id NUMBER;
1388: l_desc HZ_MERGE_DICTIONARY.DESCRIPTION%TYPE;
1389:
1390: BEGIN
1391: OPEN c_dict_id(p_rule_set_name,p_entity_name);
1392: FETCH c_dict_id INTO l_dict_id, l_desc;

Line 1451: FROM hz_merge_dictionary

1447: -- Fetch dictionary details for the entity (Merge procedure)
1448: CURSOR c_dict_details(cp_merge_dict_id NUMBER) IS
1449: SELECT PROCEDURE_NAME, PK_COLUMN_NAME,nvl(DESC_COLUMN_NAME,PK_COLUMN_NAME),
1450: FK_COLUMN_NAME, PARENT_ENTITY_NAME
1451: FROM hz_merge_dictionary
1452: WHERE merge_dict_id = cp_merge_dict_id;
1453:
1454: -- Fecth merge party details from the dictionary
1455: CURSOR c_party_details(cp_ent_name VARCHAR2, cp_pk_value NUMBER) IS

Line 1463: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;

1459: batch_party_id = p_batch_party_id AND
1460: entity_name = cp_ent_name;
1461:
1462:
1463: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1464: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1465: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1466: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1467: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;

Line 1464: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

1460: entity_name = cp_ent_name;
1461:
1462:
1463: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1464: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1465: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1466: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1467: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1468: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;

Line 1465: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;

1461:
1462:
1463: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1464: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1465: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1466: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1467: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1468: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1469: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

Line 1466: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

1462:
1463: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1464: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1465: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1466: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1467: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1468: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1469: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1470: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;

Line 1467: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;

1463: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1464: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1465: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1466: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1467: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1468: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1469: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1470: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1471: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

Line 1468: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;

1464: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1465: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1466: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1467: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1468: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1469: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1470: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1471: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1472: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;

Line 1469: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

1465: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1466: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1467: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1468: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1469: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1470: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1471: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1472: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1473: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

Line 1470: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;

1466: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1467: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1468: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1469: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1470: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1471: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1472: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1473: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1474: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;

Line 1471: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

1467: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1468: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1469: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1470: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1471: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1472: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1473: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1474: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1475: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

Line 1472: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;

1468: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1469: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1470: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1471: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1472: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1473: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1474: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1475: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1476: l_parent_entity_name_b HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;

Line 1473: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

1469: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1470: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1471: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1472: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1473: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1474: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1475: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1476: l_parent_entity_name_b HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1477:

Line 1474: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;

1470: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1471: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1472: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1473: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1474: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1475: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1476: l_parent_entity_name_b HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1477:
1478: l_sub_to_id NUMBER;

Line 1475: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

1471: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1472: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1473: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1474: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1475: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1476: l_parent_entity_name_b HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1477:
1478: l_sub_to_id NUMBER;
1479: l_op_type VARCHAR2(50);

Line 1476: l_parent_entity_name_b HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;

1472: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1473: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1474: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1475: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1476: l_parent_entity_name_b HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1477:
1478: l_sub_to_id NUMBER;
1479: l_op_type VARCHAR2(50);
1480: l_join_clause VARCHAR2(2000);

Line 1687: 'FROM HZ_MERGE_DICTIONARY ' ||

1683:
1684: OPEN c_sub_entities FOR
1685: 'SELECT MERGE_DICT_ID, ENTITY_NAME, FK_COLUMN_NAME, FK_DATA_TYPE, PK_COLUMN_NAME,'||
1686: 'JOIN_CLAUSE, DESCRIPTION, PROCEDURE_NAME, BULK_FLAG '||
1687: 'FROM HZ_MERGE_DICTIONARY ' ||
1688: 'WHERE PARENT_ENTITY_NAME = :pentity' ||
1689: ' AND RULE_SET_NAME = :ruleset '||
1690: ' AND DICT_APPLICATION_ID IN ' || l_pmerge_apps ||
1691: ' AND NVL(BATCH_MERGE_FLAG,''N'') <> ''Y'' '|| --bug4634891

Line 1697: 'FROM HZ_MERGE_DICTIONARY ' ||

1693: ELSE
1694: OPEN c_sub_entities FOR
1695: 'SELECT MERGE_DICT_ID, ENTITY_NAME, FK_COLUMN_NAME, FK_DATA_TYPE, PK_COLUMN_NAME,'||
1696: 'JOIN_CLAUSE, DESCRIPTION, PROCEDURE_NAME, BULK_FLAG '||
1697: 'FROM HZ_MERGE_DICTIONARY ' ||
1698: 'WHERE PARENT_ENTITY_NAME = :pentity' ||
1699: ' AND RULE_SET_NAME = :ruleset '||
1700: ' AND NVL(BATCH_MERGE_FLAG,''N'') <> ''Y'' '|| --bug4634891
1701: ' ORDER BY SEQUENCE_NO ' USING p_entity_name, p_rule_set_name;

Line 2123: l_sub_ent_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;

2119:
2120: -- Dummy join clause
2121: l_join_clause VARCHAR2(2000) := '1=1';
2122:
2123: l_sub_ent_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
2124: l_sub_fkcol HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
2125: l_sub_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
2126: l_sub_joincl VARCHAR2(2000);
2127:

Line 2124: l_sub_fkcol HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

2120: -- Dummy join clause
2121: l_join_clause VARCHAR2(2000) := '1=1';
2122:
2123: l_sub_ent_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
2124: l_sub_fkcol HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
2125: l_sub_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
2126: l_sub_joincl VARCHAR2(2000);
2127:
2128: lockstr VARCHAR2(32000);

Line 2125: l_sub_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

2121: l_join_clause VARCHAR2(2000) := '1=1';
2122:
2123: l_sub_ent_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
2124: l_sub_fkcol HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
2125: l_sub_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
2126: l_sub_joincl VARCHAR2(2000);
2127:
2128: lockstr VARCHAR2(32000);
2129: str_lockstr VARCHAR2(32000);

Line 2181: 'FROM HZ_MERGE_DICTIONARY ' ||

2177: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
2178: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
2179: OPEN c_dict_details FOR
2180: 'SELECT ENTITY_NAME, PK_COLUMN_NAME, FK_COLUMN_NAME, JOIN_CLAUSE, DICT_APPLICATION_ID'||
2181: 'FROM HZ_MERGE_DICTIONARY ' ||
2182: 'WHERE PARENT_ENTITY_NAME = :pentity' ||
2183: ' AND RULE_SET_NAME = :ruleset '||
2184: ' AND DICT_APPLICATION_ID IN ' || l_pmerge_apps ||
2185: ' ORDER BY SEQUENCE_NO ' USING p_entity_name, p_rule_set_name;

Line 2189: 'FROM HZ_MERGE_DICTIONARY ' ||

2185: ' ORDER BY SEQUENCE_NO ' USING p_entity_name, p_rule_set_name;
2186: ELSE
2187: OPEN c_dict_details FOR
2188: 'SELECT ENTITY_NAME, PK_COLUMN_NAME, FK_COLUMN_NAME, JOIN_CLAUSE, DICT_APPLICATION_ID '||
2189: 'FROM HZ_MERGE_DICTIONARY ' ||
2190: 'WHERE PARENT_ENTITY_NAME = :pentity' ||
2191: ' AND RULE_SET_NAME = :ruleset '||
2192: ' ORDER BY SEQUENCE_NO ' USING p_entity_name, p_rule_set_name;
2193: END IF;

Line 2244: FROM HZ_MERGE_PARTY_HISTORY h, HZ_MERGE_DICTIONARY d

2240: x_return_status IN OUT NOCOPY VARCHAR2) IS
2241:
2242: CURSOR c_deleted_records IS
2243: SELECT h.from_entity_id, d.entity_name, d.pk_column_name
2244: FROM HZ_MERGE_PARTY_HISTORY h, HZ_MERGE_DICTIONARY d
2245: WHERE h.merge_dict_id = d.merge_dict_id
2246: AND h.batch_party_id = p_batch_party_id
2247: AND h.request_id = hz_utility_pub.request_id
2248: AND h.operation_type = 'Merge'

Line 2252: l_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;

2248: AND h.operation_type = 'Merge'
2249: ORDER BY h.merge_dict_id desc;
2250:
2251: l_record_id HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_ID%TYPE;
2252: l_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
2253: l_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
2254:
2255: rec_delete VARCHAR2(2000);
2256:

Line 2253: l_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

2249: ORDER BY h.merge_dict_id desc;
2250:
2251: l_record_id HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_ID%TYPE;
2252: l_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
2253: l_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
2254:
2255: rec_delete VARCHAR2(2000);
2256:
2257: BEGIN

Line 2389: p_proc_name IN HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE,

2385: |------------------------------------------------------------------*/
2386:
2387: PROCEDURE exec_merge(
2388: p_entity_name IN VARCHAR2,
2389: p_proc_name IN HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE,
2390: p_from_id IN NUMBER,
2391: x_to_id IN OUT NOCOPY NUMBER,
2392: p_par_from_id IN NUMBER,
2393: p_par_to_id IN NUMBER,

Line 2394: p_parent_entity IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,

2390: p_from_id IN NUMBER,
2391: x_to_id IN OUT NOCOPY NUMBER,
2392: p_par_from_id IN NUMBER,
2393: p_par_to_id IN NUMBER,
2394: p_parent_entity IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,
2395: p_batch_id IN NUMBER,
2396: p_batch_party_id IN NUMBER,
2397: x_return_status IN OUT NOCOPY VARCHAR2) IS
2398:

Line 2475: p_proc_name IN HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE,

2471: |-----------------------------------------------------------------*/
2472:
2473: PROCEDURE exec_merge_r(
2474: p_entity_name IN VARCHAR2,
2475: p_proc_name IN HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE,
2476: p_from_id IN ROWID,
2477: x_to_id IN OUT NOCOPY ROWID,
2478: p_par_from_id IN NUMBER,
2479: p_par_to_id IN NUMBER,

Line 2480: p_parent_entity IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,

2476: p_from_id IN ROWID,
2477: x_to_id IN OUT NOCOPY ROWID,
2478: p_par_from_id IN NUMBER,
2479: p_par_to_id IN NUMBER,
2480: p_parent_entity IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,
2481: p_batch_id IN NUMBER,
2482: p_batch_party_id IN NUMBER,
2483: x_return_status IN OUT NOCOPY VARCHAR2) IS
2484:

Line 2624: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,

2620: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2621: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2622: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2623: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2624: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2625: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,
2626: p_flush IN VARCHAR2 := 'N') IS
2627:
2628: BEGIN

Line 2728: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,

2724: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2725: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2726: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2727: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2728: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2729: p_op_type IN HZ_MERGE_PARTY_LOG.OPERATION_TYPE%TYPE,
2730: p_error IN HZ_MERGE_PARTY_LOG.ERROR_MESSAGES%TYPE
2731: DEFAULT NULL,
2732: p_flush IN VARCHAR2 := 'N') IS

Line 2943: l_proc_name hz_merge_dictionary.procedure_name%type;

2939: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
2940: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
2941: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;
2942: l_new_party_site_id hz_party_sites.party_site_id%type;
2943: l_proc_name hz_merge_dictionary.procedure_name%type;
2944: l_subject_id HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;
2945: l_object_id HZ_RELATIONSHIPS.OBJECT_ID%TYPE;
2946:
2947: l_return_status VARCHAR2(200);

Line 3195: FROM HZ_MERGE_PARTY_HISTORY mh, HZ_MERGE_DICTIONARY md

3191: ) IS
3192:
3193: CURSOR c_merge_to_rec (cp_merge_from_id NUMBER) IS
3194: SELECT mh.TO_ENTITY_ID, mh.TO_ENTITY_DESC
3195: FROM HZ_MERGE_PARTY_HISTORY mh, HZ_MERGE_DICTIONARY md
3196: WHERE mh.merge_dict_id = md.merge_dict_id
3197: AND md.entity_name = p_entity_name
3198: AND mh.from_entity_id = cp_merge_from_id;
3199: