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 358: FROM HZ_MERGE_DICTIONARY

354:
355:
356: CURSOR c_dict_id(cp_ruleset_name VARCHAR2, cp_entity_name VARCHAR2) IS
357: SELECT merge_dict_id
358: FROM HZ_MERGE_DICTIONARY
359: WHERE RULE_SET_NAME = cp_ruleset_name
360: AND ENTITY_NAME = cp_entity_name;
361:
362: cursor c_request_type(cp_batch_id NUMBER) is

Line 375: from hz_merge_dictionary

371: and mb.batch_id = cp_batch_id;
372:
373: cursor c_dict_no_fktype is
374: select entity_name, fk_column_name, merge_dict_id, dict_application_id
375: from hz_merge_dictionary
376: where fk_data_type is null;
377:
378: cursor app_name(app_id NUMBER) IS
379: Select application_short_name from fnd_application where application_id=app_id;

Line 391: from hz_merge_dictionary

387: --start bug 4634891
388:
389: CURSOR batch_merge_procedures IS
390: select merge_dict_id, entity_name, procedure_name
391: from hz_merge_dictionary
392: where merge_dict_id in (
393: select min(merge_dict_id)
394: from HZ_MERGE_DICTIONARY where batch_merge_flag = 'Y'
395: group by procedure_name);

Line 394: from HZ_MERGE_DICTIONARY where batch_merge_flag = 'Y'

390: select merge_dict_id, entity_name, procedure_name
391: from hz_merge_dictionary
392: where merge_dict_id in (
393: select min(merge_dict_id)
394: from HZ_MERGE_DICTIONARY where batch_merge_flag = 'Y'
395: group by procedure_name);
396:
397: CURSOR merge_to_parties IS
398: select DISTINCT(to_party_id)

Line 404: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;

400: where batch_id = p_batch_id
401: and merge_status = 'DONE';
402:
403:
404: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
405: --end bug 4634891
406:
407: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
408: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;

Line 433: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;

429:
430: l_from_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
431: l_to_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
432:
433: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
434: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
435:
436:
437: l_num_merged NUMBER;

Line 434: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

430: l_from_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
431: l_to_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
432:
433: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
434: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
435:
436:
437: l_num_merged NUMBER;
438:

Line 607: update hz_merge_dictionary

603: close app_name;
604:
605: l_data_type:=get_col_type(l_sub_entity_name,l_sub_fk_column_name,l_app_name);
606:
607: update hz_merge_dictionary
608: set fk_data_type = l_data_type
609: where merge_dict_id = l_merge_dict_id;
610:
611: end loop;

Line 1343: FROM HZ_MERGE_DICTIONARY

1339: x_return_status IN OUT NOCOPY VARCHAR2) IS
1340:
1341: CURSOR c_dict_id(cp_ruleset_name VARCHAR2, cp_entity_name VARCHAR2) IS
1342: SELECT merge_dict_id, DESCRIPTION
1343: FROM HZ_MERGE_DICTIONARY
1344: WHERE RULE_SET_NAME = cp_ruleset_name
1345: AND ENTITY_NAME = cp_entity_name;
1346:
1347: l_dict_id NUMBER;

Line 1348: l_desc HZ_MERGE_DICTIONARY.DESCRIPTION%TYPE;

1344: WHERE RULE_SET_NAME = cp_ruleset_name
1345: AND ENTITY_NAME = cp_entity_name;
1346:
1347: l_dict_id NUMBER;
1348: l_desc HZ_MERGE_DICTIONARY.DESCRIPTION%TYPE;
1349:
1350: BEGIN
1351: OPEN c_dict_id(p_rule_set_name,p_entity_name);
1352: FETCH c_dict_id INTO l_dict_id, l_desc;

Line 1411: FROM hz_merge_dictionary

