APPS.OZF_RESALE_WF_PVT SQL Statements

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

Line: 181

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

Line: 248

           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: 367

SELECT auto_tp_accrual_flag
  FROM ozf_sys_parameters;

Line: 659

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

Line: 920

l_last_updated_by        Number;

Line: 931

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

Line: 940

SELECT employee_id
  FROM ams_jtf_rs_emp_v
 WHERE  resource_id = p_res_id;

Line: 967

                             , l_last_updated_by
                             , l_batch_org_id;

Line: 994

      OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_last_updated_by));

Line: 1240

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

Line: 2192

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

Line: 2227

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

Line: 2232

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

Line: 2240

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

Line: 2245

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

Line: 2339

l_last_updated_by      NUMBER;

Line: 2345

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

Line: 2353

  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: 2374

   SELECT number_value
   FROM    wf_item_attribute_values wiav
   WHERE   wiav.item_type = p_item_type
   AND     wiav.item_key like p_item_key||'%'
   AND     wiav.name      = p_name;

Line: 2454

      FETCH batch_status_csr INTO l_last_updated_by
                                , l_batch_status;

Line: 2459

      OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_last_updated_by));

Line: 2464

      IF l_user_id = l_last_updated_by THEN
         l_wf_user_id := l_user_id;

Line: 2467

         l_wf_user_id := l_last_updated_by;

Line: 2532

            UPDATE ozf_resale_batches_all
               SET status_code = l_batch_next_status
             WHERE resale_batch_id = l_resale_batch_id;

Line: 2670

      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: 2767

l_last_update_date DATE;

Line: 2772

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: 2781

SELECT header_tolerance_operand,
       header_tolerance_calc_code
FROM ozf_sys_parameters;

Line: 2786

SELECT header_tolerance_operand,
       header_tolerance_calc_code
FROM ozf_cust_trd_prfls
WHERE cust_account_id = p_cust_account_id;

Line: 2792

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: 2799

SELECT line_tolerance_operand,
       line_tolerance_calc_code
FROM ozf_sys_parameters;

Line: 2804

SELECT line_tolerance_operand,
       line_tolerance_calc_code
FROM ozf_cust_trd_prfls
WHERE cust_account_id = p_cust_account_id;

Line: 2810

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: 2860

                                 l_last_update_date,
                                 l_partner_party_id,
                                 l_partner_cust_account_id;

Line: 2865

      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: 2910

      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: 3717

   SELECT status_code
   ,      last_updated_by
   ,      batch_type
   ,      batch_number
   ,      org_id                  -- nepanda : Fix for Bug 13819601
   FROM  ozf_resale_batches_all
   WHERE resale_batch_id = p_resale_batch_id;

Line: 3727

  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: 3762

   SELECT number_value
   FROM    wf_item_attribute_values wiav
   WHERE   wiav.item_type = p_item_type
   AND     wiav.item_key like p_item_key||'%'
   AND     wiav.name      = p_name;

Line: 3779

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

Line: 3793

	IF l_batch_info.last_updated_by = l_user_id THEN
		l_wf_user_id := l_user_id;

Line: 3796

		l_wf_user_id := l_batch_info.last_updated_by;

Line: 3799

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

Line: 3974

   SELECT status_code
   ,      last_updated_by
   ,      batch_type
   ,      batch_number
   ,      org_id                     -- nepanda : Fix for Bug 13819601
   FROM  ozf_resale_batches_all
   WHERE resale_batch_id = p_resale_batch_id;

Line: 3984

  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: 4014

   SELECT number_value
   FROM    wf_item_attribute_values wiav
   WHERE   wiav.item_type = p_item_type
   AND     wiav.item_key like p_item_key||'%'
   AND     wiav.name      = p_name;

Line: 4030

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

Line: 4067

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

Line: 4077

   IF l_batch_info.last_updated_by = l_user_id THEN
      l_wf_user_id := l_user_id;

Line: 4080

      l_wf_user_id := l_batch_info.last_updated_by;

Line: 4278

   WF_CORE.context( 'OZF_RESALE_WF_PVT','SELECTOR',p_itemtype,p_itemkey,p_actid,p_funcmode);