39: x_msg_data OUT NOCOPY VARCHAR2
40: );
41:
42: PROCEDURE store_merge_history(
43: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
44: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
45: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
46: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
47: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
40: );
41:
42: PROCEDURE store_merge_history(
43: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
44: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
45: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
46: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
47: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
48: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
41:
42: PROCEDURE store_merge_history(
43: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
44: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
45: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
46: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
47: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
48: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
49: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
42: PROCEDURE store_merge_history(
43: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
44: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
45: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
46: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
47: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
48: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
49: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
50: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
43: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
44: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
45: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
46: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
47: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
48: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
49: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
50: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
51: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,
51: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,
52: p_flush IN VARCHAR2 := 'N');
53:
54: PROCEDURE store_merge_log(
55: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
56: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
57: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
58: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
59: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
52: p_flush IN VARCHAR2 := 'N');
53:
54: PROCEDURE store_merge_log(
55: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
56: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
57: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
58: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
59: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
60: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
53:
54: PROCEDURE store_merge_log(
55: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
56: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
57: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
58: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
59: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
60: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
61: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
54: PROCEDURE store_merge_log(
55: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
56: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
57: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
58: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
59: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
60: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
61: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
62: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
55: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
56: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
57: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
58: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
59: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
60: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
61: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
62: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
63: p_op_type IN HZ_MERGE_PARTY_LOG.OPERATION_TYPE%TYPE,