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_LOTS_PUB dependencies on IC_LOTS_CPG

Line 99: l_ic_lots_cpg_rec ic_lots_cpg%ROWTYPE;

95: l_user_name fnd_user.user_name%TYPE;
96: l_user_id fnd_user.user_id%TYPE;
97: l_ic_item_mst_rec ic_item_mst%ROWTYPE;
98: l_ic_lots_mst_rec ic_lots_mst%ROWTYPE;
99: l_ic_lots_cpg_rec ic_lots_cpg%ROWTYPE;
100: l_lot_rec lot_rec_typ;
101: l_po_vend_mst_rec po_vend_mst%ROWTYPE;
102: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
103:

Line 398: -- Set up PL/SQL record and insert lot into ic_lots_cpg

394: THEN
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END IF;
397:
398: -- Set up PL/SQL record and insert lot into ic_lots_cpg
399:
400: l_ic_lots_cpg_rec.item_id := l_ic_item_mst_rec.item_id;
401: l_ic_lots_cpg_rec.lot_id := l_lot_id;
402: l_ic_lots_cpg_rec.ic_matr_date := l_lot_rec.ic_matr_date;

Line 400: l_ic_lots_cpg_rec.item_id := l_ic_item_mst_rec.item_id;

396: END IF;
397:
398: -- Set up PL/SQL record and insert lot into ic_lots_cpg
399:
400: l_ic_lots_cpg_rec.item_id := l_ic_item_mst_rec.item_id;
401: l_ic_lots_cpg_rec.lot_id := l_lot_id;
402: l_ic_lots_cpg_rec.ic_matr_date := l_lot_rec.ic_matr_date;
403: l_ic_lots_cpg_rec.ic_hold_date := l_lot_rec.ic_hold_date;
404: l_ic_lots_cpg_rec.created_by := l_user_id;

Line 401: l_ic_lots_cpg_rec.lot_id := l_lot_id;

397:
398: -- Set up PL/SQL record and insert lot into ic_lots_cpg
399:
400: l_ic_lots_cpg_rec.item_id := l_ic_item_mst_rec.item_id;
401: l_ic_lots_cpg_rec.lot_id := l_lot_id;
402: l_ic_lots_cpg_rec.ic_matr_date := l_lot_rec.ic_matr_date;
403: l_ic_lots_cpg_rec.ic_hold_date := l_lot_rec.ic_hold_date;
404: l_ic_lots_cpg_rec.created_by := l_user_id;
405: l_ic_lots_cpg_rec.creation_date := SYSDATE;

Line 402: l_ic_lots_cpg_rec.ic_matr_date := l_lot_rec.ic_matr_date;

398: -- Set up PL/SQL record and insert lot into ic_lots_cpg
399:
400: l_ic_lots_cpg_rec.item_id := l_ic_item_mst_rec.item_id;
401: l_ic_lots_cpg_rec.lot_id := l_lot_id;
402: l_ic_lots_cpg_rec.ic_matr_date := l_lot_rec.ic_matr_date;
403: l_ic_lots_cpg_rec.ic_hold_date := l_lot_rec.ic_hold_date;
404: l_ic_lots_cpg_rec.created_by := l_user_id;
405: l_ic_lots_cpg_rec.creation_date := SYSDATE;
406: l_ic_lots_cpg_rec.last_update_date := SYSDATE;

Line 403: l_ic_lots_cpg_rec.ic_hold_date := l_lot_rec.ic_hold_date;

399:
400: l_ic_lots_cpg_rec.item_id := l_ic_item_mst_rec.item_id;
401: l_ic_lots_cpg_rec.lot_id := l_lot_id;
402: l_ic_lots_cpg_rec.ic_matr_date := l_lot_rec.ic_matr_date;
403: l_ic_lots_cpg_rec.ic_hold_date := l_lot_rec.ic_hold_date;
404: l_ic_lots_cpg_rec.created_by := l_user_id;
405: l_ic_lots_cpg_rec.creation_date := SYSDATE;
406: l_ic_lots_cpg_rec.last_update_date := SYSDATE;
407: l_ic_lots_cpg_rec.last_updated_by := l_user_id;

