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

Line 197: TYPE material_details_tab IS TABLE OF gme_material_details%ROWTYPE

193:
194: TYPE batch_headers_tab IS TABLE OF gme_batch_header%ROWTYPE
195: INDEX BY BINARY_INTEGER;
196:
197: TYPE material_details_tab IS TABLE OF gme_material_details%ROWTYPE
198: INDEX BY BINARY_INTEGER;
199:
200: TYPE steps_tab IS TABLE OF gme_batch_steps%ROWTYPE
201: INDEX BY BINARY_INTEGER;

Line 330: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

326: PROCEDURE construct_material_detail (
327: p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
328: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE
329: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
330: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
331: ,x_return_status OUT NOCOPY VARCHAR2);
332:
333: FUNCTION get_process_loss (
334: p_batch_id IN NUMBER DEFAULT NULL

Line 360: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE

356: p_batch_header_rec IN gme_batch_header%ROWTYPE
357: DEFAULT NULL
358: ,p_batchstep_rec IN gme_batch_steps%ROWTYPE
359: DEFAULT NULL
360: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE
361: ,x_mtl_req_date OUT NOCOPY DATE
362: ,x_return_status OUT NOCOPY VARCHAR2);
363:
364: FUNCTION is_qty_below_capacity (

Line 424: p_mtl_dtl_rec IN gme_material_details%ROWTYPE

420: ,x_return_status OUT NOCOPY VARCHAR2
421: ,x_exception_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
422:
423: PROCEDURE get_open_qty (
424: p_mtl_dtl_rec IN gme_material_details%ROWTYPE
425: ,p_called_by IN VARCHAR2
426: , /* P- picking, R-reservation, S-shortages */
427: p_item_location_control IN NUMBER DEFAULT NULL
428: ,p_item_restrict_locators IN NUMBER DEFAULT NULL

Line 440: p_material_detail_id IN gme_material_details.material_detail_id%TYPE)

436: p_exception_tbl IN gme_common_pvt.exceptions_tab)
437: RETURN BOOLEAN;
438:
439: FUNCTION is_material_assoc_to_step (
440: p_material_detail_id IN gme_material_details.material_detail_id%TYPE)
441: RETURN BOOLEAN;
442:
443: FUNCTION get_batch_header (
444: p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 506: p_line_id IN gme_material_details.material_detail_id%TYPE)

502: ,p_material_date IN DATE
503: ,x_return_status OUT NOCOPY VARCHAR2);
504:
505: FUNCTION is_material_auto_release (
506: p_line_id IN gme_material_details.material_detail_id%TYPE)
507: RETURN NUMBER;
508:
509: FUNCTION get_assoc_step (
510: p_material_detail_id IN gme_material_details.material_detail_id%TYPE

Line 510: p_material_detail_id IN gme_material_details.material_detail_id%TYPE

506: p_line_id IN gme_material_details.material_detail_id%TYPE)
507: RETURN NUMBER;
508:
509: FUNCTION get_assoc_step (
510: p_material_detail_id IN gme_material_details.material_detail_id%TYPE
511: ,x_batchstep_id OUT NOCOPY NUMBER
512: ,x_batchstep_status OUT NOCOPY NUMBER)
513: RETURN BOOLEAN;
514:

Line 516: p_material_detail_rec IN gme_material_details%ROWTYPE

512: ,x_batchstep_status OUT NOCOPY NUMBER)
513: RETURN BOOLEAN;
514:
515: FUNCTION get_material_detail (
516: p_material_detail_rec IN gme_material_details%ROWTYPE
517: ,p_org_code IN VARCHAR2
518: ,p_batch_no IN VARCHAR2
519: ,p_batch_type IN NUMBER
520: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 521: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

517: ,p_org_code IN VARCHAR2
518: ,p_batch_no IN VARCHAR2
519: ,p_batch_type IN NUMBER
520: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
521: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
522: RETURN BOOLEAN;
523: -- Pawan Kumar Added for bug 5138929
524: FUNCTION check_close_period (
525: p_org_id IN NUMBER

Line 541: p_material_detail_rec IN gme_material_details%ROWTYPE

537: ,x_message_list OUT NOCOPY VARCHAR2
538: ,x_return_status OUT NOCOPY VARCHAR2);
539:
540: Procedure Validate_material_detail (
541: p_material_detail_rec IN gme_material_details%ROWTYPE
542: ,p_org_code IN VARCHAR2
543: ,p_batch_no IN VARCHAR2
544: ,p_batch_type IN NUMBER
545: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 546: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

542: ,p_org_code IN VARCHAR2
543: ,p_batch_no IN VARCHAR2
544: ,p_batch_type IN NUMBER
545: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
546: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
547: ,x_message_count OUT NOCOPY NUMBER
548: ,x_message_list OUT NOCOPY VARCHAR2
549: ,x_return_status OUT NOCOPY VARCHAR2);
550: Procedure Validate_batch_step (