[Home] [Help]
PACKAGE: APPS.GL_STAT_ACCOUNT_UOM_PKG
Source
1 PACKAGE GL_STAT_ACCOUNT_UOM_PKG as
2 /* $Header: glisuoms.pls 120.5 2005/05/05 01:28:35 kvora ship $ */
3
4 --
5 -- Package
6 -- gl_stat_account_uom_pkg
7 -- Purpose
8 -- To contain routines for the gl_stat_account_uom table
9 -- History
10 -- 01-18-94 S. Leotin Created
11 -- 01-20-94 D. J. Ogg Added select_columns routine
12
13 --
14 -- Procedure
15 -- select_columns
16 -- Purpose
17 -- Used to select the unit of measure for a given account
18 -- segment value and chart of accounts.
19 -- History
20 -- 01-20-94 D. J. Ogg Created
21 -- 05-05-94 R Ng Added description to select_columns
22 -- Arguments
23 -- x_chart_of_accounts_id Chart of Accounts ID
24 -- x_account_segment_value Accounting segment value
25 -- x_unit_of_measure Resulting unit of measure
26 -- x_description Description of Unit
27 -- Example
28 -- gl_stat_account_uom_pkg.select_columns(101, '00', uom);
29 -- Notes
30 --
31 PROCEDURE select_columns(
32 x_chart_of_accounts_id IN OUT NOCOPY NUMBER,
33 x_account_segment_value IN OUT NOCOPY VARCHAR2,
34 x_unit_of_measure IN OUT NOCOPY VARCHAR2,
35 x_description IN OUT NOCOPY VARCHAR2);
36
37 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
38
39 X_Account_Segment_Value VARCHAR2,
40 X_Unit_Of_Measure VARCHAR2,
41 X_Chart_Of_Accounts_Id NUMBER,
42 X_Description VARCHAR2 DEFAULT NULL,
43 X_Last_Update_Date DATE DEFAULT NULL,
44 X_Last_Updated_By NUMBER DEFAULT NULL,
45 X_Creation_Date DATE DEFAULT NULL,
46 X_Created_By NUMBER DEFAULT NULL,
47 X_Last_Update_Login NUMBER DEFAULT NULL
48 );
49
50 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
51 X_Account_Segment_Value VARCHAR2,
52 X_Unit_Of_Measure VARCHAR2,
53 X_Chart_Of_Accounts_Id NUMBER,
54 X_Description VARCHAR2 DEFAULT NULL
55 );
56
57 PROCEDURE Update_Row(X_Rowid VARCHAR2,
58 X_Account_Segment_Value VARCHAR2,
59 X_Unit_Of_Measure VARCHAR2,
60 X_Chart_Of_Accounts_Id NUMBER,
61 X_Description VARCHAR2 DEFAULT NULL,
62 X_Last_Update_Date DATE DEFAULT NULL,
63 X_Last_Updated_By NUMBER DEFAULT NULL,
64 X_Last_Update_Login NUMBER DEFAULT NULL
65 );
66
67 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
68
69 PROCEDURE Check_Unique(X_Rowid VARCHAR2,
70 X_Account_Segment_Value VARCHAR2,
71 X_Chart_Of_Accounts_Id NUMBER
72 );
73
74 END GL_STAT_ACCOUNT_UOM_PKG;