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 OE_ID_TO_VALUE

Line 624: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);

620: ind := ind+1;
621: prior_exists := 'Y';
622: x_header_changed_attr_tbl(ind).attribute_name := 'accounting_rule';
623: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.accounting_rule_id;
624: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);
625: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.accounting_rule_id;
626: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);
627: END IF;
628: END IF; /* PRIOR */

Line 626: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);

622: x_header_changed_attr_tbl(ind).attribute_name := 'accounting_rule';
623: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.accounting_rule_id;
624: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);
625: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.accounting_rule_id;
626: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);
627: END IF;
628: END IF; /* PRIOR */
629: /****************************/
630: IF p_next_version IS NOT NULL THEN

Line 635: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);

631: IF OE_Globals.Equal(
632: p_curr_rec.accounting_rule_id,
633: p_next_rec.accounting_rule_id) THEN
634: IF prior_exists = 'Y' THEN
635: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);
636: END IF;
637: ELSE
638: IF prior_exists = 'N' THEN
639: ind := ind+1;

Line 643: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);

639: ind := ind+1;
640: END IF;
641: x_header_changed_attr_tbl(ind).attribute_name := 'accounting_rule';
642: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.accounting_rule_id;
643: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);
644: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.accounting_rule_id;
645: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);
646: x_header_changed_attr_tbl(ind).next_id := p_next_rec.accounting_rule_id;
647: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_next_rec.accounting_rule_id);

Line 645: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);

641: x_header_changed_attr_tbl(ind).attribute_name := 'accounting_rule';
642: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.accounting_rule_id;
643: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);
644: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.accounting_rule_id;
645: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);
646: x_header_changed_attr_tbl(ind).next_id := p_next_rec.accounting_rule_id;
647: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_next_rec.accounting_rule_id);
648: END IF;
649: END IF; /* NEXT */

Line 647: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_next_rec.accounting_rule_id);

643: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);
644: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.accounting_rule_id;
645: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);
646: x_header_changed_attr_tbl(ind).next_id := p_next_rec.accounting_rule_id;
647: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_next_rec.accounting_rule_id);
648: END IF;
649: END IF; /* NEXT */
650:
651: /* END ACCOUNTING_RULE_ID*/

Line 668: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_curr_rec.PAYMENT_TERM_ID);

664: ind := ind+1;
665: prior_exists := 'Y';
666: x_header_changed_attr_tbl(ind).attribute_name := 'terms';
667: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.PAYMENT_TERM_ID;
668: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_curr_rec.PAYMENT_TERM_ID);
669: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.PAYMENT_TERM_ID;
670: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_prior_rec.PAYMENT_TERM_ID);
671: END IF;
672: END IF; /* PRIOR */

Line 670: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_prior_rec.PAYMENT_TERM_ID);

666: x_header_changed_attr_tbl(ind).attribute_name := 'terms';
667: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.PAYMENT_TERM_ID;
668: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_curr_rec.PAYMENT_TERM_ID);
669: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.PAYMENT_TERM_ID;
670: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_prior_rec.PAYMENT_TERM_ID);
671: END IF;
672: END IF; /* PRIOR */
673: /****************************/
674: IF p_next_version IS NOT NULL THEN

Line 679: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_curr_rec.PAYMENT_TERM_ID);

675: IF OE_Globals.Equal(
676: p_curr_rec.PAYMENT_TERM_ID,
677: p_next_rec.PAYMENT_TERM_ID) THEN
678: IF prior_exists = 'Y' THEN
679: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_curr_rec.PAYMENT_TERM_ID);
680: END IF;
681: ELSE
682: IF prior_exists = 'N' THEN
683: ind := ind+1;

Line 687: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_prior_rec.PAYMENT_TERM_ID);

683: ind := ind+1;
684: END IF;
685: x_header_changed_attr_tbl(ind).attribute_name := 'terms';
686: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.PAYMENT_TERM_ID;
687: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_prior_rec.PAYMENT_TERM_ID);
688: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.PAYMENT_TERM_ID;
689: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_curr_rec.PAYMENT_TERM_ID);
690: x_header_changed_attr_tbl(ind).next_id := p_next_rec.PAYMENT_TERM_ID;
691: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_next_rec.PAYMENT_TERM_ID);

Line 689: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_curr_rec.PAYMENT_TERM_ID);

685: x_header_changed_attr_tbl(ind).attribute_name := 'terms';
686: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.PAYMENT_TERM_ID;
687: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_prior_rec.PAYMENT_TERM_ID);
688: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.PAYMENT_TERM_ID;
689: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_curr_rec.PAYMENT_TERM_ID);
690: x_header_changed_attr_tbl(ind).next_id := p_next_rec.PAYMENT_TERM_ID;
691: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_next_rec.PAYMENT_TERM_ID);
692: END IF;
693: END IF; /* NEXT */

Line 691: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_next_rec.PAYMENT_TERM_ID);

687: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_prior_rec.PAYMENT_TERM_ID);
688: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.PAYMENT_TERM_ID;
689: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_curr_rec.PAYMENT_TERM_ID);
690: x_header_changed_attr_tbl(ind).next_id := p_next_rec.PAYMENT_TERM_ID;
691: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_next_rec.PAYMENT_TERM_ID);
692: END IF;
693: END IF; /* NEXT */
694:
695: /* END PAYMENT_TERM_ID*/

Line 712: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);

708: ind := ind+1;
709: prior_exists := 'Y';
710: x_header_changed_attr_tbl(ind).attribute_name := 'agreement';
711: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.agreement_id;
712: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);
713: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.agreement_id;
714: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);
715: END IF;
716: END IF; /* PRIOR */

Line 714: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);

710: x_header_changed_attr_tbl(ind).attribute_name := 'agreement';
711: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.agreement_id;
712: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);
713: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.agreement_id;
714: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);
715: END IF;
716: END IF; /* PRIOR */
717: /****************************/
718: IF p_next_version IS NOT NULL THEN

Line 723: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);

719: IF OE_Globals.Equal(
720: p_curr_rec.agreement_id,
721: p_next_rec.agreement_id) THEN
722: IF prior_exists = 'Y' THEN
723: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);
724: END IF;
725: ELSE
726: IF prior_exists = 'N' THEN
727: ind := ind+1;

Line 731: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);

727: ind := ind+1;
728: END IF;
729: x_header_changed_attr_tbl(ind).attribute_name := 'agreement';
730: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.agreement_id;
731: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);
732: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.agreement_id;
733: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);
734: x_header_changed_attr_tbl(ind).next_id := p_next_rec.agreement_id;
735: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_next_rec.agreement_id);

Line 733: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);

729: x_header_changed_attr_tbl(ind).attribute_name := 'agreement';
730: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.agreement_id;
731: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);
732: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.agreement_id;
733: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);
734: x_header_changed_attr_tbl(ind).next_id := p_next_rec.agreement_id;
735: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_next_rec.agreement_id);
736: END IF; /* NEXT */
737: END IF;

Line 735: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_next_rec.agreement_id);

731: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);
732: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.agreement_id;
733: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);
734: x_header_changed_attr_tbl(ind).next_id := p_next_rec.agreement_id;
735: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_next_rec.agreement_id);
736: END IF; /* NEXT */
737: END IF;
738:
739: /* END agreement_id*/

Line 1375: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Conversion_Type(p_curr_rec.conversion_type_code);

1371: ind := ind+1;
1372: prior_exists := 'Y';
1373: x_header_changed_attr_tbl(ind).attribute_name := 'conversion_type';
1374: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.conversion_type_code;
1375: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Conversion_Type(p_curr_rec.conversion_type_code);
1376: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.conversion_type_code;
1377: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Conversion_Type(p_prior_rec.conversion_type_code);
1378: END IF;
1379: END IF; /* PRIOR */

Line 1377: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Conversion_Type(p_prior_rec.conversion_type_code);

1373: x_header_changed_attr_tbl(ind).attribute_name := 'conversion_type';
1374: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.conversion_type_code;
1375: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Conversion_Type(p_curr_rec.conversion_type_code);
1376: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.conversion_type_code;
1377: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Conversion_Type(p_prior_rec.conversion_type_code);
1378: END IF;
1379: END IF; /* PRIOR */
1380: /****************************/
1381: IF p_next_version IS NOT NULL THEN

Line 1386: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Conversion_Type(p_curr_rec.conversion_type_code);

1382: IF OE_Globals.Equal(
1383: p_curr_rec.conversion_type_code,
1384: p_next_rec.conversion_type_code) THEN
1385: IF prior_exists = 'Y' THEN
1386: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Conversion_Type(p_curr_rec.conversion_type_code);
1387: END IF;
1388: ELSE
1389: IF prior_exists = 'N' THEN
1390: ind := ind+1;

Line 1394: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Conversion_Type(p_prior_rec.conversion_type_code);

1390: ind := ind+1;
1391: END IF;
1392: x_header_changed_attr_tbl(ind).attribute_name := 'conversion_type';
1393: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.conversion_type_code;
1394: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Conversion_Type(p_prior_rec.conversion_type_code);
1395: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.conversion_type_code;
1396: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Conversion_Type(p_curr_rec.conversion_type_code);
1397: x_header_changed_attr_tbl(ind).next_id := p_next_rec.conversion_type_code;
1398: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Conversion_type(p_next_rec.conversion_type_code);

Line 1396: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Conversion_Type(p_curr_rec.conversion_type_code);

1392: x_header_changed_attr_tbl(ind).attribute_name := 'conversion_type';
1393: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.conversion_type_code;
1394: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Conversion_Type(p_prior_rec.conversion_type_code);
1395: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.conversion_type_code;
1396: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Conversion_Type(p_curr_rec.conversion_type_code);
1397: x_header_changed_attr_tbl(ind).next_id := p_next_rec.conversion_type_code;
1398: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Conversion_type(p_next_rec.conversion_type_code);
1399: END IF; /* NEXT */
1400: END IF;

Line 1398: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Conversion_type(p_next_rec.conversion_type_code);

1394: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Conversion_Type(p_prior_rec.conversion_type_code);
1395: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.conversion_type_code;
1396: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Conversion_Type(p_curr_rec.conversion_type_code);
1397: x_header_changed_attr_tbl(ind).next_id := p_next_rec.conversion_type_code;
1398: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Conversion_type(p_next_rec.conversion_type_code);
1399: END IF; /* NEXT */
1400: END IF;
1401:
1402: /* END Conversion_Type_code*/

Line 1458: OE_ID_TO_VALUE.deliver_To_Org

