1 PACKAGE WSH_ITM_QUERY_CUSTOM AUTHID CURRENT_USER AS
2 /* $Header: WSHITQCS.pls 120.0 2005/05/26 18:33:32 appldev noship $ */
3 --Record Type that can store - NUMBER, VARCHAR2 or DATE
4 -- either one at a time is permitted.
5 TYPE g_ValueRecType IS RECORD( g_number_val NUMBER,
6 g_varchar_val VARCHAR2(360),
7 g_date_val DATE,
8 g_Bind_Literal VARCHAR2(100));
9
10 --PL/SQL Table which stores the Values to be binded.
11 -- This is required to handle IN and BETWEEN Clauses
12 -- where there are multiple bind values per filter condition
13 TYPE g_ValueTableType IS Table of g_ValueRecType INDEX BY BINARY_INTEGER;
14
15
16 --g_Condn_Qry - Filter Condition
17 -- e.g: ' AND B.ORG_ID = :value3'
18 -- ' AND B.ITEM_ID <= :value4'
19 -- Depending on the type of the Value - g_number_val, g_varchar_val
20 -- or g_date_val is populated.
21 -- Appropriate value of g_Bind_Literal is used for binding.
22 --g_Value_Type - Value Type - This could be either
23 -- VARCHAR2, NUMBER or DATE
24 --Modified by AJPRABHA for 8.1 Compatibility
25 TYPE g_CondnValRecType IS RECORD (g_Condn_Qry VARCHAR2(1000),
26 g_number_val NUMBER,
27 g_varchar_val VARCHAR2(360),
28 g_date_val DATE,
29 g_Bind_Literal VARCHAR2(100),
30 g_Value_Type VARCHAR2(10));
31
32 TYPE g_CondnValTableType IS Table of g_CondnValRecType INDEX BY BINARY_INTEGER;
33
34 PROCEDURE ADD_CONDITION(p_Table IN OUT NOCOPY g_CondnValTableType,
35 p_FilerCond IN VARCHAR2,
36 p_Value IN g_ValueTableType,
37 p_Value_Type IN VARCHAR2);
38
39 PROCEDURE ADD_CONDITION(p_Table IN OUT NOCOPY g_CondnValTableType,
40 p_FilerCond IN VARCHAR2);
41
42 PROCEDURE DEL_CONDITION(p_Table IN OUT NOCOPY g_CondnValTableType,
43 p_FilerCond IN VARCHAR2);
44
45 PROCEDURE EDIT_CONDITION(p_Table IN OUT NOCOPY g_CondnValTableType,
46 p_OldFilerCond IN VARCHAR2,
47 p_NewFilerCond IN VARCHAR2,
48 p_NewValue IN g_ValueTableType,
49 p_NewValueType IN VARCHAR2);
50
51 PROCEDURE BIND_VALUES (p_Table IN g_CondnValTableType,
52 p_CursorID IN NUMBER) ;
53
54
55 END;
[Home] [Help]