1 PACKAGE ece_poco_transaction AS
2 -- $Header: ECPOCOS.pls 120.2.12010000.1 2008/07/25 07:25:47 appldev ship $
3
4
5 /*===========================================================================
6
7 PROCEDURE NAME: Extract_POCO_Outbound
8
9 PURPOSE: This procedure initiates the concurrent process to
10 extract the eligible deliveires on a dparture.
11
12 ===========================================================================*/
13 /*Bug 1854866
14 Assigned default values to the parameter
15 v_debug_mode of the procedure extract_poco_outbound
16 since the default values are assigned to these parameters
17 in the package body
18 */
19
20 PROCEDURE extract_poco_outbound(
21 errbuf OUT NOCOPY VARCHAR2,
22 retcode OUT NOCOPY VARCHAR2,
23 cOutput_Path IN VARCHAR2,
24 cOutput_Filename IN VARCHAR2,
25 cPO_Number_From IN VARCHAR2,
26 cPO_Number_To IN VARCHAR2,
27 cRDate_From IN VARCHAR2,
28 cRDate_To IN VARCHAR2,
29 cPC_Type IN VARCHAR2,
30 cVendor_Name IN VARCHAR2,
31 cVendor_Site_Code IN VARCHAR2,
32 v_debug_mode IN NUMBER DEFAULT 0);
33
34 PROCEDURE populate_poco_trx(
35 cCommunication_Method IN VARCHAR2,
36 cTransaction_Type IN VARCHAR2,
37 iOutput_Width IN INTEGER,
38 dTransaction_date IN DATE,
39 iRun_Id IN INTEGER,
40 cHeader_Interface IN VARCHAR2,
41 cLine_Interface IN VARCHAR2,
42 cShipment_Interface IN VARCHAR2,
43 cProject_Interface IN VARCHAR2,
44 cRevised_Date_From IN DATE,
45 cRevised_Date_To IN DATE,
46 cSupplier_Name IN VARCHAR2,
47 cSupplier_Site IN VARCHAR2,
48 cDocument_Type IN VARCHAR2,
49 cPO_Number_From IN VARCHAR2,
50 cPO_Number_To IN VARCHAR2);
51
52 PROCEDURE put_data_to_output_table(
53 cCommunication_Method IN VARCHAR2,
54 cTransaction_Type IN VARCHAR2,
55 iOutput_width IN INTEGER,
56 iRun_id IN INTEGER,
57 cHeader_Interface IN VARCHAR2,
58 cLine_Interface IN VARCHAR2,
59 cShipment_Interface IN VARCHAR2,
60 cProject_Interface IN VARCHAR2);
61
62 END;
63