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_API_MAIN dependencies on GME_MATERIAL_DETAILS

Line 147: ,p_material_detail_rec IN gme_material_details%ROWTYPE

143: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
144: ,x_message_count OUT NOCOPY NUMBER
145: ,x_message_list OUT NOCOPY VARCHAR2
146: ,x_return_status OUT NOCOPY VARCHAR2
147: ,p_material_detail_rec IN gme_material_details%ROWTYPE
148: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476
149: ,p_batch_no IN VARCHAR2 DEFAULT NULL
150: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
151: ,p_validity_rule_id IN NUMBER

Line 150: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

146: ,x_return_status OUT NOCOPY VARCHAR2
147: ,p_material_detail_rec IN gme_material_details%ROWTYPE
148: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476
149: ,p_batch_no IN VARCHAR2 DEFAULT NULL
150: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
151: ,p_validity_rule_id IN NUMBER
152: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
153: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
154: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false

Line 444: ,p_material_detail_rec IN gme_material_details%ROWTYPE

440: ,x_message_count OUT NOCOPY NUMBER
441: ,x_message_list OUT NOCOPY VARCHAR2
442: ,x_return_status OUT NOCOPY VARCHAR2
443: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
444: ,p_material_detail_rec IN gme_material_details%ROWTYPE
445: ,p_batch_step_id IN NUMBER := NULL
446: ,p_trans_id IN NUMBER
447: ,x_transacted OUT NOCOPY VARCHAR2
448: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

Line 448: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

444: ,p_material_detail_rec IN gme_material_details%ROWTYPE
445: ,p_batch_step_id IN NUMBER := NULL
446: ,p_trans_id IN NUMBER
447: ,x_transacted OUT NOCOPY VARCHAR2
448: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
449: IS
450: l_api_name CONSTANT VARCHAR2 (30) := 'insert_material_line_form';
451:
452: l_batch_step_rec gme_batch_steps%ROWTYPE;

Line 622: ,p_material_detail_rec IN gme_material_details%ROWTYPE

618: ,x_message_count OUT NOCOPY NUMBER
619: ,x_message_list OUT NOCOPY VARCHAR2
620: ,x_return_status OUT NOCOPY VARCHAR2
621: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
622: ,p_material_detail_rec IN gme_material_details%ROWTYPE
623: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
624: ,p_trans_id IN NUMBER
625: ,x_transacted OUT NOCOPY VARCHAR2
626: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

Line 626: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

622: ,p_material_detail_rec IN gme_material_details%ROWTYPE
623: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
624: ,p_trans_id IN NUMBER
625: ,x_transacted OUT NOCOPY VARCHAR2
626: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
627: IS
628: l_api_name CONSTANT VARCHAR2 (30) := 'insert_material_line';
629: setup_failure EXCEPTION;
630: ins_mtl_line_failure EXCEPTION;

Line 740: ,p_material_detail_rec IN gme_material_details%ROWTYPE

736: ,x_message_count OUT NOCOPY NUMBER
737: ,x_message_list OUT NOCOPY VARCHAR2
738: ,x_return_status OUT NOCOPY VARCHAR2
739: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
740: ,p_material_detail_rec IN gme_material_details%ROWTYPE
741: ,p_batch_step_id IN NUMBER := NULL
742: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
743: ,p_trans_id IN NUMBER
744: ,x_transacted OUT NOCOPY VARCHAR2

Line 745: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

741: ,p_batch_step_id IN NUMBER := NULL
742: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
743: ,p_trans_id IN NUMBER
744: ,x_transacted OUT NOCOPY VARCHAR2
745: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
746: IS
747: l_api_name CONSTANT VARCHAR2 (30) := 'update_material_line_form';
748:
749: l_stored_material_detail_rec gme_material_details%ROWTYPE;

Line 749: l_stored_material_detail_rec gme_material_details%ROWTYPE;

745: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
746: IS
747: l_api_name CONSTANT VARCHAR2 (30) := 'update_material_line_form';
748:
749: l_stored_material_detail_rec gme_material_details%ROWTYPE;
750: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
751: l_batch_step_rec gme_batch_steps%ROWTYPE;
752: upd_mtl_line_failure EXCEPTION;
753: setup_failure EXCEPTION;

