[Home] [Help]
30: X_attribute13 VARCHAR2,
31: X_attribute14 VARCHAR2,
32: X_attribute15 VARCHAR2
33: ) IS
34: CURSOR C IS SELECT rowid FROM GL_CONS_SET_ASSIGNMENTS
35: WHERE consolidation_set_id = X_Consolidation_Set_Id;
36: BEGIN
37:
38: INSERT INTO GL_CONS_SET_ASSIGNMENTS(
34: CURSOR C IS SELECT rowid FROM GL_CONS_SET_ASSIGNMENTS
35: WHERE consolidation_set_id = X_Consolidation_Set_Id;
36: BEGIN
37:
38: INSERT INTO GL_CONS_SET_ASSIGNMENTS(
39: consolidation_set_id,
40: consolidation_id,
41: last_update_date,
42: last_updated_by,
124: ) IS
125:
126: BEGIN
127:
128: UPDATE GL_CONS_SET_ASSIGNMENTS
129: SET
130: consolidation_set_id = X_Consolidation_Set_Id,
131: consolidation_id = X_Consolidation_Id,
132: last_update_date = X_Last_Update_Date,
183: X_attribute13 VARCHAR2,
184: X_attribute14 VARCHAR2,
185: X_attribute15 VARCHAR2
186: ) IS
187: CURSOR C IS SELECT * FROM GL_CONS_SET_ASSIGNMENTS
188: WHERE rowid = X_Rowid
189: FOR UPDATE of consolidation_set_id NOWAIT;
190: Recinfo C%ROWTYPE;
191:
292: X_Context VARCHAR2
293: ) IS
294: BEGIN
295:
296: DELETE FROM GL_CONS_SET_ASSIGNMENTS
297: WHERE rowid = X_Rowid;
298:
299: IF ( SQL%NOTFOUND ) THEN
300: RAISE NO_DATA_FOUND;
304:
305: PROCEDURE Delete_All_Child_Rows( X_Consolidation_Set_Id IN OUT NOCOPY NUMBER) IS
306: BEGIN
307:
308: DELETE FROM GL_CONS_SET_ASSIGNMENTS
309: WHERE consolidation_set_id = X_Consolidation_Set_Id;
310:
311: END Delete_All_Child_Rows;
312:
314: X_Consolidation_Set_Id IN OUT NOCOPY NUMBER,
315: X_Consolidation_Id IN OUT NOCOPY NUMBER ) IS
316: CURSOR check_dups IS
317: SELECT 1
318: FROM GL_CONS_SET_ASSIGNMENTS gla
319: WHERE gla.consolidation_set_id = X_Consolidation_Set_Id
320: AND gla.consolidation_id = X_consolidation_id
321: AND ( X_Rowid is NULL
322: OR gla.rowid <> X_Rowid);