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_COMP dependencies on DUAL

Line 2197: into x_prior_deliver_to_address from dual;

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

Line 2228: into x_current_deliver_to_address from dual;

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

Line 2274: into x_prior_deliver_to_address from dual;

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

Line 2304: into x_current_deliver_to_address from dual;

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

Line 2334: into x_next_deliver_to_address from dual;

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

Line 3524: into x_current_invoice_to_address from dual;

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

Line 3555: into x_prior_invoice_to_address from dual;

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

Line 3601: into x_prior_invoice_to_address from dual;

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

Line 3631: into x_current_invoice_to_address from dual;

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

Line 3661: into x_next_invoice_to_address from dual;

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

Line 4495: into x_current_ship_from_address from dual;

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

Line 4518: into x_prior_ship_from_address from dual;

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

Line 4557: into x_prior_ship_from_address from dual;

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

Line 4580: into x_current_ship_from_address from dual;

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

Line 4603: into x_next_ship_from_address from dual;

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

Line 4773: into x_current_ship_to_address from dual;

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

Line 4804: into x_prior_ship_to_address from dual;

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

Line 4850: into x_prior_ship_to_address from dual;

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

Line 4879: into x_current_ship_to_address from dual;

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

Line 4909: into x_next_ship_to_address from dual;

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

Line 6900: into x_current_sold_to_location from dual;

6896: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
6897: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
6898: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
6899: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
6900: into x_current_sold_to_location from dual;
6901: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.sold_to_site_use_id;
6902:
6903: x_header_changed_attr_tbl(ind).current_value := x_current_sold_to_location;
6904:

Line 6930: into x_prior_sold_to_location from dual;

6926: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
6927: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
6928: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
6929: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
6930: into x_prior_sold_to_location from dual;
6931: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.sold_to_site_use_id;
6932: x_header_changed_attr_tbl(ind).prior_value := x_prior_sold_to_location;
6933: end if;
6934: END IF;

Line 6975: into x_prior_sold_to_location from dual;

6971: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
6972: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
6973: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
6974: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
6975: into x_prior_sold_to_location from dual;
6976: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.sold_to_site_use_id;
6977: x_header_changed_attr_tbl(ind).prior_value := x_prior_sold_to_location;
6978: end if;
6979:

Line 7004: into x_current_sold_to_location from dual;

7000: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
7001: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
7002: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
7003: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
7004: into x_current_sold_to_location from dual;
7005: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.sold_to_site_use_id;
7006: x_header_changed_attr_tbl(ind).current_value := x_current_sold_to_location;
7007:
7008: end if;

Line 7033: into x_next_sold_to_location from dual;

7029: DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
7030: DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
7031: DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
7032: DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
7033: into x_next_sold_to_location from dual;
7034: x_header_changed_attr_tbl(ind).next_id := p_next_rec.sold_to_site_use_id;
7035: x_header_changed_attr_tbl(ind).next_value := x_next_sold_to_location;
7036: end if;
7037: END IF; /* NEXT */

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

8617: END IF;
8618: END IF;
8619:
8620:
8621: --select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
8622:
8623: IF l_debug_level > 0 THEN
8624: oe_debug_pub.add(' before finding new lines ');
8625: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

Line 10429: into x_current_deliver_to_address from dual;

10425: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
10426: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
10427: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
10428: DECODE(x_deliver_to_country, NULL,x_deliver_to_country)
10429: into x_current_deliver_to_address from dual;
10430:
10431: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.deliver_to_org_id;
10432: x_line_changed_attr_tbl(ind).current_value := x_current_deliver_to_address;
10433: end if;

Line 10460: into x_prior_deliver_to_address from dual;

10456: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
10457: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
10458: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
10459: DECODE(x_deliver_to_country, NULL,x_deliver_to_country)
10460: into x_prior_deliver_to_address from dual;
10461: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.deliver_to_org_id;
10462: x_line_changed_attr_tbl(ind).prior_value := x_prior_deliver_to_address;
10463: end if;
10464: END IF;

Line 10506: into x_prior_deliver_to_address from dual;

10502: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
10503: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
10504: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
10505: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
10506: into x_prior_deliver_to_address from dual;
10507: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.deliver_to_org_id;
10508: x_line_changed_attr_tbl(ind).prior_value := x_prior_deliver_to_address;
10509:
10510: end if;

Line 10536: into x_current_deliver_to_address from dual;

