APPS.DPP_BPEL_UPDATEPO SQL Statements

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

Line: 16

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;

Line: 46

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;

Line: 137

		aSqlItem.UPDATE_STATUS := aPlsqlItem.UPDATE_STATUS;

Line: 167

		aPlsqlItem.UPDATE_STATUS := aSqlItem.UPDATE_STATUS;

Line: 192

   PROCEDURE DPP_PURCHASEPRICE_PVT$UPDATE_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
   P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
   X_MSG_DATA OUT NOCOPY VARCHAR2,P_ITEM_PRICE_REC DPP_PURCHASEPRICE_PVT_DPP_TXN,P_ITEM_COST_TBL DPP_PURCHASEPRICE_PVT_DPP_ITE) IS
      P_ITEM_PRICE_REC_ DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;

Line: 198

      P_ITEM_PRICE_REC_ := DPP_BPEL_UPDATEPO.SQL_TO_PL14(P_ITEM_PRICE_REC);

Line: 199

      P_ITEM_COST_TBL_ := DPP_BPEL_UPDATEPO.SQL_TO_PL15(P_ITEM_COST_TBL);

Line: 200

      DPP_PURCHASEPRICE_PVT.UPDATE_PURCHASEPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_ITEM_PRICE_REC_,P_ITEM_COST_TBL_);

Line: 201

   END DPP_PURCHASEPRICE_PVT$UPDATE_;