DBA Data[Home] [Help]

PACKAGE: APPS.WSH_OTM_SYNC_REF_DATA_PKG

Source


1 PACKAGE WSH_OTM_SYNC_REF_DATA_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHTMTHS.pls 120.0.12000000.1 2007/01/25 16:15:17 amohamme noship $ */
3 
4 PROCEDURE is_ref_data_send_reqd(p_entity_id IN NUMBER,
5 				p_parent_entity_id IN VARCHAR2,
6 				p_entity_type IN VARCHAR2,
7 				p_entity_updated_date IN DATE,
8 				x_substitute_entity OUT NOCOPY VARCHAR2,
9 				p_transmission_id IN NUMBER,
10 				x_send_allowed OUT NOCOPY BOOLEAN,
11 				x_return_status OUT NOCOPY VARCHAR2
12 				);
13 
14 PROCEDURE update_ref_data(	p_transmission_id IN NUMBER,
15 				p_transmission_status IN VARCHAR2,
16 				x_return_status OUT NOCOPY VARCHAR2
17 				);
18 
19 PROCEDURE insert_row_sync_ref_data(	p_entity_id IN NUMBER,
20 					p_parent_entity_id IN NUMBER,
21 					p_entity_type IN VARCHAR2,
22 					p_transmission_id IN NUMBER,
23                                         x_sync_ref_id     OUT NOCOPY NUMBER,
24 					x_substitute_entity OUT NOCOPY VARCHAR2,
25 					x_return_status OUT NOCOPY VARCHAR2
26 				  );
27 
28 PROCEDURE insert_row_sync_ref_data_log(	p_sync_ref_id IN NUMBER,
29 					p_transmission_id IN NUMBER,
30                                         p_entity_type IN VARCHAR2,
31 					x_return_status OUT NOCOPY VARCHAR2
32 				       );
33 
34 
35 END WSH_OTM_SYNC_REF_DATA_PKG;