APPS.GL_CODE_COMBINATIONS_PKG dependencies on GL_CODE_COMBINATIONS

Line 1: PACKAGE BODY GL_CODE_COMBINATIONS_PKG AS

1: PACKAGE BODY GL_CODE_COMBINATIONS_PKG AS
2: /* $Header: gliccidb.pls 120.9 2005/07/01 05:19:41 agovil ship $ */
3:
4:
5: --

Line 11: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_code_combinations%ROWTYPE ) IS

7: --
8:
9:
10:
11: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_code_combinations%ROWTYPE ) IS
12: BEGIN
13: SELECT *
14: INTO recinfo
15: FROM gl_code_combinations

Line 15: FROM gl_code_combinations

11: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_code_combinations%ROWTYPE ) IS
12: BEGIN
13: SELECT *
14: INTO recinfo
15: FROM gl_code_combinations
16: WHERE code_combination_id = recinfo.code_combination_id;
17: END select_row;
18:
19: -- **********************************************************************

Line 25: recinfo gl_code_combinations%ROWTYPE;

21: PROCEDURE select_columns(
22: X_code_combination_id NUMBER,
23: X_account_type IN OUT NOCOPY VARCHAR2,
24: X_template_id IN OUT NOCOPY NUMBER ) IS
25: recinfo gl_code_combinations%ROWTYPE;
26: BEGIN
27: recinfo.code_combination_id := X_code_combination_id;
28: select_row(recinfo);
29: X_account_type := recinfo.account_type;

Line 39: FROM gl_code_combinations cc

35: PROCEDURE check_unique( x_rowid VARCHAR2,
36: x_ccid NUMBER ) IS
37: CURSOR c_dup IS
38: SELECT 'Duplicate'
39: FROM gl_code_combinations cc
40: WHERE cc.code_combination_id = x_ccid
41: AND ( x_rowid is NULL
42: OR
43: cc.rowid <> x_rowid );

Line 64: 'GL_CODE_COMBINATIONS_PKG.check_unique');

60: RAISE;
61: WHEN OTHERS THEN
62: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
63: fnd_message.set_token('PROCEDURE',
64: 'GL_CODE_COMBINATIONS_PKG.check_unique');
65: RAISE;
66:
67: END check_unique;
68:

Line 84: FROM gl_code_combinations cc,

80: SELECT st.ledger_id,
81: st.template_id
82: INTO new_ledger_id,
83: x_template_id
84: FROM gl_code_combinations cc,
85: gl_summary_templates st
86: WHERE cc.code_combination_id = x_ccid
87: AND st.template_id(+) = cc.template_id;
88:

Line 100: 'GL_CODE_COMBINATIONS_PKG.get_valid_sob_summary');

96: RAISE;
97: WHEN OTHERS THEN
98: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
99: fnd_message.set_token('PROCEDURE',
100: 'GL_CODE_COMBINATIONS_PKG.get_valid_sob_summary');
101: RAISE;
102:
103: END get_valid_sob_summary;
104:

Line 216: CURSOR C IS SELECT rowid FROM gl_code_combinations

212: X_reference5 VARCHAR2,
213: X_preserve_flag VARCHAR2,
214: X_refresh_flag VARCHAR2
215: ) IS
216: CURSOR C IS SELECT rowid FROM gl_code_combinations
217:
218: WHERE code_combination_id = X_Code_Combination_Id;
219:
220:

Line 232: INSERT INTO gl_code_combinations(

228:
229:
230:
231:
232: INSERT INTO gl_code_combinations(
233: code_combination_id,
234: alternate_code_combination_id,
235: last_update_date,
236: last_updated_by,

Line 570: FROM gl_code_combinations

566: X_refresh_flag VARCHAR2
567: ) IS
568: CURSOR C IS
569: SELECT *
570: FROM gl_code_combinations
571: WHERE rowid = X_Rowid
572: FOR UPDATE of Code_Combination_Id NOWAIT;
573: Recinfo C%ROWTYPE;
574: BEGIN

Line 1035: FROM gl_code_combinations

1031: /* Check to see if account has been disabled */
1032: IF (X_enabled_flag = 'N') THEN
1033: SELECT enabled_flag
1034: INTO old_enabled_flag
1035: FROM gl_code_combinations
1036: WHERE rowid = X_rowid;
1037:
1038: IF (old_enabled_flag = 'Y') THEN
1039: /*

Line 1077: UPDATE gl_code_combinations

1073: END IF;
1074: END IF;
1075:
1076:
1077: UPDATE gl_code_combinations
1078: SET
1079:
1080: code_combination_id = X_Code_Combination_Id,
1081: alternate_code_combination_id = X_Alt_Code_Combination_Id,

Line 1198: DELETE FROM gl_code_combinations

1194: END Update_Row;
1195:
1196: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
1197: BEGIN
1198: DELETE FROM gl_code_combinations
1199: WHERE rowid = X_Rowid;
1200:
1201: if (SQL%NOTFOUND) then
1202: RAISE NO_DATA_FOUND;

Line 1249: FROM GL_CODE_COMBINATIONS

1245: CURSOR get_acct_info IS
1246: SELECT NVL(account_type, 'XXX'), NVL(summary_flag, 'XXX'),
1247: NVL(template_id, -1), NVL(refresh_flag, 'N'),
1248: NVL(preserve_flag, 'N'), enabled_flag
1249: FROM GL_CODE_COMBINATIONS
1250: WHERE code_combination_id = X_CCID;
1251:
1252: ret_val BOOLEAN := FALSE;
1253:

Line 1351: END GL_CODE_COMBINATIONS_PKG;

1347:
1348:
1349: -- **********************************************************************
1350:
1351: END GL_CODE_COMBINATIONS_PKG;