106: PROCEDURE update_row (
107: x_payment_worksheet_id NUMBER
108: ,x_quota_id NUMBER
109: ,x_comp_plan_id NUMBER
110: ,x_amount NUMBER := fnd_api.g_miss_num
111: ,x_last_updated_by NUMBER
112: ,x_last_update_login NUMBER
113: ,x_last_update_date DATE
114: ) IS
135: CLOSE C;
136:
137: SELECT
138: decode(x_amount,
139: fnd_api.g_miss_num, oldrow.amount,
140: Nvl(x_amount, 0))
141: INTO
142: l_amount
143: FROM dual;