PACKAGE: APPS.OKC_ARTICLE_RELATIONSHIPS_PVT

Source

1 PACKAGE OKC_ARTICLE_RELATIONSHIPS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVARLS.pls 120.0 2005/05/25 22:41:15 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_source_article_id     IN NUMBER,
13     p_target_article_id     IN NUMBER,
14     p_org_id                IN NUMBER,
15     p_relationship_type     IN VARCHAR2,
16 
17 
18 
19     x_source_article_id     OUT NOCOPY NUMBER,
20     x_target_article_id     OUT NOCOPY NUMBER,
21     x_org_id                OUT NOCOPY NUMBER
22   );
23 
24   PROCEDURE lock_row(
25     x_return_status                OUT NOCOPY VARCHAR2,
26 
27     p_source_article_id     IN NUMBER,
28     p_target_article_id     IN NUMBER,
29     p_org_id                IN NUMBER,
30 
31     p_object_version_number IN NUMBER
32   );
33 
34   PROCEDURE update_row(
35     p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36     x_return_status                OUT NOCOPY VARCHAR2,
37 
38     p_source_article_id     IN NUMBER,
39     p_target_article_id     IN NUMBER,
40     p_org_id                IN NUMBER,
41     p_relationship_type     IN VARCHAR2,
42 
43 
44 
45     p_object_version_number IN NUMBER
46   );
47 
48   PROCEDURE delete_row(
49     x_return_status                OUT NOCOPY VARCHAR2,
50 
51     p_source_article_id     IN NUMBER,
52     p_target_article_id     IN NUMBER,
53     p_org_id                IN NUMBER,
54 
55     p_object_version_number IN NUMBER
56   );
57 
58   PROCEDURE validate_row(
59     p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60     x_return_status                OUT NOCOPY VARCHAR2,
61 
62     p_source_article_id     IN NUMBER,
63     p_target_article_id     IN NUMBER,
64     p_org_id                IN NUMBER,
65     p_relationship_type     IN VARCHAR2,
66 
67 
68 
69     p_object_version_number IN NUMBER
70   );
71 
72   FUNCTION get_rec (
73     p_source_article_id     IN NUMBER,
74     p_target_article_id     IN NUMBER,
75     p_org_id                IN NUMBER,
76 
77     x_relationship_type     OUT NOCOPY VARCHAR2,
78     x_object_version_number OUT NOCOPY NUMBER,
79     x_created_by            OUT NOCOPY NUMBER,
80     x_creation_date         OUT NOCOPY DATE,
81     x_last_updated_by       OUT NOCOPY NUMBER,
82     x_last_update_login     OUT NOCOPY NUMBER,
83     x_last_update_date      OUT NOCOPY DATE
84 
85   ) RETURN VARCHAR2;
86 
87 
88 
89 END OKC_ARTICLE_RELATIONSHIPS_PVT;