[Home] [Help]
PACKAGE: APPS.OKC_INST_CND_PVT
Source
1 PACKAGE OKC_INST_CND_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCRINCS.pls 120.0 2005/05/25 18:39:17 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 ----------------------------------------------------------------------------
26 -- RECORD TYPE DECLARATION
27 ----------------------------------------------------------------------------
28 TYPE INSTCND_INP_REC IS RECORD
29 ( chr_id NUMBER,
30 cle_id NUMBER,
31 inv_item_id NUMBER,
32 jtot_object_code OKC_CONDITION_HEADERS_B.JTOT_OBJECT_CODE%TYPE,
33 tmp_ctr_grp_id NUMBER,
34 ins_ctr_grp_id NUMBER
35 );
36
37 ----------------------------------------------------------------------------
38 -- GLOBAL CONSTANTS
39 ----------------------------------------------------------------------------
40 g_pkg_name CONSTANT varchar2(100) := 'OKC_INST_CND_PVT';
41 g_app_name CONSTANT varchar2(3) := OKC_API.G_APP_NAME;
42 g_unexpected_error CONSTANT varchar2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
43 g_sqlerrm_token CONSTANT varchar2(200) := 'SQLerrm';
44 g_sqlcode_token CONSTANT varchar2(200) := 'SQLcode';
45
46 ----------------------------------------------------------------------------
47 -- GLOBAL EXCEPTION
48 ----------------------------------------------------------------------------
49 g_exception_halt_validation EXCEPTION;
50
51
52 ----------------------------------------------------------------------------
53 -- PROCEDURE inst_condition
54 ----------------------------------------------------------------------------
55 PROCEDURE inst_condition(
56 p_api_version IN NUMBER,
57 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 p_instcnd_inp_rec IN INSTCND_INP_REC);
62
63 END OKC_INST_CND_PVT;