1407: -- Fetch dictionary details for the entity (Merge procedure)
1408: CURSOR c_dict_details(cp_merge_dict_id NUMBER) IS
1409: SELECT PROCEDURE_NAME, PK_COLUMN_NAME,nvl(DESC_COLUMN_NAME,PK_COLUMN_NAME),
1410: FK_COLUMN_NAME, PARENT_ENTITY_NAME
1411: FROM hz_merge_dictionary
1412: WHERE merge_dict_id = cp_merge_dict_id;
1413:
1414: -- Fecth merge party details from the dictionary
1415: CURSOR c_party_details(cp_ent_name VARCHAR2, cp_pk_value NUMBER) IS

Line 1423: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;

1419: batch_party_id = p_batch_party_id AND
1420: entity_name = cp_ent_name;
1421:
1422:
1423: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1424: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1425: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1426: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1427: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;

Line 1424: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

1420: entity_name = cp_ent_name;
1421:
1422:
1423: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1424: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1425: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1426: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1427: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1428: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;

Line 1425: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;

1421:
1422:
1423: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1424: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1425: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1426: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1427: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1428: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1429: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

Line 1426: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

1422:
1423: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1424: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1425: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1426: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1427: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1428: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1429: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1430: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;

Line 1427: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;

1423: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1424: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1425: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1426: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1427: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1428: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1429: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1430: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1431: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

Line 1428: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;

1424: l_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1425: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1426: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1427: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1428: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1429: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1430: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1431: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1432: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;

Line 1429: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

1425: l_desc_column_name HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1426: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1427: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1428: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1429: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1430: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1431: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1432: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1433: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

Line 1430: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;

1426: l_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1427: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1428: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1429: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1430: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1431: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1432: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1433: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1434: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;

Line 1431: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

1427: l_parent_entity_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1428: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1429: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1430: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1431: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1432: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1433: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1434: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1435: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

Line 1432: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;

1428: l_sub_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
1429: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1430: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1431: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1432: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1433: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1434: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1435: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1436: l_parent_entity_name_b HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;

Line 1433: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

1429: l_sub_fk_column_name HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1430: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1431: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1432: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1433: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1434: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1435: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1436: l_parent_entity_name_b HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1437:

Line 1434: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;

1430: l_sub_fk_column_type HZ_MERGE_DICTIONARY.FK_DATA_TYPE%TYPE;
1431: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1432: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1433: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1434: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1435: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1436: l_parent_entity_name_b HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1437:
1438: l_sub_to_id NUMBER;

Line 1435: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

1431: l_sub_pk_column_name HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1432: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1433: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1434: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1435: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1436: l_parent_entity_name_b HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1437:
1438: l_sub_to_id NUMBER;
1439: l_op_type VARCHAR2(50);

Line 1436: l_parent_entity_name_b HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;

1432: l_proc_name_b HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
1433: l_pk_column_name_b HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
1434: l_desc_column_name_b HZ_MERGE_DICTIONARY.DESC_COLUMN_NAME%TYPE;
1435: l_fk_column_name_b HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
1436: l_parent_entity_name_b HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
1437:
1438: l_sub_to_id NUMBER;
1439: l_op_type VARCHAR2(50);
1440: l_join_clause VARCHAR2(2000);

Line 1647: 'FROM HZ_MERGE_DICTIONARY ' ||

1643:
1644: OPEN c_sub_entities FOR
1645: 'SELECT MERGE_DICT_ID, ENTITY_NAME, FK_COLUMN_NAME, FK_DATA_TYPE, PK_COLUMN_NAME,'||
1646: 'JOIN_CLAUSE, DESCRIPTION, PROCEDURE_NAME, BULK_FLAG '||
1647: 'FROM HZ_MERGE_DICTIONARY ' ||
1648: 'WHERE PARENT_ENTITY_NAME = :pentity' ||
1649: ' AND RULE_SET_NAME = :ruleset '||
1650: ' AND DICT_APPLICATION_ID IN ' || l_pmerge_apps ||
1651: ' AND NVL(BATCH_MERGE_FLAG,''N'') <> ''Y'' '|| --bug4634891

Line 1657: 'FROM HZ_MERGE_DICTIONARY ' ||

