7: g_proc CONSTANT VARCHAR2 (33) :='error';
8: g_bg_id per_business_groups.business_group_id%TYPE;
9: g_view_application_id FND_LOOKUP_TYPES.view_application_id%type;
10: g_security_group_id PER_BUSINESS_GROUPS.business_group_id%type;
11: --l_original_desc fnd_lookup_values.description%type;
12:
13: -- File Handling variables
14: l_file_type UTL_FILE.file_type;
15: l_location VARCHAR2 (4000);
254: ( p_line IN varchar2
255: )
256: is
257: l_update_flag varchar2(50);
258: l_original_meaning fnd_lookup_values.meaning%type;
259: l_Description fnd_lookup_values.description%type;
260: l_code fnd_lookup_values.lookup_code%type;
261:
262:
255: )
256: is
257: l_update_flag varchar2(50);
258: l_original_meaning fnd_lookup_values.meaning%type;
259: l_Description fnd_lookup_values.description%type;
260: l_code fnd_lookup_values.lookup_code%type;
261:
262:
263: BEGIN
256: is
257: l_update_flag varchar2(50);
258: l_original_meaning fnd_lookup_values.meaning%type;
259: l_Description fnd_lookup_values.description%type;
260: l_code fnd_lookup_values.lookup_code%type;
261:
262:
263: BEGIN
264: l_update_flag:='N';
302: /* if so update the description only */
303:
304: SELECT 'Y',flv.meaning
305: INTO l_update_flag,l_original_meaning
306: FROM fnd_lookup_values flv
307: WHERE flv.lookup_type=g_lookup_type
308: AND flv.lookup_code=l_code and
309: security_group_id = g_security_group_id and
310: language=userenv('LANG') and
329:
330: end READ_RECORD;
331:
332: PROCEDURE INSERT_ROW(
333: p_lookup_code in fnd_lookup_values.lookup_code%TYPE
334: ,p_meaning in fnd_lookup_values.meaning%TYPE
335: ,p_description IN fnd_lookup_values.description%type
336: )
337: is
330: end READ_RECORD;
331:
332: PROCEDURE INSERT_ROW(
333: p_lookup_code in fnd_lookup_values.lookup_code%TYPE
334: ,p_meaning in fnd_lookup_values.meaning%TYPE
335: ,p_description IN fnd_lookup_values.description%type
336: )
337: is
338:
331:
332: PROCEDURE INSERT_ROW(
333: p_lookup_code in fnd_lookup_values.lookup_code%TYPE
334: ,p_meaning in fnd_lookup_values.meaning%TYPE
335: ,p_description IN fnd_lookup_values.description%type
336: )
337: is
338:
339: --G_LOOKUP_TYPE CONSTANT VARCHAR2(50) :='SE_POSTAL_CODE';
342:
343: begin
344:
345:
346: FND_LOOKUP_VALUES_PKG.INSERT_ROW(
347: X_ROWID => l_rowid,
348: X_LOOKUP_TYPE => g_lookup_type,
349: X_SECURITY_GROUP_ID => g_security_group_id,
350: X_VIEW_APPLICATION_ID => 3,
383: end INSERT_ROW;
384:
385:
386:
387: PROCEDURE UPDATE_ROW(p_lookup_code in fnd_lookup_values.lookup_code%TYPE,
388: p_meaning in fnd_lookup_values.meaning%TYPE,
389: p_description IN fnd_lookup_values.description%type)
390: is
391: --G_LOOKUP_TYPE CONSTANT VARCHAR2(50) :='SE_POSTAL_CODE';
384:
385:
386:
387: PROCEDURE UPDATE_ROW(p_lookup_code in fnd_lookup_values.lookup_code%TYPE,
388: p_meaning in fnd_lookup_values.meaning%TYPE,
389: p_description IN fnd_lookup_values.description%type)
390: is
391: --G_LOOKUP_TYPE CONSTANT VARCHAR2(50) :='SE_POSTAL_CODE';
392:
385:
386:
387: PROCEDURE UPDATE_ROW(p_lookup_code in fnd_lookup_values.lookup_code%TYPE,
388: p_meaning in fnd_lookup_values.meaning%TYPE,
389: p_description IN fnd_lookup_values.description%type)
390: is
391: --G_LOOKUP_TYPE CONSTANT VARCHAR2(50) :='SE_POSTAL_CODE';
392:
393: begin
391: --G_LOOKUP_TYPE CONSTANT VARCHAR2(50) :='SE_POSTAL_CODE';
392:
393: begin
394:
395: FND_LOOKUP_VALUES_PKG.UPDATE_ROW(
396: X_LOOKUP_TYPE => g_lookup_type,
397: X_SECURITY_GROUP_ID => g_security_group_id,
398: X_VIEW_APPLICATION_ID => 3,
399: X_LOOKUP_CODE => p_lookup_code,