eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DYT_GLOBALS_PKG SQL Statements

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

Line: 40


    ACTION: DELETE
    GENERATED DATE:   06/11/2008 01:53
    DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON DELETE OF FF_GLOBALS_F
    FULL
 TRIGGER NAME: FF_GLOBALS_F_ARD
  ================================================
*/
--
PROCEDURE FF_GLOBALS_F_ARD_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_GLOBAL_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_DATA_TYPE                          IN VARCHAR2
   ,P_OLD_EFFECTIVE_END_DATE                 IN DATE
   ,P_OLD_EFFECTIVE_START_DATE               IN DATE
   
,P_OLD_GLOBAL_DESCRIPTION                 IN VARCHAR2
   ,P_OLD_GLOBAL_NAME                        IN VARCHAR2
   ,P_OLD_GLOBAL_VALUE                       IN VARCHAR2
   ,P_OLD_LEGISLATION_CODE                   IN VARCHAR2
   
,P_OLD_OBJECT_VERSION_NUMBER              IN NUMBER
 ) IS 

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

Line: 84


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

Line: 143


    ACTION: INSERT
    GENERATED DATE:   06/11/2008 01:53
    DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON INSERT OF FF_GLOBALS_F
    FULL
 TRIGGER NAME: FF_GLOBALS_F_ARI
  ================================================
*/
--
PROCEDURE FF_GLOBALS_F_ARI_ARI
(
    P_NEW_BUSINESS_GROUP_ID                  IN NUMBER
   ,P_NEW_DATA_TYPE                          IN VARCHAR2
   
,P_NEW_EFFECTIVE_DATE                     IN DATE
   ,P_NEW_EFFECTIVE_END_DATE                 IN DATE
   ,P_NEW_EFFECTIVE_START_DATE               IN DATE
   ,P_NEW_GLOBAL_DESCRIPTION                 IN VARCHAR2
   ,P_NEW_GLOBAL_ID                      
    IN NUMBER
   ,P_NEW_GLOBAL_NAME                        IN VARCHAR2
   ,P_NEW_GLOBAL_VALUE                       IN VARCHAR2
   ,P_NEW_LEGISLATION_CODE                   IN VARCHAR2
   ,P_NEW_OBJECT_VERSION_NUMBER              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: 184


    P_STATEMENT                    => 'SELECT BUSINESS_GROUP_ID FROM FF_GLOBALS_F '||' WHERE GLOBAL_ID = '|| P_NEW_GLOBAL_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') 
BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE'
  );

Line: 239


    ACTION: UPDATE
    GENERATED DATE:   06/11/2008 01:53
    DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON UPDATE OF FF_GLOBALS_F
    FULL
 TRIGGER NAME: FF_GLOBALS_F_ARU
  ================================================
*/
--
PROCEDURE FF_GLOBALS_F_ARU_ARU
(
    P_NEW_BUSINESS_GROUP_ID                  IN NUMBER
   ,P_NEW_DATA_TYPE                          IN VARCHAR2
   
,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_GLOBAL_DESCRIPTION             
    IN VARCHAR2
   ,P_NEW_GLOBAL_ID                          IN NUMBER
   ,P_NEW_GLOBAL_NAME                        IN VARCHAR2
   ,P_NEW_GLOBAL_VALUE                       IN VARCHAR2
   ,P_NEW_LEGISLATION_CODE                   IN VARCHAR2
   
,P_NEW_OBJECT_VERSION_NUMBER              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_DATA_TYPE                      
    IN VARCHAR2
   ,P_OLD_EFFECTIVE_END_DATE                 IN DATE
   ,P_OLD_EFFECTIVE_START_DATE               IN DATE
   ,P_OLD_GLOBAL_DESCRIPTION                 IN VARCHAR2
   ,P_OLD_GLOBAL_NAME                        IN VARCHAR2
   
,P_OLD_GLOBAL_VALUE                       IN VARCHAR2
   ,P_OLD_LEGISLATION_CODE                   IN VARCHAR2
   ,P_OLD_OBJECT_VERSION_NUMBER              IN NUMBER
 ) IS 

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

Line: 292


    P_STATEMENT                    => 'SELECT BUSINESS_GROUP_ID FROM FF_GLOBALS_F WHERE GLOBAL_ID = ' ||P_NEW_GLOBAL_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 
'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE'
  );

Line: 361


    Name:   AFTER_INSERT
    Table:  FF_GLOBALS_F
    Action: INSERT
    Generated Date:   06/11/2008 01:53
    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_GLOBAL_ID                              in NUMBER
   ,P_EFFECTIVE_START_DATE                   in DATE
   ,P_EFFECTIVE_END_DATE                     in DATE
   ,P_BUSINESS_GROUP_ID                      in NUMBER
   ,P_LEGISLATION_CODE                   
    in VARCHAR2
   ,P_DATA_TYPE                              in VARCHAR2
   ,P_GLOBAL_NAME                            in VARCHAR2
   ,P_GLOBAL_DESCRIPTION                     in VARCHAR2
   ,P_GLOBAL_VALUE                           in VARCHAR2
   
,P_OBJECT_VERSION_NUMBER                  in NUMBER
 ) IS 
  l_mode  varchar2(80);

Line: 396


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

Line: 400


  pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;

Line: 432


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

Line: 436


END  AFTER_INSERT;

Line: 448


    Name:   AFTER_UPDATE
    Table:  FF_GLOBALS_F
    Action: UPDATE
    Generated Date:   06/11/2008 01:53
    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_GLOBAL_ID                              in NUMBER
   ,P_EFFECTIVE_START_DATE                   in DATE
   ,P_EFFECTIVE_END_DATE                     in DATE
   ,P_BUSINESS_GROUP_ID                    
  in NUMBER
   ,P_LEGISLATION_CODE                       in VARCHAR2
   ,P_DATA_TYPE                              in VARCHAR2
   ,P_GLOBAL_NAME                            in VARCHAR2
   ,P_GLOBAL_DESCRIPTION                     in VARCHAR2
   
,P_GLOBAL_VALUE                           in VARCHAR2
   ,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_LEGISLATION_CODE_O                     in VARCHAR2
   ,P_DATA_TYPE_O                            in VARCHAR2
   ,P_GLOBAL_NAME_O                          in VARCHAR2
   ,P_GLOBAL_DESCRIPTION_O                   in VARCHAR2
   
,P_GLOBAL_VALUE_O                         in VARCHAR2
   ,P_OBJECT_VERSION_NUMBER_O                in NUMBER
 ) IS 
  l_mode  varchar2(80);

Line: 495


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

Line: 544


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

Line: 548


END  AFTER_UPDATE;

Line: 560


    Name:   AFTER_DELETE
    Table:  FF_GLOBALS_F
    Action: DELETE
    Generated Date:   06/11/2008 01:53
    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_GLOBAL_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_LEGISLATION_CODE_O                     in VARCHAR2
   ,P_DATA_TYPE_O                            in VARCHAR2
   ,P_GLOBAL_NAME_O   
                       in VARCHAR2
   ,P_GLOBAL_DESCRIPTION_O                   in VARCHAR2
   ,P_GLOBAL_VALUE_O                         in VARCHAR2
   ,P_OBJECT_VERSION_NUMBER_O                in NUMBER
 ) IS 
  l_mode  varchar2(80);

Line: 599


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

Line: 638


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

Line: 642


END  AFTER_DELETE;