1 PACKAGE PER_DK_POSTALCODE_UPLOAD AS
2 /* $Header: pedkpost.pkh 120.0 2005/05/31 07:42:40 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
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);
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 (
29 p_line IN OUT NOCOPY VARCHAR2,
30 p_delimiter IN VARCHAR2,
31 p_start_pos IN NUMBER DEFAULT 1,
32 p_occurance IN NUMBER DEFAULT 1
33 )
34 RETURN VARCHAR2;
35
36
37 end PER_DK_POSTALCODE_UPLOAD;
38
39