APPS.WSH_ITM_PARTY_SYNC dependencies on DBMS_SQL

Line 202: l_num_sourceID_tab DBMS_SQL.Number_Table;

198: l_CursorID NUMBER;
199: l_ignore NUMBER;
200:
201: --PL/SQL Table used for Bulk Select
202: l_num_sourceID_tab DBMS_SQL.Number_Table;
203: l_num_custAccountID_tab DBMS_SQL.Number_Table;
204: l_num_hzpartyID_tab DBMS_SQL.Number_Table;
205:
206: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;

Line 203: l_num_custAccountID_tab DBMS_SQL.Number_Table;

199: l_ignore NUMBER;
200:
201: --PL/SQL Table used for Bulk Select
202: l_num_sourceID_tab DBMS_SQL.Number_Table;
203: l_num_custAccountID_tab DBMS_SQL.Number_Table;
204: l_num_hzpartyID_tab DBMS_SQL.Number_Table;
205:
206: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;
207: l_num_itmpartyID_tab DBMS_SQL.Number_Table;

Line 204: l_num_hzpartyID_tab DBMS_SQL.Number_Table;

200:
201: --PL/SQL Table used for Bulk Select
202: l_num_sourceID_tab DBMS_SQL.Number_Table;
203: l_num_custAccountID_tab DBMS_SQL.Number_Table;
204: l_num_hzpartyID_tab DBMS_SQL.Number_Table;
205:
206: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;
207: l_num_itmpartyID_tab DBMS_SQL.Number_Table;
208:

Line 206: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;

202: l_num_sourceID_tab DBMS_SQL.Number_Table;
203: l_num_custAccountID_tab DBMS_SQL.Number_Table;
204: l_num_hzpartyID_tab DBMS_SQL.Number_Table;
205:
206: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;
207: l_num_itmpartyID_tab DBMS_SQL.Number_Table;
208:
209: l_num_partyrel_tab DBMS_SQL.Number_Table;
210: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;

Line 207: l_num_itmpartyID_tab DBMS_SQL.Number_Table;

203: l_num_custAccountID_tab DBMS_SQL.Number_Table;
204: l_num_hzpartyID_tab DBMS_SQL.Number_Table;
205:
206: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;
207: l_num_itmpartyID_tab DBMS_SQL.Number_Table;
208:
209: l_num_partyrel_tab DBMS_SQL.Number_Table;
210: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
211: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;

Line 209: l_num_partyrel_tab DBMS_SQL.Number_Table;

205:
206: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;
207: l_num_itmpartyID_tab DBMS_SQL.Number_Table;
208:
209: l_num_partyrel_tab DBMS_SQL.Number_Table;
210: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
211: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
212: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
213: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;

Line 210: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;

206: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;
207: l_num_itmpartyID_tab DBMS_SQL.Number_Table;
208:
209: l_num_partyrel_tab DBMS_SQL.Number_Table;
210: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
211: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
212: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
213: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
214: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;

Line 211: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;

207: l_num_itmpartyID_tab DBMS_SQL.Number_Table;
208:
209: l_num_partyrel_tab DBMS_SQL.Number_Table;
210: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
211: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
212: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
213: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
214: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
215: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;

Line 212: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;

208:
209: l_num_partyrel_tab DBMS_SQL.Number_Table;
210: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
211: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
212: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
213: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
214: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
215: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
216: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;

Line 213: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;

209: l_num_partyrel_tab DBMS_SQL.Number_Table;
210: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
211: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
212: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
213: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
214: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
215: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
216: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
217: l_varchar_City_tab DBMS_SQL.Varchar2_Table;

Line 214: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;

210: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
211: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
212: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
213: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
214: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
215: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
216: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
217: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
218: l_varchar_State_tab DBMS_SQL.Varchar2_Table;

Line 215: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;

211: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
212: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
213: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
214: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
215: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
216: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
217: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
218: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
219: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;

Line 216: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;

212: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
213: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
214: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
215: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
216: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
217: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
218: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
219: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
220: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;

Line 217: l_varchar_City_tab DBMS_SQL.Varchar2_Table;

