1 PACKAGE BODY ASG_PARTY_MERGE_PKG AS
2 /* $Header: asgtcapb.pls 120.1 2005/08/12 02:58:17 saradhak noship $*/
3
4 --
5 -- OBsoleted the procedure for asg_mobile_accesses
6 --
7 -- DESCRIPTION
8 -- This package handles the Party Merge issue in the Table
9 -- 1. ASG_PARTY_ACC (Used by Service)
10 -- If the destination party exists then
11 -- add the counters of the 2 party's (TO and FROM).
12 -- ELSE
13 -- set from_party_id = to_party_id.
14 --
15 -- 2. ASG_MOBILE_ACCESSES (Used by Sales)
16 -- If the destination party (HZ_PARTY) exists then
17 -- add the counters of the 2 party's (TO and FROM).
18 -- IF a HZ_CUSTOMER record also exists then
19 -- add the counters of the 2 customers's (TO and FROM).
20 -- ELSE
21 -- set from_party_id = to_party_id for HZ_PARTY.
22 -- set from_party_id = to_party_id for HZ_CUSTOMER (If exists).
23 --
24
25 PROCEDURE PARTY_ACC_MERGE (p_Entity_name IN varchar2,
26 p_From_id IN Number,
27 x_To_id IN OUT nocopy Number,
28 p_From_FK_id IN Number,
29 p_To_FK_id IN Number,
30 p_Parent_Entity_name IN Varchar2,
31 p_batch_id IN Number,
32 p_Batch_Party_id IN Number,
33 x_return_status OUT nocopy Varchar2) IS
34 BEGIN
35 null;
36 END PARTY_ACC_MERGE;
37
38
39 PROCEDURE MOBILE_ACC_PARTY_MERGE (p_Entity_name IN varchar2,
40 p_From_id IN Number,
41 x_To_id IN OUT nocopy Number,
42 p_From_FK_id IN Number,
43 p_To_FK_id IN Number,
44 p_Parent_Entity_name IN Varchar2,
45 p_batch_id IN Number,
46 p_Batch_Party_id IN Number,
47 x_return_status OUT nocopy Varchar) IS
48 BEGIN
49 null;
50 END MOBILE_ACC_PARTY_MERGE;
51
52 END ASG_PARTY_MERGE_PKG;