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.GMIVITM dependencies on IC_ITEM_CPG

Line 337: | x_ic_item_cpg_row OUT ic_item_cpg%ROWTYPE |

333: | p_api_version IN NUMBER - Api Version |
334: | p_validation_level IN VARCHAR2 - Validation Level Indicator |
335: | p_item_rec IN item_rec_typ - Item Master details |
336: | x_ic_item_mst_row OUT ic_item_mst%ROWTYPE |
337: | x_ic_item_cpg_row OUT ic_item_cpg%ROWTYPE |
338: | x_return_status OUT VARCHAR2 - Return Status |
339: | x_msg_count OUT NUMBER - Number of messages |
340: | x_msg_data OUT VARCHAR2 - Messages in encoded format |
341: | |

Line 365: , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE

361: ( p_api_version IN NUMBER
362: , p_validation_level IN VARCHAR2 :=FND_API.G_VALID_LEVEL_FULL
363: , p_item_rec IN GMIGAPI.item_rec_typ
364: , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE
365: , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE
366: , x_return_status OUT NOCOPY VARCHAR2
367: , x_msg_count OUT NOCOPY NUMBER
368: , x_msg_data OUT NOCOPY VARCHAR2
369: )

Line 372: l_ic_item_cpg_row ic_item_cpg%ROWTYPE;

368: , x_msg_data OUT NOCOPY VARCHAR2
369: )
370: IS
371: l_ic_item_mst_row ic_item_mst%ROWTYPE;
372: l_ic_item_cpg_row ic_item_cpg%ROWTYPE;
373: l_sy_uoms_mst_row sy_uoms_mst%ROWTYPE;
374: l_sy_uoms_typ_row sy_uoms_typ%ROWTYPE;
375: l_qc_grad_mst_row qc_grad_mst%ROWTYPE;
376: l_qc_actn_mst_row qc_actn_mst%ROWTYPE;

Line 757: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.whse_item_no)), l_ic_item_mst_row, l_ic_item_cpg_row);

753: THEN
754: x_ic_item_mst_row.whse_item_id:= NULL;
755: ELSE
756: -- BUG#2461984 VAK
757: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.whse_item_no)), l_ic_item_mst_row, l_ic_item_cpg_row);
758: IF l_ic_item_mst_row.item_id IS NOT NULL
759: THEN
760: x_ic_item_mst_row.whse_item_id := l_ic_item_mst_row.item_id;
761: ELSE

Line 774: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.qcitem_no)),l_ic_item_mst_row, l_ic_item_cpg_row);

770: THEN
771: x_ic_item_mst_row.qcitem_id:= NULL;
772: ELSE
773: -- BUG#2461984 VAK
774: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.qcitem_no)),l_ic_item_mst_row, l_ic_item_cpg_row);
775: IF l_ic_item_mst_row.item_id IS NOT NULL
776: THEN
777: x_ic_item_mst_row.qcitem_id := l_ic_item_mst_row.item_id;
778: ELSE

Line 863: x_ic_item_cpg_row.item_id := NULL;

859: Replace check for CPG_INSTALL with lot control */
860: IF p_item_rec.lot_ctl = 1
861: THEN
862: /* Validate/setup CPG fields */
863: x_ic_item_cpg_row.item_id := NULL;
864: x_ic_item_cpg_row.ic_matr_days := NVL(p_item_rec.ic_matr_days,0);
865: IF x_ic_item_cpg_row.ic_matr_days < 0
866: THEN
867: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_MATR_DAYS');

Line 864: x_ic_item_cpg_row.ic_matr_days := NVL(p_item_rec.ic_matr_days,0);

860: IF p_item_rec.lot_ctl = 1
861: THEN
862: /* Validate/setup CPG fields */
863: x_ic_item_cpg_row.item_id := NULL;
864: x_ic_item_cpg_row.ic_matr_days := NVL(p_item_rec.ic_matr_days,0);
865: IF x_ic_item_cpg_row.ic_matr_days < 0
866: THEN
867: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_MATR_DAYS');
868: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

