1 PACKAGE GCS_FORMULA_STATEMENTS_PKG AS
2 /* $Header: gcserfss.pls 120.1 2005/10/30 05:18:18 appldev noship $ */
3 --
4 -- Package
5 -- gcs_formula_statements_pkg
6 -- Purpose
7 -- Package procedures for GCS formula statements table
8 -- History
9 -- 27-APR-04 J Huang Created
10 --
11
12 --
13 -- Procedure
14 -- Insert_Row
15 -- Purpose
16 -- Inserts a row into the gcs_formula_statements table.
17 -- Arguments
18 -- row_id Row ID of the inserted row.
19 -- statement_num Numeric value of the sql statement
20 -- rule_type_code Whether the variable is intended for use
21 -- in A&D or Consolidation, or both, formulas.
22 -- statement_text Sql statement text.
23 -- compiled_variables Comma delimited list of names of bind variables
24 -- used in this sql statement.
25 -- last_update_date Last time the structure was updated.
26 -- last_updated_by User last updating this structure.
27 -- last_update_login Login of person last updating this structure.
28 -- creation_date Time this structure was created.
29 -- created_by User who created this structure.
30 -- Example
31 -- GCS_FORMULA_STATEMENTS_PKG.Insert_Row(...);
32 -- Notes
33 --
34 PROCEDURE Insert_Row( row_id IN OUT NOCOPY VARCHAR2,
35 statement_num VARCHAR2,
36 rule_type_code VARCHAR2,
37 statement_text VARCHAR2,
38 compiled_variables VARCHAR2,
39 last_update_date DATE,
40 last_updated_by NUMBER,
41 last_update_login NUMBER,
42 creation_date DATE,
43 created_by NUMBER);
44
45 --
46 -- Procedure
47 -- Update_Row
48 -- Purpose
49 -- Updates a row in the gcs_formula_statements table.
50 -- Arguments
51 -- statement_num Numeric value of the sql statement
52 -- rule_type_code Whether the variable is intended for use
53 -- in A&D or Consolidation, or both, formulas.
54 -- statement_text Sql statement text.
55 -- compiled_variables Comma delimited list of names of bind variables
56 -- used in this sql statement.
57 -- last_update_date Last time the structure was updated.
58 -- last_updated_by User last updating this structure.
59 -- last_update_login Login of person last updating this structure.
60 -- Example
61 -- GCS_FORMULA_STATEMENTS_PKG.Update_Row(...);
62 -- Notes
63 --
64 PROCEDURE Update_Row( statement_num VARCHAR2,
65 rule_type_code VARCHAR2,
66 statement_text VARCHAR2,
67 compiled_variables VARCHAR2,
68 last_update_date DATE,
69 last_updated_by NUMBER,
70 last_update_login NUMBER);
71
72 --
73 -- Procedure
74 -- Load_Row
75 -- Purpose
76 -- Loads a row into the gcs_formula_statements table.
77 -- Arguments
78 -- statement_num Name of the formual variable
79 -- rule_type_code Whether the variable is intended for use
80 -- in A&D or Consolidation, or both, formulas.
81 -- owner Whether this is custom or seed data.
82 -- last_update_date Last time the structure was updated.
83 -- statement_text Sql statement value assigned to the variable.
84 -- compiled_variables Bind variable name, when applicable.
85 -- Sql expression
86 -- custom_mode Whether or not to force a load.
87 -- Example
88 -- GCS_FORMULA_STATEMENTS_PKG.Load_Row(...);
89 -- Notes
90 --
91 PROCEDURE Load_Row( statement_num VARCHAR2,
92 rule_type_code VARCHAR2,
93 owner VARCHAR2,
94 last_update_date VARCHAR2,
95 statement_text VARCHAR2,
96 compiled_variables VARCHAR2,
97 custom_mode VARCHAR2);
98
99 --
100 -- Procedure
101 -- Translate_Row
102 -- Purpose
103 -- Updates translated infromation for a row in the
104 -- gcs_formula_statements table.
105 -- Arguments
106 -- statement_num Name of the formual variable
107 -- rule_type_code Whether the variable is intended for use
108 -- in A&D or Consolidation, or both, formulas.
109 -- owner Whether this is custom or seed data.
110 -- last_update_date Last time the structure was updated.
111 -- custom_mode Whether or not to force a load.
112 -- Example
113 -- GCS_FORMULA_STATEMENTS_PKG.Translate_Row(...);
114 -- Notes
115 --
116 PROCEDURE Translate_Row( statement_num VARCHAR2,
117 rule_type_code VARCHAR2,
118 owner VARCHAR2,
119 last_update_date VARCHAR2,
120 custom_mode VARCHAR2);
121
122 END GCS_FORMULA_STATEMENTS_PKG;
[Home] [Help]