213: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
214: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
215: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
216: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
217: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
218: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
219: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
220: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
221: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;

Line 218: l_varchar_State_tab DBMS_SQL.Varchar2_Table;

214: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
215: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
216: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
217: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
218: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
219: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
220: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
221: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
222: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;

Line 219: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;

215: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
216: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
217: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
218: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
219: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
220: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
221: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
222: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;
223: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;

Line 220: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;

216: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
217: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
218: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
219: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
220: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
221: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
222: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;
223: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;
224: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;

Line 221: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;

217: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
218: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
219: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
220: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
221: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
222: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;
223: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;
224: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;
225:

Line 222: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;

218: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
219: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
220: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
221: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
222: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;
223: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;
224: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;
225:
226:

Line 223: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;

219: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
220: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
221: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
222: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;
223: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;
224: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;
225:
226:
227: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;

Line 224: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;

220: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
221: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
222: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;
223: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;
224: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;
225:
226:
227: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;
228: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;

Line 227: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;

223: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;
224: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;
225:
226:
227: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;
228: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;
229: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;
230: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
231: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;

Line 228: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;

224: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;
225:
226:
227: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;
228: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;
229: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;
230: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
231: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
232:

Line 229: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;

225:
226:
227: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;
228: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;
229: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;
230: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
231: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
232:
233: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;

Line 230: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;

226:
227: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;
228: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;
229: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;
230: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
231: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
232:
233: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
234: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;

Line 231: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;

227: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;
228: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;
229: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;
230: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
231: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
232:
233: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
234: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
235: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;

Line 233: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;

229: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;
230: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
231: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
232:
233: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
234: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
235: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
236: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;

Line 234: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;

230: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
231: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
232:
233: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
234: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
235: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
236: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;

Line 235: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;

231: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
232:
233: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
234: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
235: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
236: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
239: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;

Line 236: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;

232:
233: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
234: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
235: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
236: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
239: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
240: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;

Line 237: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;

233: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
234: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
235: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
236: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
239: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
240: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
241: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;

Line 238: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;

234: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
235: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
236: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
239: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
240: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
241: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
242: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;

Line 239: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;

235: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
236: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
239: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
240: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
241: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
242: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;

Line 240: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;

236: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
239: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
240: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
241: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
242: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
244: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;

Line 241: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;

237: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
239: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
240: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
241: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
242: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
244: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
245: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;

Line 242: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;

238: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
239: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
240: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
241: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
242: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
244: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
245: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;
246: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;

Line 243: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;

239: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
240: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
241: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
242: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
244: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
245: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;
246: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;
247: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;

Line 244: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;

240: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
241: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
242: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
244: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
245: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;
246: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;
247: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;
248:

Line 245: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;

241: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
242: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
244: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
245: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;
246: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;
247: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;
248:
249:

Line 246: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;

242: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
244: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
245: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;
246: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;
247: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;
248:
249:
250: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;

Line 247: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;

243: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
244: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
245: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;
246: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;
247: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;
248:
249:
250: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;
251: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;

Line 250: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;

246: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;
247: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;
248:
249:
250: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;
251: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;
252: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;

Line 251: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;

247: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;
248:
249:
250: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;
251: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;
252: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;

Line 252: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;

248:
249:
250: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;
251: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;
252: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;

Line 253: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;

249:
250: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;
251: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;
252: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;

Line 254: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;

250: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;
251: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;
252: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;

Line 255: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;

251: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;
252: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;

Line 256: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;

252: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;

Line 257: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;

253: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;

Line 258: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;

254: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;

Line 259: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;

255: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;
263: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;

Line 260: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;

256: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;
263: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;
264: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;

Line 261: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;

257: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;
263: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;
264: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;
265:

Line 262: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;

258: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;
263: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;
264: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;
265:
266:

Line 263: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;

259: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;
263: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;
264: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;
265:
266:
267: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;

Line 264: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;

260: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;
263: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;
264: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;
265:
266:
267: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
268: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;

Line 267: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;

263: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;
264: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;
265:
266:
267: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
268: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
269: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
270: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
271: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;

