APPS.OE_BLANKET_HEADER_SECURITY dependencies on OE_GLOBALS

Line 90: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

86: -- set OUT result to NOT CONSTRAINED
87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
89: END IF;
90: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
91: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
92: ELSIF x_on_operation_action = 2 THEN
93: -- set OUT result to NOT CONSTRAINED
94: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

Line 91: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
89: END IF;
90: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
91: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
92: ELSIF x_on_operation_action = 2 THEN
93: -- set OUT result to NOT CONSTRAINED
94: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
95: IF l_debug_level > 0 THEN

Line 94: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

90: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
91: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
92: ELSIF x_on_operation_action = 2 THEN
93: -- set OUT result to NOT CONSTRAINED
94: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
95: IF l_debug_level > 0 THEN
96: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
97: END IF;
98: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

Line 98: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

94: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
95: IF l_debug_level > 0 THEN
96: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
97: END IF;
98: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
99: END IF;
100: END IF;
101: END IF;
102: END IF;

Line 110: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

106: -- set OUT result to NOT CONSTRAINED
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
109: END IF;
110: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
111: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
112: ELSIF x_on_operation_action = 2 THEN
113: -- set OUT result to NOT CONSTRAINED
114: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

Line 111: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
109: END IF;
110: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
111: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
112: ELSIF x_on_operation_action = 2 THEN
113: -- set OUT result to NOT CONSTRAINED
114: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
115: IF l_debug_level > 0 THEN

Line 114: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

110: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
111: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
112: ELSIF x_on_operation_action = 2 THEN
113: -- set OUT result to NOT CONSTRAINED
114: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
117: END IF;
118: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

Line 118: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

114: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
117: END IF;
118: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
119: END IF;
120: END IF;
121: END IF;
122: END IF;

Line 1594: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

1590:
1591: -- Initializing return status to SUCCESS
1592: x_return_status := FND_API.G_RET_STS_SUCCESS;
1593:
1594: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1595: l_operation := OE_PC_GLOBALS.CREATE_OP;
1596: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1597: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1598: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

Line 1596: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1592: x_return_status := FND_API.G_RET_STS_SUCCESS;
1593:
1594: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1595: l_operation := OE_PC_GLOBALS.CREATE_OP;
1596: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1597: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1598: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1599: l_operation := OE_PC_GLOBALS.DELETE_OP;
1600: ELSE

Line 1598: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

1594: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1595: l_operation := OE_PC_GLOBALS.CREATE_OP;
1596: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1597: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1598: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1599: l_operation := OE_PC_GLOBALS.DELETE_OP;
1600: ELSE
1601: IF l_debug_level > 0 THEN
1602: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

Line 1670: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

1666: -- Initializing out result to NOT CONSTRAINED
1667: x_result := OE_PC_GLOBALS.NO;
1668:
1669: -- Get the operation code to be passed to the security framework API
1670: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1671: -- Bug 1987983 : if the order source is Copy then skip the Attribute
1672: -- level check
1673: -- IF p_HEADER_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
1674: -- THEN

Line 1673: -- IF p_HEADER_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY

1669: -- Get the operation code to be passed to the security framework API
1670: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1671: -- Bug 1987983 : if the order source is Copy then skip the Attribute
1672: -- level check
1673: -- IF p_HEADER_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
1674: -- THEN
1675: -- RETURN;
1676: -- ELSE
1677: l_operation := OE_PC_GLOBALS.CREATE_OP;

Line 1692: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1688: THEN
1689: RETURN;
1690: END IF;
1691:
1692: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1693: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1694: ELSE
1695: IF l_debug_level > 0 THEN
1696: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

Line 1710: AND NOT OE_GLOBALS.Equal(p_header_rec.cancelled_flag,

1706: -- Compare the new and old entity records and
1707: -- check constraints for all the changed attributes.
1708: /*
1709: IF p_header_rec.cancelled_flag <> FND_API.G_MISS_CHAR
1710: AND NOT OE_GLOBALS.Equal(p_header_rec.cancelled_flag,
1711: p_old_header_rec.cancelled_flag)
1712: THEN
1713: IF p_header_rec.cancelled_flag = 'Y' THEN
1714: l_result := CANCELLED

Line 1729: AND (NOT oe_globals.equal(p_header_rec.price_list_id,

1725:
1726: END IF;
1727: */
1728: IF ((p_header_rec.price_list_id IS NOT NULL)
1729: AND (NOT oe_globals.equal(p_header_rec.price_list_id,
1730: p_old_HEADER_rec.price_list_id))
1731: AND (p_header_rec.order_category_code IS NOT NULL)
1732: AND (p_header_rec.order_category_code <>
1733: Oe_Globals.G_RETURN_CATEGORY_CODE)) THEN

Line 1733: Oe_Globals.G_RETURN_CATEGORY_CODE)) THEN

