DBA Data[Home] [Help]

APPS.FLM_SUPPLY_DEMAND dependencies on OE_INSTALL

Line 1571: l_oe_install VARCHAR2(10);

1567:
1568:
1569: l_oe_demand_rec OE_SALESORDER_DEMAND_CURSOR%ROWTYPE;
1570: l_ont_demand_rec ONT_SALESORDER_DEMAND_CURSOR%ROWTYPE;
1571: l_oe_install VARCHAR2(10);
1572: j NUMBER := Nvl(p_demand_table.LAST,0) + 1;
1573: BEGIN
1574:
1575: SELECT OE_INSTALL.Get_Active_Product

Line 1575: SELECT OE_INSTALL.Get_Active_Product

1571: l_oe_install VARCHAR2(10);
1572: j NUMBER := Nvl(p_demand_table.LAST,0) + 1;
1573: BEGIN
1574:
1575: SELECT OE_INSTALL.Get_Active_Product
1576: INTO l_oe_install
1577: FROM DUAL;
1578:
1579: IF l_oe_install = 'OE' THEN

Line 1576: INTO l_oe_install

1572: j NUMBER := Nvl(p_demand_table.LAST,0) + 1;
1573: BEGIN
1574:
1575: SELECT OE_INSTALL.Get_Active_Product
1576: INTO l_oe_install
1577: FROM DUAL;
1578:
1579: IF l_oe_install = 'OE' THEN
1580: OPEN OE_SALESORDER_DEMAND_CURSOR;

Line 1579: IF l_oe_install = 'OE' THEN

1575: SELECT OE_INSTALL.Get_Active_Product
1576: INTO l_oe_install
1577: FROM DUAL;
1578:
1579: IF l_oe_install = 'OE' THEN
1580: OPEN OE_SALESORDER_DEMAND_CURSOR;
1581:
1582: LOOP
1583: FETCH OE_SALESORDER_DEMAND_CURSOR INTO l_oe_demand_rec;