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_CMP_TRAN_PVT dependencies on IC_SUMM_INV

Line 178: IF NOT Update_ic_summ_inv(l_cmp_tran_rec)

174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176:
177: -- Update inventory summary
178: IF NOT Update_ic_summ_inv(l_cmp_tran_rec)
179: THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182:

Line 322: IF NOT Update_ic_summ_inv_QC_GRADE(l_cmp_tran_rec)

318: AND lot_id = p_cmp_tran_rec.lot_id;
319: END IF;
320:
321: -- Update summary inventory
322: IF NOT Update_ic_summ_inv_QC_GRADE(l_cmp_tran_rec)
323: THEN
324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326:

Line 646: --| Update_Ic_Summ_Inv |

642:
643: -- Func start of comments
644: --+==========================================================================+
645: --| FUNCTION NAME |
646: --| Update_Ic_Summ_Inv |
647: --| |
648: --| USAGE |
649: --| Update inventory balances on ic_summ_inv |
650: --| |

Line 649: --| Update inventory balances on ic_summ_inv |

645: --| FUNCTION NAME |
646: --| Update_Ic_Summ_Inv |
647: --| |
648: --| USAGE |
649: --| Update inventory balances on ic_summ_inv |
650: --| |
651: --| DESCRIPTION |
652: --| This function updates the on-hand inventory balances on ic_summ_inv |
653: --| |

Line 652: --| This function updates the on-hand inventory balances on ic_summ_inv |

648: --| USAGE |
649: --| Update inventory balances on ic_summ_inv |
650: --| |
651: --| DESCRIPTION |
652: --| This function updates the on-hand inventory balances on ic_summ_inv |
653: --| |
654: --| PARAMETERS |
655: --| p_cmp_tran_rec IN RECORD - Inventory Transction Details |
656: --| |

Line 665: FUNCTION Update_Ic_Summ_Inv

661: --| HISTORY |
662: --| |
663: --+==========================================================================+
664: -- Func end of comments
665: FUNCTION Update_Ic_Summ_Inv
666: (p_cmp_tran_rec IN cmp_tran_typ)
667: RETURN BOOLEAN
668: IS
669: -- Cursors

Line 682: ic_summ_inv

