PACKAGE: APPS.CNSYIN_ATTR_RULES_PKG

Source

1 PACKAGE CNSYIN_Attr_Rules_PKG AUTHID CURRENT_USER AS
2 -- $Header: cnsyinhs.pls 115.9 2002/02/05 00:25:32 pkm ship    $
3 
4 
5   --
6   -- Procedure Name
7   --   populate_fields
8   -- Purpose
9   --
10   -- History
11   --   01/26/94         Tony Lower              Created
12   --   07-18-95         Amy Erickson            Updated
13   --
14 
15 PROCEDURE Populate_Fields (x_column_id                 number,
16                            x_dimension_id      IN OUT  number,
17                            x_column_name       IN OUT  varchar2,
18                            x_user_column_name  IN OUT  varchar2,
19                            x_dim_hier_id               number,
20                            x_hier_name         IN OUT  varchar2,
21                            x_value_id                  varchar2,
22                            x_hier_value        IN OUT  varchar2) ;
23   --
24   -- Procedure Name
25   --   default_row
26   -- Purpose
27   --
28   -- History
29   --   01/26/94         Tony Lower              Created
30   --
31 PROCEDURE Default_Row (X_rule_id        IN OUT  number);
32 
33 --
34 -- Procedure Name
35 --   Insert_Row
36 -- Purpose
37 --
38 -- History
39 --   26-AUG-98          Ram Kalyanasundaram     Created
40 --
41 PROCEDURE Insert_Row(p_attribute_rule_id        NUMBER,
42 		     p_column_id                NUMBER,
43 		     p_column_value             VARCHAR2,
44 		     p_low_value                VARCHAR2,
45 		     p_high_value               VARCHAR2,
46 		     p_dimension_hierarchy_id   NUMBER,
47 		     p_not_flag                 VARCHAR2,
48 		     p_rule_id                  NUMBER,
49 		     p_ruleset_id               NUMBER,
50 		     p_last_update_date         DATE,
51 		     p_last_updated_by          NUMBER,
52 		     p_creation_date            DATE,
53 		     p_created_by               NUMBER,
54 		     p_last_update_login        NUMBER
55 		     );
56 
57 --
58 -- Procedure Name
59 --   Update_Row
60 -- Purpose
61 --
62 -- History
63 --   26-AUG-98          Ram Kalyanasundaram     Created
64 --
65 PROCEDURE Update_Row(p_attribute_rule_id        NUMBER,
66                      p_object_version_number    number, --added rckalyan
67 		     p_column_id                NUMBER,
68 		     p_column_value             VARCHAR2,
69 		     p_low_value                VARCHAR2,
70 		     p_high_value               VARCHAR2,
71 		     p_dimension_hierarchy_id   NUMBER,
72 		     p_not_flag                 VARCHAR2,
73 		     p_last_update_date         DATE,
74 		     p_last_updated_by          NUMBER,
75 		     p_last_update_login        NUMBER
76 		     );
77 
78 --
79 -- Procedure Name
80 --   Delete_Row
81 -- Purpose
82 --
83 -- History
84 --   26-AUG-98          Ram Kalyanasundaram     Created
85 --
86 PROCEDURE Delete_Row(p_attribute_rule_id        NUMBER);
87 
88 
89 END CNSYIN_Attr_Rules_PKG;