[Home] [Help]
PACKAGE: APPS.GL_COA_MAPPINGS_PKG
Source
1 PACKAGE GL_COA_MAPPINGS_PKG as
2 /* $Header: glicoams.pls 120.3 2005/05/05 01:04:16 kvora ship $ */
3 --
4 -- Package
5 -- gl_coa_mappings_pkg
6 -- Purpose
7 -- Package procedures for Chart of Accounts Mapping form,
8 -- Mapping block
9 -- History
10 -- 07/19/02 M Ward Created
11 --
12
13 --
14 -- Procedure
15 -- Insert_Row
16 -- Purpose
17 -- Insert new records into table GL_COA_MAPPINGS
18 -- Arguments
19 -- <table columns>
20 -- Example
21 -- GL_COA_MAPPINGS_PKG.Insert_Row(<table columns>)
22 -- Notes
23 --
24 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
25 X_Coa_Mapping_Id IN OUT NOCOPY NUMBER,
26 X_To_Coa_Id NUMBER,
27 X_From_Coa_Id NUMBER,
28 X_Name VARCHAR2,
29 X_Last_Update_Date DATE,
30 X_Last_Updated_By NUMBER,
31 X_Creation_Date DATE,
32 X_Created_By NUMBER,
33 X_Last_Update_Login NUMBER,
34 X_Description VARCHAR2,
35 X_Start_Date_Active DATE,
36 X_End_Date_Active DATE,
37 X_Security_Flag VARCHAR2
38 );
39
40 --
41 -- Procedure
42 -- Lock_Row
43 -- Purpose
44 -- Lock records in table GL_COA_MAPPINGS
45 -- Arguments
46 -- <table columns>
47 -- Example
48 -- GL_COA_MAPPINGS_PKG.Lock_Row(<table columns>)
49 -- Notes
50 --
51 PROCEDURE Lock_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
52 X_Coa_Mapping_Id IN OUT NOCOPY NUMBER,
53 X_To_Coa_Id NUMBER,
54 X_From_Coa_Id NUMBER,
55 X_Name VARCHAR2,
56 X_Description VARCHAR2,
57 X_Start_Date_Active DATE,
58 X_End_Date_Active DATE,
59 X_Security_Flag VARCHAR2
60 );
61
62 --
63 -- Procedure
64 -- Update_Row
65 -- Purpose
66 -- Update table GL_COA_MAPPINGS
67 -- Arguments
68 -- <table columns>
69 -- Example
70 -- GL_COA_MAPPINGS_PKG.Update_Row(<table columns>)
71 -- Notes
72 --
73 PROCEDURE Update_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
74 X_Coa_Mapping_Id IN OUT NOCOPY NUMBER,
75 X_To_Coa_Id NUMBER,
76 X_From_Coa_Id NUMBER,
77 X_Name VARCHAR2,
78 X_Last_Update_Date DATE,
79 X_Last_Updated_By NUMBER,
80 X_Last_Update_Login NUMBER,
81 X_Description VARCHAR2,
82 X_Start_Date_Active DATE,
83 X_End_Date_Active DATE,
84 X_Security_Flag VARCHAR2
85 );
86
87 --
88 -- Procedure
89 -- Delete_Row
90 -- Purpose
91 -- Delete records from table GL_COA_MAPPINGS
92 -- Arguments
93 -- Row_Id Rowid of row to be deleted
94 -- Coa_Mapping_Id Mapping ID for the mapping to be deleted
95 -- Example
96 -- GL_COA_MAPPINGS_PKG.Delete_Row(:MAPPING.Row_Id, :MAPPING.Mapping_Id)
97 -- Notes
98 --
99 PROCEDURE Delete_Row(X_Rowid VARCHAR2, X_Coa_Mapping_Id NUMBER);
100
101 --
102 -- Procedure
103 -- Check_Unique_Name
104 -- Purpose
105 -- Check if Coa_Mapping name is unique
106 -- Arguments
107 -- X_Rowid Rowid of record to be checked
108 -- Example
109 -- GL_COA_MAPPING_PKG.Check_Unique_Name(:MAPPING.row_id,
110 -- :MAPPING.name)
111 -- Notes
112 --
113 PROCEDURE Check_Unique_Name(X_Rowid VARCHAR2,
114 X_Name VARCHAR2);
115
116 --
117 -- Procedure
118 -- Check_Unique
119 -- Purpose
120 -- Check uniqueness of unique id
121 -- Arguments
122 -- X_Rowid Rowid of record to be checked
123 -- X_Coa_Mapping_Id Value of unique id
124 -- Example
125 -- GL_COA_MAPPING_PKG.Check_Unique(:MAPPING.row_id,
126 -- :MAPPING.coa_mapping_id)
127 -- Notes
128 --
129 PROCEDURE Check_Unique(X_Rowid VARCHAR2,
130 X_Coa_Mapping_Id NUMBER);
131
132 --
133 -- Procedure
134 -- Check_Unmapped_Sub_Segments
135 -- Purpose
136 -- Check at the time closing the form if there are any
137 -- unmapped subsidiary segments.
138 -- Arguments
139 -- X_From_Coa_Id From Chart of Accounts Id
140 -- X_Coa_Mapping_Id Coa_Mapping_Id
141 -- X_Unmapped_Segment_found Y or N
142 -- Example
143 -- GL_COA_MAPPING_PKG.Check_Unmapped_Sub_Segments(:MAPPING.from_coa_id,
144 -- :MAPPING.coa_mapping_id, unmapped_found)
145 -- Notes
146 --
147 PROCEDURE Check_Unmapped_Sub_Segments( X_From_Coa_Id NUMBER,
148 X_Coa_Mapping_Id NUMBER,
149 X_Unmapped_Segment_Found IN OUT NOCOPY VARCHAR2);
150 END GL_COA_MAPPINGS_PKG;