APPS.GL_COA_MAPPINGS_PKG dependencies on GL_COA_MAPPINGS

Line 1: PACKAGE BODY GL_COA_MAPPINGS_PKG as

1: PACKAGE BODY GL_COA_MAPPINGS_PKG as
2: /* $Header: glicoamb.pls 120.4 2005/05/05 01:04:08 kvora ship $ */
3: --
4: -- PRIVATE FUNCTIONS
5: --

Line 27: CURSOR C IS SELECT rowid FROM gl_coa_mappings

23: X_Start_Date_Active DATE,
24: X_End_Date_Active DATE,
25: X_Security_Flag VARCHAR2
26: ) IS
27: CURSOR C IS SELECT rowid FROM gl_coa_mappings
28: WHERE coa_mapping_id = X_Coa_Mapping_Id;
29:
30: BEGIN
31:

Line 32: INSERT INTO gl_coa_mappings(

28: WHERE coa_mapping_id = X_Coa_Mapping_Id;
29:
30: BEGIN
31:
32: INSERT INTO gl_coa_mappings(
33: coa_mapping_id,
34: to_coa_id,
35: from_coa_id,
36: name,

Line 84: FROM gl_coa_mappings

80: X_Security_Flag VARCHAR2
81: ) IS
82: CURSOR C IS
83: SELECT *
84: FROM gl_coa_mappings
85: WHERE rowid = X_Rowid
86: FOR UPDATE of Coa_Mapping_Id NOWAIT;
87: Recinfo C%ROWTYPE;
88: BEGIN

Line 145: UPDATE gl_coa_mappings

141: X_Security_Flag VARCHAR2
142: ) IS
143: BEGIN
144:
145: UPDATE gl_coa_mappings
146: SET
147: coa_mapping_id = X_Coa_Mapping_Id,
148: to_coa_id = X_To_Coa_Id,
149: from_coa_id = X_From_Coa_Id,

Line 179: DELETE FROM gl_coa_mappings

175:
176: DELETE FROM GL_CONS_SEGMENT_MAP
177: WHERE COA_MAPPING_ID = X_Coa_Mapping_Id;
178:
179: DELETE FROM gl_coa_mappings
180: WHERE rowid = X_Rowid;
181:
182: if (SQL%NOTFOUND) then
183: RAISE NO_DATA_FOUND;

Line 193: FROM GL_COA_MAPPINGS map

189: PROCEDURE Check_Unique_Name(X_Rowid VARCHAR2,
190: X_Name VARCHAR2) IS
191: CURSOR check_dups IS
192: SELECT 1
193: FROM GL_COA_MAPPINGS map
194: WHERE map.name = X_Name
195: AND ( X_Rowid is NULL
196: OR map.rowid <> X_Rowid);
197:

Line 217: FROM GL_COA_MAPPINGS map

213: PROCEDURE Check_Unique(X_Rowid VARCHAR2,
214: X_Coa_Mapping_Id NUMBER) IS
215: CURSOR C2 IS
216: SELECT 1
217: FROM GL_COA_MAPPINGS map
218: WHERE map.coa_mapping_id = X_Coa_Mapping_Id
219: AND ( X_Rowid is NULL
220: OR map.rowid <> X_Rowid);
221:

Line 231: fnd_message.set_token('TAB_S','GL_COA_MAPPINGS_S');

227:
228: IF C2%FOUND THEN
229: CLOSE C2;
230: fnd_message.set_name('SQLGL','GL_DUP_UNIQUE_ID');
231: fnd_message.set_token('TAB_S','GL_COA_MAPPINGS_S');
232: app_exception.raise_exception;
233: END IF;
234:
235: CLOSE C2;

Line 270: END GL_COA_MAPPINGS_PKG;

266:
267: CLOSE C4;
268: END Check_Unmapped_Sub_Segments;
269:
270: END GL_COA_MAPPINGS_PKG;