1 PACKAGE PER_NO_POSTALCODE_UPLOAD AS
2 /* $Header: penopost.pkh 120.0 2005/05/31 11:57 appldev noship $ */
3
4 -- Procedure to upload postal code lookup
5 PROCEDURE upload(errbuf OUT NOCOPY VARCHAR2,
6 retcode OUT NOCOPY NUMBER,
7 p_file_name IN VARCHAR2,
8 p_business_group_id IN per_business_groups.business_group_id%TYPE);
9
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);
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