1729: AND (NOT oe_globals.equal(p_header_rec.price_list_id,
1730: p_old_HEADER_rec.price_list_id))
1731: AND (p_header_rec.order_category_code IS NOT NULL)
1732: AND (p_header_rec.order_category_code <>
1733: Oe_Globals.G_RETURN_CATEGORY_CODE)) THEN
1734: BEGIN
1735: SELECT active_flag
1736: INTO l_active_flag
1737: FROM qp_List_headers_vl

Line 1754: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.accounting_rule_id,p_old_header_rec.accounting_rule_id) THEN

1750: END;
1751: END IF;
1752:
1753: IF p_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;
1754: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.accounting_rule_id,p_old_header_rec.accounting_rule_id) THEN
1755:
1756: l_result := ACCOUNTING_RULE
1757: (p_operation => l_operation
1758: ,p_record => l_rowtype_rec

Line 1770: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_type_code,p_old_header_rec.conversion_type_code) THEN

1766:
1767: END IF;
1768:
1769: IF p_header_rec.conversion_type_code = FND_API.G_MISS_CHAR THEN NULL;
1770: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_type_code,p_old_header_rec.conversion_type_code) THEN
1771:
1772: l_result := CONVERSION_TYPE
1773: (p_operation => l_operation
1774: ,p_record => l_rowtype_rec

Line 1786: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number,p_old_header_rec.cust_po_number) THEN

1782:
1783: END IF;
1784:
1785: IF p_header_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;
1786: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number,p_old_header_rec.cust_po_number) THEN
1787:
1788: l_result := CUST_PO_NUMBER
1789: (p_operation => l_operation
1790: ,p_record => l_rowtype_rec

Line 1802: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id,p_old_header_rec.deliver_to_org_id) THEN

1798:
1799: END IF;
1800:
1801: IF p_header_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN NULL;
1802: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id,p_old_header_rec.deliver_to_org_id) THEN
1803:
1804: l_result := DELIVER_TO_ORG
1805: (p_operation => l_operation
1806: ,p_record => l_rowtype_rec

Line 1818: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.freight_terms_code,p_old_header_rec.freight_terms_code) THEN

1814:
1815: END IF;
1816:
1817: IF p_header_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;
1818: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.freight_terms_code,p_old_header_rec.freight_terms_code) THEN
1819:
1820: l_result := FREIGHT_TERMS
1821: (p_operation => l_operation
1822: ,p_record => l_rowtype_rec

Line 1834: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id) THEN

1830:
1831: END IF;
1832:
1833: IF p_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN NULL;
1834: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id) THEN
1835:
1836: l_result := INVOICE_TO_ORG
1837: (p_operation => l_operation
1838: ,p_record => l_rowtype_rec

Line 1850: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoicing_rule_id,p_old_header_rec.invoicing_rule_id) THEN

1846:
1847: END IF;
1848:
1849: IF p_header_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN NULL;
1850: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoicing_rule_id,p_old_header_rec.invoicing_rule_id) THEN
1851:
1852: l_result := INVOICING_RULE
1853: (p_operation => l_operation
1854: ,p_record => l_rowtype_rec

Line 1866: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_number,p_old_header_rec.order_number) THEN

1862:
1863: END IF;
1864:
1865: IF p_header_rec.order_number = FND_API.G_MISS_NUM THEN NULL;
1866: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_number,p_old_header_rec.order_number) THEN
1867:
1868: l_result := ORDER_NUMBER
1869: (p_operation => l_operation
1870: ,p_record => l_rowtype_rec

Line 1882: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id,p_old_header_rec.order_type_id) THEN

1878:
1879: END IF;
1880:
1881: IF p_header_rec.order_type_id = FND_API.G_MISS_NUM THEN NULL;
1882: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id,p_old_header_rec.order_type_id) THEN
1883:
1884: l_result := ORDER_TYPE
1885: (p_operation => l_operation
1886: ,p_record => l_rowtype_rec

Line 1898: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.packing_instructions,p_old_header_rec.packing_instructions) THEN

1894:
1895: END IF;
1896:
1897: IF p_header_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;
1898: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.packing_instructions,p_old_header_rec.packing_instructions) THEN
1899:
1900: l_result := PACKING_INSTRUCTIONS
1901: (p_operation => l_operation
1902: ,p_record => l_rowtype_rec

Line 1914: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_term_id,p_old_header_rec.payment_term_id) THEN

1910:
1911: END IF;
1912:
1913: IF p_header_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;
1914: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_term_id,p_old_header_rec.payment_term_id) THEN
1915:
1916: l_result := PAYMENT_TERM
1917: (p_operation => l_operation
1918: ,p_record => l_rowtype_rec

Line 1930: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.price_list_id,p_old_header_rec.price_list_id) THEN

1926:
1927: END IF;
1928:
1929: IF p_header_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;
1930: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.price_list_id,p_old_header_rec.price_list_id) THEN
1931:
1932: l_result := PRICE_LIST
1933: (p_operation => l_operation
1934: ,p_record => l_rowtype_rec

Line 1949: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.salesrep_id,p_old_header_rec.salesrep_id) THEN

