DBA Data[Home] [Help]

APPS.PAY_DYT_COST_ALLOCATIONS_PKG SQL Statements

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

Line: 40

    ACTION: DELETE
    GENERATED DATE:   27/11/2012 04:01
    DESCRIPTION: CONTINUOUS CALCULATION TRIGGER ON DELETION 
OF PAY_COST_ALLOCATIONS_F
    FULL TRIGGER NAME: PAY_COST_ALLOCATIONS_F_ARD
  ================================================
*/
--
PROCEDURE PAY_COST_ALLOCATIONS_F_ARD_ARD
(
    P_NEW_COST_ALLOCATION_ID                 IN NUMBER
   
,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_VALIDATION_END_DATE            
    IN DATE
   ,P_NEW_VALIDATION_START_DATE              IN DATE
   ,P_OLD_ASSIGNMENT_ID                      IN NUMBER
   ,P_OLD_BUSINESS_GROUP_ID                  IN NUMBER
   ,P_OLD_COST_ALLOCATION_KEYFLEX_           IN NUMBER
   
,P_OLD_EFFECTIVE_END_DATE                 IN DATE
   ,P_OLD_EFFECTIVE_START_DATE               IN DATE
   ,P_OLD_OBJECT_VERSION_NUMBER              IN NUMBER
   ,P_OLD_PROGRAM_APPLICATION_ID             IN NUMBER
   ,P_OLD_PROGRAM_ID                     
    IN NUMBER
   ,P_OLD_PROGRAM_UPDATE_DATE                IN DATE
   ,P_OLD_PROPORTION                         IN NUMBER
   ,P_OLD_REQUEST_ID                         IN NUMBER
 ) IS 

--
  /* LOCAL VARIABLE DECLARATIONS */
  L_BUSINESS_GROUP_ID         
   NUMBER;
Line: 87

    P_STATEMENT                    => 'SELECT '||P_OLD_BUSINESS_GROUP_ID||' FROM SYS.DUAL'
  );
Line: 147

    ACTION: INSERT
    GENERATED DATE:   27/11/2012 04:01
    DESCRIPTION: CONTINUOUS CALCULATION TRIGGER ON INSERT OF 
PAY_COST_ALLOCATIONS_F
    FULL TRIGGER NAME: PAY_COST_ALLOCATIONS_F_ARI
  ================================================
*/
--
PROCEDURE PAY_COST_ALLOCATIONS_F_ARI_ARI
(
    P_NEW_ASSIGNMENT_ID                      IN NUMBER
   
,P_NEW_BUSINESS_GROUP_ID                  IN NUMBER
   ,P_NEW_COST_ALLOCATION_ID                 IN NUMBER
   ,P_NEW_COST_ALLOCATION_KEYFLEX_           IN NUMBER
   ,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_PROGRAM_APPLICATION_ID             IN NUMBER
   ,P_NEW_PROGRAM_ID                         IN NUMBER
   
,P_NEW_PROGRAM_UPDATE_DATE                IN DATE
   ,P_NEW_PROPORTION                         IN NUMBER
   ,P_NEW_REQUEST_ID                         IN NUMBER
   ,P_NEW_VALIDATION_END_DATE                IN DATE
   ,P_NEW_VALIDATION_START_DATE          
    IN DATE
 ) IS 

--
  /* LOCAL VARIABLE DECLARATIONS */
  L_BUSINESS_GROUP_ID            NUMBER;
Line: 190

    P_STATEMENT                    => 'SELECT 
'||P_NEW_BUSINESS_GROUP_ID||' FROM SYS.DUAL'
  );
Line: 246

    ACTION: UPDATE
    GENERATED DATE:   27/11/2012 04:01
    DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON UPDATE OF 
PAY_COST_ALLOCATIONS_F
    FULL TRIGGER NAME: PAY_COST_ALLOCATIONS_F_ARU
  ================================================
*/
--
PROCEDURE PAY_COST_ALLOCATIONS_F_ARU_ARU
(
    P_NEW_ASSIGNMENT_ID                      IN NUMBER
   
,P_NEW_BUSINESS_GROUP_ID                  IN NUMBER
   ,P_NEW_COST_ALLOCATION_ID                 IN NUMBER
   ,P_NEW_COST_ALLOCATION_KEYFLEX_           IN NUMBER
   ,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_PROGRAM_APPLICATION_ID             IN NUMBER
   ,P_NEW_PROGRAM_ID
                         IN NUMBER
   ,P_NEW_PROGRAM_UPDATE_DATE                IN DATE
   ,P_NEW_PROPORTION                         IN NUMBER
   ,P_NEW_REQUEST_ID                         IN NUMBER
   ,P_NEW_VALIDATION_END_DATE                IN DATE
   
,P_NEW_VALIDATION_START_DATE              IN DATE
   ,P_OLD_ASSIGNMENT_ID                      IN NUMBER
   ,P_OLD_BUSINESS_GROUP_ID                  IN NUMBER
   ,P_OLD_COST_ALLOCATION_KEYFLEX_           IN NUMBER
   ,P_OLD_EFFECTIVE_END_DATE           
      IN DATE
   ,P_OLD_EFFECTIVE_START_DATE               IN DATE
   ,P_OLD_OBJECT_VERSION_NUMBER              IN NUMBER
   ,P_OLD_PROGRAM_APPLICATION_ID             IN NUMBER
   ,P_OLD_PROGRAM_ID                         IN NUMBER
   
,P_OLD_PROGRAM_UPDATE_DATE                IN DATE
   ,P_OLD_PROPORTION                         IN NUMBER
   ,P_OLD_REQUEST_ID                         IN NUMBER
 ) IS 

--
  /* LOCAL VARIABLE DECLARATIONS */
  L_BUSINESS_GROUP_ID            NUMBER;
Line: 304

    P_STATEMENT                    => 'SELECT '||P_OLD_BUSINESS_GROUP_ID||' FROM SYS.DUAL'
  );
Line: 339

    P_NEW_PROGRAM_UPDATE_DATE      => P_NEW_PROGRAM_UPDATE_DATE,
    P_NEW_PROPORTION               => P_NEW_PROPORTION,
    
P_NEW_REQUEST_ID               => P_NEW_REQUEST_ID,
    P_OLD_ASSIGNMENT_ID            => P_OLD_ASSIGNMENT_ID,
    P_OLD_BUSINESS_GROUP_ID        => P_OLD_BUSINESS_GROUP_ID,
    P_OLD_COST_ALLOCATION_ID       => P_NEW_COST_ALLOCATION_ID,
    
P_OLD_COST_ALLOCATION_KEYFLEX_ => P_OLD_COST_ALLOCATION_KEYFLEX_,
    P_OLD_EFFECTIVE_END_DATE       => P_OLD_EFFECTIVE_END_DATE,
    P_OLD_EFFECTIVE_START_DATE     => P_OLD_EFFECTIVE_START_DATE,
    P_OLD_PROGRAM_APPLICATION_ID   => 
P_OLD_PROGRAM_APPLICATION_ID,
    P_OLD_PROGRAM_ID               => P_OLD_PROGRAM_ID,
    P_OLD_PROGRAM_UPDATE_DATE      => P_OLD_PROGRAM_UPDATE_DATE,
    P_OLD_PROPORTION               => P_OLD_PROPORTION,
    P_OLD_REQUEST_ID               => 
P_OLD_REQUEST_ID
  );
Line: 383

    Name:   AFTER_INSERT
    Table:  PAY_COST_ALLOCATIONS_F
    Action: INSERT
    Generated Date:   27/11/2012 04:01
    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_COST_ALLOCATION_ID                     in NUMBER
   ,P_EFFECTIVE_START_DATE                   in DATE
   ,P_EFFECTIVE_END_DATE                     in DATE
   ,P_BUSINESS_GROUP_ID                      in NUMBER
   ,P_COST_ALLOCATION_KEYFLEX_ID         
    in NUMBER
   ,P_ASSIGNMENT_ID                          in NUMBER
   ,P_PROPORTION                             in NUMBER
   ,P_REQUEST_ID                             in NUMBER
   ,P_PROGRAM_APPLICATION_ID                 in NUMBER
   ,P_PROGRAM_ID    
                         in NUMBER
   ,P_PROGRAM_UPDATE_DATE                    in DATE
   ,P_OBJECT_VERSION_NUMBER                  in NUMBER
 ) IS 
  l_mode  varchar2(80);
Line: 421

AFTER_INSERT');
Line: 424

  pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;
Line: 443

     ,p_new_PROGRAM_UPDATE_DATE                => P_PROGRAM_UPDATE_DATE
     ,p_new_PROPORTION                         => P_PROPORTION
     ,p_new_REQUEST_ID                         => 
P_REQUEST_ID
     ,p_new_VALIDATION_END_DATE                => P_VALIDATION_END_DATE
     ,p_new_VALIDATION_START_DATE              => P_VALIDATION_START_DATE
    );
Line: 459

    hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
Line: 463

END  AFTER_INSERT;
Line: 475

    Name:   AFTER_UPDATE
    Table:  PAY_COST_ALLOCATIONS_F
    Action: UPDATE
    Generated Date:   27/11/2012 04:01
    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_COST_ALLOCATION_ID                     in NUMBER
   ,P_EFFECTIVE_START_DATE                   in DATE
   ,P_EFFECTIVE_END_DATE                     in DATE
   ,P_BUSINESS_GROUP_ID                    
  in NUMBER
   ,P_COST_ALLOCATION_KEYFLEX_ID             in NUMBER
   ,P_ASSIGNMENT_ID                          in NUMBER
   ,P_PROPORTION                             in NUMBER
   ,P_REQUEST_ID                             in NUMBER
   
,P_PROGRAM_APPLICATION_ID                 in NUMBER
   ,P_PROGRAM_ID                             in NUMBER
   ,P_PROGRAM_UPDATE_DATE                    in DATE
   ,P_OBJECT_VERSION_NUMBER                  in NUMBER
   ,P_EFFECTIVE_START_DATE_O           
      in DATE
   ,P_EFFECTIVE_END_DATE_O                   in DATE
   ,P_BUSINESS_GROUP_ID_O                    in NUMBER
   ,P_COST_ALLOCATION_KEYFLEX_ID_O           in NUMBER
   ,P_ASSIGNMENT_ID_O                        in NUMBER
   ,P_PROPORTION_O    
                       in NUMBER
   ,P_REQUEST_ID_O                           in NUMBER
   ,P_PROGRAM_APPLICATION_ID_O               in NUMBER
   ,P_PROGRAM_ID_O                           in NUMBER
   ,P_PROGRAM_UPDATE_DATE_O                  in DATE
   
,P_OBJECT_VERSION_NUMBER_O                in NUMBER
 ) IS 
  l_mode  varchar2(80);
Line: 527

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

     ,p_new_PROGRAM_UPDATE_DATE                => P_PROGRAM_UPDATE_DATE
     ,p_new_PROPORTION                         =>
 P_PROPORTION
     ,p_new_REQUEST_ID                         => P_REQUEST_ID
     ,p_new_VALIDATION_END_DATE                => P_VALIDATION_END_DATE
     ,p_new_VALIDATION_START_DATE              => P_VALIDATION_START_DATE
     ,p_old_ASSIGNMENT_ID      
                => P_ASSIGNMENT_ID_O
     ,p_old_BUSINESS_GROUP_ID                  => P_BUSINESS_GROUP_ID_O
     ,p_old_COST_ALLOCATION_KEYFLEX_           => P_COST_ALLOCATION_KEYFLEX_ID_O
     ,p_old_EFFECTIVE_END_DATE                 => 
P_EFFECTIVE_END_DATE_O
     ,p_old_EFFECTIVE_START_DATE               => P_EFFECTIVE_START_DATE_O
     ,p_old_OBJECT_VERSION_NUMBER              => P_OBJECT_VERSION_NUMBER_O
     ,p_old_PROGRAM_APPLICATION_ID             => P_PROGRAM_APPLICATION_ID_O
   
  ,p_old_PROGRAM_ID                         => P_PROGRAM_ID_O
     ,p_old_PROGRAM_UPDATE_DATE                => P_PROGRAM_UPDATE_DATE_O
     ,p_old_PROPORTION                         => P_PROPORTION_O
     ,p_old_REQUEST_ID                         => 
P_REQUEST_ID_O
    );
Line: 581

    hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
Line: 585

END  AFTER_UPDATE;
Line: 597

    Name:   AFTER_DELETE
    Table:  PAY_COST_ALLOCATIONS_F
    Action: DELETE
    Generated Date:   27/11/2012 04:01
    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_COST_ALLOCATION_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_BUSINESS_GROUP_ID_O                    in NUMBER
   ,P_COST_ALLOCATION_KEYFLEX_ID_O           in NUMBER
   ,P_ASSIGNMENT_ID_O                        in NUMBER
   ,P_PROPORTION_O        
                   in NUMBER
   ,P_REQUEST_ID_O                           in NUMBER
   ,P_PROGRAM_APPLICATION_ID_O               in NUMBER
   ,P_PROGRAM_ID_O                           in NUMBER
   ,P_PROGRAM_UPDATE_DATE_O                  in DATE
   
,P_OBJECT_VERSION_NUMBER_O                in NUMBER
 ) IS 
  l_mode  varchar2(80);
Line: 638

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

     ,p_old_PROGRAM_UPDATE_DATE          
      => P_PROGRAM_UPDATE_DATE_O
     ,p_old_PROPORTION                         => P_PROPORTION_O
     ,p_old_REQUEST_ID                         => P_REQUEST_ID_O
    );
Line: 681

    hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
Line: 685

END  AFTER_DELETE;