APPS.GME_RELEASE_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_RELEASE_BATCH_PVT';
7:
8:
9: PROCEDURE release_batch
10: (p_batch_header_rec IN gme_batch_header%ROWTYPE
11: ,p_phantom_product_id IN NUMBER DEFAULT NULL
12: ,p_yield IN BOOLEAN DEFAULT NULL
13: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
14: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 14: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

10: (p_batch_header_rec IN gme_batch_header%ROWTYPE
11: ,p_phantom_product_id IN NUMBER DEFAULT NULL
12: ,p_yield IN BOOLEAN DEFAULT NULL
13: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
14: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
15: ,x_return_status OUT NOCOPY VARCHAR2) IS
16:
17:
18: CURSOR Cur_batch_ingredients(v_batch_id NUMBER) IS

Line 36: l_phantom_batch_rec gme_batch_header%ROWTYPE;

32: l_step_rec gme_batch_steps%ROWTYPE;
33: l_matl_dtl_tab gme_common_pvt.material_details_tab;
34: l_matl_dtl_rec gme_material_details%ROWTYPE;
35: l_release_type NUMBER;
36: l_phantom_batch_rec gme_batch_header%ROWTYPE;
37: l_item_rec mtl_system_items_b%ROWTYPE;
38: l_consume BOOLEAN;
39: l_return_status VARCHAR2(1);
40:

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

90: -- this is expected to be populated and validated (from either user input or timestamp)
91: x_batch_header_rec.actual_start_date := p_batch_header_rec.actual_start_date;
92:
93: -- Update the batch header
94: IF NOT gme_batch_header_dbl.update_row (p_batch_header => x_batch_header_rec) THEN
95: RAISE error_update_batch;
96: END IF;
97:
98: -- Update WHO columns for output structure

Line 302: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;

298:
299: l_api_name CONSTANT VARCHAR2 (30) := 'process_ingredient';
300:
301: l_matl_dtl_rec gme_material_details%ROWTYPE;
302: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;
303: l_phantom_batch_rec gme_batch_header%ROWTYPE;
304: l_return_status VARCHAR2(1);
305: l_item_rec mtl_system_items_b%ROWTYPE;
306: l_actual_qty NUMBER;

Line 303: l_phantom_batch_rec gme_batch_header%ROWTYPE;

299: l_api_name CONSTANT VARCHAR2 (30) := 'process_ingredient';
300:
301: l_matl_dtl_rec gme_material_details%ROWTYPE;
302: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;
303: l_phantom_batch_rec gme_batch_header%ROWTYPE;
304: l_return_status VARCHAR2(1);
305: l_item_rec mtl_system_items_b%ROWTYPE;
306: l_actual_qty NUMBER;
307: l_update_matl BOOLEAN;

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

336:
337: -- release phantom batch
338: IF l_matl_dtl_rec.phantom_id IS NOT NULL THEN -- phantom -> release the phantom batch
339: l_phantom_batch_rec.batch_id := l_matl_dtl_rec.phantom_id;
340: IF NOT gme_batch_header_dbl.fetch_row(l_phantom_batch_rec, l_phantom_batch_rec) THEN
341: RAISE error_fetch_batch;
342: END IF;
343:
344: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 1624: PROCEDURE validate_batch_for_release (p_batch_header_rec IN gme_batch_header%ROWTYPE

1620: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1622: END check_unexploded_phantom;
1623:
1624: PROCEDURE validate_batch_for_release (p_batch_header_rec IN gme_batch_header%ROWTYPE
1625: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1626: ,x_return_status OUT NOCOPY VARCHAR2) IS
1627:
1628: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_release';

Line 1625: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1622: END check_unexploded_phantom;
1623:
1624: PROCEDURE validate_batch_for_release (p_batch_header_rec IN gme_batch_header%ROWTYPE
1625: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1626: ,x_return_status OUT NOCOPY VARCHAR2) IS
1627:
1628: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_release';
1629:

Line 1630: l_batch_header_rec gme_batch_header%ROWTYPE;

1626: ,x_return_status OUT NOCOPY VARCHAR2) IS
1627:
1628: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_release';
1629:
1630: l_batch_header_rec gme_batch_header%ROWTYPE;
1631:
1632: CURSOR cur_validity_rule(v_recipe_validity_rule_id NUMBER)
1633: IS
1634: SELECT *