1653: ELSE
1654: OPEN c_sub_entities FOR
1655: 'SELECT MERGE_DICT_ID, ENTITY_NAME, FK_COLUMN_NAME, FK_DATA_TYPE, PK_COLUMN_NAME,'||
1656: 'JOIN_CLAUSE, DESCRIPTION, PROCEDURE_NAME, BULK_FLAG '||
1657: 'FROM HZ_MERGE_DICTIONARY ' ||
1658: 'WHERE PARENT_ENTITY_NAME = :pentity' ||
1659: ' AND RULE_SET_NAME = :ruleset '||
1660: ' AND NVL(BATCH_MERGE_FLAG,''N'') <> ''Y'' '|| --bug4634891
1661: ' ORDER BY SEQUENCE_NO ' USING p_entity_name, p_rule_set_name;

Line 2083: l_sub_ent_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;

2079:
2080: -- Dummy join clause
2081: l_join_clause VARCHAR2(2000) := '1=1';
2082:
2083: l_sub_ent_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
2084: l_sub_fkcol HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
2085: l_sub_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
2086: l_sub_joincl VARCHAR2(2000);
2087:

Line 2084: l_sub_fkcol HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;

2080: -- Dummy join clause
2081: l_join_clause VARCHAR2(2000) := '1=1';
2082:
2083: l_sub_ent_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
2084: l_sub_fkcol HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
2085: l_sub_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
2086: l_sub_joincl VARCHAR2(2000);
2087:
2088: lockstr VARCHAR2(32000);

Line 2085: l_sub_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

2081: l_join_clause VARCHAR2(2000) := '1=1';
2082:
2083: l_sub_ent_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
2084: l_sub_fkcol HZ_MERGE_DICTIONARY.FK_COLUMN_NAME%TYPE;
2085: l_sub_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
2086: l_sub_joincl VARCHAR2(2000);
2087:
2088: lockstr VARCHAR2(32000);
2089: str_lockstr VARCHAR2(32000);

Line 2141: 'FROM HZ_MERGE_DICTIONARY ' ||

2137: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
2138: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
2139: OPEN c_dict_details FOR
2140: 'SELECT ENTITY_NAME, PK_COLUMN_NAME, FK_COLUMN_NAME, JOIN_CLAUSE, DICT_APPLICATION_ID'||
2141: 'FROM HZ_MERGE_DICTIONARY ' ||
2142: 'WHERE PARENT_ENTITY_NAME = :pentity' ||
2143: ' AND RULE_SET_NAME = :ruleset '||
2144: ' AND DICT_APPLICATION_ID IN ' || l_pmerge_apps ||
2145: ' ORDER BY SEQUENCE_NO ' USING p_entity_name, p_rule_set_name;

Line 2149: 'FROM HZ_MERGE_DICTIONARY ' ||

2145: ' ORDER BY SEQUENCE_NO ' USING p_entity_name, p_rule_set_name;
2146: ELSE
2147: OPEN c_dict_details FOR
2148: 'SELECT ENTITY_NAME, PK_COLUMN_NAME, FK_COLUMN_NAME, JOIN_CLAUSE, DICT_APPLICATION_ID '||
2149: 'FROM HZ_MERGE_DICTIONARY ' ||
2150: 'WHERE PARENT_ENTITY_NAME = :pentity' ||
2151: ' AND RULE_SET_NAME = :ruleset '||
2152: ' ORDER BY SEQUENCE_NO ' USING p_entity_name, p_rule_set_name;
2153: END IF;

Line 2204: FROM HZ_MERGE_PARTY_HISTORY h, HZ_MERGE_DICTIONARY d

2200: x_return_status IN OUT NOCOPY VARCHAR2) IS
2201:
2202: CURSOR c_deleted_records IS
2203: SELECT h.from_entity_id, d.entity_name, d.pk_column_name
2204: FROM HZ_MERGE_PARTY_HISTORY h, HZ_MERGE_DICTIONARY d
2205: WHERE h.merge_dict_id = d.merge_dict_id
2206: AND h.batch_party_id = p_batch_party_id
2207: AND h.request_id = hz_utility_pub.request_id
2208: AND h.operation_type = 'Merge'

