1: PACKAGE gme_release_batch_step_pvt AS
2: /* $Header: GMEVRLSS.pls 120.5 2005/07/18 21:06:58 anewbury ship $ */
3: PROCEDURE release_step (
4: p_batch_step_rec IN gme_batch_steps%ROWTYPE
5: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
6: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
7: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
8: ,x_return_status OUT NOCOPY VARCHAR2);
2: /* $Header: GMEVRLSS.pls 120.5 2005/07/18 21:06:58 anewbury ship $ */
3: PROCEDURE release_step (
4: p_batch_step_rec IN gme_batch_steps%ROWTYPE
5: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
6: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
7: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
8: ,x_return_status OUT NOCOPY VARCHAR2);
9:
10: PROCEDURE release_step_recursive (
7: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
8: ,x_return_status OUT NOCOPY VARCHAR2);
9:
10: PROCEDURE release_step_recursive (
11: p_batch_step_rec IN gme_batch_steps%ROWTYPE
12: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
13: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
14: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
15: ,x_return_status OUT NOCOPY VARCHAR2);
9:
10: PROCEDURE release_step_recursive (
11: p_batch_step_rec IN gme_batch_steps%ROWTYPE
12: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
13: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
14: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
15: ,x_return_status OUT NOCOPY VARCHAR2);
16:
17: PROCEDURE process_dependent_steps (
14: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
15: ,x_return_status OUT NOCOPY VARCHAR2);
16:
17: PROCEDURE process_dependent_steps (
18: p_batch_step_rec IN gme_batch_steps%ROWTYPE
19: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
20: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
21: ,x_return_status OUT NOCOPY VARCHAR2);
22:
20: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
21: ,x_return_status OUT NOCOPY VARCHAR2);
22:
23: PROCEDURE release_step_line (
24: p_batch_step_rec IN gme_batch_steps%ROWTYPE
25: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
26: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
27: ,x_return_status OUT NOCOPY VARCHAR2);
28:
21: ,x_return_status OUT NOCOPY VARCHAR2);
22:
23: PROCEDURE release_step_line (
24: p_batch_step_rec IN gme_batch_steps%ROWTYPE
25: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
26: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
27: ,x_return_status OUT NOCOPY VARCHAR2);
28:
29: PROCEDURE release_step_ingredients (
26: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
27: ,x_return_status OUT NOCOPY VARCHAR2);
28:
29: PROCEDURE release_step_ingredients (
30: p_batch_step_rec IN gme_batch_steps%ROWTYPE
31: ,p_update_inv_ind IN VARCHAR2
32: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
33: ,x_return_status OUT NOCOPY VARCHAR2);
34:
32: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
33: ,x_return_status OUT NOCOPY VARCHAR2);
34:
35: PROCEDURE validate_step_for_release (p_batch_header_rec IN gme_batch_header%ROWTYPE
36: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
37: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
38: ,x_return_status OUT NOCOPY VARCHAR2);
39:
40: END gme_release_batch_step_pvt;
33: ,x_return_status OUT NOCOPY VARCHAR2);
34:
35: PROCEDURE validate_step_for_release (p_batch_header_rec IN gme_batch_header%ROWTYPE
36: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
37: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
38: ,x_return_status OUT NOCOPY VARCHAR2);
39:
40: END gme_release_batch_step_pvt;