Line 803: IF NOT gme_material_details_dbl.fetch_row

799: END IF;
800:
801: l_stored_material_detail_rec.material_detail_id := p_material_detail_rec.material_detail_id;
802:
803: IF NOT gme_material_details_dbl.fetch_row
804: (l_stored_material_detail_rec,l_stored_material_detail_rec) THEN
805: RAISE fnd_api.g_exc_error;
806: END IF;
807:

Line 936: ,p_material_detail_rec IN gme_material_details%ROWTYPE

932: ,x_message_count OUT NOCOPY NUMBER
933: ,x_message_list OUT NOCOPY VARCHAR2
934: ,x_return_status OUT NOCOPY VARCHAR2
935: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
936: ,p_material_detail_rec IN gme_material_details%ROWTYPE
937: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
938: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
939: ,p_scale_phantom IN VARCHAR2
940: := fnd_api.g_false

Line 937: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE

933: ,x_message_list OUT NOCOPY VARCHAR2
934: ,x_return_status OUT NOCOPY VARCHAR2
935: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
936: ,p_material_detail_rec IN gme_material_details%ROWTYPE
937: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
938: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
939: ,p_scale_phantom IN VARCHAR2
940: := fnd_api.g_false
941: ,p_trans_id IN NUMBER

Line 943: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

939: ,p_scale_phantom IN VARCHAR2
940: := fnd_api.g_false
941: ,p_trans_id IN NUMBER
942: ,x_transacted OUT NOCOPY VARCHAR2
943: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
944: IS
945: l_api_name CONSTANT VARCHAR2 (30) := 'update_material_line';
946: upd_mtl_line_failure EXCEPTION;
947: setup_failure EXCEPTION;

Line 1056: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1052: ,x_message_count OUT NOCOPY NUMBER
1053: ,x_message_list OUT NOCOPY VARCHAR2
1054: ,x_return_status OUT NOCOPY VARCHAR2
1055: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1056: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1057: ,p_batch_step_id IN NUMBER := NULL
1058: ,p_bypass_gmf IN VARCHAR2 := 'N'
1059: ,x_transacted OUT NOCOPY VARCHAR2)
1060: IS

Line 1227: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1223: ,x_message_count OUT NOCOPY NUMBER
1224: ,x_message_list OUT NOCOPY VARCHAR2
1225: ,x_return_status OUT NOCOPY VARCHAR2
1226: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1227: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1228: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1229: ,x_transacted OUT NOCOPY VARCHAR2)
1230: IS
1231: l_api_name CONSTANT VARCHAR2 (30) := 'delete_material_line';

Line 1650: ,p_matl_dtl_rec IN gme_material_details%ROWTYPE

1646: END create_batch_reservations;
1647:
1648: PROCEDURE create_line_reservations (
1649: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1650: ,p_matl_dtl_rec IN gme_material_details%ROWTYPE
1651: ,x_message_count OUT NOCOPY NUMBER
1652: ,x_message_list OUT NOCOPY VARCHAR2
1653: ,x_return_status OUT NOCOPY VARCHAR2)
1654: IS

Line 3286: ,p_material_detail_rec IN gme_material_details%ROWTYPE

3282: ,x_message_count OUT NOCOPY NUMBER
3283: ,x_message_list OUT NOCOPY VARCHAR2
3284: ,x_return_status OUT NOCOPY VARCHAR2
3285: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3286: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3287: ,p_qty IN NUMBER
3288: ,p_qty_type IN NUMBER
3289: ,p_trans_date IN DATE
3290: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab )

Line 4128: ,p_material_detail_rec IN gme_material_details%ROWTYPE)

4124: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
4125: ,x_message_count OUT NOCOPY NUMBER
4126: ,x_message_list OUT NOCOPY VARCHAR2
4127: ,x_return_status OUT NOCOPY VARCHAR2
4128: ,p_material_detail_rec IN gme_material_details%ROWTYPE)
4129: IS
4130: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_LINE';
4131: setup_failure EXCEPTION;
4132: auto_detail_failure EXCEPTION;