APPS.PQH_WKS_ERROR_CHK SQL Statements

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

Line: 43

   cursor c1 is select position_id,organization_id,job_id,grade_id,position_transaction_id
                from pqh_worksheet_details
                where worksheet_detail_id = p_worksheet_detail_id;

Line: 46

   cursor c2 is select business_group_id from hr_positions
                where position_id = l_position_id;

Line: 48

   cursor c3 is select business_group_id from per_jobs
                where job_id = l_job_id;

Line: 50

   cursor c4 is select business_group_id from per_grades
                where grade_id = l_grade_id;

Line: 52

   cursor c5 is select business_group_id from pqh_position_transactions
                where position_transaction_id = l_position_transaction_id;

Line: 105

 SELECT  level, wdt.*
 FROM pqh_worksheet_details wdt
 START WITH worksheet_detail_id = p_worksheet_detail_id
 CONNECT BY prior worksheet_detail_id = parent_worksheet_detail_id ;

Line: 111

 SELECT *
 FROM  pqh_worksheet_periods
 WHERE  worksheet_detail_id = p_worksheet_detail_id;

Line: 116

 SELECT *
 FROM  pqh_worksheet_budget_sets
 WHERE worksheet_period_id = p_worksheet_period_id;

Line: 121

 SELECT *
 FROM  pqh_worksheet_bdgt_elmnts
 WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;

Line: 126

 SELECT *
 FROM  pqh_worksheet_fund_srcs
 WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;

Line: 131

 SELECT  *
 FROM pqh_worksheet_details
 WHERE worksheet_detail_id = p_worksheet_detail_id;

Line: 221

            pqh_process_batch_log.insert_log
            (
              p_message_type_cd    =>  'ERROR',
              p_message_text       =>  l_message_text
            );

Line: 512

 SELECT *
 FROM pqh_budgets
 WHERE budget_id =
  (
   SELECT b.budget_id
   FROM pqh_budgets b, pqh_worksheets wks, pqh_worksheet_details wdt
   WHERE wdt.worksheet_id = wks.worksheet_id
     AND wks.budget_id = b.budget_id
     AND wdt.worksheet_detail_id = p_worksheet_detail_id
  );

Line: 524

   SELECT *
   FROM pqh_worksheets
   WHERE worksheet_id =
    (
     SELECT wks.worksheet_id
     FROM pqh_worksheets wks, pqh_worksheet_details wdt
     WHERE wdt.worksheet_id = wks.worksheet_id
      AND  wdt.worksheet_detail_id = p_worksheet_detail_id
    );

Line: 535

  SELECT table_route_id
  FROM pqh_table_route
  WHERE table_alias =  p_table_alias;

Line: 656

  We will then update the child row with the new values

*/

 l_proc                           varchar2(72) := g_package||'check_level1_rows';

Line: 682

SELECT *
FROM pqh_worksheet_details
WHERE worksheet_detail_id IN
(
 SELECT  worksheet_detail_id
 FROM pqh_worksheet_details
 WHERE level = 2
   AND action_cd = 'D'
 START WITH worksheet_detail_id = p_worksheet_detail_id
 CONNECT BY prior worksheet_detail_id = parent_worksheet_detail_id
 )
FOR UPDATE OF budget_unit1_available,budget_unit2_available,budget_unit3_available;

Line: 764

           UPDATE pqh_worksheet_details
              SET budget_unit1_available = l_unit1_available,
                  budget_unit2_available = l_unit2_available,
                  budget_unit3_available = l_unit3_available
            WHERE CURRENT OF csr_level1_rows;

Line: 807

           UPDATE pqh_worksheet_details
              SET budget_unit1_value = l_unit1_value,
                  budget_unit2_value = l_unit2_value,
                  budget_unit3_value = l_unit3_value
            WHERE CURRENT OF csr_level1_rows;

Line: 828

              pqh_process_batch_log.insert_log
              (
                p_message_type_cd    =>  'ERROR',
                p_message_text       =>  l_message_text
              );

Line: 833

            END IF; -- insert error message if l_error_flag is Y

Line: 886

SELECT *
FROM pqh_worksheet_details
WHERE worksheet_detail_id = p_worksheet_detail_id;

Line: 891

SELECT COUNT(*)
FROM pqh_worksheet_periods
WHERE worksheet_detail_id = p_worksheet_detail_id;

Line: 897

SELECT pos.availability_status_id
  FROM hr_all_positions_f pos, pqh_worksheets wks, pqh_budgets bud
 WHERE pos.position_id  = p_position_id
   AND wks.worksheet_id = p_worksheet_id
   AND wks.budget_id    = bud.budget_id
   AND pos.effective_start_date < bud.budget_end_date
   AND pos.effective_end_date   > bud.budget_start_date;

Line: 1194

              pqh_process_batch_log.insert_log
              (
                p_message_type_cd    =>  'ERROR',
                p_message_text       =>  l_message_text
              );

Line: 1199

            END IF; -- insert error message if l_error_flag is Y

Line: 1245