1454: ind := ind+1;
1455: prior_exists := 'Y';
1456: x_header_changed_attr_tbl(ind).attribute_name := 'deliver_to';
1457: if p_curr_rec.deliver_to_org_id is not null then
1458: OE_ID_TO_VALUE.deliver_To_Org
1459: ( p_deliver_to_org_id => p_curr_rec.deliver_To_org_id
1460: , x_deliver_to_address1 => x_deliver_to_address1
1461: , x_deliver_to_address2 => x_deliver_to_address2
1462: , x_deliver_to_address3 => x_deliver_to_address3

Line 1489: OE_ID_TO_VALUE.deliver_To_Org

1485: x_header_changed_attr_tbl(ind).current_value := x_current_deliver_to_address;
1486:
1487: end if;
1488: if p_prior_rec.deliver_to_org_id is not null then
1489: OE_ID_TO_VALUE.deliver_To_Org
1490: ( p_deliver_to_org_id => p_prior_rec.deliver_To_org_id
1491: , x_deliver_to_address1 => x_deliver_to_address1
1492: , x_deliver_to_address2 => x_deliver_to_address2
1493: , x_deliver_to_address3 => x_deliver_to_address3

Line 1534: OE_ID_TO_VALUE.deliver_To_Org

1530: END IF;
1531: x_header_changed_attr_tbl(ind).attribute_name := 'deliver_to';
1532:
1533: if p_prior_rec.deliver_to_org_id is not null then
1534: OE_ID_TO_VALUE.deliver_To_Org
1535: ( p_deliver_to_org_id => p_prior_rec.deliver_To_org_id
1536: , x_deliver_to_address1 => x_deliver_to_address1
1537: , x_deliver_to_address2 => x_deliver_to_address2
1538: , x_deliver_to_address3 => x_deliver_to_address3

Line 1564: OE_ID_TO_VALUE.deliver_To_Org

1560: x_header_changed_attr_tbl(ind).prior_value := x_prior_deliver_to_address;
1561:
1562: end if;
1563: if p_curr_rec.deliver_to_org_id is not null then
1564: OE_ID_TO_VALUE.deliver_To_Org
1565: ( p_deliver_to_org_id => p_curr_rec.deliver_To_org_id
1566: , x_deliver_to_address1 => x_deliver_to_address1
1567: , x_deliver_to_address2 => x_deliver_to_address2
1568: , x_deliver_to_address3 => x_deliver_to_address3

Line 1594: OE_ID_TO_VALUE.deliver_To_Org

1590: x_header_changed_attr_tbl(ind).current_value := x_current_deliver_to_address;
1591: end if;
1592:
1593: if p_next_rec.deliver_to_org_id is not null then
1594: OE_ID_TO_VALUE.deliver_To_Org
1595: ( p_deliver_to_org_id => p_next_rec.deliver_To_org_id
1596: , x_deliver_to_address1 => x_deliver_to_address1
1597: , x_deliver_to_address2 => x_deliver_to_address2
1598: , x_deliver_to_address3 => x_deliver_to_address3

Line 1643: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);

1639: ind := ind+1;
1640: prior_exists := 'Y';
1641: x_header_changed_attr_tbl(ind).attribute_name := 'freight_terms';
1642: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.freight_terms_code;
1643: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);
1644: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.freight_terms_code;
1645: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);
1646: END IF;
1647: END IF; /* PRIOR */

Line 1645: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);

1641: x_header_changed_attr_tbl(ind).attribute_name := 'freight_terms';
1642: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.freight_terms_code;
1643: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);
1644: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.freight_terms_code;
1645: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);
1646: END IF;
1647: END IF; /* PRIOR */
1648: /****************************/
1649:

Line 1655: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);

1651: IF OE_Globals.Equal(
1652: p_curr_rec.freight_terms_code,
1653: p_next_rec.freight_terms_code) THEN
1654: IF prior_exists = 'Y' THEN
1655: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);
1656: END IF;
1657: ELSE
1658: IF prior_exists = 'N' THEN
1659: ind := ind+1;

Line 1663: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);

1659: ind := ind+1;
1660: END IF;
1661: x_header_changed_attr_tbl(ind).attribute_name := 'freight_terms';
1662: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.freight_terms_code;
1663: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);
1664: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.freight_terms_code;
1665: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);
1666: x_header_changed_attr_tbl(ind).next_id := p_next_rec.freight_terms_code;
1667: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_next_rec.freight_terms_code);

Line 1665: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);

1661: x_header_changed_attr_tbl(ind).attribute_name := 'freight_terms';
1662: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.freight_terms_code;
1663: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);
1664: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.freight_terms_code;
1665: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);
1666: x_header_changed_attr_tbl(ind).next_id := p_next_rec.freight_terms_code;
1667: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_next_rec.freight_terms_code);
1668: END IF; /* NEXT */
1669: END IF;

Line 1667: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_next_rec.freight_terms_code);

1663: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);
1664: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.freight_terms_code;
1665: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);
1666: x_header_changed_attr_tbl(ind).next_id := p_next_rec.freight_terms_code;
1667: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_next_rec.freight_terms_code);
1668: END IF; /* NEXT */
1669: END IF;
1670:
1671: /* END freight_terms_code*/

Line 1688: OE_ID_TO_VALUE.invoice_to_Org

1684: prior_exists := 'Y';
1685: x_header_changed_attr_tbl(ind).attribute_name := 'invoice_to';
1686: if p_curr_rec.invoice_to_org_id is not null then
1687:
1688: OE_ID_TO_VALUE.invoice_to_Org
1689: ( p_invoice_to_org_id => p_curr_rec.invoice_to_org_id
1690: , x_invoice_to_address1 => x_invoice_to_address1
1691: , x_invoice_to_address2 => x_invoice_to_address2
1692: , x_invoice_to_address3 => x_invoice_to_address3

Line 1719: OE_ID_TO_VALUE.invoice_to_Org

1715: x_header_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
1716: end if;
1717:
1718: if p_prior_rec.invoice_to_org_id is not null then
1719: OE_ID_TO_VALUE.invoice_to_Org
1720: ( p_invoice_to_org_id => p_prior_rec.invoice_to_org_id
1721: , x_invoice_to_address1 => x_invoice_to_address1
1722: , x_invoice_to_address2 => x_invoice_to_address2
1723: , x_invoice_to_address3 => x_invoice_to_address3

Line 1765: OE_ID_TO_VALUE.invoice_to_Org

1761: END IF;
1762: x_header_changed_attr_tbl(ind).attribute_name := 'invoice_to';
1763:
1764: if p_prior_rec.invoice_to_org_id is not null then
1765: OE_ID_TO_VALUE.invoice_to_Org
1766: ( p_invoice_to_org_id => p_prior_rec.invoice_to_org_id
1767: , x_invoice_to_address1 => x_invoice_to_address1
1768: , x_invoice_to_address2 => x_invoice_to_address2
1769: , x_invoice_to_address3 => x_invoice_to_address3

Line 1795: OE_ID_TO_VALUE.invoice_to_Org

1791: x_header_changed_attr_tbl(ind).prior_value := x_prior_invoice_to_address;
1792: end if;
1793:
1794: if p_curr_rec.invoice_to_org_id is not null then
1795: OE_ID_TO_VALUE.invoice_to_Org
1796: ( p_invoice_to_org_id => p_curr_rec.invoice_to_org_id
1797: , x_invoice_to_address1 => x_invoice_to_address1
1798: , x_invoice_to_address2 => x_invoice_to_address2
1799: , x_invoice_to_address3 => x_invoice_to_address3

Line 1825: OE_ID_TO_VALUE.invoice_to_Org

1821: x_header_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
1822: end if;
1823:
1824: if p_next_rec.invoice_to_org_id is not null then
1825: OE_ID_TO_VALUE.invoice_to_Org
1826: ( p_invoice_to_org_id => p_next_rec.invoice_to_org_id
1827: , x_invoice_to_address1 => x_invoice_to_address1
1828: , x_invoice_to_address2 => x_invoice_to_address2
1829: , x_invoice_to_address3 => x_invoice_to_address3

Line 1873: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);

1869: ind := ind+1;
1870: prior_exists := 'Y';
1871: x_header_changed_attr_tbl(ind).attribute_name := 'invoicing_rule';
1872: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.invoicing_rule_id;
1873: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);
1874: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.invoicing_rule_id;
1875: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);
1876: END IF;
1877: END IF; /* PRIOR */

Line 1875: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);

1871: x_header_changed_attr_tbl(ind).attribute_name := 'invoicing_rule';
1872: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.invoicing_rule_id;
1873: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);
1874: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.invoicing_rule_id;
1875: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);
1876: END IF;
1877: END IF; /* PRIOR */
1878: /****************************/
1879: IF p_next_version IS NOT NULL THEN

Line 1884: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);

1880: IF OE_Globals.Equal(
1881: p_curr_rec.invoicing_rule_id,
1882: p_next_rec.invoicing_rule_id) THEN
1883: IF prior_exists = 'Y' THEN
1884: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);
1885: END IF;
1886: ELSE
1887: IF prior_exists = 'N' THEN
1888: ind := ind+1;

Line 1892: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);

1888: ind := ind+1;
1889: END IF;
1890: x_header_changed_attr_tbl(ind).attribute_name := 'invoicing_rule';
1891: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.invoicing_rule_id;
1892: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);
1893: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.invoicing_rule_id;
1894: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);
1895: x_header_changed_attr_tbl(ind).next_id := p_next_rec.invoicing_rule_id;
1896: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_next_rec.invoicing_rule_id);

Line 1894: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);

1890: x_header_changed_attr_tbl(ind).attribute_name := 'invoicing_rule';
1891: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.invoicing_rule_id;
1892: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);
1893: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.invoicing_rule_id;
1894: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);
1895: x_header_changed_attr_tbl(ind).next_id := p_next_rec.invoicing_rule_id;
1896: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_next_rec.invoicing_rule_id);
1897: END IF; /* NEXT */
1898: END IF;

Line 1896: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_next_rec.invoicing_rule_id);

1892: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);
1893: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.invoicing_rule_id;
1894: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);
1895: x_header_changed_attr_tbl(ind).next_id := p_next_rec.invoicing_rule_id;
1896: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_next_rec.invoicing_rule_id);
1897: END IF; /* NEXT */
1898: END IF;
1899:
1900: /* END invoicing_rule_id*/

Line 1955: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.order_Type(p_curr_rec.order_type_id);

1951: ind := ind+1;
1952: prior_exists := 'Y';
1953: x_header_changed_attr_tbl(ind).attribute_name := 'order_type';
1954: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.order_type_id;
1955: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.order_Type(p_curr_rec.order_type_id);
1956: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.order_type_id;
1957: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.order_Type(p_prior_rec.order_type_id);
1958: END IF;
1959: END IF; /* PRIOR */

Line 1957: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.order_Type(p_prior_rec.order_type_id);

1953: x_header_changed_attr_tbl(ind).attribute_name := 'order_type';
1954: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.order_type_id;
1955: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.order_Type(p_curr_rec.order_type_id);
1956: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.order_type_id;
1957: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.order_Type(p_prior_rec.order_type_id);
1958: END IF;
1959: END IF; /* PRIOR */
1960: /****************************/
1961: IF p_next_version IS NOT NULL THEN

Line 1966: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.order_Type(p_curr_rec.order_type_id);

1962: IF OE_Globals.Equal(
1963: p_curr_rec.order_type_id,
1964: p_next_rec.order_type_id) THEN
1965: IF prior_exists = 'Y' THEN
1966: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.order_Type(p_curr_rec.order_type_id);
1967: END IF;
1968: ELSE
1969: IF prior_exists = 'N' THEN
1970: ind := ind+1;

Line 1974: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.order_Type(p_prior_rec.order_type_id);

1970: ind := ind+1;
1971: END IF;
1972: x_header_changed_attr_tbl(ind).attribute_name := 'order_type';
1973: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.order_type_id;
1974: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.order_Type(p_prior_rec.order_type_id);
1975: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.order_type_id;
1976: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.order_Type(p_curr_rec.order_type_id);
1977: x_header_changed_attr_tbl(ind).next_id := p_next_rec.order_type_id;
1978: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.order_Type(p_next_rec.order_type_id);

Line 1976: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.order_Type(p_curr_rec.order_type_id);

