773: p_address_line4_in IS NOT NULL OR
774: p_address_line_alt_in IS NOT NULL OR
775: p_city_in IS NOT NULL OR
776: p_zip_in IS NOT NULL OR
777: ece_rules_pkg.g_party_name IS NOT NULL OR
778: ece_rules_pkg.g_party_number IS NOT NULL)) THEN
779: xProgress := 'ADDRB-20-1060';
780: b_use_addr_comp := TRUE;
781: END IF;
774: p_address_line_alt_in IS NOT NULL OR
775: p_city_in IS NOT NULL OR
776: p_zip_in IS NOT NULL OR
777: ece_rules_pkg.g_party_name IS NOT NULL OR
778: ece_rules_pkg.g_party_number IS NOT NULL)) THEN
779: xProgress := 'ADDRB-20-1060';
780: b_use_addr_comp := TRUE;
781: END IF;
782:
1574: cp_address_line4_in => p_address_line4_in,
1575: cp_address_line_alt_in => p_address_line_alt_in,
1576: cp_city_in => p_city_in,
1577: cp_zip_in => p_zip_in,
1578: cp_customer_name_in => ece_rules_pkg.g_party_name,
1579: cp_customer_number_in => ece_rules_pkg.g_party_number) LOOP
1580: n_loop_count := n_loop_count + 1;
1581: x_org_id_out := r_addr_rec.org_id;
1582: x_address_id_out := r_addr_rec.address_id;
1575: cp_address_line_alt_in => p_address_line_alt_in,
1576: cp_city_in => p_city_in,
1577: cp_zip_in => p_zip_in,
1578: cp_customer_name_in => ece_rules_pkg.g_party_name,
1579: cp_customer_number_in => ece_rules_pkg.g_party_number) LOOP
1580: n_loop_count := n_loop_count + 1;
1581: x_org_id_out := r_addr_rec.org_id;
1582: x_address_id_out := r_addr_rec.address_id;
1583: x_tp_location_code_out := r_addr_rec.tp_location_code;
1612: cp_address_line4_in => p_address_line4_in,
1613: cp_address_line_alt_in => p_address_line_alt_in,
1614: cp_city_in => p_city_in,
1615: cp_zip_in => p_zip_in,
1616: cp_customer_name_in => ece_rules_pkg.g_party_name,
1617: cp_customer_number_in => ece_rules_pkg.g_party_number) LOOP
1618: n_loop_count := n_loop_count + 1;
1619: x_org_id_out := r_addr_rec.org_id;
1620: x_address_id_out := r_addr_rec.address_id;
1613: cp_address_line_alt_in => p_address_line_alt_in,
1614: cp_city_in => p_city_in,
1615: cp_zip_in => p_zip_in,
1616: cp_customer_name_in => ece_rules_pkg.g_party_name,
1617: cp_customer_number_in => ece_rules_pkg.g_party_number) LOOP
1618: n_loop_count := n_loop_count + 1;
1619: x_org_id_out := r_addr_rec.org_id;
1620: x_address_id_out := r_addr_rec.address_id;
1621: x_tp_location_code_out := r_addr_rec.tp_location_code;
1732: IF n_loop_count = 0 THEN
1733: x_org_id_out := p_org_id_in;
1734: x_address_id_out := p_address_id_in;
1735: x_tp_location_code_out := p_tp_location_code_in;
1736: x_translator_code_out := nvl(ece_rules_pkg.g_party_number,p_translator_code_in);
1737: x_tp_location_name_out := nvl(ece_rules_pkg.g_party_name,p_tp_location_name_in);
1738: x_address_line1_out := p_address_line1_in;
1739: x_address_line2_out := p_address_line2_in;
1740: x_address_line3_out := p_address_line3_in;
1733: x_org_id_out := p_org_id_in;
1734: x_address_id_out := p_address_id_in;
1735: x_tp_location_code_out := p_tp_location_code_in;
1736: x_translator_code_out := nvl(ece_rules_pkg.g_party_number,p_translator_code_in);
1737: x_tp_location_name_out := nvl(ece_rules_pkg.g_party_name,p_tp_location_name_in);
1738: x_address_line1_out := p_address_line1_in;
1739: x_address_line2_out := p_address_line2_in;
1740: x_address_line3_out := p_address_line3_in;
1741: x_address_line4_out := p_address_line4_in;
1806: --IF n_match_count = 0 THEN
1807: x_org_id_out := p_org_id_in;
1808: x_address_id_out := p_address_id_in;
1809: x_tp_location_code_out := p_tp_location_code_in;
1810: x_translator_code_out := nvl(ece_rules_pkg.g_party_number,p_translator_code_in);
1811: x_tp_location_name_out := nvl(ece_rules_pkg.g_party_name,p_tp_location_name_in);
1812: x_address_line1_out := p_address_line1_in;
1813: x_address_line2_out := p_address_line2_in;
1814: x_address_line3_out := p_address_line3_in;
1807: x_org_id_out := p_org_id_in;
1808: x_address_id_out := p_address_id_in;
1809: x_tp_location_code_out := p_tp_location_code_in;
1810: x_translator_code_out := nvl(ece_rules_pkg.g_party_number,p_translator_code_in);
1811: x_tp_location_name_out := nvl(ece_rules_pkg.g_party_name,p_tp_location_name_in);
1812: x_address_line1_out := p_address_line1_in;
1813: x_address_line2_out := p_address_line2_in;
1814: x_address_line3_out := p_address_line3_in;
1815: x_address_line4_out := p_address_line4_in;
1880: -- At this point, all we have are raw address components and nothing else.
1881: x_org_id_out := p_org_id_in;
1882: x_address_id_out := p_address_id_in;
1883: x_tp_location_code_out := p_tp_location_code_in;
1884: x_translator_code_out := nvl(ece_rules_pkg.g_party_number,p_translator_code_in);
1885: x_tp_location_name_out := nvl(ece_rules_pkg.g_party_name,p_tp_location_name_in);
1886: x_address_line1_out := p_address_line1_in;
1887: x_address_line2_out := p_address_line2_in;
1888: x_address_line3_out := p_address_line3_in;
1881: x_org_id_out := p_org_id_in;
1882: x_address_id_out := p_address_id_in;
1883: x_tp_location_code_out := p_tp_location_code_in;
1884: x_translator_code_out := nvl(ece_rules_pkg.g_party_number,p_translator_code_in);
1885: x_tp_location_name_out := nvl(ece_rules_pkg.g_party_name,p_tp_location_name_in);
1886: x_address_line1_out := p_address_line1_in;
1887: x_address_line2_out := p_address_line2_in;
1888: x_address_line3_out := p_address_line3_in;
1889: x_address_line4_out := p_address_line4_in;