DBA Data[Home] [Help]

APPS.PER_DK_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 272: from fnd_lookup_values

268:
269:
270: begin
271: select 'Y' INTO update_flag
272: from fnd_lookup_values
273: where lookup_type=l_lookup_type
274: and lookup_code=l_lookup_code and
275: security_group_id = l_security_group_id and
276: view_application_id = l_view_application_id and

Line 299: -- Procedure to insert a row into fnd_lookup_values table

295: raise e_invalid_record;
296:
297: end read_record;
298:
299: -- Procedure to insert a row into fnd_lookup_values table
300:
301: PROCEDURE insert_row
302: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
303: p_meaning IN fnd_lookup_values.meaning%type,

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

298:
299: -- Procedure to insert a row into fnd_lookup_values table
300:
301: PROCEDURE insert_row
302: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
303: p_meaning IN fnd_lookup_values.meaning%type,
304: p_description IN fnd_lookup_values.description%type)
305:
306: IS

Line 303: p_meaning IN fnd_lookup_values.meaning%type,

299: -- Procedure to insert a row into fnd_lookup_values table
300:
301: PROCEDURE insert_row
302: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
303: p_meaning IN fnd_lookup_values.meaning%type,
304: p_description IN fnd_lookup_values.description%type)
305:
306: IS
307:

Line 304: p_description IN fnd_lookup_values.description%type)

300:
301: PROCEDURE insert_row
302: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
303: p_meaning IN fnd_lookup_values.meaning%type,
304: p_description IN fnd_lookup_values.description%type)
305:
306: IS
307:
308: l_lookup_type CONSTANT VARCHAR2(50):='DK_POSTCODE_TOWN';

Line 314: FND_LOOKUP_VALUES_PKG.INSERT_ROW(

310:
311: begin
312:
313:
314: FND_LOOKUP_VALUES_PKG.INSERT_ROW(
315: X_ROWID => l_rowid,
316: X_LOOKUP_TYPE => l_lookup_type,
317: X_SECURITY_GROUP_ID => l_security_group_id,
318: X_VIEW_APPLICATION_ID => 3,

Line 353: -- Procedure to update a row in fnd_lookup_values table

349: hr_utility.set_location ( ' insert row ', 30);
350:
351: end insert_row;
352:
353: -- Procedure to update a row in fnd_lookup_values table
354:
355: PROCEDURE update_row
356: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
357: p_meaning IN fnd_lookup_values.meaning%type,

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

352:
353: -- Procedure to update a row in fnd_lookup_values table
354:
355: PROCEDURE update_row
356: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
357: p_meaning IN fnd_lookup_values.meaning%type,
358: p_description IN fnd_lookup_values.description%type)
359:
360: IS

Line 357: p_meaning IN fnd_lookup_values.meaning%type,

353: -- Procedure to update a row in fnd_lookup_values table
354:
355: PROCEDURE update_row
356: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
357: p_meaning IN fnd_lookup_values.meaning%type,
358: p_description IN fnd_lookup_values.description%type)
359:
360: IS
361:

Line 358: p_description IN fnd_lookup_values.description%type)

354:
355: PROCEDURE update_row
356: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
357: p_meaning IN fnd_lookup_values.meaning%type,
358: p_description IN fnd_lookup_values.description%type)
359:
360: IS
361:
362: l_lookup_type CONSTANT VARCHAR2(50):='DK_POSTCODE_TOWN';

Line 366: FND_LOOKUP_VALUES_PKG.UPDATE_ROW(

362: l_lookup_type CONSTANT VARCHAR2(50):='DK_POSTCODE_TOWN';
363:
364: begin
365:
366: FND_LOOKUP_VALUES_PKG.UPDATE_ROW(
367: X_LOOKUP_TYPE => l_lookup_type,
368: X_SECURITY_GROUP_ID => l_security_group_id,
369: X_VIEW_APPLICATION_ID => 3,
370: X_LOOKUP_CODE => l_lookup_code,