PACKAGE: APPS.HR_DU_DI_INSERT

Source

1 PACKAGE hr_du_di_insert AUTHID CURRENT_USER AS
2 /* $Header: perduext.pkh 120.1 2005/06/27 02:51:19 mroberts noship $ */
3 
4 --global variable to count the number of lines down the spread sheet the
5 --program has travelled
6 
7 g_counter		   NUMBER;
8 g_delimiter_count	   NUMBER;
9 g_flat_file_delimiter	   VARCHAR2(10);
10 g_current_delimiter	   VARCHAR2(10);
11 g_current_delimiter_string VARCHAR2(50);
12 
13 g_tab_delimiter		   VARCHAR2(10)	 := hr_du_utility.local_CHR(9);
14 g_carr_delimiter           VARCHAR2(10)   := hr_du_utility.local_CHR(13);
15 g_linef_delimiter          VARCHAR2(10)   := hr_du_utility.local_CHR(10);
16 
17 g_length_carr              NUMBER   := length(g_carr_delimiter);
18 g_length_linef 		   NUMBER   := length(g_linef_delimiter);
19 
20 
21 
22 TYPE R_ORIGINAL_HEADER_TYPE IS RECORD
23  (
24   r_upload_header_id	NUMBER,
25   r_api_module_id	NUMBER);
26 
27 TYPE TABLE_HEADER_API_TYPE IS TABLE OF R_ORIGINAL_HEADER_TYPE
28   INDEX BY BINARY_INTEGER;
29 
30 TYPE TABLE_LOCAL_CHRS IS TABLE OF VARCHAR2(20)
31   INDEX BY BINARY_INTEGER;
32 
33 TYPE update_line_table IS TABLE OF VARCHAR2(2000)
34   INDEX BY BINARY_INTEGER;
35 
36 g_line_table  	UPDATE_LINE_TABLE;
37 g_header_table	TABLE_HEADER_API_TYPE;
38 
39 Char_table	TABLE_LOCAL_CHRS;
40 
41 
42 FUNCTION WORDS_ON_LINE(p_line IN VARCHAR2)
43                      RETURN NUMBER;
44 
45 FUNCTION Return_Word(p_line IN varchar2,
46                      p_word_num IN NUMBER)
47  	             RETURN Varchar2;
48 
49 PROCEDURE Extract_API_locations (
50                      p_filehandle IN utl_file.file_type,
51                      p_upload_id IN NUMBER);
52 
53 PROCEDURE Extract_Headers (
54                      p_filehandle IN utl_file.file_type,
55                      p_upload_id IN NUMBER);
56 
57 FUNCTION EXTRACT_DESCRIPTORS (
58                      p_filehandle IN utl_file.file_type,
59                      p_upload_id IN NUMBER,
60                      p_upload_header_id IN NUMBER)
61                      RETURN VARCHAR2;
62 
63 PROCEDURE Handle_API_Files (
64                      p_Location IN VARCHAR2,
65                      p_upload_id IN NUMBER);
66 
67 PROCEDURE Update_Upload_table (
68                      p_upload_id IN NUMBER);
69 
70 FUNCTION Return_File_Name(
71                      p_upload_id IN NUMBER)
72                      RETURN VARCHAR2;
73 
74 FUNCTION Open_file ( p_file_location IN varchar2,
75                      p_file_name IN varchar2)
76                      RETURN utl_file.file_type;
77 
78 
79 PROCEDURE EXTRACT_LINES(
80                      p_filehandle IN utl_file.file_type,
81                      p_upload_id IN NUMBER,
82                      p_original_upload_header_id IN NUMBER,
83                      p_reference_type IN VARCHAR2,
84                      p_api_module_id IN NUMBER,
85                      p_upload_header_id IN NUMBER);
86 
87 PROCEDURE ORDERED_SEQUENCE(
88                      p_upload_id IN NUMBER);
89 
90 PROCEDURE ROLLBACK(  p_upload_id IN NUMBER);
91 
92 PROCEDURE VALIDATE(  p_upload_id IN NUMBER);
93 
94 FUNCTION NUM_DELIMITERS(
95                      p_line IN VARCHAR2)
96                      RETURN NUMBER;
97 
98 end hr_du_di_insert;