1 PACKAGE HZ_WORD_CONDITIONS_PKG AUTHID CURRENT_USER as
2 /*$Header: ARHDQWCS.pls 120.3 2005/10/30 04:19:34 appldev noship $ */
3 TYPE vlisttype IS TABLE of VARCHAR2(255) INDEX BY BINARY_INTEGER ;
4 gbl_condition_rec vlisttype ;
5
6 /*** This will assume that any comparison that we perform on the attributes, will be on the basis
7 of the value returned by get_gbl_condition_rec_value
8 ****/
9 FUNCTION tca_eval_condition_rec(
10 p_input_str IN VARCHAR2,
11 p_token_str IN VARCHAR2,
12 p_repl_str IN VARCHAR2,
13 p_condition_id IN NUMBER,
14 p_user_spec_cond_val IN VARCHAR2
15 )
16 RETURN VARCHAR2 ;
17
18 /*** This will be used to determine if this attribute is a condition attribute ***/
19 FUNCTION is_a_cond_attrib (p_attribute_id IN NUMBER )
20 RETURN BOOLEAN ;
21
22
23 /*** This will be used by search/staging to populate the global condition record ***/
24 PROCEDURE set_gbl_condition_rec (p_attribute_id IN NUMBER, p_attribute_value IN VARCHAR2) ;
25
26 /*** This will be used to return the value of condition record *****/
27 FUNCTION get_gbl_condition_rec_value( p_entity IN VARCHAR2, p_attribute_name IN VARCHAR2 )
28 RETURN VARCHAR2 ;
29
30 /********* This will be a wrapper on top of the condition function, that would be used by
31 HZ_TRANS_PKG, so that the user does not have to modify word_replace directly.
32 A user who wants to seed a new condition function would write code here.
33 *****************/
34
35 FUNCTION evaluate_condition (
36 p_input_str IN VARCHAR2,
37 p_token_str IN VARCHAR2,
38 p_repl_str IN VARCHAR2,
39 p_condition_id IN NUMBER,
40 p_user_spec_cond_val IN VARCHAR2
41 )
42 RETURN BOOLEAN ;
43
44
45 END; -- Package Specification HZ_WORD_CONDITIONS_PKG
46
|
|
|