11: -- Procedure to read lines from file and insert to /update the lookup.
12: PROCEDURE read_record
13: ( p_line IN VARCHAR2);
14:
15: -- Procedure to insert a row into fnd_lookup_values table
16: PROCEDURE insert_row
17: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
18: p_meaning IN fnd_lookup_values.meaning%type,
19: p_description IN fnd_lookup_values.description%type);
13: ( p_line IN VARCHAR2);
14:
15: -- Procedure to insert a row into fnd_lookup_values table
16: PROCEDURE insert_row
17: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
18: p_meaning IN fnd_lookup_values.meaning%type,
19: p_description IN fnd_lookup_values.description%type);
20:
21: -- Procedure to update a row in fnd_lookup_values table
14:
15: -- Procedure to insert a row into fnd_lookup_values table
16: PROCEDURE insert_row
17: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
18: p_meaning IN fnd_lookup_values.meaning%type,
19: p_description IN fnd_lookup_values.description%type);
20:
21: -- Procedure to update a row in fnd_lookup_values table
22: PROCEDURE update_row
15: -- Procedure to insert a row into fnd_lookup_values table
16: PROCEDURE insert_row
17: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
18: p_meaning IN fnd_lookup_values.meaning%type,
19: p_description IN fnd_lookup_values.description%type);
20:
21: -- Procedure to update a row in fnd_lookup_values table
22: PROCEDURE update_row
23: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
17: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
18: p_meaning IN fnd_lookup_values.meaning%type,
19: p_description IN fnd_lookup_values.description%type);
20:
21: -- Procedure to update a row in fnd_lookup_values table
22: PROCEDURE update_row
23: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
24: p_meaning IN fnd_lookup_values.meaning%type,
25: p_description IN fnd_lookup_values.description%type);
19: p_description IN fnd_lookup_values.description%type);
20:
21: -- Procedure to update a row in fnd_lookup_values table
22: PROCEDURE update_row
23: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
24: p_meaning IN fnd_lookup_values.meaning%type,
25: p_description IN fnd_lookup_values.description%type);
26:
27: --Function to fetch a field from the line.
20:
21: -- Procedure to update a row in fnd_lookup_values table
22: PROCEDURE update_row
23: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
24: p_meaning IN fnd_lookup_values.meaning%type,
25: p_description IN fnd_lookup_values.description%type);
26:
27: --Function to fetch a field from the line.
28: FUNCTION get_field (
21: -- Procedure to update a row in fnd_lookup_values table
22: PROCEDURE update_row
23: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
24: p_meaning IN fnd_lookup_values.meaning%type,
25: p_description IN fnd_lookup_values.description%type);
26:
27: --Function to fetch a field from the line.
28: FUNCTION get_field (
29: p_line IN OUT NOCOPY VARCHAR2,