APPS.CSD_REPAIR_ESTIMATE_LINES_PKG dependencies on CSD_REPAIR_ESTIMATE_LINES

Line 1: PACKAGE BODY CSD_REPAIR_ESTIMATE_LINES_PKG as

1: PACKAGE BODY CSD_REPAIR_ESTIMATE_LINES_PKG as
2: /* $Header: csdtetlb.pls 115.8 2003/08/29 21:59:15 swai noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_ESTIMATE_LINES_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_ESTIMATE_LINES_PKG';

1: PACKAGE BODY CSD_REPAIR_ESTIMATE_LINES_PKG as
2: /* $Header: csdtetlb.pls 115.8 2003/08/29 21:59:15 swai noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_ESTIMATE_LINES_PKG';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtetlb.pls';
7: l_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
8:
9: -- travi forward port Bug # 2789754 fix added override_charge_flag

Line 47: CURSOR C2 IS SELECT CSD_REPAIR_ESTIMATE_LINES_S1.nextval FROM sys.dual;

43: ,p_RO_SERVICE_CODE_ID NUMBER
44: )
45:
46: IS
47: CURSOR C2 IS SELECT CSD_REPAIR_ESTIMATE_LINES_S1.nextval FROM sys.dual;
48: BEGIN
49: If (px_REPAIR_ESTIMATE_LINE_ID IS NULL) OR (px_REPAIR_ESTIMATE_LINE_ID = FND_API.G_MISS_NUM) then
50: OPEN C2;
51: FETCH C2 INTO px_REPAIR_ESTIMATE_LINE_ID;

Line 54: INSERT INTO CSD_REPAIR_ESTIMATE_LINES(

50: OPEN C2;
51: FETCH C2 INTO px_REPAIR_ESTIMATE_LINE_ID;
52: CLOSE C2;
53: End If;
54: INSERT INTO CSD_REPAIR_ESTIMATE_LINES(
55: REPAIR_ESTIMATE_LINE_ID
56: ,REPAIR_ESTIMATE_ID
57: ,CREATION_DATE
58: ,CREATED_BY

Line 165: Update CSD_REPAIR_ESTIMATE_LINES

161: )
162:
163: IS
164: BEGIN
165: Update CSD_REPAIR_ESTIMATE_LINES
166: SET
167: REPAIR_ESTIMATE_ID = decode( p_REPAIR_ESTIMATE_ID, FND_API.G_MISS_NUM, REPAIR_ESTIMATE_ID, p_REPAIR_ESTIMATE_ID)
168: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
169: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)

Line 211: DELETE FROM CSD_REPAIR_ESTIMATE_LINES

207: PROCEDURE Delete_Row(
208: p_REPAIR_ESTIMATE_LINE_ID NUMBER)
209: IS
210: BEGIN
211: DELETE FROM CSD_REPAIR_ESTIMATE_LINES
212: WHERE REPAIR_ESTIMATE_LINE_ID = p_REPAIR_ESTIMATE_LINE_ID;
213: If (SQL%NOTFOUND) then
214: RAISE NO_DATA_FOUND;
215: End If;

Line 225: FROM CSD_REPAIR_ESTIMATE_LINES

221:
222: IS
223: CURSOR C IS
224: SELECT *
225: FROM CSD_REPAIR_ESTIMATE_LINES
226: WHERE REPAIR_ESTIMATE_LINE_ID = p_REPAIR_ESTIMATE_LINE_ID
227: FOR UPDATE of REPAIR_ESTIMATE_LINE_ID NOWAIT;
228: Recinfo C%ROWTYPE;
229:

Line 242: csd_gen_utility_pvt.add('CSD_REPAIR_ESTIMATE_LINES_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);

238: End If;
239: CLOSE C;
240:
241: IF l_debug > 0 THEN
242: csd_gen_utility_pvt.add('CSD_REPAIR_ESTIMATE_LINES_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);
243: csd_gen_utility_pvt.add('CSD_REPAIR_ESTIMATE_LINES_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);
244: END IF;
245:
246: IF (recinfo.object_version_number = p_OBJECT_VERSION_NUMBER)

Line 243: csd_gen_utility_pvt.add('CSD_REPAIR_ESTIMATE_LINES_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);

239: CLOSE C;
240:
241: IF l_debug > 0 THEN
242: csd_gen_utility_pvt.add('CSD_REPAIR_ESTIMATE_LINES_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);
243: csd_gen_utility_pvt.add('CSD_REPAIR_ESTIMATE_LINES_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);
244: END IF;
245:
246: IF (recinfo.object_version_number = p_OBJECT_VERSION_NUMBER)
247: THEN

Line 257: End CSD_REPAIR_ESTIMATE_LINES_PKG;

253:
254: END Lock_Row;
255:
256:
257: End CSD_REPAIR_ESTIMATE_LINES_PKG;