1945:
1946: END IF;
1947:
1948: IF p_header_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
1949: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.salesrep_id,p_old_header_rec.salesrep_id) THEN
1950:
1951: l_result := SALESREP
1952: (p_operation => l_operation
1953: ,p_record => l_rowtype_rec

Line 1965: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_instructions,p_old_header_rec.shipping_instructions) THEN

1961:
1962: END IF;
1963:
1964: IF p_header_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;
1965: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_instructions,p_old_header_rec.shipping_instructions) THEN
1966:
1967: l_result := SHIPPING_INSTRUCTIONS
1968: (p_operation => l_operation
1969: ,p_record => l_rowtype_rec

Line 1981: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_method_code,p_old_header_rec.shipping_method_code) THEN

1977:
1978: END IF;
1979:
1980: IF p_header_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;
1981: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_method_code,p_old_header_rec.shipping_method_code) THEN
1982:
1983: l_result := SHIPPING_METHOD
1984: (p_operation => l_operation
1985: ,p_record => l_rowtype_rec

Line 1997: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_from_org_id,p_old_header_rec.ship_from_org_id) THEN

1993:
1994: END IF;
1995:
1996: IF p_header_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;
1997: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_from_org_id,p_old_header_rec.ship_from_org_id) THEN
1998:
1999: l_result := SHIP_FROM_ORG
2000: (p_operation => l_operation
2001: ,p_record => l_rowtype_rec

Line 2013: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id,p_old_header_rec.ship_to_org_id) THEN

2009:
2010: END IF;
2011:
2012: IF p_header_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2013: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id,p_old_header_rec.ship_to_org_id) THEN
2014:
2015: l_result := SHIP_TO_ORG
2016: (p_operation => l_operation
2017: ,p_record => l_rowtype_rec

Line 2029: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id,p_old_header_rec.sold_to_contact_id) THEN

2025:
2026: END IF;
2027:
2028: IF p_header_rec.sold_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
2029: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id,p_old_header_rec.sold_to_contact_id) THEN
2030:
2031: l_result := SOLD_TO_CONTACT
2032: (p_operation => l_operation
2033: ,p_record => l_rowtype_rec

Line 2045: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id) THEN

2041:
2042: END IF;
2043:
2044: IF p_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2045: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id) THEN
2046:
2047: l_result := SOLD_TO_ORG
2048: (p_operation => l_operation
2049: ,p_record => l_rowtype_rec

Line 2061: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code) THEN

2057:
2058: END IF;
2059:
2060: IF p_header_rec.transactional_curr_code = FND_API.G_MISS_CHAR THEN NULL;
2061: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code) THEN
2062:
2063: l_result := TRANSACTIONAL_CURR
2064: (p_operation => l_operation
2065: ,p_record => l_rowtype_rec

Line 2077: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_ship_to_flag,p_old_header_rec.enforce_ship_to_flag) THEN

2073:
2074: END IF;
2075:
2076: IF p_header_rec.enforce_ship_to_flag = FND_API.G_MISS_CHAR THEN NULL;
2077: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_ship_to_flag,p_old_header_rec.enforce_ship_to_flag) THEN
2078:
2079: l_result := ENFORCE_SHIP_TO_FLAG
2080: (p_operation => l_operation
2081: ,p_record => l_rowtype_rec

Line 2093: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_freight_term_flag,p_old_header_rec.enforce_freight_term_flag) THEN

2089:
2090: END IF;
2091:
2092: IF p_header_rec.enforce_freight_term_flag = FND_API.G_MISS_CHAR THEN NULL;
2093: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_freight_term_flag,p_old_header_rec.enforce_freight_term_flag) THEN
2094:
2095: l_result := ENFORCE_FREIGHT_TERM_FLAG
2096: (p_operation => l_operation
2097: ,p_record => l_rowtype_rec

Line 2109: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_shipping_method_flag,p_old_header_rec.enforce_shipping_method_flag) THEN

2105:
2106: END IF;
2107:
2108: IF p_header_rec.enforce_shipping_method_flag = FND_API.G_MISS_CHAR THEN NULL;
2109: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_shipping_method_flag,p_old_header_rec.enforce_shipping_method_flag) THEN
2110:
2111: l_result := ENFORCE_SHIPPING_METHOD_FLAG
2112: (p_operation => l_operation
2113: ,p_record => l_rowtype_rec

Line 2125: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_invoice_to_flag,p_old_header_rec.enforce_invoice_to_flag) THEN

2121:
2122: END IF;
2123:
2124: IF p_header_rec.enforce_invoice_to_flag = FND_API.G_MISS_CHAR THEN NULL;
2125: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_invoice_to_flag,p_old_header_rec.enforce_invoice_to_flag) THEN
2126:
2127: l_result := ENFORCE_INVOICE_TO_FLAG
2128: (p_operation => l_operation
2129: ,p_record => l_rowtype_rec

Line 2141: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_price_list_flag,p_old_header_rec.enforce_price_list_flag) THEN

