1 package okc_condition_eval_pvt AUTHID CURRENT_USER as
2 /* $Header: OKCRCEVS.pls 120.0 2005/05/26 09:35:53 appldev noship $ */
3
4 subtype cnhv_rec_type is okc_cnh_pvt.cnhv_rec_type;
5 subtype cnhv_tbl_type is okc_cnh_pvt.cnhv_tbl_type;
6 subtype cnlv_rec_type is okc_cnl_pvt.cnlv_rec_type;
7 subtype cnlv_tbl_type is okc_cnl_pvt.cnlv_tbl_type;
8 subtype coev_rec_type is okc_coe_pvt.coev_rec_type;
9 subtype coev_tbl_type is okc_coe_pvt.coev_tbl_type;
10 subtype acnv_rec_type is okc_acn_pvt.acnv_rec_type;
11 subtype acnv_tbl_type is okc_acn_pvt.acnv_tbl_type;
12 subtype aaev_rec_type is okc_aae_pvt.aaev_rec_type;
13 subtype aaev_tbl_type is okc_aae_pvt.aaev_tbl_type;
14 subtype aavv_rec_type is okc_aav_pvt.aavv_rec_type;
15 subtype aavv_tbl_type is okc_aav_pvt.aavv_tbl_type;
16 subtype aalv_rec_type is okc_aal_pvt.aalv_rec_type;
17 subtype aalv_tbl_type is okc_aal_pvt.aalv_tbl_type;
18 subtype fepv_rec_type is okc_fep_pvt.fepv_rec_type;
19 subtype fepv_tbl_type is okc_fep_pvt.fepv_tbl_type;
20 subtype pdfv_rec_type is okc_pdf_pvt.pdfv_rec_type;
21 subtype pdfv_tbl_type is okc_pdf_pvt.pdfv_tbl_type;
22 subtype pdpv_rec_type is okc_pdp_pvt.pdpv_rec_type;
23 subtype pdpv_tbl_type is okc_pdp_pvt.pdpv_tbl_type;
24
25 ----------------------------------------------------------------------------------
26 -- Global Variables
27 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONDITION_EVAL_PVT';
28 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
29 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
30 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
31 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
32 ----------------------------------------------------------------------------------
33 --Global Exception
34 ----------------------------------------------------------------------------------
35 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
36 ----------------------------------------------------------------------------------
37 -- GLOBAL DATASTRUCTURES
38 ----------------------------------------------------------------------------------
39 -- TYPES
40 -- declaring record type
41 TYPE id_rec_type IS RECORD (
42 v_id NUMBER
43 );
44 TYPE exec_rec_type IS RECORD (
45 name VARCHAR2(500)
46 );
47 TYPE outcome_rec_type IS RECORD (
48 type okc_process_defs_b.pdf_type%TYPE,
49 name VARCHAR2(32000)
50 );
51 -- declaring table of record type
52 TYPE id_tab_type IS TABLE OF id_rec_type;
53 TYPE exec_tab_type IS TABLE OF exec_rec_type;
54 TYPE outcome_tab_type IS TABLE OF outcome_rec_type;
55 -----------------------------------------------------------------------------------
56 -- This procedure is overloaded to handle synch and asynch events.
57 -- For synch events there is out parameter which returns
58 -- a table of outcomes to calling program. For date based actions
59 -- the evaluator accepts condition header id.
60
61 -- Evaluate single plan
62 PROCEDURE evaluate_plan_condition(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_cnh_id IN okc_condition_headers_b.id%TYPE,
69 p_msg_tab IN okc_aq_pvt.msg_tab_typ,
70 x_sync_outcome_tab OUT NOCOPY okc_condition_eval_pvt.outcome_tab_type
71 );
72
73
74 -- Evaluator for asynchronous actions
75 PROCEDURE evaluate_condition(
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 p_acn_id IN okc_actions_b.id%TYPE,
82 p_msg_tab IN okc_aq_pvt.msg_tab_typ,
83 x_sync_outcome_tab OUT NOCOPY okc_condition_eval_pvt.outcome_tab_type
84 );
85
86 -- Evaluator for standard and counter actions
87 PROCEDURE evaluate_condition(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_acn_id IN okc_actions_b.id%TYPE,
94 p_msg_tab IN okc_aq_pvt.msg_tab_typ
95 );
96
97 -- Evaluator for date based actions
98 PROCEDURE evaluate_date_condition(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_cnh_id IN okc_condition_headers_b.id%TYPE,
105 p_msg_tab IN okc_aq_pvt.msg_tab_typ
106 );
107
108
109 END okc_condition_eval_pvt;