APPS.IEC_CRITERIA_UTIL_PVT dependencies on DBMS_SQL

Line 13: -- as DBMS_SQL.VARCHAR2S can be executed via DBMS_SQL.

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

Line 18: -- x_criteria_sql IN OUT DBMS_SQL.VARCHAR2S Required

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: --

Line 30: , x_criteria_sql IN OUT NOCOPY DBMS_SQL.VARCHAR2S

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: -----------------------------++++++-------------------------------

Line 43: -- as DBMS_SQL.VARCHAR2S can be executed via DBMS_SQL.

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

Line 48: -- x_criteria_sql IN OUT DBMS_SQL.VARCHAR2S Required

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: --

Line 60: , x_criteria_sql IN OUT NOCOPY DBMS_SQL.VARCHAR2S

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;