[Home] [Help]
PACKAGE: APPS.OKC_INST_CND_PUB
Source
1 PACKAGE OKC_INST_CND_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPINCS.pls 120.0 2005/05/25 22:42:55 appldev noship $ */
3
4 /*********************** HAND-CODED ***************************************/
5 ----------------------------------------------------------------------------
6 -- GLOBAL DATASTRUCTURES
7 ----------------------------------------------------------------------------
8
9 SUBTYPE cnhv_rec_type IS OKC_CONDITIONS_PUB.cnhv_rec_type;
10 SUBTYPE cnhv_tbl_type IS OKC_CONDITIONS_PUB.cnhv_tbl_type;
11 SUBTYPE cnlv_rec_type IS OKC_CONDITIONS_PUB.cnlv_rec_type;
12 SUBTYPE cnlv_tbl_type IS OKC_CONDITIONS_PUB.cnlv_tbl_type;
13 SUBTYPE coev_rec_type IS OKC_CONDITIONS_PUB.coev_rec_type;
14 SUBTYPE coev_tbl_type IS OKC_CONDITIONS_PUB.coev_tbl_type;
15 SUBTYPE aavv_rec_type IS OKC_CONDITIONS_PUB.aavv_rec_type;
16 SUBTYPE aavv_tbl_type IS OKC_CONDITIONS_PUB.aavv_tbl_type;
17 SUBTYPE aalv_rec_type IS OKC_CONDITIONS_PUB.aalv_rec_type;
18 SUBTYPE aalv_tbl_type IS OKC_CONDITIONS_PUB.aalv_tbl_type;
19 SUBTYPE fepv_rec_type IS OKC_CONDITIONS_PUB.fepv_rec_type;
20 SUBTYPE fepv_tbl_type IS OKC_CONDITIONS_PUB.fepv_tbl_type;
21 SUBTYPE ocev_rec_type IS OKC_OUTCOME_PUB.ocev_rec_type;
22 SUBTYPE ocev_tbl_type IS OKC_OUTCOME_PUB.ocev_tbl_type;
23 SUBTYPE oatv_rec_type IS OKC_OUTCOME_PUB.oatv_rec_type;
24 SUBTYPE oatv_tbl_type IS OKC_OUTCOME_PUB.oatv_tbl_type;
25 SUBTYPE instcnd_inp_rec IS OKC_INST_CND_PVT.instcnd_inp_rec;
26
27 ----------------------------------------------------------------------------
28 -- GLOBAL CONSTANTS
29 ----------------------------------------------------------------------------
30 g_pkg_name CONSTANT varchar2(100) := 'OKC_INST_CND_PUB';
31 g_app_name CONSTANT varchar2(100) := OKC_API.G_APP_NAME;
32
33 ----------------------------------------------------------------------------
34 -- GLOBAL EXCEPTION
35 ----------------------------------------------------------------------------
36 g_exception_halt_validation EXCEPTION;
37
38 ----------------------------------------------------------------------------
39 -- GLOBAL MESSAGE CONSTANTS
40 ----------------------------------------------------------------------------
41 g_fnd_app CONSTANT varchar2(200) := OKC_API.G_FND_APP;
42 g_form_unable_to_reserve_rec CONSTANT varchar2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43 g_form_record_deleted CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_DELETED;
44 g_form_record_changed CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45 g_record_logically_deleted CONSTANT varchar2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46 g_required_value CONSTANT varchar2(200) := OKC_API.G_REQUIRED_VALUE;
47 g_invalid_value CONSTANT varchar2(200) := OKC_API.G_INVALID_VALUE;
48 g_col_name_token CONSTANT varchar2(200) := OKC_API.G_COL_NAME_TOKEN;
49 g_parent_table_token CONSTANT varchar2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50 g_child_table_token CONSTANT varchar2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51 g_unexpected_error CONSTANT varchar2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
52 g_sqlerrm_token CONSTANT varchar2(200) := 'SQLerrm';
53 g_sqlcode_token CONSTANT varchar2(200) := 'SQLcode';
54 g_uppercase_required CONSTANT varchar2(200) := 'OKC_UPPER_CASE_REQUIRED';
55
56 ----------------------------------------------------------------------------
57 -- PROCEDURE inst_condition
58 ----------------------------------------------------------------------------
59 PROCEDURE inst_condition(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_instcnd_inp_rec IN INSTCND_INP_REC);
66 END OKC_INST_CND_PUB;