DBA Data[Home] [Help]

APPS.PAY_DYT_ELEMENT_ENTRY_VAL_PKG SQL Statements

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

Line: 40

    ACTION: UPDATE
    GENERATED DATE:   30/03/2009 04:53
    DESCRIPTION: CONTINUOUS CALCULATION TRIGGER ON UPDATE
 OF ELEMENT ENTRY VALUE
    FULL TRIGGER NAME: PAY_ELEMENT_ENTRY_VALUES_F_ARU
  ================================================
*/
--
PROCEDURE PAY_ELEMENT_ENTRY_VALUES_F_ARU
(
    P_NEW_EFFECTIVE_END_DATE                 IN DATE
   
,P_NEW_EFFECTIVE_START_DATE               IN DATE
   ,P_NEW_ELEMENT_ENTRY_ID                   IN NUMBER
   ,P_NEW_ELEMENT_ENTRY_VALUE_ID             IN NUMBER
   ,P_NEW_INPUT_VALUE_ID                     IN NUMBER
   ,P_NEW_SCREEN_ENTRY_VALUE           
      IN VARCHAR2
   ,P_OLD_EFFECTIVE_END_DATE                 IN DATE
   ,P_OLD_EFFECTIVE_START_DATE               IN DATE
   ,P_OLD_ELEMENT_ENTRY_ID                   IN NUMBER
   ,P_OLD_ELEMENT_ENTRY_VALUE_ID             IN NUMBER
   
,P_OLD_INPUT_VALUE_ID                     IN NUMBER
   ,P_OLD_SCREEN_ENTRY_VALUE                 IN VARCHAR2
 ) IS 

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

    P_STATEMENT                    => 'SELECT PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF, PAY_ELEMENT_ENTRIES_F PEE WHERE PEE.ELEMENT_ENTRY_ID = '||P_OLD_ELEMENT_ENTRY_ID||' AND 
TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN 
PEE.EFFECTIVE_START_DATE AND PEE.EFFECTIVE_END_DATE AND PAF.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID'
  );
Line: 129

    ACTION: INSERT
    GENERATED DATE:   30/03/2009 04:53
    DESCRIPTION: SPANISH TRIGGER FOR SOCIAL SECURITY REPORTING
   
 FULL TRIGGER NAME: ES_SS_REP_ELEMENT_I
  ================================================
*/
--
PROCEDURE ES_SS_REP_ELEMENT_I_I
(
    P_NEW_EFFECTIVE_END_DATE                 IN DATE
   ,P_NEW_EFFECTIVE_START_DATE               IN DATE
   
,P_NEW_ELEMENT_ENTRY_ID                   IN NUMBER
   ,P_NEW_ELEMENT_ENTRY_VALUE_ID             IN NUMBER
   ,P_NEW_INPUT_VALUE_ID                     IN NUMBER
   ,P_NEW_SCREEN_ENTRY_VALUE                 IN VARCHAR2
   ,P_OLD_EFFECTIVE_END_DATE       
          IN DATE
   ,P_OLD_EFFECTIVE_START_DATE               IN DATE
   ,P_OLD_ELEMENT_ENTRY_ID                   IN NUMBER
   ,P_OLD_ELEMENT_ENTRY_VALUE_ID             IN NUMBER
   ,P_OLD_INPUT_VALUE_ID                     IN NUMBER
   
,P_OLD_SCREEN_ENTRY_VALUE                 IN VARCHAR2
 ) IS 

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

  SELECT LEGISLATION_CODE
  INTO   L_LEGISLATION_CODE
  FROM PER_BUSINESS_GROUPS WHERE BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID;
Line: 192

    PER_ES_SS_REP_DYN_TRG.ELEMENT_CHECK_INSERT(
      P_EFFECTIVE_END_DATE           => P_NEW_EFFECTIVE_END_DATE,
      P_EFFECTIVE_START_DATE         => 
P_NEW_EFFECTIVE_START_DATE,
      P_ELEMENT_ENTRY_ID             => P_NEW_ELEMENT_ENTRY_ID,
      P_EPIGRAPH_CODE                => P_NEW_SCREEN_ENTRY_VALUE,
      P_INPUT_VALUE_ID               => P_NEW_INPUT_VALUE_ID
    );
Line: 226

    ACTION: UPDATE
    GENERATED DATE:   30/03/2009 04:53
    DESCRIPTION: SPANISH TRIGGER FOR SOCIAL SECURITY REPORTING
   
 FULL TRIGGER NAME: ES_SS_REP_ELEMENT_U
  ================================================
*/
--
PROCEDURE ES_SS_REP_ELEMENT_U_U
(
    P_NEW_EFFECTIVE_END_DATE                 IN DATE
   ,P_NEW_EFFECTIVE_START_DATE               IN DATE
   
,P_NEW_ELEMENT_ENTRY_ID                   IN NUMBER
   ,P_NEW_ELEMENT_ENTRY_VALUE_ID             IN NUMBER
   ,P_NEW_INPUT_VALUE_ID                     IN NUMBER
   ,P_NEW_SCREEN_ENTRY_VALUE                 IN VARCHAR2
   ,P_OLD_EFFECTIVE_END_DATE       
          IN DATE
   ,P_OLD_EFFECTIVE_START_DATE               IN DATE
   ,P_OLD_ELEMENT_ENTRY_ID                   IN NUMBER
   ,P_OLD_ELEMENT_ENTRY_VALUE_ID             IN NUMBER
   ,P_OLD_INPUT_VALUE_ID                     IN NUMBER
   
,P_OLD_SCREEN_ENTRY_VALUE                 IN VARCHAR2
 ) IS 

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

  SELECT LEGISLATION_CODE
  INTO   L_LEGISLATION_CODE
  FROM PER_BUSINESS_GROUPS WHERE BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID;
