101: --
102: -- *-------------------------------------------------------------------------*/
103: PROCEDURE update_row (
104: x_srp_pmt_plan_id NUMBER
105: ,x_pmt_plan_id NUMBER := fnd_api.g_miss_num
106: ,x_salesrep_id NUMBER := fnd_api.g_miss_num
107: ,x_org_id NUMBER := fnd_api.g_miss_num
108: ,x_role_id NUMBER := fnd_api.g_miss_num
109: ,x_credit_type_id NUMBER := fnd_api.g_miss_num
102: -- *-------------------------------------------------------------------------*/
103: PROCEDURE update_row (
104: x_srp_pmt_plan_id NUMBER
105: ,x_pmt_plan_id NUMBER := fnd_api.g_miss_num
106: ,x_salesrep_id NUMBER := fnd_api.g_miss_num
107: ,x_org_id NUMBER := fnd_api.g_miss_num
108: ,x_role_id NUMBER := fnd_api.g_miss_num
109: ,x_credit_type_id NUMBER := fnd_api.g_miss_num
110: ,x_start_date DATE := fnd_api.g_miss_date
103: PROCEDURE update_row (
104: x_srp_pmt_plan_id NUMBER
105: ,x_pmt_plan_id NUMBER := fnd_api.g_miss_num
106: ,x_salesrep_id NUMBER := fnd_api.g_miss_num
107: ,x_org_id NUMBER := fnd_api.g_miss_num
108: ,x_role_id NUMBER := fnd_api.g_miss_num
109: ,x_credit_type_id NUMBER := fnd_api.g_miss_num
110: ,x_start_date DATE := fnd_api.g_miss_date
111: ,x_end_date DATE := fnd_api.g_miss_date
104: x_srp_pmt_plan_id NUMBER
105: ,x_pmt_plan_id NUMBER := fnd_api.g_miss_num
106: ,x_salesrep_id NUMBER := fnd_api.g_miss_num
107: ,x_org_id NUMBER := fnd_api.g_miss_num
108: ,x_role_id NUMBER := fnd_api.g_miss_num
109: ,x_credit_type_id NUMBER := fnd_api.g_miss_num
110: ,x_start_date DATE := fnd_api.g_miss_date
111: ,x_end_date DATE := fnd_api.g_miss_date
112: ,x_minimum_amount NUMBER := fnd_api.g_miss_num
105: ,x_pmt_plan_id NUMBER := fnd_api.g_miss_num
106: ,x_salesrep_id NUMBER := fnd_api.g_miss_num
107: ,x_org_id NUMBER := fnd_api.g_miss_num
108: ,x_role_id NUMBER := fnd_api.g_miss_num
109: ,x_credit_type_id NUMBER := fnd_api.g_miss_num
110: ,x_start_date DATE := fnd_api.g_miss_date
111: ,x_end_date DATE := fnd_api.g_miss_date
112: ,x_minimum_amount NUMBER := fnd_api.g_miss_num
113: ,x_maximum_amount NUMBER := fnd_api.g_miss_num
106: ,x_salesrep_id NUMBER := fnd_api.g_miss_num
107: ,x_org_id NUMBER := fnd_api.g_miss_num
108: ,x_role_id NUMBER := fnd_api.g_miss_num
109: ,x_credit_type_id NUMBER := fnd_api.g_miss_num
110: ,x_start_date DATE := fnd_api.g_miss_date
111: ,x_end_date DATE := fnd_api.g_miss_date
112: ,x_minimum_amount NUMBER := fnd_api.g_miss_num
113: ,x_maximum_amount NUMBER := fnd_api.g_miss_num
114: ,x_max_recovery_amount NUMBER := fnd_api.g_miss_num
107: ,x_org_id NUMBER := fnd_api.g_miss_num
108: ,x_role_id NUMBER := fnd_api.g_miss_num
109: ,x_credit_type_id NUMBER := fnd_api.g_miss_num
110: ,x_start_date DATE := fnd_api.g_miss_date
111: ,x_end_date DATE := fnd_api.g_miss_date
112: ,x_minimum_amount NUMBER := fnd_api.g_miss_num
113: ,x_maximum_amount NUMBER := fnd_api.g_miss_num
114: ,x_max_recovery_amount NUMBER := fnd_api.g_miss_num
115: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
108: ,x_role_id NUMBER := fnd_api.g_miss_num
109: ,x_credit_type_id NUMBER := fnd_api.g_miss_num
110: ,x_start_date DATE := fnd_api.g_miss_date
111: ,x_end_date DATE := fnd_api.g_miss_date
112: ,x_minimum_amount NUMBER := fnd_api.g_miss_num
113: ,x_maximum_amount NUMBER := fnd_api.g_miss_num
114: ,x_max_recovery_amount NUMBER := fnd_api.g_miss_num
115: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
116: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
109: ,x_credit_type_id NUMBER := fnd_api.g_miss_num
110: ,x_start_date DATE := fnd_api.g_miss_date
111: ,x_end_date DATE := fnd_api.g_miss_date
112: ,x_minimum_amount NUMBER := fnd_api.g_miss_num
113: ,x_maximum_amount NUMBER := fnd_api.g_miss_num
114: ,x_max_recovery_amount NUMBER := fnd_api.g_miss_num
115: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
116: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
117: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
110: ,x_start_date DATE := fnd_api.g_miss_date
111: ,x_end_date DATE := fnd_api.g_miss_date
112: ,x_minimum_amount NUMBER := fnd_api.g_miss_num
113: ,x_maximum_amount NUMBER := fnd_api.g_miss_num
114: ,x_max_recovery_amount NUMBER := fnd_api.g_miss_num
115: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
116: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
117: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
118: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
111: ,x_end_date DATE := fnd_api.g_miss_date
112: ,x_minimum_amount NUMBER := fnd_api.g_miss_num
113: ,x_maximum_amount NUMBER := fnd_api.g_miss_num
114: ,x_max_recovery_amount NUMBER := fnd_api.g_miss_num
115: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
116: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
117: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
118: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
119: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
112: ,x_minimum_amount NUMBER := fnd_api.g_miss_num
113: ,x_maximum_amount NUMBER := fnd_api.g_miss_num
114: ,x_max_recovery_amount NUMBER := fnd_api.g_miss_num
115: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
116: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
117: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
118: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
119: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
120: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
113: ,x_maximum_amount NUMBER := fnd_api.g_miss_num
114: ,x_max_recovery_amount NUMBER := fnd_api.g_miss_num
115: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
116: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
117: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
118: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
119: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
120: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
121: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
114: ,x_max_recovery_amount NUMBER := fnd_api.g_miss_num
115: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
116: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
117: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
118: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
119: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
120: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
121: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
122: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
115: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
116: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
117: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
118: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
119: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
120: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
121: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
122: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
123: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
116: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
117: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
118: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
119: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
120: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
121: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
122: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
123: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
124: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
117: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
118: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
119: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
120: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
121: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
122: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
123: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
124: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
125: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
118: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
119: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
120: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
121: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
122: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
123: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
124: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
125: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
126: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
119: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
120: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
121: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
122: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
123: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
124: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
125: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
126: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
127: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
120: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
121: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
122: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
123: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
124: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
125: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
126: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
127: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
128: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
121: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
122: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
123: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
124: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
125: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
126: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
127: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
128: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
129: ,x_attribute14 VARCHAR2 := fnd_api.g_miss_char
122: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
123: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
124: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
125: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
126: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
127: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
128: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
129: ,x_attribute14 VARCHAR2 := fnd_api.g_miss_char
130: ,x_attribute15 VARCHAR2 := fnd_api.g_miss_char
123: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
124: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
125: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
126: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
127: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
128: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
129: ,x_attribute14 VARCHAR2 := fnd_api.g_miss_char
130: ,x_attribute15 VARCHAR2 := fnd_api.g_miss_char
131: ,x_Last_Updated_By NUMBER
124: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
125: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
126: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
127: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
128: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
129: ,x_attribute14 VARCHAR2 := fnd_api.g_miss_char
130: ,x_attribute15 VARCHAR2 := fnd_api.g_miss_char
131: ,x_Last_Updated_By NUMBER
132: ,x_Last_Update_Date DATE
125: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
126: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
127: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
128: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
129: ,x_attribute14 VARCHAR2 := fnd_api.g_miss_char
130: ,x_attribute15 VARCHAR2 := fnd_api.g_miss_char
131: ,x_Last_Updated_By NUMBER
132: ,x_Last_Update_Date DATE
133: ,x_Last_Update_Login NUMBER
126: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
127: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
128: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
129: ,x_attribute14 VARCHAR2 := fnd_api.g_miss_char
130: ,x_attribute15 VARCHAR2 := fnd_api.g_miss_char
131: ,x_Last_Updated_By NUMBER
132: ,x_Last_Update_Date DATE
133: ,x_Last_Update_Login NUMBER
134: ,x_object_version_number NUMBER
131: ,x_Last_Updated_By NUMBER
132: ,x_Last_Update_Date DATE
133: ,x_Last_Update_Login NUMBER
134: ,x_object_version_number NUMBER
135: ,x_lock_flag VARCHAR2 := fnd_api.g_miss_char);
136:
137: --/*-------------------------------------------------------------------------*
138: -- Procedure Name
139: -- Delete_row