2137:
2138: END IF;
2139:
2140: IF p_header_rec.enforce_price_list_flag = FND_API.G_MISS_CHAR THEN NULL;
2141: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_price_list_flag,p_old_header_rec.enforce_price_list_flag) THEN
2142:
2143: l_result := ENFORCE_PRICE_LIST_FLAG
2144: (p_operation => l_operation
2145: ,p_record => l_rowtype_rec

Line 2157: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_payment_term_flag,p_old_header_rec.enforce_payment_term_flag) THEN

2153:
2154: END IF;
2155:
2156: IF p_header_rec.enforce_payment_term_flag = FND_API.G_MISS_CHAR THEN NULL;
2157: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_payment_term_flag,p_old_header_rec.enforce_payment_term_flag) THEN
2158:
2159: l_result := ENFORCE_PAYMENT_TERM_FLAG
2160: (p_operation => l_operation
2161: ,p_record => l_rowtype_rec

Line 2173: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_accounting_rule_flag,p_old_header_rec.enforce_accounting_rule_flag) THEN

2169:
2170: END IF;
2171:
2172: IF p_header_rec.enforce_accounting_rule_flag = FND_API.G_MISS_CHAR THEN NULL;
2173: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_accounting_rule_flag,p_old_header_rec.enforce_accounting_rule_flag) THEN
2174:
2175: l_result := ENFORCE_ACCOUNTING_RULE_FLAG
2176: (p_operation => l_operation
2177: ,p_record => l_rowtype_rec

Line 2189: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_invoicing_rule_flag,p_old_header_rec.enforce_invoicing_rule_flag) THEN

2185:
2186: END IF;
2187:
2188: IF p_header_rec.enforce_invoicing_rule_flag = FND_API.G_MISS_CHAR THEN NULL;
2189: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_invoicing_rule_flag,p_old_header_rec.enforce_invoicing_rule_flag) THEN
2190:
2191: l_result := ENFORCE_INVOICING_RULE_FLAG
2192: (p_operation => l_operation
2193: ,p_record => l_rowtype_rec

Line 2205: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.start_date_active,p_old_header_rec.start_date_active) THEN

2201:
2202: END IF;
2203:
2204: IF p_header_rec.start_date_active = FND_API.G_MISS_DATE THEN NULL;
2205: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.start_date_active,p_old_header_rec.start_date_active) THEN
2206:
2207: l_result := START_DATE_ACTIVE
2208: (p_operation => l_operation
2209: ,p_record => l_rowtype_rec

Line 2221: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.end_date_active,p_old_header_rec.end_date_active) THEN

2217:
2218: END IF;
2219:
2220: IF p_header_rec.end_date_active = FND_API.G_MISS_DATE THEN NULL;
2221: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.end_date_active,p_old_header_rec.end_date_active) THEN
2222:
2223: l_result := END_DATE_ACTIVE
2224: (p_operation => l_operation
2225: ,p_record => l_rowtype_rec

Line 2237: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.version_number,p_old_header_rec.version_number) THEN

2233:
2234: END IF;
2235:
2236: IF p_header_rec.version_number = FND_API.G_MISS_NUM THEN NULL;
2237: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.version_number,p_old_header_rec.version_number) THEN
2238:
2239: l_result := VERSION_NUMBER
2240: (p_operation => l_operation
2241: ,p_record => l_rowtype_rec

Line 2253: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.revision_change_date,p_old_header_rec.revision_change_date) THEN

2249:
2250: END IF;
2251:
2252: IF p_header_rec.revision_change_date = FND_API.G_MISS_DATE THEN NULL;
2253: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.revision_change_date,p_old_header_rec.revision_change_date) THEN
2254:
2255: l_result := REVISION_CHANGE_DATE
2256: (p_operation => l_operation
2257: ,p_record => l_rowtype_rec

Line 2269: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.revision_change_reason_code,p_old_header_rec.revision_change_reason_code) THEN

2265:
2266: END IF;
2267:
2268: IF p_header_rec.revision_change_reason_code = FND_API.G_MISS_CHAR THEN NULL;
2269: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.revision_change_reason_code,p_old_header_rec.revision_change_reason_code) THEN
2270:
2271: l_result := REVISION_CHANGE_REASON
2272: (p_operation => l_operation
2273: ,p_record => l_rowtype_rec

Line 2285: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.revision_change_comments,p_old_header_rec.revision_change_comments) THEN

2281:
2282: END IF;
2283:
2284: IF p_header_rec.revision_change_comments = FND_API.G_MISS_CHAR THEN NULL;
2285: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.revision_change_comments,p_old_header_rec.revision_change_comments) THEN
2286:
2287: l_result := REVISION_CHANGE_COMMENTS
2288: (p_operation => l_operation
2289: ,p_record => l_rowtype_rec

Line 2301: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_min_amount,p_old_header_rec.blanket_min_amount) THEN

