APPS.XLA_PROD_ACCT_LINES_F_PKG dependencies on XLA_PROD_ACCT_LINES

Line 1: PACKAGE BODY xla_prod_acct_lines_f_pkg AS

1: PACKAGE BODY xla_prod_acct_lines_f_pkg AS
2: /* $Header: xlatbpal.pkb 120.8 2003/03/18 00:43:33 dcshah ship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_prod_acct_lines_f_pkg |

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

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

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

Line 49: FROM xla_prod_acct_lines

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

Line 64: INSERT INTO xla_prod_acct_lines

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

Line 149: FROM xla_prod_acct_lines

145: ,accounting_line_code
146: ,description_type_code
147: ,description_code
148: ,active_flag
149: FROM xla_prod_acct_lines
150: WHERE application_id = x_application_id
151: AND amb_context_code = x_amb_context_code
152: AND product_rule_type_code = x_product_rule_type_code
153: AND product_rule_code = x_product_rule_code

Line 231: UPDATE xla_prod_acct_lines

227: IS
228:
229: BEGIN
230: xla_utility_pkg.trace('> .update_row' ,20);
231: UPDATE xla_prod_acct_lines
232: SET
233: last_update_date = x_last_update_date
234: ,description_type_code = x_description_type_code
235: ,description_code = x_description_code

Line 276: DELETE FROM xla_prod_acct_lines

272: IS
273:
274: BEGIN
275: xla_utility_pkg.trace('> .delete_row' ,20);
276: DELETE FROM xla_prod_acct_lines
277: WHERE application_id = x_application_id
278: AND amb_context_code = x_amb_context_code
279: AND product_rule_type_code = x_product_rule_type_code
280: AND product_rule_code = x_product_rule_code

Line 294: end xla_prod_acct_lines_f_pkg;

290:
291: xla_utility_pkg.trace('< .delete_row' ,20);
292: END delete_row;
293:
294: end xla_prod_acct_lines_f_pkg;