[Home] [Help]
PACKAGE: APPS.HZ_PARTY_MERGE
Source
1 PACKAGE HZ_PARTY_MERGE AS
2 /* $Header: ARHPMERS.pls 120.3 2005/06/16 21:14:25 jhuang noship $ */
3
4 PROCEDURE batch_merge(
5 errbuf OUT NOCOPY VARCHAR2,
6 retcode OUT NOCOPY VARCHAR2,
7 p_batch_id IN VARCHAR2,
8 p_preview IN VARCHAR2
9 );
10
11 PROCEDURE veto_delete;
12
13 PROCEDURE get_merge_to_record_id
14 (
15 p_api_version IN NUMBER,
16 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
17 p_record_id IN NUMBER,
18 p_entity_name IN VARCHAR2,
19 x_is_merged OUT NOCOPY VARCHAR2,
20 x_merge_to_record_id OUT NOCOPY NUMBER,
21 x_merge_to_record_desc OUT NOCOPY VARCHAR2,
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2
25 );
26
27 PROCEDURE check_party_in_merge_batch
28 (
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
31 p_party_id IN NUMBER,
32 x_in_merge OUT NOCOPY VARCHAR2,
33 x_batch_id OUT NOCOPY NUMBER,
34 x_batch_name OUT NOCOPY VARCHAR2,
35 x_batch_created_by OUT NOCOPY VARCHAR2,
36 x_batch_creation_date OUT NOCOPY DATE,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
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,
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,
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,
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,
64 p_error IN HZ_MERGE_PARTY_LOG.ERROR_MESSAGES%TYPE
65 DEFAULT NULL,
66 p_flush IN VARCHAR2 := 'N');
67
68 FUNCTION get_col_type(
69 p_table VARCHAR2,
70 p_column VARCHAR2,
71 p_app_name VARCHAR2)
72 RETURN VARCHAR2;
73
74 END HZ_PARTY_MERGE;