678: CURSOR summary_inv IS
679: SELECT
680: *
681: FROM
682: ic_summ_inv
683: WHERE
684: item_id = p_cmp_tran_rec.item_id
685: AND whse_code = p_cmp_tran_rec.whse_code
686: AND ( qc_grade = p_cmp_tran_rec.qc_grade

Line 692: l_ic_summ_inv ic_summ_inv%ROWTYPE;

688: FOR UPDATE;
689:
690: -- Local variables
691: l_ic_lots_sts ic_lots_sts%ROWTYPE;
692: l_ic_summ_inv ic_summ_inv%ROWTYPE;
693: l_qty NUMBER := 0;
694: l_qty2 NUMBER := 0;
695: l_prod_qty NUMBER := 0;
696: l_prod_qty2 NUMBER := 0;

Line 701: l_summ_inv_id ic_summ_inv.summ_inv_id%TYPE :=0;

697: l_order_qty NUMBER := 0;
698: l_order_qty2 NUMBER := 0;
699: l_ship_qty NUMBER := 0;
700: l_ship_qty2 NUMBER := 0;
701: l_summ_inv_id ic_summ_inv.summ_inv_id%TYPE :=0;
702:
703: BEGIN
704: -- Retrieve lot status indicators
705:

Line 747: FETCH summary_inv INTO l_ic_summ_inv;

743:
744: -- Check if inventory summary row exists and if not create it
745: OPEN summary_inv;
746:
747: FETCH summary_inv INTO l_ic_summ_inv;
748:
749: IF (summary_inv%NOTFOUND)
750: THEN
751: SELECT gem5_summ_inv_id_s.nextval INTO l_summ_inv_id FROM dual;

Line 759: INSERT INTO ic_summ_inv

755: FND_MESSAGE.SET_TOKEN('SKEY','summ_inv_id');
756: FND_MSG_PUB.Add;
757: RAISE FND_API.G_EXC_ERROR;
758: ELSE
759: INSERT INTO ic_summ_inv
760: ( summ_inv_id
761: , item_id
762: , whse_code
763: , qc_grade

Line 829: UPDATE ic_summ_inv

825: END IF;
826: END IF;
827:
828: CLOSE summary_inv;
829: UPDATE ic_summ_inv
830: SET
831: onhand_qty = onhand_qty + l_qty
832: , onhand_qty2 = onhand_qty2 + l_qty2
833: , onhand_prod_qty = onhand_prod_qty + l_prod_qty

Line 859: , 'Update_ic_summ_inv'

855: -- IF FND_MSG_PUB.check_msg_level
856: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
857: -- THEN
858: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
859: , 'Update_ic_summ_inv'
860: );
861: -- END IF;
862: RETURN FALSE;
863:

Line 865: END Update_Ic_Summ_Inv;

861: -- END IF;
862: RETURN FALSE;
863:
864:
865: END Update_Ic_Summ_Inv;
866:
867: -- Func start of comments
868: --+==========================================================================+
869: --| FUNCTION NAME |

Line 958: IF NOT Update_ic_summ_inv(l_cmp_tran_rec)

954: AND location = p_cmp_tran_rec.location;
955: END IF;
956:
957: -- Update inventory summary
958: IF NOT Update_ic_summ_inv(l_cmp_tran_rec)
959: THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: END IF;
962:

Line 986: --| Update_Ic_Summ_Inv_Qc_Grade |

982:
983: -- Func start of comments
984: --+==========================================================================+
985: --| FUNCTION NAME |
986: --| Update_Ic_Summ_Inv_Qc_Grade |
987: --| |
988: --| USAGE |
989: --| Update ic_summ_inv for QC Grade change |
990: --| |

Line 989: --| Update ic_summ_inv for QC Grade change |

985: --| FUNCTION NAME |
986: --| Update_Ic_Summ_Inv_Qc_Grade |
987: --| |
988: --| USAGE |
989: --| Update ic_summ_inv for QC Grade change |
990: --| |
991: --| DESCRIPTION |
992: --| This function retrieves the on-hand balances for updating the |
993: --| summary inventory |

Line 1006: FUNCTION Update_Ic_Summ_Inv_Qc_Grade

1002: --| HISTORY |
1003: --| |
1004: --+==========================================================================+
1005: -- Func end of comments
1006: FUNCTION Update_Ic_Summ_Inv_Qc_Grade
1007: (p_cmp_tran_rec IN cmp_tran_typ)
1008: RETURN BOOLEAN
1009: IS
1010: -- Cursors

Line 1062: IF NOT Update_ic_summ_inv(l_cmp_tran_rec)

1058: l_cmp_tran_rec.trans_qty := l_qty;
1059: l_cmp_tran_rec.trans_qty2 := l_qty2;
1060: END IF;
1061: -- Update inventory summary
1062: IF NOT Update_ic_summ_inv(l_cmp_tran_rec)
1063: THEN
1064: CLOSE location_inv;
1065: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1066: END IF;

Line 1084: , 'Update_ic_summ_inv_Qc_Grade'

1080: -- IF FND_MSG_PUB.check_msg_level
1081: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1082: -- THEN
1083: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1084: , 'Update_ic_summ_inv_Qc_Grade'
1085: );
1086: -- END IF;
1087: RETURN FALSE;
1088:

Line 1090: END Update_Ic_Summ_Inv_Qc_Grade;

1086: -- END IF;
1087: RETURN FALSE;
1088:
1089:
1090: END Update_Ic_Summ_Inv_Qc_Grade;
1091:
1092: END GMI_CMP_TRAN_PVT;