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.1.12010000.3 2008/11/04 08:48:49 ksivasa 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 538: FROM mtl_lot_numbers

534: the record get updated with modified values. */
535:
536: SELECT status_id, grade_code
537: INTO l_status_id, l_grade_code
538: FROM mtl_lot_numbers
539: WHERE rowid = X_Rowid;
540:
541: /*===================================
542: Joe DiIorio - Convergence

Line 551: FROM mtl_lot_numbers

547: and incorporated it in select above
548: ===================================
549: SELECT grade_code
550: INTO l_grade_code
551: FROM mtl_lot_numbers
552: WHERE rowid = X_Rowid;
553: ===================================*/
554:
555:

Line 560: UPDATE mtl_lot_numbers

556: /*========================================
557: SFeinstein Convergence
558: Added Sampling_Event_ID to columns updated
559: ========================================*/
560: UPDATE mtl_lot_numbers
561: SET
562: inventory_item_id = X_Inventory_Item_Id,
563: organization_id = X_Organization_Id,
564: lot_number = X_Lot_Number,

Line 923: INSERT INTO MTL_LOT_NUMBERS (

919: IS
920:
921: BEGIN
922:
923: INSERT INTO MTL_LOT_NUMBERS (
924: Inventory_Item_Id,
925: Organization_Id,
926: Lot_Number,
927: Creation_Date,

Line 1089: END MTL_LOT_NUMBERS_PKG;

1085:
1086:
1087: END Insert_Row;
1088:
1089: END MTL_LOT_NUMBERS_PKG;