APPS.PER_SE_POSTALCODE_UPLOAD dependencies on FND_LOOKUP_VALUES

Line 11: --l_original_desc fnd_lookup_values.description%type;

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);

Line 258: l_original_meaning fnd_lookup_values.meaning%type;

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:

Line 259: l_Description fnd_lookup_values.description%type;

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

Line 260: l_code fnd_lookup_values.lookup_code%type;

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';

Line 301: FROM fnd_lookup_values flv

297: /* if so update the description only */
298:
299: SELECT 'Y',flv.meaning
300: INTO l_update_flag,l_original_meaning
301: FROM fnd_lookup_values flv
302: WHERE flv.lookup_type=g_lookup_type
303: AND flv.lookup_code=l_code and
304: security_group_id = g_security_group_id and
305: language=userenv('LANG') and

Line 328: p_lookup_code in fnd_lookup_values.lookup_code%TYPE

324:
325: end READ_RECORD;
326:
327: PROCEDURE INSERT_ROW(
328: p_lookup_code in fnd_lookup_values.lookup_code%TYPE
329: ,p_meaning in fnd_lookup_values.meaning%TYPE
330: ,p_description IN fnd_lookup_values.description%type
331: )
332: is

Line 329: ,p_meaning in fnd_lookup_values.meaning%TYPE

325: end READ_RECORD;
326:
327: PROCEDURE INSERT_ROW(
328: p_lookup_code in fnd_lookup_values.lookup_code%TYPE
329: ,p_meaning in fnd_lookup_values.meaning%TYPE
330: ,p_description IN fnd_lookup_values.description%type
331: )
332: is
333:

Line 330: ,p_description IN fnd_lookup_values.description%type

326:
327: PROCEDURE INSERT_ROW(
328: p_lookup_code in fnd_lookup_values.lookup_code%TYPE
329: ,p_meaning in fnd_lookup_values.meaning%TYPE
330: ,p_description IN fnd_lookup_values.description%type
331: )
332: is
333:
334: --G_LOOKUP_TYPE CONSTANT VARCHAR2(50) :='SE_POSTAL_CODE';

Line 341: FND_LOOKUP_VALUES_PKG.INSERT_ROW(

337:
338: begin
339:
340:
341: FND_LOOKUP_VALUES_PKG.INSERT_ROW(
342: X_ROWID => l_rowid,
343: X_LOOKUP_TYPE => g_lookup_type,
344: X_SECURITY_GROUP_ID => g_security_group_id,
345: X_VIEW_APPLICATION_ID => 3,

Line 382: PROCEDURE UPDATE_ROW(p_lookup_code in fnd_lookup_values.lookup_code%TYPE,

378: end INSERT_ROW;
379:
380:
381:
382: PROCEDURE UPDATE_ROW(p_lookup_code in fnd_lookup_values.lookup_code%TYPE,
383: p_meaning in fnd_lookup_values.meaning%TYPE,
384: p_description IN fnd_lookup_values.description%type)
385: is
386: --G_LOOKUP_TYPE CONSTANT VARCHAR2(50) :='SE_POSTAL_CODE';

Line 383: p_meaning in fnd_lookup_values.meaning%TYPE,

379:
380:
381:
382: PROCEDURE UPDATE_ROW(p_lookup_code in fnd_lookup_values.lookup_code%TYPE,
383: p_meaning in fnd_lookup_values.meaning%TYPE,
384: p_description IN fnd_lookup_values.description%type)
385: is
386: --G_LOOKUP_TYPE CONSTANT VARCHAR2(50) :='SE_POSTAL_CODE';
387:

Line 384: p_description IN fnd_lookup_values.description%type)

380:
381:
382: PROCEDURE UPDATE_ROW(p_lookup_code in fnd_lookup_values.lookup_code%TYPE,
383: p_meaning in fnd_lookup_values.meaning%TYPE,
384: p_description IN fnd_lookup_values.description%type)
385: is
386: --G_LOOKUP_TYPE CONSTANT VARCHAR2(50) :='SE_POSTAL_CODE';
387:
388: begin

Line 390: FND_LOOKUP_VALUES_PKG.UPDATE_ROW(

386: --G_LOOKUP_TYPE CONSTANT VARCHAR2(50) :='SE_POSTAL_CODE';
387:
388: begin
389:
390: FND_LOOKUP_VALUES_PKG.UPDATE_ROW(
391: X_LOOKUP_TYPE => g_lookup_type,
392: X_SECURITY_GROUP_ID => g_security_group_id,
393: X_VIEW_APPLICATION_ID => 3,
394: X_LOOKUP_CODE => p_lookup_code,