APPS.PQH_BDGT_REALLOC_LOG_PKG SQL Statements

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

Line: 10

  SELECT table_route_id
  FROM   pqh_table_route
  WHERE  table_alias =  'BPL';

Line: 30

     SELECT process_log_id
     FROM   pqh_process_log
     WHERE  txn_id = p_folder_id
     AND    module_cd = 'BUDGET_REALLOCATION';

Line: 36

    IS SELECT process_log_id,
              txn_id,
              information_category
     FROM     pqh_process_log
     START WITH txn_id = p_transaction_id
     AND        master_process_log_id     =  p_batch_id
     AND        module_cd = 'BUDGET_REALLOCATION'
     CONNECT BY PRIOR  process_log_id = master_process_log_id;

Line: 80

SELECT fld.name,
       pb.budget_name||'-'||bvr.version_number,
       pb.budgeted_entity_cd,
       fld.budget_unit_id
FROM   pqh_budget_pools fld,
       pqh_budgets pb,
       pqh_budget_versions bvr
WHERE  fld.pool_id = p_folder_id
AND    fld.budget_version_id = bvr.budget_version_id
AND    bvr.budget_id = pb.budget_id;

Line: 118

   SELECT name
   FROM   pqh_budget_pools
   WHERE  pool_id = p_transaction_id;

Line: 145

  hr_utility.set_location('Inserted a row for Transaction Level '||l_proc,20);

Line: 158

  hr_utility.set_location('Inserted a row for Transaction-Donor Level '||l_proc,25);

Line: 170

  hr_utility.set_location('Inserted a row for Transaction-Receiver Level '||l_proc,25);

Line: 174

  hr_utility.set_location('Inserted a row for Transaction-Receive Level. Leaving '||l_proc,25);

Line: 221

SELECT COUNT(*)
FROM pqh_process_log
WHERE message_type_cd = p_message_type_cd
START WITH  process_log_id = p_start_log_id
CONNECT BY PRIOR process_log_id = master_process_log_id;

Line: 281

    update the 'start' record for this transaction with message_type_cd = 'COMPLETE'
  */
   UPDATE pqh_process_log
   SET message_type_cd = DECODE(message_type_cd,'ERROR',message_type_cd,'COMPLETE'),
       message_text   = DECODE(message_type_cd,'ERROR',message_text,fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED')),
       batch_status = DECODE(batch_status,'ERROR',batch_status,l_status),
       batch_end_date = sysdate
   WHERE process_log_id = l_process_log_id;

Line: 293

PROCEDURE update_log_message(p_folder_id IN Number
                            ,p_txn_entity_type IN varchar2 ---- T/D/R/DP
                            ,p_transaction_id IN Number Default Null
                            ,p_entity_id IN Number Default Null
                            ,p_budget_period_id IN NUMBER default Null
                            ,p_message_type_cd  IN varchar2  -- E/I/W
                            ,p_message_text IN varchar2) IS
  l_proc varchar2(80) := g_package||'update_log_message';

Line: 309

    SELECT to_char(tp1.start_date,'DD-MM-RRRR')||' '||to_char(tp2.end_date,'DD-MM-RRRR')
    FROM   pqh_budget_periods bpr,
           per_time_periods tp1,
           per_time_periods tp2
    WHERE  bpr.budget_period_id = p_budget_period_id
    AND    tp1.time_period_id = bpr.start_time_period_id
    AND    tp2.time_period_id = bpr.end_time_period_id;

Line: 317

   SELECT  to_char(bpr.start_date,'DD-MM-RRRR')||' '||to_char(bpr.end_date,'DD-MM-RRRR')
   FROM    pqh_bdgt_pool_realloctions bpr
   WHERE   bpr.reallocation_id = p_budget_period_id;

Line: 365

      UPDATE  pqh_process_log
      set     message_type_cd =  l_message_type_cd
             ,batch_status = l_status
             ,message_text = p_message_text
      WHERE   process_log_id = l_process_log_id;

Line: 413

END update_log_message;

Line: 468

   update_log_message(p_folder_id => p_folder_id
                     ,p_txn_entity_type => 'F'
                     ,p_message_type_cd => p_rule_level
                     ,p_message_text => l_message_text);

Line: 475

    update_log_message(p_folder_id => p_folder_id
                      ,p_transaction_id => p_transaction_id
                      ,p_txn_entity_type => 'T'
                      ,p_message_type_cd => p_rule_level
                      ,p_message_text=> l_message_text);

Line: 485

     update_log_message(p_folder_id => p_folder_id
                       ,p_transaction_id => p_transaction_id
                       ,p_entity_id => p_entity_id
                       ,p_txn_entity_type => p_txn_entity_type
                       ,p_budget_period_id => p_budget_period_id
                       ,p_message_type_cd => p_rule_level
                       ,p_message_text => l_message_text);