1 PACKAGE okl_process_tmplts_pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPPTMS.pls 115.6 2002/07/18 18:39:24 rvaduri noship $ */
3
4 subtype PTMv_rec_type is okl_PTM_pvt.PTMv_rec_type;
5 subtype PTMv_tbl_type is okl_PTM_pvt.PTMv_tbl_type;
6 ------------------------------------------------------------------------------
7 -- Global Variables
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PROCESS_TMPLTS_PUB';
9 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
13 ------------------------------------------------------------------------------
14 --Global Exception
15 ------------------------------------------------------------------------------
16 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
17 ------------------------------------------------------------------------------
18
19
20 PROCEDURE insert_PROCESS_TMPLTS(
21 p_api_version IN NUMBER
22 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
23 ,x_return_status OUT NOCOPY VARCHAR2
24 ,x_msg_count OUT NOCOPY NUMBER
25 ,x_msg_data OUT NOCOPY VARCHAR2
26 ,p_PTMv_tbl IN PTMv_tbl_type
27 ,x_PTMv_tbl OUT NOCOPY PTMv_tbl_type);
28
29 PROCEDURE insert_PROCESS_TMPLTS(
30 p_api_version IN NUMBER
31 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
32 ,x_return_status OUT NOCOPY VARCHAR2
33 ,x_msg_count OUT NOCOPY NUMBER
34 ,x_msg_data OUT NOCOPY VARCHAR2
35 ,p_PTMv_rec IN PTMv_rec_type
36 ,x_PTMv_rec OUT NOCOPY PTMv_rec_type);
37
38 PROCEDURE lock_PROCESS_TMPLTS(
39 p_api_version IN NUMBER
40 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_msg_count OUT NOCOPY NUMBER
43 ,x_msg_data OUT NOCOPY VARCHAR2
44 ,p_PTMv_tbl IN PTMv_tbl_type);
45
46 PROCEDURE lock_PROCESS_TMPLTS(
47 p_api_version IN NUMBER
48 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2
52 ,p_PTMv_rec IN PTMv_rec_type);
53
54 PROCEDURE update_PROCESS_TMPLTS(
55 p_api_version IN NUMBER
56 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_msg_count OUT NOCOPY NUMBER
59 ,x_msg_data OUT NOCOPY VARCHAR2
60 ,p_PTMv_tbl IN PTMv_tbl_type
61 ,x_PTMv_tbl OUT NOCOPY PTMv_tbl_type);
62
63 PROCEDURE update_PROCESS_TMPLTS(
64 p_api_version IN NUMBER
65 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
66 ,x_return_status OUT NOCOPY VARCHAR2
67 ,x_msg_count OUT NOCOPY NUMBER
68 ,x_msg_data OUT NOCOPY VARCHAR2
69 ,p_PTMv_rec IN PTMv_rec_type
70 ,x_PTMv_rec OUT NOCOPY PTMv_rec_type);
71
72 PROCEDURE delete_PROCESS_TMPLTS(
73 p_api_version IN NUMBER
74 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
75 ,x_return_status OUT NOCOPY VARCHAR2
76 ,x_msg_count OUT NOCOPY NUMBER
77 ,x_msg_data OUT NOCOPY VARCHAR2
78 ,p_PTMv_tbl IN PTMv_tbl_type);
79
80 PROCEDURE delete_PROCESS_TMPLTS(
81 p_api_version IN NUMBER
82 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
83 ,x_return_status OUT NOCOPY VARCHAR2
84 ,x_msg_count OUT NOCOPY NUMBER
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 ,p_PTMv_rec IN PTMv_rec_type);
87
88 PROCEDURE validate_PROCESS_TMPLTS(
89 p_api_version IN NUMBER
90 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
91 ,x_return_status OUT NOCOPY VARCHAR2
92 ,x_msg_count OUT NOCOPY NUMBER
93 ,x_msg_data OUT NOCOPY VARCHAR2
94 ,p_PTMv_tbl IN PTMv_tbl_type);
95
96 PROCEDURE validate_PROCESS_TMPLTS(
97 p_api_version IN NUMBER
98 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
99 ,x_return_status OUT NOCOPY VARCHAR2
100 ,x_msg_count OUT NOCOPY NUMBER
101 ,x_msg_data OUT NOCOPY VARCHAR2
102 ,p_PTMv_rec IN PTMv_rec_type);
103
104 END okl_process_tmplts_pub;
105