[Home] [Help]
PACKAGE: APPS.OKL_AM_SHIPPING_INSTR_PUB
Source
1 PACKAGE OKL_AM_SHIPPING_INSTR_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPSHIS.pls 115.1 2002/06/20 20:53:28 rmunjulu noship $ */
3
4 SUBTYPE rasv_rec_type IS OKL_AM_SHIPPING_INSTR_PVT.rasv_rec_type;
5 SUBTYPE rasv_tbl_type IS OKL_AM_SHIPPING_INSTR_PVT.rasv_tbl_type;
6 ------------------------------------------------------------------------------
7 -- Global Variables
8 ------------------------------------------------------------------------------
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_SHIPPING_INSTR_PUB';
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
11 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
12 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
13 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
14 ------------------------------------------------------------------------------
15 --Global Exception
16 ------------------------------------------------------------------------------
17 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18 ------------------------------------------------------------------------------
19
20 PROCEDURE create_shipping_instr(
21 p_api_version IN NUMBER,
22 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rasv_rec IN rasv_rec_type,
27 x_rasv_rec OUT NOCOPY rasv_rec_type);
28
29 PROCEDURE create_shipping_instr(
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rasv_tbl IN rasv_tbl_type,
36 x_rasv_tbl OUT NOCOPY rasv_tbl_type);
37
38 PROCEDURE update_shipping_instr(
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rasv_rec IN rasv_rec_type,
45 x_rasv_rec OUT NOCOPY rasv_rec_type);
46
47 -- terminates the quote for a input of tbl type
48 PROCEDURE update_shipping_instr(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rasv_tbl IN rasv_tbl_type,
55 x_rasv_tbl OUT NOCOPY rasv_tbl_type);
56
57 PROCEDURE send_shipping_instr(
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_rasv_rec IN rasv_rec_type,
64 x_rasv_rec OUT NOCOPY rasv_rec_type);
65
66 PROCEDURE send_shipping_instr(
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 p_rasv_tbl IN rasv_tbl_type,
73 x_rasv_tbl OUT NOCOPY rasv_tbl_type);
74
75 END OKL_AM_SHIPPING_INSTR_PUB;