1 PACKAGE IGI_RPI_ITEMS_PKG AUTHID CURRENT_USER AS
2 --- $Header: igiritms.pls 120.3.12000000.1 2007/08/31 05:52:47 mbremkum ship $
3 PROCEDURE Insert_Row( X_Item_Id IN NUMBER
4 , X_Set_Of_Books_Id IN NUMBER
5 , X_Item_Code IN VARCHAR2
6 , X_Price IN NUMBER
7 , X_Price_Effective_Date IN DATE
8 , X_Unit_Of_Measure IN VARCHAR2
9 , X_Start_Effective_Date IN DATE
10 , X_Creation_Date IN DATE
11 , X_Created_By IN NUMBER
12 , X_Last_Update_Date IN DATE
13 , X_Last_Updated_By IN NUMBER
14 , X_Last_Update_Login IN NUMBER
15 , X_Revised_Price_Eff_Date IN DATE
16 , X_Revised_Price IN NUMBER
17 , X_Description IN VARCHAR2
18 , X_Vat_Tax_Id IN NUMBER
19 , X_Revenue_Code_Combination_Id IN NUMBER
20 , X_Inactive_Date IN DATE
21 , X_Enabled_Flag IN VARCHAR2
22 /*Added for MOAC Impact Bug No 5905216*/
23 , X_Org_Id IN NUMBER
24 );
25
26 PROCEDURE Update_Row( X_Item_Id IN NUMBER
27 , X_Set_Of_Books_Id IN NUMBER
28 , X_Item_Code IN VARCHAR2
29 , X_Price IN NUMBER
30 , X_Price_Effective_Date IN DATE
31 , X_Unit_Of_Measure IN VARCHAR2
32 , X_Start_Effective_Date IN DATE
33 , X_Last_Update_Date IN DATE
34 , X_Last_Updated_By IN NUMBER
35 , X_Last_Update_Login IN NUMBER
36 , X_Revised_Price_Eff_Date IN DATE
37 , X_Revised_Price IN NUMBER
38 , X_Description IN VARCHAR2
39 , X_Vat_Tax_Id IN NUMBER
40 , X_Revenue_Code_Combination_Id IN NUMBER
41 , X_Inactive_Date IN DATE
42 , X_Enabled_Flag IN VARCHAR2
43 );
44
45 PROCEDURE Delete_Row( X_Item_Id IN NUMBER);
46
47 END IGI_RPI_ITEMS_PKG;
[Home] [Help]