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.4 2006/04/17 03:45:25 pviprana noship $ */
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.4 2006/04/17 03:45:25 pviprana noship $ */
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 1290: IF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE THEN

1286: -- procedure if it is the dependent attribute.
1287: -- Also, eliminate unnecessary code for attribute that cannot be
1288: -- dependent attributes
1289:
1290: IF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE THEN
1291: ACCOUNTING_RULE;
1292: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE_DURATION THEN
1293: ACCOUNTING_RULE_DURATION;
1294: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_AGREEMENT THEN

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

1288: -- dependent attributes
1289:
1290: IF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE THEN
1291: ACCOUNTING_RULE;
1292: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE_DURATION THEN
1293: ACCOUNTING_RULE_DURATION;
1294: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_AGREEMENT THEN
1295: AGREEMENT;
1296: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ATO_LINE THEN

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

1290: IF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE THEN
1291: ACCOUNTING_RULE;
1292: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE_DURATION THEN
1293: ACCOUNTING_RULE_DURATION;
1294: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_AGREEMENT THEN
1295: AGREEMENT;
1296: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ATO_LINE THEN
1297: ATO_LINE;
1298: --For bug 3571400

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

1292: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE_DURATION THEN
1293: ACCOUNTING_RULE_DURATION;
1294: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_AGREEMENT THEN
1295: AGREEMENT;
1296: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ATO_LINE THEN
1297: ATO_LINE;
1298: --For bug 3571400
1299: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_NUMBER THEN
1300: BLANKET_NUMBER;

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

1295: AGREEMENT;
1296: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ATO_LINE THEN
1297: ATO_LINE;
1298: --For bug 3571400
1299: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_NUMBER THEN
1300: BLANKET_NUMBER;
1301: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_LINE_NUMBER THEN
1302: BLANKET_LINE_NUMBER;
1303: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_VERSION_NUMBER THEN

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

1297: ATO_LINE;
1298: --For bug 3571400
1299: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_NUMBER THEN
1300: BLANKET_NUMBER;
1301: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_LINE_NUMBER THEN
1302: BLANKET_LINE_NUMBER;
1303: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_VERSION_NUMBER THEN
1304: BLANKET_VERSION_NUMBER;
1305: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMMITMENT THEN

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

1299: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_NUMBER THEN
1300: BLANKET_NUMBER;
1301: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_LINE_NUMBER THEN
1302: BLANKET_LINE_NUMBER;
1303: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_VERSION_NUMBER THEN
1304: BLANKET_VERSION_NUMBER;
1305: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMMITMENT THEN
1306: COMMITMENT;
1307: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT THEN

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

1301: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_LINE_NUMBER THEN
1302: BLANKET_LINE_NUMBER;
1303: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_VERSION_NUMBER THEN
1304: BLANKET_VERSION_NUMBER;
1305: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMMITMENT THEN
1306: COMMITMENT;
1307: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT THEN
1308: COMPONENT;
1309: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT_SEQUENCE THEN

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

1303: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_VERSION_NUMBER THEN
1304: BLANKET_VERSION_NUMBER;
1305: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMMITMENT THEN
1306: COMMITMENT;
1307: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT THEN
1308: COMPONENT;
1309: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT_SEQUENCE THEN
1310: COMPONENT_SEQUENCE;
1311: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SORT_ORDER THEN

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

1305: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMMITMENT THEN
1306: COMMITMENT;
1307: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT THEN
1308: COMPONENT;
1309: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT_SEQUENCE THEN
1310: COMPONENT_SEQUENCE;
1311: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SORT_ORDER THEN
1312: SORT_ORDER;
1313: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUST_PO_NUMBER THEN

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

1307: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT THEN
1308: COMPONENT;
1309: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT_SEQUENCE THEN
1310: COMPONENT_SEQUENCE;
1311: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SORT_ORDER THEN
1312: SORT_ORDER;
1313: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUST_PO_NUMBER THEN
1314: CUST_PO_NUMBER;
1315: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUSTOMER_LINE_NUMBER THEN --For 2844285

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

1309: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT_SEQUENCE THEN
1310: COMPONENT_SEQUENCE;
1311: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SORT_ORDER THEN
1312: SORT_ORDER;
1313: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUST_PO_NUMBER THEN
1314: CUST_PO_NUMBER;
1315: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUSTOMER_LINE_NUMBER THEN --For 2844285
1316: CUSTOMER_LINE_NUMBER;
1317: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_CONTACT THEN

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

1311: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SORT_ORDER THEN
1312: SORT_ORDER;
1313: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUST_PO_NUMBER THEN
1314: CUST_PO_NUMBER;
1315: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUSTOMER_LINE_NUMBER THEN --For 2844285
1316: CUSTOMER_LINE_NUMBER;
1317: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_CONTACT THEN
1318: DELIVER_TO_CONTACT;
1319: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_ORG THEN

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

