APPS.MTL_LOT_NUMBERS_PKG dependencies on MTL_LOT_NUMBERS

Line 1: PACKAGE BODY MTL_LOT_NUMBERS_PKG as

1: PACKAGE BODY MTL_LOT_NUMBERS_PKG as
2: /* $Header: INVTDILB.pls 120.5.12020000.2 2012/08/13 06:16:01 avrose ship $ */
3:
4:
5: PROCEDURE Lock_Row(X_Rowid VARCHAR2,

Line 104: FROM mtl_lot_numbers

100:
101: ) IS
102: CURSOR C IS
103: SELECT *
104: FROM mtl_lot_numbers
105: WHERE rowid = X_Rowid
106: FOR UPDATE of Organization_Id NOWAIT;
107: Recinfo C%ROWTYPE;
108:

Line 399: Added Sampling_Event_ID to MTL_LOT_NUMBERS table

395:
396:
397: /*========================================
398: SFeinstein Convergence
399: Added Sampling_Event_ID to MTL_LOT_NUMBERS table
400: ========================================*/
401: PROCEDURE Update_Row(X_Rowid VARCHAR2,
402: X_Inventory_Item_Id NUMBER,
403: X_Organization_Id NUMBER,

Line 507: l_grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE;

503: Joe DiIorio - Convergence
504: Added l_grade_code and variables
505: to support call to update grade history.
506: ========================================*/
507: l_grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE;
508: l_status VARCHAR2(2);
509: l_message VARCHAR2(2000);
510: /* Jalaj Srivastava Bug 4998256
511: added varaibles below for call to quantity tree */

Line 535: FROM mtl_lot_numbers

531:
532: --Global Lot ER Start
533: CURSOR get_all_orgid(p_item_id IN NUMBER, p_lot_number IN VARCHAR2) IS
534: SELECT organization_id
535: FROM mtl_lot_numbers
536: WHERE inventory_item_id = p_item_id
537: AND lot_number = p_lot_number;
538: --Global Lot ER End
539:

Line 550: FROM mtl_lot_numbers

546: the record get updated with modified values. */
547:
548: SELECT status_id, grade_code
549: INTO l_status_id, l_grade_code
550: FROM mtl_lot_numbers
551: WHERE rowid = X_Rowid;
552:
553: /*===================================
554: Joe DiIorio - Convergence

Line 563: FROM mtl_lot_numbers

559: and incorporated it in select above
560: ===================================
561: SELECT grade_code
562: INTO l_grade_code
563: FROM mtl_lot_numbers
564: WHERE rowid = X_Rowid;
565: ===================================*/
566:
567:

Line 572: UPDATE mtl_lot_numbers

568: /*========================================
569: SFeinstein Convergence
570: Added Sampling_Event_ID to columns updated
571: ========================================*/
572: UPDATE mtl_lot_numbers
573: SET
574: inventory_item_id = X_Inventory_Item_Id,
575: organization_id = X_Organization_Id,
576: lot_number = X_Lot_Number,

Line 675: UPDATE mtl_lot_numbers

671: WHERE rowid = X_Rowid;
672:
673: --Global Lot ER Start
674: IF l_global_profile = 'Y' THEN
675: UPDATE mtl_lot_numbers
676: SET
677: expiration_date = X_Expiration_Date,
678: origination_date = X_Origination_Date,
679: maturity_date = X_Maturity_Date,

Line 1097: FROM mtl_lot_numbers

1093: IF l_global_profile = 'Y' THEN
1094: BEGIN
1095: SELECT 1,Expiration_Date,origination_date,maturity_date,retest_date,expiration_action_date,expiration_action_code,hold_date,grade_code
1096: INTO l_tmp,l_Expiration_Date,l_Origination_Date,l_Maturity_Date,l_Retest_Date,l_Expiration_Action_Date,l_Expiration_Action_Code,l_Hold_Date,l_Grade_Code
1097: FROM mtl_lot_numbers
1098: WHERE organization_id <> X_Organization_Id
1099: AND inventory_item_id = X_Inventory_Item_Id
1100: AND lot_number = X_Lot_Number
1101: AND ROWNUM = 1;

Line 1122: INSERT INTO MTL_LOT_NUMBERS (

1118: l_Grade_Code := X_Grade_Code;
1119: END IF;
1120: --Global Lot ER END
1121:
1122: INSERT INTO MTL_LOT_NUMBERS (
1123: Inventory_Item_Id,
1124: Organization_Id,
1125: Lot_Number,
1126: Creation_Date,

Line 1295: END MTL_LOT_NUMBERS_PKG;

1291: END IF;
1292:
1293: END Insert_Row;
1294:
1295: END MTL_LOT_NUMBERS_PKG;