1 PACKAGE IEC_CRITERIA_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: IECCRUTS.pls 115.1 2003/08/22 20:41:23 hhuang noship $ */
3
4 -----------------------------++++++-------------------------------
5 --
6 -- Start of comments
7 --
8 -- API name : Append_SubsetCriteriaClause
9 -- Type : Private
10 -- Pre-reqs : None
11 -- Function : Append a SQL representation of the subset criteria
12 -- to a collection of VARCHAR2S. This query, represented
13 -- as DBMS_SQL.VARCHAR2S can be executed via DBMS_SQL.
14 --
15 -- Parameters : p_source_id IN NUMBER Required
16 -- p_record_filter_id IN NUMBER Required
17 -- p_source_type_view IN VARCHAR2 Required
18 -- x_criteria_sql IN OUT DBMS_SQL.VARCHAR2S Required
19 -- x_return_code OUT VARCHAR2 Required
20 --
21 -- Version : Initial version 1.0
22 --
23 -- End of comments
24 --
25 -----------------------------++++++-------------------------------
26 PROCEDURE Append_SubsetCriteriaClause
27 ( p_source_id IN NUMBER
28 , p_subset_id IN NUMBER
29 , p_source_type_view IN VARCHAR2
30 , x_criteria_sql IN OUT NOCOPY DBMS_SQL.VARCHAR2S
31 , x_return_code OUT NOCOPY VARCHAR2
32 );
33
34 -----------------------------++++++-------------------------------
35 --
36 -- Start of comments
37 --
38 -- API name : Append_RecFilterCriteriaClause
39 -- Type : Private
40 -- Pre-reqs : None
41 -- Function : Append a SQL representation of the record filter criteria
42 -- to a collection of VARCHAR2s. This query, represented
43 -- as DBMS_SQL.VARCHAR2S can be executed via DBMS_SQL.
44 --
45 -- Parameters : p_source_id IN NUMBER Required
46 -- p_record_filter_id IN NUMBER Required
47 -- p_source_type_view IN VARCHAR2 Required
48 -- x_criteria_sql IN OUT DBMS_SQL.VARCHAR2S Required
49 -- x_return_code OUT VARCHAR2 Required
50 --
51 -- Version : Initial version 1.0
52 --
53 -- End of comments
54 --
55 -----------------------------++++++-------------------------------
56 PROCEDURE Append_RecFilterCriteriaClause
57 ( p_source_id IN NUMBER
58 , p_record_filter_id IN NUMBER
59 , p_source_type_view IN VARCHAR2
60 , x_criteria_sql IN OUT NOCOPY DBMS_SQL.VARCHAR2S
61 , x_return_code OUT NOCOPY VARCHAR2
62 );
63
64 END IEC_CRITERIA_UTIL_PVT;