1313: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUST_PO_NUMBER THEN
1314: CUST_PO_NUMBER;
1315: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUSTOMER_LINE_NUMBER THEN --For 2844285
1316: CUSTOMER_LINE_NUMBER;
1317: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_CONTACT THEN
1318: DELIVER_TO_CONTACT;
1319: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_ORG THEN
1320: DELIVER_TO_ORG;
1321: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEMAND_CLASS THEN

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

1315: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUSTOMER_LINE_NUMBER THEN --For 2844285
1316: CUSTOMER_LINE_NUMBER;
1317: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_CONTACT THEN
1318: DELIVER_TO_CONTACT;
1319: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_ORG THEN
1320: DELIVER_TO_ORG;
1321: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEMAND_CLASS THEN
1322: DEMAND_CLASS;
1323: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEP_PLAN_REQUIRED THEN

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

1317: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_CONTACT THEN
1318: DELIVER_TO_CONTACT;
1319: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_ORG THEN
1320: DELIVER_TO_ORG;
1321: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEMAND_CLASS THEN
1322: DEMAND_CLASS;
1323: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEP_PLAN_REQUIRED THEN
1324: DEP_PLAN_REQUIRED;
1325: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_ITEM_UNIT_NUMBER THEN

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

1319: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_ORG THEN
1320: DELIVER_TO_ORG;
1321: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEMAND_CLASS THEN
1322: DEMAND_CLASS;
1323: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEP_PLAN_REQUIRED THEN
1324: DEP_PLAN_REQUIRED;
1325: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_ITEM_UNIT_NUMBER THEN
1326: END_ITEM_UNIT_NUMBER;
1327: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FOB_POINT THEN

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

1321: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEMAND_CLASS THEN
1322: DEMAND_CLASS;
1323: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEP_PLAN_REQUIRED THEN
1324: DEP_PLAN_REQUIRED;
1325: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_ITEM_UNIT_NUMBER THEN
1326: END_ITEM_UNIT_NUMBER;
1327: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FOB_POINT THEN
1328: FOB_POINT;
1329: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FREIGHT_TERMS THEN

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

1323: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEP_PLAN_REQUIRED THEN
1324: DEP_PLAN_REQUIRED;
1325: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_ITEM_UNIT_NUMBER THEN
1326: END_ITEM_UNIT_NUMBER;
1327: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FOB_POINT THEN
1328: FOB_POINT;
1329: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FREIGHT_TERMS THEN
1330: FREIGHT_TERMS;
1331: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_CONTACT THEN

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

1325: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_ITEM_UNIT_NUMBER THEN
1326: END_ITEM_UNIT_NUMBER;
1327: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FOB_POINT THEN
1328: FOB_POINT;
1329: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FREIGHT_TERMS THEN
1330: FREIGHT_TERMS;
1331: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_CONTACT THEN
1332: INTERMED_SHIP_TO_CONTACT;
1333: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG THEN

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

1327: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FOB_POINT THEN
1328: FOB_POINT;
1329: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FREIGHT_TERMS THEN
1330: FREIGHT_TERMS;
1331: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_CONTACT THEN
1332: INTERMED_SHIP_TO_CONTACT;
1333: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG THEN
1334: INTERMED_SHIP_TO_ORG;
1335: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_CONTACT THEN

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

1329: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FREIGHT_TERMS THEN
1330: FREIGHT_TERMS;
1331: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_CONTACT THEN
1332: INTERMED_SHIP_TO_CONTACT;
1333: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG THEN
1334: INTERMED_SHIP_TO_ORG;
1335: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_CONTACT THEN
1336: INVOICE_TO_CONTACT;
1337: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_ORG THEN

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

1331: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_CONTACT THEN
1332: INTERMED_SHIP_TO_CONTACT;
1333: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG THEN
1334: INTERMED_SHIP_TO_ORG;
1335: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_CONTACT THEN
1336: INVOICE_TO_CONTACT;
1337: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_ORG THEN
1338: INVOICE_TO_ORG;
1339: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICING_RULE THEN

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

1333: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG THEN
1334: INTERMED_SHIP_TO_ORG;
1335: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_CONTACT THEN
1336: INVOICE_TO_CONTACT;
1337: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_ORG THEN
1338: INVOICE_TO_ORG;
1339: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICING_RULE THEN
1340: INVOICING_RULE;
1341: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_IDENTIFIER_TYPE THEN

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

