DBA Data[Home] [Help]

PACKAGE: APPS.GL_SUMMARY_BC_OPTIONS_PKG

Source


1 PACKAGE gl_summary_bc_options_pkg AS
2 /* $Header: glistbcs.pls 120.2.12010000.1 2008/07/28 13:26:47 appldev ship $ */
3 --
4 -- Package
5 --   gl_summary_bc_options_pkg
6 -- Purpose
7 --   To contain validation and insertion routines for gl_summary_bc_options
8 -- History
9 --  01-07-05  	A Govil	Created
10 
11 
12  -- Procedure
13  --  Insert_Row
14  -- Purpose
15  --  Insert a new row into GL_SUMMARY_BC_OPTIONS
16  -- History
17  --  04/07/05 A Govil Created
18  -- Example
19  --  GL_SUMMARY_BC_OPTIONS_PKG.Insert_Row;
20 
21 PROCEDURE Insert_Row(X_Rowid                        IN OUT NOCOPY VARCHAR2,
22                      X_Funds_Check_Level_Code              VARCHAR2,
23                      X_Dr_Cr_Code                          VARCHAR2,
24                      X_Amount_Type                         VARCHAR2,
25                      X_Boundary_Code                       VARCHAR2,
26                      X_Template_Id                         NUMBER,
27                      X_Last_Update_Date                    DATE,
28                      X_Last_Updated_by                     NUMBER,
29                      X_Created_By                          NUMBER,
30                      X_Creation_Date                       DATE,
31                      X_Last_Update_Login                   NUMBER,
32                      X_Funding_Budget_Version_Id           NUMBER
33                      );
34 
35  -- Procedure
36  --  Lock_Row
37  -- Purpose
38  --  Lock a row in GL_SUMMARY_BC_OPTIONS
39  -- History
40  --  04/07/05 A Govil	Created
41  -- Example
42  --  GL_SUMMARY_BC_OPTIONS_PKG.Lock_Row;
43 
44 PROCEDURE Lock_Row(X_Rowid                               VARCHAR2,
45                    X_Funds_Check_Level_Code              VARCHAR2,
46                    X_Dr_Cr_Code                          VARCHAR2,
47                    X_Amount_Type                         VARCHAR2,
48                    X_Boundary_Code                       VARCHAR2,
49                    X_Template_Id                         NUMBER,
50                    X_Last_Update_Date                    DATE,
51                    X_Last_Updated_by                     NUMBER,
52                    X_Created_By                          NUMBER,
53                    X_Creation_Date                       DATE,
54                    X_Last_Update_Login                   NUMBER,
55                    X_Funding_Budget_Version_Id           NUMBER
56                    );
57 
58  -- Procedure
59  --  Insert_BC_Options
60  -- Purpose
61  --  API given to Isetup API to insert a new row into GL_SUMMARY_BC_OPTIONS
62  -- History
63  --  14/12/06 A Govil Created
64  -- Example
65  --  GL_SUMMARY_BC_OPTIONS_PKG.Insert_BC_Options;
66 
67 PROCEDURE Insert_BC_Options(X_Rowid                        IN OUT NOCOPY VARCHAR2,
68                             X_Funds_Check_Level_Code              VARCHAR2,
69                             X_Dr_Cr_Code                          VARCHAR2,
70                             X_Amount_Type                         VARCHAR2,
71                             X_Boundary_Code                       VARCHAR2,
72                             X_Template_Id                         NUMBER,
73                             X_Last_Update_Date                    DATE,
74                             X_Last_Updated_by                     NUMBER,
75                             X_Created_By                          NUMBER,
76                             X_Creation_Date                       DATE,
77                             X_Last_Update_Login                   NUMBER,
78                             X_Funding_Budget_Version_Id           NUMBER
79                            );
80 
81 END gl_summary_bc_options_pkg;