APPS.GCS_FORMULA_STATEMENTS_PKG dependencies on GCS_FORMULA_STATEMENTS

Line 1: PACKAGE BODY GCS_FORMULA_STATEMENTS_PKG AS

1: PACKAGE BODY GCS_FORMULA_STATEMENTS_PKG AS
2: /* $Header: gcserfsb.pls 120.1 2005/10/30 05:18:15 appldev noship $ */
3: --
4: -- Package
5: -- gcs_formula_statements_pkg

Line 5: -- gcs_formula_statements_pkg

1: PACKAGE BODY GCS_FORMULA_STATEMENTS_PKG AS
2: /* $Header: gcserfsb.pls 120.1 2005/10/30 05:18:15 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

Line 7: -- Package procedures for GCS formula statements table

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:

Line 24: FROM gcs_formula_statements fs

20: creation_date DATE,
21: created_by NUMBER) IS
22: CURSOR var_row IS
23: SELECT rowid
24: FROM gcs_formula_statements fs
25: WHERE fs.statement_num = insert_row.statement_num
26: AND fs.rule_type_code = insert_row.rule_type_code;
27:
28: BEGIN

Line 35: INSERT INTO gcs_formula_statements( statement_num,

31: ELSIF rule_type_code IS NULL THEN
32: raise no_data_found;
33: END IF;
34:
35: INSERT INTO gcs_formula_statements( statement_num,
36: rule_type_code,
37: statement_text,
38: compiled_variables,
39: last_update_date,

Line 56: FROM gcs_formula_statements fs

52: created_by
53: FROM dual
54: WHERE NOT EXISTS
55: (SELECT 1
56: FROM gcs_formula_statements fs
57: WHERE fs.statement_num = insert_row.statement_num
58: AND fs.rule_type_code = insert_row.rule_type_code);
59:
60: OPEN var_row;

Line 77: UPDATE gcs_formula_statements fs

73: last_update_date DATE,
74: last_updated_by NUMBER,
75: last_update_login NUMBER) IS
76: BEGIN
77: UPDATE gcs_formula_statements fs
78: SET rule_type_code = update_row.rule_type_code,
79: statement_text = update_row.statement_text,
80: compiled_variables = update_row.compiled_variables,
81: last_update_date = update_row.last_update_date,

Line 112: FROM GCS_FORMULA_STATEMENTS fs

108:
109: BEGIN
110: SELECT fs.last_updated_by, fs.last_update_date
111: INTO db_luby, db_ludate
112: FROM GCS_FORMULA_STATEMENTS fs
113: WHERE fs.statement_num = load_row.statement_num
114: AND fs.rule_type_code = load_row.rule_type_code;
115:
116: -- Test for customization information

Line 159: FROM GCS_FORMULA_STATEMENTS fs

155:
156: BEGIN
157: SELECT fs.last_updated_by, fs.last_update_date
158: INTO db_luby, db_ludate
159: FROM GCS_FORMULA_STATEMENTS fs
160: WHERE fs.statement_num = translate_row.statement_num
161: AND fs.rule_type_code = translate_row.rule_type_code;
162:
163: -- Test for customization information

Line 166: UPDATE gcs_formula_statements fs

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_statements fs
167: SET last_update_date = f_ludate,
168: last_updated_by = f_luby,
169: last_update_login = 0
170: WHERE fs.statement_num = translate_row.statement_num

Line 179: END GCS_FORMULA_STATEMENTS_PKG;

175: null;
176: END;
177: END Translate_Row;
178:
179: END GCS_FORMULA_STATEMENTS_PKG;