1335: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_CONTACT THEN
1336: INVOICE_TO_CONTACT;
1337: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_ORG THEN
1338: INVOICE_TO_ORG;
1339: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICING_RULE THEN
1340: INVOICING_RULE;
1341: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_IDENTIFIER_TYPE THEN
1342: ITEM_IDENTIFIER_TYPE;
1343: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_REVISION THEN -- For bug 2951575

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

1337: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_ORG THEN
1338: INVOICE_TO_ORG;
1339: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICING_RULE THEN
1340: INVOICING_RULE;
1341: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_IDENTIFIER_TYPE THEN
1342: ITEM_IDENTIFIER_TYPE;
1343: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_REVISION THEN -- For bug 2951575
1344: ITEM_REVISION;
1345: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_TYPE THEN

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

1339: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICING_RULE THEN
1340: INVOICING_RULE;
1341: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_IDENTIFIER_TYPE THEN
1342: ITEM_IDENTIFIER_TYPE;
1343: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_REVISION THEN -- For bug 2951575
1344: ITEM_REVISION;
1345: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_TYPE THEN
1346: ITEM_TYPE;
1347: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_TYPE THEN

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

1341: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_IDENTIFIER_TYPE THEN
1342: ITEM_IDENTIFIER_TYPE;
1343: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_REVISION THEN -- For bug 2951575
1344: ITEM_REVISION;
1345: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_TYPE THEN
1346: ITEM_TYPE;
1347: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_TYPE THEN
1348: LINE_TYPE;
1349: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_CATEGORY THEN

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

1343: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_REVISION THEN -- For bug 2951575
1344: ITEM_REVISION;
1345: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_TYPE THEN
1346: ITEM_TYPE;
1347: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_TYPE THEN
1348: LINE_TYPE;
1349: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_CATEGORY THEN
1350: LINE_CATEGORY;
1351: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_OPTION_NUMBER THEN

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

1345: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_TYPE THEN
1346: ITEM_TYPE;
1347: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_TYPE THEN
1348: LINE_TYPE;
1349: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_CATEGORY THEN
1350: LINE_CATEGORY;
1351: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_OPTION_NUMBER THEN
1352: OPTION_NUMBER;
1353: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_ITEM THEN

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

1347: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_TYPE THEN
1348: LINE_TYPE;
1349: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_CATEGORY THEN
1350: LINE_CATEGORY;
1351: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_OPTION_NUMBER THEN
1352: OPTION_NUMBER;
1353: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_ITEM THEN
1354: ORDERED_ITEM;
1355: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_QUANTITY_UOM THEN

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

1349: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_CATEGORY THEN
1350: LINE_CATEGORY;
1351: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_OPTION_NUMBER THEN
1352: OPTION_NUMBER;
1353: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_ITEM THEN
1354: ORDERED_ITEM;
1355: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_QUANTITY_UOM THEN
1356: ORDER_QUANTITY_UOM;
1357: -- OPM 02/JUN/00 BEGIN

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

1351: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_OPTION_NUMBER THEN
1352: OPTION_NUMBER;
1353: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_ITEM THEN
1354: ORDERED_ITEM;
1355: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_QUANTITY_UOM THEN
1356: ORDER_QUANTITY_UOM;
1357: -- OPM 02/JUN/00 BEGIN
1358: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY_UOM2 THEN
1359: ORDERED_QUANTITY_UOM2;

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

1354: ORDERED_ITEM;
1355: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_QUANTITY_UOM THEN
1356: ORDER_QUANTITY_UOM;
1357: -- OPM 02/JUN/00 BEGIN
1358: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY_UOM2 THEN
1359: ORDERED_QUANTITY_UOM2;
1360: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY2 THEN
1361: ORDERED_QUANTITY2; -- Bug3016136
1362: -- OPM 02/JUN/00 END

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

1356: ORDER_QUANTITY_UOM;
1357: -- OPM 02/JUN/00 BEGIN
1358: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY_UOM2 THEN
1359: ORDERED_QUANTITY_UOM2;
1360: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY2 THEN
1361: ORDERED_QUANTITY2; -- Bug3016136
1362: -- OPM 02/JUN/00 END
1363: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PAYMENT_TERM THEN
1364: PAYMENT_TERM;

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

1359: ORDERED_QUANTITY_UOM2;
1360: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY2 THEN
1361: ORDERED_QUANTITY2; -- Bug3016136
1362: -- OPM 02/JUN/00 END
1363: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PAYMENT_TERM THEN
1364: PAYMENT_TERM;
1365: -- OPM 02/JUN/00 BEGIN
1366: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PREFERRED_GRADE THEN
1367: PREFERRED_GRADE;

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

