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 186: TYPE material_details_tab IS TABLE OF gme_material_details%ROWTYPE

182:
183: TYPE batch_headers_tab IS TABLE OF gme_batch_header%ROWTYPE
184: INDEX BY BINARY_INTEGER;
185:
186: TYPE material_details_tab IS TABLE OF gme_material_details%ROWTYPE
187: INDEX BY BINARY_INTEGER;
188:
189: TYPE steps_tab IS TABLE OF gme_batch_steps%ROWTYPE
190: INDEX BY BINARY_INTEGER;

Line 318: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

314: PROCEDURE construct_material_detail (
315: p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
316: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE
317: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
318: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
319: ,x_return_status OUT NOCOPY VARCHAR2);
320:
321: FUNCTION get_process_loss (
322: p_batch_id IN NUMBER DEFAULT NULL

Line 348: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE

344: p_batch_header_rec IN gme_batch_header%ROWTYPE
345: DEFAULT NULL
346: ,p_batchstep_rec IN gme_batch_steps%ROWTYPE
347: DEFAULT NULL
348: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE
349: ,x_mtl_req_date OUT NOCOPY DATE
350: ,x_return_status OUT NOCOPY VARCHAR2);
351:
352: FUNCTION is_qty_below_capacity (

Line 412: p_mtl_dtl_rec IN gme_material_details%ROWTYPE

408: ,x_return_status OUT NOCOPY VARCHAR2
409: ,x_exception_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
410:
411: PROCEDURE get_open_qty (
412: p_mtl_dtl_rec IN gme_material_details%ROWTYPE
413: ,p_called_by IN VARCHAR2
414: , /* P- picking, R-reservation, S-shortages */
415: p_item_location_control IN NUMBER DEFAULT NULL
416: ,p_item_restrict_locators IN NUMBER DEFAULT NULL

Line 428: p_material_detail_id IN gme_material_details.material_detail_id%TYPE)

424: p_exception_tbl IN gme_common_pvt.exceptions_tab)
425: RETURN BOOLEAN;
426:
427: FUNCTION is_material_assoc_to_step (
428: p_material_detail_id IN gme_material_details.material_detail_id%TYPE)
429: RETURN BOOLEAN;
430:
431: FUNCTION get_batch_header (
432: p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 494: p_line_id IN gme_material_details.material_detail_id%TYPE)

490: ,p_material_date IN DATE
491: ,x_return_status OUT NOCOPY VARCHAR2);
492:
493: FUNCTION is_material_auto_release (
494: p_line_id IN gme_material_details.material_detail_id%TYPE)
495: RETURN NUMBER;
496:
497: FUNCTION get_assoc_step (
498: p_material_detail_id IN gme_material_details.material_detail_id%TYPE

Line 498: p_material_detail_id IN gme_material_details.material_detail_id%TYPE

494: p_line_id IN gme_material_details.material_detail_id%TYPE)
495: RETURN NUMBER;
496:
497: FUNCTION get_assoc_step (
498: p_material_detail_id IN gme_material_details.material_detail_id%TYPE
499: ,x_batchstep_id OUT NOCOPY NUMBER
500: ,x_batchstep_status OUT NOCOPY NUMBER)
501: RETURN BOOLEAN;
502:

Line 504: p_material_detail_rec IN gme_material_details%ROWTYPE

500: ,x_batchstep_status OUT NOCOPY NUMBER)
501: RETURN BOOLEAN;
502:
503: FUNCTION get_material_detail (
504: p_material_detail_rec IN gme_material_details%ROWTYPE
505: ,p_org_code IN VARCHAR2
506: ,p_batch_no IN VARCHAR2
507: ,p_batch_type IN NUMBER
508: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 509: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

505: ,p_org_code IN VARCHAR2
506: ,p_batch_no IN VARCHAR2
507: ,p_batch_type IN NUMBER
508: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
509: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
510: RETURN BOOLEAN;
511: -- Pawan Kumar Added for bug 5138929
512: FUNCTION check_close_period (
513: p_org_id IN NUMBER

Line 526: p_material_detail_rec IN gme_material_details%ROWTYPE

522: ,x_message_list OUT NOCOPY VARCHAR2
523: ,x_return_status OUT NOCOPY VARCHAR2);
524:
525: Procedure Validate_material_detail (
526: p_material_detail_rec IN gme_material_details%ROWTYPE
527: ,p_org_code IN VARCHAR2
528: ,p_batch_no IN VARCHAR2
529: ,p_batch_type IN NUMBER
530: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 531: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

527: ,p_org_code IN VARCHAR2
528: ,p_batch_no IN VARCHAR2
529: ,p_batch_type IN NUMBER
530: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
531: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
532: ,x_message_count OUT NOCOPY NUMBER
533: ,x_message_list OUT NOCOPY VARCHAR2
534: ,x_return_status OUT NOCOPY VARCHAR2);
535: Procedure Validate_batch_step (