DBA Data[Home] [Help]

APPS.WPS_SUPPLY_DEMAND dependencies on OE_INSTALL

Line 1561: l_oe_install VARCHAR2(10);

1557:
1558:
1559: l_oe_demand_rec OE_SALESORDER_DEMAND_CURSOR%ROWTYPE;
1560: l_ont_demand_rec ONT_SALESORDER_DEMAND_CURSOR%ROWTYPE;
1561: l_oe_install VARCHAR2(10);
1562: j NUMBER := Nvl(p_demand_table.LAST,0) + 1;
1563: BEGIN
1564:
1565: SELECT OE_INSTALL.Get_Active_Product

Line 1565: SELECT OE_INSTALL.Get_Active_Product

1561: l_oe_install VARCHAR2(10);
1562: j NUMBER := Nvl(p_demand_table.LAST,0) + 1;
1563: BEGIN
1564:
1565: SELECT OE_INSTALL.Get_Active_Product
1566: INTO l_oe_install
1567: FROM DUAL;
1568:
1569: IF l_oe_install = 'OE' THEN

Line 1566: INTO l_oe_install

1562: j NUMBER := Nvl(p_demand_table.LAST,0) + 1;
1563: BEGIN
1564:
1565: SELECT OE_INSTALL.Get_Active_Product
1566: INTO l_oe_install
1567: FROM DUAL;
1568:
1569: IF l_oe_install = 'OE' THEN
1570: OPEN OE_SALESORDER_DEMAND_CURSOR;

Line 1569: IF l_oe_install = 'OE' THEN

1565: SELECT OE_INSTALL.Get_Active_Product
1566: INTO l_oe_install
1567: FROM DUAL;
1568:
1569: IF l_oe_install = 'OE' THEN
1570: OPEN OE_SALESORDER_DEMAND_CURSOR;
1571:
1572: LOOP
1573: FETCH OE_SALESORDER_DEMAND_CURSOR INTO l_oe_demand_rec;