APPS.PAY_WC_STATE_SURCHARGES_PKG SQL Statements

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

Line: 4

  PROCEDURE Insert_Row(X_Rowid                   IN OUT VARCHAR2,
                       X_Surcharge_Id                   IN OUT NUMBER,
                       X_State_Code                     VARCHAR2,
                       X_Add_To_Rt                      VARCHAR2,
                       X_Name                           VARCHAR2,
                       X_Position                       VARCHAR2,
                       X_Rate                           NUMBER
  ) IS
    CURSOR C IS SELECT rowid FROM PAY_WC_STATE_SURCHARGES
                 WHERE surcharge_id = X_Surcharge_Id;

Line: 14

      CURSOR C2 IS SELECT pay_wc_state_surcharges_s.nextval FROM sys.dual;

Line: 26

		p_event      => 'INSERT');

Line: 34

       INSERT INTO PAY_WC_STATE_SURCHARGES(
              surcharge_id,
              state_code,
              add_to_rt,
              name,
              position,
              rate
             ) VALUES (
              X_Surcharge_Id,
              X_State_Code,
              X_Add_To_Rt,
              X_Name,
              X_Position,
              X_Rate
             );

Line: 57

  END Insert_Row;

Line: 69

        SELECT *
        FROM   PAY_WC_STATE_SURCHARGES
        WHERE  rowid = X_Rowid
        FOR UPDATE of Surcharge_Id NOWAIT;

Line: 81

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

Line: 106

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Surcharge_Id                   NUMBER,
                       X_State_Code                     VARCHAR2,
                       X_Add_To_Rt                      VARCHAR2,
                       X_Name                           VARCHAR2,
                       X_Position                       VARCHAR2,
                       X_Rate                           NUMBER
  ) IS
  BEGIN
--
-- check if unique
--
check_unique( x_surcharge_id,
	      x_state_code,
              x_name,
	      x_position );

Line: 125

		p_event      => 'UPDATE');

Line: 127

    UPDATE PAY_WC_STATE_SURCHARGES
    SET
       surcharge_id                    =     X_Surcharge_Id,
       state_code                      =     X_State_Code,
       add_to_rt                       =     X_Add_To_Rt,
       name                            =     X_Name,
       position                        =     X_Position,
       rate                            =     X_Rate
    WHERE rowid = X_Rowid;

Line: 140

  END Update_Row;

Line: 141

  PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
  BEGIN
    DELETE FROM PAY_WC_STATE_SURCHARGES
    WHERE rowid = X_Rowid;

Line: 149

  END Delete_Row;

Line: 159

SELECT
	'N'
FROM
	pay_wc_state_surcharges wss
WHERE
	wss.name	= p_name	AND
	wss.state_code	= p_state_code	AND
	(wss.surcharge_id <> p_surcharge_id
	OR
	 p_surcharge_id IS NULL);

Line: 171

SELECT
	'N'
FROM
	pay_wc_state_surcharges wss
WHERE
	wss.state_code	= p_state_code	AND
	wss.position	= p_position	AND
	(wss.surcharge_id <> p_surcharge_id
	OR
	 p_surcharge_id IS NULL);

Line: 222

SELECT
	'Y'
FROM
	pay_wc_state_surcharges wss
WHERE
	wss.position	= l_position	AND
	wss.state_code	= p_state_code;

Line: 232

IF (p_event = 'DELETE')
THEN
     IF(p_position = 'POST_EXP_MOD_1')
     THEN
         l_position := 'POST_EXP_MOD_2';

Line: 249

ELSIF (p_event IN ('INSERT', 'UPDATE') )
THEN
     IF(p_position = 'POST_EXP_MOD_2')
     THEN
         l_position := 'POST_EXP_MOD_1';