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 276: (p_batch_header_rec IN gme_batch_header%ROWTYPE

272: x_return_status := FND_API.g_ret_sts_unexp_error;
273: END insert_material_line;
274:
275: PROCEDURE validate_batch_for_matl_ins
276: (p_batch_header_rec IN gme_batch_header%ROWTYPE
277: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
278: ,x_return_status OUT NOCOPY VARCHAR2) IS
279:
280: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_matl_ins';

Line 349: p_batch_header_rec IN gme_batch_header%ROWTYPE

345: *
346: *
347: ***********************************************************************/
348: PROCEDURE validate_material_for_ins (
349: p_batch_header_rec IN gme_batch_header%ROWTYPE
350: ,p_material_detail_rec IN gme_material_details%ROWTYPE
351: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
352: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
353: ,x_return_status OUT NOCOPY VARCHAR2)

Line 797: p_batch_header_rec IN gme_batch_header%ROWTYPE

793: x_return_status := FND_API.g_ret_sts_unexp_error;
794: END validate_material_for_ins;
795:
796: PROCEDURE open_and_process_actual_qty (
797: p_batch_header_rec IN gme_batch_header%ROWTYPE
798: ,p_material_detail_rec IN gme_material_details%ROWTYPE
799: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE DEFAULT NULL
800: ,p_trans_id IN NUMBER
801: ,p_insert IN VARCHAR2

Line 1381: p_batch_header_rec IN gme_batch_header%ROWTYPE

1377: RETURN -2;
1378: END open_actual_qty;
1379:
1380: PROCEDURE process_actual_qty (
1381: p_batch_header_rec IN gme_batch_header%ROWTYPE
1382: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1383: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1384: DEFAULT NULL
1385: ,p_trans_id IN NUMBER

Line 1547: ,p_batch_hdr_rec IN gme_batch_header%ROWTYPE

1543:
1544: PROCEDURE construct_trans_row (
1545: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1546: ,p_item_rec IN mtl_system_items_b%ROWTYPE
1547: ,p_batch_hdr_rec IN gme_batch_header%ROWTYPE
1548: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1549: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1550: ,x_return_status OUT NOCOPY VARCHAR2)
1551: IS

Line 2766: FROM gme_batch_header

2762: WHERE si.batchstep_id = s.batchstep_id
2763: AND si.material_detail_id = v_material_detail_id;
2764: CURSOR Cur_get_batch_status(v_batch_id NUMBER) IS
2765: SELECT batch_status
2766: FROM gme_batch_header
2767: WHERE batch_id = v_batch_id;
2768: CURSOR Cur_get_cost_alloc(v_material_detail_id NUMBER) IS
2769: SELECT cost_alloc
2770: FROM gme_material_details

Line 3119: p_batch_header_rec IN gme_batch_header%ROWTYPE

3115: x_return_status := fnd_api.g_ret_sts_unexp_error;
3116: END validate_locator;
3117:
3118: PROCEDURE update_material_line (
3119: p_batch_header_rec IN gme_batch_header%ROWTYPE
3120: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3121: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3122: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3123: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false

Line 3146: l_ph_batch_header_rec gme_batch_header%ROWTYPE;

3142: l_rsc_count NUMBER;
3143: l_message_count NUMBER;
3144: l_message_list VARCHAR2 (2000);
3145:
3146: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
3147: l_batch_header_rec gme_batch_header%ROWTYPE;
3148: l_out_material_detail_tbl gme_common_pvt.material_details_tab;
3149: l_material_detail_tbl gme_common_pvt.material_details_tab;
3150: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 3147: l_batch_header_rec gme_batch_header%ROWTYPE;

3143: l_message_count NUMBER;
3144: l_message_list VARCHAR2 (2000);
3145:
3146: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
3147: l_batch_header_rec gme_batch_header%ROWTYPE;
3148: l_out_material_detail_tbl gme_common_pvt.material_details_tab;
3149: l_material_detail_tbl gme_common_pvt.material_details_tab;
3150: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
3151:

Line 3158: l_phantom_batch_header_rec_out gme_batch_header%ROWTYPE;

3154: l_db_mtl_dtl_rec gme_material_details%ROWTYPE;
3155: l_batch_step_rec gme_batch_steps%ROWTYPE;
3156: l_exception_material_tbl gme_common_pvt.exceptions_tab;
3157: l_ph_batch_step_rec gme_batch_steps%ROWTYPE;
3158: l_phantom_batch_header_rec_out gme_batch_header%ROWTYPE;
3159: l_step_tbl gme_reschedule_step_pvt.step_tab;
3160: x_batch_step_rec gme_batch_steps%ROWTYPE;
3161: error_dbl EXCEPTION;
3162: error_processing EXCEPTION;

Line 3163: l_plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE;

3159: l_step_tbl gme_reschedule_step_pvt.step_tab;
3160: x_batch_step_rec gme_batch_steps%ROWTYPE;
3161: error_dbl EXCEPTION;
3162: error_processing EXCEPTION;
3163: l_plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE;
3164:
3165: BEGIN
3166: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
3167: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

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

3376: /*REWORK Sunitha ch. Bug 5353941 Check whether phantom material is associated to
3377: step and call reschedule batch if it is not associated to step or call
3378: rescedule step for that batch if it is associated to step*/
3379: l_ph_batch_header_rec.batch_id := l_db_mtl_dtl_rec.phantom_id;
3380: IF NOT gme_batch_header_dbl.fetch_row(l_ph_batch_header_rec, l_ph_batch_header_rec) THEN
3381: l_proc := 'gme_batch_header_dbl.fetch_row';
3382: RAISE error_dbl;
3383: END IF;
3384:

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

3377: step and call reschedule batch if it is not associated to step or call
3378: rescedule step for that batch if it is associated to step*/
3379: l_ph_batch_header_rec.batch_id := l_db_mtl_dtl_rec.phantom_id;
3380: IF NOT gme_batch_header_dbl.fetch_row(l_ph_batch_header_rec, l_ph_batch_header_rec) THEN
3381: l_proc := 'gme_batch_header_dbl.fetch_row';
3382: RAISE error_dbl;
3383: END IF;
3384:
3385: IF p_scale_phantom = FND_API.G_TRUE AND l_factor <> 1 THEN

Line 3467: FROM gme_batch_header

3463: l_ph_mtl_dtl_rec.material_detail_id );
3464: ELSE
3465: SELECT plan_start_date
3466: INTO l_plan_cmplt_date
3467: FROM gme_batch_header
3468: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id;
3469: END IF;
3470: l_mtl_dtl_rec.material_requirement_date:=l_plan_cmplt_date;
3471: l_ph_mtl_dtl_rec.material_requirement_date := l_mtl_dtl_rec.material_requirement_date;

Line 3689: p_batch_header_rec IN gme_batch_header%ROWTYPE

3685: END update_material_line;
3686:
3687: --Bug#5078853 removed p_validate_flexfields parameter
3688: PROCEDURE val_and_pop_material_for_upd (
3689: p_batch_header_rec IN gme_batch_header%ROWTYPE
3690: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3691: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3692: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3693: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

Line 4213: p_batch_header_rec IN gme_batch_header%ROWTYPE

4209: END val_and_pop_material_for_upd;
4210:
4211: --Bug#5078853 Procedure Created
4212: PROCEDURE validate_material_for_del (
4213: p_batch_header_rec IN gme_batch_header%ROWTYPE
4214: ,p_material_detail_rec IN gme_material_details%ROWTYPE
4215: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4216: ,x_return_status OUT NOCOPY VARCHAR2) IS
4217:

Line 4243: FROM gme_batch_header h, gmd_recipe_validity_rules r

4239: /*CURSOR cur_parent_phant (v_batch_id NUMBER, v_item_id NUMBER) IS
4240: SELECT 1
4241: FROM sys.DUAL
4242: WHERE EXISTS ( SELECT 1
4243: FROM gme_batch_header h, gmd_recipe_validity_rules r
4244: WHERE h.batch_id = v_batch_id
4245: AND h.recipe_validity_rule_id = r.recipe_validity_rule_id
4246: AND r.item_id = v_item_id
4247: AND h.parentline_id > 0); */

Line 4410: p_batch_header_rec IN gme_batch_header%ROWTYPE

4406: x_return_status := fnd_api.g_ret_sts_unexp_error;
4407: END validate_phantom_type_change;
4408:
4409: PROCEDURE delete_material_line (
4410: p_batch_header_rec IN gme_batch_header%ROWTYPE
4411: ,p_material_detail_rec IN gme_material_details%ROWTYPE
4412: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4413: ,x_transacted OUT NOCOPY VARCHAR2
4414: ,x_return_status OUT NOCOPY VARCHAR2)