1 PACKAGE ZX_PTP_IMPORT AUTHID CURRENT_USER AS
2 /* $Header: zxptpimports.pls 120.1 2011/03/10 10:15:25 msakalab noship $ */
3
4 PROCEDURE IMPORT_WRAPPER
5 (p_request_id IN NUMBER
6 ,p_interface_table_name IN VARCHAR2
7 ,p_gather_stats IN VARCHAR2
8 ,p_validate_only IN VARCHAR2
9 ,p_sql_select_insert_ptp_intf IN VARCHAR2
10 ,p_sql_from_insert_ptp_intf IN VARCHAR2
11 ,p_insert_only IN VARCHAR2
12 ,p_sql_select_valid_party_id IN VARCHAR2
13 ,p_sql_from_valid_party_id IN VARCHAR2
14 ,p_sql_select_insert_ptp_prod IN VARCHAR2
15 ,p_sql_from_insert_ptp_prod IN VARCHAR2
16 ,p_commit IN VARCHAR2
17 ,p_batch_id IN NUMBER
18 ,x_return_status OUT NOCOPY VARCHAR2
19 ,x_msg_data OUT NOCOPY VARCHAR2
20 );
21
22 PROCEDURE MESSAGE_WRAPPER
23 (p_request_id IN NUMBER
24 ,p_interface_table_name IN VARCHAR2
25 ,p_display_stats IN VARCHAR2
26 ,p_display_messages IN VARCHAR2
27 ,p_message_header_string_1 IN VARCHAR2
28 ,p_message_header_string_2 IN VARCHAR2
29 ,x_return_status OUT NOCOPY VARCHAR2
30 ,x_msg_data OUT NOCOPY VARCHAR2
31 );
32
33 PROCEDURE DELETE_SUCCESS_RECORDS
34 (p_request_id IN NUMBER
35 ,p_commit IN VARCHAR2
36 ,x_return_status OUT NOCOPY VARCHAR2
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 );
39
40 END ZX_PTP_IMPORT;