Line: 289

    PER_ES_SS_REP_DYN_TRG.ELEMENT_CHECK_UPDATE(
      P_EFFECTIVE_END_DATE           => P_NEW_EFFECTIVE_END_DATE,
      P_EFFECTIVE_START_DATE         => 
P_NEW_EFFECTIVE_START_DATE,
      P_ELEMENT_ENTRY_ID             => P_NEW_ELEMENT_ENTRY_ID,
      P_EPIGRAPH_CODE                => P_NEW_SCREEN_ENTRY_VALUE,
      P_INPUT_VALUE_ID               => P_NEW_INPUT_VALUE_ID
    );
Line: 321

    Name:   AFTER_INSERT
    Table:  PAY_ELEMENT_ENTRY_VALUES_F
    Action: INSERT
    Generated Date:   30/03/2009 04:53
    Description: Called as part of INSERT process
  
================================================
*/

--
PROCEDURE AFTER_INSERT
(
    P_EFFECTIVE_END_DATE                     in DATE
   ,P_EFFECTIVE_START_DATE                   in DATE
   ,P_ELEMENT_ENTRY_ID                       in NUMBER
   
,P_ELEMENT_ENTRY_VALUE_ID                 in NUMBER
   ,P_INPUT_VALUE_ID                         in NUMBER
   ,P_SCREEN_ENTRY_VALUE                     in VARCHAR2
   ,P_EFFECTIVE_END_DATE_O                   in DATE
   ,P_EFFECTIVE_START_DATE_O         
        in DATE
   ,P_ELEMENT_ENTRY_ID_O                     in NUMBER
   ,P_ELEMENT_ENTRY_VALUE_ID_O               in NUMBER
   ,P_INPUT_VALUE_ID_O                       in NUMBER
   ,P_SCREEN_ENTRY_VALUE_O                   in VARCHAR2
 ) IS 
  l_mode 
 varchar2(80);
Line: 355

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

hr_api.g_insert;
Line: 390

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

END  AFTER_INSERT;
Line: 406

    Name:   AFTER_UPDATE
    Table:  PAY_ELEMENT_ENTRY_VALUES_F
    Action: UPDATE
    Generated Date:   30/03/2009 04:53
    Description: Called as part of UPDATE process
  
================================================
*/

--
PROCEDURE AFTER_UPDATE
(
    P_EFFECTIVE_END_DATE                     in DATE
   ,P_EFFECTIVE_START_DATE                   in DATE
   ,P_ELEMENT_ENTRY_ID                       in NUMBER
   
,P_ELEMENT_ENTRY_VALUE_ID                 in NUMBER
   ,P_INPUT_VALUE_ID                         in NUMBER
   ,P_SCREEN_ENTRY_VALUE                     in VARCHAR2
   ,P_EFFECTIVE_END_DATE_O                   in DATE
   ,P_EFFECTIVE_START_DATE_O         
        in DATE
   ,P_ELEMENT_ENTRY_ID_O                     in NUMBER
   ,P_ELEMENT_ENTRY_VALUE_ID_O               in NUMBER
   ,P_INPUT_VALUE_ID_O                       in NUMBER
   ,P_SCREEN_ENTRY_VALUE_O                   in VARCHAR2
   
,P_DATETRACK_MODE                         in VARCHAR2
 ) IS 
  l_mode  varchar2(80);
Line: 441

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

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

END  AFTER_UPDATE;
Line: 515

    Name:   AFTER_DELETE
    Table:  PAY_ELEMENT_ENTRY_VALUES_F
    Action: DELETE
    Generated Date:   30/03/2009 04:53
    Description: Called as part of DELETE process
  
================================================
*/

--
PROCEDURE AFTER_DELETE
(
    P_EFFECTIVE_END_DATE                     in DATE
   ,P_EFFECTIVE_START_DATE                   in DATE
   ,P_ELEMENT_ENTRY_ID                       in NUMBER
   
,P_ELEMENT_ENTRY_VALUE_ID                 in NUMBER
   ,P_INPUT_VALUE_ID                         in NUMBER
   ,P_SCREEN_ENTRY_VALUE                     in VARCHAR2
   ,P_VALIDATION_END_DATE                    in DATE
   ,P_VALIDATION_START_DATE          
        in DATE
   ,P_ELEMENT_ENTRY_ID_O                     in NUMBER
   ,P_ELEMENT_ENTRY_VALUE_ID_O               in NUMBER
   ,P_INPUT_VALUE_ID_O                       in NUMBER
   ,P_SCREEN_ENTRY_VALUE_O                   in VARCHAR2
   
,P_DATETRACK_MODE                         in VARCHAR2
 ) IS 
  l_mode  varchar2(80);
Line: 550

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

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

END  AFTER_DELETE;