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.

[Home] [Help]

APPS.OE_VERSION_COMP dependencies on DUAL

Line 2199: into x_prior_deliver_to_address from dual;

2195: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
2196: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
2197: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
2198: DECODE(x_deliver_to_country, NULL,x_deliver_to_country)
2199: into x_prior_deliver_to_address from dual;
2200:
2201: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.deliver_to_org_id;
2202: x_header_changed_attr_tbl(ind).current_value := x_prior_deliver_to_address;
2203: end if;

Line 2230: into x_current_deliver_to_address from dual;

2226: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
2227: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
2228: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
2229: DECODE(x_deliver_to_country, NULL,x_deliver_to_country)
2230: into x_current_deliver_to_address from dual;
2231: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.deliver_to_org_id;
2232: x_header_changed_attr_tbl(ind).prior_value := x_current_deliver_to_address;
2233: end if;
2234: END IF;

Line 2276: into x_prior_deliver_to_address from dual;

2272: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
2273: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
2274: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
2275: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
2276: into x_prior_deliver_to_address from dual;
2277: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.deliver_to_org_id;
2278: x_header_changed_attr_tbl(ind).prior_value := x_prior_deliver_to_address;
2279:
2280: end if;

Line 2306: into x_current_deliver_to_address from dual;

2302: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
2303: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
2304: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
2305: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
2306: into x_current_deliver_to_address from dual;
2307: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.deliver_to_org_id;
2308: x_header_changed_attr_tbl(ind).current_value := x_current_deliver_to_address;
2309:
2310: end if;

Line 2336: into x_next_deliver_to_address from dual;

2332: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
2333: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
2334: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
2335: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
2336: into x_next_deliver_to_address from dual;
2337: x_header_changed_attr_tbl(ind).next_id := p_next_rec.deliver_to_org_id;
2338: x_header_changed_attr_tbl(ind).next_value := x_next_deliver_to_address;
2339: end if;
2340: END IF; /* NEXT */

Line 3526: into x_current_invoice_to_address from dual;

3522: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
3523: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
3524: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
3525: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
3526: into x_current_invoice_to_address from dual;
3527:
3528: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.invoice_to_org_id;
3529: x_header_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
3530: end if;

Line 3557: into x_prior_invoice_to_address from dual;

3553: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
3554: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
3555: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
3556: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
3557: into x_prior_invoice_to_address from dual;
3558: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.invoice_to_org_id;
3559: x_header_changed_attr_tbl(ind).prior_value := x_prior_invoice_to_address;
3560: end if;
3561: END IF;

Line 3603: into x_prior_invoice_to_address from dual;

3599: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
3600: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
3601: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
3602: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
3603: into x_prior_invoice_to_address from dual;
3604: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.invoice_to_org_id;
3605: x_header_changed_attr_tbl(ind).prior_value := x_prior_invoice_to_address;
3606: end if;
3607:

Line 3633: into x_current_invoice_to_address from dual;

3629: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
3630: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
3631: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
3632: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
3633: into x_current_invoice_to_address from dual;
3634: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.invoice_to_org_id;
3635: x_header_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
3636:
3637: end if;

Line 3663: into x_next_invoice_to_address from dual;

3659: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
3660: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
3661: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
3662: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
3663: into x_next_invoice_to_address from dual;
3664: x_header_changed_attr_tbl(ind).next_id := p_next_rec.invoice_to_org_id;
3665: x_header_changed_attr_tbl(ind).next_value := x_next_invoice_to_address;
3666: end if;
3667: END IF; /* NEXT */

Line 4497: into x_current_ship_from_address from dual;

4493: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
4494: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
4495: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
4496: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
4497: into x_current_ship_from_address from dual;
4498: */
4499: x_header_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
4500: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.ship_from_org_id;
4501: end if;

Line 4520: into x_prior_ship_from_address from dual;

4516: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
4517: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
4518: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
4519: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
4520: into x_prior_ship_from_address from dual;
4521: */
4522: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_from_org_id;
4523: x_header_changed_attr_tbl(ind).prior_value := x_prior_ship_from_org;
4524: end if;

Line 4559: into x_prior_ship_from_address from dual;

4555: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
4556: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
4557: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
4558: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
4559: into x_prior_ship_from_address from dual;
4560: */
4561: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_from_org_id;
4562: x_header_changed_attr_tbl(ind).prior_value := x_prior_ship_from_org;
4563: end if;

Line 4582: into x_current_ship_from_address from dual;

4578: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
4579: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
4580: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
4581: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
4582: into x_current_ship_from_address from dual;
4583: */
4584: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.ship_from_org_id;
4585: x_header_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
4586: end if;

Line 4605: into x_next_ship_from_address from dual;

4601: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
4602: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
4603: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
4604: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
4605: into x_next_ship_from_address from dual;
4606: */
4607: x_header_changed_attr_tbl(ind).next_id := p_next_rec.ship_from_org_id;
4608: x_header_changed_attr_tbl(ind).next_value := x_next_ship_from_org;
4609: end if;

Line 4775: into x_current_ship_to_address from dual;

4771: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
4772: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
4773: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
4774: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
4775: into x_current_ship_to_address from dual;
4776:
4777: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.ship_to_org_id;
4778: x_header_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
4779: end if;

Line 4806: into x_prior_ship_to_address from dual;

4802: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
4803: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
4804: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
4805: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
4806: into x_prior_ship_to_address from dual;
4807: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_to_org_id;
4808: x_header_changed_attr_tbl(ind).prior_value := x_prior_ship_to_address;
4809: end if;
4810: END IF;

Line 4852: into x_prior_ship_to_address from dual;

4848: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
4849: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
4850: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
4851: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
4852: into x_prior_ship_to_address from dual;
4853: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_to_org_id;
4854: x_header_changed_attr_tbl(ind).prior_value := x_prior_ship_to_address;
4855: end if;
4856: if p_curr_rec.ship_to_org_id is not null then

Line 4881: into x_current_ship_to_address from dual;

4877: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
4878: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
4879: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
4880: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
4881: into x_current_ship_to_address from dual;
4882: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.ship_to_org_id;
4883: x_header_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
4884: end if;
4885:

Line 4911: into x_next_ship_to_address from dual;

4907: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
4908: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
4909: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
4910: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
4911: into x_next_ship_to_address from dual;
4912: x_header_changed_attr_tbl(ind).next_id := p_next_rec.ship_to_org_id;
4913: x_header_changed_attr_tbl(ind).next_value := x_next_ship_to_address;
4914: end if;
4915: END IF; /* NEXT */

Line 7025: into x_current_sold_to_location from dual;

7021: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
7022: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
7023: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
7024: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
7025: into x_current_sold_to_location from dual;
7026: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.sold_to_site_use_id;
7027:
7028: x_header_changed_attr_tbl(ind).current_value := x_current_sold_to_location;
7029:

Line 7055: into x_prior_sold_to_location from dual;

7051: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
7052: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
7053: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
7054: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
7055: into x_prior_sold_to_location from dual;
7056: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.sold_to_site_use_id;
7057: x_header_changed_attr_tbl(ind).prior_value := x_prior_sold_to_location;
7058: end if;
7059: END IF;

Line 7100: into x_prior_sold_to_location from dual;

7096: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
7097: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
7098: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
7099: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
7100: into x_prior_sold_to_location from dual;
7101: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.sold_to_site_use_id;
7102: x_header_changed_attr_tbl(ind).prior_value := x_prior_sold_to_location;
7103: end if;
7104:

Line 7129: into x_current_sold_to_location from dual;

7125: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
7126: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
7127: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
7128: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
7129: into x_current_sold_to_location from dual;
7130: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.sold_to_site_use_id;
7131: x_header_changed_attr_tbl(ind).current_value := x_current_sold_to_location;
7132:
7133: end if;

Line 7158: into x_next_sold_to_location from dual;

7154: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
7155: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
7156: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
7157: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
7158: into x_next_sold_to_location from dual;
7159: x_header_changed_attr_tbl(ind).next_id := p_next_rec.sold_to_site_use_id;
7160: x_header_changed_attr_tbl(ind).next_value := x_next_sold_to_location;
7161: end if;
7162: END IF; /* NEXT */

Line 8778: --select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;

8774: END IF;
8775: END IF;
8776:
8777:
8778: --select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
8779:
8780: IF l_debug_level > 0 THEN
8781: oe_debug_pub.add(' before finding new lines ');
8782: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

Line 10586: into x_current_deliver_to_address from dual;

10582: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
10583: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
10584: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
10585: DECODE(x_deliver_to_country, NULL,x_deliver_to_country)
10586: into x_current_deliver_to_address from dual;
10587:
10588: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.deliver_to_org_id;
10589: x_line_changed_attr_tbl(ind).current_value := x_current_deliver_to_address;
10590: end if;

Line 10617: into x_prior_deliver_to_address from dual;

10613: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
10614: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
10615: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
10616: DECODE(x_deliver_to_country, NULL,x_deliver_to_country)
10617: into x_prior_deliver_to_address from dual;
10618: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.deliver_to_org_id;
10619: x_line_changed_attr_tbl(ind).prior_value := x_prior_deliver_to_address;
10620: end if;
10621: END IF;

Line 10663: into x_prior_deliver_to_address from dual;

10659: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
10660: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
10661: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
10662: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
10663: into x_prior_deliver_to_address from dual;
10664: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.deliver_to_org_id;
10665: x_line_changed_attr_tbl(ind).prior_value := x_prior_deliver_to_address;
10666:
10667: end if;

Line 10693: into x_current_deliver_to_address from dual;

10689: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
10690: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
10691: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
10692: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
10693: into x_current_deliver_to_address from dual;
10694: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.deliver_to_org_id;
10695: x_line_changed_attr_tbl(ind).current_value := x_current_deliver_to_address;
10696:
10697: end if;

Line 10723: into x_next_deliver_to_address from dual;

10719: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
10720: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
10721: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
10722: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
10723: into x_next_deliver_to_address from dual;
10724: x_line_changed_attr_tbl(ind).next_id := p_next_rec.deliver_to_org_id;
10725: x_line_changed_attr_tbl(ind).next_value := x_next_deliver_to_address;
10726: end if;
10727: END IF;

Line 13080: into x_current_intermed_address from dual;

13076: DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
13077: DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
13078: DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
13079: DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
13080: into x_current_intermed_address from dual;
13081:
13082: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.intermed_ship_to_org_id;
13083: x_line_changed_attr_tbl(ind).current_value := x_current_intermed_address;
13084: end if;

Line 13111: into x_prior_intermed_address from dual;

13107: DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
13108: DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
13109: DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
13110: DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
13111: into x_prior_intermed_address from dual;
13112: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.intermed_ship_to_org_id;
13113: x_line_changed_attr_tbl(ind).prior_value := x_prior_intermed_address;
13114: end if;
13115: END IF;

Line 13158: into x_prior_intermed_address from dual;

13154: DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
13155: DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
13156: DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
13157: DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
13158: into x_prior_intermed_address from dual;
13159: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.intermed_ship_to_org_id;
13160: x_line_changed_attr_tbl(ind).prior_value := x_prior_intermed_address;
13161: end if;
13162:

Line 13188: into x_current_intermed_address from dual;

13184: DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
13185: DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
13186: DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
13187: DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
13188: into x_current_intermed_address from dual;
13189: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.intermed_ship_to_org_id;
13190: x_line_changed_attr_tbl(ind).current_value := x_current_intermed_address;
13191: end if;
13192:

Line 13218: into x_next_intermed_address from dual;

13214: DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
13215: DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
13216: DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
13217: DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
13218: into x_next_intermed_address from dual;
13219: x_line_changed_attr_tbl(ind).next_id := p_next_rec.intermed_ship_to_org_id;
13220: x_line_changed_attr_tbl(ind).next_value := x_next_intermed_address;
13221: end if;
13222: END IF;

Line 13315: into x_current_invoice_to_address from dual;

13311: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
13312: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
13313: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
13314: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
13315: into x_current_invoice_to_address from dual;
13316:
13317: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.invoice_to_org_id;
13318: x_line_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
13319: end if;

Line 13346: into x_prior_invoice_to_address from dual;

13342: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
13343: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
13344: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
13345: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
13346: into x_prior_invoice_to_address from dual;
13347: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.invoice_to_org_id;
13348: x_line_changed_attr_tbl(ind).prior_value := x_prior_invoice_to_address;
13349: end if;
13350: END IF;

Line 13393: into x_prior_invoice_to_address from dual;

13389: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
13390: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
13391: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
13392: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
13393: into x_prior_invoice_to_address from dual;
13394: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.invoice_to_org_id;
13395: x_line_changed_attr_tbl(ind).prior_value := x_prior_invoice_to_address;
13396: end if;
13397:

Line 13423: into x_current_invoice_to_address from dual;

13419: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
13420: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
13421: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
13422: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
13423: into x_current_invoice_to_address from dual;
13424: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.invoice_to_org_id;
13425: x_line_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
13426: end if;
13427: if p_next_rec.invoice_to_org_id is not null then

Line 13451: into x_next_invoice_to_address from dual;

13447: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
13448: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
13449: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
13450: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
13451: into x_next_invoice_to_address from dual;
13452: x_line_changed_attr_tbl(ind).next_id := p_next_rec.invoice_to_org_id;
13453: x_line_changed_attr_tbl(ind).next_value := x_next_invoice_to_address;
13454: end if;
13455: END IF;

Line 16474: into x_ship_from_address from dual;

16470: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
16471: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
16472: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
16473: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
16474: into x_ship_from_address from dual;
16475: */
16476: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.ship_from_org_id;
16477: x_line_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
16478: end if;

Line 16497: into x_ship_from_address from dual;

16493: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
16494: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
16495: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
16496: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
16497: into x_ship_from_address from dual;
16498: */
16499: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_from_org_id;
16500: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_from_org;
16501: end if;

Line 16537: into x_ship_from_address from dual;

16533: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
16534: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
16535: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
16536: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
16537: into x_ship_from_address from dual;
16538: */
16539: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_from_org_id;
16540: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_from_org;
16541:

Line 16560: into x_ship_from_address from dual;

16556: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
16557: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
16558: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
16559: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
16560: into x_ship_from_address from dual;
16561: */
16562: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.ship_from_org_id;
16563: x_line_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
16564: end if;

Line 16583: into x_ship_from_address from dual;

16579: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
16580: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
16581: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
16582: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
16583: into x_ship_from_address from dual;
16584: */
16585: x_line_changed_attr_tbl(ind).next_id := p_next_rec.ship_from_org_id;
16586: x_line_changed_attr_tbl(ind).next_value := x_next_ship_from_org;
16587: end if;

Line 16759: into x_current_ship_to_address from dual;

16755: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
16756: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
16757: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
16758: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
16759: into x_current_ship_to_address from dual;
16760:
16761: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.ship_to_org_id;
16762: x_line_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
16763: end if;

Line 16790: into x_prior_ship_to_address from dual;

16786: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
16787: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
16788: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
16789: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
16790: into x_prior_ship_to_address from dual;
16791: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_to_org_id;
16792: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_to_address;
16793: end if;
16794: END IF;

Line 16837: into x_prior_ship_to_address from dual;

16833: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
16834: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
16835: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
16836: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
16837: into x_prior_ship_to_address from dual;
16838: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_to_org_id;
16839: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_to_address;
16840: end if;
16841:

Line 16867: into x_current_ship_to_address from dual;

16863: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
16864: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
16865: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
16866: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
16867: into x_current_ship_to_address from dual;
16868: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.ship_to_org_id;
16869: x_line_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
16870: end if;
16871:

Line 16897: into x_next_ship_to_address from dual;

16893: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
16894: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
16895: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
16896: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
16897: into x_next_ship_to_address from dual;
16898: x_line_changed_attr_tbl(ind).next_id := p_next_rec.ship_to_org_id;
16899: x_line_changed_attr_tbl(ind).next_value := x_next_ship_to_address;
16900: end if;
16901: END IF;

Line 18702: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;

18698: IF l_line_id IS NOT NULL THEN
18699: IF l_debug_level > 0 THEN
18700: oe_debug_pub.add('*************before call total lines(trans) ******************'||ind1);
18701: END IF;
18702: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
18703: IF x_line_number IS NULL THEN
18704: -- bug 9299752
18705: begin
18706: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;

Line 18706: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;

18702: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
18703: IF x_line_number IS NULL THEN
18704: -- bug 9299752
18705: begin
18706: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18707: exception
18708: when others then
18709: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
18710: end;

Line 18709: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;

18705: begin
18706: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18707: exception
18708: when others then
18709: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
18710: end;
18711: -- bug 9299752
18712: END IF;
18713: IF l_debug_level > 0 THEN

Line 18754: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;

18750: oe_debug_pub.add('*************before call total lines ******************'||ind1);
18751: END IF;
18752: -- bug 9299752
18753: begin
18754: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18755: exception
18756: when others then
18757: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
18758: end;

Line 18757: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;

18753: begin
18754: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18755: exception
18756: when others then
18757: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
18758: end;
18759: -- bug 9299752
18760: COMPARE_LINE_ATTRIBUTES(p_header_id => p_header_id,
18761: p_line_id => l_line_id,

Line 21638: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;

21634:
21635: IF l_line_id IS NOT NULL THEN
21636: -- bug 9299752
21637: begin
21638: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21639: exception
21640: when others then
21641: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
21642: end;

Line 21641: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;

21637: begin
21638: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21639: exception
21640: when others then
21641: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
21642: end;
21643: -- bug 9299752
21644: END IF;
21645: IF x_line_number IS NULL THEN

Line 21646: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;

21642: end;
21643: -- bug 9299752
21644: END IF;
21645: IF x_line_number IS NULL THEN
21646: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
21647: END IF;
21648:
21649: COMPARE_line_SC_ATTRIBUTES(p_header_id => p_header_id,
21650: p_sales_credit_id => l_sales_credit_id,

Line 21687: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;

21683: oe_debug_pub.add('*************before call total sales_credits ******************'||ind1);
21684: END IF;
21685: -- bug 9299752
21686: begin
21687: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21688: exception
21689: when others then
21690: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
21691: end;

Line 21690: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;

21686: begin
21687: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21688: exception
21689: when others then
21690: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
21691: end;
21692: -- bug 9299752
21693: COMPARE_line_SC_ATTRIBUTES(p_header_id => p_header_id,
21694: p_sales_credit_id => l_sales_credit_id,