DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_ACTION SQL Statements

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

Line: 34

PROCEDURE InsertHistForOwnerApprove (itemtype VARCHAR2,
                                     itemkey VARCHAR2,
                                     p_document_id NUMBER,
                                     p_document_type VARCHAR2,
                                     p_document_subtype VARCHAR2);
Line: 151

PROCEDURE AutoUpdateCloseAutonomous(
   p_document_id       IN NUMBER
,  p_document_type     IN VARCHAR2
,  p_document_subtype  IN VARCHAR2
,  x_return_status     OUT NOCOPY VARCHAR2
,  x_exception_msg     OUT NOCOPY VARCHAR2
,  x_return_code       OUT NOCOPY VARCHAR2
);
Line: 189

		select USER_ID from fnd_user where supplier_id = supplier_contact_id;
Line: 202

	select vendor_contact_id, nvl(acceptance_required_flag, 'N'), acceptance_due_date, nvl(revision_num, 0)
	into x_vendor_contact_id, x_acceptance_required_flag, x_acceptance_due_date, x_doc_revision
	from po_headers
	where po_header_id = document_id;
Line: 228

			select count(*) into x_item_exists
			from wf_items
			where item_type = 'POSPOACK'
			and item_key = l_itemkey;
Line: 274

				select (trunc(nvl(x_acceptance_due_date, sysdate)) - trunc(sysdate)) * 60
				into x_minutes_to_acceptance
				from sys.dual;
Line: 328

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 397

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 437

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 477

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 522

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 613

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 666

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 697

    InsertHistForOwnerApprove(itemtype, itemkey,
                            l_document_id, l_document_type, l_document_subtype);
Line: 734

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 779

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 844

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 891

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 958

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1002

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1066

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1102

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1129

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1169

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1201

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1240

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1273

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1316

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1398

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1460

    /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1487

        /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1498

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1557

    /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1584

        /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1595

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1672

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1722

             /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1736

                 SELECT 'E'
                 INTO l_error
                 FROM dual
                 WHERE EXISTS (SELECT 1
                          FROM PO_ONLINE_REPORT_TEXT
                          WHERE online_report_id = x_online_report_id
                          AND NVL(message_type, 'E') = 'E');  -- Bug 3906870
Line: 1751

                     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1780

            /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1789

             /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1809

PROCEDURE InsertHistForOwnerApprove (itemtype VARCHAR2,
                                     itemkey VARCHAR2,
                                     p_document_id NUMBER,
                                     p_document_type VARCHAR2,
                                     p_document_subtype VARCHAR2) IS
pragma AUTONOMOUS_TRANSACTION;
Line: 1826

   x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove begin';
Line: 1829

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1833

  select sequence_num,
         action_code,
         object_revision_num,
         approval_path_id
    into l_sequence_num,
         l_action_code,
         l_object_rev_num,
         l_approval_path_id
    from po_action_history
   where object_id = p_document_id
     and object_type_code = p_document_type
     and sequence_num = (select max(sequence_num)
                           from po_action_history
                          where object_id = p_document_id
                            and object_type_code = p_document_type);
Line: 1849

   x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove action_code: ' || l_action_code;
Line: 1852

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
Line: 1860

    select employee_id
    into l_employee_id
    from po_action_history
    where object_id = p_document_id
     and object_type_code = p_document_type
     and sequence_num = (select max(sequence_num)
                           from po_action_history
                          where object_id = p_document_id
                            and action_code = 'SUBMIT'
                            and object_type_code = p_document_type);
Line: 1871

   x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove employee_id: ' || l_employee_id;
Line: 1874

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
Line: 1877

      INSERT into PO_ACTION_HISTORY
             (object_id,
              object_type_code,
              object_sub_type_code,
              sequence_num,
              last_update_date,
              last_updated_by,
              creation_date,
              created_by,
              action_code,
              action_date,
              employee_id,
              note,
              object_revision_num,
              last_update_login,
              request_id,
              program_application_id,
              program_id,
              program_update_date,
              approval_path_id,
              offline_code)
             VALUES
             (p_document_id,
              p_document_type,
              p_document_subtype,
              l_sequence_num + 1,
              sysdate,
              fnd_global.user_id,
              sysdate,
              fnd_global.user_id,
              NULL,
              NULL,
              l_employee_id,
              NULL,
              l_object_rev_num,
              fnd_global.login_id,
              0,
              0,
              0,
              '',
              l_approval_path_id,
              '' );
Line: 1922

     x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove inserted';
Line: 1926

   x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove end';
Line: 1929

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 1938

END InsertHistForOwnerApprove;
Line: 1993

    /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2023

      PO_KANBAN_SV.Update_Card_Status ('IN_PROCESS',
  					      l_document_type,
  					      l_document_id,
					      l_kanban_return_status);
Line: 2038

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2115

    /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2148

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2226

    /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2258

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2337

    /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2369

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2464

    /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2506

           /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2520

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2584

    /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2619

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2671

  x_progress := 'OpenDocumentState: calling autoupdatecloseautonomous  with: ' || 'Doc_type= ' ||
  l_document_type || ' Subtype= ' || l_document_subtype ||
  ' Doc_id= ' || to_char(l_document_id);
Line: 2676

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2679

  AutoUpdateCloseAutonomous(
     p_document_id      => l_document_id
  ,  p_document_type    => l_document_type
  ,  p_document_subtype => l_document_subtype
  ,  x_return_status    => l_ret_sts
  ,  x_exception_msg    => l_exc_msg
  ,  x_return_code      => l_ret_code
  );
Line: 2701

         /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2715

    x_progress := 'PO_REQAPPROVAL_ACTION.OpenDocumentState: auto_close_update_autonomous returned with: ' ||
               l_ret_sts;
Line: 2718

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2767

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2783

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2801

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2832

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2866

         /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 2905

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 3073

  SELECT substr(text_line, 1, 2000)
  BULK COLLECT INTO l_report_text_lines
  FROM po_online_report_text
  WHERE online_report_id = p_online_report_id
  ORDER BY sequence;
Line: 3105

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 3138

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 3227

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 3266

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 3308

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 3325

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 3610

PROCEDURE AutoUpdateCloseAutonomous(
   p_document_id       IN NUMBER
,  p_document_type     IN VARCHAR2
,  p_document_subtype  IN VARCHAR2
,  x_return_status     OUT NOCOPY VARCHAR2
,  x_exception_msg     OUT NOCOPY VARCHAR2
,  x_return_code       OUT NOCOPY VARCHAR2
)
IS
pragma AUTONOMOUS_TRANSACTION;
Line: 3627

  PO_DOCUMENT_ACTION_PVT.auto_update_close_state(
     p_document_id       => p_document_id
  ,  p_document_type     => p_document_type
  ,  p_document_subtype  => p_document_subtype
  ,  p_line_id           => NULL
  ,  p_shipment_id       => NULL
  ,  p_calling_mode      => 'PO'
  ,  p_called_from_conc  => FALSE
  ,  x_return_status     => x_return_status
  ,  x_exception_msg     => x_exception_msg
  ,  x_return_code       => x_return_code
  );
Line: 3655

    wf_core.context('PO_REQAPPROVAL_ACTION', 'AutoUpdateCloseAutonomous', to_char(d_progress));
Line: 3658

END AutoUpdateCloseAutonomous;