Line 268: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;

264: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;
265:
266:
267: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
268: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
269: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
270: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
271: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
272: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;

Line 269: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;

265:
266:
267: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
268: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
269: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
270: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
271: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
272: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
273: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;

Line 270: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;

266:
267: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
268: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
269: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
270: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
271: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
272: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
273: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
274: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;

Line 271: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;

267: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
268: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
269: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
270: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
271: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
272: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
273: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
274: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
275: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;

Line 272: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;

268: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
269: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
270: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
271: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
272: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
273: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
274: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
275: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
276: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;

Line 273: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;

269: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
270: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
271: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
272: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
273: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
274: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
275: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
276: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
277: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;

Line 274: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;

270: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
271: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
272: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
273: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
274: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
275: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
276: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
277: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
278: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;

Line 275: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;

271: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
272: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
273: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
274: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
275: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
276: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
277: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
278: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
279: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;

Line 276: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;

272: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
273: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
274: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
275: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
276: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
277: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
278: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
279: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
280: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;

Line 277: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;

273: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
274: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
275: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
276: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
277: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
278: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
279: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
280: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
281: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;

Line 278: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;

274: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
275: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
276: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
277: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
278: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
279: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
280: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
281: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
282:

Line 279: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;

275: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
276: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
277: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
278: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
279: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
280: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
281: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
282:
283: --Bug 7297690 Added variable to store the party site id and Org contact id of the contacts who will be screened

Line 280: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;

276: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
277: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
278: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
279: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
280: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
281: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
282:
283: --Bug 7297690 Added variable to store the party site id and Org contact id of the contacts who will be screened
284: l_org_contact_id_tab DBMS_SQL.Number_Table;

Line 281: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;

277: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
278: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
279: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
280: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
281: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
282:
283: --Bug 7297690 Added variable to store the party site id and Org contact id of the contacts who will be screened
284: l_org_contact_id_tab DBMS_SQL.Number_Table;
285: Type l_org_contact_type is table of Varchar2(1) index by BINARY_INTEGER;

Line 284: l_org_contact_id_tab DBMS_SQL.Number_Table;

280: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
281: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
282:
283: --Bug 7297690 Added variable to store the party site id and Org contact id of the contacts who will be screened
284: l_org_contact_id_tab DBMS_SQL.Number_Table;
285: Type l_org_contact_type is table of Varchar2(1) index by BINARY_INTEGER;
286: l_org_contact_cache l_org_contact_type;
287: Type l_party_site_id_type is table of Varchar2(1) index by BINARY_INTEGER;
288: l_party_site_id_cache l_party_site_id_type;

Line 290: l_operating_unit DBMS_SQL.Number_Table;

286: l_org_contact_cache l_org_contact_type;
287: Type l_party_site_id_type is table of Varchar2(1) index by BINARY_INTEGER;
288: l_party_site_id_cache l_party_site_id_type;
289:
290: l_operating_unit DBMS_SQL.Number_Table;
291: l_address_type DBMS_SQL.Varchar2_Table;
292: l_email VARCHAR2(100);
293: l_phone VARCHAR2(100);
294: l_fax VARCHAR2(100);

Line 291: l_address_type DBMS_SQL.Varchar2_Table;

287: Type l_party_site_id_type is table of Varchar2(1) index by BINARY_INTEGER;
288: l_party_site_id_cache l_party_site_id_type;
289:
290: l_operating_unit DBMS_SQL.Number_Table;
291: l_address_type DBMS_SQL.Varchar2_Table;
292: l_email VARCHAR2(100);
293: l_phone VARCHAR2(100);
294: l_fax VARCHAR2(100);
295:

Line 297: l_num_ReqCtrl_tab DBMS_SQL.Number_Table;

293: l_phone VARCHAR2(100);
294: l_fax VARCHAR2(100);
295:
296: --For Insert to ITM Inteface Tables
297: l_num_ReqCtrl_tab DBMS_SQL.Number_Table;
298: l_num_PartyReqCtrl_tab DBMS_SQL.Number_Table;
299: l_tempSourceID NUMBER := -999;
300: j NUMBER;
301:

Line 298: l_num_PartyReqCtrl_tab DBMS_SQL.Number_Table;

294: l_fax VARCHAR2(100);
295:
296: --For Insert to ITM Inteface Tables
297: l_num_ReqCtrl_tab DBMS_SQL.Number_Table;
298: l_num_PartyReqCtrl_tab DBMS_SQL.Number_Table;
299: l_tempSourceID NUMBER := -999;
300: j NUMBER;
301:
302: l_user_id NUMBER;

Line 586: l_CursorID := DBMS_SQL.Open_Cursor;

582: WSH_DEBUG_SV.LOG (l_module_name, 'Query ', l_SQLQuery, WSH_DEBUG_SV.C_STMT_LEVEL);
583: END IF;
584:
585: -- Parse cursor
586: l_CursorID := DBMS_SQL.Open_Cursor;
587: DBMS_SQL.PARSE(l_CursorID, l_SQLQuery, DBMS_SQL.v7);
588:
589:
590:

Line 587: DBMS_SQL.PARSE(l_CursorID, l_SQLQuery, DBMS_SQL.v7);

583: END IF;
584:
585: -- Parse cursor
586: l_CursorID := DBMS_SQL.Open_Cursor;
587: DBMS_SQL.PARSE(l_CursorID, l_SQLQuery, DBMS_SQL.v7);
588:
589:
590:
591: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_sourceID_tab, 100, 0);

Line 591: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_sourceID_tab, 100, 0);

587: DBMS_SQL.PARSE(l_CursorID, l_SQLQuery, DBMS_SQL.v7);
588:
589:
590:
591: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_sourceID_tab, 100, 0);
592: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_hzpartyID_tab, 100, 0);
593: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
594: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
595: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);

Line 592: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_hzpartyID_tab, 100, 0);

588:
589:
590:
591: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_sourceID_tab, 100, 0);
592: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_hzpartyID_tab, 100, 0);
593: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
594: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
595: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
596: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);

Line 593: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);

589:
590:
591: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_sourceID_tab, 100, 0);
592: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_hzpartyID_tab, 100, 0);
593: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
594: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
595: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
596: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
597: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);

Line 594: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);

590:
591: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_sourceID_tab, 100, 0);
592: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_hzpartyID_tab, 100, 0);
593: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
594: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
595: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
596: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
597: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
598: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);

Line 595: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);

591: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_sourceID_tab, 100, 0);
592: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_hzpartyID_tab, 100, 0);
593: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
594: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
595: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
596: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
597: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
598: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
599: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);

Line 596: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);

592: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_hzpartyID_tab, 100, 0);
593: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
594: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
595: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
596: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
597: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
598: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
599: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
600: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);

Line 597: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);

593: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
594: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
595: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
596: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
597: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
598: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
599: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
600: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
601: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);

Line 598: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);

594: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
595: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
596: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
597: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
598: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
599: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
600: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
601: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
602: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);

Line 599: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);

595: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
596: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
597: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
598: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
599: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
600: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
601: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
602: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
603: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);

Line 600: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);

596: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
597: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
598: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
599: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
600: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
601: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
602: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
603: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
604: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);

Line 601: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);

597: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
598: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
599: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
600: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
601: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
602: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
603: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
604: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
605: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);

Line 602: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);

598: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
599: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
600: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
601: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
602: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
603: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
604: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
605: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
606: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);

Line 603: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);

599: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
600: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
601: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
602: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
603: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
604: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
605: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
606: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
607: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);

Line 604: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);

600: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
601: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
602: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
603: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
604: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
605: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
606: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
607: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);
608: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);

Line 605: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);

601: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
602: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
603: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
604: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
605: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
606: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
607: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);
608: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);
609: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);

Line 606: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);

602: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
603: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
604: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
605: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
606: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
607: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);
608: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);
609: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);
610:

Line 607: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);

603: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
604: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
605: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
606: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
607: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);
608: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);
609: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);
610:
611:

Line 608: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);

604: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
605: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
606: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
607: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);
608: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);
609: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);
610:
611:
612: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);

Line 609: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);

