1 PACKAGE FND_SEED_STAGE_UTIL AUTHID CURRENT_USER as
2 /* $Header: fndpstus.pls 120.5 2011/01/19 13:32:40 smadhapp ship $ */
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(x_msg_tab OUT NOCOPY CHAR4K_TAB);
21
22 PROCEDURE get_messages(p_msg_from IN NUMBER,
23 p_msg_to IN NUMBER,
24 x_msg_tab OUT NOCOPY CHAR4K_TAB);
25
26
27 procedure UPLOAD (p_lct_file IN VARCHAR2,
28 p_proc_id IN NUMBER,
29 p_debug IN NUMBER,
30 x_abort OUT NOCOPY NUMBER,
31 x_warning OUT NOCOPY NUMBER,
32 x_err_count OUT NOCOPY NUMBER,
33 x_err_tab OUT NOCOPY CHAR4K_TAB);
34
35 procedure create_temp_clob(p_temp_clob IN OUT NOCOPY CLOB);
36
37 end FND_SEED_STAGE_UTIL;