Line 865: IF x_ic_item_cpg_row.ic_matr_days < 0

861: THEN
862: /* Validate/setup CPG fields */
863: x_ic_item_cpg_row.item_id := NULL;
864: x_ic_item_cpg_row.ic_matr_days := NVL(p_item_rec.ic_matr_days,0);
865: IF x_ic_item_cpg_row.ic_matr_days < 0
866: THEN
867: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_MATR_DAYS');
868: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
869: FND_MSG_PUB.Add;

Line 872: x_ic_item_cpg_row.ic_hold_days := p_item_rec.ic_hold_days;

868: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
869: FND_MSG_PUB.Add;
870: END IF;
871:
872: x_ic_item_cpg_row.ic_hold_days := p_item_rec.ic_hold_days;
873: /* Jalaj Srivastava Bug 3158806
874: Removed nvl above so that hold days in cpg table go as null if user did not sepcify
875: hold days.
876: Populate dummy column level code in ic_item_mst with hold days. */

Line 877: x_ic_item_mst_row.level_code := x_ic_item_cpg_row.ic_hold_days;

873: /* Jalaj Srivastava Bug 3158806
874: Removed nvl above so that hold days in cpg table go as null if user did not sepcify
875: hold days.
876: Populate dummy column level code in ic_item_mst with hold days. */
877: x_ic_item_mst_row.level_code := x_ic_item_cpg_row.ic_hold_days;
878:
879: IF x_ic_item_cpg_row.ic_matr_days < 0
880: THEN
881: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_HOLD_DAYS');

Line 879: IF x_ic_item_cpg_row.ic_matr_days < 0

875: hold days.
876: Populate dummy column level code in ic_item_mst with hold days. */
877: x_ic_item_mst_row.level_code := x_ic_item_cpg_row.ic_hold_days;
878:
879: IF x_ic_item_cpg_row.ic_matr_days < 0
880: THEN
881: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_HOLD_DAYS');
882: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
883: FND_MSG_PUB.Add;

Line 901: x_ic_item_cpg_row.creation_date := SYSDATE;

897: /* Jalaj Srivastava Bug 3158806
898: Replace check for CPG_INSTALL with lot control */
899: IF p_item_rec.lot_ctl = 1
900: THEN
901: x_ic_item_cpg_row.creation_date := SYSDATE;
902: x_ic_item_cpg_row.last_update_date := SYSDATE;
903: x_ic_item_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
904: x_ic_item_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
905: x_ic_item_cpg_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;

Line 902: x_ic_item_cpg_row.last_update_date := SYSDATE;

898: Replace check for CPG_INSTALL with lot control */
899: IF p_item_rec.lot_ctl = 1
900: THEN
901: x_ic_item_cpg_row.creation_date := SYSDATE;
902: x_ic_item_cpg_row.last_update_date := SYSDATE;
903: x_ic_item_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
904: x_ic_item_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
905: x_ic_item_cpg_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
906: END IF;

Line 903: x_ic_item_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;

899: IF p_item_rec.lot_ctl = 1
900: THEN
901: x_ic_item_cpg_row.creation_date := SYSDATE;
902: x_ic_item_cpg_row.last_update_date := SYSDATE;
903: x_ic_item_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
904: x_ic_item_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
905: x_ic_item_cpg_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
906: END IF;
907:

Line 904: x_ic_item_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;

900: THEN
901: x_ic_item_cpg_row.creation_date := SYSDATE;
902: x_ic_item_cpg_row.last_update_date := SYSDATE;
903: x_ic_item_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
904: x_ic_item_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
905: x_ic_item_cpg_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
906: END IF;
907:
908: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 905: x_ic_item_cpg_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;

901: x_ic_item_cpg_row.creation_date := SYSDATE;
902: x_ic_item_cpg_row.last_update_date := SYSDATE;
903: x_ic_item_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
904: x_ic_item_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
905: x_ic_item_cpg_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
906: END IF;
907:
908: x_return_status := FND_API.G_RET_STS_SUCCESS;
909: