106: VALUES (
107: c1_rec.category_id,
108: c1_rec.structure_id,
109: sysdate,
110: FND_GLOBAL.user_id,
111: sysdate,
112: FND_GLOBAL.user_id,
113: FND_GLOBAL.conc_login_id,
114: FND_FLEX_KEYVAL.concatenated_values
108: c1_rec.structure_id,
109: sysdate,
110: FND_GLOBAL.user_id,
111: sysdate,
112: FND_GLOBAL.user_id,
113: FND_GLOBAL.conc_login_id,
114: FND_FLEX_KEYVAL.concatenated_values
115: );
116:
109: sysdate,
110: FND_GLOBAL.user_id,
111: sysdate,
112: FND_GLOBAL.user_id,
113: FND_GLOBAL.conc_login_id,
114: FND_FLEX_KEYVAL.concatenated_values
115: );
116:
117: insert into AMS_MTL_CATEGORIES_DENORM_TL (
128: c1_rec.category_id,
129: l.language_code,
130: USERENV('LANG'),
131: sysdate,
132: FND_GLOBAL.user_id,
133: sysdate,
134: FND_GLOBAL.user_id,
135: FND_GLOBAL.conc_login_id,
136: FND_FLEX_KEYVAL.concatenated_descriptions
130: USERENV('LANG'),
131: sysdate,
132: FND_GLOBAL.user_id,
133: sysdate,
134: FND_GLOBAL.user_id,
135: FND_GLOBAL.conc_login_id,
136: FND_FLEX_KEYVAL.concatenated_descriptions
137: FROM fnd_languages l
138: WHERE l.installed_flag IN ('I', 'B')
131: sysdate,
132: FND_GLOBAL.user_id,
133: sysdate,
134: FND_GLOBAL.user_id,
135: FND_GLOBAL.conc_login_id,
136: FND_FLEX_KEYVAL.concatenated_descriptions
137: FROM fnd_languages l
138: WHERE l.installed_flag IN ('I', 'B')
139: AND NOT EXISTS (SELECT NULL