APPS.WSH_ITM_PARTY_SYNC dependencies on DBMS_SQL

Line 342: l_num_sourceID_tab DBMS_SQL.Number_Table;

338: l_CursorID NUMBER;
339: l_ignore NUMBER;
340:
341: --PL/SQL Table used for Bulk Select
342: l_num_sourceID_tab DBMS_SQL.Number_Table;
343: l_num_custAccountID_tab DBMS_SQL.Number_Table;
344: l_num_hzpartyID_tab DBMS_SQL.Number_Table;
345:
346: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;

Line 343: l_num_custAccountID_tab DBMS_SQL.Number_Table;

339: l_ignore NUMBER;
340:
341: --PL/SQL Table used for Bulk Select
342: l_num_sourceID_tab DBMS_SQL.Number_Table;
343: l_num_custAccountID_tab DBMS_SQL.Number_Table;
344: l_num_hzpartyID_tab DBMS_SQL.Number_Table;
345:
346: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;
347: l_num_itmpartyID_tab DBMS_SQL.Number_Table;

Line 344: l_num_hzpartyID_tab DBMS_SQL.Number_Table;

340:
341: --PL/SQL Table used for Bulk Select
342: l_num_sourceID_tab DBMS_SQL.Number_Table;
343: l_num_custAccountID_tab DBMS_SQL.Number_Table;
344: l_num_hzpartyID_tab DBMS_SQL.Number_Table;
345:
346: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;
347: l_num_itmpartyID_tab DBMS_SQL.Number_Table;
348:

Line 346: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;

342: l_num_sourceID_tab DBMS_SQL.Number_Table;
343: l_num_custAccountID_tab DBMS_SQL.Number_Table;
344: l_num_hzpartyID_tab DBMS_SQL.Number_Table;
345:
346: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;
347: l_num_itmpartyID_tab DBMS_SQL.Number_Table;
348:
349: l_num_partyrel_tab DBMS_SQL.Number_Table;
350: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;

Line 347: l_num_itmpartyID_tab DBMS_SQL.Number_Table;

343: l_num_custAccountID_tab DBMS_SQL.Number_Table;
344: l_num_hzpartyID_tab DBMS_SQL.Number_Table;
345:
346: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;
347: l_num_itmpartyID_tab DBMS_SQL.Number_Table;
348:
349: l_num_partyrel_tab DBMS_SQL.Number_Table;
350: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
351: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;

Line 349: l_num_partyrel_tab DBMS_SQL.Number_Table;

345:
346: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;
347: l_num_itmpartyID_tab DBMS_SQL.Number_Table;
348:
349: l_num_partyrel_tab DBMS_SQL.Number_Table;
350: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
351: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
352: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
353: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;

Line 350: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;

346: l_num_hzpartySiteID_tab DBMS_SQL.Number_Table;
347: l_num_itmpartyID_tab DBMS_SQL.Number_Table;
348:
349: l_num_partyrel_tab DBMS_SQL.Number_Table;
350: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
351: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
352: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
353: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
354: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;

Line 351: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;

347: l_num_itmpartyID_tab DBMS_SQL.Number_Table;
348:
349: l_num_partyrel_tab DBMS_SQL.Number_Table;
350: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
351: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
352: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
353: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
354: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
355: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;

Line 352: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;

348:
349: l_num_partyrel_tab DBMS_SQL.Number_Table;
350: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
351: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
352: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
353: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
354: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
355: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
356: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;

Line 353: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;

349: l_num_partyrel_tab DBMS_SQL.Number_Table;
350: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
351: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
352: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
353: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
354: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
355: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
356: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
357: l_varchar_City_tab DBMS_SQL.Varchar2_Table;

Line 354: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;

350: l_varchar_PartnrType_tab DBMS_SQL.Varchar2_Table;
351: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
352: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
353: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
354: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
355: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
356: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
357: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
358: l_varchar_State_tab DBMS_SQL.Varchar2_Table;

Line 355: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;

351: l_varchar_PartyName_tab DBMS_SQL.Varchar2_Table;
352: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
353: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
354: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
355: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
356: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
357: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
358: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
359: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;

Line 356: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;

352: l_varchar_AlternateName_tab DBMS_SQL.Varchar2_Table;
353: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
354: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
355: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
356: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
357: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
358: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
359: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
360: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;

Line 357: l_varchar_City_tab DBMS_SQL.Varchar2_Table;

353: l_varchar_Address1_tab DBMS_SQL.Varchar2_Table;
354: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
355: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
356: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
357: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
358: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
359: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
360: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
361: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;

Line 358: l_varchar_State_tab DBMS_SQL.Varchar2_Table;

354: l_varchar_Address2_tab DBMS_SQL.Varchar2_Table;
355: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
356: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
357: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
358: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
359: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
360: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
361: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
362: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;

Line 359: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;

355: l_varchar_Address3_tab DBMS_SQL.Varchar2_Table;
356: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
357: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
358: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
359: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
360: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
361: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
362: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;
363: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;

Line 360: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;

356: l_varchar_Address4_tab DBMS_SQL.Varchar2_Table;
357: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
358: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
359: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
360: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
361: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
362: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;
363: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;
364: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;

Line 361: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;

357: l_varchar_City_tab DBMS_SQL.Varchar2_Table;
358: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
359: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
360: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
361: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
362: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;
363: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;
364: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;
365:

Line 362: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;

358: l_varchar_State_tab DBMS_SQL.Varchar2_Table;
359: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
360: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
361: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
362: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;
363: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;
364: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;
365:
366: -- gtm: contact start

Line 363: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;

359: l_varchar_Country_tab DBMS_SQL.Varchar2_Table;
360: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
361: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
362: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;
363: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;
364: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;
365:
366: -- gtm: contact start
367: l_num_CtPartyId_tab DBMS_SQL.Number_Table;

Line 364: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;

360: l_varchar_PostalCode_tab DBMS_SQL.Varchar2_Table;
361: l_varchar_TaxRef_tab DBMS_SQL.Varchar2_Table;
362: l_varchar_AcctNumber_tab DBMS_SQL.Varchar2_Table;
363: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;
364: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;
365:
366: -- gtm: contact start
367: l_num_CtPartyId_tab DBMS_SQL.Number_Table;
368: l_varchar_CtPartyNum_tab DBMS_SQL.Varchar2_Table;

Line 367: l_num_CtPartyId_tab DBMS_SQL.Number_Table;

363: l_varchar_AcctName_tab DBMS_SQL.Varchar2_Table;
364: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;
365:
366: -- gtm: contact start
367: l_num_CtPartyId_tab DBMS_SQL.Number_Table;
368: l_varchar_CtPartyNum_tab DBMS_SQL.Varchar2_Table;
369: l_ct_alternate_name_tab DBMS_SQL.Varchar2_Table;
370: l_ct_party_type_tab DBMS_SQL.Varchar2_Table;
371: l_ct_status_tab DBMS_SQL.Varchar2_Table;

Line 368: l_varchar_CtPartyNum_tab DBMS_SQL.Varchar2_Table;

364: l_varchar_SiteNumber_tab DBMS_SQL.Varchar2_Table;
365:
366: -- gtm: contact start
367: l_num_CtPartyId_tab DBMS_SQL.Number_Table;
368: l_varchar_CtPartyNum_tab DBMS_SQL.Varchar2_Table;
369: l_ct_alternate_name_tab DBMS_SQL.Varchar2_Table;
370: l_ct_party_type_tab DBMS_SQL.Varchar2_Table;
371: l_ct_status_tab DBMS_SQL.Varchar2_Table;
372: l_ct_first_name_tab DBMS_SQL.Varchar2_Table;

Line 369: l_ct_alternate_name_tab DBMS_SQL.Varchar2_Table;

365:
366: -- gtm: contact start
367: l_num_CtPartyId_tab DBMS_SQL.Number_Table;
368: l_varchar_CtPartyNum_tab DBMS_SQL.Varchar2_Table;
369: l_ct_alternate_name_tab DBMS_SQL.Varchar2_Table;
370: l_ct_party_type_tab DBMS_SQL.Varchar2_Table;
371: l_ct_status_tab DBMS_SQL.Varchar2_Table;
372: l_ct_first_name_tab DBMS_SQL.Varchar2_Table;
373: l_ct_middle_name_tab DBMS_SQL.Varchar2_Table;

Line 370: l_ct_party_type_tab DBMS_SQL.Varchar2_Table;

366: -- gtm: contact start
367: l_num_CtPartyId_tab DBMS_SQL.Number_Table;
368: l_varchar_CtPartyNum_tab DBMS_SQL.Varchar2_Table;
369: l_ct_alternate_name_tab DBMS_SQL.Varchar2_Table;
370: l_ct_party_type_tab DBMS_SQL.Varchar2_Table;
371: l_ct_status_tab DBMS_SQL.Varchar2_Table;
372: l_ct_first_name_tab DBMS_SQL.Varchar2_Table;
373: l_ct_middle_name_tab DBMS_SQL.Varchar2_Table;
374: l_ct_last_name_tab DBMS_SQL.Varchar2_Table;

Line 371: l_ct_status_tab DBMS_SQL.Varchar2_Table;

367: l_num_CtPartyId_tab DBMS_SQL.Number_Table;
368: l_varchar_CtPartyNum_tab DBMS_SQL.Varchar2_Table;
369: l_ct_alternate_name_tab DBMS_SQL.Varchar2_Table;
370: l_ct_party_type_tab DBMS_SQL.Varchar2_Table;
371: l_ct_status_tab DBMS_SQL.Varchar2_Table;
372: l_ct_first_name_tab DBMS_SQL.Varchar2_Table;
373: l_ct_middle_name_tab DBMS_SQL.Varchar2_Table;
374: l_ct_last_name_tab DBMS_SQL.Varchar2_Table;
375: l_ct_country_tab DBMS_SQL.Varchar2_Table;

Line 372: l_ct_first_name_tab DBMS_SQL.Varchar2_Table;

368: l_varchar_CtPartyNum_tab DBMS_SQL.Varchar2_Table;
369: l_ct_alternate_name_tab DBMS_SQL.Varchar2_Table;
370: l_ct_party_type_tab DBMS_SQL.Varchar2_Table;
371: l_ct_status_tab DBMS_SQL.Varchar2_Table;
372: l_ct_first_name_tab DBMS_SQL.Varchar2_Table;
373: l_ct_middle_name_tab DBMS_SQL.Varchar2_Table;
374: l_ct_last_name_tab DBMS_SQL.Varchar2_Table;
375: l_ct_country_tab DBMS_SQL.Varchar2_Table;
376: l_ct_address1_tab DBMS_SQL.Varchar2_Table;

Line 373: l_ct_middle_name_tab DBMS_SQL.Varchar2_Table;

369: l_ct_alternate_name_tab DBMS_SQL.Varchar2_Table;
370: l_ct_party_type_tab DBMS_SQL.Varchar2_Table;
371: l_ct_status_tab DBMS_SQL.Varchar2_Table;
372: l_ct_first_name_tab DBMS_SQL.Varchar2_Table;
373: l_ct_middle_name_tab DBMS_SQL.Varchar2_Table;
374: l_ct_last_name_tab DBMS_SQL.Varchar2_Table;
375: l_ct_country_tab DBMS_SQL.Varchar2_Table;
376: l_ct_address1_tab DBMS_SQL.Varchar2_Table;
377: l_ct_address2_tab DBMS_SQL.Varchar2_Table;

Line 374: l_ct_last_name_tab DBMS_SQL.Varchar2_Table;

370: l_ct_party_type_tab DBMS_SQL.Varchar2_Table;
371: l_ct_status_tab DBMS_SQL.Varchar2_Table;
372: l_ct_first_name_tab DBMS_SQL.Varchar2_Table;
373: l_ct_middle_name_tab DBMS_SQL.Varchar2_Table;
374: l_ct_last_name_tab DBMS_SQL.Varchar2_Table;
375: l_ct_country_tab DBMS_SQL.Varchar2_Table;
376: l_ct_address1_tab DBMS_SQL.Varchar2_Table;
377: l_ct_address2_tab DBMS_SQL.Varchar2_Table;
378: l_ct_address3_tab DBMS_SQL.Varchar2_Table;

Line 375: l_ct_country_tab DBMS_SQL.Varchar2_Table;

