1 PACKAGE OKC_ADOPTIONS_GRP AUTHID CURRENT_USER AS
2 /* $Header: OKCGADPS.pls 120.0 2005/05/25 22:31:36 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7
8 PROCEDURE check_adoption_details(
9 p_api_version IN NUMBER,
10 p_init_msg_list IN VARCHAR2 ,
11 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12
13 x_return_status OUT NOCOPY VARCHAR2,
14 x_msg_count OUT NOCOPY NUMBER,
15 x_msg_data OUT NOCOPY VARCHAR2,
16
17 x_earlier_local_version_id OUT NOCOPY VARCHAR2,
18 p_global_article_version_id IN NUMBER,
19 p_adoption_type IN VARCHAR2,
20 p_local_org_id IN NUMBER
21 );
22
23 PROCEDURE delete_local_adoption_details(
24 p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2 ,
26
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30
31 p_only_local_version IN VARCHAR2,
32 p_local_article_version_id IN NUMBER,
33 p_local_org_id IN NUMBER
34 );
35
36 PROCEDURE create_local_adoption_details(
37 p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 ,
39 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 x_adoption_type OUT NOCOPY VARCHAR2,
45
46 p_article_status IN VARCHAR2,
47 p_earlier_local_version_id IN NUMBER,
48 p_local_article_version_id IN NUMBER,
49 p_global_article_version_id IN NUMBER,
50 p_local_org_id IN NUMBER
51 );
52
53 PROCEDURE AUTO_ADOPT_ARTICLES
54 (
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 ,
57 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58 p_commit IN VARCHAR2 := FND_API.G_FALSE,
59
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_relationship_yn IN VARCHAR2 := 'N',
64 p_adoption_yn IN VARCHAR2 := 'N',
65 p_fetchsize IN NUMBER,
66 p_global_article_id IN NUMBER,
67 p_global_article_version_id IN NUMBER
68 ) ;
69
70 -- The following procedure is a concurrent job that will be run if a new org is added and hence there is a
71 -- need to create autoadoption rows for the currently active global article versions
72
73 PROCEDURE AUTO_ADOPT_NEWORG
74 (errbuf OUT NOCOPY VARCHAR2,
75 retcode OUT NOCOPY VARCHAR2,
76 p_org_id IN NUMBER ,
77 p_fetchsize IN NUMBER
78 ) ;
79
80
81 END OKC_ADOPTIONS_GRP;