APPS.BEN_CREATE_PTNL_LER_SS SQL Statements

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

Line: 35

    ,p_program_update_date            in  varchar2  default null
    ,p_object_version_number          out nocopy varchar2
    ,p_effective_date                 in  varchar2
    ,p_item_type                      in  varchar2
    ,p_item_key                       in  varchar2
    ,p_activity_id                    in  varchar2
    ,p_login_person_id                in  varchar2  default null
    ,P_flow_mode                      in  varchar2
    ,p_subflow_mode                   in  varchar2
    ,p_life_event_name                in  varchar2
    ,p_transaction_step_id            out nocopy varchar2
    ,p_error_message                  out nocopy long
    ,p_hire_dt                        in  varchar2  default null
) is

    l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type := to_number(p_ptnl_ler_for_per_id);

Line: 57

    select ler.ocrd_dt_det_cd
    from ben_ler_f ler
    where  ler.business_group_id = to_number(p_business_group_id)
    and ler.ler_id = to_number(p_ler_id)
    and to_date(p_effective_date,hr_transaction_ss.g_date_format)
        between ler.effective_start_date
        and     ler.effective_end_date;

Line: 115

    ,p_program_update_date           => to_date(p_program_update_date,hr_transaction_ss.g_date_format) -- in  date      default null
    ,p_object_version_number         => l_object_version_number                                      --out number
    ,p_effective_date                => to_date(p_effective_date,hr_transaction_ss.g_date_format)    -- in  date
    ,p_item_type                     => p_item_type                                                  -- in  varchar2
    ,p_item_key                      => p_item_key                                                   -- in  varchar2
    ,p_activity_id                   => to_number(p_activity_id)                                     -- in  number
    ,p_login_person_id               => to_number(p_login_person_id)                                 -- in     number default null
    ,P_flow_mode                     => P_flow_mode                                                  -- in  varchar2 -- This may have a value of Insert, Update
    ,p_subflow_mode                  => p_subflow_mode                                               -- in  varchar2
    ,p_life_event_name               => p_life_event_name                                            -- in  varchar2
    ,p_transaction_step_id           => l_transaction_step_id                                        -- out number
    ,p_error_message                 => p_error_message                                              -- out long
    );

Line: 160

    ,p_program_update_date            in  date      default null
    ,p_object_version_number          out nocopy number
    ,p_effective_date                 in  date
    ,p_item_type                      in  varchar2
    ,p_item_key                       in  varchar2
    ,p_activity_id                    in  number
    ,p_login_person_id                in     number default null
    ,P_flow_mode                      in  varchar2 -- This may have a value of Insert, Update
    ,p_subflow_mode                   in  varchar2  -- This may have a value of Insert and Cobra
    ,p_life_event_name                in  varchar2
    ,p_transaction_step_id            out nocopy number
    ,p_error_message                  out nocopy long
    ) IS

    --declare a cursor to check if the person actually exists in the database
    cursor csr_person is select person_id from per_all_people_f where person_id = p_person_id;

Line: 263

  ,p_program_update_date          =>  p_program_update_date          -- in  date      default null
  ,p_object_version_number        =>  p_object_version_number        -- out number
  ,p_effective_date               =>  p_effective_date               --in  date
  );

Line: 440

 	l_transaction_table(l_count).param_name := 'P_PROGRAM_UPDATE_DATE';

Line: 441

 	l_transaction_table(l_count).param_value := to_char(p_program_update_date,
                                                    hr_transaction_ss.g_date_format);

Line: 572

   ,p_program_update_date             out nocopy date      -- in  date      default null
   ,p_effective_date                  out nocopy date
   ,p_flow_mode                       in varchar2
   ,p_subflow_mode                    in varchar2
   ,p_life_event_name                 out nocopy varchar2
) is
   l_transaction_id hr_api_transaction_steps.transaction_id%type default null;

Line: 628

   ,p_program_update_date             => p_program_update_date
   ,p_effective_date                  => p_effective_date
   ,p_flow_mode                       => p_flow_mode
   ,p_subflow_mode                    => p_subflow_mode
   ,p_life_event_name                 => p_life_event_name
);

Line: 673

   ,p_program_update_date             out nocopy date      -- in  date      default null
   ,p_effective_date                  out nocopy date
   ,p_flow_mode                       in varchar2
   ,p_subflow_mode                    in varchar2
   ,p_life_event_name                 out nocopy varchar2
)is
l_proc varchar2(72)  := g_package||'GET_PTNL_LER_DATA_FROM_TT';

Line: 770

  p_program_update_date :=
    hr_transaction_api.get_date_value
    (p_transaction_step_id => p_transaction_step_id
    ,p_name                => 'P_PROGRAM_UPDATE_DATE');

Line: 940

  l_ptnl_ler.program_update_date :=
    hr_transaction_api.get_date_value
    (p_transaction_step_id => p_transaction_step_id
    ,p_name                => 'P_PROGRAM_UPDATE_DATE');

Line: 993

  ,p_program_update_date          =>  l_ptnl_ler.program_update_date          -- in  date      default null
  ,p_object_version_number        =>  l_ovn                                     -- out number
  ,p_effective_date               =>  l_effective_date               --in  date
  );

Line: 1018

select transaction_step_id
,      object_version_number
from hr_api_transaction_steps
where item_type=p_item_type
and   item_key=p_item_key
--and   activity_id = p_activity_id --because when this is called from review page the activity id is different
and   api_name=p_api_name;