APPS.XLA_ACCTG_METHOD_RULES_F_PKG dependencies on XLA_ACCTG_METHOD_RULES

Line 1: PACKAGE BODY xla_acctg_method_rules_f_pkg AS

1: PACKAGE BODY xla_acctg_method_rules_f_pkg AS
2: /* $Header: xlatbsap.pkb 120.6 2003/04/19 00:32:52 dcshah ship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_acctg_method_rules_f_pkg |

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

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

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

Line 46: FROM xla_acctg_method_rules

42: IS
43:
44: CURSOR c IS
45: SELECT rowid
46: FROM xla_acctg_method_rules
47: WHERE acctg_method_rule_id = x_acctg_method_rule_id;
48:
49: BEGIN
50: xla_utility_pkg.trace('> .insert_row' ,20);

Line 52: INSERT INTO xla_acctg_method_rules

48:
49: BEGIN
50: xla_utility_pkg.trace('> .insert_row' ,20);
51:
52: INSERT INTO xla_acctg_method_rules
53: (creation_date
54: ,created_by
55: ,accounting_method_type_code
56: ,accounting_method_code

Line 72: ,xla_acctg_method_rules_s.nextval

68: (x_creation_date
69: ,x_created_by
70: ,x_accounting_method_type_code
71: ,x_accounting_method_code
72: ,xla_acctg_method_rules_s.nextval
73: ,x_amb_context_code
74: ,x_application_id
75: ,x_product_rule_type_code
76: ,x_product_rule_code

Line 125: FROM xla_acctg_method_rules

121: ,product_rule_type_code
122: ,product_rule_code
123: ,start_date_active
124: ,end_date_active
125: FROM xla_acctg_method_rules
126: WHERE acctg_method_rule_id = x_acctg_method_rule_id
127: FOR UPDATE OF accounting_method_type_code NOWAIT;
128:
129: recinfo c%ROWTYPE;

Line 190: UPDATE xla_acctg_method_rules

186: IS
187:
188: BEGIN
189: xla_utility_pkg.trace('> .update_row' ,20);
190: UPDATE xla_acctg_method_rules
191: SET
192: product_rule_type_code = x_product_rule_type_code
193: ,product_rule_code = x_product_rule_code
194: ,last_update_date = x_last_update_date

Line 220: DELETE FROM xla_acctg_method_rules

216: IS
217:
218: BEGIN
219: xla_utility_pkg.trace('> .delete_row' ,20);
220: DELETE FROM xla_acctg_method_rules
221: WHERE acctg_method_rule_id = x_acctg_method_rule_id;
222:
223: IF (SQL%NOTFOUND) THEN
224: RAISE NO_DATA_FOUND;

Line 230: end xla_acctg_method_rules_f_pkg;

226:
227: xla_utility_pkg.trace('< .delete_row' ,20);
228: END delete_row;
229:
230: end xla_acctg_method_rules_f_pkg;