605: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
606: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
607: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);
608: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);
609: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);
610:
611:
612: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);
613: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);

Line 612: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);

608: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);
609: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);
610:
611:
612: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);
613: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);
614: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
615: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
616: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);

Line 613: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);

609: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);
610:
611:
612: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);
613: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);
614: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
615: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
616: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
617: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);

Line 614: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);

610:
611:
612: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);
613: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);
614: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
615: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
616: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
617: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
618: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);

Line 615: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);

611:
612: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);
613: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);
614: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
615: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
616: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
617: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
618: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
619: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);

Line 616: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);

612: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);
613: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);
614: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
615: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
616: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
617: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
618: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
619: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
620: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);

Line 617: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);

613: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);
614: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
615: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
616: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
617: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
618: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
619: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
620: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
621: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);

Line 618: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);

614: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
615: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
616: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
617: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
618: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
619: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
620: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
621: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
622: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);

Line 619: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);

615: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
616: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
617: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
618: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
619: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
620: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
621: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
622: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
623: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);

Line 620: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);

616: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
617: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
618: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
619: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
620: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
621: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
622: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
623: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
624: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);

Line 621: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);

617: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
618: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
619: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
620: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
621: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
622: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
623: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
624: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);
625: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 33, l_varchar_tempAttrib14_tab, 100, 0);

Line 622: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);

618: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
619: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
620: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
621: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
622: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
623: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
624: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);
625: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 33, l_varchar_tempAttrib14_tab, 100, 0);
626: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 34, l_varchar_tempAttrib15_tab, 100, 0);

Line 623: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);

619: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
620: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
621: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
622: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
623: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
624: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);
625: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 33, l_varchar_tempAttrib14_tab, 100, 0);
626: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 34, l_varchar_tempAttrib15_tab, 100, 0);
627:

Line 624: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);

620: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
621: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
622: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
623: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
624: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);
625: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 33, l_varchar_tempAttrib14_tab, 100, 0);
626: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 34, l_varchar_tempAttrib15_tab, 100, 0);
627:
628:

Line 625: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 33, l_varchar_tempAttrib14_tab, 100, 0);

621: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
622: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
623: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
624: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);
625: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 33, l_varchar_tempAttrib14_tab, 100, 0);
626: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 34, l_varchar_tempAttrib15_tab, 100, 0);
627:
628:
629:

Line 626: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 34, l_varchar_tempAttrib15_tab, 100, 0);

622: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
623: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
624: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);
625: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 33, l_varchar_tempAttrib14_tab, 100, 0);
626: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 34, l_varchar_tempAttrib15_tab, 100, 0);
627:
628:
629:
630: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 35, l_varchar_Attrib1_tab, 100, 0);

Line 630: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 35, l_varchar_Attrib1_tab, 100, 0);

626: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 34, l_varchar_tempAttrib15_tab, 100, 0);
627:
628:
629:
630: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 35, l_varchar_Attrib1_tab, 100, 0);
631: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 36, l_varchar_Attrib2_tab, 100, 0);
632: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
633: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
634: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);

Line 631: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 36, l_varchar_Attrib2_tab, 100, 0);

627:
628:
629:
630: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 35, l_varchar_Attrib1_tab, 100, 0);
631: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 36, l_varchar_Attrib2_tab, 100, 0);
632: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
633: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
634: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
635: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);

Line 632: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);

628:
629:
630: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 35, l_varchar_Attrib1_tab, 100, 0);
631: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 36, l_varchar_Attrib2_tab, 100, 0);
632: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
633: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
634: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
635: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
636: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);

Line 633: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);

629:
630: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 35, l_varchar_Attrib1_tab, 100, 0);
631: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 36, l_varchar_Attrib2_tab, 100, 0);
632: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
633: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
634: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
635: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
636: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
637: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);

Line 634: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);

630: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 35, l_varchar_Attrib1_tab, 100, 0);
631: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 36, l_varchar_Attrib2_tab, 100, 0);
632: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
633: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
634: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
635: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
636: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
637: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
638: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);

Line 635: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);

