APPS.CSD_MASS_RO_SN_PKG dependencies on CSD_MASS_RO_SN

Line 1: PACKAGE BODY CSD_MASS_RO_SN_PKG as

1: PACKAGE BODY CSD_MASS_RO_SN_PKG as
2: /* $Header: csdtmrsb.pls 115.4 2003/10/28 18:53:43 vparvath noship $ */
3: -- Start of Comments
4: -- Package name : CSD_MASS_RO_SN_PKG
5: -- Purpose :

Line 4: -- Package name : CSD_MASS_RO_SN_PKG

1: PACKAGE BODY CSD_MASS_RO_SN_PKG as
2: /* $Header: csdtmrsb.pls 115.4 2003/10/28 18:53:43 vparvath noship $ */
3: -- Start of Comments
4: -- Package name : CSD_MASS_RO_SN_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_MASS_RO_SN_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_MASS_RO_SN_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtmrsb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_MASS_RO_SN_ID IN OUT NOCOPY NUMBER

Line 44: CURSOR C2 IS SELECT CSD_MASS_RO_SN_S1.nextval FROM sys.dual;

40: ,p_ATTRIBUTE14 VARCHAR2
41: ,p_ATTRIBUTE15 VARCHAR2)
42:
43: IS
44: CURSOR C2 IS SELECT CSD_MASS_RO_SN_S1.nextval FROM sys.dual;
45: BEGIN
46: If (px_MASS_RO_SN_ID IS NULL) OR (px_MASS_RO_SN_ID = FND_API.G_MISS_NUM) then
47: OPEN C2;
48: FETCH C2 INTO px_MASS_RO_SN_ID;

Line 51: INSERT INTO CSD_MASS_RO_SN(

47: OPEN C2;
48: FETCH C2 INTO px_MASS_RO_SN_ID;
49: CLOSE C2;
50: End If;
51: INSERT INTO CSD_MASS_RO_SN(
52: MASS_RO_SN_ID
53: ,REPAIR_LINE_ID
54: ,SERIAL_NUMBER
55: ,INSTANCE_ID

Line 140: Update CSD_MASS_RO_SN

136: ,p_ATTRIBUTE15 VARCHAR2)
137:
138: IS
139: BEGIN
140: Update CSD_MASS_RO_SN
141: SET
142: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
143: ,SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, SERIAL_NUMBER, p_SERIAL_NUMBER)
144: ,INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, NULL, INSTANCE_ID, p_INSTANCE_ID)

Line 179: DELETE FROM CSD_MASS_RO_SN

175: PROCEDURE Delete_Row(
176: p_MASS_RO_SN_ID NUMBER)
177: IS
178: BEGIN
179: DELETE FROM CSD_MASS_RO_SN
180: WHERE MASS_RO_SN_ID = p_MASS_RO_SN_ID;
181: If (SQL%NOTFOUND) then
182: RAISE NO_DATA_FOUND;
183: End If;

Line 193: FROM CSD_MASS_RO_SN

189:
190: IS
191: CURSOR C IS
192: SELECT *
193: FROM CSD_MASS_RO_SN
194: WHERE MASS_RO_SN_ID = p_MASS_RO_SN_ID
195: FOR UPDATE of MASS_RO_SN_ID NOWAIT;
196: Recinfo C%ROWTYPE;
197: BEGIN

Line 214: End CSD_MASS_RO_SN_PKG;

210: APP_EXCEPTION.RAISE_EXCEPTION;
211: End If;
212: END Lock_Row;
213:
214: End CSD_MASS_RO_SN_PKG;