[Home] [Help]
PACKAGE: APPS.OKC_NUMBER_SCHEME_GRP
Source
1 PACKAGE OKC_NUMBER_SCHEME_GRP AUTHID CURRENT_USER AS
2 /* $Header: OKCGNSMS.pls 120.2 2005/10/04 15:26:27 ausmani noship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7 PROCEDURE generate_preview(
8 p_api_version IN NUMBER,
9 p_init_msg_list IN VARCHAR2 ,
10
11 x_return_status OUT NOCOPY VARCHAR2,
12 x_msg_count OUT NOCOPY NUMBER,
13 x_msg_data OUT NOCOPY VARCHAR2,
14 x_out_string OUT NOCOPY VARCHAR2,
15 p_update_db IN VARCHAR2 := FND_API.G_FALSE,
16
17 p_num_scheme_id IN NUMBER
18 );
19
20 PROCEDURE apply_numbering_scheme(
21 p_api_version IN NUMBER,
22 p_init_msg_list IN VARCHAR2 ,
23
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER,
26 x_msg_data OUT NOCOPY VARCHAR2,
27 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
28 p_validation_string IN VARCHAR2,
29 p_commit IN VARCHAR2 := FND_API.G_FALSE,
30 p_doc_type IN VARCHAR2,
31 p_doc_id IN NUMBER,
32 p_num_scheme_id IN NUMBER
33 );
34
35 FUNCTION Ok_To_Delete(
36 p_num_scheme_id IN NUMBER
37 ) RETURN VARCHAR2;
38
39 PROCEDURE apply_num_scheme_4_Review(
40 p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 ,
42
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
47 p_validation_string IN VARCHAR2,
48 p_commit IN VARCHAR2 := FND_API.G_FALSE,
49 p_doc_type IN VARCHAR2,
50 p_doc_id IN NUMBER,
51 p_num_scheme_id IN NUMBER
52 );
53 FUNCTION GETALPHABET(seq_number number,type varchar2) return varchar2;
54 END OKC_NUMBER_SCHEME_GRP;