631: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 36, l_varchar_Attrib2_tab, 100, 0);
632: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
633: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
634: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
635: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
636: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
637: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
638: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
639: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);

Line 636: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);

632: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
633: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
634: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
635: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
636: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
637: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
638: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
639: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
640: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);

Line 637: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);

633: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
634: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
635: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
636: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
637: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
638: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
639: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
640: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
641: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);

Line 638: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);

634: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
635: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
636: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
637: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
638: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
639: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
640: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
641: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
642: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);

Line 639: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);

635: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
636: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
637: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
638: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
639: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
640: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
641: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
642: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
643: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);

Line 640: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);

636: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
637: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
638: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
639: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
640: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
641: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
642: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
643: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
644: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);

Line 641: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);

637: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
638: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
639: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
640: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
641: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
642: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
643: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
644: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
645: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);

Line 642: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);

638: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
639: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
640: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
641: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
642: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
643: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
644: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
645: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);
646: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0);

Line 643: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);

639: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
640: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
641: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
642: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
643: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
644: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
645: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);
646: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0);
647: --

Line 644: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);

640: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
641: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
642: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
643: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
644: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
645: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);
646: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0);
647: --
648: -- Debug Statements

Line 645: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);

641: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
642: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
643: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
644: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
645: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);
646: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0);
647: --
648: -- Debug Statements
649: --

Line 646: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0);

642: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
643: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
644: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
645: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);
646: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0);
647: --
648: -- Debug Statements
649: --
650: IF l_debug_on THEN

Line 669: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);

665: IF l_debug_on THEN
666: WSH_DEBUG_SV.LOGMSG (l_module_name,'Successfull in binding values',WSH_DEBUG_SV.C_STMT_LEVEL);
667: END IF;
668:
669: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
670:
671:
672: --Bulk Collect customized SQL
673: LOOP

Line 674: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);

670:
671:
672: --Bulk Collect customized SQL
673: LOOP
674: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
675:
676:
677: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_sourceID_tab);
678: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);

Line 677: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_sourceID_tab);

673: LOOP
674: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
675:
676:
677: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_sourceID_tab);
678: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);
679: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
680: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
681: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);

Line 678: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);

674: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
675:
676:
677: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_sourceID_tab);
678: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);
679: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
680: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
681: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
682: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);

Line 679: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);

675:
676:
677: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_sourceID_tab);
678: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);
679: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
680: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
681: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
682: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
683: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);

Line 680: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);

676:
677: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_sourceID_tab);
678: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);
679: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
680: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
681: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
682: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
683: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
684: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);

Line 681: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);

677: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_sourceID_tab);
678: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);
679: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
680: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
681: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
682: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
683: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
684: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
685: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);

Line 682: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);

678: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);
679: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
680: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
681: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
682: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
683: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
684: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
685: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
686: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);

Line 683: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);

679: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
680: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
681: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
682: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
683: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
684: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
685: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
686: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
687: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);

Line 684: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);

680: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
681: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
682: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
683: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
684: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
685: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
686: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
687: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
688: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);

Line 685: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);

681: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
682: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
683: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
684: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
685: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
686: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
687: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
688: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
689: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);

Line 686: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);

682: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
683: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
684: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
685: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
686: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
687: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
688: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
689: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
690: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);

Line 687: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);

683: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
684: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
685: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
686: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
687: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
688: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
689: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
690: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
691: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);

Line 688: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);

684: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
685: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
686: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
687: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
688: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
689: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
690: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
691: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
692: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);

Line 689: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);

685: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
686: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
687: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
688: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
689: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
690: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
691: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
692: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
693: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);

Line 690: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);

686: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
687: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
688: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
689: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
690: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
691: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
692: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
693: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
694: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);

Line 691: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);

687: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
688: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
689: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
690: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
691: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
692: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
693: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
694: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
695: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);

Line 692: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);

688: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
689: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
690: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
691: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
692: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
693: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
694: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
695: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
696:

Line 693: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);

689: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
690: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
691: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
692: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
693: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
694: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
695: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
696:
697: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);

Line 694: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);

690: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
691: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
692: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
693: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
694: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
695: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
696:
697: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
698: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);

