APPS.INV_TRANSACTIONS_UTIL2 SQL Statements

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

Line: 8

PROCEDURE Update_Txn_Hist_Err_WF(	Item_type 	IN	VARCHAR2,
					Item_key	IN	VARCHAR2,
					Actid		IN	NUMBER,
					Funcmode	IN	VARCHAR2,
					Resultout	OUT NOCOPY 	VARCHAR2
                       	 	     )

IS
l_return_status VARCHAR2(1);

Line: 18

update_history EXCEPTION;

Line: 24

    inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Err_WF', 'INV_TRANSACTIONS_UTIL2', 9);

Line: 32

     Update_Txn_History ( Item_type,
			  Item_key,
			  'ER',
                          l_return_status
                        );

Line: 43

	    raise update_history;

Line: 55

  WHEN update_history THEN
	resultout := 'COMPLETE:FAILURE';

Line: 58

          inv_trx_util_pub.TRACE('update_history exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);

Line: 67

END Update_Txn_Hist_Err_WF;

Line: 69

PROCEDURE Update_Txn_Hist_Success_WF(	Item_type 	IN	VARCHAR2,
					Item_key	IN	VARCHAR2,
					Actid		IN	NUMBER,
					Funcmode	IN	VARCHAR2,
					Resultout	OUT NOCOPY 	VARCHAR2
                       	 	     )

IS
l_return_status VARCHAR2(1);

Line: 79

update_history EXCEPTION;

Line: 85

    inv_trx_util_pub.TRACE('Entering Update_Txn_Hist_Success_WF', 'INV_TRANSACTIONS_UTIL2', 9);

Line: 95

      Update_Txn_History ( Item_type,
			   Item_key,
			   'ST',
			   l_return_status
			 );

Line: 102

          inv_trx_util_pub.TRACE('Update_Txn_Hist_Success_WF.l_return_status is '||l_return_status, 'INV_TRANSACTIONS_UTIL2', 9);

Line: 106

	    raise update_history;

Line: 110

          inv_trx_util_pub.TRACE('Update_Txn_Hist_Success_WF.resultout is '||resultout, 'INV_TRANSACTIONS_UTIL2', 9);

Line: 117

   inv_trx_util_pub.TRACE('Exiting Update_Txn_Hist_Success_WF', 'INV_TRANSACTIONS_UTIL2', 9);

Line: 123

  WHEN update_history THEN

	update mtl_txns_history
        set transaction_status = 'ER'
        where event_name = Item_type
        and event_key = Item_key
        and transaction_status = 'IP';

Line: 134

          inv_trx_util_pub.TRACE('update_history exception has occured.', 'INV_TRANSACTIONS_UTIL2', 9);

Line: 139

        update mtl_txns_history
        set transaction_status = 'ER'
        where event_name = Item_type
        and event_key = Item_key
        and transaction_status = 'IP';

Line: 151

END Update_Txn_Hist_Success_WF;

Line: 154

PROCEDURE Update_Txn_History ( p_item_type     IN      VARCHAR2,
                               p_item_key      IN      VARCHAR2,
                               p_transaction_status IN VARCHAR2,
                               x_return_status OUT NOCOPY      VARCHAR2
                              )
IS


pragma AUTONOMOUS_TRANSACTION;

Line: 172

update_history EXCEPTION;

Line: 178

     inv_trx_util_pub.TRACE('Entering Update_Txn_History', 'INV_TRANSACTIONS_UTIL2', 9);

Line: 204

     inv_trx_util_pub.TRACE('Update_Txn_History.x_return_status is '||x_return_status, 'INV_TRANSACTIONS_UTIL2', 9);

Line: 210

     raise update_history;

Line: 213

  INV_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txns_history_rec,
                               l_xml_document_id, -- being passed as null at this point
                               l_txn_id,
                               x_return_status );

Line: 220

     inv_trx_util_pub.TRACE('Update_Txn_History.x_return_status is '||x_return_status, 'INV_TRANSACTIONS_UTIL2', 9);

Line: 224

     raise update_history;

Line: 230

     inv_trx_util_pub.TRACE('Exiting Update_Txn_History', 'INV_TRANSACTIONS_UTIL2', 9);

Line: 234

  WHEN  update_history THEN

        update mtl_txns_history
        set transaction_status = 'ER'
        where event_name = p_item_type
        and event_key = p_item_key
        and transaction_status = 'IP';

Line: 244

           inv_trx_util_pub.TRACE('update_history exception has occured.', 'INV_TRANSACTIONS_UTIL2', 9);

Line: 249

        update mtl_txns_history
        set transaction_status = 'ER'
        where event_name = p_item_type
        and event_key = p_item_key
        and transaction_status = 'IP';

Line: 260

END Update_Txn_History;

Line: 311

      SELECT po_wf_itemkey_s.NEXTVAL
      INTO   l_orig_Event_Key
      FROM   DUAL;

Line: 334

          SELECT party_id
          INTO l_party_id
          FROM hz_cust_accounts
          WHERE cust_account_id IN (SELECT client_id
                                FROM mtl_client_parameters
                                WHERE client_code = P_client_code);

Line: 342

          select location_id
          into l_party_id
          from hr_organization_units_v
          where organization_id = P_Org_ID
          and rownum = 1;

Line: 363

      /* Raise event will insert the record into the transaction history table
         for the current transaction.
      */

      INV_EXTERNAL_INTERFACE_SV.Raise_Event ( l_curr_txn_hist_record,
                                              l_xml_document_id,
                                              l_Return_Status );