DBA Data[Home] [Help]

PACKAGE: APPS.PRODUCT_FAMILY_PKG

Source


1 PACKAGE Product_Family_PKG AS
2 /* $Header: BOMPFAPS.pls 120.1 2005/10/05 03:39:17 vhymavat noship $ */
3 
4 
5 	PROCEDURE Update_PF_Item_Id(X_Inventory_Item_Id NUMBER,
6 				    X_Organization_Id   NUMBER,
7 				    X_PF_Item_Id        NUMBER,
8 				    X_Trans_Type	VARCHAR2 DEFAULT 'ADD',
9 				    X_Error_Msg	  IN OUT NOCOPY VARCHAR2,
10 				    X_Error_Code  IN OUT NOCOPY NUMBER);
11 
12 	PROCEDURE Delete_PF_Member(X_Member_Item_Id     NUMBER,
13 				   X_Organization_Id	NUMBER,
14 				   X_Bill_Sequence_Id	NUMBER,
15 				   X_Error_Msg	  IN OUT NOCOPY VARCHAR2,
16 				   X_Error_Code  IN OUT NOCOPY NUMBER);
17 
18 	FUNCTION Check_Overlap_Dates(X_Effectivity_Date DATE,
19 				     X_Disable_Date     DATE,
20 				     X_Member_Item_Id	NUMBER,
21 				     X_Bill_Sequence_Id NUMBER,
22 				     X_Rowid		VARCHAR2) RETURN BOOLEAN;
23 
24 	PROCEDURE Update_Config_Item(X_PF_Item_Id	NUMBER,
25 				     X_Base_Item_Id	NUMBER,
26 				     X_Organization_Id	NUMBER,
27                                      X_Error_Msg   IN OUT NOCOPY VARCHAR2,
28                                      X_Error_Code  IN OUT NOCOPY NUMBER);
29 
30    	PROCEDURE GetMemberInfo(p_Organization_id       IN      NUMBER,
31                                 p_Component_Item_Id     IN      NUMBER,
32                                 x_Bom_Item_Type         IN OUT NOCOPY VARCHAR2,
33                                 x_Forecast_Control      IN OUT NOCOPY VARCHAR2,
34                                 x_Planning_Method       IN OUT NOCOPY VARCHAR2
35                                 );
36 
37         FUNCTION Check_Unique(X_Assembly_Item_Id NUMBER,
38                               X_Organization_Id  NUMBER) RETURN BOOLEAN;
39 
40 END Product_Family_PKG;