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 145: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 148: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

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

Line 442: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 446: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

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

Line 608: ,p_material_detail_rec IN gme_material_details%ROWTYPE

604: ,x_message_count OUT NOCOPY NUMBER
605: ,x_message_list OUT NOCOPY VARCHAR2
606: ,x_return_status OUT NOCOPY VARCHAR2
607: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
608: ,p_material_detail_rec IN gme_material_details%ROWTYPE
609: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
610: ,p_trans_id IN NUMBER
611: ,x_transacted OUT NOCOPY VARCHAR2
612: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

Line 612: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

608: ,p_material_detail_rec IN gme_material_details%ROWTYPE
609: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
610: ,p_trans_id IN NUMBER
611: ,x_transacted OUT NOCOPY VARCHAR2
612: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
613: IS
614: l_api_name CONSTANT VARCHAR2 (30) := 'insert_material_line';
615: setup_failure EXCEPTION;
616: ins_mtl_line_failure EXCEPTION;

Line 726: ,p_material_detail_rec IN gme_material_details%ROWTYPE

722: ,x_message_count OUT NOCOPY NUMBER
723: ,x_message_list OUT NOCOPY VARCHAR2
724: ,x_return_status OUT NOCOPY VARCHAR2
725: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
726: ,p_material_detail_rec IN gme_material_details%ROWTYPE
727: ,p_batch_step_id IN NUMBER := NULL
728: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
729: ,p_trans_id IN NUMBER
730: ,x_transacted OUT NOCOPY VARCHAR2

Line 731: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

727: ,p_batch_step_id IN NUMBER := NULL
728: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
729: ,p_trans_id IN NUMBER
730: ,x_transacted OUT NOCOPY VARCHAR2
731: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
732: IS
733: l_api_name CONSTANT VARCHAR2 (30) := 'update_material_line_form';
734:
735: l_stored_material_detail_rec gme_material_details%ROWTYPE;

Line 735: l_stored_material_detail_rec gme_material_details%ROWTYPE;

731: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
732: IS
733: l_api_name CONSTANT VARCHAR2 (30) := 'update_material_line_form';
734:
735: l_stored_material_detail_rec gme_material_details%ROWTYPE;
736: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
737: l_batch_step_rec gme_batch_steps%ROWTYPE;
738: upd_mtl_line_failure EXCEPTION;
739: setup_failure EXCEPTION;

Line 784: IF NOT gme_material_details_dbl.fetch_row

780: END IF;
781:
782: l_stored_material_detail_rec.material_detail_id := p_material_detail_rec.material_detail_id;
783:
784: IF NOT gme_material_details_dbl.fetch_row
785: (l_stored_material_detail_rec,l_stored_material_detail_rec) THEN
786: RAISE fnd_api.g_exc_error;
787: END IF;
788:

Line 884: ,p_material_detail_rec IN gme_material_details%ROWTYPE

880: ,x_message_count OUT NOCOPY NUMBER
881: ,x_message_list OUT NOCOPY VARCHAR2
882: ,x_return_status OUT NOCOPY VARCHAR2
883: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
884: ,p_material_detail_rec IN gme_material_details%ROWTYPE
885: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
886: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
887: ,p_scale_phantom IN VARCHAR2
888: := fnd_api.g_false

Line 885: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE

881: ,x_message_list OUT NOCOPY VARCHAR2
882: ,x_return_status OUT NOCOPY VARCHAR2
883: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
884: ,p_material_detail_rec IN gme_material_details%ROWTYPE
885: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
886: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
887: ,p_scale_phantom IN VARCHAR2
888: := fnd_api.g_false
889: ,p_trans_id IN NUMBER

Line 891: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

887: ,p_scale_phantom IN VARCHAR2
888: := fnd_api.g_false
889: ,p_trans_id IN NUMBER
890: ,x_transacted OUT NOCOPY VARCHAR2
891: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
892: IS
893: l_api_name CONSTANT VARCHAR2 (30) := 'update_material_line';
894: upd_mtl_line_failure EXCEPTION;
895: setup_failure EXCEPTION;

Line 1004: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1000: ,x_message_count OUT NOCOPY NUMBER
1001: ,x_message_list OUT NOCOPY VARCHAR2
1002: ,x_return_status OUT NOCOPY VARCHAR2
1003: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1004: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1005: ,p_batch_step_id IN NUMBER := NULL
1006: ,x_transacted OUT NOCOPY VARCHAR2)
1007: IS
1008: l_api_name CONSTANT VARCHAR2 (30) := 'delete_material_line_form';

Line 1169: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1165: ,x_message_count OUT NOCOPY NUMBER
1166: ,x_message_list OUT NOCOPY VARCHAR2
1167: ,x_return_status OUT NOCOPY VARCHAR2
1168: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1169: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1170: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1171: ,x_transacted OUT NOCOPY VARCHAR2)
1172: IS
1173: l_api_name CONSTANT VARCHAR2 (30) := 'delete_material_line';

Line 1592: ,p_matl_dtl_rec IN gme_material_details%ROWTYPE

1588: END create_batch_reservations;
1589:
1590: PROCEDURE create_line_reservations (
1591: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1592: ,p_matl_dtl_rec IN gme_material_details%ROWTYPE
1593: ,x_message_count OUT NOCOPY NUMBER
1594: ,x_message_list OUT NOCOPY VARCHAR2
1595: ,x_return_status OUT NOCOPY VARCHAR2)
1596: IS

Line 3213: ,p_material_detail_rec IN gme_material_details%ROWTYPE

3209: ,x_message_count OUT NOCOPY NUMBER
3210: ,x_message_list OUT NOCOPY VARCHAR2
3211: ,x_return_status OUT NOCOPY VARCHAR2
3212: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3213: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3214: ,p_qty IN NUMBER
3215: ,p_qty_type IN NUMBER
3216: ,p_trans_date IN DATE
3217: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab )

Line 4028: ,p_material_detail_rec IN gme_material_details%ROWTYPE)

4024: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
4025: ,x_message_count OUT NOCOPY NUMBER
4026: ,x_message_list OUT NOCOPY VARCHAR2
4027: ,x_return_status OUT NOCOPY VARCHAR2
4028: ,p_material_detail_rec IN gme_material_details%ROWTYPE)
4029: IS
4030: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_LINE';
4031: setup_failure EXCEPTION;
4032: auto_detail_failure EXCEPTION;