[Home] [Help]
PACKAGE: APPS.GML_GPOAO_X
Source
1 PACKAGE GML_GPOAO_X AUTHID CURRENT_USER as
2 /* $Header: GMLPAOXS.pls 115.1 99/07/16 06:16:30 porting ship $ */
3 /*============================ GML_GPOAO_X ================================*/
4 /*===========================================================================
5 PACKAGE NAME: GML_GPOAO_X
6
7 DESCRIPTION: Contains the stub procedures called during the Gateway
8 export process. These procedures may be customized as
9 necessary to populate extension tables.
10
11 CLIENT/SERVER: Server
12
13 LIBRARY NAME: None
14
15 PROCEDURE/FUNCTIONS: Populate_ORD_Ext()
16 Populate_OAC_Ext()
17 Populate_OTX_Ext()
18 Populate_DTL_Ext()
19 Populate_DAC_Ext()
20 Populate_DTX_Ext()
21 Populate_ALL_Ext()
22
23 NOTES: To run the script:
24
25 sql> start GMLPAOXS.pls
26
27 HISTORY 02/15/99 dgrailic Created.
28 05/17/99 dgrailic Modified to use GML_ prefix
29
30 /*===========================================================================
31 PROCEDURE NAME: Populate_ORD_Ext
32
33 DESCRIPTION: Stub procedure to populate Order extension table.
34
35 PARAMETERS: p_ORD_Key IN NUMBER
36 p_ORD_Table IN ece_flatfile_pvt.Interface_tbl_type
37
38 DESIGN REFERENCES: gpoao_hld.rtf.
39
40 ALGORITHM:
41
42 NOTES:
43
44 OPEN ISSUES:
45
46 CLOSED ISSUES:
47
48 CHANGE HISTORY: 02/24/99 dgrailic Created.
49
50 ===========================================================================*/
51
52 PROCEDURE Populate_ORD_Ext (
53 p_ORD_Key IN NUMBER,
54 p_ORD_Table IN ece_flatfile_pvt.Interface_tbl_type );
55
56 /*===========================================================================
57 PROCEDURE NAME: Populate_OAC_Ext
58
59 DESCRIPTION: Stub procedure to populate Order Charges ext table.
60
61 PARAMETERS: p_OAC_Key IN NUMBER
62 p_OAC_Table IN ece_flatfile_pvt.Interface_tbl_type
63
64 DESIGN REFERENCES: gpoao_hld.rtf.
65
66 ALGORITHM:
67
68 NOTES:
69
70 OPEN ISSUES:
71
72 CLOSED ISSUES:
73
74 CHANGE HISTORY: 02/24/99 dgrailic Created.
75
76 ===========================================================================*/
77
78 PROCEDURE Populate_OAC_Ext (
79 p_OAC_Key IN NUMBER,
80 p_OAC_Table IN ece_flatfile_pvt.Interface_tbl_type );
81
82 /*===========================================================================
83 PROCEDURE NAME: Populate_OTX_Ext
84
85 DESCRIPTION: Stub procedure to populate Order Text extension table.
86
87 PARAMETERS: p_OTX_Key IN NUMBER
88 p_OTX_Table IN ece_flatfile_pvt.Interface_tbl_type
89
90 DESIGN REFERENCES: gpoao_hld.rtf.
91
92 ALGORITHM:
93
94 NOTES:
95
96 OPEN ISSUES:
97
98 CLOSED ISSUES:
99
100 CHANGE HISTORY: 02/24/99 dgrailic Created.
101
102 ===========================================================================*/
103
104 PROCEDURE Populate_OTX_Ext (
105 p_OTX_Key IN NUMBER,
106 p_OTX_Table IN ece_flatfile_pvt.Interface_tbl_type );
107
108 /*===========================================================================
109 PROCEDURE NAME: Populate_DTL_Ext
110
111 DESCRIPTION: Stub procedure to populate Detail extension table.
112
113 PARAMETERS: p_DTL_Key IN NUMBER
114 p_DTL_Table IN ece_flatfile_pvt.Interface_tbl_type
115
116 DESIGN REFERENCES: gpoao_hld.rtf.
117
118 ALGORITHM:
119
120 NOTES:
121
122 OPEN ISSUES:
123
124 CLOSED ISSUES:
125
126 CHANGE HISTORY: 02/24/99 dgrailic Created.
127
128 ===========================================================================*/
129
130 PROCEDURE Populate_DTL_Ext (
131 p_DTL_Key IN NUMBER,
132 p_DTL_Table IN ece_flatfile_pvt.Interface_tbl_type );
133
134 /*===========================================================================
135 PROCEDURE NAME: Populate_DAC_Ext
136
137 DESCRIPTION: Stub procedure to populate Detail Charges ext table.
138
139 PARAMETERS: p_DAC_Key IN NUMBER
140 p_DAC_Table IN ece_flatfile_pvt.Interface_tbl_type
141
142 DESIGN REFERENCES: gpoao_hld.rtf.
143
144 ALGORITHM:
145
146 NOTES:
147
148 OPEN ISSUES:
149
150 CLOSED ISSUES:
151
152 CHANGE HISTORY: 02/24/99 dgrailic Created.
153
154 ===========================================================================*/
155
156 PROCEDURE Populate_DAC_Ext (
157 p_DAC_Key IN NUMBER,
158 p_DAC_Table IN ece_flatfile_pvt.Interface_tbl_type );
159
160 /*===========================================================================
161 PROCEDURE NAME: Populate_DTX_Ext
162
163 DESCRIPTION: Stub procedure to populate Detail Text extension table.
164
165 PARAMETERS: p_DTX_Key IN NUMBER
166 p_DTX_Table IN ece_flatfile_pvt.Interface_tbl_type
167
168 DESIGN REFERENCES: gpoao_hld.rtf.
169
170 ALGORITHM:
171
172 NOTES:
173
174 OPEN ISSUES:
175
176 CLOSED ISSUES:
177
178 CHANGE HISTORY: 02/24/99 dgrailic Created.
179
180 ===========================================================================*/
181
182 PROCEDURE Populate_DTX_Ext (
183 p_DTX_Key IN NUMBER,
184 p_DTX_Table IN ece_flatfile_pvt.Interface_tbl_type );
185
186 /*===========================================================================
187 PROCEDURE NAME: Populate_ALL_Ext
188
189 DESCRIPTION: Stub procedure to populate Detail allocations (lot info)
190 extension table.
191
192 PARAMETERS: p_ALL_Key IN NUMBER
193 p_ALL_Table IN ece_flatfile_pvt.Interface_tbl_type
194
195 DESIGN REFERENCES: gpoao_hld.rtf.
196
197 ALGORITHM:
198
199 NOTES:
200
201 OPEN ISSUES:
202
203 CLOSED ISSUES:
204
205 CHANGE HISTORY: 02/24/99 dgrailic Created.
206
207 ===========================================================================*/
208
209 PROCEDURE Populate_ALL_Ext (
210 p_ALL_Key IN NUMBER,
211 p_ALL_Table IN ece_flatfile_pvt.Interface_tbl_type );
212
213 END GML_GPOAO_X;