APPS.XLA_PROD_ACCT_HEADERS_F_PKG dependencies on XLA_PROD_ACCT_HEADERS

Line 1: PACKAGE BODY xla_prod_acct_headers_f_pkg AS

1: PACKAGE BODY xla_prod_acct_headers_f_pkg AS
2: /* $Header: xlatbpah.pkb 120.8 2004/11/20 01:13:36 wychan ship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_prod_acct_headers_f_pkg |

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

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

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

Line 51: FROM xla_prod_acct_headers

47: IS
48:
49: CURSOR c IS
50: SELECT rowid
51: FROM xla_prod_acct_headers
52: WHERE application_id = x_application_id
53: AND amb_context_code = x_amb_context_code
54: AND product_rule_type_code = x_product_rule_type_code
55: AND product_rule_code = x_product_rule_code

Line 64: INSERT INTO xla_prod_acct_headers

60:
61: BEGIN
62: xla_utility_pkg.trace('> .insert_row' ,20);
63:
64: INSERT INTO xla_prod_acct_headers
65: (creation_date
66: ,created_by
67: ,application_id
68: ,amb_context_code

Line 145: FROM xla_prod_acct_headers

141: ,event_type_code
142: ,validation_status_code
143: ,accounting_required_flag
144: ,locking_status_flag
145: FROM xla_prod_acct_headers
146: WHERE application_id = x_application_id
147: AND amb_context_code = x_amb_context_code
148: AND product_rule_type_code = x_product_rule_type_code
149: AND product_rule_code = x_product_rule_code

Line 216: UPDATE xla_prod_acct_headers

212: IS
213:
214: BEGIN
215: xla_utility_pkg.trace('> .update_row' ,20);
216: UPDATE xla_prod_acct_headers
217: SET
218: last_update_date = x_last_update_date
219: ,validation_status_code = x_validation_status_code
220: ,accounting_required_flag = x_accounting_required_flag

Line 262: UPDATE xla_prod_acct_headers

258: IS
259:
260: BEGIN
261: xla_utility_pkg.trace('> .update_row' ,20);
262: UPDATE xla_prod_acct_headers
263: SET
264: last_update_date = x_last_update_date
265: ,description_type_code = x_description_type_code
266: ,description_code = x_description_code

Line 302: DELETE FROM xla_prod_acct_headers

298: IS
299:
300: BEGIN
301: xla_utility_pkg.trace('> .delete_row' ,20);
302: DELETE FROM xla_prod_acct_headers
303: WHERE application_id = x_application_id
304: AND amb_context_code = x_amb_context_code
305: AND product_rule_type_code = x_product_rule_type_code
306: AND product_rule_code = x_product_rule_code

Line 348: FROM xla_prod_acct_headers

344: ,event_class_code
345: ,event_type_code
346: ,description_type_code
347: ,description_code
348: FROM xla_prod_acct_headers
349: WHERE application_id = x_application_id
350: AND amb_context_code = x_amb_context_code
351: AND product_rule_type_code = x_product_rule_type_code
352: AND product_rule_code = x_product_rule_code

Line 399: end xla_prod_acct_headers_f_pkg;

395:
396: END lock_row;
397:
398:
399: end xla_prod_acct_headers_f_pkg;