1 PACKAGE okl_xcr_pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPXCRS.pls 115.6 2002/04/02 16:41:36 pkm ship $ */
3
4 SUBTYPE xcrv_rec_type IS Okl_Extrn_Pvt.xcrv_rec_type;
5 SUBTYPE xcrv_tbl_type IS Okl_Extrn_Pvt.xcrv_tbl_type;
6
7 SUBTYPE xcav_rec_type IS Okl_Extrn_Pvt.xcav_rec_type;
8 SUBTYPE xcav_tbl_type IS Okl_Extrn_Pvt.xcav_tbl_type;
9
10 ------------------------------------------------------------------------------
11 -- Global Variables
12 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_EXTRN_PUB';
13 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
14 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
15 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
16 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
17 ------------------------------------------------------------------------------
18 --Global Exception
19 ------------------------------------------------------------------------------
20 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
21 ------------------------------------------------------------------------------
22
23
24 PROCEDURE ADD_LANGUAGE;
25
26 --Object type procedure for insert
27 PROCEDURE create_ext_ar_txns(
28 p_api_version IN NUMBER
29 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
30 ,x_return_status OUT NOCOPY VARCHAR2
31 ,x_msg_count OUT NOCOPY NUMBER
32 ,x_msg_data OUT NOCOPY VARCHAR2
33 ,p_xcrv_rec IN xcrv_rec_type
34 ,p_xcav_tbl IN xcav_tbl_type
35 ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
36 ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
37 );
38
39 --Object type procedure for update
40 PROCEDURE update_ext_ar_txns(
41 p_api_version IN NUMBER
42 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
43 ,x_return_status OUT NOCOPY VARCHAR2
44 ,x_msg_count OUT NOCOPY NUMBER
45 ,x_msg_data OUT NOCOPY VARCHAR2
46 ,p_xcrv_rec IN xcrv_rec_type
47 ,p_xcav_tbl IN xcav_tbl_type
48 ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
49 ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
50 );
51
52 PROCEDURE update_ext_csh_txns(
53 p_api_version IN NUMBER
54 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
55 ,x_return_status OUT NOCOPY VARCHAR2
56 ,x_msg_count OUT NOCOPY NUMBER
57 ,x_msg_data OUT NOCOPY VARCHAR2
58 ,p_xcrv_rec IN xcrv_rec_type
59 ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
60 );
61
62 --Object type procedure for update
63 PROCEDURE delete_ext_ar_txns(
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_xcrv_rec IN xcrv_rec_type
70 ,p_xcav_tbl IN xcav_tbl_type
71 ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
72 ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
73 );
74
75 --Object type procedure for validate
76 PROCEDURE validate_ext_ar_txns(
77 p_api_version IN NUMBER
78 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
79 ,x_return_status OUT NOCOPY VARCHAR2
80 ,x_msg_count OUT NOCOPY NUMBER
81 ,x_msg_data OUT NOCOPY VARCHAR2
82 ,p_xcrv_rec IN xcrv_rec_type
83 ,p_xcav_tbl IN xcav_tbl_type
84 );
85
86 --Object type procedure for lock
87 PROCEDURE lock_ext_ar_txns(
88 p_api_version IN NUMBER
89 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
90 ,x_return_status OUT NOCOPY VARCHAR2
91 ,x_msg_count OUT NOCOPY NUMBER
92 ,x_msg_data OUT NOCOPY VARCHAR2
93 ,p_xcrv_rec IN xcrv_rec_type
94 );
95
96 --Object type procedure for lock
97 PROCEDURE lock_ext_ar_txns(
98 p_api_version IN NUMBER
99 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
100 ,x_return_status OUT NOCOPY VARCHAR2
101 ,x_msg_count OUT NOCOPY NUMBER
102 ,x_msg_data OUT NOCOPY VARCHAR2
103 ,p_xcrv_tbl IN xcrv_tbl_type
104 );
105
106 --Object type procedure for lock
107 PROCEDURE lock_ext_ar_txns(
108 p_api_version IN NUMBER
109 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
110 ,x_return_status OUT NOCOPY VARCHAR2
111 ,x_msg_count OUT NOCOPY NUMBER
112 ,x_msg_data OUT NOCOPY VARCHAR2
113 ,p_xcav_rec IN xcav_rec_type
114 );
115
116 --Object type procedure for lock
117 PROCEDURE lock_ext_ar_txns(
118 p_api_version IN NUMBER
119 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
120 ,x_return_status OUT NOCOPY VARCHAR2
121 ,x_msg_count OUT NOCOPY NUMBER
122 ,x_msg_data OUT NOCOPY VARCHAR2
123 ,p_xcav_tbl IN xcav_tbl_type
124 );
125
126 END Okl_Xcr_Pub;