PACKAGE: APPS.EGO_CATG_MAP_UTIL_PKG

Source

1 PACKAGE EGO_CATG_MAP_UTIL_PKG AUTHID CURRENT_USER AS
2 /* $Header: EGOUCMS.pls 120.2 2007/08/22 10:36:25 ysireesh noship $ */
3 
4 /*
5  * ACC to ACC Mapping
6  * Used in Data Orchestration.
7  * GPC i.e One alternate catalog category code is passed to the API as input and the
8  * API in turn will return us APC ACC(Alternate catalog category) Id and the
9  * alternate catalog category associated with it.
10  * param P_GPC_ID - GPC Code
11  * param X_ACC_CATEGORY_ID - Alternate Catalog Category Id
12  * param X_ACC_CATALOG_ID - Alternate Catalog Id.
13  */
14  	 PROCEDURE Get_Alt_Catalog_Ctgr_Mapping
15  	 (
16  	       P_GPC_ID  IN NUMBER,
17  	       X_ACC_CATEGORY_ID OUT NOCOPY NUMBER,
18  	       X_ACC_CATALOG_ID OUT NOCOPY NUMBER
19  	 );
20 
21 
22 /*
23  * ACC to ICC Mapping
24  * Used in Data Orchestration.
25  * GPC i.e One alternate catalog category code is passed to the API as input and the
26  * API in turn will return us APC ICC(Primary catalog category) Id associated
27  * with it.
28  * param P_GPC_ID - GPC Code
29  * param X_ICC_CATEGORY_ID - Primary Catalog Category Id
30  */
31  	 PROCEDURE Get_Item_Catalog_Ctgr_Mapping
32  	 (
33  	       P_GPC_ID  IN VARCHAR2,
34  	       X_ICC_CATEGORY_ID OUT NOCOPY NUMBER
35  	 );
36 
37 END EGO_CATG_MAP_UTIL_PKG;