eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VERSION_BLANKET_COMP dependencies on DUAL

Line 1482: into x_current_deliver_to_address from dual;

1478: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
1479: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
1480: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
1481: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
1482: into x_current_deliver_to_address from dual;
1483:
1484: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.deliver_to_org_id;
1485: x_header_changed_attr_tbl(ind).current_value := x_current_deliver_to_address;
1486:

Line 1513: into x_prior_deliver_to_address from dual;

1509: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
1510: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
1511: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
1512: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
1513: into x_prior_deliver_to_address from dual;
1514: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.deliver_to_org_id;
1515: x_header_changed_attr_tbl(ind).prior_value := x_prior_deliver_to_address;
1516: end if;
1517: END IF;

Line 1558: into x_prior_deliver_to_address from dual;

1554: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
1555: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
1556: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
1557: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
1558: into x_prior_deliver_to_address from dual;
1559: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.deliver_to_org_id;
1560: x_header_changed_attr_tbl(ind).prior_value := x_prior_deliver_to_address;
1561:
1562: end if;

Line 1588: into x_current_deliver_to_address from dual;

1584: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
1585: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
1586: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
1587: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
1588: into x_current_deliver_to_address from dual;
1589: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.deliver_to_org_id;
1590: x_header_changed_attr_tbl(ind).current_value := x_current_deliver_to_address;
1591: end if;
1592:

Line 1618: into x_next_deliver_to_address from dual;

1614: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
1615: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
1616: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
1617: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
1618: into x_next_deliver_to_address from dual;
1619: x_header_changed_attr_tbl(ind).next_id := p_next_rec.deliver_to_org_id;
1620: x_header_changed_attr_tbl(ind).next_value := x_next_deliver_to_address;
1621: end if;
1622: END IF; /* NEXT */

Line 1712: into x_current_invoice_to_address from dual;

1708: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
1709: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
1710: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
1711: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
1712: into x_current_invoice_to_address from dual;
1713: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.invoice_to_org_id;
1714:
1715: x_header_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
1716: end if;

Line 1743: into x_prior_invoice_to_address from dual;

1739: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
1740: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
1741: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
1742: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
1743: into x_prior_invoice_to_address from dual;
1744: x_header_changed_attr_tbl(ind).prior_value := x_prior_invoice_to_address;
1745: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.invoice_to_org_id;
1746: end if;
1747: END IF;

Line 1789: into x_prior_invoice_to_address from dual;

1785: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
1786: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
1787: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
1788: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
1789: into x_prior_invoice_to_address from dual;
1790: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.invoice_to_org_id;
1791: x_header_changed_attr_tbl(ind).prior_value := x_prior_invoice_to_address;
1792: end if;
1793:

Line 1819: into x_current_invoice_to_address from dual;

1815: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
1816: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
1817: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
1818: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
1819: into x_current_invoice_to_address from dual;
1820: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.invoice_to_org_id;
1821: x_header_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
1822: end if;
1823:

Line 1849: into x_next_invoice_to_address from dual;

1845: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
1846: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
1847: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
1848: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
1849: into x_next_invoice_to_address from dual;
1850: x_header_changed_attr_tbl(ind).next_id := p_next_rec.invoice_to_org_id;
1851: x_header_changed_attr_tbl(ind).next_value := x_next_invoice_to_address;
1852: end if;
1853: END IF;

Line 2145: into x_current_ship_from_address from dual;

2141: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
2142: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
2143: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
2144: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
2145: into x_current_ship_from_address from dual;
2146: */
2147: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.ship_from_org_id;
2148: x_header_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
2149:

Line 2168: into x_prior_ship_from_address from dual;

2164: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
2165: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
2166: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
2167: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
2168: into x_prior_ship_from_address from dual;
2169: */
2170: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_from_org_id;
2171: x_header_changed_attr_tbl(ind).prior_value := x_prior_ship_from_org;
2172: end if;

Line 2207: into x_prior_ship_from_address from dual;

2203: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
2204: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
2205: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
2206: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
2207: into x_prior_ship_from_address from dual;
2208: */
2209: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_from_org_id;
2210: x_header_changed_attr_tbl(ind).prior_value := x_prior_ship_from_org;
2211: end if;

Line 2229: into x_current_ship_from_address from dual;

2225: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
2226: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
2227: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
2228: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
2229: into x_current_ship_from_address from dual;
2230: */
2231: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.ship_from_org_id;
2232: x_header_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
2233: end if;

Line 2252: into x_next_ship_from_address from dual;