1362: -- OPM 02/JUN/00 END
1363: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PAYMENT_TERM THEN
1364: PAYMENT_TERM;
1365: -- OPM 02/JUN/00 BEGIN
1366: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PREFERRED_GRADE THEN
1367: PREFERRED_GRADE;
1368: -- OPM 02/JUN/00 END
1369: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_LIST THEN
1370: PRICE_LIST;

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

1365: -- OPM 02/JUN/00 BEGIN
1366: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PREFERRED_GRADE THEN
1367: PREFERRED_GRADE;
1368: -- OPM 02/JUN/00 END
1369: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_LIST THEN
1370: PRICE_LIST;
1371: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_REQUEST_CODE THEN
1372: PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
1373: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICING_QUANTITY_UOM THEN

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

1367: PREFERRED_GRADE;
1368: -- OPM 02/JUN/00 END
1369: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_LIST THEN
1370: PRICE_LIST;
1371: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_REQUEST_CODE THEN
1372: PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
1373: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICING_QUANTITY_UOM THEN
1374: PRICING_QUANTITY_UOM;
1375: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PROMISE_DATE THEN

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

1369: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_LIST THEN
1370: PRICE_LIST;
1371: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_REQUEST_CODE THEN
1372: PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
1373: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICING_QUANTITY_UOM THEN
1374: PRICING_QUANTITY_UOM;
1375: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PROMISE_DATE THEN
1376: PROMISE_DATE;
1377: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_REQUEST_DATE THEN

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

1371: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_REQUEST_CODE THEN
1372: PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
1373: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICING_QUANTITY_UOM THEN
1374: PRICING_QUANTITY_UOM;
1375: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PROMISE_DATE THEN
1376: PROMISE_DATE;
1377: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_REQUEST_DATE THEN
1378: REQUEST_DATE;
1379: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SALESREP THEN

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

1373: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICING_QUANTITY_UOM THEN
1374: PRICING_QUANTITY_UOM;
1375: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PROMISE_DATE THEN
1376: PROMISE_DATE;
1377: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_REQUEST_DATE THEN
1378: REQUEST_DATE;
1379: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SALESREP THEN
1380: SALESREP;
1381: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE THEN

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

1375: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PROMISE_DATE THEN
1376: PROMISE_DATE;
1377: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_REQUEST_DATE THEN
1378: REQUEST_DATE;
1379: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SALESREP THEN
1380: SALESREP;
1381: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE THEN
1382: SCHEDULE_SHIP_DATE;
1383: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_NUMBER THEN

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

1377: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_REQUEST_DATE THEN
1378: REQUEST_DATE;
1379: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SALESREP THEN
1380: SALESREP;
1381: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE THEN
1382: SCHEDULE_SHIP_DATE;
1383: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_NUMBER THEN
1384: SHIPMENT_NUMBER;
1385: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_PRIORITY THEN

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

1379: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SALESREP THEN
1380: SALESREP;
1381: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE THEN
1382: SCHEDULE_SHIP_DATE;
1383: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_NUMBER THEN
1384: SHIPMENT_NUMBER;
1385: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_PRIORITY THEN
1386: SHIPMENT_PRIORITY;
1387: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPABLE THEN

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

1381: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE THEN
1382: SCHEDULE_SHIP_DATE;
1383: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_NUMBER THEN
1384: SHIPMENT_NUMBER;
1385: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_PRIORITY THEN
1386: SHIPMENT_PRIORITY;
1387: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPABLE THEN
1388: SHIPPABLE;
1389: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_METHOD THEN

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

1383: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_NUMBER THEN
1384: SHIPMENT_NUMBER;
1385: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_PRIORITY THEN
1386: SHIPMENT_PRIORITY;
1387: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPABLE THEN
1388: SHIPPABLE;
1389: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_METHOD THEN
1390: SHIPPING_METHOD;
1391: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_FROM_ORG THEN

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

1385: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_PRIORITY THEN
1386: SHIPMENT_PRIORITY;
1387: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPABLE THEN
1388: SHIPPABLE;
1389: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_METHOD THEN
1390: SHIPPING_METHOD;
1391: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_FROM_ORG THEN
1392: SHIP_FROM_ORG;
1393: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SUBINVENTORY THEN

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

1387: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPABLE THEN
1388: SHIPPABLE;
1389: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_METHOD THEN
1390: SHIPPING_METHOD;
1391: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_FROM_ORG THEN
1392: SHIP_FROM_ORG;
1393: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SUBINVENTORY THEN
1394: SUBINVENTORY;
1395: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_ABOVE THEN

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

1389: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_METHOD THEN
1390: SHIPPING_METHOD;
1391: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_FROM_ORG THEN
1392: SHIP_FROM_ORG;
1393: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SUBINVENTORY THEN
1394: SUBINVENTORY;
1395: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
1396: SHIP_TOLERANCE_ABOVE;
1397: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_BELOW THEN

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

