APPS.OZF_RESALE_WF_PVT SQL Statements

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

Line: 124

SELECT status_code
 --FROM  ozf_resale_batches
 FROM  ozf_resale_batches_all
 WHERE resale_batch_id = p_id;

Line: 184

           OZF_RESALE_COMMON_PVT.Update_Duplicates (
            p_api_version        => 1.0,
            p_init_msg_list      => FND_API.G_FALSE,
            p_commit             => FND_API.G_FALSE,
            p_validation_level   => FND_API.G_VALID_LEVEL_FULL,
            p_resale_batch_id    => l_batch_id,
            p_resale_batch_type  => l_batch_type,
            p_batch_status       => l_batch_status,
            x_batch_status       => l_batch_return_status,
            x_return_status      => l_return_status,
            x_msg_count          => l_msg_count,
            x_msg_data           => l_msg_data);

Line: 303

SELECT auto_tp_accrual_flag
  FROM ozf_sys_parameters;

Line: 587

SELECT status_code
 --FROM  ozf_resale_batches
 FROM  ozf_resale_batches_all
 WHERE resale_batch_id = p_id;

Line: 846

l_last_updated_by        Number;

Line: 857

 SELECT batch_number
     , batch_type
     , last_updated_by
     , org_id
 FROM ozf_resale_batches_all
 WHERE resale_batch_id = p_id;

Line: 866

SELECT employee_id
  FROM ams_jtf_rs_emp_v
 WHERE  resource_id = p_res_id;

Line: 893

                             , l_last_updated_by
                             , l_batch_org_id;

Line: 920

      OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_last_updated_by));

Line: 2069

SELECT status_code
     , lines_disputed
 --FROM  ozf_resale_batches
 FROM  ozf_resale_batches_all
 WHERE resale_batch_id = p_id;

Line: 2104

            UPDATE ozf_resale_batches_all
               SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_OPEN
             WHERE resale_batch_id = l_resale_batch_id;

Line: 2109

            UPDATE ozf_resale_batches_all
               SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
             WHERE resale_batch_id = l_resale_batch_id;

Line: 2117

            UPDATE ozf_resale_batches_all
               SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED
             WHERE resale_batch_id = l_resale_batch_id;

Line: 2122

            UPDATE ozf_resale_batches_all
               SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
             WHERE resale_batch_id = l_resale_batch_id;

Line: 2216

l_last_updated_by      NUMBER;

Line: 2222

SELECT last_updated_by
,      status_code
 --FROM  ozf_resale_batches
 FROM  ozf_resale_batches_all
 WHERE resale_batch_id = p_id;

Line: 2230

  SELECT  ppl.person_id
  FROM jtf_rs_resource_extns rsc
     , per_people_f ppl
  WHERE rsc.category = 'EMPLOYEE'
  AND ppl.person_id = rsc.source_id
  AND rsc.resource_id=p_res_id;

Line: 2282

      FETCH batch_status_csr INTO l_last_updated_by
                                , l_batch_status;

Line: 2287

      OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_last_updated_by));

Line: 2327

            UPDATE ozf_resale_batches_all
               SET status_code = l_batch_next_status
             WHERE resale_batch_id = l_resale_batch_id;

Line: 2464

      UPDATE ozf_resale_batches_all
      SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT
      WHERE resale_batch_id = l_resale_batch_id;

Line: 2561

l_last_update_date DATE;

Line: 2566

SELECT creation_date,
       last_update_date,
       partner_party_id,
       partner_cust_account_id
--FROM ozf_resale_batches
FROM ozf_resale_batches_all
WHERE resale_batch_id = p_batch_id;

Line: 2575

SELECT header_tolerance_operand,
       header_tolerance_calc_code
FROM ozf_sys_parameters;

Line: 2580

SELECT header_tolerance_operand,
       header_tolerance_calc_code
FROM ozf_cust_trd_prfls
WHERE cust_account_id = p_cust_account_id;

Line: 2586

SELECT header_tolerance_operand,
       header_tolerance_calc_code
FROM ozf_cust_trd_prfls
WHERE party_id = p_party_id
and  cust_account_id IS NULL;

Line: 2593

SELECT line_tolerance_operand,
       line_tolerance_calc_code
FROM ozf_sys_parameters;

Line: 2598

SELECT line_tolerance_operand,
       line_tolerance_calc_code
FROM ozf_cust_trd_prfls
WHERE cust_account_id = p_cust_account_id;

Line: 2604

SELECT line_tolerance_operand,
       line_tolerance_calc_code
FROM ozf_cust_trd_prfls
WHERE party_id = p_party_id
AND   cust_account_id IS NULL;

Line: 2653

                                 l_last_update_date,
                                 l_partner_party_id,
                                 l_partner_cust_account_id;

Line: 2658

      IF l_creation_date = l_last_update_date THEN
         -- It is the first time this batch is processed. default toleracne

         -- Set header tolerance
         OPEN  header_tolerance_account_csr(l_partner_cust_account_id);

Line: 2703

      UPDATE ozf_resale_batches_all
      SET   header_tolerance_operand = l_header_tolerance_operand,
            header_tolerance_calc_code = l_header_tolerance_calc_code,
            line_tolerance_operand  = l_line_tolerance_operand,
            line_tolerance_calc_code = l_line_tolerance_calc_code
      WHERE resale_batch_id = l_resale_batch_id;

Line: 3506

   SELECT status_code
   ,      last_updated_by
   ,      batch_type
   ,      batch_number
   FROM  ozf_resale_batches_all
   WHERE resale_batch_id = p_resale_batch_id;

Line: 3515

  SELECT  ppl.person_id
  FROM jtf_rs_resource_extns rsc
     , per_people_f ppl
  WHERE rsc.category = 'EMPLOYEE'
  AND ppl.person_id = rsc.source_id
  AND rsc.resource_id=p_res_id;

Line: 3540

      UPDATE ozf_resale_batches_all
      SET status_code = 'PROCESSING'
      WHERE resale_batch_id = p_resale_batch_id;

Line: 3564

   OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_batch_info.last_updated_by));

Line: 3644

   SELECT status_code
   ,      last_updated_by
   ,      batch_type
   ,      batch_number
   FROM  ozf_resale_batches_all
   WHERE resale_batch_id = p_resale_batch_id;

Line: 3653

  SELECT  ppl.person_id
  FROM jtf_rs_resource_extns rsc
     , per_people_f ppl
  WHERE rsc.category = 'EMPLOYEE'
  AND ppl.person_id = rsc.source_id
  AND rsc.resource_id=p_res_id;

Line: 3676

      UPDATE ozf_resale_batches_all
      SET status_code = 'PENDING_PAYMENT'
      WHERE resale_batch_id = p_resale_batch_id;

Line: 3700

   OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_batch_info.last_updated_by));