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_MODEL_RESOURCES_PKG dependencies on FND_API

Line 5: (P_MODEL_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,

1: PACKAGE BODY cn_model_resources_pkg AS
2: /*$Header: cntmlrsb.pls 115.2 2002/01/28 20:04:51 pkm ship $*/
3:
4: PROCEDURE insert_row
5: (P_MODEL_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
6: P_RESOURCE_ID IN NUMBER,
7: P_NAME IN VARCHAR2,
8: P_SRP_ID IN NUMBER,
9: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 9: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

5: (P_MODEL_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
6: P_RESOURCE_ID IN NUMBER,
7: P_NAME IN VARCHAR2,
8: P_SRP_ID IN NUMBER,
9: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
10: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 10: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

6: P_RESOURCE_ID IN NUMBER,
7: P_NAME IN VARCHAR2,
8: P_SRP_ID IN NUMBER,
9: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
10: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 11: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

7: P_NAME IN VARCHAR2,
8: P_SRP_ID IN NUMBER,
9: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
10: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 12: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

8: P_SRP_ID IN NUMBER,
9: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
10: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 13: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

9: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
10: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 14: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

10: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 15: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

11: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 16: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

12: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 17: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

13: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 18: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

14: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 19: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

15: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 20: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

16: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)

Line 21: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

17: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
25: IS

Line 22: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

18: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
25: IS
26: MN NUMBER := FND_API.G_MISS_NUM;

Line 23: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

19: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
25: IS
26: MN NUMBER := FND_API.G_MISS_NUM;
27: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;

Line 24: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)

20: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
25: IS
26: MN NUMBER := FND_API.G_MISS_NUM;
27: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
28: MD DATE := FND_API.G_MISS_DATE;

Line 26: MN NUMBER := FND_API.G_MISS_NUM;

22: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
25: IS
26: MN NUMBER := FND_API.G_MISS_NUM;
27: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
28: MD DATE := FND_API.G_MISS_DATE;
29:
30: BEGIN

Line 27: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;

23: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
25: IS
26: MN NUMBER := FND_API.G_MISS_NUM;
27: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
28: MD DATE := FND_API.G_MISS_DATE;
29:
30: BEGIN
31:

Line 28: MD DATE := FND_API.G_MISS_DATE;

24: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR)
25: IS
26: MN NUMBER := FND_API.G_MISS_NUM;
27: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
28: MD DATE := FND_API.G_MISS_DATE;
29:
30: BEGIN
31:
32: INSERT INTO cn_model_resources(

Line 96: P_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,

92:
93:
94: PROCEDURE Update_Row
95: (P_MODEL_RESOURCE_ID IN NUMBER,
96: P_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
97: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
99: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 97: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,

93:
94: PROCEDURE Update_Row
95: (P_MODEL_RESOURCE_ID IN NUMBER,
96: P_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
97: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
99: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 98: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,

94: PROCEDURE Update_Row
95: (P_MODEL_RESOURCE_ID IN NUMBER,
96: P_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
97: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
99: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 99: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

95: (P_MODEL_RESOURCE_ID IN NUMBER,
96: P_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
97: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
99: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 100: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

96: P_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
97: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
99: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 101: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

97: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
99: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 102: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

98: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
99: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 103: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

99: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 104: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

100: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 105: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

101: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 106: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

102: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 107: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

103: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 108: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

104: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 109: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

105: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 110: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

106: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 111: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

107: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM )

Line 112: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

108: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM )
116: IS

Line 113: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

109: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM )
116: IS
117:

Line 114: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

110: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM )
116: IS
117:
118: CURSOR l_old_csr IS

Line 115: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM )

111: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM )
116: IS
117:
118: CURSOR l_old_csr IS
119: SELECT *

Line 125: MN NUMBER := FND_API.G_MISS_NUM;

121: WHERE model_resource_id = p_model_resource_id;
122:
123: l_old_rec l_old_csr%ROWTYPE;
124:
125: MN NUMBER := FND_API.G_MISS_NUM;
126: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
127: MD DATE := FND_API.G_MISS_DATE;
128:
129: l_object_version_number NUMBER;

Line 126: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;

122:
123: l_old_rec l_old_csr%ROWTYPE;
124:
125: MN NUMBER := FND_API.G_MISS_NUM;
126: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
127: MD DATE := FND_API.G_MISS_DATE;
128:
129: l_object_version_number NUMBER;
130:

Line 127: MD DATE := FND_API.G_MISS_DATE;

123: l_old_rec l_old_csr%ROWTYPE;
124:
125: MN NUMBER := FND_API.G_MISS_NUM;
126: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
127: MD DATE := FND_API.G_MISS_DATE;
128:
129: l_object_version_number NUMBER;
130:
131: BEGIN

Line 146: raise fnd_api.g_exc_error;

142: -- check object version number
143: IF l_object_version_number <> l_old_rec.object_version_number THEN
144: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
145: fnd_msg_pub.add;
146: raise fnd_api.g_exc_error;
147: END IF;
148:
149: UPDATE cn_model_resources SET
150: (resource_id,