[Home] [Help]
PACKAGE: APPS.IGI_ITR_CHARGE_CENTER_SS_PKG
Source
1 PACKAGE IGI_ITR_CHARGE_CENTER_SS_PKG as
2 -- $Header: igiitrls.pls 120.3.12000000.1 2007/09/12 10:31:51 mbremkum ship $
3 --
4 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5 X_Charge_Center_Id NUMBER,
6 X_Name VARCHAR2,
7 X_Set_Of_Books_Id NUMBER,
8 X_Start_Date_Active DATE,
9 X_End_Date_Active DATE,
10 X_Description VARCHAR2,
11 X_Creation_Date DATE,
12 X_Created_By NUMBER,
13 X_Last_Update_Login NUMBER,
14 X_Last_Update_Date DATE,
15 X_Last_Updated_By NUMBER
16 );
17
18 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
19 X_Charge_Center_Id NUMBER,
20 X_Name VARCHAR2,
21 X_Set_Of_Books_Id NUMBER,
22 X_Start_Date_Active DATE,
23 X_End_Date_Active DATE,
24 X_Description VARCHAR2
25 );
26
27 PROCEDURE Update_Row(X_Rowid VARCHAR2,
28 X_Charge_Center_Id NUMBER,
29 X_Name VARCHAR2,
30 X_Set_Of_Books_Id NUMBER,
31 X_Start_Date_Active DATE,
32 X_End_Date_Active DATE,
33 X_Description VARCHAR2,
34 X_Last_Update_Login NUMBER,
35 X_Last_Update_Date DATE,
36 X_Last_Updated_By NUMBER
37 );
38
39
40 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
41
42
43 -- to check the Charge Center Name is Unique for each Set Of Books Id.
44
45 PROCEDURE check_unique_cc(x_rowid VARCHAR2,
46 x_name VARCHAR2,
47 x_set_of_books_id NUMBER);
48
49
50 END IGI_ITR_CHARGE_CENTER_SS_PKG;