371: l_ct_status_tab DBMS_SQL.Varchar2_Table;
372: l_ct_first_name_tab DBMS_SQL.Varchar2_Table;
373: l_ct_middle_name_tab DBMS_SQL.Varchar2_Table;
374: l_ct_last_name_tab DBMS_SQL.Varchar2_Table;
375: l_ct_country_tab DBMS_SQL.Varchar2_Table;
376: l_ct_address1_tab DBMS_SQL.Varchar2_Table;
377: l_ct_address2_tab DBMS_SQL.Varchar2_Table;
378: l_ct_address3_tab DBMS_SQL.Varchar2_Table;
379: l_ct_address4_tab DBMS_SQL.Varchar2_Table;

Line 376: l_ct_address1_tab DBMS_SQL.Varchar2_Table;

372: l_ct_first_name_tab DBMS_SQL.Varchar2_Table;
373: l_ct_middle_name_tab DBMS_SQL.Varchar2_Table;
374: l_ct_last_name_tab DBMS_SQL.Varchar2_Table;
375: l_ct_country_tab DBMS_SQL.Varchar2_Table;
376: l_ct_address1_tab DBMS_SQL.Varchar2_Table;
377: l_ct_address2_tab DBMS_SQL.Varchar2_Table;
378: l_ct_address3_tab DBMS_SQL.Varchar2_Table;
379: l_ct_address4_tab DBMS_SQL.Varchar2_Table;
380: l_ct_city_tab DBMS_SQL.Varchar2_Table;

Line 377: l_ct_address2_tab DBMS_SQL.Varchar2_Table;

373: l_ct_middle_name_tab DBMS_SQL.Varchar2_Table;
374: l_ct_last_name_tab DBMS_SQL.Varchar2_Table;
375: l_ct_country_tab DBMS_SQL.Varchar2_Table;
376: l_ct_address1_tab DBMS_SQL.Varchar2_Table;
377: l_ct_address2_tab DBMS_SQL.Varchar2_Table;
378: l_ct_address3_tab DBMS_SQL.Varchar2_Table;
379: l_ct_address4_tab DBMS_SQL.Varchar2_Table;
380: l_ct_city_tab DBMS_SQL.Varchar2_Table;
381: l_ct_postal_code_tab DBMS_SQL.Varchar2_Table;

Line 378: l_ct_address3_tab DBMS_SQL.Varchar2_Table;

374: l_ct_last_name_tab DBMS_SQL.Varchar2_Table;
375: l_ct_country_tab DBMS_SQL.Varchar2_Table;
376: l_ct_address1_tab DBMS_SQL.Varchar2_Table;
377: l_ct_address2_tab DBMS_SQL.Varchar2_Table;
378: l_ct_address3_tab DBMS_SQL.Varchar2_Table;
379: l_ct_address4_tab DBMS_SQL.Varchar2_Table;
380: l_ct_city_tab DBMS_SQL.Varchar2_Table;
381: l_ct_postal_code_tab DBMS_SQL.Varchar2_Table;
382: l_ct_state_tab DBMS_SQL.Varchar2_Table;

Line 379: l_ct_address4_tab DBMS_SQL.Varchar2_Table;

375: l_ct_country_tab DBMS_SQL.Varchar2_Table;
376: l_ct_address1_tab DBMS_SQL.Varchar2_Table;
377: l_ct_address2_tab DBMS_SQL.Varchar2_Table;
378: l_ct_address3_tab DBMS_SQL.Varchar2_Table;
379: l_ct_address4_tab DBMS_SQL.Varchar2_Table;
380: l_ct_city_tab DBMS_SQL.Varchar2_Table;
381: l_ct_postal_code_tab DBMS_SQL.Varchar2_Table;
382: l_ct_state_tab DBMS_SQL.Varchar2_Table;
383: l_ct_province_tab DBMS_SQL.Varchar2_Table;

Line 380: l_ct_city_tab DBMS_SQL.Varchar2_Table;

376: l_ct_address1_tab DBMS_SQL.Varchar2_Table;
377: l_ct_address2_tab DBMS_SQL.Varchar2_Table;
378: l_ct_address3_tab DBMS_SQL.Varchar2_Table;
379: l_ct_address4_tab DBMS_SQL.Varchar2_Table;
380: l_ct_city_tab DBMS_SQL.Varchar2_Table;
381: l_ct_postal_code_tab DBMS_SQL.Varchar2_Table;
382: l_ct_state_tab DBMS_SQL.Varchar2_Table;
383: l_ct_province_tab DBMS_SQL.Varchar2_Table;
384: l_ct_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end

Line 381: l_ct_postal_code_tab DBMS_SQL.Varchar2_Table;

377: l_ct_address2_tab DBMS_SQL.Varchar2_Table;
378: l_ct_address3_tab DBMS_SQL.Varchar2_Table;
379: l_ct_address4_tab DBMS_SQL.Varchar2_Table;
380: l_ct_city_tab DBMS_SQL.Varchar2_Table;
381: l_ct_postal_code_tab DBMS_SQL.Varchar2_Table;
382: l_ct_state_tab DBMS_SQL.Varchar2_Table;
383: l_ct_province_tab DBMS_SQL.Varchar2_Table;
384: l_ct_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end
385:

Line 382: l_ct_state_tab DBMS_SQL.Varchar2_Table;

378: l_ct_address3_tab DBMS_SQL.Varchar2_Table;
379: l_ct_address4_tab DBMS_SQL.Varchar2_Table;
380: l_ct_city_tab DBMS_SQL.Varchar2_Table;
381: l_ct_postal_code_tab DBMS_SQL.Varchar2_Table;
382: l_ct_state_tab DBMS_SQL.Varchar2_Table;
383: l_ct_province_tab DBMS_SQL.Varchar2_Table;
384: l_ct_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end
385:
386: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;

Line 383: l_ct_province_tab DBMS_SQL.Varchar2_Table;

379: l_ct_address4_tab DBMS_SQL.Varchar2_Table;
380: l_ct_city_tab DBMS_SQL.Varchar2_Table;
381: l_ct_postal_code_tab DBMS_SQL.Varchar2_Table;
382: l_ct_state_tab DBMS_SQL.Varchar2_Table;
383: l_ct_province_tab DBMS_SQL.Varchar2_Table;
384: l_ct_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end
385:
386: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;
387: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;

Line 384: l_ct_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end

380: l_ct_city_tab DBMS_SQL.Varchar2_Table;
381: l_ct_postal_code_tab DBMS_SQL.Varchar2_Table;
382: l_ct_state_tab DBMS_SQL.Varchar2_Table;
383: l_ct_province_tab DBMS_SQL.Varchar2_Table;
384: l_ct_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end
385:
386: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;
387: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;
388: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;

Line 386: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;

382: l_ct_state_tab DBMS_SQL.Varchar2_Table;
383: l_ct_province_tab DBMS_SQL.Varchar2_Table;
384: l_ct_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end
385:
386: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;
387: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;
388: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;
389: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
390: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;

Line 387: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;

383: l_ct_province_tab DBMS_SQL.Varchar2_Table;
384: l_ct_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end
385:
386: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;
387: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;
388: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;
389: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
390: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
391:

Line 388: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;

384: l_ct_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end
385:
386: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;
387: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;
388: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;
389: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
390: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
391:
392: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;

Line 389: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;

385:
386: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;
387: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;
388: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;
389: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
390: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
391:
392: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
393: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;

Line 390: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;

386: l_varchar_CtPartyName_tab DBMS_SQL.Varchar2_Table;
387: l_varchar_CtPointType_tab DBMS_SQL.Varchar2_Table;
388: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;
389: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
390: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
391:
392: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
393: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
394: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;

Line 392: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;

388: l_varchar_ctEmail_tab DBMS_SQL.Varchar2_Table;
389: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
390: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
391:
392: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
393: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
394: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
395: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
396: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;

Line 393: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;

389: l_varchar_ctPhone_tab DBMS_SQL.Varchar2_Table;
390: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
391:
392: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
393: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
394: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
395: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
396: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
397: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;

Line 394: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;

390: l_varchar_ctFax_tab DBMS_SQL.Varchar2_Table;
391:
392: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
393: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
394: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
395: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
396: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
397: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
398: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;

Line 395: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;

391:
392: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
393: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
394: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
395: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
396: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
397: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
398: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
399: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;

Line 396: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;

392: l_varchar_tempAttrib1_tab DBMS_SQL.Varchar2_Table;
393: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
394: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
395: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
396: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
397: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
398: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
399: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
400: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;

Line 397: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;

393: l_varchar_tempAttrib2_tab DBMS_SQL.Varchar2_Table;
394: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
395: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
396: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
397: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
398: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
399: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
400: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
401: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;

Line 398: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;

394: l_varchar_tempAttrib3_tab DBMS_SQL.Varchar2_Table;
395: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
396: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
397: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
398: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
399: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
400: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
401: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
402: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;

Line 399: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;

395: l_varchar_tempAttrib4_tab DBMS_SQL.Varchar2_Table;
396: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
397: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
398: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
399: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
400: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
401: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
402: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
403: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;

Line 400: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;

396: l_varchar_tempAttrib5_tab DBMS_SQL.Varchar2_Table;
397: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
398: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
399: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
400: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
401: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
402: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
403: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
404: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;

Line 401: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;

397: l_varchar_tempAttrib6_tab DBMS_SQL.Varchar2_Table;
398: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
399: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
400: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
401: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
402: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
403: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
404: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;
405: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;

Line 402: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;

398: l_varchar_tempAttrib7_tab DBMS_SQL.Varchar2_Table;
399: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
400: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
401: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
402: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
403: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
404: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;
405: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;
406: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;

Line 403: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;

399: l_varchar_tempAttrib8_tab DBMS_SQL.Varchar2_Table;
400: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
401: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
402: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
403: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
404: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;
405: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;
406: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;
407:

Line 404: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;

400: l_varchar_tempAttrib9_tab DBMS_SQL.Varchar2_Table;
401: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
402: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
403: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
404: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;
405: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;
406: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;
407:
408:

Line 405: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;

401: l_varchar_tempAttrib10_tab DBMS_SQL.Varchar2_Table;
402: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
403: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
404: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;
405: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;
406: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;
407:
408:
409: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;

Line 406: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;

402: l_varchar_tempAttrib11_tab DBMS_SQL.Varchar2_Table;
403: l_varchar_tempAttrib12_tab DBMS_SQL.Varchar2_Table;
404: l_varchar_tempAttrib13_tab DBMS_SQL.Varchar2_Table;
405: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;
406: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;
407:
408:
409: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;
410: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;

Line 409: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;

405: l_varchar_tempAttrib14_tab DBMS_SQL.Varchar2_Table;
406: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;
407:
408:
409: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;
410: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;
411: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
412: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
413: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;

Line 410: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;

406: l_varchar_tempAttrib15_tab DBMS_SQL.Varchar2_Table;
407:
408:
409: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;
410: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;
411: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
412: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
413: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
414: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;

Line 411: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;

407:
408:
409: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;
410: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;
411: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
412: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
413: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
414: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
415: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;

Line 412: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;

408:
409: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;
410: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;
411: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
412: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
413: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
414: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
415: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
416: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;

Line 413: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;

409: l_varchar_rcAttrib1_tab DBMS_SQL.Varchar2_Table;
410: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;
411: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
412: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
413: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
414: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
415: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
416: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
417: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;

Line 414: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;

410: l_varchar_rcAttrib2_tab DBMS_SQL.Varchar2_Table;
411: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
412: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
413: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
414: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
415: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
416: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
417: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
418: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;

Line 415: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;

411: l_varchar_rcAttrib3_tab DBMS_SQL.Varchar2_Table;
412: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
413: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
414: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
415: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
416: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
417: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
418: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
419: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;

Line 416: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;

412: l_varchar_rcAttrib4_tab DBMS_SQL.Varchar2_Table;
413: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
414: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
415: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
416: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
417: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
418: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
419: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
420: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;

Line 417: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;

413: l_varchar_rcAttrib5_tab DBMS_SQL.Varchar2_Table;
414: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
415: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
416: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
417: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
418: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
419: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
420: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
421: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;

Line 418: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;

414: l_varchar_rcAttrib6_tab DBMS_SQL.Varchar2_Table;
415: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
416: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
417: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
418: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
419: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
420: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
421: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;
422: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;

Line 419: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;

415: l_varchar_rcAttrib7_tab DBMS_SQL.Varchar2_Table;
416: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
417: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
418: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
419: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
420: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
421: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;
422: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;
423: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;

