APPS.XLA_PROD_SEG_RULES_F_PKG dependencies on XLA_PROD_SEG_RULES

Line 1: PACKAGE BODY xla_prod_seg_rules_f_pkg AS

1: PACKAGE BODY xla_prod_seg_rules_f_pkg AS
2: /* $Header: xlatbasr.pkb 120.5 2003/03/18 00:42:57 dcshah ship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_prod_seg_rules_f_pkg |

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

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

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

Line 50: FROM xla_prod_seg_rules

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

Line 66: INSERT INTO xla_prod_seg_rules

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

Line 151: FROM xla_prod_seg_rules

147: ,accounting_line_code
148: ,flexfield_segment_code
149: ,segment_rule_type_code
150: ,segment_rule_code
151: FROM xla_prod_seg_rules
152: WHERE application_id = x_application_id
153: AND amb_context_code = x_amb_context_code
154: AND product_rule_type_code = x_product_rule_type_code
155: AND product_rule_code = x_product_rule_code

Line 229: UPDATE xla_prod_seg_rules

225: IS
226:
227: BEGIN
228: xla_utility_pkg.trace('> .update_row' ,20);
229: UPDATE xla_prod_seg_rules
230: SET
231: last_update_date = x_last_update_date
232: ,segment_rule_type_code = x_segment_rule_type_code
233: ,segment_rule_code = x_segment_rule_code

Line 275: DELETE FROM xla_prod_seg_rules

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

Line 294: end xla_prod_seg_rules_f_pkg;

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