APPS.XLA_LINE_DEFN_ADR_ASSGNS_F_PVT dependencies on XLA_LINE_DEFN_ADR_ASSGNS

Line 1: PACKAGE BODY xla_line_defn_adr_assgns_f_pvt AS

1: PACKAGE BODY xla_line_defn_adr_assgns_f_pvt AS
2: /* $Header: xlathlad.pkb 120.8 2005/06/14 00:54:30 wychan ship $ */
3:
4: --=============================================================================
5: -- *********** Local Trace Routine **********

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

Line 41: (p_location => 'xla_line_defn_adr_assgns_f_pvt.trace');

37: RAISE;
38:
39: WHEN OTHERS THEN
40: xla_exceptions_pkg.raise_message
41: (p_location => 'xla_line_defn_adr_assgns_f_pvt.trace');
42: END trace;
43:
44:
45:

Line 77: FROM xla_line_defn_adr_assgns

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

Line 103: INSERT INTO xla_line_defn_adr_assgns

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

Line 195: FROM xla_line_defn_adr_assgns

191: ,segment_rule_appl_id
192: ,segment_rule_type_code
193: ,segment_rule_code
194: , side_code
195: FROM xla_line_defn_adr_assgns
196: WHERE application_id = x_application_id
197: AND amb_context_code = x_amb_context_code
198: AND event_class_code = x_event_class_code
199: AND event_type_code = x_event_type_code

Line 297: UPDATE xla_line_defn_adr_assgns

293: p_module => l_log_module,
294: p_level => C_LEVEL_PROCEDURE);
295: END IF;
296:
297: UPDATE xla_line_defn_adr_assgns
298: SET
299: last_update_date = x_last_update_date
300: ,inherit_adr_flag = x_inherit_adr_flag
301: ,segment_rule_appl_id = x_segment_rule_appl_id

Line 362: DELETE FROM xla_line_defn_adr_assgns

358: p_module => l_log_module,
359: p_level => C_LEVEL_PROCEDURE);
360: END IF;
361:
362: DELETE FROM xla_line_defn_adr_assgns
363: WHERE application_id = x_application_id
364: AND amb_context_code = x_amb_context_code
365: AND event_class_code = x_event_class_code
366: AND event_type_code = x_event_type_code

Line 402: END xla_line_defn_adr_assgns_f_pvt;

398: IF NOT g_log_enabled THEN
399: g_log_level := C_LEVEL_LOG_DISABLED;
400: END IF;
401:
402: END xla_line_defn_adr_assgns_f_pvt;