272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273: l_sysdate := SYSDATE;
274:
275: FOR i IN p_TerrLead_Rec.sales_lead_id.FIRST .. p_TerrLead_Rec.sales_lead_id.LAST LOOP
276: l_trans_rec.trans_object_id1 := jtf_terr_number_list(p_TerrLead_Rec.sales_lead_id(i));
277: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
278: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
279: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
280: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
273: l_sysdate := SYSDATE;
274:
275: FOR i IN p_TerrLead_Rec.sales_lead_id.FIRST .. p_TerrLead_Rec.sales_lead_id.LAST LOOP
276: l_trans_rec.trans_object_id1 := jtf_terr_number_list(p_TerrLead_Rec.sales_lead_id(i));
277: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
278: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
279: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
280: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
281: l_trans_rec.txn_date := jtf_terr_date_list(null);
274:
275: FOR i IN p_TerrLead_Rec.sales_lead_id.FIRST .. p_TerrLead_Rec.sales_lead_id.LAST LOOP
276: l_trans_rec.trans_object_id1 := jtf_terr_number_list(p_TerrLead_Rec.sales_lead_id(i));
277: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
278: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
279: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
280: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
281: l_trans_rec.txn_date := jtf_terr_date_list(null);
282:
275: FOR i IN p_TerrLead_Rec.sales_lead_id.FIRST .. p_TerrLead_Rec.sales_lead_id.LAST LOOP
276: l_trans_rec.trans_object_id1 := jtf_terr_number_list(p_TerrLead_Rec.sales_lead_id(i));
277: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
278: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
279: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
280: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
281: l_trans_rec.txn_date := jtf_terr_date_list(null);
282:
283: JTY_ASSIGN_REALTIME_PUB.get_winners(
276: l_trans_rec.trans_object_id1 := jtf_terr_number_list(p_TerrLead_Rec.sales_lead_id(i));
277: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
278: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
279: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
280: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
281: l_trans_rec.txn_date := jtf_terr_date_list(null);
282:
283: JTY_ASSIGN_REALTIME_PUB.get_winners(
284: p_api_version_number => 1.0,
444: l_counter NUMBER := 0;
445:
446: BEGIN
447: /* initialise BULK tables with SINGLE record values */
448: p_Rec.party_id := jtf_terr_number_list(p_terraccount_rec.party_id);
449: p_Rec.party_site_id := jtf_terr_number_list(p_terraccount_rec.party_site_id);
450: p_rec.city := jtf_terr_char_360list(p_terraccount_rec.city);
451: p_Rec.postal_code := jtf_terr_char_360list(p_terraccount_rec.postal_code);
452: p_rec.state := jtf_terr_char_360list(p_terraccount_rec.state);
445:
446: BEGIN
447: /* initialise BULK tables with SINGLE record values */
448: p_Rec.party_id := jtf_terr_number_list(p_terraccount_rec.party_id);
449: p_Rec.party_site_id := jtf_terr_number_list(p_terraccount_rec.party_site_id);
450: p_rec.city := jtf_terr_char_360list(p_terraccount_rec.city);
451: p_Rec.postal_code := jtf_terr_char_360list(p_terraccount_rec.postal_code);
452: p_rec.state := jtf_terr_char_360list(p_terraccount_rec.state);
453: p_rec.province := jtf_terr_char_360list(p_terraccount_rec.province);
452: p_rec.state := jtf_terr_char_360list(p_terraccount_rec.state);
453: p_rec.province := jtf_terr_char_360list(p_terraccount_rec.province);
454: p_rec.county := jtf_terr_char_360list(p_terraccount_rec.county);
455: p_rec.country := jtf_terr_char_360list(p_terraccount_rec.country);
456: p_rec.interest_type_id := jtf_terr_number_list(p_terraccount_rec.interest_type_id);
457: p_rec.primary_interest_id := jtf_terr_number_list(p_terraccount_rec.primary_interest_id);
458: p_rec.secondary_interest_id := jtf_terr_number_list(p_terraccount_rec.secondary_interest_id);
459: p_rec.area_code := jtf_terr_char_360list(p_terraccount_rec.area_code);
460: p_rec.comp_name_range := jtf_terr_char_360list(p_terraccount_rec.comp_name_range);
453: p_rec.province := jtf_terr_char_360list(p_terraccount_rec.province);
454: p_rec.county := jtf_terr_char_360list(p_terraccount_rec.county);
455: p_rec.country := jtf_terr_char_360list(p_terraccount_rec.country);
456: p_rec.interest_type_id := jtf_terr_number_list(p_terraccount_rec.interest_type_id);
457: p_rec.primary_interest_id := jtf_terr_number_list(p_terraccount_rec.primary_interest_id);
458: p_rec.secondary_interest_id := jtf_terr_number_list(p_terraccount_rec.secondary_interest_id);
459: p_rec.area_code := jtf_terr_char_360list(p_terraccount_rec.area_code);
460: p_rec.comp_name_range := jtf_terr_char_360list(p_terraccount_rec.comp_name_range);
461: p_rec.partner_id := jtf_terr_number_list(p_terraccount_rec.partner_id);
454: p_rec.county := jtf_terr_char_360list(p_terraccount_rec.county);
455: p_rec.country := jtf_terr_char_360list(p_terraccount_rec.country);
456: p_rec.interest_type_id := jtf_terr_number_list(p_terraccount_rec.interest_type_id);
457: p_rec.primary_interest_id := jtf_terr_number_list(p_terraccount_rec.primary_interest_id);
458: p_rec.secondary_interest_id := jtf_terr_number_list(p_terraccount_rec.secondary_interest_id);
459: p_rec.area_code := jtf_terr_char_360list(p_terraccount_rec.area_code);
460: p_rec.comp_name_range := jtf_terr_char_360list(p_terraccount_rec.comp_name_range);
461: p_rec.partner_id := jtf_terr_number_list(p_terraccount_rec.partner_id);
462: p_rec.num_of_employees := jtf_terr_number_list(p_terraccount_rec.num_of_employees);
457: p_rec.primary_interest_id := jtf_terr_number_list(p_terraccount_rec.primary_interest_id);
458: p_rec.secondary_interest_id := jtf_terr_number_list(p_terraccount_rec.secondary_interest_id);
459: p_rec.area_code := jtf_terr_char_360list(p_terraccount_rec.area_code);
460: p_rec.comp_name_range := jtf_terr_char_360list(p_terraccount_rec.comp_name_range);
461: p_rec.partner_id := jtf_terr_number_list(p_terraccount_rec.partner_id);
462: p_rec.num_of_employees := jtf_terr_number_list(p_terraccount_rec.num_of_employees);
463: p_rec.category_code := jtf_terr_char_360list(p_terraccount_rec.category_code);
464: p_rec.party_relationship_id := jtf_terr_number_list(p_terraccount_rec.party_relationship_id);
465: p_rec.sic_code := jtf_terr_char_360list(p_terraccount_rec.sic_code);
458: p_rec.secondary_interest_id := jtf_terr_number_list(p_terraccount_rec.secondary_interest_id);
459: p_rec.area_code := jtf_terr_char_360list(p_terraccount_rec.area_code);
460: p_rec.comp_name_range := jtf_terr_char_360list(p_terraccount_rec.comp_name_range);
461: p_rec.partner_id := jtf_terr_number_list(p_terraccount_rec.partner_id);
462: p_rec.num_of_employees := jtf_terr_number_list(p_terraccount_rec.num_of_employees);
463: p_rec.category_code := jtf_terr_char_360list(p_terraccount_rec.category_code);
464: p_rec.party_relationship_id := jtf_terr_number_list(p_terraccount_rec.party_relationship_id);
465: p_rec.sic_code := jtf_terr_char_360list(p_terraccount_rec.sic_code);
466: p_rec.attribute1 := jtf_terr_char_360list(p_terraccount_rec.attribute1);
460: p_rec.comp_name_range := jtf_terr_char_360list(p_terraccount_rec.comp_name_range);
461: p_rec.partner_id := jtf_terr_number_list(p_terraccount_rec.partner_id);
462: p_rec.num_of_employees := jtf_terr_number_list(p_terraccount_rec.num_of_employees);
463: p_rec.category_code := jtf_terr_char_360list(p_terraccount_rec.category_code);
464: p_rec.party_relationship_id := jtf_terr_number_list(p_terraccount_rec.party_relationship_id);
465: p_rec.sic_code := jtf_terr_char_360list(p_terraccount_rec.sic_code);
466: p_rec.attribute1 := jtf_terr_char_360list(p_terraccount_rec.attribute1);
467: p_rec.attribute2 := jtf_terr_char_360list(p_terraccount_rec.attribute2);
468: p_rec.attribute3 := jtf_terr_char_360list(p_terraccount_rec.attribute3);
552: BEGIN
553:
554: /* initialise BULK tables with SINGLE record values */
555: p_Rec.POSTAL_CODE := jtf_terr_char_360list(p_terracct_rec.postal_code);
556: p_Rec.PARTY_ID := jtf_terr_number_list(p_terracct_rec.party_id);
557: p_Rec.PARTY_SITE_ID := jtf_terr_number_list(p_terracct_rec.party_site_id);
558: p_rec.city := jtf_terr_char_360list(p_terracct_rec.city);
559: p_Rec.postal_code := jtf_terr_char_360list(p_terracct_rec.postal_code);
560: p_rec.state := jtf_terr_char_360list(p_terracct_rec.state);
553:
554: /* initialise BULK tables with SINGLE record values */
555: p_Rec.POSTAL_CODE := jtf_terr_char_360list(p_terracct_rec.postal_code);
556: p_Rec.PARTY_ID := jtf_terr_number_list(p_terracct_rec.party_id);
557: p_Rec.PARTY_SITE_ID := jtf_terr_number_list(p_terracct_rec.party_site_id);
558: p_rec.city := jtf_terr_char_360list(p_terracct_rec.city);
559: p_Rec.postal_code := jtf_terr_char_360list(p_terracct_rec.postal_code);
560: p_rec.state := jtf_terr_char_360list(p_terracct_rec.state);
561: p_rec.province := jtf_terr_char_360list(p_terracct_rec.province);
560: p_rec.state := jtf_terr_char_360list(p_terracct_rec.state);
561: p_rec.province := jtf_terr_char_360list(p_terracct_rec.province);
562: p_rec.county := jtf_terr_char_360list(p_terracct_rec.county);
563: p_rec.country := jtf_terr_char_360list(p_terracct_rec.country);
564: p_rec.interest_type_id := jtf_terr_number_list(p_terracct_rec.interest_type_id);
565: p_rec.primary_interest_id := jtf_terr_number_list(p_terracct_rec.primary_interest_id);
566: p_rec.secondary_interest_id := jtf_terr_number_list(p_terracct_rec.secondary_interest_id);
567: p_rec.area_code := jtf_terr_char_360list(p_terracct_rec.area_code);
568: p_rec.comp_name_range := jtf_terr_char_360list(p_terracct_rec.comp_name_range);
561: p_rec.province := jtf_terr_char_360list(p_terracct_rec.province);
562: p_rec.county := jtf_terr_char_360list(p_terracct_rec.county);
563: p_rec.country := jtf_terr_char_360list(p_terracct_rec.country);
564: p_rec.interest_type_id := jtf_terr_number_list(p_terracct_rec.interest_type_id);
565: p_rec.primary_interest_id := jtf_terr_number_list(p_terracct_rec.primary_interest_id);
566: p_rec.secondary_interest_id := jtf_terr_number_list(p_terracct_rec.secondary_interest_id);
567: p_rec.area_code := jtf_terr_char_360list(p_terracct_rec.area_code);
568: p_rec.comp_name_range := jtf_terr_char_360list(p_terracct_rec.comp_name_range);
569: p_rec.partner_id := jtf_terr_number_list(p_terracct_rec.partner_id);
562: p_rec.county := jtf_terr_char_360list(p_terracct_rec.county);
563: p_rec.country := jtf_terr_char_360list(p_terracct_rec.country);
564: p_rec.interest_type_id := jtf_terr_number_list(p_terracct_rec.interest_type_id);
565: p_rec.primary_interest_id := jtf_terr_number_list(p_terracct_rec.primary_interest_id);
566: p_rec.secondary_interest_id := jtf_terr_number_list(p_terracct_rec.secondary_interest_id);
567: p_rec.area_code := jtf_terr_char_360list(p_terracct_rec.area_code);
568: p_rec.comp_name_range := jtf_terr_char_360list(p_terracct_rec.comp_name_range);
569: p_rec.partner_id := jtf_terr_number_list(p_terracct_rec.partner_id);
570: p_rec.num_of_employees := jtf_terr_number_list(p_terracct_rec.num_of_employees);
565: p_rec.primary_interest_id := jtf_terr_number_list(p_terracct_rec.primary_interest_id);
566: p_rec.secondary_interest_id := jtf_terr_number_list(p_terracct_rec.secondary_interest_id);
567: p_rec.area_code := jtf_terr_char_360list(p_terracct_rec.area_code);
568: p_rec.comp_name_range := jtf_terr_char_360list(p_terracct_rec.comp_name_range);
569: p_rec.partner_id := jtf_terr_number_list(p_terracct_rec.partner_id);
570: p_rec.num_of_employees := jtf_terr_number_list(p_terracct_rec.num_of_employees);
571: p_rec.category_code := jtf_terr_char_360list(p_terracct_rec.category_code);
572: p_rec.party_relationship_id := jtf_terr_number_list(p_terracct_rec.party_relationship_id);
573: p_rec.sic_code := jtf_terr_char_360list(p_terracct_rec.sic_code);
566: p_rec.secondary_interest_id := jtf_terr_number_list(p_terracct_rec.secondary_interest_id);
567: p_rec.area_code := jtf_terr_char_360list(p_terracct_rec.area_code);
568: p_rec.comp_name_range := jtf_terr_char_360list(p_terracct_rec.comp_name_range);
569: p_rec.partner_id := jtf_terr_number_list(p_terracct_rec.partner_id);
570: p_rec.num_of_employees := jtf_terr_number_list(p_terracct_rec.num_of_employees);
571: p_rec.category_code := jtf_terr_char_360list(p_terracct_rec.category_code);
572: p_rec.party_relationship_id := jtf_terr_number_list(p_terracct_rec.party_relationship_id);
573: p_rec.sic_code := jtf_terr_char_360list(p_terracct_rec.sic_code);
574: p_rec.attribute1 := jtf_terr_char_360list(p_terracct_rec.attribute1);
568: p_rec.comp_name_range := jtf_terr_char_360list(p_terracct_rec.comp_name_range);
569: p_rec.partner_id := jtf_terr_number_list(p_terracct_rec.partner_id);
570: p_rec.num_of_employees := jtf_terr_number_list(p_terracct_rec.num_of_employees);
571: p_rec.category_code := jtf_terr_char_360list(p_terracct_rec.category_code);
572: p_rec.party_relationship_id := jtf_terr_number_list(p_terracct_rec.party_relationship_id);
573: p_rec.sic_code := jtf_terr_char_360list(p_terracct_rec.sic_code);
574: p_rec.attribute1 := jtf_terr_char_360list(p_terracct_rec.attribute1);
575: p_rec.attribute2 := jtf_terr_char_360list(p_terracct_rec.attribute2);
576: p_rec.attribute3 := jtf_terr_char_360list(p_terracct_rec.attribute3);
656:
657: /* This cursor is not allowed in 9i
658: CURSOR c_get_win_terr IS
659: SELECT DISTINCT wt.column_value
660: FROM TABLE ( CAST( x_winners_rec.terr_id AS JTF_TERR_NUMBER_LIST) ) AS wt;
661: */
662:
663:
664: /* 2167091 bug fix: JDOCHERT: 01/17/02 */
853: BEGIN
854:
855:
856: /* initialise BULK tables with SINGLE record values */
857: p_Rec.lead_id := jtf_terr_number_list(p_terroppor_rec.lead_id);
858: p_Rec.lead_line_id := jtf_terr_number_list(p_terroppor_rec.lead_line_id);
859: p_rec.city := jtf_terr_char_360list(p_terroppor_rec.city);
860: p_Rec.postal_code := jtf_terr_char_360list(p_terroppor_rec.postal_code);
861: p_rec.state := jtf_terr_char_360list(p_terroppor_rec.state);
854:
855:
856: /* initialise BULK tables with SINGLE record values */
857: p_Rec.lead_id := jtf_terr_number_list(p_terroppor_rec.lead_id);
858: p_Rec.lead_line_id := jtf_terr_number_list(p_terroppor_rec.lead_line_id);
859: p_rec.city := jtf_terr_char_360list(p_terroppor_rec.city);
860: p_Rec.postal_code := jtf_terr_char_360list(p_terroppor_rec.postal_code);
861: p_rec.state := jtf_terr_char_360list(p_terroppor_rec.state);
862: p_rec.province := jtf_terr_char_360list(p_terroppor_rec.province);
861: p_rec.state := jtf_terr_char_360list(p_terroppor_rec.state);
862: p_rec.province := jtf_terr_char_360list(p_terroppor_rec.province);
863: p_rec.county := jtf_terr_char_360list(p_terroppor_rec.county);
864: p_rec.country := jtf_terr_char_360list(p_terroppor_rec.country);
865: p_rec.interest_type_id := jtf_terr_number_list(p_terroppor_rec.interest_type_id);
866: p_rec.primary_interest_id := jtf_terr_number_list(p_terroppor_rec.primary_interest_id);
867: p_rec.secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.secondary_interest_id);
868: p_Rec.party_id := jtf_terr_number_list(p_terroppor_rec.party_id);
869: p_Rec.party_site_id := jtf_terr_number_list(p_terroppor_rec.party_site_id);
862: p_rec.province := jtf_terr_char_360list(p_terroppor_rec.province);
863: p_rec.county := jtf_terr_char_360list(p_terroppor_rec.county);
864: p_rec.country := jtf_terr_char_360list(p_terroppor_rec.country);
865: p_rec.interest_type_id := jtf_terr_number_list(p_terroppor_rec.interest_type_id);
866: p_rec.primary_interest_id := jtf_terr_number_list(p_terroppor_rec.primary_interest_id);
867: p_rec.secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.secondary_interest_id);
868: p_Rec.party_id := jtf_terr_number_list(p_terroppor_rec.party_id);
869: p_Rec.party_site_id := jtf_terr_number_list(p_terroppor_rec.party_site_id);
870: p_rec.area_code := jtf_terr_char_360list(p_terroppor_rec.area_code);
863: p_rec.county := jtf_terr_char_360list(p_terroppor_rec.county);
864: p_rec.country := jtf_terr_char_360list(p_terroppor_rec.country);
865: p_rec.interest_type_id := jtf_terr_number_list(p_terroppor_rec.interest_type_id);
866: p_rec.primary_interest_id := jtf_terr_number_list(p_terroppor_rec.primary_interest_id);
867: p_rec.secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.secondary_interest_id);
868: p_Rec.party_id := jtf_terr_number_list(p_terroppor_rec.party_id);
869: p_Rec.party_site_id := jtf_terr_number_list(p_terroppor_rec.party_site_id);
870: p_rec.area_code := jtf_terr_char_360list(p_terroppor_rec.area_code);
871: p_rec.comp_name_range := jtf_terr_char_360list(p_terroppor_rec.comp_name_range);
864: p_rec.country := jtf_terr_char_360list(p_terroppor_rec.country);
865: p_rec.interest_type_id := jtf_terr_number_list(p_terroppor_rec.interest_type_id);
866: p_rec.primary_interest_id := jtf_terr_number_list(p_terroppor_rec.primary_interest_id);
867: p_rec.secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.secondary_interest_id);
868: p_Rec.party_id := jtf_terr_number_list(p_terroppor_rec.party_id);
869: p_Rec.party_site_id := jtf_terr_number_list(p_terroppor_rec.party_site_id);
870: p_rec.area_code := jtf_terr_char_360list(p_terroppor_rec.area_code);
871: p_rec.comp_name_range := jtf_terr_char_360list(p_terroppor_rec.comp_name_range);
872: p_rec.partner_id := jtf_terr_number_list(p_terroppor_rec.partner_id);
865: p_rec.interest_type_id := jtf_terr_number_list(p_terroppor_rec.interest_type_id);
866: p_rec.primary_interest_id := jtf_terr_number_list(p_terroppor_rec.primary_interest_id);
867: p_rec.secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.secondary_interest_id);
868: p_Rec.party_id := jtf_terr_number_list(p_terroppor_rec.party_id);
869: p_Rec.party_site_id := jtf_terr_number_list(p_terroppor_rec.party_site_id);
870: p_rec.area_code := jtf_terr_char_360list(p_terroppor_rec.area_code);
871: p_rec.comp_name_range := jtf_terr_char_360list(p_terroppor_rec.comp_name_range);
872: p_rec.partner_id := jtf_terr_number_list(p_terroppor_rec.partner_id);
873: p_rec.num_of_employees := jtf_terr_number_list(p_terroppor_rec.num_of_employees);
868: p_Rec.party_id := jtf_terr_number_list(p_terroppor_rec.party_id);
869: p_Rec.party_site_id := jtf_terr_number_list(p_terroppor_rec.party_site_id);
870: p_rec.area_code := jtf_terr_char_360list(p_terroppor_rec.area_code);
871: p_rec.comp_name_range := jtf_terr_char_360list(p_terroppor_rec.comp_name_range);
872: p_rec.partner_id := jtf_terr_number_list(p_terroppor_rec.partner_id);
873: p_rec.num_of_employees := jtf_terr_number_list(p_terroppor_rec.num_of_employees);
874: p_rec.category_code := jtf_terr_char_360list(p_terroppor_rec.category_code);
875: p_rec.party_relationship_id := jtf_terr_number_list(p_terroppor_rec.party_relationship_id);
876: p_rec.sic_code := jtf_terr_char_360list(p_terroppor_rec.sic_code);
869: p_Rec.party_site_id := jtf_terr_number_list(p_terroppor_rec.party_site_id);
870: p_rec.area_code := jtf_terr_char_360list(p_terroppor_rec.area_code);
871: p_rec.comp_name_range := jtf_terr_char_360list(p_terroppor_rec.comp_name_range);
872: p_rec.partner_id := jtf_terr_number_list(p_terroppor_rec.partner_id);
873: p_rec.num_of_employees := jtf_terr_number_list(p_terroppor_rec.num_of_employees);
874: p_rec.category_code := jtf_terr_char_360list(p_terroppor_rec.category_code);
875: p_rec.party_relationship_id := jtf_terr_number_list(p_terroppor_rec.party_relationship_id);
876: p_rec.sic_code := jtf_terr_char_360list(p_terroppor_rec.sic_code);
877: p_rec.target_segment_current := jtf_terr_char_360list(p_terroppor_rec.target_segment_current);
871: p_rec.comp_name_range := jtf_terr_char_360list(p_terroppor_rec.comp_name_range);
872: p_rec.partner_id := jtf_terr_number_list(p_terroppor_rec.partner_id);
873: p_rec.num_of_employees := jtf_terr_number_list(p_terroppor_rec.num_of_employees);
874: p_rec.category_code := jtf_terr_char_360list(p_terroppor_rec.category_code);
875: p_rec.party_relationship_id := jtf_terr_number_list(p_terroppor_rec.party_relationship_id);
876: p_rec.sic_code := jtf_terr_char_360list(p_terroppor_rec.sic_code);
877: p_rec.target_segment_current := jtf_terr_char_360list(p_terroppor_rec.target_segment_current);
878: p_rec.total_amount := jtf_terr_number_list(p_terroppor_rec.total_amount);
879: p_rec.currency_code := jtf_terr_char_360list(p_terroppor_rec.currency_code);
874: p_rec.category_code := jtf_terr_char_360list(p_terroppor_rec.category_code);
875: p_rec.party_relationship_id := jtf_terr_number_list(p_terroppor_rec.party_relationship_id);
876: p_rec.sic_code := jtf_terr_char_360list(p_terroppor_rec.sic_code);
877: p_rec.target_segment_current := jtf_terr_char_360list(p_terroppor_rec.target_segment_current);
878: p_rec.total_amount := jtf_terr_number_list(p_terroppor_rec.total_amount);
879: p_rec.currency_code := jtf_terr_char_360list(p_terroppor_rec.currency_code);
880: p_rec.pricing_date := jtf_terr_date_list(p_terroppor_rec.pricing_date);
881: p_rec.channel_code := jtf_terr_char_360list(p_terroppor_rec.channel_code);
882: p_rec.inventory_item_id := jtf_terr_number_list(p_terroppor_rec.inventory_item_id);
878: p_rec.total_amount := jtf_terr_number_list(p_terroppor_rec.total_amount);
879: p_rec.currency_code := jtf_terr_char_360list(p_terroppor_rec.currency_code);
880: p_rec.pricing_date := jtf_terr_date_list(p_terroppor_rec.pricing_date);
881: p_rec.channel_code := jtf_terr_char_360list(p_terroppor_rec.channel_code);
882: p_rec.inventory_item_id := jtf_terr_number_list(p_terroppor_rec.inventory_item_id);
883: p_rec.opp_interest_type_id := jtf_terr_number_list(p_terroppor_rec.opp_interest_type_id);
884: p_rec.opp_primary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_primary_interest_id);
885: p_rec.opp_secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_secondary_interest_id);
886: p_rec.opclss_interest_type_id := jtf_terr_number_list(p_terroppor_rec.opclss_interest_type_id);
879: p_rec.currency_code := jtf_terr_char_360list(p_terroppor_rec.currency_code);
880: p_rec.pricing_date := jtf_terr_date_list(p_terroppor_rec.pricing_date);
881: p_rec.channel_code := jtf_terr_char_360list(p_terroppor_rec.channel_code);
882: p_rec.inventory_item_id := jtf_terr_number_list(p_terroppor_rec.inventory_item_id);
883: p_rec.opp_interest_type_id := jtf_terr_number_list(p_terroppor_rec.opp_interest_type_id);
884: p_rec.opp_primary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_primary_interest_id);
885: p_rec.opp_secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_secondary_interest_id);
886: p_rec.opclss_interest_type_id := jtf_terr_number_list(p_terroppor_rec.opclss_interest_type_id);
887: p_rec.opclss_primary_interest_id := jtf_terr_number_list(p_terroppor_rec.opclss_primary_interest_id);
880: p_rec.pricing_date := jtf_terr_date_list(p_terroppor_rec.pricing_date);
881: p_rec.channel_code := jtf_terr_char_360list(p_terroppor_rec.channel_code);
882: p_rec.inventory_item_id := jtf_terr_number_list(p_terroppor_rec.inventory_item_id);
883: p_rec.opp_interest_type_id := jtf_terr_number_list(p_terroppor_rec.opp_interest_type_id);
884: p_rec.opp_primary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_primary_interest_id);
885: p_rec.opp_secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_secondary_interest_id);
886: p_rec.opclss_interest_type_id := jtf_terr_number_list(p_terroppor_rec.opclss_interest_type_id);
887: p_rec.opclss_primary_interest_id := jtf_terr_number_list(p_terroppor_rec.opclss_primary_interest_id);
888: p_rec.opclss_secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.opclss_secondary_interest_id);
881: p_rec.channel_code := jtf_terr_char_360list(p_terroppor_rec.channel_code);
882: p_rec.inventory_item_id := jtf_terr_number_list(p_terroppor_rec.inventory_item_id);
883: p_rec.opp_interest_type_id := jtf_terr_number_list(p_terroppor_rec.opp_interest_type_id);
884: p_rec.opp_primary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_primary_interest_id);
885: p_rec.opp_secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_secondary_interest_id);
886: p_rec.opclss_interest_type_id := jtf_terr_number_list(p_terroppor_rec.opclss_interest_type_id);
887: p_rec.opclss_primary_interest_id := jtf_terr_number_list(p_terroppor_rec.opclss_primary_interest_id);
888: p_rec.opclss_secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.opclss_secondary_interest_id);
889: p_rec.attribute1 := jtf_terr_char_360list(p_terroppor_rec.attribute1);
882: p_rec.inventory_item_id := jtf_terr_number_list(p_terroppor_rec.inventory_item_id);
883: p_rec.opp_interest_type_id := jtf_terr_number_list(p_terroppor_rec.opp_interest_type_id);
884: p_rec.opp_primary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_primary_interest_id);
885: p_rec.opp_secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_secondary_interest_id);
886: p_rec.opclss_interest_type_id := jtf_terr_number_list(p_terroppor_rec.opclss_interest_type_id);
887: p_rec.opclss_primary_interest_id := jtf_terr_number_list(p_terroppor_rec.opclss_primary_interest_id);
888: p_rec.opclss_secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.opclss_secondary_interest_id);
889: p_rec.attribute1 := jtf_terr_char_360list(p_terroppor_rec.attribute1);
890: p_rec.attribute2 := jtf_terr_char_360list(p_terroppor_rec.attribute2);
883: p_rec.opp_interest_type_id := jtf_terr_number_list(p_terroppor_rec.opp_interest_type_id);
884: p_rec.opp_primary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_primary_interest_id);
885: p_rec.opp_secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_secondary_interest_id);
886: p_rec.opclss_interest_type_id := jtf_terr_number_list(p_terroppor_rec.opclss_interest_type_id);
887: p_rec.opclss_primary_interest_id := jtf_terr_number_list(p_terroppor_rec.opclss_primary_interest_id);
888: p_rec.opclss_secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.opclss_secondary_interest_id);
889: p_rec.attribute1 := jtf_terr_char_360list(p_terroppor_rec.attribute1);
890: p_rec.attribute2 := jtf_terr_char_360list(p_terroppor_rec.attribute2);
891: p_rec.attribute3 := jtf_terr_char_360list(p_terroppor_rec.attribute3);
884: p_rec.opp_primary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_primary_interest_id);
885: p_rec.opp_secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.opp_secondary_interest_id);
886: p_rec.opclss_interest_type_id := jtf_terr_number_list(p_terroppor_rec.opclss_interest_type_id);
887: p_rec.opclss_primary_interest_id := jtf_terr_number_list(p_terroppor_rec.opclss_primary_interest_id);
888: p_rec.opclss_secondary_interest_id := jtf_terr_number_list(p_terroppor_rec.opclss_secondary_interest_id);
889: p_rec.attribute1 := jtf_terr_char_360list(p_terroppor_rec.attribute1);
890: p_rec.attribute2 := jtf_terr_char_360list(p_terroppor_rec.attribute2);
891: p_rec.attribute3 := jtf_terr_char_360list(p_terroppor_rec.attribute3);
892: p_rec.attribute4 := jtf_terr_char_360list(p_terroppor_rec.attribute4);
984: BEGIN
985:
986:
987: /* initialise BULK tables with SINGLE record values */
988: p_Rec.sales_lead_id := jtf_terr_number_list(p_terrlead_rec.sales_lead_id);
989: p_Rec.sales_lead_line_id := jtf_terr_number_list(p_terrlead_rec.sales_lead_line_id);
990: p_rec.city := jtf_terr_char_360list(p_terrlead_rec.city);
991: p_Rec.postal_code := jtf_terr_char_360list(p_terrlead_rec.postal_code);
992: p_rec.state := jtf_terr_char_360list(p_terrlead_rec.state);
985:
986:
987: /* initialise BULK tables with SINGLE record values */
988: p_Rec.sales_lead_id := jtf_terr_number_list(p_terrlead_rec.sales_lead_id);
989: p_Rec.sales_lead_line_id := jtf_terr_number_list(p_terrlead_rec.sales_lead_line_id);
990: p_rec.city := jtf_terr_char_360list(p_terrlead_rec.city);
991: p_Rec.postal_code := jtf_terr_char_360list(p_terrlead_rec.postal_code);
992: p_rec.state := jtf_terr_char_360list(p_terrlead_rec.state);
993: p_rec.province := jtf_terr_char_360list(p_terrlead_rec.province);
992: p_rec.state := jtf_terr_char_360list(p_terrlead_rec.state);
993: p_rec.province := jtf_terr_char_360list(p_terrlead_rec.province);
994: p_rec.county := jtf_terr_char_360list(p_terrlead_rec.county);
995: p_rec.country := jtf_terr_char_360list(p_terrlead_rec.country);
996: p_rec.interest_type_id := jtf_terr_number_list(p_terrlead_rec.interest_type_id);
997: p_rec.primary_interest_id := jtf_terr_number_list(p_terrlead_rec.primary_interest_id);
998: p_rec.secondary_interest_id := jtf_terr_number_list(p_terrlead_rec.secondary_interest_id);
999: p_Rec.party_id := jtf_terr_number_list(p_terrlead_rec.party_id);
1000: p_Rec.party_site_id := jtf_terr_number_list(p_terrlead_rec.party_site_id);
993: p_rec.province := jtf_terr_char_360list(p_terrlead_rec.province);
994: p_rec.county := jtf_terr_char_360list(p_terrlead_rec.county);
995: p_rec.country := jtf_terr_char_360list(p_terrlead_rec.country);
996: p_rec.interest_type_id := jtf_terr_number_list(p_terrlead_rec.interest_type_id);
997: p_rec.primary_interest_id := jtf_terr_number_list(p_terrlead_rec.primary_interest_id);
998: p_rec.secondary_interest_id := jtf_terr_number_list(p_terrlead_rec.secondary_interest_id);
999: p_Rec.party_id := jtf_terr_number_list(p_terrlead_rec.party_id);
1000: p_Rec.party_site_id := jtf_terr_number_list(p_terrlead_rec.party_site_id);
1001: p_rec.area_code := jtf_terr_char_360list(p_terrlead_rec.area_code);
994: p_rec.county := jtf_terr_char_360list(p_terrlead_rec.county);
995: p_rec.country := jtf_terr_char_360list(p_terrlead_rec.country);
996: p_rec.interest_type_id := jtf_terr_number_list(p_terrlead_rec.interest_type_id);
997: p_rec.primary_interest_id := jtf_terr_number_list(p_terrlead_rec.primary_interest_id);
998: p_rec.secondary_interest_id := jtf_terr_number_list(p_terrlead_rec.secondary_interest_id);
999: p_Rec.party_id := jtf_terr_number_list(p_terrlead_rec.party_id);
1000: p_Rec.party_site_id := jtf_terr_number_list(p_terrlead_rec.party_site_id);
1001: p_rec.area_code := jtf_terr_char_360list(p_terrlead_rec.area_code);
1002: p_rec.comp_name_range := jtf_terr_char_360list(p_terrlead_rec.comp_name_range);
995: p_rec.country := jtf_terr_char_360list(p_terrlead_rec.country);
996: p_rec.interest_type_id := jtf_terr_number_list(p_terrlead_rec.interest_type_id);
997: p_rec.primary_interest_id := jtf_terr_number_list(p_terrlead_rec.primary_interest_id);
998: p_rec.secondary_interest_id := jtf_terr_number_list(p_terrlead_rec.secondary_interest_id);
999: p_Rec.party_id := jtf_terr_number_list(p_terrlead_rec.party_id);
1000: p_Rec.party_site_id := jtf_terr_number_list(p_terrlead_rec.party_site_id);
1001: p_rec.area_code := jtf_terr_char_360list(p_terrlead_rec.area_code);
1002: p_rec.comp_name_range := jtf_terr_char_360list(p_terrlead_rec.comp_name_range);
1003: p_rec.partner_id := jtf_terr_number_list(p_terrlead_rec.partner_id);
996: p_rec.interest_type_id := jtf_terr_number_list(p_terrlead_rec.interest_type_id);
997: p_rec.primary_interest_id := jtf_terr_number_list(p_terrlead_rec.primary_interest_id);
998: p_rec.secondary_interest_id := jtf_terr_number_list(p_terrlead_rec.secondary_interest_id);
999: p_Rec.party_id := jtf_terr_number_list(p_terrlead_rec.party_id);
1000: p_Rec.party_site_id := jtf_terr_number_list(p_terrlead_rec.party_site_id);
1001: p_rec.area_code := jtf_terr_char_360list(p_terrlead_rec.area_code);
1002: p_rec.comp_name_range := jtf_terr_char_360list(p_terrlead_rec.comp_name_range);
1003: p_rec.partner_id := jtf_terr_number_list(p_terrlead_rec.partner_id);
1004: p_rec.num_of_employees := jtf_terr_number_list(p_terrlead_rec.num_of_employees);
999: p_Rec.party_id := jtf_terr_number_list(p_terrlead_rec.party_id);
1000: p_Rec.party_site_id := jtf_terr_number_list(p_terrlead_rec.party_site_id);
1001: p_rec.area_code := jtf_terr_char_360list(p_terrlead_rec.area_code);
1002: p_rec.comp_name_range := jtf_terr_char_360list(p_terrlead_rec.comp_name_range);
1003: p_rec.partner_id := jtf_terr_number_list(p_terrlead_rec.partner_id);
1004: p_rec.num_of_employees := jtf_terr_number_list(p_terrlead_rec.num_of_employees);
1005: p_rec.category_code := jtf_terr_char_360list(p_terrlead_rec.category_code);
1006: p_rec.party_relationship_id := jtf_terr_number_list(p_terrlead_rec.party_relationship_id);
1007: p_rec.sic_code := jtf_terr_char_360list(p_terrlead_rec.sic_code);
1000: p_Rec.party_site_id := jtf_terr_number_list(p_terrlead_rec.party_site_id);
1001: p_rec.area_code := jtf_terr_char_360list(p_terrlead_rec.area_code);
1002: p_rec.comp_name_range := jtf_terr_char_360list(p_terrlead_rec.comp_name_range);
1003: p_rec.partner_id := jtf_terr_number_list(p_terrlead_rec.partner_id);
1004: p_rec.num_of_employees := jtf_terr_number_list(p_terrlead_rec.num_of_employees);
1005: p_rec.category_code := jtf_terr_char_360list(p_terrlead_rec.category_code);
1006: p_rec.party_relationship_id := jtf_terr_number_list(p_terrlead_rec.party_relationship_id);
1007: p_rec.sic_code := jtf_terr_char_360list(p_terrlead_rec.sic_code);
1008: p_rec.budget_amount := jtf_terr_number_list(p_terrlead_rec.budget_amount);
1002: p_rec.comp_name_range := jtf_terr_char_360list(p_terrlead_rec.comp_name_range);
1003: p_rec.partner_id := jtf_terr_number_list(p_terrlead_rec.partner_id);
1004: p_rec.num_of_employees := jtf_terr_number_list(p_terrlead_rec.num_of_employees);
1005: p_rec.category_code := jtf_terr_char_360list(p_terrlead_rec.category_code);
1006: p_rec.party_relationship_id := jtf_terr_number_list(p_terrlead_rec.party_relationship_id);
1007: p_rec.sic_code := jtf_terr_char_360list(p_terrlead_rec.sic_code);
1008: p_rec.budget_amount := jtf_terr_number_list(p_terrlead_rec.budget_amount);
1009: p_rec.currency_code := jtf_terr_char_360list(p_terrlead_rec.currency_code);
1010: p_rec.pricing_date := jtf_terr_date_list(p_terrlead_rec.pricing_date);
1004: p_rec.num_of_employees := jtf_terr_number_list(p_terrlead_rec.num_of_employees);
1005: p_rec.category_code := jtf_terr_char_360list(p_terrlead_rec.category_code);
1006: p_rec.party_relationship_id := jtf_terr_number_list(p_terrlead_rec.party_relationship_id);
1007: p_rec.sic_code := jtf_terr_char_360list(p_terrlead_rec.sic_code);
1008: p_rec.budget_amount := jtf_terr_number_list(p_terrlead_rec.budget_amount);
1009: p_rec.currency_code := jtf_terr_char_360list(p_terrlead_rec.currency_code);
1010: p_rec.pricing_date := jtf_terr_date_list(p_terrlead_rec.pricing_date);
1011: p_rec.source_promotion_id := jtf_terr_number_list(p_terrlead_rec.source_promotion_id);
1012: p_rec.inventory_item_id := jtf_terr_number_list(p_terrlead_rec.inventory_item_id);
1007: p_rec.sic_code := jtf_terr_char_360list(p_terrlead_rec.sic_code);
1008: p_rec.budget_amount := jtf_terr_number_list(p_terrlead_rec.budget_amount);
1009: p_rec.currency_code := jtf_terr_char_360list(p_terrlead_rec.currency_code);
1010: p_rec.pricing_date := jtf_terr_date_list(p_terrlead_rec.pricing_date);
1011: p_rec.source_promotion_id := jtf_terr_number_list(p_terrlead_rec.source_promotion_id);
1012: p_rec.inventory_item_id := jtf_terr_number_list(p_terrlead_rec.inventory_item_id);
1013: p_rec.lead_interest_type_id := jtf_terr_number_list(p_terrlead_rec.lead_interest_type_id);
1014: p_rec.lead_primary_interest_id := jtf_terr_number_list(p_terrlead_rec.lead_primary_interest_id);
1015: p_rec.lead_secondary_interest_id := jtf_terr_number_list(p_terrlead_rec.lead_secondary_interest_id);
1008: p_rec.budget_amount := jtf_terr_number_list(p_terrlead_rec.budget_amount);
1009: p_rec.currency_code := jtf_terr_char_360list(p_terrlead_rec.currency_code);
1010: p_rec.pricing_date := jtf_terr_date_list(p_terrlead_rec.pricing_date);
1011: p_rec.source_promotion_id := jtf_terr_number_list(p_terrlead_rec.source_promotion_id);
1012: p_rec.inventory_item_id := jtf_terr_number_list(p_terrlead_rec.inventory_item_id);
1013: p_rec.lead_interest_type_id := jtf_terr_number_list(p_terrlead_rec.lead_interest_type_id);
1014: p_rec.lead_primary_interest_id := jtf_terr_number_list(p_terrlead_rec.lead_primary_interest_id);
1015: p_rec.lead_secondary_interest_id := jtf_terr_number_list(p_terrlead_rec.lead_secondary_interest_id);
1016: p_rec.purchase_amount := jtf_terr_number_list(p_terrlead_rec.purchase_amount);
1009: p_rec.currency_code := jtf_terr_char_360list(p_terrlead_rec.currency_code);
1010: p_rec.pricing_date := jtf_terr_date_list(p_terrlead_rec.pricing_date);
1011: p_rec.source_promotion_id := jtf_terr_number_list(p_terrlead_rec.source_promotion_id);
1012: p_rec.inventory_item_id := jtf_terr_number_list(p_terrlead_rec.inventory_item_id);
1013: p_rec.lead_interest_type_id := jtf_terr_number_list(p_terrlead_rec.lead_interest_type_id);
1014: p_rec.lead_primary_interest_id := jtf_terr_number_list(p_terrlead_rec.lead_primary_interest_id);
1015: p_rec.lead_secondary_interest_id := jtf_terr_number_list(p_terrlead_rec.lead_secondary_interest_id);
1016: p_rec.purchase_amount := jtf_terr_number_list(p_terrlead_rec.purchase_amount);
1017: p_rec.attribute1 := jtf_terr_char_360list(p_terrlead_rec.attribute1);
1010: p_rec.pricing_date := jtf_terr_date_list(p_terrlead_rec.pricing_date);
1011: p_rec.source_promotion_id := jtf_terr_number_list(p_terrlead_rec.source_promotion_id);
1012: p_rec.inventory_item_id := jtf_terr_number_list(p_terrlead_rec.inventory_item_id);
1013: p_rec.lead_interest_type_id := jtf_terr_number_list(p_terrlead_rec.lead_interest_type_id);
1014: p_rec.lead_primary_interest_id := jtf_terr_number_list(p_terrlead_rec.lead_primary_interest_id);
1015: p_rec.lead_secondary_interest_id := jtf_terr_number_list(p_terrlead_rec.lead_secondary_interest_id);
1016: p_rec.purchase_amount := jtf_terr_number_list(p_terrlead_rec.purchase_amount);
1017: p_rec.attribute1 := jtf_terr_char_360list(p_terrlead_rec.attribute1);
1018: p_rec.attribute2 := jtf_terr_char_360list(p_terrlead_rec.attribute2);
1011: p_rec.source_promotion_id := jtf_terr_number_list(p_terrlead_rec.source_promotion_id);
1012: p_rec.inventory_item_id := jtf_terr_number_list(p_terrlead_rec.inventory_item_id);
1013: p_rec.lead_interest_type_id := jtf_terr_number_list(p_terrlead_rec.lead_interest_type_id);
1014: p_rec.lead_primary_interest_id := jtf_terr_number_list(p_terrlead_rec.lead_primary_interest_id);
1015: p_rec.lead_secondary_interest_id := jtf_terr_number_list(p_terrlead_rec.lead_secondary_interest_id);
1016: p_rec.purchase_amount := jtf_terr_number_list(p_terrlead_rec.purchase_amount);
1017: p_rec.attribute1 := jtf_terr_char_360list(p_terrlead_rec.attribute1);
1018: p_rec.attribute2 := jtf_terr_char_360list(p_terrlead_rec.attribute2);
1019: p_rec.attribute3 := jtf_terr_char_360list(p_terrlead_rec.attribute3);
1012: p_rec.inventory_item_id := jtf_terr_number_list(p_terrlead_rec.inventory_item_id);
1013: p_rec.lead_interest_type_id := jtf_terr_number_list(p_terrlead_rec.lead_interest_type_id);
1014: p_rec.lead_primary_interest_id := jtf_terr_number_list(p_terrlead_rec.lead_primary_interest_id);
1015: p_rec.lead_secondary_interest_id := jtf_terr_number_list(p_terrlead_rec.lead_secondary_interest_id);
1016: p_rec.purchase_amount := jtf_terr_number_list(p_terrlead_rec.purchase_amount);
1017: p_rec.attribute1 := jtf_terr_char_360list(p_terrlead_rec.attribute1);
1018: p_rec.attribute2 := jtf_terr_char_360list(p_terrlead_rec.attribute2);
1019: p_rec.attribute3 := jtf_terr_char_360list(p_terrlead_rec.attribute3);
1020: p_rec.attribute4 := jtf_terr_char_360list(p_terrlead_rec.attribute4);