APPS.ASO_QUOTE_LINE_DETAILS_PKG dependencies on ASO_QUOTE_LINE_DETAILS

Line 1: PACKAGE BODY ASO_QUOTE_LINE_DETAILS_PKG as

1: PACKAGE BODY ASO_QUOTE_LINE_DETAILS_PKG as
2: /* $Header: asotldtb.pls 120.1 2005/06/29 12:39:09 appldev ship $ */
3: -- Start of Comments
4: -- Package name : ASO_QUOTE_LINE_DETAILS_PKG
5: -- Purpose :

Line 4: -- Package name : ASO_QUOTE_LINE_DETAILS_PKG

1: PACKAGE BODY ASO_QUOTE_LINE_DETAILS_PKG as
2: /* $Header: asotldtb.pls 120.1 2005/06/29 12:39:09 appldev ship $ */
3: -- Start of Comments
4: -- Package name : ASO_QUOTE_LINE_DETAILS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_QUOTE_LINE_DETAILS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotldtb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_QUOTE_LINE_DETAIL_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 99: CURSOR C2 IS SELECT ASO_QUOTE_LINE_DETAILS_S.nextval FROM sys.dual;

95: p_COMPONENT_SEQUENCE_ID NUMBER
96: )
97:
98: IS
99: CURSOR C2 IS SELECT ASO_QUOTE_LINE_DETAILS_S.nextval FROM sys.dual;
100: BEGIN
101: If (px_QUOTE_LINE_DETAIL_ID IS NULL) OR (px_QUOTE_LINE_DETAIL_ID = FND_API.G_MISS_NUM) then
102: OPEN C2;
103: FETCH C2 INTO px_QUOTE_LINE_DETAIL_ID;

Line 106: INSERT INTO ASO_QUOTE_LINE_DETAILS(

102: OPEN C2;
103: FETCH C2 INTO px_QUOTE_LINE_DETAIL_ID;
104: CLOSE C2;
105: End If;
106: INSERT INTO ASO_QUOTE_LINE_DETAILS(
107: QUOTE_LINE_DETAIL_ID,
108: CREATION_DATE,
109: CREATED_BY,
110: LAST_UPDATE_DATE,

Line 360: Update ASO_QUOTE_LINE_DETAILS

356: )
357:
358: IS
359: BEGIN
360: Update ASO_QUOTE_LINE_DETAILS
361: SET
362: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
363: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
364: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 455: DELETE FROM ASO_QUOTE_LINE_DETAILS

451: PROCEDURE Delete_Row(
452: p_QUOTE_LINE_DETAIL_ID NUMBER)
453: IS
454: BEGIN
455: DELETE FROM ASO_QUOTE_LINE_DETAILS
456: WHERE QUOTE_LINE_DETAIL_ID = p_QUOTE_LINE_DETAIL_ID;
457: If (SQL%NOTFOUND) then
458: RAISE NO_DATA_FOUND;
459: End If;

Line 466: DELETE FROM ASO_QUOTE_LINE_DETAILS

462: PROCEDURE Delete_Row(
463: p_QUOTE_LINE_ID NUMBER)
464: IS
465: BEGIN
466: DELETE FROM ASO_QUOTE_LINE_DETAILS
467: WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID;
468: If (SQL%NOTFOUND) then
469: RAISE NO_DATA_FOUND;
470: End If;

Line 610: FROM ASO_QUOTE_LINE_DETAILS

606: RETURN_REASON_CODE,
607: ATTRIBUTE1,
608: ATTRIBUTE2,
609: ATTRIBUTE3
610: FROM ASO_QUOTE_LINE_DETAILS
611: WHERE QUOTE_LINE_DETAIL_ID = p_QUOTE_LINE_DETAIL_ID
612: FOR UPDATE of QUOTE_LINE_DETAIL_ID NOWAIT;
613: Recinfo C%ROWTYPE;
614: BEGIN

Line 838: End ASO_QUOTE_LINE_DETAILS_PKG;

834: APP_EXCEPTION.RAISE_EXCEPTION;
835: End If;
836: END Lock_Row;
837:
838: End ASO_QUOTE_LINE_DETAILS_PKG;