2297:
2298: END IF;
2299:
2300: IF p_header_rec.blanket_min_amount = FND_API.G_MISS_NUM THEN NULL;
2301: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_min_amount,p_old_header_rec.blanket_min_amount) THEN
2302:
2303: l_result := BLANKET_MIN_AMOUNT
2304: (p_operation => l_operation
2305: ,p_record => l_rowtype_rec

Line 2317: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_max_amount,p_old_header_rec.blanket_max_amount) THEN

2313:
2314: END IF;
2315:
2316: IF p_header_rec.blanket_max_amount = FND_API.G_MISS_NUM THEN NULL;
2317: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_max_amount,p_old_header_rec.blanket_max_amount) THEN
2318:
2319: l_result := BLANKET_MAX_AMOUNT
2320: (p_operation => l_operation
2321: ,p_record => l_rowtype_rec

Line 2333: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.override_amount_flag,p_old_header_rec.override_amount_flag) THEN

2329:
2330: END IF;
2331:
2332: IF p_header_rec.override_amount_flag = FND_API.G_MISS_CHAR THEN NULL;
2333: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.override_amount_flag,p_old_header_rec.override_amount_flag) THEN
2334:
2335: l_result := OVERRIDE_AMOUNT_FLAG
2336: (p_operation => l_operation
2337: ,p_record => l_rowtype_rec

Line 2349: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transaction_phase_code,p_old_header_rec.transaction_phase_code) THEN

2345:
2346: END IF;
2347:
2348: IF p_header_rec.transaction_phase_code = FND_API.G_MISS_CHAR THEN NULL;
2349: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transaction_phase_code,p_old_header_rec.transaction_phase_code) THEN
2350:
2351: l_result := TRANSACTION_PHASE
2352: (p_operation => l_operation
2353: ,p_record => l_rowtype_rec

Line 2365: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.SOLD_TO_SITE_USE_ID,p_old_header_rec.SOLD_TO_SITE_USE_ID) THEN

2361:
2362: END IF;
2363:
2364: IF p_header_rec.SOLD_TO_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;
2365: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.SOLD_TO_SITE_USE_ID,p_old_header_rec.SOLD_TO_SITE_USE_ID) THEN
2366:
2367: l_result := SOLD_TO_SITE_USE
2368: (p_operation => l_operation
2369: ,p_record => l_rowtype_rec

Line 2381: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.SALES_DOCUMENT_NAME,p_old_header_rec.SALES_DOCUMENT_NAME) THEN

2377:
2378: END IF;
2379:
2380: IF p_header_rec.SALES_DOCUMENT_NAME = FND_API.G_MISS_CHAR THEN NULL;
2381: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.SALES_DOCUMENT_NAME,p_old_header_rec.SALES_DOCUMENT_NAME) THEN
2382:
2383: l_result := SALES_DOCUMENT_NAME
2384: (p_operation => l_operation
2385: ,p_record => l_rowtype_rec

Line 2397: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.CUSTOMER_SIGNATURE,p_old_header_rec.CUSTOMER_SIGNATURE) THEN

2393:
2394: END IF;
2395:
2396: IF p_header_rec.CUSTOMER_SIGNATURE = FND_API.G_MISS_CHAR THEN NULL;
2397: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.CUSTOMER_SIGNATURE,p_old_header_rec.CUSTOMER_SIGNATURE) THEN
2398:
2399: l_result := CUSTOMER_SIGNATURE
2400: (p_operation => l_operation
2401: ,p_record => l_rowtype_rec

Line 2413: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.CUSTOMER_SIGNATURE_DATE,p_old_header_rec.CUSTOMER_SIGNATURE_DATE) THEN

2409:
2410: END IF;
2411:
2412: IF p_header_rec.CUSTOMER_SIGNATURE_DATE = FND_API.G_MISS_DATE THEN NULL;
2413: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.CUSTOMER_SIGNATURE_DATE,p_old_header_rec.CUSTOMER_SIGNATURE_DATE) THEN
2414:
2415: l_result := CUSTOMER_SIGNATURE_DATE
2416: (p_operation => l_operation
2417: ,p_record => l_rowtype_rec

Line 2429: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.SUPPLIER_SIGNATURE,p_old_header_rec.SUPPLIER_SIGNATURE) THEN

2425:
2426: END IF;
2427:
2428: IF p_header_rec.SUPPLIER_SIGNATURE = FND_API.G_MISS_CHAR THEN NULL;
2429: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.SUPPLIER_SIGNATURE,p_old_header_rec.SUPPLIER_SIGNATURE) THEN
2430:
2431: l_result := SUPPLIER_SIGNATURE
2432: (p_operation => l_operation
2433: ,p_record => l_rowtype_rec

Line 2445: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.SUPPLIER_SIGNATURE_DATE,p_old_header_rec.SUPPLIER_SIGNATURE_DATE) THEN

2441:
2442: END IF;
2443:
2444: IF p_header_rec.SUPPLIER_SIGNATURE_DATE = FND_API.G_MISS_DATE THEN NULL;
2445: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.SUPPLIER_SIGNATURE_DATE,p_old_header_rec.SUPPLIER_SIGNATURE_DATE) THEN
2446:
2447: l_result := SUPPLIER_SIGNATURE_DATE
2448: (p_operation => l_operation
2449: ,p_record => l_rowtype_rec

Line 2461: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.USER_STATUS_CODE,p_old_header_rec.USER_STATUS_CODE) THEN

2457:
2458: END IF;
2459:
2460: IF p_header_rec.USER_STATUS_CODE = FND_API.G_MISS_CHAR THEN NULL;
2461: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.USER_STATUS_CODE,p_old_header_rec.USER_STATUS_CODE) THEN
2462:
2463: l_result := USER_STATUS
2464: (p_operation => l_operation
2465: ,p_record => l_rowtype_rec

Line 2477: ELSIF ( NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_PRICE_LIST_ID,p_old_header_rec.NEW_PRICE_LIST_ID)

2473:
2474: END IF;
2475:
2476: IF p_header_rec.NEW_PRICE_LIST_ID = FND_API.G_MISS_NUM THEN NULL;
2477: ELSIF ( NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_PRICE_LIST_ID,p_old_header_rec.NEW_PRICE_LIST_ID)
2478: OR NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_PRICE_LIST_NAME,p_old_header_rec.NEW_PRICE_LIST_NAME)
2479: )
2480: THEN
2481:

Line 2478: OR NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_PRICE_LIST_NAME,p_old_header_rec.NEW_PRICE_LIST_NAME)

2474: END IF;
2475:
2476: IF p_header_rec.NEW_PRICE_LIST_ID = FND_API.G_MISS_NUM THEN NULL;
2477: ELSIF ( NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_PRICE_LIST_ID,p_old_header_rec.NEW_PRICE_LIST_ID)
2478: OR NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_PRICE_LIST_NAME,p_old_header_rec.NEW_PRICE_LIST_NAME)
2479: )
2480: THEN
2481:
2482: l_result := NEW_PRICE_LIST

Line 2496: ELSIF ( NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_MODIFIER_LIST_ID,p_old_header_rec.NEW_MODIFIER_LIST_ID)

2492:
2493: END IF;
2494:
2495: IF p_header_rec.NEW_MODIFIER_LIST_ID = FND_API.G_MISS_NUM THEN NULL;
2496: ELSIF ( NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_MODIFIER_LIST_ID,p_old_header_rec.NEW_MODIFIER_LIST_ID)
2497: OR NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_MODIFIER_LIST_NAME,p_old_header_rec.NEW_MODIFIER_LIST_NAME)
2498: )
2499: THEN
2500:

Line 2497: OR NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_MODIFIER_LIST_NAME,p_old_header_rec.NEW_MODIFIER_LIST_NAME)

2493: END IF;
2494:
2495: IF p_header_rec.NEW_MODIFIER_LIST_ID = FND_API.G_MISS_NUM THEN NULL;
2496: ELSIF ( NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_MODIFIER_LIST_ID,p_old_header_rec.NEW_MODIFIER_LIST_ID)
2497: OR NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_MODIFIER_LIST_NAME,p_old_header_rec.NEW_MODIFIER_LIST_NAME)
2498: )
2499: THEN
2500:
2501:

Line 2516: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.DEFAULT_DISCOUNT_PERCENT,p_old_header_rec.DEFAULT_DISCOUNT_PERCENT) THEN

2512:
2513: END IF;
2514:
2515: IF p_header_rec.DEFAULT_DISCOUNT_PERCENT = FND_API.G_MISS_NUM THEN NULL;
2516: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.DEFAULT_DISCOUNT_PERCENT,p_old_header_rec.DEFAULT_DISCOUNT_PERCENT) THEN
2517:
2518: l_result := DEFAULT_DISCOUNT_PERCENT
2519: (p_operation => l_operation
2520: ,p_record => l_rowtype_rec

Line 2532: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.DEFAULT_DISCOUNT_AMOUNT,p_old_header_rec.DEFAULT_DISCOUNT_AMOUNT) THEN

2528:
2529: END IF;
2530:
2531: IF p_header_rec.DEFAULT_DISCOUNT_AMOUNT = FND_API.G_MISS_NUM THEN NULL;
2532: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.DEFAULT_DISCOUNT_AMOUNT,p_old_header_rec.DEFAULT_DISCOUNT_AMOUNT) THEN
2533:
2534: l_result := DEFAULT_DISCOUNT_AMOUNT
2535: (p_operation => l_operation
2536: ,p_record => l_rowtype_rec

Line 2550: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ON_HOLD_FLAG,p_old_header_rec.ON_HOLD_FLAG) THEN