SELECT *
FROM pqh_worksheet_periods
WHERE worksheet_period_id = p_worksheet_period_id;

Line: 1250

SELECT COUNT(*)
FROM pqh_worksheet_periods
WHERE worksheet_detail_id = p_worksheet_detail_id;

Line: 1255

SELECT COUNT(*)
FROM pqh_worksheet_budget_sets
WHERE worksheet_period_id  = p_worksheet_period_id;

Line: 1340

                 pqh_utility.insert_warning
                 (
                  p_warnings_rec => l_warnings_rec
                 );

Line: 1347

                    pqh_process_batch_log.insert_log
                    (
                     p_message_type_cd    =>  'WARNING',
                     p_message_text       =>  l_message_text
                    );

Line: 1384

           pqh_process_batch_log.insert_log
           (
            p_message_type_cd    =>  'ERROR',
            p_message_text       =>  l_message_text
           );

Line: 1389

        END IF; -- insert error message if l_error_flag is Y

Line: 1447

SELECT SUM(budget_unit1_value),
       SUM(budget_unit2_value),
       SUM(budget_unit3_value)
FROM pqh_worksheet_budget_sets
WHERE worksheet_period_id = p_worksheet_period_id;

Line: 1454

SELECT *
FROM pqh_worksheet_periods
WHERE worksheet_period_id = p_worksheet_period_id;

Line: 1490

                              pqh_process_batch_log.insert_log
                              (
                               p_message_type_cd    =>  'ERROR',
                               p_message_text       =>  l_message_text
                              );

Line: 1499

                            pqh_utility.insert_warning
                            (
                             p_warnings_rec => l_warnings_rec
                            );

Line: 1504

                               pqh_process_batch_log.insert_log
                               (
                                p_message_type_cd    =>  'WARNING',
                                p_message_text       =>  l_message_text
                               );

Line: 1526

                      pqh_process_batch_log.insert_log
                      (
                       p_message_type_cd    =>  'ERROR',
                       p_message_text       =>  l_message_text
                      );

Line: 1550

                              pqh_process_batch_log.insert_log
                              (
                               p_message_type_cd    =>  'ERROR',
                               p_message_text       =>  l_message_text
                              );

Line: 1559

                            pqh_utility.insert_warning
                            (
                             p_warnings_rec => l_warnings_rec
                            );

Line: 1564

                               pqh_process_batch_log.insert_log
                               (
                                p_message_type_cd    =>  'WARNING',
                                p_message_text       =>  l_message_text
                               );

Line: 1587

                      pqh_process_batch_log.insert_log
                      (
                       p_message_type_cd    =>  'ERROR',
                       p_message_text       =>  l_message_text
                      );

Line: 1612

                              pqh_process_batch_log.insert_log
                              (
                               p_message_type_cd    =>  'ERROR',
                               p_message_text       =>  l_message_text
                              );

Line: 1621

                            pqh_utility.insert_warning
                            (
                             p_warnings_rec => l_warnings_rec
                            );

Line: 1626

                               pqh_process_batch_log.insert_log
                               (
                                p_message_type_cd    =>  'WARNING',
                                p_message_text       =>  l_message_text
                               );

Line: 1648

                      pqh_process_batch_log.insert_log
                      (
                       p_message_type_cd    =>  'ERROR',
                       p_message_text       =>  l_message_text
                      );

Line: 1704

 SELECT *
 FROM pqh_worksheet_bdgt_elmnts
 WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;

Line: 1709

 SELECT SUM(distribution_percentage)
 FROM pqh_worksheet_bdgt_elmnts
 WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;

Line: 1751

                 pqh_utility.insert_warning
                 (
                  p_warnings_rec => l_warnings_rec
                 );

Line: 1756

                    pqh_process_batch_log.insert_log
                    (
                     p_message_type_cd    =>  'WARNING',
                     p_message_text       =>  l_message_text
                    );

Line: 1798

                 pqh_utility.insert_warning
                 (
                  p_warnings_rec => l_warnings_rec
                 );

Line: 1803

                    pqh_process_batch_log.insert_log
                    (
                     p_message_type_cd    =>  'WARNING',
                     p_message_text       =>  l_message_text
                    );

Line: 1872

           pqh_process_batch_log.insert_log
           (
            p_message_type_cd    =>  'ERROR',
            p_message_text       =>  l_message_text
           );

Line: 1877

        END IF; -- insert error message if l_error_flag is Y

Line: 1924

 SELECT *
 FROM pqh_worksheet_fund_srcs
 WHERE worksheet_fund_src_id = p_worksheet_fund_src_id;

Line: 1929

 SELECT SUM(distribution_percentage)
 FROM pqh_worksheet_fund_srcs
 WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;

Line: 1963

                 pqh_utility.insert_warning
                 (
                  p_warnings_rec => l_warnings_rec
                 );

Line: 1968

                    pqh_process_batch_log.insert_log
                    (
                     p_message_type_cd    =>  'WARNING',
                     p_message_text       =>  l_message_text
                    );