1391: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_FROM_ORG THEN
1392: SHIP_FROM_ORG;
1393: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SUBINVENTORY THEN
1394: SUBINVENTORY;
1395: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
1396: SHIP_TOLERANCE_ABOVE;
1397: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_BELOW THEN
1398: SHIP_TOLERANCE_BELOW;
1399: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_CONTACT THEN

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

1393: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SUBINVENTORY THEN
1394: SUBINVENTORY;
1395: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
1396: SHIP_TOLERANCE_ABOVE;
1397: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_BELOW THEN
1398: SHIP_TOLERANCE_BELOW;
1399: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_CONTACT THEN
1400: SHIP_TO_CONTACT;
1401: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_ORG THEN

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

1395: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
1396: SHIP_TOLERANCE_ABOVE;
1397: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_BELOW THEN
1398: SHIP_TOLERANCE_BELOW;
1399: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_CONTACT THEN
1400: SHIP_TO_CONTACT;
1401: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_ORG THEN
1402: SHIP_TO_ORG;
1403: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOLD_TO_ORG THEN

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

1397: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_BELOW THEN
1398: SHIP_TOLERANCE_BELOW;
1399: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_CONTACT THEN
1400: SHIP_TO_CONTACT;
1401: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_ORG THEN
1402: SHIP_TO_ORG;
1403: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOLD_TO_ORG THEN
1404: SOLD_TO_ORG;
1405: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX THEN

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

1399: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_CONTACT THEN
1400: SHIP_TO_CONTACT;
1401: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_ORG THEN
1402: SHIP_TO_ORG;
1403: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOLD_TO_ORG THEN
1404: SOLD_TO_ORG;
1405: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX THEN
1406: TAX;
1407: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_DATE THEN

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

1401: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_ORG THEN
1402: SHIP_TO_ORG;
1403: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOLD_TO_ORG THEN
1404: SOLD_TO_ORG;
1405: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX THEN
1406: TAX;
1407: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_DATE THEN
1408: TAX_DATE;
1409: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT THEN

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

1403: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOLD_TO_ORG THEN
1404: SOLD_TO_ORG;
1405: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX THEN
1406: TAX;
1407: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_DATE THEN
1408: TAX_DATE;
1409: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT THEN
1410: TAX_EXEMPT;
1411: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_NUMBER THEN

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

1405: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX THEN
1406: TAX;
1407: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_DATE THEN
1408: TAX_DATE;
1409: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT THEN
1410: TAX_EXEMPT;
1411: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_NUMBER THEN
1412: TAX_EXEMPT_NUMBER;
1413: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_REASON THEN

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

1407: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_DATE THEN
1408: TAX_DATE;
1409: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT THEN
1410: TAX_EXEMPT;
1411: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_NUMBER THEN
1412: TAX_EXEMPT_NUMBER;
1413: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_REASON THEN
1414: TAX_EXEMPT_REASON;
1415: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TOP_MODEL_LINE THEN

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

1409: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT THEN
1410: TAX_EXEMPT;
1411: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_NUMBER THEN
1412: TAX_EXEMPT_NUMBER;
1413: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_REASON THEN
1414: TAX_EXEMPT_REASON;
1415: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TOP_MODEL_LINE THEN
1416: TOP_MODEL_LINE;
1417: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_START_DATE THEN

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

1411: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_NUMBER THEN
1412: TAX_EXEMPT_NUMBER;
1413: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_REASON THEN
1414: TAX_EXEMPT_REASON;
1415: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TOP_MODEL_LINE THEN
1416: TOP_MODEL_LINE;
1417: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_START_DATE THEN
1418: SERVICE_START_DATE;
1419: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_PERIOD THEN

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

1413: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_REASON THEN
1414: TAX_EXEMPT_REASON;
1415: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TOP_MODEL_LINE THEN
1416: TOP_MODEL_LINE;
1417: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_START_DATE THEN
1418: SERVICE_START_DATE;
1419: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_PERIOD THEN
1420: SERVICE_PERIOD;
1421: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_REFERENCE_TYPE_CODE THEN

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

1415: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TOP_MODEL_LINE THEN
1416: TOP_MODEL_LINE;
1417: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_START_DATE THEN
1418: SERVICE_START_DATE;
1419: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_PERIOD THEN
1420: SERVICE_PERIOD;
1421: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_REFERENCE_TYPE_CODE THEN
1422: SERVICE_REFERENCE_TYPE_CODE;
1423: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_RETURN_CONTEXT THEN

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

