PACKAGE: APPS.OKC_NUMBER_SCHEME_DTL_PVT

Source

1 PACKAGE OKC_NUMBER_SCHEME_DTL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVNSDS.pls 120.0 2005/05/25 19:02: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_num_sequence_code     IN VARCHAR2,
14     p_sequence_level        IN NUMBER,
15     p_concatenation_yn      IN VARCHAR2,
16     p_end_character         IN VARCHAR2,
17 
18 
19 
20     x_num_scheme_id         OUT NOCOPY NUMBER,
21     x_num_sequence_code     OUT NOCOPY VARCHAR2,
22     x_sequence_level        OUT NOCOPY NUMBER
23   );
24 
25   PROCEDURE lock_row(
26     x_return_status                OUT NOCOPY VARCHAR2,
27 
28     p_num_scheme_id         IN NUMBER,
29     p_num_sequence_code     IN VARCHAR2,
30     p_sequence_level        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_num_scheme_id         IN NUMBER,
40     p_num_sequence_code     IN VARCHAR2,
41     p_sequence_level        IN NUMBER,
42     p_concatenation_yn      IN VARCHAR2 := NULL,
43     p_end_character         IN VARCHAR2 := NULL,
44 
45 
46 
47     p_object_version_number IN NUMBER
48   );
49 
50   PROCEDURE delete_row(
51     x_return_status                OUT NOCOPY VARCHAR2,
52 
53     p_num_scheme_id         IN NUMBER,
54     p_num_sequence_code     IN VARCHAR2,
55     p_sequence_level        IN NUMBER,
56 
57     p_object_version_number IN NUMBER
58   );
59 
60   PROCEDURE delete_set(
61     x_return_status                OUT NOCOPY VARCHAR2,
62 
63     p_num_scheme_id         IN NUMBER
64   );
65 
66   PROCEDURE validate_row(
67     p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68     x_return_status                OUT NOCOPY VARCHAR2,
69 
70     p_num_scheme_id         IN NUMBER,
71     p_num_sequence_code     IN VARCHAR2,
72     p_sequence_level        IN NUMBER,
73     p_concatenation_yn      IN VARCHAR2,
74     p_end_character         IN VARCHAR2,
75 
76 
77 
78     p_object_version_number IN NUMBER
79   );
80 
81   FUNCTION get_rec (
82     p_num_scheme_id         IN NUMBER,
83     p_num_sequence_code     IN VARCHAR2,
84     p_sequence_level        IN NUMBER,
85 
86     x_concatenation_yn      OUT NOCOPY VARCHAR2,
87     x_end_character         OUT NOCOPY VARCHAR2,
88     x_object_version_number OUT NOCOPY NUMBER,
89     x_created_by            OUT NOCOPY NUMBER,
90     x_creation_date         OUT NOCOPY DATE,
91     x_last_updated_by       OUT NOCOPY NUMBER,
92     x_last_update_login     OUT NOCOPY NUMBER,
93     x_last_update_date      OUT NOCOPY DATE
94 
95   ) RETURN VARCHAR2;
96 
97 
98 
99 END OKC_NUMBER_SCHEME_DTL_PVT;