1972: x_header_changed_attr_tbl(ind).attribute_name := 'order_type';
1973: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.order_type_id;
1974: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.order_Type(p_prior_rec.order_type_id);
1975: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.order_type_id;
1976: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.order_Type(p_curr_rec.order_type_id);
1977: x_header_changed_attr_tbl(ind).next_id := p_next_rec.order_type_id;
1978: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.order_Type(p_next_rec.order_type_id);
1979: END IF;
1980: END IF; /* NEXT */

Line 1978: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.order_Type(p_next_rec.order_type_id);

1974: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.order_Type(p_prior_rec.order_type_id);
1975: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.order_type_id;
1976: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.order_Type(p_curr_rec.order_type_id);
1977: x_header_changed_attr_tbl(ind).next_id := p_next_rec.order_type_id;
1978: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.order_Type(p_next_rec.order_type_id);
1979: END IF;
1980: END IF; /* NEXT */
1981:
1982: /* END order_type_id*/

Line 1998: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);

1994: ind := ind+1;
1995: prior_exists := 'Y';
1996: x_header_changed_attr_tbl(ind).attribute_name := 'PRICE_LIST_NAME';
1997: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.PRICE_LIST_ID;
1998: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);
1999: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.PRICE_LIST_ID;
2000: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);
2001: END IF;
2002: END IF; /* PRIOR */

Line 2000: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);

1996: x_header_changed_attr_tbl(ind).attribute_name := 'PRICE_LIST_NAME';
1997: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.PRICE_LIST_ID;
1998: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);
1999: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.PRICE_LIST_ID;
2000: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);
2001: END IF;
2002: END IF; /* PRIOR */
2003: /****************************/
2004: IF p_next_version IS NOT NULL THEN

Line 2009: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);

2005: IF OE_Globals.Equal(
2006: p_curr_rec.PRICE_LIST_ID,
2007: p_next_rec.PRICE_LIST_ID) THEN
2008: IF prior_exists = 'Y' THEN
2009: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);
2010: END IF;
2011: ELSE
2012: IF prior_exists = 'N' THEN
2013: ind := ind+1;

Line 2017: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);

2013: ind := ind+1;
2014: END IF;
2015: x_header_changed_attr_tbl(ind).attribute_name := 'PRICE_LIST_NAME';
2016: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.PRICE_LIST_ID;
2017: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);
2018: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.PRICE_LIST_ID;
2019: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);
2020: x_header_changed_attr_tbl(ind).next_id := p_next_rec.PRICE_LIST_ID;
2021: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_next_rec.PRICE_LIST_ID);

Line 2019: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);

2015: x_header_changed_attr_tbl(ind).attribute_name := 'PRICE_LIST_NAME';
2016: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.PRICE_LIST_ID;
2017: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);
2018: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.PRICE_LIST_ID;
2019: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);
2020: x_header_changed_attr_tbl(ind).next_id := p_next_rec.PRICE_LIST_ID;
2021: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_next_rec.PRICE_LIST_ID);
2022: END IF; /* NEXT */
2023: END IF;

Line 2021: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_next_rec.PRICE_LIST_ID);

2017: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);
2018: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.PRICE_LIST_ID;
2019: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);
2020: x_header_changed_attr_tbl(ind).next_id := p_next_rec.PRICE_LIST_ID;
2021: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_next_rec.PRICE_LIST_ID);
2022: END IF; /* NEXT */
2023: END IF;
2024:
2025: /* END PRICE_LIST_ID*/

Line 2042: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);

2038: ind := ind+1;
2039: prior_exists := 'Y';
2040: x_header_changed_attr_tbl(ind).attribute_name := 'SALESREP';
2041: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SALESREP_ID;
2042: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);
2043: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.SALESREP_ID;
2044: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);
2045: END IF;
2046: END IF; /* PRIOR */

Line 2044: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);

2040: x_header_changed_attr_tbl(ind).attribute_name := 'SALESREP';
2041: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SALESREP_ID;
2042: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);
2043: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.SALESREP_ID;
2044: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);
2045: END IF;
2046: END IF; /* PRIOR */
2047: /****************************/
2048: IF p_next_version IS NOT NULL THEN

Line 2053: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);

2049: IF OE_Globals.Equal(
2050: p_curr_rec.SALESREP_ID,
2051: p_next_rec.SALESREP_ID) THEN
2052: IF prior_exists = 'Y' THEN
2053: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);
2054: END IF;
2055: ELSE
2056: IF prior_exists = 'N' THEN
2057: ind := ind+1;

Line 2061: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);

2057: ind := ind+1;
2058: END IF;
2059: x_header_changed_attr_tbl(ind).attribute_name := 'SALESREP';
2060: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.SALESREP_ID;
2061: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);
2062: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SALESREP_ID;
2063: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);
2064: x_header_changed_attr_tbl(ind).next_id := p_next_rec.SALESREP_ID;
2065: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_next_rec.SALESREP_ID);

Line 2063: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);

2059: x_header_changed_attr_tbl(ind).attribute_name := 'SALESREP';
2060: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.SALESREP_ID;
2061: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);
2062: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SALESREP_ID;
2063: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);
2064: x_header_changed_attr_tbl(ind).next_id := p_next_rec.SALESREP_ID;
2065: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_next_rec.SALESREP_ID);
2066: END IF; /* NEXT */
2067: END IF;

Line 2065: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_next_rec.SALESREP_ID);

2061: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);
2062: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SALESREP_ID;
2063: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);
2064: x_header_changed_attr_tbl(ind).next_id := p_next_rec.SALESREP_ID;
2065: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_next_rec.SALESREP_ID);
2066: END IF; /* NEXT */
2067: END IF;
2068:
2069: /* END SALESREP_ID*/

Line 2085: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);

2081: ind := ind+1;
2082: prior_exists := 'Y';
2083: x_header_changed_attr_tbl(ind).attribute_name := 'SHIPPING_METHOD';
2084: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SHIPPING_METHOD_CODE;
2085: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);
2086: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.SHIPPING_METHOD_CODE;
2087: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);
2088: END IF;
2089: END IF; /* PRIOR */

Line 2087: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);

2083: x_header_changed_attr_tbl(ind).attribute_name := 'SHIPPING_METHOD';
2084: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SHIPPING_METHOD_CODE;
2085: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);
2086: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.SHIPPING_METHOD_CODE;
2087: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);
2088: END IF;
2089: END IF; /* PRIOR */
2090: /****************************/
2091: IF p_next_version IS NOT NULL THEN

Line 2096: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);

2092: IF OE_Globals.Equal(
2093: p_curr_rec.SHIPPING_METHOD_CODE,
2094: p_next_rec.SHIPPING_METHOD_CODE) THEN
2095: IF prior_exists = 'Y' THEN
2096: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);
2097: END IF;
2098: ELSE
2099: IF prior_exists = 'N' THEN
2100: ind := ind+1;

Line 2104: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);

2100: ind := ind+1;
2101: END IF;
2102: x_header_changed_attr_tbl(ind).attribute_name := 'SHIPPING_METHOD';
2103: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.SHIPPING_METHOD_CODE;
2104: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);
2105: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SHIPPING_METHOD_CODE;
2106: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);
2107: x_header_changed_attr_tbl(ind).next_id := p_next_rec.SHIPPING_METHOD_CODE;
2108: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_next_rec.SHIPPING_METHOD_CODE);

Line 2106: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);

2102: x_header_changed_attr_tbl(ind).attribute_name := 'SHIPPING_METHOD';
2103: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.SHIPPING_METHOD_CODE;
2104: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);
2105: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SHIPPING_METHOD_CODE;
2106: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);
2107: x_header_changed_attr_tbl(ind).next_id := p_next_rec.SHIPPING_METHOD_CODE;
2108: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_next_rec.SHIPPING_METHOD_CODE);
2109: END IF; /* NEXT */
2110: END IF;

Line 2108: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_next_rec.SHIPPING_METHOD_CODE);

2104: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);
2105: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SHIPPING_METHOD_CODE;
2106: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);
2107: x_header_changed_attr_tbl(ind).next_id := p_next_rec.SHIPPING_METHOD_CODE;
2108: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_next_rec.SHIPPING_METHOD_CODE);
2109: END IF; /* NEXT */
2110: END IF;
2111:
2112: /* END SHIPPING_METHOD_CODE*/

Line 2129: OE_ID_TO_VALUE.ship_from_Org

