[Home] [Help]
PACKAGE: APPS.HZ_PARTY_MERGE
Source
1 PACKAGE HZ_PARTY_MERGE AUTHID CURRENT_USER AS
2 /* $Header: ARHPMERS.pls 120.3.12020000.2 2013/03/27 07:23:14 vsegu ship $ */
3
4 g_automerge_flag VARCHAR2(1); --8536294
5 g_merge_reason_code VARCHAR2(30);
6
7 PROCEDURE batch_merge(
8 errbuf OUT NOCOPY VARCHAR2,
9 retcode OUT NOCOPY VARCHAR2,
10 p_batch_id IN VARCHAR2,
11 p_preview IN VARCHAR2
12 );
13
14 PROCEDURE veto_delete;
15
16 PROCEDURE get_merge_to_record_id
17 (
18 p_api_version IN NUMBER,
19 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
20 p_record_id IN NUMBER,
21 p_entity_name IN VARCHAR2,
22 x_is_merged OUT NOCOPY VARCHAR2,
23 x_merge_to_record_id OUT NOCOPY NUMBER,
24 x_merge_to_record_desc OUT NOCOPY VARCHAR2,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2
28 );
29
30 PROCEDURE check_party_in_merge_batch
31 (
32 p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
34 p_party_id IN NUMBER,
35 x_in_merge OUT NOCOPY VARCHAR2,
36 x_batch_id OUT NOCOPY NUMBER,
37 x_batch_name OUT NOCOPY VARCHAR2,
38 x_batch_created_by OUT NOCOPY VARCHAR2,
39 x_batch_creation_date OUT NOCOPY DATE,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2
43 );
44
45 PROCEDURE store_merge_history(
46 p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
47 p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
48 p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
49 p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
50 p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
51 p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
52 p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
53 p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
54 p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,
55 p_flush IN VARCHAR2 := 'N');
56
57 PROCEDURE store_merge_log(
58 p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
59 p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
60 p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
61 p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
62 p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
63 p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
64 p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
65 p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
66 p_op_type IN HZ_MERGE_PARTY_LOG.OPERATION_TYPE%TYPE,
67 p_error IN HZ_MERGE_PARTY_LOG.ERROR_MESSAGES%TYPE
68 DEFAULT NULL,
69 p_flush IN VARCHAR2 := 'N');
70
71 FUNCTION get_col_type(
72 p_table VARCHAR2,
73 p_column VARCHAR2,
74 p_app_name VARCHAR2)
75 RETURN VARCHAR2;
76
77 END HZ_PARTY_MERGE;