Line 420: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;

416: l_varchar_rcAttrib8_tab DBMS_SQL.Varchar2_Table;
417: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
418: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
419: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
420: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
421: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;
422: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;
423: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;
424:

Line 421: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;

417: l_varchar_rcAttrib9_tab DBMS_SQL.Varchar2_Table;
418: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
419: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
420: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
421: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;
422: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;
423: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;
424:
425:

Line 422: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;

418: l_varchar_rcAttrib10_tab DBMS_SQL.Varchar2_Table;
419: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
420: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
421: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;
422: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;
423: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;
424:
425:
426: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;

Line 423: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;

419: l_varchar_rcAttrib11_tab DBMS_SQL.Varchar2_Table;
420: l_varchar_rcAttrib12_tab DBMS_SQL.Varchar2_Table;
421: l_varchar_rcAttrib13_tab DBMS_SQL.Varchar2_Table;
422: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;
423: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;
424:
425:
426: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
427: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;

Line 426: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;

422: l_varchar_rcAttrib14_tab DBMS_SQL.Varchar2_Table;
423: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;
424:
425:
426: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
427: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
428: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
429: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
430: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;

Line 427: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;

423: l_varchar_rcAttrib15_tab DBMS_SQL.Varchar2_Table;
424:
425:
426: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
427: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
428: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
429: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
430: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
431: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;

Line 428: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;

424:
425:
426: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
427: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
428: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
429: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
430: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
431: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
432: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;

Line 429: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;

425:
426: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
427: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
428: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
429: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
430: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
431: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
432: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
433: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;

Line 430: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;

426: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
427: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
428: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
429: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
430: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
431: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
432: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
433: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
434: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;

Line 431: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;

427: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
428: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
429: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
430: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
431: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
432: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
433: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
434: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
435: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;

Line 432: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;

428: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
429: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
430: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
431: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
432: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
433: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
434: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
435: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
436: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;

Line 433: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;

429: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
430: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
431: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
432: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
433: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
434: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
435: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
436: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
437: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;

Line 434: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;

430: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
431: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
432: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
433: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
434: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
435: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
436: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
437: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
438: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;

Line 435: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;

431: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
432: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
433: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
434: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
435: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
436: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
437: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
438: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
439: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;

Line 436: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;

432: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
433: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
434: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
435: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
436: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
437: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
438: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
439: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
440: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;

Line 437: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;

433: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
434: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
435: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
436: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
437: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
438: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
439: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
440: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
441:

Line 438: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;

434: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
435: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
436: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
437: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
438: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
439: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
440: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
441:
442: --Bug 7297690 Added variable to store the party site id and Org contact id of the contacts who will be screened

Line 439: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;

435: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
436: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
437: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
438: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
439: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
440: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
441:
442: --Bug 7297690 Added variable to store the party site id and Org contact id of the contacts who will be screened
443: l_org_contact_id_tab DBMS_SQL.Number_Table;

Line 440: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;

436: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
437: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
438: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
439: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
440: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
441:
442: --Bug 7297690 Added variable to store the party site id and Org contact id of the contacts who will be screened
443: l_org_contact_id_tab DBMS_SQL.Number_Table;
444: Type l_org_contact_type is table of Varchar2(1) index by BINARY_INTEGER;

Line 443: l_org_contact_id_tab DBMS_SQL.Number_Table;

439: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
440: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
441:
442: --Bug 7297690 Added variable to store the party site id and Org contact id of the contacts who will be screened
443: l_org_contact_id_tab DBMS_SQL.Number_Table;
444: Type l_org_contact_type is table of Varchar2(1) index by BINARY_INTEGER;
445: l_org_contact_cache l_org_contact_type;
446: Type l_party_site_id_type is table of Varchar2(1) index by BINARY_INTEGER;
447: l_party_site_id_cache l_party_site_id_type;

Line 449: l_operating_unit DBMS_SQL.Number_Table;

445: l_org_contact_cache l_org_contact_type;
446: Type l_party_site_id_type is table of Varchar2(1) index by BINARY_INTEGER;
447: l_party_site_id_cache l_party_site_id_type;
448:
449: l_operating_unit DBMS_SQL.Number_Table;
450: l_address_type DBMS_SQL.Varchar2_Table; -- gtm related: start
451: l_hz_party_num_tab DBMS_SQL.Varchar2_Table;
452: l_hz_party_type_tab DBMS_SQL.Varchar2_Table;
453: l_hz_status_tab DBMS_SQL.Varchar2_Table;

Line 450: l_address_type DBMS_SQL.Varchar2_Table; -- gtm related: start

446: Type l_party_site_id_type is table of Varchar2(1) index by BINARY_INTEGER;
447: l_party_site_id_cache l_party_site_id_type;
448:
449: l_operating_unit DBMS_SQL.Number_Table;
450: l_address_type DBMS_SQL.Varchar2_Table; -- gtm related: start
451: l_hz_party_num_tab DBMS_SQL.Varchar2_Table;
452: l_hz_party_type_tab DBMS_SQL.Varchar2_Table;
453: l_hz_status_tab DBMS_SQL.Varchar2_Table;
454: l_hz_hq_branch_ind_tab DBMS_SQL.Varchar2_Table;

Line 451: l_hz_party_num_tab DBMS_SQL.Varchar2_Table;

447: l_party_site_id_cache l_party_site_id_type;
448:
449: l_operating_unit DBMS_SQL.Number_Table;
450: l_address_type DBMS_SQL.Varchar2_Table; -- gtm related: start
451: l_hz_party_num_tab DBMS_SQL.Varchar2_Table;
452: l_hz_party_type_tab DBMS_SQL.Varchar2_Table;
453: l_hz_status_tab DBMS_SQL.Varchar2_Table;
454: l_hz_hq_branch_ind_tab DBMS_SQL.Varchar2_Table;
455: l_hz_sic_code_tab DBMS_SQL.Varchar2_Table;

Line 452: l_hz_party_type_tab DBMS_SQL.Varchar2_Table;

448:
449: l_operating_unit DBMS_SQL.Number_Table;
450: l_address_type DBMS_SQL.Varchar2_Table; -- gtm related: start
451: l_hz_party_num_tab DBMS_SQL.Varchar2_Table;
452: l_hz_party_type_tab DBMS_SQL.Varchar2_Table;
453: l_hz_status_tab DBMS_SQL.Varchar2_Table;
454: l_hz_hq_branch_ind_tab DBMS_SQL.Varchar2_Table;
455: l_hz_sic_code_tab DBMS_SQL.Varchar2_Table;
456: l_hz_sic_code_type_tab DBMS_SQL.Varchar2_Table;

Line 453: l_hz_status_tab DBMS_SQL.Varchar2_Table;

449: l_operating_unit DBMS_SQL.Number_Table;
450: l_address_type DBMS_SQL.Varchar2_Table; -- gtm related: start
451: l_hz_party_num_tab DBMS_SQL.Varchar2_Table;
452: l_hz_party_type_tab DBMS_SQL.Varchar2_Table;
453: l_hz_status_tab DBMS_SQL.Varchar2_Table;
454: l_hz_hq_branch_ind_tab DBMS_SQL.Varchar2_Table;
455: l_hz_sic_code_tab DBMS_SQL.Varchar2_Table;
456: l_hz_sic_code_type_tab DBMS_SQL.Varchar2_Table;
457: l_person_first_name_tab DBMS_SQL.Varchar2_Table;

Line 454: l_hz_hq_branch_ind_tab DBMS_SQL.Varchar2_Table;

450: l_address_type DBMS_SQL.Varchar2_Table; -- gtm related: start
451: l_hz_party_num_tab DBMS_SQL.Varchar2_Table;
452: l_hz_party_type_tab DBMS_SQL.Varchar2_Table;
453: l_hz_status_tab DBMS_SQL.Varchar2_Table;
454: l_hz_hq_branch_ind_tab DBMS_SQL.Varchar2_Table;
455: l_hz_sic_code_tab DBMS_SQL.Varchar2_Table;
456: l_hz_sic_code_type_tab DBMS_SQL.Varchar2_Table;
457: l_person_first_name_tab DBMS_SQL.Varchar2_Table;
458: l_person_middle_name_tab DBMS_SQL.Varchar2_Table;

Line 455: l_hz_sic_code_tab DBMS_SQL.Varchar2_Table;

451: l_hz_party_num_tab DBMS_SQL.Varchar2_Table;
452: l_hz_party_type_tab DBMS_SQL.Varchar2_Table;
453: l_hz_status_tab DBMS_SQL.Varchar2_Table;
454: l_hz_hq_branch_ind_tab DBMS_SQL.Varchar2_Table;
455: l_hz_sic_code_tab DBMS_SQL.Varchar2_Table;
456: l_hz_sic_code_type_tab DBMS_SQL.Varchar2_Table;
457: l_person_first_name_tab DBMS_SQL.Varchar2_Table;
458: l_person_middle_name_tab DBMS_SQL.Varchar2_Table;
459: l_person_last_name_tab DBMS_SQL.Varchar2_Table;

Line 456: l_hz_sic_code_type_tab DBMS_SQL.Varchar2_Table;

452: l_hz_party_type_tab DBMS_SQL.Varchar2_Table;
453: l_hz_status_tab DBMS_SQL.Varchar2_Table;
454: l_hz_hq_branch_ind_tab DBMS_SQL.Varchar2_Table;
455: l_hz_sic_code_tab DBMS_SQL.Varchar2_Table;
456: l_hz_sic_code_type_tab DBMS_SQL.Varchar2_Table;
457: l_person_first_name_tab DBMS_SQL.Varchar2_Table;
458: l_person_middle_name_tab DBMS_SQL.Varchar2_Table;
459: l_person_last_name_tab DBMS_SQL.Varchar2_Table;
460: l_hz_location_id_tab DBMS_SQL.Number_Table;

Line 457: l_person_first_name_tab DBMS_SQL.Varchar2_Table;

453: l_hz_status_tab DBMS_SQL.Varchar2_Table;
454: l_hz_hq_branch_ind_tab DBMS_SQL.Varchar2_Table;
455: l_hz_sic_code_tab DBMS_SQL.Varchar2_Table;
456: l_hz_sic_code_type_tab DBMS_SQL.Varchar2_Table;
457: l_person_first_name_tab DBMS_SQL.Varchar2_Table;
458: l_person_middle_name_tab DBMS_SQL.Varchar2_Table;
459: l_person_last_name_tab DBMS_SQL.Varchar2_Table;
460: l_hz_location_id_tab DBMS_SQL.Number_Table;
461: l_hz_country_tab DBMS_SQL.Varchar2_Table;

Line 458: l_person_middle_name_tab DBMS_SQL.Varchar2_Table;

454: l_hz_hq_branch_ind_tab DBMS_SQL.Varchar2_Table;
455: l_hz_sic_code_tab DBMS_SQL.Varchar2_Table;
456: l_hz_sic_code_type_tab DBMS_SQL.Varchar2_Table;
457: l_person_first_name_tab DBMS_SQL.Varchar2_Table;
458: l_person_middle_name_tab DBMS_SQL.Varchar2_Table;
459: l_person_last_name_tab DBMS_SQL.Varchar2_Table;
460: l_hz_location_id_tab DBMS_SQL.Number_Table;
461: l_hz_country_tab DBMS_SQL.Varchar2_Table;
462: l_hz_address1_tab DBMS_SQL.Varchar2_Table;

Line 459: l_person_last_name_tab DBMS_SQL.Varchar2_Table;

455: l_hz_sic_code_tab DBMS_SQL.Varchar2_Table;
456: l_hz_sic_code_type_tab DBMS_SQL.Varchar2_Table;
457: l_person_first_name_tab DBMS_SQL.Varchar2_Table;
458: l_person_middle_name_tab DBMS_SQL.Varchar2_Table;
459: l_person_last_name_tab DBMS_SQL.Varchar2_Table;
460: l_hz_location_id_tab DBMS_SQL.Number_Table;
461: l_hz_country_tab DBMS_SQL.Varchar2_Table;
462: l_hz_address1_tab DBMS_SQL.Varchar2_Table;
463: l_hz_address2_tab DBMS_SQL.Varchar2_Table;

Line 460: l_hz_location_id_tab DBMS_SQL.Number_Table;

