74: END;
75:
76: -- Based on asxpopps.pls 115.22 2000/07/07 23:18:17 xding ship $ *
77:
78: FUNCTION GET_P_HEADER_REC RETURN AS_OPPORTUNITY_PUB.HEADER_REC_TYPE IS
79:
80: TEMP_TYPE AS_OPPORTUNITY_PUB.HEADER_REC_TYPE;
81: BEGIN
82: return TEMP_TYPE;
76: -- Based on asxpopps.pls 115.22 2000/07/07 23:18:17 xding ship $ *
77:
78: FUNCTION GET_P_HEADER_REC RETURN AS_OPPORTUNITY_PUB.HEADER_REC_TYPE IS
79:
80: TEMP_TYPE AS_OPPORTUNITY_PUB.HEADER_REC_TYPE;
81: BEGIN
82: return TEMP_TYPE;
83: END;
84:
81: BEGIN
82: return TEMP_TYPE;
83: END;
84:
85: FUNCTION GET_P_HEADER_TBL RETURN AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE IS
86:
87: TEMP_TYPE AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE;
88: BEGIN
89: return TEMP_TYPE;
83: END;
84:
85: FUNCTION GET_P_HEADER_TBL RETURN AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE IS
86:
87: TEMP_TYPE AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE;
88: BEGIN
89: return TEMP_TYPE;
90: END;
91:
88: BEGIN
89: return TEMP_TYPE;
90: END;
91:
92: FUNCTION GET_P_LINE_REC RETURN AS_OPPORTUNITY_PUB.LINE_REC_TYPE IS
93:
94: TEMP_TYPE AS_OPPORTUNITY_PUB.LINE_REC_TYPE;
95: BEGIN
96: return TEMP_TYPE;
90: END;
91:
92: FUNCTION GET_P_LINE_REC RETURN AS_OPPORTUNITY_PUB.LINE_REC_TYPE IS
93:
94: TEMP_TYPE AS_OPPORTUNITY_PUB.LINE_REC_TYPE;
95: BEGIN
96: return TEMP_TYPE;
97: END;
98:
95: BEGIN
96: return TEMP_TYPE;
97: END;
98:
99: FUNCTION GET_P_LINE_TBL RETURN AS_OPPORTUNITY_PUB.LINE_TBL_TYPE IS
100:
101: TEMP_TYPE AS_OPPORTUNITY_PUB.LINE_TBL_TYPE;
102: BEGIN
103: return TEMP_TYPE;
97: END;
98:
99: FUNCTION GET_P_LINE_TBL RETURN AS_OPPORTUNITY_PUB.LINE_TBL_TYPE IS
100:
101: TEMP_TYPE AS_OPPORTUNITY_PUB.LINE_TBL_TYPE;
102: BEGIN
103: return TEMP_TYPE;
104: END;
105:
102: BEGIN
103: return TEMP_TYPE;
104: END;
105:
106: FUNCTION GET_P_LINE_OUT_REC RETURN AS_OPPORTUNITY_PUB.LINE_OUT_REC_TYPE IS
107:
108: TEMP_TYPE AS_OPPORTUNITY_PUB.LINE_OUT_REC_TYPE;
109: BEGIN
110: return TEMP_TYPE;
104: END;
105:
106: FUNCTION GET_P_LINE_OUT_REC RETURN AS_OPPORTUNITY_PUB.LINE_OUT_REC_TYPE IS
107:
108: TEMP_TYPE AS_OPPORTUNITY_PUB.LINE_OUT_REC_TYPE;
109: BEGIN
110: return TEMP_TYPE;
111: END;
112:
109: BEGIN
110: return TEMP_TYPE;
111: END;
112:
113: FUNCTION GET_P_LINE_OUT_TBL RETURN AS_OPPORTUNITY_PUB.LINE_OUT_TBL_TYPE IS
114:
115: TEMP_TYPE AS_OPPORTUNITY_PUB.LINE_OUT_TBL_TYPE;
116: BEGIN
117: return TEMP_TYPE;
111: END;
112:
113: FUNCTION GET_P_LINE_OUT_TBL RETURN AS_OPPORTUNITY_PUB.LINE_OUT_TBL_TYPE IS
114:
115: TEMP_TYPE AS_OPPORTUNITY_PUB.LINE_OUT_TBL_TYPE;
116: BEGIN
117: return TEMP_TYPE;
118: END;
119:
116: BEGIN
117: return TEMP_TYPE;
118: END;
119:
120: FUNCTION GET_P_SALES_CREDIT_REC RETURN AS_OPPORTUNITY_PUB.SALES_CREDIT_REC_TYPE IS
121:
122: TEMP_TYPE AS_OPPORTUNITY_PUB.SALES_CREDIT_REC_TYPE;
123: BEGIN
124: return TEMP_TYPE;
118: END;
119:
120: FUNCTION GET_P_SALES_CREDIT_REC RETURN AS_OPPORTUNITY_PUB.SALES_CREDIT_REC_TYPE IS
121:
122: TEMP_TYPE AS_OPPORTUNITY_PUB.SALES_CREDIT_REC_TYPE;
123: BEGIN
124: return TEMP_TYPE;
125: END;
126:
123: BEGIN
124: return TEMP_TYPE;
125: END;
126:
127: FUNCTION GET_P_SALES_CREDIT_TBL RETURN AS_OPPORTUNITY_PUB.SALES_CREDIT_TBL_TYPE IS
128:
129: TEMP_TYPE AS_OPPORTUNITY_PUB.SALES_CREDIT_TBL_TYPE;
130: BEGIN
131: return TEMP_TYPE;
125: END;
126:
127: FUNCTION GET_P_SALES_CREDIT_TBL RETURN AS_OPPORTUNITY_PUB.SALES_CREDIT_TBL_TYPE IS
128:
129: TEMP_TYPE AS_OPPORTUNITY_PUB.SALES_CREDIT_TBL_TYPE;
130: BEGIN
131: return TEMP_TYPE;
132: END;
133:
130: BEGIN
131: return TEMP_TYPE;
132: END;
133:
134: FUNCTION GET_P_SALES_CREDIT_OUT_REC RETURN AS_OPPORTUNITY_PUB.SALES_CREDIT_OUT_REC_TYPE IS
135:
136: TEMP_TYPE AS_OPPORTUNITY_PUB.SALES_CREDIT_OUT_REC_TYPE;
137: BEGIN
138: return TEMP_TYPE;
132: END;
133:
134: FUNCTION GET_P_SALES_CREDIT_OUT_REC RETURN AS_OPPORTUNITY_PUB.SALES_CREDIT_OUT_REC_TYPE IS
135:
136: TEMP_TYPE AS_OPPORTUNITY_PUB.SALES_CREDIT_OUT_REC_TYPE;
137: BEGIN
138: return TEMP_TYPE;
139: END;
140:
137: BEGIN
138: return TEMP_TYPE;
139: END;
140:
141: FUNCTION GET_P_SALES_CREDIT_OUT_TBL RETURN AS_OPPORTUNITY_PUB.SALES_CREDIT_OUT_TBL_TYPE IS
142:
143: TEMP_TYPE AS_OPPORTUNITY_PUB.SALES_CREDIT_OUT_TBL_TYPE;
144: BEGIN
145: return TEMP_TYPE;
139: END;
140:
141: FUNCTION GET_P_SALES_CREDIT_OUT_TBL RETURN AS_OPPORTUNITY_PUB.SALES_CREDIT_OUT_TBL_TYPE IS
142:
143: TEMP_TYPE AS_OPPORTUNITY_PUB.SALES_CREDIT_OUT_TBL_TYPE;
144: BEGIN
145: return TEMP_TYPE;
146: END;
147:
144: BEGIN
145: return TEMP_TYPE;
146: END;
147:
148: FUNCTION GET_P_OBSTACLE_REC RETURN AS_OPPORTUNITY_PUB.OBSTACLE_REC_TYPE IS
149:
150: TEMP_TYPE AS_OPPORTUNITY_PUB.OBSTACLE_REC_TYPE;
151: BEGIN
152: return TEMP_TYPE;
146: END;
147:
148: FUNCTION GET_P_OBSTACLE_REC RETURN AS_OPPORTUNITY_PUB.OBSTACLE_REC_TYPE IS
149:
150: TEMP_TYPE AS_OPPORTUNITY_PUB.OBSTACLE_REC_TYPE;
151: BEGIN
152: return TEMP_TYPE;
153: END;
154:
151: BEGIN
152: return TEMP_TYPE;
153: END;
154:
155: FUNCTION GET_P_OBSTACLE_TBL RETURN AS_OPPORTUNITY_PUB.OBSTACLE_TBL_TYPE IS
156:
157: TEMP_TYPE AS_OPPORTUNITY_PUB.OBSTACLE_TBL_TYPE;
158: BEGIN
159: return TEMP_TYPE;
153: END;
154:
155: FUNCTION GET_P_OBSTACLE_TBL RETURN AS_OPPORTUNITY_PUB.OBSTACLE_TBL_TYPE IS
156:
157: TEMP_TYPE AS_OPPORTUNITY_PUB.OBSTACLE_TBL_TYPE;
158: BEGIN
159: return TEMP_TYPE;
160: END;
161:
158: BEGIN
159: return TEMP_TYPE;
160: END;
161:
162: FUNCTION GET_P_OBSTACLE_OUT_REC RETURN AS_OPPORTUNITY_PUB.OBSTACLE_OUT_REC_TYPE IS
163:
164: TEMP_TYPE AS_OPPORTUNITY_PUB.OBSTACLE_OUT_REC_TYPE;
165: BEGIN
166: return TEMP_TYPE;
160: END;
161:
162: FUNCTION GET_P_OBSTACLE_OUT_REC RETURN AS_OPPORTUNITY_PUB.OBSTACLE_OUT_REC_TYPE IS
163:
164: TEMP_TYPE AS_OPPORTUNITY_PUB.OBSTACLE_OUT_REC_TYPE;
165: BEGIN
166: return TEMP_TYPE;
167: END;
168:
165: BEGIN
166: return TEMP_TYPE;
167: END;
168:
169: FUNCTION GET_P_OBSTACLE_OUT_TBL RETURN AS_OPPORTUNITY_PUB.OBSTACLE_OUT_TBL_TYPE IS
170:
171: TEMP_TYPE AS_OPPORTUNITY_PUB.OBSTACLE_OUT_TBL_TYPE;
172: BEGIN
173: return TEMP_TYPE;
167: END;
168:
169: FUNCTION GET_P_OBSTACLE_OUT_TBL RETURN AS_OPPORTUNITY_PUB.OBSTACLE_OUT_TBL_TYPE IS
170:
171: TEMP_TYPE AS_OPPORTUNITY_PUB.OBSTACLE_OUT_TBL_TYPE;
172: BEGIN
173: return TEMP_TYPE;
174: END;
175:
172: BEGIN
173: return TEMP_TYPE;
174: END;
175:
176: FUNCTION GET_P_COMPETITOR_REC RETURN AS_OPPORTUNITY_PUB.COMPETITOR_REC_TYPE IS
177:
178: TEMP_TYPE AS_OPPORTUNITY_PUB.COMPETITOR_REC_TYPE;
179: BEGIN
180: return TEMP_TYPE;
174: END;
175:
176: FUNCTION GET_P_COMPETITOR_REC RETURN AS_OPPORTUNITY_PUB.COMPETITOR_REC_TYPE IS
177:
178: TEMP_TYPE AS_OPPORTUNITY_PUB.COMPETITOR_REC_TYPE;
179: BEGIN
180: return TEMP_TYPE;
181: END;
182:
179: BEGIN
180: return TEMP_TYPE;
181: END;
182:
183: FUNCTION GET_P_COMPETITOR_TBL RETURN AS_OPPORTUNITY_PUB.COMPETITOR_TBL_TYPE IS
184:
185: TEMP_TYPE AS_OPPORTUNITY_PUB.COMPETITOR_TBL_TYPE;
186: BEGIN
187: return TEMP_TYPE;
181: END;
182:
183: FUNCTION GET_P_COMPETITOR_TBL RETURN AS_OPPORTUNITY_PUB.COMPETITOR_TBL_TYPE IS
184:
185: TEMP_TYPE AS_OPPORTUNITY_PUB.COMPETITOR_TBL_TYPE;
186: BEGIN
187: return TEMP_TYPE;
188: END;
189:
186: BEGIN
187: return TEMP_TYPE;
188: END;
189:
190: FUNCTION GET_P_COMPETITOR_OUT_REC RETURN AS_OPPORTUNITY_PUB.COMPETITOR_OUT_REC_TYPE IS
191:
192: TEMP_TYPE AS_OPPORTUNITY_PUB.COMPETITOR_OUT_REC_TYPE;
193: BEGIN
194: return TEMP_TYPE;
188: END;
189:
190: FUNCTION GET_P_COMPETITOR_OUT_REC RETURN AS_OPPORTUNITY_PUB.COMPETITOR_OUT_REC_TYPE IS
191:
192: TEMP_TYPE AS_OPPORTUNITY_PUB.COMPETITOR_OUT_REC_TYPE;
193: BEGIN
194: return TEMP_TYPE;
195: END;
196:
193: BEGIN
194: return TEMP_TYPE;
195: END;
196:
197: FUNCTION GET_P_COMPETITOR_OUT_TBL RETURN AS_OPPORTUNITY_PUB.COMPETITOR_OUT_TBL_TYPE IS
198:
199: TEMP_TYPE AS_OPPORTUNITY_PUB.COMPETITOR_OUT_TBL_TYPE;
200: BEGIN
201: return TEMP_TYPE;
195: END;
196:
197: FUNCTION GET_P_COMPETITOR_OUT_TBL RETURN AS_OPPORTUNITY_PUB.COMPETITOR_OUT_TBL_TYPE IS
198:
199: TEMP_TYPE AS_OPPORTUNITY_PUB.COMPETITOR_OUT_TBL_TYPE;
200: BEGIN
201: return TEMP_TYPE;
202: END;
203:
200: BEGIN
201: return TEMP_TYPE;
202: END;
203:
204: FUNCTION GET_P_ORDER_REC RETURN AS_OPPORTUNITY_PUB.ORDER_REC_TYPE IS
205:
206: TEMP_TYPE AS_OPPORTUNITY_PUB.ORDER_REC_TYPE;
207: BEGIN
208: return TEMP_TYPE;
202: END;
203:
204: FUNCTION GET_P_ORDER_REC RETURN AS_OPPORTUNITY_PUB.ORDER_REC_TYPE IS
205:
206: TEMP_TYPE AS_OPPORTUNITY_PUB.ORDER_REC_TYPE;
207: BEGIN
208: return TEMP_TYPE;
209: END;
210:
207: BEGIN
208: return TEMP_TYPE;
209: END;
210:
211: FUNCTION GET_P_ORDER_TBL RETURN AS_OPPORTUNITY_PUB.ORDER_TBL_TYPE IS
212:
213: TEMP_TYPE AS_OPPORTUNITY_PUB.ORDER_TBL_TYPE;
214: BEGIN
215: return TEMP_TYPE;
209: END;
210:
211: FUNCTION GET_P_ORDER_TBL RETURN AS_OPPORTUNITY_PUB.ORDER_TBL_TYPE IS
212:
213: TEMP_TYPE AS_OPPORTUNITY_PUB.ORDER_TBL_TYPE;
214: BEGIN
215: return TEMP_TYPE;
216: END;
217:
214: BEGIN
215: return TEMP_TYPE;
216: END;
217:
218: FUNCTION GET_P_ORDER_OUT_REC RETURN AS_OPPORTUNITY_PUB.ORDER_OUT_REC_TYPE IS
219:
220: TEMP_TYPE AS_OPPORTUNITY_PUB.ORDER_OUT_REC_TYPE;
221: BEGIN
222: return TEMP_TYPE;
216: END;
217:
218: FUNCTION GET_P_ORDER_OUT_REC RETURN AS_OPPORTUNITY_PUB.ORDER_OUT_REC_TYPE IS
219:
220: TEMP_TYPE AS_OPPORTUNITY_PUB.ORDER_OUT_REC_TYPE;
221: BEGIN
222: return TEMP_TYPE;
223: END;
224:
221: BEGIN
222: return TEMP_TYPE;
223: END;
224:
225: FUNCTION GET_P_ORDER_OUT_TBL RETURN AS_OPPORTUNITY_PUB.ORDER_OUT_TBL_TYPE IS
226:
227: TEMP_TYPE AS_OPPORTUNITY_PUB.ORDER_OUT_TBL_TYPE;
228: BEGIN
229: return TEMP_TYPE;
223: END;
224:
225: FUNCTION GET_P_ORDER_OUT_TBL RETURN AS_OPPORTUNITY_PUB.ORDER_OUT_TBL_TYPE IS
226:
227: TEMP_TYPE AS_OPPORTUNITY_PUB.ORDER_OUT_TBL_TYPE;
228: BEGIN
229: return TEMP_TYPE;
230: END;
231:
228: BEGIN
229: return TEMP_TYPE;
230: END;
231:
232: FUNCTION GET_P_CONTACT_REC RETURN AS_OPPORTUNITY_PUB.CONTACT_REC_TYPE IS
233:
234: TEMP_TYPE AS_OPPORTUNITY_PUB.CONTACT_REC_TYPE;
235: BEGIN
236: return TEMP_TYPE;
230: END;
231:
232: FUNCTION GET_P_CONTACT_REC RETURN AS_OPPORTUNITY_PUB.CONTACT_REC_TYPE IS
233:
234: TEMP_TYPE AS_OPPORTUNITY_PUB.CONTACT_REC_TYPE;
235: BEGIN
236: return TEMP_TYPE;
237: END;
238:
235: BEGIN
236: return TEMP_TYPE;
237: END;
238:
239: FUNCTION GET_P_CONTACT_TBL RETURN AS_OPPORTUNITY_PUB.CONTACT_TBL_TYPE IS
240:
241: TEMP_TYPE AS_OPPORTUNITY_PUB.CONTACT_TBL_TYPE;
242: BEGIN
243: return TEMP_TYPE;
237: END;
238:
239: FUNCTION GET_P_CONTACT_TBL RETURN AS_OPPORTUNITY_PUB.CONTACT_TBL_TYPE IS
240:
241: TEMP_TYPE AS_OPPORTUNITY_PUB.CONTACT_TBL_TYPE;
242: BEGIN
243: return TEMP_TYPE;
244: END;
245:
242: BEGIN
243: return TEMP_TYPE;
244: END;
245:
246: FUNCTION GET_P_CONTACT_OUT_REC RETURN AS_OPPORTUNITY_PUB.CONTACT_OUT_REC_TYPE IS
247:
248: TEMP_TYPE AS_OPPORTUNITY_PUB.CONTACT_OUT_REC_TYPE;
249: BEGIN
250: return TEMP_TYPE;
244: END;
245:
246: FUNCTION GET_P_CONTACT_OUT_REC RETURN AS_OPPORTUNITY_PUB.CONTACT_OUT_REC_TYPE IS
247:
248: TEMP_TYPE AS_OPPORTUNITY_PUB.CONTACT_OUT_REC_TYPE;
249: BEGIN
250: return TEMP_TYPE;
251: END;
252:
249: BEGIN
250: return TEMP_TYPE;
251: END;
252:
253: FUNCTION GET_P_CONTACT_OUT_TBL RETURN AS_OPPORTUNITY_PUB.CONTACT_OUT_TBL_TYPE IS
254:
255: TEMP_TYPE AS_OPPORTUNITY_PUB.CONTACT_OUT_TBL_TYPE;
256: BEGIN
257: return TEMP_TYPE;
251: END;
252:
253: FUNCTION GET_P_CONTACT_OUT_TBL RETURN AS_OPPORTUNITY_PUB.CONTACT_OUT_TBL_TYPE IS
254:
255: TEMP_TYPE AS_OPPORTUNITY_PUB.CONTACT_OUT_TBL_TYPE;
256: BEGIN
257: return TEMP_TYPE;
258: END;
259: