APPS.EAM_CONSTRUCTION_ESTIMATES_PKG dependencies on EAM_CONSTRUCTION_ESTIMATES

Line 1: PACKAGE BODY EAM_CONSTRUCTION_ESTIMATES_PKG AS

1: PACKAGE BODY EAM_CONSTRUCTION_ESTIMATES_PKG AS
2: /* $Header: EAMTCESB.pls 120.1.12020000.2 2012/11/01 20:10:59 devijay ship $ */
3: -- Start of Comments
4: -- Package name : EAM_CONSTRUCTION_ESTIMATES_PKG
5: -- Purpose : Body of package EAM_CONSTRUCTION_ESTIMATES_PKG

Line 4: -- Package name : EAM_CONSTRUCTION_ESTIMATES_PKG

1: PACKAGE BODY EAM_CONSTRUCTION_ESTIMATES_PKG AS
2: /* $Header: EAMTCESB.pls 120.1.12020000.2 2012/11/01 20:10:59 devijay ship $ */
3: -- Start of Comments
4: -- Package name : EAM_CONSTRUCTION_ESTIMATES_PKG
5: -- Purpose : Body of package EAM_CONSTRUCTION_ESTIMATES_PKG
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 5: -- Purpose : Body of package EAM_CONSTRUCTION_ESTIMATES_PKG

1: PACKAGE BODY EAM_CONSTRUCTION_ESTIMATES_PKG AS
2: /* $Header: EAMTCESB.pls 120.1.12020000.2 2012/11/01 20:10:59 devijay ship $ */
3: -- Start of Comments
4: -- Package name : EAM_CONSTRUCTION_ESTIMATES_PKG
5: -- Purpose : Body of package EAM_CONSTRUCTION_ESTIMATES_PKG
6: -- History :
7: -- NOTE :
8: -- End of Comments
9:

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'EAM_CONSTRUCTION_ESTIMATES_PKG';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'EAM_CONSTRUCTION_ESTIMATES_PKG';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EAMTCESB.pls';
12:
13: PROCEDURE INSERT_ROW(
14: px_ESTIMATE_ID IN OUT NOCOPY NUMBER,

Line 44: CURSOR C IS SELECT EAM_CONSTRUCTION_ESTIMATES_S.NEXTVAL FROM SYS.DUAL;

40: p_ATTRIBUTE14 VARCHAR2,
41: p_ATTRIBUTE15 VARCHAR2
42: )
43: IS
44: CURSOR C IS SELECT EAM_CONSTRUCTION_ESTIMATES_S.NEXTVAL FROM SYS.DUAL;
45: BEGIN
46: IF (px_ESTIMATE_ID IS NULL) OR (px_ESTIMATE_ID = FND_API.G_MISS_NUM) THEN
47: OPEN C;
48: FETCH C INTO px_ESTIMATE_ID;

Line 51: INSERT INTO EAM_CONSTRUCTION_ESTIMATES(

47: OPEN C;
48: FETCH C INTO px_ESTIMATE_ID;
49: CLOSE C;
50: END IF;
51: INSERT INTO EAM_CONSTRUCTION_ESTIMATES(
52: ESTIMATE_ID,
53: ORGANIZATION_ID,
54: ESTIMATE_NUMBER,
55: ESTIMATE_DESCRIPTION,

Line 144: UPDATE EAM_CONSTRUCTION_ESTIMATES

140: p_ATTRIBUTE15 VARCHAR2
141: )
142: IS
143: BEGIN
144: UPDATE EAM_CONSTRUCTION_ESTIMATES
145: SET ORGANIZATION_ID = decode(p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
146: ESTIMATE_NUMBER = decode(p_ESTIMATE_NUMBER, FND_API.G_MISS_CHAR, ESTIMATE_NUMBER, p_ESTIMATE_NUMBER),
147: ESTIMATE_DESCRIPTION = decode(p_ESTIMATE_DESCRIPTION, FND_API.G_MISS_CHAR, ESTIMATE_DESCRIPTION, p_ESTIMATE_DESCRIPTION),
148: GROUPING_OPTION = decode(p_GROUPING_OPTION, FND_API.G_MISS_NUM, GROUPING_OPTION, p_GROUPING_OPTION),

Line 212: FROM EAM_CONSTRUCTION_ESTIMATES

208: )
209: IS
210: CURSOR C IS
211: SELECT *
212: FROM EAM_CONSTRUCTION_ESTIMATES
213: WHERE ESTIMATE_ID = p_ESTIMATE_ID
214: FOR UPDATE OF ESTIMATE_ID NOWAIT;
215: Recinfo C%ROWTYPE;
216: BEGIN

Line 252: DELETE FROM EAM_CONSTRUCTION_ESTIMATES

248: p_ESTIMATE_ID NUMBER
249: )
250: IS
251: BEGIN
252: DELETE FROM EAM_CONSTRUCTION_ESTIMATES
253: WHERE ESTIMATE_ID = p_ESTIMATE_ID;
254:
255: IF (SQL%NOTFOUND) THEN
256: RAISE NO_DATA_FOUND;

Line 260: END EAM_CONSTRUCTION_ESTIMATES_PKG;

256: RAISE NO_DATA_FOUND;
257: END IF;
258: END DELETE_ROW;
259:
260: END EAM_CONSTRUCTION_ESTIMATES_PKG;