APPS.HRWCDJC_PKG SQL Statements

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

Line: 7

PROCEDURE INSERT_ROW( X_ROWID IN OUT      VARCHAR2,
                      X_STATE_CODE        VARCHAR2,
                      X_BUSINESS_GROUP_ID NUMBER,
                      X_JOB_ID            NUMBER,
                      X_WC_CODE           NUMBER) IS
BEGIN
--
   INSERT INTO PAY_JOB_WC_CODE_USAGES
      (STATE_CODE, BUSINESS_GROUP_ID, JOB_ID, WC_CODE)
   VALUES
      (X_STATE_CODE, X_BUSINESS_GROUP_ID, X_JOB_ID, X_WC_CODE);

Line: 19

   SELECT ROWID
   INTO   X_ROWID
   FROM   PAY_JOB_WC_CODE_USAGES
   WHERE  STATE_CODE = X_STATE_CODE
   AND    JOB_ID = X_JOB_ID;

Line: 29

END INSERT_ROW;

Line: 33

PROCEDURE UPDATE_ROW( X_ROWID             VARCHAR2,
                      X_STATE_CODE        VARCHAR2,
                      X_BUSINESS_GROUP_ID NUMBER,
                      X_JOB_ID            NUMBER,
                      X_WC_CODE           NUMBER) IS
BEGIN
--
   UPDATE PAY_JOB_WC_CODE_USAGES
   SET    STATE_CODE        = X_STATE_CODE
   ,      BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
   ,      JOB_ID            = X_JOB_ID
   ,      WC_CODE           = X_WC_CODE
   WHERE  ROWID = X_ROWID;

Line: 51

END UPDATE_ROW;

Line: 55

PROCEDURE DELETE_ROW( X_ROWID             VARCHAR2,
                      X_STATE_CODE        VARCHAR2,
                      X_BUSINESS_GROUP_ID NUMBER,
                      X_JOB_ID            NUMBER,
                      X_WC_CODE           NUMBER) IS
BEGIN
--
   DELETE FROM PAY_JOB_WC_CODE_USAGES
   WHERE  ROWID = X_ROWID;

Line: 69

END DELETE_ROW;

Line: 80

   SELECT *
   FROM   PAY_JOB_WC_CODE_USAGES
   WHERE  ROWID = X_ROWID
   FOR    UPDATE OF STATE_CODE NOWAIT;

Line: 132

SELECT 'Y'
FROM   PAY_JOB_WC_CODE_USAGES
WHERE  STATE_CODE = P_STATE_CODE
AND    JOB_ID = P_JOB_ID
AND  ((ROWID <> P_ROWID
   AND P_ROWID IS NOT NULL)
 OR
      (P_ROWID IS NULL));