1 PACKAGE WSH_SHIPMENT_ADVICE_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHSAPKS.pls 120.0.12010000.1 2010/02/25 17:02:20 sankarun noship $ */
3
4 --
5 --=============================================================================
6 -- PUBLIC PROCEDURE :
7 -- Shipment_Advice_Inbound
8 --
9 -- PARAMETERS:
10 -- errbuf => Message returned to Concurrent Manager
11 -- retcode => Code (0, 1, 2) returned to Concurrent Manager
12 -- p_transaction_status => Either AP, ER, NULL
13 -- p_from_document_number => From Document Number
14 -- p_to_document_number => To Document Number
15 -- p_from_creation_date => From Creation Date
16 -- p_to_creation_date => To Creation Date
17 -- p_transaction_id => Transacation id to be processed
18 -- p_log_level => Either 1(Debug), 0(No Debug)
19 -- COMMENT:
20 -- API will be invoked from Concurrent Manager whenever concurrent program
21 -- 'Process Shipment Advices' is triggered.
22 --=============================================================================
23 --
24 PROCEDURE Shipment_Advice_Inbound (
25 errbuf OUT NOCOPY VARCHAR2,
26 retcode OUT NOCOPY NUMBER,
27 p_transaction_status IN VARCHAR2,
28 p_from_document_number IN VARCHAR2,
29 p_to_document_number IN VARCHAR2,
30 p_from_creation_date IN VARCHAR2,
31 p_to_creation_date IN VARCHAR2,
32 p_transaction_id IN NUMBER,
33 p_log_level IN NUMBER );
34 --
35 --=============================================================================
36 -- PUBLIC PROCEDURE :
37 -- Process_Shipment_Advice
38 --
39 -- PARAMETERS:
40 -- p_commit_flag => Either FND_API.G_TRUE, FND_API.G_FALSE
41 -- p_transaction_status => Either AP, ER, NULL
42 -- p_from_document_number => From Document Number
43 -- p_to_document_number => To Document Number
44 -- p_from_creation_date => From Creation Date
45 -- p_to_creation_date => To Creation Date
46 -- p_transaction_id => Transacation id to be processed
47 -- x_return_status => Return Status of API (S,W,E,U)
48 -- COMMENT:
49 -- Based on input parameter values, eligble records for processing are
50 -- queried from WTH table.
51 -- Calling API WSH_PROCESS_INTERFACED_PKG.Process_Inbound to process the
52 -- eligible records queried from WTH table.
53 --=============================================================================
54 --
55 PROCEDURE Process_Shipment_Advice (
56 p_commit_flag IN VARCHAR2,
57 p_transaction_status IN VARCHAR2,
58 p_from_document_number IN VARCHAR2,
59 p_to_document_number IN VARCHAR2,
60 p_from_creation_date IN VARCHAR2,
61 p_to_creation_date IN VARCHAR2,
62 p_transaction_id IN NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2 );
64
65 END WSH_SHIPMENT_ADVICE_PKG;