DBA Data[Home] [Help]

PACKAGE: APPS.OKL_SETUPOPERANDS_PUB

Source


1 PACKAGE OKL_SETUPOPERANDS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPSOPS.pls 115.1 2002/02/06 20:29:59 pkm ship       $ */
3 
4   ---------------------------------------------------------------------------
5   -- GLOBAL VARIABLES
6   ---------------------------------------------------------------------------
7   G_UNEXPECTED_ERROR          CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8   G_SQLERRM_TOKEN             CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
9   G_SQLCODE_TOKEN             CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
10 
11   G_APP_NAME				  CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
12   G_PKG_NAME                  CONSTANT VARCHAR2(30)  := 'OKL_SETUPOPERANDS_PUB';
13 
14   SUBTYPE opdv_rec_type IS okl_setupoperands_pvt.opdv_rec_type;
15   SUBTYPE opdv_tbl_type IS okl_setupoperands_pvt.opdv_tbl_type;
16 
17   PROCEDURE get_rec(
18   	p_opdv_rec					   IN opdv_rec_type,
19 	x_return_status				   OUT NOCOPY VARCHAR2,
20 	x_msg_data					   OUT NOCOPY VARCHAR2,
21     x_no_data_found                OUT NOCOPY BOOLEAN,
22 	x_opdv_rec					   OUT NOCOPY opdv_rec_type);
23 
24   PROCEDURE insert_operands(
25     p_api_version                  IN  NUMBER,
26     p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
27     x_return_status                OUT NOCOPY VARCHAR2,
28     x_msg_count                    OUT NOCOPY NUMBER,
29     x_msg_data                     OUT NOCOPY VARCHAR2,
30     p_opdv_rec                     IN  opdv_rec_type,
31     x_opdv_rec                     OUT NOCOPY opdv_rec_type);
32 
33   PROCEDURE update_operands(
34     p_api_version                  IN  NUMBER,
35     p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
36     x_return_status                OUT NOCOPY VARCHAR2,
37     x_msg_count                    OUT NOCOPY NUMBER,
38     x_msg_data                     OUT NOCOPY VARCHAR2,
39     p_opdv_rec                     IN  opdv_rec_type,
40     x_opdv_rec                     OUT NOCOPY opdv_rec_type);
41 
42 END OKL_SETUPOPERANDS_PUB;