456: l_hz_sic_code_type_tab DBMS_SQL.Varchar2_Table;
457: l_person_first_name_tab DBMS_SQL.Varchar2_Table;
458: l_person_middle_name_tab DBMS_SQL.Varchar2_Table;
459: l_person_last_name_tab DBMS_SQL.Varchar2_Table;
460: l_hz_location_id_tab DBMS_SQL.Number_Table;
461: l_hz_country_tab DBMS_SQL.Varchar2_Table;
462: l_hz_address1_tab DBMS_SQL.Varchar2_Table;
463: l_hz_address2_tab DBMS_SQL.Varchar2_Table;
464: l_hz_address3_tab DBMS_SQL.Varchar2_Table;

Line 461: l_hz_country_tab DBMS_SQL.Varchar2_Table;

457: l_person_first_name_tab DBMS_SQL.Varchar2_Table;
458: l_person_middle_name_tab DBMS_SQL.Varchar2_Table;
459: l_person_last_name_tab DBMS_SQL.Varchar2_Table;
460: l_hz_location_id_tab DBMS_SQL.Number_Table;
461: l_hz_country_tab DBMS_SQL.Varchar2_Table;
462: l_hz_address1_tab DBMS_SQL.Varchar2_Table;
463: l_hz_address2_tab DBMS_SQL.Varchar2_Table;
464: l_hz_address3_tab DBMS_SQL.Varchar2_Table;
465: l_hz_address4_tab DBMS_SQL.Varchar2_Table;

Line 462: l_hz_address1_tab DBMS_SQL.Varchar2_Table;

458: l_person_middle_name_tab DBMS_SQL.Varchar2_Table;
459: l_person_last_name_tab DBMS_SQL.Varchar2_Table;
460: l_hz_location_id_tab DBMS_SQL.Number_Table;
461: l_hz_country_tab DBMS_SQL.Varchar2_Table;
462: l_hz_address1_tab DBMS_SQL.Varchar2_Table;
463: l_hz_address2_tab DBMS_SQL.Varchar2_Table;
464: l_hz_address3_tab DBMS_SQL.Varchar2_Table;
465: l_hz_address4_tab DBMS_SQL.Varchar2_Table;
466: l_hz_city_tab DBMS_SQL.Varchar2_Table;

Line 463: l_hz_address2_tab DBMS_SQL.Varchar2_Table;

459: l_person_last_name_tab DBMS_SQL.Varchar2_Table;
460: l_hz_location_id_tab DBMS_SQL.Number_Table;
461: l_hz_country_tab DBMS_SQL.Varchar2_Table;
462: l_hz_address1_tab DBMS_SQL.Varchar2_Table;
463: l_hz_address2_tab DBMS_SQL.Varchar2_Table;
464: l_hz_address3_tab DBMS_SQL.Varchar2_Table;
465: l_hz_address4_tab DBMS_SQL.Varchar2_Table;
466: l_hz_city_tab DBMS_SQL.Varchar2_Table;
467: l_hz_postal_code_tab DBMS_SQL.Varchar2_Table;

Line 464: l_hz_address3_tab DBMS_SQL.Varchar2_Table;

460: l_hz_location_id_tab DBMS_SQL.Number_Table;
461: l_hz_country_tab DBMS_SQL.Varchar2_Table;
462: l_hz_address1_tab DBMS_SQL.Varchar2_Table;
463: l_hz_address2_tab DBMS_SQL.Varchar2_Table;
464: l_hz_address3_tab DBMS_SQL.Varchar2_Table;
465: l_hz_address4_tab DBMS_SQL.Varchar2_Table;
466: l_hz_city_tab DBMS_SQL.Varchar2_Table;
467: l_hz_postal_code_tab DBMS_SQL.Varchar2_Table;
468: l_hz_state_tab DBMS_SQL.Varchar2_Table;

Line 465: l_hz_address4_tab DBMS_SQL.Varchar2_Table;

461: l_hz_country_tab DBMS_SQL.Varchar2_Table;
462: l_hz_address1_tab DBMS_SQL.Varchar2_Table;
463: l_hz_address2_tab DBMS_SQL.Varchar2_Table;
464: l_hz_address3_tab DBMS_SQL.Varchar2_Table;
465: l_hz_address4_tab DBMS_SQL.Varchar2_Table;
466: l_hz_city_tab DBMS_SQL.Varchar2_Table;
467: l_hz_postal_code_tab DBMS_SQL.Varchar2_Table;
468: l_hz_state_tab DBMS_SQL.Varchar2_Table;
469: l_hz_province_tab DBMS_SQL.Varchar2_Table;

Line 466: l_hz_city_tab DBMS_SQL.Varchar2_Table;

462: l_hz_address1_tab DBMS_SQL.Varchar2_Table;
463: l_hz_address2_tab DBMS_SQL.Varchar2_Table;
464: l_hz_address3_tab DBMS_SQL.Varchar2_Table;
465: l_hz_address4_tab DBMS_SQL.Varchar2_Table;
466: l_hz_city_tab DBMS_SQL.Varchar2_Table;
467: l_hz_postal_code_tab DBMS_SQL.Varchar2_Table;
468: l_hz_state_tab DBMS_SQL.Varchar2_Table;
469: l_hz_province_tab DBMS_SQL.Varchar2_Table;
470: l_hz_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end

Line 467: l_hz_postal_code_tab DBMS_SQL.Varchar2_Table;

463: l_hz_address2_tab DBMS_SQL.Varchar2_Table;
464: l_hz_address3_tab DBMS_SQL.Varchar2_Table;
465: l_hz_address4_tab DBMS_SQL.Varchar2_Table;
466: l_hz_city_tab DBMS_SQL.Varchar2_Table;
467: l_hz_postal_code_tab DBMS_SQL.Varchar2_Table;
468: l_hz_state_tab DBMS_SQL.Varchar2_Table;
469: l_hz_province_tab DBMS_SQL.Varchar2_Table;
470: l_hz_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end
471: l_email VARCHAR2(100);

Line 468: l_hz_state_tab DBMS_SQL.Varchar2_Table;

464: l_hz_address3_tab DBMS_SQL.Varchar2_Table;
465: l_hz_address4_tab DBMS_SQL.Varchar2_Table;
466: l_hz_city_tab DBMS_SQL.Varchar2_Table;
467: l_hz_postal_code_tab DBMS_SQL.Varchar2_Table;
468: l_hz_state_tab DBMS_SQL.Varchar2_Table;
469: l_hz_province_tab DBMS_SQL.Varchar2_Table;
470: l_hz_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end
471: l_email VARCHAR2(100);
472: l_phone VARCHAR2(100);

Line 469: l_hz_province_tab DBMS_SQL.Varchar2_Table;

465: l_hz_address4_tab DBMS_SQL.Varchar2_Table;
466: l_hz_city_tab DBMS_SQL.Varchar2_Table;
467: l_hz_postal_code_tab DBMS_SQL.Varchar2_Table;
468: l_hz_state_tab DBMS_SQL.Varchar2_Table;
469: l_hz_province_tab DBMS_SQL.Varchar2_Table;
470: l_hz_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end
471: l_email VARCHAR2(100);
472: l_phone VARCHAR2(100);
473: l_fax VARCHAR2(100);

Line 470: l_hz_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end

466: l_hz_city_tab DBMS_SQL.Varchar2_Table;
467: l_hz_postal_code_tab DBMS_SQL.Varchar2_Table;
468: l_hz_state_tab DBMS_SQL.Varchar2_Table;
469: l_hz_province_tab DBMS_SQL.Varchar2_Table;
470: l_hz_county_tab DBMS_SQL.Varchar2_Table; -- gtm related: end
471: l_email VARCHAR2(100);
472: l_phone VARCHAR2(100);
473: l_fax VARCHAR2(100);
474:

Line 476: l_num_ReqCtrl_tab DBMS_SQL.Number_Table;

472: l_phone VARCHAR2(100);
473: l_fax VARCHAR2(100);
474:
475: --For Insert to ITM Inteface Tables
476: l_num_ReqCtrl_tab DBMS_SQL.Number_Table;
477: l_num_PartyReqCtrl_tab DBMS_SQL.Number_Table;
478: l_tempSourceID NUMBER := -999;
479: j NUMBER;
480:

Line 477: l_num_PartyReqCtrl_tab DBMS_SQL.Number_Table;

473: l_fax VARCHAR2(100);
474:
475: --For Insert to ITM Inteface Tables
476: l_num_ReqCtrl_tab DBMS_SQL.Number_Table;
477: l_num_PartyReqCtrl_tab DBMS_SQL.Number_Table;
478: l_tempSourceID NUMBER := -999;
479: j NUMBER;
480:
481: l_user_id NUMBER;

Line 841: l_CursorID := DBMS_SQL.Open_Cursor;

837: WSH_DEBUG_SV.LOG (l_module_name, 'Query ', l_SQLQuery, WSH_DEBUG_SV.C_STMT_LEVEL);
838: END IF;
839:
840: -- Parse cursor
841: l_CursorID := DBMS_SQL.Open_Cursor;
842: DBMS_SQL.PARSE(l_CursorID, l_SQLQuery, DBMS_SQL.v7);
843:
844:
845:

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

838: END IF;
839:
840: -- Parse cursor
841: l_CursorID := DBMS_SQL.Open_Cursor;
842: DBMS_SQL.PARSE(l_CursorID, l_SQLQuery, DBMS_SQL.v7);
843:
844:
845:
846: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_sourceID_tab, 100, 0);

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

842: DBMS_SQL.PARSE(l_CursorID, l_SQLQuery, DBMS_SQL.v7);
843:
844:
845:
846: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_sourceID_tab, 100, 0);
847: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_hzpartyID_tab, 100, 0);
848: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
849: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
850: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);

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

843:
844:
845:
846: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_sourceID_tab, 100, 0);
847: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_hzpartyID_tab, 100, 0);
848: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
849: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
850: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
851: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);

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

844:
845:
846: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_sourceID_tab, 100, 0);
847: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_hzpartyID_tab, 100, 0);
848: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
849: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
850: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
851: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
852: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);

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

845:
846: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_sourceID_tab, 100, 0);
847: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_hzpartyID_tab, 100, 0);
848: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
849: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
850: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
851: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
852: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
853: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);

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

846: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_sourceID_tab, 100, 0);
847: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_hzpartyID_tab, 100, 0);
848: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
849: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
850: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
851: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
852: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
853: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
854: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);

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

847: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_hzpartyID_tab, 100, 0);
848: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
849: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
850: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
851: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
852: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
853: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
854: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
855: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);

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

848: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_hzpartySiteID_tab, 100, 0);
849: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
850: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
851: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
852: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
853: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
854: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
855: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
856: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);

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

849: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_num_custAccountID_tab, 100, 0);
850: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
851: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
852: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
853: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
854: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
855: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
856: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
857: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);

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

850: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_PartnrType_tab, 100, 0);
851: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
852: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
853: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
854: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
855: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
856: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
857: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
858: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);

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

851: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_varchar_PartyName_tab, 100, 0);
852: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
853: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
854: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
855: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
856: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
857: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
858: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
859: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);

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

852: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_varchar_AlternateName_tab, 100, 0);
853: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
854: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
855: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
856: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
857: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
858: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
859: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
860: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);

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

853: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_TaxRef_tab, 100, 0);
854: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
855: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
856: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
857: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
858: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
859: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
860: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
861: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);

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

854: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_Address1_tab, 100, 0);
855: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
856: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
857: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
858: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
859: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
860: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
861: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
862: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);

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

855: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10,l_varchar_Address2_tab, 100, 0);
856: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
857: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
858: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
859: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
860: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
861: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
862: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);
863: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);

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

856: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11,l_varchar_Address3_tab, 100, 0);
857: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
858: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
859: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
860: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
861: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
862: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);
863: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);
864: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);

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

857: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Address4_tab, 100, 0);
858: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
859: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
860: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
861: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
862: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);
863: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);
864: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);
865:

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

858: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_City_tab, 100, 0);
859: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
860: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
861: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
862: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);
863: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);
864: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);
865:
866:

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

859: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_State_tab, 100, 0);
860: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
861: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
862: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);
863: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);
864: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);
865:
866:
867: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);

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

860: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Country_tab, 100, 0);
861: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_PostalCode_tab, 100, 0);
862: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_AcctNumber_tab , 100, 0);
863: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);
864: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);
865:
866:
867: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);
868: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);

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

