DBA Data[Home] [Help]

APPS.ECE_TRADING_PARTNERS_PUB dependencies on ECE_RULES_PKG

Line 777: ece_rules_pkg.g_party_name IS NOT NULL OR

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;

Line 778: ece_rules_pkg.g_party_number IS NOT NULL)) THEN

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:

Line 1578: cp_customer_name_in => ece_rules_pkg.g_party_name,

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;

Line 1579: cp_customer_number_in => ece_rules_pkg.g_party_number) LOOP

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;

Line 1616: cp_customer_name_in => ece_rules_pkg.g_party_name,

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;

Line 1617: cp_customer_number_in => ece_rules_pkg.g_party_number) LOOP

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;

Line 1736: x_translator_code_out := nvl(ece_rules_pkg.g_party_number,p_translator_code_in);

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;

Line 1737: x_tp_location_name_out := nvl(ece_rules_pkg.g_party_name,p_tp_location_name_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;

Line 1810: x_translator_code_out := nvl(ece_rules_pkg.g_party_number,p_translator_code_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;

Line 1811: x_tp_location_name_out := nvl(ece_rules_pkg.g_party_name,p_tp_location_name_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;

Line 1884: x_translator_code_out := nvl(ece_rules_pkg.g_party_number,p_translator_code_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;

Line 1885: x_tp_location_name_out := nvl(ece_rules_pkg.g_party_name,p_tp_location_name_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;