1 PACKAGE OKC_ARTICLE_ADOPTIONS_PVT AS
2 /* $Header: OKCVADPS.pls 120.0 2005/05/25 18:47:25 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7
8 PROCEDURE insert_row(
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 x_return_status OUT NOCOPY VARCHAR2,
11
12 p_global_article_version_id IN NUMBER,
13 p_adoption_type IN VARCHAR2,
14 p_local_org_id IN NUMBER,
15 p_local_article_version_id IN NUMBER,
16 p_adoption_status IN VARCHAR2,
17
18
19
20 x_global_article_version_id OUT NOCOPY NUMBER,
21 x_local_org_id OUT NOCOPY NUMBER,
22 x_local_article_version_id OUT NOCOPY NUMBER
23 );
24
25 PROCEDURE lock_row(
26 x_return_status OUT NOCOPY VARCHAR2,
27
28 p_global_article_version_id IN NUMBER,
29 p_local_org_id IN NUMBER,
30 p_local_article_version_id IN NUMBER,
31
32 p_object_version_number IN NUMBER
33 );
34
35 PROCEDURE update_row(
36 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37 x_return_status OUT NOCOPY VARCHAR2,
38
39 p_global_article_version_id IN NUMBER,
40 p_adoption_type IN VARCHAR2,
41 p_local_org_id IN NUMBER,
42 p_orig_local_version_id IN NUMBER,
43 p_new_local_version_id IN NUMBER,
44 p_adoption_status IN VARCHAR2,
45
46
47
48 p_object_version_number IN NUMBER
49 );
50
51 PROCEDURE delete_row(
52 x_return_status OUT NOCOPY VARCHAR2,
53
54 p_global_article_version_id IN NUMBER,
55 p_local_org_id IN NUMBER,
56 p_local_article_version_id IN NUMBER,
57
58 p_object_version_number IN NUMBER
59 );
60
61 PROCEDURE validate_row(
62 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63 x_return_status OUT NOCOPY VARCHAR2,
64
65 p_global_article_version_id IN NUMBER,
66 p_adoption_type IN VARCHAR2,
67 p_local_org_id IN NUMBER,
68 p_local_article_version_id IN NUMBER,
69 p_adoption_status IN VARCHAR2,
70
71
72
73 p_object_version_number IN NUMBER
74 );
75
76 FUNCTION get_rec (
77 p_global_article_version_id IN OUT NOCOPY NUMBER,
78 p_local_org_id IN NUMBER,
79 p_local_article_version_id IN NUMBER,
80
81 x_adoption_type OUT NOCOPY VARCHAR2,
82 x_adoption_status OUT NOCOPY VARCHAR2,
83 x_object_version_number OUT NOCOPY NUMBER,
84 x_created_by OUT NOCOPY NUMBER,
85 x_creation_date OUT NOCOPY DATE,
86 x_last_updated_by OUT NOCOPY NUMBER,
87 x_last_update_login OUT NOCOPY NUMBER,
88 x_last_update_date OUT NOCOPY DATE
89
90 ) RETURN VARCHAR2;
91
92
93
94 END OKC_ARTICLE_ADOPTIONS_PVT;