PACKAGE: APPS.OKC_XPRT_RULES_ENGINE_PVT

Source

1 PACKAGE OKC_XPRT_RULES_ENGINE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVXRULENGS.pls 120.1.12020000.2 2012/08/21 14:04:38 nbingi noship $ */
3 
4 p_doc_id NUMBER;
5 p_doc_type VARCHAR2(40);
6 p_template_id NUMBER;
7 questions_display_changed VARCHAR2(1);
8 
9 TYPE result_rec_type IS RECORD (
10   rule_id         NUMBER,
11   condition_id    NUMBER,
12   result	  VARCHAR2(30) );
13 TYPE result_tbl_type IS TABLE OF result_rec_type INDEX BY BINARY_INTEGER;
14 
15 TYPE varchar2_4000 IS TABLE OF VARCHAR2(4000);
16 lhs_values_tbl varchar2_4000;
17 rhs_values_tbl varchar2_4000;
18 
19 TYPE number_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
20 
21 PROCEDURE init_contract_expert(doc_id IN NUMBER, doc_type IN VARCHAR2, template_id IN NUMBER, x_has_questions OUT NOCOPY VARCHAR2);
22 PROCEDURE populate_rule_cond_eval_table;
23 PROCEDURE populate_doc_var_values;
24 PROCEDURE populate_doc_questions;
25 PROCEDURE populate_rule_cond_dep;
26 PROCEDURE evaluate_rules_and_conditions;
27 FUNCTION evaluate_condition(p_cond_id NUMBER, p_cond_type VARCHAR2, p_object_code VARCHAR2, p_object_value_type VARCHAR2, p_object_value_code VARCHAR2, p_operator VARCHAR2) RETURN BOOLEAN;
28 PROCEDURE reevaluate_rules(reeval_rules OKC_TBL_NUMBER);
29 FUNCTION evaluate_user_response(doc_id NUMBER, doc_type VARCHAR2, template_id NUMBER, p_question_id VARCHAR2, p_response VARCHAR2) RETURN VARCHAR2;
30 PROCEDURE save_responses(doc_id IN NUMBER, doc_type IN VARCHAR2, p_lock_xprt_yn IN VARCHAR2, x_return_status OUT NOCOPY VARCHAR2);
31 FUNCTION getTemplateId RETURN NUMBER;
32 FUNCTION getDocId RETURN NUMBER;
33 FUNCTION getDocType RETURN VARCHAR2;
34 FUNCTION has_all_questions_answered(doc_id NUMBER, doc_type VARCHAR2) RETURN VARCHAR2;
35 PROCEDURE create_xprt_responses_version(doc_id IN NUMBER, doc_type IN VARCHAR2, p_major_version IN NUMBER);
36 PROCEDURE restore_xprt_responses_version(doc_id IN NUMBER, doc_type IN VARCHAR2, p_major_version IN NUMBER);
37 PROCEDURE delete_xprt_responses_version(doc_id IN NUMBER, doc_type IN VARCHAR2, p_major_version IN NUMBER);
38 
39 END OKC_XPRT_RULES_ENGINE_PVT;