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_MATERIAL_DETAIL_PVT dependencies on GME_BATCH_HEADER

Line 7: (p_batch_header_rec IN gme_batch_header%ROWTYPE

3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name VARCHAR2 (30) := 'gme_material_detail_pvt';
5:
6: PROCEDURE insert_material_line
7: (p_batch_header_rec IN gme_batch_header%ROWTYPE
8: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
10: ,p_trans_id IN NUMBER
11: ,x_transacted OUT NOCOPY VARCHAR2

Line 316: (p_batch_header_rec IN gme_batch_header%ROWTYPE

312: x_return_status := FND_API.g_ret_sts_unexp_error;
313: END insert_material_line;
314:
315: PROCEDURE validate_batch_for_matl_ins
316: (p_batch_header_rec IN gme_batch_header%ROWTYPE
317: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
318: ,x_return_status OUT NOCOPY VARCHAR2) IS
319:
320: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_matl_ins';

Line 389: p_batch_header_rec IN gme_batch_header%ROWTYPE

385: *
386: *
387: ***********************************************************************/
388: PROCEDURE validate_material_for_ins (
389: p_batch_header_rec IN gme_batch_header%ROWTYPE
390: ,p_material_detail_rec IN gme_material_details%ROWTYPE
391: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
392: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
393: ,x_return_status OUT NOCOPY VARCHAR2)

Line 837: p_batch_header_rec IN gme_batch_header%ROWTYPE

833: x_return_status := FND_API.g_ret_sts_unexp_error;
834: END validate_material_for_ins;
835:
836: PROCEDURE open_and_process_actual_qty (
837: p_batch_header_rec IN gme_batch_header%ROWTYPE
838: ,p_material_detail_rec IN gme_material_details%ROWTYPE
839: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE DEFAULT NULL
840: ,p_trans_id IN NUMBER
841: ,p_insert IN VARCHAR2

Line 1421: p_batch_header_rec IN gme_batch_header%ROWTYPE

1417: RETURN -2;
1418: END open_actual_qty;
1419:
1420: PROCEDURE process_actual_qty (
1421: p_batch_header_rec IN gme_batch_header%ROWTYPE
1422: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1423: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1424: DEFAULT NULL
1425: ,p_trans_id IN NUMBER

Line 1690: ,p_batch_hdr_rec IN gme_batch_header%ROWTYPE

1686:
1687: PROCEDURE construct_trans_row (
1688: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1689: ,p_item_rec IN mtl_system_items_b%ROWTYPE
1690: ,p_batch_hdr_rec IN gme_batch_header%ROWTYPE
1691: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1692: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1693: ,x_return_status OUT NOCOPY VARCHAR2)
1694: IS

Line 2910: FROM gme_batch_header

2906: WHERE si.batchstep_id = s.batchstep_id
2907: AND si.material_detail_id = v_material_detail_id;
2908: CURSOR Cur_get_batch_status(v_batch_id NUMBER) IS
2909: SELECT batch_status
2910: FROM gme_batch_header
2911: WHERE batch_id = v_batch_id;
2912: CURSOR Cur_get_cost_alloc(v_material_detail_id NUMBER) IS
2913: SELECT cost_alloc
2914: FROM gme_material_details

Line 3263: p_batch_header_rec IN gme_batch_header%ROWTYPE

3259: x_return_status := fnd_api.g_ret_sts_unexp_error;
3260: END validate_locator;
3261:
3262: PROCEDURE update_material_line (
3263: p_batch_header_rec IN gme_batch_header%ROWTYPE
3264: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3265: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3266: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3267: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false

Line 3292: l_ph_batch_header_rec gme_batch_header%ROWTYPE;

3288: l_message_list VARCHAR2 (2000);
3289:
3290: l_compare_qty NUMBER; -- 13076579
3291:
3292: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
3293: l_batch_header_rec gme_batch_header%ROWTYPE;
3294: l_out_material_detail_tbl gme_common_pvt.material_details_tab;
3295: l_material_detail_tbl gme_common_pvt.material_details_tab;
3296: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 3293: l_batch_header_rec gme_batch_header%ROWTYPE;

3289:
3290: l_compare_qty NUMBER; -- 13076579
3291:
3292: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
3293: l_batch_header_rec gme_batch_header%ROWTYPE;
3294: l_out_material_detail_tbl gme_common_pvt.material_details_tab;
3295: l_material_detail_tbl gme_common_pvt.material_details_tab;
3296: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
3297:

Line 3304: l_phantom_batch_header_rec_out gme_batch_header%ROWTYPE;

3300: l_db_mtl_dtl_rec gme_material_details%ROWTYPE;
3301: l_batch_step_rec gme_batch_steps%ROWTYPE;
3302: l_exception_material_tbl gme_common_pvt.exceptions_tab;
3303: l_ph_batch_step_rec gme_batch_steps%ROWTYPE;
3304: l_phantom_batch_header_rec_out gme_batch_header%ROWTYPE;
3305: l_step_tbl gme_reschedule_step_pvt.step_tab;
3306: x_batch_step_rec gme_batch_steps%ROWTYPE;
3307: error_dbl EXCEPTION;
3308: error_processing EXCEPTION;

Line 3309: l_plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE;

3305: l_step_tbl gme_reschedule_step_pvt.step_tab;
3306: x_batch_step_rec gme_batch_steps%ROWTYPE;
3307: error_dbl EXCEPTION;
3308: error_processing EXCEPTION;
3309: l_plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE;
3310:
3311: BEGIN
3312: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
3313: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

Line 3526: IF NOT gme_batch_header_dbl.fetch_row(l_ph_batch_header_rec, l_ph_batch_header_rec) THEN

3522: /*REWORK Sunitha ch. Bug 5353941 Check whether phantom material is associated to
3523: step and call reschedule batch if it is not associated to step or call
3524: rescedule step for that batch if it is associated to step*/
3525: l_ph_batch_header_rec.batch_id := l_db_mtl_dtl_rec.phantom_id;
3526: IF NOT gme_batch_header_dbl.fetch_row(l_ph_batch_header_rec, l_ph_batch_header_rec) THEN
3527: l_proc := 'gme_batch_header_dbl.fetch_row';
3528: RAISE error_dbl;
3529: END IF;
3530:

Line 3527: l_proc := 'gme_batch_header_dbl.fetch_row';

3523: step and call reschedule batch if it is not associated to step or call
3524: rescedule step for that batch if it is associated to step*/
3525: l_ph_batch_header_rec.batch_id := l_db_mtl_dtl_rec.phantom_id;
3526: IF NOT gme_batch_header_dbl.fetch_row(l_ph_batch_header_rec, l_ph_batch_header_rec) THEN
3527: l_proc := 'gme_batch_header_dbl.fetch_row';
3528: RAISE error_dbl;
3529: END IF;
3530:
3531: IF p_scale_phantom = FND_API.G_TRUE AND l_factor <> 1 THEN

Line 3613: FROM gme_batch_header

3609: l_ph_mtl_dtl_rec.material_detail_id );
3610: ELSE
3611: SELECT plan_start_date
3612: INTO l_plan_cmplt_date
3613: FROM gme_batch_header
3614: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id;
3615: END IF;
3616: l_mtl_dtl_rec.material_requirement_date:=l_plan_cmplt_date;
3617: l_ph_mtl_dtl_rec.material_requirement_date := l_mtl_dtl_rec.material_requirement_date;

Line 3880: p_batch_header_rec IN gme_batch_header%ROWTYPE

3876: END update_material_line;
3877:
3878: --Bug#5078853 removed p_validate_flexfields parameter
3879: PROCEDURE val_and_pop_material_for_upd (
3880: p_batch_header_rec IN gme_batch_header%ROWTYPE
3881: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3882: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3883: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3884: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

Line 4404: p_batch_header_rec IN gme_batch_header%ROWTYPE

4400: END val_and_pop_material_for_upd;
4401:
4402: --Bug#5078853 Procedure Created
4403: PROCEDURE validate_material_for_del (
4404: p_batch_header_rec IN gme_batch_header%ROWTYPE
4405: ,p_material_detail_rec IN gme_material_details%ROWTYPE
4406: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4407: ,x_return_status OUT NOCOPY VARCHAR2) IS
4408:

Line 4434: FROM gme_batch_header h, gmd_recipe_validity_rules r

4430: /*CURSOR cur_parent_phant (v_batch_id NUMBER, v_item_id NUMBER) IS
4431: SELECT 1
4432: FROM sys.DUAL
4433: WHERE EXISTS ( SELECT 1
4434: FROM gme_batch_header h, gmd_recipe_validity_rules r
4435: WHERE h.batch_id = v_batch_id
4436: AND h.recipe_validity_rule_id = r.recipe_validity_rule_id
4437: AND r.item_id = v_item_id
4438: AND h.parentline_id > 0); */

Line 4603: p_batch_header_rec IN gme_batch_header%ROWTYPE

4599: x_return_status := fnd_api.g_ret_sts_unexp_error;
4600: END validate_phantom_type_change;
4601:
4602: PROCEDURE delete_material_line (
4603: p_batch_header_rec IN gme_batch_header%ROWTYPE
4604: ,p_material_detail_rec IN gme_material_details%ROWTYPE
4605: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4606: ,x_transacted OUT NOCOPY VARCHAR2
4607: ,x_return_status OUT NOCOPY VARCHAR2)