1 PACKAGE cn_role_models_pkg AUTHID CURRENT_USER AS
2 /*$Header: cntrlmls.pls 115.2 2002/01/28 20:05:33 pkm ship $*/
3
4 PROCEDURE insert_row
5 (P_ROLE_MODEL_ID IN NUMBER := FND_API.G_MISS_NUM,
6 P_ROLE_ID IN NUMBER,
7 P_NAME IN VARCHAR2,
8 P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
9 P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
10 P_STATUS IN VARCHAR2,
11 P_ACTIVATE_STATUS IN VARCHAR2,
12 P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
13 P_OTE IN NUMBER := FND_API.G_MISS_NUM,
14 P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
15 P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
16 P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
17 P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
18 P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
19 P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
20 P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
21 P_START_DATE IN DATE,
22 P_END_DATE IN DATE := FND_API.G_MISS_DATE,
23 P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
24 P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
25 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
26 P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27 P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28 P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29 P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30 P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31 P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32 P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33 P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34 P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35 P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36 P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37 P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38 P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39 P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40 P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR);
41
42 PROCEDURE update_row
43 (P_ROLE_MODEL_ID IN NUMBER,
44 P_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
45 P_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
46 P_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
47 P_SEQ IN NUMBER := FND_API.G_MISS_NUM,
48 P_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
49 P_ACTIVATE_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
50 P_CLUB_ELIGIBLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
51 P_OTE IN NUMBER := FND_API.G_MISS_NUM,
52 P_ROUNDING_FACTOR IN NUMBER := FND_API.G_MISS_NUM,
53 P_ATTAIN_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
54 P_PLAN_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
55 P_QUOTA_MIN IN NUMBER := FND_API.G_MISS_NUM,
56 P_QUOTA_MAX IN NUMBER := FND_API.G_MISS_NUM,
57 P_ESTIMATED_PAYOUT IN NUMBER := FND_API.G_MISS_NUM,
58 P_SRP_ROLE_ID IN NUMBER := FND_API.G_MISS_NUM,
59 P_START_DATE IN DATE := FND_API.G_MISS_DATE,
60 P_END_DATE IN DATE := FND_API.G_MISS_DATE,
61 P_SCENARIO_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
62 P_SRP_ID IN NUMBER := FND_API.G_MISS_NUM,
63 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
64 P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65 P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66 P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67 P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68 P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69 P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70 P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71 P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72 P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73 P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74 P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75 P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76 P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77 P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78 P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79 P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM );
80
81 PROCEDURE delete_row
82 (P_ROLE_MODEL_ID IN NUMBER);
83
84 END cn_role_models_pkg;