1 PACKAGE ECE_ADVO_ADVICE_PKG AUTHID CURRENT_USER AS
2 -- $Header: ECADVOS.pls 120.3 2005/09/28 11:00:44 arsriniv ship $
3
4 /*===========================================================================
5
6 PROCEDURE NAME: Extract_DSNO_Outbound
7
8 PURPOSE: This procedure initiates the concurrent process to
9 extract the eligible deliveires on a dparture.
10
11 ===========================================================================*/
12 /*Bug 1854866
13 Assigned default values to the parameter
14 v_debug_mode of the procedure extract_advo_outbound
15 since the default values are assigned to these parameters
16 in the package body
17 */
18
19 PROCEDURE Extract_ADVO_Outbound (errbuf OUT NOCOPY VARCHAR2,
20 retcode OUT NOCOPY VARCHAR2,
21 cOutput_Path IN VARCHAR2,
22 cOutput_Filename IN VARCHAR2,
23 p_TP_Group IN VARCHAR2,
24 p_TP IN VARCHAR2,
25 p_Response_to_doc IN VARCHAR2,
26 cDate_From IN VARCHAR2,
27 cDate_To IN VARCHAR2,
28 p_ext_ref1 IN VARCHAR2,
29 p_ext_ref2 IN VARCHAR2,
30 p_ext_ref3 IN VARCHAR2,
31 p_ext_ref4 IN VARCHAR2,
32 p_ext_ref5 IN VARCHAR2,
33 p_ext_ref6 IN VARCHAR2,
34 v_debug_mode IN NUMBER DEFAULT 0);
35
36
37 PROCEDURE EXTRACT_FROM_BASE_APPS(
38 cCommunication_Method IN VARCHAR2,
39 cTransaction_Type IN VARCHAR2,
40 iOutput_width IN INTEGER,
41 dTransaction_date IN DATE,
42 iRun_id IN INTEGER,
43 cHeader_Interface IN VARCHAR2,
44 cLine_Interface IN VARCHAR2,
45 p_TP_Group IN VARCHAR2,
46 p_TP IN VARCHAR2,
47 p_Response_to_doc IN VARCHAR2,
48 p_Date_From IN DATE,
49 p_Date_To IN DATE,
50 p_ext_ref1 IN VARCHAR2,
51 p_ext_ref2 IN VARCHAR2,
52 p_ext_ref3 IN VARCHAR2,
53 p_ext_ref4 IN VARCHAR2,
54 p_ext_ref5 IN VARCHAR2,
55 p_ext_ref6 IN VARCHAR2);
56
57 PROCEDURE PUT_DATA_TO_OUTPUT_TABLE(
58 cCommunication_Method IN VARCHAR2,
59 cTransaction_Type IN VARCHAR2,
60 iOutput_width IN INTEGER,
61 iRun_id IN INTEGER,
62 cHeader_Interface IN VARCHAR2,
63 cLine_Interface IN VARCHAR2);
64
65 END;
66