2546: --bug6531947
2547:
2548: -- Bug 6609645
2549: IF p_header_rec.ON_HOLD_FLAG = FND_API.G_MISS_CHAR THEN NULL;
2550: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ON_HOLD_FLAG,p_old_header_rec.ON_HOLD_FLAG) THEN
2551: l_result := ON_HOLD_FLAG
2552: (p_operation => l_operation
2553: ,p_record => l_rowtype_rec
2554: ,x_on_operation_action => l_on_operation_action

Line 2567: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.CONTEXT,p_old_header_rec.CONTEXT

2563:
2564: --Bug 6609645
2565:
2566: IF p_header_rec.CONTEXT = FND_API.G_MISS_CHAR THEN NULL;
2567: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.CONTEXT,p_old_header_rec.CONTEXT
2568: ) THEN
2569: l_result := CONTEXT
2570: (p_operation => l_operation
2571: ,p_record => l_rowtype_rec

Line 2583: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE1,p_old_header_rec.ATTRIBUTE1) THEN

2579: END IF;
2580:
2581:
2582: IF p_header_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN NULL;
2583: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE1,p_old_header_rec.ATTRIBUTE1) THEN
2584: l_result := ATTRIBUTE1
2585: (p_operation => l_operation
2586: ,p_record => l_rowtype_rec
2587: ,x_on_operation_action => l_on_operation_action

Line 2598: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE2,p_old_header_rec.ATTRIBUTE2) THEN

2594: END IF;
2595:
2596:
2597: IF p_header_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN NULL;
2598: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE2,p_old_header_rec.ATTRIBUTE2) THEN
2599: l_result := ATTRIBUTE2
2600: (p_operation => l_operation
2601: ,p_record => l_rowtype_rec
2602: ,x_on_operation_action => l_on_operation_action

Line 2613: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE3,p_old_header_rec.ATTRIBUTE3) THEN

2609: END IF;
2610:
2611:
2612: IF p_header_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN NULL;
2613: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE3,p_old_header_rec.ATTRIBUTE3) THEN
2614: l_result := ATTRIBUTE3
2615: (p_operation => l_operation
2616: ,p_record => l_rowtype_rec
2617: ,x_on_operation_action => l_on_operation_action

Line 2628: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE4,p_old_header_rec.ATTRIBUTE4) THEN

2624: END IF;
2625:
2626:
2627: IF p_header_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN NULL;
2628: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE4,p_old_header_rec.ATTRIBUTE4) THEN
2629: l_result := ATTRIBUTE4
2630: (p_operation => l_operation
2631: ,p_record => l_rowtype_rec
2632: ,x_on_operation_action => l_on_operation_action

Line 2642: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE5,p_old_header_rec.ATTRIBUTE5) THEN

2638:
2639: END IF;
2640:
2641: IF p_header_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN NULL;
2642: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE5,p_old_header_rec.ATTRIBUTE5) THEN
2643: l_result := ATTRIBUTE5
2644: (p_operation => l_operation
2645: ,p_record => l_rowtype_rec
2646: ,x_on_operation_action => l_on_operation_action

Line 2657: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE6,p_old_header_rec.ATTRIBUTE6) THEN

2653: END IF;
2654:
2655:
2656: IF p_header_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN NULL;
2657: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE6,p_old_header_rec.ATTRIBUTE6) THEN
2658: l_result := ATTRIBUTE6
2659: (p_operation => l_operation
2660: ,p_record => l_rowtype_rec
2661: ,x_on_operation_action => l_on_operation_action

Line 2672: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE7,p_old_header_rec.ATTRIBUTE7) THEN

2668: END IF;
2669:
2670:
2671: IF p_header_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN NULL;
2672: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE7,p_old_header_rec.ATTRIBUTE7) THEN
2673: l_result := ATTRIBUTE7
2674: (p_operation => l_operation
2675: ,p_record => l_rowtype_rec
2676: ,x_on_operation_action => l_on_operation_action

Line 2687: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE8,p_old_header_rec.ATTRIBUTE8) THEN

2683:
2684: END IF;
2685:
2686: IF p_header_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN NULL;
2687: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE8,p_old_header_rec.ATTRIBUTE8) THEN
2688: l_result := ATTRIBUTE8
2689: (p_operation => l_operation
2690: ,p_record => l_rowtype_rec
2691: ,x_on_operation_action => l_on_operation_action

Line 2703: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE9,p_old_header_rec.ATTRIBUTE9) THEN

2699: END IF;
2700:
2701:
2702: IF p_header_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN NULL;
2703: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE9,p_old_header_rec.ATTRIBUTE9) THEN
2704: l_result := ATTRIBUTE9
2705: (p_operation => l_operation
2706: ,p_record => l_rowtype_rec
2707: ,x_on_operation_action => l_on_operation_action

Line 2718: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE10,p_old_header_rec.ATTRIBUTE10) THEN