2125: ind := ind+1;
2126: prior_exists := 'Y';
2127: x_header_changed_attr_tbl(ind).attribute_name := 'Warehouse';
2128: if p_curr_rec.ship_from_org_id is not null then
2129: OE_ID_TO_VALUE.ship_from_Org
2130: ( p_ship_from_org_id => p_curr_rec.ship_from_org_id
2131: , x_ship_from_address1 => x_ship_from_address1
2132: , x_ship_from_address2 => x_ship_from_address2
2133: , x_ship_from_address3 => x_ship_from_address3

Line 2152: OE_ID_TO_VALUE.ship_from_Org

2148: x_header_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
2149:
2150: end if;
2151: if p_prior_rec.ship_from_org_id is not null then
2152: OE_ID_TO_VALUE.ship_from_Org
2153: ( p_ship_from_org_id => p_prior_rec.ship_from_org_id
2154: , x_ship_from_address1 => x_ship_from_address1
2155: , x_ship_from_address2 => x_ship_from_address2
2156: , x_ship_from_address3 => x_ship_from_address3

Line 2191: OE_ID_TO_VALUE.ship_from_Org

2187: END IF;
2188: x_header_changed_attr_tbl(ind).attribute_name := 'Warehouse';
2189:
2190: if p_prior_rec.ship_from_org_id is not null then
2191: OE_ID_TO_VALUE.ship_from_Org
2192: ( p_ship_from_org_id => p_prior_rec.ship_from_org_id
2193: , x_ship_from_address1 => x_ship_from_address1
2194: , x_ship_from_address2 => x_ship_from_address2
2195: , x_ship_from_address3 => x_ship_from_address3

Line 2213: OE_ID_TO_VALUE.ship_from_Org

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;
2212: if p_curr_rec.ship_from_org_id is not null then
2213: OE_ID_TO_VALUE.ship_from_Org
2214: ( p_ship_from_org_id => p_curr_rec.ship_from_org_id
2215: , x_ship_from_address1 => x_ship_from_address1
2216: , x_ship_from_address2 => x_ship_from_address2
2217: , x_ship_from_address3 => x_ship_from_address3

Line 2236: OE_ID_TO_VALUE.ship_from_Org

2232: x_header_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
2233: end if;
2234:
2235: if p_next_rec.ship_from_org_id is not null then
2236: OE_ID_TO_VALUE.ship_from_Org
2237: ( p_ship_from_org_id => p_next_rec.ship_from_org_id
2238: , x_ship_from_address1 => x_ship_from_address1
2239: , x_ship_from_address2 => x_ship_from_address2
2240: , x_ship_from_address3 => x_ship_from_address3

Line 2277: OE_ID_TO_VALUE.ship_to_Org

2273: ind := ind+1;
2274: prior_exists := 'Y';
2275: x_header_changed_attr_tbl(ind).attribute_name := 'ship_to';
2276: if p_curr_rec.ship_to_org_id is not null then
2277: OE_ID_TO_VALUE.ship_to_Org
2278: ( p_ship_to_org_id => p_curr_rec.ship_to_org_id
2279: , x_ship_to_address1 => x_ship_to_address1
2280: , x_ship_to_address2 => x_ship_to_address2
2281: , x_ship_to_address3 => x_ship_to_address3

Line 2308: OE_ID_TO_VALUE.ship_to_Org

2304: x_header_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
2305: end if;
2306:
2307: if p_prior_rec.ship_to_org_id is not null then
2308: OE_ID_TO_VALUE.ship_to_Org
2309: ( p_ship_to_org_id => p_prior_rec.ship_to_org_id
2310: , x_ship_to_address1 => x_ship_to_address1
2311: , x_ship_to_address2 => x_ship_to_address2
2312: , x_ship_to_address3 => x_ship_to_address3

Line 2354: OE_ID_TO_VALUE.ship_to_Org

2350: END IF;
2351: x_header_changed_attr_tbl(ind).attribute_name := 'ship_to';
2352:
2353: if p_prior_rec.ship_to_org_id is not null then
2354: OE_ID_TO_VALUE.ship_to_Org
2355: ( p_ship_to_org_id => p_prior_rec.ship_to_org_id
2356: , x_ship_to_address1 => x_ship_to_address1
2357: , x_ship_to_address2 => x_ship_to_address2
2358: , x_ship_to_address3 => x_ship_to_address3

Line 2384: OE_ID_TO_VALUE.ship_to_Org

2380: x_header_changed_attr_tbl(ind).prior_value := x_prior_ship_to_address;
2381: end if;
2382:
2383: if p_curr_rec.ship_to_org_id is not null then
2384: OE_ID_TO_VALUE.ship_to_Org
2385: ( p_ship_to_org_id => p_curr_rec.ship_to_org_id
2386: , x_ship_to_address1 => x_ship_to_address1
2387: , x_ship_to_address2 => x_ship_to_address2
2388: , x_ship_to_address3 => x_ship_to_address3

Line 2414: OE_ID_TO_VALUE.ship_to_Org

2410: x_header_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
2411: end if;
2412:
2413: if p_next_rec.ship_to_org_id is not null then
2414: OE_ID_TO_VALUE.ship_to_Org
2415: ( p_ship_to_org_id => p_next_rec.ship_to_org_id
2416: , x_ship_to_address1 => x_ship_to_address1
2417: , x_ship_to_address2 => x_ship_to_address2
2418: , x_ship_to_address3 => x_ship_to_address3

Line 2462: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.sold_To_Contact(p_curr_rec.sold_to_contact_id);

2458: ind := ind+1;
2459: prior_exists := 'Y';
2460: x_header_changed_attr_tbl(ind).attribute_name := 'sold_to_contact';
2461: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.sold_to_contact_id;
2462: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.sold_To_Contact(p_curr_rec.sold_to_contact_id);
2463: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.sold_to_contact_id;
2464: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.sold_To_Contact(p_prior_rec.sold_to_contact_id);
2465: END IF;
2466: END IF; /* PRIOR */

Line 2464: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.sold_To_Contact(p_prior_rec.sold_to_contact_id);

2460: x_header_changed_attr_tbl(ind).attribute_name := 'sold_to_contact';
2461: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.sold_to_contact_id;
2462: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.sold_To_Contact(p_curr_rec.sold_to_contact_id);
2463: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.sold_to_contact_id;
2464: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.sold_To_Contact(p_prior_rec.sold_to_contact_id);
2465: END IF;
2466: END IF; /* PRIOR */
2467: /****************************/
2468: IF p_next_version IS NOT NULL THEN

Line 2473: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.sold_To_Contact(p_curr_rec.sold_to_contact_id);

2469: IF OE_Globals.Equal(
2470: p_curr_rec.sold_to_contact_id,
2471: p_next_rec.sold_to_contact_id) THEN
2472: IF prior_exists = 'Y' THEN
2473: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.sold_To_Contact(p_curr_rec.sold_to_contact_id);
2474: END IF;
2475: ELSE
2476: IF prior_exists = 'N' THEN
2477: ind := ind+1;

Line 2481: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.sold_To_Contact(p_prior_rec.sold_to_contact_id);

2477: ind := ind+1;
2478: END IF;
2479: x_header_changed_attr_tbl(ind).attribute_name := 'sold_to_contact';
2480: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.sold_to_contact_id;
2481: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.sold_To_Contact(p_prior_rec.sold_to_contact_id);
2482: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.sold_to_contact_id;
2483: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.sold_To_Contact(p_curr_rec.sold_to_contact_id);
2484: x_header_changed_attr_tbl(ind).next_id := p_next_rec.sold_to_contact_id;
2485: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.sold_To_Contact(p_next_rec.sold_to_contact_id);

Line 2483: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.sold_To_Contact(p_curr_rec.sold_to_contact_id);

2479: x_header_changed_attr_tbl(ind).attribute_name := 'sold_to_contact';
2480: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.sold_to_contact_id;
2481: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.sold_To_Contact(p_prior_rec.sold_to_contact_id);
2482: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.sold_to_contact_id;
2483: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.sold_To_Contact(p_curr_rec.sold_to_contact_id);
2484: x_header_changed_attr_tbl(ind).next_id := p_next_rec.sold_to_contact_id;
2485: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.sold_To_Contact(p_next_rec.sold_to_contact_id);
2486: END IF; /* NEXT */
2487: END IF;

Line 2485: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.sold_To_Contact(p_next_rec.sold_to_contact_id);

2481: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.sold_To_Contact(p_prior_rec.sold_to_contact_id);
2482: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.sold_to_contact_id;
2483: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.sold_To_Contact(p_curr_rec.sold_to_contact_id);
2484: x_header_changed_attr_tbl(ind).next_id := p_next_rec.sold_to_contact_id;
2485: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.sold_To_Contact(p_next_rec.sold_to_contact_id);
2486: END IF; /* NEXT */
2487: END IF;
2488:
2489: /* END sold_to_contact_id*/

Line 2506: OE_ID_TO_VALUE.Sold_To_Org(p_sold_to_org_id => p_curr_rec.SOLD_TO_ORG_ID,

2502: ind := ind+1;
2503: prior_exists := 'Y';
2504: x_header_changed_attr_tbl(ind).attribute_name := 'SOLD_TO';
2505: If p_curr_rec.sold_to_org_id is not NULL THEN
2506: OE_ID_TO_VALUE.Sold_To_Org(p_sold_to_org_id => p_curr_rec.SOLD_TO_ORG_ID,
2507: x_org => x_current_customer_name,
2508: x_customer_number=> x_customer_number);
2509: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SOLD_TO_ORG_ID;
2510: x_header_changed_attr_tbl(ind).current_value := x_current_customer_name;

Line 2513: OE_ID_TO_VALUE.Sold_To_Org(p_sold_to_org_id => p_prior_rec.SOLD_TO_ORG_ID,

2509: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SOLD_TO_ORG_ID;
2510: x_header_changed_attr_tbl(ind).current_value := x_current_customer_name;
2511: END IF;
2512: If p_prior_rec.sold_to_org_id is not NULL THEN
2513: OE_ID_TO_VALUE.Sold_To_Org(p_sold_to_org_id => p_prior_rec.SOLD_TO_ORG_ID,
2514: x_org => x_prior_customer_name,
2515: x_customer_number=> x_customer_number);
2516: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.SOLD_TO_ORG_ID;
2517: x_header_changed_attr_tbl(ind).prior_value := x_prior_customer_name;

Line 2535: OE_ID_TO_VALUE.Sold_To_Org(p_sold_to_org_id => p_prior_rec.SOLD_TO_ORG_ID,

2531: ind := ind+1;
2532: END IF;
2533: x_header_changed_attr_tbl(ind).attribute_name := 'SOLD_TO';
2534: If p_prior_rec.sold_to_org_id is not NULL THEN
2535: OE_ID_TO_VALUE.Sold_To_Org(p_sold_to_org_id => p_prior_rec.SOLD_TO_ORG_ID,
2536: x_org => x_prior_customer_name,
2537: x_customer_number=> x_customer_number);
2538: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.SOLD_TO_ORG_ID;
2539: x_header_changed_attr_tbl(ind).prior_value := x_prior_customer_name;

Line 2542: OE_ID_TO_VALUE.Sold_To_Org(p_sold_to_org_id => p_curr_rec.SOLD_TO_ORG_ID,

2538: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.SOLD_TO_ORG_ID;
2539: x_header_changed_attr_tbl(ind).prior_value := x_prior_customer_name;
2540: END IF;
2541: If p_curr_rec.sold_to_org_id is not NULL THEN
2542: OE_ID_TO_VALUE.Sold_To_Org(p_sold_to_org_id => p_curr_rec.SOLD_TO_ORG_ID,
2543: x_org => x_current_customer_name,
2544: x_customer_number=> x_customer_number);
2545: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SOLD_TO_ORG_ID;
2546: x_header_changed_attr_tbl(ind).current_value := x_current_customer_name;

Line 2549: OE_ID_TO_VALUE.Sold_To_Org(p_sold_to_org_id => p_next_rec.SOLD_TO_ORG_ID,

2545: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.SOLD_TO_ORG_ID;
2546: x_header_changed_attr_tbl(ind).current_value := x_current_customer_name;
2547: END IF;
2548: If p_next_rec.sold_to_org_id is not NULL THEN
2549: OE_ID_TO_VALUE.Sold_To_Org(p_sold_to_org_id => p_next_rec.SOLD_TO_ORG_ID,
2550: x_org => x_next_customer_name,
2551: x_customer_number=> x_customer_number);
2552: x_header_changed_attr_tbl(ind).next_id := p_next_rec.SOLD_TO_ORG_ID;
2553: x_header_changed_attr_tbl(ind).next_value := x_next_customer_name;

Line 2692: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.flow_status(p_curr_rec.flow_status_code);

2688: ind := ind+1;
2689: prior_exists := 'Y';
2690: x_header_changed_attr_tbl(ind).attribute_name := 'flow_status';
2691: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.flow_status_code;
2692: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.flow_status(p_curr_rec.flow_status_code);
2693: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.flow_status_code;
2694: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.flow_status(p_prior_rec.flow_status_code);
2695: END IF;
2696: END IF; /* PRIOR */

Line 2694: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.flow_status(p_prior_rec.flow_status_code);

2690: x_header_changed_attr_tbl(ind).attribute_name := 'flow_status';
2691: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.flow_status_code;
2692: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.flow_status(p_curr_rec.flow_status_code);
2693: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.flow_status_code;
2694: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.flow_status(p_prior_rec.flow_status_code);
2695: END IF;
2696: END IF; /* PRIOR */
2697: /****************************/
2698: IF p_next_version IS NOT NULL THEN

Line 2703: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.flow_status(p_curr_rec.flow_status_code);

2699: IF OE_Globals.Equal(
2700: p_curr_rec.flow_status_code,
2701: p_next_rec.flow_status_code) THEN
2702: IF prior_exists = 'Y' THEN
2703: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.flow_status(p_curr_rec.flow_status_code);
2704: END IF;
2705: ELSE
2706: IF prior_exists = 'N' THEN
2707: ind := ind+1;

Line 2711: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.flow_status(p_prior_rec.flow_status_code);

2707: ind := ind+1;
2708: END IF;
2709: x_header_changed_attr_tbl(ind).attribute_name := 'flow_status';
2710: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.flow_status_code;
2711: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.flow_status(p_prior_rec.flow_status_code);
2712: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.flow_status_code;
2713: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.flow_status(p_curr_rec.flow_status_code);
2714: x_header_changed_attr_tbl(ind).next_id := p_next_rec.flow_status_code;
2715: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.flow_status(p_next_rec.flow_status_code);

Line 2713: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.flow_status(p_curr_rec.flow_status_code);

2709: x_header_changed_attr_tbl(ind).attribute_name := 'flow_status';
2710: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.flow_status_code;
2711: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.flow_status(p_prior_rec.flow_status_code);
2712: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.flow_status_code;
2713: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.flow_status(p_curr_rec.flow_status_code);
2714: x_header_changed_attr_tbl(ind).next_id := p_next_rec.flow_status_code;
2715: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.flow_status(p_next_rec.flow_status_code);
2716: END IF;
2717: END IF; /* NEXT */

Line 2715: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.flow_status(p_next_rec.flow_status_code);

2711: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.flow_status(p_prior_rec.flow_status_code);
2712: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.flow_status_code;
2713: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.flow_status(p_curr_rec.flow_status_code);
2714: x_header_changed_attr_tbl(ind).next_id := p_next_rec.flow_status_code;
2715: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.flow_status(p_next_rec.flow_status_code);
2716: END IF;
2717: END IF; /* NEXT */
2718:
2719: /* END flow_status_code*/

Line 2774: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Transaction_Phase(p_curr_rec.transaction_phase_code);

2770: ind := ind+1;
2771: prior_exists := 'Y';
2772: x_header_changed_attr_tbl(ind).attribute_name := 'transaction_phase';
2773: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.transaction_phase_code;
2774: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Transaction_Phase(p_curr_rec.transaction_phase_code);
2775: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.transaction_phase_code;
2776: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Transaction_Phase(p_prior_rec.transaction_phase_code);
2777: END IF;
2778: END IF; /* PRIOR */

Line 2776: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Transaction_Phase(p_prior_rec.transaction_phase_code);

2772: x_header_changed_attr_tbl(ind).attribute_name := 'transaction_phase';
2773: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.transaction_phase_code;
2774: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Transaction_Phase(p_curr_rec.transaction_phase_code);
2775: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.transaction_phase_code;
2776: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Transaction_Phase(p_prior_rec.transaction_phase_code);
2777: END IF;
2778: END IF; /* PRIOR */
2779: /****************************/
2780: IF p_next_version IS NOT NULL THEN

Line 2785: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Transaction_Phase(p_curr_rec.transaction_phase_code);

2781: IF OE_Globals.Equal(
2782: p_curr_rec.transaction_phase_code,
2783: p_next_rec.transaction_phase_code) THEN
2784: IF prior_exists = 'Y' THEN
2785: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Transaction_Phase(p_curr_rec.transaction_phase_code);
2786: END IF;
2787: ELSE
2788: IF prior_exists = 'N' THEN
2789: ind := ind+1;

Line 2793: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Transaction_Phase(p_prior_rec.transaction_phase_code);

2789: ind := ind+1;
2790: END IF;
2791: x_header_changed_attr_tbl(ind).attribute_name := 'transaction_phase';
2792: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.transaction_phase_code;
2793: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Transaction_Phase(p_prior_rec.transaction_phase_code);
2794: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.transaction_phase_code;
2795: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Transaction_Phase(p_curr_rec.transaction_phase_code);
2796: x_header_changed_attr_tbl(ind).next_id := p_next_rec.transaction_phase_code;
2797: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Transaction_Phase(p_next_rec.transaction_phase_code);

Line 2795: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Transaction_Phase(p_curr_rec.transaction_phase_code);

2791: x_header_changed_attr_tbl(ind).attribute_name := 'transaction_phase';
2792: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.transaction_phase_code;
2793: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Transaction_Phase(p_prior_rec.transaction_phase_code);
2794: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.transaction_phase_code;
2795: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Transaction_Phase(p_curr_rec.transaction_phase_code);
2796: x_header_changed_attr_tbl(ind).next_id := p_next_rec.transaction_phase_code;
2797: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Transaction_Phase(p_next_rec.transaction_phase_code);
2798: END IF; /* NEXT */
2799: END IF;

Line 2797: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Transaction_Phase(p_next_rec.transaction_phase_code);

2793: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Transaction_Phase(p_prior_rec.transaction_phase_code);
2794: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.transaction_phase_code;
2795: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Transaction_Phase(p_curr_rec.transaction_phase_code);
2796: x_header_changed_attr_tbl(ind).next_id := p_next_rec.transaction_phase_code;
2797: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Transaction_Phase(p_next_rec.transaction_phase_code);
2798: END IF; /* NEXT */
2799: END IF;
2800:
2801: /* END transaction_phase_code*/

Line 2817: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.User_Status(p_curr_rec.user_status_code);

2813: ind := ind+1;
2814: prior_exists := 'Y';
2815: x_header_changed_attr_tbl(ind).attribute_name := 'user_status';
2816: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.user_status_code;
2817: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.User_Status(p_curr_rec.user_status_code);
2818: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.user_status_code;
2819: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.User_Status(p_prior_rec.user_status_code);
2820: END IF;
2821: END IF; /* PRIOR */

Line 2819: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.User_Status(p_prior_rec.user_status_code);

2815: x_header_changed_attr_tbl(ind).attribute_name := 'user_status';
2816: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.user_status_code;
2817: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.User_Status(p_curr_rec.user_status_code);
2818: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.user_status_code;
2819: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.User_Status(p_prior_rec.user_status_code);
2820: END IF;
2821: END IF; /* PRIOR */
2822: /****************************/
2823: IF p_next_version IS NOT NULL THEN

Line 2828: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.User_Status(p_curr_rec.user_status_code);

2824: IF OE_Globals.Equal(
2825: p_curr_rec.user_status_code,
2826: p_next_rec.user_status_code) THEN
2827: IF prior_exists = 'Y' THEN
2828: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.User_Status(p_curr_rec.user_status_code);
2829: END IF;
2830: ELSE
2831: IF prior_exists = 'N' THEN
2832: ind := ind+1;

Line 2836: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.User_Status(p_prior_rec.user_status_code);

2832: ind := ind+1;
2833: END IF;
2834: x_header_changed_attr_tbl(ind).attribute_name := 'user_status';
2835: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.user_status_code;
2836: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.User_Status(p_prior_rec.user_status_code);
2837: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.user_status_code;
2838: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.User_Status(p_curr_rec.user_status_code);
2839: x_header_changed_attr_tbl(ind).next_id := p_next_rec.user_status_code;
2840: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.User_Status(p_next_rec.user_status_code);

Line 2838: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.User_Status(p_curr_rec.user_status_code);

2834: x_header_changed_attr_tbl(ind).attribute_name := 'user_status';
2835: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.user_status_code;
2836: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.User_Status(p_prior_rec.user_status_code);
2837: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.user_status_code;
2838: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.User_Status(p_curr_rec.user_status_code);
2839: x_header_changed_attr_tbl(ind).next_id := p_next_rec.user_status_code;
2840: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.User_Status(p_next_rec.user_status_code);
2841: END IF; /* NEXT */
2842: END IF;

Line 2840: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.User_Status(p_next_rec.user_status_code);

2836: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.User_Status(p_prior_rec.user_status_code);
2837: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.user_status_code;
2838: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.User_Status(p_curr_rec.user_status_code);
2839: x_header_changed_attr_tbl(ind).next_id := p_next_rec.user_status_code;
2840: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.User_Status(p_next_rec.user_status_code);
2841: END IF; /* NEXT */
2842: END IF;
2843:
2844: /* END user_status_code*/

Line 2863: OE_ID_TO_VALUE.Customer_Location

2859: ind := ind+1;
2860: prior_exists := 'Y';
2861: x_header_changed_attr_tbl(ind).attribute_name := 'Customer_Location';
2862: if p_curr_rec.sold_to_site_use_id is not null then
2863: OE_ID_TO_VALUE.Customer_Location
2864: ( p_sold_to_site_use_id => p_curr_rec.sold_to_site_use_id
2865: , x_sold_to_location_address1 => x_sold_to_location_address1
2866: , x_sold_to_location_address2 => x_sold_to_location_address2
2867: , x_sold_to_location_address3 => x_sold_to_location_address3

Line 2893: OE_ID_TO_VALUE.Customer_Location

2889: x_header_changed_attr_tbl(ind).current_value := x_current_sold_to_location;
2890:
2891: end if;
2892: if p_prior_rec.sold_to_site_use_id is not null then
2893: OE_ID_TO_VALUE.Customer_Location
2894: ( p_sold_to_site_use_id => p_prior_rec.sold_to_site_use_id
2895: , x_sold_to_location_address1 => x_sold_to_location_address1
2896: , x_sold_to_location_address2 => x_sold_to_location_address2
2897: , x_sold_to_location_address3 => x_sold_to_location_address3

Line 2938: OE_ID_TO_VALUE.customer_location

2934: END IF;
2935: x_header_changed_attr_tbl(ind).attribute_name := 'customer_location';
2936:
2937: if p_prior_rec.sold_to_site_use_id is not null then
2938: OE_ID_TO_VALUE.customer_location
2939: ( p_sold_to_site_use_id => p_prior_rec.sold_to_site_use_id
2940: , x_sold_to_location_address1 => x_sold_to_location_address1
2941: , x_sold_to_location_address2 => x_sold_to_location_address2
2942: , x_sold_to_location_address3 => x_sold_to_location_address3

Line 2967: OE_ID_TO_VALUE.customer_location

2963: x_header_changed_attr_tbl(ind).prior_value := x_prior_sold_to_location;
2964: end if;
2965:
2966: if p_curr_rec.sold_to_site_use_id is not null then
2967: OE_ID_TO_VALUE.customer_location
2968: ( p_sold_to_site_use_id => p_curr_rec.sold_to_site_use_id
2969: , x_sold_to_location_address1 => x_sold_to_location_address1
2970: , x_sold_to_location_address2 => x_sold_to_location_address2
2971: , x_sold_to_location_address3 => x_sold_to_location_address3

Line 2996: OE_ID_TO_VALUE.customer_location

2992: x_header_changed_attr_tbl(ind).current_value := x_current_sold_to_location;
2993: end if;
2994:
2995: if p_next_rec.sold_to_site_use_id is not null then
2996: OE_ID_TO_VALUE.customer_location
2997: ( p_sold_to_site_use_id => p_next_rec.sold_to_site_use_id
2998: , x_sold_to_location_address1 => x_sold_to_location_address1
2999: , x_sold_to_location_address2 => x_sold_to_location_address2
3000: , x_sold_to_location_address3 => x_sold_to_location_address3

Line 3859: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.NEW_PRICE_LIST_ID);

3855: ind := ind+1;
3856: prior_exists := 'Y';
3857: x_header_changed_attr_tbl(ind).attribute_name := 'NEW_PRICE_LIST_NAME';
3858: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.NEW_PRICE_LIST_ID;
3859: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.NEW_PRICE_LIST_ID);
3860: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.NEW_PRICE_LIST_ID;
3861: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.NEW_PRICE_LIST_ID);
3862: END IF;
3863: END IF; /* PRIOR */

Line 3861: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.NEW_PRICE_LIST_ID);

3857: x_header_changed_attr_tbl(ind).attribute_name := 'NEW_PRICE_LIST_NAME';
3858: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.NEW_PRICE_LIST_ID;
3859: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.NEW_PRICE_LIST_ID);
3860: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.NEW_PRICE_LIST_ID;
3861: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.NEW_PRICE_LIST_ID);
3862: END IF;
3863: END IF; /* PRIOR */
3864: /****************************/
3865: IF p_next_version IS NOT NULL THEN

Line 3870: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.NEW_PRICE_LIST_ID);

3866: IF OE_Globals.Equal(
3867: p_curr_rec.NEW_PRICE_LIST_ID,
3868: p_next_rec.NEW_PRICE_LIST_ID) THEN
3869: IF prior_exists = 'Y' THEN
3870: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.NEW_PRICE_LIST_ID);
3871: END IF;
3872: ELSE
3873: IF prior_exists = 'N' THEN
3874: ind := ind+1;

Line 3878: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.NEW_PRICE_LIST_ID);

3874: ind := ind+1;
3875: END IF;
3876: x_header_changed_attr_tbl(ind).attribute_name := 'NEW_PRICE_LIST_NAME';
3877: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.NEW_PRICE_LIST_ID;
3878: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.NEW_PRICE_LIST_ID);
3879: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.NEW_PRICE_LIST_ID;
3880: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.NEW_PRICE_LIST_ID);
3881: x_header_changed_attr_tbl(ind).next_id := p_next_rec.NEW_PRICE_LIST_ID;
3882: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_next_rec.NEW_PRICE_LIST_ID);

Line 3880: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.NEW_PRICE_LIST_ID);

3876: x_header_changed_attr_tbl(ind).attribute_name := 'NEW_PRICE_LIST_NAME';
3877: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.NEW_PRICE_LIST_ID;
3878: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.NEW_PRICE_LIST_ID);
3879: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.NEW_PRICE_LIST_ID;
3880: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.NEW_PRICE_LIST_ID);
3881: x_header_changed_attr_tbl(ind).next_id := p_next_rec.NEW_PRICE_LIST_ID;
3882: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_next_rec.NEW_PRICE_LIST_ID);
3883: END IF; /* NEXT */
3884: END IF;

Line 3882: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_next_rec.NEW_PRICE_LIST_ID);

3878: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.NEW_PRICE_LIST_ID);
3879: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.NEW_PRICE_LIST_ID;
3880: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.NEW_PRICE_LIST_ID);
3881: x_header_changed_attr_tbl(ind).next_id := p_next_rec.NEW_PRICE_LIST_ID;
3882: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_next_rec.NEW_PRICE_LIST_ID);
3883: END IF; /* NEXT */
3884: END IF;
3885:
3886: /* END NEW_PRICE_LIST_ID*/

Line 3903: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_curr_rec.NEW_MODIFIER_LIST_ID);

3899: ind := ind+1;
3900: prior_exists := 'Y';
3901: x_header_changed_attr_tbl(ind).attribute_name := 'NEW_MODIFIER_LIST_NAME';
3902: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.NEW_MODIFIER_LIST_ID;
3903: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_curr_rec.NEW_MODIFIER_LIST_ID);
3904: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.NEW_MODIFIER_LIST_ID;
3905: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_prior_rec.NEW_MODIFIER_LIST_ID);
3906: END IF;
3907: END IF; /* PRIOR */

Line 3905: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_prior_rec.NEW_MODIFIER_LIST_ID);

3901: x_header_changed_attr_tbl(ind).attribute_name := 'NEW_MODIFIER_LIST_NAME';
3902: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.NEW_MODIFIER_LIST_ID;
3903: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_curr_rec.NEW_MODIFIER_LIST_ID);
3904: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.NEW_MODIFIER_LIST_ID;
3905: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_prior_rec.NEW_MODIFIER_LIST_ID);
3906: END IF;
3907: END IF; /* PRIOR */
3908: /****************************/
3909: IF p_next_version IS NOT NULL THEN

Line 3914: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_curr_rec.NEW_MODIFIER_LIST_ID);

