[Home] [Help]
PACKAGE: APPS.GL_BUDORG_BC_OPTIONS_PKG
Source
1 PACKAGE gl_budorg_bc_options_pkg AS
2 /* $Header: glibebcs.pls 120.3.12010000.1 2008/07/28 13:23:33 appldev ship $ */
3 --
4 -- Package
5 -- gl_budorg_bc_options_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_budorg_bc_options
8 -- History
9 -- 28-06-05 A Govil Created
10
11 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
12 X_Last_Update_Date DATE,
13 X_Last_Updated_By NUMBER,
14 X_Creation_Date DATE,
15 X_Created_By NUMBER,
16 X_Last_Update_Login NUMBER,
17 X_Funds_Check_Level_Code VARCHAR2,
18 X_Amount_Type VARCHAR2,
19 X_Boundary_Code VARCHAR2,
20 X_Funding_Budget_Version_Id NUMBER,
21 X_Range_Id NUMBER
22 );
23
24 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
25 X_Funds_Check_Level_Code VARCHAR2,
26 X_Amount_Type VARCHAR2,
27 X_Boundary_Code VARCHAR2,
28 X_Funding_Budget_Version_Id NUMBER,
29 X_Range_Id NUMBER
30 );
31
32 PROCEDURE Update_Row(X_Rowid VARCHAR2,
33 X_Last_Update_Date DATE,
34 X_Last_Updated_By NUMBER,
35 X_Last_Update_Login NUMBER,
36 X_Funds_Check_Level_Code VARCHAR2,
37 X_Amount_Type VARCHAR2,
38 X_Boundary_Code VARCHAR2,
39 X_Funding_Budget_Version_Id NUMBER,
40 X_Range_Id NUMBER
41 );
42
43 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
44
45 PROCEDURE delete_budorg_bc_options(xrange_id NUMBER);
46
47 PROCEDURE Insert_BC_Options(X_Rowid IN OUT NOCOPY VARCHAR2,
48 X_Last_Update_Date DATE,
49 X_Last_Updated_By NUMBER,
50 X_Creation_Date DATE,
51 X_Created_By NUMBER,
52 X_Last_Update_Login NUMBER,
53 X_Funds_Check_Level_Code VARCHAR2,
54 X_Amount_Type VARCHAR2,
55 X_Boundary_Code VARCHAR2,
56 X_Funding_Budget_Version_Id NUMBER,
57 X_Range_Id NUMBER
58 );
59
60 PROCEDURE Update_BC_Options(X_Range_Id NUMBER,
61 X_Last_Update_Date DATE,
62 X_Last_Updated_By NUMBER,
63 X_Last_Update_Login NUMBER,
64 X_Funds_Check_Level_Code VARCHAR2,
65 X_Amount_Type VARCHAR2,
66 X_Boundary_Code VARCHAR2,
67 X_Funding_Budget_Version_Id NUMBER
68 );
69
70
71 END gl_budorg_bc_options_pkg;