[Home] [Help]
PACKAGE: APPS.GL_SUSPENSE_ACCOUNTS_PKG
Source
1 PACKAGE GL_SUSPENSE_ACCOUNTS_PKG as
2 /* $Header: gliacsas.pls 120.5 2005/05/05 00:58:49 kvora ship $ */
3
4 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5 X_Ledger_Id NUMBER,
6 X_Je_Source_Name VARCHAR2,
7 X_Je_Category_Name VARCHAR2,
8 X_Code_Combination_Id NUMBER,
9 X_Last_Update_Date DATE,
10 X_Last_Updated_By NUMBER,
11 X_Creation_Date DATE,
12 X_Created_By NUMBER,
13 X_Last_Update_Login NUMBER,
14 X_Attribute1 VARCHAR2,
15 X_Attribute2 VARCHAR2,
16 X_Attribute3 VARCHAR2,
17 X_Attribute4 VARCHAR2,
18 X_Attribute5 VARCHAR2,
19 X_Context VARCHAR2
20 );
21
22 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
23 X_Ledger_Id NUMBER,
24 X_Je_Source_Name VARCHAR2,
25 X_Je_Category_Name VARCHAR2,
26 X_Code_Combination_Id NUMBER,
27 X_Attribute1 VARCHAR2,
28 X_Attribute2 VARCHAR2,
29 X_Attribute3 VARCHAR2,
30 X_Attribute4 VARCHAR2,
31 X_Attribute5 VARCHAR2,
32 X_Context VARCHAR2
33 );
34
35 PROCEDURE Update_Row(X_Rowid VARCHAR2,
36 X_Ledger_Id NUMBER,
37 X_Je_Source_Name VARCHAR2,
38 X_Je_Category_Name VARCHAR2,
39 X_Code_Combination_Id NUMBER,
40 X_Last_Update_Date DATE,
41 X_Last_Updated_By NUMBER,
42 X_Last_Update_Login NUMBER,
43 X_Attribute1 VARCHAR2,
44 X_Attribute2 VARCHAR2,
45 X_Attribute3 VARCHAR2,
46 X_Attribute4 VARCHAR2,
47 X_Attribute5 VARCHAR2,
48 X_Context VARCHAR2
49 );
50
51 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
52
53 PROCEDURE Check_Unique(X_Ledger_Id NUMBER,
54 X_Je_Source_Name VARCHAR2,
55 X_Je_Category_Name VARCHAR2,
56 X_Rowid VARCHAR2
57 );
58
59
60 FUNCTION is_ledger_suspense_exist( x_ledger_id NUMBER ) RETURN BOOLEAN;
61
62 PROCEDURE insert_ledger_suspense( x_ledger_id NUMBER,
63 x_code_combination_id NUMBER,
64 x_last_update_date DATE,
65 x_last_updated_by NUMBER );
66
67 PROCEDURE update_ledger_suspense( x_ledger_id NUMBER,
68 x_code_combination_id NUMBER,
69 x_last_update_date DATE,
70 x_last_updated_by NUMBER );
71
72
73 END GL_SUSPENSE_ACCOUNTS_PKG;