863: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_AcctName_tab , 100, 0);
864: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);
865:
866:
867: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);
868: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);
869: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
870: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
871: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);

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

864: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_SiteNumber_tab , 100, 0);
865:
866:
867: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);
868: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);
869: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
870: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
871: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
872: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);

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

865:
866:
867: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);
868: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);
869: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
870: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
871: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
872: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
873: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);

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

866:
867: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);
868: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);
869: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
870: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
871: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
872: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
873: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
874: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);

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

867: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_tempAttrib1_tab, 100, 0);
868: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);
869: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
870: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
871: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
872: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
873: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
874: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
875: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);

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

868: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_tempAttrib2_tab, 100, 0);
869: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
870: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
871: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
872: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
873: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
874: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
875: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
876: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);

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

869: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_tempAttrib3_tab, 100, 0);
870: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
871: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
872: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
873: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
874: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
875: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
876: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
877: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);

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

870: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_tempAttrib4_tab, 100, 0);
871: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
872: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
873: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
874: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
875: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
876: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
877: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
878: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);

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

871: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_tempAttrib5_tab, 100, 0);
872: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
873: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
874: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
875: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
876: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
877: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
878: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
879: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);

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

872: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_tempAttrib6_tab, 100, 0);
873: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
874: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
875: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
876: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
877: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
878: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
879: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);
880: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 33, l_varchar_tempAttrib14_tab, 100, 0);

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

873: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_tempAttrib7_tab, 100, 0);
874: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
875: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
876: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
877: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
878: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
879: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);
880: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 33, l_varchar_tempAttrib14_tab, 100, 0);
881: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 34, l_varchar_tempAttrib15_tab, 100, 0);

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

874: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_tempAttrib8_tab, 100, 0);
875: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
876: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
877: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
878: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
879: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);
880: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 33, l_varchar_tempAttrib14_tab, 100, 0);
881: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 34, l_varchar_tempAttrib15_tab, 100, 0);
882:

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

875: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_varchar_tempAttrib9_tab, 100, 0);
876: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
877: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
878: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
879: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);
880: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 33, l_varchar_tempAttrib14_tab, 100, 0);
881: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 34, l_varchar_tempAttrib15_tab, 100, 0);
882:
883:

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

876: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 29, l_varchar_tempAttrib10_tab, 100, 0);
877: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
878: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
879: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);
880: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 33, l_varchar_tempAttrib14_tab, 100, 0);
881: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 34, l_varchar_tempAttrib15_tab, 100, 0);
882:
883:
884:

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

877: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 30, l_varchar_tempAttrib11_tab, 100, 0);
878: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 31, l_varchar_tempAttrib12_tab, 100, 0);
879: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 32, l_varchar_tempAttrib13_tab, 100, 0);
880: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 33, l_varchar_tempAttrib14_tab, 100, 0);
881: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 34, l_varchar_tempAttrib15_tab, 100, 0);
882:
883:
884:
885: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 35, l_varchar_Attrib1_tab, 100, 0);

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

881: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 34, l_varchar_tempAttrib15_tab, 100, 0);
882:
883:
884:
885: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 35, l_varchar_Attrib1_tab, 100, 0);
886: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 36, l_varchar_Attrib2_tab, 100, 0);
887: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
888: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
889: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);

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

882:
883:
884:
885: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 35, l_varchar_Attrib1_tab, 100, 0);
886: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 36, l_varchar_Attrib2_tab, 100, 0);
887: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
888: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
889: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
890: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);

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

883:
884:
885: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 35, l_varchar_Attrib1_tab, 100, 0);
886: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 36, l_varchar_Attrib2_tab, 100, 0);
887: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
888: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
889: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
890: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
891: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);

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

884:
885: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 35, l_varchar_Attrib1_tab, 100, 0);
886: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 36, l_varchar_Attrib2_tab, 100, 0);
887: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
888: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
889: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
890: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
891: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
892: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);

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

885: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 35, l_varchar_Attrib1_tab, 100, 0);
886: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 36, l_varchar_Attrib2_tab, 100, 0);
887: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
888: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
889: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
890: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
891: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
892: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
893: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);

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

886: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 36, l_varchar_Attrib2_tab, 100, 0);
887: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
888: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
889: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
890: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
891: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
892: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
893: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
894: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);

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

887: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 37, l_varchar_Attrib3_tab, 100, 0);
888: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
889: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
890: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
891: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
892: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
893: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
894: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
895: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);

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

888: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 38, l_varchar_Attrib4_tab, 100, 0);
889: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
890: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
891: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
892: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
893: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
894: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
895: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
896: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);

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

889: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 39, l_varchar_Attrib5_tab, 100, 0);
890: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
891: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
892: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
893: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
894: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
895: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
896: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
897: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);

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

890: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 40, l_varchar_Attrib6_tab, 100, 0);
891: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
892: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
893: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
894: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
895: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
896: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
897: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
898: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);

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

891: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 41, l_varchar_Attrib7_tab, 100, 0);
892: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
893: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
894: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
895: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
896: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
897: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
898: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
899: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);

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

892: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 42, l_varchar_Attrib8_tab, 100, 0);
893: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
894: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
895: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
896: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
897: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
898: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
899: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
900: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);

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

893: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 43, l_varchar_Attrib9_tab, 100, 0);
894: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
895: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
896: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
897: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
898: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
899: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
900: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);
901: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0); -- gtm v Changes added below

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

894: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 44, l_varchar_Attrib10_tab, 100, 0);
895: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
896: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
897: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
898: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
899: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
900: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);
901: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0); -- gtm v Changes added below
902: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 52, l_hz_party_num_tab, 100, 0);

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

895: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 45, l_varchar_Attrib11_tab, 100, 0);
896: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
897: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
898: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
899: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
900: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);
901: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0); -- gtm v Changes added below
902: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 52, l_hz_party_num_tab, 100, 0);
903: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 53, l_hz_party_type_tab, 100, 0);

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

896: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 46, l_varchar_Attrib12_tab, 100, 0);
897: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
898: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
899: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
900: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);
901: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0); -- gtm v Changes added below
902: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 52, l_hz_party_num_tab, 100, 0);
903: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 53, l_hz_party_type_tab, 100, 0);
904: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 54, l_hz_status_tab, 100, 0);

Line 901: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0); -- gtm v Changes added below

897: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 47, l_varchar_Attrib13_tab, 100, 0);
898: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
899: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
900: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);
901: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0); -- gtm v Changes added below
902: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 52, l_hz_party_num_tab, 100, 0);
903: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 53, l_hz_party_type_tab, 100, 0);
904: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 54, l_hz_status_tab, 100, 0);
905: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 55, l_hz_hq_branch_ind_tab, 100, 0);

Line 902: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 52, l_hz_party_num_tab, 100, 0);

898: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 48, l_varchar_Attrib14_tab, 100, 0);
899: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
900: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);
901: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0); -- gtm v Changes added below
902: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 52, l_hz_party_num_tab, 100, 0);
903: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 53, l_hz_party_type_tab, 100, 0);
904: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 54, l_hz_status_tab, 100, 0);
905: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 55, l_hz_hq_branch_ind_tab, 100, 0);
906: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 56, l_hz_sic_code_tab, 100, 0);

Line 903: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 53, l_hz_party_type_tab, 100, 0);

899: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 49, l_varchar_Attrib15_tab, 100, 0);
900: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);
901: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0); -- gtm v Changes added below
902: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 52, l_hz_party_num_tab, 100, 0);
903: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 53, l_hz_party_type_tab, 100, 0);
904: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 54, l_hz_status_tab, 100, 0);
905: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 55, l_hz_hq_branch_ind_tab, 100, 0);
906: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 56, l_hz_sic_code_tab, 100, 0);
907: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 57, l_hz_sic_code_type_tab, 100, 0);

Line 904: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 54, l_hz_status_tab, 100, 0);

900: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 50, l_operating_unit, 100, 0);
901: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0); -- gtm v Changes added below
902: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 52, l_hz_party_num_tab, 100, 0);
903: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 53, l_hz_party_type_tab, 100, 0);
904: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 54, l_hz_status_tab, 100, 0);
905: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 55, l_hz_hq_branch_ind_tab, 100, 0);
906: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 56, l_hz_sic_code_tab, 100, 0);
907: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 57, l_hz_sic_code_type_tab, 100, 0);
908: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 58, l_person_first_name_tab, 100, 0);

Line 905: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 55, l_hz_hq_branch_ind_tab, 100, 0);

901: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 51, l_address_type, 100, 0); -- gtm v Changes added below
902: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 52, l_hz_party_num_tab, 100, 0);
903: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 53, l_hz_party_type_tab, 100, 0);
904: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 54, l_hz_status_tab, 100, 0);
905: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 55, l_hz_hq_branch_ind_tab, 100, 0);
906: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 56, l_hz_sic_code_tab, 100, 0);
907: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 57, l_hz_sic_code_type_tab, 100, 0);
908: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 58, l_person_first_name_tab, 100, 0);
909: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 59, l_person_middle_name_tab, 100, 0);

Line 906: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 56, l_hz_sic_code_tab, 100, 0);

902: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 52, l_hz_party_num_tab, 100, 0);
903: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 53, l_hz_party_type_tab, 100, 0);
904: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 54, l_hz_status_tab, 100, 0);
905: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 55, l_hz_hq_branch_ind_tab, 100, 0);
906: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 56, l_hz_sic_code_tab, 100, 0);
907: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 57, l_hz_sic_code_type_tab, 100, 0);
908: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 58, l_person_first_name_tab, 100, 0);
909: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 59, l_person_middle_name_tab, 100, 0);
910: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 60, l_person_last_name_tab, 100, 0);

Line 907: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 57, l_hz_sic_code_type_tab, 100, 0);

903: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 53, l_hz_party_type_tab, 100, 0);
904: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 54, l_hz_status_tab, 100, 0);
905: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 55, l_hz_hq_branch_ind_tab, 100, 0);
906: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 56, l_hz_sic_code_tab, 100, 0);
907: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 57, l_hz_sic_code_type_tab, 100, 0);
908: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 58, l_person_first_name_tab, 100, 0);
909: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 59, l_person_middle_name_tab, 100, 0);
910: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 60, l_person_last_name_tab, 100, 0);
911: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 61, l_hz_location_id_tab, 100, 0);

Line 908: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 58, l_person_first_name_tab, 100, 0);

904: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 54, l_hz_status_tab, 100, 0);
905: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 55, l_hz_hq_branch_ind_tab, 100, 0);
906: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 56, l_hz_sic_code_tab, 100, 0);
907: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 57, l_hz_sic_code_type_tab, 100, 0);
908: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 58, l_person_first_name_tab, 100, 0);
909: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 59, l_person_middle_name_tab, 100, 0);
910: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 60, l_person_last_name_tab, 100, 0);
911: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 61, l_hz_location_id_tab, 100, 0);
912: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 62, l_hz_country_tab, 100, 0);

Line 909: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 59, l_person_middle_name_tab, 100, 0);

905: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 55, l_hz_hq_branch_ind_tab, 100, 0);
906: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 56, l_hz_sic_code_tab, 100, 0);
907: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 57, l_hz_sic_code_type_tab, 100, 0);
908: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 58, l_person_first_name_tab, 100, 0);
909: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 59, l_person_middle_name_tab, 100, 0);
910: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 60, l_person_last_name_tab, 100, 0);
911: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 61, l_hz_location_id_tab, 100, 0);
912: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 62, l_hz_country_tab, 100, 0);
913: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 63, l_hz_address1_tab, 100, 0);

Line 910: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 60, l_person_last_name_tab, 100, 0);

906: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 56, l_hz_sic_code_tab, 100, 0);
907: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 57, l_hz_sic_code_type_tab, 100, 0);
908: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 58, l_person_first_name_tab, 100, 0);
909: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 59, l_person_middle_name_tab, 100, 0);
910: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 60, l_person_last_name_tab, 100, 0);
911: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 61, l_hz_location_id_tab, 100, 0);
912: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 62, l_hz_country_tab, 100, 0);
913: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 63, l_hz_address1_tab, 100, 0);
914: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 64, l_hz_address2_tab, 100, 0);

Line 911: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 61, l_hz_location_id_tab, 100, 0);