2248: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
2249: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
2250: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
2251: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
2252: into x_next_ship_from_address from dual;
2253: */
2254: x_header_changed_attr_tbl(ind).next_id := p_next_rec.ship_from_org_id;
2255: x_header_changed_attr_tbl(ind).next_value := x_next_ship_from_org;
2256: end if;

Line 2301: into x_current_ship_to_address from dual;

2297: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
2298: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
2299: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
2300: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
2301: into x_current_ship_to_address from dual;
2302:
2303: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.ship_to_org_id;
2304: x_header_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
2305: end if;

Line 2332: into x_prior_ship_to_address from dual;

2328: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
2329: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
2330: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
2331: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
2332: into x_prior_ship_to_address from dual;
2333: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_to_org_id;
2334: x_header_changed_attr_tbl(ind).prior_value := x_prior_ship_to_address;
2335: end if;
2336: END IF;

Line 2378: into x_prior_ship_to_address from dual;

2374: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
2375: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
2376: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
2377: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
2378: into x_prior_ship_to_address from dual;
2379: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_to_org_id;
2380: x_header_changed_attr_tbl(ind).prior_value := x_prior_ship_to_address;
2381: end if;
2382:

Line 2408: into x_current_ship_to_address from dual;

2404: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
2405: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
2406: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
2407: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
2408: into x_current_ship_to_address from dual;
2409: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.ship_to_org_id;
2410: x_header_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
2411: end if;
2412:

Line 2438: into x_next_ship_to_address from dual;

2434: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
2435: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
2436: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
2437: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
2438: into x_next_ship_to_address from dual;
2439: x_header_changed_attr_tbl(ind).next_id := p_next_rec.ship_to_org_id;
2440: x_header_changed_attr_tbl(ind).next_value := x_next_ship_to_address;
2441: end if;
2442: END IF; /* NEXT */

Line 2886: into x_current_sold_to_location from dual;

2882: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
2883: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
2884: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
2885: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
2886: into x_current_sold_to_location from dual;
2887: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.sold_to_site_use_id;
2888:
2889: x_header_changed_attr_tbl(ind).current_value := x_current_sold_to_location;
2890:

Line 2916: into x_prior_sold_to_location from dual;

2912: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
2913: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
2914: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
2915: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
2916: into x_prior_sold_to_location from dual;
2917: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.sold_to_site_use_id;
2918: x_header_changed_attr_tbl(ind).prior_value := x_prior_sold_to_location;
2919: end if;
2920: END IF;

Line 2961: into x_prior_sold_to_location from dual;

2957: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
2958: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
2959: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
2960: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
2961: into x_prior_sold_to_location from dual;
2962: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.sold_to_site_use_id;
2963: x_header_changed_attr_tbl(ind).prior_value := x_prior_sold_to_location;
2964: end if;
2965:

Line 2990: into x_current_sold_to_location from dual;

2986: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
2987: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
2988: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
2989: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
2990: into x_current_sold_to_location from dual;
2991: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.sold_to_site_use_id;
2992: x_header_changed_attr_tbl(ind).current_value := x_current_sold_to_location;
2993: end if;
2994:

Line 3019: into x_next_sold_to_location from dual;

3015: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
3016: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
3017: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
3018: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
3019: into x_next_sold_to_location from dual;
3020: x_header_changed_attr_tbl(ind).next_id := p_next_rec.sold_to_site_use_id;
3021: x_header_changed_attr_tbl(ind).next_value := x_next_sold_to_location;
3022: end if;
3023: END IF; /* NEXT */

Line 5537: into x_current_deliver_to_address from dual;

5533: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
5534: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
5535: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
5536: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
5537: into x_current_deliver_to_address from dual;
5538:
5539: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.deliver_to_org_id;
5540: x_line_changed_attr_tbl(ind).current_value := x_current_deliver_to_address;
5541:

Line 5568: into x_prior_deliver_to_address from dual;

5564: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
5565: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
5566: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
5567: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
5568: into x_prior_deliver_to_address from dual;
5569: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.deliver_to_org_id;
5570: x_line_changed_attr_tbl(ind).prior_value := x_prior_deliver_to_address;
5571: end if;
5572: END IF;

Line 5615: into x_prior_deliver_to_address from dual;

5611: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
5612: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
5613: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
5614: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
5615: into x_prior_deliver_to_address from dual;
5616: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.deliver_to_org_id;
5617: x_line_changed_attr_tbl(ind).prior_value := x_prior_deliver_to_address;
5618:
5619: end if;

Line 5645: into x_current_deliver_to_address from dual;

5641: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
5642: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
5643: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
5644: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
5645: into x_current_deliver_to_address from dual;
5646: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.deliver_to_org_id;
5647: x_line_changed_attr_tbl(ind).current_value := x_current_deliver_to_address;
5648: end if;
5649:

Line 5675: into x_next_deliver_to_address from dual;

5671: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
5672: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
5673: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
5674: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
5675: into x_next_deliver_to_address from dual;
5676: x_line_changed_attr_tbl(ind).next_id := p_next_rec.deliver_to_org_id;
5677: x_line_changed_attr_tbl(ind).next_value := x_next_deliver_to_address;
5678: end if;
5679: END IF;

Line 5854: into x_current_invoice_to_address from dual;

5850: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
5851: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
5852: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
5853: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
5854: into x_current_invoice_to_address from dual;
5855: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.invoice_to_org_id;
5856:
5857: x_line_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
5858: end if;

Line 5885: into x_prior_invoice_to_address from dual;

5881: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
5882: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
5883: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
5884: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
5885: into x_prior_invoice_to_address from dual;
5886: x_line_changed_attr_tbl(ind).prior_value := x_prior_invoice_to_address;
5887: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.invoice_to_org_id;
5888: end if;
5889: END IF;

Line 5932: into x_prior_invoice_to_address from dual;

5928: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
5929: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
5930: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
5931: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
5932: into x_prior_invoice_to_address from dual;
5933: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.invoice_to_org_id;
5934: x_line_changed_attr_tbl(ind).prior_value := x_prior_invoice_to_address;
5935: end if;
5936:

Line 5962: into x_current_invoice_to_address from dual;

5958: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
5959: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
5960: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
5961: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
5962: into x_current_invoice_to_address from dual;
5963: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.invoice_to_org_id;
5964: x_line_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
5965: end if;
5966:

Line 5992: into x_next_invoice_to_address from dual;

5988: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
5989: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
5990: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
5991: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
5992: into x_next_invoice_to_address from dual;
5993: x_line_changed_attr_tbl(ind).next_id := p_next_rec.invoice_to_org_id;
5994: x_line_changed_attr_tbl(ind).next_value := x_next_invoice_to_address;
5995: end if;
5996: END IF;

Line 6298: into x_ship_from_address from dual;

6294: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
6295: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
6296: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
6297: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
6298: into x_ship_from_address from dual;
6299: */
6300: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.ship_from_org_id;
6301: x_line_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
6302:

Line 6321: into x_ship_from_address from dual;

6317: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
6318: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
6319: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
6320: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
6321: into x_ship_from_address from dual;
6322: */
6323: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_from_org_id;
6324: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_from_org;
6325: end if;

Line 6361: into x_ship_from_address from dual;

6357: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
6358: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
6359: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
6360: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
6361: into x_ship_from_address from dual;
6362: */
6363: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_from_org_id;
6364: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_from_org;
6365:

Line 6384: into x_ship_from_address from dual;

6380: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
6381: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
6382: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
6383: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
6384: into x_ship_from_address from dual;
6385: */
6386: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.ship_from_org_id;
6387: x_line_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
6388: end if;

Line 6407: into x_ship_from_address from dual;

6403: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
6404: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
6405: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
6406: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
6407: into x_ship_from_address from dual;
6408: */
6409: x_line_changed_attr_tbl(ind).next_id := p_next_rec.ship_from_org_id;
6410: x_line_changed_attr_tbl(ind).next_value := x_next_ship_from_org;
6411: end if;

Line 6457: into x_current_ship_to_address from dual;

6453: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
6454: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
6455: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
6456: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
6457: into x_current_ship_to_address from dual;
6458:
6459: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.ship_to_org_id;
6460: x_line_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
6461: end if;

Line 6488: into x_prior_ship_to_address from dual;

6484: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
6485: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
6486: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
6487: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
6488: into x_prior_ship_to_address from dual;
6489: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_to_org_id;
6490: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_to_address;
6491: end if;
6492: END IF;

Line 6535: into x_prior_ship_to_address from dual;

6531: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
6532: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
6533: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
6534: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
6535: into x_prior_ship_to_address from dual;
6536: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_to_org_id;
6537: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_to_address;
6538: end if;
6539:

Line 6565: into x_current_ship_to_address from dual;

6561: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
6562: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
6563: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
6564: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
6565: into x_current_ship_to_address from dual;
6566: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.ship_to_org_id;
6567: x_line_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
6568: end if;
6569:

Line 6595: into x_next_ship_to_address from dual;

6591: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
6592: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
6593: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
6594: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
6595: into x_next_ship_to_address from dual;
6596: x_line_changed_attr_tbl(ind).next_id := p_next_rec.ship_to_org_id;
6597: x_line_changed_attr_tbl(ind).next_value := x_next_ship_to_address;
6598: end if;
6599: END IF;