1 PACKAGE GML_GASNO AUTHID CURRENT_USER as
2 /*$Header: GMLSNOS.pls 115.7 2002/11/08 16:04:02 gmangari ship $*/
3 /*============================== GML_GASNO =================================*/
4 /*===========================================================================
5 PACKAGE NAME: GML_GASNO
6
7 DESCRIPTION: Contains all server side procedures to export
8 Ship Notice data to a flat file.
9
10 CLIENT/SERVER: Server
11
12 LIBRARY NAME: None
13
14 OWNER: OPM Logistics
15
16 PROCEDURE/FUNCTIONS: Extract_GASNO_Outbound()
17 Populate_Interface_Tables()
18 Put_Data_To_Output_Table()
19
20
21 NOTES: To run the script:
22
23 sql> start GMLSNOS.pls
24
25 HISTORY 01/11/99 mmacary Created.
26 04/05/99 Sining Wang Modified for 11.5.
27 05/12/99 dgrailic For 11i, modified names from ECE_ to GML_
28 Bug 2411796 06/17/2002 Added default value for parameter p_debug_mode.
29 Bug#2642152 26-OCT-2002 RajaSekhar Added NOCOPY hint
30 ===========================================================================*/
31
32 /*===========================================================================
33
34 PROCEDURE NAME: Extract_GASNO_Outbound
35
36 PURPOSE: This procedure initiates the concurrent process to
37 extract the OPM Advanced Ship Notice
38
39 ===========================================================================*/
40
41 PROCEDURE Extract_GASNO_Outbound (errbuf OUT NOCOPY VARCHAR2,
42 retcode OUT NOCOPY VARCHAR2,
43 p_OutputPath IN VARCHAR2,
44 p_Filename IN VARCHAR2,
45 p_Orgn_Code IN VARCHAR2,
46 p_BOL_No_From IN VARCHAR2,
47 p_BOL_No_To IN VARCHAR2,
48 p_Creation_Date_From IN VARCHAR2,
49 p_Creation_Date_To IN VARCHAR2,
50 p_Customer_Name IN VARCHAR2,
51 p_debug_mode IN NUMBER default 0);
52
53 /*===========================================================================
54 PROCEDURE NAME: Populate_Interface_Tables
55
56 DESCRIPTION: Initiate export process OPM Advanced Ship Notice
57
58 DESIGN REFERENCES: gasnomap.xls
59
60 ===========================================================================*/
61
62 PROCEDURE Populate_Interface_Tables ( p_CommunicationMethod IN VARCHAR2,
63 p_TransactionType IN VARCHAR2,
64 p_Orgn_Code IN VARCHAR2,
65 p_BOL_No_From IN VARCHAR2,
66 p_BOL_No_To IN VARCHAR2,
67 p_Creation_Date_From IN VARCHAR2,
68 p_Creation_Date_To IN VARCHAR2,
69 p_Customer_Name IN VARCHAR2,
70 p_RunID IN INTEGER,
71 p_SHP_Interface IN VARCHAR2,
72 p_STX_Interface IN VARCHAR2,
73 p_ORD_Interface IN VARCHAR2,
74 p_OAC_Interface IN VARCHAR2,
75 p_OTX_Interface IN VARCHAR2,
76 p_DTL_Interface IN VARCHAR2,
77 p_DAC_Interface IN VARCHAR2,
78 p_DTX_Interface IN VARCHAR2,
79 p_ALL_Interface IN VARCHAR2 );
80
81 /*===========================================================================
82 PROCEDURE NAME: Put_Data_To_Output_Table
83
84 DESCRIPTION: Extracts, sequences and formats data from the interface
85 tables and writes it to the output table. The output
86 file is then written by spooling the data from the
87 output table. Upon successful completion, purges
88 interface tables.
89
90 DESIGN REFERENCES: gasnomap.xls
91
92 ===========================================================================*/
93
94 PROCEDURE Put_Data_To_Output_Table ( p_CommunicationMethod IN VARCHAR2,
95 p_TransactionType IN VARCHAR2,
96 p_Orgn_Code IN VARCHAR2,
97 p_BOL_No_From IN VARCHAR2,
98 p_BOL_No_To IN VARCHAR2,
99 p_Creation_Date_From IN VARCHAR2,
100 p_Creation_Date_To IN VARCHAR2,
101 p_Customer_Name IN VARCHAR2,
102 p_RunID IN INTEGER,
103 p_OutputWidth IN INTEGER,
104 p_SHP_Interface IN VARCHAR2,
105 p_STX_Interface IN VARCHAR2,
106 p_ORD_Interface IN VARCHAR2,
107 p_OAC_Interface IN VARCHAR2,
108 p_OTX_Interface IN VARCHAR2,
109 p_DTL_Interface IN VARCHAR2,
110 p_DAC_Interface IN VARCHAR2,
111 p_DTX_Interface IN VARCHAR2,
112 p_ALL_Interface IN VARCHAR2 );
113
114 /*=========================================================================*/
115
116 END GML_GASNO;