10: -- Procedure to read lines from file and insert to /update the lookup.
11: PROCEDURE read_record
12: ( p_line IN varchar2);
13:
14: -- Procedure to insert a row into fnd_lookup_values table
15: PROCEDURE insert_row
16: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
17: p_meaning IN fnd_lookup_values.meaning%type,
18: p_description IN fnd_lookup_values.description%type);
12: ( p_line IN varchar2);
13:
14: -- Procedure to insert a row into fnd_lookup_values table
15: PROCEDURE insert_row
16: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
17: p_meaning IN fnd_lookup_values.meaning%type,
18: p_description IN fnd_lookup_values.description%type);
19:
20: -- Procedure to update a row in fnd_lookup_values table
13:
14: -- Procedure to insert a row into fnd_lookup_values table
15: PROCEDURE insert_row
16: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
17: p_meaning IN fnd_lookup_values.meaning%type,
18: p_description IN fnd_lookup_values.description%type);
19:
20: -- Procedure to update a row in fnd_lookup_values table
21: PROCEDURE update_row
14: -- Procedure to insert a row into fnd_lookup_values table
15: PROCEDURE insert_row
16: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
17: p_meaning IN fnd_lookup_values.meaning%type,
18: p_description IN fnd_lookup_values.description%type);
19:
20: -- Procedure to update a row in fnd_lookup_values table
21: PROCEDURE update_row
22: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
16: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
17: p_meaning IN fnd_lookup_values.meaning%type,
18: p_description IN fnd_lookup_values.description%type);
19:
20: -- Procedure to update a row in fnd_lookup_values table
21: PROCEDURE update_row
22: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
23: p_meaning IN fnd_lookup_values.meaning%type,
24: p_description IN fnd_lookup_values.description%type);
18: p_description IN fnd_lookup_values.description%type);
19:
20: -- Procedure to update a row in fnd_lookup_values table
21: PROCEDURE update_row
22: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
23: p_meaning IN fnd_lookup_values.meaning%type,
24: p_description IN fnd_lookup_values.description%type);
25:
26: end PER_NO_POSTALCODE_UPLOAD;
19:
20: -- Procedure to update a row in fnd_lookup_values table
21: PROCEDURE update_row
22: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
23: p_meaning IN fnd_lookup_values.meaning%type,
24: p_description IN fnd_lookup_values.description%type);
25:
26: end PER_NO_POSTALCODE_UPLOAD;
27:
20: -- Procedure to update a row in fnd_lookup_values table
21: PROCEDURE update_row
22: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
23: p_meaning IN fnd_lookup_values.meaning%type,
24: p_description IN fnd_lookup_values.description%type);
25:
26: end PER_NO_POSTALCODE_UPLOAD;
27: