APPS.EGO_ITEM_ASSOCIATIONS_UTIL dependencies on FND_API

Line 21: -- iii) If p_search_sites is fnd_api.G_FALSE, then the criteria

17: -- Function : Searches the supplier and site for the given criteria
18: -- Pre-reqs :
19: -- i) Search criteria is built using the constants specified in ego_item_associations_util or EgoSearchAssociationAM.
20: -- ii) Search Columns and Criteria has same number of values
21: -- iii) If p_search_sites is fnd_api.G_FALSE, then the criteria
22: -- for those columns should not be passed.
23: -- Will result in SQL exception if passed.
24: -- iv) Atleast one criteria has been specified to search.
25: -- v) Passed organization id should be master organization id. No validation will be done from search. Wrong value

Line 32: -- p_search_sites IN VARCHAR2 Optional Default fnd_api.G_FALSE

28: -- IN : p_api_version IN NUMBER Required
29: -- p_batch_id INOUT NOCOPY NUMBER Required
30: -- p_search_cols IN EGO_VARCHAR_TBL_TYPE Required
31: -- p_search_criteria IN EGO_VARCHAR_TBL_TYPE Required
32: -- p_search_sites IN VARCHAR2 Optional Default fnd_api.G_FALSE
33: -- p_filter_rows IN VARCHAR2 Optional Default fnd_api.G_FALSE
34: -- p_inventory_item_id IN NUMBER Optional Default NULL
35: -- p_master_org_id IN NUMBER Required
36: -- p_search_existing_site_only IN VARCHAR2 Optional Default fnd_api.G_FALSE

Line 33: -- p_filter_rows IN VARCHAR2 Optional Default fnd_api.G_FALSE

29: -- p_batch_id INOUT NOCOPY NUMBER Required
30: -- p_search_cols IN EGO_VARCHAR_TBL_TYPE Required
31: -- p_search_criteria IN EGO_VARCHAR_TBL_TYPE Required
32: -- p_search_sites IN VARCHAR2 Optional Default fnd_api.G_FALSE
33: -- p_filter_rows IN VARCHAR2 Optional Default fnd_api.G_FALSE
34: -- p_inventory_item_id IN NUMBER Optional Default NULL
35: -- p_master_org_id IN NUMBER Required
36: -- p_search_existing_site_only IN VARCHAR2 Optional Default fnd_api.G_FALSE
37: -- Version : Current version 1.0

Line 36: -- p_search_existing_site_only IN VARCHAR2 Optional Default fnd_api.G_FALSE

32: -- p_search_sites IN VARCHAR2 Optional Default fnd_api.G_FALSE
33: -- p_filter_rows IN VARCHAR2 Optional Default fnd_api.G_FALSE
34: -- p_inventory_item_id IN NUMBER Optional Default NULL
35: -- p_master_org_id IN NUMBER Required
36: -- p_search_existing_site_only IN VARCHAR2 Optional Default fnd_api.G_FALSE
37: -- Version : Current version 1.0
38: -- Initial version 1.0
39: -- Notes : p_search_cols contains the search criteria columns. The list of columns are
40: -- defined as constants in ego_item_associations_util.

Line 55: ,p_search_sites IN VARCHAR2 DEFAULT fnd_api.G_FALSE

51: p_api_version IN NUMBER
52: ,p_batch_id IN OUT NOCOPY NUMBER
53: ,p_search_cols IN EGO_VARCHAR_TBL_TYPE
54: ,p_search_criteria IN EGO_VARCHAR_TBL_TYPE
55: ,p_search_sites IN VARCHAR2 DEFAULT fnd_api.G_FALSE
56: ,p_filter_rows IN VARCHAR2 := fnd_api.G_FALSE
57: ,p_inventory_item_id IN NUMBER := NULL
58: ,p_master_org_id IN NUMBER
59: ,p_search_existing_site_only IN VARCHAR2 := fnd_api.G_FALSE

Line 56: ,p_filter_rows IN VARCHAR2 := fnd_api.G_FALSE

52: ,p_batch_id IN OUT NOCOPY NUMBER
53: ,p_search_cols IN EGO_VARCHAR_TBL_TYPE
54: ,p_search_criteria IN EGO_VARCHAR_TBL_TYPE
55: ,p_search_sites IN VARCHAR2 DEFAULT fnd_api.G_FALSE
56: ,p_filter_rows IN VARCHAR2 := fnd_api.G_FALSE
57: ,p_inventory_item_id IN NUMBER := NULL
58: ,p_master_org_id IN NUMBER
59: ,p_search_existing_site_only IN VARCHAR2 := fnd_api.G_FALSE
60: ,p_filter_suppliers IN VARCHAR2 := fnd_api.G_FALSE

Line 59: ,p_search_existing_site_only IN VARCHAR2 := fnd_api.G_FALSE

55: ,p_search_sites IN VARCHAR2 DEFAULT fnd_api.G_FALSE
56: ,p_filter_rows IN VARCHAR2 := fnd_api.G_FALSE
57: ,p_inventory_item_id IN NUMBER := NULL
58: ,p_master_org_id IN NUMBER
59: ,p_search_existing_site_only IN VARCHAR2 := fnd_api.G_FALSE
60: ,p_filter_suppliers IN VARCHAR2 := fnd_api.G_FALSE
61: );
62:
63: /*PROCEDURE a_debug(p_msg VARCHAR2);*/

Line 60: ,p_filter_suppliers IN VARCHAR2 := fnd_api.G_FALSE

56: ,p_filter_rows IN VARCHAR2 := fnd_api.G_FALSE
57: ,p_inventory_item_id IN NUMBER := NULL
58: ,p_master_org_id IN NUMBER
59: ,p_search_existing_site_only IN VARCHAR2 := fnd_api.G_FALSE
60: ,p_filter_suppliers IN VARCHAR2 := fnd_api.G_FALSE
61: );
62:
63: /*PROCEDURE a_debug(p_msg VARCHAR2);*/
64: