APPS.XLA_AAD_HEADER_AC_ASSGNS_F_PVT dependencies on XLA_AAD_HEADER_AC_ASSGNS

Line 1: PACKAGE BODY xla_aad_header_ac_assgns_f_pvt AS

1: PACKAGE BODY xla_aad_header_ac_assgns_f_pvt AS
2: /* $Header: xlathhac.pkb 120.1 2005/04/28 18:45:52 masada ship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_aad_header_ac_assgns_f_pvt |

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

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

8: | PACKAGE NAME |
9: | xla_aad_header_ac_assgns_f_pvt |
10: | |
11: | DESCRIPTION |
12: | Forms PL/SQL Wrapper for xla_aad_header_ac_assgns |
13: | |
14: | HISTORY |
15: | 10/18/04 Wynne Chan Created |
16: | |

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

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_aad_header_ac_assgns_f_pvt';
31:
32: g_log_level NUMBER;
33: g_log_enabled BOOLEAN;
34:

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

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

Line 83: FROM xla_aad_header_ac_assgns

79: IS
80:
81: CURSOR c IS
82: SELECT rowid
83: FROM xla_aad_header_ac_assgns
84: WHERE application_id = x_application_id
85: AND amb_context_code = x_amb_context_code
86: AND event_class_code = x_event_class_code
87: AND event_type_code = x_event_type_code

Line 107: INSERT INTO xla_aad_header_ac_assgns

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

Line 174: FROM xla_aad_header_ac_assgns

170: ,x_analytical_criterion_code IN VARCHAR2)
171: IS
172: CURSOR c IS
173: SELECT *
174: FROM xla_aad_header_ac_assgns
175: WHERE application_id = x_application_id
176: AND amb_context_code = x_amb_context_code
177: AND product_rule_type_code = x_product_rule_type_code
178: AND product_rule_code = x_product_rule_code

Line 247: DELETE FROM xla_aad_header_ac_assgns

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

Line 287: end xla_aad_header_ac_assgns_f_pvt;

283: IF NOT g_log_enabled THEN
284: g_log_level := C_LEVEL_LOG_DISABLED;
285: END IF;
286:
287: end xla_aad_header_ac_assgns_f_pvt;