APPS.OE_LINE_UTIL_EXT dependencies on OE_LINE_UTIL

Line 1: PACKAGE BODY OE_Line_Util_Ext AS

1: PACKAGE BODY OE_Line_Util_Ext AS
2: /* $Header: OEXULXTB.pls 120.11.12020000.2 2013/01/07 10:42:22 sujithku ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Line_Util_Ext';

2: /* $Header: OEXULXTB.pls 120.11.12020000.2 2013/01/07 10:42:22 sujithku ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Line_Util_Ext';
7:
8: -- LOCAL Procedures
9: -- Clear_Dependents
10:

Line 1421: IF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE THEN

1417: -- procedure if it is the dependent attribute.
1418: -- Also, eliminate unnecessary code for attribute that cannot be
1419: -- dependent attributes
1420:
1421: IF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE THEN
1422: ACCOUNTING_RULE;
1423: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE_DURATION THEN
1424: ACCOUNTING_RULE_DURATION;
1425: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_AGREEMENT THEN

Line 1423: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE_DURATION THEN

1419: -- dependent attributes
1420:
1421: IF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE THEN
1422: ACCOUNTING_RULE;
1423: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE_DURATION THEN
1424: ACCOUNTING_RULE_DURATION;
1425: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_AGREEMENT THEN
1426: AGREEMENT;
1427: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ATO_LINE THEN

Line 1425: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_AGREEMENT THEN

1421: IF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE THEN
1422: ACCOUNTING_RULE;
1423: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE_DURATION THEN
1424: ACCOUNTING_RULE_DURATION;
1425: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_AGREEMENT THEN
1426: AGREEMENT;
1427: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ATO_LINE THEN
1428: ATO_LINE;
1429: --For bug 3571400

Line 1427: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ATO_LINE THEN

1423: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE_DURATION THEN
1424: ACCOUNTING_RULE_DURATION;
1425: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_AGREEMENT THEN
1426: AGREEMENT;
1427: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ATO_LINE THEN
1428: ATO_LINE;
1429: --For bug 3571400
1430: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_NUMBER THEN
1431: BLANKET_NUMBER;

Line 1430: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_NUMBER THEN

1426: AGREEMENT;
1427: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ATO_LINE THEN
1428: ATO_LINE;
1429: --For bug 3571400
1430: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_NUMBER THEN
1431: BLANKET_NUMBER;
1432: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_LINE_NUMBER THEN
1433: BLANKET_LINE_NUMBER;
1434: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_VERSION_NUMBER THEN

Line 1432: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_LINE_NUMBER THEN

1428: ATO_LINE;
1429: --For bug 3571400
1430: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_NUMBER THEN
1431: BLANKET_NUMBER;
1432: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_LINE_NUMBER THEN
1433: BLANKET_LINE_NUMBER;
1434: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_VERSION_NUMBER THEN
1435: BLANKET_VERSION_NUMBER;
1436: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMMITMENT THEN

Line 1434: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_VERSION_NUMBER THEN

1430: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_NUMBER THEN
1431: BLANKET_NUMBER;
1432: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_LINE_NUMBER THEN
1433: BLANKET_LINE_NUMBER;
1434: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_VERSION_NUMBER THEN
1435: BLANKET_VERSION_NUMBER;
1436: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMMITMENT THEN
1437: COMMITMENT;
1438: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT THEN

Line 1436: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMMITMENT THEN

1432: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_LINE_NUMBER THEN
1433: BLANKET_LINE_NUMBER;
1434: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_VERSION_NUMBER THEN
1435: BLANKET_VERSION_NUMBER;
1436: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMMITMENT THEN
1437: COMMITMENT;
1438: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT THEN
1439: COMPONENT;
1440: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT_SEQUENCE THEN

Line 1438: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT THEN

1434: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_VERSION_NUMBER THEN
1435: BLANKET_VERSION_NUMBER;
1436: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMMITMENT THEN
1437: COMMITMENT;
1438: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT THEN
1439: COMPONENT;
1440: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT_SEQUENCE THEN
1441: COMPONENT_SEQUENCE;
1442: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SORT_ORDER THEN

Line 1440: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT_SEQUENCE THEN

1436: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMMITMENT THEN
1437: COMMITMENT;
1438: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT THEN
1439: COMPONENT;
1440: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT_SEQUENCE THEN
1441: COMPONENT_SEQUENCE;
1442: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SORT_ORDER THEN
1443: SORT_ORDER;
1444: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUST_PO_NUMBER THEN

Line 1442: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SORT_ORDER THEN

1438: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT THEN
1439: COMPONENT;
1440: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT_SEQUENCE THEN
1441: COMPONENT_SEQUENCE;
1442: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SORT_ORDER THEN
1443: SORT_ORDER;
1444: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUST_PO_NUMBER THEN
1445: CUST_PO_NUMBER;
1446: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUSTOMER_LINE_NUMBER THEN --For 2844285

Line 1444: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUST_PO_NUMBER THEN

1440: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT_SEQUENCE THEN
1441: COMPONENT_SEQUENCE;
1442: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SORT_ORDER THEN
1443: SORT_ORDER;
1444: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUST_PO_NUMBER THEN
1445: CUST_PO_NUMBER;
1446: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUSTOMER_LINE_NUMBER THEN --For 2844285
1447: CUSTOMER_LINE_NUMBER;
1448: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_CONTACT THEN

Line 1446: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUSTOMER_LINE_NUMBER THEN --For 2844285

1442: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SORT_ORDER THEN
1443: SORT_ORDER;
1444: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUST_PO_NUMBER THEN
1445: CUST_PO_NUMBER;
1446: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUSTOMER_LINE_NUMBER THEN --For 2844285
1447: CUSTOMER_LINE_NUMBER;
1448: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_CONTACT THEN
1449: DELIVER_TO_CONTACT;
1450: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_ORG THEN

Line 1448: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_CONTACT THEN

1444: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUST_PO_NUMBER THEN
1445: CUST_PO_NUMBER;
1446: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUSTOMER_LINE_NUMBER THEN --For 2844285
1447: CUSTOMER_LINE_NUMBER;
1448: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_CONTACT THEN
1449: DELIVER_TO_CONTACT;
1450: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_ORG THEN
1451: DELIVER_TO_ORG;
1452: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEMAND_CLASS THEN

Line 1450: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_ORG THEN

1446: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUSTOMER_LINE_NUMBER THEN --For 2844285
1447: CUSTOMER_LINE_NUMBER;
1448: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_CONTACT THEN
1449: DELIVER_TO_CONTACT;
1450: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_ORG THEN
1451: DELIVER_TO_ORG;
1452: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEMAND_CLASS THEN
1453: DEMAND_CLASS;
1454: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEP_PLAN_REQUIRED THEN

Line 1452: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEMAND_CLASS THEN

1448: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_CONTACT THEN
1449: DELIVER_TO_CONTACT;
1450: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_ORG THEN
1451: DELIVER_TO_ORG;
1452: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEMAND_CLASS THEN
1453: DEMAND_CLASS;
1454: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEP_PLAN_REQUIRED THEN
1455: DEP_PLAN_REQUIRED;
1456: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_ITEM_UNIT_NUMBER THEN

Line 1454: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEP_PLAN_REQUIRED THEN

1450: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_ORG THEN
1451: DELIVER_TO_ORG;
1452: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEMAND_CLASS THEN
1453: DEMAND_CLASS;
1454: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEP_PLAN_REQUIRED THEN
1455: DEP_PLAN_REQUIRED;
1456: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_ITEM_UNIT_NUMBER THEN
1457: END_ITEM_UNIT_NUMBER;
1458: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FOB_POINT THEN

Line 1456: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_ITEM_UNIT_NUMBER THEN

1452: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEMAND_CLASS THEN
1453: DEMAND_CLASS;
1454: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEP_PLAN_REQUIRED THEN
1455: DEP_PLAN_REQUIRED;
1456: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_ITEM_UNIT_NUMBER THEN
1457: END_ITEM_UNIT_NUMBER;
1458: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FOB_POINT THEN
1459: FOB_POINT;
1460: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FREIGHT_TERMS THEN

Line 1458: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FOB_POINT THEN

1454: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEP_PLAN_REQUIRED THEN
1455: DEP_PLAN_REQUIRED;
1456: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_ITEM_UNIT_NUMBER THEN
1457: END_ITEM_UNIT_NUMBER;
1458: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FOB_POINT THEN
1459: FOB_POINT;
1460: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FREIGHT_TERMS THEN
1461: FREIGHT_TERMS;
1462: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_CONTACT THEN

Line 1460: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FREIGHT_TERMS THEN

1456: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_ITEM_UNIT_NUMBER THEN
1457: END_ITEM_UNIT_NUMBER;
1458: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FOB_POINT THEN
1459: FOB_POINT;
1460: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FREIGHT_TERMS THEN
1461: FREIGHT_TERMS;
1462: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_CONTACT THEN
1463: INTERMED_SHIP_TO_CONTACT;
1464: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG THEN

Line 1462: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_CONTACT THEN

1458: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FOB_POINT THEN
1459: FOB_POINT;
1460: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FREIGHT_TERMS THEN
1461: FREIGHT_TERMS;
1462: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_CONTACT THEN
1463: INTERMED_SHIP_TO_CONTACT;
1464: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG THEN
1465: INTERMED_SHIP_TO_ORG;
1466: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_CONTACT THEN

Line 1464: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG THEN

1460: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FREIGHT_TERMS THEN
1461: FREIGHT_TERMS;
1462: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_CONTACT THEN
1463: INTERMED_SHIP_TO_CONTACT;
1464: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG THEN
1465: INTERMED_SHIP_TO_ORG;
1466: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_CONTACT THEN
1467: INVOICE_TO_CONTACT;
1468: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_ORG THEN

Line 1466: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_CONTACT THEN

1462: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_CONTACT THEN
1463: INTERMED_SHIP_TO_CONTACT;
1464: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG THEN
1465: INTERMED_SHIP_TO_ORG;
1466: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_CONTACT THEN
1467: INVOICE_TO_CONTACT;
1468: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_ORG THEN
1469: INVOICE_TO_ORG;
1470: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICING_RULE THEN

Line 1468: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_ORG THEN

1464: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG THEN
1465: INTERMED_SHIP_TO_ORG;
1466: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_CONTACT THEN
1467: INVOICE_TO_CONTACT;
1468: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_ORG THEN
1469: INVOICE_TO_ORG;
1470: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICING_RULE THEN
1471: INVOICING_RULE;
1472: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_IDENTIFIER_TYPE THEN

Line 1470: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICING_RULE THEN

1466: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_CONTACT THEN
1467: INVOICE_TO_CONTACT;
1468: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_ORG THEN
1469: INVOICE_TO_ORG;
1470: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICING_RULE THEN
1471: INVOICING_RULE;
1472: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_IDENTIFIER_TYPE THEN
1473: ITEM_IDENTIFIER_TYPE;
1474: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_REVISION THEN -- For bug 2951575

Line 1472: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_IDENTIFIER_TYPE THEN

1468: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_ORG THEN
1469: INVOICE_TO_ORG;
1470: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICING_RULE THEN
1471: INVOICING_RULE;
1472: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_IDENTIFIER_TYPE THEN
1473: ITEM_IDENTIFIER_TYPE;
1474: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_REVISION THEN -- For bug 2951575
1475: ITEM_REVISION;
1476: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_TYPE THEN

Line 1474: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_REVISION THEN -- For bug 2951575

1470: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICING_RULE THEN
1471: INVOICING_RULE;
1472: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_IDENTIFIER_TYPE THEN
1473: ITEM_IDENTIFIER_TYPE;
1474: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_REVISION THEN -- For bug 2951575
1475: ITEM_REVISION;
1476: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_TYPE THEN
1477: ITEM_TYPE;
1478: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_TYPE THEN

Line 1476: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_TYPE THEN

1472: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_IDENTIFIER_TYPE THEN
1473: ITEM_IDENTIFIER_TYPE;
1474: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_REVISION THEN -- For bug 2951575
1475: ITEM_REVISION;
1476: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_TYPE THEN
1477: ITEM_TYPE;
1478: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_TYPE THEN
1479: LINE_TYPE;
1480: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_CATEGORY THEN

Line 1478: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_TYPE THEN

1474: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_REVISION THEN -- For bug 2951575
1475: ITEM_REVISION;
1476: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_TYPE THEN
1477: ITEM_TYPE;
1478: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_TYPE THEN
1479: LINE_TYPE;
1480: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_CATEGORY THEN
1481: LINE_CATEGORY;
1482: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_OPTION_NUMBER THEN

Line 1480: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_CATEGORY THEN

1476: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_TYPE THEN
1477: ITEM_TYPE;
1478: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_TYPE THEN
1479: LINE_TYPE;
1480: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_CATEGORY THEN
1481: LINE_CATEGORY;
1482: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_OPTION_NUMBER THEN
1483: OPTION_NUMBER;
1484: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_ITEM THEN

Line 1482: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_OPTION_NUMBER THEN

1478: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_TYPE THEN
1479: LINE_TYPE;
1480: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_CATEGORY THEN
1481: LINE_CATEGORY;
1482: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_OPTION_NUMBER THEN
1483: OPTION_NUMBER;
1484: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_ITEM THEN
1485: ORDERED_ITEM;
1486: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_QUANTITY_UOM THEN

Line 1484: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_ITEM THEN

1480: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_CATEGORY THEN
1481: LINE_CATEGORY;
1482: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_OPTION_NUMBER THEN
1483: OPTION_NUMBER;
1484: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_ITEM THEN
1485: ORDERED_ITEM;
1486: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_QUANTITY_UOM THEN
1487: ORDER_QUANTITY_UOM;
1488: -- OPM 02/JUN/00 BEGIN

Line 1486: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_QUANTITY_UOM THEN

1482: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_OPTION_NUMBER THEN
1483: OPTION_NUMBER;
1484: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_ITEM THEN
1485: ORDERED_ITEM;
1486: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_QUANTITY_UOM THEN
1487: ORDER_QUANTITY_UOM;
1488: -- OPM 02/JUN/00 BEGIN
1489: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY_UOM2 THEN
1490: ORDERED_QUANTITY_UOM2;

Line 1489: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY_UOM2 THEN

1485: ORDERED_ITEM;
1486: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_QUANTITY_UOM THEN
1487: ORDER_QUANTITY_UOM;
1488: -- OPM 02/JUN/00 BEGIN
1489: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY_UOM2 THEN
1490: ORDERED_QUANTITY_UOM2;
1491: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY2 THEN
1492: ORDERED_QUANTITY2; -- Bug3016136
1493: -- OPM 02/JUN/00 END

Line 1491: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY2 THEN

1487: ORDER_QUANTITY_UOM;
1488: -- OPM 02/JUN/00 BEGIN
1489: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY_UOM2 THEN
1490: ORDERED_QUANTITY_UOM2;
1491: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY2 THEN
1492: ORDERED_QUANTITY2; -- Bug3016136
1493: -- OPM 02/JUN/00 END
1494: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PAYMENT_TERM THEN
1495: PAYMENT_TERM;

Line 1494: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PAYMENT_TERM THEN

1490: ORDERED_QUANTITY_UOM2;
1491: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY2 THEN
1492: ORDERED_QUANTITY2; -- Bug3016136
1493: -- OPM 02/JUN/00 END
1494: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PAYMENT_TERM THEN
1495: PAYMENT_TERM;
1496: -- OPM 02/JUN/00 BEGIN
1497: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PREFERRED_GRADE THEN
1498: PREFERRED_GRADE;

Line 1497: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PREFERRED_GRADE THEN

1493: -- OPM 02/JUN/00 END
1494: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PAYMENT_TERM THEN
1495: PAYMENT_TERM;
1496: -- OPM 02/JUN/00 BEGIN
1497: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PREFERRED_GRADE THEN
1498: PREFERRED_GRADE;
1499: -- OPM 02/JUN/00 END
1500: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_LIST THEN
1501: PRICE_LIST;

Line 1500: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_LIST THEN

1496: -- OPM 02/JUN/00 BEGIN
1497: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PREFERRED_GRADE THEN
1498: PREFERRED_GRADE;
1499: -- OPM 02/JUN/00 END
1500: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_LIST THEN
1501: PRICE_LIST;
1502: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_REQUEST_CODE THEN
1503: PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
1504: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICING_QUANTITY_UOM THEN

Line 1502: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_REQUEST_CODE THEN

1498: PREFERRED_GRADE;
1499: -- OPM 02/JUN/00 END
1500: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_LIST THEN
1501: PRICE_LIST;
1502: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_REQUEST_CODE THEN
1503: PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
1504: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICING_QUANTITY_UOM THEN
1505: PRICING_QUANTITY_UOM;
1506: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PROMISE_DATE THEN

Line 1504: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICING_QUANTITY_UOM THEN

1500: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_LIST THEN
1501: PRICE_LIST;
1502: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_REQUEST_CODE THEN
1503: PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
1504: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICING_QUANTITY_UOM THEN
1505: PRICING_QUANTITY_UOM;
1506: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PROMISE_DATE THEN
1507: PROMISE_DATE;
1508: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_REQUEST_DATE THEN

Line 1506: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PROMISE_DATE THEN

1502: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_REQUEST_CODE THEN
1503: PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
1504: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICING_QUANTITY_UOM THEN
1505: PRICING_QUANTITY_UOM;
1506: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PROMISE_DATE THEN
1507: PROMISE_DATE;
1508: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_REQUEST_DATE THEN
1509: REQUEST_DATE;
1510: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SALESREP THEN

Line 1508: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_REQUEST_DATE THEN

1504: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICING_QUANTITY_UOM THEN
1505: PRICING_QUANTITY_UOM;
1506: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PROMISE_DATE THEN
1507: PROMISE_DATE;
1508: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_REQUEST_DATE THEN
1509: REQUEST_DATE;
1510: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SALESREP THEN
1511: SALESREP;
1512: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE THEN

Line 1510: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SALESREP THEN

1506: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PROMISE_DATE THEN
1507: PROMISE_DATE;
1508: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_REQUEST_DATE THEN
1509: REQUEST_DATE;
1510: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SALESREP THEN
1511: SALESREP;
1512: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE THEN
1513: SCHEDULE_SHIP_DATE;
1514: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_NUMBER THEN

Line 1512: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE THEN

1508: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_REQUEST_DATE THEN
1509: REQUEST_DATE;
1510: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SALESREP THEN
1511: SALESREP;
1512: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE THEN
1513: SCHEDULE_SHIP_DATE;
1514: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_NUMBER THEN
1515: SHIPMENT_NUMBER;
1516: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_PRIORITY THEN

Line 1514: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_NUMBER THEN

1510: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SALESREP THEN
1511: SALESREP;
1512: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE THEN
1513: SCHEDULE_SHIP_DATE;
1514: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_NUMBER THEN
1515: SHIPMENT_NUMBER;
1516: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_PRIORITY THEN
1517: SHIPMENT_PRIORITY;
1518: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPABLE THEN

Line 1516: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_PRIORITY THEN

1512: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE THEN
1513: SCHEDULE_SHIP_DATE;
1514: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_NUMBER THEN
1515: SHIPMENT_NUMBER;
1516: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_PRIORITY THEN
1517: SHIPMENT_PRIORITY;
1518: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPABLE THEN
1519: SHIPPABLE;
1520: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_METHOD THEN

Line 1518: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPABLE THEN

1514: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_NUMBER THEN
1515: SHIPMENT_NUMBER;
1516: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_PRIORITY THEN
1517: SHIPMENT_PRIORITY;
1518: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPABLE THEN
1519: SHIPPABLE;
1520: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_METHOD THEN
1521: SHIPPING_METHOD;
1522: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_FROM_ORG THEN

Line 1520: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_METHOD THEN

1516: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_PRIORITY THEN
1517: SHIPMENT_PRIORITY;
1518: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPABLE THEN
1519: SHIPPABLE;
1520: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_METHOD THEN
1521: SHIPPING_METHOD;
1522: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_FROM_ORG THEN
1523: SHIP_FROM_ORG;
1524: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SUBINVENTORY THEN

Line 1522: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_FROM_ORG THEN

1518: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPABLE THEN
1519: SHIPPABLE;
1520: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_METHOD THEN
1521: SHIPPING_METHOD;
1522: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_FROM_ORG THEN
1523: SHIP_FROM_ORG;
1524: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SUBINVENTORY THEN
1525: SUBINVENTORY;
1526: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_ABOVE THEN

Line 1524: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SUBINVENTORY THEN

1520: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_METHOD THEN
1521: SHIPPING_METHOD;
1522: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_FROM_ORG THEN
1523: SHIP_FROM_ORG;
1524: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SUBINVENTORY THEN
1525: SUBINVENTORY;
1526: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
1527: SHIP_TOLERANCE_ABOVE;
1528: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_BELOW THEN

Line 1526: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_ABOVE THEN

1522: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_FROM_ORG THEN
1523: SHIP_FROM_ORG;
1524: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SUBINVENTORY THEN
1525: SUBINVENTORY;
1526: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
1527: SHIP_TOLERANCE_ABOVE;
1528: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_BELOW THEN
1529: SHIP_TOLERANCE_BELOW;
1530: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_CONTACT THEN

Line 1528: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_BELOW THEN

1524: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SUBINVENTORY THEN
1525: SUBINVENTORY;
1526: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
1527: SHIP_TOLERANCE_ABOVE;
1528: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_BELOW THEN
1529: SHIP_TOLERANCE_BELOW;
1530: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_CONTACT THEN
1531: SHIP_TO_CONTACT;
1532: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_ORG THEN

Line 1530: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_CONTACT THEN

1526: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
1527: SHIP_TOLERANCE_ABOVE;
1528: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_BELOW THEN
1529: SHIP_TOLERANCE_BELOW;
1530: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_CONTACT THEN
1531: SHIP_TO_CONTACT;
1532: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_ORG THEN
1533: SHIP_TO_ORG;
1534: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOLD_TO_ORG THEN

Line 1532: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_ORG THEN

1528: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_BELOW THEN
1529: SHIP_TOLERANCE_BELOW;
1530: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_CONTACT THEN
1531: SHIP_TO_CONTACT;
1532: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_ORG THEN
1533: SHIP_TO_ORG;
1534: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOLD_TO_ORG THEN
1535: SOLD_TO_ORG;
1536: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX THEN

Line 1534: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOLD_TO_ORG THEN

1530: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_CONTACT THEN
1531: SHIP_TO_CONTACT;
1532: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_ORG THEN
1533: SHIP_TO_ORG;
1534: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOLD_TO_ORG THEN
1535: SOLD_TO_ORG;
1536: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX THEN
1537: TAX;
1538: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_DATE THEN

Line 1536: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX THEN

1532: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_ORG THEN
1533: SHIP_TO_ORG;
1534: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOLD_TO_ORG THEN
1535: SOLD_TO_ORG;
1536: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX THEN
1537: TAX;
1538: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_DATE THEN
1539: TAX_DATE;
1540: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT THEN

Line 1538: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_DATE THEN

1534: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOLD_TO_ORG THEN
1535: SOLD_TO_ORG;
1536: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX THEN
1537: TAX;
1538: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_DATE THEN
1539: TAX_DATE;
1540: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT THEN
1541: TAX_EXEMPT;
1542: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_NUMBER THEN

Line 1540: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT THEN

1536: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX THEN
1537: TAX;
1538: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_DATE THEN
1539: TAX_DATE;
1540: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT THEN
1541: TAX_EXEMPT;
1542: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_NUMBER THEN
1543: TAX_EXEMPT_NUMBER;
1544: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_REASON THEN

Line 1542: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_NUMBER THEN

1538: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_DATE THEN
1539: TAX_DATE;
1540: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT THEN
1541: TAX_EXEMPT;
1542: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_NUMBER THEN
1543: TAX_EXEMPT_NUMBER;
1544: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_REASON THEN
1545: TAX_EXEMPT_REASON;
1546: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TOP_MODEL_LINE THEN

Line 1544: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_REASON THEN

1540: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT THEN
1541: TAX_EXEMPT;
1542: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_NUMBER THEN
1543: TAX_EXEMPT_NUMBER;
1544: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_REASON THEN
1545: TAX_EXEMPT_REASON;
1546: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TOP_MODEL_LINE THEN
1547: TOP_MODEL_LINE;
1548: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_START_DATE THEN

Line 1546: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TOP_MODEL_LINE THEN

1542: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_NUMBER THEN
1543: TAX_EXEMPT_NUMBER;
1544: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_REASON THEN
1545: TAX_EXEMPT_REASON;
1546: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TOP_MODEL_LINE THEN
1547: TOP_MODEL_LINE;
1548: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_START_DATE THEN
1549: SERVICE_START_DATE;
1550: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_PERIOD THEN

Line 1548: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_START_DATE THEN

1544: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_REASON THEN
1545: TAX_EXEMPT_REASON;
1546: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TOP_MODEL_LINE THEN
1547: TOP_MODEL_LINE;
1548: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_START_DATE THEN
1549: SERVICE_START_DATE;
1550: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_PERIOD THEN
1551: SERVICE_PERIOD;
1552: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_REFERENCE_TYPE_CODE THEN

Line 1550: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_PERIOD THEN

1546: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TOP_MODEL_LINE THEN
1547: TOP_MODEL_LINE;
1548: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_START_DATE THEN
1549: SERVICE_START_DATE;
1550: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_PERIOD THEN
1551: SERVICE_PERIOD;
1552: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_REFERENCE_TYPE_CODE THEN
1553: SERVICE_REFERENCE_TYPE_CODE;
1554: --sol_ord_er #16014165

Line 1552: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_REFERENCE_TYPE_CODE THEN

1548: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_START_DATE THEN
1549: SERVICE_START_DATE;
1550: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_PERIOD THEN
1551: SERVICE_PERIOD;
1552: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_REFERENCE_TYPE_CODE THEN
1553: SERVICE_REFERENCE_TYPE_CODE;
1554: --sol_ord_er #16014165
1555: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_BILL_PROFILE_ID THEN
1556: BILL_PROFILE_ID;

Line 1555: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_BILL_PROFILE_ID THEN

1551: SERVICE_PERIOD;
1552: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_REFERENCE_TYPE_CODE THEN
1553: SERVICE_REFERENCE_TYPE_CODE;
1554: --sol_ord_er #16014165
1555: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_BILL_PROFILE_ID THEN
1556: BILL_PROFILE_ID;
1557: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_COV_TEMPLATE_ID THEN
1558: SERVICE_COVERAGE_TEMP;
1559: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_SUBS_TEMPLATE_ID THEN

Line 1557: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_COV_TEMPLATE_ID THEN

1553: SERVICE_REFERENCE_TYPE_CODE;
1554: --sol_ord_er #16014165
1555: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_BILL_PROFILE_ID THEN
1556: BILL_PROFILE_ID;
1557: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_COV_TEMPLATE_ID THEN
1558: SERVICE_COVERAGE_TEMP;
1559: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_SUBS_TEMPLATE_ID THEN
1560: SUBSCRIPTION_TEMP;
1561: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_BILL_OPTION_CODE THEN

Line 1559: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_SUBS_TEMPLATE_ID THEN

1555: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_BILL_PROFILE_ID THEN
1556: BILL_PROFILE_ID;
1557: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_COV_TEMPLATE_ID THEN
1558: SERVICE_COVERAGE_TEMP;
1559: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_SUBS_TEMPLATE_ID THEN
1560: SUBSCRIPTION_TEMP;
1561: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_BILL_OPTION_CODE THEN
1562: serv_bill_option;
1563: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.g_subscription_enable_flag THEN

Line 1561: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_BILL_OPTION_CODE THEN

1557: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_COV_TEMPLATE_ID THEN
1558: SERVICE_COVERAGE_TEMP;
1559: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_SUBS_TEMPLATE_ID THEN
1560: SUBSCRIPTION_TEMP;
1561: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_BILL_OPTION_CODE THEN
1562: serv_bill_option;
1563: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.g_subscription_enable_flag THEN
1564: subscription_enable_flag;
1565: -- sol_ord_er #16014165 end

Line 1563: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.g_subscription_enable_flag THEN

1559: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_SUBS_TEMPLATE_ID THEN
1560: SUBSCRIPTION_TEMP;
1561: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_BILL_OPTION_CODE THEN
1562: serv_bill_option;
1563: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.g_subscription_enable_flag THEN
1564: subscription_enable_flag;
1565: -- sol_ord_er #16014165 end
1566: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_RETURN_CONTEXT THEN
1567: RETURN_CONTEXT;

Line 1566: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_RETURN_CONTEXT THEN

1562: serv_bill_option;
1563: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.g_subscription_enable_flag THEN
1564: subscription_enable_flag;
1565: -- sol_ord_er #16014165 end
1566: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_RETURN_CONTEXT THEN
1567: RETURN_CONTEXT;
1568: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOURCE_TYPE THEN
1569: SOURCE_TYPE;
1570: -- Add for bug 2766005

Line 1568: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOURCE_TYPE THEN

1564: subscription_enable_flag;
1565: -- sol_ord_er #16014165 end
1566: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_RETURN_CONTEXT THEN
1567: RETURN_CONTEXT;
1568: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOURCE_TYPE THEN
1569: SOURCE_TYPE;
1570: -- Add for bug 2766005
1571: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PACKING_INSTRUCTIONS THEN
1572: PACKING_INSTRUCTIONS;

Line 1571: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PACKING_INSTRUCTIONS THEN

1567: RETURN_CONTEXT;
1568: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOURCE_TYPE THEN
1569: SOURCE_TYPE;
1570: -- Add for bug 2766005
1571: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PACKING_INSTRUCTIONS THEN
1572: PACKING_INSTRUCTIONS;
1573: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_INSTRUCTIONS THEN
1574: SHIPPING_INSTRUCTIONS;
1575: -- End of code for bug 2766005

Line 1573: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_INSTRUCTIONS THEN

1569: SOURCE_TYPE;
1570: -- Add for bug 2766005
1571: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PACKING_INSTRUCTIONS THEN
1572: PACKING_INSTRUCTIONS;
1573: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_INSTRUCTIONS THEN
1574: SHIPPING_INSTRUCTIONS;
1575: -- End of code for bug 2766005
1576: -- Distributed orders
1577: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER THEN

Line 1577: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER THEN

1573: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_INSTRUCTIONS THEN
1574: SHIPPING_INSTRUCTIONS;
1575: -- End of code for bug 2766005
1576: -- Distributed orders
1577: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER THEN
1578: END_CUSTOMER;
1579: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_CONTACT THEN
1580: END_CUSTOMER_CONTACT;
1581: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_SITE_USE THEN

Line 1579: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_CONTACT THEN

1575: -- End of code for bug 2766005
1576: -- Distributed orders
1577: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER THEN
1578: END_CUSTOMER;
1579: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_CONTACT THEN
1580: END_CUSTOMER_CONTACT;
1581: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_SITE_USE THEN
1582: END_CUSTOMER_SITE_USE;
1583: -- bug 4283037

Line 1581: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_SITE_USE THEN

1577: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER THEN
1578: END_CUSTOMER;
1579: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_CONTACT THEN
1580: END_CUSTOMER_CONTACT;
1581: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_SITE_USE THEN
1582: END_CUSTOMER_SITE_USE;
1583: -- bug 4283037
1584: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_DURATION THEN
1585: SERVICE_DURATION;

Line 1584: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_DURATION THEN

1580: END_CUSTOMER_CONTACT;
1581: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_SITE_USE THEN
1582: END_CUSTOMER_SITE_USE;
1583: -- bug 4283037
1584: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_DURATION THEN
1585: SERVICE_DURATION;
1586: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_FIRMED_DATE and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >='110509'
1587: THEN --key Transaction Dates Project
1588: ORDER_FIRMED_DATE ;

Line 1586: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_FIRMED_DATE and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >='110509'

1582: END_CUSTOMER_SITE_USE;
1583: -- bug 4283037
1584: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_DURATION THEN
1585: SERVICE_DURATION;
1586: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_FIRMED_DATE and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >='110509'
1587: THEN --key Transaction Dates Project
1588: ORDER_FIRMED_DATE ;
1589: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CHARGE_PERIODICITY THEN
1590: CHARGE_PERIODICITY;

Line 1589: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CHARGE_PERIODICITY THEN

1585: SERVICE_DURATION;
1586: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_FIRMED_DATE and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >='110509'
1587: THEN --key Transaction Dates Project
1588: ORDER_FIRMED_DATE ;
1589: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CHARGE_PERIODICITY THEN
1590: CHARGE_PERIODICITY;
1591: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LATEST_ACCEPTABLE_DATE THEN --bug13088960
1592: latest_acceptable_date; --bug13088960
1593: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_SET THEN --ER 2843738

Line 1591: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LATEST_ACCEPTABLE_DATE THEN --bug13088960

1587: THEN --key Transaction Dates Project
1588: ORDER_FIRMED_DATE ;
1589: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CHARGE_PERIODICITY THEN
1590: CHARGE_PERIODICITY;
1591: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LATEST_ACCEPTABLE_DATE THEN --bug13088960
1592: latest_acceptable_date; --bug13088960
1593: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_SET THEN --ER 2843738
1594: ship_set; --ER 2843738
1595: END IF;

Line 1593: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_SET THEN --ER 2843738

1589: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CHARGE_PERIODICITY THEN
1590: CHARGE_PERIODICITY;
1591: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LATEST_ACCEPTABLE_DATE THEN --bug13088960
1592: latest_acceptable_date; --bug13088960
1593: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_SET THEN --ER 2843738
1594: ship_set; --ER 2843738
1595: END IF;
1596: END LOOP;
1597: END IF;

Line 2714: oe_debug_pub.add('Entering OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);

2710: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
2711: l_dep_attr_exists VARCHAR2(1);
2712: BEGIN
2713:
2714: oe_debug_pub.add('Entering OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2715: oe_debug_pub.add('Attr Id: '||p_attr_id);
2716:
2717:
2718: IF p_attr_id <> FND_API.G_MISS_NUM THEN

Line 2731: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ACCOUNTING_RULE;

2727:
2728: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ACCOUNTING_RULE_ID,p_old_line_rec.ACCOUNTING_RULE_ID)
2729: THEN
2730: l_index := l_index + 1.0;
2731: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ACCOUNTING_RULE;
2732: END IF;
2733:
2734: IF NOT OE_GLOBALS.Equal(p_x_line_rec.AGREEMENT_ID,p_old_line_rec.AGREEMENT_ID)
2735: THEN

Line 2737: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_AGREEMENT;

2733:
2734: IF NOT OE_GLOBALS.Equal(p_x_line_rec.AGREEMENT_ID,p_old_line_rec.AGREEMENT_ID)
2735: THEN
2736: l_index := l_index + 1.0;
2737: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_AGREEMENT;
2738: END IF;
2739:
2740: IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_number,p_old_line_rec.blanket_number)
2741: THEN

Line 2743: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_NUMBER;

2739:
2740: IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_number,p_old_line_rec.blanket_number)
2741: THEN
2742: l_index := l_index + 1.0;
2743: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_NUMBER;
2744: END IF;
2745:
2746: IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_line_number,p_old_line_rec.blanket_line_number)
2747: THEN

Line 2749: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_LINE_NUMBER;

2745:
2746: IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_line_number,p_old_line_rec.blanket_line_number)
2747: THEN
2748: l_index := l_index + 1.0;
2749: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_LINE_NUMBER;
2750: END IF;
2751:
2752: --bug5160469
2753: IF NOT OE_GLOBALS.Equal(p_x_line_rec.commitment_id,p_old_line_rec.commitment_id)

Line 2756: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_COMMITMENT;

2752: --bug5160469
2753: IF NOT OE_GLOBALS.Equal(p_x_line_rec.commitment_id,p_old_line_rec.commitment_id)
2754: THEN
2755: l_index := l_index + 1.0;
2756: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_COMMITMENT;
2757: END IF;
2758:
2759: IF NOT OE_GLOBALS.Equal(p_x_line_rec.DELIVER_TO_ORG_ID,p_old_line_rec.DELIVER_TO_ORG_ID)
2760: THEN

Line 2762: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_DELIVER_TO_ORG;

2758:
2759: IF NOT OE_GLOBALS.Equal(p_x_line_rec.DELIVER_TO_ORG_ID,p_old_line_rec.DELIVER_TO_ORG_ID)
2760: THEN
2761: l_index := l_index + 1.0;
2762: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_DELIVER_TO_ORG;
2763: END IF;
2764:
2765: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INTERMED_SHIP_TO_ORG_ID,p_old_line_rec.INTERMED_SHIP_TO_ORG_ID)
2766: THEN

Line 2768: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG;

2764:
2765: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INTERMED_SHIP_TO_ORG_ID,p_old_line_rec.INTERMED_SHIP_TO_ORG_ID)
2766: THEN
2767: l_index := l_index + 1.0;
2768: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG;
2769: END IF;
2770:
2771:
2772:

Line 2776: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVENTORY_ITEM;

2772:
2773: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVENTORY_ITEM_ID,p_old_line_rec.INVENTORY_ITEM_ID)
2774: THEN
2775: l_index := l_index + 1.0;
2776: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVENTORY_ITEM;
2777: END IF;
2778: --sol_ord_er #16014165
2779: IF NOT OE_GLOBALS.Equal(p_x_line_rec.subscription_enable_flag,p_old_line_rec.subscription_enable_flag)
2780: THEN

Line 2782: l_src_attr_tbl(l_index) := OE_LINE_UTIL.g_subscription_enable_flag;

2778: --sol_ord_er #16014165
2779: IF NOT OE_GLOBALS.Equal(p_x_line_rec.subscription_enable_flag,p_old_line_rec.subscription_enable_flag)
2780: THEN
2781: l_index := l_index + 1.0;
2782: l_src_attr_tbl(l_index) := OE_LINE_UTIL.g_subscription_enable_flag;
2783: END IF;
2784: --sol_ord_er #16014165 end
2785:
2786: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVOICE_TO_ORG_ID,p_old_line_rec.INVOICE_TO_ORG_ID)

Line 2789: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVOICE_TO_ORG;

2785:
2786: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVOICE_TO_ORG_ID,p_old_line_rec.INVOICE_TO_ORG_ID)
2787: THEN
2788: l_index := l_index + 1.0;
2789: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVOICE_TO_ORG;
2790: END IF;
2791:
2792: IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_NUMBER,p_old_line_rec.LINE_NUMBER)
2793: THEN

Line 2795: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_NUMBER;

2791:
2792: IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_NUMBER,p_old_line_rec.LINE_NUMBER)
2793: THEN
2794: l_index := l_index + 1.0;
2795: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_NUMBER;
2796: END IF;
2797:
2798: IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_TYPE_ID,p_old_line_rec.LINE_TYPE_ID)
2799: THEN

Line 2801: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_TYPE;

2797:
2798: IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_TYPE_ID,p_old_line_rec.LINE_TYPE_ID)
2799: THEN
2800: l_index := l_index + 1.0;
2801: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_TYPE;
2802: END IF;
2803:
2804: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICE_LIST_ID,p_old_line_rec.PRICE_LIST_ID)
2805: THEN

Line 2807: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICE_LIST;

2803:
2804: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICE_LIST_ID,p_old_line_rec.PRICE_LIST_ID)
2805: THEN
2806: l_index := l_index + 1.0;
2807: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICE_LIST;
2808: END IF;
2809:
2810: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PROMISE_DATE,p_old_line_rec.PROMISE_DATE)
2811: THEN

Line 2813: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PROMISE_DATE;

2809:
2810: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PROMISE_DATE,p_old_line_rec.PROMISE_DATE)
2811: THEN
2812: l_index := l_index + 1.0;
2813: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PROMISE_DATE;
2814: END IF;
2815:
2816: IF NOT OE_GLOBALS.Equal(p_x_line_rec.REQUEST_DATE,p_old_line_rec.REQUEST_DATE)
2817: THEN

Line 2819: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_REQUEST_DATE;

2815:
2816: IF NOT OE_GLOBALS.Equal(p_x_line_rec.REQUEST_DATE,p_old_line_rec.REQUEST_DATE)
2817: THEN
2818: l_index := l_index + 1.0;
2819: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_REQUEST_DATE;
2820: END IF;
2821:
2822: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SCHEDULE_SHIP_DATE,p_old_line_rec.SCHEDULE_SHIP_DATE)
2823: THEN

Line 2825: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;

2821:
2822: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SCHEDULE_SHIP_DATE,p_old_line_rec.SCHEDULE_SHIP_DATE)
2823: THEN
2824: l_index := l_index + 1.0;
2825: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;
2826: END IF;
2827:
2828: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_FROM_ORG_ID,p_old_line_rec.SHIP_FROM_ORG_ID)
2829: THEN

Line 2831: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_FROM_ORG;

2827:
2828: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_FROM_ORG_ID,p_old_line_rec.SHIP_FROM_ORG_ID)
2829: THEN
2830: l_index := l_index + 1.0;
2831: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_FROM_ORG;
2832: END IF;
2833:
2834: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SUBINVENTORY,p_old_line_rec.SUBINVENTORY)
2835: THEN

Line 2837: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SUBINVENTORY;

2833:
2834: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SUBINVENTORY,p_old_line_rec.SUBINVENTORY)
2835: THEN
2836: l_index := l_index + 1.0;
2837: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SUBINVENTORY;
2838: END IF;
2839:
2840: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_TO_ORG_ID,p_old_line_rec.SHIP_TO_ORG_ID)
2841: THEN

Line 2843: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_TO_ORG;

2839:
2840: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_TO_ORG_ID,p_old_line_rec.SHIP_TO_ORG_ID)
2841: THEN
2842: l_index := l_index + 1.0;
2843: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_TO_ORG;
2844: END IF;
2845:
2846: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SOLD_TO_ORG_ID,p_old_line_rec.SOLD_TO_ORG_ID)
2847: THEN

Line 2849: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SOLD_TO_ORG;

2845:
2846: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SOLD_TO_ORG_ID,p_old_line_rec.SOLD_TO_ORG_ID)
2847: THEN
2848: l_index := l_index + 1.0;
2849: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SOLD_TO_ORG;
2850: END IF;
2851:
2852: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_CODE,p_old_line_rec.TAX_CODE)
2853: THEN

Line 2855: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX;

2851:
2852: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_CODE,p_old_line_rec.TAX_CODE)
2853: THEN
2854: l_index := l_index + 1.0;
2855: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX;
2856: END IF;
2857:
2858: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_DATE,p_old_line_rec.TAX_DATE)
2859: THEN

Line 2861: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_DATE;

2857:
2858: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_DATE,p_old_line_rec.TAX_DATE)
2859: THEN
2860: l_index := l_index + 1.0;
2861: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_DATE;
2862: END IF;
2863:
2864: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG,p_old_line_rec.TAX_EXEMPT_FLAG)
2865: THEN

Line 2867: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_EXEMPT;

2863:
2864: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG,p_old_line_rec.TAX_EXEMPT_FLAG)
2865: THEN
2866: l_index := l_index + 1.0;
2867: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_EXEMPT;
2868: END IF;
2869: --Added following condition for Bug 2245073
2870: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICING_DATE, p_old_line_rec.PRICING_DATE
2871: ) Then

Line 2873: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICING_DATE;

2869: --Added following condition for Bug 2245073
2870: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICING_DATE, p_old_line_rec.PRICING_DATE
2871: ) Then
2872: l_index := l_index + 1.0;
2873: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICING_DATE;
2874: End If;
2875:
2876: -- The next two IF statements added for bug 5076119
2877: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDERED_QUANTITY, p_old_line_rec.ORDERED_QUANTITY)

Line 2880: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDERED_QUANTITY;

2876: -- The next two IF statements added for bug 5076119
2877: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDERED_QUANTITY, p_old_line_rec.ORDERED_QUANTITY)
2878: THEN
2879: l_index := l_index + 1.0;
2880: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDERED_QUANTITY;
2881: END IF;
2882:
2883: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDER_QUANTITY_UOM, p_old_line_rec.ORDER_QUANTITY_UOM)
2884: THEN

Line 2886: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDER_QUANTITY_UOM;

2882:
2883: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDER_QUANTITY_UOM, p_old_line_rec.ORDER_QUANTITY_UOM)
2884: THEN
2885: l_index := l_index + 1.0;
2886: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDER_QUANTITY_UOM;
2887: END IF;
2888:
2889: --bug 13088960
2890: IF NOT OE_GLOBALS.Equal(p_x_line_rec.shipping_method_code, p_old_line_rec.shipping_method_code)

Line 2893: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIPPING_METHOD ;

2889: --bug 13088960
2890: IF NOT OE_GLOBALS.Equal(p_x_line_rec.shipping_method_code, p_old_line_rec.shipping_method_code)
2891: THEN
2892: l_index := l_index + 1.0;
2893: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIPPING_METHOD ;
2894: END IF;
2895: ---end 13088960
2896:
2897: END IF;

Line 2906: oe_debug_pub.add('Exiting OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);

2902: ,p_old_line_rec => p_old_line_rec
2903: ,p_x_line_rec => p_x_line_rec
2904: ,x_dep_attr_exists => l_dep_attr_exists);
2905:
2906: oe_debug_pub.add('Exiting OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2907:
2908: EXCEPTION
2909: WHEN FND_API.G_EXC_ERROR THEN
2910: RAISE FND_API.G_EXC_ERROR;

Line 3027: END OE_Line_Util_Ext;

3023: END IF;
3024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3025: END Clear_Dep_And_Default;
3026:
3027: END OE_Line_Util_Ext;