DBA Data[Home] [Help]

APPS.WIP_FLOW_UTILITIES dependencies on WIP_FLOW_UTILITIES

Line 1: Package Body Wip_Flow_Utilities as

1: Package Body Wip_Flow_Utilities as
2: /* $Header: wipfcomb.pls 120.2 2006/04/27 17:25:35 yulin noship $ */
3:
4: /* *********************************************************************
5: Public Procedures

Line 1436: decode(Wip_Flow_Utilities.Status_Change(PLANNED_QUANTITY,QUANTITY_COMPLETED,p_quantity_completed*-1),

1432: QUANTITY_SCRAPPED = Nvl(QUANTITY_SCRAPPED,0)+(p_quantity_scrapped * -1), -- CFM Scrap
1433: TRANSACTED_FLAG = 'Y',
1434: DATE_CLOSED =
1435: decode(UPPER(NVL(p_schedule_flag,'N')), 'Y',
1436: decode(Wip_Flow_Utilities.Status_Change(PLANNED_QUANTITY,QUANTITY_COMPLETED,p_quantity_completed*-1),
1437: 0,DATE_CLOSED,1,null,2,p_transaction_date),
1438: DATE_CLOSED),
1439: STATUS =
1440: decode(UPPER(NVL(p_schedule_flag,'N')), 'Y',

Line 1441: decode(Wip_Flow_Utilities.Status_Change(PLANNED_QUANTITY,QUANTITY_COMPLETED,p_quantity_completed*-1),

1437: 0,DATE_CLOSED,1,null,2,p_transaction_date),
1438: DATE_CLOSED),
1439: STATUS =
1440: decode(UPPER(NVL(p_schedule_flag,'N')), 'Y',
1441: decode(Wip_Flow_Utilities.Status_Change(PLANNED_QUANTITY,QUANTITY_COMPLETED,p_quantity_completed*-1),
1442: 0,STATUS,1,1,2,2),
1443: STATUS),
1444: LAST_UPDATED_BY = p_last_updated_by,
1445: LAST_UPDATE_DATE = sysdate

Line 2680: end Wip_Flow_Utilities;

2676: rollback to defaultlotsp_10;
2677:
2678: END default_lots;
2679:
2680: end Wip_Flow_Utilities;