APPS.XLA_LINE_DEFN_AC_ASSGNS_F_PVT dependencies on XLA_LINE_DEFN_AC_ASSGNS

Line 1: PACKAGE BODY xla_line_defn_ac_assgns_f_pvt AS

1: PACKAGE BODY xla_line_defn_ac_assgns_f_pvt AS
2: /* $Header: xlathlac.pkb 120.1 2005/04/28 18:45:54 masada ship $ */
3:
4: --=============================================================================
5: -- *********** Local Trace Routine **********

Line 15: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_line_defn_ac_assgns_f_pvt';

11: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
13:
14: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
15: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_line_defn_ac_assgns_f_pvt';
16:
17: g_log_level NUMBER;
18: g_log_enabled BOOLEAN;
19:

Line 40: (p_location => 'xla_line_defn_ac_assgns_f_pvt.trace');

36: RAISE;
37:
38: WHEN OTHERS THEN
39: xla_exceptions_pkg.raise_message
40: (p_location => 'xla_line_defn_ac_assgns_f_pvt.trace');
41: END trace;
42:
43:
44: /*======================================================================+

Line 71: FROM xla_line_defn_ac_assgns

67: IS
68:
69: CURSOR c IS
70: SELECT rowid
71: FROM xla_line_defn_ac_assgns
72: WHERE application_id = x_application_id
73: AND amb_context_code = x_amb_context_code
74: AND event_class_code = x_event_class_code
75: AND event_type_code = x_event_type_code

Line 97: INSERT INTO xla_line_defn_ac_assgns

93: p_module => l_log_module,
94: p_level => C_LEVEL_PROCEDURE);
95: END IF;
96:
97: INSERT INTO xla_line_defn_ac_assgns
98: (creation_date
99: ,created_by
100: ,application_id
101: ,amb_context_code

Line 169: FROM xla_line_defn_ac_assgns

165: ,x_analy_criterion_code IN VARCHAR2)
166: IS
167: CURSOR c IS
168: SELECT *
169: FROM xla_line_defn_ac_assgns
170: WHERE application_id = x_application_id
171: AND amb_context_code = x_amb_context_code
172: AND event_class_code = x_event_class_code
173: AND event_type_code = x_event_type_code

Line 245: DELETE FROM xla_line_defn_ac_assgns

241: p_module => l_log_module,
242: p_level => C_LEVEL_PROCEDURE);
243: END IF;
244:
245: DELETE FROM xla_line_defn_ac_assgns
246: WHERE application_id = x_application_id
247: AND amb_context_code = x_amb_context_code
248: AND event_class_code = x_event_class_code
249: AND event_type_code = x_event_type_code

Line 285: END xla_line_defn_ac_assgns_f_pvt;

281: IF NOT g_log_enabled THEN
282: g_log_level := C_LEVEL_LOG_DISABLED;
283: END IF;
284:
285: END xla_line_defn_ac_assgns_f_pvt;