1 package FV_CCR_BPN_LOAD_PKG AUTHID CURRENT_USER as
2 /* $Header: FVBPNLDS.pls 120.4 2009/11/12 16:05:05 sthota noship $*/
3
4 type new_data is table of varchar2(2000);
5 ccr_data new_data;
6 procedure insert_ccr_codes(clob_buff in clob,
7 field_count_low in number,
8 field_count_high in number,
9 delimiter in varchar2,
10 proc_count in number,
11 from_index in number,
12 duns_num in varchar2,
13 retpos out NOCOPY number);
14 procedure insert_ccr_data(clob_buff in clob,
15 field_count_low in number,
16 field_count_high in number,
17 delimiter in varchar2,
18 proc_count in number,
19 from_index in number,
20 ccr_data in out NOCOPY new_data,
21 retpos out NOCOPY number
22 );
23 procedure main;
24
25 procedure delete_ccr_codes(p_duns in varchar2);
26 procedure delete_ccr_flags(p_duns in varchar2);
27
28 end fv_ccr_bpn_load_pkg;
29