APPS.GCS_FORMULA_VARIABLES_PKG dependencies on GCS_FORMULA_VARIABLES

Line 1: PACKAGE BODY GCS_FORMULA_VARIABLES_PKG AS

1: PACKAGE BODY GCS_FORMULA_VARIABLES_PKG AS
2: /* $Header: gcserfvb.pls 120.1 2005/10/30 05:18:19 appldev noship $ */
3: --
4: -- Package
5: -- gcs_formula_variables_pkg

Line 5: -- gcs_formula_variables_pkg

1: PACKAGE BODY GCS_FORMULA_VARIABLES_PKG AS
2: /* $Header: gcserfvb.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

Line 25: FROM gcs_formula_variables fv

21: creation_date DATE,
22: created_by NUMBER) IS
23: CURSOR var_row IS
24: SELECT rowid
25: FROM gcs_formula_variables fv
26: WHERE fv.user_variable_name = insert_row.user_variable_name;
27: BEGIN
28: IF user_variable_name IS NULL THEN
29: raise no_data_found;

Line 32: INSERT INTO gcs_formula_variables( user_variable_name,

28: IF user_variable_name IS NULL THEN
29: raise no_data_found;
30: END IF;
31:
32: INSERT INTO gcs_formula_variables( user_variable_name,
33: rule_type_code,
34: sql_statement_value,
35: compiled_variable_name,
36: sql_expression,

Line 55: FROM gcs_formula_variables fv

51: created_by
52: FROM dual
53: WHERE NOT EXISTS
54: (SELECT 1
55: FROM gcs_formula_variables fv
56: WHERE fv.user_variable_name = insert_row.user_variable_name);
57:
58: OPEN var_row;
59: FETCH var_row INTO row_id;

Line 76: UPDATE gcs_formula_variables fv

72: last_update_date DATE,
73: last_updated_by NUMBER,
74: last_update_login NUMBER) IS
75: BEGIN
76: UPDATE gcs_formula_variables fv
77: SET rule_type_code = update_row.rule_type_code,
78: sql_statement_value = update_row.sql_statement_value,
79: compiled_variable_name = update_row.compiled_variable_name,
80: sql_expression = update_row.sql_expression,

Line 112: FROM GCS_FORMULA_VARIABLES fv

108:
109: BEGIN
110: SELECT fv.last_updated_by, fv.last_update_date
111: INTO db_luby, db_ludate
112: FROM GCS_FORMULA_VARIABLES fv
113: WHERE fv.user_variable_name = load_row.user_variable_name;
114:
115: -- Test for customization information
116: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,

Line 160: FROM GCS_FORMULA_VARIABLES fv

156:
157: BEGIN
158: SELECT fv.last_updated_by, fv.last_update_date
159: INTO db_luby, db_ludate
160: FROM GCS_FORMULA_VARIABLES fv
161: WHERE fv.user_variable_name = translate_row.user_variable_name;
162:
163: -- Test for customization information
164: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,

Line 166: UPDATE gcs_formula_variables fv

162:
163: -- Test for customization information
164: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,
165: custom_mode) THEN
166: UPDATE gcs_formula_variables fv
167: SET last_update_date = f_ludate,
168: last_updated_by = f_luby,
169: last_update_login = 0
170: WHERE fv.user_variable_name = translate_row.user_variable_name;

Line 178: END GCS_FORMULA_VARIABLES_PKG;

174: null;
175: END;
176: END Translate_Row;
177:
178: END GCS_FORMULA_VARIABLES_PKG;