DBA Data[Home] [Help]

APPS.WPS_SUPPLY_DEMAND dependencies on DUAL

Line 219: This procedure is a wrapper to collect all the individual supply types.

215: END Collect_Supply_Demand_Info;
216:
217:
218: /*
219: This procedure is a wrapper to collect all the individual supply types.
220: */
221: PROCEDURE Collect_Supply_Info(p_group_id IN NUMBER,
222: p_sys_seq_num IN NUMBER,
223: p_mrp_status IN NUMBER,

Line 287: This procedure is a wrapper to collect all the individual demand types.

283: END Collect_Supply_Info;
284:
285:
286: /*
287: This procedure is a wrapper to collect all the individual demand types.
288: */
289: PROCEDURE Collect_Demand_Info(p_group_id IN NUMBER,
290: p_sys_seq_num IN NUMBER,
291: p_mrp_status IN NUMBER,

Line 342: -- The procedures to collect individual supply/demand information follow.

338:
339:
340:
341: --
342: -- The procedures to collect individual supply/demand information follow.
343: --
344:
345:
346: PROCEDURE Collect_OnHand_Supply(p_group_id IN NUMBER,

Line 1567: FROM DUAL;

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;
1571: