APPS.CN_WKSHT_BONUS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31

   PROCEDURE insert_row
   (x_payrun_id                 IN NUMBER
    ,x_salesrep_id              IN NUMBER
    ,x_quota_id                 IN NUMBER
    ,x_comp_plan_id             IN NUMBER
    ,x_amount                   IN NUMBER
    ,x_srp_plan_assign_id       IN NUMBER
    ,x_payment_worksheet_id     IN NUMBER
    ,x_created_by               IN NUMBER
    ,x_creation_date            IN DATE
  ) IS

   BEGIN

     INSERT INTO cn_worksheet_bonuses
       (payrun_id
	,salesrep_id
	,quota_id
	,comp_plan_id
	,amount
	,srp_plan_assign_id
	,payment_worksheet_id)
       VALUES
       (x_payrun_id
	,x_salesrep_id
	,x_quota_id
	,x_comp_plan_id
	,x_amount
	,x_srp_plan_assign_id
	,x_payment_worksheet_id);

Line: 62

   END Insert_row;

Line: 78

        SELECT *
          FROM cn_worksheet_bonuses
	  WHERE payment_worksheet_id = x_payment_worksheet_id
	  AND quota_id = x_quota_id
	  AND comp_plan_id = x_comp_plan_id
           FOR UPDATE NOWAIT;

Line: 92

        fnd_message.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 106

PROCEDURE update_row (
		      x_payment_worksheet_id      NUMBER
		      ,x_quota_id                 NUMBER
		      ,x_comp_plan_id             NUMBER
		      ,x_amount                   NUMBER   	:= fnd_api.g_miss_num
		      ,x_last_updated_by          NUMBER
		      ,x_last_update_login       NUMBER
		      ,x_last_update_date         DATE
		      ) IS
	l_amount NUMBER;

Line: 118

	   SELECT *
	     FROM cn_worksheet_bonuses
	     WHERE payment_worksheet_id = x_payment_worksheet_id
	     AND quota_id = x_quota_id
	     AND comp_plan_id = x_comp_plan_id
	     FOR UPDATE;

Line: 132

	fnd_message.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 137

     SELECT
       decode(x_amount,
	      fnd_api.g_miss_num, oldrow.amount,
	      Nvl(x_amount, 0))
       INTO
       l_amount
       FROM dual;

Line: 145

     UPDATE cn_worksheet_bonuses
       SET  amount =  l_amount,
       last_updated_by = x_last_updated_by,
       last_update_date = x_last_update_date,
       last_update_login = x_last_update_login
       WHERE payment_worksheet_id = x_payment_worksheet_id
       AND quota_id = x_quota_id
       AND comp_plan_id = x_comp_plan_id;

Line: 160

  END Update_row;

Line: 168

  PROCEDURE Delete_row( x_payment_worksheet_id     NUMBER ) IS
  BEGIN

     DELETE FROM cn_worksheet_bonuses
       WHERE  payment_worksheet_id = x_payment_worksheet_id;

Line: 177

  END Delete_row;