DBA Data[Home] [Help]

APPS.XLA_EVT_CLASS_ACCT_ATTRS_F_PKG dependencies on XLA_EVT_CLASS_ACCT_ATTRS

Line 1: PACKAGE BODY xla_evt_class_acct_attrs_f_pkg AS

1: PACKAGE BODY xla_evt_class_acct_attrs_f_pkg AS
2: /* $Header: xlatbaaa.pkb 120.2.12000000.2 2007/04/27 18:28:25 svellani ship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_evt_class_acct_attrs |

5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +=======================================================================+
8: | PACKAGE NAME |
9: | xla_evt_class_acct_attrs |
10: | |
11: | DESCRIPTION |
12: | Forms PL/SQL Wrapper for xla_evt_class_acct_attrs |
13: | |

Line 12: | Forms PL/SQL Wrapper for xla_evt_class_acct_attrs |

8: | PACKAGE NAME |
9: | xla_evt_class_acct_attrs |
10: | |
11: | DESCRIPTION |
12: | Forms PL/SQL Wrapper for xla_evt_class_acct_attrs |
13: | |
14: | HISTORY |
15: | 05/22/01 Dimple Shah Created |
16: | |

Line 30: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_evt_class_acct_attrs_f_pkg';

26: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
27: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
28:
29: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
30: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_evt_class_acct_attrs_f_pkg';
31:
32: g_log_level NUMBER;
33: g_log_enabled BOOLEAN;
34:

Line 55: (p_location => 'xla_evt_class_acct_attrs_f_pkg.trace');

51: RAISE;
52:
53: WHEN OTHERS THEN
54: xla_exceptions_pkg.raise_message
55: (p_location => 'xla_evt_class_acct_attrs_f_pkg.trace');
56: END trace;
57:
58:
59:

Line 85: FROM xla_evt_class_acct_attrs

81: IS
82:
83: CURSOR c IS
84: SELECT rowid
85: FROM xla_evt_class_acct_attrs
86: WHERE application_id = x_application_id
87: AND event_class_code = x_event_class_code
88: AND accounting_attribute_code = x_accounting_attribute_code
89: AND source_application_id = x_source_application_id

Line 107: INSERT INTO xla_evt_class_acct_attrs

103: p_module => l_log_module,
104: p_level => C_LEVEL_PROCEDURE);
105: END IF;
106:
107: INSERT INTO xla_evt_class_acct_attrs
108: (creation_date
109: ,created_by
110: ,application_id
111: ,event_class_code

Line 181: FROM xla_evt_class_acct_attrs

177: ,source_code
178: ,assignment_owner_code
179: ,default_flag
180: ,accounting_attribute_code
181: FROM xla_evt_class_acct_attrs
182: WHERE application_id = x_application_id
183: AND event_class_code = x_event_class_code
184: AND accounting_attribute_code = x_accounting_attribute_code
185: AND source_application_id = x_source_application_id

Line 273: UPDATE xla_evt_class_acct_attrs

269: p_module => l_log_module,
270: p_level => C_LEVEL_PROCEDURE);
271: END IF;
272:
273: UPDATE xla_evt_class_acct_attrs
274: SET
275: last_update_date = x_last_update_date
276: ,default_flag = x_default_flag
277: ,last_updated_by = x_last_updated_by

Line 326: DELETE FROM xla_evt_class_acct_attrs

322: p_module => l_log_module,
323: p_level => C_LEVEL_PROCEDURE);
324: END IF;
325:
326: DELETE FROM xla_evt_class_acct_attrs
327: WHERE application_id = x_application_id
328: AND event_class_code = x_event_class_code
329: AND accounting_attribute_code = x_accounting_attribute_code
330: AND source_application_id = x_source_application_id

Line 414: DELETE FROM xla_evt_class_acct_attrs

410: FROM xla_acct_attributes_b
411: WHERE accounting_attribute_code = p_accounting_attribute_code;
412:
413: IF l_assign_level_code = 'EVT_CLASS_ONLY' THEN
414: DELETE FROM xla_evt_class_acct_attrs
415: WHERE application_id = l_application_id
416: AND event_class_code = p_event_class_code
417: AND accounting_attribute_code = p_accounting_attribute_code
418: AND source_application_id = l_source_app_id

Line 430: FROM xla_evt_class_acct_attrs

426:
427:
428: SELECT last_updated_by, last_update_date
429: INTO db_luby, db_ludate
430: FROM xla_evt_class_acct_attrs
431: WHERE application_id = l_application_id
432: AND event_class_code = p_event_class_code
433: AND accounting_attribute_code = p_accounting_attribute_code
434: AND source_application_id = l_source_app_id

Line 439: xla_evt_class_acct_attrs_f_pkg.update_row

435: AND source_type_code = p_source_type_code
436: AND source_code = p_source_code;
437:
438: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, NULL)) THEN
439: xla_evt_class_acct_attrs_f_pkg.update_row
440: (x_rowid => l_rowid
441: ,x_application_id => l_application_id
442: ,x_event_class_code => p_event_class_code
443: ,x_accounting_attribute_code => p_accounting_attribute_code

Line 457: xla_evt_class_acct_attrs_f_pkg.insert_row

453: END IF;
454:
455: EXCEPTION
456: WHEN NO_DATA_FOUND THEN
457: xla_evt_class_acct_attrs_f_pkg.insert_row
458: (x_rowid => l_rowid
459: ,x_application_id => l_application_id
460: ,x_event_class_code => p_event_class_code
461: ,x_accounting_attribute_code => p_accounting_attribute_code

Line 485: (p_location => 'xla_evt_class_acct_attrs_f_pkg.load_row');

481: WHEN NO_DATA_FOUND THEN
482: null;
483: WHEN OTHERS THEN
484: xla_exceptions_pkg.raise_message
485: (p_location => 'xla_evt_class_acct_attrs_f_pkg.load_row');
486:
487: END load_row;
488:
489:

Line 490: end xla_evt_class_acct_attrs_f_PKG;

486:
487: END load_row;
488:
489:
490: end xla_evt_class_acct_attrs_f_PKG;