APPS.CSP_EXCESS_LST_SERIAL_LOTS_PKG dependencies on CSP_EXCESS_LIST_SERIAL_LOTS

Line 27: CURSOR C2 IS SELECT CSP_EXCESS_LIST_SERIAL_LOTS_S1.nextval FROM sys.dual;

23: p_SERIAL_NUMBER VARCHAR2,
24: p_REVISION VARCHAR2,
25: p_LOCATOR_ID NUMBER)
26: IS
27: CURSOR C2 IS SELECT CSP_EXCESS_LIST_SERIAL_LOTS_S1.nextval FROM sys.dual;
28: BEGIN
29: If (px_EXCESS_LIST_SERIAL_LOT_ID IS NULL) OR (px_EXCESS_LIST_SERIAL_LOT_ID = FND_API.G_MISS_NUM) then
30: OPEN C2;
31: FETCH C2 INTO px_EXCESS_LIST_SERIAL_LOT_ID;

Line 34: INSERT INTO CSP_EXCESS_LIST_SERIAL_LOTS(

30: OPEN C2;
31: FETCH C2 INTO px_EXCESS_LIST_SERIAL_LOT_ID;
32: CLOSE C2;
33: End If;
34: INSERT INTO CSP_EXCESS_LIST_SERIAL_LOTS(
35: EXCESS_LIST_SERIAL_LOT_ID,
36: CREATED_BY,
37: CREATION_DATE,
38: LAST_UPDATED_BY,

Line 78: Update CSP_EXCESS_LIST_SERIAL_LOTS

74: p_LOCATOR_ID NUMBER)
75:
76: IS
77: BEGIN
78: Update CSP_EXCESS_LIST_SERIAL_LOTS
79: SET CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
80: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
81: LAST_UPDATED_BY = G_USER_ID,
82: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 99: DELETE FROM CSP_EXCESS_LIST_SERIAL_LOTS

95: PROCEDURE Delete_Row(
96: p_EXCESS_LIST_SERIAL_LOT_ID NUMBER)
97: IS
98: BEGIN
99: DELETE FROM CSP_EXCESS_LIST_SERIAL_LOTS
100: WHERE EXCESS_LIST_SERIAL_LOT_ID = p_EXCESS_LIST_SERIAL_LOT_ID;
101: If (SQL%NOTFOUND) then
102: RAISE NO_DATA_FOUND;
103: End If;

Line 122: FROM CSP_EXCESS_LIST_SERIAL_LOTS

118:
119: IS
120: CURSOR C IS
121: SELECT *
122: FROM CSP_EXCESS_LIST_SERIAL_LOTS
123: WHERE EXCESS_LIST_SERIAL_LOT_ID = p_EXCESS_LIST_SERIAL_LOT_ID
124: FOR UPDATE of EXCESS_LIST_SERIAL_LOT_ID NOWAIT;
125: Recinfo C%ROWTYPE;
126: BEGIN