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.

[Home] [Help]

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 317: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 391: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 839: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE DEFAULT NULL

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

Line 1031: FROM gme_batch_steps

1027:
1028: CURSOR cur_get_step_status (v_step_id NUMBER)
1029: IS
1030: SELECT step_status
1031: FROM gme_batch_steps
1032: WHERE batchstep_id = v_step_id;
1033: --Bug#5129153 To find out if the item is revision controlled or not Start.
1034: CURSOR cur_get_rev_code (v_org_id NUMBER,v_item_id NUMBER)
1035: IS

Line 1423: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 1691: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 2905: FROM gme_batch_step_items si, gme_batch_steps s

2901: IS
2902: --FPBug#4524232 Begin
2903: CURSOR Cur_get_step_status(v_material_detail_id NUMBER) IS
2904: SELECT steprelease_type,step_status
2905: FROM gme_batch_step_items si, gme_batch_steps s
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

Line 3266: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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
3268: ,p_trans_id IN NUMBER
3269: ,x_transacted OUT NOCOPY VARCHAR2
3270: ,x_return_status OUT NOCOPY VARCHAR2

Line 3301: l_batch_step_rec gme_batch_steps%ROWTYPE;

3297:
3298: l_mtl_dtl_rec gme_material_details%ROWTYPE;
3299: l_ph_mtl_dtl_rec gme_material_details%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;

Line 3303: l_ph_batch_step_rec gme_batch_steps%ROWTYPE;

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

Line 3306: x_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;
3309: l_plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE;
3310:

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

3562: SELECT batchstep_id INTO l_ph_batch_step_rec.batchstep_id
3563: FROM gme_batch_step_items
3564: WHERE batch_id = l_mtl_dtl_rec.phantom_id
3565: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3566: IF NOT gme_batch_steps_dbl.fetch_row(l_ph_batch_step_rec, l_ph_batch_step_rec) THEN
3567: l_proc := 'gme_batch_steps_dbl.fetch_row';
3568: RAISE error_dbl;
3569: END IF;
3570: l_ph_batch_step_rec.plan_cmplt_date:=l_mtl_dtl_rec.material_requirement_date;

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

3563: FROM gme_batch_step_items
3564: WHERE batch_id = l_mtl_dtl_rec.phantom_id
3565: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3566: IF NOT gme_batch_steps_dbl.fetch_row(l_ph_batch_step_rec, l_ph_batch_step_rec) THEN
3567: l_proc := 'gme_batch_steps_dbl.fetch_row';
3568: RAISE error_dbl;
3569: END IF;
3570: l_ph_batch_step_rec.plan_cmplt_date:=l_mtl_dtl_rec.material_requirement_date;
3571: l_ph_batch_step_rec.plan_start_date:=NULL;

Line 3602: FROM gme_batch_steps

3598: gme_common_pvt.is_material_assoc_to_step
3599: (l_ph_mtl_dtl_rec.material_detail_id )) THEN
3600: SELECT plan_start_date
3601: INTO l_plan_cmplt_date
3602: FROM gme_batch_steps
3603: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id
3604: AND batchstep_id =
3605: (SELECT batchstep_id
3606: FROM gme_batch_step_items

Line 3883: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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
3885: ,x_return_status OUT NOCOPY VARCHAR2)
3886: IS
3887: l_item_rec mtl_system_items_b%ROWTYPE;

Line 4406: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 4605: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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)
4608: IS
4609:

Line 4612: l_batch_step_rec gme_batch_steps%ROWTYPE;

4608: IS
4609:
4610: l_message_count NUMBER;
4611: l_message_list VARCHAR2 (2000);
4612: l_batch_step_rec gme_batch_steps%ROWTYPE;
4613: l_rsc_count NUMBER;
4614: l_proc VARCHAR2(100);
4615:
4616: l_mmt_tbl gme_common_pvt.mtl_mat_tran_tbl;