1 PACKAGE GCS_FORMULA_VARIABLES_PKG AS
2 /* $Header: gcserfvs.pls 120.1 2005/10/30 05:18:19 appldev noship $ */
3 --
4 -- Package
5 -- gcs_formula_variables_pkg
6 -- Purpose
7 -- Package procedures for Lexical Mapping Structures
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_lex_map_structs table.
17 -- Arguments
18 -- row_id Row ID of the inserted row.
19 -- user_variable_name Name of the formual variable
20 -- rule_type_code Whether the variable is intended for use
21 -- in A&D or Consolidation, or both, formulas.
22 -- sql_statement_value Sql statement value assigned to the variable.
23 -- compiled_variable_name Bind variable name, when applicable.
24 -- sql_expression Sql expression
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_VARIABLES_PKG.Insert_Row(...);
32 -- Notes
33 --
34 PROCEDURE Insert_Row( row_id IN OUT NOCOPY VARCHAR2,
35 user_variable_name VARCHAR2,
36 rule_type_code VARCHAR2,
37 sql_statement_value NUMBER,
38 compiled_variable_name VARCHAR2,
39 sql_expression VARCHAR2,
40 last_update_date DATE,
41 last_updated_by NUMBER,
42 last_update_login NUMBER,
43 creation_date DATE,
44 created_by NUMBER);
45
46 --
47 -- Procedure
48 -- Update_Row
49 -- Purpose
50 -- Updates a row in the gcs_formula_variables table.
51 -- Arguments
52 -- user_variable_name Name of the formual variable
53 -- rule_type_code Whether the variable is intended for use
54 -- in A&D or Consolidation, or both, formulas.
55 -- sql_statement_value Sql statement value assigned to the variable.
56 -- compiled_variable_name Bind variable name, when applicable.
57 -- sql_expression Sql expression
58 -- last_update_date Last time the structure was updated.
59 -- last_updated_by User last updating this structure.
60 -- last_update_login Login of person last updating this structure.
61 -- Example
62 -- GCS_FORMULA_VARIABLES_PKG.Update_Row(...);
63 -- Notes
64 --
65 PROCEDURE Update_Row( user_variable_name VARCHAR2,
66 rule_type_code VARCHAR2,
67 sql_statement_value NUMBER,
68 compiled_variable_name VARCHAR2,
69 sql_expression VARCHAR2,
70 last_update_date DATE,
71 last_updated_by NUMBER,
72 last_update_login NUMBER);
73
74 --
75 -- Procedure
76 -- Load_Row
77 -- Purpose
78 -- Loads a row into the gcs_formula_variables table.
79 -- Arguments
80 -- user_variable_name Name of the formual variable
81 -- owner Whether this is custom or seed data.
82 -- last_update_date Last time the structure was updated.
83 -- rule_type_code Whether the variable is intended for use
84 -- in A&D or Consolidation, or both, formulas.
85 -- sql_statement_value Sql statement value assigned to the variable.
86 -- compiled_variable_name Bind variable name, when applicable.
87 -- sql_expression Sql expression
88 -- custom_mode Whether or not to force a load.
89 -- Example
90 -- GCS_FORMULA_VARIABLES_PKG.Load_Row(...);
91 -- Notes
92 --
93 PROCEDURE Load_Row( user_variable_name VARCHAR2,
94 owner VARCHAR2,
95 last_update_date VARCHAR2,
96 rule_type_code VARCHAR2,
97 sql_statement_value NUMBER,
98 compiled_variable_name VARCHAR2,
99 sql_expression VARCHAR2,
100 custom_mode VARCHAR2);
101
102 --
103 -- Procedure
104 -- Translate_Row
105 -- Purpose
106 -- Updates translated infromation for a row in the
107 -- gcs_formula_variables table.
108 -- Arguments
109 -- structure_name Name of the structure.
110 -- owner Whether this is custom or seed data.
111 -- last_update_date Last time the structure was updated.
112 -- custom_mode Whether or not to force a load.
113 -- Example
114 -- GCS_FORMULA_VARIABLES_PKG.Translate_Row(...);
115 -- Notes
116 --
117 PROCEDURE Translate_Row( user_variable_name VARCHAR2,
118 rule_type_code VARCHAR2,
119 owner VARCHAR2,
120 last_update_date VARCHAR2,
121 custom_mode VARCHAR2);
122
123 END GCS_FORMULA_VARIABLES_PKG;