APPS.XLA_AAD_LINE_DEFN_ASSGNS_F_PVT dependencies on XLA_AAD_LINE_DEFN_ASSGNS

Line 1: PACKAGE BODY xla_aad_line_defn_assgns_f_pvt AS

1: PACKAGE BODY xla_aad_line_defn_assgns_f_pvt AS
2: /* $Header: xlathald.pkb 120.2 2005/05/04 06:46:13 ksvenkat ship $ */
3:
4: --=============================================================================
5: -- *********** Local Trace Routine **********

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

Line 37: (p_location => 'xla_aad_line_defn_assgns_f_pvt.trace');

33: RAISE;
34:
35: WHEN OTHERS THEN
36: xla_exceptions_pkg.raise_message
37: (p_location => 'xla_aad_line_defn_assgns_f_pvt.trace');
38: END trace;
39:
40: /*======================================================================+
41: | |

Line 65: FROM xla_aad_line_defn_assgns

61: IS
62:
63: CURSOR c IS
64: SELECT rowid
65: FROM xla_aad_line_defn_assgns
66: WHERE application_id = x_application_id
67: AND amb_context_code = x_amb_context_code
68: AND product_rule_type_code = x_product_rule_type_code
69: AND product_rule_code = x_product_rule_code

Line 89: INSERT INTO xla_aad_line_defn_assgns

85: p_module => l_log_module,
86: p_level => C_LEVEL_PROCEDURE);
87: END IF;
88:
89: INSERT INTO xla_aad_line_defn_assgns
90: (creation_date
91: ,created_by
92: ,application_id
93: ,amb_context_code

Line 168: DELETE FROM xla_aad_line_defn_assgns

164: p_module => l_log_module,
165: p_level => C_LEVEL_PROCEDURE);
166: END IF;
167:
168: DELETE FROM xla_aad_line_defn_assgns
169: WHERE application_id = x_application_id
170: AND amb_context_code = x_amb_context_code
171: AND product_rule_type_code = x_product_rule_type_code
172: AND product_rule_code = x_product_rule_code

Line 206: END xla_aad_line_defn_assgns_f_pvt;

202: IF NOT g_log_enabled THEN
203: g_log_level := C_LEVEL_LOG_DISABLED;
204: END IF;
205:
206: END xla_aad_line_defn_assgns_f_pvt;