APPS.XLA_LINE_DEFN_JLT_ASSGNS_F_PVT dependencies on XLA_LINE_DEFN_JLT_ASSGNS

Line 1: PACKAGE BODY xla_line_defn_jlt_assgns_f_pvt AS

1: PACKAGE BODY xla_line_defn_jlt_assgns_f_pvt AS
2: /* $Header: xlathljl.pkb 120.5 2005/07/06 20:48:25 eklau ship $ */
3:
4: --=============================================================================
5: -- *********** Local Trace Routine **********

Line 15: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_line_defn_jlt_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_jlt_assgns_f_pvt';
16:
17: g_log_level NUMBER;
18: g_log_enabled BOOLEAN;
19:

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

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

Line 78: FROM xla_line_defn_jlt_assgns

74: IS
75:
76: CURSOR c IS
77: SELECT rowid
78: FROM xla_line_defn_jlt_assgns
79: WHERE application_id = x_application_id
80: AND amb_context_code = x_amb_context_code
81: AND event_class_code = x_event_class_code
82: AND event_type_code = x_event_type_code

Line 102: INSERT INTO xla_line_defn_jlt_assgns

98: p_module => l_log_module,
99: p_level => C_LEVEL_PROCEDURE);
100: END IF;
101:
102: INSERT INTO xla_line_defn_jlt_assgns
103: (creation_date
104: ,created_by
105: ,application_id
106: ,amb_context_code

Line 205: FROM xla_line_defn_jlt_assgns

201: ,mpa_header_desc_type_code
202: ,mpa_num_je_code
203: ,mpa_gl_dates_code
204: ,mpa_proration_code
205: FROM xla_line_defn_jlt_assgns
206: WHERE application_id = x_application_id
207: AND amb_context_code = x_amb_context_code
208: AND event_class_code = x_event_class_code
209: AND event_type_code = x_event_type_code

Line 320: UPDATE xla_line_defn_jlt_assgns

316: p_module => l_log_module,
317: p_level => C_LEVEL_PROCEDURE);
318: END IF;
319:
320: UPDATE xla_line_defn_jlt_assgns
321: SET
322: last_update_date = x_last_update_date
323: ,description_type_code = x_description_type_code
324: ,description_code = x_description_code

Line 386: DELETE FROM xla_line_defn_jlt_assgns

382: p_module => l_log_module,
383: p_level => C_LEVEL_PROCEDURE);
384: END IF;
385:
386: DELETE FROM xla_line_defn_jlt_assgns
387: WHERE application_id = x_application_id
388: AND amb_context_code = x_amb_context_code
389: AND event_class_code = x_event_class_code
390: AND event_type_code = x_event_type_code

Line 424: END xla_line_defn_jlt_assgns_f_pvt;

420: IF NOT g_log_enabled THEN
421: g_log_level := C_LEVEL_LOG_DISABLED;
422: END IF;
423:
424: END xla_line_defn_jlt_assgns_f_pvt;