907: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 57, l_hz_sic_code_type_tab, 100, 0);
908: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 58, l_person_first_name_tab, 100, 0);
909: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 59, l_person_middle_name_tab, 100, 0);
910: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 60, l_person_last_name_tab, 100, 0);
911: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 61, l_hz_location_id_tab, 100, 0);
912: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 62, l_hz_country_tab, 100, 0);
913: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 63, l_hz_address1_tab, 100, 0);
914: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 64, l_hz_address2_tab, 100, 0);
915: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 65, l_hz_address3_tab, 100, 0);

Line 912: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 62, l_hz_country_tab, 100, 0);

908: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 58, l_person_first_name_tab, 100, 0);
909: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 59, l_person_middle_name_tab, 100, 0);
910: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 60, l_person_last_name_tab, 100, 0);
911: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 61, l_hz_location_id_tab, 100, 0);
912: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 62, l_hz_country_tab, 100, 0);
913: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 63, l_hz_address1_tab, 100, 0);
914: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 64, l_hz_address2_tab, 100, 0);
915: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 65, l_hz_address3_tab, 100, 0);
916: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 66, l_hz_address4_tab, 100, 0);

Line 913: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 63, l_hz_address1_tab, 100, 0);

909: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 59, l_person_middle_name_tab, 100, 0);
910: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 60, l_person_last_name_tab, 100, 0);
911: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 61, l_hz_location_id_tab, 100, 0);
912: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 62, l_hz_country_tab, 100, 0);
913: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 63, l_hz_address1_tab, 100, 0);
914: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 64, l_hz_address2_tab, 100, 0);
915: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 65, l_hz_address3_tab, 100, 0);
916: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 66, l_hz_address4_tab, 100, 0);
917: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 67, l_hz_city_tab, 100, 0);

Line 914: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 64, l_hz_address2_tab, 100, 0);

910: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 60, l_person_last_name_tab, 100, 0);
911: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 61, l_hz_location_id_tab, 100, 0);
912: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 62, l_hz_country_tab, 100, 0);
913: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 63, l_hz_address1_tab, 100, 0);
914: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 64, l_hz_address2_tab, 100, 0);
915: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 65, l_hz_address3_tab, 100, 0);
916: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 66, l_hz_address4_tab, 100, 0);
917: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 67, l_hz_city_tab, 100, 0);
918: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 68, l_hz_postal_code_tab, 100, 0);

Line 915: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 65, l_hz_address3_tab, 100, 0);

911: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 61, l_hz_location_id_tab, 100, 0);
912: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 62, l_hz_country_tab, 100, 0);
913: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 63, l_hz_address1_tab, 100, 0);
914: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 64, l_hz_address2_tab, 100, 0);
915: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 65, l_hz_address3_tab, 100, 0);
916: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 66, l_hz_address4_tab, 100, 0);
917: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 67, l_hz_city_tab, 100, 0);
918: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 68, l_hz_postal_code_tab, 100, 0);
919: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 69, l_hz_state_tab, 100, 0);

Line 916: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 66, l_hz_address4_tab, 100, 0);

912: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 62, l_hz_country_tab, 100, 0);
913: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 63, l_hz_address1_tab, 100, 0);
914: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 64, l_hz_address2_tab, 100, 0);
915: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 65, l_hz_address3_tab, 100, 0);
916: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 66, l_hz_address4_tab, 100, 0);
917: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 67, l_hz_city_tab, 100, 0);
918: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 68, l_hz_postal_code_tab, 100, 0);
919: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 69, l_hz_state_tab, 100, 0);
920: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 70, l_hz_province_tab, 100, 0);

Line 917: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 67, l_hz_city_tab, 100, 0);

913: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 63, l_hz_address1_tab, 100, 0);
914: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 64, l_hz_address2_tab, 100, 0);
915: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 65, l_hz_address3_tab, 100, 0);
916: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 66, l_hz_address4_tab, 100, 0);
917: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 67, l_hz_city_tab, 100, 0);
918: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 68, l_hz_postal_code_tab, 100, 0);
919: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 69, l_hz_state_tab, 100, 0);
920: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 70, l_hz_province_tab, 100, 0);
921: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 71, l_hz_county_tab, 100, 0);

Line 918: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 68, l_hz_postal_code_tab, 100, 0);

914: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 64, l_hz_address2_tab, 100, 0);
915: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 65, l_hz_address3_tab, 100, 0);
916: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 66, l_hz_address4_tab, 100, 0);
917: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 67, l_hz_city_tab, 100, 0);
918: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 68, l_hz_postal_code_tab, 100, 0);
919: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 69, l_hz_state_tab, 100, 0);
920: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 70, l_hz_province_tab, 100, 0);
921: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 71, l_hz_county_tab, 100, 0);
922: --

Line 919: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 69, l_hz_state_tab, 100, 0);

915: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 65, l_hz_address3_tab, 100, 0);
916: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 66, l_hz_address4_tab, 100, 0);
917: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 67, l_hz_city_tab, 100, 0);
918: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 68, l_hz_postal_code_tab, 100, 0);
919: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 69, l_hz_state_tab, 100, 0);
920: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 70, l_hz_province_tab, 100, 0);
921: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 71, l_hz_county_tab, 100, 0);
922: --
923: -- Debug Statements

Line 920: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 70, l_hz_province_tab, 100, 0);

916: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 66, l_hz_address4_tab, 100, 0);
917: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 67, l_hz_city_tab, 100, 0);
918: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 68, l_hz_postal_code_tab, 100, 0);
919: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 69, l_hz_state_tab, 100, 0);
920: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 70, l_hz_province_tab, 100, 0);
921: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 71, l_hz_county_tab, 100, 0);
922: --
923: -- Debug Statements
924: --

Line 921: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 71, l_hz_county_tab, 100, 0);

917: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 67, l_hz_city_tab, 100, 0);
918: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 68, l_hz_postal_code_tab, 100, 0);
919: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 69, l_hz_state_tab, 100, 0);
920: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 70, l_hz_province_tab, 100, 0);
921: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 71, l_hz_county_tab, 100, 0);
922: --
923: -- Debug Statements
924: --
925: IF l_debug_on THEN

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

940: IF l_debug_on THEN
941: WSH_DEBUG_SV.LOGMSG (l_module_name,'Successfull in binding values',WSH_DEBUG_SV.C_STMT_LEVEL);
942: END IF;
943:
944: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
945:
946:
947: --Bulk Collect customized SQL
948: LOOP

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

945:
946:
947: --Bulk Collect customized SQL
948: LOOP
949: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
950:
951:
952: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_sourceID_tab);
953: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);

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

948: LOOP
949: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
950:
951:
952: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_sourceID_tab);
953: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);
954: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
955: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
956: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);

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

949: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
950:
951:
952: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_sourceID_tab);
953: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);
954: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
955: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
956: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
957: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);

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

950:
951:
952: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_sourceID_tab);
953: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);
954: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
955: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
956: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
957: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
958: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);

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

951:
952: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_sourceID_tab);
953: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);
954: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
955: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
956: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
957: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
958: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
959: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);

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

952: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_sourceID_tab);
953: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);
954: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
955: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
956: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
957: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
958: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
959: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
960: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);

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

953: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_num_hzpartyID_tab);
954: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
955: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
956: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
957: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
958: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
959: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
960: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
961: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);

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

954: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_num_hzpartySiteID_tab);
955: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
956: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
957: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
958: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
959: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
960: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
961: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
962: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);

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

955: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_num_custAccountID_tab);
956: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
957: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
958: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
959: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
960: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
961: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
962: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
963: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);

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

956: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_PartnrType_tab);
957: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
958: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
959: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
960: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
961: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
962: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
963: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
964: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);

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

957: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_varchar_PartyName_tab);
958: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
959: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
960: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
961: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
962: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
963: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
964: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
965: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);

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

958: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_varchar_AlternateName_tab);
959: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
960: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
961: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
962: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
963: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
964: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
965: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
966: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);

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

959: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_TaxRef_tab);
960: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
961: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
962: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
963: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
964: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
965: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
966: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
967: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);

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

960: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_Address1_tab);
961: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
962: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
963: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
964: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
965: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
966: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
967: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
968: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);

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

961: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10,l_varchar_Address2_tab);
962: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
963: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
964: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
965: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
966: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
967: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
968: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
969: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);

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

962: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Address3_tab);
963: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
964: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
965: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
966: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
967: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
968: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
969: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
970: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);

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

963: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Address4_tab);
964: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
965: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
966: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
967: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
968: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
969: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
970: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
971:

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

964: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_City_tab);
965: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
966: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
967: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
968: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
969: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
970: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
971:
972: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);

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

965: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_State_tab);
966: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
967: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
968: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
969: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
970: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
971:
972: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
973: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);

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

966: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Country_tab);
967: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_PostalCode_tab);
968: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
969: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
970: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
971:
972: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
973: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
974: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);

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

968: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_AcctNumber_tab);
969: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
970: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
971:
972: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
973: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
974: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
975: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
976: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);

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

969: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_AcctName_tab);
970: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
971:
972: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
973: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
974: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
975: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
976: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
977: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);

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

970: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_SiteNumber_tab);
971:
972: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
973: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
974: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
975: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
976: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
977: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
978: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);

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

971:
972: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
973: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
974: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
975: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
976: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
977: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
978: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
979: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);

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

972: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_tempAttrib1_tab);
973: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
974: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
975: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
976: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
977: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
978: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
979: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
980: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);

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

973: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_tempAttrib2_tab);
974: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
975: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
976: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
977: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
978: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
979: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
980: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
981: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);

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

974: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_tempAttrib3_tab);
975: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
976: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
977: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
978: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
979: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
980: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
981: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
982: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);

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

975: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_tempAttrib4_tab);
976: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
977: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
978: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
979: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
980: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
981: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
982: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
983: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);

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

976: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_tempAttrib5_tab);
977: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
978: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
979: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
980: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
981: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
982: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
983: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
984: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);

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

977: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_tempAttrib6_tab);
978: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
979: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
980: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
981: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
982: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
983: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
984: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
985: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);

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

978: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_tempAttrib7_tab);
979: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
980: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
981: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
982: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
983: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
984: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
985: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
986: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);

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

979: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_tempAttrib8_tab);
980: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
981: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
982: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
983: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
984: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
985: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
986: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
987:

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

980: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_varchar_tempAttrib9_tab);
981: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
982: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
983: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
984: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
985: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
986: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
987:
988: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);

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

981: DBMS_SQL.COLUMN_VALUE(l_CursorID, 29, l_varchar_tempAttrib10_tab);
982: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
983: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
984: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
985: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
986: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
987:
988: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
989: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);

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

982: DBMS_SQL.COLUMN_VALUE(l_CursorID, 30, l_varchar_tempAttrib11_tab);
983: DBMS_SQL.COLUMN_VALUE(l_CursorID, 31, l_varchar_tempAttrib12_tab);
984: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
985: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
986: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
987:
988: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
989: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
990: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);

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

984: DBMS_SQL.COLUMN_VALUE(l_CursorID, 32, l_varchar_tempAttrib13_tab);
985: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
986: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
987:
988: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
989: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
990: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
991: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
992: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);

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

985: DBMS_SQL.COLUMN_VALUE(l_CursorID, 33, l_varchar_tempAttrib14_tab);
986: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
987:
988: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
989: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
990: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
991: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
992: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
993: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);

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

986: DBMS_SQL.COLUMN_VALUE(l_CursorID, 34, l_varchar_tempAttrib15_tab);
987:
988: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
989: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
990: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
991: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
992: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
993: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
994: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);

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

987:
988: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
989: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
990: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
991: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
992: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
993: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
994: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
995: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);

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

988: DBMS_SQL.COLUMN_VALUE(l_CursorID, 35, l_varchar_Attrib1_tab);
989: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
990: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
991: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
992: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
993: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
994: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
995: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
996: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);

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

989: DBMS_SQL.COLUMN_VALUE(l_CursorID, 36, l_varchar_Attrib2_tab);
990: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
991: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
992: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
993: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
994: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
995: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
996: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
997: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);

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

990: DBMS_SQL.COLUMN_VALUE(l_CursorID, 37, l_varchar_Attrib3_tab);
991: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
992: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
993: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
994: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
995: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
996: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
997: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
998: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);

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

991: DBMS_SQL.COLUMN_VALUE(l_CursorID, 38, l_varchar_Attrib4_tab);
992: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
993: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
994: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
995: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
996: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
997: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
998: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
999: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);

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

