APPS.GCS_LEX_MAP_COLUMNS_PKG dependencies on GCS_LEX_MAP_COLUMNS

Line 1: PACKAGE BODY GCS_LEX_MAP_COLUMNS_PKG AS

1: PACKAGE BODY GCS_LEX_MAP_COLUMNS_PKG AS
2: /* $Header: gcslxmcb.pls 115.2 2003/08/13 17:55:00 mikeward noship $ */
3: --
4: -- Package
5: -- gcs_lex_map_structs_pkg

Line 25: FROM gcs_lex_map_columns mc

21: creation_date DATE,
22: created_by NUMBER) IS
23: CURSOR column_row IS
24: SELECT rowid
25: FROM gcs_lex_map_columns mc
26: WHERE mc.structure_id = insert_row.structure_id
27: AND mc.column_name = insert_row.column_name;
28: BEGIN
29: IF structure_id IS NULL OR column_name IS NULL THEN

Line 33: INSERT INTO gcs_lex_map_columns( column_id,

29: IF structure_id IS NULL OR column_name IS NULL THEN
30: raise no_data_found;
31: END IF;
32:
33: INSERT INTO gcs_lex_map_columns( column_id,
34: structure_id,
35: column_name,
36: column_type_code,
37: write_flag,

Line 44: SELECT gcs_lex_map_columns_s.nextval,

40: last_updated_by,
41: last_update_login,
42: creation_date,
43: created_by)
44: SELECT gcs_lex_map_columns_s.nextval,
45: structure_id,
46: column_name,
47: column_type_code,
48: write_flag,

Line 58: FROM gcs_lex_map_columns mc

54: created_by
55: FROM dual
56: WHERE NOT EXISTS
57: (SELECT 1
58: FROM gcs_lex_map_columns mc
59: WHERE mc.structure_id = insert_row.structure_id
60: AND mc.column_name = insert_row.column_name);
61:
62: OPEN column_row;

Line 80: UPDATE gcs_lex_map_columns mc

76: last_update_date DATE,
77: last_updated_by NUMBER,
78: last_update_login NUMBER) IS
79: BEGIN
80: UPDATE gcs_lex_map_columns mc
81: SET column_type_code = update_row.column_type_code,
82: write_flag = update_row.write_flag,
83: error_code_column_flag = update_row.error_code_column_flag,
84: last_update_date = update_row.last_update_date,

Line 123: FROM GCS_LEX_MAP_COLUMNS mc

119:
120: BEGIN
121: SELECT mc.last_updated_by, mc.last_update_date
122: INTO db_luby, db_ludate
123: FROM GCS_LEX_MAP_COLUMNS mc
124: WHERE mc.structure_id = struct_id
125: AND mc.column_name = load_row.column_name;
126:
127: -- Test for customization information

Line 179: FROM GCS_LEX_MAP_COLUMNS mc

175:
176: BEGIN
177: SELECT mc.last_updated_by, mc.last_update_date
178: INTO db_luby, db_ludate
179: FROM GCS_LEX_MAP_COLUMNS mc
180: WHERE mc.structure_id = struct_id
181: AND mc.column_name = translate_row.column_name;
182:
183: -- Test for customization information

Line 186: UPDATE gcs_lex_map_columns mc

182:
183: -- Test for customization information
184: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,
185: custom_mode) THEN
186: UPDATE gcs_lex_map_columns mc
187: SET last_update_date = f_ludate,
188: last_updated_by = f_luby,
189: last_update_login = 0
190: WHERE mc.structure_id = struct_id

Line 199: END GCS_LEX_MAP_COLUMNS_PKG;

195: null;
196: END;
197: END Translate_Row;
198:
199: END GCS_LEX_MAP_COLUMNS_PKG;