PACKAGE: APPS.CN_SYIN_ATTR_RULES_PKG

Source

1 PACKAGE CN_SYIN_Attr_Rules_PKG AUTHID CURRENT_USER AS
2 -- $Header: cnsyinhs.pls 120.5 2005/07/08 09:45:10 appldev 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 NOCOPY number,
17                            x_column_name       IN OUT NOCOPY varchar2,
18                            x_user_column_name  IN OUT NOCOPY varchar2,
19                            x_dim_hier_id               number,
20                            x_hier_name         IN OUT NOCOPY varchar2,
21                            x_value_id                  varchar2,
22                            x_hier_value        IN OUT NOCOPY varchar2,
23 			   x_org_id            IN NUMBER) ;
24   --
25   -- Procedure Name
26   --   default_row
27   -- Purpose
28   --
29   -- History
30   --   01/26/94         Tony Lower              Created
31   --
32 PROCEDURE Default_Row (X_rule_id        IN OUT NOCOPY  number);
33 
34 --
35 -- Procedure Name
36 --   Insert_Row
37 -- Purpose
38 --
39 -- History
40 --   26-AUG-98          Ram Kalyanasundaram     Created
41 --
42 PROCEDURE Insert_Row(p_attribute_rule_id        NUMBER,
43 		     p_column_id                NUMBER,
44 		     p_column_value             VARCHAR2,
45 		     p_low_value                VARCHAR2,
46 		     p_high_value               VARCHAR2,
47 		     p_dimension_hierarchy_id   NUMBER,
48 		     p_not_flag                 VARCHAR2,
49 		     p_rule_id                  NUMBER,
50 		     p_ruleset_id               NUMBER,
51 		     p_last_update_date         DATE,
52 		     p_last_updated_by          NUMBER,
53 		     p_creation_date            DATE,
54 		     p_created_by               NUMBER,
55 		     p_last_update_login        NUMBER,
56 		     p_org_id                   NUMBER
57 		     );
58 
59 --
60 -- Procedure Name
61 --   Update_Row
62 -- Purpose
63 --
64 -- History
65 --   26-AUG-98          Ram Kalyanasundaram     Created
66 --
67 PROCEDURE Update_Row(p_attribute_rule_id        NUMBER,
68                      x_object_version_number in out NOCOPY number, --added rckalyan
69 		     p_column_id                NUMBER,
70 		     p_column_value             VARCHAR2,
71 		     p_low_value                VARCHAR2,
72 		     p_high_value               VARCHAR2,
73 		     p_dimension_hierarchy_id   NUMBER,
74 		     p_not_flag                 VARCHAR2,
75 		     p_last_update_date         DATE,
76 		     p_last_updated_by          NUMBER,
77 		     p_last_update_login        NUMBER,
78 		     p_org_id                   NUMBER
79 		     );
80 
81 --
82 -- Procedure Name
83 --   Delete_Row
84 -- Purpose
85 --
86 -- History
87 --   26-AUG-98          Ram Kalyanasundaram     Created
88 --
89 PROCEDURE Delete_Row(p_attribute_rule_id        NUMBER);
90 
91 
92 END CN_SYIN_Attr_Rules_PKG;