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.GMI_ITEM_LOT_CONV_PUB dependencies on IC_ITEM_CNV

Line 83: l_ic_item_cnv_rec ic_item_cnv%ROWTYPE;

79: l_return_status VARCHAR2(1);
80: l_error_code NUMBER;
81: l_factor NUMBER;
82: l_type_factorrev NUMBER;
83: l_ic_item_cnv_rec ic_item_cnv%ROWTYPE;
84: l_ic_item_mst_rec ic_item_mst%ROWTYPE;
85: l_ic_lots_mst_rec ic_lots_mst%ROWTYPE;
86: l_item_cnv_rec item_cnv_rec_typ;
87: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;

Line 433: -- Set up PL/SQL record and insert item/lot conversion into IC_ITEM_CNV

429: -- Now calculate the inverse value of the conversion factor
430:
431: l_type_factorrev := 1 / l_factor;
432:
433: -- Set up PL/SQL record and insert item/lot conversion into IC_ITEM_CNV
434:
435: l_ic_item_cnv_rec.item_id := l_ic_item_mst_rec.item_id;
436: l_ic_item_cnv_rec.lot_id := l_ic_lots_mst_rec.lot_id;
437: l_ic_item_cnv_rec.um_type := l_um_type;

Line 435: l_ic_item_cnv_rec.item_id := l_ic_item_mst_rec.item_id;

431: l_type_factorrev := 1 / l_factor;
432:
433: -- Set up PL/SQL record and insert item/lot conversion into IC_ITEM_CNV
434:
435: l_ic_item_cnv_rec.item_id := l_ic_item_mst_rec.item_id;
436: l_ic_item_cnv_rec.lot_id := l_ic_lots_mst_rec.lot_id;
437: l_ic_item_cnv_rec.um_type := l_um_type;
438: l_ic_item_cnv_rec.type_factor := l_factor;
439: l_ic_item_cnv_rec.last_update_date := SYSDATE;

Line 436: l_ic_item_cnv_rec.lot_id := l_ic_lots_mst_rec.lot_id;

432:
433: -- Set up PL/SQL record and insert item/lot conversion into IC_ITEM_CNV
434:
435: l_ic_item_cnv_rec.item_id := l_ic_item_mst_rec.item_id;
436: l_ic_item_cnv_rec.lot_id := l_ic_lots_mst_rec.lot_id;
437: l_ic_item_cnv_rec.um_type := l_um_type;
438: l_ic_item_cnv_rec.type_factor := l_factor;
439: l_ic_item_cnv_rec.last_update_date := SYSDATE;
440: l_ic_item_cnv_rec.last_updated_by := l_user_id;

Line 437: l_ic_item_cnv_rec.um_type := l_um_type;

433: -- Set up PL/SQL record and insert item/lot conversion into IC_ITEM_CNV
434:
435: l_ic_item_cnv_rec.item_id := l_ic_item_mst_rec.item_id;
436: l_ic_item_cnv_rec.lot_id := l_ic_lots_mst_rec.lot_id;
437: l_ic_item_cnv_rec.um_type := l_um_type;
438: l_ic_item_cnv_rec.type_factor := l_factor;
439: l_ic_item_cnv_rec.last_update_date := SYSDATE;
440: l_ic_item_cnv_rec.last_updated_by := l_user_id;
441: l_ic_item_cnv_rec.trans_cnt := 1;

Line 438: l_ic_item_cnv_rec.type_factor := l_factor;

434:
435: l_ic_item_cnv_rec.item_id := l_ic_item_mst_rec.item_id;
436: l_ic_item_cnv_rec.lot_id := l_ic_lots_mst_rec.lot_id;
437: l_ic_item_cnv_rec.um_type := l_um_type;
438: l_ic_item_cnv_rec.type_factor := l_factor;
439: l_ic_item_cnv_rec.last_update_date := SYSDATE;
440: l_ic_item_cnv_rec.last_updated_by := l_user_id;
441: l_ic_item_cnv_rec.trans_cnt := 1;
442: l_ic_item_cnv_rec.delete_mark := 0;

Line 439: l_ic_item_cnv_rec.last_update_date := SYSDATE;

435: l_ic_item_cnv_rec.item_id := l_ic_item_mst_rec.item_id;
436: l_ic_item_cnv_rec.lot_id := l_ic_lots_mst_rec.lot_id;
437: l_ic_item_cnv_rec.um_type := l_um_type;
438: l_ic_item_cnv_rec.type_factor := l_factor;
439: l_ic_item_cnv_rec.last_update_date := SYSDATE;
440: l_ic_item_cnv_rec.last_updated_by := l_user_id;
441: l_ic_item_cnv_rec.trans_cnt := 1;
442: l_ic_item_cnv_rec.delete_mark := 0;
443: l_ic_item_cnv_rec.text_code := NULL;

Line 440: l_ic_item_cnv_rec.last_updated_by := l_user_id;

436: l_ic_item_cnv_rec.lot_id := l_ic_lots_mst_rec.lot_id;
437: l_ic_item_cnv_rec.um_type := l_um_type;
438: l_ic_item_cnv_rec.type_factor := l_factor;
439: l_ic_item_cnv_rec.last_update_date := SYSDATE;
440: l_ic_item_cnv_rec.last_updated_by := l_user_id;
441: l_ic_item_cnv_rec.trans_cnt := 1;
442: l_ic_item_cnv_rec.delete_mark := 0;
443: l_ic_item_cnv_rec.text_code := NULL;
444: l_ic_item_cnv_rec.creation_date := SYSDATE;

Line 441: l_ic_item_cnv_rec.trans_cnt := 1;

437: l_ic_item_cnv_rec.um_type := l_um_type;
438: l_ic_item_cnv_rec.type_factor := l_factor;
439: l_ic_item_cnv_rec.last_update_date := SYSDATE;
440: l_ic_item_cnv_rec.last_updated_by := l_user_id;
441: l_ic_item_cnv_rec.trans_cnt := 1;
442: l_ic_item_cnv_rec.delete_mark := 0;
443: l_ic_item_cnv_rec.text_code := NULL;
444: l_ic_item_cnv_rec.creation_date := SYSDATE;
445: l_ic_item_cnv_rec.created_by := l_user_id;

Line 442: l_ic_item_cnv_rec.delete_mark := 0;

438: l_ic_item_cnv_rec.type_factor := l_factor;
439: l_ic_item_cnv_rec.last_update_date := SYSDATE;
440: l_ic_item_cnv_rec.last_updated_by := l_user_id;
441: l_ic_item_cnv_rec.trans_cnt := 1;
442: l_ic_item_cnv_rec.delete_mark := 0;
443: l_ic_item_cnv_rec.text_code := NULL;
444: l_ic_item_cnv_rec.creation_date := SYSDATE;
445: l_ic_item_cnv_rec.created_by := l_user_id;
446: l_ic_item_cnv_rec.type_factorrev := l_type_factorrev;

Line 443: l_ic_item_cnv_rec.text_code := NULL;

439: l_ic_item_cnv_rec.last_update_date := SYSDATE;
440: l_ic_item_cnv_rec.last_updated_by := l_user_id;
441: l_ic_item_cnv_rec.trans_cnt := 1;
442: l_ic_item_cnv_rec.delete_mark := 0;
443: l_ic_item_cnv_rec.text_code := NULL;
444: l_ic_item_cnv_rec.creation_date := SYSDATE;
445: l_ic_item_cnv_rec.created_by := l_user_id;
446: l_ic_item_cnv_rec.type_factorrev := l_type_factorrev;
447: l_ic_item_cnv_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(

Line 444: l_ic_item_cnv_rec.creation_date := SYSDATE;

440: l_ic_item_cnv_rec.last_updated_by := l_user_id;
441: l_ic_item_cnv_rec.trans_cnt := 1;
442: l_ic_item_cnv_rec.delete_mark := 0;
443: l_ic_item_cnv_rec.text_code := NULL;
444: l_ic_item_cnv_rec.creation_date := SYSDATE;
445: l_ic_item_cnv_rec.created_by := l_user_id;
446: l_ic_item_cnv_rec.type_factorrev := l_type_factorrev;
447: l_ic_item_cnv_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(
448: 'LOGIN_ID'));

Line 445: l_ic_item_cnv_rec.created_by := l_user_id;

441: l_ic_item_cnv_rec.trans_cnt := 1;
442: l_ic_item_cnv_rec.delete_mark := 0;
443: l_ic_item_cnv_rec.text_code := NULL;
444: l_ic_item_cnv_rec.creation_date := SYSDATE;
445: l_ic_item_cnv_rec.created_by := l_user_id;
446: l_ic_item_cnv_rec.type_factorrev := l_type_factorrev;
447: l_ic_item_cnv_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(
448: 'LOGIN_ID'));
449:

Line 446: l_ic_item_cnv_rec.type_factorrev := l_type_factorrev;

442: l_ic_item_cnv_rec.delete_mark := 0;
443: l_ic_item_cnv_rec.text_code := NULL;
444: l_ic_item_cnv_rec.creation_date := SYSDATE;
445: l_ic_item_cnv_rec.created_by := l_user_id;
446: l_ic_item_cnv_rec.type_factorrev := l_type_factorrev;
447: l_ic_item_cnv_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(
448: 'LOGIN_ID'));
449:
450:

Line 447: l_ic_item_cnv_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(

443: l_ic_item_cnv_rec.text_code := NULL;
444: l_ic_item_cnv_rec.creation_date := SYSDATE;
445: l_ic_item_cnv_rec.created_by := l_user_id;
446: l_ic_item_cnv_rec.type_factorrev := l_type_factorrev;
447: l_ic_item_cnv_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(
448: 'LOGIN_ID'));
449:
450:
451: IF NOT GMI_ITEM_LOT_CONV_PVT.insert_IC_ITEM_CNV(l_ic_item_cnv_rec)

Line 451: IF NOT GMI_ITEM_LOT_CONV_PVT.insert_IC_ITEM_CNV(l_ic_item_cnv_rec)

447: l_ic_item_cnv_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(
448: 'LOGIN_ID'));
449:
450:
451: IF NOT GMI_ITEM_LOT_CONV_PVT.insert_IC_ITEM_CNV(l_ic_item_cnv_rec)
452: THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455: