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