APPS.IEC_CRITERIA_UTIL_PVT dependencies on DBMS_SQL

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

181: -- Pre-reqs : None
182: -- Function : Parse the ruleCriteriaCollection to create a string
183: -- representation of the criteria (SQL) that will be
184: -- appended to x_criteria_strings. This query, represented
185: -- as DBMS_SQL.VARCHAR2S can be executed via DBMS_SQL.
186: --
187: -- Parameters : p_source_id IN NUMBER Required
188: -- p_criteria_collection IN ruleCriteriaCollection Required
189: -- x_criteria_strings IN OUT DBMS_SQL.VARCHAR2S Required

Line 189: -- x_criteria_strings IN OUT DBMS_SQL.VARCHAR2S Required

185: -- as DBMS_SQL.VARCHAR2S can be executed via DBMS_SQL.
186: --
187: -- Parameters : p_source_id IN NUMBER Required
188: -- p_criteria_collection IN ruleCriteriaCollection Required
189: -- x_criteria_strings IN OUT DBMS_SQL.VARCHAR2S Required
190: -- x_return_code OUT VARCHAR2 Required
191: --
192: -- Version : Initial version 1.0
193: --

Line 200: , x_criteria_strings IN OUT NOCOPY DBMS_SQL.VARCHAR2S

196: -----------------------------++++++-------------------------------
197: PROCEDURE Get_CriteriaStrings
198: ( p_source_id IN NUMBER
199: , p_criteria_collection IN ruleCriteriaCollection
200: , x_criteria_strings IN OUT NOCOPY DBMS_SQL.VARCHAR2S
201: , x_return_code OUT NOCOPY VARCHAR2
202: )
203: IS
204: l_status_code VARCHAR2(1);

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

453: -- Type : Private
454: -- Pre-reqs : None
455: -- Function : Append a SQL representation of the record filter criteria
456: -- to a collection of VARCHAR2s. This query, represented
457: -- as DBMS_SQL.VARCHAR2S can be executed via DBMS_SQL.
458: --
459: -- Parameters : p_source_id IN NUMBER Required
460: -- p_record_filter_id IN NUMBER Required
461: -- p_source_type_view IN VARCHAR2 Required

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

458: --
459: -- Parameters : p_source_id IN NUMBER Required
460: -- p_record_filter_id IN NUMBER Required
461: -- p_source_type_view IN VARCHAR2 Required
462: -- x_criteria_sql IN OUT DBMS_SQL.VARCHAR2S Required
463: -- x_return_code OUT VARCHAR2 Required
464: --
465: -- Version : Initial version 1.0
466: --

Line 474: , x_criteria_sql IN OUT NOCOPY DBMS_SQL.VARCHAR2S

470: PROCEDURE Append_RecFilterCriteriaClause
471: ( p_source_id IN NUMBER
472: , p_record_filter_id IN NUMBER
473: , p_source_type_view IN VARCHAR2
474: , x_criteria_sql IN OUT NOCOPY DBMS_SQL.VARCHAR2S
475: , x_return_code OUT NOCOPY VARCHAR2
476: )
477: IS
478: l_status_code VARCHAR2(1);

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

514: -- Type : Private
515: -- Pre-reqs : None
516: -- Function : Append a SQL representation of the subset criteria
517: -- to a collection of VARCHAR2S. This query, represented
518: -- as DBMS_SQL.VARCHAR2S can be executed via DBMS_SQL.
519: --
520: -- Parameters : p_source_id IN NUMBER Required
521: -- p_record_filter_id IN NUMBER Required
522: -- p_source_type_view IN VARCHAR2 Required

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

519: --
520: -- Parameters : p_source_id IN NUMBER Required
521: -- p_record_filter_id IN NUMBER Required
522: -- p_source_type_view IN VARCHAR2 Required
523: -- x_criteria_sql IN OUT DBMS_SQL.VARCHAR2S Required
524: -- x_return_code OUT VARCHAR2 Required
525: --
526: -- Version : Initial version 1.0
527: --

Line 535: , x_criteria_sql IN OUT NOCOPY DBMS_SQL.VARCHAR2S

531: PROCEDURE Append_SubsetCriteriaClause
532: ( p_source_id IN NUMBER
533: , p_subset_id IN NUMBER
534: , p_source_type_view IN VARCHAR2
535: , x_criteria_sql IN OUT NOCOPY DBMS_SQL.VARCHAR2S
536: , x_return_code OUT NOCOPY VARCHAR2
537: )
538: IS
539: l_status_code VARCHAR2(1);