APPS.PAY_DYT_DURATION_SUMMARY_PKG SQL Statements

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

Line: 40

    ACTION: DELETE
    GENERATED DATE:   03/01/2007 23:17
    DESCRIPTION: INCIDENT REGISTER TRIGGER ON DELETE OF 
PQP_GAP_DURATION_SUMMARY 
    FULL TRIGGER NAME: PQP_GAP_DURATION_SUMMARY_ARD
  ================================================
*/
--
PROCEDURE PQP_GAP_DURATION_SUMMARY_A_ARD
(
    P_OLD_ASSIGNMENT_ID                      IN NUMBER
   ,P_OLD_DATE_START 
                        IN DATE
   ,P_OLD_GAP_DURATION_SUMMARY_ID            IN NUMBER
 ) IS 

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

Line: 74

  SELECT BUSINESS_GROUP_ID
  INTO   L_BUSINESS_GROUP_ID
  FROM PER_ASSIGNMENTS_F WHERE  ASSIGNMENT_ID = L_ASSIGNMENT_ID AND L_DATE_START BETWEEN 
EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE; 

Line: 79

  SELECT LEGISLATION_CODE
  INTO   L_LEGISLATION_CODE
  FROM PER_BUSINESS_GROUPS WHERE  BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID; 

Line: 131

    ACTION: INSERT
    GENERATED DATE:   03/01/2007 23:17
    DESCRIPTION: INCIDENT REGISTER TRIGGER ON INSERT OF 
PQP_GAP_DURATION_SUMMARY 
    FULL TRIGGER NAME: PQP_GAP_DURATION_SUMMARY_ARI
  ================================================
*/
--
PROCEDURE PQP_GAP_DURATION_SUMMARY_A_ARI
(
    P_NEW_ASSIGNMENT_ID                      IN NUMBER
   ,P_NEW_DATE_END   
                        IN DATE
   ,P_NEW_DATE_START                         IN DATE
   ,P_NEW_DURATION_IN_DAYS                   IN NUMBER
   ,P_NEW_DURATION_IN_HOURS                  IN NUMBER
   ,P_NEW_GAP_DURATION_SUMMARY_ID            IN NUMBER
   
,P_NEW_GAP_LEVEL                          IN VARCHAR2
   ,P_NEW_SUMMARY_TYPE                       IN VARCHAR2
 ) IS 

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

Line: 171

  SELECT BUSINESS_GROUP_ID
  INTO   L_BUSINESS_GROUP_ID
  FROM PER_ASSIGNMENTS_F WHERE  ASSIGNMENT_ID = L_ASSIGNMENT_ID AND 
L_DATE_START BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE; 

Line: 176

  SELECT LEGISLATION_CODE
  INTO   L_LEGISLATION_CODE
  FROM PER_BUSINESS_GROUPS WHERE  BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID; 

Line: 228

    ACTION: UPDATE
    GENERATED DATE:   03/01/2007 23:17
    DESCRIPTION: INCIDENT REGISTER TRIGGER ON UPDATE OF 
PQP_GAP_DURATION_SUMMARY 
    FULL TRIGGER NAME: PQP_GAP_DURATION_SUMMARY_ARU
  ================================================
*/
--
PROCEDURE PQP_GAP_DURATION_SUMMARY_A_ARU
(
    P_NEW_ASSIGNMENT_ID                      IN NUMBER
   ,P_NEW_DATE_END   
                        IN DATE
   ,P_NEW_DATE_START                         IN DATE
   ,P_NEW_DURATION_IN_DAYS                   IN NUMBER
   ,P_NEW_DURATION_IN_HOURS                  IN NUMBER
   ,P_NEW_GAP_DURATION_SUMMARY_ID            IN NUMBER
   
,P_NEW_GAP_LEVEL                          IN VARCHAR2
   ,P_NEW_SUMMARY_TYPE                       IN VARCHAR2
   ,P_OLD_ASSIGNMENT_ID                      IN NUMBER
   ,P_OLD_DATE_END                           IN DATE
   ,P_OLD_DATE_START               
          IN DATE
   ,P_OLD_DURATION_IN_DAYS                   IN NUMBER
   ,P_OLD_DURATION_IN_HOURS                  IN NUMBER
   ,P_OLD_GAP_LEVEL                          IN VARCHAR2
   ,P_OLD_SUMMARY_TYPE                       IN VARCHAR2
 ) IS 

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

Line: 277

  SELECT BUSINESS_GROUP_ID
  INTO   L_BUSINESS_GROUP_ID
  FROM PER_ASSIGNMENTS_F WHERE  ASSIGNMENT_ID = L_ASSIGNMENT_ID AND L_DATE_START BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE; 

Line: 281

  SELECT LEGISLATION_CODE
  INTO   L_LEGISLATION_CODE
 
 FROM PER_BUSINESS_GROUPS WHERE  BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID; 

Line: 342

    Name:   AFTER_INSERT
    Table:  PQP_GAP_DURATION_SUMMARY
    Action: INSERT
    Generated Date:   03/01/2007 23:17
    Description: Called as part of INSERT process
  
================================================
*/

--
PROCEDURE AFTER_INSERT
(
    P_GAP_DURATION_SUMMARY_ID                in NUMBER
   ,P_ASSIGNMENT_ID                          in NUMBER
   ,P_GAP_ABSENCE_PLAN_ID                    in NUMBER
   
,P_SUMMARY_TYPE                           in VARCHAR2
   ,P_GAP_LEVEL                              in VARCHAR2
   ,P_DURATION_IN_DAYS                       in NUMBER
   ,P_DURATION_IN_HOURS                      in NUMBER
   ,P_DATE_START                 
            in DATE
   ,P_DATE_END                               in DATE
   ,P_OBJECT_VERSION_NUMBER                  in NUMBER
 ) IS 
  l_mode  varchar2(80);

Line: 373

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

Line: 377

  pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;

Line: 403

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

Line: 407

END  AFTER_INSERT;

Line: 419

    Name:   AFTER_UPDATE
    Table:  PQP_GAP_DURATION_SUMMARY
    Action: UPDATE
    Generated Date:   03/01/2007 23:17
    Description: Called as part of UPDATE process
  
================================================
*/

--
PROCEDURE AFTER_UPDATE
(
    P_GAP_DURATION_SUMMARY_ID                in NUMBER
   ,P_ASSIGNMENT_ID                          in NUMBER
   ,P_GAP_ABSENCE_PLAN_ID                    in NUMBER
   
,P_SUMMARY_TYPE                           in VARCHAR2
   ,P_GAP_LEVEL                              in VARCHAR2
   ,P_DURATION_IN_DAYS                       in NUMBER
   ,P_DURATION_IN_HOURS                      in NUMBER
   ,P_DATE_START                 
            in DATE
   ,P_DATE_END                               in DATE
   ,P_OBJECT_VERSION_NUMBER                  in NUMBER
   ,P_ASSIGNMENT_ID_O                        in NUMBER
   ,P_GAP_ABSENCE_PLAN_ID_O                  in NUMBER
   
,P_SUMMARY_TYPE_O                         in VARCHAR2
   ,P_GAP_LEVEL_O                            in VARCHAR2
   ,P_DURATION_IN_DAYS_O                     in NUMBER
   ,P_DURATION_IN_HOURS_O                    in NUMBER
   ,P_DATE_START_O               
            in DATE
   ,P_DATE_END_O                             in DATE
   ,P_OBJECT_VERSION_NUMBER_O                in NUMBER
 ) IS 
  l_mode  varchar2(80);

Line: 461

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

Line: 500

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

Line: 504

END  AFTER_UPDATE;

Line: 516

    Name:   AFTER_DELETE
    Table:  PQP_GAP_DURATION_SUMMARY
    Action: DELETE
    Generated Date:   03/01/2007 23:17
    Description: Called as part of DELETE process
  
================================================
*/

--
PROCEDURE AFTER_DELETE
(
    P_GAP_DURATION_SUMMARY_ID                in NUMBER
   ,P_ASSIGNMENT_ID_O                        in NUMBER
   ,P_GAP_ABSENCE_PLAN_ID_O                  in NUMBER
   
,P_SUMMARY_TYPE_O                         in VARCHAR2
   ,P_GAP_LEVEL_O                            in VARCHAR2
   ,P_DURATION_IN_DAYS_O                     in NUMBER
   ,P_DURATION_IN_HOURS_O                    in NUMBER
   ,P_DATE_START_O               
            in DATE
   ,P_DATE_END_O                             in DATE
   ,P_OBJECT_VERSION_NUMBER_O                in NUMBER
 ) IS 
  l_mode  varchar2(80);

Line: 547

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

Line: 570

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

Line: 575

END  AFTER_DELETE;