3910: IF OE_Globals.Equal(
3911: p_curr_rec.NEW_MODIFIER_LIST_ID,
3912: p_next_rec.NEW_MODIFIER_LIST_ID) THEN
3913: IF prior_exists = 'Y' THEN
3914: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_curr_rec.NEW_MODIFIER_LIST_ID);
3915: END IF;
3916: ELSE
3917: IF prior_exists = 'N' THEN
3918: ind := ind+1;

Line 3922: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_prior_rec.NEW_MODIFIER_LIST_ID);

3918: ind := ind+1;
3919: END IF;
3920: x_header_changed_attr_tbl(ind).attribute_name := 'NEW_MODIFIER_LIST_NAME';
3921: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.NEW_MODIFIER_LIST_ID;
3922: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_prior_rec.NEW_MODIFIER_LIST_ID);
3923: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.NEW_MODIFIER_LIST_ID;
3924: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_curr_rec.NEW_MODIFIER_LIST_ID);
3925: x_header_changed_attr_tbl(ind).next_id := p_next_rec.NEW_MODIFIER_LIST_ID;
3926: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_next_rec.NEW_MODIFIER_LIST_ID);

Line 3924: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_curr_rec.NEW_MODIFIER_LIST_ID);

3920: x_header_changed_attr_tbl(ind).attribute_name := 'NEW_MODIFIER_LIST_NAME';
3921: x_header_changed_attr_tbl(ind).prior_id := p_prior_rec.NEW_MODIFIER_LIST_ID;
3922: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_prior_rec.NEW_MODIFIER_LIST_ID);
3923: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.NEW_MODIFIER_LIST_ID;
3924: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_curr_rec.NEW_MODIFIER_LIST_ID);
3925: x_header_changed_attr_tbl(ind).next_id := p_next_rec.NEW_MODIFIER_LIST_ID;
3926: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_next_rec.NEW_MODIFIER_LIST_ID);
3927: END IF; /* NEXT */
3928: END IF;

Line 3926: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_next_rec.NEW_MODIFIER_LIST_ID);

3922: x_header_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_prior_rec.NEW_MODIFIER_LIST_ID);
3923: x_header_changed_attr_tbl(ind).current_id := p_curr_rec.NEW_MODIFIER_LIST_ID;
3924: x_header_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_curr_rec.NEW_MODIFIER_LIST_ID);
3925: x_header_changed_attr_tbl(ind).next_id := p_next_rec.NEW_MODIFIER_LIST_ID;
3926: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_next_rec.NEW_MODIFIER_LIST_ID);
3927: END IF; /* NEXT */
3928: END IF;
3929:
3930: /* END NEW_MODIFIER_LIST_ID*/

Line 4729: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);

4725: prior_exists := 'Y';
4726: x_line_changed_attr_tbl(ind).attribute_name := 'accounting_rule';
4727: x_line_changed_attr_tbl(ind).line_number := x_line_number;
4728: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.accounting_rule_id;
4729: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);
4730: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.accounting_rule_id;
4731: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);
4732: END IF;
4733: END IF; /* PRIOR */

Line 4731: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);

4727: x_line_changed_attr_tbl(ind).line_number := x_line_number;
4728: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.accounting_rule_id;
4729: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);
4730: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.accounting_rule_id;
4731: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);
4732: END IF;
4733: END IF; /* PRIOR */
4734: /****************************/
4735: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN

Line 4740: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);

4736: IF OE_Globals.Equal(
4737: p_curr_rec.accounting_rule_id,
4738: p_next_rec.accounting_rule_id) THEN
4739: IF prior_exists = 'Y' THEN
4740: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);
4741: END IF;
4742: ELSE
4743: IF prior_exists = 'N' THEN
4744: ind := ind+1;

Line 4749: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);

4745: END IF;
4746: x_line_changed_attr_tbl(ind).attribute_name := 'accounting_rule';
4747: x_line_changed_attr_tbl(ind).line_number := x_line_number;
4748: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.accounting_rule_id;
4749: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);
4750: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.accounting_rule_id;
4751: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);
4752: x_line_changed_attr_tbl(ind).next_id := p_next_rec.accounting_rule_id;
4753: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_next_rec.accounting_rule_id);

Line 4751: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);

4747: x_line_changed_attr_tbl(ind).line_number := x_line_number;
4748: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.accounting_rule_id;
4749: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);
4750: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.accounting_rule_id;
4751: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);
4752: x_line_changed_attr_tbl(ind).next_id := p_next_rec.accounting_rule_id;
4753: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_next_rec.accounting_rule_id);
4754: END IF;
4755: END IF; /* NEXT */

Line 4753: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_next_rec.accounting_rule_id);

4749: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Accounting_rule(p_prior_rec.accounting_rule_id);
4750: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.accounting_rule_id;
4751: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);
4752: x_line_changed_attr_tbl(ind).next_id := p_next_rec.accounting_rule_id;
4753: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_next_rec.accounting_rule_id);
4754: END IF;
4755: END IF; /* NEXT */
4756:
4757: /* END ACCOUNTING_RULE_ID*/

Line 4775: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);

4771: prior_exists := 'Y';
4772: x_line_changed_attr_tbl(ind).attribute_name := 'agreement';
4773: x_line_changed_attr_tbl(ind).line_number := x_line_number;
4774: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.agreement_id;
4775: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);
4776: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.agreement_id;
4777: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);
4778: END IF;
4779: END IF; /* PRIOR */

Line 4777: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);

4773: x_line_changed_attr_tbl(ind).line_number := x_line_number;
4774: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.agreement_id;
4775: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);
4776: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.agreement_id;
4777: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);
4778: END IF;
4779: END IF; /* PRIOR */
4780: /****************************/
4781: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN

Line 4786: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);

4782: IF OE_Globals.Equal(
4783: p_curr_rec.agreement_id,
4784: p_next_rec.agreement_id) THEN
4785: IF prior_exists = 'Y' THEN
4786: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);
4787: END IF;
4788: ELSE
4789: IF prior_exists = 'N' THEN
4790: ind := ind+1;

Line 4795: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);

4791: END IF;
4792: x_line_changed_attr_tbl(ind).attribute_name := 'agreement';
4793: x_line_changed_attr_tbl(ind).line_number := x_line_number;
4794: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.agreement_id;
4795: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);
4796: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.agreement_id;
4797: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);
4798: x_line_changed_attr_tbl(ind).next_id := p_next_rec.agreement_id;
4799: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_next_rec.agreement_id);

Line 4797: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);

4793: x_line_changed_attr_tbl(ind).line_number := x_line_number;
4794: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.agreement_id;
4795: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);
4796: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.agreement_id;
4797: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);
4798: x_line_changed_attr_tbl(ind).next_id := p_next_rec.agreement_id;
4799: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_next_rec.agreement_id);
4800: END IF;
4801: END IF; /* NEXT */

Line 4799: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_next_rec.agreement_id);

4795: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Agreement(p_prior_rec.agreement_id);
4796: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.agreement_id;
4797: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);
4798: x_line_changed_attr_tbl(ind).next_id := p_next_rec.agreement_id;
4799: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_next_rec.agreement_id);
4800: END IF;
4801: END IF; /* NEXT */
4802:
4803: /* END agreement_id*/

Line 5513: OE_ID_TO_VALUE.deliver_To_Org

