APPS.XLA_ANALYTICAL_ASSGNS_F_PKG dependencies on XLA_ANALYTICAL_ASSGNS

Line 1: PACKAGE BODY xla_analytical_assgns_f_pkg AS

1: PACKAGE BODY xla_analytical_assgns_f_pkg AS
2: /* $Header: xlatbanc.pkb 120.4 2003/04/03 22:06:18 dcshah ship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_analytical_assgns_f_pkg |

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

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

8: | PACKAGE NAME |
9: | xla_analytical_assgns_f_pkg |
10: | |
11: | DESCRIPTION |
12: | Forms PL/SQL Wrapper for xla_analytical_assgns |
13: | |
14: | HISTORY |
15: | 05/22/01 Dimple Shah Created |
16: | |

Line 51: FROM xla_analytical_assgns

47: l_analytical_assignment_id number(38);
48:
49: CURSOR c IS
50: SELECT rowid
51: FROM xla_analytical_assgns
52: WHERE analytical_assignment_id = x_analytical_assignment_id
53: ;
54:
55: BEGIN

Line 58: INSERT INTO xla_analytical_assgns

54:
55: BEGIN
56: xla_utility_pkg.trace('> .insert_row' ,20);
57:
58: INSERT INTO xla_analytical_assgns
59: (creation_date
60: ,created_by
61: ,application_id
62: ,amb_context_code

Line 81: ,xla_analytical_assgns_s.nextval

77: (x_creation_date
78: ,x_created_by
79: ,x_application_id
80: ,x_amb_context_code
81: ,xla_analytical_assgns_s.nextval
82: ,x_product_rule_type_code
83: ,x_product_rule_code
84: ,x_entity_code
85: ,x_event_class_code

Line 144: FROM xla_analytical_assgns

140: ,accounting_line_type_code
141: ,accounting_line_code
142: ,analytical_criterion_type_code
143: ,analytical_criterion_code
144: FROM xla_analytical_assgns
145: WHERE analytical_assignment_id = x_analytical_assignment_id
146: FOR UPDATE OF application_id NOWAIT;
147:
148: recinfo c%ROWTYPE;

Line 217: UPDATE xla_analytical_assgns

213: IS
214:
215: BEGIN
216: xla_utility_pkg.trace('> .update_row' ,20);
217: UPDATE xla_analytical_assgns
218: SET
219: last_update_date = x_last_update_date
220: ,analytical_criterion_type_code = x_anal_criterion_type_code
221: ,analytical_criterion_code = x_analytical_criterion_code

Line 245: DELETE FROM xla_analytical_assgns

241: IS
242:
243: BEGIN
244: xla_utility_pkg.trace('> .delete_row' ,20);
245: DELETE FROM xla_analytical_assgns
246: WHERE analytical_assignment_id = x_analytical_assignment_id;
247:
248: IF (SQL%NOTFOUND) THEN
249: RAISE NO_DATA_FOUND;

Line 255: end xla_analytical_assgns_f_pkg;

251:
252: xla_utility_pkg.trace('< .delete_row' ,20);
253: END delete_row;
254:
255: end xla_analytical_assgns_f_pkg;