1 PACKAGE GML_GPOAO AUTHID CURRENT_USER as
2 /* $Header: GMLPAOS.pls 115.5 2002/11/08 06:33:46 gmangari ship $ */
3 /*===========================================================================
4 PACKAGE NAME: GML_GPOAO
5
6 DESCRIPTION: Contains all server side procedures to export
7 PO Ack to a flat file. One flat file
8 will be created for all PO Acks
9
10 CLIENT/SERVER: Server
11
12 LIBRARY NAME: None
13
14 PROCEDURE/FUNCTIONS:
15 Populate_Interface_Tables()
16 Put_Data_To_Output_Table()
17
18
19 NOTES: To run the script:
20
21 sql> start GMLPAOS.pls
22
23 HISTORY 02/14/99 dgrailic Created.
24 05/17/99 dgrailic Modified to use GML_ prefix
25 26-OCT-2002 Bug#2642152 RajaSekhar Added NOCOPY hint
26
27 ===========================================================================*/
28
29 /*===========================================================================
30
31 PROCEDURE NAME: Extract_GPOAO_Outbound
32
33 PURPOSE: This PLSQL procedure produces an ASCII file containing
34 an OPM PO Ack Outbound
35 This ASCII file may then be processed by
36 third-party EDI translation software to generate and send
37 the EDI Outbound Ship Notice transaction.
38
39 NOTES: This script takes nine parameters:
40 1. The output path
41 2. The output file name
42 3. Required field, OPM organization code
43 4. Optional Order Number from
44 5. Optional Order Number to
45 6. Optional Creation Date from
46 7. Optional Creation Date to
47 8. Optional OF Customer Name
48 9. debug
49
50 DESIGN REFERENCES:
51
52 ALGORITHM:
53
54 NOTES:
55
56 OPEN ISSUES:
57
58 CLOSED ISSUES:
59
60 CHANGE HISTORY: 02/15/99 dgrailic Created.
61
62 ============================================================================ */
63 PROCEDURE Extract_GPOAO_Outbound ( errbuf OUT NOCOPY VARCHAR2,
64 retcode OUT NOCOPY VARCHAR2,
65 v_OutputPath IN VARCHAR2,
66 v_Filename IN VARCHAR2,
67 v_Orgn_Code IN VARCHAR2,
68 v_Order_No_From IN VARCHAR2,
69 v_Order_No_To IN VARCHAR2,
70 v_Creation_Date_From IN VARCHAR2,
71 v_Creation_Date_To IN VARCHAR2,
72 v_Customer_Name IN VARCHAR2,
73 v_debug_mode IN NUMBER default 0 );
74
75 /*===========================================================================
76 PROCEDURE NAME: Populate_Interface_Tables
77
78 DESCRIPTION: Initiate export process for all PO Acks
79
80 DESIGN REFERENCES: gpoao_hld.rtf
81
82 ALGORITHM:
83
84 NOTES:
85
86 OPEN ISSUES:
87
88 CLOSED ISSUES:
89
90 CHANGE HISTORY: 02/15/99 dgrailic Created.
91
92 ===========================================================================*/
93
94 PROCEDURE Populate_Interface_Tables ( p_CommunicationMethod IN VARCHAR2,
95 p_TransactionType IN VARCHAR2,
96 p_Orgn_Code IN VARCHAR2,
97 p_Order_No_From IN VARCHAR2,
98 p_Order_No_To IN VARCHAR2,
99 p_Creation_Date_From IN DATE,
100 p_Creation_Date_To IN DATE,
101 p_Customer_Name IN VARCHAR2,
102 p_RunID IN INTEGER,
103 p_ORD_Interface IN VARCHAR2,
104 p_OAC_Interface IN VARCHAR2,
105 p_OTX_Interface IN VARCHAR2,
106 p_DTL_Interface IN VARCHAR2,
107 p_DAC_Interface IN VARCHAR2,
108 p_DTX_Interface IN VARCHAR2,
109 p_ALL_Interface IN VARCHAR2 );
110
111 /*===========================================================================
112 PROCEDURE NAME: Put_Data_To_Output_Table
113
114 DESCRIPTION: Extracts, sequences and formats data from the interface
115 tables and writes it to the output table. The output
116 file is then written by spooling the data from the
117 output table. Upon successful completion, purges
118 interface tables.
119
120 DESIGN REFERENCES: gpoao_hld.rtf
121
122 ALGORITHM:
123
124 NOTES:
125
126 OPEN ISSUES:
127
128 CLOSED ISSUES:
129
130 CHANGE HISTORY: 02/15/99 dgrailic Created.
131
132 ===========================================================================*/
133
134 PROCEDURE Put_Data_To_Output_Table ( p_CommunicationMethod IN VARCHAR2,
135 p_TransactionType IN VARCHAR2,
136 p_Orgn_Code IN VARCHAR2,
137 p_Order_No_From IN VARCHAR2,
138 p_Order_No_To IN VARCHAR2,
139 p_Creation_Date_From IN DATE,
140 p_Creation_Date_To IN DATE,
141 p_Customer_Name IN VARCHAR2,
142 p_RunID IN INTEGER,
143 p_OutputWidth IN INTEGER,
144 p_ORD_Interface IN VARCHAR2,
145 p_OAC_Interface IN VARCHAR2,
146 p_OTX_Interface IN VARCHAR2,
147 p_DTL_Interface IN VARCHAR2,
148 p_DAC_Interface IN VARCHAR2,
149 p_DTX_Interface IN VARCHAR2,
150 p_ALL_Interface IN VARCHAR2 );
151
152
153 /*=========================================================================*/
154
155 END GML_GPOAO;