PACKAGE: APPS.OKC_NUMBER_SCHEME_PVT

Source

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