[Home] [Help]
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
6: -- Purpose
7: -- Package procedures for Lexical Mapping Structures
8: -- History
9: -- 23-JUN-03 M Ward Created
109: BEGIN
110: -- Get the structure ID given the structure name
111: SELECT structure_id
112: INTO struct_id
113: FROM gcs_lex_map_structs ms
114: WHERE ms.structure_name = load_row.structure_name;
115:
116: -- Get last updated information from the loader data file
117: f_luby := fnd_load_util.owner_id(owner);
165: BEGIN
166: -- Get the structure ID given the structure name
167: SELECT structure_id
168: INTO struct_id
169: FROM gcs_lex_map_structs ms
170: WHERE ms.structure_name = translate_row.structure_name;
171:
172: -- Get last updated information from the loader data file
173: f_luby := fnd_load_util.owner_id(owner);