DBA Data[Home] [Help]

APPS.GME_COMPLETE_BATCH_STEP_PVT dependencies on GME_BATCH_HEADER

Line 33: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

29: =============================================================================================*/
30:
31: PROCEDURE complete_step
32: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
33: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
34: ,x_batch_step_rec OUT NOCOPY GME_BATCH_STEPS%ROWTYPE
35: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
36: ,x_return_status OUT NOCOPY VARCHAR2) IS
37:

Line 47: l_batch_header_rec gme_batch_header%ROWTYPE;

43: AND rownum = 1;
44:
45: l_api_name CONSTANT VARCHAR2 (30) := 'complete_step';
46:
47: l_batch_header_rec gme_batch_header%ROWTYPE;
48: l_in_batch_header_rec gme_batch_header%ROWTYPE;
49: l_batch_step_rec gme_batch_steps%ROWTYPE;
50: l_return_status VARCHAR2(1);
51: l_step_count NUMBER;

Line 48: l_in_batch_header_rec gme_batch_header%ROWTYPE;

44:
45: l_api_name CONSTANT VARCHAR2 (30) := 'complete_step';
46:
47: l_batch_header_rec gme_batch_header%ROWTYPE;
48: l_in_batch_header_rec gme_batch_header%ROWTYPE;
49: l_batch_step_rec gme_batch_steps%ROWTYPE;
50: l_return_status VARCHAR2(1);
51: l_step_count NUMBER;
52:

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

93: END IF;
94:
95: -- re-retrieve the batch header if the batch status was pending
96: IF (p_batch_header_rec.batch_status = gme_common_pvt.g_batch_pending) THEN
97: IF NOT gme_batch_header_dbl.fetch_row(l_batch_header_rec, l_batch_header_rec) THEN
98: RAISE error_fetch;
99: END IF;
100: END IF;
101:

Line 216: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

212: END complete_step;
213:
214: PROCEDURE complete_step_recursive
215: (p_batch_step_rec IN gme_batch_steps%ROWTYPE
216: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
217: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
218: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
219: ,x_return_status OUT NOCOPY VARCHAR2
220: ,p_quality_override IN BOOLEAN := FALSE) IS --Bug#6348353

Line 678: PROCEDURE validate_step_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE

674: END IF;
675: x_return_status := FND_API.g_ret_sts_unexp_error;
676: END validate_dependent_steps;
677:
678: PROCEDURE validate_step_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE
679: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
680: ,p_override_quality IN VARCHAR2
681: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
682: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 902: ,p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE

898: =============================================================================================*/
899:
900: PROCEDURE validate_step_cmplt_date
901: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
902: ,p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
903: ,x_batch_start_date OUT NOCOPY DATE
904: ,x_return_status OUT NOCOPY VARCHAR2) IS
905:
906: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_cmplt_date';