Line: 1996

                 pqh_utility.insert_warning
                 (
                  p_warnings_rec => l_warnings_rec
                 );

Line: 2001

                    pqh_process_batch_log.insert_log
                    (
                     p_message_type_cd    =>  'WARNING',
                     p_message_text       =>  l_message_text
                    );

Line: 2073

           pqh_process_batch_log.insert_log
           (
            p_message_type_cd    =>  'ERROR',
            p_message_text       =>  l_message_text
           );

Line: 2078

        END IF; -- insert error message if l_error_flag is Y

Line: 2128

 SELECT *
 FROM pqh_worksheet_details
 WHERE worksheet_detail_id = p_worksheet_detail_id ;

Line: 2133

SELECT name
FROM pqh_position_transactions
WHERE position_transaction_id = p_position_transaction_id;

Line: 2241

 SELECT *
 FROM pqh_worksheet_periods
 WHERE worksheet_period_id = p_worksheet_period_id ;

Line: 2246

 SELECT *
 FROM per_time_periods
 WHERE time_period_id = p_time_period_id ;

Line: 2321

 SELECT *
 FROM pqh_worksheet_budget_sets
 WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;

Line: 2326

 SELECT *
 FROM pqh_dflt_budget_sets
 WHERE dflt_budget_set_id = p_dflt_budget_set_id;

Line: 2394

 SELECT *
 FROM pqh_worksheet_bdgt_elmnts
 WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;

Line: 2399

 SELECT *
 FROM pay_element_types
 WHERE element_type_id = p_element_type_id;

Line: 2404

 SELECT *
 FROM pqh_worksheet_budget_sets
 WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;

Line: 2409

 SELECT *
 FROM pqh_dflt_budget_sets
 WHERE dflt_budget_set_id = p_dflt_budget_set_id;

Line: 2490

 SELECT *
 FROM pqh_worksheet_fund_srcs
 WHERE worksheet_fund_src_id = p_worksheet_fund_src_id;

Line: 2495

 SELECT *
 FROM pay_cost_allocation_keyflex
 WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;

Line: 2500

 SELECT *
 FROM pqh_worksheet_bdgt_elmnts
 WHERE worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;

Line: 2505

 SELECT *
 FROM pay_element_types
 WHERE element_type_id = p_element_type_id;

Line: 2586

SELECT *
FROM pqh_worksheet_details
WHERE worksheet_detail_id = p_worksheet_detail_id;

Line: 2591

SELECT COUNT(*)
FROM pqh_worksheet_periods
WHERE worksheet_detail_id = p_worksheet_detail_id;

Line: 2596

 SELECT  COUNT(*)
 FROM pqh_worksheet_details wdt
 WHERE action_cd = 'B'
 START WITH worksheet_detail_id = p_worksheet_detail_id
 CONNECT BY prior worksheet_detail_id = parent_worksheet_detail_id ;

Line: 2722

            END IF; -- insert error message if l_error_flag is Y

Line: 2756

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

Line: 2763

SELECT *
FROM pqh_process_log
WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

Line: 2813

    update the 'start' record for this batch with message_type_cd = 'COMPLETE' and
    update the batch_end_date with current date time
  */

   OPEN csr_batch_rec;

Line: 2823

      UPDATE pqh_process_log
      SET message_type_cd = 'COMPLETE',
         message_text   = fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED'),
          txn_table_route_id    =  g_table_route_id_wdt,
          batch_status = l_status,
          batch_end_date  = sysdate
      WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

Line: 2833

      UPDATE pqh_process_log
      SET batch_status = l_status,
          batch_end_date  = sysdate,
          txn_table_route_id    =  g_table_route_id_wdt
      WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

Line: 2883

    UPDATE pqh_process_log
    SET message_type_cd =  'ERROR',
      message_text   = p_message_text,
      txn_table_route_id    =  g_table_route_id_wdt,
      batch_status    = 'ERROR',
      batch_end_date  = sysdate
    WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

Line: 2940

SELECT *
FROM pqh_worksheets
WHERE worksheet_id =
(
  SELECT wks.worksheet_id
  FROM pqh_worksheets wks, pqh_worksheet_details wdt
  WHERE wdt.worksheet_id = wks.worksheet_id
  AND  wdt.worksheet_detail_id = p_worksheet_detail_id
);

Line: 2951

SELECT *
FROM pqh_budgets
WHERE budget_id = p_budget_id ;

Line: 3023

SELECT DISTINCT bgt.budget_id
FROM pqh_budgets bgt, pqh_budget_versions bvr, pqh_budget_details bdt
WHERE bgt.budget_id = bvr.budget_id
  AND bvr.budget_version_id = bdt.budget_version_id
  AND bdt.position_id = p_position_id
  AND NVL(bgt.position_control_flag,'X') = 'Y'
  AND bgt.budget_id <> g_budget_id;

Line: 3032

SELECT *
FROM pqh_budgets
WHERE budget_id = p_budget_id;

Line: 3037

SELECT system_type_cd
FROM per_shared_types
WHERE shared_type_id = NVL(p_shared_type_id,-1);