10532: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
10533: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
10534: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
10535: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
10536: into x_current_deliver_to_address from dual;
10537: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.deliver_to_org_id;
10538: x_line_changed_attr_tbl(ind).current_value := x_current_deliver_to_address;
10539:
10540: end if;

Line 10566: into x_next_deliver_to_address from dual;

10562: DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
10563: DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
10564: DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
10565: DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
10566: into x_next_deliver_to_address from dual;
10567: x_line_changed_attr_tbl(ind).next_id := p_next_rec.deliver_to_org_id;
10568: x_line_changed_attr_tbl(ind).next_value := x_next_deliver_to_address;
10569: end if;
10570: END IF;

Line 12882: into x_current_intermed_address from dual;

12878: DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
12879: DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
12880: DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
12881: DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
12882: into x_current_intermed_address from dual;
12883:
12884: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.intermed_ship_to_org_id;
12885: x_line_changed_attr_tbl(ind).current_value := x_current_intermed_address;
12886: end if;

Line 12913: into x_prior_intermed_address from dual;

12909: DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
12910: DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
12911: DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
12912: DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
12913: into x_prior_intermed_address from dual;
12914: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.intermed_ship_to_org_id;
12915: x_line_changed_attr_tbl(ind).prior_value := x_prior_intermed_address;
12916: end if;
12917: END IF;

Line 12960: into x_prior_intermed_address from dual;

12956: DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
12957: DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
12958: DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
12959: DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
12960: into x_prior_intermed_address from dual;
12961: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.intermed_ship_to_org_id;
12962: x_line_changed_attr_tbl(ind).prior_value := x_prior_intermed_address;
12963: end if;
12964:

Line 12990: into x_current_intermed_address from dual;

12986: DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
12987: DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
12988: DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
12989: DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
12990: into x_current_intermed_address from dual;
12991: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.intermed_ship_to_org_id;
12992: x_line_changed_attr_tbl(ind).current_value := x_current_intermed_address;
12993: end if;
12994:

Line 13020: into x_next_intermed_address from dual;

13016: DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
13017: DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
13018: DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
13019: DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
13020: into x_next_intermed_address from dual;
13021: x_line_changed_attr_tbl(ind).next_id := p_next_rec.intermed_ship_to_org_id;
13022: x_line_changed_attr_tbl(ind).next_value := x_next_intermed_address;
13023: end if;
13024: END IF;

Line 13117: into x_current_invoice_to_address from dual;

13113: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
13114: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
13115: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
13116: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
13117: into x_current_invoice_to_address from dual;
13118:
13119: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.invoice_to_org_id;
13120: x_line_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
13121: end if;

Line 13148: into x_prior_invoice_to_address from dual;

13144: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
13145: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
13146: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
13147: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
13148: into x_prior_invoice_to_address from dual;
13149: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.invoice_to_org_id;
13150: x_line_changed_attr_tbl(ind).prior_value := x_prior_invoice_to_address;
13151: end if;
13152: END IF;

Line 13195: into x_prior_invoice_to_address from dual;

13191: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
13192: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
13193: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
13194: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
13195: into x_prior_invoice_to_address from dual;
13196: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.invoice_to_org_id;
13197: x_line_changed_attr_tbl(ind).prior_value := x_prior_invoice_to_address;
13198: end if;
13199:

Line 13225: into x_current_invoice_to_address from dual;

13221: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
13222: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
13223: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
13224: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
13225: into x_current_invoice_to_address from dual;
13226: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.invoice_to_org_id;
13227: x_line_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
13228: end if;
13229: if p_next_rec.invoice_to_org_id is not null then

Line 13253: into x_next_invoice_to_address from dual;

13249: DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
13250: DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
13251: DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
13252: DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
13253: into x_next_invoice_to_address from dual;
13254: x_line_changed_attr_tbl(ind).next_id := p_next_rec.invoice_to_org_id;
13255: x_line_changed_attr_tbl(ind).next_value := x_next_invoice_to_address;
13256: end if;
13257: END IF;

Line 15967: into x_ship_from_address from dual;

15963: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
15964: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
15965: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
15966: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
15967: into x_ship_from_address from dual;
15968: */
15969: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.ship_from_org_id;
15970: x_line_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
15971: end if;

Line 15990: into x_ship_from_address from dual;

15986: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
15987: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
15988: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
15989: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
15990: into x_ship_from_address from dual;
15991: */
15992: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_from_org_id;
15993: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_from_org;
15994: end if;