Line 2212: l_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;

2208: AND h.operation_type = 'Merge'
2209: ORDER BY h.merge_dict_id desc;
2210:
2211: l_record_id HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_ID%TYPE;
2212: l_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
2213: l_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
2214:
2215: rec_delete VARCHAR2(2000);
2216:

Line 2213: l_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;

2209: ORDER BY h.merge_dict_id desc;
2210:
2211: l_record_id HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_ID%TYPE;
2212: l_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
2213: l_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
2214:
2215: rec_delete VARCHAR2(2000);
2216:
2217: BEGIN

Line 2349: p_proc_name IN HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE,

2345: |------------------------------------------------------------------*/
2346:
2347: PROCEDURE exec_merge(
2348: p_entity_name IN VARCHAR2,
2349: p_proc_name IN HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE,
2350: p_from_id IN NUMBER,
2351: x_to_id IN OUT NOCOPY NUMBER,
2352: p_par_from_id IN NUMBER,
2353: p_par_to_id IN NUMBER,

Line 2354: p_parent_entity IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,

2350: p_from_id IN NUMBER,
2351: x_to_id IN OUT NOCOPY NUMBER,
2352: p_par_from_id IN NUMBER,
2353: p_par_to_id IN NUMBER,
2354: p_parent_entity IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,
2355: p_batch_id IN NUMBER,
2356: p_batch_party_id IN NUMBER,
2357: x_return_status IN OUT NOCOPY VARCHAR2) IS
2358:

Line 2435: p_proc_name IN HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE,

2431: |-----------------------------------------------------------------*/
2432:
2433: PROCEDURE exec_merge_r(
2434: p_entity_name IN VARCHAR2,
2435: p_proc_name IN HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE,
2436: p_from_id IN ROWID,
2437: x_to_id IN OUT NOCOPY ROWID,
2438: p_par_from_id IN NUMBER,
2439: p_par_to_id IN NUMBER,

Line 2440: p_parent_entity IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,

2436: p_from_id IN ROWID,
2437: x_to_id IN OUT NOCOPY ROWID,
2438: p_par_from_id IN NUMBER,
2439: p_par_to_id IN NUMBER,
2440: p_parent_entity IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,
2441: p_batch_id IN NUMBER,
2442: p_batch_party_id IN NUMBER,
2443: x_return_status IN OUT NOCOPY VARCHAR2) IS
2444:

Line 2584: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,

2580: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2581: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2582: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2583: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2584: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2585: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,
2586: p_flush IN VARCHAR2 := 'N') IS
2587:
2588: BEGIN

Line 2688: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,

2684: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2685: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2686: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2687: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2688: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2689: p_op_type IN HZ_MERGE_PARTY_LOG.OPERATION_TYPE%TYPE,
2690: p_error IN HZ_MERGE_PARTY_LOG.ERROR_MESSAGES%TYPE
2691: DEFAULT NULL,
2692: p_flush IN VARCHAR2 := 'N') IS

Line 2903: l_proc_name hz_merge_dictionary.procedure_name%type;

2899: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
2900: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
2901: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;
2902: l_new_party_site_id hz_party_sites.party_site_id%type;
2903: l_proc_name hz_merge_dictionary.procedure_name%type;
2904: l_subject_id HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;
2905: l_object_id HZ_RELATIONSHIPS.OBJECT_ID%TYPE;
2906:
2907: l_return_status VARCHAR2(200);

Line 3155: FROM HZ_MERGE_PARTY_HISTORY mh, HZ_MERGE_DICTIONARY md

3151: ) IS
3152:
3153: CURSOR c_merge_to_rec (cp_merge_from_id NUMBER) IS
3154: SELECT mh.TO_ENTITY_ID, mh.TO_ENTITY_DESC
3155: FROM HZ_MERGE_PARTY_HISTORY mh, HZ_MERGE_DICTIONARY md
3156: WHERE mh.merge_dict_id = md.merge_dict_id
3157: AND md.entity_name = p_entity_name
3158: AND mh.from_entity_id = cp_merge_from_id;
3159: