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.GMD_COMMON_SCALE dependencies on FM_MATL_DTL

Line 1387: ( p_fm_matl_dtl_tab IN fm_matl_dtl_tab

1383: * Jeff Baird 15-Sep-2004 Bug #3890191 Added l_scale_out_tab.
1384: *
1385: **********************************************************************/
1386: PROCEDURE scale
1387: ( p_fm_matl_dtl_tab IN fm_matl_dtl_tab
1388: , p_orgn_id IN NUMBER
1389: , p_scale_factor IN NUMBER
1390: , p_primaries IN VARCHAR2
1391: , x_fm_matl_dtl_tab OUT NOCOPY fm_matl_dtl_tab

Line 1391: , x_fm_matl_dtl_tab OUT NOCOPY fm_matl_dtl_tab

1387: ( p_fm_matl_dtl_tab IN fm_matl_dtl_tab
1388: , p_orgn_id IN NUMBER
1389: , p_scale_factor IN NUMBER
1390: , p_primaries IN VARCHAR2
1391: , x_fm_matl_dtl_tab OUT NOCOPY fm_matl_dtl_tab
1392: , x_return_status OUT NOCOPY VARCHAR2
1393: )
1394: IS
1395: l_row_count NUMBER;

Line 1401: l_row_count := p_fm_matl_dtl_tab.count;

1397: l_scale_tab scale_tab;
1398: l_scale_out_tab scale_tab;
1399: -- Bug #3890191 (JKB) Added l_scale_out_tab above.
1400: BEGIN
1401: l_row_count := p_fm_matl_dtl_tab.count;
1402: FOR l_row_number IN 1 .. l_row_count
1403: LOOP
1404: -- NPD Conv. Use inventory_item_id and detail_uom instead of item_id and item_um
1405: l_scale_tab(l_row_number).inventory_item_id := p_fm_matl_dtl_tab(l_row_number).inventory_item_id;

Line 1405: l_scale_tab(l_row_number).inventory_item_id := p_fm_matl_dtl_tab(l_row_number).inventory_item_id;

1401: l_row_count := p_fm_matl_dtl_tab.count;
1402: FOR l_row_number IN 1 .. l_row_count
1403: LOOP
1404: -- NPD Conv. Use inventory_item_id and detail_uom instead of item_id and item_um
1405: l_scale_tab(l_row_number).inventory_item_id := p_fm_matl_dtl_tab(l_row_number).inventory_item_id;
1406: l_scale_tab(l_row_number).detail_uom := p_fm_matl_dtl_tab(l_row_number).detail_uom;
1407: l_scale_tab(l_row_number).qty := p_fm_matl_dtl_tab(l_row_number).qty;
1408: l_scale_tab(l_row_number).line_type := p_fm_matl_dtl_tab(l_row_number).line_type;
1409: l_scale_tab(l_row_number).line_no := p_fm_matl_dtl_tab(l_row_number).line_no;

Line 1406: l_scale_tab(l_row_number).detail_uom := p_fm_matl_dtl_tab(l_row_number).detail_uom;

1402: FOR l_row_number IN 1 .. l_row_count
1403: LOOP
1404: -- NPD Conv. Use inventory_item_id and detail_uom instead of item_id and item_um
1405: l_scale_tab(l_row_number).inventory_item_id := p_fm_matl_dtl_tab(l_row_number).inventory_item_id;
1406: l_scale_tab(l_row_number).detail_uom := p_fm_matl_dtl_tab(l_row_number).detail_uom;
1407: l_scale_tab(l_row_number).qty := p_fm_matl_dtl_tab(l_row_number).qty;
1408: l_scale_tab(l_row_number).line_type := p_fm_matl_dtl_tab(l_row_number).line_type;
1409: l_scale_tab(l_row_number).line_no := p_fm_matl_dtl_tab(l_row_number).line_no;
1410: l_scale_tab(l_row_number).scale_type := p_fm_matl_dtl_tab(l_row_number).scale_type;

Line 1407: l_scale_tab(l_row_number).qty := p_fm_matl_dtl_tab(l_row_number).qty;

1403: LOOP
1404: -- NPD Conv. Use inventory_item_id and detail_uom instead of item_id and item_um
1405: l_scale_tab(l_row_number).inventory_item_id := p_fm_matl_dtl_tab(l_row_number).inventory_item_id;
1406: l_scale_tab(l_row_number).detail_uom := p_fm_matl_dtl_tab(l_row_number).detail_uom;
1407: l_scale_tab(l_row_number).qty := p_fm_matl_dtl_tab(l_row_number).qty;
1408: l_scale_tab(l_row_number).line_type := p_fm_matl_dtl_tab(l_row_number).line_type;
1409: l_scale_tab(l_row_number).line_no := p_fm_matl_dtl_tab(l_row_number).line_no;
1410: l_scale_tab(l_row_number).scale_type := p_fm_matl_dtl_tab(l_row_number).scale_type;
1411: l_scale_tab(l_row_number).scale_rounding_variance := p_fm_matl_dtl_tab(l_row_number).scale_rounding_variance;

Line 1408: l_scale_tab(l_row_number).line_type := p_fm_matl_dtl_tab(l_row_number).line_type;

1404: -- NPD Conv. Use inventory_item_id and detail_uom instead of item_id and item_um
1405: l_scale_tab(l_row_number).inventory_item_id := p_fm_matl_dtl_tab(l_row_number).inventory_item_id;
1406: l_scale_tab(l_row_number).detail_uom := p_fm_matl_dtl_tab(l_row_number).detail_uom;
1407: l_scale_tab(l_row_number).qty := p_fm_matl_dtl_tab(l_row_number).qty;
1408: l_scale_tab(l_row_number).line_type := p_fm_matl_dtl_tab(l_row_number).line_type;
1409: l_scale_tab(l_row_number).line_no := p_fm_matl_dtl_tab(l_row_number).line_no;
1410: l_scale_tab(l_row_number).scale_type := p_fm_matl_dtl_tab(l_row_number).scale_type;
1411: l_scale_tab(l_row_number).scale_rounding_variance := p_fm_matl_dtl_tab(l_row_number).scale_rounding_variance;
1412: l_scale_tab(l_row_number).scale_multiple := p_fm_matl_dtl_tab(l_row_number).scale_multiple;

Line 1409: l_scale_tab(l_row_number).line_no := p_fm_matl_dtl_tab(l_row_number).line_no;

1405: l_scale_tab(l_row_number).inventory_item_id := p_fm_matl_dtl_tab(l_row_number).inventory_item_id;
1406: l_scale_tab(l_row_number).detail_uom := p_fm_matl_dtl_tab(l_row_number).detail_uom;
1407: l_scale_tab(l_row_number).qty := p_fm_matl_dtl_tab(l_row_number).qty;
1408: l_scale_tab(l_row_number).line_type := p_fm_matl_dtl_tab(l_row_number).line_type;
1409: l_scale_tab(l_row_number).line_no := p_fm_matl_dtl_tab(l_row_number).line_no;
1410: l_scale_tab(l_row_number).scale_type := p_fm_matl_dtl_tab(l_row_number).scale_type;
1411: l_scale_tab(l_row_number).scale_rounding_variance := p_fm_matl_dtl_tab(l_row_number).scale_rounding_variance;
1412: l_scale_tab(l_row_number).scale_multiple := p_fm_matl_dtl_tab(l_row_number).scale_multiple;
1413: l_scale_tab(l_row_number).contribute_yield_ind := p_fm_matl_dtl_tab(l_row_number).contribute_yield_ind;

Line 1410: l_scale_tab(l_row_number).scale_type := p_fm_matl_dtl_tab(l_row_number).scale_type;

1406: l_scale_tab(l_row_number).detail_uom := p_fm_matl_dtl_tab(l_row_number).detail_uom;
1407: l_scale_tab(l_row_number).qty := p_fm_matl_dtl_tab(l_row_number).qty;
1408: l_scale_tab(l_row_number).line_type := p_fm_matl_dtl_tab(l_row_number).line_type;
1409: l_scale_tab(l_row_number).line_no := p_fm_matl_dtl_tab(l_row_number).line_no;
1410: l_scale_tab(l_row_number).scale_type := p_fm_matl_dtl_tab(l_row_number).scale_type;
1411: l_scale_tab(l_row_number).scale_rounding_variance := p_fm_matl_dtl_tab(l_row_number).scale_rounding_variance;
1412: l_scale_tab(l_row_number).scale_multiple := p_fm_matl_dtl_tab(l_row_number).scale_multiple;
1413: l_scale_tab(l_row_number).contribute_yield_ind := p_fm_matl_dtl_tab(l_row_number).contribute_yield_ind;
1414: END LOOP;

Line 1411: l_scale_tab(l_row_number).scale_rounding_variance := p_fm_matl_dtl_tab(l_row_number).scale_rounding_variance;

1407: l_scale_tab(l_row_number).qty := p_fm_matl_dtl_tab(l_row_number).qty;
1408: l_scale_tab(l_row_number).line_type := p_fm_matl_dtl_tab(l_row_number).line_type;
1409: l_scale_tab(l_row_number).line_no := p_fm_matl_dtl_tab(l_row_number).line_no;
1410: l_scale_tab(l_row_number).scale_type := p_fm_matl_dtl_tab(l_row_number).scale_type;
1411: l_scale_tab(l_row_number).scale_rounding_variance := p_fm_matl_dtl_tab(l_row_number).scale_rounding_variance;
1412: l_scale_tab(l_row_number).scale_multiple := p_fm_matl_dtl_tab(l_row_number).scale_multiple;
1413: l_scale_tab(l_row_number).contribute_yield_ind := p_fm_matl_dtl_tab(l_row_number).contribute_yield_ind;
1414: END LOOP;
1415: scale( l_scale_tab

Line 1412: l_scale_tab(l_row_number).scale_multiple := p_fm_matl_dtl_tab(l_row_number).scale_multiple;

1408: l_scale_tab(l_row_number).line_type := p_fm_matl_dtl_tab(l_row_number).line_type;
1409: l_scale_tab(l_row_number).line_no := p_fm_matl_dtl_tab(l_row_number).line_no;
1410: l_scale_tab(l_row_number).scale_type := p_fm_matl_dtl_tab(l_row_number).scale_type;
1411: l_scale_tab(l_row_number).scale_rounding_variance := p_fm_matl_dtl_tab(l_row_number).scale_rounding_variance;
1412: l_scale_tab(l_row_number).scale_multiple := p_fm_matl_dtl_tab(l_row_number).scale_multiple;
1413: l_scale_tab(l_row_number).contribute_yield_ind := p_fm_matl_dtl_tab(l_row_number).contribute_yield_ind;
1414: END LOOP;
1415: scale( l_scale_tab
1416: , p_orgn_id -- NPD Conv.

Line 1413: l_scale_tab(l_row_number).contribute_yield_ind := p_fm_matl_dtl_tab(l_row_number).contribute_yield_ind;

1409: l_scale_tab(l_row_number).line_no := p_fm_matl_dtl_tab(l_row_number).line_no;
1410: l_scale_tab(l_row_number).scale_type := p_fm_matl_dtl_tab(l_row_number).scale_type;
1411: l_scale_tab(l_row_number).scale_rounding_variance := p_fm_matl_dtl_tab(l_row_number).scale_rounding_variance;
1412: l_scale_tab(l_row_number).scale_multiple := p_fm_matl_dtl_tab(l_row_number).scale_multiple;
1413: l_scale_tab(l_row_number).contribute_yield_ind := p_fm_matl_dtl_tab(l_row_number).contribute_yield_ind;
1414: END LOOP;
1415: scale( l_scale_tab
1416: , p_orgn_id -- NPD Conv.
1417: , p_scale_factor

Line 1425: x_fm_matl_dtl_tab := p_fm_matl_dtl_tab;

1421: );
1422: -- Bug #3890191 (JKB) Added l_scale_out_tab above.
1423: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1424: THEN
1425: x_fm_matl_dtl_tab := p_fm_matl_dtl_tab;
1426: FOR l_row_number in 1 .. l_row_count
1427: LOOP
1428: x_fm_matl_dtl_tab(l_row_number).qty := l_scale_out_tab(l_row_number).qty;
1429: -- Bug #3890191 (JKB) Added l_scale_out_tab above.

Line 1428: x_fm_matl_dtl_tab(l_row_number).qty := l_scale_out_tab(l_row_number).qty;

1424: THEN
1425: x_fm_matl_dtl_tab := p_fm_matl_dtl_tab;
1426: FOR l_row_number in 1 .. l_row_count
1427: LOOP
1428: x_fm_matl_dtl_tab(l_row_number).qty := l_scale_out_tab(l_row_number).qty;
1429: -- Bug #3890191 (JKB) Added l_scale_out_tab above.
1430: END LOOP;
1431: END IF;
1432: END scale;