1417: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_START_DATE THEN
1418: SERVICE_START_DATE;
1419: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_PERIOD THEN
1420: SERVICE_PERIOD;
1421: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_REFERENCE_TYPE_CODE THEN
1422: SERVICE_REFERENCE_TYPE_CODE;
1423: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_RETURN_CONTEXT THEN
1424: RETURN_CONTEXT;
1425: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOURCE_TYPE THEN

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

1419: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_PERIOD THEN
1420: SERVICE_PERIOD;
1421: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_REFERENCE_TYPE_CODE THEN
1422: SERVICE_REFERENCE_TYPE_CODE;
1423: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_RETURN_CONTEXT THEN
1424: RETURN_CONTEXT;
1425: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOURCE_TYPE THEN
1426: SOURCE_TYPE;
1427: -- Add for bug 2766005

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

1421: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_REFERENCE_TYPE_CODE THEN
1422: SERVICE_REFERENCE_TYPE_CODE;
1423: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_RETURN_CONTEXT THEN
1424: RETURN_CONTEXT;
1425: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOURCE_TYPE THEN
1426: SOURCE_TYPE;
1427: -- Add for bug 2766005
1428: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PACKING_INSTRUCTIONS THEN
1429: PACKING_INSTRUCTIONS;

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

1424: RETURN_CONTEXT;
1425: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOURCE_TYPE THEN
1426: SOURCE_TYPE;
1427: -- Add for bug 2766005
1428: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PACKING_INSTRUCTIONS THEN
1429: PACKING_INSTRUCTIONS;
1430: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_INSTRUCTIONS THEN
1431: SHIPPING_INSTRUCTIONS;
1432: -- End of code for bug 2766005

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

1426: SOURCE_TYPE;
1427: -- Add for bug 2766005
1428: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PACKING_INSTRUCTIONS THEN
1429: PACKING_INSTRUCTIONS;
1430: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_INSTRUCTIONS THEN
1431: SHIPPING_INSTRUCTIONS;
1432: -- End of code for bug 2766005
1433: -- Distributed orders
1434: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER THEN

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

1430: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_INSTRUCTIONS THEN
1431: SHIPPING_INSTRUCTIONS;
1432: -- End of code for bug 2766005
1433: -- Distributed orders
1434: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER THEN
1435: END_CUSTOMER;
1436: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_CONTACT THEN
1437: END_CUSTOMER_CONTACT;
1438: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_SITE_USE THEN

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

1432: -- End of code for bug 2766005
1433: -- Distributed orders
1434: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER THEN
1435: END_CUSTOMER;
1436: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_CONTACT THEN
1437: END_CUSTOMER_CONTACT;
1438: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_SITE_USE THEN
1439: END_CUSTOMER_SITE_USE;
1440: -- bug 4283037

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

1434: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER THEN
1435: END_CUSTOMER;
1436: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_CONTACT THEN
1437: END_CUSTOMER_CONTACT;
1438: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_SITE_USE THEN
1439: END_CUSTOMER_SITE_USE;
1440: -- bug 4283037
1441: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_DURATION THEN
1442: SERVICE_DURATION;

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

1437: END_CUSTOMER_CONTACT;
1438: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_SITE_USE THEN
1439: END_CUSTOMER_SITE_USE;
1440: -- bug 4283037
1441: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_DURATION THEN
1442: SERVICE_DURATION;
1443: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_FIRMED_DATE and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >='110509'
1444: THEN --key Transaction Dates Project
1445: ORDER_FIRMED_DATE ;

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

1439: END_CUSTOMER_SITE_USE;
1440: -- bug 4283037
1441: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_DURATION THEN
1442: SERVICE_DURATION;
1443: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_FIRMED_DATE and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >='110509'
1444: THEN --key Transaction Dates Project
1445: ORDER_FIRMED_DATE ;
1446: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CHARGE_PERIODICITY THEN
1447: CHARGE_PERIODICITY;

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

1442: SERVICE_DURATION;
1443: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_FIRMED_DATE and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >='110509'
1444: THEN --key Transaction Dates Project
1445: ORDER_FIRMED_DATE ;
1446: ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CHARGE_PERIODICITY THEN
1447: CHARGE_PERIODICITY;
1448: END IF;
1449: END LOOP;
1450: END IF;

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

2539: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
2540: l_dep_attr_exists VARCHAR2(1);
2541: BEGIN
2542:
2543: oe_debug_pub.add('Entering OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2544: oe_debug_pub.add('Attr Id: '||p_attr_id);
2545:
2546:
2547: IF p_attr_id <> FND_API.G_MISS_NUM THEN

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

2556:
2557: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ACCOUNTING_RULE_ID,p_old_line_rec.ACCOUNTING_RULE_ID)
2558: THEN
2559: l_index := l_index + 1.0;
2560: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ACCOUNTING_RULE;
2561: END IF;
2562:
2563: IF NOT OE_GLOBALS.Equal(p_x_line_rec.AGREEMENT_ID,p_old_line_rec.AGREEMENT_ID)
2564: THEN

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

