3: --
4: -- Package Name
5: -- CN_WKSHT_BONUS_PKG
6: -- Purpose
7: -- Table Handler for CN_WORKSHEET_BONUSES
8: -- FORM CNSBPS
9: -- BLOCK BONUSES
10: --
11: -- History
41: ) IS
42:
43: BEGIN
44:
45: INSERT INTO cn_worksheet_bonuses
46: (payrun_id
47: ,salesrep_id
48: ,quota_id
49: ,comp_plan_id
75: ,x_comp_plan_id NUMBER ) IS
76:
77: CURSOR C IS
78: SELECT *
79: FROM cn_worksheet_bonuses
80: WHERE payment_worksheet_id = x_payment_worksheet_id
81: AND quota_id = x_quota_id
82: AND comp_plan_id = x_comp_plan_id
83: FOR UPDATE NOWAIT;
115: l_amount NUMBER;
116:
117: CURSOR C IS
118: SELECT *
119: FROM cn_worksheet_bonuses
120: WHERE payment_worksheet_id = x_payment_worksheet_id
121: AND quota_id = x_quota_id
122: AND comp_plan_id = x_comp_plan_id
123: FOR UPDATE;
141: INTO
142: l_amount
143: FROM dual;
144:
145: UPDATE cn_worksheet_bonuses
146: SET amount = l_amount,
147: last_updated_by = x_last_updated_by,
148: last_update_date = x_last_update_date,
149: last_update_login = x_last_update_login
167: *-------------------------------------------------------------------------*/
168: PROCEDURE Delete_row( x_payment_worksheet_id NUMBER ) IS
169: BEGIN
170:
171: DELETE FROM cn_worksheet_bonuses
172: WHERE payment_worksheet_id = x_payment_worksheet_id;
173: /* IF (SQL%NOTFOUND) THEN
174: RAISE NO_DATA_FOUND;
175: END IF;*/