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_STEPS

Line 9: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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
12: ,x_return_status OUT NOCOPY VARCHAR2
13: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

Line 18: l_batch_step_rec gme_batch_steps%ROWTYPE;

14: IS
15: l_api_name CONSTANT VARCHAR2 (30) := 'insert_material_line';
16: l_material_detail_rec gme_material_details%ROWTYPE;
17: l_batchstep_items gme_batch_step_items%ROWTYPE;
18: l_batch_step_rec gme_batch_steps%ROWTYPE;
19: l_out_material_detail_tbl gme_common_pvt.material_details_tab;
20: l_material_detail_tbl gme_common_pvt.material_details_tab;
21: l_recipe_id NUMBER;
22: l_message_count NUMBER;

Line 277: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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';
281:

Line 351: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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)
354: IS
355: l_item_rec mtl_system_items_b%ROWTYPE;

Line 799: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE DEFAULT NULL

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
802: ,x_transacted OUT NOCOPY VARCHAR2
803: ,x_return_status OUT NOCOPY VARCHAR2)

Line 991: FROM gme_batch_steps

987:
988: CURSOR cur_get_step_status (v_step_id NUMBER)
989: IS
990: SELECT step_status
991: FROM gme_batch_steps
992: WHERE batchstep_id = v_step_id;
993: --Bug#5129153 To find out if the item is revision controlled or not Start.
994: CURSOR cur_get_rev_code (v_org_id NUMBER,v_item_id NUMBER)
995: IS

Line 1383: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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
1386: ,p_item_rec IN mtl_system_items_b%ROWTYPE
1387: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1548: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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
1552:

Line 2761: FROM gme_batch_step_items si, gme_batch_steps s

2757: IS
2758: --FPBug#4524232 Begin
2759: CURSOR Cur_get_step_status(v_material_detail_id NUMBER) IS
2760: SELECT steprelease_type,step_status
2761: FROM gme_batch_step_items si, gme_batch_steps s
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

Line 3122: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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
3124: ,p_trans_id IN NUMBER
3125: ,x_transacted OUT NOCOPY VARCHAR2
3126: ,x_return_status OUT NOCOPY VARCHAR2

Line 3155: l_batch_step_rec gme_batch_steps%ROWTYPE;

3151:
3152: l_mtl_dtl_rec gme_material_details%ROWTYPE;
3153: l_ph_mtl_dtl_rec gme_material_details%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;

Line 3157: l_ph_batch_step_rec gme_batch_steps%ROWTYPE;

3153: l_ph_mtl_dtl_rec gme_material_details%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;

Line 3160: x_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;
3163: l_plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE;
3164:

Line 3420: IF NOT gme_batch_steps_dbl.fetch_row(l_ph_batch_step_rec, l_ph_batch_step_rec) THEN

3416: SELECT batchstep_id INTO l_ph_batch_step_rec.batchstep_id
3417: FROM gme_batch_step_items
3418: WHERE batch_id = l_mtl_dtl_rec.phantom_id
3419: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3420: IF NOT gme_batch_steps_dbl.fetch_row(l_ph_batch_step_rec, l_ph_batch_step_rec) THEN
3421: l_proc := 'gme_batch_steps_dbl.fetch_row';
3422: RAISE error_dbl;
3423: END IF;
3424: l_ph_batch_step_rec.plan_cmplt_date:=l_mtl_dtl_rec.material_requirement_date;

Line 3421: l_proc := 'gme_batch_steps_dbl.fetch_row';

3417: FROM gme_batch_step_items
3418: WHERE batch_id = l_mtl_dtl_rec.phantom_id
3419: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3420: IF NOT gme_batch_steps_dbl.fetch_row(l_ph_batch_step_rec, l_ph_batch_step_rec) THEN
3421: l_proc := 'gme_batch_steps_dbl.fetch_row';
3422: RAISE error_dbl;
3423: END IF;
3424: l_ph_batch_step_rec.plan_cmplt_date:=l_mtl_dtl_rec.material_requirement_date;
3425: l_ph_batch_step_rec.plan_start_date:=NULL;

Line 3456: FROM gme_batch_steps

3452: gme_common_pvt.is_material_assoc_to_step
3453: (l_ph_mtl_dtl_rec.material_detail_id )) THEN
3454: SELECT plan_start_date
3455: INTO l_plan_cmplt_date
3456: FROM gme_batch_steps
3457: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id
3458: AND batchstep_id =
3459: (SELECT batchstep_id
3460: FROM gme_batch_step_items

Line 3692: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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
3694: ,x_return_status OUT NOCOPY VARCHAR2)
3695: IS
3696: l_item_rec mtl_system_items_b%ROWTYPE;

Line 4215: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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:
4218: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_del';
4219:

Line 4412: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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)
4415: IS
4416:

Line 4419: l_batch_step_rec gme_batch_steps%ROWTYPE;

4415: IS
4416:
4417: l_message_count NUMBER;
4418: l_message_list VARCHAR2 (2000);
4419: l_batch_step_rec gme_batch_steps%ROWTYPE;
4420: l_rsc_count NUMBER;
4421: l_proc VARCHAR2(100);
4422:
4423: l_mmt_tbl gme_common_pvt.mtl_mat_tran_tbl;