2562:
2563: IF NOT OE_GLOBALS.Equal(p_x_line_rec.AGREEMENT_ID,p_old_line_rec.AGREEMENT_ID)
2564: THEN
2565: l_index := l_index + 1.0;
2566: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_AGREEMENT;
2567: END IF;
2568:
2569: IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_number,p_old_line_rec.blanket_number)
2570: THEN

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

2568:
2569: IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_number,p_old_line_rec.blanket_number)
2570: THEN
2571: l_index := l_index + 1.0;
2572: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_NUMBER;
2573: END IF;
2574:
2575: IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_line_number,p_old_line_rec.blanket_line_number)
2576: THEN

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

2574:
2575: IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_line_number,p_old_line_rec.blanket_line_number)
2576: THEN
2577: l_index := l_index + 1.0;
2578: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_LINE_NUMBER;
2579: END IF;
2580:
2581: --bug5160469
2582: IF NOT OE_GLOBALS.Equal(p_x_line_rec.commitment_id,p_old_line_rec.commitment_id)

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

2581: --bug5160469
2582: IF NOT OE_GLOBALS.Equal(p_x_line_rec.commitment_id,p_old_line_rec.commitment_id)
2583: THEN
2584: l_index := l_index + 1.0;
2585: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_COMMITMENT;
2586: END IF;
2587:
2588: IF NOT OE_GLOBALS.Equal(p_x_line_rec.DELIVER_TO_ORG_ID,p_old_line_rec.DELIVER_TO_ORG_ID)
2589: THEN

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

2587:
2588: IF NOT OE_GLOBALS.Equal(p_x_line_rec.DELIVER_TO_ORG_ID,p_old_line_rec.DELIVER_TO_ORG_ID)
2589: THEN
2590: l_index := l_index + 1.0;
2591: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_DELIVER_TO_ORG;
2592: END IF;
2593:
2594: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INTERMED_SHIP_TO_ORG_ID,p_old_line_rec.INTERMED_SHIP_TO_ORG_ID)
2595: THEN

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

2593:
2594: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INTERMED_SHIP_TO_ORG_ID,p_old_line_rec.INTERMED_SHIP_TO_ORG_ID)
2595: THEN
2596: l_index := l_index + 1.0;
2597: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG;
2598: END IF;
2599:
2600:
2601:

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

2601:
2602: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVENTORY_ITEM_ID,p_old_line_rec.INVENTORY_ITEM_ID)
2603: THEN
2604: l_index := l_index + 1.0;
2605: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVENTORY_ITEM;
2606: END IF;
2607:
2608: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVOICE_TO_ORG_ID,p_old_line_rec.INVOICE_TO_ORG_ID)
2609: THEN

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

2607:
2608: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVOICE_TO_ORG_ID,p_old_line_rec.INVOICE_TO_ORG_ID)
2609: THEN
2610: l_index := l_index + 1.0;
2611: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVOICE_TO_ORG;
2612: END IF;
2613:
2614: IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_NUMBER,p_old_line_rec.LINE_NUMBER)
2615: THEN

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

2613:
2614: IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_NUMBER,p_old_line_rec.LINE_NUMBER)
2615: THEN
2616: l_index := l_index + 1.0;
2617: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_NUMBER;
2618: END IF;
2619:
2620: IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_TYPE_ID,p_old_line_rec.LINE_TYPE_ID)
2621: THEN

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

2619:
2620: IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_TYPE_ID,p_old_line_rec.LINE_TYPE_ID)
2621: THEN
2622: l_index := l_index + 1.0;
2623: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_TYPE;
2624: END IF;
2625:
2626: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICE_LIST_ID,p_old_line_rec.PRICE_LIST_ID)
2627: THEN

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

2625:
2626: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICE_LIST_ID,p_old_line_rec.PRICE_LIST_ID)
2627: THEN
2628: l_index := l_index + 1.0;
2629: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICE_LIST;
2630: END IF;
2631:
2632: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PROMISE_DATE,p_old_line_rec.PROMISE_DATE)
2633: THEN

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

2631:
2632: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PROMISE_DATE,p_old_line_rec.PROMISE_DATE)
2633: THEN
2634: l_index := l_index + 1.0;
2635: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PROMISE_DATE;
2636: END IF;
2637:
2638: IF NOT OE_GLOBALS.Equal(p_x_line_rec.REQUEST_DATE,p_old_line_rec.REQUEST_DATE)
2639: THEN

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

