95: --
96: -- -------------------------------------------------------------------------+
97: PROCEDURE UPDATE_ROW
98: (X_SRP_PLAN_ASSIGN_ID IN NUMBER,
99: X_SRP_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
100: X_ROLE_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
101: X_SALESREP_ID IN NUMBER := fnd_api.g_miss_num,
102: X_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
103: X_COMP_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
96: -- -------------------------------------------------------------------------+
97: PROCEDURE UPDATE_ROW
98: (X_SRP_PLAN_ASSIGN_ID IN NUMBER,
99: X_SRP_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
100: X_ROLE_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
101: X_SALESREP_ID IN NUMBER := fnd_api.g_miss_num,
102: X_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
103: X_COMP_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
104: X_START_DATE IN DATE := fnd_api.g_miss_date,
97: PROCEDURE UPDATE_ROW
98: (X_SRP_PLAN_ASSIGN_ID IN NUMBER,
99: X_SRP_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
100: X_ROLE_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
101: X_SALESREP_ID IN NUMBER := fnd_api.g_miss_num,
102: X_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
103: X_COMP_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
104: X_START_DATE IN DATE := fnd_api.g_miss_date,
105: X_END_DATE IN DATE := fnd_api.g_miss_date,
98: (X_SRP_PLAN_ASSIGN_ID IN NUMBER,
99: X_SRP_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
100: X_ROLE_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
101: X_SALESREP_ID IN NUMBER := fnd_api.g_miss_num,
102: X_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
103: X_COMP_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
104: X_START_DATE IN DATE := fnd_api.g_miss_date,
105: X_END_DATE IN DATE := fnd_api.g_miss_date,
106: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := fnd_api.g_miss_char,
99: X_SRP_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
100: X_ROLE_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
101: X_SALESREP_ID IN NUMBER := fnd_api.g_miss_num,
102: X_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
103: X_COMP_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
104: X_START_DATE IN DATE := fnd_api.g_miss_date,
105: X_END_DATE IN DATE := fnd_api.g_miss_date,
106: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := fnd_api.g_miss_char,
107: X_ATTRIBUTE1 IN VARCHAR2 := fnd_api.g_miss_char,
100: X_ROLE_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
101: X_SALESREP_ID IN NUMBER := fnd_api.g_miss_num,
102: X_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
103: X_COMP_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
104: X_START_DATE IN DATE := fnd_api.g_miss_date,
105: X_END_DATE IN DATE := fnd_api.g_miss_date,
106: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := fnd_api.g_miss_char,
107: X_ATTRIBUTE1 IN VARCHAR2 := fnd_api.g_miss_char,
108: X_ATTRIBUTE2 IN VARCHAR2 := fnd_api.g_miss_char,
101: X_SALESREP_ID IN NUMBER := fnd_api.g_miss_num,
102: X_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
103: X_COMP_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
104: X_START_DATE IN DATE := fnd_api.g_miss_date,
105: X_END_DATE IN DATE := fnd_api.g_miss_date,
106: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := fnd_api.g_miss_char,
107: X_ATTRIBUTE1 IN VARCHAR2 := fnd_api.g_miss_char,
108: X_ATTRIBUTE2 IN VARCHAR2 := fnd_api.g_miss_char,
109: X_ATTRIBUTE3 IN VARCHAR2 := fnd_api.g_miss_char,
102: X_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
103: X_COMP_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
104: X_START_DATE IN DATE := fnd_api.g_miss_date,
105: X_END_DATE IN DATE := fnd_api.g_miss_date,
106: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := fnd_api.g_miss_char,
107: X_ATTRIBUTE1 IN VARCHAR2 := fnd_api.g_miss_char,
108: X_ATTRIBUTE2 IN VARCHAR2 := fnd_api.g_miss_char,
109: X_ATTRIBUTE3 IN VARCHAR2 := fnd_api.g_miss_char,
110: X_ATTRIBUTE4 IN VARCHAR2 := fnd_api.g_miss_char,
103: X_COMP_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
104: X_START_DATE IN DATE := fnd_api.g_miss_date,
105: X_END_DATE IN DATE := fnd_api.g_miss_date,
106: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := fnd_api.g_miss_char,
107: X_ATTRIBUTE1 IN VARCHAR2 := fnd_api.g_miss_char,
108: X_ATTRIBUTE2 IN VARCHAR2 := fnd_api.g_miss_char,
109: X_ATTRIBUTE3 IN VARCHAR2 := fnd_api.g_miss_char,
110: X_ATTRIBUTE4 IN VARCHAR2 := fnd_api.g_miss_char,
111: X_ATTRIBUTE5 IN VARCHAR2 := fnd_api.g_miss_char,
104: X_START_DATE IN DATE := fnd_api.g_miss_date,
105: X_END_DATE IN DATE := fnd_api.g_miss_date,
106: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := fnd_api.g_miss_char,
107: X_ATTRIBUTE1 IN VARCHAR2 := fnd_api.g_miss_char,
108: X_ATTRIBUTE2 IN VARCHAR2 := fnd_api.g_miss_char,
109: X_ATTRIBUTE3 IN VARCHAR2 := fnd_api.g_miss_char,
110: X_ATTRIBUTE4 IN VARCHAR2 := fnd_api.g_miss_char,
111: X_ATTRIBUTE5 IN VARCHAR2 := fnd_api.g_miss_char,
112: X_ATTRIBUTE6 IN VARCHAR2 := fnd_api.g_miss_char,
105: X_END_DATE IN DATE := fnd_api.g_miss_date,
106: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := fnd_api.g_miss_char,
107: X_ATTRIBUTE1 IN VARCHAR2 := fnd_api.g_miss_char,
108: X_ATTRIBUTE2 IN VARCHAR2 := fnd_api.g_miss_char,
109: X_ATTRIBUTE3 IN VARCHAR2 := fnd_api.g_miss_char,
110: X_ATTRIBUTE4 IN VARCHAR2 := fnd_api.g_miss_char,
111: X_ATTRIBUTE5 IN VARCHAR2 := fnd_api.g_miss_char,
112: X_ATTRIBUTE6 IN VARCHAR2 := fnd_api.g_miss_char,
113: X_ATTRIBUTE7 IN VARCHAR2 := fnd_api.g_miss_char,
106: X_ATTRIBUTE_CATEGORY IN VARCHAR2 := fnd_api.g_miss_char,
107: X_ATTRIBUTE1 IN VARCHAR2 := fnd_api.g_miss_char,
108: X_ATTRIBUTE2 IN VARCHAR2 := fnd_api.g_miss_char,
109: X_ATTRIBUTE3 IN VARCHAR2 := fnd_api.g_miss_char,
110: X_ATTRIBUTE4 IN VARCHAR2 := fnd_api.g_miss_char,
111: X_ATTRIBUTE5 IN VARCHAR2 := fnd_api.g_miss_char,
112: X_ATTRIBUTE6 IN VARCHAR2 := fnd_api.g_miss_char,
113: X_ATTRIBUTE7 IN VARCHAR2 := fnd_api.g_miss_char,
114: X_ATTRIBUTE8 IN VARCHAR2 := fnd_api.g_miss_char,
107: X_ATTRIBUTE1 IN VARCHAR2 := fnd_api.g_miss_char,
108: X_ATTRIBUTE2 IN VARCHAR2 := fnd_api.g_miss_char,
109: X_ATTRIBUTE3 IN VARCHAR2 := fnd_api.g_miss_char,
110: X_ATTRIBUTE4 IN VARCHAR2 := fnd_api.g_miss_char,
111: X_ATTRIBUTE5 IN VARCHAR2 := fnd_api.g_miss_char,
112: X_ATTRIBUTE6 IN VARCHAR2 := fnd_api.g_miss_char,
113: X_ATTRIBUTE7 IN VARCHAR2 := fnd_api.g_miss_char,
114: X_ATTRIBUTE8 IN VARCHAR2 := fnd_api.g_miss_char,
115: X_ATTRIBUTE9 IN VARCHAR2 := fnd_api.g_miss_char,
108: X_ATTRIBUTE2 IN VARCHAR2 := fnd_api.g_miss_char,
109: X_ATTRIBUTE3 IN VARCHAR2 := fnd_api.g_miss_char,
110: X_ATTRIBUTE4 IN VARCHAR2 := fnd_api.g_miss_char,
111: X_ATTRIBUTE5 IN VARCHAR2 := fnd_api.g_miss_char,
112: X_ATTRIBUTE6 IN VARCHAR2 := fnd_api.g_miss_char,
113: X_ATTRIBUTE7 IN VARCHAR2 := fnd_api.g_miss_char,
114: X_ATTRIBUTE8 IN VARCHAR2 := fnd_api.g_miss_char,
115: X_ATTRIBUTE9 IN VARCHAR2 := fnd_api.g_miss_char,
116: X_ATTRIBUTE10 IN VARCHAR2 := fnd_api.g_miss_char,
109: X_ATTRIBUTE3 IN VARCHAR2 := fnd_api.g_miss_char,
110: X_ATTRIBUTE4 IN VARCHAR2 := fnd_api.g_miss_char,
111: X_ATTRIBUTE5 IN VARCHAR2 := fnd_api.g_miss_char,
112: X_ATTRIBUTE6 IN VARCHAR2 := fnd_api.g_miss_char,
113: X_ATTRIBUTE7 IN VARCHAR2 := fnd_api.g_miss_char,
114: X_ATTRIBUTE8 IN VARCHAR2 := fnd_api.g_miss_char,
115: X_ATTRIBUTE9 IN VARCHAR2 := fnd_api.g_miss_char,
116: X_ATTRIBUTE10 IN VARCHAR2 := fnd_api.g_miss_char,
117: X_ATTRIBUTE11 IN VARCHAR2 := fnd_api.g_miss_char,
110: X_ATTRIBUTE4 IN VARCHAR2 := fnd_api.g_miss_char,
111: X_ATTRIBUTE5 IN VARCHAR2 := fnd_api.g_miss_char,
112: X_ATTRIBUTE6 IN VARCHAR2 := fnd_api.g_miss_char,
113: X_ATTRIBUTE7 IN VARCHAR2 := fnd_api.g_miss_char,
114: X_ATTRIBUTE8 IN VARCHAR2 := fnd_api.g_miss_char,
115: X_ATTRIBUTE9 IN VARCHAR2 := fnd_api.g_miss_char,
116: X_ATTRIBUTE10 IN VARCHAR2 := fnd_api.g_miss_char,
117: X_ATTRIBUTE11 IN VARCHAR2 := fnd_api.g_miss_char,
118: X_ATTRIBUTE12 IN VARCHAR2 := fnd_api.g_miss_char,
111: X_ATTRIBUTE5 IN VARCHAR2 := fnd_api.g_miss_char,
112: X_ATTRIBUTE6 IN VARCHAR2 := fnd_api.g_miss_char,
113: X_ATTRIBUTE7 IN VARCHAR2 := fnd_api.g_miss_char,
114: X_ATTRIBUTE8 IN VARCHAR2 := fnd_api.g_miss_char,
115: X_ATTRIBUTE9 IN VARCHAR2 := fnd_api.g_miss_char,
116: X_ATTRIBUTE10 IN VARCHAR2 := fnd_api.g_miss_char,
117: X_ATTRIBUTE11 IN VARCHAR2 := fnd_api.g_miss_char,
118: X_ATTRIBUTE12 IN VARCHAR2 := fnd_api.g_miss_char,
119: X_ATTRIBUTE13 IN VARCHAR2 := fnd_api.g_miss_char,
112: X_ATTRIBUTE6 IN VARCHAR2 := fnd_api.g_miss_char,
113: X_ATTRIBUTE7 IN VARCHAR2 := fnd_api.g_miss_char,
114: X_ATTRIBUTE8 IN VARCHAR2 := fnd_api.g_miss_char,
115: X_ATTRIBUTE9 IN VARCHAR2 := fnd_api.g_miss_char,
116: X_ATTRIBUTE10 IN VARCHAR2 := fnd_api.g_miss_char,
117: X_ATTRIBUTE11 IN VARCHAR2 := fnd_api.g_miss_char,
118: X_ATTRIBUTE12 IN VARCHAR2 := fnd_api.g_miss_char,
119: X_ATTRIBUTE13 IN VARCHAR2 := fnd_api.g_miss_char,
120: X_ATTRIBUTE14 IN VARCHAR2 := fnd_api.g_miss_char,
113: X_ATTRIBUTE7 IN VARCHAR2 := fnd_api.g_miss_char,
114: X_ATTRIBUTE8 IN VARCHAR2 := fnd_api.g_miss_char,
115: X_ATTRIBUTE9 IN VARCHAR2 := fnd_api.g_miss_char,
116: X_ATTRIBUTE10 IN VARCHAR2 := fnd_api.g_miss_char,
117: X_ATTRIBUTE11 IN VARCHAR2 := fnd_api.g_miss_char,
118: X_ATTRIBUTE12 IN VARCHAR2 := fnd_api.g_miss_char,
119: X_ATTRIBUTE13 IN VARCHAR2 := fnd_api.g_miss_char,
120: X_ATTRIBUTE14 IN VARCHAR2 := fnd_api.g_miss_char,
121: X_ATTRIBUTE15 IN VARCHAR2 := fnd_api.g_miss_char,
114: X_ATTRIBUTE8 IN VARCHAR2 := fnd_api.g_miss_char,
115: X_ATTRIBUTE9 IN VARCHAR2 := fnd_api.g_miss_char,
116: X_ATTRIBUTE10 IN VARCHAR2 := fnd_api.g_miss_char,
117: X_ATTRIBUTE11 IN VARCHAR2 := fnd_api.g_miss_char,
118: X_ATTRIBUTE12 IN VARCHAR2 := fnd_api.g_miss_char,
119: X_ATTRIBUTE13 IN VARCHAR2 := fnd_api.g_miss_char,
120: X_ATTRIBUTE14 IN VARCHAR2 := fnd_api.g_miss_char,
121: X_ATTRIBUTE15 IN VARCHAR2 := fnd_api.g_miss_char,
122: X_LAST_UPDATE_DATE IN DATE,
115: X_ATTRIBUTE9 IN VARCHAR2 := fnd_api.g_miss_char,
116: X_ATTRIBUTE10 IN VARCHAR2 := fnd_api.g_miss_char,
117: X_ATTRIBUTE11 IN VARCHAR2 := fnd_api.g_miss_char,
118: X_ATTRIBUTE12 IN VARCHAR2 := fnd_api.g_miss_char,
119: X_ATTRIBUTE13 IN VARCHAR2 := fnd_api.g_miss_char,
120: X_ATTRIBUTE14 IN VARCHAR2 := fnd_api.g_miss_char,
121: X_ATTRIBUTE15 IN VARCHAR2 := fnd_api.g_miss_char,
122: X_LAST_UPDATE_DATE IN DATE,
123: X_LAST_UPDATED_BY IN NUMBER,
116: X_ATTRIBUTE10 IN VARCHAR2 := fnd_api.g_miss_char,
117: X_ATTRIBUTE11 IN VARCHAR2 := fnd_api.g_miss_char,
118: X_ATTRIBUTE12 IN VARCHAR2 := fnd_api.g_miss_char,
119: X_ATTRIBUTE13 IN VARCHAR2 := fnd_api.g_miss_char,
120: X_ATTRIBUTE14 IN VARCHAR2 := fnd_api.g_miss_char,
121: X_ATTRIBUTE15 IN VARCHAR2 := fnd_api.g_miss_char,
122: X_LAST_UPDATE_DATE IN DATE,
123: X_LAST_UPDATED_BY IN NUMBER,
124: X_LAST_UPDATE_LOGIN IN NUMBER
117: X_ATTRIBUTE11 IN VARCHAR2 := fnd_api.g_miss_char,
118: X_ATTRIBUTE12 IN VARCHAR2 := fnd_api.g_miss_char,
119: X_ATTRIBUTE13 IN VARCHAR2 := fnd_api.g_miss_char,
120: X_ATTRIBUTE14 IN VARCHAR2 := fnd_api.g_miss_char,
121: X_ATTRIBUTE15 IN VARCHAR2 := fnd_api.g_miss_char,
122: X_LAST_UPDATE_DATE IN DATE,
123: X_LAST_UPDATED_BY IN NUMBER,
124: X_LAST_UPDATE_LOGIN IN NUMBER
125: );