PACKAGE: APPS.OKC_NUMBER_SCHEME_DTL_GRP

Source

1 PACKAGE OKC_NUMBER_SCHEME_DTL_GRP AS
2 /* $Header: OKCGNSDS.pls 120.0 2005/05/26 09:36:11 appldev noship $ */
3 
4   ---------------------------------------------------------------------------
5   -- Procedures and Functions
6   ---------------------------------------------------------------------------
7 
8   PROCEDURE Insert_Number_Scheme_Dtl(
9     p_api_version                  IN NUMBER,
10     p_init_msg_list                IN VARCHAR2 ,
11     p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12     p_commit                       IN VARCHAR2 := FND_API.G_FALSE,
13 
14     x_return_status                OUT NOCOPY VARCHAR2,
15     x_msg_count                    OUT NOCOPY NUMBER,
16     x_msg_data                     OUT NOCOPY VARCHAR2,
17 
18     p_num_scheme_id         IN NUMBER,
19     p_num_sequence_code     IN VARCHAR2,
20     p_sequence_level        IN NUMBER,
21     p_concatenation_yn      IN VARCHAR2,
22     p_end_character         IN VARCHAR2,
23 
24 
25 
26     x_num_scheme_id         OUT NOCOPY NUMBER,
27     x_num_sequence_code     OUT NOCOPY VARCHAR2,
28     x_sequence_level        OUT NOCOPY NUMBER
29 
30     );
31 
32   PROCEDURE Lock_Number_Scheme_Dtl(
33     p_api_version                  IN NUMBER,
34     p_init_msg_list                IN VARCHAR2 ,
35 
36     x_return_status                OUT NOCOPY VARCHAR2,
37     x_msg_count                    OUT NOCOPY NUMBER,
38     x_msg_data                     OUT NOCOPY VARCHAR2,
39 
40     p_num_scheme_id         IN NUMBER,
41     p_num_sequence_code     IN VARCHAR2,
42     p_sequence_level        IN NUMBER,
43 
44     p_object_version_number IN NUMBER
45 
46     );
47 
48   PROCEDURE Update_Number_Scheme_Dtl(
49     p_api_version                  IN NUMBER,
50     p_init_msg_list                IN VARCHAR2 ,
51     p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52     p_commit                       IN VARCHAR2 := FND_API.G_FALSE,
53 
54     x_return_status                OUT NOCOPY VARCHAR2,
55     x_msg_count                    OUT NOCOPY NUMBER,
56     x_msg_data                     OUT NOCOPY VARCHAR2,
57 
58     p_num_scheme_id         IN NUMBER,
59     p_num_sequence_code     IN VARCHAR2,
60     p_sequence_level        IN NUMBER,
61     p_concatenation_yn      IN VARCHAR2,
62     p_end_character         IN VARCHAR2,
63 
64 
65 
66     p_object_version_number IN NUMBER
67     );
68 
69   PROCEDURE Delete_Number_Scheme_Dtl(
70     p_api_version                  IN NUMBER,
71     p_init_msg_list                IN VARCHAR2 ,
72     p_commit                       IN VARCHAR2 := FND_API.G_FALSE,
73 
74     x_return_status                OUT NOCOPY VARCHAR2,
75     x_msg_count                    OUT NOCOPY NUMBER,
76     x_msg_data                     OUT NOCOPY VARCHAR2,
77 
78     p_num_scheme_id         IN NUMBER,
79     p_num_sequence_code     IN VARCHAR2,
80     p_sequence_level        IN NUMBER,
81 
82     p_object_version_number IN NUMBER
83     );
84 
85   PROCEDURE Validate_Number_Scheme_Dtl(
86     p_api_version                  IN NUMBER,
87     p_init_msg_list                IN VARCHAR2 ,
88     p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89 
90     x_return_status                OUT NOCOPY VARCHAR2,
91     x_msg_count                    OUT NOCOPY NUMBER,
92     x_msg_data                     OUT NOCOPY VARCHAR2,
93 
94     p_num_scheme_id         IN NUMBER,
95     p_num_sequence_code     IN VARCHAR2,
96     p_sequence_level        IN NUMBER,
97     p_concatenation_yn      IN VARCHAR2,
98     p_end_character         IN VARCHAR2,
99 
100 
101 
102     p_object_version_number IN NUMBER
103     );
104 
105 END OKC_NUMBER_SCHEME_DTL_GRP;