1: PACKAGE BODY WIP_Work_Order_PUB AS
2: /* $Header: WIPPWORB.pls 115.10 2002/12/01 16:07:49 rmahidha ship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: WIPPWORB.pls 115.10 2002/12/01 16:07:49 rmahidha ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WIP_Work_Order_PUB';
7:
8: -- Start of Comments
9:
10: -- Start of Comments
43: IS
44: l_api_version_number CONSTANT NUMBER := 1.0;
45: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
46: l_wip_entity_id NUMBER := p_wip_entity_id;
47: l_Wip_Entities_tbl WIP_Work_Order_PUB.Wip_Entities_Tbl_Type;
48: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
49: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
50: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
51: BEGIN
44: l_api_version_number CONSTANT NUMBER := 1.0;
45: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
46: l_wip_entity_id NUMBER := p_wip_entity_id;
47: l_Wip_Entities_tbl WIP_Work_Order_PUB.Wip_Entities_Tbl_Type;
48: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
49: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
50: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
51: BEGIN
52:
45: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
46: l_wip_entity_id NUMBER := p_wip_entity_id;
47: l_Wip_Entities_tbl WIP_Work_Order_PUB.Wip_Entities_Tbl_Type;
48: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
49: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
50: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
51: BEGIN
52:
53: -- Standard call to check for call compatibility
46: l_wip_entity_id NUMBER := p_wip_entity_id;
47: l_Wip_Entities_tbl WIP_Work_Order_PUB.Wip_Entities_Tbl_Type;
48: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
49: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
50: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
51: BEGIN
52:
53: -- Standard call to check for call compatibility
54:
159: );
160:
161: END Get_Work_Order;
162:
163: END WIP_Work_Order_PUB;