5509: prior_exists := 'Y';
5510: x_line_changed_attr_tbl(ind).attribute_name := 'deliver_to';
5511: x_line_changed_attr_tbl(ind).line_number := x_line_number;
5512: if p_curr_rec.deliver_to_org_id is not null then
5513: OE_ID_TO_VALUE.deliver_To_Org
5514: ( p_deliver_to_org_id => p_curr_rec.deliver_To_org_id
5515: , x_deliver_to_address1 => x_deliver_to_address1
5516: , x_deliver_to_address2 => x_deliver_to_address2
5517: , x_deliver_to_address3 => x_deliver_to_address3

Line 5544: OE_ID_TO_VALUE.deliver_To_Org

5540: x_line_changed_attr_tbl(ind).current_value := x_current_deliver_to_address;
5541:
5542: end if;
5543: if p_prior_rec.deliver_to_org_id is not null then
5544: OE_ID_TO_VALUE.deliver_To_Org
5545: ( p_deliver_to_org_id => p_prior_rec.deliver_To_org_id
5546: , x_deliver_to_address1 => x_deliver_to_address1
5547: , x_deliver_to_address2 => x_deliver_to_address2
5548: , x_deliver_to_address3 => x_deliver_to_address3

Line 5591: OE_ID_TO_VALUE.deliver_To_Org

5587: x_line_changed_attr_tbl(ind).attribute_name := 'deliver_to';
5588: x_line_changed_attr_tbl(ind).line_number := x_line_number;
5589:
5590: if p_prior_rec.deliver_to_org_id is not null then
5591: OE_ID_TO_VALUE.deliver_To_Org
5592: ( p_deliver_to_org_id => p_prior_rec.deliver_To_org_id
5593: , x_deliver_to_address1 => x_deliver_to_address1
5594: , x_deliver_to_address2 => x_deliver_to_address2
5595: , x_deliver_to_address3 => x_deliver_to_address3

Line 5621: OE_ID_TO_VALUE.deliver_To_Org

5617: x_line_changed_attr_tbl(ind).prior_value := x_prior_deliver_to_address;
5618:
5619: end if;
5620: if p_curr_rec.deliver_to_org_id is not null then
5621: OE_ID_TO_VALUE.deliver_To_Org
5622: ( p_deliver_to_org_id => p_curr_rec.deliver_To_org_id
5623: , x_deliver_to_address1 => x_deliver_to_address1
5624: , x_deliver_to_address2 => x_deliver_to_address2
5625: , x_deliver_to_address3 => x_deliver_to_address3

Line 5651: OE_ID_TO_VALUE.deliver_To_Org

5647: x_line_changed_attr_tbl(ind).current_value := x_current_deliver_to_address;
5648: end if;
5649:
5650: if p_next_rec.deliver_to_org_id is not null then
5651: OE_ID_TO_VALUE.deliver_To_Org
5652: ( p_deliver_to_org_id => p_next_rec.deliver_To_org_id
5653: , x_deliver_to_address1 => x_deliver_to_address1
5654: , x_deliver_to_address2 => x_deliver_to_address2
5655: , x_deliver_to_address3 => x_deliver_to_address3

Line 5701: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);

5697: prior_exists := 'Y';
5698: x_line_changed_attr_tbl(ind).attribute_name := 'freight_terms';
5699: x_line_changed_attr_tbl(ind).line_number := x_line_number;
5700: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.freight_terms_code;
5701: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);
5702: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.freight_terms_code;
5703: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);
5704: END IF;
5705: END IF; /* PRIOR */

Line 5703: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);

5699: x_line_changed_attr_tbl(ind).line_number := x_line_number;
5700: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.freight_terms_code;
5701: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);
5702: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.freight_terms_code;
5703: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);
5704: END IF;
5705: END IF; /* PRIOR */
5706: /****************************/
5707: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN

Line 5712: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);

5708: IF OE_Globals.Equal(
5709: p_curr_rec.freight_terms_code,
5710: p_next_rec.freight_terms_code) THEN
5711: IF prior_exists = 'Y' THEN
5712: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);
5713: END IF;
5714: ELSE
5715: IF prior_exists = 'N' THEN
5716: ind := ind+1;

Line 5721: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);

5717: END IF;
5718: x_line_changed_attr_tbl(ind).attribute_name := 'freight_terms';
5719: x_line_changed_attr_tbl(ind).line_number := x_line_number;
5720: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.freight_terms_code;
5721: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);
5722: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.freight_terms_code;
5723: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);
5724: x_line_changed_attr_tbl(ind).next_id := p_next_rec.freight_terms_code;
5725: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_next_rec.freight_terms_code);

Line 5723: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);

5719: x_line_changed_attr_tbl(ind).line_number := x_line_number;
5720: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.freight_terms_code;
5721: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);
5722: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.freight_terms_code;
5723: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);
5724: x_line_changed_attr_tbl(ind).next_id := p_next_rec.freight_terms_code;
5725: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_next_rec.freight_terms_code);
5726: END IF;
5727: END IF; /* NEXT */

Line 5725: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_next_rec.freight_terms_code);

5721: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Freight_terms(p_prior_rec.freight_terms_code);
5722: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.freight_terms_code;
5723: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);
5724: x_line_changed_attr_tbl(ind).next_id := p_next_rec.freight_terms_code;
5725: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_next_rec.freight_terms_code);
5726: END IF;
5727: END IF; /* NEXT */
5728:
5729: /* END freight_terms_code*/

Line 5830: OE_ID_TO_VALUE.invoice_to_Org

5826: x_line_changed_attr_tbl(ind).attribute_name := 'invoice_to';
5827: x_line_changed_attr_tbl(ind).line_number := x_line_number;
5828: if p_curr_rec.invoice_to_org_id is not null then
5829:
5830: OE_ID_TO_VALUE.invoice_to_Org
5831: ( p_invoice_to_org_id => p_curr_rec.invoice_to_org_id
5832: , x_invoice_to_address1 => x_invoice_to_address1
5833: , x_invoice_to_address2 => x_invoice_to_address2
5834: , x_invoice_to_address3 => x_invoice_to_address3

Line 5861: OE_ID_TO_VALUE.invoice_to_Org

5857: x_line_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
5858: end if;
5859:
5860: if p_prior_rec.invoice_to_org_id is not null then
5861: OE_ID_TO_VALUE.invoice_to_Org
5862: ( p_invoice_to_org_id => p_prior_rec.invoice_to_org_id
5863: , x_invoice_to_address1 => x_invoice_to_address1
5864: , x_invoice_to_address2 => x_invoice_to_address2
5865: , x_invoice_to_address3 => x_invoice_to_address3

Line 5908: OE_ID_TO_VALUE.invoice_to_Org

5904: x_line_changed_attr_tbl(ind).attribute_name := 'invoice_to';
5905: x_line_changed_attr_tbl(ind).line_number := x_line_number;
5906:
5907: if p_prior_rec.invoice_to_org_id is not null then
5908: OE_ID_TO_VALUE.invoice_to_Org
5909: ( p_invoice_to_org_id => p_prior_rec.invoice_to_org_id
5910: , x_invoice_to_address1 => x_invoice_to_address1
5911: , x_invoice_to_address2 => x_invoice_to_address2
5912: , x_invoice_to_address3 => x_invoice_to_address3

Line 5938: OE_ID_TO_VALUE.invoice_to_Org

5934: x_line_changed_attr_tbl(ind).prior_value := x_prior_invoice_to_address;
5935: end if;
5936:
5937: if p_curr_rec.invoice_to_org_id is not null then
5938: OE_ID_TO_VALUE.invoice_to_Org
5939: ( p_invoice_to_org_id => p_curr_rec.invoice_to_org_id
5940: , x_invoice_to_address1 => x_invoice_to_address1
5941: , x_invoice_to_address2 => x_invoice_to_address2
5942: , x_invoice_to_address3 => x_invoice_to_address3

Line 5968: OE_ID_TO_VALUE.invoice_to_Org

5964: x_line_changed_attr_tbl(ind).current_value := x_current_invoice_to_address;
5965: end if;
5966:
5967: if p_next_rec.invoice_to_org_id is not null then
5968: OE_ID_TO_VALUE.invoice_to_Org
5969: ( p_invoice_to_org_id => p_next_rec.invoice_to_org_id
5970: , x_invoice_to_address1 => x_invoice_to_address1
5971: , x_invoice_to_address2 => x_invoice_to_address2
5972: , x_invoice_to_address3 => x_invoice_to_address3

Line 6017: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);

6013: prior_exists := 'Y';
6014: x_line_changed_attr_tbl(ind).attribute_name := 'invoicing_rule';
6015: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6016: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.invoicing_rule_id;
6017: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);
6018: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.invoicing_rule_id;
6019: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);
6020: END IF;
6021: END IF; /* PRIOR */

Line 6019: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);

6015: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6016: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.invoicing_rule_id;
6017: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);
6018: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.invoicing_rule_id;
6019: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);
6020: END IF;
6021: END IF; /* PRIOR */
6022: /****************************/
6023: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN

Line 6028: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);

6024: IF OE_Globals.Equal(
6025: p_curr_rec.invoicing_rule_id,
6026: p_next_rec.invoicing_rule_id) THEN
6027: IF prior_exists = 'Y' THEN
6028: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);
6029: END IF;
6030: ELSE
6031: IF prior_exists = 'N' THEN
6032: ind := ind+1;

Line 6037: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);

6033: END IF;
6034: x_line_changed_attr_tbl(ind).attribute_name := 'invoicing_rule';
6035: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6036: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.invoicing_rule_id;
6037: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);
6038: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.invoicing_rule_id;
6039: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);
6040: x_line_changed_attr_tbl(ind).next_id := p_next_rec.invoicing_rule_id;
6041: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_next_rec.invoicing_rule_id);

Line 6039: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);

6035: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6036: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.invoicing_rule_id;
6037: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);
6038: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.invoicing_rule_id;
6039: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);
6040: x_line_changed_attr_tbl(ind).next_id := p_next_rec.invoicing_rule_id;
6041: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_next_rec.invoicing_rule_id);
6042: END IF;
6043: END IF; /* NEXT */

Line 6041: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_next_rec.invoicing_rule_id);

6037: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.Invoicing_Rule(p_prior_rec.invoicing_rule_id);
6038: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.invoicing_rule_id;
6039: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);
6040: x_line_changed_attr_tbl(ind).next_id := p_next_rec.invoicing_rule_id;
6041: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_next_rec.invoicing_rule_id);
6042: END IF;
6043: END IF; /* NEXT */
6044:
6045: /* END invoicing_rule_id*/

Line 6144: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);

6140: prior_exists := 'Y';
6141: x_line_changed_attr_tbl(ind).attribute_name := 'PRICE_LIST_NAME_DUP';
6142: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6143: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.PRICE_LIST_ID;
6144: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);
6145: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.PRICE_LIST_ID;
6146: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);
6147: END IF;
6148: END IF; /* PRIOR */

Line 6146: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);

6142: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6143: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.PRICE_LIST_ID;
6144: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);
6145: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.PRICE_LIST_ID;
6146: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);
6147: END IF;
6148: END IF; /* PRIOR */
6149: /****************************/
6150:

Line 6156: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);

6152: IF OE_Globals.Equal(
6153: p_curr_rec.PRICE_LIST_ID,
6154: p_next_rec.PRICE_LIST_ID) THEN
6155: IF prior_exists = 'Y' THEN
6156: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);
6157: END IF;
6158: ELSE
6159: IF prior_exists = 'N' THEN
6160: ind := ind+1;

Line 6165: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);

