[Home] [Help]
PACKAGE: APPS.OKC_CONDITION_EVAL_PUB
Source
1 package okc_condition_eval_pub AUTHID CURRENT_USER as
2 /* $Header: OKCPCEVS.pls 120.0 2005/05/25 18:43:31 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 subtype id_tab_type is okc_condition_eval_pvt.id_tab_type;
25 subtype exec_tab_type is okc_condition_eval_pvt.exec_tab_type;
26 subtype outcome_tab_type is okc_condition_eval_pvt.outcome_tab_type;
27
28 ----------------------------------------------------------------------------------
29 -- Global Variables
30 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONDITION_EVAL_PUB';
31 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
32 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
33 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
34 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
35 ----------------------------------------------------------------------------------
36 --Global Exception
37 ----------------------------------------------------------------------------------
38 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
39 ----------------------------------------------------------------------------------
40 -- GLOBAL DATASTRUCTURES
41 ----------------------------------------------------------------------------------
42 -- TYPES
43 -----------------------------------------------------------------------------------
44
45 -- Bug 2217934 This procedure evaluates condition attached to a plan
46 -- Input is condition id p_cnh_id and p_msg_tab.
47 -- Output is x_sync_outcome_tab containing the table of outcomes.
48 PROCEDURE evaluate_plan_condition (
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_cnh_id IN okc_condition_headers_b.id%TYPE,
55 p_msg_tab IN okc_aq_pvt.msg_tab_typ,
56 x_sync_outcome_tab OUT NOCOPY okc_condition_eval_pub.outcome_tab_type
57 );
58
59 -- this procedure is overloaded to handle sync and async events. For sync events
60 -- an out parameter of table type 'x_outcome_tab' is returned to the calling API
61 PROCEDURE evaluate_condition (
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_acn_id IN okc_actions_b.id%TYPE,
68 p_msg_tab IN okc_aq_pvt.msg_tab_typ,
69 x_sync_outcome_tab OUT NOCOPY okc_condition_eval_pub.outcome_tab_type
70 );
71
72
73
74 PROCEDURE evaluate_condition (
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_acn_id IN okc_actions_b.id%TYPE,
81 p_msg_tab IN okc_aq_pvt.msg_tab_typ
82 );
83
84 PROCEDURE evaluate_date_condition (
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_cnh_id IN okc_condition_headers_b.id%TYPE,
91 p_msg_tab IN okc_aq_pvt.msg_tab_typ
92 );
93
94 END okc_condition_eval_pub;