1 PACKAGE gme_complete_batch_step_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVCMSS.pls 120.4.12010000.1 2008/07/25 10:29:54 appldev ship $ */
3
4 PROCEDURE complete_step
5 (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
6 ,p_batch_header_rec IN gme_batch_header%ROWTYPE
7 ,x_batch_step_rec OUT NOCOPY GME_BATCH_STEPS%ROWTYPE
8 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
9 ,x_return_status OUT NOCOPY VARCHAR2);
10
11 PROCEDURE complete_step_recursive
12 (p_batch_step_rec IN gme_batch_steps%ROWTYPE
13 ,p_batch_header_rec IN gme_batch_header%ROWTYPE
14 ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
15 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
16 ,x_return_status OUT NOCOPY VARCHAR2
17 , p_quality_override IN BOOLEAN := FALSE); --Bug#6348353
18
19 PROCEDURE complete_step_line
20 (p_batch_step_rec IN gme_batch_steps%ROWTYPE
21 ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
22 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
23 ,x_return_status OUT NOCOPY VARCHAR2);
24
25 PROCEDURE complete_step_material
26 (p_batch_step_rec IN gme_batch_steps%ROWTYPE
27 ,p_update_inv_ind IN VARCHAR2
28 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
29 ,x_return_status OUT NOCOPY VARCHAR2);
30
31 PROCEDURE validate_step_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE
32 ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
33 ,p_override_quality IN VARCHAR2
34 ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
35 ,x_return_status OUT NOCOPY VARCHAR2);
36
37 PROCEDURE validate_step_cmplt_date
38 (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
39 ,p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
40 ,x_batch_start_date OUT NOCOPY DATE
41 ,x_return_status OUT NOCOPY VARCHAR2);
42
43 PROCEDURE validate_dependent_steps (p_batch_id IN NUMBER
44 ,p_step_id IN NUMBER
45 ,p_step_actual_start_date IN DATE
46 ,x_return_status OUT NOCOPY VARCHAR2);
47
48 END gme_complete_batch_step_pvt;