1 PACKAGE OKS_PARTY_MERGE_PKG AS
2 /* $Header: OKSPYMGS.pls 120.0 2005/05/25 18:30:33 appldev noship $ */
3
4 /* Merge the records in OKS_BILLING_PROFILES_B */
5
6 PROCEDURE OKS_BILLING_PROFILES(
7 p_entity_name in hz_merge_dictionary.entity_name%type,
8 p_from_id in oks_billing_profiles_b.id%type,
9 x_to_id in out nocopy oks_billing_profiles_b.id%type,
10 p_from_fk_id in hz_merge_parties.from_party_id%type,
11 p_to_fk_id in hz_merge_parties.to_party_id%type,
12 p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
13 p_batch_id in hz_merge_batch.batch_id%type,
14 p_batch_party_id in hz_merge_party_details.batch_party_id%type,
15 x_return_status out nocopy varchar2);
16
17
18 /* Merge the records in OKS_K_DEFAULTS */
19
20 PROCEDURE OKS_DEFAULTS(
21 p_entity_name in hz_merge_dictionary.entity_name%type,
22 p_from_id in oks_k_defaults.id%type,
23 x_to_id in out nocopy oks_k_defaults.id%type,
24 p_from_fk_id in hz_merge_parties.from_party_id%type,
25 p_to_fk_id in hz_merge_parties.to_party_id%type,
26 p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
27 p_batch_id in hz_merge_batch.batch_id%type,
28 p_batch_party_id in hz_merge_party_details.batch_party_id%type,
29 x_return_status out nocopy varchar2);
30
31
32 /* Merge the records in OKS_SERV_AVAIL_EXCEPTS */
33
34 PROCEDURE OKS_SERVICE_EXCEPTS(
35 p_entity_name in hz_merge_dictionary.entity_name%type,
36 p_from_id in oks_serv_avail_excepts.id%type,
37 x_to_id in out nocopy oks_serv_avail_excepts.id%type,
38 p_from_fk_id in hz_merge_parties.from_party_id%type,
39 p_to_fk_id in hz_merge_parties.to_party_id%type,
40 p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
41 p_batch_id in hz_merge_batch.batch_id%type,
42 p_batch_party_id in hz_merge_party_details.batch_party_id%type,
43 x_return_status out nocopy varchar2);
44
45 /* Merge the records in OKS_QUALIFIERS */
46
47 PROCEDURE OKS_QUALIFIERS(
48 p_entity_name in hz_merge_dictionary.entity_name%type,
49 p_from_id in number,
50 x_to_id in out nocopy number,
51 p_from_fk_id in number,
52 p_to_fk_id in number,
53 p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
54 p_batch_id in hz_merge_batch.batch_id%type,
55 p_batch_party_id in hz_merge_party_details.batch_party_id%type,
56 x_return_status out nocopy varchar2);
57
58
59 END OKS_PARTY_MERGE_PKG;