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_FORMULA_DETAIL_PVT dependencies on FM_MATL_DTL

Line 39: ,p_formula_detail_rec IN fm_matl_dtl%ROWTYPE

35: ,p_commit IN VARCHAR2
36: ,x_return_status OUT NOCOPY VARCHAR2
37: ,x_msg_count OUT NOCOPY NUMBER
38: ,x_msg_data OUT NOCOPY VARCHAR2
39: ,p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
40: )
41: IS
42: /* Local Variables definitions */
43: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_FORMULADETAIL';

Line 86: INSERT INTO fm_matl_dtl

82: gmd_debug.put_line(' In formula detail Pvt - About to insert formulaline id = '
83: ||p_formula_detail_rec.formulaline_id);
84: END IF;
85:
86: INSERT INTO fm_matl_dtl
87: (formulaline_id,
88: formula_id,
89: line_type,
90: line_no,

Line 274: ,p_formula_detail_rec IN fm_matl_dtl%ROWTYPE

270: ,p_commit IN VARCHAR2
271: ,x_return_status OUT NOCOPY VARCHAR2
272: ,x_msg_count OUT NOCOPY NUMBER
273: ,x_msg_data OUT NOCOPY VARCHAR2
274: ,p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
275: )
276: IS
277:
278: /* Local Variables definitions */

Line 281: l_line_no fm_matl_dtl.line_no%TYPE;

277:
278: /* Local Variables definitions */
279: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULADETAIL';
280: l_api_version CONSTANT NUMBER := 1.0;
281: l_line_no fm_matl_dtl.line_no%TYPE;
282: l_line_type fm_matl_dtl.line_type%TYPE;
283: l_qty fm_matl_dtl.qty%TYPE;
284: l_item_um fm_matl_dtl.detail_uom%TYPE;
285: l_release_type fm_matl_dtl.release_type%TYPE;

Line 282: l_line_type fm_matl_dtl.line_type%TYPE;

278: /* Local Variables definitions */
279: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULADETAIL';
280: l_api_version CONSTANT NUMBER := 1.0;
281: l_line_no fm_matl_dtl.line_no%TYPE;
282: l_line_type fm_matl_dtl.line_type%TYPE;
283: l_qty fm_matl_dtl.qty%TYPE;
284: l_item_um fm_matl_dtl.detail_uom%TYPE;
285: l_release_type fm_matl_dtl.release_type%TYPE;
286: l_scrap_factor fm_matl_dtl.scrap_factor%TYPE;

Line 283: l_qty fm_matl_dtl.qty%TYPE;

279: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULADETAIL';
280: l_api_version CONSTANT NUMBER := 1.0;
281: l_line_no fm_matl_dtl.line_no%TYPE;
282: l_line_type fm_matl_dtl.line_type%TYPE;
283: l_qty fm_matl_dtl.qty%TYPE;
284: l_item_um fm_matl_dtl.detail_uom%TYPE;
285: l_release_type fm_matl_dtl.release_type%TYPE;
286: l_scrap_factor fm_matl_dtl.scrap_factor%TYPE;
287: l_scale_type fm_matl_dtl.scale_type%TYPE;

Line 284: l_item_um fm_matl_dtl.detail_uom%TYPE;

280: l_api_version CONSTANT NUMBER := 1.0;
281: l_line_no fm_matl_dtl.line_no%TYPE;
282: l_line_type fm_matl_dtl.line_type%TYPE;
283: l_qty fm_matl_dtl.qty%TYPE;
284: l_item_um fm_matl_dtl.detail_uom%TYPE;
285: l_release_type fm_matl_dtl.release_type%TYPE;
286: l_scrap_factor fm_matl_dtl.scrap_factor%TYPE;
287: l_scale_type fm_matl_dtl.scale_type%TYPE;
288: l_phantom_type fm_matl_dtl.phantom_type%TYPE;

Line 285: l_release_type fm_matl_dtl.release_type%TYPE;

281: l_line_no fm_matl_dtl.line_no%TYPE;
282: l_line_type fm_matl_dtl.line_type%TYPE;
283: l_qty fm_matl_dtl.qty%TYPE;
284: l_item_um fm_matl_dtl.detail_uom%TYPE;
285: l_release_type fm_matl_dtl.release_type%TYPE;
286: l_scrap_factor fm_matl_dtl.scrap_factor%TYPE;
287: l_scale_type fm_matl_dtl.scale_type%TYPE;
288: l_phantom_type fm_matl_dtl.phantom_type%TYPE;
289: X_msg_cnt NUMBER;

Line 286: l_scrap_factor fm_matl_dtl.scrap_factor%TYPE;

282: l_line_type fm_matl_dtl.line_type%TYPE;
283: l_qty fm_matl_dtl.qty%TYPE;
284: l_item_um fm_matl_dtl.detail_uom%TYPE;
285: l_release_type fm_matl_dtl.release_type%TYPE;
286: l_scrap_factor fm_matl_dtl.scrap_factor%TYPE;
287: l_scale_type fm_matl_dtl.scale_type%TYPE;
288: l_phantom_type fm_matl_dtl.phantom_type%TYPE;
289: X_msg_cnt NUMBER;
290: X_msg_dat VARCHAR2(100);

Line 287: l_scale_type fm_matl_dtl.scale_type%TYPE;

283: l_qty fm_matl_dtl.qty%TYPE;
284: l_item_um fm_matl_dtl.detail_uom%TYPE;
285: l_release_type fm_matl_dtl.release_type%TYPE;
286: l_scrap_factor fm_matl_dtl.scrap_factor%TYPE;
287: l_scale_type fm_matl_dtl.scale_type%TYPE;
288: l_phantom_type fm_matl_dtl.phantom_type%TYPE;
289: X_msg_cnt NUMBER;
290: X_msg_dat VARCHAR2(100);
291: X_status VARCHAR2(1);

Line 288: l_phantom_type fm_matl_dtl.phantom_type%TYPE;

284: l_item_um fm_matl_dtl.detail_uom%TYPE;
285: l_release_type fm_matl_dtl.release_type%TYPE;
286: l_scrap_factor fm_matl_dtl.scrap_factor%TYPE;
287: l_scale_type fm_matl_dtl.scale_type%TYPE;
288: l_phantom_type fm_matl_dtl.phantom_type%TYPE;
289: X_msg_cnt NUMBER;
290: X_msg_dat VARCHAR2(100);
291: X_status VARCHAR2(1);
292: l_product_qty NUMBER;

Line 336: ||' Before the update of fm_matl_dtl '

332: /* Later on to be changed to update a business view */
333: /* and not a table. */
334: IF (l_debug = 'Y') THEN
335: gmd_debug.put_line(' In Formula Detail PVT - '
336: ||' Before the update of fm_matl_dtl '
337: ||' formulaline id - '
338: ||p_formula_detail_rec.formulaline_id
339: ||' line no '
340: ||p_formula_detail_rec.line_no

Line 352: UPDATE fm_matl_dtl SET

348:
349: --bug16664160 fix start.
350: if (p_formula_detail_rec.inventory_item_id is null) then
351:
352: UPDATE fm_matl_dtl SET
353: line_no = p_formula_detail_rec.line_no,
354: line_type = p_formula_detail_rec.line_type,
355: qty = p_formula_detail_rec.qty,
356: organization_id = l_org_id,

Line 416: UPDATE fm_matl_dtl SET

412: prod_percent = p_formula_detail_rec.prod_percent
413: WHERE
414: formulaline_id = p_formula_detail_rec.formulaline_id;
415: else
416: UPDATE fm_matl_dtl SET
417: line_no = p_formula_detail_rec.line_no,
418: line_type = p_formula_detail_rec.line_type,
419: qty = p_formula_detail_rec.qty,
420: organization_id = l_org_id,

Line 572: p_formula_detail_rec IN fm_matl_dtl%ROWTYPE

568: p_commit IN VARCHAR2 ,
569: x_return_status OUT NOCOPY VARCHAR2 ,
570: x_msg_count OUT NOCOPY NUMBER ,
571: x_msg_data OUT NOCOPY VARCHAR2 ,
572: p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
573: )
574: IS
575:
576: /* Local Variables definitions */

Line 611: DELETE FROM fm_matl_dtl

607: /* API body */
608: /* Later on to be changed to update a business view */
609: /* and not a table. */
610:
611: DELETE FROM fm_matl_dtl
612: WHERE
613: formulaline_id = p_formula_detail_rec.formulaline_id;
614:
615: IF(SQL%ROWCOUNT = 0) THEN