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 BODY CN_CALC_SQL_EXPS_PKG AS

1: PACKAGE BODY CN_CALC_SQL_EXPS_PKG AS
2: /* $Header: cntcexpb.pls 120.2 2005/07/14 22:33:54 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 BODY CN_CALC_SQL_EXPS_PKG AS
2: /* $Header: cntcexpb.pls 120.2 2005/07/14 22:33:54 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: cntcexpb.pls 120.2 2005/07/14 22:33:54 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: ) is

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: ) is
40: cursor C is select calc_sql_exp_id from CN_CALC_SQL_EXPS

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: ) is
40: cursor C is select calc_sql_exp_id from CN_CALC_SQL_EXPS
41: where CALC_SQL_EXP_ID = x_calc_sql_exp_id;

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: ) is
40: cursor C is select calc_sql_exp_id from CN_CALC_SQL_EXPS
41: where CALC_SQL_EXP_ID = x_calc_sql_exp_id;
42: CURSOR id IS SELECT cn_calc_sql_exps_s.NEXTVAL FROM dual;

Line 40: cursor C is select calc_sql_exp_id from CN_CALC_SQL_EXPS

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: ) is
40: cursor C is select calc_sql_exp_id from CN_CALC_SQL_EXPS
41: where CALC_SQL_EXP_ID = x_calc_sql_exp_id;
42: CURSOR id IS SELECT cn_calc_sql_exps_s.NEXTVAL FROM dual;
43:
44: x_return_status VARCHAR2(4000);

Line 42: CURSOR id IS SELECT cn_calc_sql_exps_s.NEXTVAL FROM dual;

38: X_OBJECT_VERSION_NUMBER OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE
39: ) is
40: cursor C is select calc_sql_exp_id from CN_CALC_SQL_EXPS
41: where CALC_SQL_EXP_ID = x_calc_sql_exp_id;
42: CURSOR id IS SELECT cn_calc_sql_exps_s.NEXTVAL FROM dual;
43:
44: x_return_status VARCHAR2(4000);
45: l_note_msg VARCHAR2(4000);
46: x_msg_data VARCHAR2(4000);

Line 64: insert into CN_CALC_SQL_EXPS (

60: END IF;
61:
62: X_OBJECT_VERSION_NUMBER := 0;
63:
64: insert into CN_CALC_SQL_EXPS (
65: ORG_ID,
66: CALC_SQL_EXP_ID,
67: NAME,
68: DESCRIPTION,

Line 145: p_source_object_code => 'CN_CALC_SQL_EXPS',

141: x_return_status => x_return_status,
142: x_msg_count => x_msg_count,
143: x_msg_data => x_msg_data,
144: p_source_object_id => X_CALC_SQL_EXP_ID,
145: p_source_object_code => 'CN_CALC_SQL_EXPS',
146: p_notes => l_note_msg,
147: p_notes_detail => l_note_msg,
148: p_note_type => 'CN_SYSGEN',
149: x_jtf_note_id => x_note_id

Line 155: P_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

151:
152: end INSERT_ROW;
153:
154: procedure LOCK_ROW (
155: P_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
156: P_OBJECT_VERSION_NUMBER IN CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE) IS
157:
158: cursor c is
159: select object_version_number

Line 156: P_OBJECT_VERSION_NUMBER IN CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE) IS

152: end INSERT_ROW;
153:
154: procedure LOCK_ROW (
155: P_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
156: P_OBJECT_VERSION_NUMBER IN CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE) IS
157:
158: cursor c is
159: select object_version_number
160: from cn_calc_sql_exps

Line 160: from cn_calc_sql_exps

156: P_OBJECT_VERSION_NUMBER IN CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE) IS
157:
158: cursor c is
159: select object_version_number
160: from cn_calc_sql_exps
161: where calc_sql_exp_id = p_calc_sql_exp_id
162: for update of CALC_SQL_EXP_ID nowait;
163:
164: tlinfo c%rowtype ;

Line 185: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,

181:
182: END LOCK_ROW;
183:
184: procedure UPDATE_ROW (
185: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
186: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
187: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
188: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
189: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,

Line 186: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

182: END LOCK_ROW;
183:
184: procedure UPDATE_ROW (
185: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
186: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
187: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
188: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
189: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,
190: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := CN_API.G_MISS_CHAR,

Line 187: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,

183:
184: procedure UPDATE_ROW (
185: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
186: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
187: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
188: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
189: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,
190: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := CN_API.G_MISS_CHAR,
191: X_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,

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

184: procedure UPDATE_ROW (
185: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
186: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
187: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
188: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
189: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,
190: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := CN_API.G_MISS_CHAR,
191: X_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
192: X_SQL_SELECT IN VARCHAR2 := CN_API.G_MISS_CHAR,

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

185: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
186: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
187: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
188: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
189: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,
190: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := CN_API.G_MISS_CHAR,
191: X_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
192: X_SQL_SELECT IN VARCHAR2 := CN_API.G_MISS_CHAR,
193: X_SQL_FROM IN VARCHAR2 := CN_API.G_MISS_CHAR,

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

186: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
187: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
188: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
189: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,
190: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := CN_API.G_MISS_CHAR,
191: X_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
192: X_SQL_SELECT IN VARCHAR2 := CN_API.G_MISS_CHAR,
193: X_SQL_FROM IN VARCHAR2 := CN_API.G_MISS_CHAR,
194: X_PIPED_SQL_SELECT IN VARCHAR2 := CN_API.G_MISS_CHAR,

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

193: X_SQL_FROM IN VARCHAR2 := CN_API.G_MISS_CHAR,
194: X_PIPED_SQL_SELECT IN VARCHAR2 := CN_API.G_MISS_CHAR,
195: X_PIPED_SQL_FROM IN VARCHAR2 := CN_API.G_MISS_CHAR,
196: X_PIPED_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
197: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
198: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,

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

194: X_PIPED_SQL_SELECT IN VARCHAR2 := CN_API.G_MISS_CHAR,
195: X_PIPED_SQL_FROM IN VARCHAR2 := CN_API.G_MISS_CHAR,
196: X_PIPED_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
197: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
198: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,

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

195: X_PIPED_SQL_FROM IN VARCHAR2 := CN_API.G_MISS_CHAR,
196: X_PIPED_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
197: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
198: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,

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

196: X_PIPED_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
197: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
198: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,

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

197: X_ATTRIBUTE_CATEGORY IN CN_CALC_SQL_EXPS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
198: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,

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

198: X_ATTRIBUTE1 IN CN_CALC_SQL_EXPS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,

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

199: X_ATTRIBUTE2 IN CN_CALC_SQL_EXPS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,

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

200: X_ATTRIBUTE3 IN CN_CALC_SQL_EXPS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,

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

201: X_ATTRIBUTE4 IN CN_CALC_SQL_EXPS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,

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

202: X_ATTRIBUTE5 IN CN_CALC_SQL_EXPS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,

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

203: X_ATTRIBUTE6 IN CN_CALC_SQL_EXPS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,

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

204: X_ATTRIBUTE7 IN CN_CALC_SQL_EXPS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,

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

205: X_ATTRIBUTE8 IN CN_CALC_SQL_EXPS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
213: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,

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

206: X_ATTRIBUTE9 IN CN_CALC_SQL_EXPS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
213: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
214: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

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

207: X_ATTRIBUTE10 IN CN_CALC_SQL_EXPS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
213: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
214: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
215: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,

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

208: X_ATTRIBUTE11 IN CN_CALC_SQL_EXPS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
213: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
214: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
215: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
216: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE) IS

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

209: X_ATTRIBUTE12 IN CN_CALC_SQL_EXPS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
213: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
214: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
215: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
216: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE) IS
217:

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

210: X_ATTRIBUTE13 IN CN_CALC_SQL_EXPS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
213: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
214: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
215: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
216: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE) IS
217:
218: BEGIN

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

211: X_ATTRIBUTE14 IN CN_CALC_SQL_EXPS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
213: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
214: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
215: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
216: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE) IS
217:
218: BEGIN
219:

Line 216: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE) IS

212: X_ATTRIBUTE15 IN CN_CALC_SQL_EXPS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
213: X_LAST_UPDATE_DATE IN CN_CALC_SQL_EXPS.LAST_UPDATE_DATE%TYPE := SYSDATE,
214: X_LAST_UPDATED_BY IN CN_CALC_SQL_EXPS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
215: X_LAST_UPDATE_LOGIN IN CN_CALC_SQL_EXPS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
216: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE) IS
217:
218: BEGIN
219:
220: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;

Line 222: update CN_CALC_SQL_EXPS set

218: BEGIN
219:
220: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
221:
222: update CN_CALC_SQL_EXPS set
223: NAME = Decode(X_NAME, fnd_api.g_miss_char, name, x_name),
224: DESCRIPTION = Decode(X_DESCRIPTION, fnd_api.g_miss_char, description, x_description),
225: STATUS = Decode(X_STATUS, fnd_api.g_miss_char, status, x_status),
226: EXP_TYPE_CODE = Decode(X_EXP_TYPE_CODE, fnd_api.g_miss_char, exp_type_code, x_exp_type_code),

Line 261: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE) is

257: end if;
258: end UPDATE_ROW;
259:
260: procedure DELETE_ROW (
261: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE) is
262: begin
263: delete from CN_CALC_SQL_EXPS
264: where CALC_SQL_EXP_ID = X_CALC_SQL_EXP_ID;
265:

Line 263: delete from CN_CALC_SQL_EXPS

259:
260: procedure DELETE_ROW (
261: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE) is
262: begin
263: delete from CN_CALC_SQL_EXPS
264: where CALC_SQL_EXP_ID = X_CALC_SQL_EXP_ID;
265:
266: if (sql%notfound) then
267: fnd_message.set_name('CN', 'CN_RECORD_DELETED');

Line 274: end CN_CALC_SQL_EXPS_PKG;

270: end if;
271:
272: end DELETE_ROW;
273:
274: end CN_CALC_SQL_EXPS_PKG;