2637:
2638: IF NOT OE_GLOBALS.Equal(p_x_line_rec.REQUEST_DATE,p_old_line_rec.REQUEST_DATE)
2639: THEN
2640: l_index := l_index + 1.0;
2641: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_REQUEST_DATE;
2642: END IF;
2643:
2644: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SCHEDULE_SHIP_DATE,p_old_line_rec.SCHEDULE_SHIP_DATE)
2645: THEN

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

2643:
2644: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SCHEDULE_SHIP_DATE,p_old_line_rec.SCHEDULE_SHIP_DATE)
2645: THEN
2646: l_index := l_index + 1.0;
2647: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;
2648: END IF;
2649:
2650: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_FROM_ORG_ID,p_old_line_rec.SHIP_FROM_ORG_ID)
2651: THEN

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

2649:
2650: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_FROM_ORG_ID,p_old_line_rec.SHIP_FROM_ORG_ID)
2651: THEN
2652: l_index := l_index + 1.0;
2653: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_FROM_ORG;
2654: END IF;
2655:
2656: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SUBINVENTORY,p_old_line_rec.SUBINVENTORY)
2657: THEN

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

2655:
2656: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SUBINVENTORY,p_old_line_rec.SUBINVENTORY)
2657: THEN
2658: l_index := l_index + 1.0;
2659: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SUBINVENTORY;
2660: END IF;
2661:
2662: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_TO_ORG_ID,p_old_line_rec.SHIP_TO_ORG_ID)
2663: THEN

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

2661:
2662: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_TO_ORG_ID,p_old_line_rec.SHIP_TO_ORG_ID)
2663: THEN
2664: l_index := l_index + 1.0;
2665: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_TO_ORG;
2666: END IF;
2667:
2668: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SOLD_TO_ORG_ID,p_old_line_rec.SOLD_TO_ORG_ID)
2669: THEN

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

2667:
2668: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SOLD_TO_ORG_ID,p_old_line_rec.SOLD_TO_ORG_ID)
2669: THEN
2670: l_index := l_index + 1.0;
2671: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SOLD_TO_ORG;
2672: END IF;
2673:
2674: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_CODE,p_old_line_rec.TAX_CODE)
2675: THEN

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

2673:
2674: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_CODE,p_old_line_rec.TAX_CODE)
2675: THEN
2676: l_index := l_index + 1.0;
2677: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX;
2678: END IF;
2679:
2680: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_DATE,p_old_line_rec.TAX_DATE)
2681: THEN

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

2679:
2680: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_DATE,p_old_line_rec.TAX_DATE)
2681: THEN
2682: l_index := l_index + 1.0;
2683: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_DATE;
2684: END IF;
2685:
2686: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG,p_old_line_rec.TAX_EXEMPT_FLAG)
2687: THEN

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

2685:
2686: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG,p_old_line_rec.TAX_EXEMPT_FLAG)
2687: THEN
2688: l_index := l_index + 1.0;
2689: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_EXEMPT;
2690: END IF;
2691: --Added following condition for Bug 2245073
2692: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICING_DATE, p_old_line_rec.PRICING_DATE
2693: ) Then

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

2691: --Added following condition for Bug 2245073
2692: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICING_DATE, p_old_line_rec.PRICING_DATE
2693: ) Then
2694: l_index := l_index + 1.0;
2695: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICING_DATE;
2696: End If;
2697:
2698: -- The next two IF statements added for bug 5076119
2699: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDERED_QUANTITY, p_old_line_rec.ORDERED_QUANTITY)

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

2698: -- The next two IF statements added for bug 5076119
2699: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDERED_QUANTITY, p_old_line_rec.ORDERED_QUANTITY)
2700: THEN
2701: l_index := l_index + 1.0;
2702: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDERED_QUANTITY;
2703: END IF;
2704:
2705: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDER_QUANTITY_UOM, p_old_line_rec.ORDER_QUANTITY_UOM)
2706: THEN

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

2704:
2705: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDER_QUANTITY_UOM, p_old_line_rec.ORDER_QUANTITY_UOM)
2706: THEN
2707: l_index := l_index + 1.0;
2708: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDER_QUANTITY_UOM;
2709: END IF;
2710:
2711:
2712: END IF;

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

2717: ,p_old_line_rec => p_old_line_rec
2718: ,p_x_line_rec => p_x_line_rec
2719: ,x_dep_attr_exists => l_dep_attr_exists);
2720:
2721: oe_debug_pub.add('Exiting OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2722:
2723: EXCEPTION
2724: WHEN FND_API.G_EXC_ERROR THEN
2725: RAISE FND_API.G_EXC_ERROR;

Line 2842: END OE_Line_Util_Ext;

2838: END IF;
2839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2840: END Clear_Dep_And_Default;
2841:
2842: END OE_Line_Util_Ext;