eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_CALC_SQL_EXPS_PKG dependencies on CN_CALC_SQL_EXPS

Line 1: PACKAGE CN_CALC_SQL_EXPS_PKG AS

1: PACKAGE CN_CALC_SQL_EXPS_PKG AS
2: /* $Header: cntcexps.pls 120.2 2005/07/14 22:33:16 kjayapau ship $ */
3:
4: procedure INSERT_ROW (
5: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,

Line 5: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,

1: PACKAGE CN_CALC_SQL_EXPS_PKG AS
2: /* $Header: cntcexps.pls 120.2 2005/07/14 22:33:16 kjayapau ship $ */
3:
4: procedure INSERT_ROW (
5: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
6: X_CALC_SQL_EXP_ID IN OUT NOCOPY CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
7: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
8: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
9: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := NULL,

Line 6: X_CALC_SQL_EXP_ID IN OUT NOCOPY CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

2: /* $Header: cntcexps.pls 120.2 2005/07/14 22:33:16 kjayapau ship $ */
3:
4: procedure INSERT_ROW (
5: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
6: X_CALC_SQL_EXP_ID IN OUT NOCOPY CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
7: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
8: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
9: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := NULL,
10: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := NULL,

Line 7: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,

3:
4: procedure INSERT_ROW (
5: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
6: X_CALC_SQL_EXP_ID IN OUT NOCOPY CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
7: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
8: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
9: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := NULL,
10: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := NULL,
11: X_EXPRESSION_DISP IN VARCHAR2 := NULL, -- CLOBs

Line 8: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,

4: procedure INSERT_ROW (
5: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
6: X_CALC_SQL_EXP_ID IN OUT NOCOPY CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
7: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
8: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
9: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := NULL,
10: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := NULL,
11: X_EXPRESSION_DISP IN VARCHAR2 := NULL, -- CLOBs
12: X_SQL_SELECT IN VARCHAR2 := NULL,

Line 9: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := NULL,

5: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
6: X_CALC_SQL_EXP_ID IN OUT NOCOPY CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
7: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
8: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
9: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := NULL,
10: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := NULL,
11: X_EXPRESSION_DISP IN VARCHAR2 := NULL, -- CLOBs
12: X_SQL_SELECT IN VARCHAR2 := NULL,
13: X_SQL_FROM IN VARCHAR2 := NULL,

Line 10: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := NULL,

6: X_CALC_SQL_EXP_ID IN OUT NOCOPY CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
7: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
8: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
9: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := NULL,
10: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := NULL,
11: X_EXPRESSION_DISP IN VARCHAR2 := NULL, -- CLOBs
12: X_SQL_SELECT IN VARCHAR2 := NULL,
13: X_SQL_FROM IN VARCHAR2 := NULL,
14: X_PIPED_SQL_SELECT IN VARCHAR2 := NULL,

Line 17: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := NULL,

13: X_SQL_FROM IN VARCHAR2 := NULL,
14: X_PIPED_SQL_SELECT IN VARCHAR2 := NULL,
15: X_PIPED_SQL_FROM IN VARCHAR2 := NULL,
16: X_PIPED_EXPRESSION_DISP IN VARCHAR2 := NULL,
17: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := NULL,
18: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := NULL,
19: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := NULL,
20: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := NULL,
21: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := NULL,

Line 18: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := NULL,

14: X_PIPED_SQL_SELECT IN VARCHAR2 := NULL,
15: X_PIPED_SQL_FROM IN VARCHAR2 := NULL,
16: X_PIPED_EXPRESSION_DISP IN VARCHAR2 := NULL,
17: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := NULL,
18: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := NULL,
19: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := NULL,
20: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := NULL,
21: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := NULL,
22: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := NULL,

Line 19: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := NULL,

15: X_PIPED_SQL_FROM IN VARCHAR2 := NULL,
16: X_PIPED_EXPRESSION_DISP IN VARCHAR2 := NULL,
17: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := NULL,
18: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := NULL,
19: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := NULL,
20: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := NULL,
21: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := NULL,
22: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := NULL,
23: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := NULL,

Line 20: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := NULL,

16: X_PIPED_EXPRESSION_DISP IN VARCHAR2 := NULL,
17: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := NULL,
18: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := NULL,
19: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := NULL,
20: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := NULL,
21: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := NULL,
22: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := NULL,
23: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := NULL,
24: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := NULL,

Line 21: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := NULL,

17: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := NULL,
18: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := NULL,
19: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := NULL,
20: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := NULL,
21: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := NULL,
22: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := NULL,
23: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := NULL,
24: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := NULL,
25: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := NULL,

Line 22: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := NULL,

18: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := NULL,
19: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := NULL,
20: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := NULL,
21: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := NULL,
22: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := NULL,
23: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := NULL,
24: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := NULL,
25: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := NULL,
26: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := NULL,

Line 23: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := NULL,

19: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := NULL,
20: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := NULL,
21: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := NULL,
22: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := NULL,
23: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := NULL,
24: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := NULL,
25: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := NULL,
26: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := NULL,
27: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := NULL,

Line 24: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := NULL,

20: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := NULL,
21: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := NULL,
22: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := NULL,
23: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := NULL,
24: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := NULL,
25: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := NULL,
26: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := NULL,
27: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := NULL,
28: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := NULL,

Line 25: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := NULL,

21: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := NULL,
22: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := NULL,
23: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := NULL,
24: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := NULL,
25: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := NULL,
26: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := NULL,
27: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := NULL,
28: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := NULL,
29: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := NULL,

Line 26: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := NULL,

22: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := NULL,
23: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := NULL,
24: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := NULL,
25: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := NULL,
26: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := NULL,
27: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := NULL,
28: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := NULL,
29: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := NULL,
30: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := NULL,

Line 27: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := NULL,

23: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := NULL,
24: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := NULL,
25: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := NULL,
26: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := NULL,
27: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := NULL,
28: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := NULL,
29: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := NULL,
30: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := NULL,
31: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := NULL,

Line 28: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := NULL,

24: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := NULL,
25: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := NULL,
26: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := NULL,
27: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := NULL,
28: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := NULL,
29: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := NULL,
30: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := NULL,
31: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := NULL,
32: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := NULL,

Line 29: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := NULL,

25: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := NULL,
26: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := NULL,
27: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := NULL,
28: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := NULL,
29: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := NULL,
30: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := NULL,
31: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := NULL,
32: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := NULL,
33: X_CREATION_DATE IN CN_CALC_SQL_EXPS.CREATION_DATE%TYPE := SYSDATE,

Line 30: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := NULL,

26: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := NULL,
27: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := NULL,
28: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := NULL,
29: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := NULL,
30: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := NULL,
31: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := NULL,
32: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := NULL,
33: X_CREATION_DATE IN CN_CALC_SQL_EXPS.CREATION_DATE%TYPE := SYSDATE,
34: X_CREATED_BY IN CN_CALC_SQL_EXPS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,

Line 31: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := NULL,

27: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := NULL,
28: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := NULL,
29: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := NULL,
30: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := NULL,
31: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := NULL,
32: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := NULL,
33: X_CREATION_DATE IN CN_CALC_SQL_EXPS.CREATION_DATE%TYPE := SYSDATE,
34: X_CREATED_BY IN CN_CALC_SQL_EXPS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,

Line 32: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := NULL,

28: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := NULL,
29: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := NULL,
30: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := NULL,
31: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := NULL,
32: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := NULL,
33: X_CREATION_DATE IN CN_CALC_SQL_EXPS.CREATION_DATE%TYPE := SYSDATE,
34: X_CREATED_BY IN CN_CALC_SQL_EXPS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
36: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

Line 33: X_CREATION_DATE IN CN_CALC_SQL_EXPS.CREATION_DATE%TYPE := SYSDATE,

29: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := NULL,
30: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := NULL,
31: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := NULL,
32: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := NULL,
33: X_CREATION_DATE IN CN_CALC_SQL_EXPS.CREATION_DATE%TYPE := SYSDATE,
34: X_CREATED_BY IN CN_CALC_SQL_EXPS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
36: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
37: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,

Line 34: X_CREATED_BY IN CN_CALC_SQL_EXPS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,

30: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := NULL,
31: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := NULL,
32: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := NULL,
33: X_CREATION_DATE IN CN_CALC_SQL_EXPS.CREATION_DATE%TYPE := SYSDATE,
34: X_CREATED_BY IN CN_CALC_SQL_EXPS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
36: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
37: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
38: X_OBJECT_VERSION_NUMBER OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);

Line 35: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,

31: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := NULL,
32: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := NULL,
33: X_CREATION_DATE IN CN_CALC_SQL_EXPS.CREATION_DATE%TYPE := SYSDATE,
34: X_CREATED_BY IN CN_CALC_SQL_EXPS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
36: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
37: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
38: X_OBJECT_VERSION_NUMBER OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
39:

Line 36: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

32: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := NULL,
33: X_CREATION_DATE IN CN_CALC_SQL_EXPS.CREATION_DATE%TYPE := SYSDATE,
34: X_CREATED_BY IN CN_CALC_SQL_EXPS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
36: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
37: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
38: X_OBJECT_VERSION_NUMBER OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
39:
40: procedure LOCK_ROW (

Line 37: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,

33: X_CREATION_DATE IN CN_CALC_SQL_EXPS.CREATION_DATE%TYPE := SYSDATE,
34: X_CREATED_BY IN CN_CALC_SQL_EXPS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
36: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
37: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
38: X_OBJECT_VERSION_NUMBER OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
39:
40: procedure LOCK_ROW (
41: P_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

Line 38: X_OBJECT_VERSION_NUMBER OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);

34: X_CREATED_BY IN CN_CALC_SQL_EXPS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
36: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
37: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
38: X_OBJECT_VERSION_NUMBER OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
39:
40: procedure LOCK_ROW (
41: P_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
42: P_OBJECT_VERSION_NUMBER IN CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);

Line 41: P_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

37: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
38: X_OBJECT_VERSION_NUMBER OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
39:
40: procedure LOCK_ROW (
41: P_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
42: P_OBJECT_VERSION_NUMBER IN CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
43:
44: procedure UPDATE_ROW (
45: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,

Line 42: P_OBJECT_VERSION_NUMBER IN CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);

38: X_OBJECT_VERSION_NUMBER OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
39:
40: procedure LOCK_ROW (
41: P_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
42: P_OBJECT_VERSION_NUMBER IN CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
43:
44: procedure UPDATE_ROW (
45: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
46: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

Line 45: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,

41: P_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
42: P_OBJECT_VERSION_NUMBER IN CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
43:
44: procedure UPDATE_ROW (
45: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
46: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
47: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
48: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
49: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,

Line 46: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

42: P_OBJECT_VERSION_NUMBER IN CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
43:
44: procedure UPDATE_ROW (
45: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
46: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
47: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
48: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
49: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,
50: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := CN_API.G_MISS_CHAR,

Line 47: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,

43:
44: procedure UPDATE_ROW (
45: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
46: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
47: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
48: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
49: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,
50: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := CN_API.G_MISS_CHAR,
51: X_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,

Line 48: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,

44: procedure UPDATE_ROW (
45: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
46: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
47: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
48: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
49: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,
50: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := CN_API.G_MISS_CHAR,
51: X_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
52: X_SQL_SELECT IN VARCHAR2 := CN_API.G_MISS_CHAR,

Line 49: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,

45: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
46: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
47: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
48: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
49: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,
50: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := CN_API.G_MISS_CHAR,
51: X_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
52: X_SQL_SELECT IN VARCHAR2 := CN_API.G_MISS_CHAR,
53: X_SQL_FROM IN VARCHAR2 := CN_API.G_MISS_CHAR,

Line 50: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := CN_API.G_MISS_CHAR,

46: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
47: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
48: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
49: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,
50: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := CN_API.G_MISS_CHAR,
51: X_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
52: X_SQL_SELECT IN VARCHAR2 := CN_API.G_MISS_CHAR,
53: X_SQL_FROM IN VARCHAR2 := CN_API.G_MISS_CHAR,
54: X_PIPED_SQL_SELECT IN VARCHAR2 := CN_API.G_MISS_CHAR,

Line 57: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,

53: X_SQL_FROM IN VARCHAR2 := CN_API.G_MISS_CHAR,
54: X_PIPED_SQL_SELECT IN VARCHAR2 := CN_API.G_MISS_CHAR,
55: X_PIPED_SQL_FROM IN VARCHAR2 := CN_API.G_MISS_CHAR,
56: X_PIPED_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,

Line 58: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,

54: X_PIPED_SQL_SELECT IN VARCHAR2 := CN_API.G_MISS_CHAR,
55: X_PIPED_SQL_FROM IN VARCHAR2 := CN_API.G_MISS_CHAR,
56: X_PIPED_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,

Line 59: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,

55: X_PIPED_SQL_FROM IN VARCHAR2 := CN_API.G_MISS_CHAR,
56: X_PIPED_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,

Line 60: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,

56: X_PIPED_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,

Line 61: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,

57: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
65: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,

Line 62: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,

58: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
65: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,

Line 63: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,

59: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
65: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,

Line 64: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,

60: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
65: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,

Line 65: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,

61: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
65: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,

Line 66: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,

62: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
65: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,

Line 67: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,

63: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
65: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,

Line 68: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,

64: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
65: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,

Line 69: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,

65: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
73: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,

Line 70: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,

66: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
73: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
74: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

Line 71: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,

67: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
73: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
74: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
75: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,

Line 72: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,

68: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
73: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
74: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
75: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
76: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);

Line 73: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,

69: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
73: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
74: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
75: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
76: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
77:

Line 74: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

70: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
73: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
74: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
75: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
76: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
77:
78: procedure DELETE_ROW (

Line 75: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,

71: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
73: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
74: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
75: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
76: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
77:
78: procedure DELETE_ROW (
79: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE);

Line 76: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);

72: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
73: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
74: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
75: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
76: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
77:
78: procedure DELETE_ROW (
79: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE);
80: end CN_CALC_SQL_EXPS_PKG;

Line 79: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE);

75: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
76: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
77:
78: procedure DELETE_ROW (
79: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE);
80: end CN_CALC_SQL_EXPS_PKG;

Line 80: end CN_CALC_SQL_EXPS_PKG;

76: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
77:
78: procedure DELETE_ROW (
79: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE);
80: end CN_CALC_SQL_EXPS_PKG;