DBA Data[Home] [Help]

APPS.GME_COMPLETE_BATCH_STEP_PVT dependencies on GME_BATCH_HEADER

Line 24: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

20: =============================================================================================*/
21:
22: PROCEDURE complete_step
23: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
24: ,p_batch_header_rec IN gme_batch_header%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) IS
28:

Line 38: l_batch_header_rec gme_batch_header%ROWTYPE;

34: AND rownum = 1;
35:
36: l_api_name CONSTANT VARCHAR2 (30) := 'complete_step';
37:
38: l_batch_header_rec gme_batch_header%ROWTYPE;
39: l_in_batch_header_rec gme_batch_header%ROWTYPE;
40: l_batch_step_rec gme_batch_steps%ROWTYPE;
41: l_return_status VARCHAR2(1);
42: l_step_count NUMBER;

Line 39: l_in_batch_header_rec gme_batch_header%ROWTYPE;

35:
36: l_api_name CONSTANT VARCHAR2 (30) := 'complete_step';
37:
38: l_batch_header_rec gme_batch_header%ROWTYPE;
39: l_in_batch_header_rec gme_batch_header%ROWTYPE;
40: l_batch_step_rec gme_batch_steps%ROWTYPE;
41: l_return_status VARCHAR2(1);
42: l_step_count NUMBER;
43:

Line 85: IF NOT gme_batch_header_dbl.fetch_row(l_batch_header_rec, l_batch_header_rec) THEN

81: END IF;
82:
83: -- re-retrieve the batch header if the batch status was pending
84: IF (p_batch_header_rec.batch_status = gme_common_pvt.g_batch_pending) THEN
85: IF NOT gme_batch_header_dbl.fetch_row(l_batch_header_rec, l_batch_header_rec) THEN
86: RAISE error_fetch;
87: END IF;
88: END IF;
89:

Line 184: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

180: END complete_step;
181:
182: PROCEDURE complete_step_recursive
183: (p_batch_step_rec IN gme_batch_steps%ROWTYPE
184: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
185: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
186: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
187: ,x_return_status OUT NOCOPY VARCHAR2
188: , p_quality_override IN BOOLEAN := FALSE) IS --Bug#6348353

Line 620: PROCEDURE validate_step_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE

616: END IF;
617: x_return_status := FND_API.g_ret_sts_unexp_error;
618: END validate_dependent_steps;
619:
620: PROCEDURE validate_step_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE
621: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
622: ,p_override_quality IN VARCHAR2
623: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
624: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 825: ,p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE

821: =============================================================================================*/
822:
823: PROCEDURE validate_step_cmplt_date
824: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
825: ,p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
826: ,x_batch_start_date OUT NOCOPY DATE
827: ,x_return_status OUT NOCOPY VARCHAR2) IS
828:
829: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_cmplt_date';