1 PACKAGE JTF_BRM_UTILITY_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvbuts.pls 115.8 2002/02/14 13:18:32 pkm ship $ */
3
4 FUNCTION Attribute_Format
5 /************************************************************
6 ** This function is used in the JTF_BRM_ATTR_VALUES_V view
7 ** to retriev and format the workflow attribute value so
8 ** it can be queried as a text item in the JTFBRWKB form
9 ************************************************************/
10 ( p_attribute_type IN VARCHAR2
11 , p_text_value IN VARCHAR2
12 , p_number_value IN NUMBER
13 , p_date_value IN DATE
14 , p_format IN VARCHAR2
15 )RETURN VARCHAR2;
16
17 FUNCTION Attribute_Code
18 /************************************************************
19 ** - If an attribute lookup value is specified for the rule
20 ** the LOOKUP_CODE will be returned.
21 ** - If no attribute lookup value is specified for the rule
22 ** the default value will be returned
23 ************************************************************/
24 (p_rule_id IN VARCHAR2
25 ,p_wf_item_type IN VARCHAR2
26 ,p_wf_process_name IN VARCHAR2
27 ,p_wf_attribute_name IN VARCHAR2
28 )RETURN VARCHAR2;
29
30 FUNCTION Attribute_Meaning
31 /************************************************************
32 ** - If an attribute lookup value is specified for the rule
33 ** the Meaning will be returned.
34 ** - If no attribute lookup value is specified for the rule
35 ** the default value will be returned
36 ************************************************************/
37 (p_rule_id IN VARCHAR2
38 ,p_wf_item_type IN VARCHAR2
39 ,p_wf_process_name IN VARCHAR2
40 ,p_wf_attribute_name IN VARCHAR2
41 )RETURN VARCHAR2;
42
43 END JTF_BRM_UTILITY_PVT;