Line 695: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);

691: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
692: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
693: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
694: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
695: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
696:
697: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
698: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
699: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);

Line 697: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);

693: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
694: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
695: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
696:
697: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
698: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
699: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
700: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
701: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);

Line 698: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);

694: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
695: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
696:
697: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
698: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
699: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
700: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
701: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
702: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);

Line 699: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);

695: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
696:
697: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
698: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
699: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
700: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
701: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
702: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
703: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);

Line 700: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);

696:
697: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
698: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
699: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
700: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
701: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
702: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
703: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
704: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);

Line 701: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);

697: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
698: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
699: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
700: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
701: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
702: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
703: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
704: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
705: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);

Line 702: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);

698: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
699: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
700: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
701: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
702: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
703: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
704: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
705: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
706: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);

Line 703: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);

699: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
700: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
701: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
702: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
703: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
704: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
705: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
706: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
707: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);

Line 704: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);

700: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
701: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
702: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
703: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
704: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
705: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
706: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
707: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
708: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);

Line 705: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);

701: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
702: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
703: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
704: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
705: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
706: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
707: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
708: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
709: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);

Line 706: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);

702: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
703: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
704: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
705: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
706: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
707: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
708: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
709: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
710: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);

Line 707: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);

703: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
704: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
705: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
706: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
707: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
708: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
709: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
710: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
711: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);

Line 708: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);

704: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
705: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
706: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
707: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
708: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
709: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
710: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
711: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
712:

Line 709: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);

705: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
706: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
707: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
708: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
709: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
710: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
711: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
712:
713: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);

Line 710: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);

706: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
707: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
708: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
709: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
710: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
711: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
712:
713: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
714: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);

Line 711: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);

707: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
708: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
709: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
710: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
711: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
712:
713: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
714: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
715: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);

Line 713: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);

709: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
710: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
711: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
712:
713: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
714: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
715: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
716: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
717: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);

Line 714: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);

710: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
711: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
712:
713: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
714: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
715: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
716: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
717: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);

Line 715: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);

711: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
712:
713: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
714: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
715: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
716: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
717: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
719: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);

Line 716: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);

712:
713: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
714: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
715: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
716: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
717: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
719: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
720: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);

Line 717: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);

713: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
714: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
715: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
716: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
717: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
719: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
720: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
721: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);

Line 718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);

714: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
715: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
716: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
717: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
719: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
720: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
721: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
722: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);

Line 719: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);

715: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
716: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
717: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
719: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
720: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
721: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
722: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
723: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);

Line 720: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);

716: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
717: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
719: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
720: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
721: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
722: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
723: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
724: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);

Line 721: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);

717: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
719: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
720: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
721: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
722: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
723: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
724: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
725: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);

Line 722: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);

718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
719: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
720: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
721: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
722: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
723: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
724: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
725: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
726: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);

Line 723: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);

719: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
720: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
721: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
722: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
723: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
724: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
725: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
726: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
727: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);

Line 724: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);

720: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
721: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
722: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
723: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
724: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
725: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
726: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
727: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
728: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);

Line 725: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);

721: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
722: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
723: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
724: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
725: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
726: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
727: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
728: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);
729: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type);

Line 726: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);

722: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
723: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
724: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
725: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
726: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
727: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
728: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);
729: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type);
730:

Line 727: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);

723: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
724: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
725: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
726: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
727: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
728: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);
729: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type);
730:
731: EXIT WHEN l_ignore <> 100;

Line 728: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);

724: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
725: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
726: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
727: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
728: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);
729: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type);
730:
731: EXIT WHEN l_ignore <> 100;
732:

Line 729: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type);

725: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
726: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
727: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
728: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);
729: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type);
730:
731: EXIT WHEN l_ignore <> 100;
732:
733: END LOOP;

Line 734: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

730:
731: EXIT WHEN l_ignore <> 100;
732:
733: END LOOP;
734: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
735:
736: IF l_debug_on THEN
737: WSH_DEBUG_SV.LOG (l_module_name, 'Number of parties queried : ' ,l_num_sourceID_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);
738: END IF;