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 848: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

844: PROCEDURE construct_material_detail (
845: p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
846: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE
847: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
848: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
849: ,x_return_status OUT NOCOPY VARCHAR2)
850: IS
851: l_api_name CONSTANT VARCHAR2 (30) := 'construct_material_detail';
852: l_return_status VARCHAR2 (1);

Line 1486: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE

1482: p_batch_header_rec IN gme_batch_header%ROWTYPE
1483: DEFAULT NULL
1484: ,p_batchstep_rec IN gme_batch_steps%ROWTYPE
1485: DEFAULT NULL
1486: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE
1487: ,x_mtl_req_date OUT NOCOPY DATE
1488: ,x_return_status OUT NOCOPY VARCHAR2)
1489: IS
1490: l_batchstep_id NUMBER;

Line 2483: FROM gme_material_details d, mtl_system_items_b i

2479: ,x_exception_tbl OUT NOCOPY gme_common_pvt.exceptions_tab) IS
2480: /* Bug 5212165 added line_no in the order by */
2481: CURSOR cur_get_materials IS
2482: SELECT d.*
2483: FROM gme_material_details d, mtl_system_items_b i
2484: WHERE d.batch_id IN (SELECT DISTINCT batch_id
2485: FROM gme_material_details
2486: START WITH batch_id = p_batch_id
2487: CONNECT BY batch_id = PRIOR phantom_id)

Line 2485: FROM gme_material_details

2481: CURSOR cur_get_materials IS
2482: SELECT d.*
2483: FROM gme_material_details d, mtl_system_items_b i
2484: WHERE d.batch_id IN (SELECT DISTINCT batch_id
2485: FROM gme_material_details
2486: START WITH batch_id = p_batch_id
2487: CONNECT BY batch_id = PRIOR phantom_id)
2488: AND d.line_type = -1
2489: AND d.phantom_type = 0

Line 2566: l_mtl_dtl_rec gme_material_details%ROWTYPE;

2562: l_msg_count NUMBER;
2563: l_msg_data VARCHAR2 (2000);
2564: l_subinventory VARCHAR2 (10);
2565: l_return_status VARCHAR2 (1);
2566: l_mtl_dtl_rec gme_material_details%ROWTYPE;
2567: --FPbug#4912179
2568: --l_item_rec mtl_system_items_kfv%ROWTYPE;
2569: l_item_rec cur_get_item%ROWTYPE;
2570: l_exception_rec gme_exceptions_gtmp%ROWTYPE;

Line 2973: p_mtl_dtl_rec IN gme_material_details%ROWTYPE

2969: x_return_status := fnd_api.g_ret_sts_unexp_error;
2970: END get_batch_shortages;
2971:
2972: PROCEDURE get_open_qty (
2973: p_mtl_dtl_rec IN gme_material_details%ROWTYPE
2974: ,p_called_by IN VARCHAR2
2975: , /* P- picking, R-reservation, S-shortages, Z-from Auto-Detail line */
2976: p_item_location_control IN NUMBER DEFAULT NULL
2977: ,p_item_restrict_locators IN NUMBER DEFAULT NULL

Line 3405: p_material_detail_id IN gme_material_details.material_detail_id%TYPE)

3401: RETURN FALSE;
3402: END populate_temp_from_struct;
3403:
3404: FUNCTION is_material_assoc_to_step (
3405: p_material_detail_id IN gme_material_details.material_detail_id%TYPE)
3406: RETURN BOOLEAN
3407: IS
3408: l_assoc_count NUMBER;
3409: l_is_assoc BOOLEAN;

Line 3448: p_material_detail_id IN gme_material_details.material_detail_id%TYPE

3444: RETURN l_is_assoc;
3445: END is_material_assoc_to_step;
3446:
3447: FUNCTION get_assoc_step (
3448: p_material_detail_id IN gme_material_details.material_detail_id%TYPE
3449: ,x_batchstep_id OUT NOCOPY NUMBER
3450: ,x_batchstep_status OUT NOCOPY NUMBER)
3451: RETURN BOOLEAN
3452: IS

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

4248: FTS and for better performance */
4249: CURSOR cur_get_mo_lines
4250: IS
4251: SELECT mtrl.line_id, mtrl.inventory_item_id
4252: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh, gme_material_details d
4253: WHERE d.material_detail_id = p_material_detail_id
4254: AND mtrl.organization_id = d.organization_id
4255: AND mtrh.organization_id = d.organization_id
4256: AND mtrl.inventory_item_id = d.inventory_item_id

Line 4314: l_material_detail_rec gme_material_details%ROWTYPE;

4310: l_return_status VARCHAR2 (1);
4311: l_msg_data VARCHAR2 (2000);
4312: l_material_date DATE;
4313: l_lot_expiration_date DATE;
4314: l_material_detail_rec gme_material_details%ROWTYPE;
4315: l_batch_header_rec gme_batch_header%ROWTYPE;
4316: l_rsv inv_reservation_global.mtl_reservation_rec_type;
4317: ---l_rsv_array inv_reservation_global.mtl_reservation_tbl_type; --------- Punit Kumar
4318: l_rsv_array gme_common_pvt.reservations_tab;

Line 4341: IF NOT gme_material_details_dbl.fetch_row (l_material_detail_rec

4337: x_return_status := fnd_api.g_ret_sts_success;
4338: -- Fetch material details.
4339: l_material_detail_rec.material_detail_id := p_material_detail_id;
4340:
4341: IF NOT gme_material_details_dbl.fetch_row (l_material_detail_rec
4342: ,l_material_detail_rec) THEN
4343: RAISE fnd_api.g_exc_error;
4344: END IF;
4345:

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

4358: gme_debug.put_line
4359: ( 'Update existing Material Required Date : '
4360: || TO_CHAR (l_material_detail_rec.material_requirement_date
4361: ,'MM/DD/YYYY HH24:MI:SS')
4362: || ' in Gme_material_details with new Material Required Date : '
4363: || TO_CHAR (p_material_date, 'MM/DD/YYYY HH24:MI:SS') );
4364: END IF;
4365: ELSE /* p_material_date IS NULL */
4366: IF (NVL (g_debug, 0) IN

Line 4401: -- Update new material_required_date in gme_material_details.

4397: RAISE fnd_api.g_exc_error;
4398: END IF;
4399: END IF; /* p_material_date IS NOT NULL */
4400:
4401: -- Update new material_required_date in gme_material_details.
4402: l_material_detail_rec.material_requirement_date := l_material_date;
4403:
4404: IF NOT gme_material_details_dbl.update_row
4405: (p_material_detail => l_material_detail_rec) THEN

Line 4404: IF NOT gme_material_details_dbl.update_row

4400:
4401: -- Update new material_required_date in gme_material_details.
4402: l_material_detail_rec.material_requirement_date := l_material_date;
4403:
4404: IF NOT gme_material_details_dbl.update_row
4405: (p_material_detail => l_material_detail_rec) THEN
4406: RAISE fnd_api.g_exc_error;
4407: END IF;
4408:

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

4407: END IF;
4408:
4409: IF (NVL (g_debug, 0) IN
4410: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4411: gme_debug.put_line ('Came back from update of gme_material_details');
4412: END IF;
4413:
4414: IF (NVL (g_debug, 0) IN
4415: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

Line 4802: p_line_id IN gme_material_details.material_detail_id%TYPE)

4798: -- SYNOPSIS:
4799: --
4800: --===================================================================== */
4801: FUNCTION is_material_auto_release (
4802: p_line_id IN gme_material_details.material_detail_id%TYPE)
4803: RETURN NUMBER
4804: IS
4805: l_release_type gme_material_details.release_type%TYPE;
4806: l_dep_count NUMBER;

Line 4805: l_release_type gme_material_details.release_type%TYPE;

4801: FUNCTION is_material_auto_release (
4802: p_line_id IN gme_material_details.material_detail_id%TYPE)
4803: RETURN NUMBER
4804: IS
4805: l_release_type gme_material_details.release_type%TYPE;
4806: l_dep_count NUMBER;
4807: l_is_auto NUMBER;
4808: l_api_name CONSTANT VARCHAR2 (30) := 'IS_MATERIAL_AUTO_RELEASE';
4809: BEGIN

Line 4818: FROM gme_material_details

4814: END IF;
4815:
4816: SELECT release_type
4817: INTO l_release_type
4818: FROM gme_material_details
4819: WHERE material_detail_id = p_line_id;
4820:
4821: l_is_auto := l_release_type;
4822:

Line 4872: p_material_detail_rec IN gme_material_details%ROWTYPE

4868: RETURN l_is_auto;
4869: END is_material_auto_release;
4870:
4871: FUNCTION get_material_detail (
4872: p_material_detail_rec IN gme_material_details%ROWTYPE
4873: ,p_org_code IN VARCHAR2
4874: ,p_batch_no IN VARCHAR2
4875: ,p_batch_type IN NUMBER
4876: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 4877: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

4873: ,p_org_code IN VARCHAR2
4874: ,p_batch_no IN VARCHAR2
4875: ,p_batch_type IN NUMBER
4876: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4877: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
4878: RETURN BOOLEAN
4879: IS
4880: l_batch_header_rec gme_batch_header%ROWTYPE;
4881: l_material_detail_rec gme_material_details%ROWTYPE;

Line 4881: l_material_detail_rec gme_material_details%ROWTYPE;

4877: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
4878: RETURN BOOLEAN
4879: IS
4880: l_batch_header_rec gme_batch_header%ROWTYPE;
4881: l_material_detail_rec gme_material_details%ROWTYPE;
4882: l_api_name VARCHAR2 (30) := 'GET_MATERIAL_DETAIL';
4883: material_detail_fetch_error EXCEPTION;
4884: batch_header_fetch_error EXCEPTION;
4885: BEGIN

Line 4909: IF NOT (gme_material_details_dbl.fetch_row (l_material_detail_rec

4905:
4906: l_material_detail_rec := p_material_detail_rec;
4907: l_material_detail_rec.batch_id := x_batch_header_rec.batch_id;
4908:
4909: IF NOT (gme_material_details_dbl.fetch_row (l_material_detail_rec
4910: ,x_material_detail_rec) ) THEN
4911: RAISE material_detail_fetch_error;
4912: END IF;
4913:

Line 5107: p_material_detail_rec IN gme_material_details%ROWTYPE

5103: --
5104: --===================================================================== */
5105:
5106: Procedure Validate_material_detail (
5107: p_material_detail_rec IN gme_material_details%ROWTYPE
5108: ,p_org_code IN VARCHAR2
5109: ,p_batch_no IN VARCHAR2
5110: ,p_batch_type IN NUMBER
5111: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 5112: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

5108: ,p_org_code IN VARCHAR2
5109: ,p_batch_no IN VARCHAR2
5110: ,p_batch_type IN NUMBER
5111: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
5112: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
5113: ,x_message_count OUT NOCOPY NUMBER
5114: ,x_message_list OUT NOCOPY VARCHAR2
5115: ,x_return_status OUT NOCOPY VARCHAR2)
5116:

Line 5120: l_material_detail_rec gme_material_details%ROWTYPE;

5116:
5117: IS
5118: l_api_name VARCHAR2 (100) := 'validate_material_detail';
5119: l_batch_header_rec gme_batch_header%ROWTYPE;
5120: l_material_detail_rec gme_material_details%ROWTYPE;
5121: material_fetch_error EXCEPTION;
5122: BEGIN
5123: IF g_debug <= gme_debug.g_log_procedure THEN
5124: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 5345: l_material_detail_rec gme_material_details%ROWTYPE;

5341: l_trans_date DATE;
5342: l_step_actual_start DATE;
5343: l_step_actual_cmplt DATE;
5344:
5345: l_material_detail_rec gme_material_details%ROWTYPE;
5346: l_batch_header_rec gme_batch_header%ROWTYPE;
5347:
5348: error_fetch_material EXCEPTION;
5349: error_fetch_batch_details EXCEPTION;

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

5370:
5371: /* fetch the material detail record */
5372: l_material_detail_rec.material_detail_id := p_material_detail_id;
5373:
5374: IF NOT (gme_material_details_dbl.fetch_row(l_material_detail_rec, l_material_detail_rec)) THEN
5375: IF g_debug <= gme_debug.g_log_statement THEN
5376: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'||'Error in Fetching the material detail record');
5377: END IF;
5378: RAISE error_fetch_material;