APPS.PAY_DYT_USER_COLUMN_INSTA_PKG SQL Statements

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

Line: 40

    ACTION: DELETE
    GENERATED DATE:   13/08/2013 18:46
    DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON DELETE
 OF PAY_USER_COLUMN_INSTANCES_F
    FULL TRIGGER NAME: PAY_USER_COLUMN_INSTANCES_F_ARD
  ================================================
*/
--
PROCEDURE PAY_USER_COLUMN_INSTANCES__ARD
(
    P_NEW_DATETRACK_MODE                     IN VARCHAR2
   
,P_NEW_EFFECTIVE_DATE                     IN DATE
   ,P_NEW_EFFECTIVE_END_DATE                 IN DATE
   ,P_NEW_EFFECTIVE_START_DATE               IN DATE
   ,P_NEW_USER_COLUMN_INSTANCE_ID            IN NUMBER
   ,P_NEW_VALIDATION_END_DATE              
  IN DATE
   ,P_NEW_VALIDATION_START_DATE              IN DATE
   ,P_OLD_BUSINESS_GROUP_ID                  IN NUMBER
   ,P_OLD_EFFECTIVE_END_DATE                 IN DATE
   ,P_OLD_EFFECTIVE_START_DATE               IN DATE
   ,P_OLD_LEGISLATION_CODE    
               IN VARCHAR2
   ,P_OLD_OBJECT_VERSION_NUMBER              IN NUMBER
   ,P_OLD_USER_COLUMN_ID                     IN NUMBER
   ,P_OLD_USER_ROW_ID                        IN NUMBER
   ,P_OLD_VALUE                              IN VARCHAR2
 ) IS
 

--
  /* LOCAL VARIABLE DECLARATIONS */
  L_BUSINESS_GROUP_ID            NUMBER;

Line: 83

    P_STATEMENT                    => 'SELECT :P_BINDVAR FROM SYS.DUAL',
    
P_BINDVAR                      => P_OLD_BUSINESS_GROUP_ID
  ); 

Line: 143

    ACTION: INSERT
    GENERATED DATE:   13/08/2013 18:46
    DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON INSERT
 OF PAY_USER_COLUMN_INSTANCES_F
    FULL TRIGGER NAME: PAY_USER_COLUMN_INSTANCES_F_ARI
  ================================================
*/
--
PROCEDURE PAY_USER_COLUMN_INSTANCES__ARI
(
    P_NEW_BUSINESS_GROUP_ID                  IN NUMBER
   
,P_NEW_EFFECTIVE_DATE                     IN DATE
   ,P_NEW_EFFECTIVE_END_DATE                 IN DATE
   ,P_NEW_EFFECTIVE_START_DATE               IN DATE
   ,P_NEW_LEGISLATION_CODE                   IN VARCHAR2
   ,P_NEW_OBJECT_VERSION_NUMBER          
    IN NUMBER
   ,P_NEW_USER_COLUMN_ID                     IN NUMBER
   ,P_NEW_USER_COLUMN_INSTANCE_ID            IN NUMBER
   ,P_NEW_USER_ROW_ID                        IN NUMBER
   ,P_NEW_VALIDATION_END_DATE                IN DATE
   
,P_NEW_VALIDATION_START_DATE              IN DATE
   ,P_NEW_VALUE                              IN VARCHAR2
 ) IS 

--
  /* LOCAL VARIABLE DECLARATIONS */
  L_BUSINESS_GROUP_ID            NUMBER;

Line: 183

    P_STATEMENT                    => 'SELECT :P_BINDVAR FROM SYS.DUAL',
    P_BINDVAR                      => P_NEW_BUSINESS_GROUP_ID
  ); 

Line: 239

    ACTION: UPDATE
    GENERATED DATE:   13/08/2013 18:46
    DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON UPDATE
 OF PAY_USER_COLUMN_INSTANCES_F
    FULL TRIGGER NAME: PAY_USER_COLUMN_INSTANCES_F_ARU
  ================================================
*/
--
PROCEDURE PAY_USER_COLUMN_INSTANCES__ARU
(
    P_NEW_DATETRACK_MODE                     IN VARCHAR2
   
,P_NEW_EFFECTIVE_DATE                     IN DATE
   ,P_NEW_EFFECTIVE_END_DATE                 IN DATE
   ,P_NEW_EFFECTIVE_START_DATE               IN DATE
   ,P_NEW_OBJECT_VERSION_NUMBER              IN NUMBER
   ,P_NEW_USER_COLUMN_INSTANCE_ID          
  IN NUMBER
   ,P_NEW_VALIDATION_END_DATE                IN DATE
   ,P_NEW_VALIDATION_START_DATE              IN DATE
   ,P_NEW_VALUE                              IN VARCHAR2
   ,P_OLD_BUSINESS_GROUP_ID                  IN NUMBER
   
,P_OLD_EFFECTIVE_END_DATE                 IN DATE
   ,P_OLD_EFFECTIVE_START_DATE               IN DATE
   ,P_OLD_LEGISLATION_CODE                   IN VARCHAR2
   ,P_OLD_OBJECT_VERSION_NUMBER              IN NUMBER
   ,P_OLD_USER_COLUMN_ID               
      IN NUMBER
   ,P_OLD_USER_ROW_ID                        IN NUMBER
   ,P_OLD_VALUE                              IN VARCHAR2
 ) IS 

