DBA Data[Home] [Help]

PACKAGE: APPS.OKL_AM_SHIPPING_INSTR_PVT

Source


1 PACKAGE OKL_AM_SHIPPING_INSTR_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRSHIS.pls 115.4 2002/12/20 19:21:09 gkadarka noship $ */
3   ---------------------------------------------------------------------------
4   -- GLOBAL CONSTANTS
5   ---------------------------------------------------------------------------
6   G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKL_AM_SHIPPING_INSTR_PVT';
7   G_APP_NAME             CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
8   G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
9   G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'SQLerrm';
10   G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'SQLcode';
11 
12   ---------------------------------------------------------------------------
13   -- GLOBAL EXCEPTIONS
14   ---------------------------------------------------------------------------
15   G_EXCEPTION_CANNOT_TERM_CNT EXCEPTION;
16 
17   ---------------------------------------------------------------------------
18   -- GLOBAL DATASTRUCTURES
19   ---------------------------------------------------------------------------
20 
21   SUBTYPE rasv_rec_type IS OKL_RELOCATE_ASSETS_PUB.rasv_rec_type;
22 
23   SUBTYPE rasv_tbl_type IS OKL_RELOCATE_ASSETS_PUB.rasv_tbl_type;
24   ---------------------------------------------------------------------------
25   -- Procedures and Functions
26   ---------------------------------------------------------------------------
27   PROCEDURE create_shipping_instr(
28     p_api_version                  	IN NUMBER,
29     p_init_msg_list                	IN VARCHAR2 DEFAULT OKC_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_rasv_rec                      IN rasv_rec_type,
34     x_rasv_rec                      OUT NOCOPY rasv_rec_type);
35 
36   -- terminates the quote for a input of tbl type
37   PROCEDURE create_shipping_instr(
38     p_api_version                  	IN NUMBER,
39     p_init_msg_list                	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40     x_return_status                	OUT NOCOPY VARCHAR2,
41     x_msg_count                    	OUT NOCOPY NUMBER,
42     x_msg_data                     	OUT NOCOPY VARCHAR2,
43     p_rasv_tbl                      IN rasv_tbl_type,
44     x_rasv_tbl                      OUT NOCOPY rasv_tbl_type);
45 
46   PROCEDURE update_shipping_instr(
47     p_api_version                  	IN NUMBER,
48     p_init_msg_list                	IN VARCHAR2 DEFAULT OKC_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_rasv_rec                      IN rasv_rec_type,
53     x_rasv_rec                      OUT NOCOPY rasv_rec_type);
54 
55   -- terminates the quote for a input of tbl type
56   PROCEDURE update_shipping_instr(
57     p_api_version                  	IN NUMBER,
58     p_init_msg_list                	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59     x_return_status                	OUT NOCOPY VARCHAR2,
60     x_msg_count                    	OUT NOCOPY NUMBER,
61     x_msg_data                     	OUT NOCOPY VARCHAR2,
62     p_rasv_tbl                      IN rasv_tbl_type,
63     x_rasv_tbl                      OUT NOCOPY rasv_tbl_type);
64 
65   PROCEDURE send_shipping_instr(
66     p_api_version                  	IN NUMBER,
67     p_init_msg_list                	IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
68     x_return_status                	OUT NOCOPY VARCHAR2,
69     x_msg_count                    	OUT NOCOPY NUMBER,
70     x_msg_data                     	OUT NOCOPY VARCHAR2,
71     p_rasv_rec                      IN rasv_rec_type,
72     x_rasv_rec                      OUT NOCOPY rasv_rec_type);
73 
74   PROCEDURE send_shipping_instr(
75     p_api_version                  	IN NUMBER,
76     p_init_msg_list                	IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
77     x_return_status                	OUT NOCOPY VARCHAR2,
78     x_msg_count                    	OUT NOCOPY NUMBER,
79     x_msg_data                     	OUT NOCOPY VARCHAR2,
80     p_rasv_tbl                      IN rasv_tbl_type,
81     x_rasv_tbl                      OUT NOCOPY rasv_tbl_type);
82 
83 END OKL_AM_SHIPPING_INSTR_PVT;