APPS.OE_LOT_SERIAL_UTIL dependencies on OE_LOT_SERIAL_NUMBERS

Line 795: UPDATE OE_LOT_SERIAL_NUMBERS

791: , p_Line_Set_ID IN NUMBER)
792: IS
793: BEGIN
794:
795: UPDATE OE_LOT_SERIAL_NUMBERS
796: SET LINE_SET_ID = p_Line_Set_ID
797: WHERE LINE_ID = p_Line_ID;
798:
799: IF (SQL%NOTFOUND) THEN

Line 838: FROM OE_LOT_SERIAL_NUMBERS

834: BEGIN
835:
836: SELECT lock_control
837: INTO l_lock_control
838: FROM OE_LOT_SERIAL_NUMBERS
839: WHERE lot_serial_id = p_Lot_Serial_rec.lot_serial_id;
840:
841: l_lock_control := l_lock_control + 1;
842:

Line 853: UPDATE OE_LOT_SERIAL_NUMBERS

849: x_lot_serial_rec =>l_lot_serial_rec);
850: oe_debug_pub.add('before update, lot_serial_id= '|| l_lot_serial_rec.lot_serial_id, 1);
851: /* jolin end*/
852:
853: UPDATE OE_LOT_SERIAL_NUMBERS
854: SET ATTRIBUTE1 = p_Lot_Serial_rec.attribute1
855: , ATTRIBUTE10 = p_Lot_Serial_rec.attribute10
856: , ATTRIBUTE11 = p_Lot_Serial_rec.attribute11
857: , ATTRIBUTE12 = p_Lot_Serial_rec.attribute12

Line 951: INSERT INTO OE_LOT_SERIAL_NUMBERS

947: /* jolin end*/
948:
949: BEGIN
950:
951: INSERT INTO OE_LOT_SERIAL_NUMBERS
952: ( ATTRIBUTE1
953: , ATTRIBUTE10
954: , ATTRIBUTE11
955: , ATTRIBUTE12

Line 1119: FROM OE_LOT_SERIAL_NUMBERS

1115: l_return_status VARCHAR2(1);
1116:
1117: CURSOR line_set IS
1118: SELECT lot_serial_id
1119: FROM OE_LOT_SERIAL_NUMBERS
1120: WHERE line_set_id = l_line_rec.line_set_id;
1121:
1122: CURSOR lot_serial IS
1123: SELECT lot_serial_id

Line 1124: FROM OE_LOT_SERIAL_NUMBERS

1120: WHERE line_set_id = l_line_rec.line_set_id;
1121:
1122: CURSOR lot_serial IS
1123: SELECT lot_serial_id
1124: FROM OE_LOT_SERIAL_NUMBERS
1125: WHERE line_id = p_line_id;
1126:
1127: /* jolin end*/
1128:

Line 1188: DELETE FROM oe_lot_serial_numbers

1184: END IF; /* code set is pack H or higher */
1185: /* jolin end*/
1186:
1187: -- delete lot serial numbers for this line
1188: DELETE FROM oe_lot_serial_numbers
1189: WHERE line_id = p_line_id;
1190:
1191: ELSIF (Is_Last_In_Line_Set(p_line_id)) THEN
1192:

Line 1237: DELETE FROM oe_lot_serial_numbers

1233: END IF; /* code set is pack H or higher */
1234: /* jolin end*/
1235:
1236: -- delete lot serial records for this line set
1237: DELETE FROM oe_lot_serial_numbers
1238: WHERE line_set_id = l_line_rec.line_set_id;
1239:
1240: ELSE -- there are other lines in this line set, keep lot/serial numbers
1241: NULL;

Line 1247: DELETE FROM OE_LOT_SERIAL_NUMBERS

1243: END IF;
1244: END IF; -- return_line
1245:
1246: ELSE -- no line_id
1247: DELETE FROM OE_LOT_SERIAL_NUMBERS
1248: WHERE LOT_SERIAL_ID = p_lot_serial_id;
1249:
1250: END IF; -- line_id or lot_serial_id
1251:

Line 1337: FROM OE_LOT_SERIAL_NUMBERS

1333: , QUANTITY2 --OPM 2380194
1334: , TO_SERIAL_NUMBER
1335: , LINE_SET_ID
1336: , LOCK_CONTROL
1337: FROM OE_LOT_SERIAL_NUMBERS
1338: WHERE ( LOT_SERIAL_ID = p_lot_serial_id
1339: )
1340: OR ( LINE_ID = l_line_id
1341: )

Line 1579: FROM oe_lot_serial_numbers

1575: END IF;
1576:
1577: SELECT lot_serial_id
1578: INTO l_lot_serial_id
1579: FROM oe_lot_serial_numbers
1580: WHERE lot_serial_id = l_lot_serial_id
1581: FOR UPDATE NOWAIT;
1582:
1583: oe_debug_pub.add('selected for update', 1);

Line 1689: FROM oe_lot_serial_numbers

1685: )
1686: IS
1687: CURSOR lock_lot_serial(p_line_id NUMBER) IS
1688: SELECT lot_serial_id
1689: FROM oe_lot_serial_numbers
1690: WHERE line_id = p_line_id
1691: FOR UPDATE NOWAIT;
1692:
1693: l_lot_serial_id NUMBER;

Line 1720: FROM OE_LOT_SERIAL_NUMBERS

1716: IF p_lot_serial_id <> FND_API.G_MISS_NUM THEN
1717:
1718: SELECT lot_serial_id
1719: INTO l_lot_serial_id
1720: FROM OE_LOT_SERIAL_NUMBERS
1721: WHERE lot_serial_id = p_lot_serial_id
1722: FOR UPDATE NOWAIT;
1723:
1724: END IF;