[Home] [Help]
1: PACKAGE BODY ego_item_associations_util AS
2: /* $Header: EGOVIAUB.pls 120.6 2011/06/01 09:24:33 erwu ship $ */
3:
4: G_SEARCH_CURSOR NUMBER := dbms_sql.open_cursor;
5: G_SEARCH_STMT LONG;
108: -- API name : search_supplier_and_site
109: -- Type : Private.
110: -- Function : Searches the supplier and site for the given criteria
111: -- Pre-reqs :
112: -- i) Search criteria is built using the constants specified in ego_item_associations_util or EgoSearchAssociationAM.
113: -- ii) Search Columns and Criteria has same number of values
114: -- iii) If p_search_sites is fnd_api.G_FALSE, then the criteria
115: -- for those columns should not be passed.
116: -- Will result in SQL exception if passed.
129: -- p_search_existing_site_only IN VARCHAR2 Optional Default fnd_api.G_FALSE
130: -- Version : Current version 1.0
131: -- Initial version 1.0
132: -- Notes : p_search_cols contains the search criteria columns. The list of columns are
133: -- defined as constants in ego_item_associations_util.
134: -- p_search_criteria will be corresponding search criteria for the columns.
135: -- Criteria and column names mapped based on index of the tables.
136: -- p_search_sites allows to search/return site results.
137: -- p_filter_rows specifies whether already associated needs to be filtered or not
406: --ROLLBACK TO search_supplier_and_site_pvt;
407: app_exception.raise_exception;
408: END search_supplier_and_site;
409:
410: END ego_item_associations_util;