1 PACKAGE FND_SEED_STAGE_UTIL as
2 /* $Header: fndpstus.pls 120.3 2005/10/10 16:06:26 quli noship $ */
3 /* a utility package related to seed data staging table */
4
5 TYPE CHAR_TAB IS TABLE of VARCHAR2(32767) index by binary_integer;
6 TYPE NUM_TAB IS TABLE of NUMBER index by binary_integer;
7 TYPE DATE_TAB IS TABLE of DATE index by binary_integer;
8 TYPE CHAR4K_TAB IS TABLE OF VARCHAR2(4000)
9 INDEX BY BINARY_INTEGER;
10
11 PROCEDURE insert_msg( p_msg_str IN VARCHAR2);
12
13 PROCEDURE update_status( p_debug IN NUMBER,
14 p_seq IN NUMBER,
15 p_status IN NUMBER);
16
17 PROCEDURE get_messages(p_msg_to IN NUMBER,
18 x_msg_tab OUT NOCOPY CHAR4K_TAB);
19
20 PROCEDURE get_messages(p_msg_from IN NUMBER,
21 p_msg_to IN NUMBER,
22 x_msg_tab OUT NOCOPY CHAR4K_TAB);
23
24
25 procedure UPLOAD (p_lct_file IN VARCHAR2,
26 p_proc_id IN NUMBER,
27 p_debug IN NUMBER,
28 x_abort OUT NOCOPY NUMBER,
29 x_warning OUT NOCOPY NUMBER,
30 x_err_count OUT NOCOPY NUMBER,
31 x_err_tab OUT NOCOPY CHAR4K_TAB);
32
33 procedure create_temp_clob(p_temp_clob IN OUT NOCOPY CLOB);
34
35 end FND_SEED_STAGE_UTIL;