1 PACKAGE wsh_process_interfaced_pkg AUTHID CURRENT_USER AS
2 /* $Header: WSHINPSS.pls 120.0.12010000.2 2009/03/24 00:01:16 brana ship $ */
3
4 c_sdebug CONSTANT NUMBER := wsh_debug_sv.c_level1;
5 c_debug CONSTANT NUMBER := wsh_debug_sv.c_level2;
6
7 l_trns_history_rec wsh_transactions_history_pkg.txns_history_record_type;
8
9 /* WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type will have the following
10 Important Fields.
11 DOC_TYPE
12 DOC_NUMBER
13 TRADING_PARTNER_ID
14 ACTION_TYPE
15 ENTITY_TYPE
16 ENTITY_NUMBER
17 ORIG_DOCUMENT_NUMBER */
18
19
20 PROCEDURE process_inbound (
21 l_trns_history_rec IN WSH_TRANSACTIONS_HISTORY_PKG.txns_history_record_type,
22 x_return_status OUT NOCOPY VARCHAR2
23 );
24
25 PROCEDURE derive_ids (
26 p_delivery_interface_id IN NUMBER,
27 p_document_type IN VARCHAR2,
28 x_return_status OUT NOCOPY VARCHAR2
29 );
30
31 PROCEDURE delete_interface_records (
32 p_delivery_interface_id IN NUMBER,
33 x_return_status OUT NOCOPY VARCHAR2
34 );
35
36 -- R12.1.1 STANDALONE PROJECT
37 /*=======================================================================================
38
39 PROCEDURE NAME : Delete_Interface_Records
40
41 This Procedure will be used to delete record in the different interface tables, after data
42 is populated in the base tables
43
44 =======================================================================================*/
45 PROCEDURE delete_interface_records (
46 p_del_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
47 p_del_det_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
48 p_del_assgn_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
49 p_del_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
50 p_det_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
51 x_return_status OUT NOCOPY VARCHAR2
52 );
53
54 END wsh_process_interfaced_pkg;