992: DBMS_SQL.COLUMN_VALUE(l_CursorID, 39, l_varchar_Attrib5_tab);
993: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
994: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
995: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
996: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
997: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
998: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
999: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
1000: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);

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

993: DBMS_SQL.COLUMN_VALUE(l_CursorID, 40, l_varchar_Attrib6_tab);
994: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
995: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
996: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
997: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
998: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
999: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
1000: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
1001: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);

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

994: DBMS_SQL.COLUMN_VALUE(l_CursorID, 41, l_varchar_Attrib7_tab);
995: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
996: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
997: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
998: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
999: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
1000: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
1001: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
1002: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);

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

995: DBMS_SQL.COLUMN_VALUE(l_CursorID, 42, l_varchar_Attrib8_tab);
996: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
997: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
998: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
999: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
1000: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
1001: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
1002: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
1003: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);

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

996: DBMS_SQL.COLUMN_VALUE(l_CursorID, 43, l_varchar_Attrib9_tab);
997: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
998: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
999: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
1000: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
1001: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
1002: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
1003: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);
1004: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type); -- gtm New Ones added Below

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

997: DBMS_SQL.COLUMN_VALUE(l_CursorID, 44, l_varchar_Attrib10_tab);
998: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
999: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
1000: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
1001: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
1002: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
1003: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);
1004: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type); -- gtm New Ones added Below
1005: DBMS_SQL.COLUMN_VALUE(l_CursorID, 52, l_hz_party_num_tab);

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

998: DBMS_SQL.COLUMN_VALUE(l_CursorID, 45, l_varchar_Attrib11_tab);
999: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
1000: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
1001: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
1002: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
1003: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);
1004: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type); -- gtm New Ones added Below
1005: DBMS_SQL.COLUMN_VALUE(l_CursorID, 52, l_hz_party_num_tab);
1006: DBMS_SQL.COLUMN_VALUE(l_CursorID, 53, l_hz_party_type_tab);

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

999: DBMS_SQL.COLUMN_VALUE(l_CursorID, 46, l_varchar_Attrib12_tab);
1000: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
1001: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
1002: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
1003: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);
1004: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type); -- gtm New Ones added Below
1005: DBMS_SQL.COLUMN_VALUE(l_CursorID, 52, l_hz_party_num_tab);
1006: DBMS_SQL.COLUMN_VALUE(l_CursorID, 53, l_hz_party_type_tab);
1007: DBMS_SQL.COLUMN_VALUE(l_CursorID, 54, l_hz_status_tab);

Line 1004: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type); -- gtm New Ones added Below

1000: DBMS_SQL.COLUMN_VALUE(l_CursorID, 47, l_varchar_Attrib13_tab);
1001: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
1002: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
1003: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);
1004: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type); -- gtm New Ones added Below
1005: DBMS_SQL.COLUMN_VALUE(l_CursorID, 52, l_hz_party_num_tab);
1006: DBMS_SQL.COLUMN_VALUE(l_CursorID, 53, l_hz_party_type_tab);
1007: DBMS_SQL.COLUMN_VALUE(l_CursorID, 54, l_hz_status_tab);
1008: DBMS_SQL.COLUMN_VALUE(l_CursorID, 55, l_hz_hq_branch_ind_tab);

Line 1005: DBMS_SQL.COLUMN_VALUE(l_CursorID, 52, l_hz_party_num_tab);

1001: DBMS_SQL.COLUMN_VALUE(l_CursorID, 48, l_varchar_Attrib14_tab);
1002: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
1003: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);
1004: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type); -- gtm New Ones added Below
1005: DBMS_SQL.COLUMN_VALUE(l_CursorID, 52, l_hz_party_num_tab);
1006: DBMS_SQL.COLUMN_VALUE(l_CursorID, 53, l_hz_party_type_tab);
1007: DBMS_SQL.COLUMN_VALUE(l_CursorID, 54, l_hz_status_tab);
1008: DBMS_SQL.COLUMN_VALUE(l_CursorID, 55, l_hz_hq_branch_ind_tab);
1009: DBMS_SQL.COLUMN_VALUE(l_CursorID, 56, l_hz_sic_code_tab);

Line 1006: DBMS_SQL.COLUMN_VALUE(l_CursorID, 53, l_hz_party_type_tab);

1002: DBMS_SQL.COLUMN_VALUE(l_CursorID, 49, l_varchar_Attrib15_tab);
1003: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);
1004: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type); -- gtm New Ones added Below
1005: DBMS_SQL.COLUMN_VALUE(l_CursorID, 52, l_hz_party_num_tab);
1006: DBMS_SQL.COLUMN_VALUE(l_CursorID, 53, l_hz_party_type_tab);
1007: DBMS_SQL.COLUMN_VALUE(l_CursorID, 54, l_hz_status_tab);
1008: DBMS_SQL.COLUMN_VALUE(l_CursorID, 55, l_hz_hq_branch_ind_tab);
1009: DBMS_SQL.COLUMN_VALUE(l_CursorID, 56, l_hz_sic_code_tab);
1010: DBMS_SQL.COLUMN_VALUE(l_CursorID, 57, l_hz_sic_code_type_tab);

Line 1007: DBMS_SQL.COLUMN_VALUE(l_CursorID, 54, l_hz_status_tab);

1003: DBMS_SQL.COLUMN_VALUE(l_CursorID, 50, l_operating_unit);
1004: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type); -- gtm New Ones added Below
1005: DBMS_SQL.COLUMN_VALUE(l_CursorID, 52, l_hz_party_num_tab);
1006: DBMS_SQL.COLUMN_VALUE(l_CursorID, 53, l_hz_party_type_tab);
1007: DBMS_SQL.COLUMN_VALUE(l_CursorID, 54, l_hz_status_tab);
1008: DBMS_SQL.COLUMN_VALUE(l_CursorID, 55, l_hz_hq_branch_ind_tab);
1009: DBMS_SQL.COLUMN_VALUE(l_CursorID, 56, l_hz_sic_code_tab);
1010: DBMS_SQL.COLUMN_VALUE(l_CursorID, 57, l_hz_sic_code_type_tab);
1011: DBMS_SQL.COLUMN_VALUE(l_CursorID, 58, l_person_first_name_tab);

Line 1008: DBMS_SQL.COLUMN_VALUE(l_CursorID, 55, l_hz_hq_branch_ind_tab);

1004: DBMS_SQL.COLUMN_VALUE(l_CursorID, 51, l_address_type); -- gtm New Ones added Below
1005: DBMS_SQL.COLUMN_VALUE(l_CursorID, 52, l_hz_party_num_tab);
1006: DBMS_SQL.COLUMN_VALUE(l_CursorID, 53, l_hz_party_type_tab);
1007: DBMS_SQL.COLUMN_VALUE(l_CursorID, 54, l_hz_status_tab);
1008: DBMS_SQL.COLUMN_VALUE(l_CursorID, 55, l_hz_hq_branch_ind_tab);
1009: DBMS_SQL.COLUMN_VALUE(l_CursorID, 56, l_hz_sic_code_tab);
1010: DBMS_SQL.COLUMN_VALUE(l_CursorID, 57, l_hz_sic_code_type_tab);
1011: DBMS_SQL.COLUMN_VALUE(l_CursorID, 58, l_person_first_name_tab);
1012: DBMS_SQL.COLUMN_VALUE(l_CursorID, 59, l_person_middle_name_tab);

Line 1009: DBMS_SQL.COLUMN_VALUE(l_CursorID, 56, l_hz_sic_code_tab);

1005: DBMS_SQL.COLUMN_VALUE(l_CursorID, 52, l_hz_party_num_tab);
1006: DBMS_SQL.COLUMN_VALUE(l_CursorID, 53, l_hz_party_type_tab);
1007: DBMS_SQL.COLUMN_VALUE(l_CursorID, 54, l_hz_status_tab);
1008: DBMS_SQL.COLUMN_VALUE(l_CursorID, 55, l_hz_hq_branch_ind_tab);
1009: DBMS_SQL.COLUMN_VALUE(l_CursorID, 56, l_hz_sic_code_tab);
1010: DBMS_SQL.COLUMN_VALUE(l_CursorID, 57, l_hz_sic_code_type_tab);
1011: DBMS_SQL.COLUMN_VALUE(l_CursorID, 58, l_person_first_name_tab);
1012: DBMS_SQL.COLUMN_VALUE(l_CursorID, 59, l_person_middle_name_tab);
1013: DBMS_SQL.COLUMN_VALUE(l_CursorID, 60, l_person_last_name_tab);

Line 1010: DBMS_SQL.COLUMN_VALUE(l_CursorID, 57, l_hz_sic_code_type_tab);

1006: DBMS_SQL.COLUMN_VALUE(l_CursorID, 53, l_hz_party_type_tab);
1007: DBMS_SQL.COLUMN_VALUE(l_CursorID, 54, l_hz_status_tab);
1008: DBMS_SQL.COLUMN_VALUE(l_CursorID, 55, l_hz_hq_branch_ind_tab);
1009: DBMS_SQL.COLUMN_VALUE(l_CursorID, 56, l_hz_sic_code_tab);
1010: DBMS_SQL.COLUMN_VALUE(l_CursorID, 57, l_hz_sic_code_type_tab);
1011: DBMS_SQL.COLUMN_VALUE(l_CursorID, 58, l_person_first_name_tab);
1012: DBMS_SQL.COLUMN_VALUE(l_CursorID, 59, l_person_middle_name_tab);
1013: DBMS_SQL.COLUMN_VALUE(l_CursorID, 60, l_person_last_name_tab);
1014: DBMS_SQL.COLUMN_VALUE(l_CursorID, 61, l_hz_location_id_tab);

Line 1011: DBMS_SQL.COLUMN_VALUE(l_CursorID, 58, l_person_first_name_tab);

1007: DBMS_SQL.COLUMN_VALUE(l_CursorID, 54, l_hz_status_tab);
1008: DBMS_SQL.COLUMN_VALUE(l_CursorID, 55, l_hz_hq_branch_ind_tab);
1009: DBMS_SQL.COLUMN_VALUE(l_CursorID, 56, l_hz_sic_code_tab);
1010: DBMS_SQL.COLUMN_VALUE(l_CursorID, 57, l_hz_sic_code_type_tab);
1011: DBMS_SQL.COLUMN_VALUE(l_CursorID, 58, l_person_first_name_tab);
1012: DBMS_SQL.COLUMN_VALUE(l_CursorID, 59, l_person_middle_name_tab);
1013: DBMS_SQL.COLUMN_VALUE(l_CursorID, 60, l_person_last_name_tab);
1014: DBMS_SQL.COLUMN_VALUE(l_CursorID, 61, l_hz_location_id_tab);
1015: DBMS_SQL.COLUMN_VALUE(l_CursorID, 62, l_hz_country_tab);

Line 1012: DBMS_SQL.COLUMN_VALUE(l_CursorID, 59, l_person_middle_name_tab);

1008: DBMS_SQL.COLUMN_VALUE(l_CursorID, 55, l_hz_hq_branch_ind_tab);
1009: DBMS_SQL.COLUMN_VALUE(l_CursorID, 56, l_hz_sic_code_tab);
1010: DBMS_SQL.COLUMN_VALUE(l_CursorID, 57, l_hz_sic_code_type_tab);
1011: DBMS_SQL.COLUMN_VALUE(l_CursorID, 58, l_person_first_name_tab);
1012: DBMS_SQL.COLUMN_VALUE(l_CursorID, 59, l_person_middle_name_tab);
1013: DBMS_SQL.COLUMN_VALUE(l_CursorID, 60, l_person_last_name_tab);
1014: DBMS_SQL.COLUMN_VALUE(l_CursorID, 61, l_hz_location_id_tab);
1015: DBMS_SQL.COLUMN_VALUE(l_CursorID, 62, l_hz_country_tab);
1016: DBMS_SQL.COLUMN_VALUE(l_CursorID, 63, l_hz_address1_tab);

Line 1013: DBMS_SQL.COLUMN_VALUE(l_CursorID, 60, l_person_last_name_tab);

