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_COMMON_PVT dependencies on GME_MATERIAL_DETAILS

Line 758: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

754: PROCEDURE construct_material_detail (
755: p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
756: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE
757: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
758: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
759: ,x_return_status OUT NOCOPY VARCHAR2)
760: IS
761: l_api_name CONSTANT VARCHAR2 (30) := 'construct_material_detail';
762: l_return_status VARCHAR2 (1);

Line 1389: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE

1385: p_batch_header_rec IN gme_batch_header%ROWTYPE
1386: DEFAULT NULL
1387: ,p_batchstep_rec IN gme_batch_steps%ROWTYPE
1388: DEFAULT NULL
1389: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE
1390: ,x_mtl_req_date OUT NOCOPY DATE
1391: ,x_return_status OUT NOCOPY VARCHAR2)
1392: IS
1393: l_batchstep_id NUMBER;

Line 2368: FROM gme_material_details d, mtl_system_items_b i

2364: ,x_exception_tbl OUT NOCOPY gme_common_pvt.exceptions_tab) IS
2365: /* Bug 5212165 added line_no in the order by */
2366: CURSOR cur_get_materials IS
2367: SELECT d.*
2368: FROM gme_material_details d, mtl_system_items_b i
2369: WHERE d.batch_id IN (SELECT DISTINCT batch_id
2370: FROM gme_material_details
2371: START WITH batch_id = p_batch_id
2372: CONNECT BY batch_id = PRIOR phantom_id)

Line 2370: FROM gme_material_details

2366: CURSOR cur_get_materials IS
2367: SELECT d.*
2368: FROM gme_material_details d, mtl_system_items_b i
2369: WHERE d.batch_id IN (SELECT DISTINCT batch_id
2370: FROM gme_material_details
2371: START WITH batch_id = p_batch_id
2372: CONNECT BY batch_id = PRIOR phantom_id)
2373: AND d.line_type = -1
2374: AND d.phantom_type = 0

Line 2441: l_mtl_dtl_rec gme_material_details%ROWTYPE;

2437: l_msg_count NUMBER;
2438: l_msg_data VARCHAR2 (2000);
2439: l_subinventory VARCHAR2 (10);
2440: l_return_status VARCHAR2 (1);
2441: l_mtl_dtl_rec gme_material_details%ROWTYPE;
2442: --FPbug#4912179
2443: --l_item_rec mtl_system_items_kfv%ROWTYPE;
2444: l_item_rec cur_get_item%ROWTYPE;
2445: l_exception_rec gme_exceptions_gtmp%ROWTYPE;

Line 2809: p_mtl_dtl_rec IN gme_material_details%ROWTYPE

2805: x_return_status := fnd_api.g_ret_sts_unexp_error;
2806: END get_batch_shortages;
2807:
2808: PROCEDURE get_open_qty (
2809: p_mtl_dtl_rec IN gme_material_details%ROWTYPE
2810: ,p_called_by IN VARCHAR2
2811: , /* P- picking, R-reservation, S-shortages */
2812: p_item_location_control IN NUMBER DEFAULT NULL
2813: ,p_item_restrict_locators IN NUMBER DEFAULT NULL

Line 3146: p_material_detail_id IN gme_material_details.material_detail_id%TYPE)

3142: RETURN FALSE;
3143: END populate_temp_from_struct;
3144:
3145: FUNCTION is_material_assoc_to_step (
3146: p_material_detail_id IN gme_material_details.material_detail_id%TYPE)
3147: RETURN BOOLEAN
3148: IS
3149: l_assoc_count NUMBER;
3150: l_is_assoc BOOLEAN;

Line 3189: p_material_detail_id IN gme_material_details.material_detail_id%TYPE

3185: RETURN l_is_assoc;
3186: END is_material_assoc_to_step;
3187:
3188: FUNCTION get_assoc_step (
3189: p_material_detail_id IN gme_material_details.material_detail_id%TYPE
3190: ,x_batchstep_id OUT NOCOPY NUMBER
3191: ,x_batchstep_status OUT NOCOPY NUMBER)
3192: RETURN BOOLEAN
3193: IS

Line 3993: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh, gme_material_details d

3989: FTS and for better performance */
3990: CURSOR cur_get_mo_lines
3991: IS
3992: SELECT mtrl.line_id, mtrl.inventory_item_id
3993: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh, gme_material_details d
3994: WHERE d.material_detail_id = p_material_detail_id
3995: AND mtrl.organization_id = d.organization_id
3996: AND mtrh.organization_id = d.organization_id
3997: AND mtrl.inventory_item_id = d.inventory_item_id

Line 4055: l_material_detail_rec gme_material_details%ROWTYPE;

4051: l_return_status VARCHAR2 (1);
4052: l_msg_data VARCHAR2 (2000);
4053: l_material_date DATE;
4054: l_lot_expiration_date DATE;
4055: l_material_detail_rec gme_material_details%ROWTYPE;
4056: l_batch_header_rec gme_batch_header%ROWTYPE;
4057: l_rsv inv_reservation_global.mtl_reservation_rec_type;
4058: ---l_rsv_array inv_reservation_global.mtl_reservation_tbl_type; --------- Punit Kumar
4059: l_rsv_array gme_common_pvt.reservations_tab;

Line 4082: IF NOT gme_material_details_dbl.fetch_row (l_material_detail_rec

4078: x_return_status := fnd_api.g_ret_sts_success;
4079: -- Fetch material details.
4080: l_material_detail_rec.material_detail_id := p_material_detail_id;
4081:
4082: IF NOT gme_material_details_dbl.fetch_row (l_material_detail_rec
4083: ,l_material_detail_rec) THEN
4084: RAISE fnd_api.g_exc_error;
4085: END IF;
4086:

Line 4103: || ' in Gme_material_details with new Material Required Date : '

4099: gme_debug.put_line
4100: ( 'Update existing Material Required Date : '
4101: || TO_CHAR (l_material_detail_rec.material_requirement_date
4102: ,'MM/DD/YYYY HH24:MI:SS')
4103: || ' in Gme_material_details with new Material Required Date : '
4104: || TO_CHAR (p_material_date, 'MM/DD/YYYY HH24:MI:SS') );
4105: END IF;
4106: ELSE /* p_material_date IS NULL */
4107: IF (NVL (g_debug, 0) IN

Line 4142: -- Update new material_required_date in gme_material_details.

4138: RAISE fnd_api.g_exc_error;
4139: END IF;
4140: END IF; /* p_material_date IS NOT NULL */
4141:
4142: -- Update new material_required_date in gme_material_details.
4143: l_material_detail_rec.material_requirement_date := l_material_date;
4144:
4145: IF NOT gme_material_details_dbl.update_row
4146: (p_material_detail => l_material_detail_rec) THEN

Line 4145: IF NOT gme_material_details_dbl.update_row

4141:
4142: -- Update new material_required_date in gme_material_details.
4143: l_material_detail_rec.material_requirement_date := l_material_date;
4144:
4145: IF NOT gme_material_details_dbl.update_row
4146: (p_material_detail => l_material_detail_rec) THEN
4147: RAISE fnd_api.g_exc_error;
4148: END IF;
4149:

Line 4152: gme_debug.put_line ('Came back from update of gme_material_details');

4148: END IF;
4149:
4150: IF (NVL (g_debug, 0) IN
4151: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4152: gme_debug.put_line ('Came back from update of gme_material_details');
4153: END IF;
4154:
4155: IF (NVL (g_debug, 0) IN
4156: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

Line 4543: p_line_id IN gme_material_details.material_detail_id%TYPE)

4539: -- SYNOPSIS:
4540: --
4541: --===================================================================== */
4542: FUNCTION is_material_auto_release (
4543: p_line_id IN gme_material_details.material_detail_id%TYPE)
4544: RETURN NUMBER
4545: IS
4546: l_release_type gme_material_details.release_type%TYPE;
4547: l_dep_count NUMBER;

Line 4546: l_release_type gme_material_details.release_type%TYPE;

4542: FUNCTION is_material_auto_release (
4543: p_line_id IN gme_material_details.material_detail_id%TYPE)
4544: RETURN NUMBER
4545: IS
4546: l_release_type gme_material_details.release_type%TYPE;
4547: l_dep_count NUMBER;
4548: l_is_auto NUMBER;
4549: l_api_name CONSTANT VARCHAR2 (30) := 'IS_MATERIAL_AUTO_RELEASE';
4550: BEGIN

Line 4559: FROM gme_material_details

4555: END IF;
4556:
4557: SELECT release_type
4558: INTO l_release_type
4559: FROM gme_material_details
4560: WHERE material_detail_id = p_line_id;
4561:
4562: l_is_auto := l_release_type;
4563:

Line 4613: p_material_detail_rec IN gme_material_details%ROWTYPE

4609: RETURN l_is_auto;
4610: END is_material_auto_release;
4611:
4612: FUNCTION get_material_detail (
4613: p_material_detail_rec IN gme_material_details%ROWTYPE
4614: ,p_org_code IN VARCHAR2
4615: ,p_batch_no IN VARCHAR2
4616: ,p_batch_type IN NUMBER
4617: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 4618: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

4614: ,p_org_code IN VARCHAR2
4615: ,p_batch_no IN VARCHAR2
4616: ,p_batch_type IN NUMBER
4617: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4618: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
4619: RETURN BOOLEAN
4620: IS
4621: l_batch_header_rec gme_batch_header%ROWTYPE;
4622: l_material_detail_rec gme_material_details%ROWTYPE;

Line 4622: l_material_detail_rec gme_material_details%ROWTYPE;

4618: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
4619: RETURN BOOLEAN
4620: IS
4621: l_batch_header_rec gme_batch_header%ROWTYPE;
4622: l_material_detail_rec gme_material_details%ROWTYPE;
4623: l_api_name VARCHAR2 (30) := 'GET_MATERIAL_DETAIL';
4624: material_detail_fetch_error EXCEPTION;
4625: batch_header_fetch_error EXCEPTION;
4626: BEGIN

Line 4650: IF NOT (gme_material_details_dbl.fetch_row (l_material_detail_rec

4646:
4647: l_material_detail_rec := p_material_detail_rec;
4648: l_material_detail_rec.batch_id := x_batch_header_rec.batch_id;
4649:
4650: IF NOT (gme_material_details_dbl.fetch_row (l_material_detail_rec
4651: ,x_material_detail_rec) ) THEN
4652: RAISE material_detail_fetch_error;
4653: END IF;
4654:

Line 4843: p_material_detail_rec IN gme_material_details%ROWTYPE

4839: --
4840: --===================================================================== */
4841:
4842: Procedure Validate_material_detail (
4843: p_material_detail_rec IN gme_material_details%ROWTYPE
4844: ,p_org_code IN VARCHAR2
4845: ,p_batch_no IN VARCHAR2
4846: ,p_batch_type IN NUMBER
4847: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 4848: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

4844: ,p_org_code IN VARCHAR2
4845: ,p_batch_no IN VARCHAR2
4846: ,p_batch_type IN NUMBER
4847: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4848: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
4849: ,x_message_count OUT NOCOPY NUMBER
4850: ,x_message_list OUT NOCOPY VARCHAR2
4851: ,x_return_status OUT NOCOPY VARCHAR2)
4852:

Line 4856: l_material_detail_rec gme_material_details%ROWTYPE;

4852:
4853: IS
4854: l_api_name VARCHAR2 (100) := 'validate_material_detail';
4855: l_batch_header_rec gme_batch_header%ROWTYPE;
4856: l_material_detail_rec gme_material_details%ROWTYPE;
4857: material_fetch_error EXCEPTION;
4858: BEGIN
4859: IF g_debug <= gme_debug.g_log_procedure THEN
4860: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 5077: l_material_detail_rec gme_material_details%ROWTYPE;

5073: l_trans_date DATE;
5074: l_step_actual_start DATE;
5075: l_step_actual_cmplt DATE;
5076:
5077: l_material_detail_rec gme_material_details%ROWTYPE;
5078: l_batch_header_rec gme_batch_header%ROWTYPE;
5079:
5080: error_fetch_material EXCEPTION;
5081: error_fetch_batch_details EXCEPTION;

Line 5106: IF NOT (gme_material_details_dbl.fetch_row(l_material_detail_rec, l_material_detail_rec)) THEN

5102:
5103: /* fetch the material detail record */
5104: l_material_detail_rec.material_detail_id := p_material_detail_id;
5105:
5106: IF NOT (gme_material_details_dbl.fetch_row(l_material_detail_rec, l_material_detail_rec)) THEN
5107: IF g_debug <= gme_debug.g_log_statement THEN
5108: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'||'Error in Fetching the material detail record');
5109: END IF;
5110: RAISE error_fetch_material;