APPS.PER_FI_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: view_application_id = g_view_application_id;

Line 327: p_lookup_code in fnd_lookup_values.lookup_code%TYPE

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

Line 328: ,p_meaning in fnd_lookup_values.meaning%TYPE

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

Line 329: ,p_description IN fnd_lookup_values.description%type

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

Line 340: FND_LOOKUP_VALUES_PKG.INSERT_ROW(

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

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

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

Line 382: p_meaning in fnd_lookup_values.meaning%TYPE,

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

Line 383: p_description IN fnd_lookup_values.description%type)

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

Line 389: FND_LOOKUP_VALUES_PKG.UPDATE_ROW(

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