1 PACKAGE Okl_Rct_Pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPRCTS.pls 115.3 2002/02/05 12:08:39 pkm ship $ */
3
4 SUBTYPE rctv_rec_type IS Okl_Rct_Pvt.rctv_rec_type;
5 SUBTYPE rctv_tbl_type IS Okl_Rct_Pvt.rctv_tbl_type;
6
7 SUBTYPE rcav_rec_type IS Okl_Rca_Pvt.rcav_rec_type;
8 SUBTYPE rcav_tbl_type IS Okl_Rca_Pvt.rcav_tbl_type;
9 ------------------------------------------------------------------------------
10 -- Global Variables
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ARTRX_PUB';
12 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16 ------------------------------------------------------------------------------
17 --Global Exception
18 ------------------------------------------------------------------------------
19 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
20 ------------------------------------------------------------------------------
21
22 PROCEDURE create_internal_trans(
23 p_api_version IN NUMBER
24 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
25 ,x_return_status OUT NOCOPY VARCHAR2
26 ,x_msg_count OUT NOCOPY NUMBER
27 ,x_msg_data OUT NOCOPY VARCHAR2
28 ,p_rctv_rec IN rctv_rec_type
29 ,p_rcav_tbl IN rcav_tbl_type
30 ,x_rctv_rec OUT NOCOPY rctv_rec_type
31 ,x_rcav_tbl OUT NOCOPY rcav_tbl_type
32 );
33
34 --Object type procedure for update
35 PROCEDURE update_internal_trans(
36 p_api_version IN NUMBER
37 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
38 ,x_return_status OUT NOCOPY VARCHAR2
39 ,x_msg_count OUT NOCOPY NUMBER
40 ,x_msg_data OUT NOCOPY VARCHAR2
41 ,p_rctv_rec IN rctv_rec_type
42 ,p_rcav_tbl IN rcav_tbl_type
43 ,x_rctv_rec OUT NOCOPY rctv_rec_type
44 ,x_rcav_tbl OUT NOCOPY rcav_tbl_type
45 );
46
47 --Object type procedure for update
48 PROCEDURE delete_internal_trans(
49 p_api_version IN NUMBER
50 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2
54 ,p_rctv_rec IN rctv_rec_type
55 ,p_rcav_tbl IN rcav_tbl_type
56 ,x_rctv_rec OUT NOCOPY rctv_rec_type
57 ,x_rcav_tbl OUT NOCOPY rcav_tbl_type
58 );
59
60 --Object type procedure for validate
61 PROCEDURE validate_internal_trans(
62 p_api_version IN NUMBER
63 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
64 ,x_return_status OUT NOCOPY VARCHAR2
65 ,x_msg_count OUT NOCOPY NUMBER
66 ,x_msg_data OUT NOCOPY VARCHAR2
67 ,p_rctv_rec IN rctv_rec_type
68 ,p_rcav_tbl IN rcav_tbl_type
69 );
70
71 --Object type procedure for lock
72 PROCEDURE lock_internal_trans(
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_rctv_rec IN rctv_rec_type
79 );
80
81 --Object type procedure for lock
82 PROCEDURE lock_internal_trans(
83 p_api_version IN NUMBER
84 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
85 ,x_return_status OUT NOCOPY VARCHAR2
86 ,x_msg_count OUT NOCOPY NUMBER
87 ,x_msg_data OUT NOCOPY VARCHAR2
88 ,p_rctv_tbl IN rctv_tbl_type
89 );
90
91 --Object type procedure for lock
92 PROCEDURE lock_internal_trans(
93 p_api_version IN NUMBER
94 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
95 ,x_return_status OUT NOCOPY VARCHAR2
96 ,x_msg_count OUT NOCOPY NUMBER
97 ,x_msg_data OUT NOCOPY VARCHAR2
98 ,p_rcav_rec IN rcav_rec_type
99 );
100
101 --Object type procedure for lock
102 PROCEDURE lock_internal_trans(
103 p_api_version IN NUMBER
104 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
105 ,x_return_status OUT NOCOPY VARCHAR2
106 ,x_msg_count OUT NOCOPY NUMBER
107 ,x_msg_data OUT NOCOPY VARCHAR2
108 ,p_rcav_tbl IN rcav_tbl_type
109 );
110
111 END Okl_Rct_Pub;