1009: DBMS_SQL.COLUMN_VALUE(l_CursorID, 56, l_hz_sic_code_tab);
1010: DBMS_SQL.COLUMN_VALUE(l_CursorID, 57, l_hz_sic_code_type_tab);
1011: DBMS_SQL.COLUMN_VALUE(l_CursorID, 58, l_person_first_name_tab);
1012: DBMS_SQL.COLUMN_VALUE(l_CursorID, 59, l_person_middle_name_tab);
1013: DBMS_SQL.COLUMN_VALUE(l_CursorID, 60, l_person_last_name_tab);
1014: DBMS_SQL.COLUMN_VALUE(l_CursorID, 61, l_hz_location_id_tab);
1015: DBMS_SQL.COLUMN_VALUE(l_CursorID, 62, l_hz_country_tab);
1016: DBMS_SQL.COLUMN_VALUE(l_CursorID, 63, l_hz_address1_tab);
1017: DBMS_SQL.COLUMN_VALUE(l_CursorID, 64, l_hz_address2_tab);

Line 1014: DBMS_SQL.COLUMN_VALUE(l_CursorID, 61, l_hz_location_id_tab);

1010: DBMS_SQL.COLUMN_VALUE(l_CursorID, 57, l_hz_sic_code_type_tab);
1011: DBMS_SQL.COLUMN_VALUE(l_CursorID, 58, l_person_first_name_tab);
1012: DBMS_SQL.COLUMN_VALUE(l_CursorID, 59, l_person_middle_name_tab);
1013: DBMS_SQL.COLUMN_VALUE(l_CursorID, 60, l_person_last_name_tab);
1014: DBMS_SQL.COLUMN_VALUE(l_CursorID, 61, l_hz_location_id_tab);
1015: DBMS_SQL.COLUMN_VALUE(l_CursorID, 62, l_hz_country_tab);
1016: DBMS_SQL.COLUMN_VALUE(l_CursorID, 63, l_hz_address1_tab);
1017: DBMS_SQL.COLUMN_VALUE(l_CursorID, 64, l_hz_address2_tab);
1018: DBMS_SQL.COLUMN_VALUE(l_CursorID, 65, l_hz_address3_tab);

Line 1015: DBMS_SQL.COLUMN_VALUE(l_CursorID, 62, l_hz_country_tab);

1011: DBMS_SQL.COLUMN_VALUE(l_CursorID, 58, l_person_first_name_tab);
1012: DBMS_SQL.COLUMN_VALUE(l_CursorID, 59, l_person_middle_name_tab);
1013: DBMS_SQL.COLUMN_VALUE(l_CursorID, 60, l_person_last_name_tab);
1014: DBMS_SQL.COLUMN_VALUE(l_CursorID, 61, l_hz_location_id_tab);
1015: DBMS_SQL.COLUMN_VALUE(l_CursorID, 62, l_hz_country_tab);
1016: DBMS_SQL.COLUMN_VALUE(l_CursorID, 63, l_hz_address1_tab);
1017: DBMS_SQL.COLUMN_VALUE(l_CursorID, 64, l_hz_address2_tab);
1018: DBMS_SQL.COLUMN_VALUE(l_CursorID, 65, l_hz_address3_tab);
1019: DBMS_SQL.COLUMN_VALUE(l_CursorID, 66, l_hz_address4_tab);

Line 1016: DBMS_SQL.COLUMN_VALUE(l_CursorID, 63, l_hz_address1_tab);

1012: DBMS_SQL.COLUMN_VALUE(l_CursorID, 59, l_person_middle_name_tab);
1013: DBMS_SQL.COLUMN_VALUE(l_CursorID, 60, l_person_last_name_tab);
1014: DBMS_SQL.COLUMN_VALUE(l_CursorID, 61, l_hz_location_id_tab);
1015: DBMS_SQL.COLUMN_VALUE(l_CursorID, 62, l_hz_country_tab);
1016: DBMS_SQL.COLUMN_VALUE(l_CursorID, 63, l_hz_address1_tab);
1017: DBMS_SQL.COLUMN_VALUE(l_CursorID, 64, l_hz_address2_tab);
1018: DBMS_SQL.COLUMN_VALUE(l_CursorID, 65, l_hz_address3_tab);
1019: DBMS_SQL.COLUMN_VALUE(l_CursorID, 66, l_hz_address4_tab);
1020: DBMS_SQL.COLUMN_VALUE(l_CursorID, 67, l_hz_city_tab);

Line 1017: DBMS_SQL.COLUMN_VALUE(l_CursorID, 64, l_hz_address2_tab);

1013: DBMS_SQL.COLUMN_VALUE(l_CursorID, 60, l_person_last_name_tab);
1014: DBMS_SQL.COLUMN_VALUE(l_CursorID, 61, l_hz_location_id_tab);
1015: DBMS_SQL.COLUMN_VALUE(l_CursorID, 62, l_hz_country_tab);
1016: DBMS_SQL.COLUMN_VALUE(l_CursorID, 63, l_hz_address1_tab);
1017: DBMS_SQL.COLUMN_VALUE(l_CursorID, 64, l_hz_address2_tab);
1018: DBMS_SQL.COLUMN_VALUE(l_CursorID, 65, l_hz_address3_tab);
1019: DBMS_SQL.COLUMN_VALUE(l_CursorID, 66, l_hz_address4_tab);
1020: DBMS_SQL.COLUMN_VALUE(l_CursorID, 67, l_hz_city_tab);
1021: DBMS_SQL.COLUMN_VALUE(l_CursorID, 68, l_hz_postal_code_tab);

Line 1018: DBMS_SQL.COLUMN_VALUE(l_CursorID, 65, l_hz_address3_tab);

1014: DBMS_SQL.COLUMN_VALUE(l_CursorID, 61, l_hz_location_id_tab);
1015: DBMS_SQL.COLUMN_VALUE(l_CursorID, 62, l_hz_country_tab);
1016: DBMS_SQL.COLUMN_VALUE(l_CursorID, 63, l_hz_address1_tab);
1017: DBMS_SQL.COLUMN_VALUE(l_CursorID, 64, l_hz_address2_tab);
1018: DBMS_SQL.COLUMN_VALUE(l_CursorID, 65, l_hz_address3_tab);
1019: DBMS_SQL.COLUMN_VALUE(l_CursorID, 66, l_hz_address4_tab);
1020: DBMS_SQL.COLUMN_VALUE(l_CursorID, 67, l_hz_city_tab);
1021: DBMS_SQL.COLUMN_VALUE(l_CursorID, 68, l_hz_postal_code_tab);
1022: DBMS_SQL.COLUMN_VALUE(l_CursorID, 69, l_hz_state_tab);

Line 1019: DBMS_SQL.COLUMN_VALUE(l_CursorID, 66, l_hz_address4_tab);

1015: DBMS_SQL.COLUMN_VALUE(l_CursorID, 62, l_hz_country_tab);
1016: DBMS_SQL.COLUMN_VALUE(l_CursorID, 63, l_hz_address1_tab);
1017: DBMS_SQL.COLUMN_VALUE(l_CursorID, 64, l_hz_address2_tab);
1018: DBMS_SQL.COLUMN_VALUE(l_CursorID, 65, l_hz_address3_tab);
1019: DBMS_SQL.COLUMN_VALUE(l_CursorID, 66, l_hz_address4_tab);
1020: DBMS_SQL.COLUMN_VALUE(l_CursorID, 67, l_hz_city_tab);
1021: DBMS_SQL.COLUMN_VALUE(l_CursorID, 68, l_hz_postal_code_tab);
1022: DBMS_SQL.COLUMN_VALUE(l_CursorID, 69, l_hz_state_tab);
1023: DBMS_SQL.COLUMN_VALUE(l_CursorID, 70, l_hz_province_tab);

Line 1020: DBMS_SQL.COLUMN_VALUE(l_CursorID, 67, l_hz_city_tab);

1016: DBMS_SQL.COLUMN_VALUE(l_CursorID, 63, l_hz_address1_tab);
1017: DBMS_SQL.COLUMN_VALUE(l_CursorID, 64, l_hz_address2_tab);
1018: DBMS_SQL.COLUMN_VALUE(l_CursorID, 65, l_hz_address3_tab);
1019: DBMS_SQL.COLUMN_VALUE(l_CursorID, 66, l_hz_address4_tab);
1020: DBMS_SQL.COLUMN_VALUE(l_CursorID, 67, l_hz_city_tab);
1021: DBMS_SQL.COLUMN_VALUE(l_CursorID, 68, l_hz_postal_code_tab);
1022: DBMS_SQL.COLUMN_VALUE(l_CursorID, 69, l_hz_state_tab);
1023: DBMS_SQL.COLUMN_VALUE(l_CursorID, 70, l_hz_province_tab);
1024: DBMS_SQL.COLUMN_VALUE(l_CursorID, 71, l_hz_county_tab);

Line 1021: DBMS_SQL.COLUMN_VALUE(l_CursorID, 68, l_hz_postal_code_tab);

1017: DBMS_SQL.COLUMN_VALUE(l_CursorID, 64, l_hz_address2_tab);
1018: DBMS_SQL.COLUMN_VALUE(l_CursorID, 65, l_hz_address3_tab);
1019: DBMS_SQL.COLUMN_VALUE(l_CursorID, 66, l_hz_address4_tab);
1020: DBMS_SQL.COLUMN_VALUE(l_CursorID, 67, l_hz_city_tab);
1021: DBMS_SQL.COLUMN_VALUE(l_CursorID, 68, l_hz_postal_code_tab);
1022: DBMS_SQL.COLUMN_VALUE(l_CursorID, 69, l_hz_state_tab);
1023: DBMS_SQL.COLUMN_VALUE(l_CursorID, 70, l_hz_province_tab);
1024: DBMS_SQL.COLUMN_VALUE(l_CursorID, 71, l_hz_county_tab);
1025:

Line 1022: DBMS_SQL.COLUMN_VALUE(l_CursorID, 69, l_hz_state_tab);

1018: DBMS_SQL.COLUMN_VALUE(l_CursorID, 65, l_hz_address3_tab);
1019: DBMS_SQL.COLUMN_VALUE(l_CursorID, 66, l_hz_address4_tab);
1020: DBMS_SQL.COLUMN_VALUE(l_CursorID, 67, l_hz_city_tab);
1021: DBMS_SQL.COLUMN_VALUE(l_CursorID, 68, l_hz_postal_code_tab);
1022: DBMS_SQL.COLUMN_VALUE(l_CursorID, 69, l_hz_state_tab);
1023: DBMS_SQL.COLUMN_VALUE(l_CursorID, 70, l_hz_province_tab);
1024: DBMS_SQL.COLUMN_VALUE(l_CursorID, 71, l_hz_county_tab);
1025:
1026: EXIT WHEN l_ignore <> 100;

Line 1023: DBMS_SQL.COLUMN_VALUE(l_CursorID, 70, l_hz_province_tab);

1019: DBMS_SQL.COLUMN_VALUE(l_CursorID, 66, l_hz_address4_tab);
1020: DBMS_SQL.COLUMN_VALUE(l_CursorID, 67, l_hz_city_tab);
1021: DBMS_SQL.COLUMN_VALUE(l_CursorID, 68, l_hz_postal_code_tab);
1022: DBMS_SQL.COLUMN_VALUE(l_CursorID, 69, l_hz_state_tab);
1023: DBMS_SQL.COLUMN_VALUE(l_CursorID, 70, l_hz_province_tab);
1024: DBMS_SQL.COLUMN_VALUE(l_CursorID, 71, l_hz_county_tab);
1025:
1026: EXIT WHEN l_ignore <> 100;
1027:

Line 1024: DBMS_SQL.COLUMN_VALUE(l_CursorID, 71, l_hz_county_tab);

1020: DBMS_SQL.COLUMN_VALUE(l_CursorID, 67, l_hz_city_tab);
1021: DBMS_SQL.COLUMN_VALUE(l_CursorID, 68, l_hz_postal_code_tab);
1022: DBMS_SQL.COLUMN_VALUE(l_CursorID, 69, l_hz_state_tab);
1023: DBMS_SQL.COLUMN_VALUE(l_CursorID, 70, l_hz_province_tab);
1024: DBMS_SQL.COLUMN_VALUE(l_CursorID, 71, l_hz_county_tab);
1025:
1026: EXIT WHEN l_ignore <> 100;
1027:
1028: END LOOP;

Line 1029: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

1025:
1026: EXIT WHEN l_ignore <> 100;
1027:
1028: END LOOP;
1029: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
1030:
1031: IF l_debug_on THEN
1032: WSH_DEBUG_SV.LOG (l_module_name, 'Number of parties queried : ' ,l_num_sourceID_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);
1033: END IF;