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 :=
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
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 :=
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
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
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
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
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
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: );
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:
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
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
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: );
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:
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
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:
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
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
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
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);