APPS.GCS_LEX_MAP_STRUCTS_PKG dependencies on GCS_LEX_MAP_STRUCTS

Line 1: PACKAGE BODY GCS_LEX_MAP_STRUCTS_PKG AS

1: PACKAGE BODY GCS_LEX_MAP_STRUCTS_PKG AS
2: /* $Header: gcslxmsb.pls 115.2 2003/08/13 17:54:49 mikeward noship $ */
3: --
4: -- Package
5: -- gcs_lex_map_structs_pkg

Line 5: -- gcs_lex_map_structs_pkg

1: PACKAGE BODY GCS_LEX_MAP_STRUCTS_PKG AS
2: /* $Header: gcslxmsb.pls 115.2 2003/08/13 17:54:49 mikeward noship $ */
3: --
4: -- Package
5: -- gcs_lex_map_structs_pkg
6: -- Purpose
7: -- Package procedures for Lexical Mapping Structures
8: -- History
9: -- 23-JUN-03 M Ward Created

Line 24: FROM gcs_lex_map_structs ms

20: creation_date DATE,
21: created_by NUMBER) IS
22: CURSOR struct_row IS
23: SELECT rowid
24: FROM gcs_lex_map_structs ms
25: WHERE ms.structure_name = insert_row.structure_name;
26: BEGIN
27: IF structure_name IS NULL THEN
28: raise no_data_found;

Line 31: INSERT INTO gcs_lex_map_structs( structure_id,

27: IF structure_name IS NULL THEN
28: raise no_data_found;
29: END IF;
30:
31: INSERT INTO gcs_lex_map_structs( structure_id,
32: structure_name,
33: description,
34: table_use_type_code,
35: last_update_date,

Line 40: SELECT gcs_lex_map_structs_s.nextval,

36: last_updated_by,
37: last_update_login,
38: creation_date,
39: created_by)
40: SELECT gcs_lex_map_structs_s.nextval,
41: structure_name,
42: description,
43: table_use_type_code,
44: last_update_date,

Line 52: FROM gcs_lex_map_structs ms

48: created_by
49: FROM dual
50: WHERE NOT EXISTS
51: (SELECT 1
52: FROM gcs_lex_map_structs ms
53: WHERE ms.structure_name = insert_row.structure_name);
54:
55: OPEN struct_row;
56: FETCH struct_row INTO row_id;

Line 71: UPDATE gcs_lex_map_structs ms

67: last_update_date DATE,
68: last_updated_by NUMBER,
69: last_update_login NUMBER) IS
70: BEGIN
71: UPDATE gcs_lex_map_structs ms
72: SET description = update_row.description,
73: table_use_type_code = update_row.table_use_type_code,
74: last_update_date = update_row.last_update_date,
75: last_updated_by = update_row.last_updated_by,

Line 103: FROM GCS_LEX_MAP_STRUCTS ms

99:
100: BEGIN
101: SELECT ms.last_updated_by, ms.last_update_date
102: INTO db_luby, db_ludate
103: FROM GCS_LEX_MAP_STRUCTS ms
104: WHERE ms.structure_name = load_row.structure_name;
105:
106: -- Test for customization information
107: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,

Line 146: FROM GCS_LEX_MAP_STRUCTS ms

142:
143: BEGIN
144: SELECT ms.last_updated_by, ms.last_update_date
145: INTO db_luby, db_ludate
146: FROM GCS_LEX_MAP_STRUCTS ms
147: WHERE ms.structure_name = translate_row.structure_name;
148:
149: -- Test for customization information
150: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,

Line 152: UPDATE gcs_lex_map_structs ms

148:
149: -- Test for customization information
150: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,
151: custom_mode) THEN
152: UPDATE gcs_lex_map_structs ms
153: SET last_update_date = f_ludate,
154: last_updated_by = f_luby,
155: last_update_login = 0
156: WHERE ms.structure_name = translate_row.structure_name;

Line 164: END GCS_LEX_MAP_STRUCTS_PKG;

160: null;
161: END;
162: END Translate_Row;
163:
164: END GCS_LEX_MAP_STRUCTS_PKG;