DBA Data[Home] [Help]

PACKAGE: APPS.OKC_CONDITION_EVAL_PVT

Source


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;