1 PACKAGE xla_product_rules_f_pkg AS
2 /* $Header: xlathpdr.pkh 120.16 2005/05/05 23:00:08 wychan ship $ */
3 /*======================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_product_rules |
10 | |
11 | DESCRIPTION |
12 | Forms PL/SQL Wrapper for xla_product_rules |
13 | |
14 | HISTORY |
15 | Generated from XLAUTB. |
16 | |
17 +======================================================================*/
18
19
20
21 PROCEDURE insert_row
22 (x_rowid IN OUT NOCOPY VARCHAR2
23 ,x_application_id IN NUMBER
24 ,x_amb_context_code IN VARCHAR2
25 ,x_product_rule_type_code IN VARCHAR2
26 ,x_product_rule_code IN VARCHAR2
27 ,x_enabled_flag IN VARCHAR2
28 ,x_request_id IN NUMBER
29 ,x_product_rule_version IN VARCHAR2
30 ,x_transaction_coa_id IN NUMBER
31 ,x_accounting_coa_id IN NUMBER
32 ,x_product_rule_hash_id IN NUMBER
33 ,x_compile_status_code IN VARCHAR2
34 ,x_name IN VARCHAR2
35 ,x_description IN VARCHAR2
36 ,x_creation_date IN DATE
37 ,x_created_by IN NUMBER
38 ,x_last_update_date IN DATE
39 ,x_last_updated_by IN NUMBER
40 ,x_last_update_login IN NUMBER);
41
42 PROCEDURE lock_row
43 (x_application_id IN NUMBER
44 ,x_amb_context_code IN VARCHAR2
45 ,x_product_rule_type_code IN VARCHAR2
46 ,x_product_rule_code IN VARCHAR2
47 ,x_enabled_flag IN VARCHAR2
48 ,x_request_id IN NUMBER
49 ,x_product_rule_version IN VARCHAR2
50 ,x_transaction_coa_id IN NUMBER
51 ,x_accounting_coa_id IN NUMBER
52 ,x_product_rule_hash_id IN NUMBER
53 ,x_compile_status_code IN VARCHAR2
54 ,x_name IN VARCHAR2
55 ,x_description IN VARCHAR2);
56
57 PROCEDURE update_row
58 (x_application_id IN NUMBER
59 ,x_amb_context_code IN VARCHAR2
60 ,x_product_rule_type_code IN VARCHAR2
61 ,x_product_rule_code IN VARCHAR2
62 ,x_enabled_flag IN VARCHAR2
63 ,x_request_id IN NUMBER
64 ,x_product_rule_version IN VARCHAR2
65 ,x_transaction_coa_id IN NUMBER
66 ,x_accounting_coa_id IN NUMBER
67 ,x_product_rule_hash_id IN NUMBER
68 ,x_compile_status_code IN VARCHAR2
69 ,x_name IN VARCHAR2
70 ,x_description IN VARCHAR2
71 ,x_last_update_date IN DATE
72 ,x_last_updated_by IN NUMBER
73 ,x_last_update_login IN NUMBER);
74
75 PROCEDURE delete_row
76 (x_application_id IN NUMBER
77 ,x_amb_context_code IN VARCHAR2
78 ,x_product_rule_type_code IN VARCHAR2
79 ,x_product_rule_code IN VARCHAR2);
80
81 PROCEDURE add_language;
82
83 PROCEDURE translate_row
84 (p_application_short_name IN VARCHAR2
85 ,p_amb_context_code IN VARCHAR2
86 ,p_product_rule_type_code IN VARCHAR2
87 ,p_product_rule_code IN VARCHAR2
88 ,p_name IN VARCHAR2
89 ,p_description IN VARCHAR2
90 ,p_owner IN VARCHAR2
91 ,p_last_update_date IN VARCHAR2
92 ,p_custom_mode IN VARCHAR2);
93
94 END xla_product_rules_f_pkg;