APPS.GL_STAT_ACCOUNT_UOM_PKG dependencies on GL_STAT_ACCOUNT_UOM

Line 1: PACKAGE BODY GL_STAT_ACCOUNT_UOM_PKG as

1: PACKAGE BODY GL_STAT_ACCOUNT_UOM_PKG as
2: /* $Header: glisuomb.pls 120.5 2005/05/05 01:28:27 kvora ship $ */
3:
4: --
5: -- PRIVATE FUNCTIONS

Line 18: -- gl_stat_account_uom_pkg.select_row(recinfo)

14: -- 01-20-94 D. J. Ogg Created
15: -- Arguments
16: -- recinfo Various information about the row
17: -- Example
18: -- gl_stat_account_uom_pkg.select_row(recinfo)
19: -- Notes
20: --
21: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_stat_account_uom%ROWTYPE) IS
22: BEGIN

Line 21: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_stat_account_uom%ROWTYPE) IS

17: -- Example
18: -- gl_stat_account_uom_pkg.select_row(recinfo)
19: -- Notes
20: --
21: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_stat_account_uom%ROWTYPE) IS
22: BEGIN
23: SELECT *
24: INTO recinfo
25: FROM gl_stat_account_uom

Line 25: FROM gl_stat_account_uom

21: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_stat_account_uom%ROWTYPE) IS
22: BEGIN
23: SELECT *
24: INTO recinfo
25: FROM gl_stat_account_uom
26: WHERE chart_of_accounts_id = recinfo.chart_of_accounts_id
27: AND account_segment_value = recinfo.account_segment_value;
28: END SELECT_ROW;
29:

Line 41: recinfo gl_stat_account_uom%ROWTYPE;

37: x_account_segment_value IN OUT NOCOPY VARCHAR2,
38: x_unit_of_measure IN OUT NOCOPY VARCHAR2,
39: x_description IN OUT NOCOPY VARCHAR2) IS
40:
41: recinfo gl_stat_account_uom%ROWTYPE;
42:
43: BEGIN
44: recinfo.chart_of_accounts_id := x_chart_of_accounts_id;
45: recinfo.account_segment_value := x_account_segment_value;

Line 66: CURSOR C IS SELECT rowid FROM gl_stat_account_uom

62: X_Creation_Date DATE DEFAULT NULL,
63: X_Created_By NUMBER DEFAULT NULL,
64: X_Last_Update_Login NUMBER DEFAULT NULL
65: ) IS
66: CURSOR C IS SELECT rowid FROM gl_stat_account_uom
67:
68: WHERE account_segment_value = X_Account_Segment_Value
69:
70: AND chart_of_accounts_id = X_Chart_Of_Accounts_Id;

Line 82: INSERT INTO gl_stat_account_uom(

78:
79:
80:
81:
82: INSERT INTO gl_stat_account_uom(
83: account_segment_value,
84: unit_of_measure,
85: chart_of_accounts_id,
86: description,

Line 122: FROM gl_stat_account_uom

118: X_Description VARCHAR2 DEFAULT NULL
119: ) IS
120: CURSOR C IS
121: SELECT *
122: FROM gl_stat_account_uom
123: WHERE rowid = X_Rowid
124: FOR UPDATE of Account_Segment_Value NOWAIT;
125: Recinfo C%ROWTYPE;
126: BEGIN

Line 165: UPDATE gl_stat_account_uom

161: X_Last_Updated_By NUMBER DEFAULT NULL,
162: X_Last_Update_Login NUMBER DEFAULT NULL
163: ) IS
164: BEGIN
165: UPDATE gl_stat_account_uom
166: SET
167:
168: account_segment_value = X_Account_Segment_Value,
169: unit_of_measure = X_Unit_Of_Measure,

Line 185: DELETE FROM gl_stat_account_uom

181: END Update_Row;
182:
183: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
184: BEGIN
185: DELETE FROM gl_stat_account_uom
186: WHERE rowid = X_Rowid;
187:
188: if (SQL%NOTFOUND) then
189: RAISE NO_DATA_FOUND;

Line 199: (select 1 from gl_stat_account_uom

195: X_Chart_Of_Accounts_Id NUMBER) IS
196: dummy number;
197: BEGIN
198: select 1 into dummy from dual where not exists
199: (select 1 from gl_stat_account_uom
200: where account_segment_value = X_Account_Segment_Value
201: and chart_of_accounts_id = X_Chart_Of_Accounts_Id
202: and ((X_Rowid is null) or (rowid <> X_Rowid))
203: );

Line 210: END GL_STAT_ACCOUNT_UOM_PKG;

206: fnd_message.set_name('SQLGL','GL_ONE_UNIT_PER_ACCOUNT');
207: app_exception.raise_exception;
208: END Check_Unique;
209:
210: END GL_STAT_ACCOUNT_UOM_PKG;