--
  /* LOCAL VARIABLE DECLARATIONS */
  L_BUSINESS_GROUP_ID            NUMBER;

Line: 285

    P_STATEMENT                    => 'SELECT :P_BINDVAR FROM SYS.DUAL',
    P_BINDVAR                      => P_OLD_BUSINESS_GROUP_ID
  ); 

Line: 357

    Name:   AFTER_INSERT
    Table:  PAY_USER_COLUMN_INSTANCES_F
    Action: INSERT
    Generated Date:   13/08/2013 18:46
    Description: Called as part of INSERT process
  
================================================
*/

--
PROCEDURE AFTER_INSERT
(
    P_EFFECTIVE_DATE                         in DATE
   ,P_VALIDATION_START_DATE                  in DATE
   ,P_VALIDATION_END_DATE                    in DATE
   
,P_USER_COLUMN_INSTANCE_ID                in NUMBER
   ,P_EFFECTIVE_START_DATE                   in DATE
   ,P_EFFECTIVE_END_DATE                     in DATE
   ,P_USER_ROW_ID                            in NUMBER
   ,P_USER_COLUMN_ID                     
    in NUMBER
   ,P_BUSINESS_GROUP_ID                      in NUMBER
   ,P_LEGISLATION_CODE                       in VARCHAR2
   ,P_VALUE                                  in VARCHAR2
   ,P_OBJECT_VERSION_NUMBER                  in NUMBER
 ) IS 
  l_mode 
 varchar2(80);

Line: 391

    hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');

Line: 395

hr_api.g_insert;

Line: 426

    hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));

Line: 430

END  AFTER_INSERT;

Line: 442

    Name:   AFTER_UPDATE
    Table:  PAY_USER_COLUMN_INSTANCES_F
    Action: UPDATE
    Generated Date:   13/08/2013 18:46
    Description: Called as part of UPDATE process
  
================================================
*/

--
PROCEDURE AFTER_UPDATE
(
    P_EFFECTIVE_DATE                         in DATE
   ,P_DATETRACK_MODE                         in VARCHAR2
   ,P_VALIDATION_START_DATE                  in DATE
   
,P_VALIDATION_END_DATE                    in DATE
   ,P_USER_COLUMN_INSTANCE_ID                in NUMBER
   ,P_EFFECTIVE_START_DATE                   in DATE
   ,P_EFFECTIVE_END_DATE                     in DATE
   ,P_VALUE                                
  in VARCHAR2
   ,P_OBJECT_VERSION_NUMBER                  in NUMBER
   ,P_EFFECTIVE_START_DATE_O                 in DATE
   ,P_EFFECTIVE_END_DATE_O                   in DATE
   ,P_USER_ROW_ID_O                          in NUMBER
   ,P_USER_COLUMN_ID_O  
                     in NUMBER
   ,P_BUSINESS_GROUP_ID_O                    in NUMBER
   ,P_LEGISLATION_CODE_O                     in VARCHAR2
   ,P_VALUE_O                                in VARCHAR2
   ,P_OBJECT_VERSION_NUMBER_O                in NUMBER

 ) IS 
  l_mode  varchar2(80);

Line: 482

    hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');

Line: 523

    hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));

Line: 528

END  AFTER_UPDATE;

Line: 540

    Name:   AFTER_DELETE
    Table:  PAY_USER_COLUMN_INSTANCES_F
    Action: DELETE
    Generated Date:   13/08/2013 18:46
    Description: Called as part of DELETE process
  
================================================
*/

--
PROCEDURE AFTER_DELETE
(
    P_EFFECTIVE_DATE                         in DATE
   ,P_DATETRACK_MODE                         in VARCHAR2
   ,P_VALIDATION_START_DATE                  in DATE
   
,P_VALIDATION_END_DATE                    in DATE
   ,P_USER_COLUMN_INSTANCE_ID                in NUMBER
   ,P_EFFECTIVE_START_DATE                   in DATE
   ,P_EFFECTIVE_END_DATE                     in DATE
   ,P_EFFECTIVE_START_DATE_O               
  in DATE
   ,P_EFFECTIVE_END_DATE_O                   in DATE
   ,P_USER_ROW_ID_O                          in NUMBER
   ,P_USER_COLUMN_ID_O                       in NUMBER
   ,P_BUSINESS_GROUP_ID_O                    in NUMBER
   ,P_LEGISLATION_CODE_O  
                   in VARCHAR2
   ,P_VALUE_O                                in VARCHAR2
   ,P_OBJECT_VERSION_NUMBER_O                in NUMBER
 ) IS 
  l_mode  varchar2(80);

Line: 578

AFTER_DELETE');

Line: 616

    hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));

Line: 620

END  AFTER_DELETE;