6161: END IF;
6162: x_line_changed_attr_tbl(ind).attribute_name := 'PRICE_LIST_NAME_DUP';
6163: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6164: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.PRICE_LIST_ID;
6165: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);
6166: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.PRICE_LIST_ID;
6167: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);
6168: x_line_changed_attr_tbl(ind).next_id := p_next_rec.PRICE_LIST_ID;
6169: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_next_rec.PRICE_LIST_ID);

Line 6167: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);

6163: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6164: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.PRICE_LIST_ID;
6165: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);
6166: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.PRICE_LIST_ID;
6167: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);
6168: x_line_changed_attr_tbl(ind).next_id := p_next_rec.PRICE_LIST_ID;
6169: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_next_rec.PRICE_LIST_ID);
6170: END IF;
6171: END IF; /* NEXT */

Line 6169: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_next_rec.PRICE_LIST_ID);

6165: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.PRICE_LIST(p_prior_rec.PRICE_LIST_ID);
6166: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.PRICE_LIST_ID;
6167: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);
6168: x_line_changed_attr_tbl(ind).next_id := p_next_rec.PRICE_LIST_ID;
6169: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_next_rec.PRICE_LIST_ID);
6170: END IF;
6171: END IF; /* NEXT */
6172:
6173: /* END PRICE_LIST_ID*/

Line 6191: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);

6187: prior_exists := 'Y';
6188: x_line_changed_attr_tbl(ind).attribute_name := 'SALESREP';
6189: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6190: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.SALESREP_ID;
6191: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);
6192: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.SALESREP_ID;
6193: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);
6194: END IF;
6195: END IF; /* PRIOR */

Line 6193: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);

6189: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6190: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.SALESREP_ID;
6191: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);
6192: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.SALESREP_ID;
6193: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);
6194: END IF;
6195: END IF; /* PRIOR */
6196: /****************************/
6197: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN

Line 6202: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);

6198: IF OE_Globals.Equal(
6199: p_curr_rec.SALESREP_ID,
6200: p_next_rec.SALESREP_ID) THEN
6201: IF prior_exists = 'Y' THEN
6202: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);
6203: END IF;
6204: ELSE
6205: IF prior_exists = 'N' THEN
6206: ind := ind+1;

Line 6211: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);

6207: END IF;
6208: x_line_changed_attr_tbl(ind).attribute_name := 'SALESREP';
6209: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6210: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.SALESREP_ID;
6211: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);
6212: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.SALESREP_ID;
6213: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);
6214: x_line_changed_attr_tbl(ind).next_id := p_next_rec.SALESREP_ID;
6215: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_next_rec.SALESREP_ID);

Line 6213: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);

6209: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6210: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.SALESREP_ID;
6211: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);
6212: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.SALESREP_ID;
6213: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);
6214: x_line_changed_attr_tbl(ind).next_id := p_next_rec.SALESREP_ID;
6215: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_next_rec.SALESREP_ID);
6216: END IF; /* NEXT */
6217: END IF;

Line 6215: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_next_rec.SALESREP_ID);

6211: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.SALESREP(p_prior_rec.SALESREP_ID);
6212: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.SALESREP_ID;
6213: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);
6214: x_line_changed_attr_tbl(ind).next_id := p_next_rec.SALESREP_ID;
6215: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_next_rec.SALESREP_ID);
6216: END IF; /* NEXT */
6217: END IF;
6218:
6219: /* END SALESREP_ID*/

Line 6236: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);

6232: prior_exists := 'Y';
6233: x_line_changed_attr_tbl(ind).attribute_name := 'SHIPPING_METHOD';
6234: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6235: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.SHIPPING_METHOD_CODE;
6236: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);
6237: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.SHIPPING_METHOD_CODE;
6238: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);
6239: END IF;
6240: END IF; /* PRIOR */

Line 6238: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);

6234: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6235: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.SHIPPING_METHOD_CODE;
6236: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);
6237: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.SHIPPING_METHOD_CODE;
6238: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);
6239: END IF;
6240: END IF; /* PRIOR */
6241: /****************************/
6242: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN

Line 6247: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);

6243: IF OE_Globals.Equal(
6244: p_curr_rec.SHIPPING_METHOD_CODE,
6245: p_next_rec.SHIPPING_METHOD_CODE) THEN
6246: IF prior_exists = 'Y' THEN
6247: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);
6248: END IF;
6249: ELSE
6250: IF prior_exists = 'N' THEN
6251: ind := ind+1;

Line 6256: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);

6252: END IF;
6253: x_line_changed_attr_tbl(ind).attribute_name := 'SHIPPING_METHOD';
6254: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6255: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.SHIPPING_METHOD_CODE;
6256: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);
6257: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.SHIPPING_METHOD_CODE;
6258: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);
6259: x_line_changed_attr_tbl(ind).next_id := p_next_rec.SHIPPING_METHOD_CODE;
6260: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_next_rec.SHIPPING_METHOD_CODE);

Line 6258: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);

6254: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6255: x_line_changed_attr_tbl(ind).prior_id := p_prior_rec.SHIPPING_METHOD_CODE;
6256: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);
6257: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.SHIPPING_METHOD_CODE;
6258: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);
6259: x_line_changed_attr_tbl(ind).next_id := p_next_rec.SHIPPING_METHOD_CODE;
6260: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_next_rec.SHIPPING_METHOD_CODE);
6261: END IF;
6262: END IF; /* NEXT */

Line 6260: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_next_rec.SHIPPING_METHOD_CODE);

6256: x_line_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.ship_method(p_prior_rec.SHIPPING_METHOD_CODE);
6257: x_line_changed_attr_tbl(ind).current_id := p_curr_rec.SHIPPING_METHOD_CODE;
6258: x_line_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);
6259: x_line_changed_attr_tbl(ind).next_id := p_next_rec.SHIPPING_METHOD_CODE;
6260: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_next_rec.SHIPPING_METHOD_CODE);
6261: END IF;
6262: END IF; /* NEXT */
6263:
6264: /* END SHIPPING_METHOD_CODE*/

Line 6282: OE_ID_TO_VALUE.ship_from_Org

6278: prior_exists := 'Y';
6279: x_line_changed_attr_tbl(ind).attribute_name := 'Warehouse';
6280: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6281: if p_curr_rec.ship_from_org_id is not null then
6282: OE_ID_TO_VALUE.ship_from_Org
6283: ( p_ship_from_org_id => p_curr_rec.ship_from_org_id
6284: , x_ship_from_address1 => x_ship_from_address1
6285: , x_ship_from_address2 => x_ship_from_address2
6286: , x_ship_from_address3 => x_ship_from_address3

Line 6305: OE_ID_TO_VALUE.ship_from_Org

6301: x_line_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
6302:
6303: end if;
6304: if p_prior_rec.ship_from_org_id is not null then
6305: OE_ID_TO_VALUE.ship_from_Org
6306: ( p_ship_from_org_id => p_prior_rec.ship_from_org_id
6307: , x_ship_from_address1 => x_ship_from_address1
6308: , x_ship_from_address2 => x_ship_from_address2
6309: , x_ship_from_address3 => x_ship_from_address3

Line 6345: OE_ID_TO_VALUE.ship_from_Org

6341: x_line_changed_attr_tbl(ind).attribute_name := 'Warehouse';
6342: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6343:
6344: if p_prior_rec.ship_from_org_id is not null then
6345: OE_ID_TO_VALUE.ship_from_Org
6346: ( p_ship_from_org_id => p_prior_rec.ship_from_org_id
6347: , x_ship_from_address1 => x_ship_from_address1
6348: , x_ship_from_address2 => x_ship_from_address2
6349: , x_ship_from_address3 => x_ship_from_address3

Line 6368: OE_ID_TO_VALUE.ship_from_Org

6364: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_from_org;
6365:
6366: end if;
6367: if p_curr_rec.ship_from_org_id is not null then
6368: OE_ID_TO_VALUE.ship_from_Org
6369: ( p_ship_from_org_id => p_curr_rec.ship_from_org_id
6370: , x_ship_from_address1 => x_ship_from_address1
6371: , x_ship_from_address2 => x_ship_from_address2
6372: , x_ship_from_address3 => x_ship_from_address3

Line 6391: OE_ID_TO_VALUE.ship_from_Org

6387: x_line_changed_attr_tbl(ind).current_value := x_current_ship_from_org;
6388: end if;
6389:
6390: if p_next_rec.ship_from_org_id is not null then
6391: OE_ID_TO_VALUE.ship_from_Org
6392: ( p_ship_from_org_id => p_next_rec.ship_from_org_id
6393: , x_ship_from_address1 => x_ship_from_address1
6394: , x_ship_from_address2 => x_ship_from_address2
6395: , x_ship_from_address3 => x_ship_from_address3

Line 6433: OE_ID_TO_VALUE.ship_to_Org

6429: prior_exists := 'Y';
6430: x_line_changed_attr_tbl(ind).attribute_name := 'ship_to';
6431: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6432: if p_curr_rec.ship_to_org_id is not null then
6433: OE_ID_TO_VALUE.ship_to_Org
6434: ( p_ship_to_org_id => p_curr_rec.ship_to_org_id
6435: , x_ship_to_address1 => x_ship_to_address1
6436: , x_ship_to_address2 => x_ship_to_address2
6437: , x_ship_to_address3 => x_ship_to_address3

Line 6464: OE_ID_TO_VALUE.ship_to_Org

6460: x_line_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
6461: end if;
6462:
6463: if p_prior_rec.ship_to_org_id is not null then
6464: OE_ID_TO_VALUE.ship_to_Org
6465: ( p_ship_to_org_id => p_prior_rec.ship_to_org_id
6466: , x_ship_to_address1 => x_ship_to_address1
6467: , x_ship_to_address2 => x_ship_to_address2
6468: , x_ship_to_address3 => x_ship_to_address3

Line 6511: OE_ID_TO_VALUE.ship_to_Org

6507: x_line_changed_attr_tbl(ind).attribute_name := 'ship_to';
6508: x_line_changed_attr_tbl(ind).line_number := x_line_number;
6509:
6510: if p_prior_rec.ship_to_org_id is not null then
6511: OE_ID_TO_VALUE.ship_to_Org
6512: ( p_ship_to_org_id => p_prior_rec.ship_to_org_id
6513: , x_ship_to_address1 => x_ship_to_address1
6514: , x_ship_to_address2 => x_ship_to_address2
6515: , x_ship_to_address3 => x_ship_to_address3

Line 6541: OE_ID_TO_VALUE.ship_to_Org

6537: x_line_changed_attr_tbl(ind).prior_value := x_prior_ship_to_address;
6538: end if;
6539:
6540: if p_curr_rec.ship_to_org_id is not null then
6541: OE_ID_TO_VALUE.ship_to_Org
6542: ( p_ship_to_org_id => p_curr_rec.ship_to_org_id
6543: , x_ship_to_address1 => x_ship_to_address1
6544: , x_ship_to_address2 => x_ship_to_address2
6545: , x_ship_to_address3 => x_ship_to_address3

Line 6571: OE_ID_TO_VALUE.ship_to_Org

6567: x_line_changed_attr_tbl(ind).current_value := x_current_ship_to_address;
6568: end if;
6569:
6570: if p_next_rec.ship_to_org_id is not null then
6571: OE_ID_TO_VALUE.ship_to_Org
6572: ( p_ship_to_org_id => p_next_rec.ship_to_org_id
6573: , x_ship_to_address1 => x_ship_to_address1
6574: , x_ship_to_address2 => x_ship_to_address2
6575: , x_ship_to_address3 => x_ship_to_address3