APPS.PER_NO_POSTALCODE_UPLOAD dependencies on FND_LOOKUP_VALUES

Line 18: l_lookup_code fnd_lookup_values.lookup_code%type :=null;

14: l_line_read VARCHAR2 (4000) ;
15: l_batch_seq NUMBER :=0;
16:
17: -- Variables to Read from File
18: l_lookup_code fnd_lookup_values.lookup_code%type :=null;
19: l_meaning fnd_lookup_values.meaning%type;
20: l_description fnd_lookup_values.description%type;
21:
22: l_file_name VARCHAR2 (240);

Line 19: l_meaning fnd_lookup_values.meaning%type;

15: l_batch_seq NUMBER :=0;
16:
17: -- Variables to Read from File
18: l_lookup_code fnd_lookup_values.lookup_code%type :=null;
19: l_meaning fnd_lookup_values.meaning%type;
20: l_description fnd_lookup_values.description%type;
21:
22: l_file_name VARCHAR2 (240);
23:

Line 20: l_description fnd_lookup_values.description%type;

16:
17: -- Variables to Read from File
18: l_lookup_code fnd_lookup_values.lookup_code%type :=null;
19: l_meaning fnd_lookup_values.meaning%type;
20: l_description fnd_lookup_values.description%type;
21:
22: l_file_name VARCHAR2 (240);
23:
24: -- Exceptions

Line 276: from fnd_lookup_values

272:
273:
274: begin
275: select 'Y' INTO update_flag
276: from fnd_lookup_values
277: where lookup_type=l_lookup_type
278: and lookup_code=l_lookup_code and
279: security_group_id = l_security_group_id and
280: view_application_id = l_view_application_id and

Line 310: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,

306: end read_record;
307:
308:
309: PROCEDURE insert_row
310: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
311: p_meaning IN fnd_lookup_values.meaning%type,
312: p_description IN fnd_lookup_values.description%type
313: )
314:

Line 311: p_meaning IN fnd_lookup_values.meaning%type,

307:
308:
309: PROCEDURE insert_row
310: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
311: p_meaning IN fnd_lookup_values.meaning%type,
312: p_description IN fnd_lookup_values.description%type
313: )
314:
315: IS

Line 312: p_description IN fnd_lookup_values.description%type

308:
309: PROCEDURE insert_row
310: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
311: p_meaning IN fnd_lookup_values.meaning%type,
312: p_description IN fnd_lookup_values.description%type
313: )
314:
315: IS
316:

Line 322: FND_LOOKUP_VALUES_PKG.INSERT_ROW(

318: l_rowid VARCHAR2(30);
319:
320: begin
321:
322: FND_LOOKUP_VALUES_PKG.INSERT_ROW(
323: X_ROWID => l_rowid,
324: X_LOOKUP_TYPE => l_lookup_type,
325: X_SECURITY_GROUP_ID => l_security_group_id,
326: X_VIEW_APPLICATION_ID => 3,

Line 362: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,

358:
359: end insert_row;
360:
361: PROCEDURE update_row
362: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
363: p_meaning IN fnd_lookup_values.meaning%type,
364: p_description IN fnd_lookup_values.description%type
365: )
366:

Line 363: p_meaning IN fnd_lookup_values.meaning%type,

359: end insert_row;
360:
361: PROCEDURE update_row
362: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
363: p_meaning IN fnd_lookup_values.meaning%type,
364: p_description IN fnd_lookup_values.description%type
365: )
366:
367: IS

Line 364: p_description IN fnd_lookup_values.description%type

360:
361: PROCEDURE update_row
362: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
363: p_meaning IN fnd_lookup_values.meaning%type,
364: p_description IN fnd_lookup_values.description%type
365: )
366:
367: IS
368:

Line 373: FND_LOOKUP_VALUES_PKG.UPDATE_ROW(

369: l_lookup_type CONSTANT VARCHAR2(50):='NO_POSTAL_CODE';
370:
371: begin
372:
373: FND_LOOKUP_VALUES_PKG.UPDATE_ROW(
374: X_LOOKUP_TYPE => l_lookup_type,
375: X_SECURITY_GROUP_ID => l_security_group_id,
376: X_VIEW_APPLICATION_ID => 3,
377: X_LOOKUP_CODE => l_lookup_code,