7: X_ROLE_PLAN_ID IN NUMBER, -- required
8: X_ROLE_ID IN NUMBER, -- required
9: X_COMP_PLAN_ID IN NUMBER, -- required
10: X_START_DATE IN DATE, -- required
11: X_END_DATE IN DATE := FND_API.G_MISS_DATE,
12: X_CREATE_MODULE IN VARCHAR2 := 'OSC',
13: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
9: X_COMP_PLAN_ID IN NUMBER, -- required
10: X_START_DATE IN DATE, -- required
11: X_END_DATE IN DATE := FND_API.G_MISS_DATE,
12: X_CREATE_MODULE IN VARCHAR2 := 'OSC',
13: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
10: X_START_DATE IN DATE, -- required
11: X_END_DATE IN DATE := FND_API.G_MISS_DATE,
12: X_CREATE_MODULE IN VARCHAR2 := 'OSC',
13: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: X_END_DATE IN DATE := FND_API.G_MISS_DATE,
12: X_CREATE_MODULE IN VARCHAR2 := 'OSC',
13: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: X_CREATE_MODULE IN VARCHAR2 := 'OSC',
13: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
22: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
23: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
31: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
24: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
31: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
32: X_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
25: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
31: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
32: X_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: X_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
26: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
31: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
32: X_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: X_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
34: X_ORG_ID IN NUMBER,
27: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
31: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
32: X_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: X_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
34: X_ORG_ID IN NUMBER,
35: X_OBJECT_VERSION_NUMBER IN NUMBER);
28: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
31: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
32: X_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: X_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
34: X_ORG_ID IN NUMBER,
35: X_OBJECT_VERSION_NUMBER IN NUMBER);
36:
29: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
31: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
32: X_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: X_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
34: X_ORG_ID IN NUMBER,
35: X_OBJECT_VERSION_NUMBER IN NUMBER);
36:
37: procedure UPDATE_ROW
39: X_ROLE_PLAN_ID IN NUMBER, -- required
40: X_ROLE_ID IN NUMBER,
41: X_COMP_PLAN_ID IN NUMBER,
42: X_START_DATE IN DATE,
43: X_END_DATE IN DATE := FND_API.G_MISS_DATE,
44: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: X_ROLE_ID IN NUMBER,
41: X_COMP_PLAN_ID IN NUMBER,
42: X_START_DATE IN DATE,
43: X_END_DATE IN DATE := FND_API.G_MISS_DATE,
44: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: X_COMP_PLAN_ID IN NUMBER,
42: X_START_DATE IN DATE,
43: X_END_DATE IN DATE := FND_API.G_MISS_DATE,
44: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: X_START_DATE IN DATE,
43: X_END_DATE IN DATE := FND_API.G_MISS_DATE,
44: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: X_END_DATE IN DATE := FND_API.G_MISS_DATE,
44: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: X_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: X_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: X_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: X_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: X_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: X_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: X_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
53: X_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
61: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
54: X_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
61: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
62: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
55: X_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
61: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
62: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
63: X_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
56: X_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
61: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
62: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
63: X_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
64: X_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
57: X_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
61: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
62: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
63: X_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
64: X_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
65: X_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
58: X_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
61: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
62: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
63: X_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
64: X_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
65: X_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
66: X_ORG_ID IN NUMBER);
59: X_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
61: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
62: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
63: X_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
64: X_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
65: X_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
66: X_ORG_ID IN NUMBER);
67:
60: X_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
61: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
62: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
63: X_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
64: X_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
65: X_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
66: X_ORG_ID IN NUMBER);
67:
68: procedure LOCK_ROW (X_ROLE_PLAN_ID IN NUMBER);
61: X_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
62: X_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
63: X_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
64: X_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
65: X_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
66: X_ORG_ID IN NUMBER);
67:
68: procedure LOCK_ROW (X_ROLE_PLAN_ID IN NUMBER);
69: