eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_COMPLETE_BATCH_PVT dependencies on GME_BATCH_HEADER

Line 10: (p_batch_header_rec IN gme_batch_header%ROWTYPE

6: g_pkg_name VARCHAR2(30) := 'GME_COMPLETE_BATCH_PVT';
7:
8:
9: PROCEDURE complete_batch
10: (p_batch_header_rec IN gme_batch_header%ROWTYPE
11: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
12: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
13: ,x_return_status OUT NOCOPY VARCHAR2) IS
14:

Line 12: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

8:
9: PROCEDURE complete_batch
10: (p_batch_header_rec IN gme_batch_header%ROWTYPE
11: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
12: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
13: ,x_return_status OUT NOCOPY VARCHAR2) IS
14:
15:
16:

Line 32: FROM gme_material_details dtl, gme_batch_header hdr

28: AND step_status NOT IN (gme_common_pvt.g_step_completed, gme_common_pvt.g_step_closed);
29:
30: CURSOR Cur_get_phantom_batch(v_batch_id NUMBER) IS
31: SELECT hdr.*
32: FROM gme_material_details dtl, gme_batch_header hdr
33: WHERE dtl.batch_id = v_batch_id
34: AND dtl.line_type = gme_common_pvt.g_line_type_ing
35: AND dtl.phantom_id IS NOT NULL
36: AND hdr.batch_id = dtl.phantom_id

Line 61: l_btch_hdr gme_batch_header%ROWTYPE;

57:
58: l_step_status NUMBER;
59: l_matl_dtl_tab_ing gme_common_pvt.material_details_tab;
60: l_matl_dtl_tab gme_common_pvt.material_details_tab;
61: l_btch_hdr gme_batch_header%ROWTYPE;
62: l_btch_hdr_tab gme_common_pvt.batch_headers_tab;
63: l_matl_dtl gme_material_details%ROWTYPE;
64: l_matl_dtl_rec gme_material_details%ROWTYPE;
65: l_step_tab gme_common_pvt.steps_tab;

Line 68: l_phantom_batch gme_batch_header%ROWTYPE;

64: l_matl_dtl_rec gme_material_details%ROWTYPE;
65: l_step_tab gme_common_pvt.steps_tab;
66: l_batch_step_rec gme_batch_steps%ROWTYPE;
67: l_yield_type NUMBER;
68: l_phantom_batch gme_batch_header%ROWTYPE;
69: l_phantom_batch_rec gme_batch_header%ROWTYPE;
70: l_item_rec mtl_system_items_b%ROWTYPE;
71: l_return_status VARCHAR2(1);
72: l_yield BOOLEAN;

Line 69: l_phantom_batch_rec gme_batch_header%ROWTYPE;

65: l_step_tab gme_common_pvt.steps_tab;
66: l_batch_step_rec gme_batch_steps%ROWTYPE;
67: l_yield_type NUMBER;
68: l_phantom_batch gme_batch_header%ROWTYPE;
69: l_phantom_batch_rec gme_batch_header%ROWTYPE;
70: l_item_rec mtl_system_items_b%ROWTYPE;
71: l_return_status VARCHAR2(1);
72: l_yield BOOLEAN;
73: l_exception_qty NUMBER;

Line 125: IF NOT gme_batch_header_dbl.update_row (p_batch_header => x_batch_header_rec) THEN

121:
122: -- no need to set the actual completion date because it is expected to have been in p_batch_header_rec
123:
124: -- Update the batch header
125: IF NOT gme_batch_header_dbl.update_row (p_batch_header => x_batch_header_rec) THEN
126: RAISE error_update_batch;
127: END IF;
128:
129: -- Update WHO columns for output structure

Line 404: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;

400:
401: l_api_name CONSTANT VARCHAR2 (30) := 'process_material';
402:
403: l_matl_dtl_rec gme_material_details%ROWTYPE;
404: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;
405: l_phantom_batch_rec gme_batch_header%ROWTYPE;
406: l_return_status VARCHAR2(1);
407: l_item_rec mtl_system_items_b%ROWTYPE;
408: l_actual_qty NUMBER;

Line 405: l_phantom_batch_rec gme_batch_header%ROWTYPE;

401: l_api_name CONSTANT VARCHAR2 (30) := 'process_material';
402:
403: l_matl_dtl_rec gme_material_details%ROWTYPE;
404: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;
405: l_phantom_batch_rec gme_batch_header%ROWTYPE;
406: l_return_status VARCHAR2(1);
407: l_item_rec mtl_system_items_b%ROWTYPE;
408: l_actual_qty NUMBER;
409: l_start_actual_qty NUMBER;

Line 443: IF NOT gme_batch_header_dbl.fetch_row(l_phantom_batch_rec, l_phantom_batch_rec) THEN

439:
440: -- complete phantom batch
441: IF l_matl_dtl_rec.line_type = gme_common_pvt.g_line_type_ing AND l_matl_dtl_rec.phantom_id IS NOT NULL THEN -- phantom ingredient -> complete the phantom batch
442: l_phantom_batch_rec.batch_id := l_matl_dtl_rec.phantom_id;
443: IF NOT gme_batch_header_dbl.fetch_row(l_phantom_batch_rec, l_phantom_batch_rec) THEN
444: RAISE error_fetch_batch;
445: END IF;
446:
447: IF l_phantom_batch_rec.batch_status IN (gme_common_pvt.g_batch_pending, gme_common_pvt.g_batch_wip) THEN

Line 1082: PROCEDURE validate_batch_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE

1078: END IF;
1079: x_return_status := FND_API.g_ret_sts_unexp_error;
1080: END constr_mmti;
1081:
1082: PROCEDURE validate_batch_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE
1083: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1084: ,x_return_status OUT NOCOPY VARCHAR2) IS
1085:
1086: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_complete';

Line 1083: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

1079: x_return_status := FND_API.g_ret_sts_unexp_error;
1080: END constr_mmti;
1081:
1082: PROCEDURE validate_batch_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE
1083: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1084: ,x_return_status OUT NOCOPY VARCHAR2) IS
1085:
1086: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_complete';
1087:

Line 1096: l_batch_header_rec gme_batch_header%ROWTYPE;

1092: AND batch_id = v_batch_id
1093: AND rownum = 1;
1094:
1095: l_is_step NUMBER;
1096: l_batch_header_rec gme_batch_header%ROWTYPE;
1097: CURSOR cur_validity_rule(v_recipe_validity_rule_id NUMBER)
1098: IS
1099: SELECT *
1100: FROM gmd_recipe_validity_rules