2714:
2715: END IF;
2716:
2717: IF p_header_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN NULL;
2718: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE10,p_old_header_rec.ATTRIBUTE10) THEN
2719: l_result := ATTRIBUTE10
2720: (p_operation => l_operation
2721: ,p_record => l_rowtype_rec
2722: ,x_on_operation_action => l_on_operation_action

Line 2733: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE11,p_old_header_rec.ATTRIBUTE11) THEN

2729: END IF;
2730:
2731:
2732: IF p_header_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN NULL;
2733: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE11,p_old_header_rec.ATTRIBUTE11) THEN
2734: l_result := ATTRIBUTE11
2735: (p_operation => l_operation
2736: ,p_record => l_rowtype_rec
2737: ,x_on_operation_action => l_on_operation_action

Line 2748: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE12,p_old_header_rec.ATTRIBUTE12) THEN

2744:
2745: END IF;
2746:
2747: IF p_header_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN NULL;
2748: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE12,p_old_header_rec.ATTRIBUTE12) THEN
2749: l_result := ATTRIBUTE12
2750: (p_operation => l_operation
2751: ,p_record => l_rowtype_rec
2752: ,x_on_operation_action => l_on_operation_action

Line 2763: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE13,p_old_header_rec.ATTRIBUTE13) THEN

2759:
2760: END IF;
2761:
2762: IF p_header_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN NULL;
2763: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE13,p_old_header_rec.ATTRIBUTE13) THEN
2764: l_result := ATTRIBUTE13
2765: (p_operation => l_operation
2766: ,p_record => l_rowtype_rec
2767: ,x_on_operation_action => l_on_operation_action

Line 2778: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE14,p_old_header_rec.ATTRIBUTE14) THEN

2774:
2775: END IF;
2776:
2777: IF p_header_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR THEN NULL;
2778: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE14,p_old_header_rec.ATTRIBUTE14) THEN
2779: l_result := ATTRIBUTE14
2780: (p_operation => l_operation
2781: ,p_record => l_rowtype_rec
2782: ,x_on_operation_action => l_on_operation_action

Line 2793: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE15,p_old_header_rec.ATTRIBUTE15) THEN

2789:
2790: END IF;
2791:
2792: IF p_header_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN NULL;
2793: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE15,p_old_header_rec.ATTRIBUTE15) THEN
2794: l_result := ATTRIBUTE15
2795: (p_operation => l_operation
2796: ,p_record => l_rowtype_rec
2797: ,x_on_operation_action => l_on_operation_action

Line 2808: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE16,p_old_header_rec.ATTRIBUTE16) THEN

2804:
2805: END IF;
2806:
2807: IF p_header_rec.ATTRIBUTE16 = FND_API.G_MISS_CHAR THEN NULL;
2808: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE16,p_old_header_rec.ATTRIBUTE16) THEN
2809: l_result := ATTRIBUTE16
2810: (p_operation => l_operation
2811: ,p_record => l_rowtype_rec
2812: ,x_on_operation_action => l_on_operation_action

Line 2823: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE17,p_old_header_rec.ATTRIBUTE17) THEN

2819:
2820: END IF;
2821:
2822: IF p_header_rec.ATTRIBUTE17 = FND_API.G_MISS_CHAR THEN NULL;
2823: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE17,p_old_header_rec.ATTRIBUTE17) THEN
2824: l_result := ATTRIBUTE17
2825: (p_operation => l_operation
2826: ,p_record => l_rowtype_rec
2827: ,x_on_operation_action => l_on_operation_action

Line 2838: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE18,p_old_header_rec.ATTRIBUTE18) THEN

2834:
2835: END IF;
2836:
2837: IF p_header_rec.ATTRIBUTE18 = FND_API.G_MISS_CHAR THEN NULL;
2838: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE18,p_old_header_rec.ATTRIBUTE18) THEN
2839: l_result := ATTRIBUTE18
2840: (p_operation => l_operation
2841: ,p_record => l_rowtype_rec
2842: ,x_on_operation_action => l_on_operation_action

Line 2853: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE19,p_old_header_rec.ATTRIBUTE19) THEN

2849: END IF;
2850:
2851:
2852: IF p_header_rec.ATTRIBUTE19 = FND_API.G_MISS_CHAR THEN NULL;
2853: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE19,p_old_header_rec.ATTRIBUTE19) THEN
2854: l_result := ATTRIBUTE19
2855: (p_operation => l_operation
2856: ,p_record => l_rowtype_rec
2857: ,x_on_operation_action => l_on_operation_action

Line 2868: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE20,p_old_header_rec.ATTRIBUTE20) THEN

2864:
2865: END IF;
2866:
2867: IF p_header_rec.ATTRIBUTE20 = FND_API.G_MISS_CHAR THEN NULL;
2868: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE20,p_old_header_rec.ATTRIBUTE20) THEN
2869: l_result := ATTRIBUTE20
2870: (p_operation => l_operation
2871: ,p_record => l_rowtype_rec
2872: ,x_on_operation_action => l_on_operation_action