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_LOCT_INV

Line 25: --| Update_Ic_Loct_Inv |

21: --| Update_Movement |
22: --| Update_Lot_Status |
23: --| Update_Qc_Grade |
24: --| Insert_Ic_Tran_Pnd |
25: --| Update_Ic_Loct_Inv |
26: --| Update_Summ_Inv |
27: --| Update_Ic_Loct_Inv_Lot_Status |
28: --| Update_Summ_Inv_Qc_Grade |
29: --| |

Line 27: --| Update_Ic_Loct_Inv_Lot_Status |

23: --| Update_Qc_Grade |
24: --| Insert_Ic_Tran_Pnd |
25: --| Update_Ic_Loct_Inv |
26: --| Update_Summ_Inv |
27: --| Update_Ic_Loct_Inv_Lot_Status |
28: --| Update_Summ_Inv_Qc_Grade |
29: --| |
30: --| HISTORY |
31: --| Liz Enstone 2 Jan 2000 BUg 1159923 Change message name from SY_API_ |

Line 172: IF NOT Update_ic_loct_inv(l_cmp_tran_rec)

168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170:
171: -- Update location inventory
172: IF NOT Update_ic_loct_inv(l_cmp_tran_rec)
173: THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176:

Line 243: IF NOT Update_ic_loct_inv_LOT_STATUS(l_cmp_tran_rec)

239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
240: END IF;
241:
242: -- Update location inventory
243: IF NOT Update_ic_loct_inv_LOT_STATUS(l_cmp_tran_rec)
244: THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247:

Line 458: --| Update_Ic_Loct_Inv |

454:
455: -- Func start of comments
456: --+==========================================================================+
457: --| FUNCTION NAME |
458: --| Update_Ic_Loct_Inv |
459: --| |
460: --| USAGE |
461: --| Update inventory level on ic_loct_inv |
462: --| |

Line 461: --| Update inventory level on ic_loct_inv |

457: --| FUNCTION NAME |
458: --| Update_Ic_Loct_Inv |
459: --| |
460: --| USAGE |
461: --| Update inventory level on ic_loct_inv |
462: --| |
463: --| DESCRIPTION |
464: --| This function updates the on-hand inventory on ic_loct_inv |
465: --| |

Line 464: --| This function updates the on-hand inventory on ic_loct_inv |

460: --| USAGE |
461: --| Update inventory level on ic_loct_inv |
462: --| |
463: --| DESCRIPTION |
464: --| This function updates the on-hand inventory on ic_loct_inv |
465: --| |
466: --| PARAMETERS |
467: --| p_cmp_tran_rec IN RECORD - Inventory Transction Details |
468: --| |

Line 477: FUNCTION Update_Ic_Loct_Inv

473: --| HISTORY |
474: --| |
475: --+==========================================================================+
476: -- Func end of comments
477: FUNCTION Update_Ic_Loct_Inv
478: (p_cmp_tran_rec IN cmp_tran_typ)
479: RETURN BOOLEAN
480: IS
481:

Line 486: ic_loct_inv

482: CURSOR location_inv IS
483: SELECT
484: *
485: FROM
486: ic_loct_inv
487: WHERE
488: item_id = p_cmp_tran_rec.item_id
489: AND whse_code = p_cmp_tran_rec.whse_code
490: AND lot_id = p_cmp_tran_rec.lot_id

Line 495: l_ic_loct_inv ic_loct_inv%ROWTYPE;

491: AND location = p_cmp_tran_rec.location
492: FOR UPDATE;
493:
494: -- Local variables
495: l_ic_loct_inv ic_loct_inv%ROWTYPE;
496:
497: BEGIN
498:
499: -- Check if inventory exists at location

Line 503: FETCH location_inv INTO l_ic_loct_inv;

499: -- Check if inventory exists at location
500:
501: OPEN location_inv;
502:
503: FETCH location_inv INTO l_ic_loct_inv;
504:
505: IF (location_inv%NOTFOUND)
506: THEN
507: -- Insert location inventory

Line 508: IF NOT Insert_Ic_Loct_Inv(p_cmp_tran_rec)

504:
505: IF (location_inv%NOTFOUND)
506: THEN
507: -- Insert location inventory
508: IF NOT Insert_Ic_Loct_Inv(p_cmp_tran_rec)
509: THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512: END IF;

Line 516: UPDATE ic_loct_inv

512: END IF;
513:
514: CLOSE location_inv;
515:
516: UPDATE ic_loct_inv
517: SET
518: loct_onhand = loct_onhand + p_cmp_tran_rec.trans_qty
519: , loct_onhand2 = loct_onhand2 + p_cmp_tran_rec.trans_qty2
520: , last_updated_by = p_cmp_tran_rec.user_id

Line 528: -- If inventory movment then update lot_status for ic_loct_inv

524: AND whse_code = p_cmp_tran_rec.whse_code
525: AND lot_id = p_cmp_tran_rec.lot_id
526: AND location = p_cmp_tran_rec.location;
527:
528: -- If inventory movment then update lot_status for ic_loct_inv
529: IF (p_cmp_tran_rec.doc_type = 'TRNI' AND
530: p_cmp_tran_rec.line_type = 1)
531: THEN
532: UPDATE ic_loct_inv

Line 532: UPDATE ic_loct_inv

528: -- If inventory movment then update lot_status for ic_loct_inv
529: IF (p_cmp_tran_rec.doc_type = 'TRNI' AND
530: p_cmp_tran_rec.line_type = 1)
531: THEN
532: UPDATE ic_loct_inv
533: SET
534: lot_status = p_cmp_tran_rec.lot_status
535: , last_updated_by = p_cmp_tran_rec.user_id
536: , last_update_date = SYSDATE

Line 556: , 'Update_ic_loct_inv'

552: -- IF FND_MSG_PUB.check_msg_level
553: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
554: -- THEN
555: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
556: , 'Update_ic_loct_inv'
557: );
558: -- END IF;
559: RETURN FALSE;
560:

Line 561: END Update_Ic_Loct_Inv;

557: );
558: -- END IF;
559: RETURN FALSE;
560:
561: END Update_Ic_Loct_Inv;
562:
563: -- Func start of comments
564: --+==========================================================================+
565: --| FUNCTION NAME |

Line 566: --| Insert_Ic_Loct_Inv |

562:
563: -- Func start of comments
564: --+==========================================================================+
565: --| FUNCTION NAME |
566: --| Insert_Ic_Loct_Inv |
567: --| |
568: --| USAGE |
569: --| Insert row into ic_loct_inv |
570: --| |

Line 569: --| Insert row into ic_loct_inv |

565: --| FUNCTION NAME |
566: --| Insert_Ic_Loct_Inv |
567: --| |
568: --| USAGE |
569: --| Insert row into ic_loct_inv |
570: --| |
571: --| DESCRIPTION |
572: --| This function creates a new row in ic_loct_inv |
573: --| |

Line 572: --| This function creates a new row in ic_loct_inv |

568: --| USAGE |
569: --| Insert row into ic_loct_inv |
570: --| |
571: --| DESCRIPTION |
572: --| This function creates a new row in ic_loct_inv |
573: --| |
574: --| PARAMETERS |
575: --| p_cmp_tran_rec IN RECORD - Inventory Transction Details |
576: --| |

Line 585: FUNCTION Insert_Ic_Loct_Inv

581: --| HISTORY |
582: --| |
583: --+==========================================================================+
584: -- Func end of comments
585: FUNCTION Insert_Ic_Loct_Inv
586: (p_cmp_tran_rec IN cmp_tran_typ)
587: RETURN BOOLEAN
588: IS
589:

Line 592: INSERT INTO Ic_Loct_Inv

588: IS
589:
590: BEGIN
591:
592: INSERT INTO Ic_Loct_Inv
593: ( item_id
594: , whse_code
595: , lot_id
596: , location

Line 636: , 'insert_ic_loct_inv'

632: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
633: -- THEN
634:
635: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
636: , 'insert_ic_loct_inv'
637: );
638: -- END IF;
639: RETURN FALSE;
640:

Line 641: END Insert_Ic_Loct_Inv;

637: );
638: -- END IF;
639: RETURN FALSE;
640:
641: END Insert_Ic_Loct_Inv;
642:
643: -- Func start of comments
644: --+==========================================================================+
645: --| FUNCTION NAME |

Line 870: --| Update_Ic_Loct_Inv_Lot_Status |

866:
867: -- Func start of comments
868: --+==========================================================================+
869: --| FUNCTION NAME |
870: --| Update_Ic_Loct_Inv_Lot_Status |
871: --| |
872: --| USAGE |
873: --| Update ic_loct_inv for Lot Status change |
874: --| |

Line 873: --| Update ic_loct_inv for Lot Status change |

869: --| FUNCTION NAME |
870: --| Update_Ic_Loct_Inv_Lot_Status |
871: --| |
872: --| USAGE |
873: --| Update ic_loct_inv for Lot Status change |
874: --| |
875: --| DESCRIPTION |
876: --| This function retrieves the on-hand balances for updating the |
877: --| summary inventory For 'After' transactions, the lost_status is |

Line 891: FUNCTION Update_Ic_Loct_Inv_Lot_Status

887: --| HISTORY |
888: --| |
889: --+==========================================================================+
890: -- Func end of comments
891: FUNCTION Update_Ic_Loct_Inv_Lot_Status
892: (p_cmp_tran_rec IN cmp_tran_typ)
893: RETURN BOOLEAN
894: IS
895: -- Cursors

Line 901: ic_loct_inv

897: SELECT
898: loct_onhand
899: , loct_onhand2
900: FROM
901: ic_loct_inv
902: WHERE
903: item_id = p_cmp_tran_rec.item_id
904: AND whse_code = p_cmp_tran_rec.whse_code
905: AND lot_id = p_cmp_tran_rec.lot_id

Line 928: IF NOT Insert_Ic_Loct_Inv(p_cmp_tran_rec)

924:
925: IF (location_inv%NOTFOUND)
926: THEN
927: -- Insert location inventory
928: IF NOT Insert_Ic_Loct_Inv(p_cmp_tran_rec)
929: THEN
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END IF;
932: END IF;

Line 945: UPDATE ic_loct_inv

941: l_cmp_tran_rec.trans_qty2 := 0 - l_qty2;
942: ELSE
943: l_cmp_tran_rec.trans_qty := l_qty;
944: l_cmp_tran_rec.trans_qty2 := l_qty2;
945: UPDATE ic_loct_inv
946: SET
947: lot_status = l_cmp_tran_rec.lot_status
948: , last_updated_by = p_cmp_tran_rec.user_id
949: , last_update_date = SYSDATE

Line 975: , 'Update_ic_loct_inv_Lot_Status'

971: -- IF FND_MSG_PUB.check_msg_level
972: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
973: -- THEN
974: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
975: , 'Update_ic_loct_inv_Lot_Status'
976: );
977: -- END IF;
978: RETURN FALSE;
979:

Line 981: END Update_Ic_Loct_Inv_Lot_Status;

977: -- END IF;
978: RETURN FALSE;
979:
980:
981: END Update_Ic_Loct_Inv_Lot_Status;
982:
983: -- Func start of comments
984: --+==========================================================================+
985: --| FUNCTION NAME |

Line 1018: ic_loct_inv

1014: lot_status
1015: , SUM(loct_onhand)
1016: , SUM(loct_onhand2)
1017: FROM
1018: ic_loct_inv
1019: WHERE
1020: item_id = p_cmp_tran_rec.item_id
1021: AND lot_id = p_cmp_tran_rec.lot_id
1022: GROUP BY

Line 1029: l_whse_code ic_loct_inv.whse_code%TYPE;

1025: whse_code;
1026:
1027: -- local variables
1028: l_cmp_tran_rec cmp_tran_typ;
1029: l_whse_code ic_loct_inv.whse_code%TYPE;
1030: l_lot_status ic_loct_inv.lot_status%TYPE;
1031: l_qty NUMBER := 0;
1032: l_qty2 NUMBER := 0;
1033:

Line 1030: l_lot_status ic_loct_inv.lot_status%TYPE;

1026:
1027: -- local variables
1028: l_cmp_tran_rec cmp_tran_typ;
1029: l_whse_code ic_loct_inv.whse_code%TYPE;
1030: l_lot_status ic_loct_inv.lot_status%TYPE;
1031: l_qty NUMBER := 0;
1032: l_qty2 NUMBER := 0;
1033:
1034: BEGIN