1: PACKAGE cn_model_resources_pkg AUTHID CURRENT_USER AS
2: /*$Header: cntmlrss.pls 115.2 2002/01/28 20:04:52 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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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:
26: PROCEDURE update_row
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:
26: PROCEDURE update_row
27: (P_MODEL_RESOURCE_ID IN NUMBER,
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:
26: PROCEDURE update_row
27: (P_MODEL_RESOURCE_ID IN NUMBER,
28: P_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
24: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR);
25:
26: PROCEDURE update_row
27: (P_MODEL_RESOURCE_ID IN NUMBER,
28: P_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
29: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
31: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
25:
26: PROCEDURE update_row
27: (P_MODEL_RESOURCE_ID IN NUMBER,
28: P_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
29: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
31: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: PROCEDURE update_row
27: (P_MODEL_RESOURCE_ID IN NUMBER,
28: P_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
29: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
31: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: (P_MODEL_RESOURCE_ID IN NUMBER,
28: P_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
29: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
31: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: P_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
29: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
31: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
31: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
31: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM );
40: P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM );
48:
41: P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM );
48:
49: PROCEDURE delete_row
42: P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM );
48:
49: PROCEDURE delete_row
50: (P_MODEL_RESOURCE_ID IN NUMBER);
43: P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM );
48:
49: PROCEDURE delete_row
50: (P_MODEL_RESOURCE_ID IN NUMBER);
51: