1 PACKAGE WIP_Work_Order_PVT AUTHID CURRENT_USER AS
2 /* $Header: WIPVWORS.pls 115.8 2002/12/01 16:31:03 rmahidha ship $ */
3
4 -- Start of Comments
5 -- API name Lock_Work_Order
6 -- Type Private
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 PROCEDURE Lock_Work_Order
21 ( p_api_version_number IN NUMBER
22 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23 , x_return_status OUT NOCOPY VARCHAR2
24 , x_msg_count OUT NOCOPY NUMBER
25 , x_msg_data OUT NOCOPY VARCHAR2
26 , p_Wip_Entities_tbl IN WIP_Work_Order_PUB.Wip_Entities_Tbl_Type :=
27 WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_TBL
28 , p_FlowSchedule_tbl IN WIP_Work_Order_PUB.Flowschedule_Tbl_Type :=
29 WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_TBL
30 , p_DiscreteJob_tbl IN WIP_Work_Order_PUB.Discretejob_Tbl_Type :=
31 WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_TBL
32 , p_RepSchedule_tbl IN WIP_Work_Order_PUB.Repschedule_Tbl_Type :=
33 WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_TBL
34 , x_Wip_Entities_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
35 , x_FlowSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Tbl_Type
36 , x_DiscreteJob_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Tbl_Type
37 , x_RepSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Tbl_Type
38 );
39
40 -- Start of Comments
41 -- API name Get_Work_Order
42 -- Type Private
43 -- Function
44 --
45 -- Pre-reqs
46 --
47 -- Parameters
48 --
49 -- Version Current version = 1.0
50 -- Initial version = 1.0
51 --
52 -- Notes
53 --
54 -- End of Comments
55
56 PROCEDURE Get_Work_Order
57 ( p_api_version_number IN NUMBER
58 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
59 , x_return_status OUT NOCOPY VARCHAR2
60 , x_msg_count OUT NOCOPY NUMBER
61 , x_msg_data OUT NOCOPY VARCHAR2
62 , p_wip_entity_id IN NUMBER
63 , x_Wip_Entities_tbl OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
64 , x_FlowSchedule_tbl OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Tbl_Type
65 , x_DiscreteJob_tbl OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Tbl_Type
66 , x_RepSchedule_tbl OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Tbl_Type
67 );
68
69 PROCEDURE Get_Work_Order
70 ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
71 , x_return_status OUT NOCOPY VARCHAR2
72 , x_msg_count OUT NOCOPY NUMBER
73 , x_msg_data OUT NOCOPY VARCHAR2
74 , p_wip_entity_id IN NUMBER
75 , x_FlowSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Rec_Type
76 , x_DiscreteJob_rec OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Rec_Type
77 , x_RepSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Rec_Type
78 );
79
80 PROCEDURE Get_Kanban_Details( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
81 ,p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM
82 ,kanban_card_id IN OUT NOCOPY NUMBER
83 ,x_kanban_card_number OUT NOCOPY VARCHAR2
84 ,x_subinventory OUT NOCOPY VARCHAR2
85 ,x_locator_id OUT NOCOPY NUMBER
86 ,x_line_id OUT NOCOPY NUMBER
87 ,x_supply_status OUT NOCOPY NUMBER
88 ,x_return_status OUT NOCOPY VARCHAR2
89 ,x_msg_count OUT NOCOPY NUMBER
90 ,x_msg_data OUT NOCOPY VARCHAR2
91 );
92
93 PROCEDURE Check_Build_Sequence(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
94 ,p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM
95 ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
96 ,p_build_sequence IN NUMBER := FND_API.G_MISS_NUM
97 ,p_schedule_group_id IN NUMBER := FND_API.G_MISS_NUM
98 ,p_line_id IN NUMBER := FND_API.G_MISS_NUM
99 ,p_FlowSchedule_rec IN WIP_Work_Order_PUB.FlowSchedule_Rec_Type := WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_REC
100 ,p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type := WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_REC
101 ,x_build_seq_valid OUT NOCOPY VARCHAR2
102 ,x_return_status OUT NOCOPY VARCHAR2
103 ,x_msg_count OUT NOCOPY NUMBER
104 ,x_msg_data OUT NOCOPY VARCHAR2);
105
106 function component_exist (p_wip_entity_id number,
107 p_operation_seq_num number,
108 p_rep_schedule_id number,
109 p_organization_id number) return varchar2;
110 PRAGMA RESTRICT_REFERENCES(component_exist, WNDS, WNPS);
111
112 END WIP_Work_Order_PVT;