Line 16030: into x_ship_from_address from dual;

16026: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
16027: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
16028: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
16029: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
16030: into x_ship_from_address from dual;
16031: */
16032: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_from_org_id;
16033: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_from_org;
16034:

Line 16053: into x_ship_from_address from dual;

16049: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
16050: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
16051: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
16052: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
16053: into x_ship_from_address from dual;
16054: */
16055: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.ship_from_org_id;
16056: x_line_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
16057: end if;

Line 16076: into x_ship_from_address from dual;

16072: DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
16073: DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
16074: DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
16075: DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
16076: into x_ship_from_address from dual;
16077: */
16078: x_line_changed_attr_tbl(ind).next_id := p_next_rec.ship_from_org_id;
16079: x_line_changed_attr_tbl(ind).next_value := x_next_ship_from_org;
16080: end if;

Line 16252: into x_current_ship_to_address from dual;

16248: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
16249: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
16250: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
16251: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
16252: into x_current_ship_to_address from dual;
16253:
16254: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.ship_to_org_id;
16255: x_line_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
16256: end if;

Line 16283: into x_prior_ship_to_address from dual;

16279: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
16280: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
16281: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
16282: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
16283: into x_prior_ship_to_address from dual;
16284: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_to_org_id;
16285: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_to_address;
16286: end if;
16287: END IF;

Line 16330: into x_prior_ship_to_address from dual;

16326: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
16327: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
16328: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
16329: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
16330: into x_prior_ship_to_address from dual;
16331: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.ship_to_org_id;
16332: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_to_address;
16333: end if;
16334:

Line 16360: into x_current_ship_to_address from dual;

16356: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
16357: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
16358: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
16359: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
16360: into x_current_ship_to_address from dual;
16361: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.ship_to_org_id;
16362: x_line_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
16363: end if;
16364:

Line 16390: into x_next_ship_to_address from dual;

16386: DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
16387: DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
16388: DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
16389: DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
16390: into x_next_ship_to_address from dual;
16391: x_line_changed_attr_tbl(ind).next_id := p_next_rec.ship_to_org_id;
16392: x_line_changed_attr_tbl(ind).next_value := x_next_ship_to_address;
16393: end if;
16394: END IF;

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

18187: IF l_line_id IS NOT NULL THEN
18188: IF l_debug_level > 0 THEN
18189: oe_debug_pub.add('*************before call total lines(trans) ******************'||ind1);
18190: END IF;
18191: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
18192: IF x_line_number IS NULL THEN
18193: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18194: END IF;
18195: IF l_debug_level > 0 THEN

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

18189: oe_debug_pub.add('*************before call total lines(trans) ******************'||ind1);
18190: END IF;
18191: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
18192: IF x_line_number IS NULL THEN
18193: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18194: END IF;
18195: IF l_debug_level > 0 THEN
18196: oe_debug_pub.add('*************line_number ******************'||x_line_number);
18197: END IF;

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

18230: IF l_line_id IS NOT NULL THEN
18231: IF l_debug_level > 0 THEN
18232: oe_debug_pub.add('*************before call total lines ******************'||ind1);
18233: END IF;
18234: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18235: COMPARE_LINE_ATTRIBUTES(p_header_id => p_header_id,
18236: p_line_id => l_line_id,
18237: p_prior_version => p_prior_version,
18238: p_current_version => p_current_version,

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

21097: oe_debug_pub.add('*************before call total sales_credits(trans) ******************'||ind1);
21098: END IF;
21099:
21100: IF l_line_id IS NOT NULL THEN
21101: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21102: END IF;
21103: IF x_line_number IS NULL THEN
21104: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
21105: END IF;

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

21100: IF l_line_id IS NOT NULL THEN
21101: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21102: END IF;
21103: IF x_line_number IS NULL THEN
21104: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
21105: END IF;
21106:
21107: COMPARE_line_SC_ATTRIBUTES(p_header_id => p_header_id,
21108: p_sales_credit_id => l_sales_credit_id,

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

21139: IF l_sales_credit_id IS NOT NULL THEN
21140: IF l_debug_level > 0 THEN
21141: oe_debug_pub.add('*************before call total sales_credits ******************'||ind1);
21142: END IF;
21143: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21144: COMPARE_line_SC_ATTRIBUTES(p_header_id => p_header_id,
21145: p_sales_credit_id => l_sales_credit_id,
21146: p_prior_version => p_prior_version,
21147: p_current_version => p_current_version,