7: X_ROLE_PAY_GROUP_ID IN OUT NOCOPY NUMBER, -- required
8: X_ROLE_ID IN NUMBER, -- required
9: X_PAY_GROUP_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_PAY_GROUP_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_PAY_GROUP_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: X_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
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: X_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
34: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER);
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: X_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
34: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER);
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: X_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
34: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER);
35:
36: procedure DELETE_ROW (X_ROLE_PAY_GROUP_ID IN NUMBER);
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: X_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
34: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER);
35:
36: procedure DELETE_ROW (X_ROLE_PAY_GROUP_ID IN NUMBER);
37: