PACKAGE: APPS.OKC_DOC_QA_LIST_PVT

Source

1 PACKAGE OKC_DOC_QA_LIST_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVQALS.pls 120.0 2005/05/26 09:39:26 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_qa_code               IN VARCHAR2,
13     p_document_type         IN VARCHAR2,
14     p_severity_flag         IN VARCHAR2,
15     p_enable_qa_yn          IN VARCHAR2,
16 
17     x_qa_code               OUT NOCOPY VARCHAR2,
18     x_document_type         OUT NOCOPY VARCHAR2
19   );
20 
21   PROCEDURE lock_row(
22     x_return_status                OUT NOCOPY VARCHAR2,
23 
24     p_qa_code               IN VARCHAR2,
25     p_document_type         IN VARCHAR2,
26 
27     p_object_version_number IN NUMBER
28   );
29 
30   PROCEDURE update_row(
31     p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32     x_return_status                OUT NOCOPY VARCHAR2,
33 
34     p_qa_code               IN VARCHAR2,
35     p_document_type         IN VARCHAR2,
36     p_severity_flag         IN VARCHAR2 := NULL,
37     p_enable_qa_yn          IN VARCHAR2 := NULL,
38 
39     p_object_version_number IN NUMBER
40   );
41 
42   PROCEDURE delete_row(
43     x_return_status                OUT NOCOPY VARCHAR2,
44 
45     p_qa_code               IN VARCHAR2,
46     p_document_type         IN VARCHAR2,
47 
48     p_object_version_number IN NUMBER
49   );
50 
51   PROCEDURE validate_row(
52     p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53     x_return_status                OUT NOCOPY VARCHAR2,
54 
55     p_qa_code               IN VARCHAR2,
56     p_document_type         IN VARCHAR2,
57     p_severity_flag         IN VARCHAR2,
58     p_enable_qa_yn          IN VARCHAR2,
59 
60     p_object_version_number IN NUMBER
61   );
62 
63   FUNCTION get_rec (
64     p_qa_code               IN VARCHAR2,
65     p_document_type         IN VARCHAR2,
66 
67     x_severity_flag         OUT NOCOPY VARCHAR2,
68     x_enable_qa_yn          OUT NOCOPY VARCHAR2,
69     x_object_version_number OUT NOCOPY NUMBER,
70     x_created_by            OUT NOCOPY NUMBER,
71     x_creation_date         OUT NOCOPY DATE,
72     x_last_updated_by       OUT NOCOPY NUMBER,
73     x_last_update_login     OUT NOCOPY NUMBER,
74     x_last_update_date      OUT NOCOPY DATE
75 
76   ) RETURN VARCHAR2;
77 
78 
79 
80 END OKC_DOC_QA_LIST_PVT;