APPS.CSD_AHL_W_CONTRACT_XREF_PKG dependencies on CSD_AHL_W_CONTRACT_XREF

Line 1: PACKAGE BODY CSD_AHL_W_CONTRACT_XREF_PKG as

1: PACKAGE BODY CSD_AHL_W_CONTRACT_XREF_PKG as
2: /* $Header: csdtawcb.pls 120.2 2011/07/12 00:11:24 yvchen noship $ */
3: -- Start of Comments
4: -- Package name : CSD_AHL_W_CONTRACT_XREF_PKG
5: -- Purpose :

Line 4: -- Package name : CSD_AHL_W_CONTRACT_XREF_PKG

1: PACKAGE BODY CSD_AHL_W_CONTRACT_XREF_PKG as
2: /* $Header: csdtawcb.pls 120.2 2011/07/12 00:11:24 yvchen noship $ */
3: -- Start of Comments
4: -- Package name : CSD_AHL_W_CONTRACT_XREF_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 46: CURSOR C2 IS SELECT CSD_AHL_W_CONTRACT_XREF_S1.nextval FROM sys.dual;

42: ,p_REPAIR_LINE_ID NUMBER
43: ,p_INSTANCE_ID NUMBER) --yvchen
44:
45: IS
46: CURSOR C2 IS SELECT CSD_AHL_W_CONTRACT_XREF_S1.nextval FROM sys.dual;
47: BEGIN
48: If (px_WARRANTY_CONTRACT_XREF_ID IS NULL) OR (px_WARRANTY_CONTRACT_XREF_ID = FND_API.G_MISS_NUM) then
49: OPEN C2;
50: FETCH C2 INTO px_WARRANTY_CONTRACT_XREF_ID;

Line 53: INSERT INTO CSD_AHL_W_CONTRACT_XREF(

49: OPEN C2;
50: FETCH C2 INTO px_WARRANTY_CONTRACT_XREF_ID;
51: CLOSE C2;
52: End If;
53: INSERT INTO CSD_AHL_W_CONTRACT_XREF(
54: WARRANTY_CONTRACT_XREF_ID
55: ,OBJECT_VERSION_NUMBER
56: ,CREATED_BY
57: ,CREATION_DATE

Line 152: Update CSD_AHL_W_CONTRACT_XREF

148: ,p_INSTANCE_ID NUMBER) --yvchen
149:
150: IS
151: BEGIN
152: Update CSD_AHL_W_CONTRACT_XREF
153: SET
154: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
155: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
156: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 196: DELETE FROM CSD_AHL_W_CONTRACT_XREF

192: PROCEDURE Delete_Row(
193: p_WARRANTY_CONTRACT_XREF_ID NUMBER)
194: IS
195: BEGIN
196: DELETE FROM CSD_AHL_W_CONTRACT_XREF
197: WHERE WARRANTY_CONTRACT_XREF_ID = p_WARRANTY_CONTRACT_XREF_ID;
198: If (SQL%NOTFOUND) then
199: RAISE NO_DATA_FOUND;
200: End If;

Line 241: FROM CSD_AHL_W_CONTRACT_XREF

237:
238: IS
239: CURSOR C IS
240: SELECT *
241: FROM CSD_AHL_W_CONTRACT_XREF
242: WHERE WARRANTY_CONTRACT_XREF_ID = p_WARRANTY_CONTRACT_XREF_ID
243: FOR UPDATE of WARRANTY_CONTRACT_XREF_ID NOWAIT;
244: Recinfo C%ROWTYPE;
245: BEGIN

Line 348: End CSD_AHL_W_CONTRACT_XREF_PKG;

344: APP_EXCEPTION.RAISE_EXCEPTION;
345: End If;
346: END Lock_Row;
347:
348: End CSD_AHL_W_CONTRACT_XREF_PKG;