APPS.PQP_GET_DATE_MODE SQL Statements

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

Line: 14

  ,p_update                 out nocopy number
  ,p_update_override        out nocopy number
  ,p_update_change_insert   out nocopy number
  )

IS
l_correction                 BOOLEAN;

Line: 21

l_update                     BOOLEAN;

Line: 22

l_update_override            BOOLEAN;

Line: 23

l_update_change_insert       BOOLEAN;

Line: 32

    ,p_update                => l_update
    ,p_update_override       => l_update_override
    ,p_update_change_insert  => l_update_change_insert
    );

Line: 44

 IF l_update THEN
  p_update :=1;

Line: 47

  p_update :=0;

Line: 50

 IF l_update_override  THEN
  p_update_override :=1;

Line: 53

  p_update_override :=0;

Line: 56

 IF l_update_change_insert  THEN
  p_update_change_insert :=1;

Line: 59

  p_update_change_insert :=0;

Line: 75

  ,p_delete                out nocopy number
  ,p_future_change         out nocopy number
  ,p_delete_next_change    out nocopy number
  )

IS
l_zap                         BOOLEAN;

Line: 82

l_delete                      BOOLEAN;

Line: 84

l_delete_next_change          BOOLEAN;

Line: 93

   ,p_delete                        => l_delete
   ,p_future_change                 => l_future_change
   ,p_delete_next_change            => l_delete_next_change
   );

Line: 104

 IF l_delete  THEN
  p_delete:=1;

Line: 107

  p_delete:=0;

Line: 116

 IF l_delete_next_change  THEN
  p_delete_next_change:=0;

Line: 119

  p_delete_next_change:=0;