27: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
28: , x_return_status OUT NOCOPY VARCHAR2
29: , x_msg_count OUT NOCOPY NUMBER
30: , x_msg_data OUT NOCOPY VARCHAR2
31: , p_Wip_Entities_tbl IN WIP_Work_Order_PUB.Wip_Entities_Tbl_Type :=
32: WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_TBL
33: , p_FlowSchedule_tbl IN WIP_Work_Order_PUB.Flowschedule_Tbl_Type :=
34: WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_TBL
35: , p_DiscreteJob_tbl IN WIP_Work_Order_PUB.Discretejob_Tbl_Type :=
28: , x_return_status OUT NOCOPY VARCHAR2
29: , x_msg_count OUT NOCOPY NUMBER
30: , x_msg_data OUT NOCOPY VARCHAR2
31: , p_Wip_Entities_tbl IN WIP_Work_Order_PUB.Wip_Entities_Tbl_Type :=
32: WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_TBL
33: , p_FlowSchedule_tbl IN WIP_Work_Order_PUB.Flowschedule_Tbl_Type :=
34: WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_TBL
35: , p_DiscreteJob_tbl IN WIP_Work_Order_PUB.Discretejob_Tbl_Type :=
36: WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_TBL
29: , x_msg_count OUT NOCOPY NUMBER
30: , x_msg_data OUT NOCOPY VARCHAR2
31: , p_Wip_Entities_tbl IN WIP_Work_Order_PUB.Wip_Entities_Tbl_Type :=
32: WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_TBL
33: , p_FlowSchedule_tbl IN WIP_Work_Order_PUB.Flowschedule_Tbl_Type :=
34: WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_TBL
35: , p_DiscreteJob_tbl IN WIP_Work_Order_PUB.Discretejob_Tbl_Type :=
36: WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_TBL
37: , p_RepSchedule_tbl IN WIP_Work_Order_PUB.Repschedule_Tbl_Type :=
30: , x_msg_data OUT NOCOPY VARCHAR2
31: , p_Wip_Entities_tbl IN WIP_Work_Order_PUB.Wip_Entities_Tbl_Type :=
32: WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_TBL
33: , p_FlowSchedule_tbl IN WIP_Work_Order_PUB.Flowschedule_Tbl_Type :=
34: WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_TBL
35: , p_DiscreteJob_tbl IN WIP_Work_Order_PUB.Discretejob_Tbl_Type :=
36: WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_TBL
37: , p_RepSchedule_tbl IN WIP_Work_Order_PUB.Repschedule_Tbl_Type :=
38: WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_TBL
31: , p_Wip_Entities_tbl IN WIP_Work_Order_PUB.Wip_Entities_Tbl_Type :=
32: WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_TBL
33: , p_FlowSchedule_tbl IN WIP_Work_Order_PUB.Flowschedule_Tbl_Type :=
34: WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_TBL
35: , p_DiscreteJob_tbl IN WIP_Work_Order_PUB.Discretejob_Tbl_Type :=
36: WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_TBL
37: , p_RepSchedule_tbl IN WIP_Work_Order_PUB.Repschedule_Tbl_Type :=
38: WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_TBL
39: , x_Wip_Entities_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
32: WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_TBL
33: , p_FlowSchedule_tbl IN WIP_Work_Order_PUB.Flowschedule_Tbl_Type :=
34: WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_TBL
35: , p_DiscreteJob_tbl IN WIP_Work_Order_PUB.Discretejob_Tbl_Type :=
36: WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_TBL
37: , p_RepSchedule_tbl IN WIP_Work_Order_PUB.Repschedule_Tbl_Type :=
38: WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_TBL
39: , x_Wip_Entities_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
40: , x_FlowSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Tbl_Type
33: , p_FlowSchedule_tbl IN WIP_Work_Order_PUB.Flowschedule_Tbl_Type :=
34: WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_TBL
35: , p_DiscreteJob_tbl IN WIP_Work_Order_PUB.Discretejob_Tbl_Type :=
36: WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_TBL
37: , p_RepSchedule_tbl IN WIP_Work_Order_PUB.Repschedule_Tbl_Type :=
38: WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_TBL
39: , x_Wip_Entities_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
40: , x_FlowSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Tbl_Type
41: , x_DiscreteJob_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Tbl_Type
34: WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_TBL
35: , p_DiscreteJob_tbl IN WIP_Work_Order_PUB.Discretejob_Tbl_Type :=
36: WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_TBL
37: , p_RepSchedule_tbl IN WIP_Work_Order_PUB.Repschedule_Tbl_Type :=
38: WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_TBL
39: , x_Wip_Entities_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
40: , x_FlowSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Tbl_Type
41: , x_DiscreteJob_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Tbl_Type
42: , x_RepSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Tbl_Type
35: , p_DiscreteJob_tbl IN WIP_Work_Order_PUB.Discretejob_Tbl_Type :=
36: WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_TBL
37: , p_RepSchedule_tbl IN WIP_Work_Order_PUB.Repschedule_Tbl_Type :=
38: WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_TBL
39: , x_Wip_Entities_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
40: , x_FlowSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Tbl_Type
41: , x_DiscreteJob_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Tbl_Type
42: , x_RepSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Tbl_Type
43: )
36: WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_TBL
37: , p_RepSchedule_tbl IN WIP_Work_Order_PUB.Repschedule_Tbl_Type :=
38: WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_TBL
39: , x_Wip_Entities_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
40: , x_FlowSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Tbl_Type
41: , x_DiscreteJob_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Tbl_Type
42: , x_RepSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Tbl_Type
43: )
44: IS
37: , p_RepSchedule_tbl IN WIP_Work_Order_PUB.Repschedule_Tbl_Type :=
38: WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_TBL
39: , x_Wip_Entities_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
40: , x_FlowSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Tbl_Type
41: , x_DiscreteJob_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Tbl_Type
42: , x_RepSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Tbl_Type
43: )
44: IS
45: l_api_version_number CONSTANT NUMBER := 1.0;
38: WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_TBL
39: , x_Wip_Entities_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
40: , x_FlowSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Tbl_Type
41: , x_DiscreteJob_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Tbl_Type
42: , x_RepSchedule_tbl IN OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Tbl_Type
43: )
44: IS
45: l_api_version_number CONSTANT NUMBER := 1.0;
46: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Work_Order';
44: IS
45: l_api_version_number CONSTANT NUMBER := 1.0;
46: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Work_Order';
47: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
48: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
49: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
50: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;
51: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;
52: BEGIN
45: l_api_version_number CONSTANT NUMBER := 1.0;
46: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Work_Order';
47: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
48: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
49: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
50: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;
51: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;
52: BEGIN
53:
46: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Work_Order';
47: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
48: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
49: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
50: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;
51: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;
52: BEGIN
53:
54: -- Standard call to check for call compatibility
47: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
48: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
49: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
50: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;
51: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;
52: BEGIN
53:
54: -- Standard call to check for call compatibility
55:
260: , x_return_status OUT NOCOPY VARCHAR2
261: , x_msg_count OUT NOCOPY NUMBER
262: , x_msg_data OUT NOCOPY VARCHAR2
263: , p_wip_entity_id IN NUMBER
264: , x_Wip_Entities_tbl OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
265: , x_FlowSchedule_tbl OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Tbl_Type
266: , x_DiscreteJob_tbl OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Tbl_Type
267: , x_RepSchedule_tbl OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Tbl_Type
268: )
261: , x_msg_count OUT NOCOPY NUMBER
262: , x_msg_data OUT NOCOPY VARCHAR2
263: , p_wip_entity_id IN NUMBER
264: , x_Wip_Entities_tbl OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
265: , x_FlowSchedule_tbl OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Tbl_Type
266: , x_DiscreteJob_tbl OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Tbl_Type
267: , x_RepSchedule_tbl OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Tbl_Type
268: )
269: IS
262: , x_msg_data OUT NOCOPY VARCHAR2
263: , p_wip_entity_id IN NUMBER
264: , x_Wip_Entities_tbl OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
265: , x_FlowSchedule_tbl OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Tbl_Type
266: , x_DiscreteJob_tbl OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Tbl_Type
267: , x_RepSchedule_tbl OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Tbl_Type
268: )
269: IS
270: l_api_version_number CONSTANT NUMBER := 1.0;
263: , p_wip_entity_id IN NUMBER
264: , x_Wip_Entities_tbl OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Tbl_Type
265: , x_FlowSchedule_tbl OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Tbl_Type
266: , x_DiscreteJob_tbl OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Tbl_Type
267: , x_RepSchedule_tbl OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Tbl_Type
268: )
269: IS
270: l_api_version_number CONSTANT NUMBER := 1.0;
271: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
268: )
269: IS
270: l_api_version_number CONSTANT NUMBER := 1.0;
271: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
272: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
273: l_Wip_Entities_tbl WIP_Work_Order_PUB.Wip_Entities_Tbl_Type;
274: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
275: l_x_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
276: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
269: IS
270: l_api_version_number CONSTANT NUMBER := 1.0;
271: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
272: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
273: l_Wip_Entities_tbl WIP_Work_Order_PUB.Wip_Entities_Tbl_Type;
274: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
275: l_x_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
276: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
277: l_x_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
270: l_api_version_number CONSTANT NUMBER := 1.0;
271: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
272: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
273: l_Wip_Entities_tbl WIP_Work_Order_PUB.Wip_Entities_Tbl_Type;
274: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
275: l_x_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
276: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
277: l_x_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
278: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
271: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
272: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
273: l_Wip_Entities_tbl WIP_Work_Order_PUB.Wip_Entities_Tbl_Type;
274: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
275: l_x_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
276: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
277: l_x_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
278: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
279: l_x_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
272: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
273: l_Wip_Entities_tbl WIP_Work_Order_PUB.Wip_Entities_Tbl_Type;
274: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
275: l_x_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
276: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
277: l_x_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
278: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
279: l_x_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
280: BEGIN
273: l_Wip_Entities_tbl WIP_Work_Order_PUB.Wip_Entities_Tbl_Type;
274: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
275: l_x_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
276: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
277: l_x_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
278: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
279: l_x_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
280: BEGIN
281:
274: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
275: l_x_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
276: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
277: l_x_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
278: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
279: l_x_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
280: BEGIN
281:
282: -- Standard call to check for call compatibility
275: l_x_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
276: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
277: l_x_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
278: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
279: l_x_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
280: BEGIN
281:
282: -- Standard call to check for call compatibility
283:
420: , x_return_status OUT NOCOPY VARCHAR2
421: , x_msg_count OUT NOCOPY NUMBER
422: , x_msg_data OUT NOCOPY VARCHAR2
423: , p_wip_entity_id IN NUMBER
424: , x_FlowSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Rec_Type
425: , x_DiscreteJob_rec OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Rec_Type
426: , x_RepSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Rec_Type
427: )
428: IS
421: , x_msg_count OUT NOCOPY NUMBER
422: , x_msg_data OUT NOCOPY VARCHAR2
423: , p_wip_entity_id IN NUMBER
424: , x_FlowSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Rec_Type
425: , x_DiscreteJob_rec OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Rec_Type
426: , x_RepSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Rec_Type
427: )
428: IS
429: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
422: , x_msg_data OUT NOCOPY VARCHAR2
423: , p_wip_entity_id IN NUMBER
424: , x_FlowSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Rec_Type
425: , x_DiscreteJob_rec OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Rec_Type
426: , x_RepSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Rec_Type
427: )
428: IS
429: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
430: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type:=WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_REC;
426: , x_RepSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Rec_Type
427: )
428: IS
429: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
430: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type:=WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_REC;
431: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type:=WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_REC;
432: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type:=WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_REC;
433: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type:=WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_REC;
434: BEGIN
427: )
428: IS
429: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
430: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type:=WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_REC;
431: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type:=WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_REC;
432: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type:=WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_REC;
433: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type:=WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_REC;
434: BEGIN
435:
428: IS
429: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
430: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type:=WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_REC;
431: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type:=WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_REC;
432: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type:=WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_REC;
433: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type:=WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_REC;
434: BEGIN
435:
436: -- Initialize message list.
429: l_api_name CONSTANT VARCHAR2(30):= 'Get_Work_Order';
430: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type:=WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_REC;
431: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type:=WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_REC;
432: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type:=WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_REC;
433: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type:=WIP_Work_Order_PUB.G_MISS_REPSCHEDULE_REC;
434: BEGIN
435:
436: -- Initialize message list.
437:
538: ,x_msg_count OUT NOCOPY NUMBER
539: ,x_msg_data OUT NOCOPY VARCHAR2
540: )
541: IS
542: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
543: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;
544: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;
545: l_kanban_rec INV_Kanban_PVT.Kanban_Card_Rec_Type;
546: l_return_status VARCHAR2(1);
539: ,x_msg_data OUT NOCOPY VARCHAR2
540: )
541: IS
542: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
543: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;
544: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;
545: l_kanban_rec INV_Kanban_PVT.Kanban_Card_Rec_Type;
546: l_return_status VARCHAR2(1);
547: l_msg_count NUMBER;
540: )
541: IS
542: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
543: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;
544: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;
545: l_kanban_rec INV_Kanban_PVT.Kanban_Card_Rec_Type;
546: l_return_status VARCHAR2(1);
547: l_msg_count NUMBER;
548: l_msg_data VARCHAR2(1000);
713: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
714: ,p_build_sequence IN NUMBER := FND_API.G_MISS_NUM
715: ,p_schedule_group_id IN NUMBER := FND_API.G_MISS_NUM
716: ,p_line_id IN NUMBER := FND_API.G_MISS_NUM
717: ,p_FlowSchedule_rec IN WIP_Work_Order_PUB.FlowSchedule_Rec_Type := WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_REC
718: ,p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type := WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_REC
719: ,x_build_seq_valid OUT NOCOPY VARCHAR2
720: ,x_return_status OUT NOCOPY VARCHAR2
721: ,x_msg_count OUT NOCOPY NUMBER
714: ,p_build_sequence IN NUMBER := FND_API.G_MISS_NUM
715: ,p_schedule_group_id IN NUMBER := FND_API.G_MISS_NUM
716: ,p_line_id IN NUMBER := FND_API.G_MISS_NUM
717: ,p_FlowSchedule_rec IN WIP_Work_Order_PUB.FlowSchedule_Rec_Type := WIP_Work_Order_PUB.G_MISS_FLOWSCHEDULE_REC
718: ,p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type := WIP_Work_Order_PUB.G_MISS_DISCRETEJOB_REC
719: ,x_build_seq_valid OUT NOCOPY VARCHAR2
720: ,x_return_status OUT NOCOPY VARCHAR2
721: ,x_msg_count OUT NOCOPY NUMBER
722: ,x_msg_data OUT NOCOPY VARCHAR2)