457: Contract Support Service Item
458: lp_Rec.squal_num18 := jtf_terr_number_list(p_TerrServReq_Rec.squal_num18); -- Inventory Item Id
459: lp_Rec.squal_num19 := jtf_terr_number_list(p_TerrServReq_Rec.squal_num19); -- Organization Id
460:
461: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrServReq_Rec.country);
462: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrServReq_Rec.city);
463: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrServReq_Rec.postal_code);
464: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrServReq_Rec.state);
465: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrServReq_Rec.area_code);
458: lp_Rec.squal_num18 := jtf_terr_number_list(p_TerrServReq_Rec.squal_num18); -- Inventory Item Id
459: lp_Rec.squal_num19 := jtf_terr_number_list(p_TerrServReq_Rec.squal_num19); -- Organization Id
460:
461: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrServReq_Rec.country);
462: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrServReq_Rec.city);
463: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrServReq_Rec.postal_code);
464: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrServReq_Rec.state);
465: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrServReq_Rec.area_code);
466: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrServReq_Rec.county);
459: lp_Rec.squal_num19 := jtf_terr_number_list(p_TerrServReq_Rec.squal_num19); -- Organization Id
460:
461: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrServReq_Rec.country);
462: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrServReq_Rec.city);
463: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrServReq_Rec.postal_code);
464: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrServReq_Rec.state);
465: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrServReq_Rec.area_code);
466: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrServReq_Rec.county);
467: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrServReq_Rec.comp_name_range);
460:
461: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrServReq_Rec.country);
462: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrServReq_Rec.city);
463: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrServReq_Rec.postal_code);
464: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrServReq_Rec.state);
465: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrServReq_Rec.area_code);
466: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrServReq_Rec.county);
467: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrServReq_Rec.comp_name_range);
468: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrServReq_Rec.province);
461: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrServReq_Rec.country);
462: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrServReq_Rec.city);
463: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrServReq_Rec.postal_code);
464: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrServReq_Rec.state);
465: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrServReq_Rec.area_code);
466: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrServReq_Rec.county);
467: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrServReq_Rec.comp_name_range);
468: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrServReq_Rec.province);
469: lp_Rec.squal_char09 := jtf_terr_char_360list(p_TerrServReq_Rec.problem_code);
462: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrServReq_Rec.city);
463: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrServReq_Rec.postal_code);
464: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrServReq_Rec.state);
465: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrServReq_Rec.area_code);
466: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrServReq_Rec.county);
467: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrServReq_Rec.comp_name_range);
468: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrServReq_Rec.province);
469: lp_Rec.squal_char09 := jtf_terr_char_360list(p_TerrServReq_Rec.problem_code);
470: lp_Rec.squal_char10 := jtf_terr_char_360list(p_TerrServReq_Rec.sr_creation_channel);
463: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrServReq_Rec.postal_code);
464: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrServReq_Rec.state);
465: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrServReq_Rec.area_code);
466: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrServReq_Rec.county);
467: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrServReq_Rec.comp_name_range);
468: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrServReq_Rec.province);
469: lp_Rec.squal_char09 := jtf_terr_char_360list(p_TerrServReq_Rec.problem_code);
470: lp_Rec.squal_char10 := jtf_terr_char_360list(p_TerrServReq_Rec.sr_creation_channel);
471:
464: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrServReq_Rec.state);
465: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrServReq_Rec.area_code);
466: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrServReq_Rec.county);
467: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrServReq_Rec.comp_name_range);
468: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrServReq_Rec.province);
469: lp_Rec.squal_char09 := jtf_terr_char_360list(p_TerrServReq_Rec.problem_code);
470: lp_Rec.squal_char10 := jtf_terr_char_360list(p_TerrServReq_Rec.sr_creation_channel);
471:
472: --arpatel 08/02
465: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrServReq_Rec.area_code);
466: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrServReq_Rec.county);
467: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrServReq_Rec.comp_name_range);
468: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrServReq_Rec.province);
469: lp_Rec.squal_char09 := jtf_terr_char_360list(p_TerrServReq_Rec.problem_code);
470: lp_Rec.squal_char10 := jtf_terr_char_360list(p_TerrServReq_Rec.sr_creation_channel);
471:
472: --arpatel 08/02
473: VIP Customers
466: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrServReq_Rec.county);
467: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrServReq_Rec.comp_name_range);
468: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrServReq_Rec.province);
469: lp_Rec.squal_char09 := jtf_terr_char_360list(p_TerrServReq_Rec.problem_code);
470: lp_Rec.squal_char10 := jtf_terr_char_360list(p_TerrServReq_Rec.sr_creation_channel);
471:
472: --arpatel 08/02
473: VIP Customers
474: lp_Rec.squal_char11 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char11);
470: lp_Rec.squal_char10 := jtf_terr_char_360list(p_TerrServReq_Rec.sr_creation_channel);
471:
472: --arpatel 08/02
473: VIP Customers
474: lp_Rec.squal_char11 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char11);
475:
476: Qualifier: SR Problem Code
477: lp_Rec.squal_char12 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char12);
478:
473: VIP Customers
474: lp_Rec.squal_char11 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char11);
475:
476: Qualifier: SR Problem Code
477: lp_Rec.squal_char12 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char12);
478:
479: Qualifier: SR Customer Contact Preference
480: lp_Rec.squal_char13 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char13);
481:
476: Qualifier: SR Problem Code
477: lp_Rec.squal_char12 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char12);
478:
479: Qualifier: SR Customer Contact Preference
480: lp_Rec.squal_char13 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char13);
481:
482: Qualifier: SR Service Contract Coverage
483: lp_Rec.squal_char21 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char21);
484:
479: Qualifier: SR Customer Contact Preference
480: lp_Rec.squal_char13 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char13);
481:
482: Qualifier: SR Service Contract Coverage
483: lp_Rec.squal_char21 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char21);
484:
485: SR Language -JDOCHERT 12/17/01 - bug#2152253
486: lp_Rec.squal_char20 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char20);
487: */
482: Qualifier: SR Service Contract Coverage
483: lp_Rec.squal_char21 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char21);
484:
485: SR Language -JDOCHERT 12/17/01 - bug#2152253
486: lp_Rec.squal_char20 := jtf_terr_char_360list(p_TerrServReq_Rec.squal_char20);
487: */
488:
489: JTY_ASSIGN_REALTIME_PUB.process_match (
490: p_source_id => -1002
1026: Contract Support Service Item
1027: lp_Rec.squal_num18 := jtf_terr_number_list(p_TerrSrvTask_Rec.squal_num18); -- Inventory Item Id
1028: lp_Rec.squal_num19 := jtf_terr_number_list(p_TerrSrvTask_Rec.squal_num19); -- Organization Id
1029:
1030: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrSrvTask_Rec.country);
1031: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrSrvTask_Rec.city);
1032: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrSrvTask_Rec.postal_code);
1033: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrSrvTask_Rec.state);
1034: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrSrvTask_Rec.area_code);
1027: lp_Rec.squal_num18 := jtf_terr_number_list(p_TerrSrvTask_Rec.squal_num18); -- Inventory Item Id
1028: lp_Rec.squal_num19 := jtf_terr_number_list(p_TerrSrvTask_Rec.squal_num19); -- Organization Id
1029:
1030: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrSrvTask_Rec.country);
1031: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrSrvTask_Rec.city);
1032: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrSrvTask_Rec.postal_code);
1033: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrSrvTask_Rec.state);
1034: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrSrvTask_Rec.area_code);
1035: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrSrvTask_Rec.county);
1028: lp_Rec.squal_num19 := jtf_terr_number_list(p_TerrSrvTask_Rec.squal_num19); -- Organization Id
1029:
1030: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrSrvTask_Rec.country);
1031: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrSrvTask_Rec.city);
1032: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrSrvTask_Rec.postal_code);
1033: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrSrvTask_Rec.state);
1034: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrSrvTask_Rec.area_code);
1035: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrSrvTask_Rec.county);
1036: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrSrvTask_Rec.comp_name_range);
1029:
1030: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrSrvTask_Rec.country);
1031: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrSrvTask_Rec.city);
1032: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrSrvTask_Rec.postal_code);
1033: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrSrvTask_Rec.state);
1034: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrSrvTask_Rec.area_code);
1035: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrSrvTask_Rec.county);
1036: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrSrvTask_Rec.comp_name_range);
1037: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrSrvTask_Rec.province);
1030: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrSrvTask_Rec.country);
1031: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrSrvTask_Rec.city);
1032: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrSrvTask_Rec.postal_code);
1033: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrSrvTask_Rec.state);
1034: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrSrvTask_Rec.area_code);
1035: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrSrvTask_Rec.county);
1036: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrSrvTask_Rec.comp_name_range);
1037: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrSrvTask_Rec.province);
1038: lp_Rec.squal_char09 := jtf_terr_char_360list(p_TerrSrvTask_Rec.problem_code);
1031: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrSrvTask_Rec.city);
1032: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrSrvTask_Rec.postal_code);
1033: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrSrvTask_Rec.state);
1034: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrSrvTask_Rec.area_code);
1035: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrSrvTask_Rec.county);
1036: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrSrvTask_Rec.comp_name_range);
1037: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrSrvTask_Rec.province);
1038: lp_Rec.squal_char09 := jtf_terr_char_360list(p_TerrSrvTask_Rec.problem_code);
1039: lp_Rec.squal_char10 := jtf_terr_char_360list(p_TerrSrvTask_Rec.sr_creation_channel);
1032: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrSrvTask_Rec.postal_code);
1033: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrSrvTask_Rec.state);
1034: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrSrvTask_Rec.area_code);
1035: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrSrvTask_Rec.county);
1036: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrSrvTask_Rec.comp_name_range);
1037: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrSrvTask_Rec.province);
1038: lp_Rec.squal_char09 := jtf_terr_char_360list(p_TerrSrvTask_Rec.problem_code);
1039: lp_Rec.squal_char10 := jtf_terr_char_360list(p_TerrSrvTask_Rec.sr_creation_channel);
1040:
1033: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrSrvTask_Rec.state);
1034: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrSrvTask_Rec.area_code);
1035: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrSrvTask_Rec.county);
1036: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrSrvTask_Rec.comp_name_range);
1037: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrSrvTask_Rec.province);
1038: lp_Rec.squal_char09 := jtf_terr_char_360list(p_TerrSrvTask_Rec.problem_code);
1039: lp_Rec.squal_char10 := jtf_terr_char_360list(p_TerrSrvTask_Rec.sr_creation_channel);
1040:
1041: --arpatel 08/02
1034: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrSrvTask_Rec.area_code);
1035: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrSrvTask_Rec.county);
1036: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrSrvTask_Rec.comp_name_range);
1037: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrSrvTask_Rec.province);
1038: lp_Rec.squal_char09 := jtf_terr_char_360list(p_TerrSrvTask_Rec.problem_code);
1039: lp_Rec.squal_char10 := jtf_terr_char_360list(p_TerrSrvTask_Rec.sr_creation_channel);
1040:
1041: --arpatel 08/02
1042: VIP Customers
1035: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrSrvTask_Rec.county);
1036: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrSrvTask_Rec.comp_name_range);
1037: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrSrvTask_Rec.province);
1038: lp_Rec.squal_char09 := jtf_terr_char_360list(p_TerrSrvTask_Rec.problem_code);
1039: lp_Rec.squal_char10 := jtf_terr_char_360list(p_TerrSrvTask_Rec.sr_creation_channel);
1040:
1041: --arpatel 08/02
1042: VIP Customers
1043: lp_Rec.squal_char11 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char11);
1039: lp_Rec.squal_char10 := jtf_terr_char_360list(p_TerrSrvTask_Rec.sr_creation_channel);
1040:
1041: --arpatel 08/02
1042: VIP Customers
1043: lp_Rec.squal_char11 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char11);
1044:
1045: Qualifier: SR Problem Code
1046: lp_Rec.squal_char12 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char12);
1047:
1042: VIP Customers
1043: lp_Rec.squal_char11 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char11);
1044:
1045: Qualifier: SR Problem Code
1046: lp_Rec.squal_char12 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char12);
1047:
1048: Qualifier: SR Customer Contact Preference
1049: lp_Rec.squal_char13 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char13);
1050:
1045: Qualifier: SR Problem Code
1046: lp_Rec.squal_char12 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char12);
1047:
1048: Qualifier: SR Customer Contact Preference
1049: lp_Rec.squal_char13 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char13);
1050:
1051: Qualifier: SR Service Contract Coverage
1052: lp_Rec.squal_char21 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char21);
1053:
1048: Qualifier: SR Customer Contact Preference
1049: lp_Rec.squal_char13 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char13);
1050:
1051: Qualifier: SR Service Contract Coverage
1052: lp_Rec.squal_char21 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char21);
1053:
1054: SR Language -JDOCHERT 12/17/01 - bug#2152253
1055: lp_Rec.squal_char20 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char20);
1056: */
1051: Qualifier: SR Service Contract Coverage
1052: lp_Rec.squal_char21 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char21);
1053:
1054: SR Language -JDOCHERT 12/17/01 - bug#2152253
1055: lp_Rec.squal_char20 := jtf_terr_char_360list(p_TerrSrvTask_Rec.squal_char20);
1056: */
1057:
1058: JTY_ASSIGN_REALTIME_PUB.process_match (
1059: p_source_id => -1002