Line 404: l_ic_lots_cpg_rec.created_by := l_user_id;

400: l_ic_lots_cpg_rec.item_id := l_ic_item_mst_rec.item_id;
401: l_ic_lots_cpg_rec.lot_id := l_lot_id;
402: l_ic_lots_cpg_rec.ic_matr_date := l_lot_rec.ic_matr_date;
403: l_ic_lots_cpg_rec.ic_hold_date := l_lot_rec.ic_hold_date;
404: l_ic_lots_cpg_rec.created_by := l_user_id;
405: l_ic_lots_cpg_rec.creation_date := SYSDATE;
406: l_ic_lots_cpg_rec.last_update_date := SYSDATE;
407: l_ic_lots_cpg_rec.last_updated_by := l_user_id;
408: l_ic_lots_cpg_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(

Line 405: l_ic_lots_cpg_rec.creation_date := SYSDATE;

401: l_ic_lots_cpg_rec.lot_id := l_lot_id;
402: l_ic_lots_cpg_rec.ic_matr_date := l_lot_rec.ic_matr_date;
403: l_ic_lots_cpg_rec.ic_hold_date := l_lot_rec.ic_hold_date;
404: l_ic_lots_cpg_rec.created_by := l_user_id;
405: l_ic_lots_cpg_rec.creation_date := SYSDATE;
406: l_ic_lots_cpg_rec.last_update_date := SYSDATE;
407: l_ic_lots_cpg_rec.last_updated_by := l_user_id;
408: l_ic_lots_cpg_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(
409: 'LOGIN_ID'));

Line 406: l_ic_lots_cpg_rec.last_update_date := SYSDATE;

402: l_ic_lots_cpg_rec.ic_matr_date := l_lot_rec.ic_matr_date;
403: l_ic_lots_cpg_rec.ic_hold_date := l_lot_rec.ic_hold_date;
404: l_ic_lots_cpg_rec.created_by := l_user_id;
405: l_ic_lots_cpg_rec.creation_date := SYSDATE;
406: l_ic_lots_cpg_rec.last_update_date := SYSDATE;
407: l_ic_lots_cpg_rec.last_updated_by := l_user_id;
408: l_ic_lots_cpg_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(
409: 'LOGIN_ID'));
410:

Line 407: l_ic_lots_cpg_rec.last_updated_by := l_user_id;

403: l_ic_lots_cpg_rec.ic_hold_date := l_lot_rec.ic_hold_date;
404: l_ic_lots_cpg_rec.created_by := l_user_id;
405: l_ic_lots_cpg_rec.creation_date := SYSDATE;
406: l_ic_lots_cpg_rec.last_update_date := SYSDATE;
407: l_ic_lots_cpg_rec.last_updated_by := l_user_id;
408: l_ic_lots_cpg_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(
409: 'LOGIN_ID'));
410:
411: IF NOT GMI_LOTS_PVT.insert_ic_lots_cpg(l_ic_lots_cpg_rec)

Line 408: l_ic_lots_cpg_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(

404: l_ic_lots_cpg_rec.created_by := l_user_id;
405: l_ic_lots_cpg_rec.creation_date := SYSDATE;
406: l_ic_lots_cpg_rec.last_update_date := SYSDATE;
407: l_ic_lots_cpg_rec.last_updated_by := l_user_id;
408: l_ic_lots_cpg_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(
409: 'LOGIN_ID'));
410:
411: IF NOT GMI_LOTS_PVT.insert_ic_lots_cpg(l_ic_lots_cpg_rec)
412: THEN

Line 411: IF NOT GMI_LOTS_PVT.insert_ic_lots_cpg(l_ic_lots_cpg_rec)

407: l_ic_lots_cpg_rec.last_updated_by := l_user_id;
408: l_ic_lots_cpg_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(
409: 'LOGIN_ID'));
410:
411: IF NOT GMI_LOTS_PVT.insert_ic_lots_cpg(l_ic_lots_cpg_rec)
412: THEN
413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
414: END IF;
415: