1 PACKAGE HZ_DNB_HIERARCHY_PVT AUTHID CURRENT_USER AS
2 /* $Header: ARHDNBHS.pls 120.3 2005/06/16 21:10:22 jhuang noship $ */
3 --------------------------------------
4 -- AUTHOR :::::: COLATHUR VIJAYAN (VJN)
5 --------------------------------------
6
7 TYPE dnb_dfs_rec_type IS RECORD (
8 party_id NUMBER,
9 start_date DATE
10
11 );
12
13 --------------------------------------------------------------------------------------
14 -- create_dnb_hierarchy ::: THIS WILL FIX DNB DATA, BY CREATING A HIERARCHY FOR
15 -- DNB PURCHASED PARTIES, BASED ON THE INFORMATION AVAILABLE
16 -- FROM THE EXISTING NON-HIERARCHICAL RELATIONSHIPS FOR
17 -- DNB IMPORTED DATA.
18 --------------------------------------------------------------------------------------
19
20 PROCEDURE create_dnb_hierarchy (
21 -- input parameters
22 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23 -- output parameters
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER,
26 x_msg_data OUT NOCOPY VARCHAR2
27 );
28
29 --------------------------------------------------------------------------------------
30 -- create_dnb_hierarchy ::: THE ABOVE PROCEDURE IS OVERLOADED SO THAT IT CAN BE CALLED
31 -- AS A CONCURRENT PROGRAM.
32 --------------------------------------------------------------------------------------
33
34 PROCEDURE create_dnb_hierarchy (
35 errbuf OUT NOCOPY VARCHAR2,
36 Retcode OUT NOCOPY VARCHAR2,
37 -- introducing this to have a functionality in the future
38 -- so that a user could use this argument in the concurrent program
39 -- to run the cleanup script before running CPS
40 cleanup_required IN VARCHAR2 DEFAULT 'N'
41 );
42
43 ----------------------------------------------------------------------------------------------
44 -- conform_party_to_dnb_hierarchy ::: THIS WILL CONFORM A PURCHASED PARTY TO THE DNB HIERARCHY
45 -- CREATED BY THE ABOVE PROCEDURE.
46 ----------------------------------------------------------------------------------------------
47
48 PROCEDURE conform_party_to_dnb_hierarchy (
49 -- input parameters
50 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51 party_id IN NUMBER,
52 parent_party_id IN NUMBER,
53 dup_party_id IN NUMBER,
54 gup_party_id IN NUMBER,
55 -- This flag should be passed in as
56 -- H -- if parent_party_id is a PARENT_OF party_id
57 -- P -- if parent_party_id is a HEADQUARTER_OF party_id
58 parent_type_flag IN VARCHAR2,
59 -- output parameters
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65
66 END HZ_DNB_HIERARCHY_PVT ;
67
68