APPS.PO_CHORD_WF0 SQL Statements

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

Line: 21

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** In procedure chord_setup ***');

Line: 33

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'Document Type '|| x_doc_type);

Line: 34

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'Document Subtype '|| x_doc_subtype);

Line: 49

	  	select authorization_status
		into 	x_auth_status
	  	from po_headers_all
	  	where po_header_id=x_po_header_id;

Line: 65

	  	select authorization_status
		into 	x_auth_status
	  	from po_releases_all
	  	where po_release_id=x_po_release_id;

Line: 84

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** FINISH: chord_setup ***');

Line: 94

     PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** exception chord_doc_type ***');

Line: 116

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** In procedure chord_doc_type ***');

Line: 129

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'doc_type '|| x_doc_type);

Line: 130

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'doc_subtype '|| x_doc_subtype);

Line: 143

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: po_standard');

Line: 149

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: po_contract');

Line: 155

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: po_blanket');

Line: 161

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: po_planned');

Line: 170

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: blanket_release');

Line: 175

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: scheduled_release');

Line: 186

   	PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** Finish: chord_doc_type ***');

Line: 193

     PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** exception chord_doc_type ***');

Line: 348

    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** In Procedure: archive_on_approval ***');

Line: 381

       SELECT ARCHIVE_EXTERNAL_REVISION_CODE
       INTO x_archive_code
       FROM PO_DOCUMENT_TYPES podta
       WHERE podta.DOCUMENT_TYPE_CODE = x_doc_type
       AND podta.DOCUMENT_SUBTYPE = x_doc_subtype;

Line: 403

    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** Finished: archive_on_approval ***');

Line: 414

     PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
   		'*** execption archive_on_approval_set *** '||x_result);