2: /* $Header: MSCPEGS.pls 120.2 2007/12/14 07:07:04 sbnaik ship $ */
3:
4:
5:
6: TYPE itemOrg_tab IS TABLE OF msc_flp_supply_demand_v.item_org%TYPE;
7: TYPE pegId_tab IS TABLE OF msc_flp_supply_demand_v.pegging_id%TYPE;
8: TYPE prevPegId_tab IS TABLE OF msc_flp_supply_demand_v.prev_pegging_id%TYPE;
9: TYPE Qty_Tab IS TABLE OF msc_flp_supply_demand_v.demand_qty%TYPE;
10: TYPE Date_tab IS TABLE OF msc_flp_supply_demand_v.demand_date%TYPE;
3:
4:
5:
6: TYPE itemOrg_tab IS TABLE OF msc_flp_supply_demand_v.item_org%TYPE;
7: TYPE pegId_tab IS TABLE OF msc_flp_supply_demand_v.pegging_id%TYPE;
8: TYPE prevPegId_tab IS TABLE OF msc_flp_supply_demand_v.prev_pegging_id%TYPE;
9: TYPE Qty_Tab IS TABLE OF msc_flp_supply_demand_v.demand_qty%TYPE;
10: TYPE Date_tab IS TABLE OF msc_flp_supply_demand_v.demand_date%TYPE;
11: TYPE OrderName_tab IS TABLE OF msc_flp_supply_demand_v.origination_name%TYPE;
4:
5:
6: TYPE itemOrg_tab IS TABLE OF msc_flp_supply_demand_v.item_org%TYPE;
7: TYPE pegId_tab IS TABLE OF msc_flp_supply_demand_v.pegging_id%TYPE;
8: TYPE prevPegId_tab IS TABLE OF msc_flp_supply_demand_v.prev_pegging_id%TYPE;
9: TYPE Qty_Tab IS TABLE OF msc_flp_supply_demand_v.demand_qty%TYPE;
10: TYPE Date_tab IS TABLE OF msc_flp_supply_demand_v.demand_date%TYPE;
11: TYPE OrderName_tab IS TABLE OF msc_flp_supply_demand_v.origination_name%TYPE;
12: TYPE demId_tab IS TABLE OF msc_flp_supply_demand_v.demand_id%TYPE;
5:
6: TYPE itemOrg_tab IS TABLE OF msc_flp_supply_demand_v.item_org%TYPE;
7: TYPE pegId_tab IS TABLE OF msc_flp_supply_demand_v.pegging_id%TYPE;
8: TYPE prevPegId_tab IS TABLE OF msc_flp_supply_demand_v.prev_pegging_id%TYPE;
9: TYPE Qty_Tab IS TABLE OF msc_flp_supply_demand_v.demand_qty%TYPE;
10: TYPE Date_tab IS TABLE OF msc_flp_supply_demand_v.demand_date%TYPE;
11: TYPE OrderName_tab IS TABLE OF msc_flp_supply_demand_v.origination_name%TYPE;
12: TYPE demId_tab IS TABLE OF msc_flp_supply_demand_v.demand_id%TYPE;
13: TYPE trxId_tab IS TABLE OF msc_flp_supply_demand_v.transaction_id%TYPE;
6: TYPE itemOrg_tab IS TABLE OF msc_flp_supply_demand_v.item_org%TYPE;
7: TYPE pegId_tab IS TABLE OF msc_flp_supply_demand_v.pegging_id%TYPE;
8: TYPE prevPegId_tab IS TABLE OF msc_flp_supply_demand_v.prev_pegging_id%TYPE;
9: TYPE Qty_Tab IS TABLE OF msc_flp_supply_demand_v.demand_qty%TYPE;
10: TYPE Date_tab IS TABLE OF msc_flp_supply_demand_v.demand_date%TYPE;
11: TYPE OrderName_tab IS TABLE OF msc_flp_supply_demand_v.origination_name%TYPE;
12: TYPE demId_tab IS TABLE OF msc_flp_supply_demand_v.demand_id%TYPE;
13: TYPE trxId_tab IS TABLE OF msc_flp_supply_demand_v.transaction_id%TYPE;
14: TYPE itemId_tab IS TABLE OF msc_flp_supply_demand_v.item_id%TYPE;
7: TYPE pegId_tab IS TABLE OF msc_flp_supply_demand_v.pegging_id%TYPE;
8: TYPE prevPegId_tab IS TABLE OF msc_flp_supply_demand_v.prev_pegging_id%TYPE;
9: TYPE Qty_Tab IS TABLE OF msc_flp_supply_demand_v.demand_qty%TYPE;
10: TYPE Date_tab IS TABLE OF msc_flp_supply_demand_v.demand_date%TYPE;
11: TYPE OrderName_tab IS TABLE OF msc_flp_supply_demand_v.origination_name%TYPE;
12: TYPE demId_tab IS TABLE OF msc_flp_supply_demand_v.demand_id%TYPE;
13: TYPE trxId_tab IS TABLE OF msc_flp_supply_demand_v.transaction_id%TYPE;
14: TYPE itemId_tab IS TABLE OF msc_flp_supply_demand_v.item_id%TYPE;
15: TYPE pegQty_tab IS TABLE OF msc_flp_supply_demand_v.pegged_qty%TYPE;
8: TYPE prevPegId_tab IS TABLE OF msc_flp_supply_demand_v.prev_pegging_id%TYPE;
9: TYPE Qty_Tab IS TABLE OF msc_flp_supply_demand_v.demand_qty%TYPE;
10: TYPE Date_tab IS TABLE OF msc_flp_supply_demand_v.demand_date%TYPE;
11: TYPE OrderName_tab IS TABLE OF msc_flp_supply_demand_v.origination_name%TYPE;
12: TYPE demId_tab IS TABLE OF msc_flp_supply_demand_v.demand_id%TYPE;
13: TYPE trxId_tab IS TABLE OF msc_flp_supply_demand_v.transaction_id%TYPE;
14: TYPE itemId_tab IS TABLE OF msc_flp_supply_demand_v.item_id%TYPE;
15: TYPE pegQty_tab IS TABLE OF msc_flp_supply_demand_v.pegged_qty%TYPE;
16: TYPE orderNum_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
9: TYPE Qty_Tab IS TABLE OF msc_flp_supply_demand_v.demand_qty%TYPE;
10: TYPE Date_tab IS TABLE OF msc_flp_supply_demand_v.demand_date%TYPE;
11: TYPE OrderName_tab IS TABLE OF msc_flp_supply_demand_v.origination_name%TYPE;
12: TYPE demId_tab IS TABLE OF msc_flp_supply_demand_v.demand_id%TYPE;
13: TYPE trxId_tab IS TABLE OF msc_flp_supply_demand_v.transaction_id%TYPE;
14: TYPE itemId_tab IS TABLE OF msc_flp_supply_demand_v.item_id%TYPE;
15: TYPE pegQty_tab IS TABLE OF msc_flp_supply_demand_v.pegged_qty%TYPE;
16: TYPE orderNum_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
17: TYPE orderTyp_tab IS TABLE OF msc_flp_supply_demand_v.order_type%TYPE;
10: TYPE Date_tab IS TABLE OF msc_flp_supply_demand_v.demand_date%TYPE;
11: TYPE OrderName_tab IS TABLE OF msc_flp_supply_demand_v.origination_name%TYPE;
12: TYPE demId_tab IS TABLE OF msc_flp_supply_demand_v.demand_id%TYPE;
13: TYPE trxId_tab IS TABLE OF msc_flp_supply_demand_v.transaction_id%TYPE;
14: TYPE itemId_tab IS TABLE OF msc_flp_supply_demand_v.item_id%TYPE;
15: TYPE pegQty_tab IS TABLE OF msc_flp_supply_demand_v.pegged_qty%TYPE;
16: TYPE orderNum_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
17: TYPE orderTyp_tab IS TABLE OF msc_flp_supply_demand_v.order_type%TYPE;
18: TYPE disp_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
11: TYPE OrderName_tab IS TABLE OF msc_flp_supply_demand_v.origination_name%TYPE;
12: TYPE demId_tab IS TABLE OF msc_flp_supply_demand_v.demand_id%TYPE;
13: TYPE trxId_tab IS TABLE OF msc_flp_supply_demand_v.transaction_id%TYPE;
14: TYPE itemId_tab IS TABLE OF msc_flp_supply_demand_v.item_id%TYPE;
15: TYPE pegQty_tab IS TABLE OF msc_flp_supply_demand_v.pegged_qty%TYPE;
16: TYPE orderNum_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
17: TYPE orderTyp_tab IS TABLE OF msc_flp_supply_demand_v.order_type%TYPE;
18: TYPE disp_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
19: TYPE end_demClass_tab IS TABLE of msc_flp_supply_demand_v.end_demand_class%TYPE;
12: TYPE demId_tab IS TABLE OF msc_flp_supply_demand_v.demand_id%TYPE;
13: TYPE trxId_tab IS TABLE OF msc_flp_supply_demand_v.transaction_id%TYPE;
14: TYPE itemId_tab IS TABLE OF msc_flp_supply_demand_v.item_id%TYPE;
15: TYPE pegQty_tab IS TABLE OF msc_flp_supply_demand_v.pegged_qty%TYPE;
16: TYPE orderNum_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
17: TYPE orderTyp_tab IS TABLE OF msc_flp_supply_demand_v.order_type%TYPE;
18: TYPE disp_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
19: TYPE end_demClass_tab IS TABLE of msc_flp_supply_demand_v.end_demand_class%TYPE;
20:
13: TYPE trxId_tab IS TABLE OF msc_flp_supply_demand_v.transaction_id%TYPE;
14: TYPE itemId_tab IS TABLE OF msc_flp_supply_demand_v.item_id%TYPE;
15: TYPE pegQty_tab IS TABLE OF msc_flp_supply_demand_v.pegged_qty%TYPE;
16: TYPE orderNum_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
17: TYPE orderTyp_tab IS TABLE OF msc_flp_supply_demand_v.order_type%TYPE;
18: TYPE disp_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
19: TYPE end_demClass_tab IS TABLE of msc_flp_supply_demand_v.end_demand_class%TYPE;
20:
21: TYPE itemorg_pegnode_rec is RECORD (
14: TYPE itemId_tab IS TABLE OF msc_flp_supply_demand_v.item_id%TYPE;
15: TYPE pegQty_tab IS TABLE OF msc_flp_supply_demand_v.pegged_qty%TYPE;
16: TYPE orderNum_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
17: TYPE orderTyp_tab IS TABLE OF msc_flp_supply_demand_v.order_type%TYPE;
18: TYPE disp_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
19: TYPE end_demClass_tab IS TABLE of msc_flp_supply_demand_v.end_demand_class%TYPE;
20:
21: TYPE itemorg_pegnode_rec is RECORD (
22: Item_Org ItemOrg_tab := itemOrg_tab(),
15: TYPE pegQty_tab IS TABLE OF msc_flp_supply_demand_v.pegged_qty%TYPE;
16: TYPE orderNum_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
17: TYPE orderTyp_tab IS TABLE OF msc_flp_supply_demand_v.order_type%TYPE;
18: TYPE disp_tab IS TABLE OF msc_flp_supply_demand_v.end_disposition%TYPE;
19: TYPE end_demClass_tab IS TABLE of msc_flp_supply_demand_v.end_demand_class%TYPE;
20:
21: TYPE itemorg_pegnode_rec is RECORD (
22: Item_Org ItemOrg_tab := itemOrg_tab(),
23: Pegging_id pegId_tab := pegId_tab(),